Re: mySQL based user password login / Matt Barclay's authenication m odule?
Matt Barclay <mbarclay <at> cs.washington.edu>
2001-12-16 09:03:50 GMT
Hello,
The links for my PHP session + mrbs_person table authentication module
have changed. You can get the code at:
http://www.openfbo.com/auth_session_sql.tar
AND
http://www.openfbo.com/current.tar.gz
My ISP keeps dropping off the face of the planet, so if the links don't
work please be patient.
The auth_session_sql.tar contains SQL scripts to create/remove the session
and person tables. The current.tar.gz has the PHP scripts that I modified
to make my authentication scheme work.
I'll be adding a few new features to authentication module soon (options
to: Notify admin of bookings, estimate the cost of renting a room based on
hours rented and hourly rate, restrict changes/deletions to scheduled
entries within a specified number of minutes/hours/days, exclude certain
days from the schedule) And so on... These modifications all relate to
http://openfbo.sourceforge.net which is based on MRBS.
Cheers,
Matt
On Fri, 14 Dec 2001, Rajkumar Seth wrote:
> From: Rajkumar Seth <Seth.Rajkumar <at> GNI.co.uk>
> To: "'mrbs-general <at> lists.sourceforge.net'"
> <mrbs-general <at> lists.sourceforge.net>
> Subject: [Mrbs-general] mySQL based user password login / Matt Barclay's
> authenication m odule?
> Date: Fri, 14 Dec 2001 11:59:27 -0000
>
> Just a quick note to say thanks for an excellent program. The screenshots
> http://mrbs.sourceforge.net/sshots.html are excellent!
>
> Are there many people using MBRS with Matt Barclay's authentication module,
> especially on Windows? I noticed that there have been no modification to the
> core MBRS code since Version 1.0-pre2 (Sun Jul 8 13:43:53 BST 2001). I was
> wondering if anyone had used Matt Barclay's and if so if it could be rolled
> in as an option on the next release?
>
> Thanks for a great program. The details of Matt's positing are below:
>
> http://www.geocrawler.com/archives/3/3521/2001/9/0/6707083/
> This was written by a chap called Matt Barclay.
>
> FROM: Matt BarclayDATE: 09/27/2001 08:46:32SUBJECT: RE: [Mrbs-general]
> Advice on authentication plug-in options for MRBS Rajkumar [and everyone
> else],
>
> I wrote an authentication scheme that uses php sessions and a user table
> in the database. I wrote sql upgrade scripts to add and destroy session
> tracking and user tables. There's a README included that describes the set
> up. I had to add conditional includes to just about all of the php files
> in MRBS to allow session tracking, so installing my module will be
> difficult until it is merged into the MRBS repository (pending the Project
> manager's approval).
>
> Here's a list of features I've added:
> -- Web login with option to submit and maintain session in SSL
> -- Logoff link to destroy session
> -- Password changer
> -- User Management page displays mrbs_person table
> * Allows user modification
> * Allows user deletion
> -- User Register page with submit using SSL option
> * User sends name,email,username,password and is given a User Level
> 0 until the admin approves the user.
> * $mrbs_admin_email is sent a message that a user has registered
> and the user_level must be set (using the User Management tool in the admin
> page) See the AUTHENTICATION file for user_level details.
>
> You can grab the PHP code from my CVS repository:
>
> cvs -z3 -d:pserver:<EMAIL: PROTECTED>:/cvsroot/openfbo
> login
>
> cvs -z3 -d:pserver:<EMAIL: PROTECTED>:/cvsroot/openfbo
> co -P openfbo
>
> The SQL upgrade scripts and README.auth_session files are tar'ed here:
> http://c62028-a.olmpi1.wa.home.com/openfbo/auth_session_sql.tar
>
> IF YOU WANT TO INSTALL THIS NOW, I recommend setting up a test site
> separate from your live site. Installing this module will be rough until
> it is merged into MRBS. You will have to replace all of the .php and .inc
> files with copies from my CVS repository. I had to make changes to allow
> session tracking (one inclued statement per file). There are NO user
> interface changes, other than "register", "logon", and "logoff" links
> added to the page header.
>
> You can test/view my authentication scheme here:
> http://c62028-a.olmpi1.wa.home.com/openfbo
> Poke around all you like; This is a development server; Use guest/guest
> to log on as a user. Feel free to register a username if you like.
>
> My module is currently in use by a tennis club in Germany. Set up was
> fairly difficult, but I think most of the bugs are fixed. This module
> hasn't been tested on Windows. It has been tested on: Apache, Mysql,
> and pgsql running on Linux. I can provide limited tech support to set up
> this authentication module, and would greatly appreciate bug reports
> (especially on windows).
>
> OpenFBO is a project I am starting to provide online aircraft scheduling
> and accounting services for Fixed Base Operators (General Aviation
> businesses who rent aircraft, fly charter, and teach flying). Our project
> page is here:
> http://openfbo.sourceforge.net
>
> Cheers,
> Matt
>
>
> ************************************************************************
> The contents of this message and any attachments are confidential and
> are intended solely for the attention and use of the addressee only.
> Information contained in this message may be subject to legal,
> professional or other privilege or may otherwise be protected by other
> legal rules. This message should not be copied or forwarded to any other
> person without the express permission of the sender. If you are not the
> intended recipient you are not authorised to disclose, copy, distribute
> or retain this message or any part of it.
>
> If you have received this message in error, please notify the sender by
> telephone (+44-20-7002-4000) and destroy the original message.
>
> We reserve the right to monitor all e-mail messages passing through our
> network.
> ************************************************************************
>
> _______________________________________________
> Mrbs-general mailing list
> Mrbs-general <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/mrbs-general
>