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