In our support boards we aim to provide support for the B3 core in its current state. Older releases of B3 are NOT supported. Check our front page for the latest version. You may post feature requests in our General Discussion board. Modifications and Hacks of the core B3 code are NOT supported.
Before you ask for support: [ Read the Support Instructions ] - More info: [ Full Support Disclaimer ]

You are here: Big Brother Bot ForumSupport ForumsInstallation Support (Moderator: MordyT)Re: Connection to DB...
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Re: Connection to DB...  (Read 364 times) Bookmark and Share
BLUE1984
Newbie
*
OS: Windows
Type: Home user
Gameservers: cod4
Posts: 4
Offline Offline
« on: December 18, 2010, 02:49:59 AM »
hi can any1 help me with this been messing about for about four hour and can not get this to work hers my b3.xml
Quote
<?xml version='1.0'?>
<!--
 This file is generated by the B3 setup Procedure.
 If you want to regenerate this file and make sure the format is
 correct, you can invoke the setup procedure with the
 command : b3_run -s b3.xml

 This is B3 main config file (the one you specify when you run B3 with the
 command : b3_run -c b3.xml)

 For any change made in this config file, you have to restart the bot.
 Whenever you can specify a file/directory path, the following shortcuts
 can be used :
  @b3 : the folder where B3 code is installed in
  @conf : the folder containing this config file
 -->
<configuration>
   <settings name="b3">
      <!-- Define your game: cod/cod2/cod4/cod5/cod6/iourt41/etpro/wop/smg/bfbc2/moh -->
      <set name="parser">cod6</set>
      <!-- Your database info: [mysql]://[db-user]:[db-password]@[db-server[:port]]/[db-name] -->
      <set name="database">mysql://b3:mypassword@92.235.107.124:3306/blue_b3</set>
      <set name="database">mypassword</set>
      <!-- Name of the bot -->
      <set name="bot_name">b3</set>
      <!-- Ingame messages are prefixed with this code, you can use colorcodes -->
      <set name="bot_prefix">^0(^2b3^0)^7:</set>
      <set name="time_format">%I:%M%p %Z %m/%d/%y</set>
      <!-- The timezone your bot is in -->
      <set name="time_zone">GMT</set>
      <!-- How much detail in the logfile: 9 = verbose, 10 = debug, 21 = bot, 22 = console -->
      <set name="log_level">9</set>
      <!-- Name of the logfile the bot will generate -->
      <set name="logfile">b3.log</set>
   </settings>
   <settings name="server">
      <!-- The RCON pass of your gameserver -->
      <set name="rcon_password">mypassword</set>
      <!-- The port the server is running on -->
      <set name="port">28961</set>
      <!-- The gameserver generates a logfile, put the path and name here -->
      <set name="game_log">D:\tptbgames\Modern Warfare 2 - Copy\mods\isnipe2\games_mp.log</set>
      <!-- The public IP your gameserver is residing on -->
      <set name="public_ip">92.235.107.124</set>
      <!-- The IP the bot can use to send RCON commands to (127.0.0.1 when on the same box) -->
      <set name="rcon_ip">192.168.1.4</set>
      <!-- Is the gameserver running PunkBuster Anticheat: on/off -->
      <set name="punkbuster">off</set>
   </settings>
   <settings name="autodoc">
      <!-- Autodoc will generate a user documentation for all B3 commands -->
      <!-- by default, a html documentation is created in your conf folder -->

      <!-- html, htmltable or xml -->
      <set name="type">html</set>
      <!-- if you want to exclude commands reserved for higher levels -->
      <set name="maxlevel">100</set>
      <!-- Destination can be a file or a ftp url -->
      <set name="destination">test_doc.html</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">@b3/extplugins</set>
   </settings>
   <plugins><!-- plugin order is important. Plugins that add new in-game commands all depend on the admin plugin. Make sure to have the admin plugin before them. -->

      <plugin config="@conf/plugin_censor.xml" name="censor" />
      <plugin config="@conf/plugin_spamcontrol.xml" name="spamcontrol" />
      <plugin config="@conf/plugin_admin.xml" name="admin" />
      <plugin config="@conf/plugin_tk.xml" name="tk" />
      <plugin config="@conf/plugin_stats.xml" name="stats" />
      <plugin config="@conf/plugin_pingwatch.xml" name="pingwatch" />
      <plugin config="@conf/plugin_adv.xml" name="adv" />
      <plugin config="@conf/plugin_status.xml" name="status" />
      <plugin config="@conf/plugin_welcome.xml" name="welcome" />
      <!-- The punkbuster plugin was not installed since punkbuster is not supported or disabled. -->
      <!-- The next plugins are external, 3rd party plugins and should reside in the external_dir. Example: -->
      <!-- plugin config="@b3/extplugins/conf/newplugin.xml" name="newplugin" -->

      <!-- You can add new/custom plugins to this list using the same form as above. -->
   </plugins>
