Re: [SOGo] Error when marking tasks as done

2011-12-08 Thread Pascal Bourdais

Le 08/12/2011 17:05, Julian Robbins a écrit :

On 08/12/11 15:29, Pascal Bourdais wrote:


Hi,

When I wan't to mark a task as done, those errors are logged :

Dec 08 16:23:59 sogod [27637]: <0x0x39c0110[GCSFolder]> 
ERROR(-[GCSFolder writeContent:toName:baseVersion:]): cannot update 
content :  NAME:ExecutionFailed 
REASON:Unknown column 'NO' in 'field list'
Dec 08 16:23:59 sogod [27637]: [ERROR] 
<0x0240D710[SOGoTaskObject]:3AD4-4B7C1380-317-944590> write failed: 
 NAME:ExecutionFailed REASON:Unknown 
column 'NO' in 'field list'


What did I missed ?


There was a bug in 1.3.9 when using Mysql as the field name expects a 
0 instead of a Null, or similar. It was fixed in 1.3.10, but that has 
some additional issues to content with. Best wait for 1.3.11 coming 
very soon




OK, thank you for the reply.


Julian


Sogo 1.3.9 / ubuntu 10.04

Pascal.





--
users@sogo.nu
https://inverse.ca/sogo/lists


[SOGo] Error when marking tasks as done

2011-12-08 Thread Pascal Bourdais


Hi,

When I wan't to mark a task as done, those errors are logged :

Dec 08 16:23:59 sogod [27637]: <0x0x39c0110[GCSFolder]> 
ERROR(-[GCSFolder writeContent:toName:baseVersion:]): cannot update 
content :  NAME:ExecutionFailed 
REASON:Unknown column 'NO' in 'field list'
Dec 08 16:23:59 sogod [27637]: [ERROR] 
<0x0240D710[SOGoTaskObject]:3AD4-4B7C1380-317-944590> write failed: 
 NAME:ExecutionFailed REASON:Unknown column 
'NO' in 'field list'


What did I missed ?

Sogo 1.3.9 / ubuntu 10.04

Pascal.
--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Sogo-tool - standard in must be tty

2011-07-06 Thread Pascal Bourdais
Le Wed, 06 Jul 2011 09:29:05 +0200,
Philipp Strobl  a écrit :

Hi,

> 
> i have a script that execute the sogo-backup tool. For some reason it 
> exits with an error: "standard in must be a tty" ?
> 
> What does this mean ?
> The backup seems to be OK.
> 
> It is not possible to run the sogo-tool from script ?

I run it in a script with
  sudo -u sogo /usr/sbin/sogo-tool  backup /home/sauve ALL
and it works like a charm with the good config of sudo.

I think su -u ... redirects tty and that's why you have this error.

An other way is to run the script as user sogo, but you have to change
the rights of /home/sogo/Backup.

<...>

Regards,

Pascal
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] script to remove double (or more)

2011-06-27 Thread Pascal Bourdais
Le Sun, 26 Jun 2011 21:22:39 +0200,
Dominique  a écrit :

> Hi,
> 
> Great script idea, but I have a few questions:
> 1. what module to install in ubuntu 10.04 server to get the 
> data::ical::datetime module installed correctly ? No luck so far.

I'am on slackware for the scripts, so i use cpan.
I have been asked to install this on ubuntu, and i used cpan again.

> 2. does the url needs to be https? In my case it is a simple http, and 
> the script 'dies' at line 52 with an 'unauthorized' error. Since I am 
> using a working account, is there something else to look for ? Can the 
> https be change in the script for http only ?

No need to be https, and no reference to it in the script (except
comments).
Check user and password, I test with http and it's ok for me.
The module Net::SSLeay is needed for https to work.

> 3. what does the <# of days> refer to for the --doit variable?

Thank copy/paste :(
doit doesn't need anything else.

HTH

Pascal

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] script to remove double (or more)

2011-06-24 Thread Pascal Bourdais
Le Fri, 24 Jun 2011 13:30:12 +0200,
Christian Mack  a écrit :

> Hi Pascal Bourdais
> 
<...>
> 
> I've just an enhancement request for it :-)
> 
> At the moment you only check the default / personal calendar.
> It would be nice if you could also specify the calendar to check at the
> command line.

Easy to do and useful.

Done.

Pascal
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

sup-double.pl
Description: Perl program


