main June 2009

main@lists.alug.org.uk

29 participants
27 discussions

fcron or anacron
by Peter Alcibiades 04 Jun '09

04 Jun '09

Have you ever used either of these? I want to use fcron to run a command every 20 or 30 hours of machine uptime, but cannot figure out exactly where to put the command or how to get it there. Peter

2 1

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

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

1997

main June 2009