List Info

Thread: slow squirrelmail queries
slow squirrelmail queries
country flaguser name
United Kingdom		 2007-06-27 11:56:34 
Hi Guys

Still having an issue with slow imap queries via overlook
(its a
squirrelmail base with changes in gui, we've also tested
squirrelmail with
same results),

We're getting *very* slow queries on some mailboxes below
ive provided a
level 5 trace log

This client has 14mb of mail which is about 280 emails or
so

Can anyone shed some light on this?

The database is running on a dedicated server with very
little load on it
and im testing this from a spare failover webserver with the
same results as
the live webserver so im confident its not an I/O error
machines are also on
a bonded gigabit connection to eachother.

I saw a bug filed for a similar issue, is this still
outstanding? Bug id
579, i wonder if its related?

Not sure if you can see anything obvious from those
tracelogs, if anyone has
any ideas on how to fix this please let me know!

Regards

Jon


Jun 27 20:22:52 webmail-1 dbmail/imap4d[4840]: Debug:[misc]
misc.c,g_tree_merge(+1267): (0x808aad8) (0x8087768): a[0]
[OR] b[266] ->
a[266]
Jun 27 20:22:52 webmail-1 dbmail/imap4d[4840]:
Debug:[mailbox]
dbmail-mailbox.c,_do_search(+1569): [0x809ff00] depth [1]
type [2] rows
[266]
Jun 27 20:22:52 webmail-1 dbmail/imap4d[4840]:
Debug:[mailbox]
dbmail-mailbox.c,dbmail_mailbox_get_set(+1387): [1] uid [1]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Info:[serverchild]
serverchild.c,select_and_accept(+252): received connection
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Info:[serverchild]
serverchild.c,select_and_accept(+275): connection accepted
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Message:[serverchild]
serverchild.c,PerformChildTask(+341): incoming connection
from [127.0.0.1]
by pid [4839]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[serverchild]
serverchild.c,PerformChildTask(+366): client info init
complete, calling
client handler
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1450):
RESPONSE: [* OK
dbmail imap (protocol version 4r1) server 2.2 ready to run^M
]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+175): COMMAND: [A0001 LOGIN
"addiscombe.addiscombe.org" "monty1"]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2398): arg[0]:
'addiscombe.addiscombe.org'
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2398): arg[1]:
'monty1'
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+288): Executing command login...
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_handle_auth(+1554):
trying to
validate user [addiscombe.addiscombe.org], pass [XXXX]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT userid FROM
dbmail_usermap WHERE 1 =
2]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[db]
db.c,db_use_usermap(+167): enabling usermap lookups
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[db]
db.c,db_usermap_resolve(+4536): checking userid
[addiscombe.addiscombe.org]
in usermap
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[db]
db.c,db_usermap_resolve(+4547): client on inet socket
[inet:127.0.0.1:143]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT login, sock_allow,
sock_deny, userid
FROM dbmail_usermap WHERE login in
('addiscombe.addiscombe.org','ANY') ORDER
BY sock_allow, sock_deny]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[db]
db.c,db_usermap_resolve(+4573): login
[addiscombe.addiscombe.org] not found
in usermap
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT user_idnr FROM
dbmail_users WHERE
lower(userid) = lower('addiscombe.addiscombe.org')]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT user_idnr, passwd,
encryption_type
FROM dbmail_users WHERE user_idnr = 2581]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[auth]
authsql.c,auth_validate(+401): validating using plaintext
passwords
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [UPDATE dbmail_users SET
last_login =
'2007-06-27 20:23:08' WHERE user_idnr = 2581]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Message:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_handle_auth(+1559):
user (id:2581,
name addiscombe.addiscombe.org) tries login
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Message:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_handle_auth(+1580):
user (id 2581,
name addiscombe.addiscombe.org) login accepted
Jun 27 20:23:08 webmail-1 in.imapproxyd[3403]: LOGIN:
'"addiscombe.addiscombe.org"' (127.0.0.1:57553) on
new sd [11]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1450):
RESPONSE: [A0001 OK
LOGIN completed^M ]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+307): Finished command login [0]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+175): COMMAND: [A002 CAPABILITY]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+288): Executing command
capability...
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1452):
RESPONSE: [*
CAPABILITY IMAP4 IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN
SORT QUOTA
THREAD=ORDEREDSUBJECT UNS...]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1450):
RESPONSE: [A002 OK
CAPABILITY completed^M ]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+307): Finished command capability
[0]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+175): COMMAND: [A003 NAMESPACE]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+288): Executing command
namespace...
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1450):
RESPONSE: [*
NAMESPACE (("" "/"))
(("#Users" "/")) (("#Public"
"/"))^M ]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1450):
RESPONSE: [A003 OK
NAMESPACE complete^M ]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+307): Finished command namespace
[0]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+175): COMMAND: [C64 UNSELECT]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+288): Executing command
unselect...
Jun 27 20:23:08 webmail-1 in.imapproxyd[3403]: LOGOUT:
'"addiscombe.addiscombe.org"' from server sd [11]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1450):
RESPONSE: [C64 BAD
UNSELECT command received in invalid state^M ]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+307): Finished command unselect
[1]
Jun 27 20:23:08 webmail-1 in.imapproxyd[3403]: LOGIN:
'"addiscombe.addiscombe.org"' (127.0.0.1:57555) on
existing sd [11]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+175): COMMAND: [A002 STATUS
"INBOX" (MESSAGES
UNSEEN RECENT)]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2398): arg[0]:
'INBOX'
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2398): arg[1]:
'('
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2398): arg[2]:
'MESSAGES'
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2398): arg[3]:
'UNSEEN'
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2398): arg[4]:
'RECENT'
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2398): arg[5]:
')'
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+288): Executing command
status...
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[db]
db.c,db_findmailbox(+2519): looking for mailbox with FQN
[INBOX].
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT mailbox_idnr FROM
dbmail_mailboxes
WHERE name LIKE 'INBOX' AND owner_idnr=2581]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[db]
db.c,db_acl_has_right(+4064): checking ACL [read_flag] for
user [2581] on
mailbox [4945]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT owner_idnr FROM
dbmail_mailboxes
WHERE mailbox_idnr = 4945]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[db]
db.c,db_acl_has_right(+4075): mailbox [4945] is owned by
user [2581], giving
all rights
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag
,recent_flag,dra
ft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = 4945]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT 'a',COUNT(*) FROM
dbmail_messages
WHERE mailbox_idnr=4945 AND (status < 2) UNION SELECT
'b',COUNT(*) FROM
dbmail_messages WHERE mailbox_idnr=4945 AND (status < 2)
AND seen_flag=1
UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr=4945 AND
(status < 2) AND recent_flag=1]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT message_idnr+1 FROM
dbmail_messages
WHERE mailbox_idnr=4945 ORDER BY message_idnr DESC LIMIT 1]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1450):
RESPONSE: [* STATUS
"INBOX" (MESSAGES 266 UNSEEN 170 RECENT 0)^M ]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1450):
RESPONSE: [A002 OK
STATUS completed^M ]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+307): Finished command status
[0]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+175): COMMAND: [A003 SELECT
"INBOX"]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2398): arg[0]:
'INBOX'
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Info:[imap]
imap4.c,IMAPClientHandler(+288): Executing command
select...
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[db]
db.c,db_findmailbox(+2519): looking for mailbox with FQN
[INBOX].
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT mailbox_idnr FROM
dbmail_mailboxes
WHERE name LIKE 'INBOX' AND owner_idnr=2581]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[db]
db.c,db_acl_has_right(+4064): checking ACL [read_flag] for
user [2581] on
mailbox [4945]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT owner_idnr FROM
dbmail_mailboxes
WHERE mailbox_idnr = 4945]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[db]
db.c,db_acl_has_right(+4075): mailbox [4945] is owned by
user [2581], giving
all rights
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT no_select FROM
dbmail_mailboxes
WHERE mailbox_idnr = 4945]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag
,recent_flag,dra
ft_flag FROM dbmail_mailboxes WHERE mailbox_idnr = 4945]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT 'a',COUNT(*) FROM
dbmail_messages
WHERE mailbox_idnr=4945 AND (status < 2) UNION SELECT
'b',COUNT(*) FROM
dbmail_messages WHERE mailbox_idnr=4945 AND (status < 2)
AND seen_flag=1
UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr=4945 AND
(status < 2) AND recent_flag=1]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT message_idnr+1 FROM
dbmail_messages
WHERE mailbox_idnr=4945 ORDER BY message_idnr DESC LIMIT 1]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT message_idnr FROM
dbmail_messages
WHERE mailbox_idnr = 4945 AND status IN (0,1) ORDER BY
message_idnr]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[mailbox]
dbmail-mailbox.c,mailbox_build_uid_map(+180): ids [266], msn
[266]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT seen_flag,
answered_flag,
deleted_flag, flagged_flag, draft_flag, recent_flag,
DATE_FORMAT(internal_date, '%Y-%m-%d %T'), rfcsize,
message_idnr FROM
dbmail_messages msg, dbmail_physmessage pm WHERE pm.id =
msg.physmessage_id
AND message_idnr BETWEEN 21724194 AND 66992769 AND
mailbox_idnr = 4945 AND
status IN (0,1) ORDER BY message_idnr ASC]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1450):
RESPONSE: [* 266
EXISTS^M ]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1450):
RESPONSE: [* 0
RECENT^M ]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1450):
RESPONSE: [* FLAGS
(Seen Answered Deleted Flagged Draft)^M ]
Jun 27 20:23:08 webmail-1 dbmail/imap4d[4839]:
Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1450):
RESPONSE: [* OK
[PERMANENTFLAGS (Seen Answered Deleted Flagged
Draft)]^M ]


Regards

Jon Duggan
Nuco Technologies Ltd
jonhost-it.co.uk
Tel. 0870 165 1300



_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: slow squirrelmail queries
country flaguser name
Netherlands		 2007-06-27 15:03:51 
Jon Duggan wrote:
> Hi Guys
> 
> Still having an issue with slow imap queries via
overlook (its a
> squirrelmail base with changes in gui, we've also
tested squirrelmail with
> same results),
> 
> We're getting *very* slow queries on some mailboxes
below ive provided a
> level 5 trace log

No slow queries in the logs. You may want to try taking
imapproxy out of
the equation, just to clear up the picture.

> 
> This client has 14mb of mail which is about 280 emails
or so
> 
> Can anyone shed some light on this?
> 
> The database is running on a dedicated server with very
little load on it
> and im testing this from a spare failover webserver
with the same results as
> the live webserver so im confident its not an I/O error
machines are also on
> a bonded gigabit connection to eachother.
> 
> I saw a bug filed for a similar issue, is this still
outstanding? Bug id
> 579, i wonder if its related?

That bug is not about slow results.

> 
> Not sure if you can see anything obvious from those
tracelogs, if anyone has
> any ideas on how to fix this please let me know!


Jon, where are the slow queries? There aren't any in the
logs. Also,
last time around I asked you to look at the slow queries log
in mysql,
but I havent seen any, iirc.




