HI,

After i add-in the change_SQLpass plugin. My web page was going empty when i click change password from option page.

If i switch to changepass plugin and then it work fine. Due to i'm using virtual domain, i have to use the change_SQLpass plugin.

any ideas ?

Thanks

Hi,

A blank page means that there is some php error in the php script you're trying to run. Are you sure you configured the plugin correctly?
You should check your webserver error_log, or enable php logging in php.ini (you need to restart webserver)
And you should give some details about what is your webserver, squirrelmail version etc.

Regards

Hi Bathory,

So sorry for my poor explanation.

i'm configuring squirrelmail change_SQLpass plugin in.
version squirrelmail : 1.4.22
webserver : apache

Web Site i refering

MYSQL & Virtual Domain & Postfix SMTP Authentication and Dovecot SASL
http://www.linuxmail.info/multiple-d...dmin-centos-5/

http://www.linuxmail.info/squirrelma...assword-howto/
http://www.linuxmail.info/postfix-sm...sasl-centos-6/


error_log for webserver (/var/log/httpd/error_log)
[Sat Jan 14 08:28:10 2012] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips mod_wsgi/3.2 Python/2.6.6 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
[Sat Jan 14 08:44:10 2012] [error] Exception KeyError: KeyError(140416465770464,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Sat Jan 14 08:44:10 2012] [error] Exception KeyError: KeyError(140416465770464,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Sat Jan 14 08:44:10 2012] [error] Exception KeyError: KeyError(140416465770464,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Sat Jan 14 08:44:10 2012] [error] Exception KeyError: KeyError(140416465770464,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Sat Jan 14 08:44:10 2012] [error] Exception KeyError: KeyError(140416465770464,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Sat Jan 14 08:44:10 2012] [error] Exception KeyError: KeyError(140416465770464,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Sat Jan 14 08:44:10 2012] [error] Exception KeyError: KeyError(140416465770464,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Sat Jan 14 08:44:10 2012] [error] Exception KeyError: KeyError(140416465770464,) in <module 'threading' from '/usr/lib64/python2.6/threading.pyc'> ignored
[Sat Jan 14 08:44:11 2012] [notice] caught SIGTERM, shutting down
[Sat Jan 14 08:44:12 2012] [notice] SELinux policy enabled; httpd running as context system_u:system_r:httpd_t:s0
[Sat Jan 14 08:44:12 2012] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Sat Jan 14 08:44:12 2012] [notice] Digest: generating secret for digest authentication ...
[Sat Jan 14 08:44:12 2012] [notice] Digest: done
[Sat Jan 14 08:44:12 2012] [warn] mod_wsgi: Compiled for Python/2.6.2.
[Sat Jan 14 08:44:12 2012] [warn] mod_wsgi: Runtime using Python/2.6.6.
[Sat Jan 14 08:44:12 2012] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_ssl/2.2.15 OpenSSL/1.0.0-fips mod_wsgi/3.2 Python/2.6.6 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations


config php
$csp_dsn = 'mysql://postfixassword@localhost/postfix';
$lookup_password_query = 'SELECT count(*) FROM users WHERE username = "%1" AND password = %4';
$password_update_queries = array(
'UPDATE users SET password = %4 WHERE username = "%1"',
// 'UPDATE user_flags SET force_change_pwd = 0 WHERE username = "%1"',
// 'UPDATE users SET crypt_password = %4, force_change_pwd = 0 WHERE username = "%1"',
);
$force_change_password_check_query = '';
$password_encryption = 'MYSQLPWD';
$csp_salt_static = 'password';
$csp_salt_query = 'SELECT salt FROM users WHERE username = "%1"';
$csp_secure_port = 0;
$csp_non_standard_http_port = 0;
$min_password_length = 6;
$max_password_length = 0;
$include_digit_in_password = 0;
$include_uppercase_letter_in_password = 0;
$include_lowercase_letter_in_password = 0;
$include_nonalphanumeric_in_password = 0;
$csp_delimiter = '@';
$csp_debug = 0;



i enable php.ini but no able to see the log (what i add in php.ini)
error_log = /var/log/php-scripts.log

Hi,

In apache logs there is nothing related to the change password script. You should try to use the script and see what's logged.

You may also try the following in php.ini for better results:
Regards

Hi Bathory,

i already follow your step update php.ini but still unable to see the error log (php-scripts.log not found in dir).

Code:

error_reporting = E_ALL
log_errors = On
error_log = /var/log/php-scripts.log


Any Ideas ?

Thanks for your further assist.

Hi,

Are you restarting apache after editing php.ini?

Hi Bathory,

yes, i did already (even restart the pc).


Thanks
Chengli

Huh, could be selinux. Change the error_log location to some place that the apache has write permissions (/var/log/httpd/php.log)
Perhaps you need also to change ownership to apache:apache for the php.log file

HI bathory,

Thanks for your help. PHP.log work perfectly.

thanks