[SOGo] BTS activities for Sunday, May 08 2016

2016-05-08 Thread SOGo reporter 
Title: BTS activities for Sunday, May 08 2016





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Sunday, May 08 2016

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
3662
	2016-05-08 09:25:16
	updated (open)
	Backend Address Book
	sogo-slapd-sockd
	
	  
	
  
  


-- users@sogo.nuhttps://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

2016-05-08 Thread Ludovic Marcotte 

Hi,

Show your full sogo.conf file and show us the list of your database tables.

Thanks,

On 2016-05-08 12:14, Adrian Figueroa (adr...@figueroa.cc) wrote:


Checking the SOGo log file with mysql logs enabled, it shows me this, 
when I try to add a contact:


May 08 18:10:45 sogod [4786]: <0x0x7fb6ec90e660[GCSFolderManager]> 
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location 
in record: {"c_acl_location" = ""; "c_folder_id" = 4; 
"c_folder_type" = Contact; "c_location" = ""; "c_path" = 
"/Users/adr...@figueroa.cc/Contacts/personal"; "c_quick_location" = 
""; }


I am running the latest nightly again.

Adrian

Am 08.05.2016 um 16:59 schrieb Adrian Figueroa (adr...@figueroa.cc):


Also, if I want to create a new contact in the SOGo web interface, it 
tells me


"Not Found"

up in the right corner and does not add the contact. Something is 
wrong in my configuration or the permissions.


Am 08.05.2016 um 15:07 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place 
if you don't know what it does, you MUST run the nightly build of 
SOGo v3.

--
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


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



--
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] Migration script problem

2016-05-08 Thread Adrian Figueroa 

I looked inside *GCSFolderManager.m*

It is obvious, that an error is thrown in line 444-448:
if (location == nil) ...


Now, the migration script fills in "NULL" values at certain spots, which 
cause the GCSFolderManager to fail. What can I do? Sadly, I can not 
revert to the old structure.


Kind regards,
Adrian

Am 08.05.2016 um 18:14 schrieb Adrian Figueroa (adr...@figueroa.cc):


Checking the SOGo log file with mysql logs enabled, it shows me this, 
when I try to add a contact:


May 08 18:10:45 sogod [4786]: <0x0x7fb6ec90e660[GCSFolderManager]> 
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location 
in record: {"c_acl_location" = ""; "c_folder_id" = 4; 
"c_folder_type" = Contact; "c_location" = ""; "c_path" = 
"/Users/adr...@figueroa.cc/Contacts/personal"; "c_quick_location" = 
""; }


I am running the latest nightly again.

Adrian

Am 08.05.2016 um 16:59 schrieb Adrian Figueroa (adr...@figueroa.cc):


Also, if I want to create a new contact in the SOGo web interface, it 
tells me


"Not Found"

up in the right corner and does not add the contact. Something is 
wrong in my configuration or the permissions.


Am 08.05.2016 um 15:07 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place 
if you don't know what it does, you MUST run the nightly build of 
SOGo v3.

--
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


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


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

Re[2]: [SOGo] Migration script problem

2016-05-08 Thread andre.pet...@debinux.de 
We tried it once on a cloned machine and run into the same problem. Also 
using the latest nightly then (~1 week ago). Lost contacts and 
calendars.


I should have saved the log, but I didn't... It said something like 
"bla-location-bla is not set/empty".


Just tried it "for fun", didn't expect it to work already. :-)


-- Originalnachricht --
Von: "Adrian Figueroa" 
An: users@sogo.nu
Gesendet: 08.05.2016 16:59:38
Betreff: Re: [SOGo] Migration script problem

Also, if I want to create a new contact in the SOGo web interface, it 
tells me


"Not Found"

up in the right corner and does not add the contact. Something is wrong 
in my configuration or the permissions.


Am 08.05.2016 um 15:07 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place if 
you don't know what it does, you MUST run the nightly build of SOGo 
v3.
-- 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

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

Re: [SOGo] Migration script problem

2016-05-08 Thread Adrian Figueroa 
Checking the SOGo log file with mysql logs enabled, it shows me this, 
when I try to add a contact:


May 08 18:10:45 sogod [4786]: <0x0x7fb6ec90e660[GCSFolderManager]> 
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location in 
record: {"c_acl_location" = ""; "c_folder_id" = 4; "c_folder_type" 
= Contact; "c_location" = ""; "c_path" = 
"/Users/adr...@figueroa.cc/Contacts/personal"; "c_quick_location" = 
""; }


I am running the latest nightly again.

Adrian

Am 08.05.2016 um 16:59 schrieb Adrian Figueroa (adr...@figueroa.cc):


Also, if I want to create a new contact in the SOGo web interface, it 
tells me


"Not Found"

up in the right corner and does not add the contact. Something is 
wrong in my configuration or the permissions.


Am 08.05.2016 um 15:07 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place 
if you don't know what it does, you MUST run the nightly build of 
SOGo v3.

--
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


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

Re: [SOGo] Migration script problem

2016-05-08 Thread Adrian Figueroa 
Yes, you are right about the nightly version. I agree that I should not 
have used the script.


I upgraded back to the nightly version but I have no contacts/calendar 
entries yet. Is there something else that I could be missing?


This is the mysql table structure inside "sogo":

+-+
| Tables_in_sogo  |
+-+
| sogo_acl|
| sogo_alarms_folder  |
| sogo_cache_folder   |
| sogo_cache_folder_XX

.

| sogo_folder_info|
| sogo_quick_appointment  |
| sogo_quick_contact  |
| sogo_sessions_folder|
| sogo_store  |
| sogo_user_profile   |
+-+
20 rows in set (0.00 sec)

I can also look let mysql display all the data in sogo_store as user 
sogo (which is a lot).


My sogo.conf now contains:

OCSCacheFolderURL   = 
"mysql://sogo:x@127.0.0.1:3306/sogo/sogo_cache_folder";
OCSStoreURL = 
"mysql://sogo:x@127.0.0.1:3306/sogo/sogo_store";
OCSAclURL   = 
"mysql://sogo:x@127.0.0.1:3306/sogo/sogo_acl";
SOGoProfileURL  = 
"mysql://sogo:x@127.0.0.1:3306/sogo/sogo_user_profile";
OCSFolderInfoURL= 
"mysql://sogo:x@127.0.0.1:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL= 
"mysql://sogo:x@127.0.0.1:3306/sogo/sogo_sessions_folder";


Thank you for your help so far!

Am 08.05.2016 um 15:07 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place if 
you don't know what it does, you MUST run the nightly build of SOGo v3.

--
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] Migration script problem

2016-05-08 Thread Adrian Figueroa 
Also, if I want to create a new contact in the SOGo web interface, it 
tells me


"Not Found"

up in the right corner and does not add the contact. Something is wrong 
in my configuration or the permissions.


Am 08.05.2016 um 15:07 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place if 
you don't know what it does, you MUST run the nightly build of SOGo v3.

--
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

[SOGo] Starting SOGo

2016-05-08 Thread Odhiambo Washington 
I just can't manage to start the server, plus it doesn't write to the
logfile any debug info.
I am pretty much using the sogo.conf from 2.0.7 which seems not to have any
differences from the sample one for 3.0.2

root@gw:/usr/local/etc/sogo # /usr/local/etc/rc.d/sogod start
Starting sogod.
Loading two versions of Object.  The class that will be used is undefined
Loading two versions of Protocol.  The class that will be used is undefined

I cannot make heads or tails of the message, even by googling...

-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft."
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo sending invitation ... (update)

2016-05-08 Thread Tamer Higazi 
I'll create an repository on Github, and see to understand the CalDAV
problem.

Can't be such a big issue
I'll keep you informed when it's done and production ready.




best, Tamer

Am 08.05.2016 um 14:49 schrieb Ludovic Marcotte (lmarco...@inverse.ca):
> On 2016-05-08 08:39, Tamer Higazi (th9...@googlemail.com) wrote:
>> Are there any API's to SoGO for REST, SOAP, XML-RPC I can read ?
>>
>> I'll write in Python a MILTER application for Postfix that would
>> analyize the header of all incoming mails, authenticate to sogo and set
>> the invitation status.
> Use the CalDAV interface for this.
> 
> -- 
> 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] Migration script problem

2016-05-08 Thread Ludovic Marcotte 

On 2016-05-08 08:56, Adrian Figueroa (adr...@figueroa.cc) wrote:
Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.

Did you try the nightly builds and then reverted to 3.0.2?

If you ran that script, which you shouldn't have in the first place if 
you don't know what it does, you MUST run the nightly build of SOGo v3.


--
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] Migration script problem

2016-05-08 Thread Adrian Figueroa 
The upgrade told me to check the mysql migration script folder, so I 
thought that I had to run the latest one.


Those entries were defined already, except for the cachefolderurl. 
Adding that to sogo.conf did not help, unfortunately.


Am 08.05.2016 um 14:34 schrieb Ludovic Marcotte (lmarco...@inverse.ca):

On 2016-05-08 08:26, Adrian Figueroa (adr...@figueroa.cc) wrote:
I ran the migration script "sql-update-3.0.0-to-combined-mysql.sh" on 
SOGo 3.0.2 and now all contact and calendar data is gone. I am 
afraid, I forgot to do a backup before. The script ran without issues 
and told me, it merged tables. 

Why running this script in the first place?

Define:

  OCSCacheFolderURL = 
"mysql://sogo:YOURPASSWORD@127.0.0.1:3306/sogo/sogo_cache_folder";
  OCSStoreURL = 
"mysql://sogo:YOURPASSWORD@127.0.0.1:3306/sogo/sogo_store";

  OOCSAclURL = "mysql://sogo:YOURPASSWORD@127.0.0.1:3306/sogo/sogo_acl";

and restart sogod.

--
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 sending invitation ... (update)

2016-05-08 Thread Ludovic Marcotte 

