Problem with installation

by **Ghostwalker** » Sat Jul 15, 2006 11:31 pm

Hi,

I am installing WOW Roster and i am a newbie so please forgive me if this is a stupid question.

When I run install.php, I get the page and everything checks out fine.

PHP Version: Using: 5.1.4 Required: 4.3.0+
MySQL Module: Available: Yes Required: Yes
GD Module: Available: Yes Required: Optional

When I enter my SQL information, I get an error saying it cannot connect to the database as my username on my server...

"Failed to connect to database DB_2D4AFF as User_2D4AFF@SQLHosting01.myhosting.com

Restart Installation"

I know this is the correct information as I can connect to it through Access using the same information. I don't know what I am doing wrong. I know this should be easy and maybe I overlooked something really stupid but any help would be greatly appreciated.

Thank you

by **Churchland** » Sun Jul 16, 2006 4:19 pm

Tag, I'm having the same problem

by **zanix** » Sun Jul 16, 2006 4:29 pm

Make sure the username you are using has permissions to access the database used

Also make sure that the mysql server Database Host is set correctly as well

by **Promark** » Tue Jul 18, 2006 7:57 am

I am experiencing the same difficulties. I tracked it down to the name of my database. My hosting provider auto names my DBs for me like so: accountname, accountname-1, accountname-2, etc. I tried to setup Roster on the -1 DB and it fails every time. Tried it on the normal name, where my forum is, and it works fine.

Anyone got a way to work around this?

by **Sinny** » Fri Dec 01, 2006 1:59 am

Okay, I found that using "localhost" for the host name doesn't appear to work. Here's the things I did.

1. From the shell, I logged into mysql as "root".

2. I ran this command:

grant all on mydbyname.* to myname@my.complete.machine.name identified by 'mypw';

3. I then specified this information in install.php:

Database host: my.complete.machine.name
Database name: mydbname
Database username: myname
Database pw: mypw

(Of course, in both steps 2 and 3, I put in real data, not fake data).

Once I did all that, i was able to get it to work. I don't know why "localhost" didn't work.

by **zanix** » Fri Dec 01, 2006 1:47 pm

Some hosts have their mysql and web servers on different machines even though their addresses appear to be the same

Or even better, some host don't allow local access to the machine and force you to use the real address

by **abaddonislord** » Wed Apr 04, 2007 1:44 pm

alright, i appolagize if im beating a dead horse here and the solution is posted somewhere.... =0
here is what i have:
Windows server 2003 running iis 6.0
mySQL 5.0.37
PHP 5.2.1

at this point i have created a db, created a user and verified the user has access to the db. i can log in from sheel using the --user=myuser --password=mypsswd mydbname syntax. I have verified the following as well:
PHP Version: Using: 5.2.1 Required: 4.3.0+
MySQL Module: Available: Yes Required: Yes
GD Module: Available: Yes Required: Optional

as i am hosting, and running the installer on the server, localhost should work, and does from the shell. However I still get the following error:

Failed to connect to database mydb as newbieuser@localhost

I have rebuilt the DB as well as the PHP and wow roster directorys several time and am flat out of ideas!
thanks in advance for any assistance!
regards,
Abaddonislord

by **zanix** » Wed Apr 04, 2007 2:05 pm

That error sounds like it having connection issues

by **abaddonislord** » Thu Apr 05, 2007 1:51 am

Do you have any suggestions for troubleshooting that? is it an issue with the configuration of the mySQL?
Thanks

by **tuigii** » Thu Apr 05, 2007 2:18 pm

Is localhost defined ?

What about a ping localhost ?

Try also a connect to 127.0.0.1 (=localhost).

by **abaddonislord** » Fri Apr 06, 2007 12:32 am

Yeah. local host is working right. I actually just got this working. the localhost pointed me in the right direction!
he problem was with the TCP/IP settings of the mySQL. The TCP/IP stuff had an issue. I had to reinstall and make sure that the TCP/IP stuff was set up right. =)
Thanks for the help!
abaddonislord

by **iduna2** » Mon Jul 09, 2007 8:23 am

I am having the same problem abaddonislord was having, however I have absolutely no cllue how to look at the tcp/ip settings of my database using mysql admin.
can someone help please?

by **xaxa** » Thu Jan 10, 2008 5:12 am

Hey, I described here that I had the same problem and that I expect that the problem is not in TCP/IP but in handling login parameters during installation process and somebody deleted my post without any info why.

I described that I solved it by modification of mysql.php file with directly inserted login parameters just as a hint for identification of problem?

Who deleted my post and why?