- main - earth.li

Re: [ALUG] MySQL Joins
by Jim Rippon 03 Jun '09

03 Jun '09

Mark, >What I have so far is: >SELECT tbl1.email AS email1, tbl2.email AS email2 >SELECT IF(tbl1.email IS NOT NULL, tbl1.email, tbl2.email) as email >FROM tbl1 LEFT JOIN tbl2 USING (email) > >.. which will get me all the addresses from tbl1, with the matching >address from tbl2 in email2 or NULL if there is no match. > >What I want is to also get all the addresses in tbl2, with NULL against >email1 where there is no match. That is what I thought an OUTER join did >but it seems I'm wrong. An OUTER join can be a LEFT or RIGHT join like this: SELECT tbl1.email AS email1, tbl2.email AS email2 FROM tbl1 LEFT OUTER JOIN email2 USING (email); will show you all the records from the left table (in this case tbl1) and NULL for any records that didn't appear in the right table (tbl2). Perhaps what you want is a union query: SELECT DISTINCT email FROM tbl1 UNION SELECT DISTINCT email FROM tbl2 ORDER BY email; This should give you one result for each distinct entry between the two tables, if I understand it correctly. Worked for my (admittedly very small) test db. Hope this helps, Jim

2 1

MySQL Joins
by Mark Rogers 03 Jun '09

03 Jun '09

I'm not even sure if this is possible, but I have two tables containing email addresses, some of which are common to both tables. Is there a way I can extract a merged set of addresses from both tables in one go? What I have so far is: SELECT tbl1.email AS email1, tbl2.email AS email2 SELECT IF(tbl1.email IS NOT NULL, tbl1.email, tbl2.email) as email FROM tbl1 LEFT JOIN tbl2 USING (email) .. which will get me all the addresses from tbl1, with the matching address from tbl2 in email2 or NULL if there is no match. What I want is to also get all the addresses in tbl2, with NULL against email1 where there is no match. That is what I thought an OUTER join did but it seems I'm wrong. (Once I have a set of results containing 2 fields, where every address in each table appears, I can easily merge the two fields using an IF.) -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0845 45 89 555 Registered in England (0456 0902) at 13 Clarke Rd, Milton Keynes, MK1 1LG

1 0

Re: [ALUG] main Digest, Vol 48, Issue 2
by Ben Bewick 03 Jun '09

03 Jun '09

> Hi ALUG, > > I have in my possession a number of github.com stickers [0] featuring > the github mascot the octocat [0]. If anyone would like one, I'll > bring them along to the pub meet next week or I can possibly mail them > if people aren't coming to the meeting and *really* want one ;) > > Cheers, > > Dave Hi Dave, Yes please, I will be at the ALUG. Thanks! Ben / Viperfang

1 0

[ALUG Announce] 2nd Thurs Pub Meet 11th June 2009
by David Reynolds 02 Jun '09

02 Jun '09

ALUG Announce Please send announcements to Announce(a)lists.alug.org.uk Unsub, change settings via http://lists.alug.org.uk/mailman/listinfo/announce ----- Dear ALUG, The monthly second Thursday social meeting of ALUG will take place on 11th June 2009 at The Reindeer (10 Dereham Road, Norwich, NR2 4AY; tel. 01603 762223). It's very near the junction of Dereham Road and the Norwich inner ring road (Grapes Hill) and serves a selection of real ales, nice pub food (if you fancy going early to eat) and coffee. There are generally people there from 20:00 onwards and we tend to sit to the left of the main entrance. We look forward to seeing you there. Cheers, David -- David Reynolds david(a)reynoldsfamily.org.uk ----- Send discussion replies to main(a)lists.alug.org.uk (Reply-To set) Unsub, change settings via http://lists.alug.org.uk/mailman/listinfo/announce

1 0

Github stickers / Swag
by David Reynolds 02 Jun '09

02 Jun '09

