Quote:
Originally Posted by LionKing
L 01/15/2019 - 18:01:16: [extendedspeedmeter.smx] Extended Speed meter: Connection to SQL database has failed: [2003]: Can't connect to MySQL server on 'localhost' (10061)
L 01/15/2019 - 18:01:16: [csgo_items.smx] UTF-8 language file successfully processed, retrieving item schema.
L 01/15/2019 - 18:01:16: [csgo_items.smx] Item Schema successfully retrieved.
L 01/15/2019 - 18:01:17: [extendedspeedmeter.smx] Extended Speed meter: Connection to SQL database has failed: [2003]: Can't connect to MySQL server on 'localhost' (10061)
L 01/15/2019 - 18:01:18: [extendedspeedmeter.smx] Extended Speed meter: Connection to SQL database has failed: [2003]: Can't connect to MySQL server on 'localhost' (10061)
L 01/15/2019 - 18:01:19: server_cvar: "sm_nextmap" "de_mirage_winter"
L 01/15/2019 - 18:01:19: [randomcycle.smx] RandomCycle has chosen de_mirage_winter for the nextmap.
L 01/15/2019 - 18:01:19: [extendedspeedmeter.smx] Extended Speed meter: Plugin stopped, reconnect counter reached max
// This sets which database config should be used to store the topspeed table in (check addons/sourcemod/configs/databases.cfg)
// -
// Default: "default"
sm_extendedspeedmeter_databaseconfigname "speedmeter"
I've setup a database for it on the database.cfg file. Changed the databaseconfigname in the cfg file, but even after it still remains on 'localhost' how do I fix this?
|
First off about your question without a database, it kind of defeats the purpose of this extension. But I know that the original one is not fixed for CSGO so I can see why you want this. I have to do a lot of changes to make this possible. I'll see if I can get it done in the weekend.
About your question that it continues to use localhost. Are you running MySQL or SQLite on the external server?
And would you mind sharing your config file (without passwords/ip addresses etc)?
It should look something like this:
"Databases"
{
"driver_default" "mysql"
// When specifying "host", you may use an IP address, a hostname, or a socket file path
"default"
{
"driver" "default"
"host" "ip.address.of.server"
"database" "sourcemod"
"user" "YYYYY"
"pass" "ZZZZZ"
//"timeout" "0"
"port" "3306"
}
"speedmeter"
{
"driver" "default"
"host" "ip.address.of.server"
"database" "XXXXX"
"user" "YYYYY"
"pass" "ZZZZZ"
//"timeout" "0"
"port" "3306"
}
}
Are you also sure that the sourcemod server can connect to the MySQL external server? You might have to enable some firewall rules and possibly allow the ip address of your sourcemod server. If you are able to connect with command line to your server (through telnet/SSH), you can try "mysql -u {user} -p {pass} -h {host} -P {port} -D {database}" to verify that the connection works.