Pervasive.SQL Account Management on Linux

---

This section outlines 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. 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 must be a member of the group pvsw to run the following utilities:
  • 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 client configuration (pvclientcfg) for functions other than displaying current configuration.

Configuring 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 executables, 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 fo 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/lib:$PVSW_ROOT/bin:/usr/lib 
LD_LIBRARY_PATH=$PVSW_ROOT/lib:$PVSW_ROOT/bin:/usr/lib 
MANPATH=$MANPATH:$PVSW_ROOT/man 
BREQ=$PVSW_ROOT/lib  
 
export USERNAME BASH_ENV PATH PVSW_ROOT LD_LIBRARY_PATH