For those who installed ISPConfig 3 and want to give users the ability to change their email password from SquirrelMail, there is a guide on Howtoforge.com which describes the necessary steps in order to install, configure and activate change_sqlpass plugin for SquirrelMail. For me the steps described there were not enough to get it to work.
Complete steps :
- Download and install change_sqlpass plugin
- Patch functions.php (BUG with md5crypt)
- Create new config.php with some content
- Download and install compatibility plugin
- Install pear DB
- Activate the plugin in SquirrelMail
- Modify SquirrelMail include path
- Patch change_sqlpass functions.php file to get rid of “This page request could not be verified and appears to have expired.” error message
Steps 1-6 can be found here : ISPConfig Squirrelmail plugin for changing password
The problem i encountered :
Could not find Pear DB library
after trying to change password in SquirrelMail.
To get it to work :
Make sure you have Pear DB installed : apt-get install php-pear php-db
Step 7 : Edit : /etc/apache2/conf.d/squirrelmail.conf
Comment line :
php_value include_path .
Comment line :
php_admin_value open_basedir /usr/share/squirrelmail:/etc/squirrelmail:/var/lib/squirrelmail:/etc/hostname:/etc/mailname:/var/spool/squirrelmail
Change it to :
php_admin_value open_basedir /usr/share/squirrelmail:/etc/squirrelmail:/var/lib/squirrelmail:/etc/hostname:/etc/mailname:/usr/share/php
After that , the password was changed but i got a new error :
This page request could not be verified and appears to have expired.
To solve this one, you need to patch : /usr/share/squirrelmail/plugins/change_sqlpass/functions.php
with the method described here :
Step 8 : Patch change_sqlpass
Tested on :
Squirrelmail : 1.4.22
SQLpass plugin : 3.3.12
Ubuntu Server 12.04.1 LTS x64
7 comments
Skip to comment form
Under Debian 6 and ISPconfig 3.5.0.2 (SquirellMail 1.4.22) the file /etc/apache2/conf.d/squirrelmail.conf does not exist. Don’t pay attention…
It’s work for me
ubuntu 13.03 x64
squirrelmail 1.22
change_sqlpass-3.3-1.2
many thanks.
Thanh
All ok, but now I think we have a probleme with attachments.
“Could not move/copy file. File not attached”
This probleme is from change open_basedir ?
Author
You need an upload folder as described here :
squirrelmail attachament problem
Successfully Saved Options: Password changed successfully.
Please use your new password to log in from now on.
But there’s a catch ( “There’s ALWAYS a Catch” – Constantine, John) .. password doesn’t change!
Only for the session already logged in!
Example: If i change the password from 123456 to 123456b … i cannot change again without confirm with the new password as the OLD PASSWORD. It will mismatch. Of course for we just change it!
So lets logout and try the new password – it fails. Wrong username or Password. The OLD 123456 password is the current yet. What the hell? : /
Im clueless looking at logs .. nothing showing or popping out…
Debian Wheezy 7.9
SquirrelMail version 1.4.23 [SVN]
ISPCONFIG 3.0.5.4p8
change_sqlpass-3.3-1.2
pear list
Installed packages, channel pear.php.net:
=========================================
Package Version State
Archive_Tar 1.4.0 stable
Auth 1.6.4 stable
Console_Getopt 1.4.1 stable
DB 1.9.2 stable
MDB2 2.4.1 stable
PEAR 1.10.1 stable
Structures_Graph 1.1.1 stable
XML_Util 1.3.0 stable
php DB debian package = php-db 1.7.14-2
Author
For me it works.
Installed packages, channel pear.php.net:
=========================================
Package Version State
Archive_Tar 1.3.7 stable
Auth 1.6.2 stable
Console_Getopt 1.3.0 stable
DB 1.7.13 stable
PEAR 1.9.4 stable
Structures_Graph 1.0.4 stable
XML_Util 1.2.1 stable
php-pear 5.3.10-1ubuntu3.18
Thanks.