$DB = array(
'TYPE' => 'mysql',
'USER' => 'mail',
'PASS' => 'SECRET',
'PROTO' => 'unix', // set to "tcp" for TCP/IP
'HOST' => 'localhost',
'NAME' => 'mail'
);
Then in mysql you would do:
use mysql;
update users set password = old_password('SECRET') where user='mail';
On Thu, 2006-04-27 at 18:06 -0400, Larry Honig wrote:
Hm. I am using Apache2 which, on Ubuntu Dapper 6.06, has mod_php_4. Both the mysql_client and mysql_server packages are version 5.0.19, and I found it impossible to downgrade to 4.1.x. As I see it, then, I can either install mod_php_5 and disable mod_php_4, which should fix this problem, or I can start mysqld using the --old-passwords directive. If I do that, and get rid of and then recreate the mail database, are you saying that will also work? I don't mind whacking the database since this is still a test server and there is nothing in it, and I don't really care about the security associated with longer encrypted passwords, either. In fact, if I do this, I suppose I could go all the way back to 'plain' instead of 'crypt' in the web-cyradm config files. Oh, wait - that is a different password, right? (The users' passwords as opposed to the password that WCA uses to log into the mail database..) Anyway, which of the two methods is preferable? Some people said a day or so back that they prefer php 4 as it seems to be faster than php 5. /Larry Honig Cheeto wrote: > Hi Larry, > Those saslauthd errors your getting is because your mysql client > library does not support the new password encryption of your mysql > server. you have 2 options > 1) Upgrade your mysql client libraries to the same version as your server > 2) use the "old_passwords" configuration option in your my.cnf. > -Michael > > Larry Honig wrote: > > >I am an idiot. Up until now saslauthd has not even been running, due to my > >failure to uncomment the line that reads "START=yes" in /etc/default/saslauthd > > > >Now that I actually have saslauthd running, I still get the following in > >auth.log: > > > >-------------- > >Apr 26 23:21:04 lazarus saslauthd[25021]: detach_tty : master pid is: 25021 > >Apr 26 23:21:04 lazarus saslauthd[25021]: ipc_init : listening on socket: > >/var/run/saslauthd/mux > >Apr 26 23:25:07 lazarus saslauthd[25022]: pam_mysql: MySQL err Client does not > >support authentication protocol requested by server; consider upgrading MySQL > >client > >Apr 26 23:25:07 lazarus saslauthd[25022]: DEBUG: auth_pam: pam_authenticate > >failed: Permission denied > >Apr 26 23:25:07 lazarus saslauthd[25022]: do_auth : auth failure: > >[user=cyrus] [service=imap] [realm=] [mech=pam] [reason=PAM auth error] > >Apr 26 23:25:21 lazarus saslauthd[25023]: pam_mysql: MySQL err Client does not > >support authentication protocol requested by server; consider upgrading MySQL > >client > >Apr 26 23:25:21 lazarus saslauthd[25023]: DEBUG: auth_pam: pam_authenticate > >failed: Permission denied > >Apr 26 23:25:21 lazarus saslauthd[25023]: do_auth : auth failure: > >[user=cyrus] [service=imap] [realm=] [mech=pam] [reason=PAM auth error] > >Apr 26 23:25:24 lazarus saslauthd[25024]: pam_mysql: MySQL err Client does not > >support authentication protocol requested by server; consider upgrading MySQL > >client > >Apr 26 23:25:24 lazarus saslauthd[25024]: DEBUG: auth_pam: pam_authenticate > >failed: Permission denied > >Apr 26 23:25:24 lazarus saslauthd[25024]: do_auth : auth failure: > >[user=cyrus] [service=imap] [realm=] [mech=pam] [reason=PAM auth error] > >Apr 26 23:27:05 lazarus saslauthd[25025]: pam_mysql: MySQL err Client does not > >support authentication protocol requested by server; consider upgrading MySQL > >client > >Apr 26 23:27:05 lazarus saslauthd[25025]: DEBUG: auth_pam: pam_authenticate > >failed: Permission denied > >Apr 26 23:27:05 lazarus saslauthd[25025]: do_auth : auth failure: > >[user=cyrus] [service=imap] [realm=] [mech=pam] [reason=PAM auth error] > >Apr 26 23:27:08 lazarus saslauthd[25021]: pam_mysql: MySQL err Client does not > >support authentication protocol requested by server; consider upgrading MySQL > >client > >Apr 26 23:27:08 lazarus saslauthd[25021]: DEBUG: auth_pam: pam_authenticate > >failed: Permission denied > >Apr 26 23:27:08 lazarus saslauthd[25021]: do_auth : auth failure: > >[user=cyrus] [service=imap] [realm=] [mech=pam] [reason=PAM auth error] > >Apr 26 23:28:42 lazarus saslauthd[25022]: pam_mysql: MySQL err Client does not > >support authentication protocol requested by server; consider upgrading MySQL > >client > > > > > > _______________________________________________ > This mailing list is hosted and supported > by bit-heads GmbH | http://www.bit-heads.ch > > _______________________________________________ > Web-cyradm mailing list > [email protected] > http://www.web-cyradm.org/mailman/listinfo/web-cyradm _______________________________________________ This mailing list is hosted and supported by bit-heads GmbH | http://www.bit-heads.ch _______________________________________________ Web-cyradm mailing list [email protected] http://www.web-cyradm.org/mailman/listinfo/web-cyradm
_______________________________________________ This mailing list is hosted and supported by bit-heads GmbH | http://www.bit-heads.ch
_______________________________________________ Web-cyradm mailing list [email protected] http://www.web-cyradm.org/mailman/listinfo/web-cyradm
