LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 01-14-2005, 08:25 AM   #1
pudhiyavan
Member
 
Registered: Oct 2003
Location: Linux world
Distribution: redhat,mandy,centos,debian,ubuntu
Posts: 209

Rep: Reputation: 30
bugzilla error! DBD mysql user access denial


I am upgrading the mysql database,

now when i am trying to access the bugzilla , it gave internal server error. so i thought i will check it thru checksetup.pl,

after checking all the req. files it moves to next position and gave the following error,


DBD::mysql::db tables failed: Access denied for user: '@localhost' to database 'bugs' [err was 1044 now 1044]
Access denied for user: '@localhost' to database 'bugs' at ./checksetup.pl line 1613.
[Fri Jan 14 04:44:47 2005] checksetup.pl: DBD::mysql::db tables failed: Access denied for user: '@localhost' to database 'bugs' [err was 1044 now 1044]
[Fri Jan 14 04:44:47 2005] checksetup.pl: Access denied for user: '@localhost' to database 'bugs' at ./checksetup.pl line 1613.
Creating table fielddefs ...
DBD::mysql::db do failed: Access denied for user: '@localhost' to database 'bugs' at ./checksetup.pl line 1636.
[Fri Jan 14 04:44:47 2005] checksetup.pl: DBD::mysql::db do failed: Access denied for user: '@localhost' to database 'bugs' at ./checksetup.pl line 1636.
Uncaught exception from user code:
Could not create table 'fielddefs'. Please check your 'mysql' access.

!. I am able to connect to the database with the same user thru cli
2. the user name have been clearly mentioned in localconfig file
3. why it was showing "user : @localhost" why not the username,

just one hint i restored all the tables from the backup before running this checkusetup.pl

will it cause any trouble?
 
Old 01-16-2006, 05:33 PM   #2
spide21
LQ Newbie
 
Registered: Nov 2005
Distribution: Fedora Core 11
Posts: 23

Rep: Reputation: 15
CPAN and granting a user correctly

Quote:
Originally Posted by pudhiyavan
I am upgrading the mysql database,

now when i am trying to access the bugzilla , it gave internal server error. so i thought i will check it thru checksetup.pl,

after checking all the req. files it moves to next position and gave the following error,


DBD::mysql::db tables failed: Access denied for user: '@localhost' to database 'bugs' [err was 1044 now 1044]
Access denied for user: '@localhost' to database 'bugs' at ./checksetup.pl line 1613.
[Fri Jan 14 04:44:47 2005] checksetup.pl: DBD::mysql::db tables failed: Access denied for user: '@localhost' to database 'bugs' [err was 1044 now 1044]
[Fri Jan 14 04:44:47 2005] checksetup.pl: Access denied for user: '@localhost' to database 'bugs' at ./checksetup.pl line 1613.
Creating table fielddefs ...
DBD::mysql::db do failed: Access denied for user: '@localhost' to database 'bugs' at ./checksetup.pl line 1636.
[Fri Jan 14 04:44:47 2005] checksetup.pl: DBD::mysql::db do failed: Access denied for user: '@localhost' to database 'bugs' at ./checksetup.pl line 1636.
Uncaught exception from user code:
Could not create table 'fielddefs'. Please check your 'mysql' access.

!. I am able to connect to the database with the same user thru cli
2. the user name have been clearly mentioned in localconfig file
3. why it was showing "user : @localhost" why not the username,

just one hint i restored all the tables from the backup before running this checkusetup.pl

will it cause any trouble?

Did u grant correctly the user to the DataBase in Localhost?

Try using another client to connect to the same DB and if it worked then your DB::MYSQL module is not working good.
if it is the problem install DB::MYSQL usgin cpan, instructions on this post:
http://www.linuxquestions.org/questi...78#post2051378
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 01:42 AM
Error compiling perl-DBD-MySQL after upgrading to MySQL 4.1 pitaro920 Linux - Software 1 01-16-2006 05:28 PM
Error with Perl DBD::mysql ginda Programming 3 03-04-2005 07:20 PM
DBD/mysql error dt23 Programming 3 04-22-2004 05:12 AM
Can't install DBD::mysql or DBD::Pg DogTags Mandriva 2 01-21-2004 08:13 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:01 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration