MRBS - Easy to install?

[glennw]

Currently use OARBS but hear a lot on this board about MRBS ,

 

How easy is the installation ?

 

Does anybody have a dummies guide ?

[Geoff]

Assuming you have a LAMP box setup already, yes its no hassle. Simply create the DB, DB User, copy the files to the right place and run the setup.

 

Some of the more advanced stuff is fiddly like getting it to authenticate to AD and doing 2 week rotating timetables though.

[ChrisH]

Doesnt have to be a linux box either I run mine on IIS.

[Irazmus]

I've just installed this myself on an SuSE box.

Couldn't have been easier, took less than 30 mins to fully setup including AD authentication.

 

The included install guide is pretty thorough and the config file is fully commented so I can't see you'd have any trouble.

[Geoff]

Doesnt have to be a linux box either I run mine on IIS.

 

Some things don't work right on IIS/Windows. MRBS does but web servers tend to have more and more different webapps loaded on over time. If your not using a LAMP box you find ones you 'need' but don't work sooner or later.

[plexer]

I have mine running on IIS as well with php and mysql installed and don't have any problems.

 

Ben

[plexer]

I have mine running on IIS as well with php and mysql installed and don't have any problems.

 

Ben

[HodgeHi]

Hello all,

 

I am trying to get MRBS installed using IIS with AD authentication.

 

 

I am having difficulty in getting the LDAP_Auth to bind and search the AD. if i remember (its about 5 months since i last looked at it) the error was that it could not bind to the AD

 

I have tried alternative LDAP search scripts to test my default search bases and stuff but got to an error saying could not search your AD.

 

I have used the default MRBS installation 1.2.3 with no cvs updates. I read on the MRBS board that there was a problem with the original LDAP_auth file. Is this true?

 

The problem is i have not done any PHP before and this is my first project. I don't get the time to sit and learn programming as much as i would like.

[Joedetic]

I think this'd be the best place to append this.

 

I've got to install MRBS on a LAMP server next week and set it up to work as a resource booking system as opposed to a room booking system (i've seen an example and i liked it). The other alternative is

 

http://booking-dev.centralmanclc.com/ but that never wants to work on my test server.

 

Anyway. How do you all set it up to handle all the staff can log on and book. LDAP auth? Does that work over the internet from behind an ISA server. The idea is that the staff can book resources from home too.

[Ric_]

If the server hosting MRBS is on the same network as your DCs, you shouldn't have a prob with LDAP authentication.

 

If you have your server in a DMZ or outside your network, it may prove eassier to export a list of users from AD and import them into MRBS.

[webman]

There is a thread on Edugeek that Geoff posted in with the samba/winbind authentication code for MRBS.

[Geoff]

Yes. Here infact.

 

http://www.edugeek.net/index.php?name=Forums&file=viewtopic&p=13759#13759

[Joedetic]

So you all use LDAP then?

[Geoff]

No, I use external auth via the squid helper for winbind.

[thom]

One of my summer projects is to get MRBS up and running

As I had a bit of time on my hands I thought I would try using Linux to host the site

It is all very new for me so I have been following various guides around the 'net.

I used Ubuntu Feisty Fawn in a LAMP setup and then followed the MRBS instructions, pretty much leaving everything set to the defaults.

However, when i access the mrbs site I get

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'mrbs'@'localhost' (using password: YES) in /var/www/mrbs/mysql.inc on line 224

Fatal Error: Failed to connect to database

Any clues what I need to do?

The one part of the MRBS Install guide I didn't follow was that I put the contents of the MRBS web folder into /var/www/mrbs because I didn't have a /var/lib/apache/htdocs folder.

Once I put it all togoether I am hoping to write a complete guide (maybe on the wiki) for other noobs like me.

[Joedetic]

Check that your mysql user has the right permissions on the mrbs database.

 

If you're unfamiliar with the commands for mysql then you could use phpmyadmin for a web based admin front end or what i use which is MySQL administrator http://www.mysql.com/products/tools/administrator/

[Domino]

are you sure you have LAMP setup, as that tripped me up with UBUNTU, you can't just select it at setup and hit next, you have to hit space when it is highlighted to actually select it?

 

try restarting apache like so

 

sudo /etc/init.d/apache2 restart

[Joedetic]

Well if he's getting the error message in the web browser i'd assume he's got it setup.

 

Also check wether mysql is started in the same way but using mysql intead of the apache2 bit.

[Domino]

just putting in something from experience - apologies.

 

the other thing to check is permissions on the folders the site and database are stored in.

[Joedetic]

Oh god there's no need to apologise :S

[thom]

Thanks for the quick response

I restarted apache2 and mySql and then the server but none of that made a difference. I'm using Webmin 1.360 to manage apache and MySql but I haven't got a clue how to follow joedetic's advice

Check that your mysql user has the right permissions on the mrbs database.

also when I look at the permissions for the mrbs web folder it says "you are not the owner so you can't change these permissions" the owner is root. :?

Please remember, this is all new to me - pretend you are talking to a teacher.

Thanks again.

[Domino]

log in as root then.....

 

you will have set up a root password on setup

 

(note: when you see the "sudo" command in a set of instructions, that runs the command as if you were root).

 

I'd suggest having a look at some of the online tutorials in setting up a linux webserver, if you ask us for solutions to every problem you'll not really learn what the commands are doing....

 

theres a good bit about permissions here http://www.elated.com/articles/understanding-permissions/

[Joedetic]

That is how to check permissions on a folder...but for the actual mysql permissions on the database you need to use the commands or phpmyadmin or something like that.

 

sudo apt-get install phpmyadmin (should work i think) and then go to http://serveraddress/phpmyadmin and then select the database and then go to privilages and make sure that your user that you're using has got full permissions on the DB (or at least the necessary ones...i'm lazy so i just put in full).

[thom]

Thanks for the link domino, I managed to change permissions on the mrbs database and web folders so everyone could do anything.

It was still giving the same error.

I then configured mysql user and database permissions to allow anonymous users to do everything

I then changed the mrbs config.inc.php file to

# Database login user name:

$db_login = "";

# Database login password:

$db_password = '';

 

It is now working. I guess this is highly unsecure, i might try tightening it up in the future

[webman]

Yes, your database is configured very insecurely. I would recommend you undo the "anonymouse users everything" permisson, and should atleast run this MySQL query:

 

GRANT ALL PRIVILEGES ON mrbs_DB.* to 'mrbsuser'@'localhost' IDENTIFIED BY 'mrbspassword';

 

... and then change your MRBS configuration accordingly.