Re: [SOGo] LDAP filter question

2013-04-25 Thread Arnaud LE NORCY
Le 23/04/2013 23:50, Paul van der Vlis a écrit :
 On 23-04-13 16:42, Jean Raby wrote:
 On 13-04-23 10:15 AM, Paul van der Vlis wrote:
 Hello,

 I use LDAP authentication on a server, but there are some users in LDAP
 who I don't want to give access to Sogo.

 They should be easy to filter, because they don't have an e-mail
 address. Do you have an idea how to filter this?

 This does not work:
 filter = (!(mail=''));
 filter = (!(mail=));
 filter = (!(mail='*@*'));
 filter = (!(mail=*@*));

 Do the opposite, add a filter to include all users with a mail attribute:
   filter = mail = '*';
 Hey, this works!

 Thanks!

 With regards,
 Paul van der Vlis.



Hello,

it seems that  :

filter = mail = '*';

doesn't work with sogo package 2.0.5.20130422-1 on debian 7... it
doesn't work for me..

the caracter jocker * is not considered!


nice day


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


Re: [SOGo] Meego Caldav | '{DAV:}getlastmodified' has no matching SQL field

2013-04-25 Thread mourik jan heupink

Dear list, peter,

Things are still not 100% working, and I'm guessing now the problem lies 
with the N9.


Syncing appointsments I manually made in thunderbird and the 
webinterface show up on the N9. I can even edit them on the N9, and the 
changes sync back. - Success.


Problem 1:
When creating an appointment on the N9, the start/end time shifts to 40 
minutes later on thunderbird/webaccess, and the 'raw source' seems VERY 
very complicated and wy to big for just a simple single appointment. 
See: http://pastebin.com/VbVknuym
Note: this raw source is a simple, single appointment, simple and plain, 
from 14:00 to 15:00, showing up as 14:40 to 15:40


Problem 2:
Imported ical calendars never show up on the N9, however thunderbird  
web access show them fine.


The above makes me think that the problem is actually on the N9 (and the 
libkcal 4.3 that it uses, gathered from the link above).


I realise this list is about SOGo and not about the N9, therefore my 
question is: Are there other people here using the N9/Meego/Harmattan 
with SOGo, and how are your experiences? Do you observe the same two 
issues/problems or not?


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


Re: [SOGo] Meego Caldav | '{DAV:}getlastmodified' has no matching SQL field

2013-04-25 Thread Christian Mack
Hello mourik jan heupink


Am 2013-04-25 11:45, schrieb mourik jan heupink:
 
 Things are still not 100% working, and I'm guessing now the problem lies
 with the N9.
 
 Syncing appointsments I manually made in thunderbird and the
 webinterface show up on the N9. I can even edit them on the N9, and the
 changes sync back. - Success.
 
 Problem 1:
 When creating an appointment on the N9, the start/end time shifts to 40
 minutes later on thunderbird/webaccess, and the 'raw source' seems VERY
 very complicated and wy to big for just a simple single appointment.
 See: http://pastebin.com/VbVknuym
 Note: this raw source is a simple, single appointment, simple and plain,
 from 14:00 to 15:00, showing up as 14:40 to 15:40
 

This appointment is correct.
But the Timezone definition in it is really large.

It also uses RDATE in the Timezone definition.
This is not jet supported by SOGo.
See Bug #2179
http://www.sogo.nu/bugs/bug_view_advanced_page.php?bug_id=2179

As it says soon as target version, it will be integrated into one of
the next versions.


 Problem 2:
 Imported ical calendars never show up on the N9, however thunderbird 
 web access show them fine.
 
 The above makes me think that the problem is actually on the N9 (and the
 libkcal 4.3 that it uses, gathered from the link above).
 

I am not sure here.
I think I read something about SOGo not announcing web calendars.

But why don't you add this web calendar directly on the N9.


 I realise this list is about SOGo and not about the N9, therefore my
 question is: Are there other people here using the N9/Meego/Harmattan
 with SOGo, and how are your experiences? Do you observe the same two
 issues/problems or not?
 

Sorry, don't have one :-)


Kind regards,
Christian Mack

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


[SOGo] LDAP GROUP ADDRESS is not showing in contact.list

2013-04-25 Thread Ravi Kanchan
Hi,

I have configured the SOGO. The user email is showing in list but group mail 
address is not showing there.can anyone helpme. my sogo configuration is given 
below.

?xml version=1.0 encoding=UTF-8?
!DOCTYPE plist PUBLIC -//GNUstep//DTD plist 0.9//EN 
http://www.gnustep.org/plist-0_9.xml;
plist version=0.9
dict
    keyNSGlobalDomain/key
    dict
    /dict
    keysogod/key
    dict
    keyOCSEMailAlarmsFolderURL/key
    
stringmysql://sogo:sogopasswd@localhost:3306/sogo/sogo_alarms_folder/string
    keyOCSFolderInfoURL/key
    
stringmysql://sogo:sogopasswd@localhost:3306/sogo/sogo_folder_info/string
    keyOCSSessionsFolderURL/key
    
stringmysql://sogo:sogopasswd@localhost:3306/sogo/sogo_sessions_folder/string
    keySOGoACLsSendEMailNotifications/key
    stringYES/string
    keySOGoAppointmentSendEMailNotifications/key
    stringYES/string
    keySOGoDraftsFolderName/key
    stringDrafts/string
    keySOGoEnableEMailAlarms/key
    stringYES/string
    keySOGoEnablePublicAccess/key
    stringYES/string
    keySOGoFoldersSendEMailNotifications/key
    stringYES/string
    keySOGoForwardEnabled/key
    stringYES/string
    keySOGoIMAPServer/key
    stringxxx.xxx.xxx.xxx/string
    keySOGoLanguage/key
    stringEnglish/string
    keySOGoMailDomain/key
    stringxxx.xxx/string
    keySOGoMailMessageCheck/key
    stringevery_minute/string
    keySOGoMailPollingIntervals/key
    string1/string
    keySOGoMailingMechanism/key
    stringsmtp/string
    keySOGoMemcachedHost/key
    stringlocalhost/string
    keySOGoProfileURL/key
    
stringmysql://sogo:sogopasswd@localhost:3306/sogo/sogo_user_profile/string
    keySOGoSMTPServer/key
    stringlocalhost/string
    keySOGoSentFolderName/key
    stringSent/string
    keySOGoSieveScriptsEnabled/key
    stringYES/string
    keySOGoSieveServer/key
    stringsieve://localhost:2000/string
    keySOGoSuperUsernames/key
    array
    stringkanchan/string
    /array
    keySOGoTimeZone/key
    stringAmerica/Montreal/string
    keySOGoTrashFolderName/key
    stringTrash/string
    keySOGoUserSources/key
    array
    dict
    keyCNFieldName/key
    stringcn/string
    keyIDFieldName/key
    stringcn/string
    keyUIDFieldName/key
    stringcn/string
    keybaseDN/key
    stringou=People,dc=x,dc=xxx/string
    keybindDN/key
    stringcn=Manager,dc=x,dc=xxx/string
    keybindPassword/key
    stringx/string
    keycanAuthenticate/key
    stringYES/string
    keydisplayName/key
    stringShared Addresses/string
    keyhostname/key
    stringldap://127.0.0.1:389/string
    keyid/key
    stringpublic/string
    keyisAddressBook/key
    stringYES/string
    /dict
    dict
    keyCNFieldName/key
    stringcn/string
    keyIDFieldName/key
    stringcn/string
    keyUIDFieldName/key
    stringcn/string
    keybaseDN/key
    stringou=Group,dc=xx,dc=xxx/string
    keybindDN/key
    stringcn=Manager,dc=x,dc=xxx/string
    keybindPassword/key
    stringxx/string
    keycanAuthenticate/key
    stringYES/string
    keydisplayName/key
    stringShared Addresses/string
    keyhostname/key
    stringldap://127.0.0.1:389/string
    keyid/key
    stringpublic/string
    keyisAddressBook/key
    stringYES/string
    /dict
    /array
    keySOGoVacationEnabled/key
    stringYES/string
    /dict
/dict
/plist






 
Regard's

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

Re: [SOGo] LDAP GROUP ADDRESS is not showing in contact.list

2013-04-25 Thread Jean Raby

On 13-04-25 8:08 AM, Ravi Kanchan wrote:

Hi,

I have configured the SOGO. The user email is showing in list but group mail
address is not showing there.can anyone helpme. my sogo configuration is given
below.

Start by using a different 'id' for each address book.

--
Jean Raby
jr...@inverse.ca  ::  +1.514.447.4918 (x120) ::  www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence 
(www.packetfence.org)

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


Re: [SOGo] LDAP GROUP ADDRESS is not showing in contact.list

2013-04-25 Thread Ravi Kanchan
Thank you Jean for your quick response. My problem has resolved.



 
Regard's

Ravi Kanchan Sharma
Sr. System Administrator
Infinite Computer Solutions (I) Ltd. Bglr.
Mo. 9997154666
 


 From: Jean Raby jr...@inverse.ca
To: users@sogo.nu 
Sent: Thursday, 25 April 2013 6:13 PM
Subject: Re: [SOGo] LDAP GROUP ADDRESS is not showing in contact.list
 

On 13-04-25 8:08 AM, Ravi Kanchan wrote:
 Hi,

 I have configured the SOGO. The user email is showing in list but group mail
 address is not showing there.can anyone helpme. my sogo configuration is given
 below.
Start by using a different 'id' for each address book.

-- 
Jean Raby
jr...@inverse.ca  ::  +1.514.447.4918 (x120) ::  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] Google calendars

2013-04-25 Thread Marcio Merlone

Em 09-12-2012 07:31, Martin Krpata escreveu:
i have added google calendar - ical private address from settings 
(google calendar, settings, name of calendar, private address ical - 
copy, sogo - add remote calendar), but i cannot write trough sogo new 
event.
Neděle, 9 Prosinec, 2012 00:51 CET, James James jre...@gmail.com 
napsal:
I was wondering if there is a way in SOGo to add, in a read/write 
access, a google calendar ? If it is impossible, is that will be a 
feature in the next releases ?


By doing so I am able to see my personal appointments on SOGo web 
interface (I am not interested in write access), but they did not show 
up on TB with sogo-integrator neither they show up as busy for others. I 
have checked the option Include in free-busy on calendar properties, 
but no luck. Am I missing something? Should this work or is a planned 
feature?


--
*Marcio Merlone*
TI - Administrador de redes

*A1 Engenharia - Unidade Corporativa*
Fone:   +55 41 3616-3797
Cel:+55 41 9689-0036

http://www.a1.ind.br/ http://www.a1.ind.br
--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Cleanup of deleted contacts in the database

2013-04-25 Thread krasnojarsk
I added a lot of contacts to the addressbook of a user, then I deleted them. In
the database I can see, that the items are still there but flagged as deleted.

My question is, is there a cleanup process, that removes those deleted items
someday or do I have to manually write one or am I completely wrong about the
function?

Cheers

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


Re: [SOGo] Cleanup of deleted contacts in the database

2013-04-25 Thread Stephen Ingram
On Thu, Apr 25, 2013 at 9:12 AM, krasnoja...@gmx.de wrote:

 I added a lot of contacts to the addressbook of a user, then I deleted
 them. In
 the database I can see, that the items are still there but flagged as
 deleted.

 My question is, is there a cleanup process, that removes those deleted
 items
 someday or do I have to manually write one or am I completely wrong about
 the
 function?


You can use sogo-tool to backup the user. A restore will remove the deleted
contacts.

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

Re: [SOGo] Lightning using the last email, again!

2013-04-25 Thread Igor Vitorac

I have opened new bug for Lightning:
https://bugzilla.mozilla.org/show_bug.cgi?id=865726

Please add your comments (or votes) there if you have the same issues.
I think SOGo should not list Mozilla Lightning - Official release 
1.9.1 as supported version if it can not support multiple user emails.


BTW, I have tested TB ESR 10.0.10 + Lightning 1.2.3 with SOGo 2.0.4b and 
I have not found this issue.


During the test, I have noticed one interesting thing. Older Lightning 
versions were not able to accept Event invitations if TB user was not 
invited. With latest TB ESR/Lightning, user can respond to ANY (?) 
invitation if it finds it in Inbox or any other mail folder! Having this 
in mind, I don't know if CalDAV server still needs to send all emails to 
CalDAV client (Lightning), since Lightning will accept everything.


Regards,
Igor



Igor Vitorac wrote, On 19/04/2013 09:32:
According to the CalDAV standard, is server supposed to send all 
emails or just primary?
I am trying to figure out where the problem resides. SOGo side or 
Lightning side?


Thanks,
Igor



Igor Vitorac wrote, On 18/04/2013 16:22:
It seems that latest Lightning (1.9.1) has again problem with Invitee 
email address. Or could it be SOGo (2.0.4b)?
I can remember that there was such problem in previous Lightning 
versions.


- I have 2 emails defined in TB:
my_n...@example.be (this one is primary and defined as email in 
Calendar properties)

my_n...@example.com

- I have both email defined in SOGo SQL user source, so SOGo is aware 
of both.

- My SOGo is installed at sogo.example.com

- Email address defined in calendar properties in Lightning is 
my_n...@example.be


Problem:
- When I create event and I want to invite somebody, I can see that 
my address is displayed as my_n...@example.com (last email) in 
invitee list.
- When I receive email invitation from somebody else, Lightning will 
respond again with wrong email my_n...@example.com (last one)


New test:
- Then I removed my_n...@example.com (last email) from my profile in 
sogo user source, so only one has left my_n...@example.be. Cleared 
memcached; started TB/Lightning and Lightning was showing correctly 
email address (my_n...@example.be) !


So, seems that SOGo is sending both emails (my_n...@example.be and 
my_n...@example.com ) to Lightning and Lightning is using only the 
last one (for sending invitations and for responding to invitations).


These are very similar bugs that :
https://bugzilla.mozilla.org/show_bug.cgi?id=539916
https://bugzilla.mozilla.org/show_bug.cgi?id=540410
but seems that Lightning now displays always option to Accept/Decline 
invitation, however behavior with invitee email address is back again.


Does anybody have the similar scenario?

Thanks,
Igor







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


[SOGo] Install Sogo on CentOS 6.4 with Directadmin

2013-04-25 Thread george h
Hallo,

I have been tried to install SOGO on CentOS 6.4 (Final) following your 
instructions at: 
http://www.sogo.nu/english/support/faq/article/how-to-install-sogo-and-sope-through-yum-1.html
 and I get the following dependency error. I am not sure why this is happening 
I have httpd installed and running on my CentOS, the only difference is that I 
have directadmin also setup and running in that machine.

-- Processing Dependency: httpd for package: sogo-2.0.5a-1.centos6.x86_64
--- Package sope49-mime.x86_64 0:4.9-20130416_1664.el6.1 will be installed
--- Package xmlsec1.x86_64 0:1.2.16-2.el6 will be installed
--- Package xmlsec1-openssl.x86_64 0:1.2.16-2.el6 will be installed
-- Running transaction check
--- Package gnustep-filesystem.noarch 0:2.6.2-1.el6 will be installed
--- Package sogo.x86_64 0:2.0.5a-1.centos6 will be installed
-- Processing Dependency: httpd for package: sogo-2.0.5a-1.centos6.x86_64
-- Finished Dependency Resolution
Error: Package: sogo-2.0.5a-1.centos6.x86_64 (sogo-rhel6)
           Requires: httpd
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

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

Re: [SOGo] Meego Caldav | '{DAV:}getlastmodified' has no matching SQL field

2013-04-25 Thread mourik jan heupink

Hi Christian, list,


This appointment is correct.

This is already nice to know, because I started to doubt everything. :-)


It also uses RDATE in the Timezone definition.
This is not jet supported by SOGo.
See Bug #2179
http://www.sogo.nu/bugs/bug_view_advanced_page.php?bug_id=2179
I should have searched the bugzilla, thanks for pointing that bug out. 
This is also nice to know. :-)



But why don't you add this web calendar directly on the N9.
I took the caldav url directly from the webinterface. (Caldav URL from 
'links to this calendar') I'm guessing that's what you mean?



I realise this list is about SOGo and not about the N9, therefore my
question is: Are there other people here using the N9/Meego/Harmattan
with SOGo, and how are your experiences? Do you observe the same two
issues/problems or not?



Sorry, don't have one :-)

I still hope that someone else responds who has one... :-)

As it stands now, the issue 2 (imported ics files not showing up on the 
N9) is still unclear.


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


[SOGo] BTS activities for Thursday, April 25 2013

2013-04-25 Thread SOGo reporter
Title: BTS activities for Thursday, April 25 2013





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Thursday, April 25 2013

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
2302
	2013-04-25 08:45:18
	closed (wont fix)
	SOPE
	Unable to login in to sogo web page