</configuration>

and heres my b3.log
Quote
101218 10:36:54   BOT       www.bigbrotherbot.net (b3) v1.4.1 [nt] (Daniel) [Win32 standalone]
101218 10:36:54   BOT       Python: 2.6.1 (r261:67517, Dec  4 2008, 16:51:00) [MSC v.1500 32 bit (Intel)]
101218 10:36:54   BOT       Starting Cod6Parser v0.2 for server 192.168.1.4:28961
101218 10:36:54   BOT       --------------------------------------------
101218 10:36:54   BOT       Attempting to connect to database file://None:******@Nonemypassword...
101218 10:36:54   ERROR   Database connection failed, working in remote mode: Unknown database protocol file - [('b3\\storage.pyo', 207, 'connect', None), ('b3\\storage.pyo', 173, 'getConnection', None)]
101218 10:36:54   BOT       Game log D:\tptbgames\Modern Warfare 2 - Copy\mods\isnipe2\games_mp.log
101218 10:36:54   BOT       Starting bot reading file D:\tptbgames\Modern Warfare 2 - Copy\mods\isnipe2\games_mp.log
101218 10:36:54   VERBOSE   RCON sending (192.168.1.4:28961) status
101218 10:36:55   BOT       Loading Plugins (external plugin directory: C:\Program Files (x86)\BigBrotherBot_1.4.1\extplugins)
101218 10:36:55   BOT       Loading Plugin #1 censor [@conf\plugin_censor.xml]
101218 10:36:55   BOT       CensorPlugin: Loading config @conf\plugin_censor.xml for CensorPlugin
101218 10:36:55   DEBUG   Register Event: Stop Process: CensorPlugin
101218 10:36:55   DEBUG   Register Event: Program Exit: CensorPlugin
101218 10:36:55   BOT       Plugin censor (2.2.1 - ThorN) loaded
101218 10:36:55   BOT       Loading Plugin #2 spamcontrol [@conf\plugin_spamcontrol.xml]
101218 10:36:55   BOT       SpamcontrolPlugin: Loading config @conf\plugin_spamcontrol.xml for SpamcontrolPlugin
101218 10:36:55   DEBUG   Register Event: Stop Process: SpamcontrolPlugin
101218 10:36:55   DEBUG   Register Event: Program Exit: SpamcontrolPlugin
101218 10:36:55   BOT       Plugin spamcontrol (1.1.2 - ThorN) loaded
101218 10:36:55   BOT       Loading Plugin #3 admin [@conf\plugin_admin.xml]
101218 10:36:55   BOT       AdminPlugin: Loading config @conf\plugin_admin.xml for AdminPlugin
101218 10:36:55   DEBUG   Register Event: Stop Process: AdminPlugin
101218 10:36:55   DEBUG   Register Event: Program Exit: AdminPlugin
101218 10:36:55   BOT       Plugin admin (1.8.2 - ThorN, xlr8or, Courgette) loaded
101218 10:36:55   BOT       Loading Plugin #4 tk [@conf\plugin_tk.xml]
101218 10:36:55   BOT       TkPlugin: Loading config @conf\plugin_tk.xml for TkPlugin
101218 10:36:55   DEBUG   TkPlugin: tk max level is 40
101218 10:36:55   DEBUG   TkPlugin: Send messages privately ? True
101218 10:36:55   DEBUG   Register Event: Stop Process: TkPlugin
101218 10:36:55   DEBUG   Register Event: Program Exit: TkPlugin
101218 10:36:55   BOT       Plugin tk (1.2.4 - ThorN) loaded
101218 10:36:55   BOT       Loading Plugin #5 stats [@conf\plugin_stats.xml]
101218 10:36:55   BOT       StatsPlugin: Loading config @conf\plugin_stats.xml for StatsPlugin
101218 10:36:55   DEBUG   StatsPlugin: Using default value (0) for commands::mapstats
101218 10:36:55   DEBUG   StatsPlugin: Using default value (0) for commands::testscore
101218 10:36:55   DEBUG   StatsPlugin: Using default value (2) for commands::topstats
101218 10:36:55   DEBUG   Register Event: Stop Process: StatsPlugin
101218 10:36:55   DEBUG   Register Event: Program Exit: StatsPlugin
101218 10:36:55   BOT       Plugin stats (1.3.4 - ThorN, GrosBedo) loaded
101218 10:36:55   BOT       Loading Plugin #6 pingwatch [@conf\plugin_pingwatch.xml]
101218 10:36:55   BOT       PingwatchPlugin: Loading config @conf\plugin_pingwatch.xml for PingwatchPlugin
101218 10:36:55   VERBOSE   Added crontab <bound method PingwatchPlugin.check of <b3.plugins.pingwatch.PingwatchPlugin instance at 0x032C34B8>> (53206576) - [0, 30]s -1m -1h -1d -1M -1DOW
101218 10:36:55   DEBUG   AdminPlugin: Command "ci (None)" registered with cmd_ci for level (20, 100)
101218 10:36:55   DEBUG   Register Event: Stop Process: PingwatchPlugin
101218 10:36:55   DEBUG   Register Event: Program Exit: PingwatchPlugin
101218 10:36:55   BOT       Plugin pingwatch (1.2.2 - ThorN) loaded
101218 10:36:55   BOT       Loading Plugin #7 adv [@conf\plugin_adv.xml]
101218 10:36:55   BOT       AdvPlugin: Loading config @conf\plugin_adv.xml for AdvPlugin
101218 10:36:55   INFO   AdvPlugin: adv rate is 2
101218 10:36:55   VERBOSE   AdvPlugin: self._feedmaxitems: 4
101218 10:36:56   DEBUG   AdvPlugin: 2 -> (*/2,0)
101218 10:36:56   VERBOSE   Added crontab <bound method AdvPlugin.adv of <b3.plugins.adv.AdvPlugin instance at 0x032C3800>> (54274416) - 0s [0, 2, 4, 6, 8, 10, 12, 14, 16, 18, 20, 22, 24, 26, 28, 30, 32, 34, 36, 38, 40, 42, 44, 46, 48, 50, 52, 54, 56, 58]m -1h -1d -1M -1DOW
101218 10:36:56   DEBUG   Register Event: Stop Process: AdvPlugin
101218 10:36:56   DEBUG   Register Event: Program Exit: AdvPlugin
101218 10:36:56   BOT       Plugin adv (1.2.2 - ThorN) loaded
101218 10:36:56   BOT       Loading Plugin #8 status [@conf\plugin_status.xml]
101218 10:36:56   BOT       StatusPlugin: Loading config @conf\plugin_status.xml for StatusPlugin
101218 10:36:56   VERBOSE   Added crontab <bound method StatusPlugin.update of <b3.plugins.status.StatusPlugin instance at 0x033C1F30>> (55970256) -
  • s -1m -1h -1d -1M -1DOW
