Spawning probs

Kaosodin · Post by **Kaosodin** » Wed Sep 19, 2007 6:09 pm

tried re-installing and removing and installing, same error.

Kaosodin · Post by **Kaosodin** » Wed Sep 19, 2007 6:18 pm

is there anythnig else i would need to install to run MySQL?

AcadiusLost · Post by **AcadiusLost** » Wed Sep 19, 2007 6:38 pm

Google found this piece of wisdom on that particular error:

http://forums.mysql.com/read.php?11,4460,35804

Kaosodin · Post by **Kaosodin** » Wed Sep 19, 2007 6:57 pm

ok, got some progress..... this time it finishes except at the end it says..

the security settings could not be applied, error 2017

cant open named pipe to host:. pipe:mysql(2)

but i will google it and see what it says

Kaosodin · Post by **Kaosodin** » Wed Sep 19, 2007 7:02 pm

got it, had to setup as regular before i could go back and re-configure.... so i got it all setup.

now..... to the rest.

hehe

thanks guys

Kaosodin · Post by **Kaosodin** » Wed Sep 19, 2007 7:18 pm

LOL got booted from my own server, let me recheck settings

AcadiusLost · Post by **AcadiusLost** » Wed Sep 19, 2007 7:22 pm

in your NWNx4 folder:

Check the settings in the xp_mysql.ini and xp_sqlite.ini

Then check the log files nwnx.txt and xp_mysql.txt

Getting booted means it's failing on one of the database functions, you should have the error logged somewhere.

[edit: also make sure your Gamespy ID and your character names don't include any unusual characters like apostrophes (' \ " * = -), as those can confuse the database. I've recently much improved it's handling of them, but the changes won't reach you till the next hak update)

Kaosodin · Post by **Kaosodin** » Wed Sep 19, 2007 7:28 pm

i believe its giveing me a error in mysql.txt

says cant connect to mysql server on local host.

let me check those settings

Kaosodin · Post by **Kaosodin** » Wed Sep 19, 2007 7:38 pm

5. Go into your NWNx4 directory, open up the xp_mysql.ini file. You'll want the following settings to get it pointed at your local DB:

Class = SQL

server = localhost
user = root
password = (whatever your root password is)
schema = nwnx

loglevel = 1 (or 2 if you want to see everything)

under server = localhost was i supposed to type in "localhost"?
or a different path?

AcadiusLost · Post by **AcadiusLost** » Wed Sep 19, 2007 7:43 pm

Yes, you actually need to put in the word "localhost" - otherwise it tries to look across the network and to the internet for the SQL server.

If you have something else there, that's likely the problem (again, both apologies on the hoops to jump through here, and hats off to your motivation to get it working)

Kaosodin · Post by **Kaosodin** » Wed Sep 19, 2007 7:53 pm

thanks friend.... but i do need to get this working in order to get my spawns working and do testing right? if so... thna i gotta do it, hehe. thanks for being so responsive.

i believe dangit i have everythnig setup the way you asked.....in the nwnx4 folder, i open nwnx.txt and i see a stream of

nwnxsetstring: function class "SQL" not provided by any plugin. and it spans across the file.

hmmmm...... what to do

AcadiusLost · Post by **AcadiusLost** » Wed Sep 19, 2007 8:01 pm

Hmm, did you get the "madCHook.dll" file copied into your ProgramFiles/Atari/NeverwinterNights2/ folder (leaving a copy in the NWNx4 folder)? That could cause a failure of the SQL plugin loading, as could missing out the "class" edits in one or more of the .ini files in /NWNx4:

xp_mysql.ini should have: "Class = SQL"

xp_sqlite.ini should have: "Class = SQLoff"

Kaosodin · Post by **Kaosodin** » Wed Sep 19, 2007 8:15 pm

doh, yup, those settings are correct, and yes, i properly copied the madhook. BOOOOOOOOOOO.... i will hang in there and keep looking

AcadiusLost · Post by **AcadiusLost** » Wed Sep 19, 2007 8:45 pm

The only way I was able to reproduce an error like you describe was when I deleted/renamed the xp_mysql.dll file to xp_mysql_.dll . I assume your nwnx.txt file looked something like this?

NWN Extender 4 V.0.0.8
(c) 2007 by Ingmar Stieger (Papillon)
visit us at http://www.nwnx.org

* Loading plugins...
* Loading plugin xp_mysql_.dll: Error during plugin initialization.
* Loading plugin xp_sqlite.dll: Error during plugin initialization.
* Loading plugin xp_time.dll: Successfully registered as class: TIME
* Disabling general protection fault error dialog.
* NWNX4 activated.
* NWNXSetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXSetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXSetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXSetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXSetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXSetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXSetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXSetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXSetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXSetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXSetString: Function class 'SQL' not provided by any plugin. Check your installation.

(note that, even renamed, xp_mysql_.dll shows up in the list- can you paste your actual error log here?)

Try downloading NWNx4 v1.08 again, and check the size of your xp_mysql.dll file against a fresh copy - maybe something got corrupted or lost somehow. Don't know how that would happen, but it fits the symptoms.

Ideally, it should look like this:

NWN Extender 4 V.0.0.8
(c) 2007 by Ingmar Stieger (Papillon)
visit us at http://www.nwnx.org

* Loading plugins...
* Loading plugin xp_mysql.dll: Successfully registered as class: SQL
* Loading plugin xp_sqlite.dll: Error during plugin initialization.
* Loading plugin xp_time.dll: Successfully registered as class: TIME
* Disabling general protection fault error dialog.
* NWNX4 activated.

AcadiusLost · Post by **AcadiusLost** » Wed Sep 19, 2007 8:55 pm

Hmm, seems Teric is having the same problem now, the plot thickens. Hopefully he can turn up some leads, I've got to get back to work.