[jonnzus]

I'm trying run GeoLite_import.sh but it won't run. Any idea what to do?
Os is debian and pureperl is uptodate.

[Mavrick4283]

chmod +x GeoLite_import.sh

then run it

[jonnzus]

I did chmod +x it but still won't run.
But GeoLite started to work, I did to forget install pureperl

[jonnzus]

Hmm, need bit help with bans

My hlstatsxban.cfg

<?php
//** SOURCEBANS MYSQL INFO ----------------------------
// http://www.sourcebans.net/
define('SB_HOST', 'localhost');      // MySQL host
define('SB_PORT', 3306);             // MySQL port (Default 3306)
define('SB_USER', '');               // MySQL user
define('SB_PASS', '');               // MySQL password
define('SB_NAME', '');               // MySQL database name
define('SB_PREFIX', 'sb');           // MySQL table prefix
//** END SOURCEBANS MYSQL INFO ------------------------

//** AMXBANS MYSQL INFO -------------------------------
// http://www.amxbans.net/
define('AMX_HOST', 'localhost');      // MySQL host
define('AMX_PORT', 3306);             // MySQL port (Default 3306)
define('AMX_USER', 'xxx');               // MySQL user
define('AMX_PASS', 'xxx');               // MySQL password
define('AMX_NAME', 'xxx');               // MySQL database name
define('AMX_PREFIX', 'xxx');          // MySQL table prefix
//** END AMXBANS MYSQL INFO ---------------------------

//** BEETLESMOD MYSQL INFO ----------------------------
// http://www.beetlesmod.com/
define('BM_HOST', 'localhost');       // MySQL host
define('BM_PORT', 3306);              // MySQL port (Default 3306)
define('BM_USER', '');                // MySQL user
define('BM_PASS', '');                // MySQL password
define('BM_NAME', '');                // MySQL database name
define('BM_PREFIX', 'bm');            // MySQL table prefix
//** END BEETLESMOD MYSQL INFO ------------------------

//** GLOBALBAN MYSQL INFO -----------------------------
// http://addons.eventscripts.com/addons/view/GlobalBan
// http://forums.eventscripts.com/viewtopic.php?t=14384
define('GB_HOST', 'localhost');       // MySQL host
define('GB_PORT', 3306);              // MySQL port (Default 3306)
define('GB_USER', '');                // MySQL user
define('GB_PASS', '');                // MySQL password
define('GB_NAME', 'global_ban');      // MySQL database name
define('GB_PREFIX', 'gban');          // MySQL table prefix
//** END GLOBALBAN MYSQL INFO -------------------------

//** MySQL Banning - MYSQL INFO -----------------------
// http://forums.alliedmods.net/showthread.php?t=65822
define('MB_HOST', 'localhost');       // MySQL host
define('MB_PORT', 3306);              // MySQL port (Default 3306)
define('MB_USER', '');                // MySQL user
define('MB_PASS', '');                // MySQL password
define('MB_NAME', '');                // MySQL database name
define('MB_PREFIX', 'mysql');         // MySQL table prefix
//** END MySQL Banning - MYSQL INFO -------------------

//** HLSTATSX MYSQL INFO ------------------------------
// http://www.hlxcommunity.com/
define('HLX_HOST', 'localhost');      // MySQL host
define('HLX_PORT', 3306);             // MySQL port (Default 3306)
define('HLX_USER', 'xxx');               // MySQL user
define('HLX_PASS', 'xxx');               // MySQL password
define('HLX_PREFIX', '');      // MySQL table prefix

/*************************************************
/* We're using different databases for each of our server to isolate each ranking
/* Type the HLstatsX database name here like
/ $hlxdbs[] = "databasename";
/* It's fine to just type one database.
**************************************************/
$hlxdbs = array();
$hlxdbs[] = "hlxe";
//** END HLSTATSX MYSQL INFO --------------------------

?>

Now when I type php hlstatsxban.php it shows:
Please type your database information for HLstatsX and at least for one other ban database.hlxe@b-elit:/home/joona/hlxe/scriptat/ImportBans$

What I have missed?

[Mavrick4283]

You have to fill out one of those with the ban DB info and then at the bottom fill out your hlx;ce DB info

[jonnzus]

I have filled those. I just did put xxx to fields that I have filled in my cfg.

[Mavrick4283]

Try 127.0.0.1 vs localhost TBH the guy who made these scripts have not been around for some time so there is no docs or read me files.

[jonnzus]

I just thought that problem might be that I havent done chown -R hlxceuser /config.cfg, i just made it for scipts folder.

[Eska]

Originally Posted by jonnzus I just thought that problem might be that I havent done chown -R hlxceuser /config.cfg, i just made it for scipts folder.

Well, in any plugin i used with SRCDS, if You have MySQL locally, use '127.0.0.1' instead of 'localhost'.
Somehow it wont connect to 'localhost', but he will sure do to 127.0.0.1 :-)

You can always try to put there Your external IP, check it by command:

ifconfig | grep 'inet addr:'

[Mavrick4283]

The reason why you have to use 127.0.0.1 is MySQL supports both socket connections and TCP/IP connections so as far as the server is concerned they are different address so if you do not have the user set up to be allowed on localhost IE

grant w/e permissions on database_name.* to 'username'@'localhost' identified by 'userpassword';

it will be denied because MySQL rejects ALL connects you do not setup.