Edit: The story is I downloaded NWNX Core but missed the plugin NWNX ODBC. I installed ODBC plugin and it is currently working. Thank you for reading.
I weeded my all my hair of my head. In the moment really can’t connect NWNX2 to MySQL.
I used to run my server using NWNX2 and MySQL with no problems in 2014. I think I am correctly but I may be missing something for now. Can you help me to remember properly what things may I miss?
I did create the database “nwnserver”, with user “nwnserver” (all privileges) and pw “nwnserver”.
The database contains correctly pwdata table.
The NWNX.ini is:
; NWNX2 configuration file
; These are the default values for NWNX2. Values specified on the command
; line take precedence.
ServerPort = 5121
ModuleName = “Secret”
WatchdogProcess = yes
UpdateIntervalProcess = 5
WatchdogGamespy = no
UpdateIntervalGamespy = 20
GamespyRetries = 5
OldGamespyProtocol = no
RestartDelay = 6
; Log file
MaxLogSize = 512 ; in KByte
LogLevel = 2 ; 0=nothing, 1=only errors, 2=everything
; Use these two settings for the SQLite internal database
;source = sqlite
;file = sqlite.db
; Use these two settings for ODBC connections
;source = odbc
;dsn = nwn
; Use these five settings for MySQL connections
source = mysql
server = localserver
user = nwnserver
pwd = nwnserver
db = nwnserver
; Set hookscorco to false if you want to disable hooking of
; StoreCampaignObject and RetrieveCampaignObject entirely
hookscorco = true
MaxLogSize = 9512 ; in KByte
LogLevel = 1 ; 1=overall statistics, 2=full script callstack
Actually I have opened the port 3306 in my Windows 10 firewall. Actually it is not working. I’ve spent hours on it and nothing.
Can you help me?