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@coyote> run-parts /etc/cron.daily >>Date: Sunday 27 May 2007 >>From: Cron Daemon <root@xxxxxxxxxxxxxxxxx> >>To: root@xxxxxxxxxxxxxxxxx >> >>/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@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@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
