Current time: 01-25-2022, 09:15 AM Hello There, Guest! (LoginRegister)


Post Reply 
mail_addr field [split from (HowTo) Replace courier with dovecot]
Author Message
jmeyerdo Offline
Junior Member
*

Posts: 173
Joined: Oct 2007
Reputation: 2
Post: #1
mail_addr field [split from (HowTo) Replace courier with dovecot]
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-...-1781.html

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

Kind regards, Jens
(This post was last modified: 02-20-2008 05:31 AM by joximu.)
02-16-2008 09:03 PM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #2
RE: [HowTo] Replace courier with dovecot
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
02-17-2008 01:58 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Zothos Offline
Release Manager
*****
Dev Team

Posts: 1,262
Joined: Feb 2007
Reputation: 10
Post: #3
RE: [HowTo] Replace courier with dovecot
mail_addr field is on the way. Wink
02-17-2008 02:53 AM
Find all posts by this user Quote this message in a reply
jmeyerdo Offline
Junior Member
*

Posts: 173
Joined: Oct 2007
Reputation: 2
Post: #4
RE: [HowTo] Replace courier with dovecot
Hi!

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

Thx, Jens
02-17-2008 03:10 AM
Find all posts by this user Quote this message in a reply
rbtux Offline
Moderator
*****
Moderators

Posts: 1,847
Joined: Feb 2007
Reputation: 33
Post: #5
RE: [HowTo] Replace courier with dovecot
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 ;-)
02-17-2008 03:15 AM
Visit this user's website Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #6
RE: [HowTo] Replace courier with dovecot
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
02-17-2008 03:46 AM
Visit this user's website Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #7
RE: [HowTo] Replace courier with dovecot
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..
02-17-2008 04:40 AM
Visit this user's website Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #8
RE: [HowTo] Replace courier with dovecot
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
02-19-2008 06:44 AM
Visit this user's website Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #9
RE: [HowTo] Replace courier with dovecot
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/thought...#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


Attached File(s)
.php  add_mail_acc.php (Size: 19.01 KB / Downloads: 3)
02-19-2008 10:53 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Zothos Offline
Release Manager
*****
Dev Team

Posts: 1,262
Joined: Feb 2007
Reputation: 10
Post: #10
RE: [HowTo] Replace courier with dovecot
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.
02-19-2008 09:47 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)