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 ]

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: DB problem  (Read 1549 times) Bookmark and Share
Travisty
Jr. Member
**
OS: Windows
Type: Gameserver Rental Co.
Gameservers: CoD4, CoD5, more soon
Posts: 40
Offline Offline
WWW
« on: February 14, 2010, 12:29:03 PM »
ok so i installed b3 all the python an mysqlpythons had b3 running for a while, while testing on both my cod4 and cod5 servers but when i log out or remote desk for my dedi box xampp stops and i end up getting failed db connect..so i figured out that issue but not i get another error and im lost as to what to do to fix

b3log

Quote
BOT       Attempting to connect to database mysql://root:******@localhost/b3...
100213 15:29:42   ERROR   STDERR C:\UserFiles\twisted\GameServers\TC27237016248635613382133\library.zip\MySQLdb\__init__.py:34: DeprecationWarning: the sets module is deprecated

100213 15:29:42   BOT       Connected to database [1 times]
100213 15:29:42   BOT       Game log E:\UserFiles\twisted\GameServers\TC32612868234228713115253\mods\mp_brothers\games_mp.log
100213 15:29:42   BOT       Starting bot reading file E:\UserFiles\twisted\GameServers\TC32612868234228713115253\mods\mp_brothers\games_mp.log
100213 15:29:42   VERBOSE   RCON sending (209.212.148.143:28960) status
100213 15:29:43   BOT       Loading Plugin #1 censor [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_censor.xml]
100213 15:29:43   BOT       CensorPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_censor.xml for CensorPlugin
100213 15:29:43   DEBUG   Register Event: Stop Process: CensorPlugin
100213 15:29:43   DEBUG   Register Event: Program Exit: CensorPlugin
100213 15:29:43   BOT       Plugin censor (2.1.0 - ThorN) loaded
100213 15:29:43   BOT       Loading Plugin #2 spamcontrol [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_spamcontrol.xml]
100213 15:29:43   BOT       SpamcontrolPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_spamcontrol.xml for SpamcontrolPlugin
100213 15:29:43   DEBUG   Register Event: Stop Process: SpamcontrolPlugin
100213 15:29:43   DEBUG   Register Event: Program Exit: SpamcontrolPlugin
100213 15:29:43   BOT       Plugin spamcontrol (1.1.2 - ThorN) loaded
100213 15:29:43   BOT       Loading Plugin #3 admin [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_admin.xml]
100213 15:29:43   BOT       AdminPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_admin.xml for AdminPlugin
100213 15:29:43   DEBUG   Register Event: Stop Process: AdminPlugin
100213 15:29:43   DEBUG   Register Event: Program Exit: AdminPlugin
100213 15:29:43   BOT       Plugin admin (1.4.3 - ThorN) loaded
100213 15:29:43   BOT       Loading Plugin #4 tk [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_tk.xml]
100213 15:29:43   BOT       TkPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_tk.xml for TkPlugin
100213 15:29:43   DEBUG   TkPlugin: tk max level is 40
100213 15:29:43   DEBUG   TkPlugin: Send messages privately ? True
100213 15:29:43   DEBUG   Register Event: Stop Process: TkPlugin
100213 15:29:43   DEBUG   Register Event: Program Exit: TkPlugin
100213 15:29:43   BOT       Plugin tk (1.2.2 - ThorN) loaded
100213 15:29:43   BOT       Loading Plugin #5 stats [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_stats.xml]
100213 15:29:43   BOT       StatsPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_stats.xml for StatsPlugin
100213 15:29:43   DEBUG   AdminPlugin: Command "mapstats (mstats)" registered with cmd_mapstats for level (1, 100)
100213 15:29:43   DEBUG   AdminPlugin: Command "testscore (ts)" registered with cmd_testscore for level (1, 100)
100213 15:29:43   DEBUG   AdminPlugin: Command "topstats (tstats)" registered with cmd_topstats for level (9, 100)
100213 15:29:43   DEBUG   Register Event: Stop Process: StatsPlugin
100213 15:29:43   DEBUG   Register Event: Program Exit: StatsPlugin
100213 15:29:43   BOT       Plugin stats (1.2.3 - ThorN) loaded
100213 15:29:43   BOT       Loading Plugin #6 pingwatch [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_pingwatch.xml]
100213 15:29:43   BOT       PingwatchPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_pingwatch.xml for PingwatchPlugin
100213 15:29:43   VERBOSE   Added crontab <bound method PingwatchPlugin.check of <b3.plugins.pingwatch.PingwatchPlugin instance at 0x00E418A0>> (14964080) - [0, 30]s -1m -1h -1d -1M -1DOW
100213 15:29:43   DEBUG   Register Event: Stop Process: PingwatchPlugin
100213 15:29:43   DEBUG   Register Event: Program Exit: PingwatchPlugin
100213 15:29:43   BOT       Plugin pingwatch (1.1.4 - ThorN) loaded
thanks for any help in advance
Logged
Courgette
Senior Dev.
*
OS: Linux
Type: Home user
Posts: 3477
Offline Offline
WWW
Support Specialty: B3-Core, UrT/SmG/BFBC2 parsers, Plugin development
« Reply #1 on: February 14, 2010, 12:34:03 PM »
Quote
100213 15:29:42   ERROR   STDERR C:\UserFiles\twisted\GameServers\TC27237016248635613382133\library.zip\MySQLdb\__init__.py:34: DeprecationWarning: the sets module is deprecated
can be safely ignored
Logged
Follow me : @cucurb .~. new Smokin' guns official website
Travisty
Jr. Member
**
OS: Windows
Type: Gameserver Rental Co.
Gameservers: CoD4, CoD5, more soon
Posts: 40
Offline Offline
WWW
« Reply #2 on: February 14, 2010, 12:39:29 PM »
it know it says mysql://None:******@root:@127.0.0.1:8080/b3... but that isnt how its set in the cfg file database mysql://root:******@127.0.0.1:8080/b3 is what i have it set to...

