7.1 Typical installation

Use setuid programs to eliminate problems with permissions. Texis works best if all processes accessing the database run as the same user. Making the programs setuid is the best way of ensuring that on Unix systems. The most common programs you should be using are all symlinks to the monitor executable, which makes the task much easier. The only exception is if you are running our webserver, vhttpd, which typically must be started as root to bind to port 80, and needs the correct userid set in the config file. Having the programs all running as the same userid means the database can be owned by that user, and only that user needs read and write permissions on the directory and files.

 

The most common programs you will use are texis for running scripts, and tsql for issuing ad-hoc SQL. Other useful commands are timport for importing data, creatdb for creating a database, ltest, which shows the status of the locks.

Back: Performance and Installation Notes Next: Texis parameters
Copyright © 2024 Thunderstone Software LLC. All rights reserved.