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 Non Standard TCP Port

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related
View previous topic :: View next topic  
Author Message
marshallvyper



Joined: 18 Oct 2012
Posts: 5

PostPosted: Wed Jan 30, 2013 20:10    Post subject: mySQL Non Standard TCP Port Reply with quote

Can someone tell me the option to use in xp_mysql.ini to tell it to use a port other than 3306. Is there a "port" option or do I just add :<port> onto the end of the IP?

Thanks

M
Back to top
View user's profile Send private message
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Wed Jan 30, 2013 21:35    Post subject: Reply with quote

Yes, use the port config option.
_________________
In Soviet Russia, NWN plays you!
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
marshallvyper



Joined: 18 Oct 2012
Posts: 5

PostPosted: Wed Jan 30, 2013 21:56    Post subject: Reply with quote

Hmm, I tried using the port = option and it didn't make any difference. Next, I tried having the database listen on its normal 3306 and set the port = 3307 in the xp_mysql.ini file (expecting it to fail) and it connected just fine. Seems it's ignoring the port = option.

EDIT: Oh and just to clarify, this is NWNX for NWN2.

M.
Back to top
View user's profile Send private message
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Wed Jan 30, 2013 22:35    Post subject: Reply with quote

Right, this was in the unreleased version.
Try this DLL:
http://data.virusman.ru/nwn/nwnx4/xp_mysql-1.1.1.rar
_________________
In Soviet Russia, NWN plays you!
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
marshallvyper



Joined: 18 Oct 2012
Posts: 5

PostPosted: Wed Jan 30, 2013 22:41    Post subject: Reply with quote

Ohh.. that's great! Thanks a lot. Any other features in this version that are different?

Thanks

M
Back to top
View user's profile Send private message
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Wed Jan 30, 2013 22:54    Post subject: Reply with quote

XP MySQL and SQLite 1.1.0:
- SQLExec is now a NWNXGetInt function returning 0 on error
- Added GetErrno and GetErrorMessage functions

XP MySQL 1.1.1:
- Added ability to specify "port" option in xp_mysql.ini; this port will be used for connection if provided.
_________________
In Soviet Russia, NWN plays you!
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Wed Jan 30, 2013 23:00    Post subject: Reply with quote

I've updated the package linked above with new nwnx_sql.nss
_________________
In Soviet Russia, NWN plays you!
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related 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