EnglishFrenchSpanish

OnWorks favicon

oar-database - Online in the Cloud

Run oar-database in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command oar-database that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

PROGRAM:

NAME


oar-database - manage OAR database.

SYNOPSIS


oar-database --create [OPTIONS]

oar-database --drop [OPTIONS]

oar-database --upgrade [OPTIONS]

oar-database --reset [OPTIONS]

oar-database --check [OPTIONS]

DESCRIPTION


OAR uses a database for it's persitent data either using the MySQL or PostgreSQL backend
(see oar.conf). oar-database is provided to manage that database.

ACTIONS


--create
Create an OAR database: inject schema and default data and create users/roles.

--drop
Drop an existing OAR database and associated users/roles.

--upgrade
Upgrade an existing OAR database.

--reset
Reset an existing OAR database to the state of the fresh new one.

--check
Check that OAR database is accessible and up to date (schema version).

OPTIONS


General parameters
--conf=OAR_CONF_FILE
Define the OAR configuration file to use. By default /etc/oar/oar.conf is used. If
this file doesn't exist, the default parameters for each value are used.

--update-conf
The database parameters given in the command line are written to the OAR_CONF_FILE

-f,--force-sql
Force to continue the execution even if a SQL command fails

-y,--force-yes
Force oar-database to continue without prompt even if it could be harmful.

Database backend parameters
These parameters are only required by the --create and --drop actions.

--db-is-local
Use local admin account to execute command (PostgreSQL).

--db-admin-user=DB_ADMIN_USER
Set database backend admin username.

--db-admin-pass=DB_ADMIN_PASS
Set database backend admin password.

OAR database parameters
If not specified, OAR database parameters are taken from OAR_CONF_FILE. Please prefer
setting the configurations in that file instead of using these options.

--db-type=DB_TYPE
Database backend to use, mysql or Pg (for PostgreSQL).

--db-user=DB_USER
Set OAR username to access the database. Override the one set in OAR_CONF_FILE.

--db-pass=DB_PASS
Set OAR user password to access the database. Override the one set in OAR_CONF_FILE.

--db-host=DB_HOST
Set the database backend hostname. Override the one set in OAR_CONF_FILE.

--db-port=DB_PORT
Set the database backend TCP port. Override the one set in OAR_CONF_FILE.

--db-name=DB_NAME
Set OAR database name. Override the one set in OAR_CONF_FILE.

--db-ro-user=DB_RO_USER
Set OAR username for read-only access the database. Override the one set in
OAR_CONF_FILE.

--db-ro-pass=DB_RO_PASS
Set OAR user password for read-only access the database. Override the one set in
OAR_CONF_FILE.

-d,--debug
Activate the display of debugging information.

-h,--help
Display this help.

EXAMPLES


MySQL
First you need to specify the database parameters in /etc/oar/oar.conf. These parameters
will be used by oar-database.

To create a new database (assuming that the MySQL root password is PASS):

oar-database --create --db-admin-user root --db-admin-pass PASS

To upgrade an existing database:

oar-database --upgrade

PostgreSQL
First you need to specify the database parameters in /etc/oar/oar.conf. These parameters
will be used by oar-database. If your PostgreSQL database is on the local system, you can
use the --db-is-local option which will use PostgreSQL unix account (needs root
privileges).

To create a new database:

oar-database --create --db-is-local

To upgrade an existing database:

oar-database --upgrade

Advanced usages
To make some tests or to administrate several databases, you can also specify the sql
parameters on the command line. For example:

oar-database --create --db-type=Pg --db-host=HOST \
--db-user=oar --db-pass=PASS \
--db-admin-user=ADMIN_USER --db-admin-pass=ADMIN_PASS

will create the oar database and the oar user on the postgresql system hosted by HOST. The
user ADMIN_USER must have the right to create new databases and new roles on this system.

Use oar-database online using onworks.net services


Free Servers & Workstations

Download Windows & Linux apps

  • 1
    PostInstallerF
    PostInstallerF
    PostInstallerF will install all the
    software that Fedora Linux and others
    doesn't include by default, after
    running Fedora for the first time. Its
    easy for...
    Download PostInstallerF
  • 2
    strace
    strace
    The strace project has been moved to
    https://strace.io. strace is a
    diagnostic, debugging and instructional
    userspace tracer for Linux. It is used
    to monitor a...
    Download strace
  • 3
    gMKVExtractGUI
    gMKVExtractGUI
    A GUI for mkvextract utility (part of
    MKVToolNix) which incorporates most (if
    not all) functionality of mkvextract and
    mkvinfo utilities. Written in C#NET 4.0,...
    Download gMKVExtractGUI
  • 4
    JasperReports Library
    JasperReports Library
    JasperReports Library is the
    world's most popular open source
    business intelligence and reporting
    engine. It is entirely written in Java
    and it is able to ...
    Download JasperReports Library
  • 5
    Frappe Books
    Frappe Books
    Frappe Books is a free and open source
    desktop book-keeping software that's
    simple and well-designed to be used by
    small businesses and freelancers. It'...
    Download Frappe Books
  • 6
    Numerical Python
    Numerical Python
    NEWS: NumPy 1.11.2 is the last release
    that will be made on sourceforge. Wheels
    for Windows, Mac, and Linux as well as
    archived source distributions can be fou...
    Download Numerical Python
  • More »

Linux commands

Ad