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)Connect to database failed, and bug !iamgod
Pages: 1 [2]   Go Down
  Print  
Author Topic: Connect to database failed, and bug !iamgod  (Read 1504 times) Bookmark and Share
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 #15 on: August 02, 2011, 12:46:57 PM »

without the quotes. The error is clear - it can't connect to db with that user/password, so make sure it is right!

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: Windows
Type: Home user
Gameservers: Urban Terror
Posts: 12
Offline Offline
« Reply #16 on: August 02, 2011, 11:04:34 PM »

 nevertheless I bring in well the one-liner of pass, I am good the tutoriel and the worst, it is that when I installed him for the first time he worked well. It was the version 1.3.1 I believe. But I had concerns(marigolds) for plugin then I took 1.6.0 and 1.6.1. That worked at the beginning, but I had the good idea of him uninstalled to change the name malformed ingame. And since impossible. I try full of small manipulations when I reinstall and in b3.xml, but nothing.
Logged
Dev. Team
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: COD2,COD4,COD5
Posts: 1098
Offline Offline
« Reply #17 on: August 03, 2011, 05:48:28 AM »

When you created the user B3 for mysql, did you give it the needed permissions? You have to do that after creating it.
Logged
Jr. Member
**
OS: Windows
Type: Home user
Gameservers: Urban Terror
Posts: 12
Offline Offline
« Reply #18 on: August 04, 2011, 01:30:40 AM »

Yes I made him. What I also noticed, it is that a developer of b3, named Courgette, explained me in detail the important and useful plugin, detailed me the commands, and I uninstalled everything and to reinstall and then nothing more. Maybe that he saw a failure in the passage?
Logged
Jr. Member
**
OS: Windows
Type: Home user
Gameservers: Urban Terror
Posts: 12
Offline Offline
« Reply #19 on: August 07, 2011, 12:00:24 AM »

I found of or come the problem! Finally since the console, that speaks to me of b3.sql, finally here is a screen as well as my b3.sql if it is indeed about that.

Url = http://www.casimages.com/img.php?i=110807100647127239.png

Et mon b3.sql:

-- phpMyAdmin SQL Dump
--
-- Database: `b3`
--

-- --------------------------------------------------------

--
-- Table structure for table `aliases`
--

CREATE TABLE IF NOT EXISTS aliases (
  id int(10) unsigned NOT NULL auto_increment,
  num_used int(10) unsigned NOT NULL default '0',
  alias varchar(32) NOT NULL default '',
  client_id int(10) unsigned NOT NULL default '0',
  time_add int(10) unsigned NOT NULL default '0',
  time_edit int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY alias (alias,client_id),
  KEY client_id (client_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `clients`
--

CREATE TABLE IF NOT EXISTS clients (
  id int(11) unsigned NOT NULL auto_increment,
  ip varchar(16) NOT NULL default '',
  connections int(11) unsigned NOT NULL default '0',
  guid varchar(36) NOT NULL default '',
  pbid varchar(32) NOT NULL default '',
  name varchar(32) NOT NULL default '',
  auto_login tinyint(1) unsigned NOT NULL default '0',
  mask_level tinyint(1) unsigned NOT NULL default '0',
  group_bits mediumint(Cool unsigned NOT NULL default '0',
  greeting varchar(128) NOT NULL default '',
  time_add int(11) unsigned NOT NULL default '0',
  time_edit int(11) unsigned NOT NULL default '0',
  password varchar(32) default NULL,
  login varchar(16) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY guid (guid),
  KEY group_bits (group_bits),
  KEY name (name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `groups`
--

CREATE TABLE IF NOT EXISTS groups (
  id int(10) unsigned NOT NULL,
  name varchar(32) NOT NULL default '',
  keyword varchar(32) NOT NULL default '',
  level int(10) unsigned NOT NULL default '0',
  time_edit int(10) unsigned NOT NULL default '0',
  time_add int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY keyword (keyword),
  KEY level (level)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (128, 0, 'Super Admin', 'superadmin', UNIX_TIMESTAMP(), 100);
INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (64, 0, 'Senior Admin', 'senioradmin', UNIX_TIMESTAMP(), 80);
INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (32, 0, 'Full Admin', 'fulladmin', UNIX_TIMESTAMP(), 60);
INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (16, 0, 'Admin', 'admin', UNIX_TIMESTAMP(), 40);
INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (8, 0, 'Moderator', 'mod', UNIX_TIMESTAMP(), 20);
INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (2, 0, 'Regular', 'reg', UNIX_TIMESTAMP(), 2);
INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (1, 0, 'User', 'user', UNIX_TIMESTAMP(), 1);
INSERT INTO `groups` (id, time_edit, name, keyword, time_add, level) VALUES (0, 0, 'Guest', 'guest', UNIX_TIMESTAMP(), 0);

-- --------------------------------------------------------

--
-- Table structure for table `penalties`
--

CREATE TABLE IF NOT EXISTS penalties (
  id int(10) unsigned NOT NULL auto_increment,
  type enum('Ban','TempBan','Kick','Warning','Notice') NOT NULL default 'Ban',
  client_id int(10) unsigned NOT NULL default '0',
  admin_id int(10) unsigned NOT NULL default '0',
  duration int(10) unsigned NOT NULL default '0',
  inactive tinyint(1) unsigned NOT NULL default '0',
  keyword varchar(16) NOT NULL default '',
  reason varchar(255) NOT NULL default '',
  data varchar(255) NOT NULL default '',
  time_add int(11) unsigned NOT NULL default '0',
  time_edit int(11) unsigned NOT NULL default '0',
  time_expire int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY keyword (keyword),
  KEY type (type),
  KEY time_expire (time_expire),
  KEY time_add (time_add),
  KEY admin_id (admin_id),
  KEY inactive (inactive),
  KEY client_id (client_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `data`
--

CREATE TABLE IF NOT EXISTS `data` (
  `data_key` varchar(255) NOT NULL,
  `data_value` varchar(255) NOT NULL,
  PRIMARY KEY  (`data_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
« Last Edit: August 07, 2011, 12:02:10 AM by Stunted » Logged
Dev. Team
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: COD2,COD4,COD5
Posts: 1098
Offline Offline
« Reply #20 on: August 07, 2011, 06:20:12 AM »

Did you create the database? That is what b3.sql is used for.
Logged
Jr. Member
**
OS: Windows
Type: Home user
Gameservers: Urban Terror
Posts: 12
Offline Offline
« Reply #21 on: August 07, 2011, 08:44:00 AM »

Yes and I have importer b3.sql and xlrstats.sql afterward.
Logged
Full Member
***
OS: Linux
Type: Owner dedicated server(s)
Gameservers: UrT
Posts: 55
Offline Offline
WWW
« Reply #22 on: August 08, 2011, 10:55:35 AM »

Could you type the following command into the console:
mysql -u b3 -p b3
and after that the password.
What happens?
Logged

Tags:
Pages: 1 [2]   Go Up
  Print  
 
Jump to:  


Rate this page +1 at Google Search


SimplePortal 2.3.1 © 2008-2009, SimplePortal