At 10:09 PM -0400 5/27/07, Gene Heskett wrote: >On Sunday 27 May 2007, Justin W wrote: >>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. >>> >>> 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. >> >>MySQL keeps its own database of users and their passwords (by default at >>least. I've never looked into whether that can be changed). Try reading >>up on mysqladmin which can change the MySQL users' passwords so that you >>can be certain you have the right password to log in with. > >I did indeed do that, and I can su mysql, but typing the mysql shells name >still that I'm root and disallows the access. What Justin just said was that the two "mysql"s are unrelated. The mysql in /etc/passwd is not the "mysql" that is a mysql user. The two things just have the same name. >The point is I think moot now because there isn't any use of me running a >bugzilla server that I know of, so I had smart nuke it. As the script that >triggered the error is now gone from /etc/cron.daily, I'd assume that is the >end of it. I don't use mysql for anything else, so I can also stop it. Sounds OK. -- ____________________________________________________________________ TonyN.:' <mailto:tonynelson@xxxxxxxxxxxxxxxxx> ' <http://www.georgeanelson.com/>
