I finally decided to upgrade from 8.04 LTS (Hardy Heron) to 9.04 (Jaunty Jackalope) today, although this is probably relevant to those upgrading from 8.10 (Intrepid Ibex) too.
After the seemingly flawless upgrade, I decided to RDP into another machine and was presented with the following error:
'Error in query: SELECT * FROM version WHERE id = 1 Error:file is encrypted or is not a database'
So I clicked 'OK'
'There was an error during reading of record.'
So I clicked 'OK' again.
'Invalid database version!'
Now Gnome-RDP decided to close itself.
I assumed the problem was to do with the Gnome-RDP database located in my home directory '.gnome-rdp.db'. So I decided to compare the old database to a new one on a clean install. It seems the new one is using sqlite3 whereas the old one used sqlite2. As well as using the newer version of sqlite there is also a new table used by the new version that must be created.
I have found a simple work-around for this problem.
Open a terminal window and run the following commands:
What this does is: 1) Kill Gnome-RDP if its running. 2) Moves the old database named '.gnome-rdp.db' to '.gnome-rdp-backup.db'. 3) Opens the old .gnome-rdp with sqlite 2.x and dump out it's contents, then pipe it into the new sqlite 3 database. 4) Then create a new table called appOptions in the database. This new table is required by the newer version of gnome-rdp.
I hope this helps, a better fix would be if Gnome-RDP detected the version of the database and did this itself.
After the seemingly flawless upgrade, I decided to RDP into another machine and was presented with the following error:
'Error in query:
SELECT * FROM version WHERE id = 1
Error:file is encrypted or is not a database'
So I clicked 'OK'
'There was an error during reading of record.'
So I clicked 'OK' again.
'Invalid database version!'
Now Gnome-RDP decided to close itself.
I assumed the problem was to do with the Gnome-RDP database located in my home directory '.gnome-rdp.db'. So I decided to compare the old database to a new one on a clean install. It seems the new one is using sqlite3 whereas the old one used sqlite2. As well as using the newer version of sqlite there is also a new table used by the new version that must be created.
I have found a simple work-around for this problem.
Open a terminal window and run the following commands:
killall gnome-rdp
mv .gnome-rdp.db .gnome-rdp-backup.db
sqlite .gnome-rdp-backup.db .dump | sqlite3 .gnome-rdp.db
sqlite3 .gnome-rdp.db "CREATE TABLE appOptions (name VARCHAR(300) PRIMARY KEY, value VARCHAR(300));"
What this does is:
1) Kill Gnome-RDP if its running.
2) Moves the old database named '.gnome-rdp.db' to '.gnome-rdp-backup.db'.
3) Opens the old .gnome-rdp with sqlite 2.x and dump out it's contents, then pipe it into the new sqlite 3 database.
4) Then create a new table called appOptions in the database. This new table is required by the newer version of gnome-rdp.
I hope this helps, a better fix would be if Gnome-RDP detected the version of the database and did this itself.