[SOGo] SOGo User Limitation
Hi, Previously I was told that SOGo got problem that it is unable to handle user if more than 100 users. In this new release of 2.0.6b, had the limitation being fixed? Thank you -- users@sogo.nu https://inverse.ca/sogo/lists
[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 User Limitation
Who told you this? Did s/he explain where/at what point the limitation comes in? On 3 July 2013 10:48, Mail Robot themailro...@gmail.com wrote: Hi, Previously I was told that SOGo got problem that it is unable to handle user if more than 100 users. In this new release of 2.0.6b, had the limitation being fixed? Thank you -- 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
[SOGo] Mail: Move To... Calendar?
Hi - I'm writing this email to the users list before submitting a bug report because I suspect I may just be not seeing the method. How do I use an email as the basis of a calendar entry? I tried right-clicking it and looking in Copy To... and Move To... but that seems only to contain other mail folders. I can make the calendar send emails, but I don't see how to turn emails into calendar appointments without repeated copy-pasting (once to the description and then once for each piece of information in the email, such as local attendees, location and so on). It would be great if SOGo could do this more slickly than that. Or turning emails into tasks would be good, too. Thanks in advance for any answers, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo User Limitation
Am 03.07.13 09:48, schrieb Mail Robot: Previously I was told that SOGo got problem that it is unable to handle user if more than 100 users. Really? Where did you get this info? The University of Konstanz has about 3000 Users, what I heard. The use SOGo for some years. Greetings, Martin -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] dpkg error while processing sogo-package (2.0.6b)
-- From: Jean Raby jr...@inverse.ca Sent: Tuesday, July 02, 2013 11:50 PM To: users@sogo.nu Subject: Re: [SOGo] dpkg error while processing sogo-package (2.0.6b) On 13-07-02 11:06 AM, Davor Vusir wrote: New install. No go. No ideas. Regards Davor --- root@mail:~# apt-get install sogo sope4.9-gdl1-mysql Reading package lists... Done Building dependency tree Reading state information... Done sope4.9-gdl1-mysql is already the newest version. new install, yet sope4.9-gdl1-mysql is already installed? Suggested packages: nginx The following NEW packages will be installed: sogo 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. Need to get 0 B/3,954 kB of archives. After this operation, 12.9 MB of additional disk space will be used. Do you want to continue [Y/n]? Y (Reading database ... 69845 files and directories currently installed.) Unpacking sogo (from .../sogo_2.0.6b-1_amd64.deb) ... install: invalid group `sogo' somehow the sogo group wasn't created. The code is pretty simple: if [ $1 == install ] || [ $1 == upgrade ]; then if ! id sogo 1 /dev/null 21; then groupadd -f -r sogo useradd -d /var/lib/sogo -g sogo -c SOGo daemon -s /usr/sbin/nologin -r sogo fi ... The sogo user exists and the sogo group doesn't. create it and it should just work. On new installs, it should work since the sogo user won't exist. It turns out that compiling Samba4 and activating Winbind (using instructions from https://wiki.samba.org/index.php/Samba4/Winbind and http://iabsis.com/EN/article/35-2/Samba4-installation) before installing SOGo triggers the above error. -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo User Limitation
On 2013-07-03 6:28 AM, Martin Rabl wrote: Am 03.07.13 09:48, schrieb Mail Robot: Previously I was told that SOGo got problem that it is unable to handle user if more than 100 users. Really? Where did you get this info? He's most likely talking about the SOGo/OpenChange part - which has this limitation. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] dpkg error while processing sogo-package (2.0.6b)
This one was sent somewhat too early... Continued below. -- From: Davor Vusir davor.vu...@live.se Sent: Wednesday, July 03, 2013 12:31 PM To: users@sogo.nu Subject: Re: [SOGo] dpkg error while processing sogo-package (2.0.6b) -- From: Jean Raby jr...@inverse.ca Sent: Tuesday, July 02, 2013 11:50 PM To: users@sogo.nu Subject: Re: [SOGo] dpkg error while processing sogo-package (2.0.6b) On 13-07-02 11:06 AM, Davor Vusir wrote: New install. No go. No ideas. Regards Davor --- root@mail:~# apt-get install sogo sope4.9-gdl1-mysql Reading package lists... Done Building dependency tree Reading state information... Done sope4.9-gdl1-mysql is already the newest version. new install, yet sope4.9-gdl1-mysql is already installed? Suggested packages: nginx The following NEW packages will be installed: sogo 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. Need to get 0 B/3,954 kB of archives. After this operation, 12.9 MB of additional disk space will be used. Do you want to continue [Y/n]? Y (Reading database ... 69845 files and directories currently installed.) Unpacking sogo (from .../sogo_2.0.6b-1_amd64.deb) ... install: invalid group `sogo' somehow the sogo group wasn't created. The code is pretty simple: if [ $1 == install ] || [ $1 == upgrade ]; then if ! id sogo 1 /dev/null 21; then groupadd -f -r sogo useradd -d /var/lib/sogo -g sogo -c SOGo daemon -s /usr/sbin/nologin -r sogo fi ... The sogo user exists and the sogo group doesn't. create it and it should just work. On new installs, it should work since the sogo user won't exist. It turns out that compiling Samba4 and activating Winbind (using instructions from https://wiki.samba.org/index.php/Samba4/Winbind and http://iabsis.com/EN/article/35-2/Samba4-installation) before installing SOGo triggers the above error. and a user 'sogo' exists in the Samba4 AD. root@mail:/# getent passwd EXAMPLE\sogo:*:318:100::/home/EXAMPLE/sogo:/bin/bash Turning off Samba4 root@mail:/# /etc/init.d/samba4 stop * Stopping Samba 4 daemon samba [ OK ] and run the installation again root@mail:/# apt-get install sogo mysql-server sope4.9-gdl1-mysql Reading package lists... Done Building dependency tree Reading state information... Done mysql-server is already the newest version. sope4.9-gdl1-mysql is already the newest version. Suggested packages: nginx The following NEW packages will be installed: sogo 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. 21 not fully installed or removed. . . . Setting up sogo (2.0.6b-1) ... * Starting SOGo sogo[ OK ] Processing triggers for libc-bin ... ldconfig deferred processing now taking place root@mail:/# fixes it. With a running Samba4 and no user 'sogo' in Samba4 AD does it too. Cool, huh! /Davor -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Re: SOGo User Limitation
Hi, Yeah, since SOGo depend on OpenChange for Outlook user's native experience. Had this issues resolved? Regards On Wednesday, July 3, 2013, Ludovic Marcotte wrote: On 2013-07-03 6:28 AM, Martin Rabl wrote: Am 03.07.13 09:48, schrieb Mail Robot: Previously I was told that SOGo got problem that it is unable to handle user if more than 100 users. Really? Where did you get this info? He's most likely talking about the SOGo/OpenChange part - which has this limitation. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence ( http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo User Limitation
It does have a limit of 100 users with OpenChange?? On 3 July 2013 14:00, Ludovic Marcotte lmarco...@inverse.ca wrote: On 2013-07-03 6:28 AM, Martin Rabl wrote: Am 03.07.13 09:48, schrieb Mail Robot: Previously I was told that SOGo got problem that it is unable to handle user if more than 100 users. Really? Where did you get this info? He's most likely talking about the SOGo/OpenChange part - which has this limitation. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence ( http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- 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 MySQL Authentication
Hello Odhiambo Washington
Am 2013-06-26 14:46, schrieb Odhiambo Washington:
I am almost bald trying to get authentication using mysql working. The
difficult part is how to tell what SOGo is exactly doing (debugging) so
that I can fix it.
I have in my sogo.conf:
/* MySQL Authentication */
SOGoUserSources = (
{
type = sql;
canAuthenticate = YES;
displayName = Staff Members;
id = users;
isAddressBook = YES;
userPasswordAlgorithm = md5;
viewURL
=mysql://exim4u:XXX@127.0.0.1:3306/exim4u/sogo_auth_view
http://exim4u:XXX@127.0.0.1:3306/exim4u/sogo_auth_view;
}
);
And I created a view on my DB as follows:
CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS
c_uid, realname AS c_name, clear AS c_password, username AS c_cn, use
rname AS mail, realname AS displayName FROM users WHERE enabled='1';
Which gives me:
mysql select * from exim4u.sogo_auth_view where c_name like '%wash%';
+-+-+-++-+-+-+
| sogo_id | c_uid | c_name | c_password |
c_cn| mail| displayName |
+-+-+-++-+-+-+
| 3 | w...@kictanet.or.ke mailto:w...@kictanet.or.ke | Odhiambo
WASHINGTON | secret1| w...@kictanet.or.ke
mailto:w...@kictanet.or.ke | w...@kictanet.or.ke
mailto:w...@kictanet.or.ke | Odhiambo WASHINGTON |
+-+-+-++-+-+-+
I am trying to login using username=w...@kictanet.or.ke
mailto:w...@kictanet.or.ke and password=whateveritis but I always get
failure... wrong username or password.
..
Is there something I am doing wrong?? Is it wrong password format?
In your SOGo configuration you say userPasswordAlgorithm = md5, but it
seems you have plain text passwords in your Mysql view.
Is that correct?
Then just use md5 hashed passwords in your view and it should work.
My assumption is that SOGo is supposed to be sending these login details
to my IMAP (Dovecot), right? Looking at my dovecot logs, I see no
connection attempts...
It will do that, but it will check your username and password against
the mysql view first.
As that isn't working, it will not try to connect to the IMAP server at all.
Kind regards,
Christian Mack
--
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universität Konstanz
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] SOGo MySQL Authentication
Hi Christian,
I managed to wade past the authentication stage, actually. I used an MD5
encrypted password in that field and changed the userPasswordAlgorithm =
crypt, which worked for me after a suggestion from another member of this
list.
Thanks for the follow up.
Do you by any chance use Resource Configurations. I am at that stage of the
SOGo learning curve. I posted a question today. Hopefully you have ideas on
that too:)
On 3 July 2013 15:20, Christian Mack christian.m...@uni-konstanz.de wrote:
Hello Odhiambo Washington
Am 2013-06-26 14:46, schrieb Odhiambo Washington:
I am almost bald trying to get authentication using mysql working. The
difficult part is how to tell what SOGo is exactly doing (debugging) so
that I can fix it.
I have in my sogo.conf:
/* MySQL Authentication */
SOGoUserSources = (
{
type = sql;
canAuthenticate = YES;
displayName = Staff Members;
id = users;
isAddressBook = YES;
userPasswordAlgorithm = md5;
viewURL
=mysql://exim4u:XXX@127.0.0.1:3306/exim4u/sogo_auth_view
http://exim4u:XXX@127.0.0.1:3306/exim4u/sogo_auth_view;
}
);
And I created a view on my DB as follows:
CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS
c_uid, realname AS c_name, clear AS c_password, username AS c_cn, use
rname AS mail, realname AS displayName FROM users WHERE enabled='1';
Which gives me:
mysql select * from exim4u.sogo_auth_view where c_name like '%wash%';
+-+-+-++-+-+-+
| sogo_id | c_uid | c_name | c_password |
c_cn| mail| displayName |
+-+-+-++-+-+-+
| 3 | w...@kictanet.or.ke mailto:w...@kictanet.or.ke | Odhiambo
WASHINGTON | secret1| w...@kictanet.or.ke
mailto:w...@kictanet.or.ke | w...@kictanet.or.ke
mailto:w...@kictanet.or.ke | Odhiambo WASHINGTON |
+-+-+-++-+-+-+
I am trying to login using username=w...@kictanet.or.ke
mailto:w...@kictanet.or.ke and password=whateveritis but I always get
failure... wrong username or password.
..
Is there something I am doing wrong?? Is it wrong password format?
In your SOGo configuration you say userPasswordAlgorithm = md5, but it
seems you have plain text passwords in your Mysql view.
Is that correct?
Then just use md5 hashed passwords in your view and it should work.
My assumption is that SOGo is supposed to be sending these login details
to my IMAP (Dovecot), right? Looking at my dovecot logs, I see no
connection attempts...
It will do that, but it will check your username and password against
the mysql view first.
As that isn't working, it will not try to connect to the IMAP server at
all.
Kind regards,
Christian Mack
--
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universität Konstanz
--
users@sogo.nu
https://inverse.ca/sogo/lists
--
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 hangs trying to connect to external imap-server
Suppose you just change that parameter to: SOGoIMAPServer = imap.bws-uster.ch; Does it make a difference? I have used the parameter even with an IP address and it worked. On 30 June 2013 19:53, u...@rumlikon.ch wrote: Hi sogo-gods I've set up sogo (2-0-6b) on an ubuntu server 12.04. I'm authenticating against an active directory. Everything works great except imap. We are using a third party imap-server. I'm using the same password for AD and imap. My relvant config file looks like that: /* Mail */ //SOGoDraftsFolderName = Drafts; SOGoSentFolderName = Sent; SOGoTrashFolderName = Trash; SOGoIMAPServer = imap://imap.bws-uster.ch:143; SOGoForceExternalLoginWithEmail = YES; Sogo tries to connect but then just hangs for 10 minutes until the safty-belt recovers the system. I've checked the connectivity to imap with telnet. It works great. sogoadmin@sogo:~$ telnet imap.bws-uster.ch imap Trying 92.43.217.103... Connected to imap.bws-uster.ch. Escape character is '^]'. * OK Webland Mail Server v. 10.4.1 IMAP4rev1 Sun, 30 Jun 2013 18:50:19 +0200 01 login t...@bws-uster.ch *** 01 OK LOGIN Completed 02 List * * LIST (\HasNoChildren \Noinferiors) / Spam * LIST (\HasNoChildren) / INBOX 02 OK LIST Completed 03 examine inbox * FLAGS (\Seen \Answered \Flagged \Deleted \Draft \Recent $Forwarded $Redirected Junk NonJunk) * 0 EXISTS * 0 RECENT * OK [UIDVALIDITY 1121733603] UID validity * OK [UNSEEN 0] * OK [UIDNEXT 1] Predicted next UID * OK [PERMANENTFLAGS ( \*)] 03 OK [READ-ONLY] EXAMINE Completed 04 logout * BYE IMAP4rev1 Server terminating connection 04 OK LOGOUT Completed Log: 178.38.163.213 - - [30/Jun/2013:18:35:50 GMT] GET /SOGo/so/12LeuTil/Mail HTTP/1.1 302 0/0 0.003 - - 0 Jun 30 18:35:50 sogod [1346]: [ERROR] 0x0xb8688dd0[NGLdapAttribute] cound not convert value of objectSid to string Jun 30 18:35:50 sogod [1346]: [ERROR] 0x0xb8774e20[NGLdapAttribute] cound not convert value of objectGUID to string 2013-06-30 18:35:50.416 sogod[1346] WARNING: IMAP4 connection pooling is disabled! 2013-06-30 18:35:50.692 sogod[1346] Note(NGImap4Connection): using '/' as the IMAP4 folder separator. Jun 30 18:36:50 sogod [1275]: [WARN] 0x0xb846ae10[WOWatchDogChild] pid 1346 has been hanging in the same request for 1 minutes Has anybody an idea what I'm doing wrong? Thanks in advance ueli -- users@sogo.nu https://inverse.ca/sogo/lists -- 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 User Limitation
It does have a limit of 100 users with OpenChange?? On 3 July 2013 14:00, Ludovic Marcotte lmarco...@inverse.ca wrote: On 2013-07-03 6:28 AM, Martin Rabl wrote: Am 03.07.13 09:48, schrieb Mail Robot: Previously I was told that SOGo got problem that it is unable to handle user if more than 100 users. Really? Where did you get this info? He's most likely talking about the SOGo/OpenChange part - which has this limitation. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence ( http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- 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 -- 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 User Limitation
Am 03.07.13 13:00, schrieb Ludovic Marcotte: On 2013-07-03 6:28 AM, Martin Rabl wrote: Am 03.07.13 09:48, schrieb Mail Robot: Previously I was told that SOGo got problem that it is unable to handle user if more than 100 users. Really? Where did you get this info? He's most likely talking about the SOGo/OpenChange part - which has this limitation. Ah, thank you, Ludovic! Greetings, Martin -- 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
[SOGo] Re: SOGo User Limitation
Hi, Any plan for the fix to be released? On Wednesday, July 3, 2013, Martin Rabl wrote: Am 03.07.13 13:00, schrieb Ludovic Marcotte: On 2013-07-03 6:28 AM, Martin Rabl wrote: Am 03.07.13 09:48, schrieb Mail Robot: Previously I was told that SOGo got problem that it is unable to handle user if more than 100 users. Really? Where did you get this info? He's most likely talking about the SOGo/OpenChange part - which has this limitation. Ah, thank you, Ludovic! Greetings, Martin -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] E-Mail reminders on tasks
Hello all together I want to activate the reminder function for tasks. I have set: OCSEMailAlarmsFolderURL mysql://xxx:xxx@localhost:3306/sogo/sogo_alarms_folder SOGoEnableEMailAlarms YES and enabled the cron job for sogo-ealarms-notify. The reminders for events work, but I can't set a reminder for tasks. It seems, that I am not the first one with this problem. I have found an other question to this problem, but no answer. I hope someone can help me. Greeting Johannes Mock -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Re: SOGo User Limitation
Am 03.07.2013 16:22, schrieb Mail Robot: Hi, Any plan for the fix to be released? out of interest: what's the technical background of the 100-limit in openchange ? André -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Validating smime signature failes
Hello Konrad Mauz Am 2013-05-06 15:20, schrieb Konrad Mauz: I have SOGo 2.04b installed on ubuntu 12.04 LTS. When I open an email with smime signature, I always get the error: Digital signature is not valid. I have copied all ca certificates from the certificate chain in the directory /etc/ssl/certs and run c_rehash. Unfortunatly this does not solve the problem. I have tried to strace the sogod process - it only opens the first ca certificate ( telekom2ca in my case ). The process does not try to open the next ca certificate. I do not know why? Has anybody managed to get smime signature checking working on ubuntu 12.04 lts? As you are on Ubuntu. Did you install the package ca-certificates ? sudo apt-get install ca-certificates Then copy your *.pem ca certificates as *.crt into /usr/share/ca-certificates/ And reconfigure it with: sudo dpkg-reconfigure ca-certificates This will add these ca certificates and create the appropriate links. I don't know, if that helps though. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Re: SOGo User Limitation
Really exist this limit? There are an official answer? Il giorno 03/lug/2013 16:47, André Schild an...@schild.ws ha scritto: Am 03.07.2013 16:22, schrieb Mail Robot: Hi, Any plan for the fix to be released? out of interest: what's the technical background of the 100-limit in openchange ? André -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Wednesday, July 03 2013
Title: BTS activities for Wednesday, July 03 2013 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Wednesday, July 03 2013 idlast updatestatus (resolution)categorysummary 2365 2013-07-03 03:34:16 new (open) Backend Calendar Private URL for calendar 2366 2013-07-03 16:49:11 new (open) Backend Mail Implement IMAP ID x-originating-ip as x-webobjects-remote-host.. 2348 2013-07-03 10:52:00 updated (open) Web Calendar Displayed date while inviting isn't in the god format