Quote
100213 15:21:57   BOT       Attempting to connect to database mysql://None:******@root:@127.0.0.1:8080/b3...
100213 15:21:57   ERROR   STDERR C:\UserFiles\twisted\GameServers\TC27237016248635613382133\library.zip\MySQLdb\__init__.py:34: DeprecationWarning: the sets module is deprecated

100213 15:21:57   ERROR   Database connection failed, working in remote mode: connect() argument 2 must be string, not None - [('b3\\storage.pyo', 197, 'connect', None), ('b3\\storage.pyo', 153, 'getConnection', None), ('MySQLdb\\__init__.pyo', 74, 'Connect', None), ('MySQLdb\\connections.pyo', 170, '__init__', None)]
100213 15:21:57   BOT       Game log E:\UserFiles\twisted\GameServers\TC32612868234228713115253\mods\mp_brothers\games_mp.log
100213 15:21:57   BOT       Starting bot reading file E:\UserFiles\twisted\GameServers\TC32612868234228713115253\mods\mp_brothers\games_mp.log
100213 15:21:57   VERBOSE   RCON sending (209.212.148.143:28960) status
100213 15:21:58   BOT       Loading Plugin #1 censor [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_censor.xml]
100213 15:21:58   BOT       CensorPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_censor.xml for CensorPlugin
100213 15:21:58   DEBUG   Register Event: Stop Process: CensorPlugin
100213 15:21:58   DEBUG   Register Event: Program Exit: CensorPlugin
100213 15:21:58   BOT       Plugin censor (2.1.0 - ThorN) loaded
100213 15:21:58   BOT       Loading Plugin #2 spamcontrol [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_spamcontrol.xml]
100213 15:21:58   BOT       SpamcontrolPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_spamcontrol.xml for SpamcontrolPlugin
100213 15:21:58   DEBUG   Register Event: Stop Process: SpamcontrolPlugin
100213 15:21:58   DEBUG   Register Event: Program Exit: SpamcontrolPlugin
100213 15:21:58   BOT       Plugin spamcontrol (1.1.2 - ThorN) loaded
100213 15:21:58   BOT       Loading Plugin #3 admin [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_admin.xml]
100213 15:21:58   BOT       AdminPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_admin.xml for AdminPlugin
100213 15:21:58   DEBUG   Register Event: Stop Process: AdminPlugin
100213 15:21:58   DEBUG   Register Event: Program Exit: AdminPlugin
100213 15:21:58   BOT       Plugin admin (1.4.3 - ThorN) loaded
100213 15:21:58   BOT       Loading Plugin #4 tk [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_tk.xml]
100213 15:21:58   BOT       TkPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_tk.xml for TkPlugin
100213 15:21:58   DEBUG   TkPlugin: tk max level is 40
100213 15:21:58   DEBUG   TkPlugin: Send messages privately ? True
100213 15:21:58   DEBUG   Register Event: Stop Process: TkPlugin
100213 15:21:58   DEBUG   Register Event: Program Exit: TkPlugin
100213 15:21:58   BOT       Plugin tk (1.2.2 - ThorN) loaded
100213 15:21:58   BOT       Loading Plugin #5 stats [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_stats.xml]
100213 15:21:58   BOT       StatsPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_stats.xml for StatsPlugin
100213 15:21:58   DEBUG   AdminPlugin: Command "mapstats (mstats)" registered with cmd_mapstats for level (1, 100)
100213 15:21:58   DEBUG   AdminPlugin: Command "testscore (ts)" registered with cmd_testscore for level (1, 100)
100213 15:21:58   DEBUG   AdminPlugin: Command "topstats (tstats)" registered with cmd_topstats for level (9, 100)
100213 15:21:58   DEBUG   Register Event: Stop Process: StatsPlugin
100213 15:21:58   DEBUG   Register Event: Program Exit: StatsPlugin
100213 15:21:58   BOT       Plugin stats (1.2.3 - ThorN) loaded
100213 15:21:58   BOT       Loading Plugin #6 pingwatch [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_pingwatch.xml]
100213 15:21:58   BOT       PingwatchPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_pingwatch.xml for PingwatchPlugin
100213 15:21:58   VERBOSE   Added crontab <bound method PingwatchPlugin.check of <b3.plugins.pingwatch.PingwatchPlugin instance at 0x00E44738>> (14971952) - [0, 30]s -1m -1h -1d -1M -1DOW
100213 15:21:58   DEBUG   Register Event: Stop Process: PingwatchPlugin
100213 15:21:58   DEBUG   Register Event: Program Exit: PingwatchPlugin
100213 15:21:58   BOT       Plugin pingwatch (1.1.4 - ThorN) loaded
100213 15:21:58   BOT       Loading Plugin #7 adv [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_adv.xml]
100213 15:21:58   BOT       AdvPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_adv.xml for AdvPlugin
100213 15:21:58   VERBOSE   Added crontab <bound method AdvPlugin.adv of <b3.plugins.adv.AdvPlugin instance at 0x00E44AD0>> (14974256) - 0s [0, 2, 4, 6, 8, 10, 12, 14, 16, 18, 20, 22, 24, 26, 28, 30, 32, 34, 36, 38, 40, 42, 44, 46, 48, 50, 52, 54, 56, 58]m -1h -1d -1M -1DOW
100213 15:21:58   DEBUG   Register Event: Stop Process: AdvPlugin
100213 15:21:58   DEBUG   Register Event: Program Exit: AdvPlugin
100213 15:21:58   BOT       Plugin adv (1.1.3 - ThorN) loaded
100213 15:21:58   BOT       Loading Plugin #8 status [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_status.xml]
100213 15:21:58   BOT       StatusPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_status.xml for StatusPlugin
100213 15:21:58   VERBOSE   Added crontab <bound method StatusPlugin.update of <b3.plugins.status.StatusPlugin instance at 0x00E55210>> (15380848) -
  • s -1m -1h -1d -1M -1DOW
