And people said it wasn't possible...

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 :D 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 :P

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.

Congrats... But, I rather prefer MSSQL. Dunno, just an inception in my mind. MSSQL is that piece of awsome software, which you mentioned. And I think nothing can compare to it, it's Microsoft's work.

But, your succes, can prove that nothing is impossible. And for running for low resources, it's the best option.

What i've wrote here, it's just my opinion.

Thanks, and have a nice day.

I do consider MSSQL more powerful but MySQL is good enough for what we need. It's better make our software work with open source database solutions.

wel i normaly have both mysql and mssql on the same machine but i lake the idea of geting rid om ms (prefer linux) to run a cabal server
great work tho Yamachi

Quote:

---

Originally Posted by cypher

I do consider MSSQL more powerful but MySQL is good enough for what we need. It's better make our software work with open source database solutions.

---

/agree, unique OS for Cabal pserver is powerful.

Totally agree with LostSpirit and cypher. And congratz for ur amazing idea/job.

mysql is stable, 90% of servers use it, as do we.

on my server i use mssql and i wld advise u(yama) focus on fixing the broken procs there, rather than transcoding it all to mysql for ease of use ... seems pointless to me, i use mysql for website only, but procs work faster in mssql from what i know :P but i may be wrong and some users wld maybe like a tdp release that doesn't imply using 2 hosts :D but that's only my opinion :)

I think MySQL would be faster.. I'm not sure, but ofc, MySQL should have its advantages :) Good job macaco.

Quote:

---

Originally Posted by x30unlimited

on my server i use mssql and i wld advise u(yama) focus on fixing the broken procs there, rather than transcoding it all to mysql for ease of use ... seems pointless to me, i use mysql for website only, but procs work faster in mssql from what i know :P but i may be wrong and some users wld maybe like a tdp release that doesn't imply using 2 hosts :D but that's only my opinion :)

---

Don't worry, x. Once I've converted these DB's, I'll pretty much know the SQL DB inside and out. Ofcourse, this means I'll be fixing anything I think is broken. I'll also trim down the DB's by removing anything that's not needed. I'll probably add a lot of comments, too. We'll see.

Quote:

---

Originally Posted by Yamachi

Don't worry, x. Once I've converted these DB's, I'll pretty much know the SQL DB inside and out. Ofcourse, this means I'll be fixing anything I think is broken. I'll also trim down the DB's by removing anything that's not needed. I'll probably add a lot of comments, too. We'll see.

---

would be nice and a reason to switch my server to mysql only :thumbup:

nice work!!!

MySQL all the way!

removed

I think,moving to MYSQL the whole procedures would be a tough work.
I don't think that the advantages that MYSQL provides are worthing this effort.
And ofcourse most of people are afriad of "something *NEW* " which can lead to a lot of new bugs.

The stored procedures actually aren't that hard to convert. I've been manually converting them over the past few days, and currently have login, character creation, world entry, etc all fully working (with lots of comments in the SP's, might I add). I have noticed that the server responds much quicker than it does with MSSQL, but that's obviously going to be the case seeing as the MySQL server is local to the CABAL server. TBH, I think it's mostly going to come down to personal preference.

However,there is still a lot of work to do.
I agree it's much faster,but i think the environment it's more complicated than the mssql one.
Most of people are not used with mysql and the bugs may appear...
So I guess it's a personal choice

There's really not that much difference between the 2 :P Also, MySQL is used a LOT with most server emulators, so people will be familiar with it.

Both got their pros and cons but I'd probably go for MySQL :):.

Id go for mysql too i guess. But to complete the information on this new journey would take like 1-2 months of continues running server for the owner to realize if its stable or not. This sure to help alot of new cabal admins when the development is fully finished

I would use MySQL without a second thought. A while back I posted about possibilities to merge to an oracle DB but this will be great too. On the reboot of my server next month I can then give more resources to the actual server as VBox in CentOs easily takes up ram worth a channel :)

Thanks certainly are in order!

RoFl i prefer MSSQL
Cheers for it =D MSSQL is powerful

