Tomcat5.0 + mysql configuration JDBCREALM, DBCP, SSL resolve detailed

Preparation environment:

1.J2SDK-1_4_2-windows-i586.exe // jdk

2.Mysql-4.0.20d-win.zip // mysql database

3.Mysqlcc-0.9.4-win32.zip // mysqlgui control

4.Jakarta-Tomcat-5.0.27.exe // Tomcat server

5.Mysql-connector-java-3.0.14-Production.zip // Contains MYSQL driver

installation steps:

Install JDK

2. Install Tomcat

3. Install MySQL

4. Install mysqlcc

5. Packets will be driven, copy mysql-connector-java-3.0.14-production-bin.jar to tomcat / common / lib

Or download mm.mysql-2.0.14-you-must-unjar-me.jar, copy the mm.mysql-2.0.14-bin.jar after decompression

Tomcat5.0 configuration This example uses the installation password 198277

1. Configure the Manager management application

In Conf / Server.xml

Add as follows

...

DocBase = "/ usr / local / kinetic / tomcat5 / server / webapps / manager">

Restrict IP access configuration

DocBase = "/ usr / local / kinetic / tomcat5 / server / webapps / manager">

Allow = "127.0.0.1" />

Test is: http: // localhost: 8080 / manager / html

2. Configure the JDBCREALM container management security, take the mysql-4.0 database as an example.

a. Copy drive mm.mysql-2.0.14-bin.jar to Common / LIB /

b. Construction table in database YCG

Create Table Users

User_name varchar (15) Not Null Primary Key,

User_pass varchar (15) Not null

);

Create Table User_Roles

User_name varchar (15) NOT NULL,

Role_name varchar (15) NOT NULL,

PRIMARY Key (user_name, role_name)

);

c. Modify Server.xml as follows (the default database is root, no password, if tangible, if: connectionURL = "JDBC: mysql: // localhost / authority?

User = dbuser & password = dbpass ")

Drivername = "org.gjt.mm.mysql.driver" ConnectionURL = "JDBC: mysql: // localhost / ycg? user = root"

ConnectionName = "" ConnectionPassword = "

UserTable = "Users" usernamecol = "user_name" usercredcol = "user_pass"

Userroletable = "user_roles" ROLENAMECOL = "role_name" />

d. Add the default configuration data of Tomcat in the database:

---------

---------

| User_name | role_name |

---------

---------

| admin | admin |

| admin | manager |

| BOTH | ROLE1 |

| BOTH | Tomcat |

| role1 | role1 |

Tomcat | Tomcat |

---------

---------

---------

---------

| User_name | User_pass |

---------

---------

Tomcat | Tomcat |

| BOTH | Tomcat |

| role1 | Tomcat |

| admin | 198277 |

---------

---------

e. Start MySQL, start Tomcat, then Tomcat will read the user rule authentication from the database. Default conf / Tomcat-users.xml failure

3.DBCP configuration

a. set

removeabandoned

True

Re-enable the data connection of the failure.

Setup

removeabandonedTimeout

60

Failure time

If you want to write a log

Set

logabandoned

True

The above three defaults are False

b. Take MySQL as an example, configure data connection pool

c. Configure new users and databases, must set passwords, empty password will result in connection failure

e.

Specify root password: mysqladmin -u root -h localhost password "198277"

(You need to modify the above JDBCREALM settings ConnectionURL = "JDBC: mysql: // localhost / ycg? User = root & password = 198277")

Command mysql enters anonymous connection to the server

Password access

Shell> mysql -h host -u user -p

ENTER password: ********

// If root has no password, the following is unsuccessful. (Tried)

Mysql> grant all privileges on *. * to javauser @ localhost-> identified by 'javadude' with grant option;

Mysql> Create Database Javates

Mysql> Use javatest;

Mysql> Create Table TestData

-> ID INT NOT NULL AUTO_INCREMENT Primary Key,

-> foo varchar (25),

-> bar int);

Add in in Conf / Server.xml

Debug = "5" reloadable = "true" crossContext = "true">

prefix = "localhost_dbtest_log." suffix = ". txt"

TimeStamp = "true" />

Auth = "container"

TYPE = "javax.sql.datasource" />

factory

org.apache.commons.dbcp.basicDataSourceFactory

Configure your mysqld max_connections large enough to handle

All of Your DB Connections. Set to 0 for no limit.

->

maxactive

100

Set to 0 for no limit.

->

maxidle

30

IN ms, in this example 10 seconds. An Exception Is Thrown IF

THIS TIMEOUT IS EXCEEDED. SET to -1 to wait indefinitely.

->

maxWait 10000

Username

javauser

Password

javadude

If you want to use tris driver - We Recommend Using Connector / J Though

driverclassname

Org.gjt.mm.mysql.driver

->

driverclassname

com.mysql.jdbc.driver

The autoreconnect = true argument to the url makess sure what

MM.MYSQL JDBC Driver Will Automatically Reconnect IF MySQLD CLOSED THE

.

->

URL

jdbc: mysql: // localhost: 3306 / javatest? AutoreConnect = true

removeabandoned

True

removeabandonedTimeout

60

logabandoned

True

f. Call in the web service. Configure web.xml such as:

XSI: SchemAlocation = "http://java.sun.com/xml/ns/j2ee

Http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd "

Version = "2.4">

MySQL Test App

DB Connection

JDBC / TESTDB

javax.sql.datasource

container

g. Test Test.jsp

<% @ Taglib Uri = "http://java.sun.com/jsp/jstl/sql" prefix = "SQL"%>

<% @ Taglib Uri = "http://java.sun.com/jsp/jstl/core" prefix = "c"%>

Select ID, Foo, Bar from testdata