Re: [SOGo] Ldap vs Mysql
If you have your users in mysql, you don't need to migrate them to LDAP. You can use MySQL as user source. Check documentation and some earlier/older posts on this mailing list. Regards, Igor Burk Al wrote, On 05/12/2013 09:30: Hi, I have already have a running mail server setup on postfix, dovecot, mysql, roundcube and I am using postfix admin to manage domains users. Now I want to install sogo on this setup. I have two main goals. 1- I want to natively connect some of my outlook users to the mail server. 2- Some of my users need both personal address book as well as the domain wide global address book. And they want to be able to access these two address books through both from their outlooks and also from the webmail. I believe sogo is my solution. I was taking a quick look at the documentation and I have noticed that I will need some sort of an Ldap server to achieve my goals with sogo. How does this supposed to work? I already have a mysql database running the domain and user data. Do I need to first change my current setup and replace mysql with an ldap server, which sounds like a quite task. Please advice... Thanks -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] time settings for events
Hello Mark Madere Am 2013-12-03 23:54, schrieb Mark Madere: I too would like to be able to pick the time format used in the date/time picker. Does anybody know if this is just a setting or would the template need to be modified? Sorry, but that is a totally different thing and has nothing to do with the previous post. Please add an enhancement request for that at 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] Nightly updates not working since 2.1.1b
On 13-12-05 3:25 PM, Martin Lehmann wrote: I don't get an error. But packages containing 2.1.1b aren't updated. The other packages were updated. And, as I can see, the files in the repository are all up-to-date. Therefore, I think it's a naming problem. can you show the output from these commands: yum info sogo rpm -q sogo Am 05.12.2013 21:16, schrieb Jean Raby: On 13-12-05 3:05 PM, Martin Lehmann wrote: Hi, the nightly updates for CentOS5 x86_64 aren't working since release of 2.1.1b.. The problem seems to be the naming of the packages. All packages containing 2.1.1b aren't updated. Other packages like sope-core, which have only the daily timestamp in there name, are updated. what error do you get? Greetz, Martin -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Issue with Big5 character set when viewing email, but displaying fine when replying.
On 13-12-05 6:52 PM, Laz C. Peterson wrote: I will send this exact same message from my Gmail account shortly. Please do, we need to see a mail sample (with headers) to be able to understand why it breaks. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Docs for SOGo Webmin module
Hello Pablo Carranza Am 2013-12-04 07:51, schrieb Pablo Carranza: I've looked around (I even asked our friends @ Google) and I can't seem to find any documentation re: the SOGo Webmin module. Does anyone know if there's any out there? Check the ZEG at the sogo homepage. It contains one. http://www.sogo.nu/downloads/zeg.html Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Large deployments
Hello Dhionel Díaz Am 2013-12-04 17:34, schrieb Dhionel Díaz: Do you have references of very large deployments of SOGo? Something on the order of 30 users or more, or the biggest deployments known. In the web site there are some testimonials but I haven't found references to the size of the deployments. We are currently evaluating groupware software and that references would be very helpful. We at the Universität Konstanz in Germany have more than 16000 users. Not as big as you search for, but not a small one either. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Login on Webpage doesn't work / bad request from upstream proxy
Hello J. Echter Am 2013-12-05 21:37, schrieb J. Echter: Am 03.12.2013 13:54, schrieb J. Echter: Am 03.12.2013 10:58, schrieb J. Echter: Hi, i have exactly the same problem logging into the SOGo webpage. I migrated from Ubuntu 12.04 to CentOS 6.4. ldapsearch works fine, also logging into mysql with user sogo works too. Apache modules are loaded and working. I'm using latest SOGo from SOGo EL6 repo. Any hints what could cause this? sorry forgot to mention that i'm relating to this post: https://lists.inverse.ca/sogo/arc/users/2012-10/msg00441.html but meanwhile i found out that dovecot didn't like TLS anymore, i switched to ssl and all is normal again. only thing, i don't get this, because i used my old config files and certs. there where only some os dependant editing. meanwhile its fixed. TLS=yes didn't work anymore (in sogo.conf) im back to imaps (ssl only) and it works again. IIRC this was changed to match the dacumentation. Did you try imaps AND TLS=yes ? Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Large deployments
Hello Dhinel Díaz, Le 04/12/2013 17:34, Dhionel Díaz a écrit : Hello all, Do you have references of very large deployments of SOGo? Something on the order of 30 users or more, or the biggest deployments known. In the web site there are some testimonials but I haven't found references to the size of the deployments. We are currently evaluating groupware software and that references would be very helpful. Thanks in advance, -- Dhionel Díaz Centro Nacional de Desarrollo e Investigación en Tecnologías Libres Ministerio del Poder Popular para Ciencia, Tecnología e Innovación At the University of Strasbourg in France, we have ~120 000 account with ~15 000 differents users per day. If we can help us Best regards, Ludovic. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Authentication using SQL - SOGoUserSources configuration / password schemes
Hallo again, while reviewing my Postfixadmin configuration, I noticed that I did not use ssha512 as the password scheme for Dovecot. Instead I used: [/etc/postfixadmin/config.inc.php] $CONF['encrypt'] = 'dovecot:SHA512-CRYPT'; This (SHA512-CRYPT) is the 2nd strongest scheme supported by Dovecot. The strongest is BLF-CRYPT. This is not the same scheme ... my fault. I suppose SOGo 2.1.1.a doesn't support them? 1.) I think I have to choose another password scheme for now. Right? While the salt in ssha512 is good against rainbow-table based password attacks, the -CRYPT variants additionally improve the strength against brute-force and dictionary attacks by slowing the hashing down. According to Vidar’s Blog-post about - Implementation of SHA512-crypt vs MD5- crypt http://www.vidarholen.net/contents/blog/?p=33 - the -CRYPT variants maybe even need additional parameters for the number of rounds. ### Like md5-crypt, it can be divided into three phases. Initialization, loop, and finalization. Generate a simple sha512 hash based on the salt and password Loop 5000 times, calculating a new sha512 hash based on the previous hash concatenated with alternatingly the hash of the password and the salt. Additionally, sha512-crypt allows you to specify a custom number of rounds, from 1000 to 9 Use a special base64 encoding on the final hash to create the password hash string ### I suggest, that SOGo implements them like Postfixadmin does: Postfixadmin invokes Dovecots password utility: /usr/bin/doveadm pw and calls the schemes e.g. 'dovecot:SHA512-CRYPT'; [/etc/postfixadmin/config.inc.php] // If you use the dovecot encryption method: where is the dovecotpw binary located? $CONF['dovecotpw'] = /usr/bin/doveadm pw; 2.) Any opinions? Kind regards T. B. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] time settings for events
Hello Andrew Am 2013-12-02 20:37, schrieb and...@maxwellworthington.com: When i change time settings in Preferences. Those settings arent carried out in the invite menus. So I choose a conventional time setting, instead of the 24 hr or military clock. Then I create an event, invite some folks to it, and the military time is used on the invite menu even though I changed it in preferences. Any ideas? That is a known bug in SOGo. Date and Time settings in preferences are currently not used in the invite window. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Nightly updates not working since 2.1.1b
Hi, thanks for fixing the problem. Since today are the nightlies renamed to 2.1.2 and updates are working as expected. Greetz, Martin On 12/06/2013 02:02 PM, Jean Raby wrote: On 13-12-05 3:25 PM, Martin Lehmann wrote: I don't get an error. But packages containing 2.1.1b aren't updated. The other packages were updated. And, as I can see, the files in the repository are all up-to-date. Therefore, I think it's a naming problem. can you show the output from these commands: yum info sogo rpm -q sogo Am 05.12.2013 21:16, schrieb Jean Raby: On 13-12-05 3:05 PM, Martin Lehmann wrote: Hi, the nightly updates for CentOS5 x86_64 aren't working since release of 2.1.1b.. The problem seems to be the naming of the packages. All packages containing 2.1.1b aren't updated. Other packages like sope-core, which have only the daily timestamp in there name, are updated. what error do you get? Greetz, Martin -- users@sogo.nu https://inverse.ca/sogo/lists
RE : [SOGo] Adjusting shared calendar colors from iOS or Apple Calendar
Just change the color in the webmail and the color will be syncronized. Regards Envoyé depuis mon appareil mobile Samsung Message d'origine De : Laz C. Peterson l...@paravis.net Date : 06/12/2013 2:53 (GMT+01:00) A : users@sogo.nu Objet : [SOGo] Adjusting shared calendar colors from iOS or Apple Calendar Hi SOGo users, Does anyone know of a way that a user can configure the color of a shared calendar from their iOS device or Apple app? Currently, we have the administrator subscribing specific users to a group of shared calendars (as it is difficult for them), but all of the calendars default to the same “grey” color, which is extremely confusing to the user. Either in Apple Calendar or iOS Calendar, it is not possible to change the color of the calendar — however, the user can change it if they log into the web interface. The organization is all Apple OS and iOS, and we are trying to avoid the inconvenience of forcing the users to log into the web interface if they want to change basic things like this. Thank you all so much. ~Laz-- users@sogo.nu https://inverse.ca/sogo/lists-- users@sogo.nu https://inverse.ca/sogo/lists
Re: RE : [SOGo] Adjusting shared calendar colors from iOS or Apple Calendar
And what about the other direction from iOS to SOGo? Greetings, Martin Am 06.12.2013 15:16, schrieb Alain Abbas: Just change the color in the webmail and the color will be syncronized. Regards Envoyé depuis mon appareil mobile Samsung Message d'origine De : Laz C. Peterson l...@paravis.net Date : 06/12/2013 2:53 (GMT+01:00) A : users@sogo.nu Objet : [SOGo] Adjusting shared calendar colors from iOS or Apple Calendar Hi SOGo users, Does anyone know of a way that a user can configure the color of a shared calendar from their iOS device or Apple app? Currently, we have the administrator subscribing specific users to a group of shared calendars (as it is difficult for them), but all of the calendars default to the same “grey” color, which is extremely confusing to the user. Either in Apple Calendar or iOS Calendar, it is not possible to change the color of the calendar — however, the user can change it if they log into the web interface. The organization is all Apple OS and iOS, and we are trying to avoid the inconvenience of forcing the users to log into the web interface if they want to change basic things like this. Thank you all so much. ~Laz-- users@sogo.nu https://inverse.ca/sogo/lists -- Greetings, Martin Rabl -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo + Internet Explorer 11
-- Skickat från mobilusken! -- Den 6 dec 2013 14:10 skrev Jean Raby jr...@inverse.ca: On 13-12-05 10:38 AM, Szládovics Péter wrote: 2013-12-05 16:24 keltezéssel, Francis Lachapelle írta: Note that full support for IE11 won’t be available until next release even though it has been improved in 2.1.1b. Could you please tell us about the status of activesync support? It should be production ready by friday. (but I'm not telling you which ;) :) -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Ldap vs Mysql
While dated, the SOGo article that appeared in the Linux Journal back in 2008 may be of interest to you: http://www.linuxjournal.com/magazine/scalable-opengroupwareorg Also, according to the SOGo Installation and Configuration Guidehttp://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf@ p. 29: SOGo can use a SQL-based database server for authentication. The configuration is very similar to LDAP-based authentication. .. Regards, -Pablo vDevices.com http://vdevices.com/ | Providing Hosted IT Solutions for Lawyers Other Mobile Professionals On Thu, Dec 5, 2013 at 2:30 AM, Burk Al burkal...@gmail.com wrote: Hi, I have already have a running mail server setup on postfix, dovecot, mysql, roundcube and I am using postfix admin to manage domains users. Now I want to install sogo on this setup. I have two main goals. 1- I want to natively connect some of my outlook users to the mail server. 2- Some of my users need both personal address book as well as the domain wide global address book. And they want to be able to access these two address books through both from their outlooks and also from the webmail. I believe sogo is my solution. I was taking a quick look at the documentation and I have noticed that I will need some sort of an Ldap server to achieve my goals with sogo. How does this supposed to work? I already have a mysql database running the domain and user data. Do I need to first change my current setup and replace mysql with an ldap server, which sounds like a quite task. Please advice... Thanks -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Adjusting shared calendar colors from iOS or Apple Calendar
For a user like me, who actually understands the methods behind CalDAV, etc., it's no problem logging into the web interface and changing the colors. For my users, though ... Much different story. I do understand the same limitations exist for even Apple's CalDAV service, as well as Google's -- and I'm sure others, too. I am guessing there is no RFC definition for delegate calendar colors and how they can be updated outside of the specific server itself, for example from a client or third party application. It is a little frustrating though that it works for a user's own calendars, but not the delegate ones. If I knew more about the programming behind it all, I would most definitely try my hands at contributing. Though I would most likely just make a mess. ;) ~Laz On Friday, December 6, 2013 06:36 AM PST, Martin Rabl martin.r...@rablnet.de wrote: And what about the other direction from iOS to SOGo? Greetings, Martin Am 06.12.2013 15:16, schrieb Alain Abbas: Just change the color in the webmail and the color will be syncronized. Regards Envoyé depuis mon appareil mobile Samsung Message d'origine De : Laz C. Peterson Date : 06/12/2013 2:53 (GMT+01:00) A : users@sogo.nu Objet : [SOGo] Adjusting shared calendar colors from iOS or Apple Calendar Hi SOGo users, Does anyone know of a way that a user can configure the color of a shared calendar from their iOS device or Apple app? Currently, we have the administrator subscribing specific users to a group of shared calendars (as it is difficult for them), but all of the calendars default to the same “grey” color, which is extremely confusing to the user. Either in Apple Calendar or iOS Calendar, it is not possible to change the color of the calendar — however, the user can change it if they log into the web interface. The organization is all Apple OS and iOS, and we are trying to avoid the inconvenience of forcing the users to log into the web interface if they want to change basic things like this. Thank you all so much. ~Laz-- users@sogo.nu https://inverse.ca/sogo/lists -- Greetings, Martin Rabl -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGoPasswordChangeEnabled from System to Domain
Are there any plans or is it even possible to move the SOGoPasswordChangeEnabled from the system preferences to the domain preferences? I have about the same number of OpenLDAP (with ppolicy) and Active Directory servers. And, I cannot figure out how to possibly allow password changing with AD. (Only get Unhandled policy error: 32764.) So it would be nice to specify at the domain level whether or not the user can change their password. Or, if anyone knows how to allow password change using AD (Windows 2003 functional level) user source, I would be most appreciative for some tips! Thanks again SOGo users. ~Laz Peterson-- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGoPasswordChangeEnabled from System to Domain
On 13-12-06 11:04 AM, Laz C. Peterson wrote: Are there any plans or is it even possible to move the SOGoPasswordChangeEnabled from the system preferences to the domain preferences? I have about the same number of OpenLDAP (with ppolicy) and Active Directory servers. And, I cannot figure out how to possibly allow password changing with AD. (Only get Unhandled policy error: 32764.) So it would be nice to specify at the domain level whether or not the user can change their password. What version of sogo/sope are you running? Support for changing password against AD/samba4 has been added recently (2.1.0) and it shouldn't try to use password policy if your LDAP server is AD compatible. Logs with LDAPDebugEnabled=YES; would also be useful. Or, if anyone knows how to allow password change using AD (Windows 2003 functional level) user source, I would be most appreciative for some tips! Thanks again SOGo users. ~Laz Peterson-- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGoPasswordChangeEnabled from System to Domain
Ah, Jean … You are a wonderful man! I had not even thought of debug mode … (*bashing head against desk*) So, for the record, yes, I have it working properly now. The resolution was to switch ldap://ad-server.domain.com - ldaps://ad-server.domain.com, as well as exporting the server’s SSL certificate and adding it into Ubuntu’s CA certs. Much thanks for the enlightenment! ~Laz On Dec 6, 2013, at 10:39 AM, Jean Raby jr...@inverse.ca wrote: On 13-12-06 11:04 AM, Laz C. Peterson wrote: Are there any plans or is it even possible to move the SOGoPasswordChangeEnabled from the system preferences to the domain preferences? I have about the same number of OpenLDAP (with ppolicy) and Active Directory servers. And, I cannot figure out how to possibly allow password changing with AD. (Only get Unhandled policy error: 32764.) So it would be nice to specify at the domain level whether or not the user can change their password. What version of sogo/sope are you running? Support for changing password against AD/samba4 has been added recently (2.1.0) and it shouldn't try to use password policy if your LDAP server is AD compatible. Logs with LDAPDebugEnabled=YES; would also be useful. Or, if anyone knows how to allow password change using AD (Windows 2003 functional level) user source, I would be most appreciative for some tips! Thanks again SOGo users. ~Laz Peterson-- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Large deployments
El 06/12/13 08:58, Ludovic Hutin escribió: Hello Dhinel Díaz, Le 04/12/2013 17:34, Dhionel Díaz a écrit : Hello all, Do you have references of very large deployments of SOGo? Something on the order of 30 users or more, or the biggest deployments known. In the web site there are some testimonials but I haven't found references to the size of the deployments. We are currently evaluating groupware software and that references would be very helpful. Thanks in advance, -- Dhionel Díaz Centro Nacional de Desarrollo e Investigación en Tecnologías Libres Ministerio del Poder Popular para Ciencia, Tecnología e Innovación At the University of Strasbourg in France, we have ~120 000 account with ~15 000 differents users per day. If we can help us Best regards, Ludovic. That's a quite busy deployment you have there. Apart from ISPs, that's in the order of other groupwares biggest deployments I've found reference. The administration of such a system should surely be a lot of fun. Thanks for your attention. Best regards, -- Dhionel Díaz Centro Nacional de Desarrollo e Investigación en Tecnologías Libres Ministerio del Poder Popular para Ciencia, Tecnología e Innovación signature.asc Description: OpenPGP digital signature
Re: [SOGo] Large deployments
El 06/12/13 08:46, Christian Mack escribió: Hello Dhionel Díaz Am 2013-12-04 17:34, schrieb Dhionel Díaz: Do you have references of very large deployments of SOGo? Something on the order of 30 users or more, or the biggest deployments known. In the web site there are some testimonials but I haven't found references to the size of the deployments. We are currently evaluating groupware software and that references would be very helpful. We at the Universität Konstanz in Germany have more than 16000 users. Not as big as you search for, but not a small one either. Kind regards, Christian Mack It's certainly a interesting reference, thanks for your attention. Best regards, -- Dhionel Díaz Centro Nacional de Desarrollo e Investigación en Tecnologías Libres Ministerio del Poder Popular para Ciencia, Tecnología e Innovación signature.asc Description: OpenPGP digital signature
[SOGo] BTS activities for Friday, December 06 2013
Title: BTS activities for Friday, December 06 2013 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Friday, December 06 2013 idlast updatestatus (resolution)categorysummary 2534 2013-12-06 09:26:03 updated (open) SOGo inconsistent date/time in "/var/log/sogo/sogo.log" file 2521 2013-12-06 11:01:35 updated (open) Apple iPhone OS iPHone iOS: wrong mailto in ORGANIZER if login differs from mail address 2535 2013-12-06 11:36:16 updated (open) Backend Calendar Calendar Mail invitation scored as SPAM due to missing "Message ID" field 915 2013-12-06 09:09:30 updated (open) Backend General (gnustep) crash when calculating certain string lengths 2267 2013-12-06 09:30:41 updated (open) Backend Mail Wrong UTF-8-coding of From in the header when comma is used 2527 2013-12-06 08:08:28 updated (open) Web Calendar Should be possible to search for local users who have at least one public calendar 1320 2013-12-06 08:11:30 updated (open) Web Mail Forwarded mails lose HTML formatting 2533 2013-12-06 09:30:48 updated (open) Web Mail comma in name results in splitting addres when is utf-8 encoded 1411 2013-12-06 18:16:57 updated (open) with external server Modification of previously created contacts within Thunderbird create duplicates 2120 2013-12-06 09:30:48 feedback (reopened) Web Mail SOGo webmail puts utf-8 characters in from field when accent is present