{"id":18032,"date":"2015-11-11T13:32:05","date_gmt":"2015-11-11T19:32:05","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=18032"},"modified":"2022-12-16T05:23:19","modified_gmt":"2022-12-16T11:23:19","slug":"install-sogo-on-a-debian-8-vps","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/install-sogo-on-a-debian-8-vps\/","title":{"rendered":"Install SOGo on Debian 8"},"content":{"rendered":"
SOGo is a free and modern scalable groupware server. It provides a rich AJAX-based Web interface and supports multiple native clients through the use of standard protocols such as CalDAV, CardDAV and GroupDAV, as well as Microsoft ActiveSync. SOGo offers shared calendars, address books, and emails through your favourite Web browser and by using a native client such as Mozilla Thunderbird and Lightning.<\/p>\n
<\/p>\n
In this article, we will provide you with the steps needed for installing SOGo on a Debian 8 VPS<\/a>.<\/p>\n REQUIREMENTS<\/strong><\/p>\n We will be using our SSD 1 Linux VPS<\/a> Hosting plan for this tutorial.<\/p>\n Login to your server via SSH<\/p>\n You can check whether you have the proper version of Debian installed on our server with the below command:<\/p>\n Which should give you the underneath output:<\/p>\n UPDATE THE SYSTEM<\/strong><\/p>\n Make sure your server is fully up to date.<\/p>\n Next thing you need to to is to add the SOGo repository to your server sources. We will use vim as our text editor, but free to use the one which suits your skills the most.<\/p>\n Once you open \/etc\/apt\/sources.list<\/strong><\/em>, add the below line at the bottom of the file:<\/p>\n In order to verify the SOGo builds signature, their GPG public key has to be added into apt keyring. To do so, run the following command:<\/p>\n Update the package index:<\/p>\n INSTALL SOGO<\/strong><\/p>\n Use the below command to install SOGo and some necessary applications:<\/p>\n Then, enable some much needed Apache modules:<\/p>\n Restart Apache for the changes to take effect:<\/p>\n Remove the tmpreader warning:<\/p>\n Configure Memcached:<\/p>\n Next run the MySQL post-installation script mysql_secure_installation:<\/p>\n Configure it like this:<\/p>\n Restart MySQL and Memcached:<\/p>\n Now, create a database for SOGo. Enter MySQL as root:<\/p>\n The SOGo configuration has to be done by the ‘sogo<\/em><\/strong>‘ user itself. Enter the below commands and replace the ‘your_domain<\/strong><\/em>‘ and ‘your_password<\/strong><\/em>‘ values with your actual domain and password that you used in the above database creation procedure:<\/p>\n Configure SOGo configuration file:<\/p>\n Restart SOGo:<\/p>\n Now, open your favorite browser and navigate to http:\/\/your_domain\/SOGo<\/strong> . You should see the same page as the one in the image below:<\/p>\n <\/p>\n That’s it. You have successfully installed SOGo on a Debian 8 VPS<\/a>.<\/p>\n Of course you don\u2019t have to do any of this if you use one of our Linux VPS Hosting<\/a> services, in which case you can simply ask our expert Linux admins to install SOGo for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n PS.<\/span> If you liked this post please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":" SOGo is a free and modern scalable groupware server. It provides a rich AJAX-based Web interface and supports multiple native … <\/p>\n# ssh root@server_ip<\/pre>\n
# lsb_release -a<\/pre>\n
Distributor ID: Debian\r\nDescription: Debian GNU\/Linux 8.2 (jessie)\r\nRelease: 8.2\r\nCodename: jessie<\/pre>\n
# apt-get update && apt-get upgrade<\/pre>\n
# vim \/etc\/apt\/sources.list<\/pre>\n
# deb http:\/\/inverse.ca\/debian jessie jessie<\/pre>\n
# apt-key adv --keyserver keys.gnupg.net --recv-key 0x810273C4<\/pre>\n
# apt-get update<\/pre>\n
# apt-get install sogo sope4.9-gdl1-mysql memcached rpl<\/pre>\n
# a2enmod proxy proxy_http headers rewrite<\/pre>\n
# service apache2 restart<\/pre>\n
# rpl 'SHOWWARNING=true' 'SHOWWARNING=false' \/etc\/tmpreaper.conf<\/pre>\n
# rpl '127.0.0.1' localhost \/etc\/memcached.conf<\/pre>\n
# mysql_secure_installation<\/pre>\n
- Set root password? [Y\/n] y\r\n- Remove anonymous users? [Y\/n] y\r\n- Disallow root login remotely? [Y\/n] y\r\n- Remove test database and access to it? [Y\/n] y\r\n- Reload privilege tables now? [Y\/n] y<\/pre>\n
# service mysql restart\r\n\r\n# service memcached restart<\/pre>\n
# mysql -u root -p\r\n\r\nmysql> CREATE DATABASE sogo;\r\n\r\nmysql> GRANT ALL ON sogo.* TO 'sogou'@'localhost' IDENTIFIED BY 'your_password';\r\n\r\nmysql> USE sogo;\r\n\r\nmysql> 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));\r\n\r\nmysql> INSERT INTO sogo_users VALUES ('tom', 'tom', MD5('your_password'), 'Tom User', 'tom@daywalker.cf'); mysql> flush privileges; mysql> exit<\/pre>\n
# su - sogo -s \/bin\/bash\r\n\r\n# defaults write sogod SOGoTimeZone \"US\/Central\"\r\n\r\n# defaults write sogod SOGoMailDomain \"your_domain\"\r\n\r\n# defaults write sogod SOGoLanguage \"English\"\r\n\r\n# defaults write sogod SOGoUserSources '({canAuthenticate = YES; displayName = \"SOGo Users\"; id = users; isAddressBook = YES; type = sql; userPasswordAlgorithm = md5; viewURL =\"mysql:\/\/sogoUSER:your_password@127.0.0.1:3306\/sogoDB\/sogo_users\";})'\r\n\r\n# defaults write sogod SOGoProfileURL 'mysql:\/\/sogoUSER:your_password@127.0.0.1:3306\/sogoDB\/sogo_user_profile'\r\n\r\n# defaults write sogod OCSFolderInfoURL 'mysql:\/\/sogoUSER:your_password@127.0.0.1:3306\/sogoDB\/sogo_folder_info'\r\n\r\n# defaults write sogod OCSSessionsFolderURL 'mysql:\/\/sogoUSER:your_password@127.0.0.1:3306\/sogoDB\/sogo_sessions_folder'\r\n\r\n# defaults write sogod SOGoAppointmentSendEMailNotifications YES\r\n\r\n# defaults write sogod SOGoLoginModule Calendar\r\n\r\n# defaults write sogod SOGoSieveScriptsEnabled YES\r\n\r\n# defaults write sogod SOGoSieveServer sieve:\/\/localhost:4190\r\n\r\n# defaults write sogod SOGoVacationEnabled YES\r\n\r\n# defaults write sogod SOGoMailMessageCheck every_5_minutes\r\n\r\n# defaults write sogod SOGoFirstDayOfWeek 1\r\n\r\n# defaults write sogod SOGoSuperUsernames '( \"admin\" )'\r\n\r\n# defaults write sogod SOGoDraftsFolderName \"INBOX.Drafts\"\r\n\r\n# defaults write sogod SOGoSentFolderName \"INBOX.Sent\"\r\n\r\n# defaults write sogod SOGoTrashFolderName \"INBOX.Trash\"\r\n\r\n# defaults write sogod NGImap4ConnectionStringSeparator \".\"\r\n\r\n# exit<\/pre>\n
# sed -i 's#yourhostname#your_domain#g' \/etc\/apache2\/conf-available\/SOGo.conf\r\n\r\n# sed -i 's#\"x-webobjects-server-port\" \"443\"#\"x-webobjects-server-port\" \"80\"#' \/etc\/apache2\/conf-available\/SOGo.conf\r\n\r\n# sed -i 's#https#http#' \/etc\/apache2\/conf-available\/SOGo.conf<\/pre>\n
# service sogo restart<\/pre>\n