Email forwarding Pipe to a Program

obosor · September 20, 2018, 7:55pm

Can you add a feature in email forwarding “Pipe to a Program” like as cPanel?

For WHMCS I use whmcs piping option. It would be better if you add this option in Email forwarding.

aldhy · February 1, 2019, 12:00pm

I need this too.

ITKoolKidd · August 3, 2019, 4:34am

whattheserver · August 21, 2019, 2:22pm

Also, +1 to this needs a proper gui support for those switching from cPanel > cyberpanel who are running osticket whmcs etc which uses email piping for support tickets.
https://docs.whmcs.com/Email_Piping

Looks like it should be doable with postfix which is what Cyberpanel uses for the email server.
https://www.anthonyhawk.com/Linux/osticket-pipe-emails-postfix.html

You may have some luck with this method.

for example from cPanel I’m migrating a whmcs from.

How it looks in cPanel

[root@vcloud ~]# cat /etc/valiases/example.com
[email protected]: “|/opt/cpanel/ea-php73/root/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
[email protected]: “|/opt/cpanel/ea-php73/root/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
[email protected]: “|/opt/cpanel/ea-php73/root/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
[email protected]: “|/opt/cpanel/ea-php73/root/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
[email protected]: “|/opt/cpanel/ea-php73/root/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
[email protected]: “|/opt/cpanel/ea-php73/root/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”

Cleaned up with proper paths in cyberpanel
[email protected]: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
[email protected]: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
[email protected]: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
[email protected]: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
[email protected]: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
[email protected]: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”

Setup aliases in /etc/postfix/virtual

[email protected] billingalias
[email protected] salesalias
[email protected] sharedsupportalias
[email protected] supportalias
[email protected] vpnsupportalias
[email protected] vpssupportalias

[root@wcloud ~]# grep -Ev ‘^#’ /etc/postfix/virtual
[email protected] billingalias
[email protected] salesalias
[email protected] sharedsupportalias
[email protected] supportalias
[email protected] vpnsupportalias
[email protected] vpssupportalias
[root@wcloud ~]#

Setup pipes based on the aliases defined above inside /etc/aliases
billingalias: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
salesalias: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
sharedsupportalias: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
supportalias: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
vpnsupportalias: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
vpssupportalias: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”

[root@wcloud ~]# grep -Ev ‘^#’ /etc/aliases | grep alias
billingalias: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
salesalias: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
sharedsupportalias: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
supportalias: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
vpnsupportalias: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
vpssupportalias: “|/usr/bin/php -q /home/username/public_html/my.example.com/crons/pipe.php”
[root@wcloud ~]#

As root:
postmap /etc/postfix/virtual
systemctl restart postfix # or service postfix restart
newaliases

upgrade_chat · September 30, 2019, 1:14am

Also, +1 to this needs a proper gui support for those switching from cPanel > cyberpanel who are running osticket whmcs etc which uses email piping for support tickets. https://docs.whmcs.com/Email_Piping

I have tried this and I keep getting:

User unknown in virtual alias table. I have tried for days to get this piping to work… would REALLY love to see this as a feature for the GUI because this is a nightmare trying to do all this via command line and files not loading / working.

Any suggestions?

whattheserver · October 3, 2019, 3:15pm

Can you provide the output of

grep -Ev ‘^#’ /etc/postfix/virtual
grep -Ev ‘^#’ /etc/aliases

whattheserver · October 28, 2019, 1:42pm

Well after alot of learning python this feature has been pushed to github and should be available for use and testing once merged into base installer.

Special shoutout to @usmannasir for the GUI modding and help with some of the commands.

Screenshots

[Album] Cyberpanel Postfix email Piping

See the commits:

github.com

usmannasir/cyberpanel/blob/dd21a17b41ae91759b8527cfca783962267f53cc/mailServer/mailserverManager.py#L424-L446


      
          ## Create Email PIPE
          ## [email protected] examplealias
          sourceusername = source.split("@")[0]
          virtualalias = '%s %salias' % (source, sourceusername)
          command = "echo '" + virtualalias + "' >> /etc/postfix/virtual"
          ProcessUtilities.executioner(command)
          
          
## examplealias: "|/usr/bin/php -q /home/domain.com/public_html/ticket/api/pipe.php"
          pipealias = '%salias:  "|%s"' % (sourceusername, destination)
          command = "echo '" + pipealias + "' >> /etc/aliases"
          ProcessUtilities.executioner(command)
          
          
#### Restarting Postfix and newalias
          
          
command = "postmap /etc/postfix/virtual"
          ProcessUtilities.executioner(command)
          
          
command = "systemctl restart postfix"
          ProcessUtilities.executioner(command)
          ##

This file has been truncated. show original

github.com

usmannasir/cyberpanel/blob/dd21a17b41ae91759b8527cfca783962267f53cc/mailServer/mailserverManager.py#L356-L375


      
          ## Delete Email PIPE
          sourceusername = source.split("@")[0]
          virtualalias = '%s %salias' % (source, sourceusername)
          pipealias = '%salias:  "|%s"' % (sourceusername, destination)
          command = "sed -i 's/^" + source + ".*//g' /etc/postfix/virtual"
          ProcessUtilities.executioner(command)
          command = "sed -i 's/^" + sourceusername + ".*//g' /etc/aliases"
          ProcessUtilities.executioner(command)
          
          
#### Restarting Postfix and newalias
          
          
command = "postmap /etc/postfix/virtual"
          ProcessUtilities.executioner(command)
          
          
command = "systemctl restart postfix"
          ProcessUtilities.executioner(command)
          ##
          
          
command = "newaliases"
          ProcessUtilities.executioner(command)

github.com

usmannasir/cyberpanel/blob/dd21a17b41ae91759b8527cfca783962267f53cc/mailServer/models.py#L48-L53


      
          class Pipeprograms(models.Model):
              source = models.CharField(max_length=80)
              destination = models.TextField()
              
              class Meta:
                  db_table = 'e_pipeprograms'

Enjoy

CyberPanel · October 29, 2019, 10:14am

Basically all credits to @whattheserver

whattheserver · November 8, 2019, 3:37pm

In case anyone comes across this I ended up updating the backend code in how this is done to use postfix filters to pipe vs /etc/aliases+/etc/postfix/virtual approach. The aliases method was having issues with the new dovecot and virtual users defaults.

The new method is more secure and works way better. If you have added any pipe to program forwarders just remove them update this one file. Alternatively you can wait and do the new cyberpanel update with this file in it and then readd them.

The new method is based on this:
http://www.zytrax.com/tech/survival/postfix.html#pipe

instead of /etc/aliases+/etc/postfix/virtual it uses /etc/postfix/script_filter + extra line added to /etc/postfix/master.cf
Format
sourceemail FILTER pipename:dummy
nano /etc/postfix/script_filter
[email protected] FILTER testpipe:dummy

Creates a pipe named sourcemail username+pipe like below
nano /etc/postfix/master.cf
testpipe unix - n n - - pipe flags=Rq user=linuxuserthatownspipedfile argv=/usr/bin/php -q /home/example.com/testpipe.php -f $(sender) – $(recipient)