Internet Express for Tru64 UNIX Version 6.10 Administration Guide (5900-1418, March 2011)

17 PostgreSQL Database and MySQL Administration......................................249
Installing PostgreSQL.............................................................................................................249
Starting and Stopping PostgreSQL Server.................................................................................249
Viewing the PostgreSQL Log File.............................................................................................250
Administering PostgreSQL Accounts.........................................................................................251
Important Files and Directories...........................................................................................251
Running the Postmaster Startup Script..................................................................................252
Using Existing PostgreSQL Accounts....................................................................................252
Setting up a Crontab Entry for Vacuuming Databases................................................................252
Scaling PostgreSQL...............................................................................................................256
MySQLadministrationAdministering MySQL..............................................................................258
Directories and Files Established by MySQL Installation.........................................................258
Starting and Stopping MySQL...........................................................................................258
Starting and Stopping the MySQL Server Using a Command Line..........................................259
MySQL Configuration Files................................................................................................259
MySQL Log Files..............................................................................................................259
Viewing the MySQL Error Log............................................................................................259
Viewing the MySQL General Log.......................................................................................259
18 BIND Domain Name Server Administration..............................................260
BIND Overview....................................................................................................................260
Important BIND Files and Directories.......................................................................................260
Enabling BIND.....................................................................................................................262
Running the BIND Startup Script.............................................................................................263
BIND Documentation............................................................................................................263
19 Jabber.................................................................................................265
Controlling the Jabber Server.................................................................................................265
20 Twiki...................................................................................................266
Starting TWiki......................................................................................................................266
21 Stunnel................................................................................................267
Sample client server configuration...........................................................................................267
A Sendmail Supplemental Information..........................................................268
Creating a Certificate of Authority..........................................................................................268
Background - OpenSSL Certificate Creation..............................................................................268
Mail Filter Example...............................................................................................................269
Glossary..................................................................................................272
Index.......................................................................................................276
Contents 11