Problem with installation

Installation issues with WoWRoster

Problem with installation

Postby 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
Last edited by Ghostwalker on Sat Jul 15, 2006 11:36 pm, edited 1 time in total.
Ghostwalker
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sat Jul 15, 2006 1:47 pm

Re: Problem with installation

Postby Churchland » Sun Jul 16, 2006 4:19 pm

Tag, I'm having the same problem
Churchland
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Tue Jul 04, 2006 10:53 pm

Problem with installation

Postby 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
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: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Problem with installation

Postby 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?
Promark
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Tue Jul 18, 2006 12:41 am

Re: Problem with installation

Postby 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.
Sinny
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Thu Nov 30, 2006 10:45 pm

Problem with installation

Postby 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
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: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Failed to connect to database newbie as nub@localhost

Postby 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
abaddonislord
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Mon Apr 02, 2007 1:20 pm

Problem with installation

Postby zanix » Wed Apr 04, 2007 2:05 pm

That error sounds like it having connection issues
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: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Problem with installation

Postby 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
abaddonislord
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Mon Apr 02, 2007 1:20 pm

Re: Problem with installation

Postby 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).
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

Problem with installation

Postby 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
abaddonislord
WR.net Apprentice
WR.net Apprentice
 
Posts: 4
Joined: Mon Apr 02, 2007 1:20 pm

Re: Problem with installation

Postby 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?
iduna2
WR.net Apprentice
WR.net Apprentice
 
Posts: 6
Joined: Sun Jul 08, 2007 3:53 pm

Problem with installation

Postby 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?
xaxa
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Mon Aug 14, 2006 6:42 pm


Return to Installation

Who is online

Users browsing this forum: No registered users and 1 guest

cron