splewis / csgo-multi-1v1

CS:GO Sourcemod plugin to create multi-1v1 arena servers
GNU General Public License v3.0
278 stars 68 forks source link

No data is written to DB #38

Closed kebre001 closed 10 years ago

kebre001 commented 10 years ago

I have successfully installed SM and MM with this plugin and everything runs fine! The only thing that does not work is the ranking which I have tried to fix for 3 days now.

To be honest I have no idea how to troubleshoot this but since I have tried the DB connection from other applications just to make sure all the permissions are correct and checked the configurations several times. I am sad that I have to end up contacting you for this.

If you just can type a really short guide how to make the ranking system work I would be happy! Thanks

splewis commented 10 years ago

Check the value of sm_multi1v1_use_database in cfg/sourcemod/multi1v1/multi1v1.cfg

and then see if there is a "multi1v1" configuration under addons/sourcemod/configs/databases.cfg.

Also, check the error logs in addons/sourcemod/logs and paste anything that might be relevant.

kebre001 commented 10 years ago

Okay, now I know where the logs are for the plugins. Found this row which explains alot:

L 08/24/2014 - 02:58:05: [multi1v1.smx] Could not connect: Driver "mysql" not found L 08/24/2014 - 04:29:18: Error log file session closed. L 08/24/2014 - 14:47:15: [SM] Unable to load extension "dbi.mysql.ext": libz.so.1: cannot open shared object file: No such file or directory L 08/24/2014 - 14:47:15: [multi1v1.smx] Could not connect: Driver "mysql" not found

After som testing and googling im now here: L 08/24/2014 - 14:57:13: [multi1v1.smx] Could not connect: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

But I dont know how to solve it. Thank you for super fast reply! =)

splewis commented 10 years ago

Are you sure the MySQL server is running?

Here's a useful post: http://stackoverflow.com/questions/16325607/cant-connect-to-local-mysql-server-through-socket-tmp-mysql-sock

kebre001 commented 10 years ago

Got it working! The things I did to make it work:

sudo apt-get install lib32z1 changed in database.cfg from localhost to 127.0.0.1 (this was to skip the pipe and use TCP)

Awesome response! Great work on the mod