Hello
I have a problem with the ranking. When I change setting in plugin to connect to mysql database my server is crashing. Plugin works normally on sqlite settings. I have tried different methods but without success. That's why I'm asking for help.
Server is on a dedicated machine where mysql is also installed.
sm exts on the sqlite ranking settings. I will add that the sourcebans set to mysql works properly and connects locally as well:
Code:
] sm exts
"Automatic Updater" (1.10.0.6488) by AlliedModders LLC: Updates SourceMod gamedata files
"Webternet" (1.10.0.6488) by AlliedModders LLC: Extension for interacting with URLs
"CS Tools" (1.10.0.6488) by AlliedModders LLC: CS extended functionality
"BinTools" (1.10.0.6488) by AlliedModders LLC: Low-level C/C++ Calling API
"SDK Tools" (1.10.0.6488) by AlliedModders LLC: Source SDK Tools
"Top Menus" (1.10.0.6488) by AlliedModders: Creates sorted nested menus
"Client Preferences" (1.10.0.6488) by AlliedModders: Saves client preference settings
"SQLite" (1.10.0.6488) by AlliedModders LLC: SQLite Driver
"SDK Hooks" (1.10.0.6488) by AlliedModders LLC: Source SDK Hooks
"GeoIP" (1.10.0.6488) by AlliedModders LLC: Geographical IP information
To see more, type "sm exts 11"
] sm exts 11
"MySQL-DBI" (1.10.0.6488) by AlliedModders LLC: MySQL driver implementation for DBI
Parameter -debug with start server:
Code:
----------------------------------------------
CRASH: nie, 24 maj 2020, 15:38:17 CEST
Start Line: ./srcds_linux -nobreakpad -game csgo -console -usercon -secure -autoupdate -steam_dir /home/awp -steamcmd_script /home/awp/runscript_csgo_awp -maxplayers_override 26 -tickrate 128 +hostport 27015 +net_public_adr 54.36.175.46 -nohltv +sv_pure 0 +game_type 0 +game_mode 1 +mapgroup mg_custom +map awp_india -debug -authkey ************* +host_workshop_collection 429782593 +workshop_start_map 125610094 +sv_setsteamaccount ***********
[New LWP 15752]
[New LWP 15756]
[New LWP 15759]
[New LWP 15757]
[New LWP 15772]
[New LWP 15753]
[New LWP 15762]
[New LWP 15766]
[New LWP 15770]
[New LWP 15771]
[New LWP 15763]
[New LWP 15775]
[New LWP 15776]
[New LWP 15773]
[New LWP 15780]
[New LWP 15774]
[New LWP 15764]
Core was generated by `./srcds_linux -nobreakpad -game csgo -console -usercon -secure -autoupdate -ste'.
Program terminated with signal SIGABRT, Aborted.
#0 0xf773cba9 in ?? ()
[Current thread is 1 (LWP 15752)]
#0 0xf773cba9 in ?? ()
Backtrace stopped: Cannot access memory at address 0xffa6e9b8
No symbol table info available.
eax 0x0 0
ecx 0x3d88 15752
edx 0x6 6
ebx 0x3d88 15752
esp 0xffa6e9b8 0xffa6e9b8
ebp 0xffa6eb28 0xffa6eb28
esi 0x0 0
edi 0xffa6ea74 -5838220
eip 0xf773cba9 0xf773cba9
eflags 0x206 [ PF IF ]
cs 0x23 35
ss 0x2b 43
ds 0x2b 43
es 0x2b 43
fs 0x3 3
gs 0x63 99
No shared libraries loaded at this time.
End of Source crash report
----------------------------------------------
Settings databases.cfg:
Code:
"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"
}
"sourcebans"
{
"driver" "mysql"
"host" "localhost"
"database" "sourcebans++"
"user" "root"
"pass" "**************"
//"timeout" "0"
"port" "3306"
}
"rankme"
{
"driver" "mysql"
"host" "localhost"
"database" "rankme"
"user" "root"
"pass" "**************"
//"timeout" "0"
"port" "3306"
}
}
Sorry about my English but I was using a translator.