Re: [SOGo] Address Book on Postgresql
Ok, all worked. I've reimposted the sogo password and used the patch for the address book. So now i can view som data, but i need more clarifications How can I store other datas ? ( Home Phone ? fax ? address and so on ? ) Thanks in advice Il 07/02/2013 10:40, Christian Mack ha scritto: Am 2013-02-07 09:45, schrieb Dario Carbone: Ok, thanks. But don't work too, the sogo.log report : 2013-02-07 09:31:19.322 sogod[28259] PG0x0x7ffcfc9a4d80 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'testuser' AND c_folder_type = 'Contact' 2013-02-07 09:31:19.323 sogod[28259] PG0x0x7ffcfccb2140 SQL: SELECT * FROM t_gab WHERE (LOWER(c_cn) LIKE '%carb%' OR LOWER(mail) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%') Feb 07 09:31:19 sogod [28259]: [ERROR] 0x0x7ffcfcc813a0[SQLSource] could not run SQL 'SELECT * FROM t_gab WHERE (LOWER(c_cn) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%')': PostgreSQL72Exception: 0x7ffcfcc722d0 NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x7ffcfccb2140[PostgreSQL72Channel]: connection=0x0x7ffcfcc9bf00[PGConnection]: connection=0x0x7ffcfccbb460): ERROR: permission denied for relation t_gab But if I so the query with the command line psql, all work. Any ideas ? ... stringpostgresql://sogo:sogo@localhost:5432/sogo_gab/t_gab/string cut Are you sure you used user "sogo" with password "sogo" for psql too? That's what you instruct SOGo to use. Kind regards, Christian Mack -- Carbone Dario Primeur Customer Services S.r.l. EMAIL: dario.carb...@primeur.com URL: http://www.primeur.com Mobile: +39 3488960584
Re: [SOGo] Address Book on Postgresql
Am 2013-02-18 11:39, schrieb Dario Carbone: Il 07/02/2013 10:40, Christian Mack ha scritto: Am 2013-02-07 09:45, schrieb Dario Carbone: Ok, thanks. But don't work too, the sogo.log report : 2013-02-07 09:31:19.322 sogod[28259] PG0x0x7ffcfc9a4d80 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'testuser' AND c_folder_type = 'Contact' 2013-02-07 09:31:19.323 sogod[28259] PG0x0x7ffcfccb2140 SQL: SELECT * FROM t_gab WHERE (LOWER(c_cn) LIKE '%carb%' OR LOWER(mail) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%') Feb 07 09:31:19 sogod [28259]: [ERROR] 0x0x7ffcfcc813a0[SQLSource] could not run SQL 'SELECT * FROM t_gab WHERE (LOWER(c_cn) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%')': PostgreSQL72Exception: 0x7ffcfcc722d0 NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x7ffcfccb2140[PostgreSQL72Channel]: connection=0x0x7ffcfcc9bf00[PGConnection]: connection=0x0x7ffcfccbb460): ERROR: permission denied for relation t_gab But if I so the query with the command line psql, all work. Any ideas ? ... stringpostgresql://sogo:sogo@localhost:5432/sogo_gab/t_gab/string cut Are you sure you used user sogo with password sogo for psql too? That's what you instruct SOGo to use. Ok, all worked. I've reimposted the sogo password and used the patch for the address book. So now i can view som data, but i need more clarifications How can I store other datas ? ( Home Phone ? fax ? address and so on ? ) You should look at the specification for the ldap class inetOrgPerson. It has the attributes: description fax, facsimileTelephoneNumber interationaliSDNNumber l, localityName physicalDeliveryOfficeName postalAddress postalCode postOfficeBox registeredAddress st, stateOrProviceName street, streetAddress telephoneNumber telexNumber displayName departmentNumber homePhone, homeTelephoneNumber homePostalAddress jpegPhoto (deprecated) labeledURI mail mobile, mobileTelephoneNumber o, organizationName pager, pagerTelephoneNumber photo roomNumber I didn't test them all, but most of them should be shown in the address book. But be aware that multivalue entries (e.g. mail) are only shown once. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Address Book on Postgresql
Ok, thanks. But don't work too, the sogo.log report : 2013-02-07 09:31:19.322 sogod[28259] PG0x0x7ffcfc9a4d80 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'testuser' AND c_folder_type = 'Contact' 2013-02-07 09:31:19.323 sogod[28259] PG0x0x7ffcfccb2140 SQL: SELECT * FROM t_gab WHERE (LOWER(c_cn) LIKE '%carb%' OR LOWER(mail) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%') Feb 07 09:31:19 sogod [28259]: [ERROR] 0x0x7ffcfcc813a0[SQLSource] could not run SQL 'SELECT * FROM t_gab WHERE (LOWER(c_cn) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%')': PostgreSQL72Exception: 0x7ffcfcc722d0 NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x7ffcfccb2140[PostgreSQL72Channel]: connection=0x0x7ffcfcc9bf00[PGConnection]: connection=0x0x7ffcfccbb460): ERROR: permission denied for relation t_gab But if I so the query with the command line psql, all work. Any ideas ? Thanks Il 06/02/2013 22:13, Andr Schild ha scritto: Am 06.02.2013 19:25, schrieb Francis Lachapelle: Hi Dario On 2013-02-06, at 6:21 AM, Dario Carbone dario.carb...@primeur.com wrote: Hi, thanks for the reply. I've see it on the doc, but don't work for me. My configurations : POSTGRESS i've creted another db called sogo_gab and a table (t_gab) with this columns : Field name Type Array? Allow nulls? c_uid varchar(255) No No c_name varchar(255) No No c_password varchar(255) No Yes c_cn varchar(255) No Yes mail varchar(255) No No company varchar(255) No Yes SOGO : dict keycanAuthenticate/key stringNO/string keydisplayName/key stringPrimeur GAB/string keyid/key stringPrimeur_GAB/string keyisAddressBook/key stringYES/string keytype/key stringsql/string keyviewURL/key stringpostgresql://sogo:sogo@localhost:5432/sogo_gab/t_gab/string /dict But dosen't work. On the log file i saw nothing Do you see the addressbook in the Web interface? If so, notice that you need to perform a search (or type a dot ".") on global addressbooks. No entry will be shown by default. Any chance we get a solution for this? http://www.sogo.nu/bugs/view.php?id=438 Andr -- Carbone Dario Primeur Customer Services S.r.l. EMAIL: dario.carb...@primeur.com URL:http://www.primeur.com Mobile: +39 3488960584
Re: [SOGo] Address Book on Postgresql
Am 2013-02-07 09:45, schrieb Dario Carbone: Ok, thanks. But don't work too, the sogo.log report : 2013-02-07 09:31:19.322 sogod[28259] PG0x0x7ffcfc9a4d80 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'testuser' AND c_folder_type = 'Contact' 2013-02-07 09:31:19.323 sogod[28259] PG0x0x7ffcfccb2140 SQL: SELECT * FROM t_gab WHERE (LOWER(c_cn) LIKE '%carb%' OR LOWER(mail) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%') Feb 07 09:31:19 sogod [28259]: [ERROR] 0x0x7ffcfcc813a0[SQLSource] could not run SQL 'SELECT * FROM t_gab WHERE (LOWER(c_cn) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%')': PostgreSQL72Exception: 0x7ffcfcc722d0 NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x7ffcfccb2140[PostgreSQL72Channel]: connection=0x0x7ffcfcc9bf00[PGConnection]: connection=0x0x7ffcfccbb460): ERROR: permission denied for relation t_gab But if I so the query with the command line psql, all work. Any ideas ? ... stringpostgresql://sogo:sogo@localhost:5432/sogo_gab/t_gab/string cut Are you sure you used user sogo with password sogo for psql too? That's what you instruct SOGo to use. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Address Book on Postgresql
Hello
Am 2013-02-05 12:41, schrieb dario.carb...@primeur.com:
is it possible to use postgresql to have a global address book ?
Sure.
You only have to add another SOGoUserSources of type sql.
You have to set it:
canAuthenticate NO
isAddressBook YES
Example:
{
type = sql;
id = global_addresses
viewURL = postgresql://sogo:sogo@127.0.0.1:5432/sogo/sogo_view;
canAuthenticate = NO;
isAddressBook = YES;
displayName = Addresses for Everyone
}
How are the schema to create the DB ?
From the Documentation:
viewURL database URL of the view used by SOGo. The view expects
columns to be present. Required columns are :
• c_uid : will be used for authentication – it's a username
or usern...@domain.tld
• c_name : will be used to uniquely identify entries – which
can be identical to c_uid
• c_password : password of the user, plain text, crypt, md5
or sha encoded
• c_cn : the user's common name
• mail : the user's email address
Other columns can exist and will actually be mapped
automatically if they have the same name as popular LDAP
attributes (such as givenName, sn, department, title,
telephoneNumber, etc.)
Mind, that view is here used as synonym for table too.
Kind regards,
Christian Mack
--
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universität Konstanz
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] Address Book on Postgresql
Hi, thanks for the reply.
I've see it on the doc, but don't work for me.
My configurations :
POSTGRESS
i've creted another db called sogo_gab and a table (t_gab) with this
columns :
Field name Type Array? Allow nulls?
c_uid varchar(255) No No
c_name varchar(255) No No
c_password varchar(255) No Yes
c_cn varchar(255) No Yes
mail varchar(255) No No
company varchar(255) No Yes
SOGO :
dict
keycanAuthenticate/key
stringNO/string
keydisplayName/key
stringPrimeur GAB/string
keyid/key
stringPrimeur_GAB/string
keyisAddressBook/key
stringYES/string
keytype/key
stringsql/string
keyviewURL/key
stringpostgresql://sogo:sogo@localhost:5432/sogo_gab/t_gab/string
/dict
But dosen't work.
On the log file i saw nothing
Thanks in advice.
Il 06/02/2013 12:03, Christian Mack ha
scritto:
Hello
Am 2013-02-05 12:41, schrieb dario.carb...@primeur.com:
is it possible to use postgresql to have a global address book ?
Sure.
You only have to add another SOGoUserSources of type sql.
You have to set it:
canAuthenticate NO
isAddressBook YES
Example:
{
type = sql;
id = global_addresses
viewURL = "postgresql://sogo:sogo@127.0.0.1:5432/sogo/sogo_view";
canAuthenticate = NO;
isAddressBook = YES;
displayName = "Addresses for Everyone"
}
How are the schema to create the DB ?
>From the Documentation:
viewURL database URL of the view used by SOGo. The view expects
columns to be present. Required columns are :
• c_uid : will be used for authentication – it's a username
or usern...@domain.tld
• c_name : will be used to uniquely identify entries – which
can be identical to c_uid
• c_password : password of the user, plain text, crypt, md5
or sha encoded
• c_cn : the user's common name
• mail : the user's email address
Other columns can exist and will actually be mapped
automatically if they have the same name as popular LDAP
attributes (such as givenName, sn, department, title,
telephoneNumber, etc.)
Mind, that view is here used as synonym for table too.
Kind regards,
Christian Mack
--
Carbone
Dario
Primeur
Customer Services S.r.l.
EMAIL: dario.carb...@primeur.com
URL: http://www.primeur.com
Mobile:
+39 3488960584
Re: [SOGo] Address Book on Postgresql
Hi Dario On 2013-02-06, at 6:21 AM, Dario Carbone dario.carb...@primeur.com wrote: Hi, thanks for the reply. I've see it on the doc, but don't work for me. My configurations : POSTGRESS i've creted another db called sogo_gab and a table (t_gab) with this columns : Field nameTypeArray?Allow nulls? c_uid varchar(255) No No c_name varchar(255) No No c_password varchar(255) No Yes c_cn varchar(255) No Yes mail varchar(255) No No company varchar(255) No Yes SOGO : dict keycanAuthenticate/key stringNO/string keydisplayName/key stringPrimeur GAB/string keyid/key stringPrimeur_GAB/string keyisAddressBook/key stringYES/string keytype/key stringsql/string keyviewURL/key stringpostgresql://sogo:sogo@localhost:5432/sogo_gab/t_gab/string /dict But dosen't work. On the log file i saw nothing Do you see the addressbook in the Web interface? If so, notice that you need to perform a search (or type a dot .) on global addressbooks. No entry will be shown by default. Francis -- flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Address Book on Postgresql
Am 06.02.2013 19:25, schrieb Francis Lachapelle: Hi Dario On 2013-02-06, at 6:21 AM, Dario Carbone dario.carb...@primeur.com wrote: Hi, thanks for the reply. I've see it on the doc, but don't work for me. My configurations : POSTGRESS i've creted another db called sogo_gab and a table (t_gab) with this columns : Field nameTypeArray?Allow nulls? c_uid varchar(255) No No c_name varchar(255) No No c_password varchar(255) No Yes c_cn varchar(255) No Yes mail varchar(255) No No company varchar(255) No Yes SOGO : dict keycanAuthenticate/key stringNO/string keydisplayName/key stringPrimeur GAB/string keyid/key stringPrimeur_GAB/string keyisAddressBook/key stringYES/string keytype/key stringsql/string keyviewURL/key stringpostgresql://sogo:sogo@localhost:5432/sogo_gab/t_gab/string /dict But dosen't work. On the log file i saw nothing Do you see the addressbook in the Web interface? If so, notice that you need to perform a search (or type a dot .) on global addressbooks. No entry will be shown by default. Any chance we get a solution for this? http://www.sogo.nu/bugs/view.php?id=438 André -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Address Book on Postgresql
Hi at all, is it possible to use postgresql to have a global address book ? How are the schema to create the DB ? Thanks in advice -- users@sogo.nu https://inverse.ca/sogo/lists
