Pervasive.SQL Account Management on Linux

This section discusses information on Linux user accounts with respect to operation of Pervasive.SQL.

After Installation Behavior

You must be logged in as user psql to run utilities (except for PCC). User psql has no password and can only be accessed through the root account by using the su command.

All Pervasive files have user:group ownership psql:pvsw

You must be logged in as root to run the start and stop scripts for the Pervasive.SQL engines.

You can run utilities on other user accounts if you add the necessary environment variables to the user .bash_profile or system /etc/profile as described in Using Utilities from Users Other than psql .

In addition to the instructions outlined in Using Utilities from Users Other than psql, users other than ROOT must be a member of the group pvsw to perform functionality with the following utilities:

Pervasive.SQL Control Center (PCC) to administer the local server.

License Administrator utility (clilcadm) for functions other than displaying current licenses.

Named Database Maintenance utility (dbmaint) for functions other than displaying current databases.

Pervasive Services Registry Editor (psregedit) for functions other than displaying the registry.

Linux command-line configuration (bcfg).

The Java Runtime Environment (JRE) is required to use the Pervasive.SQL JavaHelp documentation. The Pervasive.SQL documentation installation detects whether a compatible JRE is present. If not, you must manually install the JRE before you can install the JavaHelp documentation.

The User Environment

The single environment variable $PVSW_ROOT is used to determine the location of installed components. The generic location for configuration files are $PVSW_ROOT/etc. For executable files, the location is $PVSW_ROOT/bin, and for shared libraries the location is $PVSW_ROOT/lib.

It is recommended that you add $PVSW_ROOT/bin to your PATH environment variable, and $PVSW_ROOT/lib to LD_LIBRARY_PATH as described in the following section.

Using Utilities from Users Other than psql

To use utilities from user accounts other than psql, you must first make modifications to the user account configuration. Add the following to either the profile for a specific user or to the profile that all users inherit.


`/home/`username`/.bash_profile.`	Profile for the user. Similar to the /etc/profile file but only for the current user. Look in /home/username for this file.
`/etc/profile`	Default profile for all user accounts on the system. Copy the lines below into this text file if you want all user accounts on the machine to have access to Pervasive.SQL utilities. This does not give the users administrative privileges or access to Pervasive.SQL data.

Here is an example of a modified profile:

PVSW_ROOT=/usr/local/psql 
PATH=$PATH:$PVSW_ROOT/bin:/bin:/usr/bin 
LD_LIBRARY_PATH=$PVSW_ROOT/lib:$PVSW_ROOT/bin:/usr/lib 
MANPATH=$MANPATH:$PVSW_ROOT/man 
BREQ=$PVSW_ROOT/lib 
LD_BIND_NOW=1

Ensure that you export all variables specific to Pervasive.SQL.