Definitely MySQL is better and more lightweight. The fact other Linux hosting companies give out offloaded mysql when you order a vps from them gives you more flexibility in hosting a server. May I know why its not mysql from the start? As i read, mysql has stored procedures too. Dont know about the linked server but we could remove that too right. Hope this becomes successfull. Will support this fully! Cheers!

I like the idea of converting it to MySql. Its easier for me tho.
..easier for me to understand mysql so to speak.

i like the idea aswell,
for me mysql runs faster and loads faster imo...

Why do you think so.
Because doing so is not easy.
Because the foundation of the system will be upgraded all.
Which is difficult to do. But do not use that do not.
My motto, "do / do not / or did not do. ".

But if it can really very good.
It will save you. A lot of resources.
We cheer.

removed

I use MySql a lot. :thumbup:

The question should be wtf exactly is MSSql?

i would use MySql but i dont really know the diffrence between the two ive been using guides to do most of my work so if there is a guide on how to setup both then i would choose the faster one

MySQL For Appserv So good

As stated by everyone else, there are pros and cons for both SQL's but I'll go for MSSQL anytime of the day. Less ram consumption compared to MYSQL. MSSQL is more on business related applications unlike MYSQL, which is open-sourced, which means more compatibility.

removed

Quote:

---

Originally Posted by Kero Yugi

Guys will you just talk or u will do it.
I'm sure u can. I mean the professionals :D

---

I'm already doing it... I stated that at the very beginning of this thread. I haven't been working on it recently, though, as I tend to switch from project to project.

removed

Bugs are to be solved, i`m sure mysql will work faster than mssql just coz you can place it on a linux system.

I am waiting from a long time this to happen, so keep up the good work Yamachi ... and share the stuff please :)

Offtopic:
Emulator for cabal will surely fire the trigger of mass updates :P

On Topic:
Really appreciated this Yam, Id like this to be implemented and released to public ^^

I like MSSQL as well because its a powerful database server, However having MySQL eliminates the need for a windows machine entirely which is more convenient I think. A BIG thanks to all of TDP for the superb job they are doing, keep up the excellent work! :wink:

mysql does a lot more queries then mssql.
But can you make the site work on mysql to?

how would i set up the my sql same as MSSql?

Congratulations on your initiative, mysql forever. This is only my opinion.

Quote:

---

Originally Posted by MecBew

Congratulations on your initiative, mysql forever. This is only my opinion.

---

Oracle has the best database engines. MySQL and MSSQL are toys in front of Oracle technology so please...

Quote:

---

Originally Posted by cypher

Oracle has the best database engines. MySQL and MSSQL are toys in front of Oracle technology so please...

---

Oh, don't even go there.

Quote:

---

Originally Posted by cypher

Oracle has the best database engines. MySQL and MSSQL are toys in front of Oracle technology so please...

---

I do not disagree with you friend. But here the post is related to the "cabal" correct? Those who voted that mysql was perhaps prefer the ease of use? Can not say much because I never used oracle. But what counts is the bigger part is not it?

Being able to put MySQL and the server in the same machine/system would save much RAM/CPU, so I would like you to take the revenge, it would be a great change to Cabal scene.

myslq is a bit faster and easy to ues but mssql is more more more secure.people like mysql more than mssql because is free and easy to use but the best database choice is mssql.

Quote:

---

Originally Posted by traxes

myslq is a bit faster and easy to ues but mssql is more more more secure.people like mysql more than mssql because is free and easy to use but the best database choice is mssql.

---

I think you'll find that MSSQL is faster.

i used My Sql to setup a RO2 server in the past and it was cool there was no lag or anything if we could have cabal on a windows platform like i did with Ro2 it would be nice i really dont see how but would be nice

One big question.Is the minerva going to use mysql?

Minerva is written in such a way that it doesn't require a specific database type; Plugins can be written to support any format.

Will there be guides on how to setup Minerva with My SQL and MSSQL i really would like to knwo the difrence between the 2

Well there are differences:

1. The price. One of them is free the other one you need to pay for it (unless your happy with the limited crappy version).
2. The syntax is a bit changed but you can do more powerful queries.
3. The processing speed is higher (not as high as Oracle but higher than MySQL)
4. You can use the SQL Agent to perform various tasks like scheduled tasks or maintenance tasks.
5. MSSQL > MySQL . End of story.

Quote:

---

Originally Posted by cypher

Well there are differences:

1. The price. One of them is free the other one you need to pay for it (unless your happy with the limited crappy version).
2. The syntax is a bit changed but you can do more powerful queries.
3. The processing speed is higher (not as high as Oracle but higher than MySQL)
4. You can use the SQL Agent to perform various tasks like scheduled tasks or maintenance tasks.
5. MSSQL > MySQL . End of story.

---

Thank you for answering cypher :thumbup:

I have a little question.. Minerva still require Centos or can be run on a ubuntu machine??

Congratz ;D

I'd so use MySQL over MSSQL, for one simple reason. I'm a web developer, and use MySQL all the time to store data.. but I don't have the MSSQL DLL so I get constant errors and can't connect to MSSQL! Only MySQL! So that would help me a lot in the website part.

no one can compare mssql with mysql.
It like comparing windos 95 with 7 =))

@PopaAndrei you wrong so much,everyone have his own opinion even if MSSQL its stronger then MySql.Not everyone is using MSSQL and not everyone is using MYSQL because some peoples don`t need a strong database,maybe they use MySql for simple things and viceversa.And about windows its same with what i wrote above.

