Raised This Month: $12 Target: $400
 3% 

People are unmuted when rejoining??


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
lilpetri
Member
Join Date: Nov 2016
Location: The Netherlands
Old 02-19-2017 , 09:11   People are unmuted when rejoining??
Reply With Quote #1

Hello,

I currently have Sourcebans++ and Sourcecomms installed. But for some reason, when people rejoin, their punishment isn't there anymore.
lilpetri is offline
Cooky
Veteran Member
Join Date: Jun 2010
Location: 127.0.0.1
Old 02-19-2017 , 09:37   Re: People are unmuted when rejoining??
Reply With Quote #2

I reported this topic as being in the wrong section.

It might be some kind of database issue. What is your log saying?
Cooky is offline
lilpetri
Member
Join Date: Nov 2016
Location: The Netherlands
Old 02-19-2017 , 11:44   Re: People are unmuted when rejoining??
Reply With Quote #3

It could be anything causing this problem, that's why I put it here.

It's most likely a database problem. My sourcebans log is telling me this:

Quote:
L 02/16/2017 - 08:21:14: [sourcebans.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). See FAQ: http://www.sourcebans.net/node/20
Quote:
L 12/18/2016 - 19:26:50: [CallAdmin: Mysql module] ConErr: Could not find driver "mysql"
L 12/18/2016 - 21:47:50: [CallAdmin: Mysql module] ConErr: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Quote:
L 02/19/2017 - 179:59: [sourcecomms.smx] Connecting to database failed: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I have a Linux based server with phpmyadmin installed.

To be honest, I don't really know how to correctly setup a database (google didn't help). I created a database in my PhpMyAdmin and put the correct credentials in the databases.cfg file.

Last edited by lilpetri; 02-19-2017 at 11:47.
lilpetri is offline
Cooky
Veteran Member
Join Date: Jun 2010
Location: 127.0.0.1
Old 02-19-2017 , 13:21   Re: People are unmuted when rejoining??
Reply With Quote #4

Is MySQL installed and started properly? What is your databases.cfg?
Cooky is offline
WildCard65
Veteran Member
Join Date: Aug 2013
Location: Canada
Old 02-20-2017 , 07:26   Re: People are unmuted when rejoining??
Reply With Quote #5

The logs are saying that the driver is trying to find a socket file on the machine at path: /tmp/mysql.sock, if the mysql server is on same machine as the gameserver, put host to path of socket file the mysql server create (may need to look at mysql server configs for path) or the local address of the machine (if user can connect via machine's address and not localhost/127.0.0.1), if mysql server is on a different machine, change db settings host to ip of remote machine.
__________________
WildCard65 is offline
lilpetri
Member
Join Date: Nov 2016
Location: The Netherlands
Old 02-21-2017 , 12:41   Re: People are unmuted when rejoining??
Reply With Quote #6

I checked and MySQL seems to be fine. I can't find the file /tmp/mysql.sock tho.

Quote:
"Databases"
{
"driver_default" "mysql"

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

"default"
{
"driver" "default"
"host" "vpsxxxx.ovh.net"
"database" "sourcemod"
"user" "root"
"pass" "xxxxx"
//"timeout" "0"
//"port" "3306"
}

"sourcecomms"
{
"driver" "mysql"
"host" "vpsxxxx.ovh.net"
"database" "sourcecomms"
"user" "root"
"pass" "xxxxx"
"port" "3306"
}

"CallAdmin"
{
"driver" "mysql"
"host" "vpsxxxx.ovh.net"
"database" "CallAdmin"
"user" "root"
"pass" "xxxxx"
"port" "3306"
}

"sourcemod"
{
"driver" "mysql"
"host" "vpsxxxx.ovh.net"
"database" "sourcemod"
"user" "root"
"pass" "xxxxx"
"port" "3306"
}

"sourcebans"
{
"driver" "mysql"
"host" "vpsxxxx.ovh.net"
"database" "sb"
"user" "root"
"pass" "xxxxx"
"port" "3306"
}

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

"clientprefs"
{
"driver" "sqlite"
"host" "vpsxxxx.ovh.net"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
}
I entered the output for the command hostname as the "host".

Last edited by lilpetri; 02-21-2017 at 12:44.
lilpetri is offline
WildCard65
Veteran Member
Join Date: Aug 2013
Location: Canada
Old 02-21-2017 , 14:09   Re: People are unmuted when rejoining??
Reply With Quote #7

Quote:
Originally Posted by lilpetri View Post
I can't find the file /tmp/mysql.sock tho.
Quote:
Originally Posted by WildCard65 View Post
if the mysql server is on same machine as the gameserver, put host to path of socket file the mysql server create (may need to look at mysql server configs for path)
__________________
WildCard65 is offline
lilpetri
Member
Join Date: Nov 2016
Location: The Netherlands
Old 02-21-2017 , 16:12   Re: People are unmuted when rejoining??
Reply With Quote #8

I am sorry for my stupidity. I found out my file is located at: /var/run/mysqld/mysqld.sock.

Do I change "host" in databases.cfg. Could you give me an example?

Thanks for your time!
lilpetri is offline
WildCard65
Veteran Member
Join Date: Aug 2013
Location: Canada
Old 02-21-2017 , 17:38   Re: People are unmuted when rejoining??
Reply With Quote #9

Quote:
Originally Posted by lilpetri View Post
I am sorry for my stupidity. I found out my file is located at: /var/run/mysqld/mysqld.sock.

Do I change "host" in databases.cfg. Could you give me an example?

Thanks for your time!
ya
__________________
WildCard65 is offline
lilpetri
Member
Join Date: Nov 2016
Location: The Netherlands
Old 02-22-2017 , 12:53   Re: People are unmuted when rejoining??
Reply With Quote #10

I changed it to:

Quote:
"host" "/var/run/mysqld/mysqld.sock"
But I am now getting another error *sight*

Quote:
[sourcecomms.smx] Connecting to database failed: [2013]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111
The port is correct.

Last edited by lilpetri; 02-22-2017 at 12:55.
lilpetri is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 11:13.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode