logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Getting real frustrated trying to get MySQL to work...

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Windows technical support
View previous topic :: View next topic  
Author Message
supasack



Joined: 08 Jul 2009
Posts: 5

PostPosted: Wed Jul 08, 2009 5:32    Post subject: Getting real frustrated trying to get MySQL to work... Reply with quote

I come back after a couple year hiatus... my last foray was with NWNX2 and didn't have any issues setting it up. However it seems NWNX4 has switched over to using SQLITE in the setup docs....however I don't want to give up some of the features of MySQL.

When I load the demo mysql mod the npc walks up and says the plugin apparently isn't loading and that I need to delete the sqlite.dll file etc from the nwn directory. I have all this correct. Here are the settings and outputs from my logs:

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

* Loading plugins...
* 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.

xp_mysql.ini:
# The function class that is provided by this plugin
class = SQLoff

# MySQL server connection parameters
server = 192.168.1.102
user = nwnxuser
password = ******
schema = nwnx4

# How much information should be written to xp_mysql.txt:
# 0=nothing, 1=only errors, 2=everything
loglevel = 2

xp_mysql.txt:
NWNX MySQL Plugin V.0.0.9
(c) 2007 by Ingmar Stieger (Papillon)
(c) 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 5e6fd0.
o RCO located at 5e6c20.
* Hooking successful
* Connecting to server 192.168.1.102
* Plugin initialized.
* Registering under function class SQLoff



Everything looks in order. I don't understand why once in-game it just will not connect to the dbase.

Getting real frustrated.... any help would be greatly appreciated. I'm running Vista x64 and have installed MySQL 5.1 x64.

Thanks.
Back to top
View user's profile Send private message
Zebranky



Joined: 04 Jun 2006
Posts: 415

PostPosted: Wed Jul 08, 2009 7:42    Post subject: Re: Getting real frustrated trying to get MySQL to work... Reply with quote

supasack wrote:
xp_mysql.ini:
# The function class that is provided by this plugin
class = SQLoff

Needs to be:
class = SQL
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/

<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.

<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for?
Back to top
View user's profile Send private message Visit poster's website
supasack



Joined: 08 Jul 2009
Posts: 5

PostPosted: Wed Jul 08, 2009 14:13    Post subject: Reply with quote

It was that simple!? Gonna try now before work.
Back to top
View user's profile Send private message
supasack



Joined: 08 Jul 2009
Posts: 5

PostPosted: Wed Jul 08, 2009 14:23    Post subject: Reply with quote

Zebranky, I love you. Smile TYVM!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Windows technical support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group