cannot authenticate to Sieve

[Jean-Gabriel Duquesnoy]

Hi,

I have been following several threads concerning similar issues, but 
could not find the information which would have helped me solve the 
issue I am encountering. When using sivtest as follows:
mail:/var/log # sivtest -a duke -u duke 192.168.0.5
S: "IMPLEMENTATION" "Cyrus timsieved v2.2.12"
S: "SASL" "PLAIN"
S: "SIEVE" "fileinto reject envelope vacation imapflags notify 
subaddress relational comparator-i;ascii-numeric regex"
S: OK
Please enter your password:
C: AUTHENTICATE "PLAIN" {24+}
ZHVrZQBkdWtlAFNwb29reTc=
S: NO "Authentication Error"
Authentication failed. generic failure
Security strength factor: 0

in the logfile I found the following:

 Sep 19 20:14:40 mail master[11029]: about to 
exec /usr/lib/cyrus/bin/timsieved
Sep 19 20:14:40 mail sieve[11029]: executed
Sep 19 20:14:40 mail sieve[11029]: sql_select option missing
Sep 19 20:14:40 mail sieve[11029]: auxpropfunc error no mechanism 
available
Sep 19 20:14:40 mail sieve[11029]: _sasl_plugin_load failed on 
sasl_auxprop_plug_init for plugin: sql
Sep 19 20:14:40 mail sieve[11029]: accepted connection
Sep 19 20:14:44 mail sieve[11029]: could not find auxprop plugin, was 
searching for '[all]'
Sep 19 20:14:44 mail saslauthd[4028]: pam_mysql - MySQL error (Can't 
connect to local MySQL server through socket 
'/var/lib/mysql/mysql.soc
k' (2))
Sep 19 20:14:44 mail saslauthd[4028]: pam_unix_auth(sieve:auth): 
authentication failure; logname= uid=0 euid=0 tty= ruser= rhost=  
user=duk
e
Sep 19 20:14:46 mail saslauthd[4028]: DEBUG: auth_pam: 
pam_authenticate failed: Permission denied
Sep 19 20:14:46 mail saslauthd[4028]: do_auth         : auth failure: 
[user=duke] [service=sieve] [realm=jgduke.dnsalias.com] [mech=pam] [r
eason=PAM auth error]
Sep 19 20:14:46 mail sieve[11029]: Password verification failed
Sep 19 20:14:46 mail sieve[11029]: badlogin: 
mail.jgduke.dnsalias.com[192.168.0.5] PLAIN authentication failure
Sep 19 20:14:53 mail master[15260]: process 11029 exited, status 0
Sep 19 20:15:50 mail kernel: SFW2-INext-DROP-DEFLT IN=eth0 OUT= MAC= 
SRC=192.168.0.5 DST=192.168.0.255 LEN=78 TOS=0x00 PREC=0x00 TTL=64 
ID=
0 DF PROTO=UDP SPT=137 DPT=137 LEN=58
Sep 19 20:15:54 mail last message repeated 3 times
Sep 19 20:15:55 mail kernel: SFW2-INext-DROP-DEFLT IN=eth0 OUT= MAC= 
SRC=192.168.0.5 DST=192.168.0.255 LEN=211 TOS=0x00 PREC=0x00 TTL=64 
ID
=0 DF PROTO=UDP SPT=138 DPT=138 LEN=191
Sep 19 20:16:13 mail master[11056]: about to 
exec /usr/lib/cyrus/bin/timsieved
Sep 19 20:16:13 mail sieve[11056]: executed
Sep 19 20:16:13 mail sieve[11056]: sql_select option missing
Sep 19 20:16:13 mail sieve[11056]: auxpropfunc error no mechanism 
available
Sep 19 20:16:13 mail sieve[11056]: _sasl_plugin_load failed on 
sasl_auxprop_plug_init for plugin: sql
Sep 19 20:16:13 mail sieve[11056]: accepted connection
Sep 19 20:16:18 mail sieve[11056]: could not find auxprop plugin, was 
searching for '[all]'
Sep 19 20:16:18 mail saslauthd[4027]: pam_mysql - MySQL error (Can't 
connect to local MySQL server through socket 
'/var/lib/mysql/mysql.soc
k' (2))
Sep 19 20:16:18 mail saslauthd[4027]: pam_unix_auth(sieve:auth): 
authentication failure; logname= uid=0 euid=0 tty= ruser= rhost=  
user=duk
e
Sep 19 20:16:20 mail saslauthd[4027]: DEBUG: auth_pam: 
pam_authenticate failed: Permission denied
Sep 19 20:16:20 mail saslauthd[4027]: do_auth         : auth failure: 
[user=duke] [service=sieve] [realm=] [mech=pam] [reason=PAM auth erro
r]
Sep 19 20:16:20 mail sieve[11056]: Password verification failed
Sep 19 20:16:20 mail sieve[11056]: badlogin: 
mail.jgduke.dnsalias.com[192.168.0.5] PLAIN authentication failure
Sep 19 20:16:35 mail master[15260]: process 11056 exited, status 0

Which settings are missing or wrong which could cause this? It seems 
some information on how to access the MySQL database is missing, but 
I do nto know which.

Any help would be greatly appreciated.

--
Jean-Gabriel Duquesnoy
Sauerbornstraße 4
D-61184 Karben
Mob: +49-172-3408344