Page 1 of 1

Building server on windows, SQL on Linux

Posted: Sun Apr 26, 2009 4:01 pm
by diehardtwb
Hi folks,

I checked this project out when it first came public, it's made good progress, I see. :)

Here's what I'd like to do in my ideal world...

I want to run the server on Windows Server 2003 and connect to a mysql database on a linux platform on a different public IP address. My reasoning for this is that I already have redundant nightly backups configured and I have phpmyadmin set up and running and it'll just make my life much easier. :)

So, when I tried to compile this without having the lib include directories, I got a lot of errors. Can I still go through and get a successful build, and change where the SQL connection is?

Thanks...

DieHard

Re: Building server on windows, SQL on Linux

Posted: Sun Apr 26, 2009 4:14 pm
by Bion
you still have to download mysql and zlib put those paths for the includes and libraries in your project settings. if you want to compile your own.

but yes you can easily do this just setup your
LoginServer.ini

for the ip of your windows box which your server is going to be on. and set
world_db.ini
the ip in there to the ip of your linux mysql server. and do all your database stuff on that machine.

Re: Building server on windows, SQL on Linux

Posted: Mon Apr 27, 2009 7:05 am
by John Adams
A local World pulling mysql data from a remote MySQL instance will be horribly slow, but should still work I suppose. You'll have to let us know how it goes. The current DB is empty, so right now it would likely be fast... but once our zones start filling up - fetching that data, I cannot imagine it being very fast.

Any reason you cannot run a local MySQL? you still have to install it anyway to compile. Maybe I mis-read your intentions.