Clarification of Answer by
readersguide-ga
on
03 Jul 2002 13:24 PDT
Hi again Danny,
As promised I did some additional digging. Here's what I found:
This page from InstantSSL gives step-by-step instructions for
Installing your Certificate on Apache Mod_SSL. It includes information
on Intermediate Certificates as well.
http://www.instantssl.com/support/cert_installation/mod_ssl.html
Verisign also has instructions
http://www.verisign.com/support/install/apache/v00Mod.html
Search terms in Google:
intermediate certificates mod_ssl
://www.google.com/search?sourceid=navclient&q=intermediate+certificates+mod%5Fssl
For password setup, Essenz Consulting offers a Comprehensive Guide to
Building Apache on FreeBSD and Linux
http://www.essenz.com/support/apache.html
Brief contents are:
1. Getting Started
2. Downloads
3. Building MySQL
4. Building PHP
5. Building SSL
6. Building mod_perl
7. Building Apache
Developer Shed had the following. It presumes the use of MySQL tables.
You didn't mention those details, so if this is incorrect, my
apologies.
http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/page6.html
Directions:
Now it is time to create the mysql tables used to define the
permissions. Make sure you replace "new-password" with something of
your choice, otherwise, new-password will be your root password.
--------------------------------------------------------------------------------#
scripts/mysql_install_db
# cd /usr/local/mysql/bin
# ./safe_mysqld &
# ./mysqladmin -u root password 'new-password'
--------------------------------------------------------------------------------
You can ensure that MySQL is working by running some simple tests to
verify that the server is working. The output should be similar to
what is shown below:
--------------------------------------------------------------------------------
# BINDIR/mysqlshow -p
Enter password: + -------------------- +
| Databases |
+ -------------------- +
| mysql |
+ -------------------- +
--------------------------------------------------------------------------------
Once you install MySQL, it will automatically create two databases.
One is the mysql table which controls users, hosts, and database
permissions in the actual server. The other is a test database. We
could use the test database, however, we want to give you a quick and
simple overview of some of the command line options available with
MySQL. Also, this will ensure that root has been set up with full
access to the database server (i.e. root has permission to create
databases, tables, etc.) We will create a "test2" database that we
will use later for our testing after logging into the MySQL server.
--------------------------------------------------------------------------------
#mysql -u root -p
Enter password:
mysql> show databases; + -------------------- +
| Database |
+ -------------------- +
| mysql |
| test |
+ -------------------- +
2 rows in set (0.00 sec)
mysql> create database test2;
Query OK, 1 row affected (0.00 sec)
--------------------------------------------------------------------------------
Now select the test2 database, and create a new table called tst_tbl,
with the two following fields. Field 1, which is an id field which
lets you know the id of the record. Essentially, this is just a row
number for simplicity. The second field is a name field in which you
will store name information about books. The formats for these fields
are.. field 1 (id) is an integer (int) of length 3, and field 2 (name)
is a character (char) field of length 50. We assign id to be the key
for searching and indexing the data.
y NOTE: MySQL commands are not case-sensitive. For example, CREATE and
cReatE will be interpreted the same way. Also, remember to add a
semi-colen after your commands.
--------------------------------------------------------------------------------
mysql> use test2;
Database changed
mysql> CREATE TABLE books (
-> id int(3) not null auto_increment,
-> name char(50) not null,
-> unique(id),
-> primary key(id)
-> );
Query OK, 0 rows affected (0.00 sec)
--------------------------------------------------------------------------------
Now we can verify that indeed everything is correct with the following
commands.
--------------------------------------------------------------------------------
mysql> show tables; + ------------------------------ +
| Tables in text2 |
+ ------------------------------ +
| books |
+ ------------------------------ +
1 row in set (0.00 sec)
mysql> describe books; + ------- + ------------- + ------ + ------ +
---------- + ------------------------ +
| Field | Type | Null | Key | Default | Extra |
+ ------- + ------------- + ------ + ------ + ---------- +
------------------------ +
| id | int(3) | | PRI | 0 | auto_increment |
| name | char(50) | | | | |
+ ------- + ------------- + ------ + ------ + ---------- +
------------------------ +
2 rows in set (0.00 sec)
Search terms in Google:
password setup mod_ssl
://www.google.com/search?sourceid=navclient&q=password+setup++mod%5Fssl
password file mod_ssl
://www.google.com/search?sourceid=navclient&q=password+file++mod%5Fssl
The links in the "password file mod_ssl" list seem to have
instructions for compiling for Microsoft Windows, Mac OS X which may
be of use if you are using something other than Linux. (For the
clarification of Worth-GA).
Since I didn't hear anything further from you Danny, I presume that
you ARE using some flavor of Linux, however, it is NOT a requirement.
I hope these instructions are what you were looking for. My initial
search was based on the information you offered regarding a need for
client certificates, but I'm happy to provide further searches to get
what you need.
Regards,
readersguide
