JDBCRealm - can't make it work

[Dipankar Sinha <di...@stssoftware.com>]

Hello Sir,

I am trying to use Tomcat-3.2.1 and Apache_1.3.14 with MySQL-3.23.31 under RedHatLinux 6.2
Tomcat, Apache and MySQL are basically working fine and jdk1.3 is installed under /usr/java. I have to make Tomcat accessing data from MySQL (name of database is test) and I am having lack of understanding how to properly setup MM.MySQL. Please help.

I have tried as follows:

1. Modified $TOMCAT_HOME/conf/server.xml to add following lines:
        <RequestInterceptor
            className="org.apache.tomcat.request.JDBCRealm"
            debug="99"
            driverName="org.gjt.mm.mysql.Driver"
            connectionURL="jdbc:mysql://localhost/test?user='';password=''"
            />
2. Unpacked mm.mysql.jdbc-1.2c.tar.gz under /opt 
3. Have set up CLASSPATH as /opt/mm.mysql.jdbc-1.2c
4. Copied both mysql_comp.jar or mysql_uncomp.jar (one at a time) to $TOMCAT_HOME/lib

Now my questions are:
    a) Do I need a separate software as DriverManager? if yes which is suitable one in my case?
    b) Do I need to set up any connection separately to the MySQL database? How?
    c) Do I need JDBCrealm.class in a specific path? How can I get the file?

When I am trying to access my webpages under Tomcat, I am getting an error message on the console as: java.sql.SQLException: No suitable driver
When I am trying to access MySQL through my Tomcat webpages or trying to stop Tomcat, I am also getting java.lang.NullPointerException

Can I get some help? 
Thanks a million in advance.

Dipankar