December 2002 - openSUSE Edu - openSUSE Mailing Lists

ODBC - seemingly OT but not - honest :)
by Phil Driscoll 09 Dec '02

09 Dec '02

We are trying to connect our OpenOffice.org clients to our MySQL server, using any technology which works. Some of our clients are Windows (NT and 2K) boxes, the rest are LTSP terminals. First job is setting up the Windows clients. It is very easy to set up a single client using odbc. Once the myodbc driver is installed, it's simply a matter of twiddling the ODBC stuff in the control panel, and then configuring OOo with the new data source. However, this is of little use to us :( We want to implement a system that configures the ODBC connection when a student logs in, so that they are connected to their own database. Since we use Samba as our PDC we should be able to write a script to facilitate this, but... I've googled the web and searched the registry, and everything points to the fact that the details are stored at HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\. However, installing the myodbc driver on another machine and then copying in the ODBC.INI\myconnection registry settings from a machine set up using the control panel does not cause the connection to be available. I suspect there is something else I need to do but I can't find any useful information anywhere :( Does anyone have any ideas? Cheers -- Phil Driscoll

1 0

RE: [suse-linux-uk-schools] Using identd to log users (NT)
by Chris Puttick 09 Dec '02

09 Dec '02

Interested to note that I got Brett's message but not Dug's. Is this possibly related to the quietness of the list in recent months? Cheers Chris -----Original Message----- From: Brett Roberts To: 'Dug Stokes'; Brett Roberts Cc: 'suse-linux-uk-schools(a)suse.com' Sent: 12/9/02 1:40 PM Subject: RE: [suse-linux-uk-schools] Using identd to log users I have a list in /var/squidGuard/db called allow_local where I add url's and domains I want to allow. Can I use acl's to resrict some users to accessing only these? -----Original Message----- From: Dug Stokes [mailto:dst@gilberd.essex.sch.uk] Sent: 09 December 2002 13:09 To: 'Brett Roberts' Cc: 'suse-linux-uk-schools(a)suse.com' Subject: RE: [suse-linux-uk-schools] Using identd to log users Yep, just use an ACL - I used: acl banuser user1 user2 user3 http_access deny banuser With webmin (www.webmin.com) its really easy! Dug Stokes Webmaster Gilberd IS Department E: dug(a)gilberd.com W: www.gilberd.com -----Original Message----- From: Brett Roberts [mailto:brett@centralmanclc.com] Sent: 09 December 2002 12:52 To: 'squidguard(a)squidguard.org'; 'squid-users(a)squid-cache.org'; 'suse-linux-uk-schools(a)suse.com' Subject: [suse-linux-uk-schools] Using identd to log users I am running squid and squidguard on Suse Linux 8.1 and am using ident and identd to log the users on windows 98 and NT clients. Is there a way in which I can use ACL's to use the usernames to deny access to certain users? -- To unsubscribe, e-mail: suse-linux-uk-schools-unsubscribe(a)suse.com For additional commands, e-mail: suse-linux-uk-schools-help(a)suse.com -- To unsubscribe, e-mail: suse-linux-uk-schools-unsubscribe(a)suse.com For additional commands, e-mail: suse-linux-uk-schools-help(a)suse.com

1 0

RE: [suse-linux-uk-schools] Using identd to log users
by Brett Roberts 09 Dec '02

09 Dec '02

I have a list in /var/squidGuard/db called allow_local where I add url's and domains I want to allow. Can I use acl's to resrict some users to accessing only these? -----Original Message----- From: Dug Stokes [mailto:dst@gilberd.essex.sch.uk] Sent: 09 December 2002 13:09 To: 'Brett Roberts' Cc: 'suse-linux-uk-schools(a)suse.com' Subject: RE: [suse-linux-uk-schools] Using identd to log users Yep, just use an ACL - I used: acl banuser user1 user2 user3 http_access deny banuser With webmin (www.webmin.com) its really easy! Dug Stokes Webmaster Gilberd IS Department E: dug(a)gilberd.com W: www.gilberd.com -----Original Message----- From: Brett Roberts [mailto:brett@centralmanclc.com] Sent: 09 December 2002 12:52 To: 'squidguard(a)squidguard.org'; 'squid-users(a)squid-cache.org'; 'suse-linux-uk-schools(a)suse.com' Subject: [suse-linux-uk-schools] Using identd to log users I am running squid and squidguard on Suse Linux 8.1 and am using ident and identd to log the users on windows 98 and NT clients. Is there a way in which I can use ACL's to use the usernames to deny access to certain users? -- To unsubscribe, e-mail: suse-linux-uk-schools-unsubscribe(a)suse.com For additional commands, e-mail: suse-linux-uk-schools-help(a)suse.com

1 0

Using identd to log users
by Brett Roberts 09 Dec '02

09 Dec '02

I am running squid and squidguard on Suse Linux 8.1 and am using ident and identd to log the users on windows 98 and NT clients. Is there a way in which I can use ACL's to use the usernames to deny access to certain users?

1 0

Mail scanning
by JOHN LOW 06 Dec '02

06 Dec '02

I entirely agree with Christopher's comments. However, you do need to be able to access archives of mails I think. Until recently qwe allowed Hotmail etc, on the grounds that if it wasn't on our server, we didn't need to get involved. Ha ha! One set of threatening emails sent by a student soon undid that idea. Don't scan or read but have them if the pastoral people feel something serious has happened. Of course you need an openly published policy for this. Same goes for staff...! John Low >> I want to scan the pupils incoming and outgoing e-mails for offensive words >> so that I can enforce our acceptable use policy. > >Don't. >Please don't. >It's not polite. >It means you don't trust them. >It has the makings of a police state. > >But worse, once they cotton on to what you are doing, they'll thoroughly >enjoy the game of emailing each other with offensive things that bypass >your checks, looking for words you don't know and ways of disguising them >that you won't spot. > >Many years ago a boy here got published in the school magazine one of >those non-rhyming non-scanning poems so beloved of trendy young English >teachers. It consisted of a four-line verse followed by a three-line one. >The first verse was something like > > From the Elysian fields ... > Under the something tree ... > Cooing away like doves ... > Killing the ..... > >and this was obviously a triumph of creative writing. It's a battle you >can't win. Instead, just come down heavily on occasional things for which >there has been a good reason for you to see. > >-- >Christopher Dawkins, Felsted School, Dunmow, Essex CM6 3JG >01371-822698, mobile 07816 821659 cchd(a)felsted.essex.sch.uk > > > This e-mail is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not represent those of St Mary's Hall.

1 0

Mail scanning
by s-clarob＠st-aidans.cumbria.sch.uk 06 Dec '02

06 Dec '02

I want to scan the pupils incoming and outgoing e-mails for offensive words so that I can enforce our acceptable use policy. Any one got any ideas that are preferably free? Thanks Robin.

7 6

RE: [suse-linux-uk-schools] Mail scanning
by Chris Puttick 06 Dec '02

06 Dec '02

Spam Assassin http://spamassassin.org . But be warned most of the problems will come from internal mails which will never reach the gateway,so ideally this needs to be run on the actual mail delivery system. Cheers Chris -----Original Message----- From: s-clarob(a)st-aidans.cumbria.sch.uk To: suse-linux-uk-schools(a)suse.com Sent: 12/6/02 11:54 AM Subject: [suse-linux-uk-schools] Mail scanning I want to scan the pupils incoming and outgoing e-mails for offensive words so that I can enforce our acceptable use policy. Any one got any ideas that are preferably free? Thanks Robin. -- To unsubscribe, e-mail: suse-linux-uk-schools-unsubscribe(a)suse.com For additional commands, e-mail: suse-linux-uk-schools-help(a)suse.com

1 0

Installing Suse 7.3 on an NT domain
by Rob Keeling 06 Dec '02

06 Dec '02

I am trying to install a Suse machine onto our school network At the moment we have. Samba 2.2.6 installed, with winbind support. All NT users and groups are visable to the suse box. However I am now trying to mount our nt home directory (with pam_mount) and get things running. There seem to be two problems. If an NT account has expired Suse doen`t offer the chance to change the password via pam_winbind. I can`t work out how to map the home directories with out them existing on the Suse box first (we have 1200 accounts). Can anyone point me in the right direction? (An idiots guide would be good) Rob Keeling Network Manager Queen Elizbeth`s Grammar School Ashbourne

1 0

CMIS (for those interested)
by Chris Puttick 06 Dec '02

06 Dec '02

Just thought you'd like to know: http://www.serco.com/newsStory.asp?sCode=810 Cheers ChriS

1 0

RE: [suse-linux-uk-schools] SIMS. SCOMIS AND ALICE
by ian 05 Dec '02

05 Dec '02

On Thu, 2002-12-05 at 22:36, Grainge, Derek wrote: > > I was at Capita a while back and I was told the reason they are in bed > > with MS is that the turn over in programmers means they have to go for > > the lowest common denominator in terms of expertise. I > > pointed out that > > if they used open source they could use the money saved in software > > licenses to pay better programmers to stay! When it comes > > down to it the > > decision makers just don't understand the options. > > > > Regards, > > > > -- > > Ian > > > > ... and the story I heard was that M$ own something like 20% of the company. WHich might also explain Capita's adoption of .NET But to be fair - if C# ( ~ Java) and C++ are typical development tools, then I don't see the 'lowest common denominator' argument. Lowest common denominator as in the technologies the people they are targeting for employment know about. (Probably the technologies some of th decision makers know about might be more significant). Unless you mean Borland = good or GCC = good and M$ = bad. Not about good bad or indifferent but about what the decisionmakers perceive to be easiest to support. > > Why do they have large turnover of programmers? Surely connected with staff satisfaction? Maybe they don't pay them enough? Who knows - what is the general turnover in programmers outside? Have you any evidence that M$ have a 20% stake in Capita? That would be interesting if it is true. Regards, -- IanL

1 0