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)B3 Can't Connect To Database!?
Pages: [1] 2   Go Down
  Print  
Author Topic: B3 Can't Connect To Database!?  (Read 1567 times) Bookmark and Share
Jr. Member
**
OS: --No B3 installed--
Type: --No B3 installed--
Gameservers: Mw2
Posts: 10
Offline Offline
« on: March 04, 2011, 05:55:46 AM »

Hii, My B3 server cant connect to my Database.. i figured out that the adress line is the problem
Every time i change it but it doesnt work Sad, still the same error

Starting www.bigbrotherbot.net (b3) v1.4.1 [nt] (Daniel) [Win32 standalone]

Using config file: b3.xml
Using external plugin directory: K:\kaaaal\Modern Warfare 2 Server\B3\BigBrother
Bot_1.4.1\extplugins
Activating log   : K:\kaaaal\Modern Warfare 2 Server\B3\BigBrotherBot_1.4.1\b3.l
og
Connecting to DB : FAILED!
Using Gamelog    : K:\kaaaal\Modern Warfare 2 Server\main\games_mp.log
Testing RCON     : OK
Loading Events   : 32 events loaded
Loading Plugins  : 220
Press the [ENTER] key


Note: rcon pass "TESTING" is hidden Tongue
Here is my b3.Xml

<?xml version="1.0"?>
<configuration>
  <settings name="b3">
    <set name="parser">cod6</set>
    <set name="database">mysql://root@localhost/b3</set>
    <set name="bot_name">B3</set>
    <set name="bot_prefix">^0(^2b3^0)^7:</set>
    <set name="time_format">%I:%M%p %Z %m/%d/%y</set>
    <set name="time_zone">CST</set>
    <set name="log_level">9</set>
    <set name="logfile">K:\\kaaaal\\Modern Warfare 2 Server\\B3\\BigBrotherBot_1.4.1\b3.log</set>
  </settings>
  <settings name="server">
    <set name="rcon_password">TESTING</set>
    <set name="port">28960</set>
    <set name="game_log">K:\kaaaal\Modern Warfare 2 Server\main\games_mp.log</set>
    <set name="public_ip">213.93.248.119</set>
    <set name="rcon_ip">192.168.1.102</set>
    <set name="punkbuster">off</set>
  </settings>
  <settings name="autodoc">
    <set name="type">0</set>
    <set name="maxlevel">100</set>
    <set name="destination"></set>
  </settings>
  <settings name="messages">
    <set name="kicked_by">$clientname^7 was kicked by $adminname^7 $reason</set>
    <set name="kicked">$clientname^7 was kicked $reason</set>
    <set name="banned_by">$clientname^7 was banned by $adminname^7 $reason</set>
    <set name="banned">$clientname^7 was banned $reason</set>
    <set name="temp_banned_by">$clientname^7 was temp banned by $adminname^7 for $banduration^7 $reason</set>
    <set name="temp_banned">$clientname^7 was temp banned for $banduration^7 $reason</set>
    <set name="unbanned_by">$clientname^7 was un-banned by $adminname^7 $reason</set>
    <set name="unbanned">$clientname^7 was un-banned $reason</set>
  </settings>
  <settings name="plugins">
    <set name="external_dir">@b3/extplugins</set>
  </settings>
  <plugins>
    <plugin name="censor" config="@conf/plugin_censor.xml"/>
    <plugin name="spamcontrol" config="@conf/plugin_spamcontrol.xml"/>
    <plugin name="admin" config="@conf/plugin_admin.xml"/>
    <plugin name="tk" config="@conf/plugin_tk.xml"/>
    <plugin name="stats" config="@conf/plugin_stats.xml"/>
    <plugin name="pingwatch" config="@conf/plugin_pingwatch.xml"/>
    <plugin name="adv" config="@conf/plugin_adv.xml"/>
    <plugin name="status" config="@conf/plugin_status.xml"/>
    <plugin name="welcome" config="@conf/plugin_welcome.xml"/>
    <plugin name="punkbuster" config="@conf/plugin_punkbuster.xml"/>
    <plugin name="xlrstats" config="@b3/extplugins/conf/xlrstats.xml"/>
  </plugins>
</configuration>
Logged

XLRstats dev.
Dev. Team
*
OS: Linux
Type: Home user
Gameservers: COD5, COD7, BF3
Posts: 947
Offline Offline
WWW
Support Specialty: XLRstats webfront
« Reply #1 on: March 04, 2011, 06:05:39 AM »

Your b3.xml seems ok.

- Make sure your MySQL user/password is correct.
- Try to use IP address (127.0.0.1) instead of localhost in DB config line in b3.xml.
Logged

Moderator
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: 2x CoD4, 1x BF3
Posts: 2627
Offline Offline
Owner of Host4B3.com - Over 70 bots hosted!
WWW
« Reply #2 on: March 04, 2011, 06:45:02 AM »

You need a password. I don't think b3 will work without one...


mysql://root:passwordneeded@localhost/b3

You could go to the privileges tab and make on if needed, or use the change password in phpmyadmin


Logged

Need B3 Bot hosting? Check out Host4B3.com
Check Twitter.com/Host4B3 for updates if the site it down.

Help will be given to those with a b3.log

System: Python 2.7.1 - B3 Source Code - Locally hosted MySQL & Apache - Win 2k3
Jr. Member
**
OS: --No B3 installed--
Type: --No B3 installed--
Gameservers: Mw2
Posts: 10
Offline Offline
« Reply #3 on: March 04, 2011, 08:04:42 AM »

