Global Address Book Question

[derekwnek]

Hello,

We are using SM 1.4.19 with PHP 5.2.9 on RHEL 5 Update 3. We have locked
down our users so that they cannot access Options or have Personal Address
Books and also when they click in the To: or Cc: text boxes in the Compose
view, the Global Address Book listing appears which has 8000 entries.

Some of our users are across 64 Kb WAN connections and it takes approx. 80
seconds for the list to display. If I knock down the list to 500 names, it
displays in approx. 6 seconds.

Is there anything that can be done, within Squirrelmail, to improve the
amount of time to display a large Global Address Boook list?

Thank You,
Derek


------------------------------------------------------------------------------
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Paul Lesniewski]

On Mon, Jun 29, 2009 at 12:09 PM, <dwnek@...> wrote:

>
> Hello,
>
> We are using SM 1.4.19 with PHP 5.2.9 on RHEL 5 Update 3. We have locked
> down our users so that they cannot access Options or have Personal Address
> Books and also when they click in the To: or Cc: text boxes in the Compose
> view, the Global Address Book listing appears which has 8000 entries.
>
> Some of our users are across 64 Kb WAN connections and it takes approx. 80
> seconds for the list to display. If I knock down the list to 500 names, it
> displays in approx. 6 seconds.
>
> Is there anything that can be done, within Squirrelmail, to improve the
> amount of time to display a large Global Address Boook list?

Yes, pagination.  Currently there is a plugin that helps paginate the
main address book page, but it does not yet include support for the
page you are referring to.  As the author of that plugin, I don't
really have the free time to work on that any time soon, but patches
are welcome.

--
Paul Lesniewski
SquirrelMail Team
Please support Open Source Software by donating to SquirrelMail!
http://squirrelmail.org/donations.php

------------------------------------------------------------------------------
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[derekwnek]

>> Hello,
>>
>> We are using SM 1.4.19 with PHP 5.2.9 on RHEL 5 Update 3. We have locked
>> down our users so that they cannot access Options or have Personal
Address
>> Books and also when they click in the To: or Cc: text boxes in the
Compose
>> view, the Global Address Book listing appears which has 8000 entries.
>>
>> Some of our users are across 64 Kb WAN connections and it takes approx.
80
>> seconds for the list to display. If I knock down the list to 500 names,
it
>> displays in approx. 6 seconds.
>>
>> Is there anything that can be done, within Squirrelmail, to improve the
>> amount of time to display a large Global Address Boook list?

> Yes, pagination.  Currently there is a plugin that helps paginate the
> main address book page, but it does not yet include support for the
> page you are referring to.  As the author of that plugin, I don't
> really have the free time to work on that any time soon, but patches
> are welcome.

Thanks Paul, Is there somewhere I can get the pagination plugin while the
main plugin page is down. I didn't see it out on sourceforge but maybe I
wasn't looking in the right place.



------------------------------------------------------------------------------
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Paul Lesniewski]

On Mon, Jun 29, 2009 at 12:55 PM, <dwnek@...> wrote:

>>> Hello,
>>>
>>> We are using SM 1.4.19 with PHP 5.2.9 on RHEL 5 Update 3. We have locked
>>> down our users so that they cannot access Options or have Personal
> Address
>>> Books and also when they click in the To: or Cc: text boxes in the
> Compose
>>> view, the Global Address Book listing appears which has 8000 entries.
>>>
>>> Some of our users are across 64 Kb WAN connections and it takes approx.
> 80
>>> seconds for the list to display. If I knock down the list to 500 names,
> it
>>> displays in approx. 6 seconds.
>>>
>>> Is there anything that can be done, within Squirrelmail, to improve the
>>> amount of time to display a large Global Address Boook list?
>
>> Yes, pagination.  Currently there is a plugin that helps paginate the
>> main address book page, but it does not yet include support for the
>> page you are referring to.  As the author of that plugin, I don't
>> really have the free time to work on that any time soon, but patches
>> are welcome.
>
> Thanks Paul, Is there somewhere I can get the pagination plugin while the
> main plugin page is down. I didn't see it out on sourceforge but maybe I
> wasn't looking in the right place.

