Hello all,
as I have recently changed the DB Password without knowing that it needs
to be changed in the DB as well I ask myself what is the impact of the
wrong password there? I had no reports that something is not working. I
am a bit confused.
Regards
Christian
On 05.10.20 17:59, Francis Lachapelle ([email protected]) wrote:
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
--
Dr. Christian Naumer
Unit Head Bioprocess Development
B.R.A.I.N Aktiengesellschaft
Darmstaedter Str. 34-36, D-64673 Zwingenberg
e-mail [email protected], homepage www.brain-biotech.com
fon +49-6251-9331-30 / fax +49-6251-9331-11
Sitz der Gesellschaft: Zwingenberg/Bergstrasse
Registergericht AG Darmstadt, HRB 24758
Vorstand: Adriaan Moelker (Vorstandsvorsitzender),
Lukas Linnig
Aufsichtsratsvorsitzender: Dr. Georg Kellinghusen
--
[email protected]
https://inverse.ca/sogo/lists
