Version 10 (modified by ibaldin, 8 years ago)

--

Setting up ORCA database environment

Steps 0-3 are mandatory for a valid setup. Steps 4 and 5 are optional and only for the indicated releases.

0. Install and start mysql server. For example, on a Debian/Ubuntu Linux system:

bash:~$ sudo apt-get install mysql-server
bash:~$ sudo /etc/init.d/mysql stop
bash:~$ sudo /etc/init.d/mysql start

1. Create user 'orca' in mysql and grant it all privileges on database 'orca':

$ mysql -u root
mysql> grant all privileges on orca.* to orca;
mysql> grant all privileges on orca.* to orca@localhost;
mysql> flush privileges;

2. Create a database called 'orca'

mysql> create database orca;

3. Populate the database with initial state

$ mysql -u orca < [source:orca/trunk/core/schema/mysql/full.schema.sql $ORCA_SRC/core/schema/mysql/full.schema.sql]
$ mysql -u orca < [source:orca/trunk/core/schema/mysql/full.data.sql $ORCA_SRC/core/schema/mysql/full.data.sql]

4. Optionally add inventory (e.g., for emulation demo in Bella 2.0 and before)

$ mysql -u orca < $ORCA_SRC/core/schema/mysql/demo.inventory.sql

5. Optional Alternative demo inventory (e.g. for emulation demo in Bella 2.1 and before): use with care. Instead of step 4, load this file instead:

$ mysql -u orca < $ORCA_SRC/tools/cmdline/renci/demo2.inventory.sql