Hi Daniel,
thanks you for help, it works great :)
Best,
Mirek
W dniu 2015-07-01 o 20:21, Daniel van Ham Colchete pisze:
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
<mailto: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 <mailto:users@sogo.nu>
https://inverse.ca/sogo/lists
--
users@sogo.nu
https://inverse.ca/sogo/lists
