Fwd: Cron <root at coyote> run-parts /etc/cron.daily

[Tony Nelson]

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

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

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 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

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 at georgeanelson.com>
      '                              <http://www.georgeanelson.com/>