I installed the sogo in arch linux, the web server is apache,i read some articles from the web and then configured the /etc/sogo/sogo.conf and /etc/httpd/conf/extra/SOGo.conf according to my knowledge, after configuration i restart the sogod and httpd both are runing, and sogod is listening on 127.0.0.1:20000, now want to open the
http://localhost/SOGo get the error in firefox:
Code:
Server error!
The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script.
If you think this is a server error, please contact the webmaster.
Error 500
This is the /var/log/httpd/localhost-error_log error:
Code:
# cat localhost-error_log
[Thu Dec 29 12:15:04.196712 2022] [authn_core:error] [pid 5226] [client ::1:34860] AH01796: AuthType sql configured without corresponding module
i run the journalctl | grep sogo, this is the ouput for sogo:
Code:
Dec 29 15:06:37 myhost sogod[3693]: 2022-12-29 15:06:37.177 sogod[3693:3693] MySQL4 connection established 0x0x555635f94c40
Dec 29 15:06:37 myhost sogod[3693]: 2022-12-29 15:06:37.177 sogod[3693:3693] ---------- -[MySQL4Channel openChannel]: <MySQL4Channel[0x0x555635dbf430] connection=0x0x555635f94c40> opens channel count[0]
Dec 29 15:06:37 myhost sogod[3693]: 2022-12-29 15:06:37.177 sogod[3693:3693] MySQL4 channel 0x0x555635dbf430 opened (connection=0x0x555635f94c40,sogo)
Dec 29 15:06:37 myhost sogod[3693]: 2022-12-29 15:06:37.177 sogod[3693:3693] <MySQL4Channel[0x0x555635dbf430] connection=0x0x555635f94c40> SQL: SELECT 1 FROM sogo_user_profile WHERE 1 = 2;
Dec 29 15:06:37 myhost sogod[3693]: 2022-12-29 15:06:37.177 sogod[3693:3693] <MySQL4Channel[0x0x555635dbf430] connection=0x0x555635f94c40> query has results, entering fetch-mode.
Dec 29 15:06:37 myhost sogod[3693]: 2022-12-29 15:06:37.177 sogod[3693:3693] <MySQL4Channel[0x0x555635dbf430] connection=0x0x555635f94c40> SQL: SELECT 1 FROM sogo_folder_info WHERE 1 = 2;
Dec 29 15:06:37 myhost sogod[3693]: 2022-12-29 15:06:37.177 sogod[3693:3693] <MySQL4Channel[0x0x555635dbf430] connection=0x0x555635f94c40> query has results, entering fetch-mode.
Dec 29 15:06:37 myhost sogod[3693]: 2022-12-29 15:06:37.178 sogod[3693:3693] <MySQL4Channel[0x0x555635dbf430] connection=0x0x555635f94c40> SQL: SELECT 1 FROM sogo_sessions_folder WHERE 1 = 2;
Dec 29 15:06:37 myhost sogod[3693]: 2022-12-29 15:06:37.179 sogod[3693:3693] <MySQL4Channel[0x0x555635dbf430] connection=0x0x555635f94c40> query has results, entering fetch-mode.
Dec 29 15:06:37 myhost sogod[3693]: Dec 29 15:06:37 sogod [3693]: <0x0x555635fd3d40[WOHttpAdaptor]> notified the watchdog that we are ready
This is the entry of my created sogo_users table in sogo database in mariadb:
Code:
MariaDB [sogo]> select * from sogo_users;
+-------+--------+------------+---------------+-----------------+
| c_uid | c_name | c_password | c_cn | mail |
+-------+--------+------------+---------------+-----------------+
| john | john | mypass | john loan | john@localhost |
+-------+--------+------------+---------------+-----------------+
The user sogo created all other tables in the sogo database:
Code:
MariaDB [sogo]> show tables;
+----------------------+
| Tables_in_sogo |
+----------------------+
| sogo_folder_info |
| sogo_sessions_folder |
| sogo_user_profile |
| sogo_users |
+----------------------+
4 rows in set (0.001 sec)
The sogo_user_profile table is empty.
This is /etc/sogo/sogo.conf:
Code:
{
/* Database configuration (mysql://, postgresql:// or oracle://) */
SOGoProfileURL = "mysql://sogo:sogo@localhost:3306/sogo/sogo_user_profile";
OCSFolderInfoURL = "mysql://sogo:sogo@localhost:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL = "mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder";
/* Mail */
SOGoDraftsFolderName = Drafts;
SOGoSentFolderName = Sent;
SOGoTrashFolderName = Trash;
SOGoJunkFolderName = Junk;
SOGoIMAPServer = "localhost";
SOGoSieveServer = "sieve://127.0.0.1:4190";
SOGoSMTPServer = "smtp://127.0.0.1";
SOGoMailDomain = shams.eu.org;
SOGoMailingMechanism = smtp;
//SOGoForceExternalLoginWithEmail = NO;
//SOGoMailSpoolPath = /var/spool/sogo;
NGImap4AuthMechanism = "plain";
NGImap4ConnectionStringSeparator = "/";
SOGoUserSources =
(
{
type = sql;
id = users;
viewURL = "mysql://sogo:sogo@127.0.0.1:3306/sogo/sogo_users";
canAuthenticate = YES;
displayName = "SOGo Users";
isAddressBook = NO;
userPasswordAlgorithm = plain;
}
);
/* Web Interface */
SOGoPageTitle = SOGo;
SOGoVacationEnabled = YES;
//SOGoForwardEnabled = YES;
SOGoSieveScriptsEnabled = YES;
//SOGoMailAuxiliaryUserAccountsEnabled = YES;
SOGoTrustProxyAuthentication = YES;
//SOGoXSRFValidationEnabled = NO;
/* General - SOGoTimeZone *MUST* be defined */
SOGoLanguage = English;
SOGoTimeZone = Region/City;
//SOGoCalendarDefaultRoles = (
// PublicDAndTViewer,
// ConfidentialDAndTViewer
//);
SOGoSuperUsernames = (user_name); // This is an array - keep the parens!
//SxVMemLimit = 384;
//WOPidFile = "/var/run/sogo/sogo.pid";
//SOGoMemcachedHost = "/var/run/memcached.sock";
/* Debug */
SOGoDebugRequests = YES;
SoDebugBaseURL = YES;
ImapDebugEnabled = YES;
//LDAPDebugEnabled = YES;
//PGDebugEnabled = YES;
MySQL4DebugEnabled = YES;
SOGoUIxDebugEnabled = YES;
//WODontZipResponse = YES;
WOLogFile = /var/log/sogo/sogo.log;
}
This is /etc/httpd/conf/extra/SOGo.conf:
Code:
Alias /SOGo.woa/WebServerResources/ \
/usr/lib/GNUstep/SOGo/WebServerResources/
Alias /SOGo/WebServerResources/ \
/usr/lib/GNUstep/SOGo/WebServerResources/
<Directory /usr/lib/GNUstep/SOGo/>
AllowOverride None
<IfVersion < 2.4>
Order deny,allow
Allow from all
</IfVersion>
<IfVersion >= 2.4>
Require all granted
</IfVersion>
<IfModule expires_module>
ExpiresActive On
ExpiresDefault "access plus 1 year"
</IfModule>
</Directory>
<Location /SOGo>
# Don't cache dynamic content
Header set Cache-Control "max-age=0, no-cache, no-store"
</Location>
## For full proxy-side authentication:
<Location /SOGo>
AuthType sql
Require valid-user
SetEnv proxy-nokeepalive 1
Allow from all
</Location>
ProxyRequests Off
ProxyPreserveHost ON
SetEnv proxy-nokeepalive 1
# Uncomment the following lines if you experience "Bad gateway" errors with mod_proxy
#SetEnv proxy-initial-not-pooled 1
#SetEnv force-proxy-request-1.0 1
<Proxy http://127.0.0.1:20000/SOGo>
## Adjust the following to your configuration
## and make sure to enable the headers module
<IfModule headers_module>
### Added by me from sogo arch wiki
SetEnvIf Host (.*) HTTP_HOST=$1
RequestHeader set "x-webobjects-server-port" "80"
RequestHeader set "x-webobjects-server-name" "%{HTTP_HOST}e" env=HTTP_HOST
## When using proxy-side autentication, you need to uncomment and
## adjust the following line:
RequestHeader unset "x-webobjects-remote-user"
RequestHeader set "x-webobjects-remote-user" "%{REMOTE_USER}e" env=REMOTE_USER
RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"
</IfModule>
AddDefaultCharset UTF-8
Order allow,deny
Allow from all
</Proxy>