Still now working, Can Someone give a tut step-to-step?

Ty Cheesy
Logged
Moderator
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: 2x CoD4, 1x BF3
Posts: 2627
Offline Offline
Owner of Host4B3.com - Over 70 bots hosted!
WWW
« Reply #4 on: March 04, 2011, 08:21:11 AM »

What OS?
Logged

Need B3 Bot hosting? Check out Host4B3.com
Check Twitter.com/Host4B3 for updates if the site it down.

Help will be given to those with a b3.log

System: Python 2.7.1 - B3 Source Code - Locally hosted MySQL & Apache - Win 2k3
Jr. Member
**
OS: --No B3 installed--
Type: --No B3 installed--
Gameservers: Mw2
Posts: 10
Offline Offline
« Reply #5 on: March 04, 2011, 09:05:11 AM »

i got Windows 7 ultimate x32 bit
Logged
Moderator
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: 2x CoD4, 1x BF3
Posts: 2627
Offline Offline
Owner of Host4B3.com - Over 70 bots hosted!
WWW
« Reply #6 on: March 04, 2011, 09:08:04 AM »

In my list of things to do is to make a windows install video...
How do you have your database install? xampp? wamp? plain old mysql?
Logged

Need B3 Bot hosting? Check out Host4B3.com
Check Twitter.com/Host4B3 for updates if the site it down.

Help will be given to those with a b3.log

System: Python 2.7.1 - B3 Source Code - Locally hosted MySQL & Apache - Win 2k3
Jr. Member
**
OS: --No B3 installed--
Type: --No B3 installed--
Gameservers: Mw2
Posts: 10
Offline Offline
« Reply #7 on: March 04, 2011, 09:10:26 AM »

i using wamp..
do you have a link to your list? (or something)
« Last Edit: March 04, 2011, 09:22:55 AM by Meliscool1 » Logged
Moderator
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: 2x CoD4, 1x BF3
Posts: 2627
Offline Offline
Owner of Host4B3.com - Over 70 bots hosted!
WWW
« Reply #8 on: March 04, 2011, 09:22:31 AM »

Link to what?

In wamp, do you have a phpmyadmin page?
Logged

Need B3 Bot hosting? Check out Host4B3.com
Check Twitter.com/Host4B3 for updates if the site it down.

Help will be given to those with a b3.log

System: Python 2.7.1 - B3 Source Code - Locally hosted MySQL & Apache - Win 2k3
Jr. Member
**
OS: --No B3 installed--
Type: --No B3 installed--
Gameservers: Mw2
Posts: 10
Offline Offline
« Reply #9 on: March 04, 2011, 09:38:52 AM »

Link to what?

In wamp, do you have a phpmyadmin page?

Yes, i set-upped everything normal up like this


I am dutch so you see it dutch xD
« Last Edit: March 04, 2011, 09:40:35 AM by Meliscool1 » Logged
Moderator
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: 2x CoD4, 1x BF3
Posts: 2627
Offline Offline
Owner of Host4B3.com - Over 70 bots hosted!
WWW
« Reply #10 on: March 04, 2011, 09:50:04 AM »

Click on the phpmyadmin logo in the top left corner.
Do you see a tab at the top that says databases? How about one that says privileges? In that tab, create a user with password and assign him to that database....
Logged

Need B3 Bot hosting? Check out Host4B3.com
Check Twitter.com/Host4B3 for updates if the site it down.

Help will be given to those with a b3.log

System: Python 2.7.1 - B3 Source Code - Locally hosted MySQL & Apache - Win 2k3
Jr. Member
**
OS: --No B3 installed--
Type: --No B3 installed--
Gameservers: Mw2
Posts: 10
Offline Offline
« Reply #11 on: March 04, 2011, 09:59:47 AM »

sounds noobish but can you say wich wich 1 it is? Lips sealed
I think you mean Rechten/Rights
« Last Edit: March 04, 2011, 10:01:56 AM by Meliscool1 » Logged
Moderator
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: 2x CoD4, 1x BF3
Posts: 2627
Offline Offline
Owner of Host4B3.com - Over 70 bots hosted!
WWW
« Reply #12 on: March 04, 2011, 10:13:51 AM »

Rights might be the same thing. In the page "Rights" do you see "Add user"
Logged

Need B3 Bot hosting? Check out Host4B3.com
Check Twitter.com/Host4B3 for updates if the site it down.

Help will be given to those with a b3.log

System: Python 2.7.1 - B3 Source Code - Locally hosted MySQL & Apache - Win 2k3
Jr. Member
**
OS: --No B3 installed--
Type: --No B3 installed--
Gameservers: Mw2
Posts: 10
Offline Offline
« Reply #13 on: March 04, 2011, 10:22:01 AM »

Tongue

Logged
Jr. Member
**
OS: --No B3 installed--
Type: --No B3 installed--
Gameservers: Mw2
Posts: 10
Offline Offline
« Reply #14 on: March 04, 2011, 11:03:58 AM »

something!, but still nothing...
It hanged a little when he tried to connect the database

When Config like this its hanging
<set name="database">mysql://root:localhost@TESTING/b3</set>
Logged
Tags:
Pages: [1] 2   Go Up
  Print  
 
Jump to:  


Rate this page +1 at Google Search


SimplePortal 2.3.1 © 2008-2009, SimplePortal