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 
 
Some strange problem with ODBC ... can someone help ... ?

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



Joined: 20 Jun 2007
Posts: 3

PostPosted: Wed Jun 20, 2007 17:43    Post subject: Some strange problem with ODBC ... can someone help ... ? Reply with quote

Hello,

I have encountered some problems running the NWNX2 so I guessed this is the right place to ask for help Smile

I am trying to run NWNX2 on the following system :

Debian Linux
Mysql 5.0.32
Standalone Linux Server 1.68

and trying to run NWNX2 directly with mysql (I obviously do not want ODBC under linux)

Everything seem ok - here is the data from the loader :

Code:

NWNX2lib: Init
NWNX2lib: org SetString() at 0x81f1660, new SetString() at 0xb7f0811a
* Parsing configuration...
NWN Extender v2.5.3-rc1
(c) 2004 by the APS/NWNX Linux Conversion Group
Based on the Win32 version (c) 2003 by Ingmar Stieger (Papillon)
and Jeroen Broekhuizen
visit us at http://www.avlis.org

* Loading modules...
[ODBC2] SetDebugLevel(3) called.  Current value=0
ERROR: ODBC: OnCreate() failed.

* NWNX2 activated.
Neverwinter Nights Server
Build:8099
Copyright BioWare Corp 1998-2004

Server: Loading...
Server: Running...

Server: Loading module "eloria"...................................................................................................................................................
Server: Module loaded
INIT: valid ret=0x0820149c
* Library ODBC!SPACER does not exist.
* Library ODBC!EXEC does not exist.
* Library ODBC!FETCH does not exist.


but I am frustrated by the 3 missing Libraries

I downloaded odmbc and ran
Code:
 ./configure --with-extraplugins="odmbc"

then
Code:
make install


and everything looked ok

copied the nwnx_odbc.so to the directory of nwnx2 (it is the same as the standalone server), but I continue receiving these errors.

The server appear running, then 4-5 seconds after loadin the module the
Code:
* Library ODBC!SPACER does not exist.
* Library ODBC!EXEC does not exist.
* Library ODBC!FETCH does not exist.

pops up.

Server Logs :

nwnx2.txt

Code:
NWN Extender v2.5.3-rc1
ERROR: ODBC: OnCreate() failed.
* NWNX2 activated.
INIT: valid ret=0x0820149c
* Library ODBC!SPACER does not exist.
* Library ODBC!EXEC does not exist.
* Library ODBC!FETCH does not exist.



nwnx_odmbc.txt
Code:
NWNX2 ODBC2 version 0.1.0 for Linux.
(c) 2005 by dumbo (dumbo@nm.ru)
o Critical Error: Section [ODBC2] not found in NWNX.INI
o Shutdown.


Any Ideas ???
Back to top
View user's profile Send private message
TaBuPeH



Joined: 20 Jun 2007
Posts: 3

PostPosted: Wed Jun 20, 2007 18:54    Post subject: Reply with quote

I forgot the nwnx2.ini

[NWNX]
disablenwnxinit=n #Set to "y" to not enforce the NWNX!INIT requirement

[Database]
source = mysql
server=localhost #name of the database server
user=****** #username to access db
pass=****** #password for username
db=nwn #database to connect to

[Debug]
debuglevel=3 #Set to 1 or higher to output successively
# # verbose debug information

[LogDir]
logdir=logs.0 #Set to the relative root of the log directory.
Back to top
View user's profile Send private message
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1060
Location: Germany

PostPosted: Fri Jun 22, 2007 11:46    Post subject: Reply with quote

You might need to init NWNX on Linux first. There is a function that needs to be called on module load, please have a look at the documentation.
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
dumbo



Joined: 21 Aug 2005
Posts: 21

PostPosted: Mon Jun 25, 2007 21:04    Post subject: Re: Some strange problem with ODBC ... can someone help ... Reply with quote

TaBuPeH wrote:

nwnx_odmbc.txt
NWNX2 ODBC2 version 0.1.0 for Linux.
(c) 2005 by dumbo (dumbo@nm.ru)
o Critical Error: Section [ODBC2] not found in NWNX.INI
o Shutdown.

Any Ideas ???


replace "[Database]" with "[ODBC2]".
Back to top
View user's profile Send private message
TaBuPeH



Joined: 20 Jun 2007
Posts: 3

PostPosted: Wed Jun 27, 2007 13:49    Post subject: Reply with quote

10x a lot for the help

Everything actually worked when i added the following line to nwnstartup.sh

export LD_PRELOAD=./nwnx_odbc.so

and made the modifications suggested by dumbo Smile

10x guys u r the best.
Back to top
View user's profile Send private message
framerate



Joined: 26 Jun 2007
Posts: 4

PostPosted: Thu Jul 12, 2007 20:47    Post subject: Re: Some strange problem with ODBC ... can someone help ... Reply with quote

dumbo wrote:
TaBuPeH wrote:

nwnx_odmbc.txt
NWNX2 ODBC2 version 0.1.0 for Linux.
(c) 2005 by dumbo (dumbo@nm.ru)
o Critical Error: Section [ODBC2] not found in NWNX.INI
o Shutdown.

Any Ideas ???


replace "[Database]" with "[ODBC2]".


This just caught me up when looking at documentation on the site. The site DOES say to use "Database". My nwnx2.ini has a section called "Database" and none for "ODBC2". I'm reading and writing to my MySQL DB just fine...

Confused? Me too.
Back to top
View user's profile Send private message
FunkySwerve



Joined: 02 Jun 2005
Posts: 377

PostPosted: Thu Jul 12, 2007 23:52    Post subject: Reply with quote

[ODBC] for Lin, [Database] for Win. That's how it is, just don't ask me why. Razz
Funky
Back to top
View user's profile Send private message
framerate



Joined: 26 Jun 2007
Posts: 4

PostPosted: Fri Jul 13, 2007 15:55    Post subject: Reply with quote

FunkySwerve wrote:
[ODBC] for Lin, [Database] for Win. That's how it is, just don't ask me why. Razz
Funky


Right, but I'm using "[Database]" for linux and it works >.>
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Linux 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