[Kenny Loggins]

Originally Posted by OpenAreas Put on server, but so much lack of support in terms of setting this up, i deleted it. Doesn't deserve to be on my servers if the support is so utter crap

You talk like this plugin is a paid service or something. What don’t you think this guy has a real life? You think he just sits around and waits to teach everyone how to use MySql or how to properly install and configure a plugin?

I have used this for a long time was easy to setup and I don't think I had any questions. It works great with no problems at all

Sounds like you don't know what you’re doing.

It’s always easy to blame someone else.

[Crypt1cMayh3m]

Originally Posted by Peace-Maker Had this too, so we fixed the plugin to use threaded queries/connections only.

I really wanted to use this plugin on our servers, but the original version caused severe lag and this updated version caused too many connections to the MySQL server. I guess we'll have to settle for the config file version of this for the time being.

[Derek]

Great plugin, we will be installing this shortly.

[Richard.UK]

OK any help would be appreciated as to why my Gameserver will not communicate with my MYSQL server?

Basically i've tried fo hours trying to figure this out and still no joy...I really hope someone understands what is incorrect here:

Used PHPMY Admin to create the "Server" Table. running the query obviously very quick to create, then the additional server rows (I have 4) using the following command:

INSERT INTO `server` (`id`, `address`, `groupnumber`, `last_update`, `display_name`, `offline_name`, `maxplayers`, `currplayers`, `map`) VALUES
(1, '217.163.31.207:27015', 1, '2008-12-31 00:00:00', 'TF2 UK | {MAP} | {CURR}/{MAX}', 'TF2 UK | OFFLINE', 0, 0, '[no map]');
INSERT INTO `server` (`id`, `address`, `groupnumber`, `last_update`, `display_name`, `offline_name`, `maxplayers`, `currplayers`, `map`) VALUES
(2, '216.245.211.61:27015', 1, '2008-12-31 00:00:00', 'TF2 US | {MAP} | {CURR}/{MAX}', 'TF2 US | OFFLINE', 0, 0, '[no map]');
INSERT INTO `server` (`id`, `address`, `groupnumber`, `last_update`, `display_name`, `offline_name`, `maxplayers`, `currplayers`, `map`) VALUES
(3, '212.187.209.75:27015', 2, '2008-12-31 00:00:00', 'CSS UK | {MAP} | {CURR}/{MAX}', 'CSS UK | OFFLINE', 0, 0, '[no map]');
INSERT INTO `server` (`id`, `address`, `groupnumber`, `last_update`, `display_name`, `offline_name`, `maxplayers`, `currplayers`, `map`) VALUES
(4, '85.234.148.165:27055', 2, '2008-12-31 00:00:00', 'CSS WCS | {MAP} | {CURR}/{MAX}', 'CSS WCS | OFFLINE', 0, 0, '[no map]');

Databases Config File:

{
            "driver"               "mysql"
            "host"                 "http://*****.****.***"
            "database"           "serverredirect" <--- created via control panel
            "user"                  "**********" <--- created via control panel
            "pass"                  "**********" <--- created via control panel
            //"timeout"                "0"
            "port"                "2082"
        }

User access given:

FULL CONTROL

Remote MYSQL has my server IP added to Allow:

217.163.31.207

Added databases.cfg to whitelist.cfg using the following:

"add"        "addons/sourcemod/configs/databases.cfg"

When reloading the server I have followed this process:

Log onto Gameserver control Panel > STOP SERVER > START SERVER

When I type !server, the horrible statement of sorry can not find the servers appears. I would highly value anybodies help in correcting this problem with communication between MYSQL and sourcemod...Although please bear in mind I am not an idiot hence why I have taken 6 hour and more to post here. This is probably as usual something simple which I am missing out

All the Very Best,
Richard

[Sexual Harassment Panda]

did you connect your user to your database and give it full access?

[Richard.UK]

EDIT above, Yes panda full control is given to the user specified!

[Richard.UK]

does anyone have any suggestion for this please? I have given extensive information as you can tell i'm not being silly here...I would hate this to be a problem with the mod

[Crypt1cMayh3m]

Have you tried using your MYSQL server's IP address instead of URL for the "host" value in databases.cfg?

[superkom]

Question: On our dedi server we have A set of css servers and a set of TF2 servers each named 1 and 2 respectivly. Now when I I connect and type !servers on the Tf2 servers they can't find each other "Currently there are no server available" But the CSS servers work fine. and they were assigned groupnumber 1 and Tf2 group number 2. When I change the Tf2 servers one from 2 to 1 they can easily find the CSS servers ( In other words the ones in group 1) Can anyoe shed some light on how I change it so group 2 find group 2's etc, or do I need to create a new database?

[Faust_mateo]

anyone know of a simple way to redirect players to another server when the server is full?