+ Post New Thread
Results 1 to 11 of 11
EduGeek Joomla 1.0 Package Thread, Room booking for joomla in Projects:; Hi Is there a free room booking component out there? I have searched around but only found commercial ones. I ...
  1. #1
    philjones2000's Avatar
    Join Date
    Mar 2006
    Location
    Pool, Cornwall
    Posts
    137
    Thank Post
    51
    Thanked 8 Times in 4 Posts
    Rep Power
    20

    Room booking for joomla

    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

  2. #2
    kerrymoralee9280
    Guest
    I've been looking at doing this too....

  3. #3
    Scotmk's Avatar
    Join Date
    May 2007
    Location
    Milton Keynes
    Posts
    277
    Thank Post
    1
    Thanked 4 Times in 3 Posts
    Rep Power
    16
    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.

  4. #4

    SYSMAN_MK's Avatar
    Join Date
    Sep 2005
    Posts
    3,978
    Thank Post
    484
    Thanked 1,330 Times in 721 Posts
    Rep Power
    425
    You could run MRBS in a Wrapper module

    And from the Joomla Forums

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

    Code:
    ###############################################
    # 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';

  5. #5

    Join Date
    Nov 2008
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    MRBS with Joomla authentication

    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?

  6. #6

    Join Date
    Jul 2009
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    MRBS db_ext not working

    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.

  7. #7
    mossj's Avatar
    Join Date
    Dec 2008
    Location
    Leicester
    Posts
    1,466
    Thank Post
    157
    Thanked 189 Times in 174 Posts
    Rep Power
    51
    hmm i could help... i think

    Code:
    # '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
    Last edited by mossj; 12th July 2009 at 08:18 PM.

  8. #8

    Join Date
    Jul 2009
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re:MRBS db_ext authentication not working

    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?

  9. #9
    mossj's Avatar
    Join Date
    Dec 2008
    Location
    Leicester
    Posts
    1,466
    Thank Post
    157
    Thanked 189 Times in 174 Posts
    Rep Power
    51
    There is no "Joomla" Switch Statment in auth_db_ext

    Code:
        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)

  10. Thanks to mossj from:

    ahess14 (14th July 2009)

  11. #10

    Join Date
    Jul 2009
    Posts
    3
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Added the joomla case into auth_db_ext

    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.

    Quote Originally Posted by mossj View Post
    There is no "Joomla" Switch Statment in auth_db_ext

    Code:
        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)

  12. #11

    Join Date
    Sep 2012
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi, i was wondering if there is also a solution for J1.6
    Any help would be great

SHARE:
+ Post New Thread

Similar Threads

  1. Room Booking Software
    By timbo343 in forum Windows
    Replies: 14
    Last Post: 6th June 2009, 10:28 AM
  2. Room booking application
    By OverWorked in forum How do you do....it?
    Replies: 45
    Last Post: 23rd October 2008, 11:21 AM
  3. Do you use Room Booking Software?
    By jazzy639 in forum Educational Software
    Replies: 30
    Last Post: 23rd October 2008, 11:09 AM
  4. Room Booking Software
    By gary234 in forum Educational Software
    Replies: 10
    Last Post: 23rd October 2008, 11:05 AM
  5. ERBS - Room Booking
    By EeEk in forum Downloads
    Replies: 0
    Last Post: 1st May 2008, 11:52 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •