doc: Mention SQLite.

[?]

Mar 9, 2011, 4:34 PM

HN7JDKV3DG4KYJHD6YWWRWGCNLUJQFI7EHRQBXZXWOM4QFGH275AC

Dependencies

[2] KBW3FDZ2 Merge remote branch 'remotes/origin/master'
[3] RQ4SOPS3 whitespace commit

Change contents

replacement in doc/manual/installation.xml at line 38

[2.1445]→[2.1445:1486](∅→∅)

<title>Creating database</title>

[2.1445]

[2.1486]

<title>Creating the database</title>
replacement in doc/manual/installation.xml at line 40

[2.1501]→[2.1501:1677](∅→∅)

Hydra stores its results in a PostgreSQL database. To setup a database with <emphasis>hydra</emphasis> as database name and username, issue the following commands:

[2.1501]

[2.1677]

Hydra stores its results in a database, which can be a
PostgreSQL or SQLite database. The latter is easier to
setup, but the former scales better.
</para>

<para>To setup a PostgreSQL
database with <emphasis>hydra</emphasis> as database name
and user name, issue the following commands:
replacement in doc/manual/installation.xml at line 53

[2.1920]→[2.1920:2014](∅→∅)

Note that <emphasis>$prefix</emphasis> is the location of Hydra in the nix store.

[2.1920]

[2.2014]

Note that <emphasis>$prefix</emphasis> is the location of
Hydra in the nix store.
</para>

<para>
For SQLite, the following command is all it takes to
create the database:

<screen>
cat $prefix/share/hydra/sql/hydra-sqlite.sql | sqlite3 /path/to/hydra.sqlite
</screen>
edit in doc/manual/installation.xml at line 65

[2.2030]

[2.2030]
replacement in doc/manual/installation.xml at line 70

[2.2341]→[2.2341:2433](∅→∅)

echo "INSERT INTO UserRoles(userName, role) values('root', 'admin');" | psql hydra</screen>

[2.2341]

[2.2433]

echo "INSERT INTO UserRoles(userName, role) values('root', 'admin');" | psql hydra
</screen>
For SQLite the same commands can be used, with
<command>psql hydra</command> replaced by
<command>sqlite3 /path/to/hydra.sqlite</command>.
</para>
replacement in doc/manual/installation.xml at line 77

[2.2434]→[2.2434:2716](∅→∅)

Hydra uses an environment variable to know which database should be used, and a variable which point to a location that holds some state. To set these
variables, add the following to the <emphasis>.profile</emphasis> of the user running the Hydra services.

[2.2434]

[2.2716]

<para>
Hydra uses an environment variable to know which database
should be used, and a variable which point to a location
that holds some state. To set these variables for a
PostgreSQL database, add the following to the
<filename>.profile</filename> of the user running the
Hydra services.
replacement in doc/manual/installation.xml at line 89

[2.2836]→[2.2836:2980](∅→∅)

Make sure that the <emphasis>HYDRA_DATA</emphasis> directory exists and is writable for the user which will run the Hydra services.

[2.2836]

[2.2980]

Make sure that the <emphasis>HYDRA_DATA</emphasis>
directory exists and is writable for the user which will
run the Hydra services. For a SQLite database, the
<varname>HYDRA_DBI</varname> should be set to something
like <literal>dbi:SQLite:/path/to/hydra.sqlite</literal>