Installation problem on remote host......almost completes

[eug168]

Hello,

I'm have setup the db using phpAdmin on the remote host added the db user and password (with all privilages) to the new db, changed the config.php to match these settings, however when i run the install (with the drop old db option) i get the following;

Dropping database...Success

Creating database...Success

Selecting database...Success

Creating announcement table...Success

Creating index...Success

Creating index...Success

Creating login table...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating reservations table...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating resources table...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating permission table...Success

Creating index...Success

Creating index...Success

Creating table schedules...Success

Creating index...Success

Creating index...Success

Creating table schedule_permission...Success

Creating index...Success

Creating index...Success

Creating table reservation_users...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating table anonymous_users...Success

Creating table additional_resources...Success

Creating index...Success

Creating index...Success

Creating table reservation_resources...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating table mutex...Success

Insert values...Success

Insert values...Success

Creating table groups...Success

Creating table user_groups...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating table reminders...Success

Creating index...Success

Creating index...Success

Creating index...Success

Creating database user...Failed: DB Error: insufficient permissions

Error connecting to database: DB Error: connect failed

Any ideas anyone?

Cheers.

[Nick]

If you've already created the user that you configured in config.php then you are fine.  Otherwise you will have to create that user by hand, as no ISP I know of will let you create users through code.

[eug168]

The user specified in the config file is the one i added to the db using phpadmin, but when i go to run phpscheduleit in the browser i get:

Error connecting to database: DB Error: connect failed

the username and password i enter to start the install is the same as in the config file.

[Nick]

Was that user created manually through cPanel or some other tool?  That is the only way I know of to create the user successfully.

[eug168]

Yep, that user was created and added to the phpScheduleIt db using phpadmin.
If i run the SQL script in phpadmin to add the db structure, do i still need to run the install, or can i simply just run the app. i have tried doing both and both haven't worked.

[Nick]

If you haven't yet, I'd suggest taking a look at the remote host install directions included in the install directory.

[eug168]

thats what i have been following, seems strange that the install runs, drops the db i created via phpadmin, creates db, select sb, starts creating tables and indexes, but fails at the end when trying to create the db user.

i have also just used the SQL script in phpadmin and tried to run the phpscheduleit, which still has a db connection error.

[Nick]

One thing I would check is the username and database name in the config file against what was actually created by your ISP.  Often, they will prefix the names with something unique.

[eug168]

yep its prefixed with my account name separated with an underscore, which i have matched in the config file.

i'm using the same user name and password for root db account, so the username and password that i am using to run the install is the same as the one that i put in the config file.

[stardom]

I subscribe all of the above.... same problem.
Since I'm not alone, Has anyone solved it ?

[Nick]

Yep, that user was created and added to the phpScheduleIt db using phpadmin.
If i run the SQL script in phpadmin to add the db structure, do i still need to run the install, or can i simply just run the app. i have tried doing both and both haven't worked.

If the setup.sql contents were run through phpMyAdmin, then you will be ready to go.  You should not run the install script after this.  If it is not working yet, I'd suggest dropping the database and starting over, following the remote host install instructions.


Here are the instructions again.  Remember that you will need modify the config.php file correctly and register the admin user.

--------------------------------------------------------------
Connect to your remote host's control panel, cPanel.

Adding the database and user

   1. Select the MySQL Databases tool
   2. Add a new user with username and password of your choice. This will be the username and password used in your phpScheduleIt config file.
   3. Create a new database with whatever name you choose. This will be the name of the database in your phpScheduleIt config file. 'phpSchedlueIt' is the recommended database name.
   4. Associate the new user with the new database, giving the user permission to SELECT, CREATE, UPDATE, INSERT and DELETE. Click the 'Add User to Db' button.

Creating the tables

   1. Open phpMyAdmin.
   2. Click on the database name that you just created in the left panel.
   3. Click the SQL tab at the top of the page.
   4. Open install/setup.sql, in your phpScheduleIt directory.
   5. Copy all text starting right after the line 'use phpScheduleIt;' and ending at the line just before 'grant select, insert, update, delete' and paste it into the Run SQL textbox.
   6. Click the 'Go' button.

Your database, user and tables are now created. Please make sure that the name of the database and user in your config file match what you just created. Many times, an ISP will prefix your database name or cut is short. Please check the created database name and copy that into your config.php file.

[katy]

I spent a long time on the phone with my hosting service. They were able to help me login to the install gui. When I clicked "Create Tables" I had Success with everything except the last two lines

Creating database user...Failed: DB Error: insufficient permissions

Error connecting to database: DB Error: unknown error

My host tech said that something in the code (he thinks the setup.spl) is trying to create a user, but, because this is a shared server, it can't. I have already created the database user through MySQL on my cpanel. Would you be able to tell me which line of code I need to modify and what I need to modify it to?

thank you!
Katy

[Nick]

The ISP will not let you create a database user through code since this is a huge security risk.  You'll need to create this user through whatever tool is provided.  If your host uses the cPanel server administration tool, here are the instructions:

Adding the database and user

   1. Select the MySQL Databases tool
   2. Add a new user with username and password of your choice. This will be the username and password used in your phpScheduleIt config file.
   3. Create a new database with whatever name you choose. This will be the name of the database in your phpScheduleIt config file. 'phpSchedlueIt' is the recommended database name.
   4. Associate the new user with the new database, giving the user permission to SELECT, CREATE, UPDATE, INSERT and DELETE. Click the 'Add User to Db' button.