iGryphy Posted December 5, 2014 Report Share Posted December 5, 2014 Hi There, This is my first post. I have my Epoch Private server set up on a dedicaited machine and followed the Tutorial on doing this all. I have the SQL DB saved under "dayz_epoch" and I can join the server. But every time I try and play on the server, The Log file on the Dedicaited Machine states this next line. " 2014-12-05 00:02:18 HiveExt: [information] HiveExt 2014-12-05 00:02:18 Database: [information] Connected to MySQL database localhost:0/ client ver: 5.5.28 server ver: 5.6.21 2014-12-05 00:02:18 Database: [information] Connected to MySQL database localhost:0/ client ver: 5.5.28 server ver: 5.6.21 2014-12-05 00:02:18 HiveExt: [information] Method: 302 Params: 11: 2014-12-05 00:02:18 Database: [Error] Error 1046 (No database selected) in MySQLQuery SQL: 'SELECT COUNT(*) FROM `Object_DATA` WHERE `Instance` = 11 AND `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 6 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )' 2014-12-05 00:02:18 Database: [Error] Error 1046 (No database selected) in MySQLQuery SQL: 'SELECT `ObjectID`, `Classname`, `CharacterID`, `Worldspace`, `Inventory`, `Hitpoints`, `Fuel`, `Damage` FROM `Object_DATA` WHERE `Instance`=11 AND `Classname` IS NOT NULL' 2014-12-05 00:02:18 HiveExt: [Error] Failed to fetch objects from database 2014-12-05 00:02:18 HiveExt: [information] Result: ["ObjectStreamStart",0,"c865f315501fe83e0e1c2c3303a1d707"] 2014-12-05 00:02:19 HiveExt: [information] Method: 399 Params: 478: 2014-12-05 00:02:19 Database: [Error] Error 1046 (No database selected) in MySQLQuery SQL: 'SELECT `id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile` FROM `Traders_DATA` WHERE `tid`=478' " I have the HiveEtx.ini file stating: ";Hostname or IP of the server to connect to ;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 = localhost ;Currently, only MySQL is supported 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. Database = dayz_epoch ;Username to connect with Username = root ;Password to authenticate with (default is blank) Password = ******" As well as the Dedicaited Server is Windows 2008 R2 Standard, I have also opened the ports required under UDP and TCP for the SQL Database connection. Im wondering if anyone can help me with the Database coming up with this error "1046 (NO DATABASE SELECTED)". Thanks, and I shall check up as soon as possible. PS: I did a fresh install of the Epoch Server, Using SteamCMD to download the Arma 2, Arma 2 OA games, and the server files required for Arma 2, and Arma 2 OA. Then used the latest version of Epoch's Server and Client files, which is 1.0.5.1. Link to comment Share on other sites More sharing options...
Namindu Posted December 5, 2014 Report Share Posted December 5, 2014 Who is the host of the dedicated box. Make sure Mysql is running on localhost. Link to comment Share on other sites More sharing options...
iGryphy Posted December 5, 2014 Author Report Share Posted December 5, 2014 Who is the host of the dedicated box. Make sure Mysql is running on localhost. Its rented from SoYouStart (OVH), but MySQL is running on the host on Port 3306. Its been a burden to my existence for 48 hours now. Link to comment Share on other sites More sharing options...
cen Posted December 5, 2014 Report Share Posted December 5, 2014 Can you connect to the database on the machine using something like Heidi SQL/MySQL Workbench/NaviCat? Link to comment Share on other sites More sharing options...
iGryphy Posted December 5, 2014 Author Report Share Posted December 5, 2014 Can you connect to the database on the machine using something like Heidi SQL/MySQL Workbench/NaviCat? Yes. Hiedi SQL and MySQL Workbench connect to the database with no issues, but when the game is running and I try to join it to test it, it ends up with No Database selected and then causes the server program to crash. Link to comment Share on other sites More sharing options...
iGryphy Posted December 7, 2014 Author Report Share Posted December 7, 2014 Still having the issue. Anyone able to help? Link to comment Share on other sites More sharing options...
Radiix Posted December 11, 2014 Report Share Posted December 11, 2014 1. Make sure your specified database "dayz_epoch" actually exists in MySQL. 2. Double check your Hive settings. Make sure you entered the correct name of the database you created. Link to comment Share on other sites More sharing options...
iGryphy Posted December 11, 2014 Author Report Share Posted December 11, 2014 Hive Settings as below: [Put them in spoiler to keep it tidy] ;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 = Static ;If using Custom type, offset from UTC in hours (can be negative as well) ;Offset = -8 ;If using Static type (Hour value always the same on every server start), the value (0-24) to set the Hour to Hour = 13 [Database] ;Hostname or IP of the server to connect to ;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 = localhost ;Currently, only MySQL is supported 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. Database = dayz_epoch ;Username to connect with Username = root ;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 = true ;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 = 127.0.0.1 ;Port = 3306 ;Database = dayz_epoch ;Username = root ;Password = Hive Error when running the Server, in spoiler to keep post tidy. 2014-12-05 00:02:18 HiveExt: [information] HiveExt 2014-12-05 00:02:18 Database: [information] Connected to MySQL database localhost:0/ client ver: 5.5.28 server ver: 5.6.21 2014-12-05 00:02:18 Database: [information] Connected to MySQL database localhost:0/ client ver: 5.5.28 server ver: 5.6.21 2014-12-05 00:02:18 HiveExt: [information] Method: 302 Params: 11: 2014-12-05 00:02:18 Database: [Error] Error 1046 (No database selected) in MySQLQuery SQL: 'SELECT COUNT(*) FROM `Object_DATA` WHERE `Instance` = 11 AND `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 6 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )' 2014-12-05 00:02:18 Database: [Error] Error 1046 (No database selected) in MySQLQuery SQL: 'SELECT `ObjectID`, `Classname`, `CharacterID`, `Worldspace`, `Inventory`, `Hitpoints`, `Fuel`, `Damage` FROM `Object_DATA` WHERE `Instance`=11 AND `Classname` IS NOT NULL' 2014-12-05 00:02:18 HiveExt: [Error] Failed to fetch objects from database 2014-12-05 00:02:18 HiveExt: [information] Result: ["ObjectStreamStart",0,"c865f315501fe83e0e1c2c3303a1d707"] 2014-12-05 00:02:19 HiveExt: [information] Method: 399 Params: 478: 2014-12-05 00:02:19 Database: [Error] Error 1046 (No database selected) in MySQLQuery SQL: 'SELECT `id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile` FROM `Traders_DATA` WHERE `tid`=478' Ports Opened On both incoming and outgoing ports: Steamport - 2300 UDP And TCP Steamqueryport - 2301 UDP and TCP DayZ Epoch 2302 UDP and TCP MySQL 3306 UDP and TCP Screen Captures of the Server: ----------- Just wondering since the SQL Database is on the localhost (127.0.0.1), it should still work, correct? Link to comment Share on other sites More sharing options...
