On Wed, Mar 1, 2023 at 3:17 PM Kat Ludwig <[email protected]> wrote:
> Greetings, > > We have implemented an Azure Mariadb database for our guacamole prod > install. However, Azure doesn’t support any current versions of Mariadb, > so I wanted to change over to Postgres preferably or to Mysql. Do you know > of any ways we can convert the mariadb to either postgresql or mysql? I > have tried some common import/export methods but they error out on various > columns. I believe the hashing is causing an issue. > > > I don't know of any automated way to do this. You can use an ETL tool to copy the data over, but the password hashing is likely going to be tricky, as the hash functions and storage methods are slightly different between the databases. I'm not sure how many users you have, but it might make sense to migrate everything except the passwords for the users and just reset those and then expire them. -Nick >
