AW: [SOGo] Database-error with Activesync

2022-01-13 Thread "Thomas Fuehrer"
Hi Hanns,
can you please set SOGoEASDebugEnabled=true, reproduce the error and provide 
sogo.log?
My understanding is that the column c_uid only exists in sogo_cache_folder 
(without username sugfix)  in a 9 table model database schema. 

Do you have any of these parameters set? OCSCacheFolderURL, OCSAclURL , 
OCSStoreURL

Regards
Thomas

-Ursprüngliche Nachricht-
Von: users-requ...@sogo.nu  Im Auftrag von Hanns Mattes
Gesendet: Montag, 10. Jänner 2022 17:56
An: users@sogo.nu
Betreff: Re: [SOGo] Database-error with Activesync

Hi,

Am 09.01.22 um 11:14 schrieb Hanns Mattes (hannsmat...@googlemail.com):
> Hello,
> 
> I've setup sogo 5.4.0 on a server running FreeBSD 13.0 und PSQL, web 
> access, caldav and carddav are working fine. But trying to access an 
> account via activesync is failing:
> [...]

(I forgot to mention, that I'm using LDAP-Authentication.)

similar results with mysql:

Jan 10 17:45:24 sogod [66817]:
<0x805167a88[SOGoCacheGCSObject]:4E696E65413341374535423136363832> an exception 
occurred when executing query 'SELECT * FROM 
sogo_cache_folder_hanns_A_hanauix_D_de WHERE c_path = 
'/4E696E65413341374535423136363832' AND c_uid = 'ha...@hanauix.de''
Jan 10 17:45:24 sogod [66817]:
<0x805167a88[SOGoCacheGCSObject]:4E696E65413341374535423136363832>
exception is ' NAME:ExecutionFailed 
REASON:Unknown column 'c_uid' in 'where clause''
Jan 10 17:45:24 sogod [66817]: [ERROR]
<0x805167a88[SOGoCacheGCSObject]:4E696E65413341374535423136363832> could not 
insert/update record for record '/4E696E65413341374535423136363832'
in sogo_cache_folder_hanns_A_hanauix_D_de:  NAME:ExecutionFailed REASON:Unknown column 'c_uid' in
'field list'

Any idea?

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

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

[SOGo] BTS activities for Thursday, January 13 2022

2022-01-13 Thread SOGo reporter
Title: BTS activities for Thursday, January 13 2022





  
BTS Activities

  Home page: https://sogo.nu/bugs
  Project: SOGo
  For the period covering: Thursday, January 13 2022

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
5420
	2022-01-13 11:02:46
	updated (open)
	Backend Address Book
	CardDAV sync failed - failed status for getetag
	
	  
	
5462
	2022-01-13 08:29:45
	updated (open)
	Backend Address Book
	Entity tag missing in CardDAV global address book REPORT
	
	  
	
5458
	2022-01-13 09:14:38
	updated (open)
	Web Calendar
	Change of event setting (private/confidential/public) will not save
	
	  
	
5460
	2022-01-13 07:12:18
	updated (open)
	Web Mail
	add receiver as sort option in sent mail list
	
	  
	
5461
	2022-01-13 07:16:23
	updated (open)
	Web Mail
	show unread count in mail account sidebar
	
	  
	
5456
	2022-01-13 08:47:01
	assigned (fixed)
	ActiveSync
	NSInvalidArgumentException when a user from an SQL source tries to FolderSync
	
	  
	
4896
	2022-01-13 10:51:46
	resolved (fixed)
	Web Address Book
	SOGoDomainsVisibility and GAL Address Book broken
	
	  
	
  
  


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

[SOGo] sogo url

2022-01-13 Thread raed abu
hello sogo
i am using sogo 5.4
how can i change url from https://ip/SOGo to only  http://ip
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Can't rid Thunderbird of sogo!

2022-01-13 Thread William Bowden
Have you looked in Accounts?

William Bowden | JMRIT Consultants
Consultant Engineer | m:07525 645105 | e:will...@jmrit.co.uk




> On 13 Jan 2022, at 20:55, Ian W. Bowden (i...@ianbowden.ca)  
> wrote:
> 
> I'm hoping that somebody out there can help me with this nagging problem:
> 
> Recently, I installed the sogo connector for Thunderbird in an effort to make 
> something happen that I eventually couldn't. I've disabled the Thunderbird 
> add-on and then completely deleted it, yet Thunderbird continues to throw up 
> this message:
> 
> 
> 
> Do you know of any way to get rid of it?
> 
> Thanks in advance for any help you can provide.
> 
> Ian Bowden
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists



smime.p7s
Description: S/MIME cryptographic signature


[SOGo] Can't rid Thunderbird of sogo!

2022-01-13 Thread "Ian W. Bowden"

I'm hoping that somebody out there can help me with this nagging problem:

Recently, I installed the sogo connector for Thunderbird in an effort to 
make something happen that I eventually couldn't. I've disabled the 
Thunderbird add-on and then completely deleted it, yet Thunderbird 
continues to throw up this message:


Do you know of any way to get rid of it?

Thanks in advance for any help you can provide.

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

Re: [SOGo] Email reminders

2022-01-13 Thread hyvernat philippe
Hello,
Yes postfix is couples with dovecot and an ldap server i put credentials and 
pas of my account 

The error doesn’t say bas credential but not configured…
Thanks for your answer

HYVERNAT Philippe

> Le 13 janv. 2022 à 13:31, Christian Mack  a écrit :
> 
> Hello
> 
> Are the crendials in /etc/sogo/mailAlarms.creds valid for sending via
> SMTP server?
> 
> 
> Kind regards,
> Christian Mack
> 
>> On 11.01.22 18:00, HYVERNAT Philippe (p.hyver...@outlook.fr) wrote:
>> lol
>> 
>> of course even the server
>> 
>> 
>> 
>>> Le 11/01/2022 à 17:11, Christian Mack (christian.m...@uni-konstanz.de) a
>>> écrit :
>>> Hello
>>> 
>>> Did you restart SOGo after changing sogo.conf?
>>> 
>>> 
>>> Kind regards,
>>> Christian Mack
>>> 
>>> Am 11.01.22 um 09:31 schrieb HYVERNAT Philippe (p.hyver...@outlook.fr):
 Hello,
 
 i setup the cronjob email reminders and i configure sogo.conf to
 enable it
 
 |
 |
 
 |
 |
 
 OCSEMailAlarmsFolderURL =
 "mysql://user:@172.30.20.151:3306/sogo/sogo_alarms_folder";
 
 
 *|SOGoEnableEMailAlarms = YES;|*
 
 |
 |
 
 |every minute, the log file (/var/log/sogo/cron-ealarms-notify.log)
 |
 
 |I have this error :
 |
 
 |
 |
 
 |2022-01-11 08:29:00.234 sogo-ealarms-notify[84802:100568] *EMail alarms
 are disabled in the SOGo configuration.*|
 
 |
 |
 
 |Do you have any hints ? i am really stuck on this.|
 
 |Thanks a lot|
 
 |HYVERNAT Philippe
 |
>>> 
> 
> 
> -- 
> Christian Mack
> Universität Konstanz
> Kommunikations-, Informations-, Medienzentrum (KIM)
> Abteilung IT-Dienste Forschung und Lehre
> 78457 Konstanz
> +49 7531 88-4416
> 
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Email reminders

2022-01-13 Thread Christian Mack
Hello

Are the crendials in /etc/sogo/mailAlarms.creds valid for sending via
SMTP server?


Kind regards,
Christian Mack

On 11.01.22 18:00, HYVERNAT Philippe (p.hyver...@outlook.fr) wrote:
> lol
> 
> of course even the server
> 
> 
> 
> Le 11/01/2022 à 17:11, Christian Mack (christian.m...@uni-konstanz.de) a
> écrit :
>> Hello
>>
>> Did you restart SOGo after changing sogo.conf?
>>
>>
>> Kind regards,
>> Christian Mack
>>
>> Am 11.01.22 um 09:31 schrieb HYVERNAT Philippe (p.hyver...@outlook.fr):
>>> Hello,
>>>
>>> i setup the cronjob email reminders and i configure sogo.conf to
>>> enable it
>>>
>>> |
>>> |
>>>
>>> |
>>> |
>>>
>>> OCSEMailAlarmsFolderURL =
>>> "mysql://user:@172.30.20.151:3306/sogo/sogo_alarms_folder";
>>> 
>>>
>>> *|SOGoEnableEMailAlarms = YES;|*
>>>
>>> |
>>> |
>>>
>>> |every minute, the log file (/var/log/sogo/cron-ealarms-notify.log)
>>> |
>>>
>>> |I have this error :
>>> |
>>>
>>> |
>>> |
>>>
>>> |2022-01-11 08:29:00.234 sogo-ealarms-notify[84802:100568] *EMail alarms
>>> are disabled in the SOGo configuration.*|
>>>
>>> |
>>> |
>>>
>>> |Do you have any hints ? i am really stuck on this.|
>>>
>>> |Thanks a lot|
>>>
>>> |HYVERNAT Philippe
>>> |
>>


-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature