| View previous topic :: View next topic |
| Author |
Message |
celtic3
Joined: 16 Jul 2005
Posts: 19
|
 Posted: Tue Feb 14, 2006 2:27 Post subject: HELP NWNX & Mysql 4.1 |
 |
|
I have Mysql Server 4.1 installed and working.
1. Made root user with password.
2. Made nwn database.
3. Made pwdata table in nwn database.
4. Gave root user all privledges to the nwn database.
This was done through the CMD (command prompt).
My NWNX.ini is as follows.
; NWNX2 configuration file
; These are the default values for NWNX2. Values specified on the command
; line take precedence.
[NWNX]
ServerPort = 5121
ModuleName = "NWN2 Cooperative"
WatchdogProcess = yes
UpdateIntervalProcess = 5
WatchdogGamespy = no
UpdateIntervalGamespy = 20
Gamespy Retries = 5
OldGamespyProtocol = no
RestartDelay = 5
[ODBC2]
; 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 = localhost:3306
user = root
pwd = Same as password when i setup MYSQL
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
[VAULTSTER]
Port = 5100
Path = C:\NeverwinterNights\NWN\servervault
Key = mykey
Password = mypassword
Startserver = 1
Validateclient = 1
Count = 1
Server1 = nwn.somehost.org
I can connect to Mysql with the CMD and MYSQL ADMINISTRATOR but not throught the NWNX APS_DEMO module.
Everytime I run aps_demo it says....
********* ********* ********* ********* ******
* Click sign: Create database table "pwdata" *
********* ********* ********* ********* ******
Table 'pwdata' deletted.
Table 'pwdata' created.
********* ********* ********* ********* **
* Click sign: Store variable in database *
********* ********* ********* ********* **
Stored 'testValue' in database.
********* ********* ********* ********* **
* Click sign Load variable from database *
********* ********* ********* ********* **
Retrived variable from database:
......... ......... ......... ......... ......... ......... ......... ......... ......... ......... ......... ......... ......... ......... ......... ......... ......... .........
Why isn't NWNX able to connect??
Please help me get this working anyone |
|
| Back to top |
|
 |
