main

main@lists.alug.org.uk

10364 discussions

Naive spreadsheet question - how to produce a running total?
by Chris Green 16 Jan '12

16 Jan '12

I'm a total newcomer to spreadsheets but I think/hope a spreadsheet is what I need to fulfil a very simple requirement. I want to maintain a simple balance of income and outgoings, e.g.:- Date Description Credit Debit Balance 1/1/2012 Monthly charge £200.00 -£200.00 5/1/2012 Received cheque £200.00 £0.0 21/1/2010 Miscellanous expense £5.00 -£5.00 .... etc. I can manage the various data entry columns in Gnumeric but what formula do I need in the Balance column? Firstly I can't find the syntax for "all cells to the end", all the Help seems to tell me is how to enter a range, i.e. C2:C12 means the range from C2 to C12, but how do you say "to the end"? Secondly how do you get a running balance without having to re-enter the formula in the Balance column for every row you enter? -- Chris Green

4 7

cp -a puzzle
by Ted.Harding＠wlandres.net 15 Jan '12

15 Jan '12

Greetings All, I am currently engaged in copying files from a desktop machine to an external USB hard drive. The machine has both Windows 98 and Linux on it, and dual-boots. Because Win98 does not recognise the external drive, while the Linux installation does, I'm booting into Linux to do the copying. The objective is to transfer every file on the desktop onto the external drive. The external drive is mounted as /media/sda1 in Linux, and has a vfat filesystem. The Windows drives \C, \D, \E, \F are mounted, when the machine is booted into Linux, as: /windows/C /windows/D ... /windows/F With the Windows files, no problem: I make the directories /media/sda1/WinLinMachine/C (and similar for .../D, .../E, .../F, these being all the Windows drives). Then I do the likes of: cd /windows/C cp -a * /media/sda1/WinLinMachine/C (and similar for D, E and F). This has worked fine. However, I now want to copy over all the Linux files as well. I have made a directory /media/sda1/WinLinMachine/LinuxFiles but now, of course, cp -a /* /media/sda1/WinLinMachine/LinuxFiles will not work, because the external drive is mounted under / and so will be itself copied and recopied in an infinite recursion. There would be no problem if there was an "exclude" option for 'cp' (say "-X") so that cp -a -X /media /* /media/sda1/WinLinMachine/LinuxFiles would inhibit anything under /media from being copied. But I can find no such option for 'cp'. So how to proceed??? With thanks, Ted. ---------------------------------- E-Mail: (Ted Harding) <Ted.Harding(a)wlandres.net> Date: 14-Jan-2012 Time: 20:49:49 This message was sent by XFMail ----------------------------------

3 3

[ALUG Announce] 3rd Monday Monthly Ipswich Social Meeting : McGintys, Northgate Street
by samwise 13 Jan '12

13 Jan '12

ALUG Announce Please send announcements to Announce(a)lists.alug.org.uk Unsub, change settings via http://lists.alug.org.uk/mailman/listinfo/announce ----- The monthly "Third Monday" ALUG Ipswich Social Meeting is back this Monday, 16th January, at 20:00: P J McGinty & Sons 15 Northgate Street Ipswich Suffolk IP1 3BY Tel: 01473 251 515 Map/Directions URI: http://maps.google.co.uk/?q=IP1+3BY WWW: http://www.pjmcgintys.co.uk/ McGintys pub is in the centre of Ipswich. It's directly opposite the town's central library and has a reputation for good Irish beer. We're usually to be found in the lowest section of the bar, near the library entrance to the pub. All are welcome, novices and experienced users. Feel free to ask for further information on the Main ALUG mailing list. ** I should be there this month to welcome in a new Linux year, after last month's absence. Hope to catch some of you there! ** Peter. ----- 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

bandwidth throttle needed
by mick 11 Jan '12

11 Jan '12

Hi Guys I have recently devoted a VM to tails (tails.boum.org). That VM appears in a DNS round robin with five other servers. When I first offered the server, trials showed I could expect to see outbound around 20-30 GB per day. I can live with that. Unfortunately, the traffic has now jumped to 150-180 GB per day. I can't live with that. It will cost me too much. So I need some advice on bandwith shaping. Can anyone recommend any tools which will allow me to set limits so that I can throttle web traffic to around 30 Gb per day (or 250 GB per week or 1000 GB per month for example). Cheers Mick --------------------------------------------------------------------- The text file for RFC 854 contains exactly 854 lines. Do you think there is any cosmic significance in this? Douglas E Comer - Internetworking with TCP/IP Volume 1 http://www.ietf.org/rfc/rfc854.txt ---------------------------------------------------------------------

2 2

Web photo management - are there any simple systems?
by Chris Green 10 Jan '12

10 Jan '12

