next »

[soruncik]

hi
i get and error while starting b3.first database connect failed second error reading games_mp.log.
b3.xml

Code:

<?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: altitude/bfbc2/cod/cod2/cod4/cod5/cod6/cod7/etpro/homefront/iourt41/moh/oa081/smg/wop/wop15/ -->
<set name="parser">iourt41</set>
<!-- Your database info: [mysql]://[db-user]:[db-password]@[db-server[:port]]/[db-name] -->
<set name="database">mysql://b3:xxx@localhost/b3</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">CST</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">1234</set>
<!-- The port the server is running on -->
<set name="port">27960</set>
<!-- The gameserver generates a logfile, put the path and name here -->
<set name="game_log">games_mp.log</set>
<!-- The public IP your gameserver is residing on -->
<set name="public_ip">78.191.22.176</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">127.0.0.1</set>
<!-- Delay between each log reading. Set a higher value to consume less disk resources or bandwidth if you remotely connect (ftp or http remote log access) -->
<set name="delay">0.33</set>
<!-- Number of lines to process per second. Set a lower value to consume less CPU resources -->
<set name="lines_per_second">50</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">b3_doc.htm</set>
</settings>
<settings name="messages">
<set name="kicked_by">$clientname^7 was kicked by $adminname^7 $reason</set>
<set name="kicked">$clientname^7 was kicked $reason</set>
<set name="banned_by">$clientname^7 was banned by $adminname^7 $reason</set>
<set name="banned">$clientname^7 was banned $reason</set>
<set name="temp_banned_by">$clientname^7 was temp banned by $adminname^7 for $banduration^7 $reason</set>
<set name="temp_banned">$clientname^7 was temp banned for $banduration^7 $reason</set>
<set name="unbanned_by">$clientname^7 was un-banned by $adminname^7 $reason</set>
<set name="unbanned">$clientname^7 was un-banned $reason</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" />
<plugin config="@conf/plugin_punkbuster.xml" name="punkbuster" />
<!-- You can add new/custom plugins to this list using the same form as above. -->
</plugins>
</configuration>

b3.log

Code:

111009 23:02:43 BOT    'www.bigbrotherbot.net (b3) v1.7.1 [nt] [Myrthe] [Win32 standalone]'
111009 23:02:43 BOT    'Python: 2.6.1 (r261:67517, Dec  4 2008, 16:51:00) [MSC v.1500 32 bit (Intel)]'
111009 23:02:43 BOT    'Default encoding: ascii'
111009 23:02:43 BOT    'Starting Iourt41Parser v1.11.0 for server 127.0.0.1:27960'
111009 23:02:43 BOT    '--------------------------------------------'
111009 23:02:43 BOT    'Attempting to connect to database mysql://b3:******@localhost/b3...'
111009 23:02:43 ERROR 'Database connection failed, working in remote mode: (1045, "Access denied for user \'b3\'@\'localhost\' (using password: YES)") - [(\'b3\\\\storage\\\\database.pyo\', 231, \'connect\', None), (\'b3\\\\storage\\\\database.pyo\', 176, \'getConnection\', None), (\'MySQLdb\\\\__init__.pyo\', 81, \'Connect\', None), (\'MySQLdb\\\\connections.pyo\', 188, \'__init__\', None)]'
111009 23:02:43 BOT    'Game log games_mp.log'
111009 23:02:43 BOT    'Starting bot reading file games_mp.log'
111009 23:02:43 ERROR 'Error reading file games_mp.log'

windows xp sp3
b3 win (2,5)installed

and here is my error pic 


Uploaded with ImageShack.us

[82ndAB.Bravo17]

You need to follow the steps here to install and configure the mysql db correctly, and put the full path of your game log in the xml

http://wiki.bigbrotherbot.net/installation:start

[GrossKopf]

For the database connection, you have this line:

<set name="database">mysql://b3:xxx@localhost/b3</set>

Where you see the first "b3", that is the username for the B3 database. After the : is the password for that user. Next, after @ is localhost if the database is hosted on the same server where the B3 is running. If it isn't, it should be the IP address of the server where the database is running. At the end, after "localhost/", is the name of your B3 database.

So, if your database user was called MyUser, the database user password was MyPassword, the database was hosted locally and was called MyB3Database, the line would look like this:

<set name="database">mysql://MyUser:MyPassword@localhost/MyB3Database</set>

For your log file, you need a path to your log file to be set correctly:

<set name="game_log">games_mp.log</set>

If you host your game server on the same server that B3 runs, you can use a local path, such as this:

<set name="game_log">c:\gameservers\cod4\hq_server\main\games_mp.log</set>

If the game server is hosted remotely, you would need an FTP account that has access to the game log, with a line similar to this:

<set name="game_log">MyUser:MyPassword@123.456.789\gameservers\cod4\hq_server\main\games_mp.log</set>

Hope that helps!

[MordyT]

That became my new fav post. I am going to save that and just copy/paste for the next time we run into that issue.

[soruncik]

i dont know how to import b3.sql to database can you help me about that and games_mp.log still gives error reading (i set path correcly)
look games_mp prob
http://imageshack.us/photo/my-images/338/adszhrz.png/

[MordyT]

For how to import sql to file: see this video (steps will vary slightly, but you get the idea - open phpmyadmin and execute query on db.

For game log error...
you need to set it like:
<set name="game_log">c:\gameservers\cod4\hq_server\main\games_mp.log</set> with the correct path. You currently have <set name="game_log">c:\path\to\games_mp.log</set>