Nots Tables (mysql)

Nots Tables (mysql)

« posted: Nov 09, 2016, 09:17 AM »
Hey guys,
My mysql server does not load tables

https://img3.picload.org/image/rdprlaol/mysql.jpg
Nots Tables (mysql)


Code: [Select]
[Main]
Version = 5

;Threads = 0 
; Default Value is the number of CPU Cores Detected (max value is 6, min value is 2)

Randomize Config File = false
;This is a legacy option to randomize config file for Arma2 Servers. Only for Windows Builds


;################################################################################################################################
;##                                                                                                                            ##
;##    A3WASTELAND DATABASE                                                                                                    ##
;##                                                                                                                            ##

[A3W]
Type = MySQL
Name = a3wasteland

Username = *****
Password = ****

IP = 89.163.216.24
Port = 3306

;minSessions = 2
idleTime = 60

compress = true
; Really should only use this if MySQL server is external. Also only for MySQL

Secure Auth = true
; Recommend you turn this on  http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_secure-auth

;##                                                                                                                            ##
;##                                                                                                                            ##
;################################################################################################################################


[Rcon]
;; This is functional, should be working fine. Just needs abit of testing on a $
;; Allow for changing Address for those running server in a VM environment.
IP = 89.163.208.120
Port = 2302

;; Rcon Password i.e Battleye/beserver.cfg
Password = *****

;; Bad Player Name Checks
;; This will only work if your mission / mod has started extDB2 Rcon. i.e 9:START_RCON:RCON
Bad Playername Enable = false
Bad Playername Kick Message = Bad Player Name

