main

main@lists.alug.org.uk

10372 discussions

Backing up databases - how?
by Chris Green 04 Jan '12

04 Jan '12

I nearly had a problem just now, having done a clean install (rather than an upgrade) of xubuntu 11.10 I needed to restore sundry mysql databases. Since they're not in /home nor in /etc I thought for a nasty moment I hadn't got backups because /var/lib isn't in my automatic cron backups. However I had done a one-off copy of the whole of /var before cleaning out the old installation and installing xubuntu 11.10 - phew! :-) It does make me want to find a sensible way of backing up those mysql databases though. My automatic (cron) incremental backups save /home and /etc. I have made /var/www a symbolic link to a 'home' directory for www-data (the apache UID) at /home/www-data/www so all my web stuff gets backed up too. The databases are not heavily used so there's a pretty good chance that I can get away with making straight copies of all the files in /var/lib/mysql without causing any disasters but what's the best way to do that? I *could* make /var/lib/mysql a link to somewhere that gets backed up but that really feels like a bit of a bodge. I'd prefer not to add /var/lib/mysql to my backup list though I suppose that's really the sanest way to do it. I use sqlite for as many databases as possible so that this isn't an issue but some applications insist on mysql (or postgres) and, even though my use is very lightweight and doesn't need a proper *database* backup strategy I need to do something. Any comments/ideas anyone? -- Chris Green

5 5

Adding an exception to iptables on ssh authentication
by Alex Scotton 04 Jan '12

04 Jan '12

Hi All, I rarely post to this list; mainly due to a lack of knowledge... but find the email chains fascinating and very informative. I was hoping you could help me out with a few security adjustments on my home development server running Ubuntu 10.10; I would like to achieve the following setup with iptables and maybe a script in sshd_config? * Accept any connection from within the LAN (192.168.0.*) * Deny All from outside LAN (Except to ports 22, 80, 443, and the range 8000 to 8999) (the above is admittedly easily done with a google search) but my skills cant quite stretch to finding out how to add an exception to iptables for the IP of any authenticated ssh session and on timeout or disconnect remove that exception. I could then allow external developers to develop on a private port range (7000-7999 - as I do internally) by just connecting to ssh with their public key. Is this possible? Festive Tidings Alex

6 11

Best replacement o/s for a Linksys WRT54GL
by steve-ALUG＠hst.me.uk 04 Jan '12

04 Jan '12

Hi, I've just got a Linksys WRT54GL and want to try replacement o/s on it. I've had a bit of a google and the main ones seem to be DDWRT, OpenWRT and Tomato. Anyone care to express a preference or a reason why I ought to use one of these over another? TIA Steve

2 2

Spare hardware sought!
by Ted.Harding＠wlandres.net 03 Jan '12

03 Jan '12

Greetings Folks! Hoping you had a good Christmas, and wishing you a Happy New Year. I have an old desktop box whose PSU has blown. So I'm looking for a compatible box to which I can transfer the hard drives and PCI cards. Basic requirements: Working AT box with motherboard & CPU, 64MB RAM or more, space for 4 IDE hard drives, PCI slots (for monitor, parallel, ethernet, etc. cards), PS/2 mouse and KB ports. So if any of you shed-stackers has something suitable, I'd be very pleased to hear. Willing to pay a reasonable reward for a suitable box of tricks! Best wishes to all, Ted. ---------------------------------- E-Mail: (Ted Harding) <Ted.Harding(a)wlandres.net> Date: 29-Dec-2011 Time: 11:24:50 This message was sent by XFMail ----------------------------------

8 9

Re: [ALUG] 2600 meeting at 18:00 on Friday the 6th January.
by Ben Bewick 03 Jan '12

03 Jan '12

oops, sorry about the double posting! script ran twice, fixed now though :-) On 3 January 2012 00:49, Viperfang <viperfang(a)gmail.com> wrote: > Quick heads up about this months Norwich 2600 meeting, > more info at http://www.norwich2600.co.uk > > _______________________________________________ > main(a)lists.alug.org.uk > http://www.alug.org.uk/ > http://lists.alug.org.uk/mailman/listinfo/main > Unsubscribe? See message headers or the web site above! >

1 0

2600 meeting at 18:00 on Friday the 6th January.
by Viperfang 03 Jan '12

03 Jan '12

Quick heads up about this months Norwich 2600 meeting, more info at http://www.norwich2600.co.uk

1 0

2600 meeting at 18:00 on Friday the 6th January.
by Viperfang 03 Jan '12

03 Jan '12

Quick heads up about this months Norwich 2600 meeting, more info at http://www.norwich2600.co.uk

1 0

icalendar/vcalendar question - how to clear 'up to now' occurrences of a repeating event?
by Chris Green 02 Jan '12

02 Jan '12

I suspect that this can't be done within the iCalendar specification but maybe I'm not understanding all of it. I (and I'm sure *lots* of other people) need a way to remind myself about repeating events like having to do quarterly PAYE returns and quarterly VAT returns. I thus need a way to set up a repeating reminder of some sort, this is quite easy using an iCalender 'object', and then I need a way to say "I've done this month's one of these". As far as I can see there is no way in the iCalendar format to do this. The only reasonably practical approach I can see is to delete the EVENT completely and create a new one that starts at the next repeat date. Using a TODO instead doesn't seem to help much, you can sort of bodge together a way of doing it but it's so messy and liable to confusions with different length months and such that it doesn't really work. Am I right, is the best/only way to do it deletion and re-creation? -- Chris Green

1 0

Anyone want a router?
by David Reynolds 30 Dec '11

30 Dec '11

Hi guys, I have a couple of Linksys routers that I do not need anymore. I have: * Linksys WRT54GL v1.1 * Linksys WRT54GS v1.1 Both have stock linksys firmware but both could run openwrt if desired. I would like £10 (or nearest offer) for each. Anyone interested? (Please note: these are *not* ADSL routers) -- David Reynolds david(a)reynoldsfamily.org.uk

1 0

Synaptic with Debian
by Ted.Harding＠wlandres.net 26 Dec '11

26 Dec '11

Greetings All! Hoping you have been enjoying the long weekend, etc. (especially the "etc."). I have a problem starting synaptic on a Debian Lenny. When it starts up, no packages are reported, and then a window opens with the error message: An error occurred The following details are provided: E: Encountered a section with no Package: header E: Problem with MergeList /var/lib/apt/lists/ security.debian.org_dists_lenny_updates_main_binary-i386_Packages E: The package lists or status file could not be parsed or opened. E: _cache->open() failed, please report. When I click to close this window, synaptic then closes. I have had a look at the named file in /var/lib/apt/lists/ which is certainly there, and cannot work out how to fix it. Any suggestions? (And, in case I don't write again in time, Happy New Year). Ted. ---------------------------------- E-Mail: (Ted Harding) <Ted.Harding(a)wlandres.net> Date: 26-Dec-2011 Time: 18:41:15 This message was sent by XFMail ----------------------------------

2 2

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