Own_x

MySql error

8 posts in this topic

Hello guys,

Since ArmA 3's update today, no new players can come on my server.

Can you help me please?

RPT :

Spoiler

17:57:53 "ExileServer - Starting session for 'Own' with ID 'YqDCFtFa'..."
17:57:53 "ExileServer - Starting session for 'Jim Raynor' with ID 'rKpfHtSB'..."
17:57:54 Inventory item with given name: [Binocular] not found
17:57:54 Server: Object info 2:654 not found during Changing Owner
17:57:54 Server: Object info 2:653 not found during Changing Owner
17:57:58 Error in expression <llExtension _query);
(_result select 1) select 0>
17:57:58   Error position: <select 0>
17:57:58   Error Generic error in expression
17:57:58 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16
17:57:58 Error in expression <llExtension _query);
(_result select 1) select 0>
17:57:58   Error position: <select 0>
17:57:58   Error Generic error in expression
17:57:58 File exile_server\code\ExileServer_system_database_query_insertSingle.sqf, line 16
17:58:38 Client: Remote object 4:0 not found
17:58:38 Warning: Cleanup player - person 2:648 not found

Logs extDB 2

Spoiler

extDB2: Version: 69
extDB2: https://github.com/Torndeco/extDB2
extDB2: Windows Debug 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 8 Cores, Setting up 6 Worker Threads


