Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
virtual mailserver as in wiki not working
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo
View previous topic :: View next topic  
Author Message
tazinblack
Veteran
Veteran


Joined: 23 Jan 2005
Posts: 1146
Location: Baden / Germany

PostPosted: Wed Oct 01, 2014 10:13 am    Post subject: virtual mailserver as in wiki not working Reply with quote

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
View user's profile Send private message
titanofold
Developer
Developer


Joined: 30 Dec 2003
Posts: 235
Location: Bryson City, NC USA

PostPosted: Thu Oct 02, 2014 4:49 pm    Post subject: Reply with quote

Postfix would query the same database that's managed by PostfixAdmin, if you have the system properly configured.

Do you have some log errors related to your setup not working? We really need some specifics to actually help.
_________________
The best things in life are free.
Guy-1: Surely, you will fold with me...
Guy-2: Alright, but don't call me Shirley
Back to top
View user's profile Send private message
thoughtform
l33t
l33t


Joined: 24 May 2004
Posts: 600

PostPosted: Sat May 23, 2015 9:26 pm    Post subject: Reply with quote

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
View user's profile Send private message
charles17
Advocate
Advocate


Joined: 02 Mar 2008
Posts: 3664

PostPosted: Sun May 24, 2015 6:32 am    Post subject: Re: virtual mailserver as in wiki not working Reply with quote

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
View user's profile Send private message
Elleni
Veteran
Veteran


Joined: 23 May 2006
Posts: 1268

PostPosted: Mon Nov 30, 2015 11:29 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum