[SOGo] Using resources with SQL-based authentication

2012-08-10 Thread Igor Vitorac
would appreciate if anybody has any hints or examples? Many thanks, Igor Vitorac SOGo 1.3.17 -- users@sogo.nu https://inverse.ca/sogo/lists

Re: [SOGo] Using resources with SQL-based authentication

2012-08-13 Thread Igor Vitorac
Thanks. We will try to put some resources in place for SQL based user sources, and I will let you know about the results. Regards, Igor Vitorac Ludovic Marcotte wrote, On 12/08/2012 01:18: On 11/08/12 18:05, Igor Vitorac wrote: Thank you. I have seen that, but it is not quite clear what

[SOGo] Does SOGo domain requires DNS domain?

2012-09-18 Thread Igor Vitorac
Hi, Are there any limitations concerning SOGo domain and DNS domain i.e. does SOGo domain requires the same DNS domain? Practical example: If we want to make one SOGo instance available to one group of people (or one community) which belongs to various DNS domains (with various email

Re: [SOGo] ANN: SOGo v2.0.0

2012-09-28 Thread Igor Vitorac
I have added new feature request for similar thing: http://www.sogo.nu/bugs/view.php?id=1997 Regards, Igor Robert Casties wrote, On 28/09/2012 18:17: I'd really like to do something so that new events in shared calendars have the creator of the event and the creation date added to the note

Re: [SOGo] Calendar and contact roles

2012-10-02 Thread Igor Vitorac
SOGoCalendarDefaultRoles does not affect anonymous access, but only Authenticated users. Regards, Igor Christian Mack wrote, On 02/10/2012 12:20: Hello Vincent Gatignol On 2012-10-01 19:20, Vincent Gatignol wrote: Le 15/08/2012 11:07, Christian Mack a écrit : On 2012-06-21 13:43, ANAND

[SOGo] Using email address for c_uid and c_name with SQL user source

2012-10-03 Thread Igor Vitorac
Hi, Is there any limitation to use email address for c_uid and c_name for SQL users sources? Thanks, Igor -- users@sogo.nu https://inverse.ca/sogo/lists

Re: [SOGo] iCal and u...@domain.com

2012-10-04 Thread Igor Vitorac
Hi Christian, I have the similar behavior with CalDAV. Most probably that is an issue with CalDAV and TB/Lightning but I can not confirm it now. If I use the following example: c_uid = c_name = user1 mail = first1.la...@domain.com TB/Lightning creates email us...@domain.com as organizer. So,

Re: [SOGo] Creating Calendar Resources

2012-10-08 Thread Igor Vitorac
Hello Sven, Most probably you have problem with ACL. Check on the following page: http://wiki.sogo.nu/ResourceConfiguration Be sure that the resource has set at MINIMUM View Time and Date for All Authenticated Users is set in ACL. So, you can: 1. either login as that resource and configure

Re: [SOGo] Resource Creation with MySQL database

2012-10-17 Thread Igor Vitorac
Problem is related to the minimal ACL which needs to be set on meeting room calendar. Wiki page for SQL user source is updated: http://wiki.sogo.nu/ResourceConfiguration Regards, Igor Jeff Folk wrote, On 29/08/2012 15:57: On Aug 29, 2012, at 8:27 AM, Karthikeyan BALASUBRAMANIAN wrote: Hi

Re: [SOGo] Using resources with SQL-based authentication

2012-10-17 Thread Igor Vitorac
We have successfully configured resources for SQL based user sources. I have updated SOGo wiki page: http://wiki.sogo.nu/ResourceConfiguration Igor Vitorac wrote, On 13/08/2012 11:19: Thanks. We will try to put some resources in place for SQL based user sources, and I will let you know about

Re: [SOGo] Manage room and other asset.

2012-10-24 Thread Igor Vitorac
Please see the following: http://wiki.sogo.nu/ResourceConfiguration Regards, Igor Albert Shih wrote, On 24/10/2012 11:12: Hi. Sometime ago I've see a feature in SOGO for put the management of room and other asset in SOGo. But I don't find any documentation about that. What I remember I

Re: [SOGo] Manage room and other asset.

2012-10-25 Thread Igor Vitorac
It is not clear what you mean. Could you please clarify? Regards, Igor Albert Shih wrote, On 24/10/2012 23:37: Le 24/10/2012 12:18, Igor Vitorac a écrit : Please see the following: http://wiki.sogo.nu/ResourceConfiguration Sometime ago I've see a feature in SOGO for put the management

Re: [SOGo] Change Logo

2012-10-25 Thread Igor Vitorac
You can do the following: - create your custom SOGoRootPage.wox file where you will replace sogo-logo.png with my_logo.png - place your custom login page SOGoRootPage.wox to /home/sogo/GNUstep/Library/SOGo/Templates/MainUI - copy your my_logo.png to the same folder where your sogo-logo.png

Re: [SOGo] Hooks status in SOGo

2012-10-30 Thread Igor Vitorac
20:46: On 29/10/12 13:10, Igor Vitorac wrote: Any news about hooks status? The status hasn't changed much. The initial PoC is ready to go but we need to create a few packages (RPM/deb) to make things easily installable. If you're familiar building everything some sources, I could send you

Re: [SOGo] SSL and non-SSL access to SOGo

2012-10-30 Thread Igor Vitorac
1:23 +0400 Николай Клименко <klimenk...@theitidea.ru> wrote: >hi >it's not a good idea cause if you have mobile users you can face with the problem that they can be outside . > >30.10.12 20:02, Igor Vitorac пишет: >> I would like to setup both SSL and non-SSL access to SOGo: >&g

Re: [SOGo] SOGoUsersSource Configuration Help

2012-10-31 Thread Igor Vitorac
I think the mentioned config is not possible. Pay attention that even if you have the same user details in 2 different sources, they will behave like two different SOGo users. If you depend on Samba, then make sure that you have Samba available all the time. Proposed SOGo config is not a way

Re: [SOGo] SSL and non-SSL access to SOGo

2012-10-31 Thread Igor Vitorac
formatting issues. Николай Клименко wrote, On 30/10/2012 20:01: hi it's not a good idea cause if you have mobile users you can face with the problem that they can be outside . 30.10.12 20:02, Igor Vitorac пишет: I would like to setup both SSL and non-SSL access to SOGo: - SSL for accessing SOGo from

Re: [SOGo] SSL and non-SSL access to SOGo

2012-10-31 Thread Igor Vitorac
Seems very elegant solution even I am not very familiar with RewriteEngine. If this is something that works for every case, I would say that putting your proxy section in standard SOGo package would allow SOGo install without any change of this file later (as one of the install steps). Maybe

Re: [SOGo] Using the same email for all meeting rooms is not possible?!

2012-10-31 Thread Igor Vitorac
wrote, On 31/10/2012 11:29: Hello Igor Vitorac On 2012-10-30 11:52, Igor Vitorac wrote: I have tried to test using the resources with the same email address. User backend is SQL (MySQL) user source and SOGo 2.0 If I configure following resources: C Uid: room1 C Name: room1 C Cn: Meeting room1 Mail

Re: [SOGo] Email is empty

2012-10-31 Thread Igor Vitorac
I have a problem that only Inbox is not visible for one user. Oct 31 13:21:59 sogod [1681]: 0x0xb62c3964[NGImap4Client] ERROR(-[NGImap4Client _processCommandParserException:]): catched IMAP4 parser exception NGImap4ParserException: unexpected char expected ( Oct 31 13:21:59 sogod [1681]:

Re: [SOGo] SOGoUsersSource Configuration Help

2012-10-31 Thread Igor Vitorac
Sorry my mistake. I had in mind another scenario where user name patterns for login into SOGo were different (e.g. user1@domain and user1). Christian Mack wrote, On 31/10/2012 14:28: On 2012-10-31 09:24, Igor Vitorac wrote: I think the mentioned config is not possible. Pay attention

Re: [SOGo] Hooks status in SOGo

2012-11-07 Thread Igor Vitorac
Has anyone managed to implement hooks? Regards, Igor Igor Vitorac wrote, On 30/10/2012 11:29: I am familiar with building from sources, but I prefer to run it from packages. In any case, I would like to see the instructions. Maybe some other people are also interested, so we could

Re: [SOGo] Resources Manual Accepting

2012-11-07 Thread Igor Vitorac
If you want to do approvals, then you should consider using normal user type for such case and grant appropriate ACL for the persons responsible for approving reservations. In that case responsible person will need to Accept event invitations, and to Reject in case not approved. Regards, Igor

Re: [SOGo] Free/Busy permissions

2012-11-13 Thread Igor Vitorac
Add this to your sogo config: defaults write sogod SOGoCalendarDefaultRoles '(PublicDAndTViewer,ConfidentialDAndTViewer,PrivateDAndTViewer)' Regards, Igor Simon Walter wrote, On 13/11/2012 06:44: I may be mistaken, but it seems that users must allow any authenticated user to view the date

Re: [SOGo] Free/Busy permissions

2012-11-13 Thread Igor Vitorac
, On 13/11/2012 14:52: On 12-11-13 3:44 AM, Igor Vitorac wrote: Add this to your sogo config: defaults write sogod SOGoCalendarDefaultRoles '(PublicDAndTViewer,ConfidentialDAndTViewer,PrivateDAndTViewer)' Do this only if you want Confidential and Private events to show up in free/busy *by default

Re: [SOGo] Setting of Calendar Default Access rights for Public Access

2012-11-16 Thread Igor Vitorac
Hello Christian, Could you please let me know how can I reproduce/test unauthenticated access for free/busy status? Thanks, Igor Igor Vitorac wrote, On 13/11/2012 19:28: Hello Christian, If you configure: defaults write sogod SOGoCalendarDefaultRoles '(PublicDAndTViewer

Re: [SOGo] problem with saved password

2012-11-23 Thread Igor Vitorac
I had the same issue with MySQL authentication. Workaround is to restart memcached. Regards, Igor Николай Клименко wrote, On 23/11/2012 14:12: Hi! Currently i have Dovecot + postfix + SOGo with authorization through MS AD. The strange thing i have found out is that when user password is

Re: [SOGo] Thunderbird 17 ESR is here

2012-11-30 Thread Igor Vitorac
Hello Ludovic, how this new behavior will affect SOGo users in 2 following cases: - SOGo user has more then one email address defined - SOGo user is using different username then primary email address Will SOGo handle such cases properly? Thanks, Igor Ludovic Marcotte wrote, On 29/11/2012

Re: [SOGo] problem with saved password

2012-12-04 Thread Igor Vitorac
convenient solution at 300 users Is it possible to achieve a classical behavior? When user changed the password, TB requires a new password 23.11.12 17:24, Igor Vitorac пишет: I had the same issue with MySQL authentication. Workaround is to restart memcached. Regards, Igor Николай Клименко wrote

Re: [SOGo] sogo-tool does not backup contacts and agenda?

2013-01-21 Thread Igor Vitorac
Most probably you have tried the below command as root. Try it as sogo user, i.e. the user which is used for running sogo. Regards, Igor John Bieling wrote, On 18/01/2013 21:49: HI, I just tried to backup my users using sogo-tool. The created backup files do not contain any contact or

Re: [SOGo] Hooks status in SOGo

2013-01-22 Thread Igor Vitorac
+1 vote from me. Thanks, Igor Mark Knasiak wrote, On 21/01/2013 23:18: Is there any additional news on the hooks front or are we still in build-it-yourself territory? If so can you please send or post the instructions you mentioned in your reply? Any examples or the location of the source

Re: [SOGo] SOGo + External E-Mail Service + Different Password

2013-01-30 Thread Igor Vitorac
This is something very interesting and useful. I have seen this in few apps that we use e.g. Moodle Regards, Igor Alessio Fattorini wrote, On 30/01/2013 14:32: Il 18/11/2010 21:25, Ludovic Marcotte ha scritto: Hi Ludovic, One thing we could eventually support is an IMAP-based

Re: [SOGo] cant delete calendar dates in thunderbird/lightening

2013-02-04 Thread Igor Vitorac
Francis, Have you tested TB ESR 10 (and Lightning 1.2.3) with the latest SOGo release i.e. 2.0.4? In order to avoid this issue with Lightning, I am still running TB ESR10, and I would like to update SOGo to the latest release. Thanks, Igor Francis Lachapelle wrote, On 04/02/2013

Re: [SOGo] cant delete calendar dates in thunderbird/lightening

2013-02-04 Thread Igor Vitorac
Sorry for the question, I saw now that you still have it as supported one: http://www.sogo.nu/english/downloads/frontends.html So, I guess the answer is yes. Regards, Igor Igor Vitorac wrote, On 04/02/2013 14:44: Francis, Have you tested TB ESR 10 (and Lightning 1.2.3) with the latest SOGo

Re: [SOGo] What happens with SOGoPasswordChangeEnabled = YES

2013-03-06 Thread Igor Vitorac
Götz Reinicke - IT Koordinator wrote, On 06/03/2013 10:32: Hi, I'd like to tune our SOGo instalation and changing the userpassword from there would be nice. So I enabled SOGoPasswordChangeEnabled and can change my password. After that I cant login with my old password on my email clients.

Re: [SOGo] What happens with SOGoPasswordChangeEnabled = YES

2013-03-06 Thread Igor Vitorac
Jean Raby wrote, On 06/03/2013 15:07: On 13-03-06 4:50 AM, Igor Vitorac wrote: Götz Reinicke - IT Koordinator wrote, On 06/03/2013 10:32: Hi, I'd like to tune our SOGo instalation and changing the userpassword from there would be nice. So I enabled SOGoPasswordChangeEnabled and can change

[SOGo] Force all sogo and sope package to be updates when updating sogo

2013-04-01 Thread Igor Vitorac
It seems that there are problems with dependency checks when updating SOGo. I have tried to update sogo from 2.0.2a to 2.0.4b (on CentOS 6.2) and after performing yum update sogo, sogo was completely useless. Browser error: Proxy Error The proxy server received an invalid response from an

Re: [SOGo] Creating resources

2013-04-05 Thread Igor Vitorac
Have you checked this wiki page: http://wiki.sogo.nu/ResourceConfiguration It might be useful. Regards, Igor Luis Angel Fernandez Fernandez wrote, On 05/04/2013 09:57: Hi! I am trying to add some resources to my SOGo setup with no success. I have added the two schemas calentry and

Re: [SOGo] not sure how to add values to /etc/sogo/sogo.conf

2013-04-16 Thread Igor Vitorac
Jean Raby wrote, On 15/04/2013 21:32: On 13-04-15 3:23 PM, Szládovics Péter wrote: I'm not sure it's working as well, but try free this bash script to convert GNUstep defaults (created by defaults write sogod) to /etc/sogo/sogo.conf format. This script only reads the XML file and displays the

[SOGo] Lightning using the last email, again!

2013-04-18 Thread Igor Vitorac
It seems that latest Lightning (1.9.1) has again problem with Invitee email address. Or could it be SOGo (2.0.4b)? I can remember that there was such problem in previous Lightning versions. - I have 2 emails defined in TB: my_n...@example.be (this one is primary and defined as email in Calendar

Re: [SOGo] Lightning using the last email, again!

2013-04-19 Thread Igor Vitorac
According to the CalDAV standard, is server supposed to send all emails or just primary? I am trying to figure out where the problem resides. SOGo side or Lightning side? Thanks, Igor Igor Vitorac wrote, On 18/04/2013 16:22: It seems that latest Lightning (1.9.1) has again problem

Re: [SOGo] Lightning using the last email, again!

2013-04-22 Thread Igor Vitorac
please provide feedback from your side, i.e. to confirm that this is a Lightning bug, so we can push issue to Mozilla Lightning. Many thanks, Igor Vitorac Arnaud LE NORCY wrote, On 22/04/2013 17:46: Hello, sorry, but same problem... and no solution... With Thunderbird (and Lightning

Re: [SOGo] Lightning using the last email, again!

2013-04-25 Thread Igor Vitorac
respond to ANY (?) invitation if it finds it in Inbox or any other mail folder! Having this in mind, I don't know if CalDAV server still needs to send all emails to CalDAV client (Lightning), since Lightning will accept everything. Regards, Igor Igor Vitorac wrote, On 19/04/2013 09:32

Re: [SOGo] SOGo sender adress - sending mails from thunderbird

2013-05-15 Thread Igor Vitorac
This might be related/similar to your problem: https://bugzilla.mozilla.org/show_bug.cgi?id=865726 Seems that none of the parties (SOGo and Mozilla) are not interested in taking this into account. Regards, Igor Lennart Barfod wrote, On 15/05/2013 18:20: Hi Christian, thank you very

Re: [SOGo] Best practice of sogo system / user backup - suggestions?

2013-06-20 Thread Igor Vitorac
I have read many backup/restore hints and I have made the following: - I have one backup scripts that dumps all SOGo calendars and user settings with sogo-tool. Please see below HELPER BACKUP script - I have second backup script that picks output from first script and takes the rest Please see

Re: [SOGo] Best practice of sogo system / user backup - suggestions?

2013-06-21 Thread Igor Vitorac
Jan-Frode Myklebust wrote, On 21/06/2013 12:50: On Wed, Jun 19, 2013 at 01:28:00PM +0200, Götz Reinicke - IT Koordinator wrote: I'd like to ask what is your best practice to backup restore your sogo system and/or user data? Should we do a e.g. database dump/backup of the mysql (what we

Re: [SOGo] Free/Busy Functionality not working from Lightening

2013-06-28 Thread Igor Vitorac
Please see this issue: https://bugzilla.mozilla.org/show_bug.cgi?id=818419 Do you use multiple calendars maybe? Regards, Igor gsd2...@gmail.com wrote, On 28/06/2013 15:36: I am using Thunderbird version 17.0.5 on Linux 2.6.32-48-generic #110-Ubuntu SMP Fri May 31 19:05:31 UTC 2013 i686

Re: [SOGo] Disable Resource Event Creation

2013-07-02 Thread Igor Vitorac
Try to set MultipleBookingsFieldName to 0. http://wiki.sogo.nu/ResourceConfiguration Regards, Igor Ronald J. Yacketta wrote, On 02/07/2013 15:41: Thought I would toss this out their again in case it was over looked All, We have a couple conference rooms that are under construction and

Re: [SOGo] SOGo - ResourceConfiguration

2013-07-03 Thread Igor Vitorac
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

Re: [SOGo] SOGo - ResourceConfiguration

2013-07-03 Thread Igor Vitorac
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

Re: [SOGo] object not found: SOGo = UID [revisited, SOLVED (at least for me)]

2013-09-12 Thread Igor Vitorac
Whenever you play with sogo (or its configuration), always restart memcached as well, i.e. every time you restart sogod restart also memcached. Marcel Waldvogel wrote, On 10/09/2013 16:51: Hello [This is in case anyone is running into the problem in the future. Maybe the friendly guys at

Re: [SOGo] How to share global calendars after deactivating/deleting an account

2013-11-29 Thread Igor Vitorac
We are creating functional user in the similar way of creating the resource user. So, create one functional (e.g. Department1) user and set email for that user (e.g. departme...@example.com). I am creating email for functional users or resources as alias to existing functional email boxes that

Re: [SOGo] Ldap vs Mysql

2013-12-06 Thread Igor Vitorac
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

Re: [SOGo] MailFieldNames - how to use it with SQL?

2014-01-08 Thread Igor Vitorac
For the SQL user source, you can use something like the following (see MailFieldNames): SOGo config: defaults write sogod SOGoUserSources '({canAuthenticate = YES; displayName = SOGo Users; id = users; isAddressBook = YES; type = sql; userPasswordAlgorithm = md5; viewURL

Re: [SOGo] Proxy Timeout on 127.0.0.1:20000 -solved

2014-01-16 Thread Igor Vitorac
Also you have the inconsistency in the first and third line. If you use http then change port to 80. Otherwise, your session might swap between https and http. Danté Bell wrote, On 15/01/2014 22:06: RequestHeader set x-webobjects-server-port 443 RequestHeader set

Re: [SOGo] sharing rigths on calendar

2014-01-23 Thread Igor Vitorac
To overcome this limitation you could do one or both of the following: - Set the following properties on your calendar: Receive a mail when someone else modifies my calendar, so in case of delete action, owner will be informed. - Assistant has access to create and edit. So, assistant can rename

Re: [SOGo] SOGo Update

2014-04-15 Thread Igor Vitorac
What about transferring ~/GNUstep/Defaults/.GNUstepDefaults to /etc/sogo/sogo.conf? Is the above procedure automated now or it still requires manual transfer with sogo-tool? Thanks, Igor Ludovic Marcotte wrote, On 15/04/2014 03:44: On 2014-04-14, 5:08 PM, Terry Welch wrote: Im currently

Re: [SOGo] Outlook FreeBusy lookups

2014-07-25 Thread Igor Vitorac
If you need to set the properties (e.g. View Date and Time) for each user, that could be done with sogo-tool (I hope so). I think it can be achived in this way: 1. First export all sogo user into one folder: sogo-tool backup my_backup_folder ALL In that way you will get one file per sogo user

Re: [SOGo] Best practice to force https in SOGo.conf

2014-08-06 Thread Igor Vitorac
I have tried to combine both (http and https), and it is not easy. You will need to do a lot of customization of your virtual host section in apache conf. Finally, I have configured only https in sogo virtual host section and additionally I have made permanent redirection from http to https,

Re: [SOGo] Best practice to force https in SOGo.conf

2014-08-07 Thread Igor Vitorac
Just make sure that you have adapted following lines in VirtualHost _default_:443 i.e. to refer only to https and 443 RequestHeader set x-webobjects-server-port *443* RequestHeader set x-webobjects-server-name sogo.example.com RequestHeader set x-webobjects-server-url *https*://sogo.example.com

Re: [SOGo] how to deal with has no matching SQL field errors?

2014-11-26 Thread Igor Vitorac
Maybe SOGo team has started working on this: http://www.sogo.nu/bugs/view.php?id=1997 :-) Regards, Igor Götz Reinicke - IT Koordinator wrote on 26/11/2014 10:53: Hi, we see a lot of has no matching SQL field errors. May be they are not yet used or implemented and I can't say if there is

Re: [SOGo] Moving a SOGo installation to another server?

2014-12-17 Thread Igor Vitorac
If you are using users from MySQL on the same server, then you need to handle that separately. Process explained by Christian Mack transfers only calendar and calendar entries! Following is assumed for the new server: - install clean SOGo and prepare same (or similar) sogo config. - prepare