Commander icon indicating copy to clipboard operation
Commander copied to clipboard

Allow MariaDB rotation with MySQL plugin

Open ogowen45 opened this issue 2 years ago • 1 comments

By changing the current lines 54-63 in mysql.py from the below:

if affected == 1: rs = cursor.fetchone() version = rs[0] # type: str vc = version.split('.') vn = 0 if len(vc) == 3: for n in vc: vn *= 1000 vn += int(n) is_old_version = vn < 5007006

to:

            if affected == 1:
                rs = cursor.fetchone()
                version = rs[0]     # type: str
                main_version = version.split('-',1)[0]
                vc = main_version.split('.')
                vn = 0
                if len(vc) == 3:
                    for n in vc:
                        vn *= 1000
                        vn += int(n)
                    is_old_version = vn < 5007006

It allows it to handle MariaDB versions to then rotate the password as expected.

ogowen45 avatar Aug 02 '23 22:08 ogowen45

Thank you for letting us know about MariaDB version format differences. The next release will include this fix. https://github.com/Keeper-Security/Commander/commit/16b5ce41d6fdb91d62660aa39a0cc0a2a49b81fb

sk-keeper avatar Aug 06 '23 20:08 sk-keeper