[SOGo] Location field

2012-03-23 Thread Bruno Lingner (Hugo)

Is it possible to automatically fill in the field Location,
based on the invited location when an event is submitted?

greetings
hugo.-
--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] multiple ldap server

2012-03-23 Thread Khapare Joshi
Thanks guys,

On Thu, Mar 22, 2012 at 3:54 PM, Ludovic Marcotte lmarco...@inverse.cawrote:

 On 22/03/12 11:21, André Schild wrote:

 Will a DNS entry which returns multiple IP addresses serve as well ?

 Read OpenLDAP's code to make sure ;-)


 --
 Ludovic Marcotte
 +1.514.755.3630  ::  www.inverse.ca
 Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (
 www.packetfence.org)

 --
 users@sogo.nu
 https://inverse.ca/sogo/lists

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool remove-doubles

2012-03-23 Thread Christian Mack
Hello Donny Brooks


On 2012-03-22 19:38, Donny Brooks wrote:
 I am trying to remove some duplicate entries in my address book by using
 sogo-tool. However this is what I get when I try to do so:
 
 -bash-3.2$ /usr/sbin/sogo-tool remove-doubles dbrooks personal
 Mar 22 13:36:43 sogo-tool [16656]: [ERROR] 0x0x808fa98[GCSFolder]
 -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot
 execute quick-fetch SQL 'SELECT
 b.c_name,a.c_givenname,a.c_cn,a.c_sn,a.c_screenname,a.c_l,a.c_mail,a.c_o,a.c_ou,b.c_telephoneNumber,b.c_content,b.c_version,b.c_creationdate,b.c_lastmodified
 FROM sogodbrooks0022dd33700_quick a, sogodbrooks0022dd33700 b WHERE
 (c_component = 'vcard') AND a.c_name = b.c_name AND (c_deleted != 1 OR
 c_deleted IS NULL)': MySQL4Exception: 0x7f8bb38 NAME:ExecutionFailed
 REASON:Unknown column 'b.c_telephoneNumber' in 'field list'
 Unable to fetch required fields from folder.
 
 I am running it as the sogo user but that looks like a mysql error to
 me. What can I do to fix this?
 

Seems there is a column c_telephoneNumber missing in your table
sogodbrooks0022dd33700.

Did you execute all database upgrade scripts on upgrading SOGo?

(We use postgres so I can't check if this is a bug or not myself.)


Kind regards,
Christian Mack

-- 
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universität Konstanz
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Location field

2012-03-23 Thread Christian Mack
Hello Bruno Lingner (Hugo)


On 2012-03-23 08:10, Bruno Lingner (Hugo) wrote:
 Is it possible to automatically fill in the field Location,
 based on the invited location when an event is submitted?
 

Not yet.

You could report a feature request bug for this under:
http://www.sogo.nu/bugs


Kind regards,
Christian Mack

-- 
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universität Konstanz
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Vacation Sieve Filter

2012-03-23 Thread Davide Bozzelli

On 3/15/12 4:23 PM, Davide Bozzelli wrote:

Hi

I'm trying to set a vacation filter tru the sogo tool:

/usr/sbin/sogo-tool user-preferences set defaults bu...@foo.it 
sieve:sieve_pass Vacation
'{enabled: 0, endDate: 1334959200, ignoreLists: 1, 
autoReplyEmailAddresses: [davide.bozze...@foo.it, bu...@foo.it], 
autoReplyText: ferieeaaa, daysBetweenResponse: 30, 
endDateEnabled: 1}'


But when i launch it I receive the following output:

0x0x1164060[SOGoCache] Cache cleanup interval set every 300.00 
seconds

0x0x1164060[SOGoCache] Using host(s) 'localhost' as server(s)
0x0x11ce100[LDAPSource] WARNING: using old bindFields format - 
please update it
0x0x11cf750[LDAPSource] WARNING: using old bindFields format - 
please update it
/usr/sbin/sogo-tool: Uncaught exception NSRangeException, reason: 
Index 6 is out of range 6 (in 'objectAtIndex:')


I suppose there is an error in the filter... but I can't figure out 
where ...


Thx in advance

Anyone could help me on this topic ?
--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Vacation Sieve Filter

2012-03-23 Thread Francis Lachapelle
Hi Davide

On 2012-03-23, at 7:15 AM, Davide Bozzelli wrote:

 On 3/15/12 4:23 PM, Davide Bozzelli wrote:
 Hi
 
 I'm trying to set a vacation filter tru the sogo tool:
 
 /usr/sbin/sogo-tool user-preferences set defaults bu...@foo.it 
 sieve:sieve_pass Vacation
 '{enabled: 0, endDate: 1334959200, ignoreLists: 1, 
 autoReplyEmailAddresses: [davide.bozze...@foo.it, bu...@foo.it], 
 autoReplyText: ferieeaaa, daysBetweenResponse: 30, 
 endDateEnabled: 1}'
 
 But when i launch it I receive the following output:
 
 0x0x1164060[SOGoCache] Cache cleanup interval set every 300.00 seconds
 0x0x1164060[SOGoCache] Using host(s) 'localhost' as server(s)
 0x0x11ce100[LDAPSource] WARNING: using old bindFields format - please 
 update it
 0x0x11cf750[LDAPSource] WARNING: using old bindFields format - please 
 update it
 /usr/sbin/sogo-tool: Uncaught exception NSRangeException, reason: Index 6 is 
 out of range 6 (in 'objectAtIndex:')
 
 I suppose there is an error in the filter... but I can't figure out where ...
 
 Thx in advance
 Anyone could help me on this topic ?

It's a bug. And it's fixed (will be part of 1.3.14).

Thanks!

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

AW: [SOGo] Problems while importing sieve rules

2012-03-23 Thread m_brunnl
Hi,

 

I have done a second try enabling each debug setting which is possible.
(http://www.sogo.nu/english/nc/support/faq/article/how-to-enable-more-verbos
e-logging-in-sogo.html)

After calling the sogo-tool command mentioned in the previous mail, I got
this:

 

Mar 23 14:54:47 sogo-tool [18630]: 0x0x1057ca0[SOGoCache] Cache cleanup
interval set every 300.00 seconds

Mar 23 14:54:47 sogo-tool [18630]: 0x0x1057ca0[SOGoCache] Using host(s)
'localhost' as server(s)

2012-03-23 14:54:47.211 sogo-tool[18630] -[NGLdapConnection
_searchAtBaseDN:qualifier:attributes:scope:]: search with at base à_;²
filter Àx;² for attrs   :²

2012-03-23 14:54:47.211 sogo-tool[18630] -[NGLdapConnection
_searchAtBaseDN:qualifier:attributes:scope:]: search with at base  filter
Àx;² for attrs   :²

2012-03-23 14:54:47.215 sogo-tool[18630] -[NGLdapConnection
_searchAtBaseDN:qualifier:attributes:scope:]: search with at base Àx;²
filter Àx;² for attrs   :²

2012-03-23 14:54:47.222 sogo-tool[18630] MySQL4 connection established
0x0xed9ff0

2012-03-23 14:54:47.222 sogo-tool[18630] MySQL4 channel 0x0xfef9e0 opened
(connection=0x0xed9ff0,sogo)

2012-03-23 14:54:47.222 sogo-tool[18630] MySQL4Channel[0x0xfef9e0]
connection=0x0xed9ff0 SQL: SELECT c_defaults FROM sogo_user_profile WHERE
c_uid = 'malte';

2012-03-23 14:54:47.222 sogo-tool[18630] MySQL4Channel[0x0xfef9e0]
connection=0x0xed9ff0   query has results, entering fetch-mode.

Aborted

 

So why do sogo-tool abort this operation? I cannot see any problem message
or hint according to the abortion. The only interesting thing is, that I am
using a MySQL 5 database, so why is the MySQL4 debugger integrated in this
command call?

 

Is there anybody having an idea what is going wrong here?

 

Best regards,

Malte

 

Von: Malte Brunnlieb [mailto:ma...@brunnlieb.net] Im Auftrag von
m_bru...@cs.uni-kl.de
Gesendet: Freitag, 16. März 2012 13:16
An: users@sogo.nu
Betreff: [SOGo] JSON problems while importing sieve rules

 

Hi folks,

 

I am currently importing sieve rules into sogo using the sogo-tool.
Therefore I execute the following: ($...: variables that I have
instantiated)

 

sudo -u $sogoUser sogo-tool user-preferences set defaults $userToModify
$sogoUser:$pw SOGoSieveFilters '{SOGoSieveFilters: [{actions:
[{method: fileinto, argument: INBOX\/Test}], active: true,
rules: [{operator: contains, field: from, value:
us...@web.de}], match: any, name: UserFilter}]}'

 

All I get is:

 

0x0x1c8f710[SOGoCache] Cache cleanup interval set every 300.00 seconds

0x0x1c8f710[SOGoCache] Using host(s) 'localhost' as server(s)

Aborted

 

I cannot see any problem with the example sieve rule and nothing is said
about an error.

Any suggestions?

 

Best regards,

Malte

-- 
users@sogo.nu
https://inverse.ca/sogo/lists