I'll send it to you offlist.

--
Paul Lesniewski
SquirrelMail Team
Please support Open Source Software by donating to SquirrelMail!
http://squirrelmail.org/donations.php

------------------------------------------------------------------------------
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Tomas Kuliavas]

2009.06.29 22:09 dwnek@... rašė:

>
> Hello,
>
> We are using SM 1.4.19 with PHP 5.2.9 on RHEL 5 Update 3. We have locked
> down our users so that they cannot access Options or have Personal Address
> Books and also when they click in the To: or Cc: text boxes in the Compose
> view, the Global Address Book listing appears which has 8000 entries.
>
> Some of our users are across 64 Kb WAN connections and it takes approx. 80
> seconds for the list to display. If I knock down the list to 500 names, it
> displays in approx. 6 seconds.
>
> Is there anything that can be done, within Squirrelmail, to improve the
> amount of time to display a large Global Address Boook list?

Disable listing of global address book.

People still can find address book entries, if they search for something.

--
Tomas



------------------------------------------------------------------------------
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Jordan R. Urie]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Derek,

 

In addition to working with Paul’s pagination plugin, you may want to look into your web server’s compression options. Many web servers can be configured to transparently gzip pages as they leave the server; this may reduce the amount of data that needs to be transmitted over your narrow WAN links.

 

Good luck!

 

Jordan

 

 

[Jordan R Urie.vcf]

---

BEGIN:VCARD
VERSION:2.1
X-MS-SIGNATURE:YES
N;LANGUAGE=en-us:Urie;Jordan;R.
FN:Jordan R. Urie
ORG:PIER Technology Consulting, Inc.
TITLE:Technology Manager
TEL;WORK;VOICE:[phone]
TEL;WORK;VOICE:[phone]
TEL;CELL;VOICE:[phone]
TEL;WORK;FAX:[phone]
ADR;WORK;PREF;ENCODING=QUOTED-PRINTABLE:;;Suite 712, Empire Building=0D=0A=
10080 Jasper Avenue;Edmonton;AB;T5J 1V9;Canada
LABEL;WORK;PREF;ENCODING=QUOTED-PRINTABLE:Suite 712, Empire Building=0D=0A=
10080 Jasper Avenue=0D=0A=
Edmonton, AB  T5J 1V9
X-MS-OL-DEFAULT-POSTAL-ADDRESS:2
URL;WORK:www.piertechnology.com
EMAIL;PREF;INTERNET:jordan.urie@...
X-MS-CARDPICTURE;TYPE=JPEG;ENCODING=BASE64:
 /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAYEBQYFBAYGBQYHBwYIChAKCgkJChQODwwQFxQY
 GBcUFhYaHSUfGhsjHBYWICwgIyYnKSopGR8tMC0oMCUoKSj/2wBDAQcHBwoIChMKChMoGhYa
 KCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCj/wAAR
 CAApADYDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAA
 AgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkK
 FhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWG
 h4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl
 5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREA
 AgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYk
 NOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOE
 hYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk
 5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2T4k+LB4W8SeHmaC4uxLDdCO2gGXml/dh
 B+rc1Rin+Kmsfv4YdE0SFuVhuMySAf7WM1R1bSdU1nW9R8Z6WXmvtJvfI0+0z8skMQKTKPdi
 X/IV6P4Z8Q2HiTTFvNNlz2khfiSF+6uvUEUAcbb+IfG+jb5Nf0e01ewjbbLcaUxEkeOp8tvv
 Y9q7rRdXstc02K/0ydZ7WQcMOoPcEdiO4Nc7o+tX0vgNbvRrJL7V4SY5rR5AhEwfEgY9jnJp
 VszoXi20vLZBDZ61mK7t1+6t0FLrIPchWU+uFoA7OiiigAooooA53wdGLbTruzPElte3Acf7
 8jSKfxWRTXLa7d+FG1me4Fzd6drCMUe6sVaN2I7Nxtcf7wNegx20Uc9xPGuJZ9pkPrgYH6V5
 to76wura5/ZFha3UZu23tMwBU88DmuPFVp03FQ6+V/wR24OhCqpOfS3VLr3ZmXlmk63Gt6X4
 nMEqsouJ4bdoJnzwPMVTsf6lK240utEnsrjxV4nN3FG4ligMQZmOCAflVSOp7GqHiHR9Qh0f
 VtV1RIYJrgxIIYfugBhyffim2x1ObxfqL2tlbXdzEqqq3D42x4GCoJ+lcjxtWL5JR1duj89b
 b7LY71l1Ca54y0V76ry0vtu9z0HR/EGm6vE72NwJDGMupBVgPoayv+FgaD2uJR/2xb/CsEab
 rkviGC/k0+0tDGpWYwSj5kIP3hmsfRNZ1XR/DMM0WnW0tjuYCZxkjJ74PFKWOqqyatvrZ9Ld
 Om44ZdRd3F32suZaXvpe1nseraVqlpqtotzYzCSI9wMEH0IPSisLwBpslnpc080kTveSmfEX
 3Fz2FFehSnOcFJo8jEQhTqOEXojqzyPrWLoOkJptzqMiOzfaZjKQex9q2uwpkX8f1rSUE5RZ
 nGbipRXUy/FOlprGky2jsyKzKSV68HNZuv8Ahi21OeGWN5oLyJAonhfa2B2PrXTTf6o0iffe
 sqlGFST5l2NqWInTiuR2t+tjnvDvhyHSzcSM8811MpV5pn3Ej0qzoOjQ6boAsH/ew/MCJADu
 BPStv1+lQt/qF+tCowp2sujFLE1Kl7vdr8DG8MaG2jidILiT7K7Zjhk58v6GiuhorSFGMY2R
 nUrSnJye5//Z