101218 10:36:56   DEBUG   Register Event: Stop Process: StatusPlugin
101218 10:36:56   DEBUG   Register Event: Program Exit: StatusPlugin
101218 10:36:56   BOT       Plugin status (1.4.3 - ThorN) loaded
101218 10:36:56   BOT       Loading Plugin #9 welcome [@conf\plugin_welcome.xml]
101218 10:36:56   BOT       WelcomePlugin: Loading config @conf\plugin_welcome.xml for WelcomePlugin
101218 10:36:56   DEBUG   AdminPlugin: Command "greeting (None)" registered with cmd_greeting for level (20, 100)
101218 10:36:56   INFO   WelcomePlugin: delay set to 30. The bot will wait 30s after a player connects to write the welcome message
101218 10:36:56   INFO   WelcomePlugin: min_gap set to 3600. The bot will not welcome a player more than once every 3600 seconds
101218 10:36:56   DEBUG   Register Event: Stop Process: WelcomePlugin
101218 10:36:56   DEBUG   Register Event: Program Exit: WelcomePlugin
101218 10:36:56   BOT       Plugin welcome (1.1 - ThorN) loaded
101218 10:36:56   BOT       Loading Plugin publist
101218 10:36:56   BOT       PublistPlugin: No config file found for PublistPlugin. (was not required either)
101218 10:36:56   DEBUG   Register Event: Stop Process: PublistPlugin
101218 10:36:56   DEBUG   Register Event: Program Exit: PublistPlugin
101218 10:36:56   BOT       Plugin publist (1.8 - ThorN, Courgette) loaded
101218 10:36:56   VERBOSE   0 cid changed from None to -1
101218 10:36:56   VERBOSE   RCON sending (192.168.1.4:28961) say ^0(^2b3^0)^7: ^8www.bigbrotherbot.net ^0(^8b3^0) ^9v1.4.1 [nt] ^9(^3Daniel^9)^3 ^2[ONLINE]
101218 10:36:56   DEBUG   Client Connected: [-1] World - WORLD ({})
101218 10:36:56   DEBUG   Storage: getClient <b3.clients.Client object at 0x036822D0>
101218 10:36:56   BOT       Attempting to connect to database file://None:******@Noneyx02dyw...
101218 10:36:56   DEBUG   User not found WORLD: 'No client matching guid WORLD in admins_cache'
101218 10:36:56   BOT       Client not found in the storage WORLD, create new
101218 10:36:56   DEBUG   Storage: setClient <b3.clients.Client object at 0x036822D0>
101218 10:36:56   DEBUG   Storage: setClient data {'time_add': 1292668616, 'time_edit': 1292668616, 'name': 'World', 'group_bits': 0, 'ip': '', 'greeting': '', 'auto_login': 1, 'connections': 1, 'mask_level': 0, 'guid': 'WORLD', 'pbid': 'WORLD'}
101218 10:36:56   BOT       Attempting to connect to database file://None:******@Noneyx02dyw...
101218 10:36:56   DEBUG   Client Authorized: [-1] World - WORLD
101218 10:36:56   VERBOSE   RCON sending (192.168.1.4:28961) status
101218 10:36:57   INFO   map is: mp_rust
101218 10:36:57   DEBUG   Forcing server cvar g_logsync to 1
101218 10:36:57   VERBOSE   RCON sending (192.168.1.4:28961) set g_logsync 1
101218 10:36:58   VERBOSE   RCON sending (192.168.1.4:28961) fs_game
101218 10:36:59   DEBUG   Get cvar fs_game = ["fs_game" is: "mods/isnipe2^7" default: "^7"
  Domain is any text
 ]
101218 10:36:59   VERBOSE   RCON sending (192.168.1.4:28961) fs_basepath
101218 10:37:00   DEBUG   Get cvar fs_basepath = ["fs_basepath" is: "D:\tptbgames\Modern Warfare 2 - Copy^7" default: "D:\tptbgames\Modern Warfare 2 - Copy^7"
  Domain is any text
 ]
101218 10:37:00   VERBOSE   RCON sending (192.168.1.4:28961) status
101218 10:37:00   DEBUG   fs_basepath: D:\tptbgames\Modern Warfare 2 - Copy
101218 10:37:00   VERBOSE   RCON sending (192.168.1.4:28961) fs_homepath

r if some 1 can sort it for me would be great thanks as i am a nooby with this
« Last Edit: December 18, 2010, 03:05:27 AM by BLUE1984 » Logged
xlr8or
[ www.xlrstats.com ]
Project Lead
*
OS: Linux
Type: Owner dedicated server(s)
Gameservers: CoD, CoD2, CoD5, UrT
Posts: 2022
Offline Offline
WWW
Support Specialty: B3-Core, CoD/UrT/WoP/ETPro parsers, Plugin development
« Reply #1 on: December 18, 2010, 03:01:10 AM »
First of all, do not hijack other peoples topics, even if your problem is the same.

