Comments on How To Configure SquirrelMail To Allow Users To Change Their Email Passwords On An ISPConfig 3 Server

Thanks for the clear guide CubAfull

I also had the header errors. This was caused because I had two "enters" after the ?> at the bottom. Deleted the "enters" and it works perfectly!

Cheers,

Rudolf.

Thanks for this plugin, it seems to work very well.

Just a little thing : the last "cd .." command is wrong, isn't it ?

Thanks you very much !

After the install of the plugin (on a ubuntu 9.10 fresh install with ISPconfig3), it worked ok and users could change passwords, but they (the users) got two header errors after inputting the new password, which caused them to have to reenter .../webmail to continue with the new password.

If anyone else got them, i've fixed the errors by editing the config.php and functions.php of the plugin at the lines shown in the error statements. Just comment out the lines and it will work ok..

 Also, remember not to have any blank lines before <?php  in the beginning of the files and after the ending ?> at the end of the configs. My default config.php had 2 extra lines..

Mitz

works like a charm. Just installed squirrelmail on an ispconfig3 server yesterday and looked for a way to let my users changing password for themselves.

great job!

magenbrot

I received an error when I used this line from the config.php file:

$Lookup_Password_Query = 'SELECT count(*) FROM mail_user WHERE email = "%1" AND crypt_password = %4';

The error said that the old password could not be located [paraphrased].  When I double checked the fields in the ISPConfig database, I did not see a field named crypt_password.  I changed the query to use the password field and then it worked.

Hi am having similar problem, can u explain better where you changed the query to use password field.

This is the squirrelmail problem:

 Could not find Pear DB library

But this is my pear list:

 Installed packages, channel pear.php.net:
=========================================
Package          Version State
Console_Getopt   1.2.3   stable
DB               1.7.13  stable
MDB2             2.4.1   stable
PEAR             1.9.0   stable
Structures_Graph 1.0.3   stable
XML_Parser       1.3.2   stable
XML_Util         1.2.1   stable

I don't understand

I have the same problem:

Installed packages, channel pear.php.net:
=========================================
Package                   Version  State
Archive_Tar               1.3.5    stable
Config                    1.10.11  stable
Console_Color             1.0.2    stable
Console_CommandLine       1.0.6    stable
Console_Getopt            1.2.3    stable
Console_Table             1.1.3    stable
DB                        1.7.13   stable
DBA                       1.1.1    stable
DB_DataObject             1.8.7    stable
DB_DataObject_FormBuilder 1.0.0RC5 beta
DB_NestedSet              1.3.6    beta
DB_Pager                  0.7.2    beta
DB_QueryTool              1.1.0    stable
DB_Sqlite_Tools           0.1.6    alpha
DB_Table                  1.5.6    stable
DB_ldap                   1.2.0    stable
DB_ldap2                  0.5.0    beta
Date                      1.5.0a1  alpha
HTML_Common               1.2.5    stable
HTML_QuickForm            3.2.10   stable
HTML_Template_IT          1.2.1    stable
HTML_TreeMenu             1.2.1    stable
Image_GraphViz            1.2.1    stable
Log                       1.11.6   stable
MDB2                      2.4.1    stable
MDB2_Driver_mysql         1.4.1    stable
Mail                      1.1.14   stable
Net_FTP                   1.3.7    stable
Net_UserAgent_Detect      2.5.0    stable
PEAR                      1.7.2    stable
PEAR_Frontend_Web         0.7.3    beta
Structures_Graph          1.0.2    stable
XML_Parser                1.3.2    stable
XML_Tree                  2.0.0RC2 beta
[13:20:02 root@aaa:php]# pear install DB
Ignoring installed package pear/DB
Nothing to install
 

Could not find Pear DB library

Maybe  plugin Change SQL Password is incompatibility with DB 1.7.13 ?

Mark

Mine works, but in my pear list I have

Auth

perhaps that is the pear mod you need.

also check the config files from the plugin and make sure that pear is in the directory that is getting called.

my server debian squeeze with bind and dovecot ispconfig3 and i follow this configuration "https://www.howtoforge.com/perfect-server-debian-squeeze-with-bind-and-dovecot-ispconfig-3" i create ftp and database for my website and it's work,

but i can't open www.domain.com/webmail so i must do step "20.2"

but when i follow this configuration to change password user i got this error when i change password "Could not find Pear DB library" 