-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
RE: slow squirrelmail queries
country flaguser name
United Kingdom		 2007-06-27 16:09:43 
Thanks for the reply Paul

The imapdproxy seemed to help with an imap fetch problem
(iirc) we were
having when we first went to 2.2.5. Although that may be a
coincidence - i
haven't figured that one out yet

I have tested without it in equation also so i don't believe
this to be the
cause.

At the squirrelmail login prompt it wont load up the ui, it
hangs until it
eventually times out with imapd dropped connection (or
something to that
effect).  I've actually set the timeout to a much higher
value now to see if
i'd get anything after a longer amount of time, but still no
joy.

(just double checked before sending the email and this is
the error im
getting )
ERROR : Connection dropped by imap-server.
Query: SEARCH CHARSET ISO-8859-1 ALL Subject 

I'll try and get some further info regarding the mysql slow
query logs.

It's been a rather intermittent fault since the upgrade
which is why i left
it last time around, it was put on the back burner but it
needs sorting.

Can you think of anything else which may need tweaking,
perhaps
apache/php/squirrelmail related?  What's the recommended
$imap_server_type
setting?  I've currently set this to 'other'

Thanks for all your help as always

Jon

-----Original Message-----
From: dbmail-bouncesdbmail.org [mailto:dbmail-bouncesdbmail.org] On Behalf
Of Paul J Stevens
Sent: 27 June 2007 21:04
To: DBMail mailinglist
Subject: Re: [Dbmail] slow squirrelmail queries

Jon Duggan wrote:
> Hi Guys
> 
> Still having an issue with slow imap queries via
overlook (its a
> squirrelmail base with changes in gui, we've also
tested squirrelmail with
> same results),
> 
> We're getting *very* slow queries on some mailboxes
below ive provided a
> level 5 trace log

No slow queries in the logs. You may want to try taking
imapproxy out of
the equation, just to clear up the picture.

