Find Jobs
Hire Freelancers

Load MRBS software and configure environment our server which is at MediaTemple.com

$100-250 USD

In Progress
Posted over 12 years ago

$100-250 USD

Paid on delivery
Hello, we are in need of a scheduling software for our conference rooms. We found this software called MRBS. I have pasted in the installation instructions below- We have a hosted server that is provided by Media Temple, here is a link to the software- [login to view URL] Please make sure you know what Media Temple can do and that you understand the installation instructions. We will give you the Admin login to mediatemple once the project is awarded. Thanks ## Deliverables REQUIREMENTS --------------------------------------------------------------------------- MRBS works with both MySQL (Version 4 and above) and PostgreSQL (Version 7 and above) systems. You must have PHP with support for your chosen database system installed and working for this application. See the PHP ([login to view URL]), MySQL ([login to view URL]), and PostgreSQL ([login to view URL]) sites for more info on setting these up. You need to know how to install, secure, run, maintain, and back up your chosen database system. No optional PHP packages (other than the database system) are required for this application. PHP Version 4 or later is required. You can run PHP either as a CGI or with a direct module interface (also called SAPI). These servers include Apache, Microsoft Internet Information Server, Netscape and iPlanet servers. Many other servers have support for ISAPI, the Microsoft module interface. You'll get better performance with PHP setup as a module. Not only will you not have to deal with the CGI performance hit, but you'll be able to use PHP's database connection pooling. However, be careful that you don't exceed the maximum number of connections allowed to your database; with connection pooling PHP/Apache can potentially create a connection from each Apache child server to the database. Also many MRBS authentication schemes use basic HTTP authentication. These don't work if you run PHP as a CGI. If you are using PHP as an Apache module, you probably want to ensure that the Apache MaxRequestsPerChild is not set to 0, in case of undetected memory leaks in PHP or MRBS. OVERVIEW --------------------------------------------------------------------------- The steps involved in installing MRBS are: 1. Installing the MRBS files on your web server 2. Creating the MRBS tables in your database 3. Configuring MRBS After that you can then point your browser at MRBS and start creating areas and rooms. INSTALLING THE MRBS FILES --------------------------------------------------------------------------- To install MRBS, just unpack the distribution into a temporary directory, then copy the files in the "web" subdirectory into a new directory somewhere your web server can find them. If you are using a remote webserver, unpack the files into a temporary directory on your local machine and then upload them to suitable directory on your webserver, for example [login to view URL] If you are using a Unix/Linux webserver to which you have access, then an example of the installation might be: Unpack the software into a new temporary directory, something like this: $ tar -xvzf ~/download/[login to view URL] (or whatever version) $ cd mrbs-1.0 (or whatever version) If you are upgrading from a previous version of MRBS, you should save your "[login to view URL]" file so you can compare and update the new file with your site-specific changes. Then rename your existing MRBS web server directory. For example: $ cp /var/lib/apache/htdocs/mrbs/[login to view URL] [login to view URL] $ mv /var/lib/apache/htdocs/mrbs /var/lib/apache/htdocs/[login to view URL] Now install MRBS by copying the contents of the "web" subdirectory of the distribution somewhere your web server can find it. For example: $ cp -r web /var/lib/apache/htdocs/mrbs CREATING THE MRBS TABLES IN YOUR DATABASE --------------------------------------------------------------------------- For a new install: If you are using a remote webserver you should use your database administration program (eg phpMyAdmin in your control panel) to create the MRBS tables, by executing the contents of tables.my.sql. For example, if you are using phpMyAdmin copy the contents of [login to view URL] into the SQL tab of phpMyAdmin and execute it as an SQL query. This assumes that you have already created a database - if not you should create a database first. If you are using a Unix/Linux webserver to which you have access, then the procedure might be: [MySQL] $ mysqladmin create mrbs [PostgreSQL] $ createdb mrbs (This will create a database named "mrbs", but you can use any name.) Create the MRBS tables using the supplied tables.*.sql file: [MySQL] $ mysql mrbs < [login to view URL] [MySQL < 4.1] $ mysql mrbs < [login to view URL] [PostgreSQL] $ psql -a -f [login to view URL] mrbs [PostgreSQL < 7.3] $ psql -a -f [login to view URL] mrbs where "mrbs" is the name of your database (mentioned above). This will create all the needed tables. You may need to set rights on the tables; for PostgreSQL see "[login to view URL]". If you need to delete the tables, for PostgreSQL see "[login to view URL]". The tables are now empty and ready for use. If you want to add a few sample areas and rooms without going through the Admin function, use this script: [MySQL] $ mysql mrbs < [login to view URL] [PostgreSQL] $ psql -a -f [login to view URL] mrbs Substitute the database name you used for "mrbs". This script is only for use in a newly initialized database! (It will not work properly in a database where the ID counters are greater than 0.) Also see the description of [login to view URL] in the README file. For an upgrade: If you are upgrading from MRBS 1.2-pre3 or later, your database will be upgraded automatically if necessary when you first run MRBS. You will be prompted for a database (not MRBS) username and password with rights to create and alter tables. Otherwise, please see the UPGRADE file. For a second installation or to use different table names: If you have table name conflicts or want to do a second installation and only have access to one database, then you can modify the 'mrbs_' prefix for the table names. In tables.*.sql you will need to change the table names and then follow the instructions above for creating the tables in your database. When editing [login to view URL], you need to change the table name prefix from "mrbs_" to the value you chose using the variable $db_tbl_prefix. WARNING: All of the .sql files are setup to use the 'mrbs_' prefix therefore you will have to edit them before you use them if you change the prefix for your tables. Maintenance: Be sure to back up your database regularly. For PostgreSQL, be sure to run the "vacuum" command regularly. You can clean out old entries from your database using the supplied SQL scripts [login to view URL] (for MySQL) and [login to view URL] (for PostgreSQL). Read the comments at the top of the scripts before using them. ADDING EXTRA COLUMNS TO THE DATABASE TABLES --------------------------------------------------------------------------- It is possible to add extra columns to the entry, repeat, room and users tables, if you need to hold extra information about bookings, rooms and users. For example you might want to add a column in the room table to record whether or not a room has a coffee machine and you might want to record the phone numbers of users. (Note that the users table is only used if you are using the 'db' authentication scheme). Similarly you might want to add a field to the entry and repeat tables to record the number of participants for a meeting. To add extra columns, just go into your database administration tool, eg phpMyAdmin, and add the extra columns manually. MRBS will then recognise them and handle them automatically, displaying the information in the lists of rooms and users and allowing you to edit the data in the appropriate forms. NOTES: (1) if you are adding a field to the entry table you must add an identical field to the repeat table. If you do not MRBS will fail with a fatal error when you try and run it. (2) names must consist of letters, numbers or underscores. If you are using PostgreSQL then the name must begin with a letter or an underscore. If you are using MySQL then there is no restriction on the first character as long as it is in the permitted set, ie a letter, number or underscore. (Although MySQL will allow other characters in column names, MRBS imposes restrictions on the characters allowed in order to simplify the code. For a technical explanation see below). At the moment only text, varchar, int, smallint and tinyint columns are supported, displayed as textarea, text or checkbox fields as appropriate. Whether a varchar is displayed as a text or textarea input depends on its maximum length, with the breakpoint determined by a configuration variable. Ints are treated as integer types, as you would expect. However smallints and tinyints are assumed to be booleans and are displayed as checkboxes. [Note: smallints are assumed to be booleans because the boolean type in PostgreSQL presents some problems in PHP when trying to process the results of a query in a database independent way, so it is more convenient to use a smallint instead of a boolean in PostgreSQL.] Text descriptions are looked for in the lang files with the tag room.column_name, eg room.coffee_machine, or [login to view URL] enabling translations to be provided. If not present, the column name will be used for labels etc. If you are adding columns to the entry and repeat tables then you only need to add the entry.column_name tags: you don't need to add a repeat.column_name tag. As an example, to add a field to the room table recording whether or not there is a coffee machine you would, in MySQL, add the column coffee_machine tinyint(1) to the room table and add the line vocab["room.coffee_machine"] = "Coffee machine"; to the [login to view URL] file and similarly for other languages as required. MRBS should then do the rest and display your coffee machine field on the room pages. Extra options for custom fields: 1) You can create dropdown boxes for a custom field by defining an entry in the configuration array $select_options. For example: $select_options['entry.conference_facilities'] = array('Video', 'Telephone', 'None'); would define the 'conference_facilities' custom field to have three possible values. For custom fields only (will be extended later) it is also possible to use an associative array for $select_options, for example $select_options['[login to view URL]'] = array('c' => 'Coffee', 's' => 'Sandwiches', 'h' => 'Hot Lunch'); In this case the key (eg 'c') is stored in the database, but the value (eg 'Coffee') is displayed and can be searched for using Search and Report. This allows you to alter the displayed values, for example changing 'Coffee' to 'Coffee, Tea and Biscuits', without having to alter the database. It can also be useful if the database table is being shared with another application. MRBS will auto-detect whether the array is associative. 2) You can specify that a field is mandatory. This will ensure that the user specifies a value for a field that may be empty, like a text box or a selection, as in 1) above. For example: $is_mandatory_field['entry.conference_facilities'] = true; would define the 'conference_facilities' custom field to be mandatory. In the case of a select field, this adds an empty value to the dropdown list. Making a checkbox field mandatory is possible and requires the checkbox to be ticked before the form can be submitted. This can be useful for example for requiring users to accept terms of service or terms and conditions. 3) You can also specify that a field is private, ensuring that the contents are only visible to yourself and the administrators. For example: $is_private_field['[login to view URL]'] = true; would prevent the details of your refreshments being visible to other users - provided that private bookings are enabled. See the section on private bookings in [login to view URL] for more information. Technical explanation of the restriction on column names for custom fields -------------------------------------------------------------------------- // Column names for custom fields are used by MRBS in a number of ways: // - as the column name in the database // - as part of an HTML name attibute for a form input // - as part of a PHP variable name // // MySQL, PostgreSQL, HTML and PHP all have different rules for these tokens: // - MySQL: almost anything is allowed except that: // - "No identifier can contain ASCII NUL (0x00) or a byte with a value // of 255." // - "Database, table, and column names should not end with space // characters." // ([login to view URL]) // // - PostgreSQL: "SQL identifiers and key words must begin with a letter (a-z, // but also letters with diacritical marks and non-Latin letters) or an // underscore (_). Subsequent characters in an identifier or key word can // be letters, underscores, digits (0-9), or dollar signs ($). Note that // dollar signs are not allowed in identifiers according to the letter of the // SQL standard, so their use may render applications less portable. The SQL // standard will not define a key word that contains digits or starts or ends // with an underscore, so identifiers of this form are safe against possible // conflict with future extensions of the standard." // ([login to view URL]) // // - PHP: "Variable names follow the same rules as other labels in PHP. A // valid variable name starts with a letter or underscore, followed by any // number of letters, numbers, or underscores. As a regular expression, it // would be expressed thus: '[a-zA-Z_\x7f-\xff][a-zA-Z0-9_\x7f-\xff]*' " // ([login to view URL]) // // - HTML: "ID and NAME tokens must begin with a letter ([A-Za-z]) and may be // followed by any number of letters, digits ([0-9]), hyphens ("-"), // underscores ("_"), colons (":"), and periods (".")." // ([login to view URL]) // // In order to avoid complications with using names in each of these contexts, // we restrict custom field names to the set of names which conforms to all // four rules, taking into account the fact that when MRBS uses column names // in PHP and HTML it always prefixes them with a string beginning with a letter. // This gives us the rule that custom field names must consist of letters, // numbers or underscores. CONFIGURING MRBS --------------------------------------------------------------------------- Next, you will need to customize the file "[login to view URL]"... As a minimum you will need to set the timezone and the database variables. Other settings can be changed by copying lines from [login to view URL] and [login to view URL] and pasting them into config.inc.php. Do not edit [login to view URL] or [login to view URL] as it will make it harder for you to upgrade when new versions are released. Note that there are two different defaults files ([login to view URL] and [login to view URL]) to draw attention to the fact that the settings in areadefaults just determine the settings for NEW areas. Settings for existing areas are set using a web browser by following the "Rooms" link in MRBS. (It can be a little frustrating editing the area settings to find that they have no effect on existing areas!) 1. Timezone You must set the timezone to a valid value, a list of which can be found at [login to view URL] Don't forget to uncomment the line by removing the '//' at the beginning. Note that the timezone to use is the timezone in which your meeting rooms are located, not the timezone of your server in case they are different. However, if you already have bookings in your system which were made under a different timezone (perhaps if you are upgrading from a previous version of MRBS where the timezone wasn't set explicitly and the timzone defaulted to that of the server) then you have two choices: (a) to set the timezone to be the same as the previous timezone. This will ensure that all your existing bookings still appear correctly, but you will have to continue to put up with some minor inconveniences. For example "Go to Today" will not always go to the today for your rooms, if you happen to be using MRBS at a time of day when the rooms are on one day but the timezone you have selected is on the day before or after. Also if you are using the min and max book ahead facility then you will find that this is out by the difference between the timezone of your rooms and the timezone you have chosen. (b) to set the timezone to the timezone of your rooms, having first corrected the start and end times of all your existing bookings, in both the entry and repeat tables. This is not a trivial exercise and you should back up your database before starting. Note also that it is not necessarily as simple as adding or subtracting a fixed number of hours to existing bookings since the dates at which your rooms change between summer and winter time may be different to the dates at which your previous timezone made the DST change. This can happen for example if your rooms are in Europe and your server is in the USA, as there is usually a week when Europe has changed but the USA has not. 2. Database Settings: First, select your database system. Define one of the following: $dbsys = "mysql"; $dbsys = "mysqli"; $dbsys = "pgsql"; Then define your database connection parameters. Set the values for: $db_host = The hostname that the database server is running on. $db_database = The name of the database containing the MRBS tables. $db_login = The database login username $db_password = The database login password for the above login username If the database server and web server are the same machine, use $db_host="localhost". Or, with PostgreSQL only, you can use $db_host="" to use Unix Domain Sockets to connect to the database server on the same machine. By default, MRBS will use PHP persistent (pooled) database connections, for better performance. Depending on your web server and database server configuration, it is possible that this will cause MRBS to reach the maximum number of connections allowed to your database, since each Apache child process may keep a connection open. Then, users will randomly get errors when trying connecting to MRBS. If you would rather use non-persistent database connections, uncomment the line in "[login to view URL]" which sets the $db_nopersist variable. If you want to install multiple sets of mrbs tables when only one SQL database is available, or resolve table name conflicts, you have to change the prefix of "mrbs_" for the tables in your database, then you will need to set the value of: $db_tbl_prefix = The table name prefix 3. Other Settings Now go through [login to view URL] and [login to view URL] and see which other configuration settings you would like to change. Do this by copying them to [login to view URL] and changing them there. This should make the task of upgrading to new releases easier as all your site-specific configuration changes will be confined to config.inc.php. There is a wide variety of settings that can be changed, including - site identification information - themes - calendar settings - booking policies - display and time format settings - private bookings settings - provisisional bookings settings - authentication settings - email settings - language settings - report settings - entry types The comments in the [login to view URL] and [login to view URL] files should explain the purpose of the various configuration variables and how to change them. (Note that some of the settings can be set on a per-area basis through the area administration page in MRBS. In this case the setting in the [login to view URL] and [login to view URL] files defines the default settings for new areas.) The Help information is held in the site_faq files, one per language. You may well want to customise it by editing the files.
Project ID: 3730542

About the project

2 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$180.20 USD in 2 days
5.0 (14 reviews)
4.7
4.7
2 freelancers are bidding on average $190 USD for this job
User Avatar
See private message.
$200.60 USD in 2 days
4.9 (6 reviews)
3.1
3.1

About the client

Flag of UNITED STATES
United States
5.0
35
Payment method verified
Member since Nov 21, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.