New NWNx mySQL Plugin

Arcsylver · Post by **Arcsylver** » Thu Jul 22, 2004 6:44 pm

I have installed and set up this plugin as per the instructions.

The thing is I have no idea how to tell if it is working or not.

Anyone who has set this up mind giving this SQL idiot some pointers?

The problem we are having is that any time we try to write anything to the database the server client locks and crashes forcing a module reload.

Not sure what is wrong and we desperately need help on this.

Post by **Orleron** » Thu Jul 22, 2004 10:52 pm

Make sure you changed the plugin name to nwnx_odbc.dll and that you have the msql library dll that came with the rar file. Both those dll's should be in your nwn directory, and your configuration file should be tailored to your own parameters in nwnx_mysql.ini.

If your module doesn't crash and it seems to work exactly as it did before, then it's working. If not, send Jeroen a PM.

Arcsylver · Post by **Arcsylver** » Fri Jul 23, 2004 7:33 am

That's just it. I did exactly what you suggested because that is what the readme tells you to do.

The only difference that there was, was that I had the install on drive D instead of drive C.

But the instant that a DM tried to place a spawn in the database from in game the Server would freeze and crash.

Will have to send J a PM

Post by **Orleron** » Fri Jul 23, 2004 7:55 am

Without the database being connected, your server would run, but you'd be frozen as soon as you logged in as a player, and you'd get a couple of TMI errors. If you didn't see that, then your MySQL plugin is probably working. You might want to consider that it's your spawn system that's crashing your server and not the plugin.

Arcsylver · Post by **Arcsylver** » Fri Jul 23, 2004 9:43 am

Funny you mention those TMI errors

I removed the plugin files and tried it using just the ODBC and got those errors.

It doesnt give them with the plugin installed. If I am using the plugin do I even need the ODBC drivers installed?

There isnt a lot of info on setting up the plugin other than to put the files in the NWN directory and to rename the DLL to ODNC instead of mysql.

Jeff · Post by **Jeff** » Fri Jul 23, 2004 10:47 am

Arcsylver wrote:Funny you mention those TMI errors

I removed the plugin files and tried it using just the ODBC and got those errors.

It doesnt give them with the plugin installed. If I am using the plugin do I even need the ODBC drivers installed?

There isnt a lot of info on setting up the plugin other than to put the files in the NWN directory and to rename the DLL to ODNC instead of mysql.

I could be wrong, but I don't think you can just rename a dll and expect that to change anything. If anything it's going to make matters worse.

Get the original dll for both mysql and odbc, then use the one your trying to test with.

Arcsylver · Post by **Arcsylver** » Fri Jul 23, 2004 12:56 pm

Well that would be fine Jeff except that the instructions for installing the mysql plugin say to rename the .dll from nwnx_odbc.dll to nwnx_mysql.dll to prevent and conflicts with things that look for the odbc files.

I dunno, I got another problem now with the darn mysql service refusing to stay started so I cant figure this out firther until I get THAT problem fixed AGAIN.

If this doesn't start working soon I am likely to say to heck with the whole thing and give up on NT ever going fully live since I cant get the NWNx stuff to work and it is required for CoPaP

Arcsylver · Post by **Arcsylver** » Sun Jul 25, 2004 2:02 pm

First off apologies for my venting my earlier frustration.

Second, I have the Plugin working. It seems that at least on this machine, when I went to set up the database and everything it did not want to work properly unless the NWNx files were already in place before I set up the connection between NWNx and mySQL.

Our database is now recording data and seems to be in perfect working order finally.

Now to figure out the problem with the spawn system.......*goes back to slaving away to get the world working*