[mats]

I have a problem with sourcebans

L 05/05/2008 - 19:50:38: [sourcebans.smx] Database failure: Could not find driver "mysql"
L 05/05/2008 - 19:50:38: [sourcebans.smx] Database failure: Could not find driver "mysql"
L 05/05/2008 - 19:50:38: [sourcebans.smx] Database failure: Could not find driver "mysql"
L 05/05/2008 - 19:54:58: [sourcebans.smx] Database failure: Could not find driver "mysql"
L 05/05/2008 - 19:54:58: [sourcebans.smx] Database failure: Could not find driver "mysql"
L 05/05/2008 - 19:54:58: [sourcebans.smx] Database failure: Could not find driver "mysql"
L 05/05/2008 - 19:55:04: [sourcebans.smx] Database failure: Could not find driver "mysql"
L 05/05/2008 - 19:55:04: [sourcebans.smx] Database failure: Could not find driver "mysql"
L 05/05/2008 - 19:55:04: [sourcebans.smx] Database failure: Could not find driver "mysql"

L 05/05/2008 - 19:50:38: SourceMod error session started
L 05/05/2008 - 19:50:38: Info (map "de_dust") (file "errors_20080505.log")
L 05/05/2008 - 19:50:38: [SM] Unable to load extension "dbi.mysql.ext.so": No such file or directory
L 05/05/2008 - 19:50:38: [SM] Native "LogToFile" reported: Could not open file "/home/game17/cstrike/"
L 05/05/2008 - 19:50:38: [SM] Debug mode is not enabled for "sourcebans.smx"
L 05/05/2008 - 19:50:38: [SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 3 on
L 05/05/2008 - 19:54:58: SourceMod error session started
L 05/05/2008 - 19:54:58: Info (map "de_dust") (file "errors_20080505.log")
L 05/05/2008 - 19:54:58: [SM] Unable to load extension "dbi.mysql.ext.so": No such file or directory
L 05/05/2008 - 19:54:58: [SM] Native "LogToFile" reported: Could not open file "/home/game17/cstrike/"
L 05/05/2008 - 19:54:58: [SM] Debug mode is not enabled for "sourcebans.smx"
L 05/05/2008 - 19:54:58: [SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 3 on
L 05/05/2008 - 19:55:04: SourceMod error session started
L 05/05/2008 - 19:55:04: Info (map "de_dust") (file "errors_20080505.log")
L 05/05/2008 - 19:55:04: [SM] Unable to load extension "dbi.mysql.ext.so": No such file or directory
L 05/05/2008 - 19:55:04: [SM] Native "LogToFile" reported: Could not open file "/home/game17/cstrike/"
L 05/05/2008 - 19:55:04: [SM] Debug mode is not enabled for "sourcebans.smx"
L 05/05/2008 - 19:55:04: [SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 3 on

I have seen this page: http://bugs.alliedmods.net/?do=details&task_id=801

and my host used this command:

ldd -d -r addons/sourcemod/extensions/dbi.mysql.ext.so

also he put the rights on the file to: -rwxr-xr-x

but still getting the same error
I just installed sourcemod, and when I install the plugin local(windows vista), everything is working perfect

[DontWannaName]

Post your database.cfg with your info blocked out so we can see the format its in cause I have done the format wrong before and it didnt work right at all. I dont know much about the whole SM Database system though.

[mats]

Originally Posted by DontWannaName Post your database.cfg with your info blocked out so we can see the format its in cause I have done the format wrong before and it didnt work right at all. I dont know much about the whole SM Database system though.

"Databases"
{
	"driver_default"		"mysql"
	
	"default"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sourcemod"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	
		"sourcebans"
	{
		"driver"			"default"
		"host"				"77.75.***.***"
		"database"			"mats_bans"
		"user"				"mats_bans"
		"pass"				"****"
		//"timeout"			"0"
		"port"			"3306"
	}
	
	"storage-local"
	{
		"driver"			"sqlite"
		"database"			"sourcemod-local"
	}
}

[W][LDF][RE]

Take this out and try again....
"default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}

Also, when you logon to your webhost cpanel...see if they have remote sql in the database area. If they do than add your game server ip there to allow access. Also, check that your database mat_bans has all permissions in databases.

[mats]

Originally Posted by W][LDF][RE Take this out and try again.... "default" { "driver" "default" "host" "localhost" "database" "sourcemod" "user" "root" "pass" "" //"timeout" "0" //"port" "0" } Also, when you logon to your webhost cpanel...see if they have remote sql in the database area. If they do than add your game server ip there to allow access. Also, check that your database mat_bans has all permissions in databases.

when I remove it, it still do not work

the database server is not located at my gameserver hosting company, but on my webhosting company, I'm using the database for my cs1.6 servers and there its working perfect

I changed to driver to: sqlite

and now I'm getting this error:

L 05/06/2008 - 00:57:03: [sourcebans.smx] Failed to retrieve groups from the database, no such table: sb_srvgroups
L 05/06/2008 - 00:57:03: [sourcebans.smx] Failed to retrieve admins from the database near "SELECT": syntax error

L 05/06/2008 - 00:57:03: [sourcebans.smx] Failed to retrieve admins from the database, near "SELECT": syntax error
L 05/06/2008 - 01:02:18: [sourcebans.smx] [SourceBans] Query failed! no such table: sb_bans

but the tables do exist so sqlite is not working i think

[W][LDF][RE]

I gathered that much from your config... and why I posted this...
Also, when you logon to your webhost cpanel...see if they have remote sql in the database area. If they do than add your game server ip there to allow access. Also, check that your database mat_bans has all permissions in databases.

[mats]

Originally Posted by W][LDF][RE I gathered that much from your config... and why I posted this... Also, when you logon to your webhost cpanel...see if they have remote sql in the database area. If they do than add your game server ip there to allow access. Also, check that your database mat_bans has all permissions in databases.

remote access is all set to the right ip (as I said, no problems on the cs1.6 servers) and the db has all permissions

[zerak]

When you wrote the command "ldd -d -r addons/sourcemod/extensions/dbi.mysql.ext.so "
you didn't get "libz.so.1 => not found" ?

Now I will hijack the thread. My libz.so.1 is installed but I still get the above error and this will cause mysql drivers fail to load. Running Ubuntu server.
How do I set the right path or make it find the file?

[mats]

Originally Posted by zerak When you wrote the command "ldd -d -r addons/sourcemod/extensions/dbi.mysql.ext.so " you didn't get "libz.so.1 => not found" ? Now I will hijack the thread. My libz.so.1 is installed but I still get the above error and this will cause mysql drivers fail to load. Running Ubuntu server. How do I set the right path or make it find the file?

no I don't get that message ;)
cstrike # ldd -d -r addons/sourcemod/extensions/dbi.mysql.ext.so
linux-gate.so.1 => (0xffffe000)
libz.so.1 => /lib/libz.so.1 (0xf7df1000)
libpthread.so.0 => /lib/libpthread.so.0 (0xf7dd9000)
libdl.so.2 => /lib/libdl.so.2 (0xf7dd5000)
libm.so.6 => /lib/libm.so.6 (0xf7daf000)
libc.so.6 => /lib/libc.so.6 (0xf7c80000)


please can someone help me

[zerak]

What does it give you then? You did execute it in cstrike folder as it said in the thread?