next »

[Freelander]

I've recently written a howto for installing B3 on a Debian Linux. I tried to cover all steps from database creation to bot configuration. I guess, that should also work on other debian based systems. I hope it helps especially beginners.

The guide is on my blog here.

If you have questions, you can use this thread.

[ryry46d9]

Error establishing a database connection

is what I got when I poked the link

[Freelander]

Yep, sorry database server was down. Should be ok now! 

[Courgette]

monit is your friend

[Freelander]

I don't have control over the db server. It's my lousy hosting company. But thanks anyway, I didn't know about monit. 

[Armani]

Thanks for this tutorial, I followed it some weeks ago when I  first found B3 and installed it on my servers
But there is a little mistake that any reader can fall for, and I have fallen in it too
at the beginning of the tutorial you created the database and named it cod4db and later on when you were configuring B3 and you were asked for the database info you typed :
mysql://freelander:MyPAsSwORD@localhost/b3
while it should be
mysql://freelander:MyPAsSwORD@localhost/cod4db
I remember  it drove my crazy because I kept getting connection to DB failure

[Freelander]

Good Catch! Corrected.

Thanks for the heads up. 

[neil]

edit:
thanks for the tuorial
but i have a little problem now
it dosnt recognize !iamgod command
see picture ?
http://www.freeimagehosting.net/ffef7
edit:
game : urban terror
bot version 1.6.1

edit 2 :
found this in my log

110807 13:35:02   DEBUG   'SELECT * FROM groups WHERE `keyword` = "superadmin" LIMIT 1'
110807 13:35:02   DEBUG   "Storage: getClientsMatching {'&group_bits': 128}"
110807 13:35:02   DEBUG   'AdminPlugin: 1 superadmins found in database'
110807 13:35:02   VERBOSE   'AdminPlugin: SuperAdmin(s) found, no need for !iamgod'

[Freelander]

Once you issued the command !iamgod, it's automatically disabled for security.

[neil]

Once you issued the command !iamgod, it's automatically disabled for security.

no, i am not able to do any commands either ,
look at picture ?
http://www.freeimagehosting.net/969db


edit2:
could it be because my local ip changes everytime i restart my router ?
see picture ?
http://www.freeimagehosting.net/ce400

also to get admin rights i edited the group bits row to 128 of the most recent join,
anything else i might have to edit to get superadmin rights ?
because some commands like !veto ,!slap etc are not recognized

[Freelander]

As far as I know, when the server IP changes in Urban Terror, all player guids are changed as well. If that's the case, B3 will not recognise you anymore and that's why you get "insufficient access" message. You will only be able to use commands that unregistered users are allowed to use.

I think the only thing you can do is to have a static IP for your server.

[neil]

As far as I know, when the server IP changes in Urban Terror, all player guids are changed as well. If that's the case, B3 will not recognise you anymore and that's why you get "insufficient access" message. You will only be able to use commands that unregistered users are allowed to use.

I think the only thing you can do is to have a static IP for your server.

how do i get a static ip for my server ?
something to do with the router ?

[Courgette]

it is something to do with your ISP. Some of them gives you only dynamic IPs, others offer you (for free or paid) the choice to have a fixed IP

[neil]

it is something to do with your ISP. Some of them gives you only dynamic IPs, others offer you (for free or paid) the choice to have a fixed IP

i live in dubai ,our isp's dosnt give a rats a** about its customers
so im goin to have to re admin myself through the db ?

[MordyT]

The way URT works is the "GUID" or the way to ID a person is based off the IP of the server and the QKey of the player. If the IP of the server changes, well then everyones "GUID" changes and B3 doesn't know who is who.

In short, yes, you will have to re-admin yourself, either through !iamgod (you will need to manually enable it) or through the DB.