odenien
Joined: 26 Sep 2005
Posts: 37
|
| Posted: Tue Feb 14, 2006 14:55 Post subject: |
|
|
Have you tried connecting through native mysql in the demo mod?
| Code: | [Database]
server=localhost #name of the database server
user=<user> #username to access db
pass=<pwd> #password for username
db=nwn #database to connect to |
3306 should be the default mysql listening port and not needed. I would appear that if you are trying to connect using the ODBC add-on, you do not have the MySQL ODBC driver and/or the datasource "mysql" configured. |
|
| Back to top |
|
|
celtic3
Joined: 16 Jul 2005
Posts: 19
|
| Posted: Tue Feb 14, 2006 16:33 Post subject: Configure |
|
|
Please give me (Moron) step by step on this configuration of the odbc, which I assume is through the Admin tools under system dsn.
I tried selecting MYSQL SERVER but didn't know what to type in for it's settings.
Also by naitive you mean if I want to go naitive comment out the other settings in NWNX.ini and put these settings you show? |
|
| Back to top |
|
|
Acrodania
Joined: 02 Jan 2005
Posts: 208
|
| Posted: Tue Feb 14, 2006 17:50 Post subject: Re: Configure |
|
|
| celtic3 wrote: | Please give me (Moron) step by step on this configuration of the odbc, which I assume is through the Admin tools under system dsn.
I tried selecting MYSQL SERVER but didn't know what to type in for it's settings.
Also by naitive you mean if I want to go naitive comment out the other settings in NWNX.ini and put these settings you show? |
Your INI file posted above is already setup to use MYSQL Direct Connect. You should use it as its noticeably faster. The information you listed above should be fine, based on what you said you had done but remove the :3306 as it isn't needed. HOWEVER, if the actual layout of the pwdata table is incorrect the data transfer will fail.
Question remains, have you ran the demo module? Inside it are a couple of things including levers that will build the pwdata table for you (in its correct configuration), test adding data to it and test extracting data.
Verify you have a database named what you put in the INI file, verify your username and password again, and physically connect to the database via an external utility to be sure. MySQL-Front is a great external client but there are others also. Also try making the connection with the username root and NO password; MySQL uses that by default and I've seen it fail to set. You really should have a custom user just for this connection with full access to your nwn database and read only to the mysql authentication database.....
If it still doesn't work post the contents of your odbc, nwnx and server log files from your nwn/logs.0 directory so we can see what is happening..... |
|
| Back to top |
|
|
celtic3
Joined: 16 Jul 2005
Posts: 19
|
| Posted: Tue Feb 14, 2006 19:57 Post subject: ODBC, NWNX, and Logs.0 |
|
|
(ODBC)
********* ********* ********* ********* ********* *********
LOGIN TAB...
Data Source Name = nwn
Discription = NWN to Mysql
Server = blank
User = root
Password = as i typed it for the database in MYSQL Administrator
Database = nwn
Connect Options Tab...
Nothing entered
Advanced Tab...
Nothing entered
********* ********* ********* ********* ********* *********
In Administrative tools when i test the ODBC it reports
Success; connection was made!
(NWNX.ini)
********* ********* ********* ********* ********* *********
; NWNX2 configuration file
; These are the default values for NWNX2. Values specified on the command
; line take precedence.
[NWNX]
ServerPort = 5121
ModuleName = "NWN2 Cooperative"
WatchdogProcess = yes
UpdateIntervalProcess = 5
WatchdogGamespy = no
UpdateIntervalGamespy = 20
Gamespy Retries = 5
OldGamespyProtocol = no
RestartDelay = 5
[ODBC2]
; 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 = localhost:3306
user = root
pwd = as i typed it for the database in MYSQL Administrator
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
[VAULTSTER]
Port = 5100
Path = C:\NeverwinterNights\NWN\servervault
Key = mykey
Password = mypassword
Startserver = 1
Validateclient = 1
Count = 1
Server1 = nwn.somehost.org
********* ********* ********* ********* ********* *********
Logs.0
There are 2 logs here (nwserverError1) has nothing in it and the following.
nwserverLog1
********* ********* ********* ********* ********* *********
[Tue Feb 14 10:51:21] Loading Module: aps_demo
[Tue Feb 14 10:51:21]---- Server Options ----
Max Players: 6
Char Levels: (1-40)
Player Password: NO
DM Login Enabled: YES
Server Admin Login Enabled: YES
Post Game To Internet: YES
Game Type: Action
Difficulty: 2
PVP Setting: PARTY
Vault: LOCAL
Only One Party: YES
Enforce Legal Characters: YES
Item Level Restrictions: NO
Player pausing: DISABLED
Auto Save: Enabled
Saving Characters in Saved Game
---- End Server Options ----
Connection Attempt made by celtic3 (FTMK4YHF)
[Tue Feb 14 10:51:59] celtic3 (FTMK4YHF) Joined as Player 1
[Tue Feb 14 10:52:24] celtic3 Left as a Player (0 players left)
Connection Attempt made by celtic3 (FTMK4YHF)
[Tue Feb 14 10:53:12] celtic3 (FTMK4YHF) Joined as Player 1
[Tue Feb 14 10:53:40] celtic3 Left as a Player (0 players left)
[Tue Feb 14 10:54:10] Server Shutting Down |
|
| Back to top |
|
|
celtic3
Joined: 16 Jul 2005
Posts: 19
|
| Posted: Tue Feb 14, 2006 21:17 Post subject: Neverwinter nights / nwn folder |
|
|
Ok
Just in case I forgot/didn't know.
I have the following files in my NeverwinterNights/NWN folder
NWNX2.exe
madCHook.dll
nwnx-module.dll
nwnx_odbc.dll <---- ODBC2
Is there anything else that I dont have because I know the MYSQL is setup and running correct.
One funny note though.. When I click the signs for storeing testVariable as stated above nothing but as stated.
When I click the signs for storeing three objects it makes a NWN database but in the (Neverwinternights\NWN\Database) folder.
The three objects in the second chest are all plate mail objects, and the last sign creates an error:too many instructions |
|
| Back to top |
|
|
Xildjian
Joined: 08 Jan 2005
Posts: 100
|
|
| Back to top |
|
|
celtic3
Joined: 16 Jul 2005
Posts: 19
|
| Posted: Tue Feb 14, 2006 23:43 Post subject: Have you installed |
|
|
| Yes I have installed the ODBC 3.51 for mysql through the Administrative tools under the System DSN and the heading (ODBC) up above are those settings that I have set for it. I also have ODBC2 in the NWN folder. |
|
| Back to top |
|
|
Acrodania
Joined: 02 Jan 2005
Posts: 208
|
| Posted: Wed Feb 15, 2006 0:02 Post subject: Re: HELP NWNX & Mysql 4.1 |
|
|
| celtic3 wrote: |
; Use these five settings for MySQL connections
source = mysql
server = localhost:3306
user = root
pwd = Same as password when i setup MYSQL
db = nwn
|
First, these lines are saying to use MySQL DIRECT CONNECT. To use ODBC you need to comment those lines out and activate these lines like so:
| Quote: |
; Use these two settings for ODBC connections
source = odbc
dsn = nwn
|
However. You should have 4 (as in FOUR) log files, not two.
How are you starting NWServer? Are you clicking on the NWNX2.EXE file and then selecting your module? Or are you clicking on NWServer.exe or starting it from inside the client?
You HAVE to start the module via the NWNX2.EXE executable or it will not grab the memory space needed to hook into NWN.
If you ARE doing that, what OS are you running on? The MadChook library won't work on x64 platforms..... |
|
| Back to top |
|
|
celtic3
Joined: 16 Jul 2005
Posts: 19
|
| Posted: Wed Feb 15, 2006 0:16 Post subject: reply |
|
|
I am clicking on NWNX2.exe which has the module to load (aps_demo) in the NWNX.ini
I then start up NWN and goto play / multiplayer / lan game ect..
I am running Win2k and I've tried it with those line and commenting out the direct connect lines and still no luck.
I used Mysql Front and connected and yes there is a nwn database, and of course I had to use the password for mysqlfronts connection. |
|
| Back to top |
|
|
Acrodania
Joined: 02 Jan 2005
Posts: 208
|
| Posted: Wed Feb 15, 2006 3:59 Post subject: |
|
|
Do you have a "logs.1" directory in your NWN directory? If so delete it and try again, checking to see if the log files are created in your "logs.0" directory. It is common with a server crash to have a logs.1 directory created.
We need the ODBC and NWNX logs to go any further, they will tell us the particulars of what is happening..... |
|
| Back to top |
|
|
celtic3
Joined: 16 Jul 2005
Posts: 19
|
| Posted: Wed Feb 15, 2006 4:13 Post subject: Reloaded |
|
|
OK
I took out.................
Aps_Demo
nwnx.ini
nwnx_odbc.dll <-----ODBC2
NWNX2.exe
madCHook.dll
nwnx-module.dll
................................
Downloaded nwnx files from site and put them back in from this download.
Using nwnx.ini with the settings for odbc.....
; Use these two settings for ODBC connections
source = odbc
dsn = nwn
all others commented out.
Using Mysql odbc 3.51 with the following settings......
(ODBC)
********* ********* ********* ********* ********* *********
LOGIN TAB...
Data Source Name = nwn
Discription = NWN to Mysql
Server = blank
User = root
Password = as i typed it for the database in MYSQL Administrator
Database = nwn
Connect Options Tab...
Nothing entered
Advanced Tab...
Nothing entered
********* ********* ********* ********* ********* *********
Now it says .......
********* ********* ********* ********* ******
* Click sign: Create database table "pwdata" *
********* ********* ********* ********* ******
Table 'pwdata' deletted.
Table 'pwdata' created.
********* ********* ********* ********* **
* Click sign: Store variable in database *
********* ********* ********* ********* **
Stored 'testValue' in database.
********* ********* ********* ********* **
* Click sign Load variable from database *
********* ********* ********* ********* **
Retrived variable from database: <----no multiple periods after this now
When I click the last object signs it says retrived 0 objects.
I have the 4 files in log.0 and I see activity on the hard drive when I click a sign.
log.0 File nwnx.................................................................
NWN Extender V.2.6.1
(c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen
visit us at http://www.nwnx.org
* Loading plugins...
* Plugin leto is loaded.
* An error occured during OnCreate of odbc
* NWNX2 activated.
* NWNX2 shutting down...
* NWNX2 shutdown successfull.
..........................................................................................
log.0 File nwnx_odbc............................................................
NWNX ODBC2 plugin V.0.9.2.4
(c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen
visit us at http://www.nwnx.org
o Logfile maximum size limit is: 524288 bytes
o Log level: Everything will be logged.
o Using ODBC connection.
o Hooking SCO....hooked at 5c65d0
o Hooking RCO....hooked at 5c64b0
! Error while connecting to database: [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
o Got request: DROP TABLE pwdata
! SQL Error: [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
o Got request: CREATE TABLE pwdata (player varchar(64) NOT NULL default '~',tag varchar(64) NOT NULL default '~',name varchar(64) NOT NULL default '~',val text,expire int(11) default NULL,last timestamp NOT NULL default CURRENT_TIMESTAMP,PRIMARY KEY (player,tag,name)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
! SQL Error: [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
o Got request: SELECT player FROM pwdata WHERE player='celtic3' AND tag='Balor Afein' AND name='demoName'
! SQL Error: [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
o Empty set
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('celtic3','Balor Afein','demoName','testValue',0)
! SQL Error: [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
o Got request: SELECT val FROM pwdata WHERE player='celtic3' AND tag='Balor Afein' AND name='demoName'
! SQL Error: [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
o Empty set
o Disconnecting from database.
.............................................................................................
log.0 File nwserverError1............................................................
nothing in this file
.........................................................................................
log.0 File nwserverlog1............................................................
[Tue Feb 14 19:53:48] Loading Module: aps_demo
[Tue Feb 14 19:53:48]---- Server Options ----
Max Players: 6
Char Levels: (1-40)
Player Password: NO
DM Login Enabled: YES
Server Admin Login Enabled: YES
Post Game To Internet: YES
Game Type: Action
Difficulty: 2
PVP Setting: PARTY
Vault: LOCAL
Only One Party: YES
Enforce Legal Characters: YES
Item Level Restrictions: NO
Player pausing: DISABLED
Auto Save: Enabled
Saving Characters in Saved Game
---- End Server Options ----
Connection Attempt made by celtic3 (FTMK4YHF)
[Tue Feb 14 19:54:08] celtic3 (FTMK4YHF) Joined as Player 1
[Tue Feb 14 19:54:34] celtic3 Left as a Player (0 players left)
[Tue Feb 14 19:54:39] Server Shutting Down
.....................................................................................
Also the SQL log states.........
NWNX2 2f8-53c ENTER SQLAllocEnv
HENV * 07040024
NWNX2 2f8-53c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x07040024 ( 0x06d714f0)
NWNX2 2f8-53c ENTER SQLAllocConnect
HENV 06D714F0
HDBC * 07040028
NWNX2 2f8-53c EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 06D714F0
HDBC * 0x07040028 ( 0x06d71598)
NWNX2 2f8-53c ENTER SQLSetConnectAttr
SQLHDBC 06D71598
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0678FB1C
SQLINTEGER 0
NWNX2 2f8-53c EXIT SQLSetConnectAttr with return code 0 (SQL_SUCCESS)
SQLHDBC 06D71598
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0678FB1C (10)
SQLINTEGER 0
NWNX2 2f8-53c ENTER SQLConnectW
HDBC 06D71598
WCHAR * 0x06D716C8 [ -3] "nwn\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3
NWNX2 2f8-53c EXIT SQLConnectW with return code -1 (SQL_ERROR)
HDBC 06D71598
WCHAR * 0x06D716C8 [ -3] "nwn\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7C4AA0 [ -3] "******\ 0"
SWORD -3
DIAG [S1T00] [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO) (1045)
NWNX2 2f8-53c ENTER SQLGetDiagRecW
SQLSMALLINT 2
SQLHANDLE 06D71598
SQLSMALLINT 1
SQLWCHAR * 0x0678FAC4 (NYI)
SQLINTEGER * 0x0678FB08
SQLWCHAR * 0x06D72060 (NYI)
SQLSMALLINT 2048
SQLSMALLINT * 0x0678FB18
NWNX2 2f8-53c EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2
SQLHANDLE 06D71598
SQLSMALLINT 1
SQLWCHAR * 0x0678FAC4 (NYI)
SQLINTEGER * 0x0678FB08 (1045)
SQLWCHAR * 0x06D72060 (NYI)
SQLSMALLINT 2048
SQLSMALLINT * 0x0678FB18 (87)
NWNX2 2f8-53c ENTER SQLFreeEnv
HENV 06D714F0
NWNX2 2f8-53c EXIT SQLFreeEnv with return code -1 (SQL_ERROR)
HENV 06D714F0
DIAG [S1010] [Microsoft][ODBC Driver Manager] Function sequence error (0)
NWNX2 2f8-53c ENTER SQLFreeConnect
HDBC 06D71598
NWNX2 2f8-53c EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 06D71598
NWNX2 2f8-30c ENTER SQLFreeStmt
HSTMT 00000000
UWORD 0 <SQL_CLOSE>
NWNX2 2f8-30c EXIT SQLFreeStmt with return code -2 (SQL_INVALID_HANDLE)
HSTMT 00000000
UWORD 0 <SQL_CLOSE>
NWNX2 2f8-30c ENTER SQLExecDirect
HSTMT 00000000
UCHAR * 0x08057288 [ -3] "DROP TABLE pwdata\ 0"
SDWORD -3
NWNX2 2f8-30c EXIT SQLExecDirect with return code -2 (SQL_INVALID_HANDLE)
HSTMT 00000000
UCHAR * 0x08057288 [ -3] "DROP TABLE pwdata\ 0"
SDWORD -3
NWNX2 2f8-30c ENTER SQLErrorW
HENV 00000000
HDBC 00000000
HSTMT 00000000
WCHAR * 0x0012FB20 (NYI)
SDWORD * 0x0012FB58
WCHAR * 0x0012F720
SWORD 512
SWORD * 0x0012FB56
NWNX2 2f8-30c ENTER SQLFreeStmt
HSTMT 00000000
UWORD 0 <SQL_CLOSE>
NWNX2 2f8-30c EXIT SQLFreeStmt with return code -2 (SQL_INVALID_HANDLE)
HSTMT 00000000
UWORD 0 <SQL_CLOSE>
NWNX2 2f8-30c ENTER SQLExecDirect
HSTMT 00000000
UCHAR * 0x080573B0 [ -3] "CREATE TABLE pwdata (player varchar(64) NOT NULL default '~',tag varchar(64) NOT NULL default '~',name varchar(64) NOT NULL default '~',val text,expire int(11) default NULL,last timestamp NOT NULL default CURRENT_TIMESTAMP,PRIMARY KEY (player,tag,name)) ENGINE=MyISAM DEFAULT CHARSET=latin1;\ 0"
SDWORD -3
NWNX2 2f8-30c EXIT SQLExecDirect with return code -2 (SQL_INVALID_HANDLE)
HSTMT 00000000
UCHAR * 0x080573B0 [ -3] "CREATE TABLE pwdata (player varchar(64) NOT NULL default '~',tag varchar(64) NOT NULL default '~',name varchar(64) NOT NULL default '~',val text,expire int(11) default NULL,last timestamp NOT NULL default CURRENT_TIMESTAMP,PRIMARY KEY (player,tag,name)) ENGINE=MyISAM DEFAULT CHARSET=latin1;\ 0"
SDWORD -3
NWNX2 2f8-30c ENTER SQLErrorW
HENV 00000000
HDBC 00000000
HSTMT 00000000
WCHAR * 0x0012FB20 (NYI)
SDWORD * 0x0012FB58
WCHAR * 0x0012F720
SWORD 512
SWORD * 0x0012FB56
NWNX2 2f8-30c ENTER SQLFreeStmt
HSTMT 00000000
UWORD 0 <SQL_CLOSE>
NWNX2 2f8-30c EXIT SQLFreeStmt with return code -2 (SQL_INVALID_HANDLE)
HSTMT 00000000
UWORD 0 <SQL_CLOSE>
NWNX2 2f8-30c ENTER SQLExecDirect
HSTMT 00000000
UCHAR * 0x07F30C10 [ -3] "SELECT player FROM pwdata WHERE player='celtic3' AND tag='Balor Afein' AND name='demoName'\ 0"
SDWORD -3
NWNX2 2f8-30c EXIT SQLExecDirect with return code -2 (SQL_INVALID_HANDLE)
HSTMT 00000000
UCHAR * 0x07F30C10 [ -3] "SELECT player FROM pwdata WHERE player='celtic3' AND tag='Balor Afein' AND name='demoName'\ 0"
SDWORD -3
NWNX2 2f8-30c ENTER SQLErrorW
HENV 00000000
HDBC 00000000
HSTMT 00000000
WCHAR * 0x0012FB20 (NYI)
SDWORD * 0x0012FB58
WCHAR * 0x0012F720
SWORD 512
SWORD * 0x0012FB56
NWNX2 2f8-30c ENTER SQLFetch
HSTMT 00000000
NWNX2 2f8-30c EXIT SQLFetch with return code -2 (SQL_INVALID_HANDLE)
HSTMT 00000000
NWNX2 2f8-30c ENTER SQLFreeStmt
HSTMT 00000000
UWORD 0 <SQL_CLOSE>
NWNX2 2f8-30c EXIT SQLFreeStmt with return code -2 (SQL_INVALID_HANDLE)
HSTMT 00000000
UWORD 0 <SQL_CLOSE>
NWNX2 2f8-30c ENTER SQLExecDirect
HSTMT 00000000
UCHAR * 0x07F1EDD8 [ -3] "INSERT INTO pwdata (player,tag,name,val,expire) VALUES('celtic3','Balor Afein','demoName','testValue',0)\ 0"
SDWORD -3
NWNX2 2f8-30c EXIT SQLExecDirect with return code -2 (SQL_INVALID_HANDLE)
HSTMT 00000000
UCHAR * 0x07F1EDD8 [ -3] "INSERT INTO pwdata (player,tag,name,val,expire) VALUES('celtic3','Balor Afein','demoName','testValue',0)\ 0"
SDWORD -3
NWNX2 2f8-30c ENTER SQLErrorW
HENV 00000000
HDBC 00000000
HSTMT 00000000
WCHAR * 0x0012FB20 (NYI)
SDWORD * 0x0012FB58
WCHAR * 0x0012F720
SWORD 512
SWORD * 0x0012FB56
NWNX2 2f8-30c ENTER SQLFreeStmt
HSTMT 00000000
UWORD 0 <SQL_CLOSE>
NWNX2 2f8-30c EXIT SQLFreeStmt with return code -2 (SQL_INVALID_HANDLE)
HSTMT 00000000
UWORD 0 <SQL_CLOSE>
NWNX2 2f8-30c ENTER SQLExecDirect
HSTMT 00000000
UCHAR * 0x07F30C78 [ -3] "SELECT val FROM pwdata WHERE player='celtic3' AND tag='Balor Afein' AND name='demoName'\ 0"
SDWORD -3
NWNX2 2f8-30c EXIT SQLExecDirect with return code -2 (SQL_INVALID_HANDLE)
HSTMT 00000000
UCHAR * 0x07F30C78 [ -3] "SELECT val FROM pwdata WHERE player='celtic3' AND tag='Balor Afein' AND name='demoName'\ 0"
SDWORD -3
NWNX2 2f8-30c ENTER SQLErrorW
HENV 00000000
HDBC 00000000
HSTMT 00000000
WCHAR * 0x0012FB20 (NYI)
SDWORD * 0x0012FB58
WCHAR * 0x0012F720
SWORD 512
SWORD * 0x0012FB56
NWNX2 2f8-30c ENTER SQLFetch
HSTMT 00000000
NWNX2 2f8-30c EXIT SQLFetch with return code -2 (SQL_INVALID_HANDLE)
HSTMT 00000000 |
|
| Back to top |
|
|
celtic3
Joined: 16 Jul 2005
Posts: 19
|
| Posted: Wed Feb 15, 2006 4:24 Post subject: WORKS |
|
|
Ok it works now why I dont know but...
all I changed from above was to make it direct access.........
[ODBC2]
; 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 = localhost
user = root
pwd = dr01745329
db = nwn
; Set hookscorco to false if you want to disable hooking of
; StoreCampaignObject and RetrieveCampaignObject entirely
hookscorco = true
What went wrong where I had to reinstall and why |
|
| Back to top |
|
|
Acrodania
Joined: 02 Jan 2005
Posts: 208
|
| Posted: Wed Feb 15, 2006 4:44 Post subject: |
|
|
Good question.... At least its working, right?
Its possible that you had one of the DLLs not extract from the ZIP file correctly or something.....
As for it working right under direct connect and not previously, the error message in the ODBC log showed that the ODBC connection was rejected. So that was something to do with the ODBC setup. You are better off with Direct Connection anyways, its faster. |
|
| Back to top |
|
|
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Fri Feb 17, 2006 21:35 Post subject: |
|
|
| Quote: | | Access denied for user 'ODBC'@'localhost' (using password: NO) |
This is the key information here. Looks like the ODBC connection you have set up does not transmit a password to MySQL, which in turn rejects the connection because of that.
I agree with Acrodania, you would be better of with removing the ODBC connection in windows and configuring NWNX.INI to use the direct MySQL connection method. It's easier and more straight forward to do it this way.
Please do so and post your logs again if it still won't work.
_________________
Papillon |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