;; By default : is a bad character (used as seperator for extDB2 Calls (this is hardcoded in)
;;Bad Playername Strings = (:):{:}
;;Bad Playername Regex_1 = [:alnum:]
;;Bad Playername Regex_2 = [:alnum:]
;;Bad Playername Regex_3 = [:alnum:]


;; Whitelisting / Reserve Slots
;; This will only work if your mission / mod has started extDB2 Rcon. i.e 9:START_RCON:RCON
Whitelist Enable = false
Whitelist Kick Message = Only Reserved Slots Left

Whitelist Public Slots = 999

;; Database settings to use (Optional)
Whitelist Database = MySQL_Example
Whitelist SQL Prepared Statement = SELECT CASE WHEN EXISTS(SELECT UID FROM PlayerInfo WHERE BattlEyeGUID=? AND Whitelisted=1) THEN 1 ELSE 0 END
Whitelist Kick on SQL Query Failed = false

;; Hardcoded BEGuids for whitelisted players
;Whitelist BEGuids = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx : yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy


[RemoteAccess]
;; Remote TCP Access to extDB2
Enable = true

Port = 2300
MaxThreads = 4
MaxQueued = 4
IdleTime = 120

Password = password


[Steam]
;; This is for VAC Protocol for VAC Bans + Steam Friends.
;; https://steamcommunity.com/dev/apikey
API Key = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


[VAC]
;; This feature requires Steam + Rcon to be enabled.
;; Also this feature is called via SQF Code atm, i.e it doesn't auto detect players joining server yet....
Auto Ban = true

;; For Player to get banned ( their total VAC Bans => NumberOfVACBans)  AND ( Days Since their Last Ban was <= DaysSinceLastBan)
;; This is also used extDB Protocol VAC:VACBanned returned results

NumberOfVACBans = 1
DaysSinceLastBan = 999999999
BanDuration = 0
;; 0 = Forever, otherwise its x Minutes
BanMessage = Steam VAC Banned


[Log]
;; Flush Logs after each write, more work on Harddrive
Flush = true


[MySQL_Example]
Type = MySQL
Name = a3wasteland

Username = ****
Password = *****

IP = 89.163.216.24
Port = 3306

;minSessions = 2
idleTime = 60

compress = true
; Really should only use this if MySQL server is external. Also only for MySQL

Secure Auth = true
; Recommend you turn this on  http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_secure-auth


[SQLite_Example]
Type = SQLite
Name = sqlite.db

minSessions = 1
; minSession Default Value = 1

;maxSessions = 4
; maxSession Default Value = number of Main->Threads
; You really should leave this value alone
idleTime = 60
; idleTime no Default Value yet, needs to be defined.
; idleTime is the time before a database session is stopped if not used.
; If Database Sessions are greater than minSessions
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Nots Tables (mysql)

« Reply #1 posted: Nov 09, 2016, 05:01 PM »
import the tables or run the query
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!

Re: Nots Tables (mysql)

« Reply #2 posted: Nov 09, 2016, 11:32 PM »
import the tables or run the query


Have I, but it does not?
  • Offline Vapr0
  • Geared Up
  • **
  • Posts: 26

Re: Nots Tables (mysql)

« Reply #3 posted: Nov 09, 2016, 11:46 PM »
have you added server permission to the schema? that should solve it, as it did for me.

Re: Nots Tables (mysql)

« Reply #4 posted: Nov 10, 2016, 12:04 AM »
How do I add authority to schema???

Re: Nots Tables (mysql)

« Reply #5 posted: Nov 10, 2016, 02:17 PM »
I noticed all your tables are created with lowercase names. The queries that ship with release files use camel case for table names.

Depending on how your database is configured this could be a problem. An easy way to test is to try "select * from PlayerInfo". If that gives you an error then then that is why mission isn't saving.

Re: Nots Tables (mysql)

« Reply #6 posted: Nov 10, 2016, 06:21 PM »
I noticed all your tables are created with lowercase names. The queries that ship with release files use camel case for table names.

Depending on how your database is configured this could be a problem. An easy way to test is to try "select * from PlayerInfo". If that gives you an error then then that is why mission isn't saving.

Umm mine didn't!! Mine came with all lower case for each table and it works fine.
  • Offline Vapr0
  • Geared Up
  • **
  • Posts: 26

Re: Nots Tables (mysql)

« Reply #7 posted: Nov 10, 2016, 09:35 PM »
How do I add authority to schema???

go to your MySQL Workbench

on the left panel (Navigator)

it will say User and Privileges
click on it

Hit -> Add Account

put in your Login name and leave everything else as default. don't put a password or that will screw things up.
Go to Schema Privileges and on the right click on Add Entry....

select you schema (default is a3wasteland) for example hit okay.

check box all of them (shortcut is Select "ALL" on the bottom right. -> then click apply

You should be okay from their

Re: Nots Tables (mysql)

« Reply #8 posted: Nov 11, 2016, 07:12 AM »
go to your MySQL Workbench

on the left panel (Navigator)

it will say User and Privileges
click on it

Hit -> Add Account

put in your Login name and leave everything else as default. don't put a password or that will screw things up.
Go to Schema Privileges and on the right click on Add Entry....

select you schema (default is a3wasteland) for example hit okay.

check box all of them (shortcut is Select "ALL" on the bottom right. -> then click apply

You should be okay from their

Can it be that my SQL file is perhaps broken?
Because at dayz everything goes ..

http://up.picr.de/27401577rd.jpg
Nots Tables (mysql)
  • Offline Vapr0
  • Geared Up
  • **
  • Posts: 26

Re: Nots Tables (mysql)

« Reply #9 posted: Nov 11, 2016, 04:33 PM »
Can it be that my SQL file is perhaps broken?
Because at dayz everything goes ..

http://up.picr.de/27401577rd.jpg
Nots Tables (mysql)


possibly, it could just be that your missing a comma/semicolon or one of your scripts or .int file is incorrectly sending or receiving the data. i would try to compare and contrast older working back ups or other peoples scripts.

https://www.diffchecker.com/diff is a good site to compare and contrast scripts
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Nots Tables (mysql)

« Reply #10 posted: Nov 18, 2016, 11:39 PM »
Does it return with an error when you execute it?
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!