> 
> This client has 14mb of mail which is about 280 emails
or so
> 
> Can anyone shed some light on this?
> 
> The database is running on a dedicated server with very
little load on it
> and im testing this from a spare failover webserver
with the same results
as
> the live webserver so im confident its not an I/O error
machines are also
on
> a bonded gigabit connection to eachother.
> 
> I saw a bug filed for a similar issue, is this still
outstanding? Bug id
> 579, i wonder if its related?

That bug is not about slow results.

> 
> Not sure if you can see anything obvious from those
tracelogs, if anyone
has
> any ideas on how to fix this please let me know!


Jon, where are the slow queries? There aren't any in the
logs. Also,
last time around I asked you to look at the slow queries log
in mysql,
but I havent seen any, iirc.




-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail 

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: slow squirrelmail queries
user name
 2007-06-27 20:30:19 

  


  

    

On 6/28/07, Jon Duggan < jonhost-it.co.uk">jonhost-it.co.uk> wrote:

Thanks for the reply Paul

The imapdproxy seemed to help with an imap fetch problem (iirc) we were
having when we first went to 2.2.5. Although that may be a coincidence - i
haven9;t figured that one out yet


I have tested without it in equation also so i don't believe this to be the
cause.

At the squirrelmail login prompt it wont load up the ui, it hangs until it
eventually times out with imapd dropped connection (or something to that

effect).  I';ve actually set the timeout to a much higher value now to see if
i'd get anything after a longer amount of time, but still no joy.

(just double checked before sending the email and this is the error im

getting )
ERROR : Connection dropped by imap-server.
Query: SEARCH CHARSET ISO-8859-1 ALL Subject 

I9;ll try and get some further info regarding the mysql slow query logs.

It&#39;s been a rather intermittent fault since the upgrade which is why i left

it last time around, it was put on the back burner but it needs sorting.

Can you think of anything else which may need tweaking, perhaps
apache/php/squirrelmail related?&nbsp; What's the recommended $imap_server_type

setting?&nbsp; I&#39;ve currently set this to 'other'

Thanks for all your help as always

Jon

Have u set server-side sort to TRUE in SquirrelMail or overlook?



-- 
zamri
Linux System Administrator
Kolej ShahPutra Kuantan
Pahang Malaysia
Tel : 609.573.777.7 ext 119
web : http://muhdzamri.blogspot.com


  

  
  
   
     
    

  

    RE:  slow squirrelmail queries
  


  

     country flaguser name
United Kingdom		
     2007-06-28 03:06:40
  


  

    

From: dbmail-bouncesdbmail.org [mailto:dbmail-bouncesdbmail.org] On Behalf
Of zamri
Sent: 28 June 2007 02:30
To: DBMail mailinglist
Subject: Re: [Dbmail] slow squirrelmail queries


On 6/28/07, Jon Duggan <jonhost-it.co.uk> wrote:
Thanks for the reply Paul

The imapdproxy seemed to help with an imap fetch problem
(iirc) we were
having when we first went to 2.2.5. Although that may be a
coincidence - i
haven't figured that one out yet 

I have tested without it in equation also so i don't believe
this to be the
cause.

At the squirrelmail login prompt it wont load up the ui, it
hangs until it
eventually times out with imapd dropped connection (or
something to that 
effect).  I've actually set the timeout to a much higher
value now to see if
i'd get anything after a longer amount of time, but still no
joy.

(just double checked before sending the email and this is
the error im 
getting )
ERROR : Connection dropped by imap-server.
Query: SEARCH CHARSET ISO-8859-1 ALL Subject 

I'll try and get some further info regarding the mysql slow
query logs.

It's been a rather intermittent fault since the upgrade
which is why i left 
it last time around, it was put on the back burner but it
needs sorting.

Can you think of anything else which may need tweaking,
perhaps
apache/php/squirrelmail related?  What's the recommended
$imap_server_type 
setting?  I've currently set this to 'other'

Thanks for all your help as always

Jon
Have u set server-side sort to TRUE in SquirrelMail or
overlook?



Zamri,

Yes i have server-side sort set to true

Jon


-- 
zamri
Linux System Administrator
Kolej ShahPutra Kuantan
Pahang Malaysia
Tel : 609.573.777.7 ext 119
web : http://muhdzamri.blogsp
ot.com 

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail



  


  

    
  

  
  
   
     
    






 [1-5]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )