webERP Forum
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.
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

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.