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. >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". >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/>
