Paul,
I got it! It's some problem on timsieved, attached there's the 511 log for
you,
It seems to login and after it complains about:
"Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[timsieved]
tims_error(+179): an invalid command was issued"
Log attached.
I changed the AUTH hash, the "XXXXXXX" was me that have inserted them there.
Jorge,
From: [email protected] [mailto:[email protected]]
On Behalf Of Jorge Bastos
Sent: quinta-feira, 16 de Julho de 2009 22:54
To: 'DBMAIL Developers Mailinglist'
Subject: Re: [Dbmail-dev] SieveScripts now showing in squirrelmail avelsieve
after upgrade
Additional info about this,
Apart from the problem below:
1- Add sieve rule
2- Rule remains visible
3- Logout and login again
4- Check existent rules, nothing's there, but rule is on DB.
How can I debug this on timsieved?
With log 511 when I check the rules on Squirrelmail there's no info on the
logs.
Please give a hand on this!
Jorge,
From: [email protected] [mailto:[email protected]]
On Behalf Of Jorge Bastos
Sent: quinta-feira, 16 de Julho de 2009 22:44
To: 'DBMAIL Developers Mailinglist'
Subject: [Dbmail-dev] SieveScripts now showing in squirrelmail avelsieve
after upgrade
Hi there,
After the upgrade, all sieve scripts that accounts had, are not shown in
squirrelmail's avelsieve.
I confirmed and they are on the db untouched.
Logging in with an account that had scripts, they are not shown, and if I
insert a new script, the existent script on the DB is overwritten.
Why without touching Squirrelmail and avelsieve, just updating dbmail, this
happened?
Jorge,
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[server]
server_sock_cb(+422): 4 2, 0x8d3b0d0
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[server]
server_sock_cb(+443): connection accepted
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Notice:[clientbase]
client_init(+168): incoming connection from [192.168.1.221:49158]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[misc]
create_unique_id(+127): created: 5965ff30ad6cec94a121a6218f05f041
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_write(+286): [0xb6a70008] S > [43/43:"IMPLEMENTATION" "DBMail timsieved
2.3.6"^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_write(+286): [0xb6a70008] S > [16/16:"SASL" "PLAIN"^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_write(+286): [0xb6a70008] S > [85/85:"SIEVE" "regex imap4flags relational
subaddress fileinto reject envelope vacation "^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_write(+286): [0xb6a70008] S > [4/4:OK^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientsession]
socket_write_cb(+161): [0x8d3ed00] state: [1]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[timsieved]
tims_cb_write(+121): [0x8d3ed00] state: [1]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientsession]
socket_write_cb(+169): reset timeout [60]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientsession]
client_session_read(+123): [0x8d3ed00] state: [1]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientbase]
ci_read_cb(+307): [0xb6a70008] reset timeout [60]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientbase]
ci_read_cb(+338): read [102:AUTHENTICATE "PLAIN" {72+}^M
bXXXXXXXXXXXXXXXXXXXXXXXXXXXXc3Rvcw==^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientbase]
ci_read_cb(+342): [0xb6a70008] state [1] read_buffer->len[102]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_readln(+390): [0xb6a70008] C < [28:AUTHENTICATE "PLAIN" {72+}^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[timsieved]
tims_tokenizer(+214): command [AUTHENTICATE] value ["PLAIN" {72+}]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_readln(+390): [0xb6a70008] C < [74:bXXXXXXXXXXXXXXXXXXXXXXXXXXXXc3Rvcw==^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[timsieved]
tims_tokenizer(+228): state [1], size [0]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[timsieved]
tims(+301): [0x8d3ed00] [4][AUTHENTICATE]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_con_get(+257): [0x8d05278] connection from pool
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_query(+344): [0x8d05278] [SELECT 1=1 FROM dbmail_usermap LIMIT 1 OFFSET 0]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
log_query_time(+290): last query took [0.000] seconds
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_con_close(+275): [0x8d05278] connection to pool
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[db]
db_use_usermap(+757): enabling usermap lookups
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[db]
db_usermap_resolve(+3140): checking userid [[email protected]] in usermap
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[db]
db_usermap_resolve(+3151): client on inet socket [inet:192.168.1.222:2000]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_con_get(+257): [0x8d05278] connection from pool
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_stmt_prepare(+397): [0x8d05278] [SELECT login, sock_allow, sock_deny, userid
FROM dbmail_usermap WHERE login in (?,'ANY') ORDER BY sock_allo
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_stmt_set_str(+405): [0x8d3cb18] 1:[[email protected]]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_con_close(+275): [0x8d05278] connection to pool
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[db]
db_usermap_resolve(+3203): login [[email protected]] not found in usermap
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_con_get(+257): [0x8d05278] connection from pool
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_stmt_prepare(+397): [0x8d05278] [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower(?)]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_stmt_set_str(+405): [0x8d40b48] 1:[[email protected]]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_con_close(+275): [0x8d05278] connection to pool
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_con_get(+257): [0x8d05278] connection from pool
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_query(+344): [0x8d05278] [SELECT passwd, encryption_type FROM dbmail_users
WHERE user_idnr = 14]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
log_query_time(+290): last query took [0.000] seconds
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_con_close(+275): [0x8d05278] connection to pool
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[auth]
auth_validate(+355): validating using plaintext passwords
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_con_get(+257): [0x8d05278] connection from pool
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_exec(+312): [0x8d05278] [UPDATE dbmail_users SET last_login = '2009-07-16
23:07:59' WHERE user_idnr = 14]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
log_query_time(+290): last query took [0.050] seconds
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_con_close(+275): [0x8d05278] connection to pool
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_write(+286): [0xb6a70008] S > [4/4:OK^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_write(+286): [0xb6a70008] S > [38/38:NO "Username or password incorrect."^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[timsieved]
tims_error(+179): an invalid command was issued
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientsession]
client_session_read(+123): [0x8d3ed00] state: [2]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientbase]
ci_read_cb(+307): [0xb6a70008] reset timeout [300]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientbase]
ci_read_cb(+338): read [12:CAPABILITY^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientbase]
ci_read_cb(+338): read [13:LISTSCRIPTS^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientbase]
ci_read_cb(+342): [0xb6a70008] state [1] read_buffer->len[25]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_readln(+390): [0xb6a70008] C < [12:CAPABILITY^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[timsieved]
tims_tokenizer(+214): command [CAPABILITY] value [(null)]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[timsieved]
tims_tokenizer(+282): [0x8d3ed00] cmd [2], state [1] [CAPABILITY]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[timsieved]
tims(+301): [0x8d3ed00] [2][CAPABILITY]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_write(+286): [0xb6a70008] S > [43/43:"IMPLEMENTATION" "DBMail timsieved
2.3.6"^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_write(+286): [0xb6a70008] S > [16/16:"SASL" "PLAIN"^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_write(+286): [0xb6a70008] S > [85/85:"SIEVE" "regex imap4flags relational
subaddress fileinto reject envelope vacation "^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_write(+286): [0xb6a70008] S > [4/4:OK^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_readln(+390): [0xb6a70008] C < [13:LISTSCRIPTS^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[timsieved]
tims_tokenizer(+214): command [LISTSCRIPTS] value [(null)]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[timsieved]
tims_tokenizer(+282): [0x8d3ed00] cmd [3], state [1] [LISTSCRIPTS]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[timsieved]
tims(+301): [0x8d3ed00] [3][LISTSCRIPTS]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_con_get(+257): [0x8d05278] connection from pool
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_query(+344): [0x8d05278] [SELECT name,active FROM dbmail_sievescripts WHERE
owner_idnr = 14]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
log_query_time(+290): last query took [0.000] seconds
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Database:[db]
db_con_close(+275): [0x8d05278] connection to pool
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_write(+286): [0xb6a70008] S > [20/20:"phpscript" ACTIVE^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Info:[clientbase]
ci_write(+286): [0xb6a70008] S > [4/4:OK^M ]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientsession]
socket_write_cb(+161): [0x8d3ed00] state: [2]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[timsieved]
tims_cb_write(+121): [0x8d3ed00] state: [2]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientsession]
socket_write_cb(+175): reset timeout [300]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientsession]
client_session_read(+123): [0x8d3ed00] state: [2]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientbase]
ci_read_cb(+307): [0xb6a70008] reset timeout [300]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientbase]
ci_read_cb(+342): [0xb6a70008] state [5] read_buffer->len[0]
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970]
Notice:[clientsession] client_session_read(+131): reached EOF
Jul 16 23:07:59 lira dbmail/timsieved[15291]: [0x8cf6970] Debug:[clientsession]
client_session_bailout(+108): [0x8d3ed00]
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
