6.0.0-beta1
7/26/25

[#14494] Unable to access Postfixadmin SQL database
Summary Unable to access Postfixadmin SQL database
Queue Passwd
Queue Version 5.0.5
Type Bug
State Not A Bug
Priority 1. Low
Owners
Requester alex9434 (at) gmail (dot) com
Created 10/22/2016 (3199 days ago)
Due
Updated 10/22/2016 (3199 days ago)
Assigned
Resolved 10/22/2016 (3199 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
10/22/2016 03:37:52 PM Michael Rubinsky Comment #2
State ⇒ Not A Bug
Priority ⇒ 1. Low
Reply to this comment

[Show Quoted Text - 13 lines]
This should be 'crypt-md5'.
Horde.log shows the following error:
2016-10-22T10:05:23+00:00 NOTICE: HORDE [passwd] PHP ERROR: 
Undefined index: db [pid 2902 on line 113 of 
"/usr/local/share/horde/passwd/lib/Factory/Driver.php"]
2
This is a harmless existence-check error.
10/22/2016 10:17:07 AM alex9434 (at) gmail (dot) com Comment #1
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Unable to access Postfixadmin SQL database
Queue ⇒ Passwd
Milestone ⇒
Patch ⇒ No
Reply to this comment
Dear all,

Thank you for providing the great horde app. However, the password 
tool does not seem to work. I have stored my passwords in a Mariadb 
database that is managed by Postfixadmin. I used the following 
settings for backents.local.php.

<?php
$backends['postfixadmin']['disabled'] = false;
$backends['postfixadmin']['policy']['minNumeric'] = 0;
$backends['postfixadmin']['params']['phptype'] = 'mysqli';
$backends['postfixadmin']['params']['password'] = 'deleted';
$backends['postfixadmin']['params']['encryption'] = 'md5crypt';
$backends['postfixadmin']['params']['show_encryption'] = true;
$backends['postfixadmin']['params']['query_lookup'] = 'SELECT password 
FROM mailbox WHERE username = %u and active = 1';
$backends['postfixadmin']['params']['query_modify'] = 'UPDATE mailbox 
SET password = %e WHERE username = %u';

When I try to change passwords, I get the following message: Failure 
in changing password for Postfix Admin server: Incorrect old password.

Horde.log shows the following error:
2016-10-22T10:05:23+00:00 NOTICE: HORDE [passwd] PHP ERROR: Undefined 
index: db [pid 2902 on line 113 of 
"/usr/local/share/horde/passwd/lib/Factory/Driver.php"]
2

Saved Queries