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 ...
12th February 2009, 09:43 AM #1
- Rep Power
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.
12th February 2009, 10:15 AM #2
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?
12th February 2009, 10:20 AM #3
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
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
phpMyAdmin - Download
MySQL GUI Toolkit
MySQL :: MySQL GUI Tools Downloads
12th February 2009, 10:36 AM #4
- Rep Power
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.
12th February 2009, 11:03 AM #5
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
By ChrisH in forum Scripts
Last Post: 21st June 2013, 12:31 AM
By matt40k in forum MIS Systems
Last Post: 5th November 2008, 09:45 AM
By jazzy639 in forum Educational Software
Last Post: 23rd October 2008, 11:09 AM
By Scotmk in forum Downloads
Last Post: 31st October 2007, 01:25 PM
By db260179 in forum Network and Classroom Management
Last Post: 25th July 2007, 07:07 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)