Can't Start Server about dayz-private-server HOT 12 CLOSED

Witch version of A2:OA server you use?

From SteamCMD version server just kick player (Communication Lost).

from dayz-private-server.

And one else, you have no table Object_DATA in yours hivemind. Check it and validate HiveExt.ini.
Server may fall 'cause HiveExt.dll can't init. And check you logs of server. There must be error description.

from dayz-private-server.

Have you executed the latest SQL file on your server? That error you are receiving is due to your database schema not being correct.

from dayz-private-server.

from dayz-private-server.

Above is a picture of my Database schema

from dayz-private-server.

Now i'm getting
2016-07-30 16:48:04 HiveExt: [Error] Error creating character for playerId 76561198094317662
2016-07-30 16:48:04 HiveExt: [Information] Result: ["ERROR"]
2016-07-30 16:48:04 HiveExt: [Information] Method: 101 Params: 76561198094317662:1337:AutoJukebox:
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT PlayerName, PlayerSex FROM Player_DATA WHERE PlayerUID='76561198094317662''
2016-07-30 16:48:04 HiveExt: [Information] Created a new player 76561198094317662 named 'AutoJukebox'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Player_DATA (PlayerUID, PlayerName) VALUES (?, ?)'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT CharacterID, Worldspace, Inventory, Backpack, TIMESTAMPDIFF(MINUTE,Datestamp,LastLogin) as SurvivalTime, TIMESTAMPDIFF(MINUTE,LastAte,NOW()) as MinsLastAte, TIMESTAMPDIFF(MINUTE,LastDrank,NOW()) as MinsLastDrank, Model FROM Character_DATA WHERE PlayerUID = '76561198094317662' AND Alive = 1 ORDER BY CharacterID DESC LIMIT 1'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Player_DATA (PlayerUID, PlayerName) VALUES (?, ?)'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT Generation, Humanity, Model FROM Character_DATA WHERE PlayerUID = '76561198094317662' AND Alive = 0 ORDER BY CharacterID DESC LIMIT 1'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Character_DATA (PlayerUID, InstanceID, Worldspace, Inventory, Backpack, Medical, Generation, Datestamp, LastLogin, LastAte, LastDrank, Humanity) VALUES (?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?)'
2016-07-30 16:48:04 HiveExt: [Error] Error creating character for playerId 76561198094317662
2016-07-30 16:48:04 HiveExt: [Information] Result: ["ERROR"]
2016-07-30 16:48:04 HiveExt: [Information] Method: 101 Params: 76561198094317662:1337:AutoJukebox:
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT PlayerName, PlayerSex FROM Player_DATA WHERE PlayerUID='76561198094317662''
2016-07-30 16:48:04 HiveExt: [Information] Created a new player 76561198094317662 named 'AutoJukebox'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT CharacterID, Worldspace, Inventory, Backpack, TIMESTAMPDIFF(MINUTE,Datestamp,LastLogin) as SurvivalTime, TIMESTAMPDIFF(MINUTE,LastAte,NOW()) as MinsLastAte, TIMESTAMPDIFF(MINUTE,LastDrank,NOW()) as MinsLastDrank, Model FROM Character_DATA WHERE PlayerUID = '76561198094317662' AND Alive = 1 ORDER BY CharacterID DESC LIMIT 1'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT Generation, Humanity, Model FROM Character_DATA WHERE PlayerUID = '76561198094317662' AND Alive = 0 ORDER BY CharacterID DESC LIMIT 1'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Character_DATA (PlayerUID, InstanceID, Worldspace, Inventory, Backpack, Medical, Generation, Datestamp, LastLogin, LastAte, LastDrank, Humanity) VALUES (?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?)'
2016-07-30 16:48:04 HiveExt: [Error] Error creating character for playerId 76561198094317662
2016-07-30 16:48:04 HiveExt: [Information] Result: ["ERROR"]
2016-07-30 16:48:04 HiveExt: [Information] Method: 101 Params: 76561198094317662:1337:AutoJukebox:
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT PlayerName, PlayerSex FROM Player_DATA WHERE PlayerUID='76561198094317662''
2016-07-30 16:48:04 HiveExt: [Information] Created a new player 76561198094317662 named 'AutoJukebox'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT CharacterID, Worldspace, Inventory, Backpack, TIMESTAMPDIFF(MINUTE,Datestamp,LastLogin) as SurvivalTime, TIMESTAMPDIFF(MINUTE,LastAte,NOW()) as MinsLastAte, TIMESTAMPDIFF(MINUTE,LastDrank,NOW()) as MinsLastDrank, Model FROM Character_DATA WHERE PlayerUID = '76561198094317662' AND Alive = 1 ORDER BY CharacterID DESC LIMIT 1'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT Generation, Humanity, Model FROM Character_DATA WHERE PlayerUID = '76561198094317662' AND Alive = 0 ORDER BY CharacterID DESC LIMIT 1'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Character_DATA (PlayerUID, InstanceID, Worldspace, Inventory, Backpack, Medical, Generation, Datestamp, LastLogin, LastAte, LastDrank, Humanity) VALUES (?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?)'
2016-07-30 16:48:04 HiveExt: [Error] Error creating character for playerId 76561198094317662
2016-07-30 16:48:04 HiveExt: [Information] Result: ["ERROR"]
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Player_DATA (PlayerUID, PlayerName) VALUES (?, ?)'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Player_DATA (PlayerUID, PlayerName) VALUES (?, ?)'

