| View previous topic :: View next topic |
| Author |
Message |
Urlord
Joined: 17 Nov 2006
Posts: 122
|
 Posted: Fri Dec 22, 2006 23:24 Post subject: NWNX4 Across a LAN Network |
 |
|
I have MySQL5 running on one server and NWN2 on another. What is the systax fot the xp_mysql.ini? These settings are not working.
class = SQL
server = \\192.168.0.125\mysql5
user = [my user name]
password = [my password]
schema = nymri2
_________________
Jim (aka, Urlord)
Visit the Persistent World of Nymri |
|
| Back to top |
|
 |
Grinning Fool
Joined: 12 Feb 2005
Posts: 264
|
| Posted: Sat Dec 23, 2006 5:33 Post subject: Re: NWNX4 Across a LAN Network |
|
|
| Urlord wrote: | I have MySQL5 running on one server and NWN2 on another. What is the systax fot the xp_mysql.ini? These settings are not working.
class = SQL
server = \\192.168.0.125\mysql5
user = [my user name]
password = [my password]
schema = nymri2 |
Server should read:
server = 192.168.0.125
The "\\" notation is just for Windows file shares; mysql doesn't use that for connections.
You'll also want to make sure that the server running mysql5 is set to listen for TCP connections. (I think on Windows, it defaults to yes while on most linux distributions it defaults to no.)
_________________
Khalidine, a NWN2 persistent world
Looking for volunteers. |
|
| Back to top |
|
|
epicpalemaster
Joined: 23 Dec 2006
Posts: 1
|
| Posted: Sat Dec 23, 2006 19:58 Post subject: |
|
|
I just NWNX4 using mySQL on another box in my LAN.
The Gotchas I found:
make sure that you have the bind-address: 127.0.0.1 commented out in the my.ini
all the HOST permission are set up so that your NWN user can connect from the NWN server host.
I found it easier to install MySQL on the NWN server box and use command line connects for trouble shooting.
c:\%mysqlbinpath%\mysql --host 192.168.0.125 --username [my user name]
Anyway, hope youo got everything running. I know I was relieved to get the DB connect/read/writes off the NWN server box.
PS. I am pleased to have found such an awesome hook for NWN2 development. Thanks to all of those that have worked on this project.
Happy Coding Holidays all.
Epic |
|
| Back to top |
|
|
Urlord
Joined: 17 Nov 2006
Posts: 122
|
| Posted: Sun Dec 24, 2006 0:45 Post subject: |
|
|
I set the server parameter to jus the IP Address and now the MySQL Server shows that NWNX is connected to the database. However, none of my data is being saved to the database. I haven't had much luck troubleshooting it yet, but I will let you know if I figure it out. In the meantime, if anyone has any words of wisdom, I would love to hear them.
I checked the my.ini file and there is not anything in there called bind-address.
Oh, I am using MySQL 5.0
_________________
Jim (aka, Urlord)
Visit the Persistent World of Nymri |
|
| Back to top |
|
|
Grinning Fool
Joined: 12 Feb 2005
Posts: 264
|
| Posted: Mon Dec 25, 2006 5:05 Post subject: |
|
|
Are you getting any errors in xp_mysql.txt?
_________________
Khalidine, a NWN2 persistent world
Looking for volunteers. |
|
| Back to top |
|
|
Urlord
Joined: 17 Nov 2006
Posts: 122
|
| Posted: Mon Dec 25, 2006 6:30 Post subject: |
|
|
| Grinning Fool wrote: | | Are you getting any errors in xp_mysql.txt? |
Yes I am getting errors:
Connection to MySQL server failed:
Access denied for user 'nwn2server'@'goldilocks' (using password: YES)
I have the user set up and can connect to the server on the same machine (localhost), but I cannot connect with this login via NWNX across the LAN. I tried and I cannot connect even with the root account with NWNX.
It has to be something incorrect with my MySQL, Router or something but I cannot figure it out. I have MySQL using the default port 3306. I have port forwarding for port 3306 set up for the MySQL server machine. I have opened port 3306 in the firewall on moth machines.
I really suck at this router/firewall stuff. I am much better with code.
_________________
Jim (aka, Urlord)
Visit the Persistent World of Nymri |
|
| Back to top |
|
|
amphiprion
Joined: 07 Nov 2006
Posts: 44
Location: Toulouse (France)
|
| Posted: Mon Dec 25, 2006 10:33 Post subject: |
|
|
| your MySQL configuratin doesn't allow remote user to connect, you must modify your MySQL configuration file(s) |
|
| Back to top |
|
|
Grinning Fool
Joined: 12 Feb 2005
Posts: 264
|
| Posted: Tue Dec 26, 2006 22:12 Post subject: |
|
|
| Urlord wrote: | | Grinning Fool wrote: | | Are you getting any errors in xp_mysql.txt? |
Yes I am getting errors:
Connection to MySQL server failed:
Access denied for user 'nwn2server'@'goldilocks' (using password: YES)
I have the user set up and can connect to the server on the same machine (localhost), but I cannot connect with this login via NWNX across the LAN. I tried and I cannot connect even with the root account with NWNX.
It has to be something incorrect with my MySQL, Router or something but I cannot figure it out. I have MySQL using the default port 3306. I have port forwarding for port 3306 set up for the MySQL server machine. I have opened port 3306 in the firewall on moth machines.
I really suck at this router/firewall stuff. I am much better with code. |
Try creating the user this way in mysql:
GRANT ALL ON nymri2.* TO 'nwn2server'@'goldilocks' IDENTIFIED BY 'password'
Or if the user will be connecting from multiple machines:
GRANT ALL ON nymri2.* TO 'nwn2server'@'%' IDENTIFIED BY 'password'
_________________
Khalidine, a NWN2 persistent world
Looking for volunteers. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
