FF 26 Update resets HTML5 webapps configuration

[Tom Brossman]

I've updated to Firefox 26.0 running on 64-bit Ubuntu 12.04.3LTS today. I use two HTML5 webapps, GAuth Authenticator and TweetDeck. Both are now reset to the default configuration as if they were newly installed. I'm not logged in to TweetDeck and there is only one demo account for GAuth Authenticator.

Checking my backups, I tried restoring the profile directory for each webapp but this did not recover the settings. Each file and file size look to be identical when comparing before/after updates.

Is there a way to recover my data and accounts?

[Gerard Braad (gbraad)]

Check if the webappsstore.sqlite database is not corrupted or broken (you can find it in your profile directory):

$ sqlite3 webappsstore.sqlite
sqlite> select * from webappsstore2;

this will return all results for localstorage. if no result is returned, firefox must have purged it for no reason.

[Tom Brossman (tom.brossman)]

The database is present and working, and I was able to recover my keys using those commands. This indicates Firefox is not reading the database entry (or it would see the values and work as before). No idea why but I'll post how to recover the keys for GAuth Authenticator in case it helps anyone else:

1) Open your home folder and press CTRL + H to display hidden folders
2) Open folder .http;gauth.apps.gbraad.nl, inside that open profile folder RANDOMCODE.default
3) Copy the file webappstore.sqlite to your Desktop
4) CTRL + ALT + T open a terminal and run: sudo apt-get install sqlite3 && cd ./Desktop/
5) In terminal: sqlite3 webappsstore.sqlite
6) Open GAuth Authenticator now and click the plus sign to re-add your accounts manually. Use the same names & secret keys now displayed in the Terminal.
7) After you have the codes copied & GAuth Authenticator working again, enter in terminal to quit sqlite3: .exit

Done, and if anyone else has an easier way to do this please explain as a comment. This is tested and working for me though probably not the most elegant workaround.

[Tom Brossman (tom.brossman)]

Sorry, Step 5 should be: sqlite3 webappsstore.sqlite and then enter 'select * from webappsstore2;' at the sqlite prompt (without quotes).

[Gerard Braad (gbraad)]

Step5 can be easier (in case you have a lot of data in webappsstore.sqlite)

$ sqlite3 webappsstore.sqlite
sqlite> select * from webappsstore2 where scope like "ln.daarbg%";

This limits to only the result from the webapps at the 'gbraad.nl' domain, such as http://gauth.apps.gbraad.nl

[Paul White (paulw2u)]

Tom,

We are sorry that we do not always have the capacity to review all reported bugs in a timely manner. You reported this bug some time ago and there have been many changes in Ubuntu since that time.

Presumably this problem was a one time occurrence and/or is no longer an issue? Can this bug report now be closed?

If we do not hear from you the bug report will close itself in approximately 60 days time.

Thank you for helping make Ubuntu better.

Paul White
[Ubuntu Bug Squad]

[Tom Brossman (tom.brossman)]

Yes, this bug no longer affects me and I was able to recover all my data. Thanks for following up, and I'm happy for this bug report to be closed now.

[Paul White (paulw2u)]

Thanks Tom. Closing by marking "Invalid" as bug report was never actually confirmed.