Version 7 (modified by chase, 9 years ago)


Setting up ORCA database environment

NOTE: these instructions help set up an initial database environment for emulation mode. Extensions to these procedures for real substrate are discussed elsewhere.

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

4. Optionally add inventory (e.g., for emulation demo)

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

5. Alternative demo inventory: use with care. Instead of step 4, load this file instead:

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