MySQL Server with RoA's Locator

[eele]

Hi guys, I'm trying to get my server running on a MySQL database..
This is for the matchserver I started up:

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..

[MentaL]

[Demantor]

Just:

Why MySQL?

[eele]

Just:

Why MySQL?

So I can have a database 24/7 online by a free host:P

[PaulBub]

What matchserver do you use?

[eele]

What matchserver do you use?

rev 5 by system32..

[Demantor]

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 ;)

[PaulBub]

It might only allow local connections, check in phpMyAdmin if you can change the allowed IPs, but it's not safe at all.

[o0slowpaul0o]

Was this the database I converted?

I kept getting database connection losses because all stored procedures wasn't in place.

- Exiled Hero.

[eele]

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 ----------

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.

[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.

[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.

[eele]

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.

[cerealnp]

Locator needs windows to run.

RoA's locator is open source, you can do another locator emulator to run at unix.

[eele]

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..

[Demantor]

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.

[Exiled Hero]

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.

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.

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);

[eele]

I don't miss that 2. I miss all:S Could you add me on Msn? eele_mailadres@hotmail.com

But thanks;)

[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.

[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

[Exiled Hero]

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.

[Asaki]

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

[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.

[Asaki]

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

[Lambda]

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.

[Asaki]

i ran with 8gb still mysql is not the ideal choice for gaming