Nsmysql FAQ
Here is the list of Frequently Asked Questions (FAQ) for the Panoptic MySQL driver for AOLserver, or, nsmysql.
General nsmysql Questions:
Q: Why are table names being prepended to the column names in my result set?
A: Dumb decision that was made around v0.5 and v0.6. To turn the behavior off, change the following line in mysql.c:
static int include_tablenames = 1;
to
static int include_tablenames = 0;
Sorry about that.
Win32 Related Questions:
Q: I get this strange "win32 error code: 126" error in my server.log. What does it mean?
A: You're seeing something like this in your server log:
Warning: modload: failed to load 'x:/path/to/aolserver/bin/nsmysql.so': 'Win32 error code 126'
Error 126 is MOD_NOT_FOUND. Does nsmysql.so exist in the directory specified by x:/path/to/aolserver/bin?
Q: I get this strange "win32 error code: 1157" error in my server.log. What does it mean?
A: You're seeing something like this in your server log:
Notice: loading: x:/path/to/aolserver/bin/nsmysql.so Warning: could not load x:/path/to/aolsever/bin/nsmysql.so: win32 error code: 1157 Error: nsd.db: could not load driver: mysql
Chances are, this means you didn't copy the libmySQL.dll into your aolserver/bin directory. This is LoadLibrary()'s way of saying that there were unresolved symbols when trying to dynamically load nsmysql.so, which is a DLL. nsmysql.so is linked against libmySQL.dll, therefore it too needs to be loadable, and the easiest way to do this is to stick it in the aolserver/bin directory.