[SOGo] script to remove double (or more)

2011-06-24 Thread Pascal Bourdais

Bonjour,

Because of some problems with funambol/android, i need a script to
remove events that where synchronized more than one time on sogo.

As I didn't found it, I wrote a perl script to fit my needs.

I join it, if someone think it can help, please use and modify.

I consider a double to have same start date/end date and summary, but
may be i missed something, please feedback.

Pascal

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

sup-double.pl
Description: Perl program


Re: [SOGo] Mass events modify

2011-06-21 Thread Pascal Bourdais
Le Tue, 21 Jun 2011 10:35:54 +0200,
Alessio Fattorini  a écrit :

Hi,

> How can i modify more events at the same times
> Specifically i should make private some events (50/60)
> adding this field on vcalendar:
> CLASS=PRIVATE
> Can anyone suggest a way to do it?
> 

I'm working on something like this. It's just a try for now, but if it
can help, modify and use 

-+-+-+-+ CUT +-+-+-+-
#!  /usr/bin/perl

#use strict;
use warnings;

use Data::ICal;
use Data::ICal::DateTime;
use DateTime;
use HTTP::DAV

my ($url, $d, $cal, $calcontent);

$url = "http://xx/SOGo/dav";;

$d = new HTTP::DAV();

# log with admin user.
$d->credentials( -user=>'admin', -pass =>'xxx', -url => $url);
$d->open( -url=> $url ) or die("Couldn't open $url: " .$d->message . "\n");

$d->get(-url => "/Calendar/personal.ics", -to => \$calcontent);

$cal = Data::ICal->new(data => $calcontent);

my @events = $cal->events();

foreach my $event (@events) {

   if ($event->property('uid') eq "1845-4DF78B00-62E1-31B97100") {
   #if ($event->start > $event->end) {
  #print "uid:", $event->property('uid')->[0]->value, "\n";
  #print "summary:", $event->property('summary')->[0]->value, "\n";
  #print "dtstart:", $event->start, "\n";
  #print "dtend:", $event->end, "\n";
  #print "correction : ";
  $o = $event->end;
  $o->add(days=>1);
  $event->end($o);
  #print "dtend:", $event->end, "\n";
  #print "\n";
  print $event->as_string;
  print "\n";

  #$d->delete($event->property('uid')->[0]->value);
  #$d->put(-local => \$event->as_string, -url => $event->property('uid'));
   }

   #exit;
}

-+-+-+-+ CUT +-+-+-+-

-- 
P.Bourdais
Infagri
Rue Albert Einstein
Parc Technopole de changé
Bp 26116
53061 Laval Cedex 9
Tél: 02.43.49.84.40
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] EMail reminders

2011-06-10 Thread Pascal Bourdais
Le Fri, 10 Jun 2011 06:38:53 -0400 (EDT),
 a écrit :

Bonjour,

> 
> We have set-up Sogo on a server, everything is working fine.
> 
> Some users asked me if it was possible to received events reminders via mail,
> instead of a pop-up via web sogo interface (in case they are connected through
> thunderbird).
> 
> I saw on the installation guide the "EMail reminders" section and I had apply
> the following option on the configuration file:
> SOGoEnableEMailAlarms = YES;
> OCSEMailAlarmsFolderURL =
> "mysql://user:password@host:port/sogo/sogo_alarms_folder";
> I add "* * * * * /usr/sbin/sogo-ealarms-notify"  to the sogo's user crontab.
> and restarted sogo daemon.
> 
> The problem is that nothing has changed, reminders still appears as pop-ups 
> and
> not as email alerts.
> 
> What could be wrong with my setup ?

This config allow the use of mail as reminder.
The users have to configure the event :

rappel -> personnalisé -> choisir une action pour le rappel


-- 
P.Bourdais
Infagri
Rue Albert Einstein
Parc Technopole de changé
Bp 26116
53061 Laval Cedex 9
Tél: 02.43.49.84.40
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] ModulesConstraints in xml GNUstepDefaults

2011-06-09 Thread Pascal Bourdais
Le Thu,  9 Jun 2011 09:55:37 -0400 (EDT),
 a écrit :

Hi,

By using defaults -u sogo write ..., it gives 


  SOGoUserSources


<...>
ModulesConstraints

Mail

objectclass
nonExistingClass


SearchFieldNames
<...>


