ispCP - Board - Support
mail_addr field [split from (HowTo) Replace courier with dovecot] - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Contributions Area (/forum-40.html)
+--- Forum: Howtos (/forum-41.html)
+--- Thread: mail_addr field [split from (HowTo) Replace courier with dovecot] (/thread-2501.html)

Pages: 1 2


mail_addr field [split from (HowTo) Replace courier with dovecot] - jmeyerdo - 02-16-2008 09:03 PM

Hi!

I moved my complete email-handling to mysql - I changed to dovecot before and moved to postfix-mysql-handling additional so that the hash-files are not needed any longer.

I posted my postfix-mysql-configuration here:
http://www.isp-control.net/forum/domain-alias-mail-forward-t-1781.html

If anybody can confirm this you/I can add this to the WIKI, too.

Kind regards, Jens


RE: [HowTo] Replace courier with dovecot - BeNe - 02-17-2008 01:58 AM

Fine! Big thanks @jmeyerdo.
I will take a look about it. German comments in it, nice Wink

So we need the mail_adress field for dovecot and the $mail_id variable for the WebmailPass changer right ?
--> http://www.isp-control.net/ispcp/wiki/howto_webmailpass
Joxi already did a patch - thanks here also.

So we could release the next Version with a PW Changer per default.

Greez BeNe


RE: [HowTo] Replace courier with dovecot - Zothos - 02-17-2008 02:53 AM

mail_addr field is on the way. Wink


RE: [HowTo] Replace courier with dovecot - jmeyerdo - 02-17-2008 03:10 AM

Hi!

Just for understanding: Is it possible to describe the "mail_addr field"-discussion in 2-3 sentences?

Thx, Jens


RE: [HowTo] Replace courier with dovecot - rbtux - 02-17-2008 03:15 AM

yeah...

In the database there is a mail_addr field, but its not filled in by ispcp. When it would provide the mail adresse all the nasty joins between mail and domain tables would be past us ;-)


RE: [HowTo] Replace courier with dovecot - BeNe - 02-17-2008 03:46 AM

And maybe joxi can patch the trunk for the $mail_id variable.
So Dovecot with AvelSieve and PW changer is welcome in ispCP Smile

Greez BeNe


RE: [HowTo] Replace courier with dovecot - joximu - 02-17-2008 04:40 AM

Hi

the mail_id has to be patch into the passwd-plugin - but there are more things to change.

With the mail_address field thing would be *far* easier.

I'd suggest: make use of mail_address and then we can provide a webmail including password change (then the idea of including squirrel with ispCP makes (little) more sense...)

/J
PS: Sure I can commit this into the trunk... when it's ready..


RE: [HowTo] Replace courier with dovecot - joximu - 02-19-2008 06:44 AM

Hi Zothos, what about with the patch.
I added one to ticket 747 http://www.isp-control.net/ispcp/ticket/747 months ago.

Either I'll update this or you can send me your patch then I take the best.

Or did you sent it to RatS?

Cheers J


RE: [HowTo] Replace courier with dovecot - joximu - 02-19-2008 10:53 AM

Hi people

I try here because it's on topic... (not in the title but in the thread..)

I had a look over my old patch and made many corrections based on a php file by deptray (http://www.isp-control.net/forum/thoughts-about-ispcp-and-other-apps-%28mail%29-t-1430.html#pid12506)

My first tests were ok - 3 adresses (normal dom, alias & subdomain).

at the moment we only use the field mail_addr for normal mail accounts (no forwardings and catchall) - but for the sql phrases maybe it should be kept in mind that maybe sometime also the forwards have an entry in mail_addr. So there should also be another check if we only want the real mail accounts - let's choose the best...
mail_pass != _no_
mail_forward = _no_ (beware -> catchall)
mail_type = %\_mail

Please check the new client/add_mail_acc.php - for all installations since december at least...

If it's ok, we need an update script :-)
some sort of php piece to go through the table and set all mail_addr for the mail accounts till today...

/Joxi


RE: [HowTo] Replace courier with dovecot - Zothos - 02-19-2008 09:47 PM

My patch im currently wirking on is mostly the same as yours. Could you make a patch out of it if you have tested it?
So i can concentrate on my update functions.
Im currently creating a gui for this. Every DB update could take place there.
More informations in the dev forum when im ready Wink Should be ready by the end of the week.