Member

[newn]

Member

[Arjen]

Is mysql running?
Did you install PhpMyAdmin?

More info please

[Terrorkarotte]

I repeat Arjen: Give us more informations!

Where is the mysql server running/hosted Is it working in general, etc., etc.

[Arjen]

Is there anything in the logging of the gameserver?

../addons/sourcemod/logs/sourcebans.log

Did you change ../addons/sourcemod/configs/databases.cfg on the gameserver?

Did you change the ip in the sourcebans webconfig?

[realchamp]

Maybe you should allow the new PC to connect to the database and double verify that the information is correctly set.

[Arjen]

http://www.sourcebans.net/faq/i-get-following-error-database-failure-1045

[xaider]

Your server is 64 bit, amirite? If so - you need some more 32bit libraries for dbi.mysql.ext.so to work. Use ldd to find which one you need.

[BehaartesEtwas]

try connecting the mysql server from linux console, i.e. run

Code:

mysql --host=<database-ip> -u <database-username> -p

if that works, the problem is with sourcemod not being able to connect to (probably) any mysql databse - you might have done something wrong during installation. if even that does not work it's not sourcemod. maybe your mysql server doesn't allow connections from your new machine.

[xaider]

(06-22-2010, 05:36 PM)BehaartesEtwas Wrote:  try connecting the mysql server from linux console, i.e. run

Code:

mysql --host=<database-ip> -u <database-username> -p

if that works, the problem is with sourcemod not being able to connect to (probably) any mysql databse - you might have done something wrong during installation. if even that does not work it's not sourcemod. maybe your mysql server doesn't allow connections from your new machine.

Probably.. But I had a similar error. Reason - one .so wasn't present in 32bit version (I don't remember which one). Maybe he should run ldd on those libraries - perhaps some child library is missing.

[Terrorkarotte]

I bet you just copied and pasted the command.
You need to replace address etc. with your data...

[cryotek]

(06-22-2010, 11:42 PM)newn Wrote:  

(06-22-2010, 11:39 PM)Terrorkarotte Wrote:  I bet you just copied and pasted the command.
You need to replace address etc. with your data...

Well, you've just lost your bet. You own me something.

Okay, i'll make it with examples how i did it:

mysql --host=<google.com> -u <newn> -p

don't use the <> brackets

(06-22-2010, 09:01 PM)newn Wrote:  -bash: address: No such file or directory

Almost makes me wanna think mysql isn't installed on your SRCDS server.

[cryotek]

(06-23-2010, 05:42 AM)newn Wrote:  ERROR 2003 (HY000): Can't connect to MySQL server on 'THE ADDRESS' (111)

P.S. yes, checked the password

When you set up the mysql database on the webserver, did you set it so only a specific IP address can connect using the username? If so this could be the issue. The MAC could be different in comparison to the windows box and made your IP address change.

[cryotek]

Looking further into this issue i've found the following things:

Quote:Symptoms

On the import to MySQL the following error arises: “ERROR 2003 (HY000): Can't connect to MySQL server on '128.103.100.153' (10061)”.

Cause

The MySQL server doesn't exist or IP address or port is incorrect.

Solution

Please follow the steps below to verify and fix the problem:

Make sure that the host with such IP Address exists. Please enter the following command in the Command Shell:
ping address
where:

address - name or IP address of the MySQL host.

Try to connect manually to MySQL Server using command:
MySQL -u 'user' -p -h 'host' -P 'port'
where:

'user' - user name;
'host' - name or IP address of host where server is installed;
'port' - MySQL port (by default 3306);

Another solution people have found is if you look at your mysql.cnf(providing you have access to the config server), comment out bind-address and restart mysql this normally fixes the issue. Again make sure the server is using port 3306

[realcs]

I have the same problem, I use CentOS server 6 for CS: S.
I installed sourcebans external web server (so not on the same computer) I configured the database, user name, password, I put "game upload" over the "addons" I set "database.cfg". I can say that they go all out for connecting to the server CS: S.
Gives me error:
Hostname VAC MOD Players OS Map
N / A N / A Error connecting (1.2.3.4:27016) N / A N / A
N / A N / A Error connecting (1.2.3.4:27015) N / A N / A
I mean I installed the server CS: S, LAMP, mysql, phpmyadmin ... etc.

I need help. Thx

[Mike]

Nice mega bump. STOP POSTING IN OLD THREADS.