Re: [ubuntu-uk] How to sync Liferea on two PCs
On Sat, May 31, 2008 at 06:22:07PM +0100, Mac wrote: I suspect the cause of my difficulties may at least in part be that my NAS drive is formatted FAT32, and therefore does not transfer ownerships and permissions; and, worse yet, I have a different user name on the household's main desktop from the one I use on my laptop and my other machines. I just had a play with moving ~/.liferea_1.4 onto the FAT partition in my laptop and creating a link to it, and it seemed to work fine. I had a play around running liferea as a different user with a link to the profile on the FAT drive: that failed the first time I tried it as the copy on the FAT drive didn't have write permissions for the user I was running liferea as so I added global read and write permissions to it and it then worked (so the ownership of the folder doesn't seem to be an issue, just the permissions). I don't have a network drive handy to test with but I think it should still work there. Could you try running liferea from a terminal with the profile on the network drive and see if it outputs any clues about what is going wrong? Robert Robert McWilliam [EMAIL PROTECTED]www.ormiret.com Only biologists could define multiplication and division as the same thing. -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
Robert McWilliam wrote: I just had a play with moving ~/.liferea_1.4 onto the FAT partition in my laptop and creating a link to it, and it seemed to work fine. snip I don't have a network drive handy to test with but I think it should still work there. Could you try running liferea from a terminal with the profile on the network drive and see if it outputs any clues about what is going wrong? Robert I moved ~/.liferea_1.4 to the FAT32 NAS, and simlinked to it from my home folder. Ran 'liferea' in terminal as you asked. Here's the output: ** ERROR **: Failure while preparing statement, (error=5, database is locked) SQL: SELECT COUNT(*) FROM sqlite_master WHERE type = 'table' AND name = 'info'; aborting... Aborted (core dumped) I tried chmod -R 777 on the NAS folder, but got the same output when I ran liferea in a terminal again. But when I move the profile back from the NAS to my /home folder, it works fine again. 'Fraid I don't know nothing about SQL, so I'm at a loss. Any thoughts? Mac -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
On Sun, Jun 1, 2008 at 5:01 PM, Mac [EMAIL PROTECTED] wrote: Robert McWilliam wrote: I just had a play with moving ~/.liferea_1.4 onto the FAT partition in my laptop and creating a link to it, and it seemed to work fine. snip I don't have a network drive handy to test with but I think it should still work there. Could you try running liferea from a terminal with the profile on the network drive and see if it outputs any clues about what is going wrong? Robert I moved ~/.liferea_1.4 to the FAT32 NAS, and simlinked to it from my home folder. Ran 'liferea' in terminal as you asked. Here's the output: ** ERROR **: Failure while preparing statement, (error=5, database is locked) SQL: SELECT COUNT(*) FROM sqlite_master WHERE type = 'table' AND name = 'info'; aborting... Aborted (core dumped) Sounds like you copied it while liferea was running? Matthew -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
Matthew Wild wrote: Sounds like you copied it while liferea was running? Matthew Many thanks for giving this your time and attention. I tried to be careful to stop liferea. Before I copied it, I did a CTRL+q to shut down liferea; and checked with ps aux | grep liferea, which didn't show anything. But, ever hopeful, I've just tried again immediately after a system shutdown and restart. I checked no liferea process was running, moved the profile to the NAS, and simlinked to it from my /home directory. Starting liferea in a terminal returned this: ** (liferea-bin:8119): WARNING **: Transaction end failed (database is locked) SQL: END ** ERROR **: file db.c: line 613 (db_init): assertion failed: (sqlite3_get_autocommit (db)) aborting... Aborted (core dumped) I'm beginning to feel like Catherine Tate: 'Am I bovvered?!' ;-) -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
On Sun, Jun 01, 2008 at 05:01:53PM +0100, Mac wrote: Robert I moved ~/.liferea_1.4 to the FAT32 NAS, and simlinked to it from my home folder. Ran 'liferea' in terminal as you asked. Here's the output: ** ERROR **: Failure while preparing statement, (error=5, database is locked) SQL: SELECT COUNT(*) FROM sqlite_master WHERE type = 'table' AND name = 'info'; aborting... Aborted (core dumped) A quick google on how sqlite does locking came up with the following: http://www.sqlite.org/faq.html#q5 Which suggests lots of possible problems with locking stuff over networks, and it doesn't look easy to fix. Robert Robert McWilliam [EMAIL PROTECTED]www.ormiret.com Instructions should be read first, or not at all. Anything else is admitting defeat... -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
Robert McWilliam wrote: A quick google on how sqlite does locking came up with the following: http://www.sqlite.org/faq.html#q5 Which suggests lots of possible problems with locking stuff over networks, and it doesn't look easy to fix. Thanks, Robert, that explains a lot. I now understand why some long and arcane scripts I saw for syncing Liferea had a lot of SQLite stuff in them. But the killer appears to be the problems with the buggy handling of locking on networks. I'm going to abandon this project. But I've again been very impressed with the generosity shown by folk on this list in spending time and effort suggesting solutions and helping to get to the bottom of an issue. Many thanks to everyone who has taken an interest. Mac -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
Robert McWilliam wrote: If you've got a network drive mounted you can put a link to somewhere on it in place of the ~/.liferea folder and then the different machines will share the same profile...snip... ...I should point out that I haven't tried this so keep a copy of the directory safe to put it back if it doesn't work. I wondered about this, and your suggestion prompted me to try it. Sadly, it didn't work: Liferea simply didn't open (despite seeming to spend a short while thinking about starting). And the 'rsync' method recommended by John and Stuart hasn't worked for me either. I suspect the cause of my difficulties may at least in part be that my NAS drive is formatted FAT32, and therefore does not transfer ownerships and permissions; and, worse yet, I have a different user name on the household's main desktop from the one I use on my laptop and my other machines. All in all, I think I'm pushing it a bit to hope Liferea wouldn't mind this level of scrambling! So when I tried to rsync the profile from the network to my laptop, I wasn't all that surprised that I'd lost the folder structure, and many of the feeds seemed to be missing. As I said in an earlier post, my experience of running Thunderbird on all of my computers from a profile on the NAS led me to hope I could get Liferea to do the same; but I guess Liferea may be a bit more fussy, and my set up isn't conducive to a simple work around. :-( I may do some experiments with a usb drive formatted ext3; but I think I'll leave things as they are for now. Many thanks to everyone who's giving advice and suggestions. Mac -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
If you've got a network drive mounted you can put a link to somewhere on it in place of the ~/.liferea folder and then the different machines will share the same profile...snip... ...I should point out that I haven't tried this so keep a copy of the directory safe to put it back if it doesn't work. I wondered about this, and your suggestion prompted me to try it. Sadly, it didn't work: Liferea simply didn't open (despite seeming to spend a short while thinking about starting). And the 'rsync' method recommended by John and Stuart hasn't worked for me either. I suspect the cause of my difficulties may at least in part be that my NAS drive is formatted FAT32, and therefore does not transfer ownerships and permissions; and, worse yet, I have a different user name on the household's main desktop from the one I use on my laptop and my other machines. All in all, I think I'm pushing it a bit to hope Liferea wouldn't mind this level of scrambling! So when I tried to rsync the profile from the network to my laptop, I wasn't all that surprised that I'd lost the folder structure, and many of the feeds seemed to be missing. As I said in an earlier post, my experience of running Thunderbird on all of my computers from a profile on the NAS led me to hope I could get Liferea to do the same; but I guess Liferea may be a bit more fussy, and my set up isn't conducive to a simple work around. :-( I may do some experiments with a usb drive formatted ext3; but I think I'll leave things as they are for now. Many thanks to everyone who's giving advice and suggestions. Rsync shouldn't mess up the folder structure, I use it to do backups of my photos, and there are 1,000's of them in hundreds of folders. I'd guess that you've got a dodgy option in there somewhere. If the permissions are getting lost, why not just reset them when you've rsync'ed the files back to the local drive. Lee -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
LeeGroups wrote: Rsync shouldn't mess up the folder structure, I use it to do backups of my photos, and there are 1,000's of them in hundreds of folders. I'd guess that you've got a dodgy option in there somewhere. If the permissions are getting lost, why not just reset them when you've rsync'ed the files back to the local drive. Lee You're right - rsync didn't mess up the directory structure on the drive; but the 'folders' within Liferea were missing. (Liferea allows you to 'group' feeds under headings of your choice; and it was this that didn't get preserved - something going wrong with the Liferea cache and database files?) I may have been misleading by mentioning permissions; I suspect it's the owner/group information that matters, and that's what's getting lost (though I'd be the first to admit I don't really understand Unix ownerships/permissions). But frankly reading some news feeds is not a serious enough matter to spend time reconstructing the data in order to use get a synced view of Liferea. ;-) Mac -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
Mac wrote: SNIP But frankly reading some news feeds is not a serious enough matter to spend time reconstructing the data in order to use get a synced view of Liferea. ;-) You could create a tarball, then put that on your NAS? Another option is rss2email[0] - imap mail server. That way you won't miss posts, and are easily viewed from anywhere you can access your email. Syncing between machines will happen automagically. [0] http://rss2email.infogami.com/ Kind Regards, Dave Waker -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
Rsync shouldn't mess up the folder structure, I use it to do backups of my photos, and there are 1,000's of them in hundreds of folders. I'd guess that you've got a dodgy option in there somewhere. If the permissions are getting lost, why not just reset them when you've rsync'ed the files back to the local drive. Lee You're right - rsync didn't mess up the directory structure on the drive; but the 'folders' within Liferea were missing. (Liferea allows you to 'group' feeds under headings of your choice; and it was this that didn't get preserved - something going wrong with the Liferea cache and database files?) I may have been misleading by mentioning permissions; I suspect it's the owner/group information that matters, and that's what's getting lost (though I'd be the first to admit I don't really understand Unix ownerships/permissions). But frankly reading some news feeds is not a serious enough matter to spend time reconstructing the data in order to use get a synced view of Liferea. ;-) Ah! All you've done is to miss off the 'r' option that recurses into sub folders. The permission one is easy to fix too. All the files/folders would have belonged to you! So a quick chown command (with the recursive option) will straighten it all out once the rsync has finished... Put them both in the same script file (with the bin/bash command on the first line) and set it executable with a chmod +x and you're done! -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
LeeGroups wrote: Ah! All you've done is to miss off the 'r' option that recurses into sub folders. I used 'rsync -avz', so shouldn't it have recursed, as the -a option includes -r? The permission one is easy to fix too... So a quick chown command (with the recursive option) will straighten it all out once the rsync has finished I'll test this out in a script as you suggest. The data that's not being read/handled properly appears to be in ~/.liferea_1.4/feedlist.opml and probably ~/.liferea_1.4/liferea.db (though that doesn't open with a text editor - any ideas how to read the contents?). I don't yet know what's causing the problem with the handling of these... Thanks for your help! Mac -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
Mac wrote: The data that's not being read/handled properly appears to be in ~/.liferea_1.4/feedlist.opml and probably ~/.liferea_1.4/liferea.db (though that doesn't open with a text editor - any ideas how to read the contents?). I don't yet know what's causing the problem with the handling of these... It seems I was nearly right about the critical files, as indicated in the script here (a script for a situation more complex than mine, involving backing up with ssh): http://www.rolfs.no/2008/03/26/sync-lifereash-syncing-script/#more-99 where the essential files are indicated in these lines # Using rsync to preserve when file was last changed.. rsync -vaz -e ssh $REMOTE:$REMOTEDIR/feedlist.opml $BACKUPDIR/remote/ rsync -vaz -e ssh $REMOTE:$REMOTEDIR/liferea.db-journal $BACKUPDIR/remote/ rsync -vaz -e ssh $REMOTE:$REMOTEDIR/liferea.db $BACKUPDIR/remote/ rsync -vaz -e ssh $REMOTE:$REMOTEDIR/feedlist.opml.backup $BACKUPDIR/remote/ and much of the rest of the script seems to be about ensuring that these are the finalised and only files transferred and used (by making sure no copies of Liferea are running). The time stamps matter (of course - these are 'live' feeds); and that may be the problems with transferring the files via FAT32 - does the time stamp info disappear altogether, and cause a problem for the 'receiving' copy of Liferea? Completely out of my depth, now! Mac -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
[ubuntu-uk] How to sync Liferea on two PCs
I have Liferea installed on a laptop and a desktop (both connected to my home LAN). Currently, I have the same feeds on both. When reading on one machine, I just click past material I think I've already read on the other. But this is getting tiresome now that I have a lot of feeds, and I'd like to be able to sync the two copies of Liferea, so that I see a single version whichever machine I happen to be using. Sadly, extensive searching on the internet suggests that setting this up is tricky and messy. Any of you clever folks found an idiot-proof way of doing this? Mac -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
Hi Mac, 2008/5/30 Mac [EMAIL PROTECTED]: I have Liferea installed on a laptop and a desktop (both connected to my home LAN). Currently, I have the same feeds on both. When reading on one machine, I just click past material I think I've already read on the other. ... Any of you clever folks found an idiot-proof way of doing this? Only one - switching to Google Reader. Not ideal, but it solved my synchronisation problems. Hwyl, Neil. -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
Mac, To sync my feeds up between my main laptop, Ubuntu-vmware image on my Windows work-supplied laptop and the desktop in my home office (aka back of garage! :)) I just rsync my liferea profile to my home/backup server. I have alias's set so I can 'put' and 'get' as required. Although a bit manual, it means I can both backup my feeds/articles and push/pull them to which ever machine I'm using at the time. Below is the alias's from my .bash_alias if it helps: alias lifeget='/usr/bin/rsync -avz --delete --force -e ssh [EMAIL PROTECTED]:/mnt/backup/stuart/LifereaProfile/ /home/stuart/.liferea_1.4' alias lifeput='/usr/bin/rsync -avz --delete --force -e ssh /home/stuart/.liferea_1.4/ [EMAIL PROTECTED]:/mnt/backup/stuart/LifereaProfile' I do basically the same for my thunderbird and firefox profiles also, but as well as having aliases for these, I have a bash file which has a minimal amount of checking in it, to try and avoid writing the wrong way! Hope that helps a little. Stuart Mac wrote: I have Liferea installed on a laptop and a desktop (both connected to my home LAN). Currently, I have the same feeds on both. When reading on one machine, I just click past material I think I've already read on the other. But this is getting tiresome now that I have a lot of feeds, and I'd like to be able to sync the two copies of Liferea, so that I see a single version whichever machine I happen to be using. Sadly, extensive searching on the internet suggests that setting this up is tricky and messy. Any of you clever folks found an idiot-proof way of doing this? Mac -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
Mac wrote: I have Liferea installed on a laptop and a desktop (both connected to my home LAN). Currently, I have the same feeds on both. When reading on one machine, I just click past material I think I've already read on the other. But this is getting tiresome now that I have a lot of feeds, and I'd like to be able to sync the two copies of Liferea, so that I see a single version whichever machine I happen to be using. Sadly, extensive searching on the internet suggests that setting this up is tricky and messy. Any of you clever folks found an idiot-proof way of doing this? Mac If they're both on the same lan, it should just be a matter of syncing the .liferea folder in your home directories. HTH John -- John Levin http://www.technolalia.org/blog/ -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
... apologies for top posting, brain not engaged! Stuart -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
Neil Greenwood wrote: Only one - switching to Google Reader. Not ideal, but it solved my synchronisation problems. Neil I thought about that; but I'm reluctant to entrust more to web services than I absolutely need to after listening to this tour-de-force about privacy from Eben Moglen: http://itc.conversationsnetwork.org/audio/download/ITC.mySQL-EbenMoglen-2007.04.25.mp3 John Levin wrote: If they're both on the same lan, it should just be a matter of syncing the .liferea folder in your home directories. Narrf wrote: To sync my feeds up between my main laptop, Ubuntu-vmware image on my Windows work-supplied laptop and the desktop in my home office (aka back of garage! :)) I just rsync my liferea profile to my home/backup server. John / Stuart I'd sort of hoped I could run Liferea directly with its profile on a network drive, as I do with Thunderbird - so there'd be no need to rsync. Looks like it's not possible to change the Liferea configuration to do that. But the solution you suggest is good: I just do a 'before and after' rsync between whichever machine I'm using and a network drive. And I liked your idea, Stuart, of using a bash alias to 'get' and 'put'. Neat. (Of course, all my stuff is on my LAN, so no need to use ssh.) Many thanks to all three of you for your time and trouble. Mac -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] How to sync Liferea on two PCs
On Fri, May 30, 2008 at 11:57:25PM +0100, Mac wrote: John / Stuart I'd sort of hoped I could run Liferea directly with its profile on a network drive, as I do with Thunderbird - so there'd be no need to rsync. Looks like it's not possible to change the Liferea configuration to do that. If you've got a network drive mounted you can put a link to somewhere on it in place of the ~/.liferea folder and then the different machines will share the same profile. It might do weird things if you try and have two instances of the program using the profile at the same time but it should work if you avoid that. Procedure to set this up: - Move ~/.liferea onto the network drive - Run ln -s /path/to/where/you/put/.liferea ~/.liferea I should point out that I haven't tried this so keep a copy of the directory safe to put it back if it doesn't work. Robert Robert McWilliam [EMAIL PROTECTED]www.ormiret.com The purpose of life is to fight maturity. -- Dick Wirthimer -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/