next »

[learco]

hi all!

i am connecting b3 to a database with phpmyadmin hosted by wampserver for windows machine.
i remember last time i install b3 (1.3) on a windows machine, xampp worked and it was easier connect with mysql.

can anyone help me?

thank you for all!  

[MordyT]

doesn't wampserver have phpmyadmin built in?

[learco]

yes, it does.

when i used xampp i didn't have any problem.
now xampp doesn't seems to work more: so, searching on internet i tried to install this application with phpmyadmin and mysql.
i created a new user in the database and i tried to connect b3 with him.
maybe i am wrong the path, because the user for me is correct.

i'm following this manual: http://forum.bigbrotherbot.net/installation-support/(tutorial)-how-to-install-b3-on-windows-for-dumb-!/

[learco]

okay, i find how to run xampp again.
but it's the same effect: here's my new b3.log

110515 09:30:26   BOT       www.bigbrotherbot.net (b3) v1.5.0 [nt] [Daniel]
110515 09:30:26   BOT       Python: 2.7 (r27:82525, Jul  4 2010, 07:43:08) [MSC v.1500 64 bit (AMD64)]
110515 09:30:26   BOT       Starting Iourt41Parser v1.7.15 for server 127.0.0.1:27961
110515 09:30:26   BOT       --------------------------------------------
110515 09:30:26   BOT       Attempting to connect to database mysql://root:******@127.0.0.1/b3...
110515 09:30:26   BOT       Connected to database [1 times]

Connected to database [1 times]... isn't it correct?
why b3_run doesn't continue anymore?

thank you again! 

[Spruehwurstheinz]

you will find the error message in the b3.log

[learco]

i can't find any error.
this is my whole b3.log. 

[Spruehwurstheinz]

ah sorry, didn't read very well

Did you try to deactivate all plugins? And can you please post your b3.xml except from the passwords?

[learco]

sure, no problem!  

this is my b3.xml:

<?xml version="1.0"?>
<configuration>
  <settings name="b3">
    <set name="parser">iourt41</set>
    <set name="database">mysql://root:THEPASSWORD@127.0.0.1/b3</set>
    <set name="bot_name">sunshine</set>
    <set name="bot_prefix">^0(^2sunshine^0)^7:</set>
    <set name="time_format">%I:%M%p %Z %m/%d/%y</set>
    <set name="time_zone">CET</set>
    <set name="log_level">9</set>
    <set name="logfile">C:\Users\Alberto\Documents\Urban Terror\b3-1.5.0\b3.log</set>
  </settings>
  <settings name="server">
    <set name="rcon_password">RCON-PASSWORD</set>
    <set name="port">27961</set>
    <set name="game_log"></set>
    <set name="public_ip">127.0.0.1</set>
    <set name="rcon_ip">127.0.0.1</set>
    <set name="punkbuster">0</set>
  </settings>
  <settings name="autodoc">
    <set name="type">html</set>
    <set name="maxlevel">100</set>
    <set name="destination">C:\Users\Alberto\Documents\Urban Terror\b3-1.5.0\b3_doc.html</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 name="censor" config="@conf/plugin_censor.xml"/>
    <plugin name="spamcontrol" config="@conf/plugin_spamcontrol.xml"/>
    <plugin name="admin" config="@conf/plugin_admin.xml"/>
    <plugin name="tk" config="@conf/plugin_tk.xml"/>
    <plugin name="stats" config="@conf/plugin_stats.xml"/>
    <plugin name="pingwatch" config="@conf/plugin_pingwatch.xml"/>
    <plugin name="adv" config="@conf/plugin_adv.xml"/>
    <plugin name="status" config="@conf/plugin_status.xml"/>
    <plugin name="welcome" config="@conf/plugin_welcome.xml"/>
    <plugin name="punkbuster" config="@conf/plugin_punkbuster.xml"/>
  </plugins>
</configuration>

p.s.: how can i deactivate al the plugins? t.y.

[Spruehwurstheinz]

the config looks fine for me, but I don't know about Urban terror (should public ip be the same as rcon ip?)

to deactivate just set a <!-- in front and a --> at the back of the part you want to disable/comment out.

[learco]

thank you for said me how to disable/enable the plugins!

wait, maybe i get other details.
this is the output from b3-run at runtime:

Using config file: b3\conf\b3.xml
Using external plugin directory: C:\Users\Alberto\Documents\Urban Terror\b3-1.5.
0\b3\extplugins
Activating log   : C:\Users\Alberto\Documents\Urban Terror\b3-1.5.0\b3.log
Connecting to DB : OK
Traceback (most recent call last):
  File "C:\Users\Alberto\Documents\Urban Terror\b3-1.5.0\b3\run.py", line 174, i
n main
    run(config=options.config, nosetup=options.nosetup)
  File "C:\Users\Alberto\Documents\Urban Terror\b3-1.5.0\b3\run.py", line 138, i
n run
    b3.start(config, nosetup)
  File "C:\Users\Alberto\Documents\Urban Terror\b3-1.5.0\b3\__init__.py", line 1
61, in start
    console = parser(conf)
  File "C:\Users\Alberto\Documents\Urban Terror\b3-1.5.0\b3\parser.py", line 322
, in __init__
    if game_log[0:6] == 'ftp://' or game_log[0:7] == 'sftp://' or game_log[0:7]
== 'http://':
TypeError: 'NoneType' object is not subscriptable

[Spruehwurstheinz]

Code:

    <set name="game_log"></set>

I guess that the bot needs a logfile there produced by the server. As I said, I don't know how it's supposed to be with UrT.

[learco]

okay... you can say me i am a stupid!!!

i was sure all configs was setted. i forget of it!

now all works fine! thank you to all, sorry for my stupid mistakes... :-O