Re: [SOGo] unix socket

[mar...@waschbuesch.de]

Hi Christian,

Am 23.08.23 um 14:07 schrieb "ChristianTruee" (ch.tr...@trueeonline.de):

Hi all,
how can I use unix socket in the sogo.conf to connect to the mysql server?

At the moment I can use localhost:port.

Thanks
Christian


if your mysql socket is e.g. /var/run/mysql/mysql.sock, then this should 
work:


SOGoProfileURL = 
"mysql://sogouser:sogopass@%2Fvar%2Frun%2Fmysql%2Fmysql.sock/sogodbname/sogo_user_profile";


The trick is to escape the forward slashes '/'.

That being said, a lot of applications end up using mysql's unix socket 
instead of a TCP connection automatically, if you just specify localhost 
(without a port). I have not tested that, though.

Re: [SOGo] Apple addressbook not working after upgrade.

[mar...@waschbuesch.de]

Am 14.08.23 um 09:38 schrieb smizr...@alinto.eu (smizr...@alinto.eu):

You need to open a bug report and provide logs

Sebastien


Gladly. What logs (just sogo or is there a way to get macOS addressbook 
to log stuff?) and which (if any) debugging options should I enable?

Re: [SOGo] Apple addressbook not working after upgrade.

[mar...@waschbuesch.de]

Hi Sebastien,

Am 13.08.23 um 20:50 schrieb smizr...@alinto.eu (smizr...@alinto.eu):
Hi Martin, did you follow the upgrade procedure 
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_upgrading 
 ?


Sadly, yes. Even removing and re-adding the account does not help.

[SOGo] Apple addressbook not working after upgrade.

[mar...@waschbuesch.de]

Hi all,

Using macOS 13 builtin apps as CalDAV/CardDAV client, I can no longer 
access contacts in my address book after upgrading SOGo to >= 5.8.3.


There are no errors in the logs, however, Apple's addressbook app will 
show 0 contacts. They are still present via SOGo webmail and also using 
Thunderbird (native, no connector) and K9 on my Android phone.


Downgrading SOGo to 5.8.0 resolves the issue.

I saw some issues around newer macOS and calendars - maybe this is 
related? At any rate, I wanted to ask if anyone else has seen this 
behavior before opening a bug report.


Thanks!

Martin

[SOGo] DAV for notes

[mar...@waschbuesch.de]

Hi,

It seems that IceWarp has implemented a way to use dav for notes.
emClient seems to support this in its current beta. They explain (by 
short example) how this is done here:

https://forum.emclient.com/emclient/topics/em-client-8-caldav-note-synchronization

I find this approach very intruiging. Could that be something for SOGo 
to implement as well?


Martin

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

Re: [SOGo] Upcoming SOGo v4 release

[mar...@waschbuesch.de]

Hi Ludovic,

> Am 01.03.2018 um 14:52 schrieb Ludovic Marcotte (lmarco...@inverse.ca) 
> :
> 
> Hello,
> 
> Early next week, we'll release SOGo v4. We've been working hard on this 
> release for many months. Among some of important features of SOGo v4, there 
> are:
> 
> full S/MIME support for signing and encryption
> complete rework of the handling of recurrence exceptions
> performance optimizations of the Web GUI by creating AngularJS components
> many Enterprise ActiveSync improvements
> We also made a gazillion of bug fixes and improvements.
> 
> Nightly builds of the upcoming v4 have been available since the beginning of 
> the week - just replace /3/ by /4/ in the URL for the repositories while we 
> update the website for the release
> 

That is awesome!

Are there instructions for the upgrade procedure yet? Any major things to look 
out for? e.g. required changes in SQL backend, etc.

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

Re: [SOGo] Unknown column 'c_hascertificate' in 'field list'

[mar...@waschbuesch.de]

> Am 18.01.2018 um 21:03 schrieb Bruce Stephenson (br...@nottheshark.com) 
> :
> 
> 
> My users have been asking me about this issue for weeks. Was finally able to 
> solve by following reading this thread. I couldn't find any documentation on 
> this either...

Am I missing something here?

Nightly builds are beta at best and come with no guarantees. Why would anyone 
expect them to be anything else?

IMHO, complaints about the lack of documentation with regards to nightly builds 
are at least somewhat out of place.

Just my two cents.

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

Re: [SOGo] Sieve filters deleted after enabling/disabling auto-vacation

[mar...@waschbuesch.de]

Hi there,
> Am 29.08.2017 um 12:13 schrieb dan le bray (d...@univ-lehavre.fr) 
> :
> 
> Hello,
> using SOGo 3.2.10 and dovecot, I made sieve filters some time ago which
> do worked well right until this morning: in order to test the
> auto-vacation, I enabled it and all my filters disappeared :/
> 
> I check on the dovecot server and my sieve/sogo.dieve file was indeed
> reseted with only the vacation part (no filter left in the file). When I
> disabled the vacation, the file sieve/sogo.sieve was removed.
> 
> Is it something you already heard about? Why and how was the file
> removed/reseted and lost all the filters?