X-MS-OL-DESIGN;CHARSET=utf-8:<card xmlns="http://schemas.microsoft.com/office/outlook/12/electronicbusinesscards" ver="1.0" layout="left" bgcolor="ffffff"><img xmlns="" align="mid" area="25" use="cardpicture"/><fld xmlns="" prop="name" align="left" dir="ltr" style="b" color="000000" size="10"/><fld xmlns="" prop="title" align="left" dir="ltr" color="000000" size="8"/><fld xmlns="" prop="org" align="left" dir="ltr" color="000000" size="8"/><fld xmlns="" prop="addrwork" align="left" dir="ltr" color="000000" size="8"/><fld xmlns="" prop="telwork" align="left" dir="ltr" color="000000" size="8"><label align="right" color="626262">Office</label></fld><fld xmlns="" prop="faxwork" align="left" dir="ltr" color="000000" size="8"><label align="right" color="626262">Fax</label></fld><fld xmlns="" prop="telcell" align="left" dir="ltr" color="000000" size="8"><label align="right" color="626262">Mobile</label></fld><fld xmlns="" prop="webwork" align="left" dir="ltr" color="000000" size="8"/><fld xmlns="" prop="telwork2" align="left" dir="ltr" color="000000" size="8"><label align="right" color="626262">Emergency</label></fld><fld xmlns="" prop="email" align="left" dir="ltr" color="000000" size="8"/><fld xmlns="" prop="blank" size="8"/><fld xmlns="" prop="blank" size="8"/><fld xmlns="" prop="blank" size="8"/><fld xmlns="" prop="blank" size="8"/><fld xmlns="" prop="blank" size="8"/><fld xmlns="" prop="blank" size="8"/></card>
REV:20080828T231432Z
END:VCARD

---

------------------------------------------------------------------------------

-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Paul Lesniewski]

> In addition to working with Paul’s pagination plugin, you may want to look
> into your web server’s compression options. Many web servers can be
> configured to transparently gzip pages as they leave the server; this may
> reduce the amount of data that needs to be transmitted over your narrow WAN
> links.

