Hi, I've just installed SOGo in one of our servers, and I have a really big
problem of slow motion when I try to access to the web page. It takes about 10
minutes to log on. I tried to find some
help in the web, but it was unsuccessful. I attach you some information, and I
hope someone could help me (note: I know SOGo is accessible and the LDAP
authentication is working because I can log on, and the tables on mysql5 have
been created by Sogo, but in the other hand I don't know if SMTP and IMAP it's
working correctly).
############# MACHINE INFORMATION ###########################
[r...@draconis ~]# cat /etc/issue
Red Hat Enterprise Linux Server release 5.3 (Tikanga)
Kernel \r on an \m
[r...@draconis ~]# uname -a
Linux draconis 2.6.18-128.2.1.el5 #1 SMP Wed Jul 8 11:54:54 EDT 2009 i686 i686
i386 GNU/Linux
[r...@draconis ~]# mysql --version
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i386) using readline 5.1
Using OpenLDAP for authenticate
[r...@draconis ~]# free -m
total used free shared buffers cached
Mem: 3034 416 2618 0 13 186
-/+ buffers/cache: 216 2818
Swap: 509 0 509
############## SOGO CONFIGURATION ########################
[r...@draconis ~]# cat /home/sogo/GNUstep/Defaults/.GNUstepDefaults
{
NSGlobalDomain = {
};
sogod = {
OCSFolderInfoURL =
"mysql://sogo:s...@localhost:3306/sogo/sogo_folder_info";
SOGoACLsSendEmailNotifications = YES;
SOGoAppointmentSendEmailNotifications = YES;
SOGoDebugRequests = YES;
SOGoDraftsFolderName = Drafts;
SOGoEnablePublicAccess = YES;
SOGoFoldersSendEmailNotifications = YES;
SOGoIMAPServer = localhost;
SOGoLanguage = Spanish;
SOGoMailDomain = upcnet.es;
SOGoMailingMechanism = smtp;
SOGoProfileURL =
"mysql://sogo:s...@localhost:3306/sogo/sogo_user_profile";
SOGoSMTPServer = localhost;
SOGoSentFolderName = Sent;
SOGoTimeZone = Europe/Madrid;
SOGoTrashFolderName = Trash;
SOGoUserSources = (
{
CNFieldName = cn;
IMAPHostFieldName = mail;
baseDN = "ou=users,dc=upc,dc=edu";
bindDN = "cn=ldap.upc,ou=users,dc=upc,dc=edu";
bindPassword = conldappasswd;
canAuthenticate = YES;
displayName = "Active Directory";
hostname = alderamin1.upc.es;
id = public;
isAddressBook = YES;
port = 389;
}
);
SxVmemLimit = 1024;
};
}
########################## SOGO LOG #######################################
Log File: Startup – Login Page – Main Page – More than 10 min.
[r...@draconis ~]#cat /var/log/sogo/sogo.log
Sep 22 11:48:35 sogod: SOGo watchdog [3449]: [WARN] <0x0x9ca1ba8[WOWatchDog]>
'WOHttpAllowHost' is ignored in watchdog mode, use a real firewall instead
Sep 22 11:48:35 sogod: SOGo watchdog [3449]: <0x0x9ca1ba8[WOWatchDog]>
listening on *:20000
Sep 22 11:48:35 sogod: SOGo watchdog [3449]: <0x0x9ca1ba8[WOWatchDog]> watchdog
process pid: 3449
Sep 22 11:48:35 sogod: SOGo watchdog [3449]: <0x0x9ca1ba8[WOWatchDog]>
preparing 1 children
Sep 22 11:48:35 sogod: SOGo watchdog [3450]: SNS support disabled.
Sep 22 11:48:35 sogod: SOGo watchdog [3449]: <0x0x9ca1ba8[WOWatchDog]> child
spawned with pid 3450
Sep 22 11:48:36 sogod: SOGo watchdog [3450]: <0x0x9e08200[SOGoProductLoader]>
SOGo products loaded from '/usr/GNUstep/System/Library/SOGo':
Sep 22 11:48:36 sogod: SOGo watchdog [3450]: <0x0x9e08200[SOGoProductLoader]>
ContactsUI.SOGo, MainUI.SOGo, Contacts.SOGo, Appointments.SOGo, CommonUI.SOGo,
PreferencesUI.SOGo, Mailer.SOGo, MailerUI.SOGo, MailPartViewers.SOGo,
AdministrationUI.SOGo, SchedulerUI.SOGo
Sep 22 11:48:36 sogod: SOGo watchdog [3450]: |SOGo| version 1.3.0 (build
r...@vizzini.inverse.ca 201008191440) -- starting
Sep 22 11:48:36 sogod: SOGo watchdog [3450]: |SOGo| vmem size check enabled:
shutting down app when vmem > 384 MB
2010-09-22 11:48:36.733 sogod[3450] ERROR: could not open MySQL4 connection to
database 'sogo': Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
Sep 22 11:48:36 sogod: SOGo watchdog [3450]: [ERROR]
<0x0x9f25378[GCSChannelManager]> could not open channel
<MySQL4Channel[0x0x9f197e0] connection=0x(null)> for URL:
mysql://sogo:s...@localhost:3306/sogo/sogo_user_profile
Sep 22 11:48:36 sogod: SOGo watchdog [3450]: [WARN]
<0x0x9f25378[GCSChannelManager]> will prevent opening of this channel 5
seconds after 2010-09-22 11:48:36 +0200
Sep 22 11:49:23 sogod: SOGo watchdog [3450]: |SOGo| starting method 'GET' on
uri '/SOGo/'
Sep 22 11:49:23 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> Cache
cleanup interval set every 300.000000 seconds
Sep 22 11:49:23 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> Using
host(s) 'localhost' as server(s)
Sep 22 11:49:23 sogod: SOGo watchdog [3450]: [ERROR] |SOGo| did not find locale
for language: Catalan
2010-09-22 11:49:23.993 sogod[3450] Note(SoObject): SoDebugKeyLookup is
enabled!
2010-09-22 11:49:23.993 sogod[3450] Note(SoObject): SoDebugBaseURL is enabled!
2010-09-22 11:49:23.993 sogod[3450] Note(SoObject): relative base URLs are
enabled.
Sep 22 11:49:24 sogod: SOGo watchdog [3450]: <0x0x9f25378[GCSChannelManager]>
db for mysql://sogo:s...@localhost:3306/sogo/sogo_user_profile is now back up
2010-09-22 11:49:24.687 sogod[3450] WOCompoundElement: pool embedding is on.
2010-09-22 11:49:24.687 sogod[3450] WOCompoundElement: id logging is on.
2010-09-22 11:49:24.840 sogod[3450] WARNING(-[NSNull(misc) count]): called
NSNull -count (returns 0) !!!
Sep 22 11:49:24 sogod: SOGo watchdog [3450]: |SOGo| request took 0.953332
seconds to execute
127.0.0.1 - - [22/Sep/2010:11:49:24 GMT] "GET /SOGo/ HTTP/1.1" 200 3403/0 0.984
10461 67% 2M
Sep 22 11:49:54 sogod: SOGo watchdog [3450]: |SOGo| starting method 'POST' on
uri '/SOGo/connect'
Sep 22 11:49:54 sogod: SOGo watchdog [3450]: [ERROR] |SOGo| did not find locale
for language: Catalan
2010-09-22 11:49:54.308 sogod[3450] Scanner initialised with nil string
Sep 22 11:49:54 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bover+attributes': "SYSTEM ERROR"
Sep 22 11:49:54 sogod: SOGo watchdog [3450]: SOGoRootPage successful login for
user 'alan.bover' - expire = -1 grace = -1
Sep 22 11:52:44 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bover+attributes': "SYSTEM ERROR"
Sep 22 11:52:44 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bo...@upcnet.es+attributes': "SYSTEM
ERROR"
Sep 22 11:52:44 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bo...@upcnet.es+attributes': "SYSTEM
ERROR"
Sep 22 11:52:44 sogod: SOGo watchdog [3450]: [WARN]
<0x0x9e9bcd0[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV
permissions table
Sep 22 11:52:44 sogod: SOGo watchdog [3450]: [WARN]
<0x0x9e9bcd0[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already
exists in DAV permissions table
Sep 22 11:52:44 sogod: SOGo watchdog [3450]: [WARN]
<0x0x9e9bcd0[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists
in DAV permissions table
Sep 22 11:52:44 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bover+settings': "SYSTEM ERROR"
Sep 22 11:52:44 sogod: SOGo watchdog [3450]: |SOGo| request took 169.773362
seconds to execute
2010-09-22 11:52:44.080 sogod[3450] Note: Using UTF-8 as URL encoding in
NGExtensions.
127.0.0.1 - - [22/Sep/2010:11:52:44 GMT] "POST /SOGo/connect HTTP/1.1" 200
27/47 169.833 - - 404K
Sep 22 11:52:44 sogod: SOGo watchdog [3450]: |SOGo| starting method 'GET' on
uri '/SOGo/alan.bover'
2010-09-22 11:52:44.088 sogod[3450] Scanner initialised with nil string
Sep 22 11:52:44 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bover+attributes': "SYSTEM ERROR"
Sep 22 11:52:44 sogod: SOGo watchdog [3450]: [ERROR] |SOGo| did not find locale
for language: Catalan
Sep 22 11:55:46 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bover+attributes': "SYSTEM ERROR"
Sep 22 11:55:46 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bo...@upcnet.es+attributes': "SYSTEM
ERROR"
Sep 22 11:55:46 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bo...@upcnet.es+attributes': "SYSTEM
ERROR"
Sep 22 11:55:46 sogod: SOGo watchdog [3450]: |SOGo| request took 182.270687
seconds to execute
127.0.0.1 - - [22/Sep/2010:11:55:46 GMT] "GET /SOGo/alan.bover HTTP/1.1" 302
0/0 182.272 - - 12K
Sep 22 11:55:46 sogod: SOGo watchdog [3450]: |SOGo| starting method 'GET' on
uri '/SOGo/alan.bover/view'
2010-09-22 11:55:46.363 sogod[3450] Scanner initialised with nil string
Sep 22 11:55:46 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bover+attributes': "SYSTEM ERROR"
Sep 22 11:55:46 sogod: SOGo watchdog [3450]: [ERROR] |SOGo| did not find locale
for language: Catalan
Sep 22 11:58:48 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bover+attributes': "SYSTEM ERROR"
Sep 22 11:58:48 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bo...@upcnet.es+attributes': "SYSTEM
ERROR"
Sep 22 11:58:48 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bo...@upcnet.es+attributes': "SYSTEM
ERROR"
Sep 22 11:58:48 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bover+defaults': "SYSTEM ERROR"
Sep 22 11:58:48 sogod: SOGo watchdog [3450]: |SOGo| request took 182.624351
seconds to execute
127.0.0.1 - - [22/Sep/2010:11:58:48 GMT] "GET /SOGo/alan.bover/view HTTP/1.1"
302 0/0 182.626 - - 8K
Sep 22 11:58:48 sogod: SOGo watchdog [3450]: |SOGo| starting method 'GET' on
uri '/SOGo/so/alan.bover/Mail'
2010-09-22 11:58:48.991 sogod[3450] Scanner initialised with nil string
Sep 22 11:58:49 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bover+attributes': "SYSTEM ERROR"
Sep 22 11:58:49 sogod: SOGo watchdog [3450]: [ERROR] |SOGo| did not find locale
for language: Catalan
Sep 22 12:01:39 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bover+attributes': "SYSTEM ERROR"
Sep 22 12:01:39 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bo...@upcnet.es+attributes': "SYSTEM
ERROR"
Sep 22 12:01:39 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bo...@upcnet.es+attributes': "SYSTEM
ERROR"
Sep 22 12:01:39 sogod: SOGo watchdog [3450]: |SOGo| request took 170.106689
seconds to execute
127.0.0.1 - - [22/Sep/2010:12:01:39 GMT] "GET /SOGo/so/alan.bover/Mail
HTTP/1.1" 302 0/0 170.108 - - 0
Sep 22 12:01:39 sogod: SOGo watchdog [3450]: |SOGo| starting method 'GET' on
uri '/SOGo/so/alan.bover/Mail/view'
2010-09-22 12:01:39.103 sogod[3450] Scanner initialised with nil string
Sep 22 12:01:39 sogod: SOGo watchdog [3450]: <0x0x9e865d8[SOGoCache]> an error
occurred when caching value for key 'alan.bover+attributes': "SYSTEM ERROR"
Sep 22 12:01:39 sogod: SOGo watchdog [3450]: [ERROR] |SOGo| did not find locale
for language: Catalan
######################## APACHE CONFIGURATION #######################
[r...@draconis ~]# cat /etc/httpd/conf.d/SOGo.conf
Alias /SOGo.woa/WebServerResources/ \
/usr/GNUstep/System/Library/SOGo/WebServerResources/
Alias /SOGo/WebServerResources/ \
/usr/GNUstep/System/Library/SOGo/WebServerResources/
AliasMatch /SOGo/so/ControlPanel/Products/(.*)/Resources/(.*) \
/usr/GNUstep/System/Library/SOGo/$1.SOGo/Resources/$2
<LocationMatch "^/SOGo/so/ControlPanel/Products/.*UI/Resources/.*jpg">
SetHandler default-handler
</LocationMatch>
<LocationMatch "^/SOGo/so/ControlPanel/Products/.*UI/Resources/.*png">
SetHandler default-handler
</LocationMatch>
<LocationMatch "^/SOGo/so/ControlPanel/Products/.*UI/Resources/.*gif">
SetHandler default-handler
</LocationMatch>
<LocationMatch "^/SOGo/so/ControlPanel/Products/.*UI/Resources/.*css">
SetHandler default-handler
</LocationMatch>
<LocationMatch "^/SOGo/so/ControlPanel/Products/.*UI/Resources/.*js">
SetHandler default-handler
</LocationMatch>
## Uncomment the following to enable proxy-side authentication, you will then
## need to set the "SOGoTrustProxyAuthentication" SOGo user default to YES and
## adjust the "x-webobjects-remote-user" proxy header in the "Proxy" section
## below.
#<Location /SOGo>
# AuthType XXX
# Require valid-user
# SetEnv proxy-nokeepalive 1
# Allow from all
#</Location>
ProxyRequests Off
SetEnv proxy-nokeepalive 1
ProxyPreserveHost On
ProxyPassInterpolateEnv On
ProxyPass /SOGo http://127.0.0.1:20000/SOGo interpolate
<Proxy http://127.0.0.1:20000/SOGo>
## adjust the following to your configuration
RequestHeader set "x-webobjects-server-port" "80"
RequestHeader set "x-webobjects-server-name" "draconis.upc.es"
RequestHeader set "x-webobjects-server-url" "http://draconis.upc.es";
## When using proxy-side autentication, you need to uncomment and
## adjust the following line:
# RequestHeader set "x-webobjects-remote-user" "%{REMOTE_USER}e"
RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"
RequestHeader set "x-webobjects-remote-host" "127.0.0.1"
AddDefaultCharset UTF-8
Order allow,deny
Allow from all
</Proxy>
--
users@sogo.nu
https://inverse.ca/sogo/lists