from dayz-private-server.

Can you paste the contents of your HiveExt.ini file? Obviously removing any sensitive information, first.

from dayz-private-server.

;This is a comment
;Comments above a certain setting will provide it's description

;The format for a setting is
;Variable = Value

;If you see a commented line of that form, it means that the setting is optional, and the Value shows the default
;To change from the default, simply uncomment the line and change the Value

;This configuration file should be placed inside your server instance's configuration directory (like cfgdayz)

[Time]
;Possible values: Local, Custom, Static
;You cannot use Static on OFFICIAL Hive, it will just revert to Local
;Type = Local
;If using Custom type, offset from UTC in hours (can be negative as well)
;Offset = 0
;These 2 settings only apply if using Static type (Custom date/time on every server start)
;The value (0-24) to set the Hour to, if commented or empty then the hour won't be changed
;Hour = 8
;The value (DD/MM/YYYY) to set the Date to, if commented or empty then the date won't be changed
;Date = 4.1.2013

[Logger]
;Possible values: trace, debug, information, notice, warning, error, critical, fatal, none
;They are sorted by importance (low to high), with trace being the most verbose, and none would turn off logging
;This controls both the file output level, and the console output level
;Level = information

;Uncomment this option to override the logging level for the console only
;The specified level can only be higher than the global one, setting lower values will have no effect
;So for example, if you want to have information-level logs in your file, but only warning-level and higher in your console
;You would uncomment this option and set it to warning
;Leaving it commented out means there's no special level for the console, so it will just use the global one
;ConsoleLevel = information

;By default, the HiveExt console log output will go to the Arma2 server window, with colour highlighing by importance
;If you want to use the old style, separate windows console window for the HiveExt log output, set this option to true
SeparateConsole = true

[Database]
;Hostname or IP of the server to connect to
;You can use the value "." (without quotes) to indicate named-pipe localhost connection
;If you leave this line commented or blank, HiveExt will connect to the OFFICIAL Hive, which requires registration
;See support.dayzmod.com for more information on what OFFICIAL Hive means, what are the rules, etc.
;If using OFFICIAL hive, the rest of the settings in this section have no effect
Host = 38.130.218.***

;The default is MySql, which is better supported than Postgre (completely untested)
Type = MySql

;Port to connect to. The default is the default listening port of a server of the selected Type
;Instead of specifying Port, you can specify Socket and set Value to the socket name
Port = 3306

;Database name to connect to (you must supply this if private).
Database = **

;Username to connect with
Username = **
;Password to authenticate with (default is blank)
Password = **

;If using OFFICIAL hive, the settings in this section have no effect, appropriate layout will be used
[Characters]
;The field name that Player's IDs are stored in (unique per game license)
;Some table layouts have this as PlayerID, and some as PlayerUID, that's why this is configurable
;IDField = PlayerUID
;The field name that Player's World Position and rotation is stored in
;Enables you to run multiple different maps (different instances) off the same character table
;WSField = Worldspace

;If using OFFICIAL hive, the settings in this section have no effect, as it will clean up by itself
[Objects]
;Which table should the objects be stored and fetched from ?
;Table = Object_DATA

;Negative values will disable this feature
;0 means that ALL empty placed items will be deleted every server restart
;A positive number is how old (in days) a placed empty item must be, in order for it to be deleted
;CleanupPlacedAfterDays = 6

;Flag indicating whether hiveext should detect vehicles out of map boundaries (X < 0, or Y > 15360) and reset their position to []
;Note: YOU MUST have a proper dayz_server.pbo that supports this feature, otherwise you will get script errors
;You can find that file under the SQF directory for your server version
;ResetOOBVehicles = false

;If using OFFICIAL hive, the settings in this section have no effect, it will manage objects on its own
[ObjectDB]
;Setting this to true separates the Object fetches from the Character fetches
;That means that the Object Table must be on this other database
;Use = false

;The settings here have the same meaning as in [Database], and are only used if the setting above is set to true
;Type = MySql
;Host = localhost
;Port = 3306
;Database =
;Username = root
;Password =

from dayz-private-server.

I don't see why this isn't working properly for you. Make sure all your database information lines up properly with the HiveExt.ini file.

from dayz-private-server.

Tried that, No luck. I even deleted my database, reuploaded the .sql and tried it with no luck.

from dayz-private-server.

Any update to this issue? Can connect to database remotely and locally with no problems using HeidiSQL. Usernames, permissions, and passwords are all correct. Is a server I built in my home that I use for multiple others servers with no issues. But DayZ just crashes. Any more troubleshooting I could do?

from dayz-private-server.

Now i'm getting
2016-07-30 16:48:04 HiveExt: [Error] Error creating character for playerId 76561198094317662
2016-07-30 16:48:04 HiveExt: [Information] Result: ["ERROR"]
2016-07-30 16:48:04 HiveExt: [Information] Method: 101 Params: 76561198094317662:1337:AutoJukebox:
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT PlayerName, PlayerSex FROM Player_DATA WHERE PlayerUID='76561198094317662''
2016-07-30 16:48:04 HiveExt: [Information] Created a new player 76561198094317662 named 'AutoJukebox'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Player_DATA (PlayerUID, PlayerName) VALUES (?, ?)'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT CharacterID, Worldspace, Inventory, Backpack, TIMESTAMPDIFF(MINUTE,Datestamp,LastLogin) as SurvivalTime, TIMESTAMPDIFF(MINUTE,LastAte,NOW()) as MinsLastAte, TIMESTAMPDIFF(MINUTE,LastDrank,NOW()) as MinsLastDrank, Model FROM Character_DATA WHERE PlayerUID = '76561198094317662' AND Alive = 1 ORDER BY CharacterID DESC LIMIT 1'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Player_DATA (PlayerUID, PlayerName) VALUES (?, ?)'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT Generation, Humanity, Model FROM Character_DATA WHERE PlayerUID = '76561198094317662' AND Alive = 0 ORDER BY CharacterID DESC LIMIT 1'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Character_DATA (PlayerUID, InstanceID, Worldspace, Inventory, Backpack, Medical, Generation, Datestamp, LastLogin, LastAte, LastDrank, Humanity) VALUES (?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?)'
2016-07-30 16:48:04 HiveExt: [Error] Error creating character for playerId 76561198094317662
2016-07-30 16:48:04 HiveExt: [Information] Result: ["ERROR"]
2016-07-30 16:48:04 HiveExt: [Information] Method: 101 Params: 76561198094317662:1337:AutoJukebox:
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT PlayerName, PlayerSex FROM Player_DATA WHERE PlayerUID='76561198094317662''
2016-07-30 16:48:04 HiveExt: [Information] Created a new player 76561198094317662 named 'AutoJukebox'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT CharacterID, Worldspace, Inventory, Backpack, TIMESTAMPDIFF(MINUTE,Datestamp,LastLogin) as SurvivalTime, TIMESTAMPDIFF(MINUTE,LastAte,NOW()) as MinsLastAte, TIMESTAMPDIFF(MINUTE,LastDrank,NOW()) as MinsLastDrank, Model FROM Character_DATA WHERE PlayerUID = '76561198094317662' AND Alive = 1 ORDER BY CharacterID DESC LIMIT 1'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT Generation, Humanity, Model FROM Character_DATA WHERE PlayerUID = '76561198094317662' AND Alive = 0 ORDER BY CharacterID DESC LIMIT 1'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Character_DATA (PlayerUID, InstanceID, Worldspace, Inventory, Backpack, Medical, Generation, Datestamp, LastLogin, LastAte, LastDrank, Humanity) VALUES (?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?)'
2016-07-30 16:48:04 HiveExt: [Error] Error creating character for playerId 76561198094317662
2016-07-30 16:48:04 HiveExt: [Information] Result: ["ERROR"]
2016-07-30 16:48:04 HiveExt: [Information] Method: 101 Params: 76561198094317662:1337:AutoJukebox:
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT PlayerName, PlayerSex FROM Player_DATA WHERE PlayerUID='76561198094317662''
2016-07-30 16:48:04 HiveExt: [Information] Created a new player 76561198094317662 named 'AutoJukebox'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT CharacterID, Worldspace, Inventory, Backpack, TIMESTAMPDIFF(MINUTE,Datestamp,LastLogin) as SurvivalTime, TIMESTAMPDIFF(MINUTE,LastAte,NOW()) as MinsLastAte, TIMESTAMPDIFF(MINUTE,LastDrank,NOW()) as MinsLastDrank, Model FROM Character_DATA WHERE PlayerUID = '76561198094317662' AND Alive = 1 ORDER BY CharacterID DESC LIMIT 1'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT Generation, Humanity, Model FROM Character_DATA WHERE PlayerUID = '76561198094317662' AND Alive = 0 ORDER BY CharacterID DESC LIMIT 1'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Character_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Character_DATA (PlayerUID, InstanceID, Worldspace, Inventory, Backpack, Medical, Generation, Datestamp, LastLogin, LastAte, LastDrank, Humanity) VALUES (?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?)'
2016-07-30 16:48:04 HiveExt: [Error] Error creating character for playerId 76561198094317662
2016-07-30 16:48:04 HiveExt: [Information] Result: ["ERROR"]
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Player_DATA (PlayerUID, PlayerName) VALUES (?, ?)'
2016-07-30 16:48:04 Database: [Error] Error 1146 (Table 'hivemind.Player_DATA' doesn't exist) in MySQLStmtPrepare SQL: 'INSERT INTO Player_DATA (PlayerUID, PlayerName) VALUES (?, ?)'

I suspet that u`r use Linux db? Or other with sensetive register.
U must rename your all databeses tables with object_data to Object_DATA, Player_DATA and other
Autor have this problem too.

from dayz-private-server.