Hello,

I'm currently installing SOGO on an ubuntu 20.06 server.
I followed the instructions on the site https://www.sogo.nu/download.html

sudo wget -O- "http://pgp.mit.edu/pks/lookup?op=get&search=0xCB2D3A2AA0030E2C"; 
| sudo gpg --dearmor | sudo apt-key add -
sudo wget -O- 
"https://keys.openpgp.org/vks/v1/by-fingerprint/74FFC6D72B925A34B5D356BDF8A27B36A6E2EAE9";
 | sudo gpg --dearmor | sudo apt-key add -
sudo apt-get update
sudo apt-get install apt-transport-https
sudo tee /etc/apt/sources.list.d/SOGo.list < deb 
https://packages.sogo.nu/nightly/5/ubuntu/ focal focal
EOF
sudo apt-get update

Before installing SOGO, I installed Apache 2 and activated the Apache modules

a2enmod proxy proxy_http headers rewrite
I restarted the apache2 service
systemctl restart apache2

Then I created the database, which I called testsogo.
Then I created a sogo_user table.

MariaDB [(none)]> USE testsogo;
MariaDB [sogo]> CREATE TABLE sogo_users (c_uid VARCHAR(10) PRIMARY KEY, c_name 
VARCHAR(10), c_password VARCHAR(32), c_cn VARCHAR(128), mail VARCHAR(128));
MariaDB [sogo]> INSERT INTO sogo_users VALUES ('admin1', 'admin1', 
MD5('your-secure-password'), 'SOGouser', 's...@example.com');

I've installed Sogo
sudo apt-get install sogo

I copied the file /etc/apache2/conf.d/SOGo.conf to 
/etc/apache2/conf-enabled/SOGo.conf

Next, I edited the SOGo virtual host configuration file:

nano /etc/apache2/conf.d/SOGo.conf

I replaced the following items:

RequestHeader set "x-webobjects-server-port" "80"
RequestHeader set "x-webobjects-server-url" "http://%{HTTP_HOST}e"; env=HTTP_HOST

I have activated the Apache2 configuration
a2enconf SOGo.conf

I've restarted the apache2 service
systemctl restart apache2


I went to /etc/sogo/sogo.conf

I added the following lines:

SOGoProfileURL = 
"mysql://sogo:your-secure-password@localhost:3306/testsogo/sogo_user_profile";
OCSFolderInfoURL = 
"mysql://sogo:your-secure-password@localhost:3306/testsogo/sogo_folder_info";
OCSSessionsFolderURL = 
"mysql://sogo:your-secure-password@localhost:3306/testsogo/sogo_sessions_folder";

SOGoPasswordChangeEnabled = YES;

SOGoUserSources =
(
{
type = sql;
id = users;
viewURL = 
"mysql://sogo:your-secure-password@127.0.0.1:3306/testsogo/sogo_users";
canAuthenticate = YES;
isAddressBook = NO;
userPasswordAlgorithm = md5;
}
);

SOGoPageTitle = SOGo;
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
SOGoSieveScriptsEnabled = YES;
SOGoMailAuxiliaryUserAccountsEnabled = YES;
SOGoTrustProxyAuthentication = NO;
SOGoXSRFValidationEnabled = YES;

SOGoSuperUsernames = (admin1, admin2); // This is an array - keep the parents!

I've restarted the Sogo service

systemctl restart sogo

Then I try to go to WebUI of Sogo via firefox 192.168.1.10/SOGO

But I get a 404 error.

Do you have any idea how to access the WebUI of Sogo?

--
Thanks
Alain 25

Reply via email to