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
    facetracknoir
    facetracknoir
    Modular headtracking program that
    supports multiple face-trackers, filters
    and game-protocols. Among the trackers
    are the SM FaceAPI, AIC Inertial Head
    Tracker ...
    Download facetracknoir
  • 2
    PHP QR Code
    PHP QR Code
    PHP QR Code is open source (LGPL)
    library for generating QR Code,
    2-dimensional barcode. Based on
    libqrencode C library, provides API for
    creating QR Code barc...
    Download PHP QR Code
  • 3
    Freeciv
    Freeciv
    Freeciv is a free turn-based
    multiplayer strategy game, in which each
    player becomes the leader of a
    civilization, fighting to obtain the
    ultimate goal: to bec...
    Download Freeciv
  • 4
    Cuckoo Sandbox
    Cuckoo Sandbox
    Cuckoo Sandbox uses components to
    monitor the behavior of malware in a
    Sandbox environment; isolated from the
    rest of the system. It offers automated
    analysis o...
    Download Cuckoo Sandbox
  • 5
    LMS-YouTube
    LMS-YouTube
    Play YouTube video on LMS (porting of
    Triode's to YouTbe API v3) This is
    an application that can also be fetched
    from
    https://sourceforge.net/projects/lms-y...
    Download LMS-YouTube
  • 6
    Windows Presentation Foundation
    Windows Presentation Foundation
    Windows Presentation Foundation (WPF)
    is a UI framework for building Windows
    desktop applications. WPF supports a
    broad set of application development
    features...
    Download Windows Presentation Foundation
  • More »

Linux commands

Ad