Re: [SOGo] SOGo, Postgres - question about users - better explanation
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
Re: [SOGo] Re: SOGo upgrade issue
thx, I'll look at it when I'm back off my downtime On 07/01/2015 12:21 PM, Achim Gottinger wrote: Hello Steve, You used purge and not remove so all configs got removed as well. Take an look in /var/lib/samba you may find backup's there done by apt/dpkg durcing upgrades. I have an bunch of backed-up-by-dpkg-on-2015-03-10T16.56.tar.gz files there. Seems these include all the necessary ldb's but they all have an suffix like backed-up-by-dpkg-on-2015-03-10T16.56 here which must be removed. achim~ -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Some contacts not synched with Thunderbird
Maybe this bug I reported over a year ago: http://www.sogo.nu/bugs/view.php?id=2802 ? Charles On 7/1/2015 12:18 AM, Nigel Pegram ndpeg...@gmail.com wrote: Hi, SOGo is working fine, web interface perfect. Thunderbird integration working, apart from one error. Some contacts are not being synced to the Thunderbird address book. It looks like the cause is contact records which have a Display Name, but no first or last names. I don't know how the user has created these records, but they obviously have been able to. So, if SOGo allows records like this to be entered, why can't it synchronise them? If there is a good reason, then why doesn't SOGo block entry of such records (validate the data)? If validation like this is not able to be enforced then perhaps we need a work around in the back end to avoid these records disappearing, e.g. a work around which enters something in the required fields so they sync. Also, is there an easy way to find these records and update them? If nothing else we could do a quick correction by copying the display name to the first or last name field as-is. How, though? The data is in a mySQL database. I can program an SQL query, but I'd need to know how to find the records (in which tables they are). Is there a better way? -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Some contacts not synched with Thunderbird
Hi, SOGo is working fine, web interface perfect. Thunderbird integration working, apart from one error. Some contacts are not being synced to the Thunderbird address book. It looks like the cause is contact records which have a Display Name, but no first or last names. I don't know how the user has created these records, but they obviously have been able to. So, if SOGo allows records like this to be entered, why can't it synchronise them? If there is a good reason, then why doesn't SOGo block entry of such records (validate the data)? If validation like this is not able to be enforced then perhaps we need a work around in the back end to avoid these records disappearing, e.g. a work around which enters something in the required fields so they sync. Also, is there an easy way to find these records and update them? If nothing else we could do a quick correction by copying the display name to the first or last name field as-is. How, though? The data is in a mySQL database. I can program an SQL query, but I'd need to know how to find the records (in which tables they are). Is there a better way? -- users@sogo.nu https://inverse.ca/sogo/lists
ODP: [SOGo] SOGo, Postgres - question about users - betterexplanation
Thanks Daniel for answers.
So I have to create new table VIEW where Sogo have access and there create the
users? I don't can't use my existing table?
-Wiadomość oryginalna-
Od: Daniel van Ham Colchete daniel.colch...@gmail.com
Wysłano: 2015-07-01 20:42
Do: users@sogo.nu users@sogo.nu
Temat: Re: [SOGo] SOGo, Postgres - question about users - betterexplanation
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
Re: [SOGo] Re: SOGo upgrade issue
Hello Steve, You used purge and not remove so all configs got removed as well. Take an look in /var/lib/samba you may find backup's there done by apt/dpkg durcing upgrades. I have an bunch of backed-up-by-dpkg-on-2015-03-10T16.56.tar.gz files there. Seems these include all the necessary ldb's but they all have an suffix like backed-up-by-dpkg-on-2015-03-10T16.56 here which must be removed. achim~ Am 27.06.2015 um 11:18 schrieb Steve Ankeny: I was able to purge the Ubuntu distro Samba packages. It also purged the 'openchangeserver' and 'openchangeproxy' packages. I was able to run update/upgrade, after which I re-installed the Inverse Samba and OpenChange packages. HOWEVER, once I restarted all the services, I was unable to login to my Samba domain. Login to the domain was refused, and the SOGo web interface failed on username/password unknown Does purging Samba also purge the accounts database, and do I need to backup/restore or re-provision? I'm looking for a few other suggestions, though I may not be able to address this for a few days (vacations) On 06/23/2015 11:01 AM, Ludovic Marcotte wrote: On 23/06/2015 10:26, Steve Ankeny wrote: Will that *damage* my Samba-AD-DC or its database? Will I need to re-provision, etc? Most likely not. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 ::http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo, Postgres - question about users - better explanation
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
[SOGo] BTS activities for Wednesday, July 01 2015
Title: BTS activities for Wednesday, July 01 2015 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Wednesday, July 01 2015 idlast updatestatus (resolution)categorysummary 3272 2015-07-01 02:15:06 updated (open) ActiveSync RoadSync for Java unable to sync 2802 2015-07-01 10:50:32 updated (open) Backend Address Book Duplicating Address Book Entry doesn't work 3248 2015-07-01 05:16:13 updated (open) Web Calendar Badly worded confirmation message when deleting appointments 54 2015-07-01 15:39:37 resolved (fixed) Web Calendar Multiple ATTACH elements 3273 2015-07-01 12:34:59 closed (not a bug) with SOGo SOGo and Postgres - problem with users (?)
