I used the wrong user "root" instead of "sogo".

International Security Providers <[email protected]> schrieb am Freitag, 7. März 
2025 um 2:51 nachm.:

> the issue which is persisting doesn't seem to be related to sieve anymore but 
> to sogo's own store.
> [SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
> 
> 
> complete output:
> 2025-03-07 14:49:57.483 sogo-tool[750089:750089] ERROR(+[GCSFolderManager 
> defaultFolderManager]): default 'OCSFolderInfoURL' is not configured.
> <0x0x555bd6c08180[SOGoCache]> Cache cleanup interval set every 43200.000000 
> seconds
> 
> <0x0x555bd6c08180[SOGoCache]> Using host(s) 'memcached' as server(s)
> 
> <0x0x555bd6b9f070[SOGoUserManager]> No authentication sources defined - 
> nobody will be able to login. Check your defaults.
> 
> 2025-03-07 14:49:57.514 sogo-tool[750089:750089] 
> ERROR(-[NSException(NGMiscellaneous) initWithFormat:]): missing format!
> <0x0x555bd6b78750[SOGoSQLUserProfile]> failed to acquire channel for URL: 
> (null)
> 
> 
> I use saml and that works to login and creating out of office using the sogo 
> webinterface works too.
> 
> International Security Providers [email protected] schrieb am Mittwoch, 5. März 
> 2025 um 12:06:
> 
> > jep the get works perfectly fine..
> > I run the command from within the docker container of mailcows sogo
> > and yes /etc/sogo/sogo.conf exists.
> > 
> > qhivert [email protected] schrieb am Dienstag, 4. März 2025 um 17:02:
> > 
> > > Where are you executing the command ?
> > > 
> > > I don't understand how the "get" can work but not the "set". Here 
> > > sogo-tool can't even find your database configuration. Are you sur you 
> > > have a sogo.conf file at /etc/sogo/sogo.conf where you're making the 
> > > sogo-tool command?
> > > 
> > > Quentin
> > > 
> > > -----Original Message-----
> > > From: [email protected] [email protected] On Behalf Of 
> > > International Security Providers
> > > 
> > > Sent: mardi 4 mars 2025 16:59
> > > To: [email protected]
> > > Subject: RE: [SOGo] change "out of office" for another account
> > > 
> > > Hi
> > > 
> > > I smh don't find a sieve script. (I use mailcow) but I know that 
> > > everything works when I use the sogo webmail to configure it.
> > > 
> > > with your command (just using my /etc/sogo/sieve.creds) I now get this:
> > > SOGoSQLUserProfile]> failed to acquire channel for URL: (null)
> > > 
> > > BR
> > > 
> > > qhivert [email protected] schrieb am Dienstag, 4. März 2025 um 16:17:
> > > 
> > > > Hello!
> > > > 
> > > > Maybe your command is missing a mandatory value to put into the sieve 
> > > > script. Doing what you did with the webmail I've got. The following 
> > > > value and the commands work:
> > > > 
> > > > sogo-tool user-preferences set defaults "[email protected]"
> > > > Vacation
> > > > '{"daysBetweenResponse":"3","autoReplyEmailAddresses":["administrator@
> > > > mydomain.tld"],"enabled":1,"autoReplyText":"Testing direct
> > > > value","days":[]}' -p cred
> > > > 
> > > > Also, it's possible that your sogo.script in your sieve server is not 
> > > > ok from the beginning, and when sogo is trying to add the vacation part 
> > > > it fails.
> > > > Could you check it?
> > > > 
> > > > You can also add ImapDebugEnabled to your sogo.conf to see the sieve 
> > > > communication and the file sogo is trying to write.
> > > > 
> > > > Quentin
> > > > 
> > > > -----Original Message-----
> > > > From: [email protected] [email protected] On Behalf Of
> > > > International Security Providers
> > > > 
> > > > Sent: mardi 4 mars 2025 16:02
> > > > To: [email protected]
> > > > Subject: Re: [SOGo] change "out of office" for another account
> > > > 
> > > > Hello
> > > > 
> > > > thanks again for the response :)
> > > > 
> > > > I tried this now again witht his updated command (oneliner):
> > > > /usr/sbin/sogo-tool user-preferences set defaults 
> > > > "[email protected]" -p /etc/sogo/sieve.creds Vacation 
> > > > '{"Vacation": {"enabled":1,"autoReplyText":"Testing direct 
> > > > value","daysBetweenResponse":3}}'
> > > > 
> > > > but I always get this parsing error:
> > > > "Could not upload Sieve script: sogo: line 5: error: expecting ',' or 
> > > > end of string list ']', but found ';'."
> > > > 
> > > > I only copied your command and replaced the newlines with spaces.. I 
> > > > can't seem to figure out my issue in formatting.
> > > > 
> > > > BR
> > > > 
> > > > Christian Mack [email protected] schrieb am Dienstag, 4. März 2025 um 14:51:
> > > > 
> > > > > Hello
> > > > > 
> > > > > Multiple answers, see inline below.
> > > > > 
> > > > > Am 04.03.25 um 12:17 schrieb International Security Providers
> > > > > ([email protected]):
> > > > > 
> > > > > > Thank you a lot.
> > > > > > reading works but smh writign the values doesn't:
> > > > > > /usr/sbin/sogo-tool user-preferences set defaults
> > > > > > "[email protected]" Vacation
> > > > > > '{"enabled":1,"autoReplyText":"Testing direct
> > > > > > value","daysBetweenResponse":3}' -p /etc/sogo/sieve.creds -F
> > > > > 
> > > > > First: There is no "-F" option for user-preferences.
> > > > > Second: "-p /etc/sogo/sieve.creds" has to be provided after the user 
> > > > > name.
> > > > > Third: You have to provide valid json as input value!
> > > > > I myself had an copy and paste error there :-) The correct example
> > > > > from above would be:
> > > > > 
> > > > > /usr/sbin/sogo-tool user-preferences set defaults
> > > > > "[email protected]" -p /etc/sogo/sieve.creds Vacation
> > > > > '{"Vacation": {"enabled":1,"autoReplyText":"Testing direct
> > > > > value","daysBetweenResponse":3}}'
> > > > > 
> > > > > > 2025-03-04 11:59:53.612 sogo-tool[35744:35744] 
> > > > > > ERROR(+[GCSFolderManager defaultFolderManager]): default 
> > > > > > 'OCSFolderInfoURL' is not configured.
> > > > > > <0x0x5620222ac670[SOGoCache]> Cache cleanup interval set every
> > > > > > 43200.000000 seconds <0x0x5620222ac670[SOGoCache]> Using host(s)
> > > > > > 'memcached' as server(s) <0x0x562022274980[SOGoUserManager]> No 
> > > > > > authentication sources defined - nobody will be able to login. 
> > > > > > Check your defaults.
> > > > > 
> > > > > Fourth: Check your /etc/sogo/sogo.conf It has to contain the
> > > > > SOGoUserSources entry.
> > > > > /usr/sbin/sogo-tool will use that in order to find the user
> > > > > specified on the command line.
> > > > > 
> > > > > > 2025-03-04 11:59:53.641 sogo-tool[35744:35744] 
> > > > > > ERROR(-[NSException(NGMiscellaneous) initWithFormat:]): missing 
> > > > > > format!
> > > > > > <0x0x562022410740[SOGoSieveManager]> Could not delete Sieve script:
> > > > > > Sieve script `sogo' not found
> > > > > 
> > > > > This only means, there was no SIEVE script before for that user.
> > > > > Which is harmless.
> > > > > 
> > > > > > <0x0x562022410740[SOGoSieveManager]> Could not upload Sieve script: 
> > > > > > sogo: line 5: error: expecting ',' or end of string list ']', but 
> > > > > > found ';'.
> > > > > > sogo: error: parse failed.
> > > > > > 
> > > > > > 2025-03-04 11:59:53.654 sogo-tool[35744:35744] Error updating
> > > > > > sieve script, not updating database user-preferences get|set|unset
> > > > > > defaults|settings user [-p credentialFile] key [value|-f filename]
> > > > > > 
> > > > > > user the user of whom to set the defaults/settings key/value value
> > > > > > the JSON-formatted value of the key
> > > > > > 
> > > > > > -p credentialFile Specify the file containing the sieve admin
> > > > > > credentials The file should contain a single line:
> > > > > > username:password
> > > > > > -F force the activation of the sieve script in case external 
> > > > > > scripts. Must be the las targument after -p credentialsFile 
> > > > > > Examples:
> > > > > > sogo-tool user-preferences get defaults janedoe SOGoLanguage
> > > > > > sogo-tool user-preferences unset settings janedoe Mail sogo-tool
> > > > > > user-preferences set defaults janedoe SOGoTimeFormat 
> > > > > > '{"SOGoTimeFormat":"%I:%M %p"}'
> > > > > 
> > > > > Those show the syntax wasn't correct and the provided value could
> > > > > not be parsed (== first till third errors).
> > > > > 
> > > > > Hope that helps.
> > > > > 
> > > > > Kind regards,
> > > > > Christian Mack
> > > > > 
> > > > > > Christian Mack [email protected] schrieb am Donnerstag, 27. Februar 
> > > > > > 2025 um 11:02:
> > > > > > 
> > > > > > > Hello
> > > > > > > 
> > > > > > > Am 26.02.25 um 17:28 schrieb International Security Providers
> > > > > > > ([email protected]):
> > > > > > > 
> > > > > > > > is it smh possible to change "out of office" for another 
> > > > > > > > account?
> > > > > > > > I have some accounts which are not users but are only used as 
> > > > > > > > group-accounts.
> > > > > > > 
> > > > > > > You only can set this via console on the SOGo server.
> > > > > > > 
> > > > > > > Get the current one with:
> > > > > > > /usr/sbin/sogo-tool user-preferences get defaults $USER Vacation
> > > > > > > 
> > > > > > > And set a new one with:
> > > > > > > /usr/sbin/sogo-tool user-preferences set defaults $USER Vacation
> > > > > > > '"Vacation":
> > > > > > > {"daysBetweenResponse":"2","autoReplyEmailAddresses":["users.ema
> > > > > > > il
> > > > > > > [email protected]",
> > > > > > > "[email protected]"],"enabled":1,"endDate":1761136
> > > > > > > 20
> > > > > > > 0,"autoReplyText":"This
> > > > > > > is an automatic reply
> > > > > > > text.\n---------------------------------------------------------
> > > > > > > -- ---------\n\nThis is an group address which is not read at
> > > > > > > all.\nAll emails to it are
> > > > > > > discarted!!!\n\n--------------------------------------------------------------------\n","alwaysSend":0,"days":[],"ignoreLists":1,"endDateEnabled":1}'
> > > > > > > 
> > > > > > > Of course you should replace the content with your own :-)
> > > > > > > 
> > > > > > > All dates are in Unix Timestamp format.
> > > > > > > You get it with:
> > > > > > > date -d '2025-10-22 14:30:00' "+%s"
> > > > > > > 
> > > > > > > Kind regards,
> > > > > > > Christian Mack
> > > > > > > 
> > > > > > > --
> > > > > > > Christian Mack
> > > > > > > Universität Konstanz
> > > > > > > Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung
> > > > > > > IT-Dienste Forschung, Lehre, Infrastruktur
> > > > > > > 78457 Konstanz
> > > > > > > +49 7531 88-4416
> > > > > 
> > > > > --
> > > > > Christian Mack
> > > > > Universität Konstanz
> > > > > Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung
> > > > > IT-Dienste Forschung, Lehre, Infrastruktur
> > > > > 78457 Konstanz
> > > > > +49 7531 88-4416

Reply via email to