MySQL problem!

[Anaestheticz 2]

Hey guys,

 

Long story short - I own a ViLayer Exile server, what worked like a charm til the most recent update. Since that, whenever I start the server, I get the error message to update to extdb 69 - I did a full cleanup, fresh install for the server, installed extdb 69 from github, and now it says "[0,"Database Exception Error]"

 

I tried reinstalling the database as well, it fails to do so, and when I try to join with Heidi, it says, that it can't connect to the database address.

 

Any help / suggestions?

 

Thanks in advance!

[Lucius 2]

Could you please post the full error messages you're seeing?

[Anaestheticz 2]

This was the first error message:

 

Quote

19:11:10 Client: Nonnetwork object 35468d00.
19:11:10 "ExileServer - MySQL connection error!"
19:11:10 "ExileServer - Please have a look at @ExileServer/extDB/logs/ to find out what went wrong."
19:11:10 "ExileServer - MySQL Error: Update extDB2 to version 69 or later"
19:11:10 "ExileServer - Server will shutdown now :("

 

The second, after installing v69:

 

Quote

19:38:03 "ExileServer - Server is loading..."
19:38:03 Client: Nonnetwork object 35cb8d00.
19:38:03 "ExileServer - Installed extDB2 version: 69"
19:38:04 "ExileServer - MySQL connection error!"
19:38:04 "ExileServer - Please have a look at @ExileServer/extDB/logs/ to find out what went wrong."
19:38:04 "ExileServer - MySQL Error: Could not add database: [0,"Database Exception Error"]"
19:38:04 "ExileServer - Server will shutdown now :("

 

The ExtDB log:

Quote

extDB2: Found extdb-conf.ini
extDB2: Detected 8 Cores, Setting up 6 Worker Threads

[19:38:03:373856 +00:-1] [Thread XXXXX] extDB2: Database Type: MySQL
[19:38:04:384890 +00:-1] [Thread XXXXX] extDB2: Database Exception Error: Connection attempt failed: Can't connect to MySQL server on 'XXXXXXXXXX' (10061)
[19:38:04:385272 +00:-1] [Thread XXXXX] extDB2: Sending Shutdown to Armaserver

 

The HeidiSQL error (IP removed for safety, but it's the database IP):

 

Quote

Can't connect to MySQL server on "XXXXXX" (10061)

 

When trying to reinstall database with the Vilayer tool (sensitive info removed):

Quote

*~*~*~*~*~*~*~*~*~*~*~* DATABASE MANAGER *~*~*~*~*~*~*~*~*~*~*~*
 
ServiceId XXXXX - Stopping XXXXXXXXX...
ServiceId XXXXX - XXXXXXXX has been stopped.
 
###### MySQL Reinstallation ######
 
 
Download Has Finished...
The system cannot find the file specified.
ServiceId XXXXX- Starting XXXXXXXXXX...
ServiceId XXXXX- XXXXXXXXXX has been started.
 
###### MySQL Reinstallation Completed ######
 
 
###### Changing MySQL Credentials ######
    
ServiceId XXXXX - Stopping XXXXXXXXXX...
ServiceId XXXXX - XXXXXXXXX has been stopped.
ERROR: MySQL Not Installed ... Script Aborting
 
The script has executed successfully. You may close this window.

 

 

Edited December 12, 2015 by Anaestheticz

[Screamer 26]

did u replace extDB2.dll ??? for new version ???

[Anaestheticz 2]

Yes. After that, I got the second error message.

[Osoben 3]

I am having same problem and have not gotten a response from vilayer....

[Lucius 2]

There could be a few  reasons why you couldn't connect to the database. But since it isn't throwing responses telling you it doesn't have permissions, then I'm thinking the database server for ViLayer may be down?

Has anyone tried running the following from a command prompt?

telnet <IP or address of database server for ViLayer> 3306

What response do you get?

[coftsock 90]

never use these tcadmin panels

[Anaestheticz 2]

Meanwhile, I got an answer from ViLayer support, they know about the issue, and they're working on a fix asap.

[RAKETA 4]

On 13.12.2015 at 5:44 PM, Anaestheticz said:

Meanwhile, I got an answer from ViLayer support, they know about the issue, and they're working on a fix asap.

Anaestheticz, vilayer fix MySQL problem or not for now?