MySQL - Bugzilla help

[Bryan O'Neal]

My hosts file has only one entry
127.0.0.1     ip-myip.ip.secureserver.net ip-myip
localhost.secureserver.net localhost.localdomain localhost 

-----Original Message-----
From: plug-discuss-bounces at lists.plug.phoenix.az.us
[mailto:plug-discuss-bounces at lists.plug.phoenix.az.us] On Behalf Of
David
Sent: Monday, February 04, 2008 4:09 PM
To: Main PLUG discussion list
Subject: Re: MySQL - Bugzilla help


----- "Bryan O'Neal" <BONeal at cornerstonehome.com> wrote:

> Ok, I am trying to install bugzilla, but I am getting an error when I 
> run ./checksetup.pl as apache Enter the e-mail address of the 
> administrator:
> bryan at loopadvertising.com
> <mailto:bryan at loopadvertising.com>
> Enter the real name of the administrator: Bryan ONeal Enter a password

> for the administrator account:
> Please retype the password to verify: DBD::mysql::db do failed:
> Access
> denied for user 'bugs'@'localhost' <mailto:'bugs'@'localhost'>  to 
> database 'bugs' at Bugzilla/DB/Mysql.pm line 209
>  
> Bugzilla::DB::Mysql::bz_lock_tables('Bugzilla::DB::Mysql=HASH(0xb2d3bc
> c) ', 'profiles WRITE', 'profiles_activity WRITE', 'user_group_map 
> WRITE', 'email_setting WRITE', 'groups READ', 'tokens READ', 
> 'fielddefs
> READ')
> called at Bugzilla/User.pm line 1548
>         Bugzilla::User::create('Bugzilla::User', 'HASH(0xb3e0f78)') 
> called at Bugzilla/Install.pm line 330
>         Bugzilla::Install::create_admin() called at ./checksetup.pl 
> line
> 214
> 
> So I decided to check out the DB but I was denied access.
>  
> As MySQL root I set up permissions prior to executing the install 
> script.
> mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,
> ALTER,CREATE,DROP,REFERENCES ON bugs.* TO bugs at localhost 
> <mailto:bugs at localhost>  IDENTIFIED BY 'SomePassword';
> mysql> FLUSH PRIVILEGES;
> 
> Then I ran the script which gave me the above error.  So I decided to 
> cheek out the DB.  As root I executed mysql -u=root (I did not get a 
> password prompt, which I thought was way odd since I have set the root
> password)
> 
> mysql> show databases;
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema | 
> | test               | 
> +--------------------+
> 2 rows in set (0.00 sec)
> 
>  
> Note, that the database bugs is not listed. However it is in the 
> system somewhere
> mysql> create database bugs;
> ERROR 1044 (42000): Access denied for user ''@'localhost'
> <mailto:''@'localhost'>  to database 'bugs'
> mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,
> ALTER,CREATE,DROP,REFERENCES ON bugs.* TO bugs at localhost 
> <mailto:bugs at localhost>  IDENTIFIED BY 'SomePassword'; ERROR 1044 
> (42000): Access denied for user ''@'localhost'
> <mailto:''@'localhost'>  to database 'bugs'
> 
>  
> I am not very failure with BugZilla..  Any suggestions on how to get 
> rid of this error and continue installation?
>  

Not sure which distro you're using, but if it's redhat, check your
/etc/hosts file.   They've
been known to do some funky things to is.

David

-- 
"I find your lack of faith disturbing."
--Darth Vader
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss