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
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
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 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. > >> 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
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. > 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 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] bluetooth problem- pc to phone
im still stuck with this problem any suggestions? as an update i can tell you i got the previously unpairable moto z8 and hardy paired and exchanging files. but i dont know the next bit...what should ido when alloting ip's? and i am using a router in between On 27/05/2008, gav <[EMAIL PROTECTED]> wrote: > On Tue, May 27, 2008 at 02:00:58PM +0100, Javad Ayaz wrote: >> So would, for example using the gutsy varient of xubuntu maybe fix this? > > Sorry, I've no idea. I only recently picked up a Bluetooth dongle so never > tried it on the Gibbon. > > -- > Gav Ford > [EMAIL PROTECTED] > http://revford.pwp.blueyonder.co.uk > I think we need to: Realign the geo-thermal dish > -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
Re: [ubuntu-uk] Ubucon Status
On Fri, May 30, 2008 at 09:10:55PM +0100, Johnathon Tinsley wrote: > I remember there was talk of and a wiki page setup for, a Ubucon run by > us a while back. Is anyone in charge of that project and if so, whats > the status of it? > After the initial discussion I dont think anything happened. Cheers, Al. -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.org/UKTeam/
