Export/Import of all Connections does not preserve passwords

[rohanc]

I'm reporting a bug concerning the backup and restore of all of the connection profiles within TablePlus, as you would do when reinstalling Windows or moving to a new computer.

2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 5.0.1 (210) x64

4. The steps to reproduce this issue: From the "Welcome to TablePlus" top-level screen, right-click in the connections area and choose Export, export all. Leave "include databses password" and "include servers password" ticked. Supply a password to secure the file. Press Confirm, save a file etc.

Now install TablePlus on a new computer. From the "Welcome to TablePlus" top-level screen right-click in the connections area and choose "Import..." and select the all_dump*.tableplusconnection file that you saved earlier. Observe that all the connections came back.

Try and use one of the connections. Immediately we get:

Driver Error

connection to server at "xxx" (1.2.3.4), port 5432 failed: fe_sendauth: no passsword supplied In this case I was trying to connect to a postgresql server.

If I edit the connection I note that there is nothing in the Password field. If I supply the correct password the connection works.

I remember trying the backup/restore of connections about a year ago too, and it didn't completely work, so I think we've had bugs in this section of the code for a while.