I am trying to install Threads for the first time. (We have a lively Classic 6.7.3 board.)

I have come to a roadblock on the Database settings.

I enter the following:
Database server: localhost
Database name: WHITNEY
Database user: WHITNEY1
and the password.

Clicking the Check database Settings button returns:

Here we are checking your database connectivity and permissions. If any of these checks fail you will need to correct the errors in order to proceed.
Connecting to server FAILED
Connecting to database FAILED
One or more of the above checks failed. Click the button below to return to the previous screen to verify your settings.

I called the tech support line, and the guy tried it on that end, and it failed as well. He says the "localhost" is the correct name for the Database Server.

The only thing I have done differently in the primary install is to create the installation directory under /httpdocs as the name "forum" rather than "forums".

Hope someone here can help me out.
Thanks in advance.

maybe try 127.0.0.1 instead of localhost?

Thanks for the suggestion. Tried 127.0.0.1, and got the same result.

By the way, I am installing on a unix server, running MySQL 4.1.11, and PHP 4.3.11

You'll want to verify the username and password are correct as well. If these are incorrect it can keep you from connecting to the database server completely.

Well, I can successfully log into their Server Administrator page using my username WHITNEY1 and the password. It gives me access to some PLESK-powered pages.

So I think I have the username/password set up ok.

Is there an alternate route I can go to determine the specific error begin returned?

The Username and password for your server admin page is more than likely different than the Database Username / Password. You could make a quick PHP script with just the following in it:



Just name it something like test.php, replace "username" and "password" with the actual username/password and then put it into your install directory. Bring it up in your browser and it should give you more info.

Thanks. Tried it, got the following:

Warning: Access denied for user: 'WHITNEY1@localhost' (Using password: YES) in /usr/local/psa/home/vhosts/whitneyportalstore.com/httpdocs/forum/install/test_install.php on line 3

Warning: MySQL Connection Failed: Access denied for user: 'WHITNEY1@localhost' (Using password: YES) in /usr/local/psa/home/vhosts/whitneyportalstore.com/httpdocs/forum/install/test_install.php on line 3



Edit ...More info coming...

Ok, so it's definitely the username/password that is being used. You'll want to contact your host and find out the proper username/password to access your database.

Ok, solved the problem with your help. I used the PLESK pages to create a second user and used the above test php file to login to the database. What I found is that this system accepts a Database name and Database user in ALL LOWER case ONLY. This is in spite of the fact that I asked tech support to initially create everything using upper-case.

Once I switched to all lower-case, I got past the check database settings page.

Not sure if that is only a restriction on this server, but a note in your install instructions could be useful.

Thanks for the help!

Updated documentation is always good, but as an FYI Windows hosting is typically not case sensitive and Linux often is.

.

Most CPanels work independantly of the MySQL password; in fact, they generally utilize your user password on the maching (such as for ftp or ssh access); mysql is a seperate service with its own user system (as it has a very strict permission system).

And as NT said best, Windows does not care about cAsE SensATIvitY, which can be horrid with usernames and passwords (the option to be CaSe SENsITIve is a good security option as well as you can change a simple string into a useful/secure password due to how you EnTEr it).

Well passwords are case sensitive on Windows, just not the file system (though it can be but I've never seen anyone set it up or use it)

Cpanel is a pita but unless you've got the cash to buy a VPS or a real server not much choice.

phpAdmin gives me fits as well via CP

Well, I was referancing them as cpanels, not specifically the cpanel control panel... I was referancing:
CPanel
Webmin
Plesk
etc...

Myself, I use Webmin as my cpanel, because I'm just that hardcore lol... besides, I like customization

No choice for me

Have to take what they give me as I don't have the cash to do my own server. But as I posted in another thread, was cool they gave me some free stuff by knowing my site already.

I'm on a VPS, so I can customize just about anything; in fact, I just upgraded Webmin/Usermin/Virtualmin/PHP/MySQL on my CentOS4.4 VPS hehe

I thought you said you was broke LOL

The VPS is free, my compensation for working 24/7 at my old place of employment...

That's cool.

yes, fueling my addictions is cool