Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

This thread was archived. Please ask a new question if you need help.

How to migrate saved credentials from SQLite to JSON?

jakobcornell
jakobcornell
more options

I think this issue came up when the Debian repositories switched from IceWeasel to actual Firefox ESR. Around this time, Firefox stopped recalling saved passwords and asking to save new passwords. The list in Preferences still contained my credentials.

I consulted this page: http://kb.mozillazine.org/Password_Manager#Troubleshooting

I tried to import the credentials from SQLite using the registry key/restart process in the article, and that didn't work (the registry key was set on restart, but the credential list in Preferences was empty).

Next I tried to export to JSON using the Browser Console code in the article. The output was an empty JSON array.

How to get the Firefox gods to smile upon my migration?

I think this issue came up when the Debian repositories switched from IceWeasel to actual Firefox ESR. Around this time, Firefox stopped recalling saved passwords and asking to save new passwords. The list in Preferences still contained my credentials. I consulted this page: http://kb.mozillazine.org/Password_Manager#Troubleshooting I tried to import the credentials from SQLite using the registry key/restart process in the article, and that didn't work (the registry key was set on restart, but the credential list in Preferences was empty). Next I tried to export to JSON using the Browser Console code in the article. The output was an empty JSON array. How to get the Firefox gods to smile upon my migration?

Modified by jakobcornell

All Replies (2)

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

Do you have a signons.sqlite file?

Firefox can still import this file in the Password Manager if you remove the logins.json file and reset signon.importedFromSqlite via the right-click context menu to the default value.

You can open the about:config page via the location/address bar. You can accept the warning and click "I'll be careful" to continue.

jakobcornell
jakobcornell Question owner
more options

Oh, right. No, there's no 'signons.sqlite' in my profile, which I'm guessing is because I've been using a KDE Wallet integration add-on (https://addons.mozilla.org/en-US/firefox/addon/kde-wallet-password-integratio).

I assume Firefox was previously pulling my credentials from KDE's store, and the update broke this interoperability. The developer of the add-on has dropped off the face of the earth, so there'll be no getting help there.

I do have a 'key3.db' file and access to the plaintext username/password pairs through KDE Wallet. With these two things is there a way to produce the encrypted credentials needed to populate 'logins.json'? I think I came across a python program to do that while I was researching for this issue but I can't remember where it was.