- main - earth.li

sqlite printf not found
by mark fernandes 18 Apr '14

18 Apr '14

I found this forum post (appears to be a version thingie. http://www.mail-archive.com/sqlite-users@sqlite.org/msg83325.html Drat it - you've gotten me interested in using sqlite! Regards, Mark

2 1

Re: [ALUG] How to format numeric output from sqlite3?
by mark fernandes 18 Apr '14

18 Apr '14

YMMV with this as I'm not an sqlite guru... You may need to prefix the printf with a sqlite3_ . Elsewhere for mprintf example gives: char *zSQL = sqlite3_mprintf("INSERT INTO table VALUES('%q')", zText); sqlite3_exec(db, zSQL, 0, 0, 0); sqlite3_free(zSQL); HTH, Mark

1 0

SQL question for the SQL gurus out there
by Chris Green 17 Apr '14

17 Apr '14

I think there should be a way to do this but at the moment I can't see how, I always find SQL difficult to fathom though. I have a table with dates, times and temperatures in it. I want to select the maximum temperature for each year, how do I do that? The table has columns as follows:- ID Date Time Indoor Temperature Outdoor Temperature What I want to get out of it is something like:- 2014 21.23 2013 30.45 2012 25.31 It's a sqlite3 database so there's no procedural language easily available. I guess I could write a Python script to do what I want, that might be the easiest way. -- Chris Green

3 7

Fw: Invite: ORG Norwich Launch Event
by mick 17 Apr '14

17 Apr '14

oops - sorry, last one sent from wrong address. M anyone else planning on going to this? Mick Begin forwarded message: Date: Tue, 15 Apr 2014 05:32:05 -0400 (EDT) From: Olivia Jardine - ORG <campaigns(a)openrightsgroup.org> To: mick(a)rlogin.net Subject: Invite: ORG Norwich Launch Event Dear Mick Morgan, We’d like to invite you to ORG Norwich’s launch event - The Internet and You: The latest developments in digital rights. http://www.meetup.com/open-rights-group-norwich/events/171314372/ The event will provide an all encompassing series of talks on privacy, surveillance and your digital rights. These will include talks from Jim Killock, Director of Open Rights Group, Paul Bernal, a Lecturer in privacy rights from UEA and Wendy Grossman, author of net.wars. Everyone is welcome, but please reserve your place to avoid disappointment. http://www.meetup.com/open-rights-group-norwich/events/171314372/ When: 6pm, Friday 25th April Where: The Curve Auditorium, The Forum, Norwich How much: Free! The event will provide a fun and informal way to meet with other local ORG supporters, as well as an opportunity to learn about privacy, surveillance and digital rights, so we hope to see you all there. For further details and to let us know that you’re coming, visit our meetup page. http://www.meetup.com/open-rights-group-norwich/events/171314372/ Thanks and best wishes, Olivia --------------------------------------------------------------------- Mick Morgan gpg fingerprint: FC23 3338 F664 5E66 876B 72C0 0A1F E60B 5BAD D312 http://baldric.net ---------------------------------------------------------------------

2 2

How/what does the Heartbleed bug compromise?
by Chris Green 17 Apr '14

17 Apr '14

I've just been discussing with my son exactly what is (seriously) compromised by the Heartbleed bug. I can understand the basics, it means that something encrypted using SSL (i.e. HTTPS protocol connections) can be decrypted by someone who shouldn't be able to do so. Having said that what can a 'bad hacker' actually do? There's a sea of packets flowing around the internet, picking out a series of packets relating to one 'connection' (i.e. with related information in them) is non-trivial as far as I can see, unless the hacker is sitting looking at the data flowing through a switch feeding one particular site. So, it's possible to hack/decrypt a single packet which I suppose *might* contain someone's login details if the username and password was in a single packet. Is this the extent ot the problem? If there's more to it than this can someone explain. For example MumsNet says it's been hacked as a consequence of this bug, I don't quite understand how someone could get at *all* the login details on MumsNet unless they fortuitously got an administrator's login details and the system is stupid enough to allow an administrator to get at all usernames and unenecrypted passwords. Surely quite simple (and well known) security practices would make this sort of thing much more difficult:- Don't send complete Username/Password details in a single packet, easy enough to do by asking for them separately or even crude padding. Don't store user's details in single, big, unencrypted files. Don't store unencrypted passwords anywhere, use the Unix login style of things so that what's stored is the result of encrypting the password and is difficult (as in requires loads of processor ooomph) to decrypt by brute force methods. -- Chris Green

5 6

How to format numeric output from sqlite3?
by Chris Green 17 Apr '14

17 Apr '14

OK, so having worked out how to extract maximum and minimum values for each year from my database (thanks Mark), how do I format them? Here's what I get at the moment:- Year MaxTemp MinTemp MaxOutside MinOutside 2010 14.0625 -0.9375 7 -7.6875 2011 25 -2.1875 41.9375 -8.6875 2012 85 -6.25 37.8125 -14.0625 2014 22.125 5.875 32.875 0.5625 It's actually presented as a table in DokuWiki but that doesn't really affect the issue. How do I get the temperatures shown in sensible, consistent format like NNN.N? According to http://www.sqlite.org/lang_corefunc.html sqlite has a printf() function but when I tried it I got an error saying "No such function: printf" and I can't find anything useful about it by Googling for the error or anything related. So any ideas, apart from horrible substr() manipulations? I *could* go into the Dokuwiki plugin I'm using to get the output from the database into tabular format, I've modified it a lot already, but it would be rather messy to do. So I'd like something I can do outside if possible. -- Chris Green

1 0

DLNA server that transcodes - any recommendations?
by Chris Green 14 Apr '14

14 Apr '14

I'm currently running minidlna as a DLNA server and it's fine except that it doesn't offer transcoding. I now have a client that doesn't understand FLAC so I need on the fly conversion of FLAC to MP3. Can anyone suggest a DLNA server that can do this? -- Chris Green

4 4

Update on ATI Problems
by Chris Walker 11 Apr '14

11 Apr '14

Well, it's up and running with my preferred desktop background, most of the applications are back, such as this 'ere email client, without having to set up all the accounts etc, but I have a problem which appears to be intermittent. The icons at the top right of the windows, minimize, maximise and close, keep disappearing. I'm very reluctant to go mucking about trying various files, just in case, so does anybody have any definite ideas as to what might be wrong please? The desktop is KDE 4.11 as I guess that's important. I've looked at, but not touched the plasma files in ~/.kde4/share/config but they don't seem to hold details of icons and the like. As it's all now working and before it all goes nipple north again, I'm about to do another backup. That way, if it all should go wrong, I know I can get back to a working state without having to download tons of updates etc. -- __ __| |_ __ __ .----------------------------------------------. / _/ _` \ V V / | mailto:alug_cdw@the-walker-household.co.uk | \__\__,_|\_/\_/ |______________________________________________|

1 0

Old bag!
by Anthony Anson 11 Apr '14

11 Apr '14

Did anyone notice the white carrier bag (tied up at the top and containing a _BIG_ cup and saucer) which I left in the Coach and Horses last night? 'Taint there today. -- Tony http://www.girolle.co.uk/

1 0

ATI Graphics failure
by Chris Walker 10 Apr '14

10 Apr '14

Hi, In the past couple of weeks, the screen of my Mageia4 (64bit) machine has decided it doesn't want to display any of the normal desktop icons or display at the full size. Having googled it, I discovered that ATI have moved the driver for my HD4670 card to legacy. So I went to their site and downloaded what they tell me is the correct driver but when I compile it, it's failing. I think the error is because the code is looking for v2.X kernels and not the 3.12 that my machine is running. If I look in the make log, it says this (excuse line-wrapping):- /usr/src/fglrx-8.97.100.7/2.6.x/drm_proc.h:98:2: error: implicit declaration of function 'create_proc_entry' [-Werror=implicit-function-declaration] It's the 2.6 bit in there that makes me think is looking for the wrong version of the kernel. Am I correct in thinking that, and if I am, what can I do about it? I should say that this sort of stuff doesn't come naturally to me and that it's taken me 2 weeks to get to this point, so a little hand-holding will be required! -- __ __| |_ __ __ .----------------------------------------------. / _/ _` \ V V / | mailto:alug_cdw@the-walker-household.co.uk | \__\__,_|\_/\_/ |______________________________________________|

3 18