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 
 
MySQL Plug-in Setup error

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Technical support
View previous topic :: View next topic  
Author Message
Kres



Joined: 01 Mar 2008
Posts: 13

PostPosted: Sat Mar 01, 2008 5:11    Post subject: MySQL Plug-in Setup error Reply with quote

Thank you for a time and efforts here!

I have just started with NWNX4 and had an already installed version of MySQL 5.0.. I created the connection, the NWNX4 logs in (I see it as a user in my Admin/connections screen) however there is two issues.

1) The portal is there to MySQL it transports me fine, but man gives me the plugin error. I moved the plug ins for SQLite out of the folder NWNX4 folder, put the xp_mysql.dll into the same folder as my nwnserver.exe and restarted NWNX4 still the error occurs. When I disconnect NWNX4 the user logs out.

2) It wont create the tables from the script or do I have to do that myself?

3) The demo for the SQLite runs just fine! when I switch it back

Here are my Setup files

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

# MySQL server connection parameters
server = localhost
user = nwn
password = nwn
schema = nwnx

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


NWNX MySQL Plugin V.0.0.8
(c) 2007 by Ingmar Stieger (Papillon)
visit us at http://www.nwnx.org
(built using mysql-5.0.27 source)

* Log level set to 2 (everything)
* Connecting to server localhost
* Plugin initialized.
* Registering under function class SQLoff
Back to top
View user's profile Send private message
Kres



Joined: 01 Mar 2008
Posts: 13

PostPosted: Sat Mar 01, 2008 7:04    Post subject: Suggestion? Reply with quote

How about just commenting out the Class = SQL statement instead of turning it off? After taking a dinner break and coming back and "READ" what I posted I realized the problem...

Anyways thanks for the Mods, and scripting step... This was still 10x easier than with my old NWNx2 setup!
Back to top
View user's profile Send private message
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1060
Location: Germany

PostPosted: Tue Mar 04, 2008 0:23    Post subject: Reply with quote

The default database plugin is SQLite, so the MySQL plugin has to register under a different name Smile .
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Kres



Joined: 01 Mar 2008
Posts: 13

PostPosted: Tue Mar 04, 2008 0:25    Post subject: Thanks Papillon Reply with quote

I realized that after I read the code, removed the "off" and moved the SQLite to a subfolder. Works like a champ!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> 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