Re: [SOGo] Address Book on Postgresql

2013-02-18 Thread Christian Mack
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

Re: [SOGo] Address Book on Postgresql

2013-02-18 Thread Dario Carbone
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

Re: [SOGo] Address Book on Postgresql

2013-02-07 Thread Christian Mack
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[2

Re: [SOGo] Address Book on Postgresql

2013-02-07 Thread 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] PG0x0x7ffcfccb214

Re: [SOGo] Address Book on Postgresql

2013-02-06 Thread André Schild
Am 06.02.2013 19:25, schrieb Francis Lachapelle: Hi Dario On 2013-02-06, at 6:21 AM, Dario Carbone 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 : Fi

Re: [SOGo] Address Book on Postgresql

2013-02-06 Thread Francis Lachapelle
Hi Dario On 2013-02-06, at 6:21 AM, Dario Carbone 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?

Re: [SOGo] Address Book on Postgresql

2013-02-06 Thread Dario Carbone
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?      

Re: [SOGo] Address Book on Postgresql

2013-02-06 Thread Christian Mack
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 = gl

[SOGo] Address Book on Postgresql

2013-02-05 Thread dario.carbone
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