Project:
Osmius
Code Location:
https://osmius.svn.sourceforge.net/svnroot/osmius/trunk/trunk
README.txt
################################################################################## # Project : Osmius # Version : 10.04 # Date : 26-04-2010 # File : README.txt # Description: # Readme file for Osmius database creation. ################################################################################## 1.- Create the database and the Osmius main database user 'osmius' Connect to your MySql database with 'root' or some user with CREATE DATABASE and CREATE USER PRIVILEGES. (*) MySql version must be greater than 5.0.38 Example (Ubuntu): home/osmius> sudo mysql (or mysql -u root) Your MySQL connection id is 16 Server version: 5.0.38-Ubuntu_0ubuntu1.1-log Ubuntu 7.04 distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> source osm_create<VERSION>.sql 2.- Disconnect and connect with the new user 'osmius' mysql> exit; home/osmius> mysql -u osmius -p (*) Initial password is 'osmius'. Changing it is a good security practice. 3.- Create the Datamodel with 'osmius' user. Tables and Views. mysql> use osmius; mysql> source osm_datamodel<VERSION>.sql (*) If you see errors tell it to the community or if you are a registere, user call support. 4.- Create Stored Procedures and Triggers with 'osmius' user. mysql> source osm_procedures_triggers<VERSION>.sql 5.- Populate Osmius database with the initial data: mysql> source osm_initialdata_<VERSION>.sql 6.- Populate SNMP Tables: mysql> source osm_mibsdata10.04.sql mysql> source osm_oiddata10.04.sql That's it.
