So, the other day I decided to actually do something with the CABAL server for a change (I haven't touched the official server files for quite a while). I was really bored, so I thought I'd take a look at the DB, in particular. I've always had this feeling that I could get MySQL working if I used the ODBC drivers, but I never tried. Everyone kept saying it wasn't possible, but I never quite believed this... So, I tried, and I succeeded It was simply a matter of installing mysql-server and mysql-connector-odbc on the CentOS machine, setting up a mysql account for the server, and manually changing a few configuration files. I set the CabalAccount SQL setup to use my newly-installed MySQL server, added an empty database, called it "ACCOUNT", then started up the CABAL server. Sure enough, I started getting errors about non-existant stored procedures in the GlobalDBAgent logs I then added some hardcoded versions of these stored procedures in the ACCOUNT DB that merely returned the required information (account number, login status, etc). Once this was done, I managed to log in and get to the character screen From this point on, CABAL was only using the GameDB database, so connecting to the world and everything else was working as it should be. Since then, I've been manually converting/rewriting and documenting the necessary stored procedures and tables from the MSSQL ACCOUNT DB. I've learned quite a bit, so far, and I've been making sure to comment all the code to make it easier for others to edit
Anyways, getting to the point, now. What do you guys think about using MySQL with CABAL instead of MSSQL? Would you switch your existing databases to MySQL? MySQL offers the benefit of being able to run on Linux, so MySQL DB's would completely rid the need of VMWare/Windows. However, MSSQL is a great piece of software. I'm waiting to here what you think
P.S. If you vote, please be so kind as to leave a comment. Thanks.
Anyways, getting to the point, now. What do you guys think about using MySQL with CABAL instead of MSSQL? Would you switch your existing databases to MySQL? MySQL offers the benefit of being able to run on Linux, so MySQL DB's would completely rid the need of VMWare/Windows. However, MSSQL is a great piece of software. I'm waiting to here what you think
P.S. If you vote, please be so kind as to leave a comment. Thanks.
Last edited: