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)cant connect to db
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: cant connect to db  (Read 339 times) Bookmark and Share
beepbeep
Full Member
***
OS: Windows
Type: Home user
Gameservers: UrT
Posts: 71
Offline Offline
« on: March 01, 2011, 12:45:28 PM »
Code:
110301 14:52:34 BOT    www.bigbrotherbot.net (b3) v1.4.0 [posix] (Daniel)
110301 14:52:34 BOT    Python: 2.4.3 (#1, Sep  3 2009, 15:37:37)
[GCC 4.1.2 20080704 (Red Hat 4.1.2-46)]
110301 14:52:34 BOT    Starting Iourt41Parser v1.7.12 for server 208.100.11.28:27962
110301 14:52:34 BOT    --------------------------------------------
110301 14:52:34 BOT    Attempting to connect to database mysql://PartyPoison:******@localhost/killjoys...
110301 14:52:34 CRITICAL No module named MySQLdb. You need to install python-mysqldb. Look for 'dependencies' in B3 documentation.
Traceback (most recent call last):
  File "/home/urtripp/b3-1.4.0/b3/storage.py", line 160, in getConnection
    import MySQLdb
ImportError: No module named MySQLdb
110301 14:52:34 ERROR Database connection failed, working in remote mode: 220 - [('/home/urtripp/b3-1.4.0/b3/storage.py', 207, 'connect', 'self.db = self.getConnection()'), ('/home/urtripp/b3-1.4.0/b3/storage.py', 163, 'getConnection', 'self.console.critical("%s. You need to install python-mysqldb. Look for \'dependencies\' in B3 documentation.",err)'), ('/home/urtripp/b3-1.4.0/b3/parser.py', 1001, 'critical', 'self.log.critical(msg, *args, **kwargs)'), ('/home/urtripp/b3-1.4.0/b3/output.py', 57, 'critical', 'sys.exit(220)')]
110301 14:52:35 BOT    Loading Plugins (external plugin directory: /home/urtripp/b3-1.4.0/b3/extplugins)
110301 14:52:35 BOT    Loading Plugin #1 spamcontrol [@conf/plugin_spamcontrol.xml]
110301 14:52:35 BOT    SpamcontrolPlugin: Loading config @conf/plugin_spamcontrol.xml for SpamcontrolPlugin
110301 14:52:35 DEBUG Register Event: Stop Process: SpamcontrolPlugin
110301 14:52:35 DEBUG Register Event: Program Exit: SpamcontrolPlugin
110301 14:52:35 BOT    Plugin spamcontrol (1.1.2 - ThorN) loaded
110301 14:52:35 BOT    Loading Plugin #2 admin [@conf/plugin_admin.xml]
110301 14:52:35 BOT    AdminPlugin: Loading config @conf/plugin_admin.xml for AdminPlugin
110301 14:52:35 DEBUG Register Event: Stop Process: AdminPlugin
110301 14:52:35 DEBUG Register Event: Program Exit: AdminPlugin
110301 14:52:35 BOT    Plugin admin (1.8.1 - ThorN, xlr8or, Courgette) loaded
110301 14:52:35 BOT    Loading Plugin #3 tk [@conf/plugin_tk.xml]
110301 14:52:35 BOT    TkPlugin: Loading config @conf/plugin_tk.xml for TkPlugin
110301 14:52:35 DEBUG TkPlugin: tk max level is 40
110301 14:52:35 DEBUG TkPlugin: Send messages privately ? True
110301 14:52:35 DEBUG Register Event: Stop Process: TkPlugin
110301 14:52:35 DEBUG Register Event: Program Exit: TkPlugin
110301 14:52:35 BOT    Plugin tk (1.2.4 - ThorN) loaded
110301 14:52:35 BOT    Loading Plugin #4 stats [@conf/plugin_stats.xml]
110301 14:52:35 BOT    StatsPlugin: Loading config @conf/plugin_stats.xml for StatsPlugin
110301 14:52:35 DEBUG StatsPlugin: Using default value (0) for commands::mapstats
110301 14:52:35 DEBUG StatsPlugin: Using default value (0) for commands::testscore
110301 14:52:35 DEBUG StatsPlugin: Using default value (2) for commands::topstats
110301 14:52:35 DEBUG Register Event: Stop Process: StatsPlugin
110301 14:52:35 DEBUG Register Event: Program Exit: StatsPlugin
110301 14:52:35 BOT    Plugin stats (1.3.2 - ThorN) loaded
110301 14:52:35 BOT    Loading Plugin #5 pingwatch [@conf/plugin_pingwatch.xml]
110301 14:52:35 BOT    PingwatchPlugin: Loading config @conf/plugin_pingwatch.xml for PingwatchPlugin
110301 14:52:35 DEBUG AdminPlugin: Command "ci (None)" registered with cmd_ci for level (20, 100)
110301 14:52:35 DEBUG Register Event: Stop Process: PingwatchPlugin
110301 14:52:35 DEBUG Register Event: Program Exit: PingwatchPlugin
110301 14:52:35 BOT    Plugin pingwatch (1.2.2 - ThorN) loaded
110301 14:52:35 BOT    Loading Plugin #6 adv [@conf/plugin_adv.xml]
110301 14:52:35 BOT    AdvPlugin: Loading config @conf/plugin_adv.xml for AdvPlugin
110301 14:52:35 DEBUG AdvPlugin: Opening feed: oK|TDM Stats
110301 14:52:35 DEBUG Register Event: Stop Process: AdvPlugin
110301 14:52:35 DEBUG Register Event: Program Exit: AdvPlugin
110301 14:52:35 BOT    Plugin adv (1.2.1 - ThorN) loaded
110301 14:52:35 BOT    Loading Plugin #7 status [@conf/plugin_status.xml]
110301 14:52:35 BOT    StatusPlugin: Loading config @conf/plugin_status.xml for StatusPlugin
110301 14:52:35 DEBUG Register Event: Stop Process: StatusPlugin
110301 14:52:35 DEBUG Register Event: Program Exit: StatusPlugin
110301 14:52:35 BOT    Plugin status (1.4.3 - ThorN) loaded
110301 14:52:35 BOT    Loading Plugin #8 welcome [@conf/plugin_welcome.xml]
110301 14:52:35 BOT    WelcomePlugin: Loading config @conf/plugin_welcome.xml for WelcomePlugin
110301 14:52:35 DEBUG AdminPlugin: Command "greeting (None)" registered with cmd_greeting for level (20, 100)
110301 14:52:35 DEBUG Register Event: Stop Process: WelcomePlugin
110301 14:52:35 DEBUG Register Event: Program Exit: WelcomePlugin
110301 14:52:35 BOT    Plugin welcome (1.1 - ThorN) loaded
110301 14:52:35 BOT    Loading Plugin publist
110301 14:52:35 BOT    PublistPlugin: No config file found for PublistPlugin. (was not required either)
110301 14:52:35 DEBUG Register Event: Stop Process: PublistPlugin
110301 14:52:35 DEBUG Register Event: Program Exit: PublistPlugin
110301 14:52:35 BOT    Plugin publist (1.5 - ThorN, Courgette) loaded
110301 14:52:35 DEBUG Client Connected: [-1] World - WORLD ({})
110301 14:52:35 DEBUG Storage: getClient <b3.clients.Client object at 0xe97be50>
110301 14:52:35 BOT    Attempting to connect to database mysql://PartyPoison:******@localhost/killjoys...
110301 14:52:35 DEBUG User not found WORLD: 'No client matching guid WORLD in admins_cache'
110301 14:52:35 BOT    Client not found in the storage WORLD, create new
110301 14:52:35 DEBUG Storage: setClient <b3.clients.Client object at 0xe97be50>
110301 14:52:35 DEBUG Storage: setClient data {'time_add': 1299012755, 'time_edit': 1299012755, 'name': 'World', 'group_bits': 0, 'ip': '', 'greeting': '', 'auto_login': 1, 'connections': 1, 'mask_level': 0, 'guid': 'WORLD', 'pbid': 'WORLD'}
110301 14:52:35 BOT    Attempting to connect to database mysql://PartyPoison:******@localhost/killjoys...
110301 14:52:35 DEBUG Client Authorized: [-1] World - WORLD
110301 14:52:37 INFO map is: ut4_algiers
110301 14:52:38 DEBUG Get cvar fs_game = ["fs_game" is:"q3ut4^7", the default]
110301 14:52:39 DEBUG Get cvar fs_basepath = ["fs_basepath" is:"/home/urtripp/UrbanTerror^7", the default]
110301 14:52:39 DEBUG fs_basepath: /home/urtripp/UrbanTerror
110301 14:52:40 DEBUG Get cvar fs_homepath = ["fs_homepath" is:"/home/urtripp/UrbanTerror/^7" default:"/home/urtripp/UrbanTerror/q3ut4/.q3a^7"]
110301 14:52:40 DEBUG fs_homepath: /home/urtripp/UrbanTerror
110301 14:52:41 BOT    Starting Plugin spamcontrol
110301 14:52:41 DEBUG Register Event: Say: SpamcontrolPlugin
110301 14:52:41 DEBUG Register Event: Team Say: SpamcontrolPlugin
110301 14:52:41 DEBUG AdminPlugin: Command "spamins (None)" registered with cmd_spamins for level (20, 100)
110301 14:52:41 BOT    Starting Plugin admin
110301 14:52:41 DEBUG Register Event: Say: AdminPlugin
110301 14:52:41 DEBUG Register Event: Private Message: AdminPlugin
110301 14:52:41 WARNING AdminPlugin: could not get command_prefix_big, using default
110301 14:52:41 DEBUG AdminPlugin: Command "status (None)" registered with cmd_status for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "rules (r)" registered with cmd_rules for level (0, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "makereg (mr)" registered with cmd_makereg for level (80, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "leveltest (lt)" registered with cmd_leveltest for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "warn (w)" registered with cmd_warn for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "list (None)" registered with cmd_list for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "warns (None)" registered with cmd_warns for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "warntest (wt)" registered with cmd_warntest for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "warninfo (wi)" registered with cmd_warninfo for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "nextmap (None)" registered with cmd_nextmap for level (0, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "say (None)" registered with cmd_say for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "lookup (l)" registered with cmd_lookup for level (80, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "b3 (None)" registered with cmd_b3 for level (9, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "seen (None)" registered with cmd_seen for level (2, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "find (None)" registered with cmd_find for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "pause (None)" registered with cmd_pause for level (90, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "kickall (kall)" registered with cmd_kickall for level (80, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "warnclear (wc)" registered with cmd_warnclear for level (80, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "admintest (None)" registered with cmd_admintest for level (40, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "regtest (None)" registered with cmd_regtest for level (1, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "rebuild (None)" registered with cmd_rebuild for level (90, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "maps (None)" registered with cmd_maps for level (2, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "ban (b)" registered with cmd_ban for level (60, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "ungroup (None)" registered with cmd_ungroup for level (90, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "banall (ball)" registered with cmd_banall for level (80, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "maprotate (None)" registered with cmd_maprotate for level (80, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "putgroup (None)" registered with cmd_putgroup for level (90, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "map (None)" registered with cmd_map for level (80, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "notice (None)" registered with cmd_notice for level (40, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "enable (None)" registered with cmd_enable for level (100, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "runas (su)" registered with cmd_runas for level (100, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "spankall (sall)" registered with cmd_spankall for level (80, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "tempban (tb)" registered with cmd_tempban for level (40, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "unmask (None)" registered with cmd_unmask for level (100, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "aliases (alias)" registered with cmd_aliases for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "disable (None)" registered with cmd_disable for level (100, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "baninfo (bi)" registered with cmd_baninfo for level (40, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "kick (k)" registered with cmd_kick for level (40, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "clientinfo (None)" registered with cmd_clientinfo for level (90, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "restart (None)" registered with cmd_restart for level (100, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "spams (None)" registered with cmd_spams for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "scream (None)" registered with cmd_scream for level (40, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "poke (None)" registered with cmd_poke for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "die (None)" registered with cmd_die for level (100, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "register (None)" registered with cmd_register for level (0, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "mask (None)" registered with cmd_mask for level (100, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "unban (None)" registered with cmd_unban for level (60, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "help (h)" registered with cmd_help for level (0, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "reconfig (None)" registered with cmd_reconfig for level (100, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "admins (None)" registered with cmd_admins for level (0, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "warnremove (wr)" registered with cmd_warnremove for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "permban (pb)" registered with cmd_permban for level (60, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "time (None)" registered with cmd_time for level (1, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "clear (kiss)" registered with cmd_clear for level (80, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "spam (s)" registered with cmd_spam for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "spank (sp)" registered with cmd_spank for level (60, 100)
110301 14:52:41 ERROR AdminPlugin: There is no database connection! Cannot store or retrieve any information. Fix the database connection first!
110301 14:52:41 BOT    Starting Plugin tk
110301 14:52:41 DEBUG Register Event: Client Team Damage: TkPlugin
110301 14:52:41 DEBUG Register Event: Client Team Kill: TkPlugin
110301 14:52:41 DEBUG Register Event: Client Disconnect: TkPlugin
110301 14:52:41 DEBUG Register Event: Game Exit: TkPlugin
110301 14:52:41 DEBUG AdminPlugin: Command "forgive (f)" registered with cmd_forgive for level (0, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "forgivelist (fl)" registered with cmd_forgivelist for level (0, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "forgiveall (fa)" registered with cmd_forgiveall for level (0, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "forgiveinfo (fi)" registered with cmd_forgiveinfo for level (20, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "forgiveclear (fc)" registered with cmd_forgiveclear for level (60, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "forgiveprev (fp)" registered with cmd_forgivelast for level (0, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "grudge (grudge)" registered with cmd_grudge for level (0, 100)
110301 14:52:41 BOT    Starting Plugin stats
110301 14:52:41 DEBUG AdminPlugin: Command "testscore (ts)" registered with cmd_testscore for level (0, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "topxp (None)" registered with cmd_topxp for level (2, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "topstats (top)" registered with cmd_topstats for level (2, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "mapstats (stats)" registered with cmd_mapstats for level (0, 100)
110301 14:52:41 DEBUG Register Event: Client Team Damage: StatsPlugin
110301 14:52:41 DEBUG Register Event: Client Team Kill: StatsPlugin
110301 14:52:41 DEBUG Register Event: Client Kill: StatsPlugin
110301 14:52:41 DEBUG Register Event: Client Damage: StatsPlugin
110301 14:52:41 DEBUG Register Event: Game Round Start: StatsPlugin
110301 14:52:41 BOT    Starting Plugin pingwatch
110301 14:52:41 DEBUG Register Event: Game Exit: PingwatchPlugin
110301 14:52:41 BOT    Starting Plugin adv
110301 14:52:41 DEBUG AdminPlugin: Command "advadd (None)" registered with cmd_advadd for level (100, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "advrate (None)" registered with cmd_advrate for level (100, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "advlist (None)" registered with cmd_advlist for level (100, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "advload (None)" registered with cmd_advload for level (100, 100)
110301 14:52:41 DEBUG AdminPlugin: Command "advrem (None)" registered with cmd_advrem for level (100, 100)
110301 14:52:41 DEBUG AdvPlugin: XLRstats not installed, @topstats not available!
110301 14:52:41 BOT    Starting Plugin status
110301 14:52:41 BOT    Starting Plugin welcome
110301 14:52:41 DEBUG Register Event: Client Authenticated: WelcomePlugin
110301 14:52:41 BOT    Starting Plugin publist
110301 14:52:41 DEBUG Set cvar _B3 = [B3 v1.4.0 [posix]]
110301 14:52:42 DEBUG PublistPlugin: publist will send heartbeat at 04:01 every day
110301 14:52:42 BOT    Start reading...
110301 14:52:42 WARNING AUTODOC: destination found but empty. using default
110301 14:52:42 ERROR AUTODOC: 0 type of doc unsupported
110301 14:52:42 INFO AUTODOC: supported doc types are : xml, html, htmltable
110301 14:52:42 DEBUG PublistPlugin: Sending heartbeat to B3 master...
110301 14:52:42 INFO STDOUT Error: 'Iourt41Parser' object has no attribute 'input'
  File "/home/urtripp/b3-1.4.0/b3/__init__.py", line 174, in start
    console.start()
  File "/home/urtripp/b3-1.4.0/b3/parser.py", line 388, in start
    self.run()
  File "/home/urtripp/b3-1.4.0/b3/parser.py", line 752, in run
    lines = self.read()
  File "/home/urtripp/b3-1.4.0/b3/parser.py", line 896, in read
    filestats = os.fstat(self.input.fileno())

110301 14:52:42 INFO STDOUT

110301 14:52:42 BOT    Shutting down...
110301 14:52:42 INFO StatusPlugin: B3 stop/exit.. updating status
110301 14:52:42 DEBUG StatusPlugin: Writing XML status to /home/status.xml
110301 14:52:42 ERROR [Errno 13] Permission denied: '/home/status.xml'





HELP Sad
Logged
Jackster
Full Member
***
OS: Linux
Type: Gameserver Rental Co.
Gameservers: COD
Posts: 53
Offline Offline
WWW
« Reply #1 on: March 01, 2011, 01:04:31 PM »
Insted of posting, How about you read the log file?


Code:
110301 14:52:34 CRITICAL No module named MySQLdb. You need to install python-mysqldb. Look for 'dependencies' in B3 documentation.
Logged
WarServers.NET

The BEST Game Server provider!
beepbeep
Full Member
***
OS: Windows
Type: Home user
Gameservers: UrT
Posts: 71
Offline Offline
« Reply #2 on: March 01, 2011, 06:27:34 PM »
i have in installed. mysql-python 1.2.3


im not sure what it means as a solution  for fixing this problem :/
Logged
beepbeep
Full Member
***
OS: Windows
Type: Home user
Gameservers: UrT
Posts: 71
Offline Offline
« Reply #3 on: March 02, 2011, 12:12:04 AM »
do i need mysql python install d on the server running the database?

i have b3 on  one server and the database on another.
Logged
Jackster
Full Member
***
OS: Linux
Type: Gameserver Rental Co.
Gameservers: COD
Posts: 53
Offline Offline
WWW
« Reply #4 on: March 02, 2011, 09:37:57 AM »
You need it on the server that runs the B3 bot.
Logged
WarServers.NET

The BEST Game Server provider!
Tags:
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to:  


Rate this page +1 at Google Search


SimplePortal 2.3.1 © 2008-2009, SimplePortal