when i don't do step "20.2" i succeed change password but i can't open www.domain.com/webmail, i open webmail using ip 192.168.0.100/webmail

anyone can help me so 

1. i can create ftp and database for my website

2. i can open www.domain.com/webmail and

3. i can change password succeed ?

thx before

Found this link which details how to fix it..

http://www.evilbox.ro/linux/change-password-plugin-for-squirrelmail-on-ispconfig-3/

hello sir ,

plese kya koi mere pc ko remote access leke squirrelmail ki configuratiopn kar sakta hai .....!

Very nice place, thank you very much!!!

when ever i want change pwd...it gave error

"Could not make database connection"

Can someone point me where to look??

im sure i put mysql pswd correct.

open the config.php at /usr/share/squirrelmail/plugins

find the line $csp_dsn = .... and fix that to your setting.

After done all the steps, when ever try to change password...my webmail give error "couldn't make database connection".

 i'm not installing any ISPconfig, maybe thats why config file cant find "dbispconfig" in my mysql which is the db is not exist...

 So, for my case (no ISPconfig installed) what i got to change to make it work?

 Please help...thanks

Hi,

I fixed it with help of this post:

https://www.howtoforge.com/forums/showpost.php?s=de57837f0b3be49d058168180606c93f&p=227290&postcount=7

Hai,

i run the perfect setup on debian Squeeze, this all went ok, and ispconfig is running fine.

now i want this also in squirrelmail.
i added the plugings, configured them as on the site is standing.
did the:   vi functions.php
als the : vi config.php

checked the whole config.php

but at first i got : DATABASE ERROR: could not lookup salt:
this was a change in the config.php ( of the plugin ) the password_encryption was MYSQLPWD
so i changed that to MD5CRYPT.

now i get: unable to get old password.

Someone else tried this.

In step 4, the compatibility plugin works well in SquirrelMail version 1.5.1 or greater or SquirrelMail version 1.4.13 or greater. But in older versions we must to patch the plugin.

Patch your SquirrelMail source code - a new plugin hook is necessary for this plugin, and it can easily be added to most SquirrelMail versions. Make sure you use the patch file that pertains to your version of SquirrelMail, this files are in patches/compability_patch-1.*.*.diff.

The patch command can be run from the compatibility plugin directory :

Note for Windows users: you can get native patch functionality by installing this very useful package: http://unxutils.sourceforge.net/ I had a Centos 5.5 with squirremail version 1.4.8, after applying this patch works the plugin change_slqpass

If you had customized mail server setup, you could really easy write your own plugin, just like that guy did, see http://belsky.info/archives/31-SquirrellMail-Change-Password-Plugin.html

Tried the stuff and rewritten that to work with my database config, it works ... so it might be also useful.

Hi All,

 I followed the tutorial but changed the compatibility to version 2.0.16-1.0

My problem is that when I do 

 squirrelmail-configure 

I get the error : command not found

 From which directory do we run the command.

Thanks in advance for your help.

Did you solve this issue?? i cannot run the command ..

Hi,

I have installed ISPConfig3 on a fresh Ubuntu 14.04 64bit

 Followed the instal guides to the letter and everything works fine except for the Squirrelmail password-change function.  I get an error: Could not find Pear DB library

After following every possible fix I could find I am still at a loss as to how to remedy this.

Any suggestions would be greatly appreciated.

To fix the pear DB problem:

double check you have installed pear DB thru pear command:

<code>

pear install DB

</code>

If its missing some libs: to fear the shell, you should not padawan - just repeat pear install *MISSING* with the dependency.

After, it is a simple line that will do the trick - I dont know why isnt in the How To ... it was a nightmare to find that out too:

<code>

apt-get install php-pear php-db

</code>I was so worried about pear modules beeing loaded.. that when I did a stupid "ls" into /usr/share/php .. i noticed that DB wasnt there! It is a Debian like system so ... is there any package for it? voi la! solved.I hope it will work out for you guys.Thank you!Daniel Nascimento:.

nice

Use conf.pl intead: find / -name squirrelmailIt should be in .../squirrelmail/config/conf.pl

Is this still correct for ISPConfig 3.2.12 ? I still maintain a Squirrelmail instance for (many) users who prefer this over other webmail packages, and I've just migrated back to ISPConfig with it. Just checking if I can implement this safely in 2024..