- main - earth.li

RE: Routing puzzle [solved]
by Ted.Harding＠nessie.mcc.ac.uk 27 Oct '05

27 Oct '05

Thanks to a number of people -- Bob Franklin, Geoff ("IT"), Simon Hobson, John Logsdon (also several private talks), on linux-users; Adam Allen, Guy Eastwood, Jim Rippon, MJ Ray, Wayne Stallwood, "Ten", Maz Walker, Keith Watson, on ALUG; it is now done! As more than a few pointed out, the trick (and I hope this solution will be useful to others in the same situation) is that the ADSL router needs to know how to talk back to the originating internal network. So it needs to have a static route to this configured on the router itself. To make it explicit: A: 192.168.0.1 eth0 default gateway -> C = 192.168.0.6 B: 192.168.0.7 eth0 default gateway -> C = 192.168.0.6 C: 192.168.0.6 eth0 default gateway -> ADSL = 192.168.1.1 C: 192.168.1.3 eth1 ADSL: Own address = 192.168.1.1, expects to be talking to 192.168.1.3 Now the following is at least partially specific to the BT Voyager 205 ADSL Router, since it refers to details of its Web interface config pages accessed via http://192.168.1.1 1. Go into "Advanced" & login as administrator 2. Go to "IP Routing" -> "IP Route" and then you see an "IP Address Table" (slightly pruned). Destn Netmask NextHop IFName RtType RtOrigin 0.0.0.0 0.0.0.0 62.3.82.17 ppp-0 Indirect Dynamic 62.3.82.17 255.255.255.255 xx.yy.zz.pqr ppp-0 Direct Dynamic xx.yy.zz.pqr 255.255.255.255 127.0.0.1 lo-0 Direct Dynamic 127.0.0.0 255.0.0.0 127.0.0.1 lo-0 Direct Dynamic 192.168.1.0 255.255.255.0 192.168.1.1 eth-0 Direct Dynamic 192.168.1.1 255.255.255.255 127.0.0.1 lo-0 Direct Dynamic 192.168.1.2 255.255.255.255 127.0.0.1 lo-0 Direct Dynamic 212.23.3.11 255.255.255.255 62.3.82.17 ppp-0 Indirect Dynamic 212.23.6.35 255.255.255.255 62.3.82.17 ppp-0 Indirect Dynamic (where "xx.yy.zz.pqr" is my "public" Zen IP addressi, and 62.3.82.17 is Zen's gateway for this connection. The "212..." addresses are Zen nameservers.) 192.168.1.1 is the router's internal ethernet interface, and 192.168.1.2 is its USB interface. It looks to 192.168.1.{3,4,5,...} for outside connections via ETH/USB and in fact I set up C's eth1 to be 192.168.1.3 which works fine. So as we can see there is of course nothing to with with 192.168.0.0 in there. At this stage there is an "Add" button at the bottom which brings up a form for entering the details of a new route. So I entered "192.168.0.0" for Destinatiom, left "255.255.255.0" as it was for the Netmask, and entered "192.158.1.3" (the address of eth1 as seen from machine C) as the "Gateway/NextHop". This resulted in the following line: 192.168.0.0 255.255.255.0 192.168.1.3 eth-0 Indirect Local appearing in the abpve table, just above the "192.168.1.0" line. Click "Apply" and then "Close" on the subsequent window, and it's done! Thanks to all who joined in, and get me pointingin the right direction. Ted. -------------------------------------------------------------------- E-Mail: (Ted Harding) <Ted.Harding(a)nessie.mcc.ac.uk> Fax-to-email: +44 (0)870 094 0861 Date: 27-Oct-05 Time: 11:50:41 ------------------------------ XFMail ------------------------------

1 0

RE: [ALUG] Routing puzzle
by Keith Watson 27 Oct '05

27 Oct '05

Hi Ted, seems to me that you need to end up with a routing table on A or C that looks like this; Routing table for C = 192.168.0.7 (similar for A = 192.168.0.1): ---------------------------------------------------------------- Destination Gateway Genmask Flags (blah) Iface 127.0.0.0 * 255.0.0.0 U (blah) lo 192.168.0.0 * 255.255.255.0 U (blah) eth0 192.168.1.1 192.168.0.6 255.255.255.0 UG (blah) eth0 <====== new entry default 192.168.0.6 0.0.0.0 UG (blah) eth0 so that A & C know to route everything for 192.168.1.1 via B (192.168.0.6) (though I would have thought that the default entry would pick this up!!) so try something like route add 192.168.1.1 gw 192.168.0.6 i.e. explicitly tell the box that traffic for 192.168.1.1 is to be routed via B. Regards, Keith ____________ Old CM people never die, they just get archived and can be reproduced at any time.

1 0

Routing puzzle
by Ted.Harding＠nessie.mcc.ac.uk 27 Oct '05

27 Oct '05

Hi Folks, I have a bit of a conundrum. Maybe there's just some simple trick I'm missing. Sorry for the lengthy background below! I've been happily running a dialup connection to the outside world on my 3-4 machine home LAN. In this, one machine has the modem and does the dialup, and the others have a default route which points to that machine. This has no default route in general, but when kppp completes the dialup connection it installs one via ppp0, and deletes it when kppp closes down. This works fine: all the other machines can find any address outside when this machine has its default ppp0 route up. Now I finally have ADSL broadband as well. This connects via a Voyager 205 ADSL modem. This has IP address 192.168.1.1. Here the situation is that, if I put a second NIC in any of the machines as eth1, give it IP address 192.168.1.3 (since this is the first in line of IP addresses which the modem gives out) and also manually install a default route to the net 192.168.1.0 via eth1, then from that machine I can also readily access the outside world. However, I have not managed to configure the machines so as to route through the ADSL machine via its eth1 in a similar way to ppp0. Say machine C has the ADSL modem on eth1, and machines A, B and C are linked over a network on eth0 for each. The C can see the Net, while A and B can not. Here is the outline of the configuration. A 192.168.0.1 eth0 B 192.168.0.7 eth0 C 192.168.0.6 eth0 192.168.2.0 vmnet1 [bridging network for VMWare] 192.168.1.3 eth1 --> 192.168.1.1 [ADSL modem/router] xxx.yyy.x.w ppp0 [when dialled up, ISP's dynamic IP] The other side of the ADSL router gets a fixed IP from the ISP, but I never need to see this. Now for what happens when not using ADSL, just dialup. [1] 'route' for A gives ----------------------- 192.168.0.0 * 255.255.255.0 U 0 0 555 eth0 loopback * 255.0.0.0 U 0 0 11 lo default C 0.0.0.0 UG 0 0 19 eth0 [2] 'route for B gives ---------------------- 192.168.0.0 * 255.255.255.0 U 0 0 0 eth0 127.0.0.0 * 255.0.0.0 U 0 0 0 lo default Co 0.0.0.0 UG 0 0 19 eth0 [3] 'route' for C, when not dialled up, gives --------------------------------------------- Destination Gateway Genmask Flags ... Iface 192.168.2.0 * 255.255.255.0 U ... vmnet1 192.168.1.0 * 255.255.255.0 U ... eth1 192.168.0.0 * 255.255.255.0 U ... eth0 [4] and, when C has dialled up ------------------------------ imsnet-cl10-hg1 * 255.255.255.255 UH ... ppp0 192.168.2.0 * 255.255.255.0 U ... vmnet1 192.168.1.0 * 255.255.255.0 U ... eth1 192.168.0.0 * 255.255.255.0 U ... eth0 default msnet-cl10-hg1 0. 0. 0.0 UG ... ppp0 In this configuration, as described above, all three machines can reach the Net without problems, routing through ppp0 on C. Now, with the ADSL router in place on C, I make the change analagous to [3]->[4] above, by adding the route to the ADSL 192.168.1.1 and the default route to the same on eth1. But this does not work. While C has no problems seeing the net, beither A nor B can. I feel stumped here, but -- as I say -- there's undoubtedly something simple I;ve overlooked. Comments and suggestions most welcom! Best wishes to all, Ted. -------------------------------------------------------------------- E-Mail: (Ted Harding) <Ted.Harding(a)nessie.mcc.ac.uk> Fax-to-email: +44 (0)870 094 0861 Date: 25-Oct-05 Time: 18:54:56 ------------------------------ XFMail ------------------------------

7 8

RE: [ALUG] Routing puzzle
by Keith Watson 26 Oct '05

26 Oct '05

> From: Ted.Harding(a)nessie.mcc.ac.uk Sent: 26 October 2005 13:11 > > 5. I now add a default gateway to B > > route add -net default gw 192.168.1.1 > > (this being the IP address of the router itself) and with this > setup I can access the web quite freely from machine B. > > 6. The other two machines (A and C) each have default gateway B. > > 7. However, from neither of the other machines can I access > the web at all. > > 8. This contrasts, however, with the behaviour when B is used > to dial-up using an ordinary phone modem. Kppp does the > business, and when it's done there's a default route on B > via PPP through interface ppp0 to the outside world. > > With this, and default routes on A and C as above, unchanged, > all 3 machines can access the web freely. > Hi Ted, I'm coming into this thread a bit late (and someone may have already suggested this) but have you tried route add -net default gw 192.168.1.1 on machines A & C? Regards, Keith ____________ BAROMETER, n. - An ingenious instrument which indicates what kind of weather we are having. - Ambrose Bierce - The Devil's Dictionary

2 1

OpenOffice and mdb files
by MJ Ray 26 Oct '05

26 Oct '05

A kind soul has posted me some mdb files to look at. I've had a look at the "Most FAQ" on www.openoffice.org and it seems to suggest that I can use them from OpenOffice by loading them into Microsoft Access. Obviously, that's slower and fiddlier for me. Do you know any other ways of getting useful information out of them? Thanks, -- MJ Ray - personal email, see http://mjr.towers.org.uk/email.html Work: http://www.ttllp.co.uk/ irc.oftc.net/slef Jabber/SIP ask

3 3

Web site designs
by MJ Ray 26 Oct '05

26 Oct '05

There's the designs on Brett's page at http://www.sommitrealweird.co.uk/alug/retheme-engine/ and a slightly updated one of mine at http://mjr.towers.org.uk/comp/alugtalk/ -- any others I've missed, or shall we move on? Thanks, -- MJ Ray - personal email, see http://mjr.towers.org.uk/email.html Work: http://www.ttllp.co.uk/ irc.oftc.net/slef Jabber/SIP ask

4 5

Re: Help! PostgreSQL corrupt system tables (Mark Rogers)
by Jenny Hopkins 25 Oct '05

25 Oct '05

Mark Rogers wrote: > One of my customers has a corrupt postgreSQL system database. The error > he's getting is: > > template1=# select * from pg_database; > ERROR: invalid page header in block 1 of relation "pg_database" > > This happens at any point where postgres is trying to access the > database catalog, not for invididual db access but (for example) > trying to create / drop any databases. > > I can't help him as I know nearly nothing about Postgres (although its > about time I learnt). > Hi Mark, I asked my brother for you and he says: pg_dumpall new database install restore all databases might do it HTH Jen

2 1

Martlesham Heath Robinson
by tom potts 25 Oct '05

25 Oct '05

Good Grief - is that place still going - I left it 15 years ago and all I've heard about it it some bloke who keeps recycling other peoples ideas - he was stealing them when I was there. <RANT>I designed a 2.4G bit fibre optic I/O and similar electrical I/O when I was there - BT said they wouldnt develop it as they didnt do research any more. Last place I worked spent £60K on a box to do the same. Mine would have cost $5! Been spitting feathers ever since.</RANT> ___________________________________________________________ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com

2 1

Unmounting of Root Filesystem
by Dan Hatton 24 Oct '05

24 Oct '05

Lately (last week or so,) when I boot my machine (Debian Testing,) after either a poweroff (via shutdown -h) or reboot (via shutdown -r,) it consistently complains that the root filesystem was not cleanly unmounted, and insists on fscking that filesystem. After the reboot forced by fsck, the machine starts up just fine. Browsing the init scripts in /etc/rc0.d/ and /etc/rc6.d/, I can't find any sign of anything attempting to unmount the root filesystem. Does anyone have any ideas where this should be happening, please? -- Thanks, Dan Hatton <http://www.bib.hatton.btinternet.co.uk/dan/>

3 4

Wiki Blocked
by Dave Briggs 24 Oct '05

24 Oct '05

Any reason why I am getting http://www.alug.org.uk/blocked.htm when I am looking at the wikified bits of the ALUG website? -- Dave Briggs linux(a)davebriggs.net | http://davebriggs.net | http://palimpsest.org.uk

2 1