Re: [SOGo] mass-edit sogo_folder_info for database connection details

2020-10-06 Thread mj
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

Re: [SOGo] mass-edit sogo_folder_info for database connection details

2020-10-06 Thread lists
Hi Francis! Op 5-10-2020 om 17:59 schreef Francis Lachapelle (flachape...@inverse.ca): 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 =

Re: [SOGo] mass-edit sogo_folder_info for database connection details

2020-10-06 Thread 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,

Re: [SOGo] mass-edit sogo_folder_info for database connection details

2020-10-05 Thread Francis Lachapelle
Hi mj > On Oct 2, 2020, at 8:26 AM, mj (li...@merit.unu.edu) 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

Re: [SOGo] mass-edit sogo_folder_info for database connection details

2020-10-05 Thread mj
Hi, Op 10/2/20 om 2:26 PM schreef mj (li...@merit.unu.edu): 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

[SOGo] mass-edit sogo_folder_info for database connection details

2020-10-02 Thread mj
Hi, 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