Changing tango database password without loosing database content

# 5 years ago
philippeg	Hi, I would like to change a password for the user tango on a database. Using dpkg-reconfigure will loose the content of the database. Changing the password through mariadb would be a simple solution, but I would need probably to change the password somewhere else to allow tango system to connect to the database with the new password. What are the steps to follow to change the tango database password without removing the database content? EDIT: I already tested changing the password and then jive does not work so there is some way allowing jive to authenticate to the tango DB. I also tested changing the password and then using dpkg-reconfigure, it reinstall the default database so all the device configured before are lost. I also tested a dump before dpkg-reconfigure and then import the dump after dpkg-reconfigure, and it seems to work. Is this last option the only way to do it? Thank you. - Philippe Edited 5 years ago

# 5 years ago

Hi,
I would like to change a password for the user tango on a database.

Using dpkg-reconfigure will loose the content of the database.
Changing the password through mariadb would be a simple solution, but I would need probably to change the password somewhere else to allow tango system to connect to the database with the new password.

What are the steps to follow to change the tango database password without removing the database content?

EDIT: I already tested changing the password and then jive does not work so there is some way allowing jive to authenticate to the tango DB.
I also tested changing the password and then using dpkg-reconfigure, it reinstall the default database so all the device configured before are lost.
I also tested a dump before dpkg-reconfigure and then import the dump after dpkg-reconfigure, and it seems to work.
Is this last option the only way to do it?

Thank you.

- Philippe

Edited 5 years ago

# 5 years ago
Reynald	Hi Philippe, philippeg I also tested changing the password and then using dpkg-reconfigure, it reinstall the default database so all the device configured before are lost. In this case, dpk-reconfigure says that a backup of the original database is made in /var/tmp if you keep the same database name. So you should be able to restore it afterwards. Rosenberg's Law: Software is easy to make, except when you want it to do something new. Corollary: The only software that's worth making is software that does something new.

# 5 years ago

Reynald

Hi Philippe,

philippeg
I also tested changing the password and then using dpkg-reconfigure, it reinstall the default database so all the device configured before are lost.

In this case, dpk-reconfigure says that a backup of the original database is made in /var/tmp if you keep the same database name.
So you should be able to restore it afterwards.

Rosenberg's Law: Software is easy to make, except when you want it to do something new.
Corollary: The only software that's worth making is software that does something new.

# 5 years ago
philippeg	Yes, absolutely. I made the dump just in case. I wanted to know if there is a way to reset the password without needing to import explicitely the dump. Then, I do not understand how the tools get the authentication to access the database. I would be interested to know this. - Philippe