Hi,
I installed sogo on raspberrypi using raspian/jessie and the precompiled sogo
packages of debian. Installation was not a problem at all, cyrus and postfix
are running as expected. As authentication source I configured a mysql
database.
When ever I try to login via the webinterface I get the error
"An unhandled error occurred."
There are no errors in /var/log/sogo/sogo.log reported:
====================================================================
192.168.2.212 - - [12/Mar/2015:16:41:05 GMT] "POST /SOGo/connect HTTP/1.0" 403
34/68 0.042 - - 0
Mar 12 16:43:59 sogod [7405]: |SOGo| starting method 'POST' on uri '/SOGo/
connect'
Mar 12 16:43:59 sogod [7405]: |SOGo| traverse(acquire): SOGo => connect
Mar 12 16:43:59 sogod [7405]: |SOGo| do traverse name: 'SOGo'
Mar 12 16:43:59 sogod [7405]: |SOGo| do traverse name: 'connect'
Mar 12 16:43:59 sogod [7405]: |SOGo| set clientObject: <SOGo[0x0xb71e3628]:
name=SOGo>
2015-03-12 16:43:59.256 sogod[7164] <MySQL4Channel[0x0xb73ebd58]
connection=0x0xb7283c80> SQL: SELECT c_password FROM so
go_view WHERE c_uid = 'tobias';
2015-03-12 16:43:59.258 sogod[7164] <MySQL4Channel[0x0xb73ebd58]
connection=0x0xb7283c80> query has results, entering
fetch-mode.
Mar 12 16:43:59 sogod [7164]: <0x0xb72090c8[WOWatchDogChild]> child 7405
exited
Mar 12 16:43:59 sogod [7164]: <0x0xb72090c8[WOWatchDogChild]> (terminated due
to signal 11)
Mar 12 16:43:59 sogod [7164]: <0x0xb7176000[WOWatchDog]> child spawned with
pid 16313
2015-03-12 16:43:59.474 sogod[7164] Note: WEResourceManager debugging is
enabled.
2015-03-12 16:43:59.475 sogod[7164] Note: WEResourceManager component
debugging is enabled.
Mar 12 16:43:59 sogod [16313]: <0x0xb6d428ec[WEResourceManager]> CHECK: /usr/
local/share/sogo/www/
Mar 12 16:43:59 sogod [16313]: <0x0xb6d428ec[WEResourceManager]> CHECK: /usr/
share/sogo/www/
2015-03-12 16:43:59.489 sogod[7164] WebServerResources pathes: ("/var/run/
sogo/GNUstep/Library/SOGo/WebServerResources",
"/usr/local/lib/GNUstep/SOGo/WebServerResources", "/usr/lib/GNUstep/SOGo/
WebServerResources")
Mar 12 16:43:59 sogod [16313]: <0x0xb6d428ec[WEResourceManager]> CHECK: /usr/
local/share/sogo/templates/
Mar 12 16:43:59 sogod [16313]: <0x0xb6d428ec[WEResourceManager]> CHECK: /usr/
share/sogo/templates/
2015-03-12 16:43:59.492 sogod[7164] template pathes: ("/var/run/sogo/GNUstep/
Library/SOGo/Templates", "/usr/local/lib/GN
Ustep/SOGo/Templates", "/usr/lib/GNUstep/SOGo/Templates")
2015-03-12 16:44:00.044 sogod[7164] MySQL4 connection established 0x0xb7283c80
2015-03-12 16:44:00.045 sogod[7164] MySQL4 channel 0x0xb70c87a0 opened
(connection=0x0xb7283c80,sogo)
2015-03-12 16:44:00.046 sogod[7164] <MySQL4Channel[0x0xb70c87a0]
connection=0x0xb7283c80> SQL: SELECT count(*) FROM sogo
_user_profile;
2015-03-12 16:44:00.048 sogod[7164] <MySQL4Channel[0x0xb70c87a0]
connection=0x0xb7283c80> query has results, entering
fetch-mode.
2015-03-12 16:44:00.050 sogod[7164] <MySQL4Channel[0x0xb70c87a0]
connection=0x0xb7283c80> SQL: SELECT count(*) FROM sogo
_folder_info;
2015-03-12 16:44:00.052 sogod[7164] <MySQL4Channel[0x0xb70c87a0]
connection=0x0xb7283c80> query has results, entering
fetch-mode.
2015-03-12 16:44:00.105 sogod[7164] <MySQL4Channel[0x0xb70c87a0]
connection=0x0xb7283c80> SQL: SELECT count(*) FROM sogo
_sessions_info;
2015-03-12 16:44:00.107 sogod[7164] <MySQL4Channel[0x0xb70c87a0]
connection=0x0xb7283c80> query has results, entering
fetch-mode.
2015-03-12 16:44:00.109 sogod[7164] <MySQL4Channel[0x0xb70c87a0]
connection=0x0xb7283c80> SQL: SELECT count(*) FROM sogo
_alarms_folder;
2015-03-12 16:44:00.111 sogod[7164] <MySQL4Channel[0x0xb70c87a0]
connection=0x0xb7283c80> query has results, entering
fetch-mode.
====================================================================
however there is a line in /var/log/apache/error.log like this:
====================================================================
[Thu Mar 12 16:43:59.268536 2015] [proxy_http:error] [pid 16187]
(20014)Internal error: [client 192.168.2.212:59129] AH0
1102: error reading status line from remote server 127.0.0.1:20000, referer:
http://192.168.2.184/SOGo/
[Thu Mar 12 16:43:59.268904 2015] [proxy:error] [pid 16187] [client
192.168.2.212:59129] AH00898: Error reading from rem
ote server returned by /SOGo/connect, referer: http://192.168.2.184/SOGo/
====================================================================
My sogo config is like this:
{
SOGoUserSources = (
{
type = sql;
id = directory;
viewURL = "mysql://sogo:[email protected]:3306/sogo/sogo_view";
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = md5;
displayName = "MySQL";
}
);
SOGoMailDomain = "lindinger-penzberg.de";
SOGoAppointmentSendEMailNotifications = YES;
//SOGoSuperUsernames = (sogo3);
SOGoProfileURL = "mysql://sogo:[email protected]:3306/sogo/sogo_user_profile";
OCSFolderInfoURL =
"mysql://sogo:[email protected]:3306/sogo/sogo_folder_info";
OCSEMailAlarmsFolderURL =
"mysql://sogo:[email protected]:3306/sogo/sogo_alarms_folder";
OCSSessionsFolderURL =
"mysql://sogo:[email protected]:3306/sogo/sogo_sessions_info";
//SOGoSieveScriptsEnabled = YES;
SOGoForwardEnabled = YES;
SOGoVacationEnabled = YES;
SOGoEnableEMailAlarms = YES;
SOGoTimeZone = Europe/Berlin;
SOGoIMAPServer = 127.0.0.1:1143;
//SOGoSieveServer = sieve://127.0.0.1:4190;
SOGoMailingMechanism = smtp;
SOGoSMTPServer = 127.0.0.1;
SOGoCalendarDefaultRoles = ("PublicDAndTViewer");
/* Debugging */
//LDAPDebugEnabled = YES;
MySQL4DebugEnabled = YES;
OCSFolderManagerSQLDebugEnabled = YES;
PGDebugEnabled = YES;
SOGoDebugRequests = YES;
WODebugTakeValues = YES;
SOGoUIxDebugEnabled = YES;
SaxDebugReaderFactory = YES;
SaxObjectDecoderDebugEnabled = YES;
SoDebugObjectTraversal = YES;
SoSecurityManagerDebugEnabled = YES;
VSSaxDriverDebugEnabled = YES;
WODebugResourceLookup = YES;
WEResourceManagerDebugEnabled = YES;
WEResourceManagerComponentDebugEnabled = YES;
}
====================================================================
My apache config /etc/apache2/conf-enabled/sogo.conf
Alias /SOGo.woa/WebServerResources/ /usr/lib/GNUstep/SOGo/
WebServerResources/
Alias /SOGo/WebServerResources/ /usr/lib/GNUstep/SOGo/
WebServerResources/
<Directory /usr/lib/GNUstep/SOGo/>
<IfVersion < 2.4>
Order deny,allow
Allow from all
</IfVersion>
<IfVersion >= 2.4>
Require all granted
</IfVersion>
# Explicitly allow caching of static content to avoid browser specific
behavior.
# A resource's URL MUST change in order to have the client load the new
version.
<IfModule expires_module>
ExpiresActive On
ExpiresDefault "access plus 1 year"
</IfModule>
</Directory>
ProxyRequests Off
SetEnv proxy-nokeepalive 1
SetEnv force-proxy-request-1.0 1
#SetEnv proxy-initial-not-pooled 1
ProxyPreserveHost On
#AllowCONNECT 20000
ProxyPass /SOGo http://127.0.0.1:20000/SOGo retry=0
#ProxyPassReverse /SOGo http://127.0.0.1:20000/SOGo retry=0
ProxyPass /Microsoft-Server-ActiveSync
http://127.0.0.1:20000/SOGo/Microsoft-Server-ActiveSync retry=0
connectiontimeout
=5 timeout=3600
<Proxy http://127.0.0.1:20000/SOGo>
RequestHeader set "x-webobjects-server-port" "80"
RequestHeader set "x-webobjects-server-name" "raspberrypi"
RequestHeader set "x-webobjects-server-url" "http://raspberrypi";
RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"
RequestHeader set "x-webobjects-remote-host" %{REMOTE_HOST}e env=REMOTE_HOST
AddDefaultCharset UTF-8
Order allow,deny
Allow from all
</Proxy>
## We use mod_rewrite to pass remote address to the SOGo proxy.
# The remote address will appear in SOGo's log files and in the X-Forward
# header of emails.
RewriteEngine On
RewriteRule ^/SOGo/(.*)$ /SOGo/$1 [env=REMOTE_HOST:%{REMOTE_ADDR},PT]
I spent many hours to locate the error but the only hint I found is the error
in apache error log and I have absolutely no clou about. Do you have any
suggestion?
Kind regards,
Tobias
--
[email protected]
https://inverse.ca/sogo/lists