Hi ALUG, I have in my possession a number of github.com stickers [0] featuring the github mascot the octocat [0]. If anyone would like one, I'll bring them along to the pub meet next week or I can possibly mail them if people aren't coming to the meeting and *really* want one ;) Cheers, Dave 0 - http://david.reynoldsfamily.org.uk/blog/octocat.jpg 1 - http://github.com/mojombo/github-media/blob/510a0a44cf602c62cd1657894bc69b9… -- David Reynolds david(a)reynoldsfamily.org.uk

1 0

Using curl (or similar) bypassing DNS
by Mark Rogers 01 Jun '09

01 Jun '09

Does anyone know how I can bypass DNS requests in a general way so that I can do, say: curl http://www.microsoft.com .. but bypassing the DNS lookup so that I can specify the IP I want the http request targetted at? In a simple case I can just add www.microsoft.com to my hosts file, but if I wanted to write (say) a bash or PHP script which did this then it would get messy using hosts that way. What I am looking to do is automate some checks which will run on an Apache server and ensure that all the virtual hosts on the server are working correctly. It is not possible to assume that all site shave the DNS pointed at the server (for example it may be a site which is being migrated to the server at some point in the near future). I may just write my own code to make http(s) requests directly using a socket library or something a bit higher level than that but below curl, but I'd prefer to use a standard tool if possible. -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0845 45 89 555 Registered in England (0456 0902) at 13 Clarke Rd, Milton Keynes, MK1 1LG

4 10

Reply-To header
by Richard Lewis 28 May '09

28 May '09

Hello ALUG, Usually when I'm sending messages to mailing lists, I set the Reply-To header to the mailing list address (as I've done with this message). How do people's mail clients respond to this? When you draft a reply, does it automatically make to To: main@lists...? Or does it make it CC? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Richard Lewis ISMS, Computing Goldsmiths, University of London Tel: +44 (0)20 7078 5134 Skype: richardjlewis JID: ironchicken(a)jabber.earth.li http://www.richard-lewis.me.uk/ -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- +-------------------------------------------------------+ |Please avoid sending me Word or PowerPoint attachments.| |http://www.gnu.org/philosophy/no-word-attachments.html | +-------------------------------------------------------+

7 8

The PCWorld Experience
by Ted.Harding＠manchester.ac.uk 28 May '09

28 May '09