Look at your b3.xml, what's this:

Code: xml
      mysql://b3:mypassword@92.235.107.124:3306/blue_b3
      mypassword

If in doubt use our online config generator: http://config.bigbrotherbot.net/
Logged

Github repo - Groupware
BLUE1984
Newbie
*
OS: Windows
Type: Home user
Gameservers: cod4
Posts: 4
Offline Offline
« Reply #2 on: December 18, 2010, 03:08:22 AM »
Quote from: xlr8or on December 18, 2010, 03:01:10 AM
First of all, do not hijack other peoples topics, even if your problem is the same.

Look at your b3.xml, what's this:

Code: xml
      mysql://b3:mypassword@92.235.107.124:3306/blue_b3
      mypassword

If in doubt use our online config generator: http://config.bigbrotherbot.net/

 sorry bout the hijack but if you look at the thread there not a fix on there he just said he had fixed it without saying how ive tried tried it 20 times iv gt to be doing something wrong
Logged
xlr8or
[ www.xlrstats.com ]
Project Lead
*
OS: Linux
Type: Owner dedicated server(s)
Gameservers: CoD, CoD2, CoD5, UrT
Posts: 2022
Offline Offline
WWW
Support Specialty: B3-Core, CoD/UrT/WoP/ETPro parsers, Plugin development
« Reply #3 on: December 18, 2010, 03:12:37 AM »
okay, you should remove the second line in your b3.xml that says:
Code: xml
mypassword
and try again
Logged

Github repo - Groupware
BLUE1984
Newbie
*
OS: Windows
Type: Home user
Gameservers: cod4
Posts: 4
Offline Offline
« Reply #4 on: December 18, 2010, 03:20:36 AM »
Quote from: xlr8or on December 18, 2010, 03:12:37 AM
okay, you should remove the second line in your b3.xml that says:
Code: xml
mypassword
and try again

thanks but still no joy
Logged
xlr8or
[ www.xlrstats.com ]
Project Lead
*
OS: Linux
Type: Owner dedicated server(s)
Gameservers: CoD, CoD2, CoD5, UrT
Posts: 2022
Offline Offline
WWW
Support Specialty: B3-Core, CoD/UrT/WoP/ETPro parsers, Plugin development
« Reply #5 on: December 18, 2010, 03:34:52 AM »
Test if you can remotely connect to the database, Navicat Light is a free program that you can use.

When still in doubt if it is a config issue, use the online config generator as mentioned above.
Logged

Github repo - Groupware
BLUE1984
Newbie
*
OS: Windows
Type: Home user
Gameservers: cod4
Posts: 4
Offline Offline
« Reply #6 on: December 18, 2010, 08:12:16 AM »
Quote from: xlr8or on December 18, 2010, 03:34:52 AM
Test if you can remotely connect to the database, Navicat Light is a free program that you can use.

When still in doubt if it is a config issue, use the online config generator as mentioned above.
hi tried wht u said used the program i carnt get it to connect though my external ip only my router ip and can see my player stats and the other stuff on the database

EDIT:all done thanks guys for the help
« Last Edit: December 18, 2010, 08:17:51 AM by BLUE1984 » Logged
Tags:
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to:  


Rate this page +1 at Google Search


SimplePortal 2.3.1 © 2008-2009, SimplePortal