MySQL trouble

[Zulaika]

I'm having trouble with the MySQL information for http://forums.alliedmods.net/showthread ... ost1513401:

I'm getting this error:

L 07/18/2011 - 17:36:03: New section, multiline unterminated (file "cstrike\addons\amxmodx\data\lang\ingame_psychostats.txt" line 341)
L 07/18/2011 - 17:36:06: [ingame_psychostats.amxx] [IG-PS] Error: (2003) Can't connect to MySQL server on 'localhost' (10061)
L 07/18/2011 - 17:36:06: [ingame_psychostats.amxx] [IG-PS] Query: SELECT `value` FROM `config` WHERE `var` = 'version';

[TimeX]

Using localhost only works if the database is located on the same machine as the game server. In the case of our standard game server rentals and managed servers, the psychostats are located on a remote machine. Installing the plugin from the "Autoinstallers" section of the control panel should configure the SQL information for you correctly.

[Zulaika]

Using localhost only works if the database is located on the same machine as the game server. In the case of our standard game server rentals and managed servers, the psychostats are located on a remote machine. Installing the plugin from the "Autoinstallers" section of the control panel should configure the SQL information for you correctly.

I didn't use localhost while installing the plugin, that's why I'm confused.

[TimeX]

That is a bit strange, since the error shows it trying to and failing. It may be that it is reading the database connection information from somewhere else in your server configuration.

[Zulaika]

That is a bit strange, since the error shows it trying to and failing. It may be that it is reading the database connection information from somewhere else in your server configuration.

This went into the amxx.cfg file:

// -------------------
// MySQL configuration

// Host of your database
ps_host ""
// User to login with
ps_user ""
// User password
ps_pass ""
// Database to connect to
ps_db ""
// Prefix of the tables
ps_prefix "ps_"

It should only be taking the information from that .cfg file.

[Edge100x]

Did you fill that out with the correct information -- the remote ps_host name (instead of ""), the right MySQL login name and password, and so on?

[Zulaika]

Did you fill that out with the correct information -- the remote ps_host name (instead of ""), the right MySQL login name and password, and so on?

Yes I did.

Edit: Could I send it to you to confirm it's correct?

[Edge100x]

Yes, if this is a shared or managed game server with us, please open a support request, and we can take a closer look at the file for you there.

[Zulaika]

Yes, if this is a shared or managed game server with us, please open a support request, and we can take a closer look at the file for you there.

Did it, Request #419093.