+ Post New Thread
Results 1 to 5 of 5
How do you do....it? Thread, Meeting Room Booking System - MRBS in Technical; This is a request for help from any PHP/Mysql novice who has managed to set up MRBS. I have installed ...
  1. #1

    Join Date
    Mar 2006
    Location
    Chelmsford
    Posts
    115
    Thank Post
    0
    Thanked 4 Times in 4 Posts
    Rep Power
    19

    Meeting Room Booking System - MRBS

    This is a request for help from any PHP/Mysql novice who has managed to set up MRBS. I have installed WAMP (latest) and followed the MRBS set up documentation but I cannot connect to the database - 'fatal error - cannot connect to database'. I am using login=root and password=' ' as I cannot find any passwords in the mysql documentation. If I leave the config.inc.php unchanged, the error is even longer and refers to a mysql function error. Also, if I run the tables.my.sql query in sqladminlite to create the tables, that fails with errors and does not create the tables. I was hoping for an easy install but my hopes were dashed! Thanks.

  2. #2
    tsky's Avatar
    Join Date
    Jan 2009
    Location
    Billingham
    Posts
    200
    Thank Post
    10
    Thanked 27 Times in 16 Posts
    Rep Power
    20
    You're getting the error because it can't log on to the database engine - probably because there are no users in the system for it.

    Best thing to do is get yourself a copy of PHPMyAdmin - this is a web-based control engine for MySQL.
    From there you can generate usernames and passwords and set privileges to your databases, rather than having to worry about the command-line stuff.
    the other thng you can do is to get the GUI toolkit if you're on Windows if you prefer to use that over a web-based toolkit.

    Ideally you want to set a password for your root account - it's not a good idea to run without one.
    you'll want to set usernames and passwords for your individual databases. I've not looked at MRBS before, but I should imagine there would be a setup script page you could configure from - anyone else out there with more info on it that can help pmassingham?

  3. #3
    tsky's Avatar
    Join Date
    Jan 2009
    Location
    Billingham
    Posts
    200
    Thank Post
    10
    Thanked 27 Times in 16 Posts
    Rep Power
    20
    Just had a quick look for you... seems you need to pre-populate MySQL with a database and user before it runs:


    From the MRBS documentation:
    ( MRBS: Documentation : INSTALL )

    --------------------
    For a new install:

    creating the DB
    ===============
    You can place the MRBS database tables in an existing database or
    create a new database with the following:

    mysqladmin create mrbs
    mysql mrbs < tables.my.sql


    Application Setup
    =================
    First, select your database system. Define one of the following:

    $dbsys = "mysql";

    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

    ---------------------



    Links
    =====
    PHPMyAdmin
    phpMyAdmin - Download

    MySQL GUI Toolkit
    MySQL :: MySQL GUI Tools Downloads

  4. #4

    Join Date
    Mar 2006
    Location
    Chelmsford
    Posts
    115
    Thank Post
    0
    Thanked 4 Times in 4 Posts
    Rep Power
    19
    Thanks for the replies. I have tried to comprehend the documentation but have to admit that I do not have the required skills in PHP nor Mysql. I will try another scratch install to see if I can make progress. The dblogin and password are where I could not find guidance. I will try PhpMydmin to change the authentication.

  5. #5

    Join Date
    May 2006
    Location
    West Bromwich
    Posts
    2,191
    Thank Post
    299
    Thanked 215 Times in 185 Posts
    Rep Power
    56
    I used the MySQL GUI tools to do mine. I found it be be a lot easier using the tools. Possibly because i am totally naff at scripting

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 30
    Last Post: 21st June 2013, 12:31 AM
  2. Room booking
    By matt40k in forum MIS Systems
    Replies: 8
    Last Post: 5th November 2008, 09:45 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. Replies: 0
    Last Post: 31st October 2007, 01:25 PM
  5. Meeting Room Booking System - examples config inside!
    By db260179 in forum Network and Classroom Management
    Replies: 7
    Last Post: 25th July 2007, 07:07 PM

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
  •