Trying to follow data NWN => MySQL and back

[DM_GoodTime]

ok i change my nwnx.ini and the server crashes when i click on the sign in the aps_demo.mod

this my nwnx.ini


; NWNX2 configuration file
; These are the default values for NWNX2. Values specified on the command
; line take precedence.

[NWNX]
ServerPort = 5121
ModuleName = "aps_demo"
WatchdogProcess = yes
UpdateIntervalProcess = 5
WatchdogGamespy = no
UpdateIntervalGamespy = 20
GamespyRetries = 5
OldGamespyProtocol = no
RestartDelay = 5

[ODBC2]
; Log file
MaxLogSize = 512 ; in KByte
LogLevel = 2 ; 0=nothing, 1=only errors, 2=everything



;Use these five settings for MySQL connections
source = myodbc
server = localhost
user = root
pwd =xxxxxxxxx
db = NWN

; Set hookscorco to false if you want to disable hooking of
; StoreCampaignObject and RetrieveCampaignObject entirely
hookscorco = true

[PROFILER]
MaxLogSize = 512 ; in KByte
LogLevel = 1 ; 1=overall statistics, 2=full script callstack









this my log.0 nwnx_odbc

o Critical Error: Datasource must be MySQL, ODBC, or SQLite.
o Got request: DROP TABLE pwdata



sorry guys i have no clue what im doing lol

[Papillon]

Hmm, it would have been easier to use the original nwnx.ini and edit your connection parameters there. What kind of ini file is that ? It does not even contain the SQLite database option.

As the logfile clearly states, you cannot specify "myodbc" as the source, it has to be "MySQL". Also make sure you setup a mysql user and password and add the login information accordingly, e.g.

[Gryphyn]

Your other trace option is the one provided by your ODBC driver.
There should be a 'Trace' option you can select. Any database requests/responses will be logged to a textfile.

Cheers
Gryphyn

[DM_GoodTime]

hey thanks guys i got it working lol i had to the db= nwn in caps lol plus i was seting the odbc driver which i didnt need which i knew i didnt need when it wasnt working i added it thinking i need it it just the caps that all thank u for the help lol

[Papillon]

Uh... yeah, your're welcome and such. lol.
_________________
Papillon