Server will not connect to DB

[RickAKASpud]

Hi guys.

 

Been trying to get this working for 3 days now. Still nothing..

 

Here is the RPT:

 

http://pastebin.com/rFjPgUcB

 

I have setup navicat and connected locally and externally.. Both work with the credentials. I have also used the default Dayz_server.pbo and dayz mission.

 

When i connect to the server i get requestion authentication then stops there.

 

Any help would be great

 

Rick

[insertcoins]

have you set up your hiveini?

[RickAKASpud]

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


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


;Username to connect with
Username = epoch
;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 = dayz
;Username = root
;Password =


[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 = trace


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


;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

[Defent]

You sure you havnt mixed up these two?

Database = zadmin_epoch

Username = epoch

Also, check the permissions of the user account, it needs to be able to read, write etc.

[RickAKASpud]

Im pritty sure.

 

Let me take a look.

[insertcoins]

Host = 127.0.0.1

you sure this is correct?

[RickAKASpud]

Checked and they are correct. Also changed it to local host with no luck :(

[insertcoins]

this is mine, maybe this helps you

;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

[Date]
;Possible values: Local, Static
Type = static
;If using Static type, the year/month/date to set the date to
;Year = 2013
;Month = 8
;Date = 31

[Time]
;Possible values: Local, Custom, Static
Type = static
;If using Custom type, offset from UTC in hours (can be negative as well)
Offset = -12
;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]
;Currently, only MySQL is supported
Type = MySQL
;Hostname or IP of the server to connect to
Host = eu-fr.mysql.verthosting.com
;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 = database-epoch
;Username to connect with
Username = I like big butts
;Password to authenticate with (default is blank)
Password = I can not lie

[Characters]
;The field name that Player's IDs are stored in (unique per game license)
;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

[Objects]
;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
;ResetOOBObjects = false
CleanupPlacedAfterDays = 60

[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 = dayz
;Username = dayz
;Password = CHANGEME

[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 = warning
 
;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 = warning
 
;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 = false

[Flosstradamus]

Checked and they are correct. Also changed it to local host with no luck :(

Are you using a host or are you trying to set up a test server on your own machine ? Reason  I ask is because 127.0.0.1 is the localhost.

[RickAKASpud]

Hi there,

 

This is hosted on a Windows server 2012 R2.

[RickAKASpud]

Still nothing. Been trying to get this working for 3 hours now. There must be something im doing wrong here but what is it?

 

Rick

[insertcoins]

Does your database have a webadress?

[cen]

Did you actually install MySQL? (legit question)

[RickAKASpud]

Hi guys,

 

Maca has taken a look over the install and he cant find anything wrong with it. Im sure he will explain more in-depth what he has done.

 

Still no server :/