Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 66 guests, and 208 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
isaac
isaac
California
Posts: 1,173
Joined: April 2004
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 12
Ruben 5
M4TT 4
Morgan 3
isaac 2
Latest Photos
Previous Thread
Next Thread
Print Thread
Trouble connecting to database #40290
04/16/04 01:23 PM
04/16/04 01:23 PM
Joined: Apr 2004
Posts: 7
G
GregKelley Offline OP
stranger
GregKelley  Offline OP
stranger
G
Joined: Apr 2004
Posts: 7
Very new to UBB Threads. In fact, I downloaded and installed everything (PHP, MySQL, MyPHPAdmin, UBB Threads trial) last night.
I am going through the UBB Threads installation and am stuck at step 2. I put in the name of the database server, the database name, database user and password and when I click "Check Database Settings" it tells me it failed connecting to server and database.
I am running it on a Windows 2000 server with IIS 5.0. I followed the instructions regarding "Installing and using PhPMyAdmin" and am supplying the database name, server and user and password that I used following through that document.

Any ideas?

-Greg


Greg Kelley
Vestige, Ltd.
Re: Trouble connecting to database #40291
04/18/04 05:06 PM
04/18/04 05:06 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Have you verified that the mysql server is actually running? You'll want to check that, and then also make sure that you have setup permissions for the database properly for the username/password and host that is connecting the mysql server. Those are usually the most common errors during install. We can start getting more specific on direction if both of those are verified.

Re: Trouble connecting to database #40292
04/18/04 08:26 PM
04/18/04 08:26 PM
Joined: Apr 2004
Posts: 7
G
GregKelley Offline OP
stranger
GregKelley  Offline OP
stranger
G
Joined: Apr 2004
Posts: 7
Thanks for replying.
I would assume that MySQL is running because I can connect to it and make modifications through PhpMyAdmin.
As far as the username and password being setup right, I followed explicitly the instructions on the UBBThreads site titled "Installing and using PhPMyAdmin". I even dumped that username and re-added it following the instructions.


Greg Kelley
Vestige, Ltd.
Re: Trouble connecting to database #40293
04/19/04 09:24 PM
04/19/04 09:24 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Hmm, is your phpmyadmin install running on the same domain name as your threads install? What are you putting in for the database server value? Not too much can go wrong in this area, so I'm not exactly sure what would be causing it. This might be something we'd have to look at in a ticket since we'd need db username and password to test.

Re: Trouble connecting to database #40294
04/19/04 10:40 PM
04/19/04 10:40 PM
Joined: Apr 2004
Posts: 7
G
GregKelley Offline OP
stranger
GregKelley  Offline OP
stranger
G
Joined: Apr 2004
Posts: 7
PhyMyAdmin is running on the same server that has MySQL as well as UbbThreads.
For database server, I have put in the netbios name, the FQDN, the IP address and localhost.

I know it seems very weird to me too. I understand the concept and what is going on and to me, everything is plugged in, turned on and ready to go but then it hiccups.

Re: Trouble connecting to database #40295
04/19/04 11:39 PM
04/19/04 11:39 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Are you able to connect to that database from a mysql command prompt. When you install mysql there is one exe installed that allows you to connect to the mysql server directly from a command prompt. If you can use that then we can get more info if the username/password are being accepted properly.

Not exactly sure where it's been installed at, but if you open up a command window and CD into the directory that the mysql utilities were installed then you should be able to type:

mysql.exe databasename -uyourusername -p

Change databasename to the actual name of your database. yourusername will be the user you setup. At that point it should prompt you for a password. If it allows you in then that verifies that the username/password were setup correctly. If not, then we not it's something in that area.

And for the database server you should probably use the IP address of your server.

Re: Trouble connecting to database #40296
04/20/04 01:01 AM
04/20/04 01:01 AM
Joined: Apr 2004
Posts: 7
G
GregKelley Offline OP
stranger
GregKelley  Offline OP
stranger
G
Joined: Apr 2004
Posts: 7
Could not get in. So, I went back to view the users and noticed that the password for the user I set up was not encrypted.
So, I deleted the user and followed the instructions again. I had forgotten in step 11 to set the drop down to be "Password".
Once I did that and followed through, it worked.
I'll follow through the rest of the install steps and let you know if I have further problems.
Thanks!

Re: Trouble connecting to database #40297
04/20/04 01:41 AM
04/20/04 01:41 AM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Great, glad you got past that step <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Member being directed to "stopforumspam?"
by Lisanne. 07/14/18 10:27 AM
7.6.1.1 - Broken ReCaptcha (Not A Bug)
by M4TT. 07/01/18 06:02 PM
Control Panel / Transactions Username
by Morgan. 06/20/18 05:38 AM
Custom Insert won't save
by Baldeagle. 06/18/18 07:44 PM
random 500 server errors on post
by Bad Frog. 05/31/18 09:34 AM
Forum Statistics
Forums36
Topics35,125
Posts191,356
Members12,091
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)