Step 1 of install, can't seem to connect to the DB.

[mike.m]

Ok, this is the situation: I'm fairly sure I've done everything correctly, I used file manager to upload the .zip file, extracted the script to /autopilot/, copied the folders to the correct places and changed permissions but when I go to run the install I keep getting this error:

Warning: mysql_query() [function.mysql-query]: Access denied for user 'username'@'localhost' (using password: NO) in /home/username/public_html/AP/inc/install1.php on line 37

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/username/public_html/AP/inc/install1.php on line 37

I've checked and double-checked everything I could think of. I can verify that I am using the correct database name prefixed by my username. What sticks out to me is the "using password: NO" thing. Has anyone else had this problem?

Thanks.

[GvilleRick]

You should be sure that you have created a database in cPanel which will append the username to the front. You also should create the user and the dbuser will have the cPanel username appended to the front. The last step is you must add the user to the database. This step is the most common step missed.

[mike.m]

Rick,

Thanks for the come-back! I'm not sure what you mean that I need to create a db to append the username to the front. I did create one db for autopilot as instructed, with one user. Do I need to create another?

[GvilleRick]

Originally Posted by mike.m

Rick,

Thanks for the come-back! I'm not sure what you mean that I need to create a db to append the username to the front. I did create one db for autopilot as instructed, with one user. Do I need to create another?

No, you need to create the one database, create a user for that database, and add the user to the database. Both the database and the user will have your cPanel username appended to the front of the names you choose. Often the last step, adding the user to the database, is the step that is missed.

[mike.m]

Nope, I've got all that covered. I submitted a ticket at whmautopilot.com, waiting to hear back from them. I'm pretty sure the problem is that, for some reason, the install script is attempting to access the database without a password.

[mike.m]

Actually haven't heard from WHMAuto. It's 2 days. Rick what are your PHP settings?

[striddy]

Originally Posted by mike.m

Actually haven't heard from WHMAuto. It's 2 days. Rick what are your PHP settings?

PHP settings for what?

[GvilleRick]

Originally Posted by mike.m

Actually haven't heard from WHMAuto. It's 2 days. Rick what are your PHP settings?

I'm afraid that I can't help much with WHMAuto. I was just mentioning the general steps to create and use a database when you install generic scripts.

[mike.m]

Originally Posted by striddy

PHP settings for what?

If I knew... I wouldn't be asking.

If it helps though, I'm trying to figure out why the install script is attempting to access my database WITHOUT a password. See above ^^

ps. Still waiting to hear from WHMAutopilot.com about this.

[dewt]

Hi mike,

I've never used Autopilot myself so can't offer any specific instructions, but reading the posts and having just watched the tutorial video there are a couple of things that spring to mind:

1. When you assigned the user to the database, what permissions did you give it?
2. When you filled in the database details in the install script, did the username have your username infront of it as well (ie cPanel_username_DBusername).
3. Finally, did you read the install.txt file to make sure that your php configuration was correct for Autopilot?

[mike.m]

dewt,

So you think it could be my PHP settings? the .txt file didn't say a whole lot about my PHP settings if I remember correctly. I've got my db_username set the same way I have it @hostgator. username_database/username_user/password
I can't figure out why it isn't using my password.

[striddy]

Originally Posted by mike.m

So you think it could be my PHP settings?

Not likely.

Did you view the install video on whmautopilot's website? If not, please do as it may be of help.

Before running the install of the software, you must have done the following in cpanel.

• Created a database
• Created a database user with a password
• Added the database user you created to that database will full privileges

When running the autopilot install, pay particular attention to the following:

• Use localhost for the database host
• Use yourCpanelUserName_dataBaseName for the database name
• Use yourCpanelUserName_dateBaseUserName for the database user
• Use the password you used when you setup the database user in cpanel

[pathiggins]

I know Brandee personally. I used to use whmautopilot a few years ago. the hostgator reseller account comes with a free license for both whmautopilot, and whmcs.

I have used both and to be very honest, I think that Brandee is not up on his game.

I highly recommend you delete the autopilot and install the whmcs option you will be happier with its performance.

Patrick Higgins

[mike.m]

Pat have you ever tried V3?

[pathiggins]

Yes, but Brandee does not seem to be offering the same level of support as hostgator users are used to