garydeng / senecabbb Goto Github PK

SenecaBBB
=========

Seneca BigBlueButton Integration Project


# Setting up DB on Ubuntu 12.04

1) Run these commands to install mysql (note the password you set when installing mysql server)
```
sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install libmysql-java
```
	
2) Edit your mysql configuration file
```
sudo gedit /etc/mysql/my.cnf
```
- port = 3309 (change all instances of port)
- bind-address = local VM ip


3) Restart the mysql service
```
sudo service mysql restart
```

4) Connect to mysql-server (use the password you set when installing mysql server)
```
mysql -u root -p
```

5) Create the database 'db' then exit
```
create database db;
```

6) Download the MySQL script files and run them (from terminal)
```
mysql -u root -p db < bbb_db_creation.sql
mysql -u root -p db < bbb_db_init.sql
mysql -u root -p db < bbb_db_sampleData.sql
```

7) Connect to mysql-server again
```
mysql -u root -p
```

8) Create a user for remote access to DB and grant privileges
```
create user 'senecaBBB'@'%' identified by 'db';
grant all on db.* to 'senecaBBB'@'%' IDENTIFIED by 'db';
```