Dotaz: zmena hesla ve Squirrelmail

[Honza]

Zdravim. Snazim se presvedcit Squirrelmail, aby umel menit hesla v MySQL. Stahl jsem si plugin change_sqlpass a compatibility ale neja se mi nedari jej pouzit. Vite o nejakem malem a srozumitelnem navodu?

Odpovědi

[Honza]

to nikdo nepouzivate?

[Honza]

prosim poradte mi, plugin mam nainstalovanej, mam nastavenou cestu (jmeno, heslo uzivatele mohouciho menit zaznamy) k databazi, ale nevim jak presne to smerovat do konkretni tabulky, kde se nachazi uzivatelovo jmeno a heslo...

[Robert Kupka]

Na HowToForge som nedavno videl navod, ktoreho sucastou bolo aj rozbehanie Squirrelmail pluginu na zmenu hesla voci MySQL.

http://www.howtoforge.com/virtual-users-domains-postfix-courier-mysql-squirrelmail-mandriva-2009.1-x86_64

[Honza]

Jojo, na http://www.howtoforge.com/virtual-users-domains-postfix-courier-mysql-squirrelmail-mandriva-2009.1-x86_64-p5 jsem taky narazil, ale moc nerozumim tomu, jak to vyplnit na miru sve databaze:

config.php

[...]
$csp_dsn = 'mysql://mail_admin:mail_admin_password@localhost/mail';
[...]
$lookup_password_query = 'SELECT count(*) FROM users WHERE email = "%1" AND password = %4';
[...]
$password_update_queries = array('UPDATE users SET password = %4 WHERE email = "%1"');
[...]
$password_encryption = 'MYSQLENCRYPT';
[...]
$csp_salt_static = 'LEFT(password, 2)';
[...]
//$csp_salt_query = 'SELECT salt FROM users WHERE username = "%1"';
[...]
$csp_delimiter = '@';
[...]

To je podle me ten zasadni problem..

[Honza]

udelal jsem toto a funguje:

vytvoril jsem si uzivatele v MySQL "mailpass" s pravy SELECT a UPDATE na databazi mailserver

[...]
$csp_dsn = 'mysql://mailpass:mailpass_heslo@localhost/mailserver';
[...]
$lookup_password_query = 'SELECT count(*) FROM view_users WHERE email = "%1" AND password = %4';
[...]
$password_update_queries = array('UPDATE view_users SET password = %4 WHERE email = "%1"');
[...]
$password_encryption = 'MYSQLENCRYPT';
[...]
$csp_salt_static = 'LEFT(password, 2)';
[...]
//$csp_salt_query = 'SELECT salt FROM view_users WHERE username = "%1"';
[...]
$csp_delimiter = '@';
[...]