thankyou
Donate to the B3 fund!

"even a small donation helps!"
Donate with PayPal!
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 ]

Author Topic: B3 Connection Error  (Read 167 times)

Offline Jika12

  • Newbie
  • *
  • Posts: 9
B3 Connection Error
« on: February 17, 2017, 11:50:53 PM »
Hi

I have been trying to get my B3 to work but unfortunately its giving me an weird error, mysql is up to date and  yea heres the log file



170217 14:47:52 BOT      'www.bigbrotherbot.net (b3) v1.10.10 [AngryBiscuit] [nt32]'
170217 14:47:52 BOT      'Python: 2.7.11 (v2.7.11:6d1b6a68f775, Dec  5 2015, 20:32:19) [MSC v.1500 32 bit (Intel)]'
170217 14:47:52 BOT      'Default encoding: ascii'
170217 14:47:52 BOT      'Starting Bf3Parser v1.12 for server ***********.net:25000 (autorestart = OFF)'
170217 14:47:52 BOT      '--------------------------------------------'
170217 14:47:52 BOT      'Connecting to MySQL database: mysql://b3_bf3:******@*************.net:3306/b3_bf3...'
170217 14:47:52 ERROR    'Database connection failed: working in remote mode: (1130, u"Host \'KEENETIC\' is not allowed to connect to this MySQL server") - [(\'c:\\\\jenkins_slave\\\\workspace\\\\B3-stable-release\\\\b3\\\\storage\\\\mysql.py\', 287, \'connect\', None), (\'c:\\\\python27\\\\lib\\\\site-packages\\\\pymysql\\\\__init__.py\', 88, \'Connect\', None), (\'c:\\\\python27\\\\lib\\\\site-packages\\\\pymysql\\\\connections.py\', 644, \'__init__\', None), (\'c:\\\\python27\\\\lib\\\\site-packages\\\\pymysql\\\\connections.py\', 837, \'_connect\', None), (\'c:\\\\python27\\\\lib\\\\site-packages\\\\pymysql\\\\connections.py\', 1048, \'_get_server_information\', None), (\'c:\\\\python27\\\\lib\\\\site-packages\\\\pymysql\\\\connections.py\', 893, \'_read_packet\', None), (\'c:\\\\python27\\\\lib\\\\site-packages\\\\pymysql\\\\connections.py\', 369, \'check_error\', None), (\'c:\\\\python27\\\\lib\\\\site-packages\\\\pymysql\\\\err.py\', 120, \'raise_mysql_exception\', None), (\'c:\\\\python27\\\\lib\\\\site-packages\\\\pymysql\\\\err.py\', 115, \'_check_mysql_exception\', None)]'
170217 14:47:52 BOT      u'Loading plugins (external plugin directory: C:\\Users\\T-90\\Desktop\\b3-1.10.10-nt32\\extplugins)'
170217 14:47:52 BOT      u'Loading configuration file C:\\Users\\T-90\\Desktop\\b3-1.10.10-nt32\\conf\\plugin_admin.ini for plugin admin'
170217 14:47:53 BOT      u'Loading configuration file C:\\Users\\T-90\\Desktop\\b3-1.10.10-nt32\\conf\\plugin_adv.xml for plugin adv'
170217 14:47:53 BOT      u'Loading configuration file C:\\Users\\T-90\\Desktop\\b3-1.10.10-nt32\\conf\\plugin_welcome.ini for plugin welcome'
170217 14:47:53 BOT      'Sorting plugins according to their dependency tree...'
170217 14:47:53 BOT      'Ready to create plugin instances: admin, adv, welcome'
170217 14:47:53 BOT      u'Loading plugin #1 : admin [C:\\Users\\T-90\\Desktop\\b3-1.10.10-nt32\\conf\\plugin_admin.ini]'
170217 14:47:53 DEBUG    'AdminPlugin: register event <Stop Process>'
170217 14:47:53 DEBUG    'AdminPlugin: created event mapping: <Stop Process:onStop>'
170217 14:47:53 DEBUG    'AdminPlugin: register event <Program Exit>'
170217 14:47:53 DEBUG    'AdminPlugin: created event mapping: <Program Exit:onExit>'
170217 14:47:53 BOT      'Plugin admin (1.35 - ThorN, xlr8or, Courgette, Ozon, Fenix) loaded'
170217 14:47:53 BOT      u'Loading plugin #2 : adv [C:\\Users\\T-90\\Desktop\\b3-1.10.10-nt32\\conf\\plugin_adv.xml]'
170217 14:47:53 DEBUG    'AdvPlugin: register event <Stop Process>'
170217 14:47:53 DEBUG    'AdvPlugin: created event mapping: <Stop Process:onStop>'
170217 14:47:53 DEBUG    'AdvPlugin: register event <Program Exit>'
170217 14:47:53 DEBUG    'AdvPlugin: created event mapping: <Program Exit:onExit>'
170217 14:47:53 BOT      'Plugin adv (1.6.1 - ThorN) loaded'
170217 14:47:53 BOT      u'Loading plugin #3 : welcome [C:\\Users\\T-90\\Desktop\\b3-1.10.10-nt32\\conf\\plugin_welcome.ini]'
170217 14:47:53 DEBUG    'WelcomePlugin: register event <Stop Process>'
170217 14:47:53 DEBUG    'WelcomePlugin: created event mapping: <Stop Process:onStop>'
170217 14:47:53 DEBUG    'WelcomePlugin: register event <Program Exit>'
170217 14:47:53 DEBUG    'WelcomePlugin: created event mapping: <Program Exit:onExit>'
170217 14:47:53 BOT      'Plugin welcome (1.4 - ThorN, xlr8or, Courgette) loaded'
170217 14:47:53 BOT      'Loading plugin : publist'
170217 14:47:53 DEBUG    'PublistPlugin: register event <Stop Process>'
170217 14:47:53 DEBUG    'PublistPlugin: created event mapping: <Stop Process:onStop>'
170217 14:47:53 DEBUG    'PublistPlugin: register event <Program Exit>'
170217 14:47:53 DEBUG    'PublistPlugin: created event mapping: <Program Exit:onExit>'
170217 14:47:53 BOT      'Plugin publist (1.14 - ThorN, Courgette) loaded'
170217 14:47:53 DEBUG    'Creating the event queue with size 50'
170217 14:47:53 BOT      'Starting parser..'
170217 14:47:53 DEBUG    'message_delay: 0.8'
170217 14:47:53 INFO     "ban_agent is 'server' -> B3 will ban using the game server banlist"
170217 14:47:53 INFO     "Ban agent 'server' : activated"
170217 14:47:53 INFO     "Ban agent 'punkbuster' : deactivated"
170217 14:47:53 INFO     'value for setting bf3.big_b3_private_responses is ON'
170217 14:47:53 INFO     'value for setting bf3.big_msg_duration is 6'
170217 14:47:53 INFO     'sayqueuelistener job started'
170217 14:47:53 VERBOSE  'Added crontab <bound method Clients.sync of {}> (40885232) - 0s [0, 5, 10, 15, 20, 25, 30, 35, 40, 45, 50, 55]m -1h -1d -1M -1DOW'
170217 14:47:53 DEBUG    'Client connected: [Server] Server - Server ({})'
170217 14:47:53 DEBUG    'Storage: getClient Client<@0:Server|Server:"Server":Server>'
170217 14:47:53 BOT      'New MySQL database connection requested but last connection attempt failed less than 60 seconds ago: exiting...'
170217 14:47:53 DEBUG    "Client not found Server: 'no client matching guid Server in admins_cache'"
170217 14:47:53 BOT      'Client not found in the storage Server: create new'
170217 14:47:53 VERBOS2  'Aborted making alias for cid Server: name is the same'
170217 14:47:53 DEBUG    'Storage: setClient Client<@0:Server|Server:"Server":Server>'
170217 14:47:53 DEBUG    "Storage: setClient data {'time_add': 1487371673, 'password': '', 'time_edit': 1487371673, 'name': 'Server', 'group_bits': 0, 'ip': '', 'greeting': '', 'auto_login': 1, 'connections': 1, 'mask_level': 0, 'login': '', 'guid': 'Server', 'pbid': 'Server'}"
170217 14:47:53 BOT      'New MySQL database connection requested but last connection attempt failed less than 60 seconds ago: exiting...'
170217 14:47:53 INFO     "STDOUT 'ERROR: lost connection with the storage layer during query'"
170217 14:47:53 INFO     "STDOUT '\\n'"
170217 14:47:53 ERROR    "STDERR 'Traceback (most recent call last):\\n'"
170217 14:47:53 ERROR    'STDERR \'  File "c:\\\\jenkins_slave\\\\workspace\\\\B3-stable-release\\\\b3\\\\__init__.py", line 350, in start\\n\''
170217 14:47:53 ERROR    'STDERR \'  File "c:\\\\jenkins_slave\\\\workspace\\\\B3-stable-release\\\\b3\\\\parser.py", line 625, in start\\n\''
170217 14:47:53 ERROR    'STDERR \'  File "c:\\\\jenkins_slave\\\\workspace\\\\B3-stable-release\\\\b3\\\\parsers\\\\bf3.py", line 520, in startup\\n\''
170217 14:47:53 ERROR    'STDERR \'  File "c:\\\\jenkins_slave\\\\workspace\\\\B3-stable-release\\\\b3\\\\clients.py", line 1627, in newClient\\n\''
170217 14:47:53 ERROR    'STDERR \'  File "c:\\\\jenkins_slave\\\\workspace\\\\B3-stable-release\\\\b3\\\\clients.py", line 948, in auth\\n\''
170217 14:47:53 ERROR    'STDERR \'  File "c:\\\\jenkins_slave\\\\workspace\\\\B3-stable-release\\\\b3\\\\clients.py", line 917, in save\\n\''
170217 14:47:53 ERROR    'STDERR \'  File "c:\\\\jenkins_slave\\\\workspace\\\\B3-stable-release\\\\b3\\\\storage\\\\common.py", line 205, in setClient\\n\''
170217 14:47:53 ERROR    'STDERR \'  File "c:\\\\jenkins_slave\\\\workspace\\\\B3-stable-release\\\\b3\\\\storage\\\\common.py", line 625, in query\\n\''
170217 14:47:53 INFO     'Cron scheduler started'
170217 14:47:53 ERROR    "STDERR 'Exception: lost connection with the storage layer during query\\n'"
170217 14:47:55 BOT      'Shutting down...'
170217 14:47:55 BOT      'Stopping cron'
170217 14:47:55 BOT      'Shutting down database connection'

Offline 82ndAB.Bravo17

  • Dev. Team
  • Hero Member
  • *
  • Posts: 2528
Re: B3 Connection Error
« Reply #1 on: February 17, 2017, 11:59:40 PM »
Host \'KEENETIC\' is not allowed to connect to this MySQL server

I guess that you are connecting to a remote sql server? In which case you need to specifically allow that user to connect from that IP

 


Rate this page +1 at Google Search