Cannot connect to database

Installation issues with WoWRoster

Cannot connect to database

Postby Velouria » Mon Jan 22, 2007 3:13 am

Hi all,

I can't see anyone else who's had this problem. I've read all the forums and wiki. At step 2 of the installation where you put in all the database configuration details, the only way I can get to the next step is to put in the name and password that I use to log into the Cpanel website admin. The username and password that I assigned to the database in MySQL don't work. Anyway, I can never get beyond step 3. I always get a 1044 or 1045 cannot connect to database error.

Does anyone have any suggestions?

Thanks!
Velouria
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Mon Jan 15, 2007 3:59 am

Cannot connect to database

Postby zanix » Mon Jan 22, 2007 3:30 am

Make sure you assign the username you created in cpanel to the database you created for roster
I forgot that once, pulled my hair out trying to figure it out
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Cannot connect to database

Postby Velouria » Mon Jan 22, 2007 3:34 am

Thanks for the quick reply!

I've already done that though :???:
Attachments
roster.jpg
roster.jpg (16.9 KiB) Viewed 397 times
Velouria
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Mon Jan 15, 2007 3:59 am

Cannot connect to database

Postby zanix » Mon Jan 22, 2007 3:47 am

Did you use these settings in the installer?

Database name = entropic_roster
Database user = entropic_card
Database password = *****
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Cannot connect to database

Postby Velouria » Mon Jan 22, 2007 3:51 am

Yep, and I get the following error.

It's weird that the website admin password works as those details aren't assigned to the database.
Attachments
error.jpg
error.jpg (7.9 KiB) Viewed 392 times
Velouria
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Mon Jan 15, 2007 3:59 am

Cannot connect to database

Postby zanix » Mon Jan 22, 2007 3:57 am

Hmmm, weird indeed
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Cannot connect to database

Postby Velouria » Mon Jan 22, 2007 4:26 am

The only other thing I think it may be is my server or Cpanel or something. Sometimes, and completely by random, when I log into Cpanel the MySQL databases are missing and the MySQL page is blank. It says in the account summary:

Mysql databases: / unlimited

whereas it should say:

Mysql databases: 2 / unlimited

:shock:

But even when they are there, like now, I have the same problem.
Velouria
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Mon Jan 15, 2007 3:59 am

Re: Cannot connect to database

Postby Ugor » Mon Feb 26, 2007 2:50 pm

Hi
I was kinda hoping that u lads have figured out what this issue is, as i seem to be having the same problem :S

Installing the roster and creating the conf.php file is np, but when i press the link to configure my roster, i get the error of not being able to connect to mysql database with the username ive provided. Ive seen what u guys have wrote about using the correct username and pass, and ive done this 4-5 times now. Ive even tried to delete the database and user accounts, and the creating them again but nada.

Any suggestions at all?
Ugor
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Mon Feb 26, 2007 12:48 am

Re: Cannot connect to database

Postby Velouria » Sat Mar 03, 2007 2:31 pm

Hi!

I am glad to see that I am not the only one.. but sad at the same time. I am still trying to figure this out. Any ideas would be hugely appreciated.

~V~
Velouria
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Mon Jan 15, 2007 3:59 am

Cannot connect to database

Postby zanix » Sat Mar 03, 2007 9:03 pm

Ask your web server host and see if maybe the mysql server is on a different server (not localhost)
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Cannot connect to database

Postby fuzzynips » Sat Mar 03, 2007 9:04 pm

try changing your user name just to entropic instead of entropic_card. i had the same issue and that worked for me for some reason. now im having another issue though on the post below this one :(
fuzzynips
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Sat Mar 03, 2007 5:14 am

Re: Cannot connect to database

Postby Velouria » Sun Mar 04, 2007 2:48 am

Well, it is finally working! I explained my problem to my web server host and he created a new DB and user and it magically worked. He doesn't know why mine didn't work. I wish I knew! If only I had done that 3 months ago.

Sorry I have no answers for you apart from hassling your host :razz:

~V~
Velouria
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Mon Jan 15, 2007 3:59 am


Return to Installation

Who is online

Users browsing this forum: No registered users and 0 guests