what version of dovecot-pigeonhole are you using?

I don't know if this is related to your problem, but it might be worth 
investigating:

There is a bug in 0.4.19 that meant sogo could not properly log in to 
manage-sieve.
https://github.com/dovecot/pigeonhole/commit/c80aa7c25b0b4e61bb8e3a91864a355f7f2fa89f
Version 0.4.20 fixed that.


signature.asc
Description: Message signed with OpenPGP

[SOGo] libwbxml

[mar...@waschbuesch.de]

Hi all,

I just noticed that the inverse builds seem to still use an older version of 
libwbxml (0.11.2)
The latest stable release is 0.11.4 and can be found here:
https://sourceforge.net/projects/libwbxml/files/libwbxml/0.11.4/
or here:
https://github.com/libwbxml/libwbxml/tree/libwbxml-0.11.4

While 0.11.4 did not bring any major updates, 0.11.3 did and, among others, 
fixed a memory leak!

I have been using this version with SOGo and ActiveSync for some time now 
without any trouble.

Anyway, just thought I'd mention it.

Martin

smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] SIGHUP handling & logfile rotation

[mar...@waschbuesch.de]

> Am 11.09.2016 um 21:30 schrieb Martin Waschbüsch (mar...@waschbuesch.de) 
> <users@sogo.nu>:
> 
> Hi all,
> 
> From what I could find out, SOGo does not do anything about its log file when 
> reacting to SIGHUP.
> When logrotate moves the current logfile /var/log/sogo/sogo.log to 
> /var/log/sogo/sogo.log.1, the file handle is kept open which makes SOGo 
> continue to log messages to /var/log/sogo/sogo.log.1.
> I guess this is the reason for the logrotate script to contain the 
> 'copytruncate' directive.
> 
> Anyway, Would it be possible to override the function
> handle_SIGHUP(int signum)
> (in sope/sope-appserver/NGObjWeb/WOWatchDogApplicationMain.m)
> to take care of this?
> 
> Alternatively, is it possible to configure SOGo to log to syslog? I could not 
> find an option in the current documentation.

Anyone? Or should I open a bug report with this?

Thanks,

Martin


signature.asc
Description: Message signed with OpenPGP using GPGMail

[SOGo] SIGHUP handling & logfile rotation

[mar...@waschbuesch.de]

Hi all,

>From what I could find out, SOGo does not do anything about its log file when 
>reacting to SIGHUP.
When logrotate moves the current logfile /var/log/sogo/sogo.log to 
/var/log/sogo/sogo.log.1, the file handle is kept open which makes SOGo 
continue to log messages to /var/log/sogo/sogo.log.1.
I guess this is the reason for the logrotate script to contain the 
'copytruncate' directive.

Anyway, Would it be possible to override the function
handle_SIGHUP(int signum)
(in sope/sope-appserver/NGObjWeb/WOWatchDogApplicationMain.m)
to take care of this?

Alternatively, is it possible to configure SOGo to log to syslog? I could not 
find an option in the current documentation.

Thanks,

Martin


signature.asc
Description: Message signed with OpenPGP using GPGMail

Re: [SOGo] sql user sources configuration question

[mar...@waschbuesch.de]

