-
MySQL Server with RoA's Locator
Hi guys, I'm trying to get my server running on a MySQL database..
This is for the matchserver I started up:
Code:
Match-Server Log
[01/10/10 17:12:42] DBMS connected
[01/10/10 17:12:42] Command registeration completed
[01/10/10 17:12:42] Release Date : Jun 13 2007
[01/10/10 17:12:42] X-Trap Off
[01/10/10 17:12:42] MD5 Check Off
[01/10/10 17:12:42] Server Country : BRAZIL
[01/10/10 17:12:42] Command version : (56)
[01/10/10 17:12:42] Event usable state : (false)
[01/10/10 17:12:42] Load event size : (1)
[01/10/10 17:12:42] FileCRCCheckSum usable state : (false)
[01/10/10 17:12:42] FileCRC size : (1)
[01/10/10 17:12:42] Country Code Filter usalbe state : (false)
[01/10/10 17:12:42] Accept Invalied IP state : (true)
[01/10/10 17:12:42] Keeper IP : (127.0.0.1)
[01/10/10 17:12:42] Monitor IP : (127.0.0.1)
[01/10/10 17:12:42] Match Server Created (Port:6000)
[01/10/10 17:13:12] [CRITICAL ERROR] DB Connection Lost.
[01/10/10 17:13:12] DBMS connected
[01/10/10 17:13:42] [CRITICAL ERROR] DB Connection Lost.
[01/10/10 17:13:42] DBMS connected
[01/10/10 17:14:12] [CRITICAL ERROR] DB Connection Lost.
[01/10/10 17:14:12] DBMS connected
[01/10/10 17:14:42] [CRITICAL ERROR] DB Connection Lost.
[01/10/10 17:14:42] DBMS connected
MatchAgent is normal...
I edited the Locator Emulator for MySQL Connection it was directly for MSSQL. And it worked here is a screenie
http://www.easy-upload.nl/index.php/file/14b49fe593c534
But if I startup my client I do not see the server..
-
Re: MySQL Server with RoA's Locator
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
Demantor
Just:
Why MySQL?
So I can have a database 24/7 online by a free host:P
-
Re: MySQL Server with RoA's Locator
What matchserver do you use?
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
PaulBub
What matchserver do you use?
rev 5 by system32..
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
eele
So I can have a database 24/7 online by a free host:P
Ah.
Too bad that the free host has a limit on MySQL Connections xD, thats might the reason why your MatchServer is losing the connection ;)
-
Re: MySQL Server with RoA's Locator
It might only allow local connections, check in phpMyAdmin if you can change the allowed IPs, but it's not safe at all.
-
Re: MySQL Server with RoA's Locator
Was this the database I converted?
I kept getting database connection losses because all stored procedures wasn't in place.
- Exiled Hero.
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
Demantor
Ah.
Too bad that the free host has a limit on MySQL Connections xD, thats might the reason why your MatchServer is losing the connection ;)
I'm testing on my xampp server
ip: 127.0.0.1
And 'IF' I had that free host for testing something should work. But the client doesn't show the server and the matchserver give me that strange errs:p
---------- Post added at 07:54 PM ---------- Previous post was at 07:52 PM ----------
Quote:
Originally Posted by
o0slowpaul0o
Was this the database I converted?
I kept getting database connection losses because all stored procedures wasn't in place.
- Exiled Hero.
Thanks for the REP.
I used that one you released, I had made my own with a program I don't remember, but I lost it so I used yours.
I'm gonna look for a new one.
-
Re: MySQL Server with RoA's Locator
Elee, that's where you went wrong.
If you uploaded the dump via PHPMyAdmin, it doesn't execute stored procedures. I never understood why.
Only losing connection because the Locator cannot find any stored procedures on the MySQL server.
-
Re: MySQL Server with RoA's Locator
Lambda said that he tested that, and after a while and only 300 -500 users online it was lagging very, so why moving to mysql?..
Free host or not, the Locator needs windows to run.
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
Exiled Hero
Elee, that's where you went wrong.
If you uploaded the dump via PHPMyAdmin, it doesn't execute stored procedures. I never understood why.
Only losing connection because the Locator cannot find any stored procedures on the MySQL server.
Damn, I executed the query for the database in Navicat now, but if I click on the Functions it's still empty.
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
Demantor
Locator needs windows to run.
RoA's locator is open source, you can do another locator emulator to run at unix.
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
Demantor
Lambda said that he tested that, and after a while and only 300 -500 users online it was lagging very, so why moving to mysql?..
Free host or not, the Locator needs windows to run.
I don't want my website and server on the same server^^
But I didn't asked for questions about why this why that. The only thing is that it doesn't work, like it has to work..
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
cerealnp
RoA's locator is open source, you can do another locator emulator to run at unix.
Thats might true, but MatchServer will also only run on windows system xD. [Code and code, waste and waste time, after all you have a boring gunz server, might bugged too + Not legal, then GunZ 2 Comes out XDDD]
Anyway, good luck in fixing it.
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
eele
Damn, I executed the query for the database in Navicat now, but if I click on the Functions it's still empty.
I had issues with the fnGetMin function. You will have to insert it manually like I did.
Code:
DELIMITER $$
CREATE FUNCTION fnGetMin(v_n1 INT, v_n2 INT) RETURNS int(11)
BEGIN
RETURN(CASE WHEN v_n1 < v_n2 THEN v_n1 ELSE v_n2 END);
END
$$
DELIMITER ;
select fnGetMin(1,2);
And the same for fnGetMax.
Code:
DELIMITER $$
CREATE FUNCTION fnGetMax(v_n1 INT, v_n2 INT) RETURNS int(11)
BEGIN
RETURN(CASE WHEN v_n1 > v_n2 THEN v_n1 ELSE v_n2 END);
END
$$
DELIMITER ;
select fnGetMax(1,2);
-
Re: MySQL Server with RoA's Locator
I don't miss that 2. I miss all:S Could you add me on Msn? eele_mailadres@hotmail.com
But thanks;)
-
Re: MySQL Server with RoA's Locator
Added.
Just so you know, I wouldn't recommend Navicat. SQLYog is better due to the fact it seperates Stored Procedures and Functions.
Gunz uses Functions and Stored Procedures but Navicat will store both together when it shouldn't.
I'm home tonight and I almost done a fix for you. =)
Millitary, if you are reading this, I'll send it to you as well.
-
Re: MySQL Server with RoA's Locator
mysql takes a lot more memory than mssql .it canot the the load as compared to mssql . Look at your memory used in procceses you will know
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
Asaki
mysql takes a lot more memory than mssql .it canot the the load as compared to mssql . Look at your memory used in procceses you will know
Correct yourself.
1) MySQL runs smoother and faster
2) Just does as much as MsSQL
3) Isn't a resource or space hog like MsSQL
3) Doesn't require .NET framework
List goes on.
And it's a fact that MySQL is used a lot more than any other databases that exists on the internet apart from MS Access.
-
Re: MySQL Server with RoA's Locator
no . correct yourself pls . I have another server which is using mysql server . Its been tested that mysql does not run smoother than mssql . Check your mysql usage of the memory you will know . mysql takes more memory than expected , when it comes to mssql server and load usage , pls compare the difference.
And like what lambda said , it cant even hold more than 300 players . mssql is able to hold more than a thousands, what do you think
-
Re: MySQL Server with RoA's Locator
Search a bit on the internet and you will find that actually SQL Server is one of the best database engines for games, the 99% of the game servers are written to use SQL Server and its for a reason.
I have ran GunZ on MySQL, at a first i was surprised for the speed of the select querys and the server in general, but when the user count increases (600 exactly), MySQL was claiming mercy, also you need to count with the fact that each matchserver instance makes 7 connections to the database.
I am using MySQL for my Team Fortress 2 community to handle all the ranking, subscriptions and user stuff and im seriously thinking to change into SQL Server because sometimes MySQL just hangs and i need to restart the whole MySQL process.
Definitively MySQL is not good for a database-intensive process like a Game server, for things like website that most of the time does selects its very good (its for what MySQL has been designed for).
If you want a database engine that performs like SQL Server you should look at PostgreSQL or Oracle.
-
Re: MySQL Server with RoA's Locator
just to add on to this , mysql usage isnt any better .I used to run a maplestory server with mysql .I only had 100 over players online and the usage of the memory usage by mysql already hit up to 750+mb . so what do you think ? i dont think mssql will even hit that much , or rather hit 1/4 of it
-
Re: MySQL Server with RoA's Locator
Arguing about the memory that a database engine takes is rather stupid, the more memory it eats the more faster it will run.
If you run any database engine in a PC with, for example, 1GB of ram, it will need to do alot of I/O operations, slowing down the querys ALOT, i have seen SQL Server taking 4GB of ram on a 8GB computer, and if you put more in your server, it will take even more, but of course it will run MUCH faster because is using alot of memory caching.
-
Re: MySQL Server with RoA's Locator
i ran with 8gb still mysql is not the ideal choice for gaming
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
Exiled Hero
Added.
Just so you know, I wouldn't recommend Navicat. SQLYog is better due to the fact it seperates Stored Procedures and Functions.
Gunz uses Functions and Stored Procedures but Navicat will store both together when it shouldn't.
I'm home tonight and I almost done a fix for you. =)
Millitary, if you are reading this, I'll send it to you as well.
Thank god.
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
Lambda
Search a bit on the internet and you will find that actually SQL Server is one of the best database engines for games, the 99% of the game servers are written to use SQL Server and its for a reason.
I have ran GunZ on MySQL, at a first i was surprised for the speed of the select querys and the server in general, but when the user count increases (600 exactly), MySQL was claiming mercy, also you need to count with the fact that each matchserver instance makes 7 connections to the database.
I am using MySQL for my Team Fortress 2 community to handle all the ranking, subscriptions and user stuff and im seriously thinking to change into SQL Server because sometimes MySQL just hangs and i need to restart the whole MySQL process.
Definitively MySQL is not good for a database-intensive process like a Game server, for things like website that most of the time does selects its very good (its for what MySQL has been designed for).
If you want a database engine that performs like SQL Server you should look at PostgreSQL or Oracle.
To add on this, MySQL was never designed to work with games. MySQL was designed as a small, fast, database engine for web purposes.
Plus, none the less, MySQL was officially written for UNIX systems, so was Apache. Hence Apache running way and way better on UNIX systems than Windows systems.
-
Quote:
Originally Posted by
Wizkidje
To add on this, MySQL was never designed to work with games. MySQL was designed as a small, fast, database engine for web purposes.
Plus, none the less, MySQL was officially written for UNIX systems, so was Apache. Hence Apache running way and way better on UNIX systems than Windows systems.
Ragnarok works great with MySQL. :O
Posted via Mobile Device
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
phoenix_147
Ragnarok works great with MySQL. :O
Posted via Mobile Device
Ragnarok is designed for MySQL's purpose, opening only a few connections. MatchServer opens a shitload of 'em, and MySQL isn't designed for a lot of connections. MySQL was designed for:
1) Open connection
2) Execute multiple query's
3) Close connection after a few seconds
Not to have hundreds of connections open all day long.
-
Re: MySQL Server with RoA's Locator
well i have no other choice since MSSQL won't install.
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
Military
well i have no other choice since MSSQL won't install.
Maybe I can help you?:) Add me on Msn Eele_mailadres@hotmail.com
I only do it by Teamviewer and if I have lagg on it I simple dont do it:P
-
Re: MySQL Server with RoA's Locator
Quote:
Originally Posted by
eele
Maybe I can help you?:) Add me on Msn
Eele_mailadres@hotmail.com
I only do it by Teamviewer and if I have lagg on it I simple dont do it:P
i don't think you can help...i get fatal system error in my installation and i have to reinstall windows.