[CS:GO] Simple CSGO Ranks - Page 8

Puppetmaster · 02-27-2016 , 17:51 Re: [CS:GO] Simple CSGO Ranks

Quote:

Originally Posted by Cosharek

Hi I need help with this plugin especially with the MySQL part, okay so I have installed the plugin correct and everything, I am using a online hosting company called gametris.com and when i start my server ang go to the rcon console and type in sm plugins list i get this

<Error> "SimpleCSGORanks" (0.2.0) by Puppetmaster, Mehffort, Zipzip, Turtl, Fnz, Furreal

i then type in sm plugins load simplecsgoranks and i get this

Database: "default" Got:"default"
Could not connect: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Database setup has been called.
If you get an error here you probably need to fix your database.
Try changing your databases.cfg file
Adding database tables
L 02/27/2016 - 14:48:51: [SM] Native "SQL_FastQuery" reported: Invalid database Handle 0 (error: 4)
L 02/27/2016 - 14:48:51: [SM] Displaying call stack trace for plugin "simplecsgoranks.smx":
L 02/27/2016 - 14:48:51: [SM] [0] Line 329, simplecsgoranks.sp::newDB()
L 02/27/2016 - 14:48:51: [SM] [1] Line 527, simplecsgoranks.sp::OnPluginStart()
[SM] Loaded plugin simplecsgoranks.smx successfully.

if you are wondering how my database.cfg is set up then here you go (i changed some numbers around so people don't steal from me >

)

"Databases"
{
"driver_default" "mysql"

// When specifying "host", you may use an IP address, a hostname, or a socket file path

"default"
{
"driver" "default"
"host" "the ip of my server"
"database" "01234"
"user" "01234"
"pass" "password"
//"timeout" "0"
"port" "01234"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}

"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
}

and if you are wondering why my user, port, database are the same, its because they are all the same when i go to my control panel, my port is the same as my database name and as my username, the password i put in is 400% correct so i don't know why the plugin doesn't want to connect to my db pls help

Are you using windows or linux? What does the MySQL log say?

Cosharek · 02-27-2016 , 18:55 Re: [CS:GO] Simple CSGO Ranks

Quote:

Originally Posted by Puppetmaster

Are you using windows or linux? What does the MySQL log say?

idk I cant really check because all I have access to is the admin panel on the hosting website, i can only check my MySQL on a web based adminer panel which doesn't show much useful stuff apart from the tables i have set up and also i can enter MySQL commands and that is about it, i hope that you do understand that i am not hosting the MySQL database on my pc I am using a hosting company. another thing i was thinking about is should i just get a separate MySQL database or what?

Cosharek · 02-27-2016 , 18:56 Re: [CS:GO] Simple CSGO Ranks

if you don't understand what i mean i can add scrnshots to show you what i can do in the online admin panel

Puppetmaster · 02-28-2016 , 16:26 Re: [CS:GO] Simple CSGO Ranks

Quote:

Originally Posted by Cosharek

idk I cant really check because all I have access to is the admin panel on the hosting website, i can only check my MySQL on a web based adminer panel which doesn't show much useful stuff apart from the tables i have set up and also i can enter MySQL commands and that is about it, i hope that you do understand that i am not hosting the MySQL database on my pc I am using a hosting company. another thing i was thinking about is should i just get a separate MySQL database or what?

Getting different hosting would definitely be my suggestion. There is not much I can do if you do not have direct access to the log. The log usually contains all of the required information for fixing issues like this

bunso · 03-09-2016 , 20:46 Re: [CS:GO] Simple CSGO Ranks

I been trying to make this plugin to work on my linux dedicated server.
Until now I was not able to make this work.
Please help!! Below are the error.

L 03/09/2016 - 17

5:21: SourceMod error session started
L 03/09/2016 - 17

5:21: Info (map "de_dust2") (file "errors_20160309.log")
L 03/09/2016 - 17

5:21: [SM] Unable to load extension "dbi.steam.ext": /home/steam/steamcd/csgo/csgo/addons/sourcemod/extensions/dbi.steam.ext.so: cannot open shared object file: No such file or directory
L 03/09/2016 - 17

5:21: [SM] Native "SQL_FastQuery" reported: Invalid database Handle 0 (error: 4)
L 03/09/2016 - 17

5:21: [SM] Displaying call stack trace for plugin "simplecsgoranks.smx":
L 03/09/2016 - 17

5:21: [SM] [0] Line 329, simplecsgoranks.sp::newDB()
L 03/09/2016 - 17

5:21: [SM] [1] Line 527, simplecsgoranks.sp::OnPluginStart()
L 03/09/2016 - 17

5:22: [SM] Native "SQL_FastQuery" reported: Invalid database Handle 0 (error: 4)
L 03/09/2016 - 17

5:22: [SM] Displaying call stack trace for plugin "simplecsgoranks.smx":
L 03/09/2016 - 17

5:22: [SM] [0] Line 329, simplecsgoranks.sp::newDB()
L 03/09/2016 - 17

5:22: [SM] [1] Line 527, simplecsgoranks.sp::OnPluginStart()

Thank you in advance

Puppetmaster · 03-09-2016 , 20:51 Re: [CS:GO] Simple CSGO Ranks

Quote:

Originally Posted by bunso