View Single Post
  #6  
Old 23rd February 2007, 03:23
FredZ FredZ is offline
Member
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I deleted the mail_admin user that was in mysql and recreated it by using the command

GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost' IDENTIFIED BY 'mail_admin_password';
GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost.localdomain' IDENTIFIED BY 'mail_admin_password';
FLUSH PRIVILEGES;

I replaced the mail_admin_password with my own password.

mysql -u mail_admin -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.0.32-Dotdeb_1.dotdeb.1-log Dotdeb Sarge backport

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit
Bye

so the mail_admin account seems to be working.

The mail.log shows
Feb 23 01:11:16 localhost amavis[1248]: starting. amavisd-new at ms01 amavisd-new-20030616-p10, Unicode aware
Feb 23 01:11:17 localhost amavis[1248]: Perl version 5.008004
Feb 23 01:11:17 localhost amavis[1248]: Module Amavis::Conf 1.15
Feb 23 01:11:17 localhost amavis[1248]: Module Archive::Tar 1.23
Feb 23 01:11:17 localhost amavis[1248]: Module Archive::Zip 1.14
Feb 23 01:11:17 localhost amavis[1248]: Module Compress::Zlib 1.34
Feb 23 01:11:17 localhost amavis[1248]: Module Convert::TNEF 0.17
Feb 23 01:11:17 localhost amavis[1248]: Module Convert::UUlib 1.051
Feb 23 01:11:17 localhost amavis[1248]: Module DBI 1.46
Feb 23 01:11:17 localhost amavis[1248]: Module DB_File 1.808
Feb 23 01:11:17 localhost amavis[1248]: Module MIME::Entity 5.417
Feb 23 01:11:17 localhost amavis[1248]: Module MIME::Parser 5.417
Feb 23 01:11:17 localhost amavis[1248]: Module MIME::Tools 5.417
Feb 23 01:11:17 localhost amavis[1248]: Module Mail::Header 1.62
Feb 23 01:11:17 localhost amavis[1248]: Module Mail::Internet 1.62
Feb 23 01:11:17 localhost amavis[1248]: Module Mail::SpamAssassin 3.000003
Feb 23 01:11:17 localhost amavis[1248]: Module Net::Cmd 2.26
Feb 23 01:11:17 localhost amavis[1248]: Module Net:NS 0.48
Feb 23 01:11:17 localhost amavis[1248]: Module Net::SMTP 2.29
Feb 23 01:11:17 localhost amavis[1248]: Module Net::Server 0.87
Feb 23 01:11:17 localhost amavis[1248]: Module Time::HiRes 1.59
Feb 23 01:11:17 localhost amavis[1248]: Module Unix::Syslog 0.100
Feb 23 01:11:17 localhost amavis[1249]: Found $file at /usr/bin/file
Feb 23 01:11:17 localhost amavis[1249]: No $arc, not using it
Feb 23 01:11:17 localhost amavis[1249]: Found $gzip at /bin/gzip
Feb 23 01:11:17 localhost amavis[1249]: Found $bzip2 at /usr/bin/bzip2
Feb 23 01:11:17 localhost amavis[1249]: No $lzop, not using it
Feb 23 01:11:17 localhost amavis[1249]: No $lha, not using it
Feb 23 01:11:17 localhost amavis[1249]: Found $unarj at /usr/bin/arj
Feb 23 01:11:17 localhost amavis[1249]: Found $uncompress at /bin/uncompress
Feb 23 01:11:17 localhost amavis[1249]: No $unfreeze, not using it
Feb 23 01:11:17 localhost amavis[1249]: No $unrar, not using it
Feb 23 01:11:17 localhost amavis[1249]: Found $zoo at /usr/bin/zoo
Feb 23 01:11:17 localhost amavis[1249]: Found $cpio at /bin/cpio
Feb 23 01:11:17 localhost amavis[1249]: Using internal av scanner code for (primary) Clam Antivirus-clamd
Feb 23 01:11:17 localhost amavis[1249]: Found secondary av scanner Clam Antivirus - clamscan at /usr/bin/clamscan
Feb 23 01:11:26 localhost authdaemond.mysql: modules="authmysql", daemons=5
Feb 23 01:11:28 localhost dccifd[1580]: 1.2.74 listening to /var/lib/dcc/dccifd
Feb 23 01:11:31 localhost postfix/postfix-script: starting the Postfix mail system
Feb 23 01:11:31 localhost postfix/master[1696]: daemon started -- version 2.1.5
Feb 23 01:11:32 localhost postfix/qmgr[1705]: 4CCB1DC0A6: from=<root@ms01.shooter.co.nz>, size=484, nrcpt=1 (queue active)
Feb 23 01:11:38 localhost dccproc[1755]: socket(UDP): Address family not supported by protocol
Feb 23 01:11:39 localhost amavis[1757]: (01757-01) connect_to_sql: unable to connect to DSN 'DBI:mysql:database=mail;host=12$
Feb 23 01:11:39 localhost amavis[1757]: (01757-01) TROUBLE in check_mail: creating_partsdir FAILED: SQL server(s) not reacha$
Feb 23 01:11:39 localhost amavis[1757]: (01757-01) PRESERVING EVIDENCE in /var/lib/amavis/amavis-20070223T011139-01757
Feb 23 01:11:39 localhost postfix/smtp[1706]: 4CCB1DC0A6: to=<postmaster@isp.tld>, relay=127.0.0.1[127.0.0.1], delay=4297, s$
Feb 23 01:12:08 localhost imapd-ssl: Connection, ip=[::ffff:192.168.1.199]
Feb 23 01:12:12 localhost authdaemond.mysql: failed to connect to mysql server (server=localhost, userid=mail_admin)
Feb 23 01:12:17 localhost imapd-ssl: LOGIN FAILED, ip=[::ffff:192.168.1.199]
Feb 23 01:12:21 localhost imapd-ssl: LOGOUT, ip=[::ffff:192.168.1.199]

And the client still cannot connect.

Regards

Fred
Reply With Quote