bbg

Server locks and kicks all players repeatedly

21 posts in this topic

I have been trying to set up an Exile Mod server over the weekend, and have run into mixed results. The server was running correctly initially, then after a restart, it is displaying some strange behavior.

The first time I connect, the server will initialize the database and then kick me and lock the server to finish the initialization:

16:21:53 "ExileServer - Server is loading..."
16:21:53 "ExileServer - ServerPassword MATCH! server locked for init"
16:21:53 "ExileServer - Installed extDB2 version: 65"
16:21:53 "ExileServer - Connected to database!"
16:21:53 "ExileServer - Database protocol initialized!"
...
16:22:02 Successfull attempt to execute serverCommand '#lock' by server.
16:22:02 Successfull attempt to execute serverCommand '#lock' by server.
16:22:02 Successfull attempt to execute serverCommand '#kick 0' by server.

After initialization, though, I attempt to reconnect, get kicked again, and the following is output to the log:

16:22:37 "ExileServer - Server is loading..."
16:22:37 "ExileServer - ServerPassword MATCH! server locked for init"
16:22:37 "ExileServer - Installed extDB2 version: 65"
16:22:37 "ExileServer - Connected to database!"
16:22:37 "ExileServer - MySQL connection error!"
16:22:37 "ExileServer - MySQL Error: Failed to initialize database protocol: [0,"Error Invalid Format"]"
16:22:37 "ExileServer - Server will shutdown now :("
...
16:22:37 Successfull attempt to execute serverCommand '#lock' by server.
16:22:37 Successfull attempt to execute serverCommand '#lock' by server.
16:22:37 Successfull attempt to execute serverCommand '#kick 0' by server.

The extDB2 logs of this event are below:

extDB2: Version: 65
extDB2: https://github.com/Torndeco/extDB2
extDB2: Linux Version

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


[15:08:33 --4:00] [Thread 23221] extDB2: Database Type: MySQL
[15:08:33 --4:00] [Thread 23221] extDB2: Database Session Pool Started
[15:08:33 --4:00] [Thread 23221] extDB2: SQL_CUSTOM_V2: Loading Template Filename: extDB/sql_custom_v2/exile.ini
[15:08:33 --4:00] [Thread 23221] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available
[15:09:56 --4:00] [Thread 23221] extDB2: Error Invalid Format: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:643737:exile
[15:09:56 --4:00] [Thread 23221] extDB2: Error Invalid Format: 9:SHUTDOWN
[16:11:33 --4:00] [Thread 23221] extDB2: Stopping ...

I am running a Linux dedicated server, if this helps. I am also sorry if this has been solved before, but after the forums were migrated, all of the old posts are inaccessible.

Share this post


Link to post
Share on other sites

We have this same issue, and we havent made any changes for a day or so now and had many restarts inbetween, dont understand why the issue, we have not applied the new update and the server was running fine, until the scheduled reboot this morning

Share this post


Link to post
Share on other sites
Advertisement

Did you update extDB\sql_custom_v2\exile.ini and are you sure all database settings are okay?

Share this post


Link to post
Share on other sites

We have made no changes in the last 48 hours, we have not updated to the 0.9.20, server was working fine last night, and i was notified this morning the server is looping at reboot, our hosts state they have not made any changes either, but someone somewherre must have,its  been running sweet

 

 

Edited by Shepster

Share this post


Link to post
Share on other sites

... state they have not made any changes either, but someone somewherre must have..

Think so :)

Share this post


Link to post
Share on other sites

Could it be a database value ?

"ExileServer - Server is loading..."
13:35:27 "ExileServer - ServerPassword MATCH! server locked for init"
13:35:27 Client: Nonnetwork object 3b58a500.
13:35:27 "ExileServer - Installed extDB2 version: 65"
13:35:27 "ExileServer - Connected to database!"
13:35:27 "ExileServer - MySQL connection error!"
13:35:27 "ExileServer - MySQL Error: Failed to initialize database protocol: [0,"Error Invalid Format"]"
13:35:27 "ExileServer - Server will shutdown now :("

the reply i received from our host support

I dont know the answer, weve not changed anything, i see on the Excile forums a few others with the problem but no fix is mentioned. You could try recompiling the PBO see if that helps.

The bit that i see is :

Output to Server: [0,"Error Invalid Format"]

Which is telling me the SQL is poorly formatted and rejected.


What is trying to do is:

Input from Server: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:278184:exile

But that command is not in the exile.ini, so i dont know i would ask the devs.

Share this post


Link to post
Share on other sites

Same Problem here ... No Solution found ... :/ Changed nothing , i really mean NOTHING ... And after a restart, Server gave me the same Shitty Message :D 

Share this post


Link to post
Share on other sites

Did you update extDB\sql_custom_v2\exile.ini and are you sure all database settings are okay?

