Hrm. OK.
Check:
ls -al /var/lib/mysql
The username is probably root, if you haven't done anything else. The
password would have been the one you set when running the pre-cursor
scripts for the installation of QMT. You did change it, right?
Eric is right, in that I wouldn't generally expect mysql errors to
cause a slow/lagging response with telnet to port 25, though. You
might consider looking at /var/log/messages to see if Bind or your
other DNS service is performing correctly and in a timely fashion.
Also try some DNS queries, both from other machines requesting info
from your server, and from your server requesting information from
your upstream DNS servers. (This would be 'dig'; see 'man dig' for
help. Simple form 'dig <ip_of_server> <dns_name_to_check>'.)
Eric may also have some additional suggestions.
Roxanne
On May 9, 2008, at 1:25 PM, Tom Manliclic wrote:
Here's my response to the items you requested.
Roxanne Sandesara wrote:
OK. Looks like you've got an issue with your MySQL database
system. What, specifically, I can't be sure. First up, I would
think, would be to check the log for the mysql service. See if the
service is actually still running. Check permissions to the data
directory to make sure the unprivileged mysql user has the right
to view the data for the table in question. Then I'd log in,
either CLI (command line interface) or using a MySQL client app if
you have one, and see if that table exists, and what its contents
are.
Give you say this happened 'all of a sudden' without you having
done anything you can think of to set this off, it would likely be
a good idea to check for rootkit as well, just in case.
a) ps aux | grep mysql
root 3151 0.0 0.1 4500 1188 ? S 12:20 0:00 /
bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file=/
var/run/mysqld/mysqld.pid --log-error=/var/log/mysqld.log
mysql 3187 0.0 1.8 137884 18528 ? Sl 12:20 0:00 /
usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --
datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/
mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock
b) ls /var/log/mysql*
# ls /var/log/mysql*
/var/log/mysqld.log
I did not find any errors or unusual info from this log.
c) ls -al /var/lib/mysql/data
# ls -al /var/lib/mysql/data
ls: /var/lib/mysql/data: No such file or directory
d) mysql -u <username> -p
1) SHOW TABLES;
I don't have a clue on what user should I use with this but
probably the default are being used which I'm not aware off.
Can you please tell me how to check this last info?
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: qmailtoaster-list-
[EMAIL PROTECTED]
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
