I have add a new LDAP addressbook to my sogo. Now, when i do any search on addressbook or
auto-complete e-mail recipient (in TB or in web) or others activities..
SOGo uses 100% if CPU, slapd is 30% and mysqld like 60%/70%
I don't understand why, and what operation causes this prolem. If i stop all my thunderbird clients,
and open only one of this.. CPU use is high and Thunderbird is unusable.
Addressbook contains only 2500 contacts, i have only 10 TB clients.
If i remove this addressbook from configuration the problem disappears.
No error log on sogo.log
Configuration is like this:
CNFieldName cn
IDFieldName cn
UIDFieldName cn
baseDN '"dc=rubrica"'
bindFields cn
canAuthenticate NO
displayName '"Rubrica Centralizzata"'
hostname localhost
id phonebook
isAddressBook YES
port 389
I see this type of query on my LDAP server:
@400000004cd271461a87967c conn=4761 op=1 SRCH base="dc=rubrica" scope=2 deref=0
filter="(|([email protected]*)([email protected]*)([email protected]*)([email protected]*)(?=undefined))"
The ldap addressbook is based on a mysql table with this mappings:
mysql> select * from ldap_attr_mappings;
+----+-----------+--------------------------+----------------+----------------+-----------+------------+----------+-------------+-------------+---------------+
| id | oc_map_id | name | sel_expr | sel_expr_u | from_tbls |
join_where | add_proc | delete_proc | param_order | expect_return |
+----+-----------+--------------------------+----------------+----------------+-----------+------------+----------+-------------+-------------+---------------+
| 1 | 1 | cn | name | name | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 2 | 1 | sn | name | name | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 3 | 1 | givenName | name | name | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 4 | 1 | telephoneNumber | workphone | workphone | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 5 | 1 | facsimiletelephonenumber | fax | fax | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 6 | 1 | mail | workemail | workemail | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 7 | 1 | o | company | company | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 8 | 1 | mobile | cellphone | cellphone | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 9 | 1 | streetaddress | workstreet | workstreet | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 10 | 1 | homePhone | homephone | homephone | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 11 | 1 | l | workcity | workcity | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 12 | 1 | countryName | workcountry | workcountry | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 13 | 1 | stateOrProvinceName | workprovince | workprovince | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 14 | 1 | personalTitle | title | title | phonebook | NULL
| NULL | NULL | 3 | 0 |
| 15 | 1 | postalCode | workpostalcode | workpostalcode | phonebook | NULL
| NULL | NULL | 3 | 0 |
+----+-----------+--------------------------+----------------+----------------+-----------+------------+----------+-------------+-------------+---------------+
Can i do any LDAP Attributes Indexing to ensure proper performance of the SOGo
application?
--
Alessio Fattorini ([email protected])
nethesis srl - Via degli Olmi 16/4 - 61100 Pesaro (PU)
tel. +39 0721 405516 - fax +39 0721 268147
www.nethesis.it - [email protected]
--
[email protected]
https://inverse.ca/sogo/lists
