[Addicted.]

Hi guys,

I am trying to connect to a mysql database for a plugin but when my server tries to connect I get this error

Connection to SQL database has failed, Reason: Could not find driver "mysql"

My databases.cfg file:

"Databases"
{
	"driver_default"		"mysql"
	
	// When specifying "host", you may use an IP address, a hostname, or a socket file path
	
	"default"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sourcemod"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	
	"storage-local"
	{
		"driver"			"sqlite"
		"database"			"sourcemod-local"
	}

	"clientprefs"
	{
		"driver"			"sqlite"
		"host"				"localhost"
		"database"			"clientprefs-sqlite"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
	"store"
	{
    		"driver"        		"mysql"
    		"host"          		"23.***.***.****"
    		"database"      		"****"
    		"user"          		"****"
    		"pass"          		"****"
	}

}

[Powerlord]

Can you show us the output of sm exts list

[floube]

Check this.

[Addicted.]

Originally Posted by Powerlord Can you show us the output of sm exts list

SM] Displaying 12 extensions:
[01] Automatic Updater (1.7.0-dev+4888): Updates SourceMod gamedata files
[02] Webternet (1.7.0-dev+4888): Extension for interacting with URLs
[03] CS Tools (1.7.0-dev+4888): CS extended functionality
[04] BinTools (1.7.0-dev+4888): Low-level C/C++ Calling API
[05] SDK Tools (1.7.0-dev+4888): Source SDK Tools
[06] Top Menus (1.7.0-dev+4888): Creates sorted nested menus
[07] <FAILED> file "steamtools.ext.so": /home/client4316/service3869/csgo/csgo/addons/sourcemod/extensions/steamtools.ext.so: cannot open shared object file: No such file or directory
[08] SDK Hooks (1.7.0-dev+4888): Source SDK Hooks
[09] SMJansson (2.3.1/3): JSON parser/writer
[10] Client Preferences (1.7.0-dev+4888): Saves client preference settings
[11] SQLite (1.7.0-dev+4888): SQLite Driver
[12] Regex (1.7.0-dev+4888): Provides regex natives for plugins

[Addicted.]

Originally Posted by floube Check this.

How can I run that command if my server is being hosted by another company?

[floube]

Originally Posted by oaaron99 SM] Displaying 12 extensions: [01] Automatic Updater (1.7.0-dev+4888): Updates SourceMod gamedata files [02] Webternet (1.7.0-dev+4888): Extension for interacting with URLs [03] CS Tools (1.7.0-dev+4888): CS extended functionality [04] BinTools (1.7.0-dev+4888): Low-level C/C++ Calling API [05] SDK Tools (1.7.0-dev+4888): Source SDK Tools [06] Top Menus (1.7.0-dev+4888): Creates sorted nested menus [07] <FAILED> file "steamtools.ext.so": /home/client4316/service3869/csgo/csgo/addons/sourcemod/extensions/steamtools.ext.so: cannot open shared object file: No such file or directory [08] SDK Hooks (1.7.0-dev+4888): Source SDK Hooks [09] SMJansson (2.3.1/3): JSON parser/writer [10] Client Preferences (1.7.0-dev+4888): Saves client preference settings [11] SQLite (1.7.0-dev+4888): SQLite Driver [12] Regex (1.7.0-dev+4888): Provides regex natives for plugins

You're missing

[13] MySQL-DBI (1.6.2-dev+4568): MySQL driver implementation for DBI

Originally Posted by oaaron99 How can I run that command if my server is being hosted by another company?

Have you checked if

addons/sourcemod/extensions/dbi.mysql.ext.so

exists? If yes, try to load it with sm exts load dbi.mysql.ext.so

[Addicted.]

The file is there.

When I enter sm exts load dbi.mysql.ext.so it returns:

[SM] Loaded extension dbi.mysql.ext.so successfully.

But when I print the list again it says:

[SM] Displaying 13 extensions:
[01] Automatic Updater (1.7.0-dev+4888): Updates SourceMod gamedata files
[02] Webternet (1.7.0-dev+4888): Extension for interacting with URLs
[03] CS Tools (1.7.0-dev+4888): CS extended functionality
[04] BinTools (1.7.0-dev+4888): Low-level C/C++ Calling API
[05] SDK Tools (1.7.0-dev+4888): Source SDK Tools
[06] Top Menus (1.7.0-dev+4888): Creates sorted nested menus
[07] <FAILED> file "steamtools.ext.so": /home/client4316/service3869/csgo/csgo/addons/sourcemod/extensions/steamtools.ext.so: cannot open shared object file: No such file or directory
[08] SDK Hooks (1.7.0-dev+4888): Source SDK Hooks
[09] SMJansson (2.3.1/3): JSON parser/writer
[10] Client Preferences (1.7.0-dev+4888): Saves client preference settings
[11] SQLite (1.7.0-dev+4888): SQLite Driver
[12] Regex (1.7.0-dev+4888): Provides regex natives for plugins
[13] <FAILED> file "dbi.mysql.ext.so": service3869/csgo/csgo/addons/sourcemod/extensions/dbi.mysql.ext.so: undefined symbol: _ZTVN10__cxxabiv120__si_class_type_infoE

[Addicted.]

I got it working I just downloaded a new version of dbi.mysql.ext.so

Thx for your help!!