100213 15:21:58   DEBUG   Register Event: Stop Process: StatusPlugin
100213 15:21:58   DEBUG   Register Event: Program Exit: StatusPlugin
100213 15:21:58   BOT       Plugin status (1.2.7 - ThorN) loaded
100213 15:21:58   BOT       Loading Plugin #9 welcome [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_welcome.xml]
100213 15:21:58   BOT       WelcomePlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_welcome.xml for WelcomePlugin
100213 15:21:58   DEBUG   Register Event: Stop Process: WelcomePlugin
100213 15:21:58   DEBUG   Register Event: Program Exit: WelcomePlugin
100213 15:21:58   BOT       Plugin welcome (1.0.6 - ThorN) loaded
100213 15:21:58   BOT       Loading Plugin #10 publist [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_publist.xml]
100213 15:21:58   BOT       PublistPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_publist.xml for PublistPlugin
100213 15:21:58   BOT       PublistPlugin: No config file found for PublistPlugin. (was not required either)
100213 15:21:58   DEBUG   Register Event: Stop Process: PublistPlugin
100213 15:21:58   DEBUG   Register Event: Program Exit: PublistPlugin
100213 15:21:58   BOT       Plugin publist (1.1.11 - ThorN) loaded
100213 15:21:58   BOT       Loading Plugin #11 punkbuster [C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_punkbuster.xml]
100213 15:21:58   BOT       PunkbusterPlugin: Loading config C:\UserFiles\twisted\GameServers\TC27237016248635613382133\conf\plugin_punkbuster.xml for PunkbusterPlugin
100213 15:21:58   VERBOSE   Added crontab <bound method PunkbusterPlugin.rebuildBans of <b3.plugins.punkbuster.PunkbusterPlugin instance at 0x00EB69E0>> (15424336) - 0s 0m 0h -1d -1M -1DOW
100213 15:21:58   DEBUG   Register Event: Stop Process: PunkbusterPlugin
100213 15:21:58   DEBUG   Register Event: Program Exit: PunkbusterPlugin
100213 15:21:58   BOT       Plugin punkbuster (1.0.8 - ThorN) loaded
100213 15:21:58   VERBOSE   0 cid changed from None to -1
100213 15:21:58   VERBOSE   RCON sending (209.212.148.143:28960) say ^0(^2b3^0)^7: ^8www.BigBrotherBot.com ^0(^8b3^0) ^9v1.2.1 [nt] ^9(^3Daniel Win32^9)^3 ^2[ONLINE]
100213 15:21:58   DEBUG   Client Connected: [-1] World - WORLD ({})
100213 15:21:58   DEBUG   Storage: getClient <b3.clients.Client object at 0x00D25D30>
100213 15:21:58   BOT       Attempting to connect to database mysql://None:******@root:@127.0.0.1:8080/b3...
100213 15:21:58   DEBUG   User not found WORLD: 'No client matching guid WORLD in admins_cache'
100213 15:21:58   BOT       Client not found in the storage WORLD, create new
100213 15:21:58   DEBUG   Storage: setClient <b3.clients.Client object at 0x00D25D30>
100213 15:21:58   DEBUG   Storage: setClient data {'time_add': 1266096118, 'time_edit': 1266096118, 'name': 'World', 'group_bits': 0, 'ip': '', 'greeting': '', 'auto_login': 1, 'connections': 1, 'mask_level': 0, 'guid': 'WORLD', 'pbid': 'WORLD'}
100213 15:21:58   BOT       Attempting to connect to database mysql://None:******@root:@127.0.0.1:8080/b3...
100213 15:21:58   DEBUG   Client Authorized: [-1] World - WORLD
100213 15:21:58   BOT       Starting Plugin censor
100213 15:21:58   DEBUG   Register Event: Say: CensorPlugin
100213 15:21:58   DEBUG   Register Event: Team Say: CensorPlugin
100213 15:21:58   BOT       Starting Plugin spamcontrol
100213 15:21:58   DEBUG   Register Event: Say: SpamcontrolPlugin
100213 15:21:58   DEBUG   Register Event: Team Say: SpamcontrolPlugin
100213 15:21:58   DEBUG   AdminPlugin: Command "spamins (None)" registered with cmd_spamins for level (20, 100)
100213 15:21:58   BOT       Starting Plugin admin
100213 15:21:58   DEBUG   Register Event: Say: AdminPlugin
100213 15:21:58   DEBUG   Register Event: Private Message: AdminPlugin
100213 15:21:58   DEBUG   AdminPlugin: Command "status (None)" registered with cmd_status for level (20, 100)
100213 15:21:58   DEBUG   AdminPlugin: Command "ci (None)" registered with cmd_ci for level (20, 100)
100213 15:21:58   DEBUG   AdminPlugin: Command "rules (r)" registered with cmd_rules for level (0, 100)
100213 15:21:58   DEBUG   AdminPlugin: Command "warnclear (wc)" registered with cmd_warnclear for level (80, 100)
100213 15:21:58   DEBUG   AdminPlugin: Command "leveltest (lt)" registered with cmd_leveltest for level (20, 100)
100213 15:21:58   DEBUG   AdminPlugin: Command "warn (w)" registered with cmd_warn for level (20, 100)
100213 15:21:58   DEBUG   AdminPlugin: Command "list (None)" registered with cmd_list for level (20, 100)
100213 15:21:58   DEBUG   AdminPlugin: Command "warns (None)" registered with cmd_warns for level (20, 100)
100213 15:21:58   DEBUG   AdminPlugin: Command "warntest (wt)" registered with cmd_warntest for level (20, 100)
100213 15:21:58   DEBUG   AdminPlugin: Command "warninfo (wi)" registered with cmd_warninfo for level (20, 100)
1
Logged
dakotaboul123
Sr. Member
****
OS: Windows
Type: Gameserver Rental Co.
Gameservers: CoD4
Posts: 182
Offline Offline
« Reply #3 on: February 14, 2010, 02:35:47 PM »
You posted 2 logs

