problems with database - dedicated server install

[Banzak 6]

Hello,

today i finally managed to install the exile mod, but i get stuck after loading here the first time i try to login into the server:

and after that always here

in the server log i get the following error-message. I think this is a problem with the mysql-connection, but I am stuck.

I am running Arma 3 on Ubuntu 16.04 LTS.

Spoiler

Dez 29 02:47:01 wekan start.sh[21273]: Unaccessible
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01 "ExileServer - Player Freeman (UID 76561198242651274) connected!"
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01 "ExileServer - Database Error: Error Unknown Protocol"
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01 Error in expression <se_handleBig;
Dez 29 02:47:01 wekan start.sh[21273]: };
Dez 29 02:47:01 wekan start.sh[21273]: };
Dez 29 02:47:01 wekan start.sh[21273]: ((_result select 1) select 0) select 0>
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01   Error position: <select 0) select 0>
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01   Error Generic error in expression
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01 File exile_server\code\ExileServer_system_database_query_selectSingleField.sqf, line 27
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01 Error in expression <se_handleBig;
Dez 29 02:47:01 wekan start.sh[21273]: };
Dez 29 02:47:01 wekan start.sh[21273]: };
Dez 29 02:47:01 wekan start.sh[21273]: ((_result select 1) select 0) select 0>
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01   Error position: <select 0) select 0>
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01   Error Generic error in expression
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01 File exile_server\code\ExileServer_system_database_query_selectSingleField.sqf, line 27
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01 Server: Object 8:61 not found (message Type_93)
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01 Server: Object 8:62 not found (message Type_121)
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01 Server: Object 8:46 not found (message Type_93)
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01 Server: Object 8:33 not found (message Type_121)
Dez 29 02:47:01 wekan start.sh[21273]:  2:47:01 Server: Object 8:34 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:35 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:36 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:37 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:38 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:39 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:40 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:41 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:42 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:51 not found (message Type_455)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:43 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:44 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:45 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:53 not found (message Type_455)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:47 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:48 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:49 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:50 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:56 not found (message Type_93)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:52 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:57 not found (message Type_93)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:54 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:55 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:58 not found (message Type_455)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:59 not found (message Type_121)
Dez 29 02:47:02 wekan start.sh[21273]:  2:47:01 Server: Object 8:60 not found (message Type_93)
Dez 29 02:47:03 wekan start.sh[21273]:  2:47:03 "ExileServer - Starting session for 'Freeman' with ID 'yevdewrn'..."
Dez 29 02:47:03 wekan start.sh[21273]:  2:47:03 "ExileServer - Dispatching hasPlayerRequest for session 'yevdewrn'..."
Dez 29 02:47:03 wekan start.sh[21273]:  2:47:03 "ExileServer - Database Error: Error Unknown Protocol"
Dez 29 02:47:03 wekan start.sh[21273]:  2:47:03 Error in expression <se_handleBig;
Dez 29 02:47:03 wekan start.sh[21273]: };
Dez 29 02:47:03 wekan start.sh[21273]: };
Dez 29 02:47:03 wekan start.sh[21273]: ((_result select 1) select 0) select 0>
Dez 29 02:47:03 wekan start.sh[21273]:  2:47:03   Error position: <select 0) select 0>
Dez 29 02:47:03 wekan start.sh[21273]:  2:47:03   Error Generic error in expression
Dez 29 02:47:03 wekan start.sh[21273]:  2:47:03 File exile_server\code\ExileServer_system_database_query_selectSingleField.sqf, line 27
Dez 29 02:47:03 wekan start.sh[21273]:  2:47:03 Error in expression <se_handleBig;
Dez 29 02:47:03 wekan start.sh[21273]: };
Dez 29 02:47:03 wekan start.sh[21273]: };
Dez 29 02:47:03 wekan start.sh[21273]: ((_result select 1) select 0) select 0>
Dez 29 02:47:03 wekan start.sh[21273]:  2:47:03   Error position: <select 0) select 0>
Dez 29 02:47:03 wekan start.sh[21273]:  2:47:03   Error Generic error in expression
Dez 29 02:47:03 wekan start.sh[21273]:  2:47:03 File exile_server\code\ExileServer_system_database_query_selectSingleField.sqf, line 27

 

I have also now entries in  /Steam/arma3/@exileserver/extDB/logs/2017/12/29

and the content of the latest log is that:

Spoiler

 

extDB2: Version: 71
extDB2: https://github.com/Torndeco/extDB2
extDB2: Linux Version
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB2 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 20/02/15

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

[01:42:56 +01:00] [Thread 21275] extDB2: Database Type: MySQL
[01:42:56 +01:00] [Thread 21275] extDB2: Database Session Pool Started
[01:42:56 +01:00] [Thread 21275] extDB2: SQL_CUSTOM_V2: Loading Template Filename: /home/steam/Steam/arma3/@exileserver/extDB/sql_custom_v2/exile.ini
[01:42:56 +01:00] [Thread 21275] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available

 

 

Can anybody give me a hint how to fix that?

Thank you & Best regards.

Banzak

[SOLVED] I solved the problem with that:

Spoiler

 

To disable strict SQL mode, SSH in to your server as root and create this file:

/etc/mysql/conf.d/disable_strict_mode.cnf

Open the file and enter these two lines:

[mysqld]
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Restart MySQL with this command:

sudo service mysql restart

This change disables two SQL mode settings, STRICT_TRANS_TABLES and ONLY_FULL_GROUP_BY, that were added in MySQL 5.7 and cause problems for some older applications.

 

The problem was the MYSQL_STRICT_MODE.

Edited January 2, 2018 by Banzak

[Maxit0 0]

Hello

I have the same problem but i already disable the  MYSQL_STRICT_MODE and i having the same problem

[Banzak 6]

i am struggeling with mysql still...

In my mysql.log i see this:

but in the database itself there are no entries:

is the ExtDB2 V71 running with Ubuntu 16.04 or do I need the V70 or even V65,
anybody has any hint?

Thank you!

Regards,
Banzak

[Maxit0 0]

47 minutes ago, Banzak said:

i am struggeling with mysql still...

In my mysql.log i see this:

but in the database itself there are no entries:

is the ExtDB2 V71 running with Ubuntu 16.04 or do I need the V70 or even V65,
anybody has any hint?

Thank you!

Regards,
Banzak

What guide you follow for setup the server in linux?

[Banzak 6]

 

[Maxit0 0]

@Banzak i install the windows guide and all run ok!  maybe you can test it.

[Banzak 6]

10 minutes ago, Maxit0 said:

@Banzak i install the windows guide and all run ok!  maybe you can test it.

yes, I already installed a new virtual machine with Win7 and now everything is running smoothly...

 

[Maxit0 0]

@Banzak Glad you ear that bro, im running good too, @odizzzzle helps me alot with some fix on my server too i was missing some  Microsoft c++ redistributable on my server we need to install 2008,2013 and 2015 for the db connection.

[Banzak 6]

8 minutes ago, Maxit0 said:

@Banzak Glad you ear that bro, im running good too, @odizzzzle helps me alot with some fix on my server too i was missing some  Microsoft c++ redistributable on my server we need to install 2008,2013 and 2015 for the db connection.

yes, I also managed to get the x64 running with the extDB3. I have now ExileZ with DMS running and I can tell you this is f... crazy good!

Edited January 3, 2018 by Banzak

[Maxit0 0]

awesome @Banzak im going to ask you for help with that later if i cannot get that on my server