logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
! SQL Error: no such table: pwdata

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Windows technical support
View previous topic :: View next topic  
Author Message
Xaim



Joined: 07 Aug 2005
Posts: 4

PostPosted: Sun Aug 07, 2005 21:26    Post subject: ! SQL Error: no such table: pwdata Reply with quote

So, i have problem in nwnx_odbc.txt ,,, and sorry, for me bad eng.

I have install this :

- mySQL 4.0.25 for Windows
- mySQL ODBC driver 3.51 for Windows
- mySQL MySQL Administrator 1.0
- PRC SERVER PACK (NWNX/APS verze 2.6.1)

I did not use your manual for install, but one in czech languare.

When i have install 4.0.25, so run (C:\mysql\bin\winmysqladmin.exe) program in first run ask me to name and password (this name a password =pwd i donīt use i other setting)

In MySQL Administrator 1.0 i login as root on localhost (i donīt need pwd)

I create new catalog, schema : gwaintharr

In schema gwaintharr create new table : pwdata ,,, and insert all culomn :

Code:
CREATE TABLE `gwaintharr`.`pwdata` (
  `player` varchar(64) NOT NULL,
  `tag` varchar(64) NOT NULL,
  `name` varchar(64) NOT NULL,
  `text` text NOT NULL,
  `expire` INTEGER NOT NULL,
  `last` timestamp(14))
)
ENGINE = MYISAM;


I canīt write collomn with " KEY idx (player,tag,name)" becose it have error, i text insert it from txt : mysql -u gwaintharr -p gwaintharr < db.txt ,,, bud donīt write this cullom too.

So when i have schema and table i go create new user : gwaintharr ,,, with pwd for examle : 111

But need to create gwaintharr@localhost, so creat it and define for schema : gwaintharr ,,, give all privileges

It all in MySQL Administrator 1.0 so we can close it

I run OBDC config and ADD in User DNS :

DataSourceName : nwn
Server : localhost
User : gwaintharr
Heslo : 111
Database : gwaintharr

Test : Success, connection was made!

So when i run server, nwnx.txt :

Code:
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.
* Plugin odbc is loaded.
* NWNX2 activated.
* NWNX2 shutting down...
* NWNX2 shutdown successfull.


nwnx_leto.txt :

Code:
NWNX-Leto module (build 03 - FF)
(c) 2004 by David Frauzel (dragonsong), dragon@weathersong.net
Information and support: http://weathersong.infopop.cc

* Loading LetoScript.dll...
* LetoScript metamodule activated (52.92ms).


nwnx_odbc.txt :

Code:
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 SQLite connection.
o Hooking SCO....hooked at 5c65d0
o Hooking RCO....hooked at 5c64b0
o Connect successful.
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='sh_prcpostava'
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='cdkey'
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='sh_zivoty'
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='novacek'
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='sh_prcpostava'
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='cdkey'
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='sh_zivoty'
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='novacek'
! SQL Error: no such table: pwdata
o Disconnecting from database.


nwnx.ini :

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

[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 = gwaintharr
pwd = 111
db = gwaintharr

; 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


I test other setting, for example ;source = mysql or all setting in mySQL ";" ... but BUG : ! SQL Error: no such table: pwdata ;(((

I donīt know were is problem, but i have few question.

Why sametimes i donīt have this file in \Log.0 : nwnx.txt; nwnx_leto.txt; nwnx_odbc.txt but in root of hdd : D:\ ,,, becose i have D:\Hry\NWN and this log be in \Log.0 ,,, this i look when edit nwnx.ini, sametime

Can be problem when i install PRC Server Pack and donīt instaled NWNX 2.53 ? becose i look for missing in archive : aps_253\madCodeHookLib.dll ,,, i donīt have it, but i copy in root this file ,,, bug stil here ,,, and in \SRC\ i have only files from PRC Server Pack, so i look on aps_253 archive an they have many files and a i donīt have it ,,, so i copy, bud never change.

In screenschot, admin is litle bug ,,, i import table from db.txt of your web : CREATE TABLE pwdata (player varchar(64) default NULL, tag varchar(64) default NULL, name varchar(64) default NULL, val text, expire int(11) default NULL, last timestamp(14) NOT NULL, KEY idx (player,tag,name));

and i can see NULL or NOT NUL in admin ,,, but i have old screen from table for NWNX 2.53

Sorry, for me bad eng.

Screeshot :





Xaim
Back to top
View user's profile Send private message
Acrodania



Joined: 02 Jan 2005
Posts: 208

PostPosted: Sun Aug 07, 2005 22:44    Post subject: Reply with quote

Your problem is right here:

Code:


[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 = gwaintharr
pwd = 111
db = gwaintharr

The NWNX.INI file reads the FIRST database entry it finds. Yours is set to SOURCE=sqlite......

Comment out these lines like this:

Code:


; Use these two settings for the SQLite internal database
;source = sqlite
;file   = sqlite.db



and you should be good to run MySQL Direct Connection....

PS-With MySQL Direct Connection you don't even need the ODBC drivers loaded. But its good to know they work, it means your user is setup correctly Smile
Back to top
View user's profile Send private message
Xaim



Joined: 07 Aug 2005
Posts: 4

PostPosted: Sun Aug 07, 2005 22:54    Post subject: Reply with quote

you have right, bingo

Code:
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='sh_prcpostava'
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='cdkey'
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='sh_zivoty'
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='novacek'
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='sh_prcpostava'
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='cdkey'
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='sh_zivoty'
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='NW_COMMALE' AND name='novacek'


So i realy blind, very fnx Wink
Back to top
View user's profile Send private message
Xaim



Joined: 07 Aug 2005
Posts: 4

PostPosted: Sun Aug 07, 2005 23:20    Post subject: Reply with quote

Acrodania wrote:


and you should be good to run MySQL Direct Connection....

PS-With MySQL Direct Connection you don't even need the ODBC drivers loaded. But its good to know they work, it means your user is setup correctly Smile


How ? i can run MySQL Direct Connection ?
Back to top
View user's profile Send private message
Acrodania



Joined: 02 Jan 2005
Posts: 208

PostPosted: Sun Aug 07, 2005 23:30    Post subject: Reply with quote

These lines tell NWNX to use ODBC:

Code:

; Use these two settings for ODBC connections
;source = odbc
;dsn    = nwn


These lines tell it to use Direct Connect:
Code:

; Use these five settings for MySQL connections
source = mysql
server = localhost
user = gwaintharr
pwd = 111
db = gwaintharr


You already ARE using Direct Connection Razz
Back to top
View user's profile Send private message
Xaim



Joined: 07 Aug 2005
Posts: 4

PostPosted: Sun Aug 07, 2005 23:47    Post subject: Reply with quote

So, it great, fnx Cool
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Windows technical support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group