Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
create new company on a web host
06-05-2013, 08:20 PM, (This post was last modified: 06-05-2013, 11:58 PM by Buz.)
#11
RE: create new company on a web host
Thanks, Exson.

Phil gave me some advice that worked. This solution applies when there is an existing DB (that's logical - you must have an existing company before you can create a new one):

1. Create a new DB in your ISP's cpanel, named (eg) "newDB" (my ISP requires a prefix, so it might be "<prefix>_newDB"). Do NOT use a Database Wizard if it requires that a new user be created as well as the DB.
2. Assign the user to the new DB that is defined in config.php. In my case, it's "user", and assign ALL_PRIVILEGES to this user. This is key - do NOT create a new user. Assign the one in config.php. Do NOT use the ADD NEW USER function; use ADD USER TO DATABASE instead.
3. IMPORT tables from your existing webERP DB into the new DB; use EXPORT in your ISP's cpanel to create the SQL.
4. Run <your URL>/Z_MakeNewCompany.php. This is key: enter the new DB name in the company field. Upload Image Logo file. Do NOT set the Create Database? check box. Click Proceed.
5. Log in to webERP using the new company (ie: the new DB) from the Company drop list with User Name of "admin" and Password of "weberp".
6. Add a new user and delete the initial log in name.

Once I understood the rules, it took two minutes to create a new company. But we must especially understand these two key points:
1. webERP looks for the user to be the one defined in config.php. So you MUST assign this existing user to the new DB instead of creating a new user. In my cpanel, I use Add User To Database to choose the database and user.
2. Z_MakeNewCompany.php looks for the new company name to be the name of the new DB. This is the main point I missed. It's not intuitive that I should make the name my new company the same as the new DB name.

It would be great if some of you try this and provide feedback here so we can create a solid set of rules for creating a new company that works in all cases.

Some believe that info like this should be held close to the vest. That may make sense because webERP is open source and contractors may think that the way to earn a living is by selling knowledge like this.

But I believe otherwise. ALL info should be public and clear. Let contractors earn a living by building applications for clients.

I'm a happy camper now. I'm comforted that there are people like Phil and Exson who believe the way I do. Heart

Regards,
Buz
Reply


Messages In This Thread
create new company on a web host - by Buz - 05-31-2013, 12:19 AM
RE: create new company on a web host - by Buz - 06-02-2013, 09:38 PM
RE: create new company on a web host - by Buz - 06-03-2013, 02:25 PM
RE: create new company on a web host - by Buz - 06-03-2013, 04:44 PM
RE: create new company on a web host - by phil - 06-03-2013, 05:52 PM
RE: create new company on a web host - by Buz - 06-03-2013, 06:07 PM
RE: create new company on a web host - by Buz - 06-05-2013, 08:20 PM
RE: create new company on a web host - by Buz - 06-07-2013, 12:24 AM
RE: create new company on a web host - by phil - 06-07-2013, 07:33 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)