Notice to all users

We are migrating towards a new forum system located at, as such this forum will become read-only on January 29, 2020

Results 1 to 4 of 4

Thread: Database Error

  1. #1
    Join Date
    July 2018
    California, USA

    Database Error

    Server Version: 3.3.1 on Linux
    DB being used: MariaDB (used same database since server version 3.1.0)

    PHP Code:
    2018-09-23 05:26:33.970127|ERROR   |DatabaseQuery |   |db_open() select from servers where server_port 9987errorCan't connect to MySQL server on '' (107)
    2018-09-23 05:26:59.651464|ERROR   |DatabaseQuery |   |db_open() select distinct c.client_id, c.server_id from (clients c left outer jo error: Can'
    t connect to MySQL server on '' (107 
    PHP Code:
    2018-09-23 06:36:12.245457|ERROR   |DatabaseQuery |   |db_open() select from clients where client_unique_id 'ServerQuery' and serve errorCan't connect to MySQL server on '' (107)
    2018-09-23 06:50:07.845528|ERROR   |DatabaseQuery |   |db_open() select * from servers where server_port = 9987; error: Can'
    t connect to MySQL server on '' (107

    Above I simply copied some of the errors I was getting to showcase them to you, but they are repeated frequently, as you can see in the pictures below. Log file ends up being over 3000 lines of this, with the pictures only incorporating the top of the log file.
    (1/2) Click image for larger version. 

Name:	WinSCP_2018-09-23_11-20-20.png 
Views:	144 
Size:	241.0 KB 
ID:	17137
    (2/2) Click image for larger version. 

Name:	WinSCP_2018-09-23_11-21-53.png 
Views:	147 
Size:	249.3 KB 
ID:	17138

    This all ends up resulting in the TeamSpeak client as '<11:10:53> database error' when I attempt to connect. This is currently happening about every 2 weeks for the past 2-3 months with a simple server restart resolving the issue temporarily.

    A remedy to this issue would be much appreciated,

  2. #2
    Join Date
    December 2004
    You have to "remedy" this yourself, it is your server and your database after all.

  3. #3
    Join Date
    June 2011
    Maybe server crashed.
    Another reason why it is highly recommended for end users to use SQLite.

  4. #4
    Join Date
    July 2018
    California, USA
    Quote Originally Posted by numma_cway View Post
    Maybe server crashed.
    The server was rebooted once prior to the TeamSpeak server being properly stopped, could this cause the corruption I am possibly experiencing?

    Assuming so, would a backup of the database prior to the reboot suffice as a "remedy"?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Database Error
    By NYDAITA in forum Client Support
    Replies: 0
    Last Post: June 1st, 2017, 09:40 AM
  2. Database Error
    By Speshals in forum Server Support
    Replies: 2
    Last Post: July 24th, 2015, 09:11 AM
  3. database error
    By shayran in forum Windows
    Replies: 6
    Last Post: March 29th, 2012, 06:08 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts