Version 13 (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 (full.schema.sql and full.data.sql). Either download these files from these links, or if you have downloaded full ORCA source, you can get it there (assuming $ORCA_SRC points to the root of downloaded ORCA source tree). The order in which they are loaded into MySQL is important:

$ mysql -u orca < $ORCA_SRC/core/schema/mysql/full.schema.sql
$ mysql -u orca < $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