8 réponses à ce sujet

[Gildren]

06-10-2012

Hi folks,

 

I’m hoping that someone might be able to point in the right
direction regarding setting up NWN2 NWNx4 and MySQL.  After several days of searching for information, I though it was
well past time that I asked for some help. 


I suspect the knee kick response is to go to the
“Neverwinter Nights Extender” site
(http://www.nwnx.org/...x4_installation) , but lets face it, the
instructions given are outdated by a number of years (madHook.dll? hello? renamed?
removed? use odbc2, on no that is nwn1, etc), and the site it’s self is pretty
much a mess if miss labeled/miss linked/undated/ information.  Very frustrating to try and find information
for NNW2 only to get linked to NWN1 topics with outdated information, again,
and again.  Very sorry to complain, no
offense is meant.

That being said, is there anywhere out there some sort of
walk-thru fro getting NWNx4 and a MySQL5.5 database up and talking to each
other for the admittedly database stupid folks like myself?

 

Any help or “look here” pointers would be appreciated.

 

Thanks for your time

 

[painofdungeoneternal]

I am just describing this off of my memory so you will have to look things up as needed ( or other members here can post answers ). I did have a very detailed tutorial but the website it was on is no longer available, and i just can't bear repeating all the work that went into setting that up a second time ( especially since it's backed up and should at some point be restored ). This is my recollection of it.

Step 1. Get MySQL installed. Take advantage of the MANY tutorials geared for all users levels.

