[SOGo] Thanks, and database questions
Hello all, A big than you to the SOGo team, as I have been able to integrate it into my Debian Stretch mail server, without too much problems. However, I have a few questions. 1 - My email server automatically makes a copy of the emails sent into the sent folder. How can I configure Sogo to not make a copy? 2 - On the official documentation, I could not find how to create the PostgreSQL database, using this code: CREATE TABLE sogo_users ( c_uid VARCHAR(128) NOT NULL PRIMARY KEY, c_name VARCHAR(128) NOT NULL, c_password VARCHAR(128) NOT NULL, c_cn VARCHAR(128) NULL, mail VARCHAR(128) NOT NULL, CONSTRAINT mail_unique UNIQUE (mail) ); Is this enough, or I am missing some tables? For reference, the latest version of the script I use to deploy is here: https://github.com/progmaticltd/homebox/tree/dev-sogo/install/playbooks/roles/sogo Kind regards, André Rodier -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Thanks, and database questions
On 11/17/18 11:28 PM, André Rodier "(an...@rodier.me) wrote: 2 - On the official documentation, I could not find how to create the PostgreSQL database, using this code: The sogo_users table is only necessary if you're configuring SOGo to use a SQL user source. The ansible role you're following doesn't do that as far as I can tell, so I'm not sure why it makes the table. See this URL for more information: http://wiki.sogo.nu/ResourceConfiguration Generally, SOGo will create the tables that it requires on its own, and you don't need to do anything manually. As described above, you might create this table if you want to create shared resources like meeting rooms in SQL rather than creating them in LDAP. If you already have an LDAP user source, you can also create resources there. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Thanks, and database questions
On 2018-11-18 20:49, Gordon Messmer wrote: On 11/17/18 11:28 PM, André Rodier "(an...@rodier.me) wrote: 2 - On the official documentation, I could not find how to create the PostgreSQL database, using this code: The sogo_users table is only necessary if you're configuring SOGo to use a SQL user source. The ansible role you're following doesn't do that as far as I can tell, so I'm not sure why it makes the table. See this URL for more information: http://wiki.sogo.nu/ResourceConfiguration Generally, SOGo will create the tables that it requires on its own, and you don't need to do anything manually. As described above, you might create this table if you want to create shared resources like meeting rooms in SQL rather than creating them in LDAP. If you already have an LDAP user source, you can also create resources there. Thank you, Gordon, I will add this LDAP schema. Kind regards, André -- users@sogo.nu https://inverse.ca/sogo/lists