Room booking for joomla

[philjones2000]

Hi

Is there a free room booking component out there? I have searched around but only found commercial ones.

I use mrbs at the moment which is great but I'd like to integrate into our joomla website. I'm just being picky.

Thanks

Phil

[kerrymoralee9280]

I've been looking at doing this too....

[Scotmk]

Me too, Cannot see any free good ones, there are a couple but not up to the job. I did find 1 commercal, but that was not free, I will see if I can remember where I saw it, though it still lacked the functionality of MRBS and Devizes one.

[SYSMAN_MK]

You could run MRBS in a Wrapper module

And from the Joomla Forums

In the MRBS config.inc.php set up db_ext authentication.

###############################################
# Authentication settings - read AUTHENTICATION
###############################################
$auth["session"] = "php"; # How to get and keep the user ID. One of
           # "http" "php" "cookie" "ip" "host" "nt" "omni".
$auth["type"] = "db_ext"; # How to validate the user/password. One of "none"
                          # "config" "db" "db_ext" "pop3" "imap" "ldap" "nis"
                          # "nw" "ext".

# The list of administrators (can modify other peoples settings)
#$auth["admin"][] = "127.0.0.1";   # localhost IP address. Useful with IP sessions.
$auth["admin"][] = "admin";   # A user name from the user list. Useful 
                                    #with most other session schemes.

# 'auth_config' user database
# Format: $auth["user"]["name"] = "password";

# 'session_http' configuration settings
$auth["realm"]  = "mrbs";

# 'auth_ext' configuration settings
$auth["prog"]   = "";
$auth["params"] = "";

# 'auth_db_ext' configuration settings
$auth['db_ext']['db_host'] = 'localhost';
$auth['db_ext']['db_username'] = 'dbuser';
$auth['db_ext']['db_password'] = 'secret';
$auth['db_ext']['db_name'] = 'joomla';
$auth['db_ext']['db_table'] = 'jos_users';
$auth['db_ext']['column_name_username'] = 'username';
$auth['db_ext']['column_name_password'] = 'password';
# Either 'md5', 'sha1', 'crypt' or 'plaintext'
$auth['db_ext']['password_format'] = 'md5';

[its_buz]

Has anyone got MRBS to authenticate with Joomla? I haven't got it working. I understand Joomla uses MD5+Salt which MRBS doesn't cater for out-of-the-box. I've tried the tips at this thread. Has anyone had any luck? Any additional steps required besides those listed in the link I just gave?

[ahess14]

Hi

I'm still not winning with regards to the db_ext authentication from
Joomla jos_users table. Done everything below:
###############################################
# Authentication settings - read AUTHENTICATION
###############################################
$auth["session"] = "php"; # How to get and keep the user ID. One of
# "http" "php" "cookie" "ip" "host" "nt" "omni".
$auth["type"] = "db_ext"; # How to validate the user/password. One of
"none"
# "config" "db" "db_ext" "pop3" "imap" "ldap"
"nis"
# "nw" "ext".

# The list of administrators (can modify other peoples settings)
#$auth["admin"][] = "127.0.0.1"; # localhost IP address. Useful with IP
sessions.
$auth["admin"][] = "admin"; # A user name from the user list. Useful
#with most other session schemes.

# 'auth_config' user database
# Format: $auth["user"]["name"] = "password";

# 'session_http' configuration settings
$auth["realm"] = "mrbs";

# 'auth_ext' configuration settings
$auth["prog"] = "";
$auth["params"] = "";

# 'auth_db_ext' configuration settings
$auth['db_ext']['db_host'] = 'localhost';
$auth['db_ext']['db_username'] = 'dbuser';
$auth['db_ext']['db_password'] = 'secret';
$auth['db_ext']['db_name'] = 'joomla';
$auth['db_ext']['db_table'] = 'jos_users';
$auth['db_ext']['column_name_username'] = 'username';
$auth['db_ext']['column_name_password'] = 'password';
# Either 'md5', 'sha1', 'crypt' or 'plaintext'
$auth['db_ext']['password_format'] = 'joomla';

And added the code in auth_db_ext.inc under the sitch statement;
case 'joomla':
list($hash, $salt) = explode(':', $row[0]);
$cryptpass = md5($pass.$salt);
if ($hash == $cryptpass)
{
$retval = 1;
}
break;

Please help, running on the latest Ubuntu Server, MySql 5 and PHP 5.

[mossj]

hmm i could help... i think

# 'auth_db_ext' configuration settings
$auth['db_ext']['db_host'] = 'localhost';
$auth['db_ext']['db_username'] = 'dbuser';
$auth['db_ext']['db_password'] = 'secret';
$auth['db_ext']['db_name'] = 'joomla';
$auth['db_ext']['db_table'] = 'jos_users';
$auth['db_ext']['column_name_username'] = 'username';
$auth['db_ext']['column_name_password'] = 'password';
# Either 'md5', 'sha1', 'crypt' or 'plaintext'
$auth['db_ext']['password_format'] = 'joomla';

Your error is the last line it must be either "md5, sha1, crypt, or plaintext" I can't remember which one joomla uses, but i think it will be md5.

If you would like a easier to read way of configing mrbs authentication look here, although ITS NOT working yet the descriptions and options make it easier to read/understand

[ahess14]

Thank you mossj but still not working I tried it in a Wrapper or External Links menu type. I change the joomla to md5 but not sure why because the joomla refer back to the joomla case in the auth_db_ext.inc file in the switch statement. Is there a live example of this implementation working somewhere?

[mossj]

There is no "Joomla" Switch Statment in auth_db_ext

    switch ($auth['db_ext']['password_format'])
    {
      case 'md5':
        if (md5($pass) == $row[0])
        {
          $retval = 1;
        }
        break;

      case 'sha1':
        if (sha1($pass) == $row[0])
        {
          $retval = 1;
        }
        break;

      case 'crypt':
        $recrypt = crypt($pass,$row[0]);
        if ($row[0] == $recrypt)
        {
          $retval = 1;
        }
        break;

      default:
        // Otherwise assume plaintext
        if ($pass == $row[0])
        {
          $retval = 1;
        }
        break;
    }

You changed it because MRBS needs to know how to convert the encoded password in your database.

Joomla converts the password in md5, so MRBS needs to be set to md5.


Is it working if you go to the url directly? (I.E Without wrapping it)

[ahess14]

I added the case in the auth_db_ext.inc file and configured the config.php file to refer to the joomla case to convert the passwords. Not sure what your point was with regards to the previous post.

There is no "Joomla" Switch Statment in auth_db_ext

    switch ($auth['db_ext']['password_format'])
    {
case 'joomla':
list($hash, $salt) = explode(':', $row[0]);
$cryptpass = md5($pass.$salt);
if ($hash == $cryptpass)
{
$retval = 1;
}
break;

      case 'md5':
        if (md5($pass) == $row[0])
        {
          $retval = 1;
        }
        break;

      case 'sha1':
        if (sha1($pass) == $row[0])
        {
          $retval = 1;
        }
        break;

      case 'crypt':
        $recrypt = crypt($pass,$row[0]);
        if ($row[0] == $recrypt)
        {
          $retval = 1;
        }
        break;

      default:
        // Otherwise assume plaintext
        if ($pass == $row[0])
        {
          $retval = 1;
        }
        break;
    }

You changed it because MRBS needs to know how to convert the encoded password in your database.

Joomla converts the password in md5, so MRBS needs to be set to md5.


Is it working if you go to the url directly? (I.E Without wrapping it)

[pathi]

Hi, i was wondering if there is also a solution for J1.6
Any help would be great