next »

[sinister6500]

Ok, I have installed the echelon on to the site( no problems)
I have created a database with the user echelon and pass echelonb3

When I attempt to log in I get this:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Now I am running my servers on a home network, not renting any servers.
I am hosting a web server through 0fees.net

2. Create a MySQL database called echelon and a user (echelon)
with a password (echelonb3) that has access from localhost (if
your mysql is running on the same machine as your webserver) to
this database. (Don't forget to flush the privileges)
*How do I flush the privileges?*

Any help please.

Hope I posted this in the right spot.

Thanks

[arod2009]

Well I got echelon running with xampp and It works fine.... Have you given xamp a try?
Its easy to run with xampp im running my server at home too and i have access to my server locally and through the internet. I would recommend xampp give it a shot .

[sinister6500]

that's what I am running

I need to know what I am doing wrong, I am running the servers and the xampp on the same machine.

If you will tell me how you did your and I will attempt to correct what mistake(s) I made.

[sinister6500]

yea, I set up the DB as seen in the picture, all access is given

here is my inc_config.php...be advised, that I am only using 2 servers right now.

<?php
$path = "/echelon/";
$hide_admin_level = "128"; // 1, 2, 8, 16, 32, 64, 128 -> Hides clientdetails

## settings for the echelon database
$hostname_wwwvalidate = "localhost";
$database_wwwvalidate = "echelon";
$username_wwwvalidate = "echelon";
$password_wwwvalidate = "echelonb3";

## settings for your b3 databases
$config = array(
  "clanname" => "Extreme Terror Corps",
  //How many servers do we have down here
  "numservers" => 2,
  "servers" => array(
    1 => array(
      "name" => "cod4",
      // Database connection for the B3
      "hostname" => "localhost",
      "database" => "cod4",
      "username" => "cod4",
      "password" => "********",
      //Do we have PunkBuster in this game? If yes, we'll use RCON to ban/unban PB-guids - Set it to "0" if not.
      "PBactive" => "1",
      //Set up rcon for talkback (need chatlogger plugin installed) and PB banning facilities
      "rcon_ip" => "68.106.91.179",
      "rcon_port" => "28966",
      "rcon_pass" => "*****",
      // set to 1 if you want permban from that server included into the banlist page.
      "include_in_banlist" => 1,
      // set this to 1 if you are using the chatlogger plugin setup for that server. (see http://www.bigbrotherbot.com/forums/index.php?topic=423.0)
      "chatlogger_activated" => 0
    ),
    2 => array(
      "name" => "cod5",
      // Database connection for the B3
      "hostname" => "localhost",
      "database" => "b5",
      "username" => "b5",
      "password" => "*******",
      //Do we have PunkBuster in this game? If yes, we'll use RCON to ban/unban PB-guids - Set it to "0" if not.
      "PBactive" => "1",
      //Set up rcon for talkback (need chatlogger plugin installed) and PB banning facilities
      "rcon_ip" => "68.106.91.179",
      "rcon_port" => "28961",
      "rcon_pass" => "*****",
      // set to 1 if you want permban from that server included into the banlist page.
      "include_in_banlist" => 1,
      // set this to 1 if you are using the chatlogger plugin setup for that server. (see http://www.bigbrotherbot.com/forums/index.php?topic=423.0)
      "chatlogger_activated" => 0
    ),
    3 => array(
      "name" => "COD2",
      // Database connection for the B3
      "hostname" => "localhost",
      "database" => "databasename",
      "username" => "db-username",
      "password" => "db-password",
      //Do we have PunkBuster in this game? If yes, we'll use RCON to ban/unban PB-guids - Set it to "0" if not.
      "PBactive" => "0",
      //Set up rcon for talkback (need chatlogger plugin installed) and PB banning facilities
      "rcon_ip" => "127.0.0.1",
      "rcon_port" => "28960",
      "rcon_pass" => "rconpassword",
      // set to 1 if you want permban from that server included into the banlist page.
      "include_in_banlist" => 0,
      // set this to 1 if you are using the chatlogger plugin setup for that server. (see http://www.bigbrotherbot.com/forums/index.php?topic=423.0)
      "chatlogger_activated" => 0
    )
  )
);
?>

[arod2009]

Heres My  Config with one server.
If your B3 bot is working fine and it connects to your db.
then your echelon user is set up wrong.
if you created the echelon db and imported sql file to create tables
then all i can think of is your user settings or your sql server is down or not working properly.
But if your SQL server is not funtioning properly then I doubt b3 is connecting to db.

Sorry if I couldn't help..
It seems you've done everything correct. I check SQL and make sure it's running correctly.

Code:

<?php
$path = "/echelon/";
$hide_admin_level = "128"; // 1, 2, 8, 16, 32, 64, 128 -> Hides clientdetails

## settings for the echelon database
$hostname_wwwvalidate = "localhost";
$database_wwwvalidate = "echelon";
$username_wwwvalidate = "echelon";
$password_wwwvalidate = "echelonb3";

## settings for your b3 databases
$config = array(
  "clanname" => "1S1K",
  //How many servers do we have down here
  "numservers" => 1,
  "servers" => array(
    1 => array(
      "name" => "1S1K",
      // Database connection for the B3
      "hostname" => "localhost",
      "database" => "b3",
      "username" => "b3",
      "password" => "XXXXXXXX",
      //Do we have PunkBuster in this game? If yes, we'll use RCON to ban/unban PB-guids - Set it to "0" if not.
      "PBactive" => "0",
      //Set up rcon for talkback (need chatlogger plugin installed) and PB banning facilities
      "rcon_ip" => "127.0.0.1",
      "rcon_port" => "28960",
      "rcon_pass" => "XXXXXXXX",
      // set to 1 if you want permban from that server included into the banlist page.
      "include_in_banlist" => 1,
      // set this to 1 if you are using the chatlogger plugin setup for that server. (see http://www.bigbrotherbot.com/forums/index.php?topic=423.0)
      "chatlogger_activated" => 0

[Bakes]

you could just execute the sql file on your normal b3 db.

Then you can use your normal b3 db info for the echelon login.

[sinister6500]

you could just execute the sql file on your normal b3 db.

Then you can use your normal b3 db info for the echelon login.

how? I did, what I think u told me to do and still nothing.
I get this when I attempt to connect: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I created a DB on my B3 DB, changed the inc_config.php to:
<?php
$path = "/echelon/";
$hide_admin_level = "128"; // 1, 2, 8, 16, 32, 64, 128 -> Hides clientdetails

## settings for the echelon database
$hostname_wwwvalidate = "localhost";
$database_wwwvalidate = "b5";
$username_wwwvalidate = "b5";
$password_wwwvalidate = "******";

## settings for your b3 databases
$config = array(
  "clanname" => "Extreme Terror Corps",
  //How many servers do we have down here
  "numservers" => 2,
  "servers" => array(
    1 => array(
      "name" => "cod4",
      // Database connection for the B3
      "hostname" => "localhost",
      "database" => "cod4",
      "username" => "root",
      "password" => "*******",
      //Do we have PunkBuster in this game? If yes, we'll use RCON to ban/unban PB-guids - Set it to "0" if not.
      "PBactive" => "1",
      //Set up rcon for talkback (need chatlogger plugin installed) and PB banning facilities
      "rcon_ip" => "68.106.91.179",
      "rcon_port" => "28966",
      "rcon_pass" => "******",
      // set to 1 if you want permban from that server included into the banlist page.
      "include_in_banlist" => 1,
      // set this to 1 if you are using the chatlogger plugin setup for that server. (see http://www.bigbrotherbot.com/forums/index.php?topic=423.0)
      "chatlogger_activated" => 0
    ),
    2 => array(
      "name" => "cod5",
      // Database connection for the B3
      "hostname" => "localhost",
      "database" => "b5",
      "username" => "root",
      "password" => "***",
      //Do we have PunkBuster in this game? If yes, we'll use RCON to ban/unban PB-guids - Set it to "0" if not.
      "PBactive" => "1",
      //Set up rcon for talkback (need chatlogger plugin installed) and PB banning facilities
      "rcon_ip" => "68.106.91.179",
      "rcon_port" => "28961",
      "rcon_pass" => "****",
      // set to 1 if you want permban from that server included into the banlist page.
      "include_in_banlist" => 1,
      // set this to 1 if you are using the chatlogger plugin setup for that server. (see http://www.bigbrotherbot.com/forums/index.php?topic=423.0)
      "chatlogger_activated" => 0
    ),
    3 => array(
      "name" => "COD2",
      // Database connection for the B3
      "hostname" => "localhost",
      "database" => "databasename",
      "username" => "db-username",
      "password" => "db-password",
      //Do we have PunkBuster in this game? If yes, we'll use RCON to ban/unban PB-guids - Set it to "0" if not.
      "PBactive" => "0",
      //Set up rcon for talkback (need chatlogger plugin installed) and PB banning facilities
      "rcon_ip" => "127.0.0.1",
      "rcon_port" => "28960",
      "rcon_pass" => "rconpassword",
      // set to 1 if you want permban from that server included into the banlist page.
      "include_in_banlist" => 0,
      // set this to 1 if you are using the chatlogger plugin setup for that server. (see http://www.bigbrotherbot.com/forums/index.php?topic=423.0)
      "chatlogger_activated" => 0
    )
  )
);
?>

[Courgette]

I don't get how you run into

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

if you are using Microsoft Windows and Xampp...

[sinister6500]

I don't get how you run into if you are using Microsoft Windows and Xampp...

I don't either

But its not something I just made up

[sinister6500]

*bump
 

[sinister6500]

hello, some help would be nice, I know y'all busy but I have not seen a lot of forums active, so I know someone could help me here...

Here is a video that shows what I do, maybe that will shine some light on the subject

http://www.youtube.com/watch?v=9i4x2Q9UYrg

sorry for the bouncing cam, working with one hand here...

[xlr8or]

Well, I have to admit you're really original  .
It seems that you're drifting somewhat to get it all going and you're changing files that do not need to be changed.

You do not need to alter the file /echelon/Connections/wwwvalidate.php
The only file that needs to be changed is the inc_config.php file in that same directory

As far as I could see your inc_config.php database credentials should be:

## settings for the echelon database
$hostname_wwwvalidate = "localhost";
$database_wwwvalidate = "echelon";
$username_wwwvalidate = "echelon";
$password_wwwvalidate = "echelonb3";

Please double check the username and password in the phpMyAdmin privileges table (/phpmyadmin/server_privileges.php). Because it is the information that echelon needs to connect to the mysql database.

If that doesn't work is there any way to give me temporary access to the server so I can take a look and investigate what's going on?

[sinister6500]

what server do u need access to? FTP?
or the localhost?

If its the localhost host, you're gonna have to tell me how to do it(still wet behind the ears on xampp)

thanks

[xlr8or]

I'm not sure I got the situation clear. I'll have to make sure that's the case before I can make any proper suggestions.

It's a good idea to give us a detailed overview of what is installed on what machine. We'll need to know where the game is installed, where B3 is installed, where the B3 database is installed, where the echelon database is installed and where the echelon website is installed.

[sinister6500]

I'm not sure I got the situation clear. I'll have to make sure that's the case before I can make any proper suggestions.

It's a good idea to give us a detailed overview of what is installed on what machine. We'll need to know where the game is installed, where B3 is installed, where the B3 database is installed, where the echelon database is installed and where the echelon website is installed.

Every thing is on one machine, I am using xampp(of course) hosting all DB's
as you seen in the video. All games are hosted on the same machine as well.
Every game has its own copy of BB on it.
I do not play on this machine(play games)