Hej guys,

I just tried to setup the beta on a new database and new path next to our old roster install.
The first couple of steps go fine, (put the files there, created a database, went to the site with my browser, checks were ok).
However, when I enter the database information it returns:

Code: Select all

Failed to connect to database hoh_roster2 as roster2@black.owl-ict.nl


Hmm...

On the commandline:

Code: Select all

# mysql -u roster2 -h black.owl-ict.nl -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 665167 to server version: 5.0.37


So that works.

However, in the errorlog I noticed something strange:

Code: Select all

[Tue Aug 21 16:25:55 2007] [error] [client 84.86.177.176] PHP Warning:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Access denied for use
r 'www'@'purple.owl-ict.nl' (using password: NO) in /www/vhosts/www.handofhades.eu/roster2/lib/dbal/mysql.php on line 103, referer: http://www.handofhades.eu/roster2/
index.php


... user 'www' ???
That's not what I entered.
Also the using password 'NO' is definately invalid.

Any ideas?

Using PHP verison 4.4.7 and MySQL 5.0.37.

Thanks.

All I can say is make sure you are entering the right information in the right boxes
I have done that before and couldn't figure out why my mysql user name was showing up in the database name location in the error...

Is there any extra debug trace or something that I can enable to figure it out?

are you using any special chars in the db name, db user, or db password that might be causing the variable to be broken out of? Only way I can see 'www' getting passed is if the script never passed this information to the connect call, and it is just trying to use the Webserver user name as the auth name and thus no password either.

I am getting similar problems with database connection / authentication.

Installation went just fine and I was able to upload my guild data successfully, but when trying to install a first addon like "Memberlist", I am getting a databse error saying

Code: Select all

1044: Access denied for user 'dbuser'@'localhost' to database 'dbname'

(where dbuser and dbname exactly match the correct values)

Without posting the full lot, this is what it fails at:

Code: Select all

SQL:
CREATE TEMPORARY TABLE `backup_roster_addon_config` LIKE `roster_addon_config`
File: lib/dbal/mysql.php
Line: 202

I checked the db and it seems to populate the roster_addon table correctly, but fails when it comes to roster_addon_config. I am using the German locale (if that matters).

When going back to the addon config after that, I got a green box indicating a successful install, when I repeat that for the activation bit, it also shows "green", but I actually never managed to see the memberlist yet.

Sorry if that is not 100% what benv666 reported - I just thought that sounded quite similar with regards to database login issues.

Kind regards,
Tweetor

Is the server running MySQL 5? You may need to do the fix explained here:

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Then, if you do that, you'll need to eliminate the client version check as explained here:

http://wowroster.net/Forums/viewtopic/t=3997.html

@ds: no weird characters, all in the [a-z0-9_-] range. You're right about the passing of info though, but the weird thing is: the error page I receive DOES tell me the correct username and host etc.

@seleleth: Indeed, the server is running MySQL 5, though the client libs are also mysql 5 so I kind of expected no problems there. (also our current (old) roster setup runs on the exact same software and hosts, no problems).

Anyway, I tried the workaround that you linked, and -it WORKS-.

So basically:
PHP4 + MySQL 5 == No no, unless you use the old password hashing for mysql and disable the client version check.

Thanks for the help guys, let's see if I can get it to work

Ok guys, been messing with it a bit more:
In addition to the database issue, I ran into another one:
I couldn't upload my characterprofiler data to load the guild into roster.
It gave me some error about a missing strftime function, so I got tired of php4.

Installed it on PHP5 now, (with the same MySQL 5 db) no issues so far.
(just loaded guild info)

tweetor: Your issue is not the one described here. You have a permission issue.

@Pleegwat: yeah, saw it's a different problem than described above. I will go ahead and log another topic for that than.