- main - earth.li

AV manipulation
by Mark Rogers 09 Jun '09

09 Jun '09

I have two AV tasks I need to perform, which are otherwise unrelated... 1. I have some video for which the sound is out of sync. The video files use an XviD codec (not sure what sound codec). I'm looking for a tool to allow me to correct them. Ideally I want something I can just use left/right arrow keys to jog the sound a small amount ahead or behind the video until it's correct, then hit save to create a new file. It all ought to be pretty quick (no recompression needed, just re-synchronising). Any suggestions? 2. I want to take some audio files and slow them down (quite a lot) without changing their pitch. I'm trying to learn to play the guitar and I can't play fast enough to play alongside anything yet unless I can slow it right down! My desktop is Ubuntu 9.04 if that's relevant. -- Mark Rogers // More Solutions Ltd (Peterborough Office) // 0845 45 89 555 Registered in England (0456 0902) at 13 Clarke Rd, Milton Keynes, MK1 1LG

2 5

Printing suddenly changed to monochrome only
by Barry Samuels 07 Jun '09

07 Jun '09

I have recently changed over to CUPS in my Debian system although I don't think that caused the problem. I have an HP Colour LaserJet 4500 which will happily print a test page from the printer menu which includes colour so no problem there. However in the CUPS setup the only options I get are 'Grayscale' or 'Inverted Grayscale'. The driver selected is 'HP Color LaserJet 4500 - CUPS+Gutenprint v5.2.3 (en)' and the printer will print only in monochrome. Any ideas? -- Barry Samuels http://www.beenthere-donethat.org.uk The Unofficial Guide to Great Britain

2 5

Eee and root
by Anthony Anson 07 Jun '09

07 Jun '09

To install a program I presume I have to be root. I can't remember ever giving the Eee a root password, nor for that matter, ever being asked for one. I want to put a link to Thunderbird on the 'Internet' page, but I can't drag the icon (kicking and screaming, or not), nor can I copy and paste the icon. Unfortunately, I've filed the book of destructions 'somewhere safe'... HELLLLLP! -- Tony

4 9

Globbed search for filenames in website
by Ted.Harding＠manchester.ac.uk 07 Jun '09

07 Jun '09

Greetings! I'm looking for a way to find out what files for a particular wild-card form exist at a certain directory depth on a website. For example: www.some.web.page/*/*.png for all PNG files 1 below the top level. The results to be listed (stored in a file) along the lines of what you would get from ls */*.png if you were at the top level on the server. A browser won't do it (won't accept wild-cards). I've looked at wget, but this doesn't seem to have a simple listing option (except under ftp mode, which the remote site won't respond to). Any suggestions? With thanks, Ted. -------------------------------------------------------------------- E-Mail: (Ted Harding) <Ted.Harding(a)manchester.ac.uk> Fax-to-email: +44 (0)870 094 0861 Date: 07-Jun-09 Time: 08:41:32 ------------------------------ XFMail ------------------------------

4 5

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