Yes, I have tried with both 0.9.19 and 0.9.20 and updated the exile.ini file. 

And as you can see by the first connection, extDB is able to connect to the database fine. It is only after it kicks the user, locks the server, and tries the exact same thing that it fails. 

I also enabled full extDB2 logging, and this is the entire output to the logs:

extDB2: Version: 65
extDB2: https://github.com/Torndeco/extDB2
extDB2: Linux Version
extDB2: Found extdb-conf.ini
extDB2: Detected 4 Cores, Setting up 4 Worker Threads

[23:25:25 --4:00] [Thread 23835] extDB2: Input from Server: 9:VERSION
[23:25:25 --4:00] [Thread 23835] extDB2: Output to Server: 65
[23:25:25 --4:00] [Thread 23835] extDB2: Input from Server: 9:ADD_DATABASE:exile
[23:25:25 --4:00] [Thread 23835] extDB2: Database Type: MySQL
[23:25:25 --4:00] [Thread 23835] extDB2: Database Session Pool Started
[23:25:25 --4:00] [Thread 23835] extDB2: Output to Server: [1]
[23:25:25 --4:00] [Thread 23835] extDB2: Input from Server: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:944137:exile
[23:25:25 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Loading Template Filename: /home/steam/steamcmd/arma3/@ExileServer/extDB/sql_custom_v2/exile.ini
[23:25:25 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available
[23:25:25 --4:00] [Thread 23835] extDB2: Output to Server: [1]
[23:25:25 --4:00] [Thread 23835] extDB2: Input from Server: 9:TIME
[23:25:25 --4:00] [Thread 23835] extDB2: Output to Server: [1,[2015, 9, 14, 03, 25]]
[23:25:25 --4:00] [Thread 23835] extDB2: Input from Server: 9:LOCK
[23:25:25 --4:00] [Thread 23835] extDB2: Output to Server: [1]
[23:25:34 --4:00] [Thread 23835] extDB2: Input from Server: 0:944137:loadTerriotryIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadTerriotryIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Output to Server: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Input from Server: 0:944137:loadConstructionIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadConstructionIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Output to Server: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Input from Server: 0:944137:loadVehicleIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadVehicleIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Output to Server: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Input from Server: 0:944137:loadContainerIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadContainerIdPage:0:100
[23:25:34 --4:00] [Thread 23835] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[23:25:34 --4:00] [Thread 23835] extDB2: Output to Server: [1,[]]
[23:25:46 --4:00] [Thread 23835] extDB2: Input from Server: 9:TIME
[23:25:46 --4:00] [Thread 23835] extDB2: Output to Server: [1,[2015, 9, 14, 03, 25]]
[23:27:24 --4:00] [Thread 23835] extDB2: Input from Server: 9:VERSION
[23:27:24 --4:00] [Thread 23835] extDB2: Output to Server: 65
[23:27:24 --4:00] [Thread 23835] extDB2: Input from Server: 9:ADD_DATABASE:exile
[23:27:24 --4:00] [Thread 23835] extDB2: Output to Server: 
[23:27:24 --4:00] [Thread 23835] extDB2: Input from Server: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:163506:exile
[23:27:24 --4:00] [Thread 23835] extDB2: Error Invalid Format: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:163506:exile
[23:27:24 --4:00] [Thread 23835] extDB2: Output to Server: [0,"Error Invalid Format"]
[23:27:24 --4:00] [Thread 23835] extDB2: Input from Server: 9:SHUTDOWN
[23:27:24 --4:00] [Thread 23835] extDB2: Error Invalid Format: 9:SHUTDOWN
[23:27:24 --4:00] [Thread 23835] extDB2: Output to Server: [0,"Error Invalid Format"]
[23:27:24 --4:00] [Thread 23835] extDB2: Input from Server: 9:SHUTDOWN
[23:27:24 --4:00] [Thread 23835] extDB2: Error Invalid Format: 9:SHUTDOWN
[23:27:24 --4:00] [Thread 23835] extDB2: Output to Server: [0,"Error Invalid Format"]

Share this post


Link to post
Share on other sites

Any update on this? I'm getting this same issue when I add infistar to my startup.. if I load without it, server runs smooth and perfect. I add -servermod=@infistar_servermod\; into it, it loops and loops and loops. I've reached out to infistar, no reply yet. Shane did attempt to assist me, but his knowledge in linux is very little. 

WINE is not an option, there is no update to the vcrun2010 yet. Reloading to Windows Server is not an option, I chose linux because of it's stability and performance (and open source). 

I'm really hoping those of us on Linux Root servers will come together and figure this out (with some help from the devs of Exile, extDB2 and infistar)

Share this post


Link to post
Share on other sites

I have this problem now; Database shutsdown and restarts infinitely when Infistar is added to the modline. is there a fix?

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.