On Sunday 27 May 2007, Tony Nelson wrote: >At 1:48 PM -0400 5/27/07, Gene Heskett wrote: >>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. > >It's probably talking about a mysql user named mysql. > >There is a mysql user if mysql is installed in a normal way, but it's home >dir is probably /var/lib/mysql. Look at "grep mysql /etc/passwd"; the >fields are username, password (usually just an x or something, real >password in /etc/shadow), UID, GID, comment (often user's real name), home >directory, login shell. Correct as usual. And its all stopped now. Thanks. >>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. > >As Justin says, that doesn't affect mysql's usernames and passwords. > >>>> 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. > >Right. > >>> ... >>> >>>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 > >Try "su - mysql". > Humm, I had forgotten that - detail, thanks. >>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. > >Well, if you never wanted it, yes indeed. > >>Thank you Tony. > >You're welcome. >-- >____________________________________________________________________ >TonyN.:' <mailto:tonynelson@xxxxxxxxxxxxxxxxx> > ' <http://www.georgeanelson.com/> -- 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) Anybody can win, unless there happens to be a second entry.
