MRBS

Meeting Room Booking System

Introduction

Meeting Room Booking System

Is a free PHP application for managing room bookings.

Requires a web server, PHP and database (MySQL, Postgres).

• Has Period settings functionality so is ideal for schools.
• Can authenticate to LDAP, so users can login with their existing Novell eDirectory or Microsoft Active Directory user account.
• Can also authenticate using IMAP/POP3 servers, an existing MySQL database or a list of users in it's config.
• Can automatically send emails to room managers and to confirm bookings.
• Can make recurring bookings every week, or every two weeks for school on A/B week system.

Uses:

• Booking Rooms and Computer Labs
• School resources:
  • Projectors
  • Mobile laptop labs
  • School buses

Configuration

Microsoft Active Directory

User Attribute

User attribute as either

Network ID (short)

$ldap_user_attrib = "sAMAccountName";

or you may need to use the UPN (Long),

$ldap_user_attrib = "userPrincipalName";

Local School server

Use following settings:

$ldap_host = "LocalADServer";

Staff container. Use Active Directory Explorer to determine your dn.

$ldap_base_dn = "OU=Staff,OU=School,DC=Domain,DC=au";

DET Win Server

$ldap_host = "staff.det.win";

$ldap_base_dn = "OU=Accounts,DC=staff,DC=det,DC=win";

However this will let ANYONE with a staff DET account in.

You will need to somehow restrict users to being a member of your school group, e.g:

"CN=Great Lakes Coll Tuncurry Senior - School.Teacher,OU=Great Lakes College Tuncurry Senior Campus,OU=North Coast,OU=Schools,DC=staff,DC=det,DC=win"

Novell eDirectory

Use following settings:

$ldap_host = "eDirServerIP";

$ldap_base_dn = "ou=Staff,ou=users,o=School";

$ldap_user_attrib = "cn";

School Examples

• Sydney Boys High Bookings