ODBC fail to connect. ODBC!EXEC failures, etc.

[12o]

After fighting with the nwnx version for Linux (and not knowing about nwnx_easy), I decided to try the easy version. Following the directions line for line, I got it to compile using the install shell script with -force, and the ./nwnstartup.sh seems to work just fine except for one small detail:

[Fireboar]

OnCreate failed? That could mean a few things:

- logs.0/nwnx_odbc.txt could not be created (i.e. no write permissions).
- There was an error in loading the configuration. Check logs.0/nwnx_odbc.txt to see if there's a line about it there.
- The functions could not be hooked properly.
- Connecting to the database failed. Again, logs.0/nwnx_odbc.txt will offer some clue as to why if this is the case.

So... paste the contents of nwnx_odbc.txt and all should become clear.

[12o]

Thanks, Fireboar. That pointed me in the right direction.

The problem is with the mysql.sock file. The version of MySQL I was using somehow wasn't creating a .sock file. NWNX couldn't connect to MySQL, but everything else could (not sure how). I completely removed the MySQL due to what I believe was a faulty install, reinstalled it, and now I can run mysqld and it generates the .sock file.

According to the logs file, NWNX is looking for the mysql.sock file in /tmp. However, on my system, mysql puts the file in /tmp/mysqld/mysql.sock. Everything on my pc looks for MySQL there and isn't configurable.

ATM, I'm looking at how NWNX can look for the mysql.sock file in the new place. Any ideas on how I can make nwnx look for /tmp/mysqld/mysql.sock?

---------------------------------------------------
UPDATE
---------------------------------------------------
NWNX does work if /tmp/mysqld/mysql.sock is set in /etc/my.cnf to /tmp/mysql.sock. However, the default installation directory was /tmp/mysqld/mysql.sock.

Just an FYI in case you ever want to incorporate a variable to set the location of the mysql.sock file in the nwnx.ini or other file.

[12o]

Okay. Fixed the problem permanently. Turns out it was a very easy fix.

The problem I was having was getting NWNX to see /tmp/mysqld/mysql.sock. This resulted in the ODBC not registering when ./nwnstartup.sh was executed.

I was unable to just move mysql.sock to /tmp or change the /etc/my.cnf file to the new location as I have other programs that look for the sock file in /tmp/mysqld/, and those can't be changed.

Creating a symbolic link worked. For anyone who might run into this problem: