Re: [SOGo] Funambol 11
On 03/01/2012 08:48 AM, Mirko Stoffers wrote: On 03/01/2012 02:19 AM, Alessio Cecchi wrote: On Blackberry I use Onemediahub 10 (just installed yesterday) with SOGo and works fine. When you start for the first time Onemediahub the app invite you to register with onemediahub.com services. Just scroll down and select "I have already an account". I don't know if is the same procedure on Android. Let me know. On Android I can either choose OneMediaHub ELEVEN or FunV10 TEN (no OneMediaHub 10 available). So, maybe, OneMediaHub 10 is still more like Funambol 10. However, if you read the user reviews on OMH 11 at https://market.android.com/details?id=com.funambol.androidsync&feature=search_result it sounds really awful. So, are you sure you are using OHM 10? Maybe, they just did not build the Blackberry package yet, and as soon as they do yours will crash to ;) I just found this page: http://www.funambol.com/solutions/omh.php "BlackBerry App -- renamed to OneMediaHub. [...] The only change is the name change, it will not have other new OneMediaHub capabilities yet, these are tbd for BlackBerry." So be happy to expect the "new OneMediaHub capabilities" to be done soon, and having everything broken :P - and disable autoupdates for OMH as a first countermeasure ;) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Funambol 11
On 03/01/2012 10:11 AM, Fabian Rodriguez wrote: On 12-03-01 08:49 AM, Mirko Stoffers wrote: On 02/29/2012 03:22 PM, Fabian Rodriguez wrote: The .APK are still available from the project page: http://sourceforge.net/projects/funambol/files/android/v10/ Hi Fabian, Thanks for the link. Is that different to what they offer as "FunV10" on the market? Thanks, Mirko Actually, this link should be better if you want to make sure you're using the same source code that's published: http://f-droid.org/repository/browse/?fdcategory=Office&fdid=com.funambol.androidsync&fdpage=1 When you install via the Android market you become dependent on the publisher and have no control over what they publish (or stop publishing), as this thread demonstrates. In terms of functionality, I can't say if the application available on the market has more or less. However, the .apk from F-Droid is a clean build from 100% free, open source code. From the About page: "Wherever possible, applications in the repository are built from source, and that source code is checked for potential security or privacy issues. This checking is far from exhaustive though, and there are no guarantees." F-Droid acts as an alternative marketplace for apps providing management (install/update/remove), and where all apps are built from source. FSF Europe recently launched a campaign to better inform people about using free software on their Android devices: http://fsfe.org/campaigns/android/android.html Cheers, Fabian Thanks again for the reply. Indeed, it looks like a good idea to change the market place (independent of this issue). However, I'm wondering what would happen when we install Funambol 10.0.6 from there. Will Funambol Inc. update the open source version later and remove the own-server-functionality this way? Will F-Droid afterwards push the new Funambol OSS version via auto-update and messing up everything again? Currently, as far as I see, there is Funambol CSS 10, OneMediaHub CSS 11, and Funambol OSS 10. While both v10 apps would work properly the v11 app broke everything. So I'm somewhat concerned how Funambol OSS 11 will look like. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Funambol 11
On 02/29/2012 03:22 PM, Fabian Rodriguez wrote: The .APK are still available from the project page: http://sourceforge.net/projects/funambol/files/android/v10/ Hi Fabian, Thanks for the link. Is that different to what they offer as "FunV10" on the market? Thanks, Mirko -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Funambol 11
On 03/01/2012 02:19 AM, Alessio Cecchi wrote: On Blackberry I use Onemediahub 10 (just installed yesterday) with SOGo and works fine. When you start for the first time Onemediahub the app invite you to register with onemediahub.com services. Just scroll down and select "I have already an account". I don't know if is the same procedure on Android. Let me know. On Android I can either choose OneMediaHub ELEVEN or FunV10 TEN (no OneMediaHub 10 available). So, maybe, OneMediaHub 10 is still more like Funambol 10. However, if you read the user reviews on OMH 11 at https://market.android.com/details?id=com.funambol.androidsync&feature=search_result it sounds really awful. So, are you sure you are using OHM 10? Maybe, they just did not build the Blackberry package yet, and as soon as they do yours will crash to ;) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Funambol 11
Hi all, I just got a complaint from a user that his Android no longer syncs with SOGo. He said that the "Funambol" app has vanished and instead a "OneMediaHub" app from Funambol Inc. has appeared. When I search for "funambol", I find two apps on the market: OneMediaHub 11.0.1: https://market.android.com/details?id=com.funambol.androidsync&feature=search_result FunV10 10.1.1: https://market.android.com/details?id=com.funambol.funv10&feature=search_result My conclusion is that Funambol updated and renamed Funambol 10 to OneMediaHub 11, and added a new app FunV10 10. So far so good, but the user-comments on the market indicate that OneMediaHub 11 does not work with custom servers, i.e. it will not work with SOGo. Can anybody confirm that? (Or did the users just not find the switch?) What would you guys suggest to fix the problem? Reinstalling Funambol 10? Would this work out-of-the-box w/o reconfiguring everything? Or would you (anyway) rather recommend carddav/caldav? Unfortunately, I don't have access to that mobile, so I'll have to give the user precise advice how to fix the problem. Further, the address book must be accessible by bluetooth (from the car) which I remember was a bit tricky with funambol. Thanks, Mirko -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] spanish support problem
On 02/16/2012 10:54 AM, Francis Lachapelle wrote: [snip] I'll make the change in SOPE to fallback to SpanishSpain by default when the browser accepts "es". Hm, interestingly, my SOGo appears to neither understand "es" nor "es-es" nor "es-ar". -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] spanish support problem
On 02/16/2012 10:23 AM, robe...@indomitux.com.ar wrote: [snip] I think the error doesn't only apply to login. In my log I also found these lines: [snip] My guess: On every connection you make SOGo tries to guess your language, but after login this guess is later overwritten by your personal preference. For this reason you have the error messages in the logs, but you don't have any error in the WebUI. (I distinguish between "error message" (entry in the log files) and "error" (misbehavior) ;) ) Mirko -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] spanish support problem
In my case, the errors occur for Mail, Calendar and Contacts, but under the following setups: PC Win7 English / Sogo Web UI Spanish (Spain) : No errors PC Win7 Spanish / Sogo Web UI Spanish (Spain) : errors PC Win7 Spanish / Sogo Web default language - no manual election : errors Before you log-in, SOGo needs to guess your language to display the login page (since it does not know who you are, and which language you selected). In order to do so, SOGo takes your browser settings (transmitted in HTTP headers). Obviously here is the bug. If I set my FF to German/Germany, my login page says "Benutzername, Passwort" (German). If I however set my FF to Spanish/Spain, my login page says "Username, Password" (does not sound Spanish to me). I did not check, but I guess at the same time I will have similar errors in my log. So, I guess, you _do_ have errors in the WebUI, you just did not check the login page ;) - After login, SOGo takes your preferences if you selected "default" at the login page. Mirko -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo extensions for Thunderbird 10!
On 02/08/2012 08:59 AM, Brendan Murtagh wrote: Can you expand on what you mean by the offical channels for Lightning v1.2.1? > [...] I'm used to downloading the Mozilla Lightning - Inverse Edition from the Frontends page on SOGo's site. By the official channels Ludovic meant exactly _not_ the Inverse Edition, but the 'official' Mozilla edition. Some days ago Ludovic said that the necessary patches now made it into that official version, such that - I guess - there will be no Inverse Edition anymore for TB 10 (or newer). -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Understanding how calendar sharing works
On 02/04/2012 05:55 PM, Peter Peltonen wrote: Hi Robert, On Sat, Feb 4, 2012 at 7:42 PM, Robert Casties wrote: As the user that owns the calendar you can right-click on the calendar in the web frontend and choose "permissions". There you can add another user to the ACL and give them permission to create, change, and delete events. Once you have done that you can use any CalDav client. Thanks for the tip, but: I do not see such option. If I right click my Personal Calendar in the SOGo web UI under Calendars tab all I see is: Properties New Calendar... Delete Calendar... Export Calendar... Import Events... Publish Calendar... Reload Remote Calendars Sharing... Did you try "Sharing"? -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Changing display of related emails in WebGUI similar to newer TB versions
Hi Georg, Adding and editing of vacation messages is possible right now. SOGo is, if I'm correct, only creating a sieve script. You can install the TB addon "Sieve" to edit your sieve scripts. Of course, the managesieve protocol has to be accessible from outside, some configurations on your firewall might be needed. On the other hand - it's really not user-friendly. No normal user will start scripting just to enable vacation messages. :-) OK, this does not sound like the solution I want to propose my users... Sharing of mailboxes should be possible with the addon "imap-acl-extensions", I guess? Indeed, that does not look too bad. Nevertheless, I miss the 'search user' part. Users don't know (and don't want to know) how exactly the user names are composed. Users want to enter a first or last name and klick on the user they searched for. And users don't know what to enter to get 'any authenticated user'. But nevertheless, it looks quite promising. Thanks for pointing me to it. Regards, Mirko -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Changing display of related emails in WebGUI similar to newer TB versions
Hi Georg, in my opinion the web interface is not meant to be the primary interface for extensive mail management. It is rather meant to be used on PCs where you don't want (be allowed) to install a fat client since you do not use them every day. Instead of adding all the features of a fat client to the web GUI, I'd prefer seeing the effort being put in adding the web GUI options to Thunderbird (extensions). It's quite annoying to log-in to the web interface in order to set a vacation message or other preferences, share a mail folder, etc. while TB is running anyway. Just my 2 cents. Mirko On 01/25/2012 02:43 PM, Georg Bretschneider wrote: Hi, it looks like enabling this in SOGo config doesn't help. Every user has to enable this view on his own. I checked it with a newly created user. Okay, the feature is there. But I have suggestions :) In Thunderbird I can "open" and "close" the threads. If you have a lot of emails, the new smart filters in Thunderbird can help finding unread messages. In SOGo web gui I can't filter for read or unread messages. Something that I would like to see in Thunderbird AND Sogo aswell, "updated" threads (new mails) are "bounced" to the top of the email list. This and a smart filter bar would enhanced the usability a lot! Other ideas? Bye Georg Am 25.01.2012 19:54, schrieb Martin Seener: i plan to add this feature too for our "Outlook"-Guys so is it enabled by default or "enable"-able? Thanks! On 1/25/12 7:52 PM, Georg Bretschneider wrote: Hi Steve, many thanks for your efforts. SOGoThreadedView = YES; (or defaults write sogod SOGoThreadedView YES if you are using the XML version) and then an option will appear in the mail tab of preferences for user to turn on option if desired. I hope you mean "turn off if desired", because, I hope, SOGoThreadedView YES will enable this kind of view per default. Ah...doesn't matter. I will see it in the next couple of minutes. :) This should probably be added to the manual as newcomers will not even know it exists. Ack! Bye Georg -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Thunderbird 10b4 questions
On 01/23/2012 11:29 AM, Donny Brooks wrote: On 1/23/2012 10:00 AM, Ludovic Marcotte wrote: On 20/01/12 16:43, Donny Brooks wrote: I am testing TB 10b4 now. I have installed lightning 1.2b2. It pulled all my sogo calendars automagically which I found quite interesting being as the connector and integrator was disabled due to incompatibility issues. Now however when I try to book a resource it cannot lookup the user. Almost as if it is not pulling from LDAP. I checked and my LDAP settings pulled over from the previous install but it just is not pulling in lightning. Should the integrator/connector once released fix this issue? Yes. Awesome. Any timeframe on when the plugins should be available? Hopefully not "Friday". Unless it is this Friday. :) I'd also very much appreciate a comment on this. It would be great if we could have the extensions for our users done even before TB 10 is released such that users can upgrade w/o problems. However, this would mean that the extensions need to be available on Friday - ehm, this Friday :P If this cannot be done, it would be great if you could at least publish an RC, or a beta, or an alpha, or a nightly ;) Thanks, Mirko -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Thunderbird 10 (Extended Support release) release is on Jan 31st, beta available
On 01/18/2012 04:49 PM, Ludovic Marcotte wrote: On 18/01/12 15:50, Fabian Rodriguez wrote: I'd encourage any SOGo admins/users using Thunderbird and awaiting for their release 10 (and corresponding updated SOGo extensions) to join the tb-enterprise Google Group or mailing list (both are the same): http://groups.google.com/group/tb-enterprise https://mail.mozilla.org/listinfo/tb-enterprise Another beta for TB 10 will be available tomorrow so it's a great time to report bugs there, and make sure TB 10 works, getting ready for next SOGo versions. Having several SOGo users/testers there can only help the SOGo project too. TB 10 target for release is Jan. 31st. You may also be interested in these resources: https://wiki.mozilla.org/Thunderbird/Enterprise https://wiki.mozilla.org/Features/Thunderbird/Modern_Address_Book Regarding this, in order to validate the proper behavior of our ACL "hooks" (https://bugzilla.mozilla.org/show_bug.cgi?id=586276), folks are required to install the attached extension. That code will eventually be included in SOGo Integrator once we go final on this for Thunderbird 10/Lightning 1.2. You also need to do one more thing to enable the ACL hooks on your "SOGo Calendars". Once you've installed the extension, quit Thunderbird. Edit the prefs.js manually and add something like: user_pref("calendar.registry.42a2ce67-bafe-034d-8ff0-2db8c266faad.aclManagerClass", "@inverse.ca/calendar/caldav-acl-manager;1"); Where "42a2ce67-bafe-034d-8ff0-2db8c266faad" is the GUID of your SOGo calendar as defined by Lightning. Do a "grep 'calendar.registry' prefs.js | grep uri" to see the list you have. Then, start Thunderbird. This will also be included in SOGo Integrator at some point. Maybe, I'm just too blind... Where are the connector and integrator extensions for TB 10? -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Mail Folder ACLs
On 01/14/2012 08:22 PM, Ludovic Marcotte wrote: On 13/01/12 22:09, Mirko Stoffers wrote: I again need your help. When I create a new mail folder in SOGo, I've got to grant other users permission on that folder. However, some of these permissions are not saved. Furthermore, it would be great to have an option to also apply permissions on (later created) subfolders. What's your IMAP server and which version? My IMAP Server is Cyrus 2.2.13-14+lenny6 Have you tried to set SOGoIMAPAclStyle to rfc2086? Thanks for the hint. This indeed solved the issue. However, the ACL conditions "remove this folder" and "expunge this folder" have vanished, but at least the remaining ones are usable. Nevertheless, there is a severe problem: Allowing users to create subdirectories under this folder, allows users also to move the folder to their own trash (by selecting "delete" in the webUI), and take control over the folder. Regards, Mirko -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Mail Folder ACLs
Hi guys, I again need your help. When I create a new mail folder in SOGo, I've got to grant other users permission on that folder. However, some of these permissions are not saved. Furthermore, it would be great to have an option to also apply permissions on (later created) subfolders. Here is the result of granting all permissions, saving, and reopening the window: [X] Read mails from this folder [X] Mark mails read and unread [X] Modify the flags of the mails in this folder [X] Insert, copy and move mails into this folder [X] Post mails [ ] Add subfolders to this folder [ ] Erase mails from this folder [ ] Remove this folder [ ] Expunge this folder [X] Modify the acl of this folder Does anybody know how to get rid of this misbehavior? Does anybody know a way to have permissions applied on subfolders? Thanks, Mirko -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Modifying values in Web Interface
Hi guys, when I click into a certain fields in the web interface (e.g. the auto reply message), the cursor moves to the beginning of that text. I cannot click anywhere I want, and I cannot mark text. The only thing I can do is deleting the first characters. This is extremely annoying if you want to modify your last auto-reply message somewhere in the middle. I know that this problem has not been there from the beginning, but I think, it came with the last update. Do you guys have the same issue? Or is it only me? Thanks, Mirko -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Deleted Events still appear in TB
On 12/31/2011 09:04 PM, Clay Wright wrote: On 12/31/2011 04:09 AM, Mirko Stoffers wrote: On 12/28/2011 04:31 PM, Mirko Stoffers wrote: On 12/28/2011 03:23 PM, Ludovic Marcotte wrote: On 28/12/11 06:18, Mirko Stoffers wrote: I've got the following problem: When I create an event via the web interface, it is also visible in TB (at least, after pushing reload). When I move this event, it is also moved in TB. However, when I delete the event in the web interface, it is still visible in TB (even after pushing reload or restarting TB). Any ideas? Which version of the extensions are you using? IIRC we fixed such issues in the latest version of the extensions. SOGo: 1.3.11 Thunderbird: 3.1.17, Windows XP 32 Bit Lightning: 1.0b2.108i Connector/Integrator: 3.108 (the version linked in the download area) Hi Ludovic, as mentioned above, this problem occurs in the most recent version of the extensions. So, I guess there is something wrong with that fix. Can you (or someone else) confirm that, or is it only me? Hello Mirko. I've seen the same thing for at least the last two upgrades to the extensions. In each case it was resolved for me after deleting the Lightning cache.sqlite file. Most of my users are either on Thunderbird only or the web interface only so I haven't heard any complaints. IMHO, something like this feature request might be good though -- regardless of how this particular issue is worked out -- http://www.sogo.nu/bugs/view.php?id=1533. Yes, indeed. Though that button would not be an excuse not to fix that bug ;) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Deleted Events still appear in TB
On 12/28/2011 04:31 PM, Mirko Stoffers wrote: On 12/28/2011 03:23 PM, Ludovic Marcotte wrote: On 28/12/11 06:18, Mirko Stoffers wrote: I've got the following problem: When I create an event via the web interface, it is also visible in TB (at least, after pushing reload). When I move this event, it is also moved in TB. However, when I delete the event in the web interface, it is still visible in TB (even after pushing reload or restarting TB). Any ideas? Which version of the extensions are you using? IIRC we fixed such issues in the latest version of the extensions. SOGo: 1.3.11 Thunderbird: 3.1.17, Windows XP 32 Bit Lightning: 1.0b2.108i Connector/Integrator: 3.108 (the version linked in the download area) Hi Ludovic, as mentioned above, this problem occurs in the most recent version of the extensions. So, I guess there is something wrong with that fix. Can you (or someone else) confirm that, or is it only me? Thanks, Mirko -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Deleted Events still appear in TB
On 12/28/2011 03:23 PM, Ludovic Marcotte wrote: On 28/12/11 06:18, Mirko Stoffers wrote: I've got the following problem: When I create an event via the web interface, it is also visible in TB (at least, after pushing reload). When I move this event, it is also moved in TB. However, when I delete the event in the web interface, it is still visible in TB (even after pushing reload or restarting TB). Any ideas? Which version of the extensions are you using? IIRC we fixed such issues in the latest version of the extensions. SOGo: 1.3.11 Thunderbird: 3.1.17, Windows XP 32 Bit Lightning: 1.0b2.108i Connector/Integrator: 3.108 (the version linked in the download area) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Deleted Events still appear in TB
Hi all, I've got the following problem: When I create an event via the web interface, it is also visible in TB (at least, after pushing reload). When I move this event, it is also moved in TB. However, when I delete the event in the web interface, it is still visible in TB (even after pushing reload or restarting TB). Any ideas? Thanks, Mirko -- SOGo: 1.3.11 Thunderbird: 3.1.17, Windows XP 32 Bit Lightning: 1.0b2.108i Connector/Integrator: 3.108 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo/Funambol/Calendar
> How do I downgrade to 1.3.8? sudo apt-get install sogo=1.3.8 ? -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Importing Private Events
On 12/14/2011 08:32 AM, Francis Lachapelle wrote: Hi Mirko On 2011-12-13, at 7:51 PM, Mirko Stoffers wrote: I figured out there are tow tables: jdoe123 and jdoe123_quick . Two my point of view jdoe123 contains correct data, i.e. there is an entry CLASS:PRIVATE in the vcal blob. However, the entries in jdoe123_quick differ from really private appointments in the sense that there are three flags zero instead of one: c_classification, c_isopaque, and c_status. I guess one of those flags is the one causing the trouble. So my question: Is there a way to make SOGo recompute this jdoe123_quick table from the entries in jdoe123? Performing a backup/restore using sogo-tool will update your quick table : su - sogo mkdir sogo-backup sogo-tool backup sogo-backup jdoe123 sogo-tool restore -F ALL sogo-backup jdoe123 Francis -- flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) OK, good to know. For the next time ;) Thanks, Mirko -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Importing Private Events
Ok, whatsoever. Since I could not figure out how to force SOGo to recreate the _quick relation, I created a script to do it for me, now. Just in case other people have similar problems, I attached the script to this mail. Please be aware that this script might contain errors and cause everything to explode, or worse. I highly recommend to make a database backup before!!! Nobody can hold me liable for any damage this script might cause! Regards, Mirko PS: It actually was the c_classification field that is not correctly set by Funambol. On 12/13/2011 07:51 PM, Mirko Stoffers wrote: Now, I started a precious discussion on the future of Funambol which actually was not my intention ;) Back to my problem: I figured out there are tow tables: jdoe123 and jdoe123_quick . Two my point of view jdoe123 contains correct data, i.e. there is an entry CLASS:PRIVATE in the vcal blob. However, the entries in jdoe123_quick differ from really private appointments in the sense that there are three flags zero instead of one: c_classification, c_isopaque, and c_status. I guess one of those flags is the one causing the trouble. So my question: Is there a way to make SOGo recompute this jdoe123_quick table from the entries in jdoe123? Thanks, Mirko -- users@sogo.nu https://inverse.ca/sogo/lists#!/bin/bash # !!!this script might cause DAMAGE to your computer and comes with absolutely NO WARRANTY!!! # this script only work with PostgreSQL # I commented the line that actually takes action. Uncomment it at your own risk! defaultdatabase=$USER indextable=sogo_folder_info read -p "Database ($defaultdatabase): " database if [ -z "$database" ] then database=$defaultdatabase fi tableIds=`psql -t $database -c "select c_folder_id from $indextable where c_folder_type = 'Appointment';"` for tableId in $tableIds do table=`psql -t $database -c "select split_part(c_location, '/', 5) from $indextable where c_folder_id='$tableId';"` qtable=`psql -t $database -c "select split_part(c_quick_location, '/', 5) from $indextable where c_folder_id='$tableId';"` privateEvents=`psql -t $database -c "select c_name from $table where c_content like '%CLASS:PRIVATE%';"` for privateEvent in $privateEvents do #res=`psql -t $database -c "update $qtable set c_classification=1 where c_name='$privateEvent';"` echo $res done done
Re: [SOGo] Importing Private Events
Now, I started a precious discussion on the future of Funambol which actually was not my intention ;) Back to my problem: I figured out there are tow tables: jdoe123 and jdoe123_quick . Two my point of view jdoe123 contains correct data, i.e. there is an entry CLASS:PRIVATE in the vcal blob. However, the entries in jdoe123_quick differ from really private appointments in the sense that there are three flags zero instead of one: c_classification, c_isopaque, and c_status. I guess one of those flags is the one causing the trouble. So my question: Is there a way to make SOGo recompute this jdoe123_quick table from the entries in jdoe123? Thanks, Mirko On 12/13/2011 09:25 AM, Mirko Stoffers wrote: On 12/13/2011 08:39 AM, Christian Mack wrote: Hello Mirko Stoffers On 2011-12-13 14:26, Mirko Stoffers wrote: Sorry for the horrible formatting of the last mail. Here again in readable formatting: Addendum: Seems like there is already a bug report related to this issue open since months: http://www.sogo.nu/bugs/bug_view_advanced_page.php?bug_id=1319 Does nobody care about that issue? oOo It is not important, as SOGo 2 will have native Outlook synchronisation via OpenChange. With this you don't need Funambol anymore. In our opinion (University of Konstanz) fixing this is a waste of development time. Hm, yes, maybe you're right. But can you nevertheless tell me how to get my database right? I actually don't know what went wrong. There is an entry saying "CLASS:PRIVATE\r" in the vcal entry in the database. However, there must be another kind of private tag anywhere else that is not set up appropriately. Thanks, Mirko PS ad "you don't need Funambol anymore": How will mobile devices be synched with SOGo 2? -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Importing Private Events
On 12/13/2011 08:39 AM, Christian Mack wrote: Hello Mirko Stoffers On 2011-12-13 14:26, Mirko Stoffers wrote: Sorry for the horrible formatting of the last mail. Here again in readable formatting: Addendum: Seems like there is already a bug report related to this issue open since months: http://www.sogo.nu/bugs/bug_view_advanced_page.php?bug_id=1319 Does nobody care about that issue? oOo It is not important, as SOGo 2 will have native Outlook synchronisation via OpenChange. With this you don't need Funambol anymore. In our opinion (University of Konstanz) fixing this is a waste of development time. Hm, yes, maybe you're right. But can you nevertheless tell me how to get my database right? I actually don't know what went wrong. There is an entry saying "CLASS:PRIVATE\r" in the vcal entry in the database. However, there must be another kind of private tag anywhere else that is not set up appropriately. Thanks, Mirko PS ad "you don't need Funambol anymore": How will mobile devices be synched with SOGo 2? -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Importing Private Events
Sorry for the horrible formatting of the last mail. Here again in readable formatting: Addendum: Seems like there is already a bug report related to this issue open since months: http://www.sogo.nu/bugs/bug_view_advanced_page.php?bug_id=1319 Does nobody care about that issue? oOo I'm still using Funambol 8.7 as suggested by the documentation. Does anybody know whether newer Funambol versions fix that issue? If yes, I'd be graceful for short descriptions how to upgrade Funambol how to get my database right ;) . Regards, Mirko On 12/12/2011 02:13 PM, Mirko Stoffers wrote: Hi all, we imported a bunch of private and public events from Outlook to SOGo via Funambol. The issue with those events is: Everybody can view the subject of the private events. When the owner of such a private event opens the event, the event is tagged private. However, in the owner's calender the lock icon is not placed at this event. When another user opens such a private event, he receives an error [1]. The issue can be resolved for a single event by opening and resaving it: The lock appears and other users just see "(Private event)". However, this does not sound like the appropriate solution for all the events ;) To fix this issue for now, I would also run an SQL statement if necessary, but I want to be sure that the error does not reoccur on the next Outlook synch. After all, it is also a kind of security issue. Regards, Mirko [1] "An error occurred during object publishing tried to access private object (0x0xb6., SoClass=SOGoAppointmentOccurence)" -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Importing Private Events
Addendum: Seems like there is already a bug report related to this issue open since months: http://www.sogo.nu/bugs/bug_view_advanced_page.php?bug_id=1319 Does nobody care about that issue? oOo I'm still using Funambol 8.7 as suggested by the documentation. Does anybody know whether newer Funambol versions fix that issue? If yes, I'd be graceful for short descriptions how to upgrade Funambol how to get my database right ;) . Regards, Mirko On 12/12/2011 02:13 PM, Mirko Stoffers wrote: > Hi all, > > we imported a bunch of private and public events from Outlook to SOGo via Funambol. The > issue with those events is: Everybody can view the subject of the private events. > > When the owner of such a private event opens the event, the event is tagged private. > However, in the owner's calender the lock icon is not placed at this event. > > When another user opens such a private event, he receives an error [1]. > > The issue can be resolved for a single event by opening and resaving it: The lock appears > and other users just see "(Private event)". However, this does not sound like the > appropriate solution for all the events ;) > > To fix this issue for now, I would also run an SQL statement if necessary, but I want to be > sure that the error does not reoccur on the next Outlook synch. After all, it is also a kind > of security issue. > > Regards, > > Mirko > > [1] "An error occurred during object publishing > > tried to access private object (0x0xb6., SoClass=SOGoAppointmentOccurence)" ___ SMS schreiben mit WEB.DE FreeMail - einfach, schnell und kostenguenstig. Jetzt gleich testen! http://f.web.de/?mc=021192 -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Importing Private Events
Hi all, we imported a bunch of private and public events from Outlook to SOGo via Funambol. The issue with those events is: Everybody can view the subject of the private events. When the owner of such a private event opens the event, the event is tagged private. However, in the owner's calender the lock icon is not placed at this event. When another user opens such a private event, he receives an error [1]. The issue can be resolved for a single event by opening and resaving it: The lock appears and other users just see "(Private event)". However, this does not sound like the appropriate solution for all the events ;) To fix this issue for now, I would also run an SQL statement if necessary, but I want to be sure that the error does not reoccur on the next Outlook synch. After all, it is also a kind of security issue. Regards, Mirko [1] "An error occurred during object publishing tried to access private object (0x0xb6., SoClass=SOGoAppointmentOccurence)" -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Global Addressbook
Hi community, so, now that E-Mail runs fine, I would like to setup the contacts component. All users can already see a global address book. However, there is no user able to insert "cards" into this address book: When I klick on "New card" the "Add to" drop down menu simply does not show the global address book. I would assume that by default no user has write permissions on that address book, right? However, how do I set those permissions? Thanks Mirko Btw: It's the same behaviour as in the demo. However, I thinks that it is intended for the demo? ___ GRATIS: Spider-Man 1-3 sowie 300 weitere Videos! Jetzt kostenlose Movie-FLAT freischalten! http://movieflat.web.de -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Authentication against SASL
Hi Patrick, hm, I cannot really see the problem with authorization: My SQL database doesn't contain any authorization information at all. Or do you mean that a saslauthdb could contain users for different purposes (say, FTP server access) who are not authorized for SOGo? For the latter I would recommend that the authentication is done by SASL and the authorization by the PostgreSQL table w/o the password field. However, obviously I have to accept that SOGo does not currently support SASL. So I keep my configuration till SOGo comes to support it ;) Thanks Mirko -Ursprüngliche Nachricht- Von: "Patrick Ben Koetter" Gesendet: Sep 9, 2010 11:56:06 PM An: users@sogo.nu Betreff: Re: [SOGo] Authentication against SASL >* Mirko Stoffers : >> Hi Patrick, thanks for your reply. Yes, I also thought about that. However, >> I'm not sure whether postgres is really a good source for authentication. I >> think, postgres is more designed as a relational database than a password >> storage, whilst the saslauthdb's only purpose is storing passwords. In >> practice, when I insert the entries into the postgres database with "insert >> into ... md5('...') ..." the passwords are shown on the screen in clear and >> saved in the history file. That's why I would prefer using a password >> storage (saslauthdb) for passwords. ;) Thanks, Mirko > >AFAIK SOGo does not support SASL as authentication service because SOGo wants >more from such as backend than only authentication. AFAIK SOGo wants >authorization too and that is something SASL can't give you. > >So, to me, you are up to "use PostgreSQL for all applications or use more than >one backend". If you want to stick with both, but not maintain both, write a >script to generate a sasldb from data taken from a PostgreSQL table. You could >even have a Python or Perl listener hooked up to PostgreSQL recreating your >sasldb anytime data in the PostgreSQL user table changes. > >p...@rick > > >> = Patrick wrote: Mirko, * m.stoff...@web.de : > >> Hello community, for some reasons the mail I sent some hours ago did not > >> make it neither to me nor to the archive. So I assume that it got lost > >> somewhere and send it again this way. I apologize if my mail just was stuck >> > somewhere. Here is the mail again: > Hello community, > > I am currently > >> > setting up a SOGo installation for a small company. At least the mail > fu >> > nctionality is working so far for now, so that I came to setting up all > >> > the accounts. > > My exim and cyrus are configured to auth against SASL > >> > (backend: saslauthdb), whilst SOGo auths against a postgres db. > >> > Unfortunately, I didn't figure out how SOGo could auth against SASL which >> > > would save me adding each user twice. > > So my questions: Does SOGo >> > > support > SASL? What would you prefer instead? > > Thanks > > Mirko have >> > > you considered doing it the other way around using PostgreSQL as auth >> > > backend for SASL (and letting exim and cyrus SASL auth against a >> > > PostgreSQL DB)? Something along these lines: # GENERIC options >> > > pwcheck_method: auxprop auxprop_plugin: sql mech_list: plain login >> > > cram-md5 digest-md5 # SQL auxprop plugin options sql_engine: pgsql >> > > sql_hostnames: 127.0.0.1 sql_user: username sql_passwd: secret >> > > sql_database: company sql_select: SELECT password FROM users WHERE user >> > > = ´%...@´%r´ p...@rick -- state of mind Digitale Kommunikation >> > > http://www.state-of-mind.de Franziskanerstraße 15 Telefon +4 >> 9 89 3090 4664 81669 München Telefax +49 89 3090 4666 Amtsgericht München Partnerschaftsregister PR 563 >> ___ >> WEB.DE DSL SOMMER-SPECIAL: Surf & Phone Flat 16.000 für >> nur 19,99 €/mtl.!* http://produkte.web.de/go/DSL-Doppel-Flatrate/2 > >> -- >> users@sogo.nu >> https://inverse.ca/sogo/lists > >> -- >> users@sogo.nu >> https://inverse.ca/sogo/lists > > >-- >state of mind >Digitale Kommunikation > >http://www.state-of-mind.de > >Franziskanerstraße 15 Telefon +49 89 3090 4664 >81669 München Telefax +49 89 3090 4666 > >Amtsgericht München Partnerschaftsregister PR 563 > ___ WEB.DE DSL SOMMER-SPECIAL: Surf & Phone Flat 16.000 für nur 19,99 €/mtl.!* http://produkte.web.de/go/DSL_Doppel_Flatrate/2 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Authentication against SASL
Hi Patrick, thanks for your reply. Yes, I also thought about that. However, I'm not sure whether postgres is really a good source for authentication. I think, postgres is more designed as a relational database than a password storage, whilst the saslauthdb's only purpose is storing passwords. In practice, when I insert the entries into the postgres database with "insert into ... md5('...') ..." the passwords are shown on the screen in clear and saved in the history file. That's why I would prefer using a password storage (saslauthdb) for passwords. ;) Thanks, Mirko = Patrick wrote: Mirko, * m.stoff...@web.de : > Hello community, for some reasons the mail I sent some hours ago did not > make it neither to me nor to the archive. So I assume that it got lost > somewhere and send it again this way. I apologize if my mail just was stuck > somewhere. Here is the mail again: > Hello community, > > I am currently > setting up a SOGo installation for a small company. At least the mail > functionality is working so far for now, so that I came to setting up all > the accounts. > > My exim and cyrus are configured to auth against SASL > (backend: saslauthdb), whilst SOGo auths against a postgres db. > Unfortunately, I didn't figure out how SOGo could auth against SASL which > would save me adding each user twice. > > So my questions: Does SOGo support > SASL? What would you prefer instead? > > Thanks > > Mirko have you considered doing it the other way around using PostgreSQL as auth backend for SASL (and letting exim and cyrus SASL auth against a PostgreSQL DB)? Something along these lines: # GENERIC options pwcheck_method: auxprop auxprop_plugin: sql mech_list: plain login cram-md5 digest-md5 # SQL auxprop plugin options sql_engine: pgsql sql_hostnames: 127.0.0.1 sql_user: username sql_passwd: secret sql_database: company sql_select: SELECT password FROM users WHERE user = ´%...@´%r´ p...@rick -- state of mind Digitale Kommunikation http://www.state-of-mind.de Franziskanerstraße 15 Telefon +49 89 3090 4664 81669 München Telefax +49 89 3090 4666 Amtsgericht München Partnerschaftsregister PR 563 ___ WEB.DE DSL SOMMER-SPECIAL: Surf & Phone Flat 16.000 für nur 19,99 €/mtl.!* http://produkte.web.de/go/DSL-Doppel-Flatrate/2 -- users@sogo.nu https://inverse.ca/sogo/lists-- users@sogo.nu https://inverse.ca/sogo/lists