why do you like to come and say a thing and in fact you have no clue what you are talking about?
I worked with both of them and for example at mssql are a lot more security problems then at mysql.

Quote:

---

Originally Posted by Popa Andrei

... at mssql are a lot more security problems then at mysql.

---

I'd love to see you prove that point.

so i get banned for releasing hacks to break cabal toolz? neah ;)

Instead of bullcraping this is more secure than this, bloody proove it. MSSQL is faster than MYSQL, and I'd always use MSSQL, even if MYSQL does have a really smaller load, I'd still use MSSQL.

Well in my opinion I use a lot of time mysql, and I have some experience in mssql, for web apps it's more fun mysql, mssql sucks in that, and for who thinks that mssql its less secure mmmm it's a little bit more complicated to hack a mssql database, the mysql can be hacked in a matter of minutes of course depends on the experience, for performance and consolidation of cabal my vote is for mysql.

Yamachi so when We would see the port of mysql for Cabal :thumbup1:

Sadly Yamachi has left us for an undetermined time. Please don't reply to this.

@cypher, He will be back, i know he will.

..well for me, i use MySQL for my server It suits very well :)

Quote:

---

Originally Posted by xDefused

..well for me, i use MySQL for my server It suits very well :)

---

Care to share?

From what I saw of Yamachi's work it shouldn't be too hard to port to MySQL. A few Stored Procedures need writing but it works.

Quote:

---

Originally Posted by chumpywumpy

Care to share?

From what I saw of Yamachi's work it shouldn't be too hard to port to MySQL. A few Stored Procedures need writing but it works.

---

Stored procedures and some SQL queries, such as "SELECT TOP", because MySQL doesn't support that.
I managed with ODBC MySQL drivers connect, and i can show logs. Here: http://pastebin.com/xxAmQe5F

As i can see, we have query: "SELECT TOP 3 UserCount FROM LOG_NATION ORDER BY LOGTIME DESC, Nation" and correct syntax for MySQL would be: "SELECT UserCount FROM LOG_NATION ORDER BY LOGTIME DESC, Nation LIMIT 3"

Dunno, if we can change that query or give somehow support for "SELECT TOP".

The queries are all in plain text in the server binaries so you could hex them. They are pretty tight on space though so you will probably have to look at relocating the strings and change all of the pointers that reference the old location to the new one. Unfortunately my hexing skills are ancient and I have only done this on Windows binaries in the past. The string you are looking for is at A7E18.

Tricky but not impossible.

anyone interested in this idea? It would be great if we could make this happen so we only need 1 VM for both the server and DB. If there is anyone who wants to work on this with me, please send me a message or reply to this thread.

Quote:

---

Originally Posted by AbS

anyone interested in this idea? It would be great if we could make this happen so we only need 1 VM for both the server and DB. If there is anyone who wants to work on this with me, please send me a message or reply to this thread.

---

There's no need for this anymore: https://www.microsoft.com/en-us/sql-...ql-server-2017 & https://docs.microsoft.com/en-us/sql...-setup-red-hat