[horde] [HORDE][WHUPS]: error on script pipe in postfix

Sat Mar 10 15:23:47 UTC 2018

Am 10.03.2018 um 11:20 schrieb Jan Schneider:
>
> Zitat von Carsten <horde-groupware at familie-lahme.de>:
>
>> Am 09.03.2018 um 11:38 schrieb Jan Schneider:
>>>
>>> Zitat von Carsten <horde-groupware at familie-lahme.de>:
>>>
>>>> Hi all,
>>>>
>>>> I try the set up whups with automated ticket generation from mails.
>>>>
>>>> my postfix sends the incoming mail to the pipe, but returns such an 
>>>> error:
>>>>
>>>> Mar  8 12:40:38 derdapp004 postfix/local[30799]: 04C7040C4C: 
>>>> to=<whups at localhost>, orig_to=<whups@[mydn.tdl]>, relay=local, 
>>>> delay=0.58, delays=0.09/0.04/0/0.45, dsn=5.3.0, status=bounced 
>>>> (Command died with status 255: "/usr/bin/whups-mail-filter -g". 
>>>> Command output: PHP Warning: 
>>>> require_once(/usr/share/php/www/horde/whups/lib/Application.php): 
>>>> failed to open stream: No such file or directory in 
>>>> /usr/bin/whups-mail-filter on line 73 PHP Fatal error: 
>>>> require_once(): Failed opening required 
>>>> '/usr/share/php/www/horde/whups/lib/Application.php' 
>>>> (include_path='.:/usr/share/php:/usr/share/pear') in 
>>>> /usr/bin/whups-mail-filter on line 73 )
>>>>
>>>>
>>>> If I pipe with the local user (root) from the command line, it 
>>>> works perfect.
>>>> I guess it is about a missing environment o.s.
>>>>
>>>> Can somebody advice, pls?
>>>>
>>>> br
>>>> Carsten
>>>
>>> You have set the horde_dir configuration setting in PEAR only for 
>>> the user that installed Horde, not for the user that runs the pipe. 
>>> Either use the same user for both (web server user is always a good 
>>> choice), or set the PEAR configuration for the other user too, or 
>>> set the configuration globally:
>>> $ pear config-set -c horde horde_dir /real/path/to/horde
>>> $ pear config-set -c horde horde_dir /real/path/to/horde system
>>>
>>
>> Hmm... ok, I see.
>> Let's check:
>> that's the user, I installed horde with:
>> root at derdapp004 /etc/postfix # pear config-show -c horde|grep -i 
>> horde_dir
>> Base Horde directory           horde_dir        /var/www/horde
>>
>> This is the user, the apache2 is running:
>> root at derdapp004 /etc/postfix # sudo -u www-data pear config-show -c 
>> horde|grep -i horde_dir
>> Base Horde directory           horde_dir /usr/share/php/www/horde
>>
>> And that's the postfix user:
>> root at derdapp004 /etc/postfix # sudo -u postfix pear config-show -c 
>> horde|grep -i horde_dir
>> Base Horde directory           horde_dir /usr/share/php/www/horde
>>
>>
>> ok. just to verify, the issue is still persistent, one test before 
>> the configuration change:
>> ##############
>> Mar  9 16:56:59 derdapp004 postfix/local[15222]: 117514085F: 
>> to=<whups at localhost>, orig_to=<whups@[mydn.tld]>, relay=local, 
>> delay=0.57, delays=0.08/0.04/0/0.46, dsn=5.3.0, status=bounced 
>> (Command died with status 255: "/usr/bin/whups-mail-filter -g". 
>> Command output: PHP Warning: 
>> require_once(/whups/lib/Application.php): failed to open stream: No 
>> such file or directory in /usr/bin/whups-mail-filter on line 73 PHP 
>> Fatal error:  require_once(): Failed opening required 
>> '/whups/lib/Application.php' 
>> (include_path='.:/usr/share/php:/usr/share/pear') in 
>> /usr/bin/whups-mail-filter on line 73 )
>> ################
>>
>>
>> Now I configure postfix for the dir, as root has it set:
>> root at derdapp004 /etc/postfix # sudo -u postfix pear config-set -c 
>> horde horde_dir /var/www/horde
>> config-set (horde_dir, /var/www/horde, user) failed, channel 
>> pear.horde.org
>>
>> uups... ?!?
>> With that knowledge I searched again the all-knowing-heapdump and 
>> found other horde user having that issue -which is a pear-issue, not 
>> a horde issue.
>> Daemon user do not have a interactive profile, so You !_have_! to set 
>> it system wide from my point of view.
>>
>> root at derdapp004 /home # pear config-set -c horde horde_dir 
>> /var/www/horde system
>> config-set succeeded
>>
>> And again, we test:
>> ##########################
>> Mar  9 16:59:54 derdapp004 postfix/local[15508]: 4CC8340861: 
>> to=<whups at localhost>, orig_to=<whups@[mydn.tld]>, relay=local, 
>> delay=1, delays=0.06/0.03/0/0.95, dsn=5.3.0, status=bounced (Command 
>> died with status 1: "/usr/bin/whups-mail-filter -g". Command output: 
>> Fatal Error: No such backend "" found In 
>> /var/www/horde/whups/lib/Factory/Driver.php on line 46 1. 
>> Horde_Registry::appInit() /usr/bin/whups-mail-filter:74              
>> 2. Horde_Registry->pushApp() 
>> /usr/share/php/Horde/Registry.php:299      3. 
>> Horde_Registry->_pushAppError() 
>> /usr/share/php/Horde/Registry.php:1640 4. Horde_Registry::appInit() 
>> /usr/bin/whups-mail-filter:74 5. Horde_Registry->pushApp() 
>> /usr/share/php/Horde/Registry.php:299      6. 
>> Horde_Registry->callAppMethod() 
>> /usr/share/php/Horde/Registry.php:1635 7. call_user_func_array() 
>> /usr/share/php/Horde/Registry.php:1197 8. 
>> Horde_Registry_Application->init() 9. Whups_Application->_init() 
>> /usr/share/php/Horde/Registry/Application.php:117 10. 
>> Whups_Factory_Driver->create() 
>> /var/www/horde/whups/lib/Application.php:49 )
>>
>> ##########################
>>
>> Here is my test mail for better debugging:
>>
>> ##########################
>> root at derdapp001 ~ # sendmail whups@[mydn.tld]
>> subject: Monitoring: test ticket
>> data
>> Hello World
>> [CTRL]+d
>> ##########################
>>
>> Let's give it a try on the local command line as postfix user:
>> We create a little script:
>> #################################
>> 1 root at derdapp004 /tmp # cat testmail :(
>> #!/bin/bash
>> clear;
>> echo "Hi, my name is $(whoami)";
>> echo "from: root at derdapp001.[mydn.tld] _
>> to: whups@[mydn.tld] _
>> subject: Monitoring: test alert _
>>  _
>> hallo welt _
>>  _
>> "|whups-mail-filter -g -q monitoring;
>> ######################################
>>
>> now we fire it as postfix:
>> ####################################
>> root at derdapp004 /tmp # sudo -u postfix /tmp/testmail
>> [clearscreen]
>> Hi, my name is postfix
>>
>> Message from syslogd at derdapp004 at Mar  9 17:28:18 ...
>>  HORDE: No such backend "" found [pid 17708 on line 1679 of 
>> "/usr/share/php/Horde/Registry.php"]
>>
>>   Fatal Error:
>>   No such backend "" found
>>   In /var/www/horde/whups/lib/Factory/Driver.php on line 46
>>
>>    1. Horde_Registry::appInit() /usr/bin/whups-mail-filter:74
>>    2. Horde_Registry->pushApp() /usr/share/php/Horde/Registry.php:299
>>    3. Horde_Registry->_pushAppError()
>> /usr/share/php/Horde/Registry.php:1640
>>    4. Horde_Registry::appInit() /usr/bin/whups-mail-filter:74
>>    5. Horde_Registry->pushApp() /usr/share/php/Horde/Registry.php:299
>>    6. Horde_Registry->callAppMethod()
>> /usr/share/php/Horde/Registry.php:1635
>>    7. call_user_func_array() /usr/share/php/Horde/Registry.php:1197
>>    8. Horde_Registry_Application->init()
>>    9. Whups_Application->_init()
>> /usr/share/php/Horde/Registry/Application.php:117
>>   10. Whups_Factory_Driver->create()
>> /var/www/horde/whups/lib/Application.php:49
>> ###################################
>>
>> Ok, give it a try on the root user:
>>
>> #######################################
>> root at derdapp004 /tmp # ./testmail
>> [clearscreen]
>>
>> Hi, my name is root
>> Usage: whups-mail-filter [options]
>>
>> [bla bla bla]
>>
>>   Fatal Error:
>>   --queue-name or --queue-id must specify a valid and public queue.
>>      Available queues:
>>
>>   1. Horde_Cli->fatal() /usr/bin/whups-mail-filter:169
>>
>> ##########################################################
>>
>> WTF?!?!?
>>
>> Revert system pear setting:
>> ####################################
>> root at derdapp004 /tmp # pear config-set -c horde horde_dir '' system
>> config-set succeeded
>> ######################################
>> again, local root test:
>>
>> #############################
>> root at derdapp004 /tmp # ./testmail
>> [clearscreen]
>>
>> [bla bla bla]
>>
>>   Fatal Error:
>>   --queue-name or --queue-id must specify a valid and public queue.
>>      Available queues:
>>
>>   1. Horde_Cli->fatal() /usr/bin/whups-mail-filter:169
>>
>> ###################################
>>
>> ok, last try, we check with the www-data:
>>
>> ##############################
>> root at derdapp004 ~www # sudo -u www-data /tmp/testmail
>> [clearscreen]
>>
>> Hi, my name is www-data
>> root at derdapp004 ~www #
>> ##############################
>>
>>
>> Well... ok, what is now going on.
>> Permission check on queue has been done.
>> Full rights for guest (tuned up during debugging).
>> So what is wrong here?
>>
>> *confused*
>>
>> Carsten
>
> Two things to rule out:
>
> - Use -Q instead of -q
> - Try using -a
>
Hi,
ok, changed the script like this:
#################################
root at derdapp004 /tmp # cat testmail :(
#!/bin/bash
clear;
echo "Hi, my name is $(whoami)";
echo "from: root at derdapp001.[mydn.tld] _
to: whups@[mydn.tld] _
subject: Monitoring: test alert _
  _
hallo welt _
  _
"|whups-mail-filter -g -Q 5 -a carsten@[mydn.tld];
###################################
Check root user: OK
Check www-data: OK
Check postfix: failed
###############################
Hi, my name is postfix
PHP Warning: require_once(/var/www/horde/whups/lib/Application.php): 
failed to open stream: Permission denied in /usr/bin/whups-mail-filter 
on line 73
PHP Fatal error:  require_once(): Failed opening required 
'/var/www/horde/whups/lib/Application.php' 
(include_path='.:/usr/share/php:/usr/share/pear') in 
/usr/bin/whups-mail-filter on line 73
###############################

Can You specify which files to check for permission settings?
At the moment I have 744 on all directories at /var/www/horde
and 745 on all files in the structure -I know a little insecure, but it 
debugging time ;-)

br
Carsten