Re: [SOGo] Unable to subscribe user to a calendar
Dne 21.6.2012 10:01, Christian Mack napsal(a): LDAP query - example user === [root@fs Defaults]# ldapsearch -x '(uid=pdobes)' # extended LDIF # # LDAPv3 # basedc=getnet,dc=cz (default) with scope subtree # filter: (uid=pdobes) # requesting: ALL # # pdobes, People, getnet.cz dn: uid=pdobes,ou=People,dc=getnet,dc=cz givenName: Pavel sn: Dobes loginShell: /bin/bash gidNumber: 501 uidNumber: 501 mail: pdo...@getnet.cz objectClass: top objectClass: person objectClass: organizationalPerson objectClass: inetorgperson objectClass: posixAccount objectClass: posixgroup uid: pdobes cn: pdobes homeDirectory: /home/pdobes # search result search: 2 result: 0 Success # numResponses: 2 # numEntries: 1 Why has your user objectClass: posixgroup ? SOGo will try to expand that group, but there are no members in it, so it will not work. Kind regards, Christian Mack Hello Christian, I removed the objectClass: posixgroup for every user and everything started working. I need every user to have its own group because of the file group ownership. It's the default scheme in CentOS/RedHat systems. I might change that in the future in our systems. I created a separate group(including objectClass: posixgroup) for each user under Groups(in LDAP) and for sure I added this particular user as a memeber. Really thank you for your help. Just one remark - in SOGo 1.3.5a the calendar sharing worked even if the user in LDAP had both posix objects. Something has changed in SOGo. As I said the sharing works fine now but the message WARNING(-[NSNull(misc) length]): called NSNull -length (returns 0) !!! still apeears in the log right after invoking the Sharing window. The same message I get when opening Calendar Properties or displaying events in Calendar - one error message per event in the calendar - for example 4 events in the week view result in 4 error messages, 6 events in the month view produce 6 error messages. I can't see any malfunction now except the messages. Is there any way to trace the errors? Thank you, Michal -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Problems with synchronization between SOGo and Outlook using Funambol – national characters
] [192.168.253.5] [fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [sogo-cal] must secure? false [2012-08-09 15:00:09,375] [funambol.sogo] [INFO] [2BD7E5531E5744050195066EE3980614] [192.168.253.5] [fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [sogo-cal] About to convert vCalendar (from v2 to v1): BEGIN:VCALENDAR VERSION:2.0 BEGIN:VTIMEZONE TZID:Europe/Prague BEGIN:DAYLIGHT DTSTART:20110327T02 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=3 TZOFFSETFROM:+0100 TZOFFSETTO:+0200 TZNAME:Europe/Prague END:DAYLIGHT BEGIN:STANDARD DTSTART:20111030T03 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=10 TZOFFSETFROM:+0200 TZOFFSETTO:+0100 TZNAME:Europe/Prague END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:F2F2EB8CB69BAC46AEAC67C530AC59C2E4062000 SUMMARY:Test from Outlook ?š??žýáíé DESCRIPTION:Event contents LOCATION: CATEGORIES: CLASS:PUBLIC DTSTART;TZID=Europe/Prague:20120808T113000 DTEND;TZID=Europe/Prague:20120808T12 PRIORITY:5 STATUS:0 X-FUNAMBOL-FOLDER:DEFAULT_FOLDER X-FUNAMBOL-ALLDAY:0 X-FUNAMBOL-FOLDER:DEFAULT_FOLDER X-MICROSOFT-CDO-BUSYSTATUS:2 X-MICROSOFT-CDO-REPLYTIME: X-FUNAMBOL-BILLINGINFO: X-FUNAMBOL-COMPANIES: X-FUNAMBOL-MILEAGE: X-FUNAMBOL-NOAGING:0 END:VEVENT END:VCALENDAR ... [2BD7E5531E5744050195066EE3980614] [192.168.253.5] [fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [sogo-cal] BEGIN:VCALENDAR VERSION:1.0 TZ:+0100 DAYLIGHT:TRUE;+0200;20110327T02;20111030T03;Europe/Prague;Europe/Prague DAYLIGHT:TRUE;+0200;20120325T02;20121028T03;Europe/Prague;Europe/Prague DAYLIGHT:TRUE;+0200;20130331T02;20131027T03;Europe/Prague;Europe/Prague DAYLIGHT:TRUE;+0200;20140330T02;20141026T03;Europe/Prague;Europe/Prague BEGIN:VEVENT UID:F2F2EB8CB69BAC46AEAC67C530AC59C2E4062000 SUMMARY;ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8:Test from Outlook ?=C5=A1??=C5=BE=C3=BD=C3=A1=C3=AD=C3=A9 DESCRIPTION:Event contents LOCATION: CATEGORIES: CLASS:PUBLIC DTSTART:20120808T093000Z DTEND:20120808T10Z PRIORITY:2 STATUS:0 X-FUNAMBOL-FOLDER:DEFAULT_FOLDER X-FUNAMBOL-ALLDAY:0 X-FUNAMBOL-FOLDER:DEFAULT_FOLDER X-FUNAMBOL-FOLDER:DEFAULT_FOLDER X-MICROSOFT-CDO-BUSYSTATUS:2 X-MICROSOFT-CDO-REPLYTIME: X-FUNAMBOL-BILLINGINFO: X-FUNAMBOL-COMPANIES: X-FUNAMBOL-MILEAGE: X-FUNAMBOL-NOAGING:0 END:VEVENT END:VCALENDAR [2012-08-09 15:00:09,403] [funambol.handler] [INFO] [2BD7E5531E5744050195066EE3980614] [192.168.253.5] [fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [] moving to state: STATE_PKG1_RECEIVING [2012-08-09 15:00:09,405] [funambol.transport.http] [INFO] [2BD7E5531E5744050195066EE3980614] [192.168.253.5] [fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [] Request processed Does anybody know where the mistake happens or what to change to avoid the mistake? Thank you, Michal Kminek -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo 2.0 ZEG strange timezone behavior
I had problems with all-day events created by MS Outlook using the MS Exchange connection on my SOGo server. Therefore I decided to test it on the latest ZEG edition but the problem persist. I setup SOGo, system and Windows to use the same timezone in ZEG. I found a strange behavior - if the timezone is GMT or any other GMT +h zone then all all-day events created with MS Outlook (2007, 2010) go one day back in the web interface. For example if I create an all-day event to happen on 25th Oct in Outlook it is displayed as an all-day event on 24th Oct in SOGo. If I setup the time zone as any GMT -h zone everything works fine. Regards, Michal Kminek -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo 2.0 ZEG strange timezone behavior
Hi, do you have correctly set your time zone in ZEG system and in SOGo? You can adjust the ZEG system time zone by running the following command (it's interractive): sudo dpkg-reconfigure tzdata the default password is sogo Modify the SOGo time zone too: sudo service sogo stop defaults write sogod SOGoTimeZone Europe/Prague sudo service sogo start Use your time zone name you have set in previous step. Just to share the experience, what Windows do you use and what MS Outlook version? Regards, Michal Dne 17.10.2012 12:56, Burkart Orlowski | Onlinehelp24 napsal(a): Almost the same for me. An all-day event is shown over 2 days in the web interface but is correctly displayed in Thunderbird. If I create an all-day event for the 16th Oct it is shown on the 16th and on the 17th Oct in the web interface. Any help is appreciated, Burkart Orlowski On 10/09/2012 03:13 PM, Michal Kminek wrote: I had problems with all-day events created by MS Outlook using the MS Exchange connection on my SOGo server. Therefore I decided to test it on the latest ZEG edition but the problem persist. I setup SOGo, system and Windows to use the same timezone in ZEG. I found a strange behavior - if the timezone is GMT or any other GMT +h zone then all all-day events created with MS Outlook (2007, 2010) go one day back in the web interface. For example if I create an all-day event to happen on 25th Oct in Outlook it is displayed as an all-day event on 24th Oct in SOGo. If I setup the time zone as any GMT -h zone everything works fine. Regards, Michal Kminek -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
Have you installed any mysql driver in /opt/Funambol/tools/tomcat/lib/? provide contents ls -l /opt/Funambol/tools/tomcat/lib/ you should have something like mysql-connector-java-5.1.22-bin.jar there. Michal Dne 18.10.2012 11:52, Devinder Singh napsal(a): Thanks Mayak, Just would like to add that Apple sync works as well on IOS 6 version. I tried syncing with IOS 4 version on TAB and IPhone it did not work untill I upgraded to newer versions. Not sure if you are also looking toward building the backward compatibility. However, I am facing issue while installing the Funambol with SOGo connector. I am following guidelines as given in the installation document. But receiving below error BUILD FAILED /opt/Funambol/ds-server/install/install.xml:238: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:120: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:168: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:240: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:284: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:358: Class Not Found: JDBC driver com.mysql.jdbc.Driver could not be loaded _Install Property settings __ _ jdbc.classpath=/opt/Funambol/tools/tomcat/lib/mysql-connector-java-5.1.13-bin.jar jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/funambol_sogo?characterEncoding=UTF-8 jdbc.user=mail jdbc.password=mail modules-to-install=content-provider-10.0.0,email-connector-10.0.0,foundation-10.0.0,phones-support-10.0.0,webdemo-10.0.0,funambol-sogo-1.0.9 Kindly guide what could be reason ? Is their a Funambol Setup with SOGo connector configured ? Thanks Regards, Devinder Singh Birdi On 10/18/2012 2:46 PM, mayak-cq wrote: On Wed, 2012-10-17 at 16:15 +0530, Devinder Singh wrote: Hi All, Just wanted to let you all know that Mobile Sync with Z-push Activsync was successful with the below php library. https://github.com/xbgmsharp/sogosync 1. Android Based phones - Native Support for 2 way sync with Calendards, Tasks and Address Book 2. Apple IOS TAB and IPhone - Native Support for 2 way sync for Calendards and Tasks.One way sync with Address Book to Apple IOS. Need to figure out further on Carddav integration issue with Apple IOS. I would recommend SOGo team to do further Testing and recommend this method as well on the below url. http://www.sogo.nu/english/downloads/frontends.html Did anyone try it on Blackberry or we can only sync through Funambol ? Looking forward to your reply. -- Thanks Regards, Devinder Singh Birdi hi devinder, thanks for your report :-) One way sync with Address Book to Apple IOS. i'm getting the same thing apple and contacts -- keeping my fingers crossed for a fix as for BB -- only funambol is working now -- i have not tried astrasync sync against z-push and sogo. when rim gets around to releasing their new phone, and if they remain in business, the new version will natively support actyivesync (exchange) for the first time. cheers m -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
Maybe you should update your config jdbc.classpath=/opt/Funambol/tools/tomcat/lib/mysql-connector-java-5.1.13-bin.jar isn't the listed file Dne 18.10.2012 12:28, Devinder Singh napsal(a): Hi Michael, Yes the file do exists. ls -l /opt/Funambol/tools/tomcat/lib/ | grep mysql -rw-rw-r-- 1 root root 832960 Sep 6 05:51 mysql-connector-java-5.1.22-bin.jar Any other reasons ? Thanks Regards, Devinder Singh Birdi On 10/18/2012 3:37 PM, Michal Kminek wrote: Have you installed any mysql driver in /opt/Funambol/tools/tomcat/lib/? provide contents ls -l /opt/Funambol/tools/tomcat/lib/ you should have something like mysql-connector-java-5.1.22-bin.jar there. Michal Dne 18.10.2012 11:52, Devinder Singh napsal(a): Thanks Mayak, Just would like to add that Apple sync works as well on IOS 6 version. I tried syncing with IOS 4 version on TAB and IPhone it did not work untill I upgraded to newer versions. Not sure if you are also looking toward building the backward compatibility. However, I am facing issue while installing the Funambol with SOGo connector. I am following guidelines as given in the installation document. But receiving below error BUILD FAILED /opt/Funambol/ds-server/install/install.xml:238: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:120: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:168: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:240: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:284: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:358: Class Not Found: JDBC driver com.mysql.jdbc.Driver could not be loaded Install Property settings jdbc.classpath=/opt/Funambol/tools/tomcat/lib/mysql-connector-java-5.1.13-bin.jar jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/funambol_sogo?characterEncoding=UTF-8 jdbc.user=mail jdbc.password=mail modules-to-install=content-provider-10.0.0,email-connector-10.0.0,foundation-10.0.0,phones-support-10.0.0,webdemo-10.0.0,funambol-sogo-1.0.9 Kindly guide what could be reason ? Is their a Funambol Setup with SOGo connector configured ? Thanks Regards, Devinder Singh Birdi -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Mobile Sync with Z-Push Activsync Successful
When this error occurs? During Funambol start? I would recommend reviewing SOGo Installation Guide - Funambol chapter. Make sure you have followed every step including install-modules command. Funambol is a big package, very self-sufficient as it includes its own Java RE. Check also file rights. Michal Dne 18.10.2012 13:20, Devinder Singh napsal(a): Thanks Michael, Agree that was the issue. I was able to proceed further. However, now Create Table fails the build. [sql] Failed to execute:create table fnbl_email_cache ( guid varchar(200) binary not null, source_uri varchar(128) binary not null, principal bigint not null, last_crc bigint, invalidchar, internal char, messageid varchar(700) binary, headerdate varchar(20) binary, received varchar(20) binary, subjectvarchar(700) binary, sender varchar(300) binary, isemailchar, constraint pk_cache primary key (guid, source_uri, principal), constraint fk_principal_email_cache foreign key (principal) references fnbl_principal (id) on delete cascade )ENGINE = InnoDB CHARACTER SET utf8 BUILD FAILED /opt/Funambol/ds-server/install/install.xml:238: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:120: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:168: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:240: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:285: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:369: java.sql.SQLException: Can't create table 'funambol_sogo.fnbl_email_cache' (errno: 150) When googled for ErrNo 150 found that we cannot create Foreign Key on Table columns not existing and I guess this is correct functionality by Mysql. Any idea how to resolve or which files we can correct these queries ? Thanks Regards, Devinder Singh Birdi On 10/18/2012 4:04 PM, Michal Kminek wrote: Maybe you should update your config jdbc.classpath=/opt/Funambol/tools/tomcat/lib/mysql-connector-java-5.1.13-bin.jar isn't the listed file Dne 18.10.2012 12:28, Devinder Singh napsal(a): Hi Michael, Yes the file do exists. ls -l /opt/Funambol/tools/tomcat/lib/ | grep mysql -rw-rw-r-- 1 root root 832960 Sep 6 05:51 mysql-connector-java-5.1.22-bin.jar Any other reasons ? Thanks Regards, Devinder Singh Birdi On 10/18/2012 3:37 PM, Michal Kminek wrote: Have you installed any mysql driver in /opt/Funambol/tools/tomcat/lib/? provide contents ls -l /opt/Funambol/tools/tomcat/lib/ you should have something like mysql-connector-java-5.1.22-bin.jar there. Michal Dne 18.10.2012 11:52, Devinder Singh napsal(a): Thanks Mayak, Just would like to add that Apple sync works as well on IOS 6 version. I tried syncing with IOS 4 version on TAB and IPhone it did not work untill I upgraded to newer versions. Not sure if you are also looking toward building the backward compatibility. However, I am facing issue while installing the Funambol with SOGo connector. I am following guidelines as given in the installation document. But receiving below error BUILD FAILED /opt/Funambol/ds-server/install/install.xml:238: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:120: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:168: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:240: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:284: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:358: Class Not Found: JDBC driver com.mysql.jdbc.Driver could not be loaded Install Property settings jdbc.classpath=/opt/Funambol/tools/tomcat/lib/mysql-connector-java-5.1.13-bin.jar jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/funambol_sogo?characterEncoding=UTF-8 jdbc.user=mail jdbc.password=mail modules-to-install=content-provider-10.0.0,email-connector-10.0.0,foundation-10.0.0,phones-support-10.0.0,webdemo-10.0.0,funambol-sogo-1.0.9 Kindly guide what could be reason ? Is their a Funambol Setup with SOGo connector configured ? Thanks Regards, Devinder Singh Birdi -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Native Outlook connection
You perform nslookup to find a record matching _ldap._tcp.dc._msdcs.airwerk.net but you have only _autodiscover._tcp.airwerk.net in your zone file. Michal Dne 13.12.2012 11:50, werdi4...@gmail.com napsal(a): nslookup airwerk.net : Server: UnKnown Address: 192.168.40.2 If I do nslookup | set type=SRV | _ldap._tcp.dc._msdcs.airwerk.net : Server: UnKnown Address: 192.168.40.2 *** _ldap._tcp.dc._msdcs.airwerk.net cannot be found by UnKnown: Non-existent domain The Address 192.168.40.2 is the address of the networks nameserver. My DNS structure was actually fine by now, but I'm not sure anymore. A ping to the Sogo Server remote.airwerk.net results in the Sogo Server's IP 192.168.40.1 ... This is db.airwerk.net : $TTL86400 @ IN SOA airwerk.net. dirk.airwerk.com. ( 2012100401 ; Serial no., based on date 3600 ; Refresh after 6 hours 3600 ; Retry after 1 hour 86400 ; Expire after 7 days 3600 ) ; Minimum TTL of 1 hour ; IN NS remote.airwerk.net. xmail IN A 192.168.40.3 remote IN A 192.168.40.1 @ IN MX 10 xmail.airwerk.net. mailIN CNAME xmail _autodiscover._tcp.airwerk.net. SRV 0 0 443 remote.airwerk.net. Anything obscure in there? -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo - expire-autoreply in systems with dovecot
Thanks, Florian. That was exactly what I needed.
Michal
Dne 17.9.2013 18:24, Florian GRUEL napsal(a):
With dovecot I got a similar problem solved by adding to
/etc/dovecot/dovecot.master the folowing :
sogo:{SHA}encriptedpasswd
and adding to /etc/dovecot/dovecot.conf
auth_master_user_separator = *
passdb passwd-file {
args = /etc/dovecot/dovecot.master
master=yes
}
following this instructions :
http://wiki.dovecot.org/Authentication/MasterUsers
Hope this help
*Florian GRUEL*
**
Message original
*Sujet: *[SOGo] SOGo - expire-autoreply in systems with dovecot
*De : *Michal Kminek mkmi...@getnet.cz
*Pour : *users@sogo.nu
*Date : *17/09/2013 17:25
Hi,
I have a problem with expire-autoreply when using sogo-tool. The
vacation autoreply works but I can't setup expiration of the autoreply.
There is a line in /etc/cron.d/sogo
0 0 * * * sogo/usr/sbin/sogo-tool expire-autoreply -p
/etc/sogo/sieve.creds
Some sieve admin credentials are expected in sieve.creds file but I
do not have any sieve admin in my system.
The script above works if I put name:password of an existing user
into the file. Then it works for the user but I need it for every
user. Maybe a different approach should be used. Rather the sieve
admin is defined only in cyrus-imap system. Has anybody any
experience with that?
Thanks,
Michal
My system is CentOS 6.4 x86_64 and I have installed the following
packages from ATRPMS repo
dovecot-pigeonhole-0.4.1-30.el6.x86_64
dovecot-2.2.5-2_140.el6.x86_64
dovecot-managesieve-0.4.1-30.el6.x86_64
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] SOGo - expire-autoreply in systems with dovecot
Dne 17.9.2013 18:34, Szládovics Péter napsal(a):
2013-09-17 17:25 keltezéssel, Michal Kminek írta:
Hi,
I have a problem with expire-autoreply when using sogo-tool. The
vacation autoreply works but I can't setup expiration of the autoreply.
There is a line in /etc/cron.d/sogo
0 0 * * * sogo/usr/sbin/sogo-tool expire-autoreply -p
/etc/sogo/sieve.creds
Some sieve admin credentials are expected in sieve.creds file but I
do not have any sieve admin in my system.
The script above works if I put name:password of an existing user
into the file. Then it works for the user but I need it for every
user. Maybe a different approach should be used. Rather the sieve
admin is defined only in cyrus-imap system. Has anybody any
experience with that?
Thanks,
Michal
My system is CentOS 6.4 x86_64 and I have installed the following
packages from ATRPMS repo
dovecot-pigeonhole-0.4.1-30.el6.x86_64
dovecot-2.2.5-2_140.el6.x86_64
dovecot-managesieve-0.4.1-30.el6.x86_64
Hi Michal,
Have you got these settings below in dovecot?
passdb {
driver = passwd-file
args = /etc/sogo/sieve.creds
master = yes
pass = yes
}
The dovecot master user(~ sieve admin) was the solution, as you showed
above.
Thank you Péter
Michal
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] sogo apt repository breaking sssd on wheezy (libldb1)
Hi MJ, The same problem is on CentOS 6, simply the sssd is dependent on samba4 libs that are different from the libs from the SOGo repo. I tried to use LDAP authorization only but I run into difficulties and after reading several articles and several attempts I gave up. I don't want to recompile the sssd and I need the regular updates to reduce the maintenance effort. I tried downloading the ZEG then converting the appliance for KVM using qemu-convert and running the appliance with the updated configuration. Regards Michal Dne 23.1.2014 17:29, mourik jan heupink napsal(a): Hi all, On a test machine I'm running wheezy with samba4/sssd. I wanted to test SOGo authentication etc, so i added the regular sogo repository. Then (without yet installing sogo) I do apt-get update apt-get upgrade, and: root@debian72:/var/www# apt-get upgrade Reading package lists... Done Building dependency tree Reading state information... Done The following packages will be upgraded: libldb1 libtevent0 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 167 kB of archives. If I run these two updates, I end up with a newer version of libldb1 (1:1.1.13-1 vs 1:1.1.6-1) which basically breaks the stock sssd: root@debian72:/etc# /etc/init.d/sssd restart ldb: module version mismatch in ../src/ldb_modules/memberof.c : ldb_version=1.1.13 module_version=1.1.6 ldb: failed to initialise module /usr/lib/x86_64-linux-gnu/ldb/modules/ldb/memberof.so : Unavailable [FAIL] Starting System Security Services Daemon: sssd failed! root@debian72:/etc# So I don't know if this is a bug that should be added to bugzilla (let me know if I should do this) but I'm sending this here mainly as a heads-up to all of you. Regards, MJ -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v2.3.1
Dne 31.7.2015 v 18:25 Ben napsal(a): I nominate adding the database schema upgrade script to the deb and rpm install/upgrade scripts. It would need to detect the current db schema version and apply the appropriate db updates. Which it surely does already... That automation alone would probably reduce friction by 5%. It is not that easy. It first would have to scan your config, in order to find which DBMS you use. Some are even using multiple DBs. I think it would be relatively straight-forward and avoid lots of upgrade confusion for SOGo to store in the db the db schema version. Then when SOGo starts up and connects to the db, it checks that the db schema version matches the version it is expecting. If it isn't, it throws an error and stops. This forces the admin to read the instructions and do the db backup, run the upgrade script, etc. But it prevents someone from doing a quick upgrade and running a new version SOGo against an old db schema and having weird problems, etc. Ben I also agree. It would be nice if all database changes were applied when upgrading binary packages like rpm. Just imagine a scenario when a new major update is released and installed automatically except its database part and the responsible admin is out somewhere and SOGo stops operating after a service reload. All packages are installed under root user and it means that upgrade scripts can see SOGo configuration and react appropriately. Best regards, Michal Kminek -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v2.3.1
Dne 4.8.2015 v 11:38 Marc Patermann napsal(a): Hi, Am 30.07.2015 um 15:05 Uhr schrieb Chris Coleman: On 7/30/2015 8:57 AM, Christian Mack wrote: Am 30.07.2015 um 14:24 schrieb Márcio Merlone: On 24-07-2015 08:07, Steve Ankeny wrote: The only issues I remember with the running of the script were -- (1) users fail to run it (2) or, they run the wrong script Instructions are *always* at the back pages of the Installation Guide -- http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf (pg 58) Since I run Ubuntu, I assume the install/upgrade procedure from apt already does that, is this correct? No! You have to do that manually. I nominate adding the database schema upgrade script to the deb and rpm install/upgrade scripts. It would need to detect the current db schema version and apply the appropriate db updates. Which it surely does already... That automation alone would probably reduce friction by 5%. whatever is done, remember: The db don't have to be on the same host as the SOGo daemon is! We have i.e. have multiple SOGo frontend server and a postgresql cluster (with pgpool) in the background. Single server scenarios are not all there is. Marc I agree but SOGo always accesses its database using a defined connection from sogo.conf. The same connection can be used to deliver a DB update. It's not important if the database is on the same server. I have no experience with pgpool but I believe any DB update can be delivered too. It would be really helpful if these DB changes come with the corresponding binary packages. Michal -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo Web interface - Refresh view
Hello, I have just one question regarding the SOGo Web Interface. Its Refresh view is set to Every 5 minutes. The Mail module works good and new emails appear within the given period, but the Refresh works partially in the Calendar. New events regularly appear in the Events list only and not in the month or week view. Tested in IE, Firefox and Chrome. Has anybody else the same experience? Regards Michal Kminek -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo Web interface - Refresh view
Dne 12.10.2016 v 17:07 Francis Lachapelle (flachape...@inverse.ca) napsal(a): Hello Michal On Oct 12, 2016, at 6:38 AM, Michal Kminek (mkmi...@getnet.cz) <users@sogo.nu> wrote: Hello, I have just one question regarding the SOGo Web Interface. Its Refresh view is set to Every 5 minutes. The Mail module works good and new emails appear within the given period, but the Refresh works partially in the Calendar. New events regularly appear in the Events list only and not in the month or week view. Tested in IE, Firefox and Chrome. Has anybody else the same experience? We were simply not refreshing the calendar view. Now we do¹. [1] https://github.com/inverse-inc/sogo/commit/c50c3763b1b5eabcff25c57c030964d075e0f648 Good job. Thank you, Michal -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo Calendar Resources | Free/Busy Times
Hi Irma,
we use LDAP for users and resources. Just to comment some entries,
Multiplebookings attribute works as expected the resource can be booked
only once if set to 1, free/busy is shown correctly.
We use mailgroup class so that our resource can have its own email
address, the email address is fictitious. With mailgroup class comes
email attribute. Additionally our resource is located in the same tree
(ou=People,dc=example,dc=com) as the other users. As a result when
creating a new event with the resource as a participant we get a hint
(name of the resource) after writing first three letters (Mee...). It's
given by the fact that SOGo offers hints only from the first configured
LDAP resource in sogo.conf. It works in SOGo web interface and in
Thunderbird with SOGo Integrator.
The calendar has set the following right "View Time and Date" for "All
Authenticated Users".
Here is our LDAP entry - LDIF:
dn: cn=Meeting Room,ou=People,dc=example,dc=com
Multiplebookings: 1
Kind: location
cn: Meeting Room
objectClass: top
objectClass: person
objectClass: organizationalPerson
objectClass: calendarresource
objectClass: calEntry
objectClass: account
objectClass: mailgroup
mail: meetingro...@example.com
sn: meetingrooom
uid: meetingrooom
userPassword:
parentid: 4
creatorsname: cn=directory manager
nsuniqueid: 741f2031-e1b221e6-81e6eeab-baae8424
entryid: 106
hassubordinates: FALSE
entrydn: cn=Meeting Room,ou=People,dc=example,dc=com
numsubordinates: 0
subschemasubentry: cn=schema
modifiersname: cn=directory manager
Kind Regards,
Michal
Dne 30.10.2018 v 14:37 Rene Schroth (rene.schr...@mmlab.de) napsal(a):
Approved that it is an LDAP issue:
- Removed objectClasses calEntry and CalendarResource from
Meetingroom's LDAP set.
- Result: Free/Busy times are being displayed during event creation!
Again the question: Is there anybody with a working LDAP resources
setup who could provide a sample LDIF of a resource?
Thank you!
BR
Irma
My resources' Free/Busy times still won't work.
For normal users, Free/Busy times work fine!
Here's more detail about the configurations.
(1) Resource 'meetingroom' created in LDAP, resides in the same OU as
the normal users. Has same objectClasses and attributes as normal user
accounts PLUS objectClasses 'calEntry' and 'CalendarResource' with
their attributes [values] 'Kind' [location] and 'Multiplebookings'
[1]. Meetingroom's full LDAP set:
#
dn:
mail=meetingr...@mycompany.com,ou=Users,domainName=mycompany.com,o=domains,dc=mycompany,dc=com
mail: meetingr...@mycompany.com
mailQuota: 1048576
objectClass: inetOrgPerson
objectClass: organizationalPerson
objectClass: mailUser
objectClass: shadowAccount
objectClass: amavisAccount
objectClass: person
objectClass: posixAccount
objectClass: top
objectClass: calEntry
objectClass: CalendarResource
storageBaseDirectory: /data/mboxes
enabledService: indexer-worker
enabledService: doveadm
enabledService: dsync
enabledService: shadowaddress
enabledService: displayedInGlobalAddressBook
enabledService: mail
enabledService: forwarding
enabledService: deliver
enabledService: lda
enabledService: lmtp
enabledService: smtp
enabledService: smtpsecured
enabledService: imap
enabledService: imapsecured
enabledService: imaptls
enabledService: managesieve
enabledService: managesievesecured
enabledService: sogo
enabledService: sieve
enabledService: sievesecured
enabledService: forward
enabledService: senderbcc
enabledService: recipientbcc
enabledService: internal
enabledService: lib-storage
amavisLocal: TRUE
accountStatus: active
shadowLastChange: 0
mailHost: localhost
cn: Meetingroom
gidNumber: 2104
homeDirectory: /data/mboxes/vmail1/mycompany.com/meetingroom/
mailMessageStore: vmail1/mycompany.com/meetingroom/
loginShell: /sbin/nologin
sn: Meetingroom
uid: meetingroom
uidNumber: 2104
userPassword:
{CRYPT}$6$ncaXAOch$FuQ9weAfqMUvbKlsam2X/e13t0cIMrnvz/S7q/XqrWq4xyK
OigNGjMPYuvBvzVYrZRJPEUPatnFlHx5rhz74O1
displayName: Meetingroom
Multiplebookings: 1
Kind: location
###
(2) ACL settings on Meetingroom's SOGo Personal Calendar:
Any Authenticated User:
- Public / View All
- Confidential / View All
- Private / View All
- This person can create objects in my calendar: NOT CHECKED
- This person can erase objects from my calendar: NOT CHECKED
(3) ACL settings on all Testusers' SOGo Personal Calendars:
Any Authenticated User:
- Public / View the Date & Time
- Confidential / View the Date & Time
- Private / View the Date & Time
- This person can create objects in my calendar: NOT CHECKED
- This person can erase objects from my calendar: NOT CHECKED
Scenario:
- Testuser us...@mycompany.com creates event1 on his SOGo Personal
Calendar, inviting testuser us...@mycompany.com and
meetingr...@mycompany.com.
-
Re: [SOGo] SOGo Calendar Resources | Free/Busy Times
Hi Irma, It's not important whether you have mailGroup objectClass or not. You need to add any objectClass that contains an email attribute. Just review the objectClasses you mentioned for the email attribute and choose one. Then check all attributes of the objectClasses, some attributes can be mandatory and some are optional. Choose an objectClass ideally with no mandatory attributes or mandatory attributes that already exist in your resource definition (sn, uid, ...) then just add the email attribute. Regards Michal Dne 01.11.2018 v 20:37 Rene Schroth (rene.schr...@mmlab.de) napsal(a): Hi Michal, thank you very much for your reply. Great to know, that generally LDAP calendar resources in SOGo work without restriction. I guess that you do not use the iRedMail OpenLDAP server, because I do and there's no objectClass mailGroup available. My iRedMail OpenLDAP installation provides these mail-related objectClasses: - mailAdmin - mailAlias - mailDomain - mailExternalUser - mailList - mailUser BTW: If you use mailGroup, how do you login with the resource's account into SOGo in order to set the ACL? Are group accounts capable to login to SOGo in your environment? BR Irma ___ Am 31.10.2018 um 13:16 schrieb Michal Kminek (mkmi...@getnet.cz): Hi Irma, we use LDAP for users and resources. Just to comment some entries, Multiplebookings attribute works as expected the resource can be booked only once if set to 1, free/busy is shown correctly. We use mailgroup class so that our resource can have its own email address, the email address is fictitious. With mailgroup class comes email attribute. Additionally our resource is located in the same tree (ou=People,dc=example,dc=com) as the other users. As a result when creating a new event with the resource as a participant we get a hint (name of the resource) after writing first three letters (Mee...). It's given by the fact that SOGo offers hints only from the first configured LDAP resource in sogo.conf. It works in SOGo web interface and in Thunderbird with SOGo Integrator. The calendar has set the following right "View Time and Date" for "All Authenticated Users". Here is our LDAP entry - LDIF: dn: cn=Meeting Room,ou=People,dc=example,dc=com Multiplebookings: 1 Kind: location cn: Meeting Room objectClass: top objectClass: person objectClass: organizationalPerson objectClass: calendarresource objectClass: calEntry objectClass: account objectClass: mailgroup mail: meetingro...@example.com sn: meetingrooom uid: meetingrooom userPassword: parentid: 4 creatorsname: cn=directory manager nsuniqueid: 741f2031-e1b221e6-81e6eeab-baae8424 entryid: 106 hassubordinates: FALSE entrydn: cn=Meeting Room,ou=People,dc=example,dc=com numsubordinates: 0 subschemasubentry: cn=schema modifiersname: cn=directory manager Kind Regards, Michal Dne 30.10.2018 v 14:37 Rene Schroth (rene.schr...@mmlab.de) napsal(a): Approved that it is an LDAP issue: - Removed objectClasses calEntry and CalendarResource from Meetingroom's LDAP set. - Result: Free/Busy times are being displayed during event creation! Again the question: Is there anybody with a working LDAP resources setup who could provide a sample LDIF of a resource? Thank you! BR Irma My resources' Free/Busy times still won't work. For normal users, Free/Busy times work fine! Here's more detail about the configurations. (1) Resource 'meetingroom' created in LDAP, resides in the same OU as the normal users. Has same objectClasses and attributes as normal user accounts PLUS objectClasses 'calEntry' and 'CalendarResource' with their attributes [values] 'Kind' [location] and 'Multiplebookings' [1]. Meetingroom's full LDAP set: # dn: mail=meetingr...@mycompany.com,ou=Users,domainName=mycompany.com,o=domains,dc=mycompany,dc=com mail: meetingr...@mycompany.com mailQuota: 1048576 objectClass: inetOrgPerson objectClass: organizationalPerson objectClass: mailUser objectClass: shadowAccount objectClass: amavisAccount objectClass: person objectClass: posixAccount objectClass: top objectClass: calEntry objectClass: CalendarResource storageBaseDirectory: /data/mboxes enabledService: indexer-worker enabledService: doveadm enabledService: dsync enabledService: shadowaddress enabledService: displayedInGlobalAddressBook enabledService: mail enabledService: forwarding enabledService: deliver enabledService: lda enabledService: lmtp enabledService: smtp enabledService: smtpsecured enabledService: imap enabledService: imapsecured enabledService: imaptls enabledService: managesieve enabledService: managesievesecured enabledService: sogo enabledService: sieve enabledService: sievesecured enabledService: forward enabledService: senderbcc enabledS
Re: [SOGo] SOGo Calendar Resources | Free/Busy Times
Hi Irma, use the email attribute with your resource and use any email address. For me "View Time and Date" for "All Authenticated Users" was sufficient. You can set higher rights for certain users so they can see event details. Regards, Michal Dne 02.11.2018 v 12:06 Rene Schroth (rene.schr...@mmlab.de) napsal(a): Hi Michal, > It's not important whether you have mailGroup objectClass or not I know. Any oC providing the mail attribute is required. >Just > review the objectClasses you mentioned for the email attribute and > choose one. My LDIF has objectClass mailUser and inetOrgPerson. Both of them provide the mail attribute. How do you set the ACL for the resource's calendar in order to make it readable for the other users? BR Irma ___ Am 02.11.2018 um 09:38 schrieb Michal Kminek (mkmi...@getnet.cz): Hi Irma, It's not important whether you have mailGroup objectClass or not. You need to add any objectClass that contains an email attribute. Just review the objectClasses you mentioned for the email attribute and choose one. Then check all attributes of the objectClasses, some attributes can be mandatory and some are optional. Choose an objectClass ideally with no mandatory attributes or mandatory attributes that already exist in your resource definition (sn, uid, ...) then just add the email attribute. Regards Michal Dne 01.11.2018 v 20:37 Rene Schroth (rene.schr...@mmlab.de) napsal(a): Hi Michal, thank you very much for your reply. Great to know, that generally LDAP calendar resources in SOGo work without restriction. I guess that you do not use the iRedMail OpenLDAP server, because I do and there's no objectClass mailGroup available. My iRedMail OpenLDAP installation provides these mail-related objectClasses: - mailAdmin - mailAlias - mailDomain - mailExternalUser - mailList - mailUser BTW: If you use mailGroup, how do you login with the resource's account into SOGo in order to set the ACL? Are group accounts capable to login to SOGo in your environment? BR Irma ___ Am 31.10.2018 um 13:16 schrieb Michal Kminek (mkmi...@getnet.cz): Hi Irma, we use LDAP for users and resources. Just to comment some entries, Multiplebookings attribute works as expected the resource can be booked only once if set to 1, free/busy is shown correctly. We use mailgroup class so that our resource can have its own email address, the email address is fictitious. With mailgroup class comes email attribute. Additionally our resource is located in the same tree (ou=People,dc=example,dc=com) as the other users. As a result when creating a new event with the resource as a participant we get a hint (name of the resource) after writing first three letters (Mee...). It's given by the fact that SOGo offers hints only from the first configured LDAP resource in sogo.conf. It works in SOGo web interface and in Thunderbird with SOGo Integrator. The calendar has set the following right "View Time and Date" for "All Authenticated Users". Here is our LDAP entry - LDIF: dn: cn=Meeting Room,ou=People,dc=example,dc=com Multiplebookings: 1 Kind: location cn: Meeting Room objectClass: top objectClass: person objectClass: organizationalPerson objectClass: calendarresource objectClass: calEntry objectClass: account objectClass: mailgroup mail: meetingro...@example.com sn: meetingrooom uid: meetingrooom userPassword: parentid: 4 creatorsname: cn=directory manager nsuniqueid: 741f2031-e1b221e6-81e6eeab-baae8424 entryid: 106 hassubordinates: FALSE entrydn: cn=Meeting Room,ou=People,dc=example,dc=com numsubordinates: 0 subschemasubentry: cn=schema modifiersname: cn=directory manager Kind Regards, Michal Dne 30.10.2018 v 14:37 Rene Schroth (rene.schr...@mmlab.de) napsal(a): Approved that it is an LDAP issue: - Removed objectClasses calEntry and CalendarResource from Meetingroom's LDAP set. - Result: Free/Busy times are being displayed during event creation! Again the question: Is there anybody with a working LDAP resources setup who could provide a sample LDIF of a resource? Thank you! BR Irma My resources' Free/Busy times still won't work. For normal users, Free/Busy times work fine! Here's more detail about the configurations. (1) Resource 'meetingroom' created in LDAP, resides in the same OU as the normal users. Has same objectClasses and attributes as normal user accounts PLUS objectClasses 'calEntry' and 'CalendarResource' with their attributes [values] 'Kind' [location] and 'Multiplebookings' [1]. Meetingroom's full LDAP set: # dn: mail=meetingr...@mycompany.com,ou=Users,domainName=mycompany.com,o=domains,dc=mycompany,dc=com
Re: [SOGo] SOGo Calendar Resources | Free/Busy Times
Hi Irma, in SOGo you can set a superuser in sogo.conf then under that user you can set rights to any calendar in SOGo Web GUI. Alternatively set a password to your resource and login into its SOGo Web GUI. Kind Regards, Michal Dne 02.11.2018 v 17:14 Rene Schroth (rene.schr...@mmlab.de) napsal(a): Hi Michal, the question was, how are you able to set the ACL, if you cannot login with your resource's account into SOGo Web GUI in order to manipulate the "Sharing" settings. BR Irma ___ Am 02.11.2018 um 16:05 schrieb Michal Kminek (mkmi...@getnet.cz): Hi Irma, use the email attribute with your resource and use any email address. For me "View Time and Date" for "All Authenticated Users" was sufficient. You can set higher rights for certain users so they can see event details. Regards, Michal Dne 02.11.2018 v 12:06 Rene Schroth (rene.schr...@mmlab.de) napsal(a): Hi Michal, > It's not important whether you have mailGroup objectClass or not I know. Any oC providing the mail attribute is required. >Just > review the objectClasses you mentioned for the email attribute and > choose one. My LDIF has objectClass mailUser and inetOrgPerson. Both of them provide the mail attribute. How do you set the ACL for the resource's calendar in order to make it readable for the other users? BR Irma _______ Am 02.11.2018 um 09:38 schrieb Michal Kminek (mkmi...@getnet.cz): Hi Irma, It's not important whether you have mailGroup objectClass or not. You need to add any objectClass that contains an email attribute. Just review the objectClasses you mentioned for the email attribute and choose one. Then check all attributes of the objectClasses, some attributes can be mandatory and some are optional. Choose an objectClass ideally with no mandatory attributes or mandatory attributes that already exist in your resource definition (sn, uid, ...) then just add the email attribute. Regards Michal Dne 01.11.2018 v 20:37 Rene Schroth (rene.schr...@mmlab.de) napsal(a): Hi Michal, thank you very much for your reply. Great to know, that generally LDAP calendar resources in SOGo work without restriction. I guess that you do not use the iRedMail OpenLDAP server, because I do and there's no objectClass mailGroup available. My iRedMail OpenLDAP installation provides these mail-related objectClasses: - mailAdmin - mailAlias - mailDomain - mailExternalUser - mailList - mailUser BTW: If you use mailGroup, how do you login with the resource's account into SOGo in order to set the ACL? Are group accounts capable to login to SOGo in your environment? BR Irma _______ Am 31.10.2018 um 13:16 schrieb Michal Kminek (mkmi...@getnet.cz): Hi Irma, we use LDAP for users and resources. Just to comment some entries, Multiplebookings attribute works as expected the resource can be booked only once if set to 1, free/busy is shown correctly. We use mailgroup class so that our resource can have its own email address, the email address is fictitious. With mailgroup class comes email attribute. Additionally our resource is located in the same tree (ou=People,dc=example,dc=com) as the other users. As a result when creating a new event with the resource as a participant we get a hint (name of the resource) after writing first three letters (Mee...). It's given by the fact that SOGo offers hints only from the first configured LDAP resource in sogo.conf. It works in SOGo web interface and in Thunderbird with SOGo Integrator. The calendar has set the following right "View Time and Date" for "All Authenticated Users". Here is our LDAP entry - LDIF: dn: cn=Meeting Room,ou=People,dc=example,dc=com Multiplebookings: 1 Kind: location cn: Meeting Room objectClass: top objectClass: person objectClass: organizationalPerson objectClass: calendarresource objectClass: calEntry objectClass: account objectClass: mailgroup mail: meetingro...@example.com sn: meetingrooom uid: meetingrooom userPassword: parentid: 4 creatorsname: cn=directory manager nsuniqueid: 741f2031-e1b221e6-81e6eeab-baae8424 entryid: 106 hassubordinates: FALSE entrydn: cn=Meeting Room,ou=People,dc=example,dc=com numsubordinates: 0 subschemasubentry: cn=schema modifiersname: cn=directory manager Kind Regards, Michal Dne 30.10.2018 v 14:37 Rene Schroth (rene.schr...@mmlab.de) napsal(a): Approved that it is an LDAP issue: - Removed objectClasses calEntry and CalendarResource from Meetingroom's LDAP set. - Result: Free/Busy times are being displayed during event creation! Again the question: Is there anybody with a working LDAP resources setup who could provide a sample LDIF of a resource? Thank you! BR Irma ###
Re: [SOGo] Thunderbird 78 Support
Hello Christian, recently I solved something similar but with no luck. My goal was sending Thunderbird as a package or through the GPO in Microsoft Domain. Which way do you distribute Thunderbird to your domain users? Or do you allow users to update Thunderbird in their profile? Regards, Michal Dne 01.12.2020 v 17:16 c...@brain-biotech.de napsal(a): Hello all, slightly different topic. Has anybody successfully deployd the new connector with the GPO Templates of Thunderbird? The xpi is copied here: C:\Program Files\Mozilla Thunderbird\features but not installed. Is this related to the PLugin, to thudnerbird V 78 or to a configuration issue? Regards Christian -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Thunderbird 78 Support
Hello Christian, thank you for the links, I'll check the projects you've mentioned. Best Regards, Michal Dne 10.12.2020 v 9:02 c...@brain-biotech.de napsal(a): Am 07.12.20 um 18:23 schrieb Michal Kminek (mkmi...@getnet.cz): Hello Christian, recently I solved something similar but with no luck. My goal was sending Thunderbird as a package or through the GPO in Microsoft Domain. Which way do you distribute Thunderbird to your domain users? Thunderbird we depoly using OPSI (https://www.opsi.org/). The SOGo-Connector we deploy using the GPO templates for Thunderbird (https://github.com/drlellinger/thunderbird-policies) Or do you allow users to update Thunderbird in their profile? No we switch of automatic updates. Regards -- users@sogo.nu https://inverse.ca/sogo/lists
