Hi;
I have just dug into root mail messages through mutt. I have managed to
fix all the problems except 2. Some help or direction would be
appreciated.
1) The first and most re-occuring message is the following:
How do I fix this and what does bugzilla have to do with my mysql
server.
mysqld is running and mysql exists in my /etc/passwd.
------------------
mail message
------------------
Date: Fri, 20 Apr 2007 08:45:21 -0400
From: root@localhost.localdomain (Cron Daemon)
To: apache@localhost.localdomain
Subject: Cron <apache@CASE> cd /usr/share/bugzilla && env LANG=C
+/usr/share/bugzilla/whine.pl
Auto-Submitted: auto-generated
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/var/www>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=apache>
X-Cron-Env: <USER=apache>
Can't connect to the database.
Error: Access denied for user ''@'localhost' to database 'bugs'
Is your database installed and up and running?
Do you have the correct username and password selected in localconfig?
--------------------
/var/log/mysqld.log
--------------------
070420 08:44:37 mysqld started
070420 8:44:38 InnoDB: Started; log sequence number 0 43655
070420 8:44:38 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27' socket: '/var/lib/mysql/mysql.sock' port: 3306
Source distribution
---------------
my.cnf
---------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
##old_passwords=1 <== should this be commented out or not (mysql -V
mysql Ver 14.12 Distrib 5.0.27)
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
2) I gather that I am being told that /dev/hdb (my linux disk) has 333
bad sectors but is still usable/passed. My question is: now that I
know, is there any action I have to take or how do I turn of this
specific notice? Of course, if it gets worse I want to know about it.
----------------------
mail message
-----------------------
Date: Fri, 20 Apr 2007 08:45:10 -0400
From: root <root@localhost.localdomain>
To: root@localhost.localdomain
Subject: SMART error (OfflineUncorrectableSector) detected on host: CASE
This email was generated by the smartd daemon running on:
host name: CASE
DNS domain: [Unknown]
NIS domain: (none)
The following warning/error was logged by the smartd daemon:
Device: /dev/hdb, 333 Offline uncorrectable sectors
For details see host's SYSLOG (default: /var/log/messages).
You can also use the smartctl utility for further investigation.
No additional email messages about this problem will be sent.
---------------------------
/var/log/messages
----------------------------
Apr 20 08:45:08 CASE smartd[2876]: Device: /dev/hdb, opened
Apr 20 08:45:08 CASE smartd[2876]: Device: /dev/hdb, found in smartd
database.
Apr 20 08:45:09 CASE smartd[2876]: Device: /dev/hdb, is SMART capable.
Adding to "monitor" list.
Apr 20 08:45:09 CASE smartd[2876]: Monitoring 2 ATA and 0 SCSI devices
Apr 20 08:45:10 CASE smartd[2876]: Device: /dev/hdb, 333 Offline
uncorrectable sectors
Apr 20 08:45:10 CASE smartd[2876]: Sending warning via mail to root ...
------------------
[root@CASE ~]# smartctl -a /dev/hdb
---------------------
smartctl version 5.36 [i386-redhat-linux-gnu] Copyright (C) 2002-6 Bruce
Allen
Home page is http://smartmontools.sourceforge.net/
=== START OF INFORMATION SECTION ===
Model Family: Maxtor DiamondMax Plus 8 family
Device Model: Maxtor 6E040L0
Serial Number: E915LXDE
Firmware Version: NAR61EA0
User Capacity: 41,110,142,976 bytes
Device is: In smartctl database [for details use: -P show]
ATA Version is: 7
ATA Standard is: ATA/ATAPI-7 T13 1532D revision 0
Local Time is: Fri Apr 20 09:36:53 2007 EDT
SMART support is: Available - device has SMART capability.
SMART support is: Enabled
=== START OF READ SMART DATA SECTION ===
SMART overall-health self-assessment test result: PASSED
........ etc.
--
Regards Bill