remote mysql connection

[Ne0nx3r0]

Maybe this is answered elsewhere, but I couldn't seem to find it >.>

Can NWNX2(for nwn1) connect to a remote mysql database? I know the example shows localhost but will it work with remote IPs/hostnames?

[Zebranky]

Yes, just set the host in NWNX.ini. It may lag the server horribly, though, unless the DB is on a LAN.
_________________
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?

[terror2001]

Is there an INI config setting to change the port # that NWNX uses to connect to the MySQL DB?

Or is there another method to change the port used other than the default 3306?

[Zebranky]

Hmm, there is not! That's an oversight. I'll commit a fix, but as a temporary solution, you can change the first 0 on line 47 of mysql.cpp (in the latest Win32 SVN revision) to the desired port number and recompile.
_________________
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?

[terror2001]

I don't suppose that can be added to NWNX2?

[Zebranky]

Easy enough. Done; grab nwnx_odbc from the link in my sig. The option is port=1234 in NWNX.ini.

Linux already supported this, BTW -- just Win32 was missing it.
_________________
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?

[terror2001]

Cool, I will give that a whirl. Thanks.

[terror2001]

Hmm, it didn't seem to work. The nwnx_odbc.dll file version I got from your site is 0.9.2.5, 1,820,160 bytes.

My ini configs are these:

[Zebranky]

That's the right file size, and it's definitely working for me, so logs are the next step. What's in logs.0/nwnx_odbc.txt?
_________________
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?

[terror2001]

nwnx.txt

[terror2001]

Are these logs of any use?

[Fireboar]

They imply that there is no mysql server running at localhost listening at the given port. To check, try in a command prompt (you're using Windows, so it's...)

[terror2001]

I know it is running when I tried nwnx because I stop and start MySQL manually when I am going to test, and Navicat can connect when it is running.