On 2016-05-08 08:39, Tamer Higazi (th9...@googlemail.com) wrote:

Are there any API's to SoGO for REST, SOAP, XML-RPC I can read ?

I'll write in Python a MILTER application for Postfix that would
analyize the header of all incoming mails, authenticate to sogo and set
the invitation status.

Use the CalDAV interface for this.

--
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] sogo sending invitation ... (update)

2016-05-08 Thread Tamer Higazi 
Are there any API's to SoGO for REST, SOAP, XML-RPC I can read ?

I'll write in Python a MILTER application for Postfix that would
analyize the header of all incoming mails, authenticate to sogo and set
the invitation status.


best, Tamer

Am 08.05.2016 um 14:36 schrieb Ludovic Marcotte (lmarco...@inverse.ca):
> On 2016-05-08 08:33, Tamer Higazi (th9...@googlemail.com) wrote:
>> But how will sogo be capable to set the desired appointment to
>> "ACCEPT/DECLINED" by automaticly incoming mail ?
> By either knowing all your user's passwords or having an IMAP trust for
> your SMTP server.
> 
> That feature is NOT supported by SOGo.
> 
> -- 
> 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 sending invitation ... (update)

2016-05-08 Thread Ludovic Marcotte 

On 2016-05-08 08:33, Tamer Higazi (th9...@googlemail.com) wrote:

But how will sogo be capable to set the desired appointment to
"ACCEPT/DECLINED" by automaticly incoming mail ?
By either knowing all your user's passwords or having an IMAP trust for 
your SMTP server.


That feature is NOT supported by SOGo.

--
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] sogo sending invitation ... (update)

2016-05-08 Thread Tamer Higazi 
Well, I have to update my request.
Sogo IS CAPABLE to send invitation requests, that do work fine.

But how will sogo be capable to set the desired appointment to
"ACCEPT/DECLINED" by automaticly incoming mail ?


best, Tamer

Am 08.05.2016 um 14:00 schrieb Tamer Higazi:
> Hi people,
> 
> I am anxious to know how it works with the invitation mails.
> 
> I got the calendar, set the apointment, add participants and no mail is
> being sent out.
> 
> Have I missed anything, or have I forgotten to read any manual setting
> up sogo that "sogo" would send out the invitation, and would find a way
> to read incoming mails and to set the check (accepted, decline) ?!
> 
> Such organisations as Google (with GMail) have it implemented, and it
> all works if I do it from thunderbird mail (where thunderbird sends out
> the mail).
> 
> Has it got something todo with Sieve ?
> Is it a feature that is missing or are there further configurations from
> my side necessary to accomplish this task.
> 
> if that's the case, I would be happy to write a Postfix MILTER
> Application, that would communicate directly with Sogo.
> 
> Let me hear from you.
> 
> 
> best, Tamer
> 
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Migration script problem

2016-05-08 Thread Ludovic Marcotte 

On 2016-05-08 08:26, Adrian Figueroa (adr...@figueroa.cc) wrote:
I ran the migration script "sql-update-3.0.0-to-combined-mysql.sh" on 
SOGo 3.0.2 and now all contact and calendar data is gone. I am afraid, 
I forgot to do a backup before. The script ran without issues and told 
me, it merged tables. 

Why running this script in the first place?

Define:

  OCSCacheFolderURL = 
"mysql://sogo:YOURPASSWORD@127.0.0.1:3306/sogo/sogo_cache_folder";

  OCSStoreURL = "mysql://sogo:YOURPASSWORD@127.0.0.1:3306/sogo/sogo_store";
  OOCSAclURL = "mysql://sogo:YOURPASSWORD@127.0.0.1:3306/sogo/sogo_acl";

and restart sogod.

--
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

[SOGo] sogo sending invitation ...

2016-05-08 Thread Tamer Higazi 
Hi people,

I am anxious to know how it works with the invitation mails.

I got the calendar, set the apointment, add participants and no mail is
being sent out.

Have I missed anything, or have I forgotten to read any manual setting
up sogo that "sogo" would send out the invitation, and would find a way
to read incoming mails and to set the check (accepted, decline) ?!

Such organisations as Google (with GMail) have it implemented, and it
all works if I do it from thunderbird mail (where thunderbird sends out
the mail).

Has it got something todo with Sieve ?
Is it a feature that is missing or are there further configurations from
my side necessary to accomplish this task.

if that's the case, I would be happy to write a Postfix MILTER
Application, that would communicate directly with Sogo.

Let me hear from you.


best, Tamer

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

[SOGo] Migration script problem

2016-05-08 Thread Adrian Figueroa 

Hello,

I ran the migration script "sql-update-3.0.0-to-combined-mysql.sh" on 
SOGo 3.0.2 and now all contact and calendar data is gone. I am afraid, I 
forgot to do a backup before. The script ran without issues and told me, 
it merged tables.


A table "sogo_store" was created in the process.

When I dump the sogo database, I can still see the data in the raw text. 
Can I repair/revert it somehow?


Help is much apprechiated.


Kind regards,

Adrian


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