PiggyArchive/PiggyAuth

Bug MySQL Provider

Closed this issue · 4 comments

Andrew1481432 commented

I use the mysql provider often appears bug ErrorException: "mysqli::ping(): MySQL server has gone away" (EXCEPTION) in "/PiggyAuth-master/src/PiggyAuth/Tasks/PingTask" at line 34

DO NOT REMOVE THIS

Please make sure your issue complies with these guidelines:

    • Be using PMMP
    • Make sure the issue hasn't already been reported
    • Make sure you are on the latest version of PMMP & PiggyAuth
    • Have a detailed title like "Players are being kicked randomly"
    • Provide any crash dumps or errors

General

Server Software:

Version of PiggyAuth:

Data Provider:

  • MySQL
  • SQLite
  • YAML
  • JSON
DaPigGuy commented

That means that connection to the MySQL db was lost.

  • 👍1
Aericio commented

are you connecting to your mysql server by localhost or tcp/udp?

Andrew1481432 commented

I'm using tcp connection

Andrew1481432 commented

localhost also error occurs [12:49:57] [Server thread/CRITICAL]: Could not execute task PiggyAuth\Tasks\PingTask: mysqli::ping(): MySQL server has gone away
[12:49:57] [Server thread/CRITICAL]: ErrorException: "mysqli::ping(): MySQL server has gone away" (EXCEPTION) in "/PiggyAuth-master/src/PiggyAuth/Tasks/PingTask" at line 34
[12:50:12] [Server thread/ERROR]: [PiggyAuth] Connection to MySQL Database lost.
#MySQL login
mysql:
host: 127.0.0.1
user: servers
name: servers
password: password
port: 3306