Hi mj
> On Oct 2, 2020, at 8:26 AM, mj ([email protected]) <[email protected]> wrote:
>
> For security reasons (more stringent password requirements) we would like to
> change the sogo database connection credentials.
>
> However, to do that, we don't only need edit sogo.conf, but also the saved
> credentials in the database, per user in the sogo_folder_info.
>
> Is there a supported nice way (sogo-tool?) to do that for users that are
> already in the database?
>
> We're runing mysql, btw, and SOGo V5.
Exactly, you need to modify three columns of the sogo_folder_info table. If you
want to change the password, you would do something like this:
update sogo_folder_info set \
c_location = replace(c_location, 'YOUR_OLD_PASSWORD', 'YOUR_NEW_PASSWORD'),
\
c_quick_location = replace(c_quick_location, 'YOUR_OLD_PASSWORD',
'YOUR_NEW_PASSWORD'), \
c_acl_location = replace(c_acl_location, 'YOUR_OLD_PASSWORD',
'YOUR_NEW_PASSWORD');
Francis
--
[email protected]
https://inverse.ca/sogo/lists
