Login failure after some days

[maiams]

Hello,

I don't know if it's a bug or a error on configuration of any service (teamspeak or mysql), but after some time, like 2 or 3 days, the server stop authenticating people, but still working with who are logged in.

Looking into the logfile, i found nothing about any error, any issue.

I'm just wondering that the problem can be a mysql sock problem or anything related.

After a reboot, everything runs fine.

Logfile:

[root@restinpeace logs]# cat ts3server_2010-12-23__14_59_55.336684.log
2010-12-23 14:59:55.336870|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta30 [Build: 12998], Linux
2010-12-23 14:59:55.340621|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
2010-12-23 14:59:55.340667|INFO    |DatabaseQuery |   | dbPlugin version: 1
2010-12-23 14:59:55.345785|INFO    |SQL           |   | pruning old database log entries where timestamp is older than 90 days
2010-12-23 14:59:55.346702|INFO    |SQL           |   | pruning old guest clients where last connected time is older than 30 days, clients to remove: 1
2010-12-23 14:59:56.066227|INFO    |Accounting    |   | Licensing Information
2010-12-23 14:59:56.066315|INFO    |Accounting    |   | type              : Non-profit
2010-12-23 14:59:56.066371|INFO    |Accounting    |   | starting date     : Wed Jun  2 00:00:00 2010
2010-12-23 14:59:56.066398|INFO    |Accounting    |   | ending date       : Thu Jun  2 00:00:00 2011
2010-12-23 14:59:56.066422|INFO    |Accounting    |   | max virtualservers: 10
2010-12-23 14:59:56.066443|INFO    |Accounting    |   | max slots         : 512
2010-12-23 14:59:56.082775|INFO    |FileManager   |   | listening on 0.0.0.0:30033
2010-12-23 14:59:56.133897|INFO    |VirtualServer |  1| listening on 0.0.0.0:9987
2010-12-23 14:59:56.205550|INFO    |VirtualServer |  2| listening on 0.0.0.0:9016
2010-12-23 14:59:56.252515|INFO    |VirtualServer |  3| listening on 0.0.0.0:9026
2010-12-23 14:59:56.252939|INFO    |CIDRManager   |   | updated query_ip_whitelist ips: 127.0.0.1,
2010-12-23 14:59:56.253394|INFO    |Query         |   | listening on 0.0.0.0:10011

Config file:

machine_id=
default_voice_port=9987
voice_ip=0.0.0.0
licensepath=
filetransfer_port=30033
filetransfer_ip=0.0.0.0
query_port=10011
query_ip=0.0.0.0
query_ip_whitelist=query_ip_whitelist.txt
query_ip_blacklist=query_ip_blacklist.txt
dbplugin=ts3db_mysql
dbpluginparameter=
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
dblogkeepdays=90
logpath=logs
logquerycommands=1
dbclientkeepdays=30

Mysql plugin:

[config]
host=localhost
port=3306
username=xxxxxxxxxx
password=yyyyyyyyy
database=teamspeak3
socket=/var/lib/mysql/mysql.sock

Any help or idea are welcome.

Thanks all!

Ricardo.

[florian_fr40]

Hello

What error message the users got when you have this problem ?
Do you try to start your server without the socket parameter (in your mysql ini file) ?

[maiams]

Hello,

We (including me) got a "Cannot connect to the server".

I've sniffed the network looking for any firewall rules or anything related, but found nothing.
The packets sent by my PC are received by the server, but no reply is sent by the server, as if they're ignoring me.

[florian_fr40]

And about this :

Do you try to start your server without the socket parameter (in your mysql ini file) ?

[maiams]

And about this :

Yes, i did.
My config file is a result of many attempts to fix the problem.

[florian_fr40]

Have you the server log at the moment of this problem ?
To connect, you use the IP address or a domain name ?