Fwd: Cron <root at coyote> run-parts /etc/cron.daily
Gene Heskett
gene.heskett at verizon.net
Sun May 27 17:48:58 UTC 2007
On Sunday 27 May 2007, Tony Nelson wrote:
>At 9:27 AM -0400 5/27/07, Gene Heskett wrote:
>>Hi folks;
>>
>>I've been trying to make this work, un-sucessfully so far. I've set a
>>password yadda yadda, but while I've spent an hour or more reading the
>>manpages, nowhere in them did I stumble across a step by step on how to
>>create, and initialize, a database called 'bugs'.
>>
>>Am I going blind in my advanced years, or is this bit of seemingly vital
>> info actually on the missing list?
>>
>>Or better yet, since this is probably the result of an update, what package
>>can I have smart remove in order to stop this daily nagging by cron?
>>
>>I also have noted that since this nagging started about 10 days ago, that
>> my logwatch report no longer contains a section listing kernel bugs. Is
>> this related?
>>
>>---------- Forwarded Message ----------
>>
>>Subject: Cron <root at coyote> run-parts /etc/cron.daily
>>Date: Sunday 27 May 2007
>>From: Cron Daemon <root at coyote.coyote.den>
>>To: root at coyote.coyote.den
>>
>>/etc/cron.daily/bugzilla:
>>
>>
>>Can't connect to the database.
>>Error: Access denied for user 'mysql'@'localhost' (using password: YES)
>
>This is the relevent part of the message. It says it can't log in to the
>mysql database. It needs to log in to the mysql database. It tried to use
>a password but it did not work. You should find out why.
>
1. There is no installed user 'mysql', or at least no home dir /home/mysql
exists.
2. There is a password set for the user 'mysql' in the other default script,
which I think its reading because the message changed a bit when I did set
the password. I also changed the password to match in the /etc/passwd file
using the passwd -u mysql command.
>> Is your database installed and up and running?
6 copies of mysqld are (sleeping) running.
>> Do you have the correct username and password selected in localconfig?
Yes, but there is not a /var/lib/mysql/bugs directory:
[root at coyote spool]# ls /var/lib/mysql
ibdata1 ib_logfile0 ib_logfile1 mysql mysql.sock test
So that 'bugs' database has apparently never been created.
> ...
>
>This is an excellent suggestion of what to check. You didn't report the
>result of trying to log in with the username and password the script is
>using. If there is a ~/.my.cnf file for the user the script runs as, is it
>correct?
[root at coyote spool]# su mysql
bash-3.1$ mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:
NO)
bash-3.1$
But, I wasn't root, I was mysql
Call me puzzled. And, I think I just got rid of the headache, it turns out
that somehow, bugzilla itself got installed. I nuked that puppy. Which
should be the end of it.
Thank you Tony.
--
Cheers, Gene
"There are four boxes to be used in defense of liberty:
soap, ballot, jury, and ammo. Please use in that order."
-Ed Howdershelt (Author)
Who goeth a-borrowing goeth a-sorrowing.
-- Thomas Tusser
More information about the fedora-list
mailing list