bodington-developers — Mailing list for Bodington developers

Re: [Bodington-developers] Deleting users

[Peter C. <Pet...@me...>]

> From: Adam Marshall
> I use MSSQLServer 8 and even though the constraints are=20
> accepted, I think
> I'm correct in saying you cant actually do a cascade delete!=20

create table pri(p int not null primary key)
create table furrin(f int not null references pri(p) on delete cascade)
insert into pri values(1)
insert into furrin values(1)
delete from pri where p=3D1
select * from furrin
drop table furrin
drop table pri

The select * returns 0 rows, as expected if this works.  Tested on SQL
Server 2000 SP4, SQL Server 2005 SP1.

		- Peter

Re: [Bodington-developers] Deleting users

[Antony C. <an...@sm...>]

On 23 Nov 2006, at 13:01, Adam Marshall wrote:

> I use MSSQLServer 8 and even though the constraints are accepted, I  
> think
> I'm correct in saying you cant actually do a cascade delete!

Well test it my friend then we can work with facts!

>
> MySQL has changed since last looked, which is great news.
>
> adam
>
>
> | -----Original Message-----
> | From: bod...@li...
> | [mailto:bod...@li...] On  
> Behalf Of
> | Peter Crowther
> | Sent: 23 November 2006 12:54
> | To: Bodington developers
> | Subject: Re: [Bodington-developers] Deleting users
> |
> | > From: Adam Marshall
> | > ON DELETE CASCADE doesn't work with MySQL and MS SQLServer,
> | > what would you do about those DB's?
> |
> | Get a supported MSSQL version - it's supported on SQL Server 2000 and
> | newer using the same syntax Antony describes.  SQL Server 7 is at the
> | end of its life, and sites running it should be thinking about
> | upgrading.
> |
> | 		- Peter
> |
> |  
> ----------------------------------------------------------------------- 
> --
> | Take Surveys. Earn Cash. Influence the Future of IT
> | Join SourceForge.net's Techsay panel and you'll get the chance to  
> share
> | your
> | opinions on IT & business topics through brief surveys - and earn  
> cash
> |  
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> | _______________________________________________
> | Bodington-developers mailing list
> | Bod...@li...
> | https://lists.sourceforge.net/lists/listinfo/bodington-developers
>
>
>
> ----------------------------------------------------------------------- 
> --
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers

Re: [Bodington-developers] Deleting users

[Adam M. <ada...@ou...>]

I use MSSQLServer 8 and even though the constraints are accepted, I think
I'm correct in saying you cant actually do a cascade delete! 

MySQL has changed since last looked, which is great news.

adam


| -----Original Message-----
| From: bod...@li...
| [mailto:bod...@li...] On Behalf Of
| Peter Crowther
| Sent: 23 November 2006 12:54
| To: Bodington developers
| Subject: Re: [Bodington-developers] Deleting users
| 
| > From: Adam Marshall
| > ON DELETE CASCADE doesn't work with MySQL and MS SQLServer,
| > what would you do about those DB's?
| 
| Get a supported MSSQL version - it's supported on SQL Server 2000 and
| newer using the same syntax Antony describes.  SQL Server 7 is at the
| end of its life, and sites running it should be thinking about
| upgrading.
| 
| 		- Peter
| 
| -------------------------------------------------------------------------
| Take Surveys. Earn Cash. Influence the Future of IT
| Join SourceForge.net's Techsay panel and you'll get the chance to share
| your
| opinions on IT & business topics through brief surveys - and earn cash
| http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
| _______________________________________________
| Bodington-developers mailing list
| Bod...@li...
| https://lists.sourceforge.net/lists/listinfo/bodington-developers

Re: [Bodington-developers] Deleting users

[Peter C. <Pet...@me...>]

> From: Adam Marshall
> ON DELETE CASCADE doesn't work with MySQL and MS SQLServer,=20
> what would you do about those DB's?

Get a supported MSSQL version - it's supported on SQL Server 2000 and
newer using the same syntax Antony describes.  SQL Server 7 is at the
end of its life, and sites running it should be thinking about
upgrading.

		- Peter

Re: [Bodington-developers] Deleting users

[Antony C. <an...@sm...>]

MySql does...and don't even mention M$!
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key- 
constraints.html

On 23 Nov 2006, at 12:48, Adam Marshall wrote:

> ON DELETE CASCADE doesn't work with MySQL and MS SQLServer, what would  
> you
> do about those DB's?
>
> adam
>
> | -----Original Message-----
> | From: bod...@li...
> | [mailto:bod...@li...] On  
> Behalf Of
> | Antony Corfield
> | Sent: 23 November 2006 12:39
> | To: bod...@li...
> | Subject: [Bodington-developers] Deleting users
> |
> | Hi All,
> |
> | We've had a few problems with unwanted users (users with wrong  
> username
> | or more than 1 username etc.) in the bodington DB but as you know
> | deleting users is a pain. This is because there are 18 tables that
> | reference the users table via foreign key constraint. So I've  
> attached
> | an sql script (bodington v 2.8) that will alter these constraints to
> | allow ON DELETE CASCADE, then all you need to remove a user, given
> | their username, is the following:
> |
> | delete from users where user_id in (select user_id from pass_phrases
> | where user_name='username');
> |
> | Some people might feel this is dangerous and object to living on the
> | edge but we on Skye encounter the severities of life on a daily  
> basis,
> | especially those with an office next to Alistair!
> |
> | Any comments?
> |
> | Antony
>
>
> ----------------------------------------------------------------------- 
> --
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers

Re: [Bodington-developers] Deleting users

[Alistair Y. <ali...@sm...>]

chuck 'em in the bin, where they belong

--------------
mov eax,1
mov ebx,0
int 80h




On 23 Nov 2006, at 12:48, Adam Marshall wrote:

> ON DELETE CASCADE doesn't work with MySQL and MS SQLServer, what  
> would you
> do about those DB's?
>
> adam
>
> | -----Original Message-----
> | From: bod...@li...
> | [mailto:bod...@li...] On  
> Behalf Of
> | Antony Corfield
> | Sent: 23 November 2006 12:39
> | To: bod...@li...
> | Subject: [Bodington-developers] Deleting users
> |
> | Hi All,
> |
> | We've had a few problems with unwanted users (users with wrong  
> username
> | or more than 1 username etc.) in the bodington DB but as you know
> | deleting users is a pain. This is because there are 18 tables that
> | reference the users table via foreign key constraint. So I've  
> attached
> | an sql script (bodington v 2.8) that will alter these constraints to
> | allow ON DELETE CASCADE, then all you need to remove a user, given
> | their username, is the following:
> |
> | delete from users where user_id in (select user_id from pass_phrases
> | where user_name='username');
> |
> | Some people might feel this is dangerous and object to living on the
> | edge but we on Skye encounter the severities of life on a daily  
> basis,
> | especially those with an office next to Alistair!
> |
> | Any comments?
> |
> | Antony
>
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers

Re: [Bodington-developers] Deleting users

[Adam M. <ada...@ou...>]

ON DELETE CASCADE doesn't work with MySQL and MS SQLServer, what would you
do about those DB's?

adam

| -----Original Message-----
| From: bod...@li...
| [mailto:bod...@li...] On Behalf Of
| Antony Corfield
| Sent: 23 November 2006 12:39
| To: bod...@li...
| Subject: [Bodington-developers] Deleting users
| 
| Hi All,
| 
| We've had a few problems with unwanted users (users with wrong username
| or more than 1 username etc.) in the bodington DB but as you know
| deleting users is a pain. This is because there are 18 tables that
| reference the users table via foreign key constraint. So I've attached
| an sql script (bodington v 2.8) that will alter these constraints to
| allow ON DELETE CASCADE, then all you need to remove a user, given
| their username, is the following:
| 
| delete from users where user_id in (select user_id from pass_phrases
| where user_name='username');
| 
| Some people might feel this is dangerous and object to living on the
| edge but we on Skye encounter the severities of life on a daily basis,
| especially those with an office next to Alistair!
| 
| Any comments?
| 
| Antony

[Bodington-developers] Deleting users

[Antony C. <an...@sm...>]

Hi All,

We've had a few problems with unwanted users (users with wrong username 
or more than 1 username etc.) in the bodington DB but as you know 
deleting users is a pain. This is because there are 18 tables that 
reference the users table via foreign key constraint. So I've attached 
an sql script (bodington v 2.8) that will alter these constraints to 
allow ON DELETE CASCADE, then all you need to remove a user, given 
their username, is the following:

delete from users where user_id in (select user_id from pass_phrases 
where user_name='username');

Some people might feel this is dangerous and object to living on the 
edge but we on Skye encounter the severities of life on a daily basis, 
especially those with an office next to Alistair!

Any comments?

Antony

[Bodington-developers] FW: Message From Bodington.org - Research

[Paul D. <pau...@ou...>]

Anyone with comments for her?  UHI??
Paul

-------------------------------------------------------------------------
Dr Paul V Davis
Acting Head, Learning Technologies Group
Marketing coordinator, Bodington.org
Oxford University Computing Services
13 Banbury Road, Oxford, OX2 6NN
Tel: 01865 283414





-----Original Message-----
From: nj...@br... via RT [mailto:web...@rt...] 
Sent: 20 November 2006 03:17
To: 'AdminCc of rt.oucs.ox.ac.uk Ticket #1024593':
Subject: [rt.oucs.ox.ac.uk #1024593] Message From Bodington.org - Research

<URL: https://rt.oucs.ox.ac.uk/Ticket/Display.html?id=1024593 >

Nicola Jackson (nj...@br...) from University of Bristol sent the
following message:

Hi, I am doing a small scale research project on students access to ICT, at
Bristol. I am interested in the use and development of Bodington. I was
wondering if you have done any student surveys into Bodington compared to
say previous VLE/ICT systems you may have used? Many thanks if you can help.

Re: [Bodington-developers] Windows 2003 CALs (was IE 7 issues)

[Sean M. <se...@sm...>]

I can confirm that, and they really are running with 120K users.  
phenomenal.


On 14 Nov 2006, at 18:02, John Norman wrote:

>
> On 14 Nov 2006, at 16:08, Peter Crowther wrote:
> ...
>
>>
>> Yep.  MS aren't contributing effort out of kindness.  However, the
>> large
>> Sakai deployments at least are *not* on MySQL; they're on Oracle.
>> Check
>> the price difference there...
> ...
>
> Just a point of information: I think UNISA in SA are using MySQL with
> 120,000 users.
>
> John
>
> ---------------------------------------------------------------------- 
> ---
> SF.net email is sponsored by: A Better Job is Waiting for You -  
> Find it Now.
> Check out Slashdot's new job board. Browse through tons of  
> technical jobs
> posted by companies looking to hire people just like you.
> http://jobs.slashdot.org/
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>

Re: [Bodington-developers] enum

[Alistair Y. <ali...@sm...>]

> (now for the purist, something relevant to the context would be
> better, e.g. records, nodes, etc - but that's a whole new kettle of  
> fish!!)
that would mean reading the code - got this far without doing that ;)

--------------
mov eax,1
mov ebx,0
int 80h




On 17 Nov 2006, at 14:13, Alexis O'Connor wrote:

> Indeed (as he gets out his dusty wind-up gramaphone, and puts on a
> broken old record).
>
> About a year ago I changed all the Enumeration instances called 'enum'
> to 'enumeration' (~800 occurances). Therefore if you were to do this
> yourself, few could realistically accuse you of breaking with existing
> convention.
>
> Alexis
>
> P.S. (now for the purist, something relevant to the context would be
> better, e.g. records, nodes, etc - but that's a whole new kettle of  
> fish!!).
>
> Naomi Miles wrote:
>> I think Alexis had proposed changing them to 'enumeration', or
>> something equally meaningful as you come across them.
>>
>> On 17 Nov 2006, at 13:53, Alistair Young wrote:
>>
>>> is there a policy for replacing variables called enum?
>>>
>>> org.bodington.logbook.server.LogBookSessionImpl has them. Just don't
>>> want to change them here and then have to do it again on merge to
>>> something else.
>>>
>>> Alistair
>>>
>>>
>>> --------------
>>> mov eax,1
>>> mov ebx,0
>>> int 80h
>>>
>>>
>>>
>>>
>>> -------------------------------------------------------------------- 
>>> -----
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to
>>> share your
>>> opinions on IT & business topics through brief surveys - and earn  
>>> cash
>>> http://www.techsay.com/default.php? 
>>> page=join.php&p=sourceforge&CID=DEVDEV______________________________ 
>>> _________________
>>> <http://www.techsay.com/default.php? 
>>> page=join.php&p=sourceforge&CID=DEVDEV______________________________ 
>>> _________________>
>>> Bodington-developers mailing list
>>> Bod...@li...
>>> <mailto:Bod...@li...>
>>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>>
>> --------------------------------------------------------------------- 
>> ---
>>
>> --------------------------------------------------------------------- 
>> ----
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to  
>> share your
>> opinions on IT & business topics through brief surveys - and earn  
>> cash
>> http://www.techsay.com/default.php? 
>> page=join.php&p=sourceforge&CID=DEVDEV
>> --------------------------------------------------------------------- 
>> ---
>>
>> _______________________________________________
>> Bodington-developers mailing list
>> Bod...@li...
>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>>
>
> -- 
> + - - - - - - - - - - - - - - - - - - - - - - - - - - - +
> | Alexis O'Connor, VLE Developer (http://bodington.org) |
> | OUCS, 13 Banbury Road, Oxford, OX2 6NN, UK.           |
> | Tel. +44 (0)1865 283661                               |
> + - - - - - - - - - - - - - - - - - - - - - - - - - - - +
>
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers

