Sourcebans not connecting to database

Sakretsos · **Author**

hello there.. i use centos 6.x x64 bits and i have problem to connect the sourcebans into mysql dedicated... i have speak into webhosting company to allow my gameserver ip into the firewall ... and i add the mysql remote host into the cpanel .. but i still have the problem

Code:

 <FAILED> file "dbi.mysql.ext.so": libz.so.1: cannot open shared object file: No such file or directory

can someone help me to fix that problem ?

Code:

database.cfg

	"sourcebans"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"********_sourcebans"
		"user"				"********_admin"
		"pass"				"**************"
		//"timeout"			"0"
		"port"			"3306"
	}

i also change the host to the dediacated ip adress.. but i have the same problem.. can someone help me ? thnx in advance !

Some more info maybe can help... i use ( CENTOS 6.X , 64 BITS )

Code:

ldd: warning: you do not have execution permission for `addons/sourcemod/extensions/dbi.mysql.ext.so'
        linux-gate.so.1 =>  (0x00a21000)
        libz.so.1 => not found
        libpthread.so.0 => /lib/libpthread.so.0 (0x00938000)
        libm.so.6 => /lib/libm.so.6 (0x004ae000)
        libc.so.6 => /lib/libc.so.6 (0x00c84000)
        /lib/ld-linux.so.2 (0x001e3000)

Sakretsos · *Last edited by Sakretsos; 02-17-2013 at 11:56.*

ok sorry for bump this ... but i resolve the problem... for centos users.. just install 32bits libs

Code:

yum install zlib.i686

and then ....

Code:

[root@sakretsos cstrike]# ldd -d -r addons/sourcemod/extensions/dbi.mysql.ext.so
ldd: warning: you do not have execution permission for `addons/sourcemod/extensions/dbi.mysql.ext.so'
        linux-gate.so.1 =>  (0x00e25000)
        libz.so.1 => /lib/libz.so.1 (0x00709000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x00338000)
        libm.so.6 => /lib/libm.so.6 (0x0055c000)
        libc.so.6 => /lib/libc.so.6 (0x00353000)
        /lib/ld-linux.so.2 (0x0029f000)

but now.. i have other problem....

Quote:

[sourcebans.smx] Database failure: [2003]: Can't connect to MySQL server on '178.21.x.x' (110). See FAQ: http://www.sourcebans.net/node/20

YamiKaitou · 02-17-2013 , 20:23 Re: Sourcebans not connecting to database

Does your host allow external connections to the MySQL server?

Sakretsos · *Last edited by Sakretsos; 02-18-2013 at 09:46.*

Quote:

Originally Posted by YamiKaitou

Does your host allow external connections to the MySQL server?

i speak with my host to allow my game server ip and we tell me that the ip have been added to firewall to allow the ip ... but maybe i can tell them to open the gameserver port too ? or.. what i need to tell to my host ? !

stoneyschillhouse · 02-18-2013 , 12:00 Re: Sourcebans not connecting to database

Tell us more about your system.

Is that all on one machine ? (GS, webspace and DB ?

Sakretsos · 02-18-2013 , 12:13 Re: Sourcebans not connecting to database

Quote:

Originally Posted by stoneyschillhouse

Tell us more about your system.

Is that all on one machine ? (GS, webspace and DB ?

i have 1 machine just for the gameserver... and 1 webhosting package with cpanel for the website.. and mysql database... and i want to connect sourceban on my webhosting mysql acount !

stoneyschillhouse · 02-18-2013 , 12:20 Re: Sourcebans not connecting to database

Is on your "webserver" setting up an WI like phpmyadmin ?

You must setting up, that the "sourcebansUser" of your mysql DB listening to localhost and to the GS.

I have set it up like this:

Code:

1st one = user: sourcebans | host: localhost | pw: yes | PRIVILEGES: .....

Code:

2nd one = user: sourcebans | host: GS IP| pw: yes | PRIVILEGES: .....

Sakretsos · 02-18-2013 , 12:23 Re: Sourcebans not connecting to database

Quote:

Originally Posted by stoneyschillhouse

Is on your "webserver" setting up an WI like phpmyadmin ?

You must setting up, that the "sourcebansUser" of your mysql DB listening to localhost and to the GS.

I have set it up like this:

Code:

1st one = user: sourcebans | host: localhost | pw: yes | PRIVILEGES: .....

Code:

2nd one = user: sourcebans | host: GS IP| pw: yes | PRIVILEGES: .....

yes my server have phpmyadmin is an CPANEL webhosting acount.. what i must do to work ?? cause i don't realy 100% understand that .. cause english is not my main language !

Sakretsos · *Last edited by Sakretsos; 02-18-2013 at 20:07.*

ok i bring the problem... i have installed the csf firewall on the gameserver.. and i don't open the port 3306 that is the mysql port to connect in the gameserver... ! thnx for help.. this maybe can help someone that searching info about how to setup a source ban mod on CENTOS machines.. ! , a moderator can close this thread.. please!