And here the problem starts.
After every major upgrade of Ubuntu, Gnome-RDP does not read the file correctly:
Error in query:This is annoying as connection information and passwords are stored in this database.
SELECT * FROM version WHERE id=1
Error:file is encrypted or is not a database
Reason for the error is a difference in the SQlite schema. The error message is missleading.
Here is a fix that works on Ubuntu 9.04.
- Open a console window
- Check if sqlite and sqlite3 are installed (type sqli and tab. If you have installed a fresh copy then sqlite might be missing. Temporarily install it)
sudo apt-get install sqlite
- Make a copy of the gnome config database
mv .gnome-rdp.db .gnome-rdp-backup.db
- Start Gnome-RDP and quit immediately. This creates an empty config database. Then you dump the old database using sqlite to the new database using the new sqlite3
gnome-rdpJust dump the session table (which will dump CREATE statements as well) and just use the INSERT statements to copy the data into the new file.
sqlite .gnome-rdp-backup.db ".dump session" | fgrep INSERT | sqlite3 .gnome-rdp.db
- Starting Gnome-RDP should now work fine.
- Deinstall sqlite (you won't need it)
sudo apt-get remove sqlite
Thanks to Mick K for the solution.