Re: [Bodington-developers] enum

[Alexis O'C. <ale...@ou...>]

Indeed (as he gets out his dusty wind-up gramaphone, and puts on a 
broken old record).

About a year ago I changed all the Enumeration instances called 'enum' 
to 'enumeration' (~800 occurances). Therefore if you were to do this 
yourself, few could realistically accuse you of breaking with existing 
convention.

Alexis

P.S. (now for the purist, something relevant to the context would be 
better, e.g. records, nodes, etc - but that's a whole new kettle of fish!!).

Naomi Miles wrote:
> I think Alexis had proposed changing them to 'enumeration', or 
> something equally meaningful as you come across them.
>
> On 17 Nov 2006, at 13:53, Alistair Young wrote:
>
>> is there a policy for replacing variables called enum?
>>
>> org.bodington.logbook.server.LogBookSessionImpl has them. Just don't 
>> want to change them here and then have to do it again on merge to 
>> something else.
>>
>> Alistair
>>
>>
>> --------------
>> mov eax,1
>> mov ebx,0
>> int 80h
>>
>>
>>
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to 
>> share your
>> opinions on IT & business topics through brief surveys - and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV_______________________________________________ 
>> <http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV_______________________________________________>
>> Bodington-developers mailing list
>> Bod...@li... 
>> <mailto:Bod...@li...>
>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> ------------------------------------------------------------------------
>
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>   

-- 
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - +
| Alexis O'Connor, VLE Developer (http://bodington.org) |
| OUCS, 13 Banbury Road, Oxford, OX2 6NN, UK.           |
| Tel. +44 (0)1865 283661                               |
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - + 

Re: [Bodington-developers] enum

[Alistair Y. <ali...@sm...>]

lucky I did that then! do we have virtual stocks we can put people in  
for using a keyword as a variable name?

--------------
mov eax,1
mov ebx,0
int 80h




On 17 Nov 2006, at 14:01, Naomi Miles wrote:

> I think Alexis had proposed changing them to 'enumeration', or  
> something equally meaningful as you come across them.
>
> On 17 Nov 2006, at 13:53, Alistair Young wrote:
>
>> is there a policy for replacing variables called enum?
>>
>> org.bodington.logbook.server.LogBookSessionImpl has them. Just  
>> don't want to change them here and then have to do it again on  
>> merge to something else.
>>
>> Alistair
>>
>>
>> --------------
>> mov eax,1
>> mov ebx,0
>> int 80h
>>
>>
>>
>>
>> --------------------------------------------------------------------- 
>> ----
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to  
>> share your
>> opinions on IT & business topics through brief surveys - and earn  
>> cash
>> http://www.techsay.com/default.php? 
>> page=join.php&p=sourceforge&CID=DEVDEV_______________________________ 
>> ________________
>> Bodington-developers mailing list
>> Bod...@li...
>> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV________________________________ 
> _______________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers

Re: [Bodington-developers] enum

[Naomi M. <na...@sm...>]

I think Alexis had proposed changing them to 'enumeration', or  
something equally meaningful as you come across them.

On 17 Nov 2006, at 13:53, Alistair Young wrote:

> is there a policy for replacing variables called enum?
>
> org.bodington.logbook.server.LogBookSessionImpl has them. Just  
> don't want to change them here and then have to do it again on  
> merge to something else.
>
> Alistair
>
>
> --------------
> mov eax,1
> mov ebx,0
> int 80h
>
>
>
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV________________________________ 
> _______________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers

[Bodington-developers] enum

[Alistair Y. <ali...@sm...>]

is there a policy for replacing variables called enum?

org.bodington.logbook.server.LogBookSessionImpl has them. Just don't  
want to change them here and then have to do it again on merge to  
something else.

Alistair


--------------
mov eax,1
mov ebx,0
int 80h

Re: [Bodington-developers] Windows 2003 CALs (was IE 7 issues)

[John N. <jo...@ca...>]

On 14 Nov 2006, at 16:08, Peter Crowther wrote:
...

>
> Yep.  MS aren't contributing effort out of kindness.  However, the  
> large
> Sakai deployments at least are *not* on MySQL; they're on Oracle.   
> Check
> the price difference there...
...

Just a point of information: I think UNISA in SA are using MySQL with  
120,000 users.

John

Re: [Bodington-developers] Windows 2003 CALs (was IE 7 issues)

[Peter C. <Pet...@me...>]

> From: Matthew Buckett
> When Microsoft are help open source apps (Moodle and Sakai) to run on
> SQL Server, even with 80% discount running them on SQL server looks
> rather expensive compared to just using MySQL on Windows.

Yep.  MS aren't contributing effort out of kindness.  However, the large
Sakai deployments at least are *not* on MySQL; they're on Oracle.  Check
the price difference there...

> Can you get around the license by installing SQL Server on another box
> and then have you Web Edition connect over the network to SQL Server?

'the license' as in Windows CALs?  Yes (I think), but you'd still need
the SQL Server and its CALs or processor licenses.

		- Peter

Re: [Bodington-developers] Windows 2003 CALs (was IE 7 issues)

[Peter C. <Pet...@me...>]

> From: Andrew Booth
> I think there is a difference between the Windows 2003 Server=20
> CALs and the SQL Server CALs.

There is.

> If you are running Bodington under IIS/SQL Server, then
> only those who log into the box need CALs.

True on Windows 2000, false on Windows 2003.  Microsoft have been
gradually tightening up the rules as their market share of Web servers
has increased.  *Any* use of authentication by an application running on
Windows 2003 Server requires CALs, whether or not the user logs onto the
box locally or has a representation in a Windows account database or
directory.

This has caught a lot of people out, and continues to catch people out.

> The SQL Server has a separate set of CALs.

Yes, and these rules must *also* be satisfied.  Processor licenses are
almost always cheaper than CALs here, and necessary in Internet
scenarios where users outside the organisation may need access.

		- Peter

Re: [Bodington-developers] Windows 2003 CALs (was IE 7 issues)

[Andrew B. <a.g...@le...>]

I think there is a difference between the Windows 2003 Server CALs and =
the
SQL Server CALs.  If you are running Bodington under IIS/SQL Server, =
then
only those who log into the box need CALs.  The SQL Server has a =
separate
set of CALs.

Aggie

-----Original Message-----
From: bod...@li...
[mailto:bod...@li...] On Behalf Of
Matthew Buckett
Sent: 14 November 2006 13:58
To: Bodington developers
Subject: Re: [Bodington-developers] Windows 2003 CALs (was IE 7 issues)

Peter Crowther wrote:

> * Bodington running on Windows 2000 Server *does not* require Windows
> CALs for every user; Bodington running on Windows 2003 Server *does*.  =
A
> subtle but expensive change for anyone running a non-Microsoft
> application that performs authentication.

More info about CALs for people who didn't know (like me).

http://www.microsoft.com/windowsserver2003/howtobuy/licensing/caloverview=
.ms
px

Aren't Mircosoft shooting themselves in the foot a little with this one
(assuming people abide by it)? As it seems that this will effect any
authenticated web application. Or are CALs acceptably cheap?

--=20
 -- Matthew Buckett, VLE Developer
 -- Learning Technologies Group, Oxford University Computing Services
 -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/


-------------------------------------------------------------------------=

Using Tomcat but need to do more? Need to support web services, =
security?
Get stuff done quickly with pre-integrated technology to make your job
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache =
Geronimo
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D=
121642
_______________________________________________
Bodington-developers mailing list
Bod...@li...
https://lists.sourceforge.net/lists/listinfo/bodington-developers

Re: [Bodington-developers] Windows 2003 CALs (was IE 7 issues)

[Matthew B. <mat...@ou...>]

Peter Crowther wrote:
>> From: Matthew Buckett More info about CALs for people who didn't
>> know (like me).
>> 
>> http://www.microsoft.com/windowsserver2003/howtobuy/licensing/ 
>> caloverview.mspx
>> 
>> Aren't Mircosoft shooting themselves in the foot a little with this
>> one (assuming people abide by it)? As it seems that this will
>> effect any authenticated web application. Or are CALs acceptably
>> cheap?
> 
> They're cheap for academia (80% discount) but a bit vicious for
> industry at c. £40 a pop.  Microsoft would argue that you could use
> Web Edition, which does not require CALs, for such non-Microsoft
> apps.  However, it won't allow useful things like SQL Server to
> install, which rather limits your options.  WIMP applications
> (Windows/IIS/MySQL/PHP) apps are possible on Web edition, but not
> WISP (Windows/IIS/SQL Server/PHP or whatever).

When Microsoft are help open source apps (Moodle and Sakai) to run on
SQL Server, even with 80% discount running them on SQL server looks
rather expensive compared to just using MySQL on Windows.

Can you get around the license by installing SQL Server on another box
and then have you Web Edition connect over the network to SQL Server?

-- 
 -- Matthew Buckett, VLE Developer
 -- Learning Technologies Group, Oxford University Computing Services
 -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/

Re: [Bodington-developers] Windows 2003 CALs (was IE 7 issues)

[Peter C. <Pet...@me...>]

> From: Matthew Buckett
> More info about CALs for people who didn't know (like me).
>=20
> http://www.microsoft.com/windowsserver2003/howtobuy/licensing/
> caloverview.mspx
>=20
> Aren't Mircosoft shooting themselves in the foot a little=20
> with this one
> (assuming people abide by it)? As it seems that this will effect any
> authenticated web application. Or are CALs acceptably cheap?

They're cheap for academia (80% discount) but a bit vicious for industry =
at c. =A340 a pop.  Microsoft would argue that you could use Web =
Edition, which does not require CALs, for such non-Microsoft apps.  =
However, it won't allow useful things like SQL Server to install, which =
rather limits your options.  WIMP applications (Windows/IIS/MySQL/PHP) =
apps are possible on Web edition, but not WISP (Windows/IIS/SQL =
Server/PHP or whatever).

		- Peter

Re: [Bodington-developers] Windows 2003 CALs (was IE 7 issues)

[Matthew B. <mat...@ou...>]

Peter Crowther wrote:

> * Bodington running on Windows 2000 Server *does not* require Windows
> CALs for every user; Bodington running on Windows 2003 Server *does*.  A
> subtle but expensive change for anyone running a non-Microsoft
> application that performs authentication.

More info about CALs for people who didn't know (like me).

http://www.microsoft.com/windowsserver2003/howtobuy/licensing/caloverview.mspx

Aren't Mircosoft shooting themselves in the foot a little with this one
(assuming people abide by it)? As it seems that this will effect any
authenticated web application. Or are CALs acceptably cheap?

-- 
 -- Matthew Buckett, VLE Developer
 -- Learning Technologies Group, Oxford University Computing Services
 -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/

Re: [Bodington-developers] IE 7 issues

[Peter C. <Pet...@me...>]

> From: Sean Mehan
> if the sw isn't supported by the company, why not just demand it be =20
> dropped!

Because the client still uses it and sees no reason to change.  I still
reasonably regularly come across desktops on Windows 98 (no longer
supported at all), Windows 2000 (on extended support) and the odd server
on NT4 (no longer supported).  I *run* a couple of Win2K servers, not
least because of the less onerous licensing terms*.  Demanding works if
we're larger than the company of which we're making the demands, but
we're a small company and end up politely suggesting instead.

		- Peter

* Bodington running on Windows 2000 Server *does not* require Windows
CALs for every user; Bodington running on Windows 2003 Server *does*.  A
subtle but expensive change for anyone running a non-Microsoft
application that performs authentication.

Re: [Bodington-developers] IE 7 issues

[Sean M. <se...@sm...>]

if the sw isn't supported by the company, why not just demand it be  
dropped!



On 14 Nov 2006, at 09:13, Peter Crowther wrote:

>> From: Jim Askey
>> indeed, i was glad to see the back of ie5 for mac!!
>
> I will be once its corpse stops moving - we still have a couple of
> diehard IE5 Mac users to support on one system.
>
> 		- Peter
>
> ---------------------------------------------------------------------- 
> ---
> Using Tomcat but need to do more? Need to support web services,  
> security?
> Get stuff done quickly with pre-integrated technology to make your  
> job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> Geronimo
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>

Re: [Bodington-developers] IE 7 issues

[Peter C. <Pet...@me...>]

> From: Jim Askey
> indeed, i was glad to see the back of ie5 for mac!!

I will be once its corpse stops moving - we still have a couple of
diehard IE5 Mac users to support on one system.

		- Peter