I have a couple of family members who have photo albums on the web which I host. For the past two or three years I have been using gallery2 to do this but I'm getting increasingly fed up with the hassle involved whenever anything changes. A recent OS upgrade has made the gallery2 installations fall in a heap yet again and I'm wondering if I might find something easier than gallery2. Apart from not being easy to upgrade it requires quite a few non-standard changes to php.ini which I'd prefer to avoid if I can, and it uses a mysql database which I'd also like to avoid if I can. My two users don't need most of gallery2's abilities, all they want to do is to be able to upload photographs and organise them into albums with (presumably) thumbnails to select them. There's no need for multiple users, no need for tags, no need for extra information, just the EXIF and IPTC from the image files. So is there anything out there that can do this with as little hassle as possible? -- Chris Green

8 13

This apache2 default (maybe ubuntu's doing) seems a bit unhelpful
by Chris Green 10 Jan '12

10 Jan '12

In the default apache2 installation on Ubuntu you get the following setting in the default virtual host:- ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/ This means that CGI scripts are in the /usr hierarchy which doesn't seem very helpful. Is the the norm for apache2 or is it just Ubuntu's doing? I'm thinking I either want to point it to some suitable /home/<user> directory or possibly somewhere below /var/www, is there anything wrong with doing either of these (assuming suitable security protection of course). -- Chris Green

2 2

Is there a known security weakness in gallery2?
by Chris Green 10 Jan '12

10 Jan '12

Well after having decided I don't want to run gallery2 any more I have another question related to it. I'm getting hundreds of hits (well, attempted hits, it's no longer there) on the old gallery2 site, logged by logwatch as follows:- /mandy/gallery2/main.php?g2_view=shutterfl ... en=26321822fb67: 1 Time(s) I seem to get thirty or forty every day and today's logwatch has logged well over a hundred. It's not a issue really as it's not eating much bandwidth or loading my web site significantly but I was just wondering if anyone knows whether it's a well know security weakness in gallery2 or what? Or is someone just very desperate to look at the pictures on Mandy's blog? :-) Maybe I should put a note at /mandy/gallery2 saying that the pictures have moved. Though come to think about it the link from the blog now points at where the pictures really are so whatever is hitting that gallery2 URL must be pretty mindless. -- Chris Green

3 5

Is there anything better than 'locate'?
by Chris Green 10 Jan '12

10 Jan '12

I find (pun not intended) the locate command very painful, it rarely produces anything useful when I use it and its command line options don't seem to help very much. First problem is that by default it returns every single file that has the search expression in its path, so if I search for 'home' for example I get thousands and thousands of lines returned because it lists every sub-directory and file under /home. Surely it would be more useful if it just returned /home plus any files (or other directories) actually called 'home'. As it is the default is nearly always not what one wants. Secondly I want a search for 'home' to return files and directories called 'home', not ones called 'homeAndAway' or anything else with 'home' in them. If I'm searching for something which has 'home' in it then I'll search for '*home*'. I know there are ways of getting over the above two problems but IMHO the syntax to do so is a bit clumsy and inconvenient. The man page gives the syntax (in the only example it gives, maybe suggesting others have the same complaints as I do) :- locate -b '\home' Finally I want some way to exclude large chunks of my system from the search (or to *include* specific areas), my short-term backups are on my desktop system under /bak. As a result locate finds dozens of hits for any file which happens to be in the incremental backups. If only locate worked the same way as find does, find does almost exactly what I want most of the time (but is very slow of course because it's not got a cron built database). I guess I'm going to write a custom script round locate that makes it produce results much like find, but quickly. I'm just wondering if someone happens to have done it for me already. -- Chris Green

3 3

[ALUG Announce] ALUG Norwich Pub Meet Thursday 12th January
by Viperfang 09 Jan '12

09 Jan '12

ALUG Announce Please send announcements to Announce(a)lists.alug.org.uk Unsub, change settings via http://lists.alug.org.uk/mailman/listinfo/announce ----- Hello Norwich Aluggers, Our monthly ALUG Norwich social meeting will be held this Thursday, 12th January at The Coach and Horses (82 Thorpe Road, Norwich, NR1 1BA). The meeting officially starts at 8pm, although some people may arrive earlier. More information on those people can be found on the list and the IRC channel. If you are unsure if you will recognise us then make yourself and your intent to attend known by either posting on list or visiting us on IRC so we can look out for you rather than hiding in the corner. Optionally you could ask at the bar if they know where the geeky computer weirdos are and they'll point you in the right direction (seriously!). Another possibility is look for heaps of electronics on a table that may possibly look like movie props that would used for detonating explosives. Feel free to bring electronics/laptops/gadgets to the meet, you will by no means be alone. Ben Bewick aka Viperfang NB: This mail is automated, please refer to the usual sources for more information. ALUG Contact Details: Website : http://www.alug.org.uk/ IRC : #alug on irc.alug.org.uk List : http://lists.alug.org.uk/mailman/listinfo Twitter : http://twitter.com/anglianlug Identica: TBA Facebook: http://www.facebook.com/group.php?gid=2381613902 ----- 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

