[SOLVED] ODBC error after running nwnstartup.sh

[David]

I've been trying to install a dedicated nwn server on Ubuntu 12.04 LTS 32-bits and ran against an issue I cannot solve myself. After I run nwnstartup.sh, I encounter the following error:

[eeriegeek]

Hey,

Run the command "locate libstdc++.so" on your system and show the output. Have you build your own NWNX or downloaded a pre-built one? I suspect you have a pre-built one that may be built against an older version of the C++ library that doesn't exist on your system. If so, you will likely need to build your own NWNX (not too hard) or find someone who has already built one for ubuntu 12.

Update: see this: http://nwnx.org/phpBB2/viewtopic.php?t=2152

[David]

I was just taking a look at that topic, eeriegeek. During my first attempt at installing nwnx, I used this guide: http://www.nwnx.org/index.php?id=doc_nwnx_linux. The one made by Squatting Monk, the one you linked, did a better job in my opinion. When I run nwnstartup.sh now, I get the following output:

[David]

I disabled nwnx_odmbc_mysql.so, a module that came with compiling nwnx and installed, instead, nwnx_odbc.so. This module didn't come on its own after compiling; I had to get it myself from http://www.nwnx.org/index.php?id=nwnx2. This got rid of the 'OnCreate() failed' error. Persistent variables aren't stored in the database yet, though. So there must be something else I'm not doing right. I'll keep working on it and will post whatever I find out in this topic.

Update: I tried installing the pwdata table while inside the aps_demo.mod. It said it'd worked, but after logging in on the database the table wasn't there. The nwnx_odbc.txt logging looks as follow:

[David]

Alright, I got everything working:
1) I installed nwnx with mysql through this guide: http://nwnx.org/phpBB2/viewtopic.php?t=2152;
2) I changed localhost in nwnstartup.sh to 127.0.0.1;
3) I removed the nwnx_odmbc_mysql.so module and replaced it with nwnx_odbc.so, which I got here: http://www.nwnx.org/index.php?id=doc_nwnx_linux;
4) I did not use aps_demo to create the pwdata table, but did so myself!

Good luck folks, I'll continue working on my server now.

[eeriegeek]

This confuses lots of people including me the first time around.

What you want to do is _rename_ the new shared library file that you just built (nwnx_odmbc_mysql.so) to (nwnx_odbc.so). Under linux it's should just be: