Well, from the wiki that AndMetal made and that I added some steps to, you can find how to set mysql on linux to allow remote connections from your windows PC in this section:
http://www.eqemulator.net/wiki/wikka...er#MySQLRemote
Make sure you follow the section directly below that as well:
http://www.eqemulator.net/wiki/wikka...LRemoteAccount
You have to configure access to the mysql database running on the linux PC by adding an account for the windows PC:
Code:
GRANT ALL PRIVILEGES ON *.* TO 'eqemu'@'192.168.1.%' IDENTIFIED BY 'my-new-password';
And then the windows PC will have to have Navicat or whatever you use set to use that account that you just created. It should be set to eqemu and whatever password you set. If your LAN uses different IPs than the 192.168.1 network, then you will need to adjust that. You can leave it with the % sign in there and that will just allow all PCs on your LAN to access your database, but still block anything from outside.
You also have to change the text file I mention in the first line (my.cnf) otherwise, Linux won't allow any access at all from outside sources. And, make sure you set the Bind Address to the IP of your Linux PC.
That should get you access to your database on the Linux PC from your Windows PC like you will need.
As for your rules, I am not exactly sure why they wouldn't load, because they should all carry over when you did the database move and it sounds like they did. The only thing I can think of off-hand is that you might want to check your Rule_Sets table and make sure that the number of your default rule set (or whichever set you normally use if you made a custom one) is the same as what is being set in your Rules_Values table to enable the rules.
In my case, my default rule set is 1, and so to enable rules, I have to set them to 1, as by default they are set to 0, which basically means the rule is ignored. Really, this should carry over and work just like it does on your windows database, but that is the only reason I can think of that would cause that. Otherwise, I think there is a command to set your rules in game, which I don't know the command name offhand, but maybe it is worth a shot if you want to try that.
Sounds like overall, your install didn't go too bad =) It took me about a week of tweaking to get my linux server working perfectly before I moved my database over and started running the server from it. But, now I have rebuilt Linux 3 or so times, so I got the hang of it hehe. And, I didn't rebuild because there were issues, I rebuilt because I was moving it back and forth between PCs. Since I went to Linux, there have been very few issues. Though, you might want to consider getting a UPS power backup at some point to protect your OS install. If your power hits and brings your Linux PC down, it can sometimes be nasty to get Mysql running properly again, but normally there aren't many issues with that even.
Hybrid Mode
