Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (JPFolks), 38 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 05/10/05
Posts: 1
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 17
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 2 1 2 >
Topic Options
#172703 - 01/08/07 01:04 PM Check Database settings fails
Steve C Offline
enthusiast
Registered: 05/05/06
Posts: 215
Loc: California
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.
_________________________
WhitneyZone -- Whitney Hikers Association
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#172704 - 01/08/07 01:09 PM Re: Check Database settings fails [Re: Steve C]
Ian Spence Offline
Registered: 06/04/06
Posts: 255
maybe try 127.0.0.1 instead of localhost?
Top
#172705 - 01/08/07 01:19 PM Re: Check Database settings fails [Re: Ian Spence]
Steve C Offline
enthusiast
Registered: 05/05/06
Posts: 215
Loc: California
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
_________________________
WhitneyZone -- Whitney Hikers Association
Top
#172706 - 01/08/07 01:35 PM Re: Check Database settings fails [Re: Steve C]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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.
Top
#172708 - 01/08/07 01:44 PM Re: Check Database settings fails [Re: Rick]
Steve C Offline
enthusiast
Registered: 05/05/06
Posts: 215
Loc: California
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?
Top
#172709 - 01/08/07 01:58 PM Re: Check Database settings fails [Re: Steve C]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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:

 PHP:

<?php

mysql_connect("localhost","username","password");

?>



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.
Top
#172713 - 01/08/07 02:26 PM Re: Check Database settings fails [Re: Rick]
Steve C Offline
enthusiast
Registered: 05/05/06
Posts: 215
Loc: California
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...


Edited by Steve C (01/08/07 02:29 PM)
_________________________
WhitneyZone -- Whitney Hikers Association
Top
#172714 - 01/08/07 02:29 PM Re: Check Database settings fails [Re: Steve C]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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.
Top
#172715 - 01/08/07 02:56 PM Re: Check Database settings fails [Re: Rick]
Steve C Offline
enthusiast
Registered: 05/05/06
Posts: 215
Loc: California
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!
_________________________
WhitneyZone -- Whitney Hikers Association
Top
#172719 - 01/08/07 03:42 PM Re: Check Database settings fails [Re: Steve C]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
Updated documentation is always good, but as an FYI Windows hosting is typically not case sensitive and Linux often is.

.
Top
Page 1 of 2 1 2 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181697 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image