Hi,
I think what happened with us:
In sogo.conf we used to have mysql creds userorig/passorig, with
matching user in mysql: 'userorig'@'localhost'
A year ago, we added a user in mysql: 'usernew'@'*' with rights granted
on the sogo database, and changed sogo.conf to use that new user, but
did NOT remove the old user.
Everything continued to work fine.
Recently we decided to remove that original 'userorig'@'localhost' from
mysql, and then suddenly problems arose. Checking the database contents,
we noticed that recently added users had the 'newusernew'@'* connection
details in their sogo_folder_info, but older users were still using the
(now deleted) 'userorig'@'localhost'
I cannot explain why it seemed to work for you, and did not work for us.
MJ
Op 10/6/20 om 8:23 AM schreef c...@brain-biotech.de:
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 (flachape...@inverse.ca) wrote:
Hi mj
On Oct 2, 2020, at 8:26 AM, mj (li...@merit.unu.edu) <users@sogo.nu>
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
--
users@sogo.nu
https://inverse.ca/sogo/lists
