next »

[sinister6500]

Ok, here we go, I decided to try to put echelon on the web instead of local network.

The only issue is that, everything is installed and working, but after I log in it states that there is no database selected.

Any help is grateful

Here is my Config.php

Code: php

date_default_timezone_set('America/New_York'); // see all available timezones at http://www.php.net/manual/en/timezones.php  
$path = "/echelon/";
$hide_admin_level = "128"; // 1, 2, 8, 16, 32, 64, 128 -> Hides clientdetails 

## settings for the echelon database
$hostname_wwwvalidate = "sql304.0fees.net";
$database_wwwvalidate = "echelon";
$username_wwwvalidate = "fees0_4757805";
$password_wwwvalidate = "*******";

## settings for your b3 databases
$config = array(
  "clanname" => "Extreme Terror Corps Clan",
  //How many servers do we have down here
  "numservers" => 3, 
  "servers" => array(
    1 => array(
      "name" => "ETCTR",
      // Database connection for the B3 
      "hostname" => "sql304.0fees.net",
      "database" => "fees0_4757805_cod5",
      "username" => "fees0_4757805",
      "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" => "68.106.92.201",
      "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" => 1
    ),
    2 => array(
      "name" => "ETRTR4",
      // Database connection for the B3
      "hostname" => "sql304.0fees.net",
      "database" => "fees0_4757805_cod4",
      "username" => "fees0_4757805",
      "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" => "68.106.92.201",
      "rcon_port" => "28964",
      "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" => 1
    ),
    3 => array(
      "name" => "Practice",
      // Database connection for the B3
      "hostname" => "sql304.0fees.net",
      "database" => "fees0_4757805_practice",
      "username" => "fees0_4757805",
      "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" => "68.106.92.201",
      "rcon_port" => "28963",
      "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" => 1
    )
  )
);
?>

[sinister6500]

  I fixed the issue, I did not have the echelon database name right  

I can not seem to get the database up and running...here is the database setup

here is the B3 Conf

Code:

<configuration>
  <settings name="b3">
    <!-- parser defines the game: cod/cod2/cod4/cod5/iourt41/etpro/wop/smg -->
    <set name="parser">cod5</set>
    <set name="database">mysql://fees0_4757805_cod5:*********@sql304.0fees.netfees0_4757805_cod5/cod5</set>
    <set name="bot_name">b3</set>
    <set name="bot_prefix">^0(^7=^3ETC^7=^0)^7:</set>
    <set name="time_format">%I:%M%p %Z %m/%d/%y</set>
    <set name="time_zone">CST</set>
    <!-- 9 = verbose, 10 = debug, 21 = bot, 22 = console -->
    <set name="log_level">9</set>
    <set name="logfile">b3.log</set>
  </settings>
  <settings name="server">
    <set name="rcon_password">******</set>
    <set name="port">28961</set>
    <set name="game_log">C:/ETC/main/games_mp.log</set>
    <set name="public_ip">68.106.92.201</set>
    <set name="rcon_ip">68.106.92.201</set>
    <set name="punkbuster">on</set>
  </settings>
  <settings name="messages">
    <set name="kicked_by">%s^7 was kicked by %s^7 %s</set>
    <set name="kicked">%s^7 was kicked %s</set>
    <set name="banned_by">%s^7 was banned by %s^7 %s</set>
    <set name="banned">%s^7 was banned %s</set>
    <set name="temp_banned_by">%s^7 was temp banned by %s^7 for %s^7 %s</set>
    <set name="temp_banned">%s^7 was temp banned for %s^7 %s</set>
    <set name="unbanned_by">%s^7 was un-banned by %s^7 %s</set>
    <set name="unbanned">%s^7 was un-banned %s</set>
  </settings>
  <settings name="plugins">
    <set name="external_dir">C:/ETC/BigBrotherBot_1.2.1/extplugins/</set>
  </settings>
  <plugins>
    <plugin name="censor" priority="1" config="@b3/conf/plugin_censor.xml"/>
    <plugin name="spamcontrol" priority="2" config="@b3/conf/plugin_spamcontrol.xml"/>
    <plugin name="admin" priority="3" config="@b3/conf/plugin_admin.xml"/>
    <plugin name="tk" priority="4" config="@b3/conf/plugin_tk.xml"/>
    <plugin name="stats" priority="5" config="@b3/conf/plugin_stats.xml"/>
    <plugin name="pingwatch" priority="6" config="@b3/conf/plugin_pingwatch.xml"/>
    <plugin name="adv" priority="7" config="@b3/conf/plugin_adv.xml"/>
    <plugin name="status" priority="8" config="@b3/conf/plugin_status.xml"/>
    <plugin name="welcome" priority="9" config="@b3/conf/plugin_welcome.xml"/>
    <plugin name="publist" priority="10" config="@b3/conf/plugin_publist.xml"/>
    <plugin name="punkbuster" priority="11" config="@b3/conf/plugin_punkbuster.xml"/>
<plugin name="chatlogger" priority="12" config="@b3/extplugins/conf/plugin_chatlogger.xml"/>
    <plugin name="ctime" priority="13" config="@b3/extplugins/conf/plugin_ctime.xml"/>
 
  This is a non-standard plugin, and quite resource heavy. Please take a look in the
  B3 forums (look for XLR Extensions) for more information before enabling this.
  Extra database tables are necessary.
    <plugin name="xlrstats" priority="14" config="@b3/extplugins/conf/xlrstats.xml"/>
-->
  </plugins>
</configuration>

[Courgette]

is this still related to an echelon issue ?

[Bakes]

you missed out a slash.

0fees.net/etc

[sinister6500]

is this still related to an echelon issue ?

No. this is  a new issue

[sinister6500]

you missed out a slash.

0fees.net/etc

I got the slash fixed, it still can not connect, I don't understand, every thing is correct as far as I know.
Here is my B3 Log:

091218 06:36:32   BOT       --------------------------------------------
091218 06:36:32   BOT       Attempting to connect to database mysql://fees0_4757805_cod5:******@sql304.0fees.net/fees0_4757805_cod5...
091218 06:36:32   ERROR   STDERR C:\ETC\BigBrotherBot_1.2.1\library.zip\MySQLdb\__init__.py:34: DeprecationWarning: the sets module is deprecated

091218 06:36:55   ERROR   Database connection failed, working in remote mode: (2003, "Can't connect to MySQL server on 'sql304.0fees.net' (10060)") - [('b3\\storage.pyo', 197, 'connect', None), ('b3\\storage.pyo', 153, 'getConnection', None), ('MySQLdb\\__init__.pyo', 74, 'Connect', None), ('MySQLdb\\connections.pyo', 170, '__init__', None)]
091218 06:36:55   BOT       Game log C:\ETC\main\games_mp.log
091218 06:36:55   BOT       Starting bot reading file C:\ETC\main\games_mp.log
091218 06:36:55   VERBOSE   RCON sending (192.168.1.100:28961) status
091218 06:36:56   BOT       Loading Plugin #1 censor [C:\ETC\BigBrotherBot_1.2.1\conf\plugin_censor.xml]
091218 06:36:56   BOT       CensorPlugin: Loading config C:\ETC\BigBrotherBot_1.2.1\conf\plugin_censor.xml for CensorPlugin
091218 06:36:56   DEBUG   Register Event: Stop Process: CensorPlugin
091218 06:36:56   DEBUG   Register Event: Program Exit: CensorPlugin
091218 06:36:56   BOT       Plugin censor (2.1.0 - ThorN) loaded
091218 06:36:56   BOT       Loading Plugin #2 spamcontrol [C:\ETC\BigBrotherBot_1.2.1\conf\plugin_spamcontrol.xml]
091218 06:36:56   BOT       SpamcontrolPlugin: Loading config C:\ETC\BigBrotherBot_1.2.1\conf\plugin_spamcontrol.xml for SpamcontrolPlugin
091218 06:36:56   DEBUG   Register Event: Stop Process: SpamcontrolPlugin
091218 06:36:56   DEBUG   Register Event: Program Exit: SpamcontrolPlugin
091218 06:36:56   BOT       Plugin spamcontrol (1.1.2 - ThorN) loaded06:40:30   VERBOSE   RCON sending (192.168.1.100:28961) status

[Bakes]

problem is that b3 cannot contact the 0fees database. My pc can't either. Does 0fees allow remote database connections?

[sinister6500]

I don't know
is there any free hosting for databases etc that you know of