[Bug 149542] Re: Gnome RDP database corruption

[Kamujin]

** Changed in: gnome-rdp (Ubuntu)
   Status: Fix Committed => Fix Released

-- 
Gnome RDP database corruption
https://bugs.launchpad.net/bugs/149542
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 149542] Re: Gnome RDP database corruption

[Kamujin]

The Gnome-RDP team is aware of this issue and we are reviewing the
changes designed to resolve this problem.

Hopefully, there should be a new version out soon to address this.

** Changed in: gnome-rdp (Ubuntu)
 Assignee: (unassigned) => Kamujin (james-p-michels)
   Status: New => Confirmed

** Changed in: gnome-rdp (Ubuntu)
   Status: Confirmed => Fix Committed

-- 
Gnome RDP database corruption
https://bugs.launchpad.net/bugs/149542
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 149542] Re: Gnome RDP database corruption

[tc7]

Excellent. I did a dump / read and cp conversion of sqlite3 to sqlite
and gnome-rdp now works fine now with the original libsqlite.so.0

thanks!

-- 
Gnome RDP database corruption
https://bugs.launchpad.net/bugs/149542
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 149542] Re: Gnome RDP database corruption

[woodgdo1]

Another Fix that I just came up with and is a bit more elegant:
(Dump a SQL backup of the DB)
cp .gnome-rdp.db .gnome-rdp2.db
sqlite3 .gnome-rdp.db
sqlite> .output dbdump
sqlite> .dump
sqlite> .quit

(Verify that there is data in the dump file)
cat dbdump

(Restore DB to other version of sqlite)
sqlite new.db
sqlite> .read dbdump
(To verify that the data made it in there correctly)
.dump 
.quit
cp new.db .gnome-rdp.db

Enjoy!!

-- 
Gnome RDP database corruption
https://bugs.launchpad.net/bugs/149542
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 149542] Re: Gnome RDP database corruption

[tc7]

Thanks, the 2nd suggestion works fine for me. I don't know of any
dependency on the original sqlite so I've made the mv semi permanent.

F-Spot still works fine (for example).

-- 
Gnome RDP database corruption
https://bugs.launchpad.net/bugs/149542
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 149542] Re: Gnome RDP database corruption

[starbugx]

The other way to make gnome-rdp working is to change the link from the 
libsqlite.so.0 while starting gnome-rdp so it is forced to use libsqlite3.so.0.
Use the following startscript for gnome-rdp instead of gnome-rdp:

[CODE]
#!/bin/bash
mv /usr/lib/libsqlite.so.0 /usr/lib/libsqlite.so.0_
gnome-rdp&
sleep 1
mv /usr/lib/libsqlite.so.0_ /usr/lib/libsqlite.so.0
[/CODE]

-- 
Gnome RDP database corruption
https://bugs.launchpad.net/bugs/149542
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 149542] Re: Gnome RDP database corruption

[starbugx]

To read the old ~/.gnome-rdp.db file do the following before delete it:
You will see the "Servername IP-Address Username Password". I hope it will help 
to restore the old information.

sqlite3 ~/.gnome-rdp.db
SQLite version 3.4.2
Enter ".help" for instructions
sqlite> .output gnome-rdp.db.txt
sqlite> select * from session;
sqlite> .exit

grep "\." gnome-rdp.db.txt | awk -F"|" '{print $4 " " $6 " "  $7 " "
$8}'

-- 
Gnome RDP database corruption
https://bugs.launchpad.net/bugs/149542
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs