Hi Mirek,
here what you will need to do is to create a VIEW on your PostgreSQL
database that Sogo will access. In my case (MySQL) the create view command
is:
create or replace view sogo as select domain, email as mail, email as
c_uid, email as c_mail, email as c_name, password as c_password, name as
c_cn from accounts;
Then, on my sogo.conf I have:
SOGoUserSources =
(
{
type = sql;
id = publicmav;
viewURL = "mysql://user:password@hostname/database/sogo";
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = crypt;
displayName = "Global";
DomainFieldName = "domain";
}
);
I recommend that you read the installation guide, there are a lot of
important parameters for you sogo.conf file that you need to understand:
http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf .
Best,
Daniel Colchete
On Wed, Jul 1, 2015 at 1:48 PM, Mirek <miros...@slawinski.net.pl> wrote:
> Hi.
>
> I have already installed Postfix and Dovecot supported with PostgreSQL
> database. In my DB i keep users, domain and aliases. Now i want to add SOGo
> but i have a problem with users because i don't want create new database
> and
> tables for sogo but use my previouse DB with my users. Can I connect SOGo
> to
> another database ? and can I create own SELECT scripts ?
>
> Best regards
> Mirek
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
--
users@sogo.nu
https://inverse.ca/sogo/lists
