| View previous topic :: View next topic |
| Author |
Message |
12o
Joined: 27 Dec 2008
Posts: 35
|
 Posted: Mon May 13, 2013 1:17 Post subject: Can't find MySQL |
 |
|
So after about a year of being too busy to work with NWN, I finally caught a break in some time to put together a test server. Problem is, nwnx2 can't seem to find the MySQL server. Logins and passwords are set up and able to log in. But when I go to run the aps_demo module to test connectivity, I get an error. The error I get in nwnx_odmbc.txt is basically:
| Code: | Critical Error: Datasource must be MySQL or SQLite.
Shutdown |
I'm using the MySQL that comes with LAMPP as it's basically already set up with phpmyadmin. I have to use the precompiled nwnx2.so and nwnx_odbc.so files as Arch Linux does not have a zlib-devel package and installing via RPM doesn't seem to work.
I set up the nwnstartup.sh file with the export statement:
| Code: | export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/lampp/lib/mysql
export LD_PRELOAD=./nwnx2.so |
which is where the file is for LAMPP. I configured the nwnx2.ini file, and made sure that the module was set to MySQL and even have the aps_onload set with
| Code: | #include "aps_include"
void main()
{
//Init placeholders for ODBC gateway
SQLInit();
GetLocalObject(GetModule(), "NWNX!INIT");
}
|
as was mentioned in previous posts in the forums for the precompiled package.
Problem is that I still can't figure out what more I need to configure in order to get NWNX to locate the MySQL server that's running on the localhost. What else needs to be configured? I've tried to set the nwnx2.ini server to "localhost" and the actual IP address. When I check the connection logs for MySQL, there's not even one attempt. This obviously means that nwnx can't find MySQL.
I've also double-checked that the mysql.sock file is in the right place, and my.cnf is set up. Still nothing.
Anyone else try using LAMPP with NWNX that might have a set of steps to follow? Any help is greatly appreciated. Thank you in advance. |
|
| Back to top |
|
 |
virusman
Joined: 30 Jan 2005
Posts: 1020
Location: Russia
|
| Posted: Mon May 13, 2013 8:06 Post subject: |
|
|
Do you have
source=mysql
in your nwnx2.ini?
_________________
In Soviet Russia, NWN plays you! |
|
| Back to top |
|
|
12o
Joined: 27 Dec 2008
Posts: 35
|
| Posted: Mon May 13, 2013 18:20 Post subject: |
|
|
| virusman wrote: | Do you have
source=mysql
in your nwnx2.ini? |
And that fixed it. Dang! That's awesome! Do you use the Force or what? 
I did notice one thing in the nwnx2.ini file. At one point, the logs were telling me that it couldn't find [ODBC2]. I looked in the file and saw [Database]. Does that signify an older, outdated version of NWNX? Or am I using the right system? |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
