jonrainier / DayZ-Private-Server

DayZ Private Server by Pwnoz0r
98 stars 131 forks source link

Can't Start Server #144

Closed AutoJukebox closed 7 years ago

AutoJukebox commented 8 years ago

I get this error in the hiveext console when i try to start my server

ss 2016-07-27 at 06 59 52

griha41 commented 8 years ago

Witch version of A2:OA server you use?

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

griha41 commented 8 years ago

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.

jonrainier commented 8 years ago

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

AutoJukebox commented 8 years ago

ss 2016-07-29 at 11 26 05

AutoJukebox commented 8 years ago

Above is a picture of my Database schema

AutoJukebox commented 8 years ago

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 (?, ?)'

jonrainier commented 8 years ago

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

AutoJukebox commented 8 years ago

;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 =

jonrainier commented 8 years ago

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.

AutoJukebox commented 8 years ago

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

RC-Robio commented 8 years ago

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?

skiperh1n1 commented 7 years ago

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.