[17:56:41:814399 +02:00] [Thread 252] extDB2: Input from Server: 9:VERSION
[17:56:41:814427 +02:00] [Thread 252] extDB2: Output to Server: 69
[17:56:41:814531 +02:00] [Thread 252] extDB2: Input from Server: 9:ADD_DATABASE:exile
[17:56:41:814550 +02:00] [Thread 252] extDB2: Database Type: MySQL
[17:56:41:816202 +02:00] [Thread 252] extDB2: Database Session Pool Started
[17:56:41:816216 +02:00] [Thread 252] extDB2: Output to Server: [1]
[17:56:41:816288 +02:00] [Thread 252] extDB2: Input from Server: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:505439:exile
[17:56:41:817527 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Program Files (x86)\Steam\steamapps\common\Arma 3\@ExileServer\extDB\sql_custom_v2\exile.ini
[17:56:41:817677 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available
[17:56:41:820048 +02:00] [Thread 252] extDB2: Output to Server: [1]
[17:56:41:820078 +02:00] [Thread 252] extDB2: Input from Server: 9:LOCAL_TIME
[17:56:41:820093 +02:00] [Thread 252] extDB2: Output to Server: [1,[2015,12,16,16,56]]
[17:56:41:820147 +02:00] [Thread 252] extDB2: Input from Server: 9:LOCK
[17:56:41:820156 +02:00] [Thread 252] extDB2: Output to Server: [1]
[17:56:42:632583 +02:00] [Thread 252] extDB2: Input from Server: 1:505439:deleteUnpaidTerritories:7
[17:56:42:632647 +02:00] [Thread 252] extDB2: Output to Server:
[17:56:42:632732 +02:00] [Thread 252] extDB2: Input from Server: 1:505439:deleteOldContainers:7
[17:56:42:632759 +02:00] [Thread 252] extDB2: Output to Server:
[17:56:42:632830 +02:00] [Thread 252] extDB2: Input from Server: 1:505439:deleteOldConstructions:2
[17:56:42:632854 +02:00] [Thread 252] extDB2: Output to Server:
[17:56:42:632875 +02:00] [Thread 3012] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: deleteUnpaidTerritories:7
[17:56:42:632917 +02:00] [Thread 1728] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: deleteOldContainers:7
[17:56:42:632923 +02:00] [Thread 252] extDB2: Input from Server: 1:505439:deleteOldVehicles:3
[17:56:42:633014 +02:00] [Thread 252] extDB2: Output to Server:
[17:56:42:632938 +02:00] [Thread 3204] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: deleteOldConstructions:2
[17:56:42:633094 +02:00] [Thread 3796] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: deleteOldVehicles:3
[17:56:42:633435 +02:00] [Thread 252] extDB2: Input from Server: 0:505439:loadTerriotryIdPage:0:100
[17:56:42:633495 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadTerriotryIdPage:0:100
[17:56:42:647987 +02:00] [Thread 3796] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[17:56:42:657518 +02:00] [Thread 3012] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[17:56:42:657654 +02:00] [Thread 3204] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[17:56:42:657822 +02:00] [Thread 1728] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[17:56:42:658268 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[17:56:42:658311 +02:00] [Thread 252] extDB2: Output to Server: [1,[]]
[17:56:42:682947 +02:00] [Thread 252] extDB2: Input from Server: 0:505439:loadConstructionIdPage:0:100
[17:56:42:683004 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadConstructionIdPage:0:100
[17:56:42:684362 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[17:56:42:684405 +02:00] [Thread 252] extDB2: Output to Server: [1,[]]
[17:56:42:684919 +02:00] [Thread 252] extDB2: Input from Server: 0:505439:loadVehicleIdPage:0:100
[17:56:42:684966 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadVehicleIdPage:0:100
[17:56:42:685833 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[[2]]]
[17:56:42:685876 +02:00] [Thread 252] extDB2: Output to Server: [1,[[2]]]
[17:56:42:686164 +02:00] [Thread 252] extDB2: Input from Server: 0:505439:loadVehicle:2
[17:56:42:686202 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadVehicle:2
[17:56:42:688440 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[[2,"Exile_Car_Offroad_Rusty3","2015-12-16T00:16:47Z","76561198042406825",-1,0.965414,0,[["HitLFWheel",0],["HitLF2Wheel",0],["HitRFWheel",0],["HitRF2Wheel",0],["HitFuel",0],["HitEngine",0],["HitBody",0],["HitGlass1",0],["HitGlass2",0],["HitRGlass",0],["HitLGlass",0],["HitGlass3",0],["HitGlass4",0],["HitGlass5",0],["HitGlass6",0],["HitLBWheel",0],["HitLMWheel",0],["HitRBWheel",0],["HitRMWheel",0],["",0],["",0],["",0],["",0],["",0],["",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0]],14052.533203,18710.265625,-0.0374832,-0.388672,0.920319,-0.0441284,0.0118575,0.0528863,0.99853,[[],[]],[["Exile_Item_Pliers",1],["Exile_Item_Handsaw",1],["Exile_Item_ZipTie",1],["Exile_Item_ZipTie",1],["Exile_Item_ZipTie",1],["Exile_Item_ZipTie",1],["Exile_Item_ZipTie",1],["Exile_Item_DuctTape",1],["Exile_Item_ZipTie",1]],[["Exile_Melee_Axe","","","",[],""]],"1110"]]]
[17:56:42:688487 +02:00] [Thread 252] extDB2: Output to Server: [1,[[2,"Exile_Car_Offroad_Rusty3","2015-12-16T00:16:47Z","76561198042406825",-1,0.965414,0,[["HitLFWheel",0],["HitLF2Wheel",0],["HitRFWheel",0],["HitRF2Wheel",0],["HitFuel",0],["HitEngine",0],["HitBody",0],["HitGlass1",0],["HitGlass2",0],["HitRGlass",0],["HitLGlass",0],["HitGlass3",0],["HitGlass4",0],["HitGlass5",0],["HitGlass6",0],["HitLBWheel",0],["HitLMWheel",0],["HitRBWheel",0],["HitRMWheel",0],["",0],["",0],["",0],["",0],["",0],["",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0],["HitTurret",0],["HitGun",0]],14052.533203,18710.265625,-0.0374832,-0.388672,0.920319,-0.0441284,0.0118575,0.0528863,0.99853,[[],[]],[["Exile_Item_Pliers",1],["Exile_Item_Handsaw",1],["Exile_Item_ZipTie",1],["Exile_Item_ZipTie",1],["Exile_Item_ZipTie",1],["Exile_Item_ZipTie",1],["Exile_Item_ZipTie",1],["Exile_Item_DuctTape",1],["Exile_Item_ZipTie",1]],[["Exile_Melee_Axe","","","",[],""]],"1110"]]]
[17:56:43:240232 +02:00] [Thread 252] extDB2: Input from Server: 0:505439:loadVehicleContainer:2
[17:56:43:240310 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadVehicleContainer:2
[17:56:43:241693 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[[[]]]]
[17:56:43:241737 +02:00] [Thread 252] extDB2: Output to Server: [1,[[[]]]]
[17:56:43:242598 +02:00] [Thread 252] extDB2: Input from Server: 0:505439:loadContainerIdPage:0:100
[17:56:43:242643 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadContainerIdPage:0:100
[17:56:43:247921 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[17:56:43:247982 +02:00] [Thread 252] extDB2: Output to Server: [1,[]]
[17:57:53:136480 +02:00] [Thread 252] extDB2: Input from Server: 0:505439:hasAlivePlayer:76561197965996488
[17:57:53:136588 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: hasAlivePlayer:76561197965996488
[17:57:53:138781 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Warning: Number of Output Options: 1, Number of SQL Columns: 0, this warning only exists in Debug Version. Its just to let you know of a possible mistake
[17:57:53:138927 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[[true]]]
[17:57:53:138956 +02:00] [Thread 252] extDB2: Output to Server: [1,[[true]]]
[17:57:53:157514 +02:00] [Thread 252] extDB2: Input from Server: 0:505439:hasAlivePlayer:76561197992634040
[17:57:53:157724 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: hasAlivePlayer:76561197992634040
[17:57:53:158827 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Warning: Number of Output Options: 1, Number of SQL Columns: 0, this warning only exists in Debug Version. Its just to let you know of a possible mistake
[17:57:53:158972 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[[false]]]
[17:57:53:159002 +02:00] [Thread 252] extDB2: Output to Server: [1,[[false]]]
[17:57:53:262806 +02:00] [Thread 252] extDB2: Input from Server: 0:505439:loadPlayer:76561197965996488
[17:57:53:262882 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadPlayer:76561197965996488
[17:57:53:281879 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[[35,"Own","76561197965996488",0,84.926231,78.739815,0,1,0,[["face_hub",0],["neck",0],["head",0],["pelvis",0],["spine1",0],["spine2",0],["spine3",0],["body",0],["arms",0],["hands",0],["legs",0]],39.325706,13992.126953,18736.0917969,0.00140381,["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio","Binocular"],"B_Carryall_ocamo",[],[],[],"srifle_DMR_02_sniper_F","G_Tactical_Black",["","","",""],"hgun_ACPC2_F","H_HelmetLeaderO_ocamo","Binocular",[["srifle_DMR_02_sniper_F","10Rnd_338_Mag",10,"srifle_DMR_02_sniper_F"],["hgun_ACPC2_F","9Rnd_45ACP_Mag",9,"hgun_ACPC2_F"]],"srifle_DMR_02_sniper_F",["muzzle_snds_338_black","","optic_KHS_blk","bipod_03_F_blk"],"",["","","",""],"U_I_GhillieSuit",[],[["Exile_Item_CanOpener",1],["10Rnd_338_Mag",10],["Exile_Item_Noodles",1],["Exile_Item_Matches",10],["Exile_Item_EnergyDrink",1],["Exile_Item_Noodles",1],["Exile_Item_ZipTie",1]],[],"V_PlateCarrierSpec_blk",[],[["10Rnd_338_Mag",10],["Exile_Item_Raisins",1],["Exile_Item_EnergyDrink",1],["Exile_Item_PlasticBottleDirtyWater",1],["9Rnd_45ACP_Mag",9],["9Rnd_45ACP_Mag",9],["9Rnd_45ACP_Mag",9],["9Rnd_45ACP_Mag",9]],[["hgun_Rook40_F",1]],2098,1889,1,11,""]]]
[17:57:53:281938 +02:00] [Thread 252] extDB2: Output to Server: [1,[[35,"Own","76561197965996488",0,84.926231,78.739815,0,1,0,[["face_hub",0],["neck",0],["head",0],["pelvis",0],["spine1",0],["spine2",0],["spine3",0],["body",0],["arms",0],["hands",0],["legs",0]],39.325706,13992.126953,18736.0917969,0.00140381,["ItemMap","ItemCompass","Exile_Item_XM8","ItemRadio","Binocular"],"B_Carryall_ocamo",[],[],[],"srifle_DMR_02_sniper_F","G_Tactical_Black",["","","",""],"hgun_ACPC2_F","H_HelmetLeaderO_ocamo","Binocular",[["srifle_DMR_02_sniper_F","10Rnd_338_Mag",10,"srifle_DMR_02_sniper_F"],["hgun_ACPC2_F","9Rnd_45ACP_Mag",9,"hgun_ACPC2_F"]],"srifle_DMR_02_sniper_F",["muzzle_snds_338_black","","optic_KHS_blk","bipod_03_F_blk"],"",["","","",""],"U_I_GhillieSuit",[],[["Exile_Item_CanOpener",1],["10Rnd_338_Mag",10],["Exile_Item_Noodles",1],["Exile_Item_Matches",10],["Exile_Item_EnergyDrink",1],["Exile_Item_Noodles",1],["Exile_Item_ZipTie",1]],[],"V_PlateCarrierSpec_blk",[],[["10Rnd_338_Mag",10],["Exile_Item_Raisins",1],["Exile_Item_EnergyDrink",1],["Exile_Item_PlasticBottleDirtyWater",1],["9Rnd_45ACP_Mag",9],["9Rnd_45ACP_Mag",9],["9Rnd_45ACP_Mag",9],["9Rnd_45ACP_Mag",9]],[["hgun_Rook40_F",1]],2098,1889,1,11,""]]]
[17:57:58:121026 +02:00] [Thread 252] extDB2: Input from Server: 0:505439:getAccountStats:76561197992634040
[17:57:58:121115 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: getAccountStats:76561197992634040
[17:57:58:122264 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[17:57:58:122307 +02:00] [Thread 252] extDB2: Output to Server: [1,[]]
[17:57:58:230122 +02:00] [Thread 252] extDB2: Input from Server: 0:505439:createPlayer:76561197992634040:Jim Raynor
[17:57:58:230213 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: createPlayer:76561197992634040:Jim Raynor
[17:57:58:249989 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error    [mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`exile`.`player`, CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE)    [mysql_stmt_errno]: 1452    [mysql_stmt_sqlstate]: 23000    [statemnt]: INSERT INTO player SET account_uid = ?, name = ?
[17:57:58:250172 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[17:57:58:250216 +02:00] [Thread 252] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561197992634040:Jim Raynor
[17:57:58:250241 +02:00] [Thread 252] extDB2: Output to Server: [0,"Error Statement Exception"]
[17:58:38:187641 +02:00] [Thread 252] extDB2: Input from Server: 1:505439:endAccountSession:76561197992634040
[17:58:38:187723 +02:00] [Thread 252] extDB2: Output to Server:
[17:58:38:187794 +02:00] [Thread 1728] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: endAccountSession:76561197992634040
[17:58:38:188862 +02:00] [Thread 1728] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[17:58:38:189730 +02:00] [Thread 252] extDB2: Input from Server: 1:505439:updatePlayer::0:100:100:0:1:0:[]:0:13230.821289:11705.513672:0.00136948:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]::G_Shades_Black:["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:-1
[17:58:38:189777 +02:00] [Thread 252] extDB2: Output to Server:
[17:58:38:189848 +02:00] [Thread 1728] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: updatePlayer::0:100:100:0:1:0:[]:0:13230.821289:11705.513672:0.00136948:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]::G_Shades_Black:["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:-1
[17:58:38:191124 +02:00] [Thread 1728] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]

 

 

Thank you in advance.

 

Share this post


Link to post
Share on other sites

What version is your mysql server?

Had the same problem, because I used 5.4. With the new update some queries changed, and only a newer version of mysql can interpret them correctly. At least that´s what I read.

You will need to upgrade to a newer version > 5.6

Share this post


Link to post
Share on other sites
Advertisement
27 minutes ago, FatSquirrel said:

What version is your mysql server?

Had the same problem, because I used 5.4. With the new update some queries changed, and only a newer version of mysql can interpret them correctly. At least that´s what I read.

You will need to upgrade to a newer version > 5.6

Yo man, thanks for reply,

I got mysql5.6.17

Share this post


Link to post
Share on other sites

Ok, that´s good news.

You might want to look at this thread

Might be your mysql configuration. Check if the sql-mode parameter is set correctly.

 

Share this post


Link to post
Share on other sites
9 minutes ago, FatSquirrel said:

Ok, that´s good news.

You might want to look at this thread

Might be your mysql configuration. Check if the sql-mode parameter is set correctly.

 

My C:\wamp\bin\mysql\mysql5.6.17\my.ini files :

# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:\mysql\data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password	= your_password
port		= 3306
socket		= /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[wampmysqld]
port		= 3306
socket		= /tmp/mysql.sock
key_buffer_size = 16M
max_allowed_packet = 1M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
basedir=c:/wamp/bin/mysql/mysql5.6.17
log-error=c:/wamp/logs/mysql.log
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" 

datadir=c:/wamp/bin/mysql/mysql5.6.17/data

lc-messages-dir=c:/wamp/bin/mysql/mysql5.6.17/share

# Change your locale here !
lc-messages=fr_FR

# Avoid warning
explicit_defaults_for_timestamp = TRUE

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
# 
#skip-networking

# Disable Federated by default
skip-federated

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# binary logging format - mixed recommended
binlog_format=mixed

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id	= 1

# Replication Slave (comment out master section to use this)


# New for MySQL 5.6 if no slave
skip-slave-start

#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin

# Point the following paths to different dedicated disks
#tmpdir		= /tmp/		
#log-update 	= /path-to-dedicated-directory/hostname

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:\mysql\data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:\mysql\data/
#innodb_log_arch_dir = C:\mysql\data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[mysqld]
port=3306
explicit_defaults_for_timestamp = TRUE

 

Share this post


Link to post
Share on other sites

yea :(

 

extB2 logs

Spoiler

extDB2: Version: 69
extDB2: https://github.com/Torndeco/extDB2
extDB2: Windows Debug 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 8 Cores, Setting up 6 Worker Threads


[11:40:11:861243 +02:00] [Thread 2660] extDB2: Input from Server: 9:VERSION
[11:40:11:861284 +02:00] [Thread 2660] extDB2: Output to Server: 69
[11:40:11:861450 +02:00] [Thread 2660] extDB2: Input from Server: 9:ADD_DATABASE:exile
[11:40:11:861479 +02:00] [Thread 2660] extDB2: Database Type: MySQL
[11:40:11:863552 +02:00] [Thread 2660] extDB2: Database Session Pool Started
[11:40:11:863574 +02:00] [Thread 2660] extDB2: Output to Server: [1]
[11:40:11:863688 +02:00] [Thread 2660] extDB2: Input from Server: 9:ADD_DATABASE_PROTOCOL:exile:SQL_CUSTOM_V2:224150:exile
[11:40:11:865699 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Program Files (x86)\Steam\steamapps\common\Arma 3\@ExileServer\extDB\sql_custom_v2\exile.ini
[11:40:11:865938 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Version 8 Detected, Latest Version 12 Available
[11:40:11:869456 +02:00] [Thread 2660] extDB2: Output to Server: [1]
[11:40:11:869505 +02:00] [Thread 2660] extDB2: Input from Server: 9:LOCAL_TIME
[11:40:11:869529 +02:00] [Thread 2660] extDB2: Output to Server: [1,[2015,12,18,10,40]]
[11:40:11:869621 +02:00] [Thread 2660] extDB2: Input from Server: 9:LOCK
[11:40:11:869636 +02:00] [Thread 2660] extDB2: Output to Server: [1]
[11:40:12:718152 +02:00] [Thread 2660] extDB2: Input from Server: 1:224150:deleteUnpaidTerritories:7
[11:40:12:718204 +02:00] [Thread 2660] extDB2: Output to Server:
[11:40:12:718272 +02:00] [Thread 2660] extDB2: Input from Server: 1:224150:deleteOldContainers:7
[11:40:12:718282 +02:00] [Thread 3188] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: deleteUnpaidTerritories:7
[11:40:12:718294 +02:00] [Thread 2660] extDB2: Output to Server:
[11:40:12:718411 +02:00] [Thread 2660] extDB2: Input from Server: 1:224150:deleteOldConstructions:2
[11:40:12:718420 +02:00] [Thread 2388] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: deleteOldContainers:7
[11:40:12:718433 +02:00] [Thread 2660] extDB2: Output to Server:
[11:40:12:718539 +02:00] [Thread 2660] extDB2: Input from Server: 1:224150:deleteOldVehicles:3
[11:40:12:718542 +02:00] [Thread 3032] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: deleteOldConstructions:2
[11:40:12:718562 +02:00] [Thread 2660] extDB2: Output to Server:
[11:40:12:718619 +02:00] [Thread 2616] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: deleteOldVehicles:3
[11:40:12:718934 +02:00] [Thread 2660] extDB2: Input from Server: 0:224150:loadTerriotryIdPage:0:100
[11:40:12:718990 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadTerriotryIdPage:0:100
[11:40:12:839071 +02:00] [Thread 3188] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[11:40:12:839079 +02:00] [Thread 2388] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[11:40:12:839206 +02:00] [Thread 2616] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[11:40:12:839083 +02:00] [Thread 3032] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[11:40:12:840013 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[11:40:12:840061 +02:00] [Thread 2660] extDB2: Output to Server: [1,[]]
[11:40:12:864976 +02:00] [Thread 2660] extDB2: Input from Server: 0:224150:loadConstructionIdPage:0:100
[11:40:12:865033 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadConstructionIdPage:0:100
[11:40:12:866393 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[11:40:12:866438 +02:00] [Thread 2660] extDB2: Output to Server: [1,[]]
[11:40:12:866964 +02:00] [Thread 2660] extDB2: Input from Server: 0:224150:loadVehicleIdPage:0:100
[11:40:12:867012 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadVehicleIdPage:0:100
[11:40:12:868245 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[11:40:12:868288 +02:00] [Thread 2660] extDB2: Output to Server: [1,[]]
[11:40:12:868754 +02:00] [Thread 2660] extDB2: Input from Server: 0:224150:loadContainerIdPage:0:100
[11:40:12:868795 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: loadContainerIdPage:0:100
[11:40:12:870035 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[11:40:12:870079 +02:00] [Thread 2660] extDB2: Output to Server: [1,[]]
[11:41:24:559409 +02:00] [Thread 2660] extDB2: Input from Server: 0:224150:hasAlivePlayer:76561197965996488
[11:41:24:559513 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: hasAlivePlayer:76561197965996488
[11:41:24:586312 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Warning: Number of Output Options: 1, Number of SQL Columns: 0, this warning only exists in Debug Version. Its just to let you know of a possible mistake
[11:41:24:586512 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[[false]]]
[11:41:24:586543 +02:00] [Thread 2660] extDB2: Output to Server: [1,[[false]]]
[11:41:42:975137 +02:00] [Thread 2660] extDB2: Input from Server: 0:224150:getAccountStats:76561197965996488
[11:41:42:975235 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: getAccountStats:76561197965996488
[11:41:43:038008 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[11:41:43:038064 +02:00] [Thread 2660] extDB2: Output to Server: [1,[]]
[11:41:43:365173 +02:00] [Thread 2660] extDB2: Input from Server: 0:224150:createPlayer:76561197965996488:Own
[11:41:43:365253 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: createPlayer:76561197965996488:Own
[11:41:43:378859 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error    [mysql_stmt_error]: Cannot add or update a child row: a foreign key constraint fails (`exile`.`player`, CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE)    [mysql_stmt_errno]: 1452    [mysql_stmt_sqlstate]: 23000    [statemnt]: INSERT INTO player SET account_uid = ?, name = ?
[11:41:43:378993 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[11:41:43:379027 +02:00] [Thread 2660] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: createPlayer:76561197965996488:Own
[11:41:43:379051 +02:00] [Thread 2660] extDB2: Output to Server: [0,"Error Statement Exception"]
[11:42:23:034528 +02:00] [Thread 2660] extDB2: Input from Server: 1:224150:endAccountSession:76561197965996488
[11:42:23:034615 +02:00] [Thread 2660] extDB2: Output to Server:
[11:42:23:034685 +02:00] [Thread 3032] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: endAccountSession:76561197965996488
[11:42:23:035742 +02:00] [Thread 3032] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[11:42:23:036613 +02:00] [Thread 2660] extDB2: Input from Server: 1:224150:updatePlayer::0:100:100:0:1:0:[]:0:13237.161133:11705.337891:0.001297:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]:::["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:-1
[11:42:23:036660 +02:00] [Thread 2660] extDB2: Output to Server:
[11:42:23:036732 +02:00] [Thread 3032] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Input: updatePlayer::0:100:100:0:1:0:[]:0:13237.161133:11705.337891:0.001297:["ItemMap","ItemCompass","ItemWatch","ItemRadio"]::[]:[]:[]:::["","","",""]::::[]::["","","",""]::["","","",""]::[]:[]:[]::[]:[]:[]:-1
[11:42:23:037992 +02:00] [Thread 3032] extDB2: SQL_CUSTOM_V2: Trace: UniqueID: 1 Result: [1,[]]
[11:45:27:885135 +02:00] [Thread 2660] extDB2: Stopping ...

 

Here a screenshot of my phpmyadmin local on dedicated server

Sorry i don't found the language parameters

https://gyazo.com/abc8986c47aa5878bc6606b2ee5df234

Edited by Own_x

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.