I try to update sieve script.
a) new script inserted with magic name
b) old script don't deleted (!)
c) new script renamed
and I get 2 scripts with the same name (old - active, new - not)
pool.c,child_reg_connected: [13036]
serverchild.c,PerformChildTask: incoming connection from [62.89.253.152]
serverchild.c,PerformChildTask: client info init complete, calling client
handler
tims(): incoming buffer: [AUTHENTICATE "PLAIN" {16+}]
tims(): command issued: cmd [AUTHENTICATE], val ["PLAIN" {16+}]
tims(): command looked up as commandtype 4
misc.c, find_bounded: Found nothing between '"' and '"'
misc.c, find_bounded: Found [16] of length [2] between '{' and '+' so next
skip [4]
db.c,db_usermap_resolve: checking userid 'loe' in usermap
db.c,db_usermap_resolve: client on inet socket [inet:62.89.253.152:20000]
dbmysql.c,db_query: executing query [SELECT login, sock_allow, sock_deny,
userid FROM dbmail_usermap WHERE login in ('loe','ANY') ORDER BY sock_allow,
sock_deny]
db.c,db_usermap_resolve: login 'loe' not found in usermap
dbmysql.c,db_query: executing query [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower('loe')]
dbmysql.c,db_query: executing query [SELECT user_idnr, passwd, encryption_type
FROM dbmail_users WHERE user_idnr = '2']
authsql.c,auth_validate: validating using plaintext passwords
dbmysql.c,db_query: executing query [UPDATE dbmail_users SET last_login =
'2006-02-21 11:16:47' WHERE user_idnr = '2']
dbmysql.c,db_query: res was not freed after the previous query!
tims(): incoming buffer: [LOGOUT]
tims(): command looked up as commandtype 0
serverchild.c,PerformChildTask: client handling complete, closing streams
serverchild.c,client_close: closing write stream
serverchild.c,client_close: closing read stream
serverchild.c,PerformChildTask: connection closed
pool.c,child_reg_connected: [13034]
serverchild.c,PerformChildTask: incoming connection from [62.89.253.152]
serverchild.c,PerformChildTask: client info init complete, calling client
handler
serverchild.c,PerformChildTask: waiting for connection
pool.c,child_reg_disconnected: [13036]
tims(): incoming buffer: [AUTHENTICATE "PLAIN" {16+}]
tims(): command issued: cmd [AUTHENTICATE], val ["PLAIN" {16+}]
tims(): command looked up as commandtype 4
misc.c, find_bounded: Found nothing between '"' and '"'
misc.c, find_bounded: Found [16] of length [2] between '{' and '+' so next
skip [4]
db.c,db_usermap_resolve: checking userid 'loe' in usermap
db.c,db_usermap_resolve: client on inet socket [inet:62.89.253.152:20000]
dbmysql.c,db_query: executing query [SELECT login, sock_allow, sock_deny,
userid FROM dbmail_usermap WHERE login in ('loe','ANY') ORDER BY sock_allow,
sock_deny]
db.c,db_usermap_resolve: login 'loe' not found in usermap
dbmysql.c,db_query: executing query [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower('loe')]
dbmysql.c,db_query: executing query [SELECT user_idnr, passwd, encryption_type
FROM dbmail_users WHERE user_idnr = '2']
authsql.c,auth_validate: validating using plaintext passwords
dbmysql.c,db_query: executing query [UPDATE dbmail_users SET last_login =
'2006-02-21 11:16:47' WHERE user_idnr = '2']
dbmysql.c,db_query: res was not freed after the previous query!
tims(): incoming buffer: [LISTSCRIPTS]
tims(): command looked up as commandtype 3
dbmysql.c,db_query: executing query [SELECT name,active from
dbmail_sievescripts where owner_idnr = 2]
tims(): incoming buffer: [GETSCRIPT "main"]
tims(): command issued: cmd [GETSCRIPT], val ["main"]
tims(): command looked up as commandtype 6
misc.c, find_bounded: Found [main] of length [4] between '"' and '"' so next
skip [5]
dbmysql.c,db_query: executing query [SELECT script from dbmail_sievescripts
where owner_idnr = '2' and name = 'main']
tims(): incoming buffer: [PUTSCRIPT "main" {460+}]
tims(): command issued: cmd [PUTSCRIPT], val ["main" {460+}]
tims(): command looked up as commandtype 9
misc.c, find_bounded: Found [main] of length [4] between '"' and '"' so next
skip [5]
misc.c, find_bounded: Found [460] of length [3] between '{' and '+' so next
skip [6]
timsieve.c, tims: Client sending script of length [460]
db.c,db_check_sievescript_quota: updating 2 sievescript quota with 460
dbmysql.c,db_query: executing query [BEGIN]
dbmysql.c,db_query: executing query [SELECT COUNT(*) FROM dbmail_sievescripts
WHERE owner_idnr = 2 AND name = '@!temp-script!@']
dbmysql.c,db_get_result: result set is null
dbmysql.c,db_query: executing query [INSERT into dbmail_sievescripts
(owner_idnr, name, script, active) values (2, '@!temp-script!@', '#Mail
filter rules for loe\n#Generated by loe using SmartSieve 0.5.2 2006/02/21
11:16:47\nrequire \"fileinto\";\r\nrequire \"subaddress\";\r\n\r\nif
envelope :detail \"to\" \"spam\" {\r\nfileinto \"SPAM\";}\r\nelsif header :is
\"X-Spam-Flag\" \"YES\" { \r\nfileinto \"SPAM\";} \r\n\r\n else {\r\nfileinto
\"INBOX\";}\n\n\n##PSEUDO script start\n#mode&&advanced\n', 0)]
dbmysql.c,db_query: executing query [COMMIT]
sortsieve.c, sort_getscript: Getting default script named [EMAIL PROTECTED]@]
dbmysql.c,db_query: executing query [SELECT script from dbmail_sievescripts
where owner_idnr = '2' and name = '@!temp-script!@']
dbmysql.c,db_query: executing query [BEGIN]
dbmysql.c,db_query: executing query [SELECT COUNT(*) FROM dbmail_sievescripts
WHERE owner_idnr = 2 AND name = 'main']
dbmysql.c,db_get_result: result set is null
dbmysql.c,db_query: executing query [UPDATE dbmail_sievescripts SET name =
'main' WHERE owner_idnr = 2 AND name = '@!temp-script!@']
dbmysql.c,db_query: executing query [COMMIT]
timsieve.c, tims: Script successfully received
tims(): incoming buffer: [LISTSCRIPTS]
tims(): command looked up as commandtype 3
dbmysql.c,db_query: executing query [SELECT name,active from
dbmail_sievescripts where owner_idnr = 2]
tims(): incoming buffer: [LISTSCRIPTS]
tims(): command looked up as commandtype 3
dbmysql.c,db_query: executing query [SELECT name,active from
dbmail_sievescripts where owner_idnr = 2]
tims(): incoming buffer: [GETSCRIPT "main"]
tims(): command issued: cmd [GETSCRIPT], val ["main"]
tims(): command looked up as commandtype 6
misc.c, find_bounded: Found [main] of length [4] between '"' and '"' so next
skip [5]
dbmysql.c,db_query: executing query [SELECT script from dbmail_sievescripts
where owner_idnr = '2' and name = 'main']
tims(): incoming buffer: [LOGOUT]
tims(): command looked up as commandtype 0
serverchild.c,PerformChildTask: client handling complete, closing streams
serverchild.c,client_close: closing write stream
serverchild.c,client_close: closing read stream
serverchild.c,PerformChildTask: connection closed
serverchild.c,PerformChildTask: waiting for connection
pool.c,child_reg_disconnected: [13034]
--
Oleg Lapshin