There's a gzip plugin for SquirrelMail, too, in case you can't
configure PHP to do it for you.

--
Paul Lesniewski
SquirrelMail Team
Please support Open Source Software by donating to SquirrelMail!
http://squirrelmail.org/donate_paul_lesniewski.php

------------------------------------------------------------------------------
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[derekwnek]

>> In addition to working with Paul’s pagination plugin, you may want to
look
>> into your web server’s compression options. Many web servers can be
>> configured to transparently gzip pages as they leave the server; this
may
>> reduce the amount of data that needs to be transmitted over your narrow
WAN
>> links.

> There's a gzip plugin for SquirrelMail, too, in case you can't
> configure PHP to do it for you.

Very cool! Could you send me that plugin offlist as well Paul? BTW, Thanks
for the group pagination plugin. I will look at it this weekend.

r/Derek
------------------------------------------------------------------------------
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[derekwnek]

>> In addition to working with Paul’s pagination plugin, you may want to
look
>> into your web server’s compression options. Many web servers can be
>> configured to transparently gzip pages as they leave the server; this
may
>> reduce the amount of data that needs to be transmitted over your narrow
WAN
>> links.

> There's a gzip plugin for SquirrelMail, too, in case you can't
> configure PHP to do it for you.

In response to Tom, setting "Allow listing of global file address book" to
false is not an option I am permitted to use by our management unless there
is a way to only list a subset of the Global Address Book (commonly emailed
addresses) while still being able to search the rest of it (which would
contain lesser used email addresses).

So far I have had no luck improving the time it takes the Global Address
Book to load across slow links using any of the following compression
methods:

1. In Apache 2.2.11's httpd.conf file: (apachectl -t -D DUMP_MODULES   #
deflate_module (static) is present)

            LoadModule deflate_module /usr/lib/httpd/modules/mod_deflate.so

            <Directory /usr/local/apache2/htdocs/webmail>
                  Options -Indexes
                  AllowOverride none
                  DirectoryIndex index.php
                  Order allow,deny
                  allow from all
                  SetOutputFilter DEFLATE
                  SetEnvIfNoCase Request_URI \.(?:gif|jpe?g|png)$ \ no-gzip
dont-vary
                  SetEnvIfNoCase Request_URI
\.(?:exe|t?gz|zip|bz2|sit|rar)$ \no-gzip dont-vary
                  SetEnvIfNoCase Request_URI \.pdf$ no-gzip dont-var
            </Directory>

2. In PHP's php.ini file:

            zlib.output_compression = On

3. In a .htaccess file within the global address book directory:

            php_flag zlib.output_compression on

It looks like the only other options for me to try is either the SM gzip
plugin or going to a couple of PHP scripting classes and trying to make it
paginated using the abook_group_pagination plugin as a reference.

If anyone has any other suggestions or knows how to hack out the latter, I
would greatly appreciate it since the is the very last thing holding me
back from being able to put it in production.

Thanks much,
Derek
------------------------------------------------------------------------------
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Tomas Kuliavas]

2009.06.30 21:30 dwnek@... rašė:

>>> In addition to working with Paul’s pagination plugin, you may want to
> look
>>> into your web server’s compression options. Many web servers can be
>>> configured to transparently gzip pages as they leave the server; this
> may
>>> reduce the amount of data that needs to be transmitted over your
>>> narrow
> WAN
>>> links.
>
>> There's a gzip plugin for SquirrelMail, too, in case you can't
>> configure PHP to do it for you.
>
> In response to Tom, setting "Allow listing of global file address book"
> to
> false is not an option I am permitted to use by our management unless
> there
> is a way to only list a subset of the Global Address Book (commonly
> emailed
> addresses) while still being able to search the rest of it (which would
> contain lesser used email addresses)

Use two global address books. If you don't want to write own address book
plugin, common addresses should be stored in global address book and all
the others in LDAP. Or smaller global address book stored in file and
bigger one in database.

--
Tomas



------------------------------------------------------------------------------
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users