> 
> how could I insert
>  " ModulesConstraints = {
>   Mail = {
>objectClass = nonExistingClass;
>};
>};"
> in a new xml style .GNUstepDefaults with defaults write sogod
> 
> or is there any other way to disable   mail in Sogo?
> 
> Kind regards,


-- 
P.Bourdais
Infagri
Rue Albert Einstein
Parc Technopole de changé
Bp 26116
53061 Laval Cedex 9
Tél: 02.43.49.84.40
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Android sync with CLASS:CONFIDENTIAL

2011-05-12 Thread Pascal Bourdais

Hi,

We are using SOGo (1.3.7) with funambol (DS Server v.9.0.0), Funambol
Android Sync Client 9.0.3 and the calendar application calendrier 1.1
shipped with the Galaxy S smartphone.

When syncing the data, the CLASS info is always public. I tried to
trace the dialog (wireshark on the server, log level to trace on the
smartphone) and i never see the CLASS:CONFIDENTIAL set while we set it
on the smartphone (it doesn't work on the other way either).

I think the problem is on the calendar app, but i'm not sure.

If the app is the problem, which calendar app are you using ?

Thank you for your advises,

Pascal
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Calendar events disappearing

2010-09-14 Thread Pascal Bourdais
Le Tue, 14 Sep 2010 14:38:15 +0900,
Jeremy Kiffiak  a écrit :

Hi,

I experienced this problem with one of my users and found the reason
why :

The username is lowercase and the user log in with uppercase.

The authentification was correct, but the function is "curious" and
leads to lose of event.

I have to open a bug for this.

Pascal

> Hello everyone,
> 
> Currently I have SOGo installed and running in a testing environment  
> for a client.  The main tester has been experiencing a troubling  
> situation where anI have some users who are complaining about  
> disappearing events in the SOGo calendars.  I have just finished  
> watching one of the users demo this problem for me and am at a  
> complete loss as to why this would be happening. I hope someone can  
> help me to solve this troubling issue.
> 
> We are using SOGo 1.3.1 on a Ubuntu 10.04 virtual machine (using  
> KVM).  Additionally the SOGo VM is running Postgres 8.4 and Apache  
> 2.2.14.  OpenLDAP is running on a separate eBox VM.
> 
> The clients are Firefox 3.6.8 (running on both Mac OS X and Windows)  
> and Safari 5.0.1 on OS X.
> 
> Everything appears to function correctly until an event is modified.   
> Typically the first edit (changing the name of the event, adding to  
> the description, etc) will have no adverse affect.  However,  
> subsequent modifications will often cause the event to disappear  
> completely from the calendar.  Logging out of the account and logging  
> back in does not fix the problem.
> 
> I have created additional LDAP accounts to test this problem in SOGo  
> with mixed "success".  Some accounts have no problem at all with the  
> disappearing calendar events and others also have experienced this  
> issue.
> 
> I would like to figure out what is causing this problem though my next  
> idea is to simply drop the current Postres DB and start fresh.
> 
> HELP!
> 
> Please let me know what additional information would be useful.
> 
> Thanks in advance,
> 
> Jeremy


-- 
P.Bourdais
Infagri
Rue Albert Einstein
Parc Technopole de changé
Bp 26116
53061 Laval Cedex 9
Tél: 02.43.49.84.40
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Re: ANN: SOGo v1.2.2

2010-05-10 Thread Pascal Bourdais
Le Fri, 07 May 2010 14:44:57 -0400,
Wolfgang Sourdeau  a écrit :

Hi Wolfgang,

> 
> 
> This is definitely a cache problem on your side because the yum metadata 
> is fine on our servers... I don't know enough of yum to tell you which 
> command yuou should execute.

It was a problem in the yum's config.

The proxy was not used even if declared in http_proxy and ftp_proxy
environment vars.

> It seems your computer does not even 
> connect to our machine...

This give me the way.

Thanks a lot,

-- 
P.Bourdais
Gie Infagri
Rue Albert Einstein
Parc Technopole de changé
53061 Laval Cedex 9
Tél: 02.43.49.84.40
« Celui qui est prêt à sacrifier un peu de liberté pour obtenir un peu
de sécurité ne mérite vraiment ni l'une, ni l'autre. » ( Benjamin
Franklin )
-- 
users@sogo.nu
https://inverse.ca/sogo/lists