Navigation

    Kopano
    • Register
    • Login
    • Search
    • Categories
    • Get Official Kopano Support
    • Recent
    Statement regarding the closure of the Kopano community forum and the end of the community edition

    Distribution Groups with Postfix

    Kopano Groupware Core
    2
    3
    487
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • ashceryth
      ashceryth last edited by ashceryth

      Hi, folks!

      I am using Kopano solely with db backend. So, I created a group via kopano-admin and gave it an e-mail address with the -e parameter. I would like to send emails to this mail address from outside. As I am using Postfix I think I need to have a virtual alias map as described here: https://kb.kopano.io/display/WIKI/Postfix. However, this example just works for normal user accounts but does not resolve distribution groups, or am I wrong? Does anyone know an appropriate sql query for resolving the members of a group? Or is there a different way to send mails to all members of a group?

      Any hints are highly appreciated. Thanks!

      1 Reply Last reply Reply Quote 0
      • ashceryth
        ashceryth last edited by ashceryth

        I tried to write a sql query that seems to give me the members of a group:

        select value
        from objectproperty p
        join objectrelation r on p.objectid=r.objectid
        where r.parentobjectid=
        	(select objectid
        	from objectproperty
        	where propname='emailaddress'
        	and value='%s')
        and r.relationtype='1'
        and p.propname='emailaddress';
        

        Is this the way to go? Maybe someone could check my query as I am not a sql expert :)

        1 Reply Last reply Reply Quote 0
        • Gerald
          Gerald last edited by

          Wow, I did not even know there are examples for postfix to automatically resolve kopano users :-)

          I’ve alway been using a manually editied textfile (compiled with postmap) which lists

          name@domain.net name@domain.net
          alias1@domain.net name@domain.net
          (where name@domain.net is the “real” kopano email address)

          And If i need mails to go to more than one person, i create
          group@domain.net name1@domain.net,name2@domain.net,name3@domain.net

          1 Reply Last reply Reply Quote 0
          • First post
            Last post