Firefox 60.3.0esr (64-bit) "Error while importing credentials from browser."

[zjw]

When attempting to use this importer, I get, "Error while importing credentials from browser."

Firefox 60.3.0esr (64-bit) KeePassBrowserImporter 1.0.6

Before using the importer, my Firefox profile does not have a signons.sqlite file. After use (and after the error occurs), my Firefox profile has a freshly created signons.sqlite file which is empty. I believe the importer is failing because it is attempting to read sql data from an empty file that it created.

When I manually create a signons.sqlite database with a suitable schema but with no data records, the importer accesses the file, finds nothing, and then it proceeds to successfully import the passwords that it finds in my logins.json file.

The importer should probably check to see if the signons.sqlite file exists before attempting access it.

[zjw]

As hinted in my original post above, I was able to work around this issue and get the importer to work.

Work-around details Download a dummy signons.sqlite file from here. Place a copy of the file in your Firefox profile folder. That's it -- the importer should then work.

Notes

1. To find your Firefox profile folder: In the Firefox menu, go to 'Help -> Troubleshooting Information'. The path to the Profile Folder will be listed there. You can use the 'Open Folder' button for easy access.

2. If you find that you already have a signons.sqlite file in your Firefox profile folder, make sure that it is empty (0 bytes) before removing it and replacing it with the dummy file that was downloaded. When in doubt, copy the existing file elsewhere as a backup before replacing it. (As mentioned in my original post above, the password importer will create an empty (0 bytes) file if the file does not already exist, so if you have attempted to run the importer previously, the empty file will already exist.)

3. If you have sqlite3 installed and want to know how to create your own dummy signons.sqlite file -- simply run this command:

sqlite3 signons.sqlite 'CREATE TABLE moz_logins (hostname text, encryptedUsername text, encryptedPassword text, timeCreated int, timePasswordChanged int);'

4. This password importer seems rather slow (even after turning off its settings for extracting info from web pages). Be patient for it to run. Progress can be observed as the logins are displayed on the bottom status line of the KeepPass program.

5. As an alternative, you can also use this password importer with Firefox. But it, too, has a problem that requires a work-around: Tiggerito/WebSiteAdvantage.KeePass.Firefox#2.