Changes between Version 1 and Version 2 of Sogo Setup

Timestamp:

04/19/22 05:00:18 (3 years ago)

Author:

Paul Kulda

Comment:

--

Sogo Setup

@@ -19 +19 @@
 }
 }}}
+
+sample database setup
+
+please note that sogo uses postgresql views to access the database (not clearly defined) and this needs to be setup before trying to auth
+
+** Also note that a view in the config file actual points to a table (or view) to access the database
+
+again not very clearly defined.
+
+
+{{{
+
+CREATE DATABASE sogo CHARSET='UTF8';
+GRANT ALL ON sogo.* TO sogo@localhost IDENTIFIED BY 'password';
+
+GRANT SELECT ON vmail.mailbox TO sogo@localhost;
+
+CREATE VIEW sogo.users (c_uid, c_name, c_password, c_cn, mail, domain) AS SELECT username, username, password, name, username, domain FROM vmail.mailbox WHERE enablesogo=1 AND active=1;
+
+}}}
+