Step 2. Use the admin console that comes with mysql and install it on your server itself, get it so it can connect to mysql. ( There are actually a lot of these out there made by many different people, but it's a GUI for doing things in MySQL ). This will get it to the point where you know how to connect to mysql. ( put in the login, password, host ip address, and also ensuring you have a user setup, you will also use this later to manage mysql when needed, to review and adjust tables and troubleshoot things. ) This has nothing to do with NWNX and there is a lot of resources to help you, please look for them.

Step 3. Install all the required libraries NWNx needs. ( Need to look them up as i don't have what they all are at the top of my head, but there are a few things you need to install to support all of this which come from microsoft, this is things like .Net, directx, and more ). You have to run their installer to verify they are working right ( it is setup to fix any issues and repair things if you have something wonky, and if you have it working already it won't do anything, microsoft provides no other method of ensuring the libraries are available per their documentation. ) To get everything running it's about 5 or 6 installers ( skywing plugins require a lot more than anyone else, but his work is probably the most valuable. ) I have buttons in my Never Launcher ( see below ) that will run all the required installers one at a time.

Step 4. Install NWNx, including skywings various plugins. Everything goes into a folder named c:\\NWNx4 ( located anywhere, off the root can avoid some permission issues, i am just going to refer to it as that ). This should just be following what info you find on www.nwnx.org, and is similar for each plugin.

Step 5. Copy files which go in same folder as the neverwinter nights program. If you have EVERYTHING it includes the following files, you might not have all of these, just copy those which you have then. ( if you don't have anything except the core parts, all you need is NWNX4_Hook.dll )

AuroraServerNetLayer.dll
AuroraServerNetLayer.pdb
NWNScriptJIT.dll
NWNScriptJITIntrinsics.dll
NWNX4_Hook.dll

Step 6. Refer to settings in Step 2, put them into the mysql ini file found in c:\\NWNx4.

Step 7. Review all the ini files and make sure they make sense.


I have setup my never launcher project to do some of this work, but it's not completed to the point where it's doing all the work for you to the point of being what i'd call easy. The NWNx included is at this point out of date and it won't work if you do not edit the ini files, but there are buttons to install the required libraries. If you do use it, you should download the latest files from nwnx.org and from skywing, might be helpful as an example. However it does have buttons for ALL the required libraries, which will run the various microsoft installers which download the latest versions.

Regardless you HAVE to get mysql setup, and it is just a good idea to use the admin console to ensure it's working properly before you start trying to get NWNx working.

Also review the ini files, the xp_craft.ini has to point to the actual database. The ini files are configured to work on my system not yours. ( part of the project is to make it have a wizard interface which deals with these issues for you )

[Promethean 47]

Gildren,

psionic-entity and psychictoaster at our forums (legacydarkage.com) would also be able to help you if you have more questions. Generally pain and skywing are pretty good about helping troubleshoot too.

[luna_hawke]

Are you able to load nwnx4 with sqlite and their demo?
It might be good to try that first.
Once you have that baseline working, then move to MySQL.

I have madHook.dll. Apparently you don't need it though. So skip that step.
http://www.nwnx.org/...10ad169302239df

[Gildren]

Thank you for your responses, they are greatly appreciated.

Pain, I recall your walk through from the site you mentioned, and that was what helped me set up a developers machine about a year ago. In retro spec, I should have saved a copy of the directions, they were very, very well done. Hopefully it will be restored soon.

From what I am reading etc, I believe my main issues are with me not setting up the database correctly, so it's off to trail and error education again.

thanks folks, I'll keep at it

[Gildren]

The search continues - asked for help on the NWNx4 Tech forums, though it looks as if these may well be dead for anything other than nwn1 *shrug*

After six days of looking, and beating my head against the wall, maybe someone will have a clue as to what I am doing wrong

thread link - http://www.nwnx.org/...p?p=15529#15529

- - - - - - - - - - Copy of the post  below - - - - - - - - - - - - - - - - -

Been searching for quite a while now for some help, and mostly what get back is silence or, there is plenty of help out there, go look. Well, I'm guessing I've spent about 30 hours or more 'looking' so apparently I'm just too dumb to "look in the right way'

So here goes, maybe some one will be able to help, understanding my frustration.

I am having issues with getting NWNx4 talking with any database. I've lost count of how many times I have reinstalled MySQL, created a schema, user, given all privileges etc.

So here is what the reports are generating -


XP_MYSQL.TXT
Quote:   
NWNX MySQL Plugin V.0.0.9
© 2007 by Ingmar Stieger (Papillon)
© 2008 by virusman
visit us at http://www.nwnx.org
(built using mysql-5.0.27 source)

* Log level set to 2 (everything)
o SCO located at 78f440.
o RCO located at 78f090.
* Hooking successful
* Connecting to server 127.0.0.1
* Plugin initialized.
* Registering under function class SQLoff
* Plugin unloaded.   


If I am reading that report correctly - the xp_mysql.dll is working correctly

Next -

NWNX.TXT
Quote:   
NWN Extender 4 V.1.0.9
© 2008 by Ingmar Stieger (Papillon)
visit us at http://www.nwnx.org

* Loading plugins...
* Loading plugin xp_AuroraServerNWScript.dll: Successfully registered as class: NWSCRIPTVM
* Loading plugin xp_mysql.dll: Successfully registered as class: SQLoff
* Loading plugin xp_time.dll: Successfully registered as class: TIME
* General protection fault error dialog disabled.
* NWNX4 activated.
* NWNXGetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXGetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXGetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXGetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXSetString: Function class 'SQL' not provided by any plugin. Check your installation.
* NWNXGetInt: Function class 'SQL' not provided by any plugin. Check your installation.
<five repeats of the above deleted just as to lessen the size of this post>
* NWNX4 shutting down.   


So if I am reading this correctly, NWNx4 is not seeing the xp-mysql.dll plugin? is the problem that xp_mysql is registered as class SQLoff (whatever that means)?

Yup, I've copied the xp_mysql.dll to the NWN2 install directory (along with AuroaServerNetLayer.dll, AuroaServerNetLayer.pdb, NWNScriptJIT.dll, NWNScriptJITIntrinsics.dll and xp_time.dll). Nope, there isn't a copy of xp_sqlite anywhere other than the compressed nwnx4_109 download archive.

So what gives? Any clue? Is there something very simple/stupid I am missing? Or should I just give up?

[luna_hawke]

It looks like it's still set to sqlite.

This is from nwnx4.      "Make sure that the class in xp_sqlite.ini is set to SQL and the class in xp_mysql.ini is set to SQLoff (or something else, doesn't matter). This is the default, so if you are working with the original files, everything should be peachy. "

You need to swap this.
Set xp_mysql.ini to SQL
Set xp_sqlite.ini to SQLoff


The top of your xp_mysql.ini should look like this.

# The function class that is provided by this plugin
class = SQL



Load the Database demo to that is provided with the install files.
I know it was fairly helpful at pointing out errors when the SQL setup wasn't working right.
Post back if this helps or not.   

[Gildren]

THANK YOU LUNA_HAWKE!!!! I would hug you in real life, so the best I can do is the caps thank you!

That was exactly it! the xp_mysl.ini was had "Set xp__mysql.ini to SQLoff" and changing that one line to "Set xp_mysql to SQL" got everything working.

In looking at the unedited nwnx4_109 zip file, and the xp_mysql.ini compressed within, one can see that the default setting is in fact "SQLoff" which for someone who is not SQL proficient is the source of the issue I have been having.

thank you again

[MarshallV]

If you still need more help.. you can try this:

www.youtube.com/playlist

Modifié par MarshallV_ForgotMyAccount, 22 septembre 2012 - 01:00 .