[SOGo] SOGo - ResourceConfiguration
I hope I am not pissing off guys on this forum with my myriad questions about SOGo - having discovered it just the other week after someone mentioned it on another mailing list. I realize SOGo is not for FreeBSD, but I have several servers that could do with such a Groupware and I am learning the curves while playing and getting stuck. I just learnt about Resource Configuration from an old thread: http://wiki.sogo.nu/ResourceConfiguration I still don't understand it. Why do I require this? Can someone please give me a case scenario? I am using MySQL auth, using a VIEW instead of a standalone database. Before knowing a use case of Resources, I configured it on my test platform and promptly got stuck! I created a user(resource): +--+---+--+--+--+---+ | c_uid| c_name| c_cn | mail | kind | multiple_bookings | +--+---+--+--+--+---+ | ro...@crownkenya.com | Meeting Room1 | ro...@crownkenya.com | ro...@crownkenya.com | location | 1 | +--+---+--+--+--+---+ I then added the following to sogo.conf: SOGoCalendarDefaultRoles = (PublicViewer,ConfidentialDAndTViewer,PrivateDAndTViewer); I understand that is the ACL required to enable a resource to work. Under my SOGoUserResourced, I added two parameters: MultipleBookingsFieldName = multiple_bookings; KindFieldName = kind; Now, as the Wiki says (remember I still don't quite understand the use case for this) I logged in and created an event in my Calendar and tried to add the resource as a participant. The problem is I could NOT save the event! The following would display in sogo.log: Jul 03 12:28:14 sogod [50769]: |SOGo| starting method 'POST' on uri '/SOGo/so/ ro...@crownkenya.com/freebusy.ifb/ajaxRead?sday=20130701eday=20130715' Jul 03 12:28:14 sogod [50769]: |SOGo| lookup name: ro...@crownkenya.com Jul 03 12:28:14 sogod [50769]: |SOGo| did not find key ' ro...@crownkenya.com' in SoClass: 0x0x298fba84[SoObjCClass]: super=0x0x298fb704 objc=SOGo slots=connect,GET,view,casProxy,index,saml2-signon-post,changePassword,saml2-metadata,loading,toolbar Jul 03 12:28:14 sogod [50769]: |SOGo| looked up value: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| lookup in root object: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| GOT: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| lookup name: ro...@crownkenya.com Jul 03 12:28:14 sogod [50769]: |SOGo| did not find key ' ro...@crownkenya.com' in SoClass: 0x0x298fba84[SoObjCClass]: super=0x0x298fb704 objc=SOGo slots=connect,GET,view,casProxy,index,saml2-signon-post,changePassword,saml2-metadata,loading,toolbar Jul 03 12:28:14 sogod [50769]: |SOGo| looked up value: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| lookup in root object: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| GOT: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| request took 0.003298 seconds to execute 196.200.26.114 - - [03/Jul/2013:12:28:14 GMT] POST /SOGo/so/ ro...@crownkenya.com/freebusy.ifb/ajaxRead?sday=20130701eday=20130715HTTP/1.1 404 72/0 0.005 - - - And I got lost:) I beg someone familiar with this to explain to me the use case, and why I am getting stuck. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo - ResourceConfiguration
Try to search for SOGo Resources This might be useful: https://inverse.ca/sogo/lists/arc/users/2011-04/msg00303.html Check SOGo user guide for options for the resources. You have some explanations there. Regarding wiki page: http://wiki.sogo.nu/ResourceConfiguration I have added Configure resources with SQL databases part, so I might be able to help you. Regarding SOGoCalendarDefaultRoles = (PublicViewer,ConfidentialDAndTViewer,PrivateDAndTViewer); It is recommended settings, but you need minimum DAndTViewer in order to be able to see free/busy. If you have changed sogo.conf, do not forget to reload sogod as well as memched and apache. Just to be on the safe side. :-) Regards, Igor Odhiambo Washington wrote, On 03/07/2013 11:28: I hope I am not pissing off guys on this forum with my myriad questions about SOGo - having discovered it just the other week after someone mentioned it on another mailing list. I realize SOGo is not for FreeBSD, but I have several servers that could do with such a Groupware and I am learning the curves while playing and getting stuck. I just learnt about Resource Configuration from an old thread: http://wiki.sogo.nu/ResourceConfiguration I still don't understand it. Why do I require this? Can someone please give me a case scenario? I am using MySQL auth, using a VIEW instead of a standalone database. Before knowing a use case of Resources, I configured it on my test platform and promptly got stuck! I created a user(resource): +--+---+--+--+--+---+ | c_uid| c_name| c_cn | mail | kind | multiple_bookings | +--+---+--+--+--+---+ | ro...@crownkenya.com mailto:ro...@crownkenya.com | Meeting Room1 | ro...@crownkenya.com mailto:ro...@crownkenya.com | ro...@crownkenya.com mailto:ro...@crownkenya.com | location | 1 | +--+---+--+--+--+---+ I then added the following to sogo.conf: SOGoCalendarDefaultRoles = (PublicViewer,ConfidentialDAndTViewer,PrivateDAndTViewer); I understand that is the ACL required to enable a resource to work. Under my SOGoUserResourced, I added two parameters: MultipleBookingsFieldName = multiple_bookings; KindFieldName = kind; Now, as the Wiki says (remember I still don't quite understand the use case for this) I logged in and created an event in my Calendar and tried to add the resource as a participant. The problem is I could NOT save the event! The following would display in sogo.log: Jul 03 12:28:14 sogod [50769]: |SOGo| starting method 'POST' on uri '/SOGo/so/ro...@crownkenya.com/freebusy.ifb/ajaxRead?sday=20130701eday=20130715 http://ro...@crownkenya.com/freebusy.ifb/ajaxRead?sday=20130701eday=20130715' Jul 03 12:28:14 sogod [50769]: |SOGo| lookup name: ro...@crownkenya.com mailto:ro...@crownkenya.com Jul 03 12:28:14 sogod [50769]: |SOGo| did not find key 'ro...@crownkenya.com mailto:ro...@crownkenya.com' in SoClass: 0x0x298fba84[SoObjCClass]: super=0x0x298fb704 objc=SOGo slots=connect,GET,view,casProxy,index,saml2-signon-post,changePassword,saml2-metadata,loading,toolbar Jul 03 12:28:14 sogod [50769]: |SOGo| looked up value: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| lookup in root object: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| GOT: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| lookup name: ro...@crownkenya.com mailto:ro...@crownkenya.com Jul 03 12:28:14 sogod [50769]: |SOGo| did not find key 'ro...@crownkenya.com mailto:ro...@crownkenya.com' in SoClass: 0x0x298fba84[SoObjCClass]: super=0x0x298fb704 objc=SOGo slots=connect,GET,view,casProxy,index,saml2-signon-post,changePassword,saml2-metadata,loading,toolbar Jul 03 12:28:14 sogod [50769]: |SOGo| looked up value: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| lookup in root object: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| GOT: (null) Jul 03 12:28:14 sogod [50769]: |SOGo| request took 0.003298 seconds to execute 196.200.26.114 - - [03/Jul/2013:12:28:14 GMT] POST /SOGo/so/ro...@crownkenya.com/freebusy.ifb/ajaxRead?sday=20130701eday=20130715 http://ro...@crownkenya.com/freebusy.ifb/ajaxRead?sday=20130701eday=20130715 HTTP/1.1 404 72/0 0.005 - - - And I got lost:) I beg someone familiar with this to explain to me the use case, and why I am getting stuck. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 I can't hear you -- I'm using the scrambler. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo - ResourceConfiguration
Hello Igor, Thanks for the link on SOGo Resources. I will read that tonight and see how much I get to understand. I had already checked the SOGo Installation Guide. Here is what I think caused my problem: I had logged in as the resource and created an event. Sorry, I did not remember to keep the event details before I deleted it. However, after I deleted the event, I was able to login as myself and create an event and invite the resource as a participant - successfully. Viewing the Raw source of the event: BEGIN:VCALENDAR PRODID:-//Inverse inc./SOGo 2.0.6b//EN VERSION:2.0 BEGIN:VTIMEZONE TZID:Africa/Nairobi X-LIC-LOCATION:Africa/Nairobi BEGIN:STANDARD TZOFFSETFROM:+0300 TZOFFSETTO:+0300 TZNAME:EAT DTSTART:19700101T00 END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:C651-51D42400-1F-6B8B4580 SUMMARY:Test Event DESCRIPTION:Test CLASS:PUBLIC ATTENDEE;PARTSTAT=ACCEPTED;RSVP=TRUE;ROLE=REQ-PARTICIPANT;CN=room1@crownken ya.com:mailto:ro...@crownkenya.com ORGANIZER;CN=w...@crownkenya.com:mailto:w...@crownkenya.com CREATED:20130703T131725Z DTSTAMP:20130703T131725Z LAST-MODIFIED:20130703T131725Z DTSTART;TZID=Africa/Nairobi:20130708T08 DTEND;TZID=Africa/Nairobi:20130708T15 TRANSP:OPAQUE END:VEVENT END:VCALENDAR So, perhaps what I need to understand is that when multiple_bookings = 1 and someone else already has booked an event, then the resource become unavailable, right??? That would explain why I wasn't able to add the resource as participant in my event because resource already had a booking. If the room1 is a resource, should it not be able to accessible it at different times, as long as there is no clash/overlap in the schedules? I think this Resources thing is beginning to sink in now -- if a resource is booked for an event, it should be unavailable to others. However, I think it should be available when there is no clash/overlap in the event schedules, right? On 3 July 2013 15:51, Igor Vitorac igor.vito...@eurodyn.be wrote: Try to search for SOGo Resources This might be useful: https://inverse.ca/sogo/lists/arc/users/2011-04/msg00303.html Check SOGo user guide for options for the resources. You have some explanations there. Regarding wiki page: http://wiki.sogo.nu/ResourceConfiguration I have added Configure resources with SQL databases part, so I might be able to help you. Regarding SOGoCalendarDefaultRoles = (PublicViewer,ConfidentialDAndTViewer,PrivateDAndTViewer); It is recommended settings, but you need minimum DAndTViewer in order to be able to see free/busy. If you have changed sogo.conf, do not forget to reload sogod as well as memched and apache. Just to be on the safe side. :-) Regards, Igor Odhiambo Washington wrote, On 03/07/2013 11:28: I hope I am not pissing off guys on this forum with my myriad questions about SOGo - having discovered it just the other week after someone mentioned it on another mailing list. I realize SOGo is not for FreeBSD, but I have several servers that could do with such a Groupware and I am learning the curves while playing and getting stuck. I just learnt about Resource Configuration from an old thread: http://wiki.sogo.nu/ResourceConfiguration I still don't understand it. Why do I require this? Can someone please give me a case scenario? I am using MySQL auth, using a VIEW instead of a standalone database. Before knowing a use case of Resources, I configured it on my test platform and promptly got stuck! I created a user(resource): +--+---+--+--+--+---+ | c_uid| c_name| c_cn | mail | kind | multiple_bookings | +--+---+--+--+--+---+ | ro...@crownkenya.com | Meeting Room1 | ro...@crownkenya.com | ro...@crownkenya.com | location | 1 | +--+---+--+--+--+---+ I then added the following to sogo.conf: SOGoCalendarDefaultRoles = (PublicViewer,ConfidentialDAndTViewer,PrivateDAndTViewer); I understand that is the ACL required to enable a resource to work. Under my SOGoUserResourced, I added two parameters: MultipleBookingsFieldName = multiple_bookings; KindFieldName = kind; Now, as the Wiki says (remember I still don't quite understand the use case for this) I logged in and created an event in my Calendar and tried to add the resource as a participant. The problem is I could NOT save the event! The following would display in sogo.log: Jul 03 12:28:14 sogod [50769]: |SOGo| starting method 'POST' on uri '/SOGo/so/ ro...@crownkenya.com/freebusy.ifb/ajaxRead?sday=20130701eday=20130715' Jul 03 12:28:14 sogod [50769]: |SOGo| lookup name: ro...@crownkenya.com Jul 03 12:28:14 sogod [50769]: |SOGo| did not find
Re: [SOGo] SOGo - ResourceConfiguration
Please see inline my answers Odhiambo Washington wrote, On 03/07/2013 15:31: So, perhaps what I need to understand is that when multiple_bookings = 1 and someone else already has booked an event, then the resource become unavailable, right??? That would explain why I wasn't able to add the resource as participant in my event because resource already had a booking. multiple_bookings tells sogo how many events could be booked at one time. If you had already one event for that time slot, that is normal behavior. If the room1 is a resource, should it not be able to accessible it at different times, as long as there is no clash/overlap in the schedules? It will prevent event save only in case there is time slot overlap and multiple_bookings number is already reached for that time slot. -- users@sogo.nu https://inverse.ca/sogo/lists