Long story, so apologies -- but the details matter. A few days ago I was checking my bank account online. I noticed a Direct Debit for £7.99 made that day. Puzzled, I checked the full transaction details: it was to PC World. I checked back earlier -- another one, a month earlier. Well, I had been to PC World in Cambridge a couple of months earlier. Objective: pick up a cheapish laptop to play with some Linux distros, then do a proper installation. I noticed a quite nice Hewlett Packard T2390 on special offer at £329.97 (not too keen on the keyboard, but it's OK. The rest seems fine). While I was looking around, one of the shop-floor assistants latched on to me assiduously. I tried asking him something about printers, (built-in PostScript with auto-duplex capability) but he didn't know much. While I was at it I picked up an ethernet switch and a laptop carrier bag. Total bill £387.20 (added up in my head). He then offered to help me carry the stuff (cardboard box with the laptop in, switch box, bag) to the checkout, which I didn't really need but since he offered ... He then stood beside me at the checkout while I paid. Total payment £387.20 (as added up in my head). I got the receipt, along with what looked like some publicity leaflets, and went out to my car. I didn't get an offer of help for that bit. I didn't check the details on the receipt at the time -- I felt that things had basically taken their expected course. After checking my bank account, however, I did check the receipt in detail. At the top: HEWLETPACK A961EM T2390 £329.97 and beneath that, in very small print: Discount Manager Offer - Manager Discretion -£7.99 then: PC PERFORMANCE £7.99 followed by the items for the network switch and the bag. So I had been signed up for their "PC Performance" cover, including the first instalment of £7.99, without noticing (it had not changed the total price). And I have no recollection of being asked at any time if I wanted this. If I had been, I would have said no -- because the first thing I intended to do was to wipe off Windows and put on Linux, which would probably have voided any warranty. (In any case, I never take up these "product cover & support" things). I then phoned "PC Performance" (a PC World sideline), and was told that they would cancel the cover, and cease the D/D, but I could not get a refund because more than 2 weeks had passed. If I wanted to get the money back, I should contact my Bank to initiate an "Indemnity Claim". So I phoned my Bank, and described the situation. "Oh, it looks as though they've been a bit cheeky", she said. We discussed Indemnity Claim, and it seemd a long shot (there had been two of them at the till, one the cashier, the other the shop-floor assistant), so I dropped the idea. But she said she would immediately close the D/D. She rang back a few minutes later, to say that since the D/D had been cancelled on the same day a debit had been made, the debit of £7.99 for that day would be refunded. So that left me overall £7.99 out of pocket (break-even on the first one, due to "Manager's Discretion"). Not worth trying to take further, though I felt annoyed enough to want to! Well, that's my PC World experience! Moral: look closely at the receipt! (Though by the time I could have done that, it would all have been set up already -- but at least I would have been within the 2-week period for getting any money back). (And I didn't get the impression that it was the first time the Bank lady had heard such a story ... ). Best wishes to all, Ted. -------------------------------------------------------------------- E-Mail: (Ted Harding) <Ted.Harding(a)manchester.ac.uk> Fax-to-email: +44 (0)870 094 0861 Date: 27-May-09 Time: 17:43:46 ------------------------------ XFMail ------------------------------

9 12

webcam and firewall java applet problem
by Jenny Hopkins 24 May '09

24 May '09

Hi, I'm trying to enable access to an internal webcam externally, through a firewall. For complex reasons I won't go into unless necessary, the firewall forwards to a server running xinetd, which then port forwards to the camera. The firewall has ports 8090 and 40001 opened, the manual stating these are the two required. The xinetd conf forwards 8090 to the camera port 80, and 40001 to the camera port 40001, the former rule called 'camera' and the latter 'camera_image'. Now - using debian and firefox browser, i.e. the java applet option, I can see the webpage but the image is blank white. (The same setup could see the image fine on the internal network.) Error message on page: "Loading java applet failed". Only the 'camera' rule is invoked in the firewall log. Windows IE users select the ActiveX button and can see the image fine, and I note that now in the firewall log the 'camera_image' rule is now being invoked as well as 'camera'. The java applet does not try and use port 40001 for some reason, but I can't see any rejected requests for other ports. Can anyone shed any light on this? I hope I've explained it well enough. Thanks, Jenny

2 2

Re: [ALUG] Keyboard not working in KDE4
by barrie jones 20 May '09

20 May '09

On Tue May 19 23:26:48 BST 2009 Steve Fosdick wrote: > >On Tue, 2009-05-19 at 21:13 +0100, Srdjan Todorovic wrote: > > > >Seems a bit odd that your keyboard uses /dev/gpmdata if it does not exist. > >Almost sounds like a messed up X11 config... >Isn't /dev/gpmdata a _mouse_ repeater device. Why would this be in use for the keyboard whether or not it exists? Yes, gpmdata is a mouse device! I've been going round in circles on this problem and missed it. The SaX utility in openSUSE generated the xorg.conf and put in 2 device lines - /dev/gpmdata and /dev/input/mice and with my brain only half in gear I was looking at the first as keyboard since the second is mouse. I'm sure the keyboard isn't using it as there's no sign of it in /dev, and I've tried a very minimal xorg.conf with no specific devices or options so that the xserver configures on the fly, all with the same result. It just seems that whatever goes in xorg.conf makes no difference, which is why I wonder if it's a kde4 conflict. Barrie _________________________________________________________________ View your Twitter and Flickr updates from one place – Learn more! http://clk.atdmt.com/UKM/go/137984870/direct/01/

1 0