View previous topic :: View next topic |
Author |
Message |
tazinblack Veteran
Joined: 23 Jan 2005 Posts: 1146 Location: Baden / Germany
|
Posted: Wed Oct 01, 2014 10:13 am Post subject: virtual mailserver as in wiki not working |
|
|
Hello everyone,
I'm trying to setup a virtual mail server as described in this wiki http://wiki.gentoo.org/wiki/Complete_Virtual_Mail_Server
There they show both database systems possible to use: postgresql and mysql.
I trying to use mysql (mariadb).
It looks like this is not working as described.
I find it also a bit strange that there is a database for postfix and one for postfixadmin.
I can not see how postfix should see users created via postfixadmin.
Maybe I'm getting to old for such things.
Also the download for mysql, which contains a dump with table structure and some examples is different from the one shown in the wiki article.
Maybe someone had the same problems here and can give me a hint.
Would also be great if someone could post the config files especially the ones /etc/postfix/mysql-*.cf
I think as the database tables from postfixadmin should be ok this would help a lot.
If I had found the author of this wiki I would also let him/her know that the mysql part is not working as described so others are not running in the same problems.
So thanks a lot!
Help is very welcome. _________________ Gruß / Regards
tazinblack
_______________________________________________________
what's the point in being grown up if you can't be childish sometimes |
|
Back to top |
|
|
titanofold Developer
Joined: 30 Dec 2003 Posts: 235 Location: Bryson City, NC USA
|
|
Back to top |
|
|
thoughtform l33t
Joined: 24 May 2004 Posts: 600
|
Posted: Sat May 23, 2015 9:26 pm Post subject: |
|
|
I'm trying to follow that very same guide and ended up with two different mysql databases myself:
postfix
mailsql
I dropped the postfix db and i'm trying to do everything in the 'mailsql' database.
Re-installing postfixadmin and running it's setup.php, seem to have trouble with mariadb in place of old mysql:
Postfix Admin Setup Checker
Running software:
PHP version 5.5.25-pl0-gentoo
Apache
Checking for dependencies:
Magic Quotes: Disabled - OK
Depends on: presence config.inc.php - OK
Checking $CONF['configured'] - OK
Depends on: MySQL 3.23, 4.0 - OK
Depends on: MySQL 4.1 - OK
Testing database connection - OK - mysqli://mailsql:xxxxx@localhost/mailsql
Depends on: session - OK
Depends on: pcre - OK
Depends on: multibyte string - OK
Depends on: IMAP functions - OK
Everything seems fine... attempting to create/update database structure
Updating database:
- old version: 2; target version: 740
updating to version 3 (MySQL)...
DEBUG INFORMATION:
Invalid query: Unknown column 'create_date' in 'alias' |
|
Back to top |
|
|
charles17 Advocate
Joined: 02 Mar 2008 Posts: 3664
|
Posted: Sun May 24, 2015 6:32 am Post subject: Re: virtual mailserver as in wiki not working |
|
|
tazinblack wrote: | If I had found the author of this wiki I would also let him/her know that the mysql part is not working as described so others are not running in the same problems. |
Just leave your comment on the Discussion page. As you can see in the article's history the author is still active. |
|
Back to top |
|
|
Elleni Veteran
Joined: 23 May 2006 Posts: 1268
|
Posted: Mon Nov 30, 2015 11:29 pm Post subject: |
|
|
thoughtform wrote: | I'm trying to follow that very same guide and ended up with two different mysql databases myself:
postfix
mailsql
I dropped the postfix db and i'm trying to do everything in the 'mailsql' database.
Re-installing postfixadmin and running it's setup.php, seem to have trouble with mariadb in place of old mysql:
Postfix Admin Setup Checker
Running software:
PHP version 5.5.25-pl0-gentoo
Apache
Checking for dependencies:
Magic Quotes: Disabled - OK
Depends on: presence config.inc.php - OK
Checking $CONF['configured'] - OK
Depends on: MySQL 3.23, 4.0 - OK
Depends on: MySQL 4.1 - OK
Testing database connection - OK - mysqli://mailsql:xxxxx@localhost/mailsql
Depends on: session - OK
Depends on: pcre - OK
Depends on: multibyte string - OK
Depends on: IMAP functions - OK
Everything seems fine... attempting to create/update database structure
Updating database:
- old version: 2; target version: 740
updating to version 3 (MySQL)...
DEBUG INFORMATION:
Invalid query: Unknown column 'create_date' in 'alias' |
I ended up in the same situation. Then I tried to just create an empty mailsql and fired up postfixadmin again. This time Databasecreation from postfixadmin did not show any error.
The problem then was that following the instructions on the wiki did not work as the database was not created with the dumpfile as suggested in the wiki.
Trying to follow wiki step by step, I encountered following problems:
When creating mailsql db for postfix with dumpfile, I had to replace TYPE ->MyISAM with ENGINE -> MyiSAM, then the dumpfile could be imported to mysql. I managed to test postfix with telnet localhost 25 and send mails this way.
Postfixadmin was setup to use its own database named postfix with user postfixadmin and seemed to work too.
But when I reached the point of linking courier-imap to database backend, I was lost. Trying to authtest, the testuser@example.com did not get authenticated. In fact no user got authenticated but the one that had a local useraccount on the server and log showed that it was authenticated by authpam module and not by mysql db.
So I can confirm that the mysql part described in this wiki does not work, as mentioned by the creator of this post.
I am looking for a guide to setup a simple mailserver for a signle domain with mysql, postfix(admin) and courier-imap or dovecot if that is a bether alternative.
I will try to implement smtp auth, webaccess, ssl certificates, dkim, and antispam measures (Amavisd, Spam-Assassin and ClamAV) step by step once I managed to setup a simple mailserver.
Thanks in advance if anyone can point me to a working howto. |
|
Back to top |
|
|
|