> Am 08.09.2016 um 21:22 schrieb Martin Waschbüsch (mar...@waschbuesch.de) 
> <users@sogo.nu>:
> 
> 
>> Am 08.09.2016 um 17:33 schrieb Ludovic Marcotte (lmarco...@inverse.ca) 
>> <users@sogo.nu>:
>> 
>> On 2016-09-08 9:37 AM, Martin Waschbüsch (mar...@waschbuesch.de) wrote:
>> 
>>> I don't see how this could work since the number of addresses that can be 
>>> associated with a mailbox is neither fixed nor limited. So, I cannot force 
>>> that into a view layout like:
>>> 
>>> c_uid | c_name | c_password | c_cn | mail | mail_2 | mail_3 | ... | mail_n
>>> 
>>> Or am I missing something?
>> You could set MailFieldNames = (mail_aliases);  in your configuration and in 
>> that column, space-delimit addresses. SOGo will automatically split them 
>> (https://github.com/inverse-inc/sogo/commit/8b9ceb327335a7995374472939c78665d035b148).
> 
> I'm afraid, both, MailFieldNames and LoginFieldNames would have to point to 
> the same field containing space-delimit addresses for this to work on my 
> setup.
> The associated email addresses also serve as usernames for a mailbox.

PS: I'd be willing to sponsor this.

Martin


signature.asc
Description: Message signed with OpenPGP using GPGMail

Re: [SOGo] sql user sources configuration question

[mar...@waschbuesch.de]

> Am 08.09.2016 um 10:28 schrieb Christian Mack 
> (christian.m...@uni-konstanz.de) <users@sogo.nu>:
> 
> Am 06.09.2016 um 18:16 schrieb Martin Waschbüsch (mar...@waschbuesch.de):
>> Hi there,
>> 
>> I use SOGo as a web frontend to a (home-grown) mailserver setup
>> (based on PostgreSQL & Exim). Everything works really well (SOGo is a
>> really cool piece of software!) except for two things:
>> 
>> - When using anything but a plain table or very straightforward view
>> to a table, it seems impossible to let users change their passwords
>> via SOGo (complex views are not writeable). It would be really cool
>> if it were possible to be able to configure a custom query for
>> password changes within sogo.conf? Or is there an alternative
>> approach I could use?
>> 
> 
> No, there is no such thing.
> But you could open a feature request for that at http://www.sogo.nu/bugs

Just did:
https://sogo.nu/bugs/view.php?id=3810

Thanks, Christian!

Martin


signature.asc
Description: Message signed with OpenPGP using GPGMail

Re: [SOGo] sql user sources configuration question

[mar...@waschbuesch.de]

> Am 08.09.2016 um 17:33 schrieb Ludovic Marcotte (lmarco...@inverse.ca) 
> <users@sogo.nu>:
> 
> On 2016-09-08 9:37 AM, Martin Waschbüsch (mar...@waschbuesch.de) wrote:
> 
>> I don't see how this could work since the number of addresses that can be 
>> associated with a mailbox is neither fixed nor limited. So, I cannot force 
>> that into a view layout like:
>> 
>> c_uid | c_name | c_password | c_cn | mail | mail_2 | mail_3 | ... | mail_n
>> 
>> Or am I missing something?
> You could set MailFieldNames = (mail_aliases);  in your configuration and in 
> that column, space-delimit addresses. SOGo will automatically split them 
> (https://github.com/inverse-inc/sogo/commit/8b9ceb327335a7995374472939c78665d035b148).

Thanks, Ludovic! I will give that one a try!

Martin


signature.asc
Description: Message signed with OpenPGP using GPGMail

Re: [SOGo] sql user sources configuration question

[mar...@waschbuesch.de]

> Am 08.09.2016 um 10:28 schrieb Christian Mack 
> (christian.m...@uni-konstanz.de) :
> 
>> treating them as individual users. Is there a way to configure SOGo
>> to recognize that different email addresses belong to the same
>> mailbox?
>> 
>> Maybe people on the list have ideas how these issues could be
>> addressed?
>> 
> 
> Sure, just specify those additional email addresses in your view with
> seperate columns.
> Then in your SOGoUserSources tell those to SOGo with option MailFieldNames

Hi Christian,

Thanks for your suggestion!

I don't see how this could work since the number of addresses that can be 
associated with a mailbox is neither fixed nor limited. So, I cannot force that 
into a view layout like:

c_uid | c_name | c_password | c_cn | mail | mail_2 | mail_3 | ... | mail_n

Or am I missing something?

Thanks,

Martin


signature.asc
Description: Message signed with OpenPGP using GPGMail

[SOGo] sql user sources configuration question

[mar...@waschbuesch.de]

Hi there,

I use SOGo as a web frontend to a (home-grown) mailserver setup (based on 
PostgreSQL & Exim).
Everything works really well (SOGo is a really cool piece of software!) except 
for two things:

- When using anything but a plain table or very straightforward view to a 
table, it seems impossible to let users change their passwords via SOGo 
(complex views are not writeable). It would be really cool if it were possible 
to be able to configure a custom query for password changes within sogo.conf? 
Or is there an alternative approach I could use?

- The setup I wrote does not use the email address as a primary key. In fact, 
each mailbox can have any unique combination of localpart@domain associated 
with it and all associated email addresses are a valid username when logging in 
to that mailbox.
Now, for users having multiple email addresses poiniting to their mailbox, SOGo 
will unfortunately create a separate profile per email address treating them as 
individual users.
Is there a way to configure SOGo to recognize that different email addresses 
belong to the same mailbox?

Maybe people on the list have ideas how these issues could be addressed?

Thanks for any and all suggestions and help!

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

Re: [SOGo] Cannot send E-Mail via Sogo Webinterface

[mar...@waschbuesch.de]

> Am 28.08.2016 um 10:48 schrieb Jan B (jabr...@gmx.de) :
> 
> Hello Users,

Hi Jan,

> 
> unfortunately I cannot send any E-Mails from my sogo instance. Ass soon as I 
> press sent the green dialog (that normally shows sending successful) appears 
> and never disappears. I cannot remember having changed anything w.r.t. SOGo. 
> I enabled all debug logging options on in the config, but I do not get any 
> hint from the logs. The last entries being that it searches my addressbook 
> for the typed recipient.
> 
> Do you have any idea how to figure out what the issue is?
> 
> Regards,

What have you configured as the directory for temporary files / drafts?
The configuration item is SOGoMailSpoolPath
Check that the permissions are correct and that the sogo user has write 
access.(And remember to check parent directories as well...)

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