thankyou
Donate to the B3 fund!

"even a small donation helps!"
Donate with PayPal!

Author Topic: No module named MySQLdb  (Read 2911 times)

Offline Dr.GEE

  • Newbie
  • *
  • Posts: 3
No module named MySQLdb
« on: December 26, 2013, 02:51:27 PM »
I have a small error with my b3. I have downloaded the b3 for black ops with all the python files, my problem is this (from b3.log)

ImportError: No module named MySQLdb

I have a MySQL database set up with all permisions working but it doesn't seem to work. Anyone know a fix to this?

Thanks, Dr.GEE

Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4883
    • Github repository
Re: No module named MySQLdb
« Reply #1 on: December 26, 2013, 05:50:59 PM »
you are missing a python module that allows python to connect to your mysql server.

refer to http://wiki.bigbrotherbot.net/installation:installing_mysql-python

Offline Dr.GEE

  • Newbie
  • *
  • Posts: 3
Re: No module named MySQLdb
« Reply #2 on: December 26, 2013, 06:21:57 PM »
ah thanks, almost works now.  Loads up to the plugins then just shuts down, doesn't show any errors when it closes it just closes instantly.  I search the .log file for errors and it finds nothing.  any ideas?

Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4883
    • Github repository
Re: No module named MySQLdb
« Reply #3 on: December 26, 2013, 07:40:55 PM »
post your b3.log file, maybe you missed a hint

Offline 40-1STU

  • Jr. Member
  • **
  • Posts: 18
Re: No module named MySQLdb
« Reply #4 on: December 26, 2013, 10:44:47 PM »
also set your log level to 8 in your b3.xml file so it logs more info

Offline Dr.GEE

  • Newbie
  • *
  • Posts: 3
Re: No module named MySQLdb
« Reply #5 on: December 26, 2013, 11:58:41 PM »
hmm it was on log level 10 but yea I set it to 8 like he said.

Here is my log file:

Code: [Select]
131226 23:57:29	BOT    	'www.bigbrotherbot.net (b3) v1.9.0 [nt] [PoisonIvy]'
131226 23:57:29 BOT    'Python: 2.7.6 (default, Nov 10 2013, 19:24:18) [MSC v.1500 32 bit (Intel)]'
131226 23:57:29 BOT    'Default encoding: ascii'
131226 23:57:29 BOT    'Starting Cod7Parser v1.2.1 for server 127.0.0.1:3074'
131226 23:57:29 BOT    '--------------------------------------------'
131226 23:57:29 BOT    'Attempting to connect to database mysql://gee:[email protected]/b3.gee...'
131226 23:57:30 BOT    'Connected to database [1 times]'
131226 23:57:30 BOT    'Game log C:\\Users\\Administrator\\Desktop\\black ops\\main/games_mp.log'
131226 23:57:30 BOT    'Starting bot reading file C:\\Users\\Administrator\\Desktop\\black ops\\main\\games_mp.log'
131226 23:57:30 BOT    'rcon status Cache Expire Time: [2 sec] Type: [memory]'
131226 23:57:30 VERBOSE "RCON sending (127.0.0.1:3074) 'status'"
131226 23:57:30 VERBOSE 'RCON: More data to read in socket'
131226 23:57:31 VERBOS2 "RCON: Received 'map: mp_mountain\\nnum score ping guid   name            lastmsg address               qport rate\\n--- ----- ---- ---------- --------------- ------- --------------------- ------ -----\\n  1   300  113 145647 Wizty^7                 0 85.76.174.91:19100    -32187 25000\\n  3  1840  264 141640 kasuritz^7              0 190.69.233.30:524     -29215 25000\\n  4  1980   57 139515 adam_the_parsnip^7      0 2.100.20.235:2316      26872 25000\\n  6   200  100 145831 abdofoxx.DZ^7           0 197.200.54.162:524    -24427 25000\\n  7   780  112 144885 UnuS76^7               50 37.252.70.227:524     -23665 25000\\n  8   820  169 126816 YOYO-GaMeR-KSA^7        0 188.55.76.237:524      -4461 25000\\n  9     0  139 145899 Elfatih^7               0 109.163.132.67:19251  -13308 25000\\n 11  1560   88 145393 screamjojo^7            0 93.30.100.61:524       32424 25000\\n 12  2000   88 145477 antho^7                 0 93.30.100.61:4        -28533 25000\\n 13  1200   78  77035 RoKi96^7                0 217.12.59.46:524      -29942 25000\\n 14  1200   97  72977 TIGRETOYO^7            50 197.205.104.171:30795  -8378 25000\\n 15   950  315 144361 cesarhi^7               0 186.53.28.89:524       -4961 25000\\n 16  2440  306 145788 matheuslau^7            0 201.68.115.179:524    -13484 25000\\n 17   620  286 145616 BuffaloSoldier^7        0 200.127.14.81:-16117  -10318 25000\\n\\n'"
131226 23:57:31 BOT    'Loading Plugins (external plugin directory: C:\\Users\\Administrator\\Desktop\\black ops\\b3\\b3\\extplugins)'
131226 23:57:31 BOT    'Loading Plugin #1 admin [b3\\conf\\plugin_admin.xml]'
131226 23:57:31 BOT    'AdminPlugin: Loading config b3\\conf\\plugin_admin.xml for AdminPlugin'
131226 23:57:31 INFO 'AdminPlugin: ------ loading warn_reasons from config file ------'
131226 23:57:31 INFO "AdminPlugin: warn reason 'default' : (60.0, '^7behave yourself')"
131226 23:57:31 INFO "AdminPlugin: warn reason 'generic' : (60.0, '^7')"
131226 23:57:31 INFO 'AdminPlugin: rule9      3 hours   \t"^3Rule #9: Do ^1NOT ^3fire at teammates or within 10 seconds of spawning" '
131226 23:57:31 INFO 'AdminPlugin: rule8      3 days    \t"^3Rule #8: No profanity or offensive language (in any language)" '
131226 23:57:31 INFO 'AdminPlugin: rule3      1 day     \t"^3Rule #3: No arguing with admins (listen and learn or leave)" '
131226 23:57:31 INFO 'AdminPlugin: rule2      1 day     \t"^3Rule #2: No clan stacking, members must split evenly between the teams" '
131226 23:57:31 INFO 'AdminPlugin: rule1      1.4 week  \t"^3Rule #1: No racism of any kind" '
131226 23:57:31 INFO 'AdminPlugin: rule7      1 day     \t"^3Rule #7: No advertising or spamming of websites or servers" '
131226 23:57:31 INFO 'AdminPlugin: rule6      1 day     \t"^3Rule #6: No recruiting for your clan, your server, or anything else" '
131226 23:57:31 INFO 'AdminPlugin: rule5      1 hour    \t"^3Rule #5: No offensive or potentially offensive names, annoying names, or in-game (double caret (^)) color in names" '
131226 23:57:31 INFO 'AdminPlugin: rule4      1 day     \t"^3Rule #4: No abusive language or behavior towards admins or other players" '
131226 23:57:31 INFO 'AdminPlugin: adv        1 day     \t"^3Rule #7: No advertising or spamming of websites or servers" '
131226 23:57:31 INFO 'AdminPlugin: afk        5 minutes \t"^7you appear to be away from your keyboard" '
131226 23:57:31 INFO 'AdminPlugin: generic    1 hour    \t"^7" '
131226 23:57:31 INFO 'AdminPlugin: ci         5 minutes \t"^7connection interupted, reconnect" '
131226 23:57:31 INFO 'AdminPlugin: racism     1.4 week  \t"^3Rule #1: No racism of any kind" '
131226 23:57:31 INFO 'AdminPlugin: camp       1 hour    \t"^7stop camping or you will be kicked!" '
131226 23:57:31 INFO 'AdminPlugin: sfire      3 hours   \t"^3Rule #9: Do ^1NOT ^3fire at teammates or within 10 seconds of spawning" '
131226 23:57:31 INFO 'AdminPlugin: color      1 hour    \t"^7No in-game (double caret (^)) color in names" '
131226 23:57:31 INFO 'AdminPlugin: tk         1 day     \t"^7stop team killing!" '
131226 23:57:31 INFO 'AdminPlugin: nocmd      1 hour    \t"^7do not use commands that you do not have access to, try using !help" '
131226 23:57:31 INFO 'AdminPlugin: spec       5 minutes \t"^7spectator too long on full server" '
131226 23:57:31 INFO 'AdminPlugin: lang       3 days    \t"^3Rule #8: No profanity or offensive language (in any language)" '
131226 23:57:31 INFO 'AdminPlugin: cuss       3 days    \t"^3Rule #8: No profanity or offensive language (in any language)" '
131226 23:57:31 INFO 'AdminPlugin: jerk       1 day     \t"^3Rule #4: No abusive language or behavior towards admins or other players" '
131226 23:57:31 INFO 'AdminPlugin: fakecmd    1 hour    \t"^7do not use fake commands" '
131226 23:57:31 INFO 'AdminPlugin: rule10     3 days    \t"^3Rule #10: Offense players must play for the objective and support their team" '
131226 23:57:31 INFO 'AdminPlugin: stack      1 day     \t"^3Rule #2: No clan stacking, members must split evenly between the teams" '
131226 23:57:31 INFO 'AdminPlugin: spawnfire  3 hours   \t"^3Rule #9: Do ^1NOT ^3fire at teammates or within 10 seconds of spawning" '
131226 23:57:31 INFO 'AdminPlugin: obj        1 hour    \t"^7go for the objective!" '
131226 23:57:31 INFO 'AdminPlugin: name       1 hour    \t"^3Rule #5: No offensive or potentially offensive names, annoying names, or in-game (double caret (^)) color in names" '
131226 23:57:31 INFO 'AdminPlugin: language   3 days    \t"^3Rule #8: No profanity or offensive language (in any language)" '
131226 23:57:31 INFO 'AdminPlugin: default    1 hour    \t"^7behave yourself" '
131226 23:57:31 INFO 'AdminPlugin: profanity  3 days    \t"^3Rule #8: No profanity or offensive language (in any language)" '
131226 23:57:31 INFO 'AdminPlugin: spam       1 hour    \t"^7do not spam, shut-up!" '
131226 23:57:31 INFO 'AdminPlugin: recruit    1 day     \t"^3Rule #6: No recruiting for your clan, your server, or anything else" '
131226 23:57:31 INFO 'AdminPlugin: badname    1 hour    \t"^7No offensive, potentially offensive, or annoying names" '
131226 23:57:31 INFO 'AdminPlugin: spectator  5 minutes \t"^7spectator too long on full server" '
131226 23:57:31 INFO 'AdminPlugin: argue      1 day     \t"^3Rule #3: No arguing with admins (listen and learn or leave)" '
131226 23:57:31 INFO 'AdminPlugin: -------------- warn_reasons loaded ----------------'
131226 23:57:31 VERBOS2 'SELECT * FROM groups WHERE `keyword` = "superadmin" LIMIT 1'
131226 23:57:31 VERBOS2 'SELECT * FROM groups WHERE `keyword` = "senioradmin" LIMIT 1'
131226 23:57:31 VERBOS2 'SELECT * FROM groups WHERE `keyword` = "mod" LIMIT 1'
131226 23:57:31 DEBUG 'Register Event: Stop Process: AdminPlugin'
131226 23:57:31 DEBUG 'Register Event: Program Exit: AdminPlugin'
131226 23:57:31 BOT    'Plugin admin (1.19 - ThorN, xlr8or, Courgette) loaded'
131226 23:57:31 INFO "STDOUT 'running newLoadArbPlugins '"
131226 23:57:31 INFO "STDOUT '\\n'"
131226 23:57:31 BOT    'Loading Plugin publist'
131226 23:57:31 BOT    'PublistPlugin: No config file found for PublistPlugin. (was not required either)'
131226 23:57:31 DEBUG 'Register Event: Stop Process: PublistPlugin'
131226 23:57:31 DEBUG 'Register Event: Program Exit: PublistPlugin'
131226 23:57:31 BOT    'Plugin publist (1.10.2 - ThorN, Courgette) loaded'
131226 23:57:31 DEBUG 'creating the event queue with size 50'
131226 23:57:31 BOT    'Starting parser'
131226 23:57:31 DEBUG 'Client Connected: [-1] World - WORLD ({})'
131226 23:57:31 DEBUG 'Storage: getClient Client<@0:WORLD|WORLD:"World":-1>'
131226 23:57:31 VERBOS2 'Aborted Making Alias for cid: -1, name is the same'
131226 23:57:31 BOT    'Client found in storage 1, welcome back World'
131226 23:57:31 VERBOS2 'Aborted Making Alias for cid: -1, name is the same'
131226 23:57:31 DEBUG u'Storage: setClient Client<@1:WORLD|WORLD:"World":-1>'
131226 23:57:31 DEBUG "Storage: setClient data {'time_add': 1387369789, 'password': u'', 'time_edit': 1388098651, 'name': 'World', 'group_bits': 0, 'ip': '', 'auto_login': 1, 'greeting': u'', 'pbid': u'WORLD', 'connections': 47, 'mask_level': 0, 'login': u'', 'guid': 'WORLD', 'id': 1}"
131226 23:57:31 DEBUG 'Client Authorized: [-1] World - WORLD'
131226 23:57:31 CRITICAL 'cannot found cod7http plugin'
None
131226 23:57:31 INFO "STDOUT 'Exiting: 220'"
131226 23:57:31 INFO "STDOUT '\\n'"
131226 23:57:31 BOT    'Shutting down...'
131226 23:57:31 BOT    'Shutting down database connections...'

Offline 82ndAB.Bravo17

  • Dev. Team
  • Hero Member
  • *
  • Posts: 2580
Re: No module named MySQLdb
« Reply #6 on: December 27, 2013, 02:59:07 PM »
What COD7 server are you using?

If you are using anything other than the official one then I think you need to put something other than cod7 in for the game name - see if there are any instructions on the site that you downloaded the bot from.
« Last Edit: December 27, 2013, 03:01:47 PM by 82ndAB.Bravo17 »

 


Rate this page +1 at Google Search