March 2003 - openSUSE Edu - openSUSE Mailing Lists

RE: [suse-linux-uk-schools] Re: Test for prospective employees? O T
by Chris Puttick 12 Mar '03

12 Mar '03

As a matter of interest, we and many schools in Manchester are now looking at 16-19k for IT support engineers and £20+ for more senior people. I won't even mention what they now have to pay me ;-). Schools and education generally are learning the difference between quality IT and mediocre IT is not the supplier or the manufacturer, but the people who make it all work. -----Original Message----- From: Paul Munro To: suse-linux-uk-schools(a)suse.com Sent: 3/11/03 2:57 PM Subject: [suse-linux-uk-schools] Re: Test for prospective employees? OT Hi. Thanks to those who have answered so far. I think I will go with the idea that perhaps a practical exercise of some kind combined with the school's own "tests" (apparently psychometric?) will go a long way. I agree with the sentiments about pay; it's unfortunate that pay levels aren't high enough to sustain a good sert of technicians (especially the ones with family- I found it particularly hard on this wage level). You tend to get the "less experienced/skilled" ICT Technician this way, but we'll give it a shot! Thanks again- any other comments are most welcome! Paul

2 1

RE: [suse-linux-uk-schools] Tricky DNS Problems
by Chris Puttick 12 Mar '03

12 Mar '03

You lie to it... If you put an entry in your DNS for smtp.freeserve.net CNAME mail.ourschool.sch.uk, then your DNS server will return that information. However, if your specific example is indicative of the others, then use the hosts file on the local computer to get a similar result. The webpages are best dealt with by Squid/Squidguard or similar. What does your primary proxy do now? Chris -----Original Message----- From: Rob Keeling To: suse-linux-uk-schools(a)suse.com Sent: 3/11/03 6:44 PM Subject: [suse-linux-uk-schools] Tricky DNS Problems I have currently got Bind 8 and dhcpd working on a suse 8.1 server. All of our clients now use this machine as primary DNS. The bind config is set to be authoritive for our own domain, and forward all other requests up stream to EMBC`s name servers. What I now want to do is "poison" the DNS cache with various entries for other (random) domain names. eg My laptop wants to send email to smtp.freeserve.net, which is right for home at school I need it to connect via our school email server. If DNS returned our internal IP for smtp.freeserve.net ..... problem solved! I also want to divert various web pages so that I can add additional web filtering to our system with out having to secondary proxy things. How do I do this? Rob Keeling Network Manager Queen Elizabeth`s Grammar School

1 0

Tricky DNS Problems
by Rob Keeling 11 Mar '03

11 Mar '03

I have currently got Bind 8 and dhcpd working on a suse 8.1 server. All of our clients now use this machine as primary DNS. The bind config is set to be authoritive for our own domain, and forward all other requests up stream to EMBC`s name servers. What I now want to do is "poison" the DNS cache with various entries for other (random) domain names. eg My laptop wants to send email to smtp.freeserve.net, which is right for home at school I need it to connect via our school email server. If DNS returned our internal IP for smtp.freeserve.net ..... problem solved! I also want to divert various web pages so that I can add additional web filtering to our system with out having to secondary proxy things. How do I do this? Rob Keeling Network Manager Queen Elizabeth`s Grammar School

1 0

selective archiving
by Mike Rees 11 Mar '03

11 Mar '03

Hi Any idea how I can selectively backup certain type of files using tar (or otherwise) For example, (don't shoot me for this) *.doc, *.xls, *.pub files. I'm trying to backup users home directories which inevitably contain loads of cr4p making the size of the archive balloon. This is the kind of thing I'm using currently. Obviously, repeated for each directory and filetype I want to backup. tar -cvf backup /etc /usr/bin/find /export/home/ -name *.doc -newer /etc/last.backup -exec tar -rvf backup {} \; The script is getting longer and longer as I add new filetypes. Am I missing something obvious? Can I feed find or tar multiple arguments ie the file types? All help much appreciated....it's doing my head in!! -- Mike Rees Ysgol Glanymor School Heol Elfed Burry Port Llanelli Carms SA16 0AL

3 2

Re: Test for prospective employees? OT
by Paul Munro 11 Mar '03

11 Mar '03

Hi. Thanks to those who have answered so far. I think I will go with the idea that perhaps a practical exercise of some kind combined with the school's own "tests" (apparently psychometric?) will go a long way. I agree with the sentiments about pay; it's unfortunate that pay levels aren't high enough to sustain a good sert of technicians (especially the ones with family- I found it particularly hard on this wage level). You tend to get the "less experienced/skilled" ICT Technician this way, but we'll give it a shot! Thanks again- any other comments are most welcome! Paul

1 0

Test for prospective employees? OT
by Paul Munro 11 Mar '03

11 Mar '03

Hi there. I'm wondering if any of you can help me? I have been delegated with the task of formulating a test of sorts for prospective ICT technicians (2), and though the school now runs some sort of testing itself (though I don't know what they do yet) are there any suggestions as to what I can do? Have any of you been to an interview in a school for an ICT position, and if so, what did you get "tested" on? Are there any web sites that give templates for tests etc? Just wondering. Thanks, Paul

3 2

iptables question
by Matt Williams 10 Mar '03

10 Mar '03

Morning We currently have 2 linux gateways within our school, one is for the broadband by provided by our council, the other our old isdn line. In true council fashion the gateway they provided us with will not do anything other than browse the web. We have set all clients (windows 2000) gateway to point at the council ip address. Is there a way I forward all requests that aren't on port 80 (or 443) onto the other gateway? All example I see for iptables seem to be routing through different interfaces on one card. So for example if the bb gateway is 172.16.0.20 and it receives any requests that aren't on port 80 to forward these requests onto 172.16.0.5 (isdn) to use that gateway for these services. Can this be done? Cheers Matt

2 2

MySQL
by Matt Johnson 08 Mar '03

08 Mar '03

Folks, I've searched for help in seemingly more relevant places, but I have a suspicion someone here will at least point me. I've googled, search the manual, read heaps of tutorials (devshed etc) but I don't know what to *call* what I'm after, so it's very tricky. Could someone direct me to a tutorial or example that deals with rearranging shown below MySQL... Or at least give me the *jargon* for what I'm trying to do. I don't think it's a cross tab or pivot table, as they seem to sum data. I have this table: name week score joe 1 30 fred 1 23 rita 1 33 joe 2 31 fred 2 24 rita 2 31 And I just want to display it like this... name week1 week2 week3 joe 30 31 fred 23 24 rita 33 31 What do I call that please? Ta in advance -- Matt Johnson __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

2 2

Oops!
by Brett Roberts 07 Mar '03

07 Mar '03

just sent an internal message to this list please delete it when you recieve it.

1 0

RE: From Maresa Andrews
by Brett Roberts 07 Mar '03

07 Mar '03

Any problems involving children accessing inappropriate websites should be directed to Mike Chapman. -----Original Message----- From: Neil Joyce Sent: 06 March 2003 10:32 To: Susan Andrews Cc: IT Help Subject: RE: From Maresa Andrews Susan I am sorry - but I don't have a clue about what you are reffering to. I have forwarded this on to IT Help. This is the address you should use for support issues. Neil -----Original Message----- From: Susan Andrews To: Neil Joyce Sent: 06/03/2003 08:00 Subject: From Maresa Andrews I told you yesterday about a boy accessing a horrid website, but I got his surname wrong - it was Chris Welburn , but I said Welbeck. Sorry. Maresa

1 0