Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 21st February 2007, 21:21
FredZ FredZ is offline
Member
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs

Hello

Well after setting up my postfix server, I am now testing it prior to installing a web client.

Under FC6 I am using Evolution to connect to the mail server.

If I setup the mail client to use POP I get no error, however, if I setup the client to use IMAP it will not authenticate (keeps asking for the password)

The mail.log states:

localhost authdaemond.mysql: failed to connect to mysql server (server=localhost, userid=mail_admin)
Localhost imapd-ssl: LOGIN FAILED, ip=[::ffff:192.168.1.199]

I am assuming the mysql server cannot be contacted. I have no idea on how to rectify this problem. Mysql server is running, and starts without errors.

Something else has just dawned upon meafter reading the document again.
Every where I find an instance of:
mail_admin
mail_admin_password
Should these be changed?
I ask this because:
Now we have to edit /etc/amavis/amavisd.conf. This is a very long file with lots of comments. I have stripped out the unnecessary parts, this is with what I ended up (make sure you adjust line 112 (@lookup_sql_dsn = ( ['DBI:mysql:database=mail;host=127.0.0.1;port=3306' , 'mail_admin', 'mail_admin_password'] ); to your own database settings):

And I didn't alter anything.

I am starting to think I haven't set the mail_admin and mail_admin_password at all and it has nothing to auth against.

Comments please

Regards

Fred

Last edited by FredZ; 21st February 2007 at 22:59.
Reply With Quote
Sponsored Links
  #2  
Old 22nd February 2007, 02:02
FredZ FredZ is offline
Member
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have now gone through and edited every instance of mail_admin_password to the password for the mail db and restarted the server.

I still have the same problem, here is my mail.log

Feb 22 00:39:09 localhost amavis[1228]: starting. amavisd-new at ms01 amavisd-new-20030616-p10, Unicode aware
Feb 22 00:39:10 localhost amavis[1228]: Perl version 5.008004
Feb 22 00:39:10 localhost amavis[1228]: Module Amavis::Conf 1.15
Feb 22 00:39:10 localhost amavis[1228]: Module Archive::Tar 1.23
Feb 22 00:39:10 localhost amavis[1228]: Module Archive::Zip 1.14
Feb 22 00:39:10 localhost amavis[1228]: Module Compress::Zlib 1.34
Feb 22 00:39:10 localhost amavis[1228]: Module Convert::TNEF 0.17
Feb 22 00:39:10 localhost amavis[1228]: Module Convert::UUlib 1.051
Feb 22 00:39:10 localhost amavis[1228]: Module DBI 1.46
Feb 22 00:39:10 localhost amavis[1228]: Module DB_File 1.808
Feb 22 00:39:10 localhost amavis[1228]: Module MIME::Entity 5.417
Feb 22 00:39:10 localhost amavis[1228]: Module MIME::Parser 5.417
Feb 22 00:39:10 localhost amavis[1228]: Module MIME::Tools 5.417
Feb 22 00:39:10 localhost amavis[1228]: Module Mail::Header 1.62
Feb 22 00:39:10 localhost amavis[1228]: Module Mail::Internet 1.62
Feb 22 00:39:10 localhost amavis[1228]: Module Mail::SpamAssassin 3.000003
Feb 22 00:39:10 localhost amavis[1228]: Module Net::Cmd 2.26
Feb 22 00:39:10 localhost amavis[1228]: Module Net:NS 0.48
Feb 22 00:39:10 localhost amavis[1228]: Module Net::SMTP 2.29
Feb 22 00:39:10 localhost amavis[1228]: Module Net::Server 0.87
Feb 22 00:39:10 localhost amavis[1228]: Module Time::HiRes 1.59
Feb 22 00:39:10 localhost amavis[1228]: Module Unix::Syslog 0.100
Feb 22 00:39:10 localhost amavis[1229]: Found $file at /usr/bin/file
Feb 22 00:39:10 localhost amavis[1229]: No $arc, not using it
Feb 22 00:39:10 localhost amavis[1229]: Found $gzip at /bin/gzip
Feb 22 00:39:10 localhost amavis[1229]: Found $bzip2 at /usr/bin/bzip2
Feb 22 00:39:10 localhost amavis[1229]: No $lzop, not using it
Feb 22 00:39:10 localhost amavis[1229]: No $lha, not using it
Feb 22 00:39:10 localhost amavis[1229]: Found $unarj at /usr/bin/arj
Feb 22 00:39:10 localhost amavis[1229]: Found $uncompress at /bin/uncompress
Feb 22 00:39:10 localhost amavis[1229]: No $unfreeze, not using it
Feb 22 00:39:10 localhost amavis[1229]: No $unrar, not using it
Feb 22 00:39:10 localhost amavis[1229]: Found $zoo at /usr/bin/zoo
Feb 22 00:39:10 localhost amavis[1229]: Found $cpio at /bin/cpio
Feb 22 00:39:10 localhost amavis[1229]: Using internal av scanner code for (primary) Clam Antivirus-clamd
Feb 22 00:39:10 localhost amavis[1229]: Found secondary av scanner Clam Antivirus - clamscan at /usr/bin/clamscan
Feb 22 00:39:19 localhost authdaemond.mysql: modules="authmysql", daemons=5
Feb 22 00:39:21 localhost dccifd[1560]: 1.2.74 listening to /var/lib/dcc/dccifd
Feb 22 00:39:25 localhost postfix/postfix-script: starting the Postfix mail system
Feb 22 00:39:26 localhost postfix/master[1676]: daemon started -- version 2.1.5
Feb 22 00:39:30 localhost dccproc[1730]: socket(UDP): Address family not supported by protocol
Feb 22 00:55:20 localhost imaplogin: Connection, ip=[::ffff:192.168.1.199]
Feb 22 00:55:24 localhost authdaemond.mysql: failed to connect to mysql server (server=localhost, userid=mail_admin)
Feb 22 00:55:30 localhost imaplogin: LOGIN FAILED, ip=[::ffff:192.168.1.199]
Feb 22 00:55:32 localhost imaplogin: LOGOUT, ip=[::ffff:192.168.1.199]
Feb 22 00:57:24 localhost imaplogin: Connection, ip=[::ffff:192.168.1.199]
Feb 22 00:57:31 localhost authdaemond.mysql: failed to connect to mysql server (server=localhost, userid=mail_admin)
Feb 22 00:57:36 localhost imaplogin: LOGIN FAILED, ip=[::ffff:192.168.1.199]
Feb 22 00:57:40 localhost authdaemond.mysql: failed to connect to mysql server (server=localhost, userid=mail_admin)


Regards

Fred
Reply With Quote
  #3  
Old 22nd February 2007, 08:45
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

Is mysql running? Can you connect from the commandline to mysql?
Code:
mysql -u mail_admin -p
? Type your password and you should get a mysql welcome prompt.
Reply With Quote
  #4  
Old 22nd February 2007, 18:49
FredZ FredZ is offline
Member
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If I type the command "mysql -u mail_admin -p" I get the following error:

ms01:~# mysql -u mail_admin -p
Enter password:
ERROR 1045 (28000): Access denied for user 'mail_admin'@'localhost' (using password: YES)

If I type the command "mysqladmin processlist -p" I get the following:

ms01:~# mysqladmin processlist -p
Enter password:
+----+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+----+---------+------+-------+------------------+
| 11 | root | localhost | | Query | 0 | | show processlist |
+----+------+-----------+----+---------+------+-------+------------------+


In both situations I am typing the same password when requested.

Regards

Fred
Reply With Quote
  #5  
Old 22nd February 2007, 18:56
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

Quote:
ms01:~# mysql -u mail_admin -p
here you use the user 'mail_admin'.
Quote:
ms01:~# mysqladmin processlist -p
Here you use the user 'root'. You will need to create the user mail_admin. I'm pretty sure this is described somewhere in the howto. Please re-read the howto and execute the missing step.
Reply With Quote
  #6  
Old 23rd February 2007, 02: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
  #7  
Old 23rd February 2007, 08:41
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

Have you installed the DBI package?
Reply With Quote
  #8  
Old 23rd February 2007, 09:42
FredZ FredZ is offline
Member
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by martinfst
Have you installed the DBI package?
I scanned the howto and there is no mention of any dbi files.

I guess the answer to your question is NO.

What files/packages should be installed?

Regards

Fred
Reply With Quote
  #9  
Old 23rd February 2007, 10:32
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

Quote:
Feb 23 01:11:39 localhost amavis[1757]: (01757-01) connect_to_sql: unable to connect to DSN 'DBI:mysql:database=mail;host=12$
I see the above in your log file. That indicates either a problem with the package, but on second look it might also be because you missed a configuration step. Previous post:
Quote:
I ask this because:
Now we have to edit /etc/amavis/amavisd.conf. This is a very long file with lots of comments. I have stripped out the unnecessary parts, this is with what I ended up (make sure you adjust line 112 (@lookup_sql_dsn = ( ['DBI:mysql:database=mail;host=127.0.0.1;port=3306' , 'mail_admin', 'mail_admin_password'] ); to your own database settings):

And I didn't alter anything.
The host should be something like localhost and not something with 12 as indicated from you log file. Could you check your /etc/amavis/amavisd.conf?
Reply With Quote
  #10  
Old 23rd February 2007, 21:01
FredZ FredZ is offline
Member
 
Join Date: Oct 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Thanks for all your help, but I have now elected to abandon this project. I am going to stay with my MS solution and bite the bullet on the huge licence.

Regards

Fred
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs k1piee HOWTO-Related Questions 14 1st October 2006 13:46
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs hdtpsi HOWTO-Related Questions 10 24th September 2006 13:52
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs mholownych HOWTO-Related Questions 10 29th May 2006 03:39
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs ebbay Installation/Configuration 9 4th March 2006 11:47
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs Rocky Installation/Configuration 24 9th February 2006 11:08


All times are GMT +2. The time now is 15:07.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.