Database name and user - Printable Version +- webERP Forum (http://www.weberp.org/forum) +-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1) +--- Forum: Installation Issues (http://www.weberp.org/forum/forumdisplay.php?fid=13) +--- Thread: Database name and user (/showthread.php?tid=835) |
Database name and user - paulcliff - 04-05-2013 Hi can anyone help. I change the database name in the weberp-new.sql script to web122-apple database and the script runs good. I then run the install and afterwards the normal weberp logon screen comes up. The problem is the company name comes up as weberp_apple and not weberp-apple. The script seems to change the dash in the database name (-)to an underscore (_) and the logon company name is then called web122_apple I cannot logon with this company name. I know I am missing something but not sure what? Help appreciated. Thanks Paul RE: Database name and user - etainse - 04-05-2013 This is an error in the installer. The Replace_Dodgy_Characters() makes no sense to me especially for the database name. All you need to do is to rename the companies/weberp_apple directory to be companies/weberp-apple and it should work fine. Thanks Tim RE: Database name and user - paulcliff - 04-06-2013 Thanks Tim I will try it . Paul RE: Database name and user - paulcliff - 04-06-2013 HI Tim Your solution worked - many thanks saved me a lot of time. RE: Database name and user - rsawoseyin - 07-01-2013 My problem is related to this, but slightly different: I am trying to install webERP on a shared linux host which prefixes database names and database usernames with the server login name. Fore example, if my server login is 'mylogin', then any database I create is prefixed with 'mylogin_' and any database username is prefixed with same. In the config.php file, do I prefix the DBuser with 'mylogin_'? What about the company name? I have tried all combinations with no success. RE: Database name and user - phil - 07-02-2013 The name of the directory under companies needs to match exactly with the name of the database. So in your case you need a companies directory webERP/companies/mylogin_yourcompanyname The file config.php needs to contain the appropriate mysql user and mysql user password to access the database mylogin_yourcompanyname If all else fails - have a good read through the manual installation instructions at webERP/doc/INSTALL.txt HTH RE: Database name and user - rsawoseyin - 07-03-2013 (07-02-2013, 07:29 AM)phil Wrote: The name of the directory under companies needs to match exactly with the name of the database. Thanks, I finally got it working. The main issue, in my experience, is that the installation instruction is misleading. It says if your server automatically prepends a prefix to DBname, you should give the database name without the prefix, and then enter the prefix separately. The only thing that eventually worked for me was to include the prefix in both the DBname and DBuser, exactly the way my shared host server handles them. |