Fwd: [Gllug] OSHUG #15 — Wireless (Hacking Commodity Wireless, Practical Wireless, Contiki OS, CWIG) — Thursday 26th January
by Richard Lewis 08 Jan '12

08 Jan '12

Hi ALUG, It's not local, but the next meeting of the Open Source Hardware User Group may be of interest to some here. It's near King's Cross Station, and a quick trip round the Circle Line from Liverpool Street. Best, Richard -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Richard Lewis ISMS, Computing Goldsmiths, University of London JID: ironchicken(a)jabber.earth.li http://www.richardlewis.me.uk/ -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > OSHUG #15 — Wireless (Hacking Commodity Wireless, Practical Wireless, > Contiki OS, CWIG) > > On the 26th January 2012, 18:00 - 20:00 at Centre for Creative > Collaboration, 16 Acton Street, London, WC1X 9NG, (51.529049, > -0.116436) > > ** Registration: http://oshug.org/event/15 ** > > At the fifteenth OSHUG meeting we'll be taking a look at wireless > technologies. We will hear how you can repurpose low cost commodity > equipment, we will be given an introduction to RF basics, we will > learn about the Contiki operating system, and we will be introduced to > Ciseco's new Wireless Internet Gateway. > > - Hacking Commodity Wireless > > Many people build their hacks from the ground up, but those short of > time sometimes prefer to repurpose cheap off-the-shelf components that > can be made to fit the bill. A good example being a wireless > thermometer for external use, where an off-the-shelf device provides > an inexpensive option complete with the requisite weatherproof > packaging. However, such devices typically use proprietary protocols > and good documentation is rarely available. This talk will look at how > to interface such devices where a degree of reverse-engineering is > frequently required. > > Paul Tanner is a consultant, developer and maker in wood, metal, > plastic, electronics and software. His day job is IT-based business > improvement for SMEs. By night he turns energy nut, creating tools to > optimise energy use. Paul graduated in electronics and was responsible > for hardware and software product development and customer services in > several product and service start-ups, switching to consulting in > 2000. > > - Practical Wireless > > Adding wireless connectivity to your latest open hardware project is > not difficult, provided that you take the time to understand some of > the principles of RF communication. In this talk we will learn about > the basics of wireless propagation, and take a look at some of the low > cost modules which now make adding wireless even easier. > > Ken Boak joined BBC Research Department after graduating and worked on > digital picture processing of HDTV images, and coding algorithms for > video distribution around studios. Since then, Ken has worked in > laboratory instrumentation, telecommunications, low power wireless and > consumer electronics produced in the Far East. With an interest in > renewables, Ken now develops laboratory instruments to teach > undergraduates the principles of photovoltaic and wind power. Outside > of work, Ken is interested in smart wireless sensors, open source > hardware and low cost solutions for the Internet of Things. > > - An Introduction to the Contiki O/S > > This talk is aimed to introduce the Contiki OS and some of the > development hardware. We will learn about the process of bootstrapping > the development environment and there will be a hands-on tutorial. > > Ilya Dmitrichenko was born in Soviet Latvia in 1985, grew up and > attended a secondary school there, and moved to UK as soon as Latvia > joined the EU. He attended the biggest university in London and was > rather disappointed with the education, but nevertheless carried on > and had fun working on a final year engineering project which served > as an introduction to the topic of this talk. Ilya is interested in > various aspects of hardware and software, spanning from WSN to DSP and > several other random fields. > > - CWIG — The Ciseco Wireless Internet Gateway > > The CWIG is a new open hardware device that is designed to be the "one > and only" platform you'd need for a wireless gateway. It employs the > same ATmega328 microcontroller that is familiar to Arduino users and > supports Ciseco's TI CC1110-based XRF module, XBee, Bluetooth, RFM12B, > X10/HomeEasy, FRAM, SD, Ethernet and over-the-air programming with > AVRDude. It's sized to be housed in a low cost, compact enclosure and > to be cheap to build using through-hole components. In this talk we > will be given an introduction to the CWIG and also to the XRF wireless > UART and programmable RF module. > > Miles Hodkinson's twenty-odd year relationship with IT ended around > six years ago when he decided that it was time to do something > completely different. He had looked around without success for > something to log and control his wind turbine, solar panels and Lister > single cylinder engine, and found that nothing was flexible enough for > the money he wanted to pay (tens of pounds per device), so he decided > he would try and build it himself. After a number of years working on > a human-focused method of networking originally built using XBee > modules and now termed LLAP, his company developed the TI CC1110-based > XRF module. > > Note: Please aim to arrive for 18:00 - 18:20 as the talks will start > at 18:30 prompt. > > ** Registration: http://oshug.org/event/15 **

1 0

Jump to page:

2025

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