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.