Each mySQL setting in the log is different....Please hep me here i am confused on what the prob is :[
Logged
ryry46d9
B3 Contrib/Support
*
OS: Linux
Type: Home user
Gameservers: Over see 25 URT servers / B3 servers (not all mine)
Posts: 339
Offline Offline
WWW
« Reply #4 on: February 14, 2010, 07:27:01 PM »
did you put your info in the b3.xml.distribution or b3.xml ?
Logged
Travisty
Jr. Member
**
OS: Windows
Type: Gameserver Rental Co.
Gameservers: CoD4, CoD5, more soon
Posts: 40
Offline Offline
WWW
« Reply #5 on: February 17, 2010, 07:32:22 AM »
i have it fixed and running i think the prob was b3 comes with 2many b3.xml files!!! u got the one in b3/conf/b3.xml then u got conf/b3.xml edit one it could be wrong file so changes dont take affect...b3 is config dbs are working now thanks
Logged
xlr8or
[ www.xlrstats.com ]
Project Lead
*
OS: Linux
Type: Owner dedicated server(s)
Gameservers: CoD, CoD2, CoD5, UrT
Posts: 2022
Offline Offline
WWW
Support Specialty: B3-Core, CoD/UrT/WoP/ETPro parsers, Plugin development
« Reply #6 on: February 19, 2010, 07:20:05 AM »
B3 should come with only 1 b3.xml file. Can you explain what might have happened that you got 2 b3.xml files?
Logged

Github repo - Groupware
ryry46d9
B3 Contrib/Support
*
OS: Linux
Type: Home user
Gameservers: Over see 25 URT servers / B3 servers (not all mine)
Posts: 339
Offline Offline
WWW
« Reply #7 on: February 19, 2010, 12:44:30 PM »
@Xlr8or b3.xml.distribution and a b3.xml

see reply4
Logged
Travisty
Jr. Member
**
OS: Windows
Type: Gameserver Rental Co.
Gameservers: CoD4, CoD5, more soon
Posts: 40
Offline Offline
WWW
« Reply #8 on: February 20, 2010, 07:50:29 AM »
i didnt have a b3.xml.distribution...in my b3 install...not sure exactly how it happen i have folder tree like this b3>conf>b3.xml then back to root i have conf>b3.xml conf>b3.xml is the file b3 uses not exactly sure how it happen or why but it works so ima leave it as is
Logged
ryry46d9
B3 Contrib/Support
*
OS: Linux
Type: Home user
Gameservers: Over see 25 URT servers / B3 servers (not all mine)
Posts: 339
Offline Offline
WWW
« Reply #9 on: February 20, 2010, 08:55:12 AM »
from all your other posts, it sounds like you should just start over from scratch.
Logged
Travisty
Jr. Member
**
OS: Windows
Type: Gameserver Rental Co.
Gameservers: CoD4, CoD5, more soon
Posts: 40
Offline Offline
WWW
« Reply #10 on: February 20, 2010, 09:14:26 AM »
but if its working and working properly other then it doing a temp ban on world...why whould i willing begin to pull my hair out again? lol no ty ill keep it as it is im sure if it has not caused much issue it will be fine i can still use all the cmds all the plugins work fine so
Logged
ryry46d9
B3 Contrib/Support
*
OS: Linux
Type: Home user
Gameservers: Over see 25 URT servers / B3 servers (not all mine)
Posts: 339
Offline Offline
WWW
« Reply #11 on: February 20, 2010, 09:48:04 AM »
but you get faster each time, you install  Shocked
Logged
Tags:
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to:  


Rate this page +1 at Google Search


SimplePortal 2.3.1 © 2008-2009, SimplePortal