unable to connect to mysql db on localhost

[ilasno]

hello,
i'm running tomcat 5.0.16 on debian linux with webmin, which provides 
mysql.  i've created a test database, and set up a user with what i 
think are the proper permissions.  here's the datasource resource from 
the server.xml that's nested within a context:

<Resource name="jdbc/dbName" auth="Container" 
type="javax.sql.DataSource" />

     <ResourceParams name="jdbc/dbName">
       <parameter>
           <name>factory</name>
           <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
         </parameter>
       <parameter>
           <name>maxActive</name>
           <value>100</value>
         </parameter>
       <parameter>
           <name>maxIdle</name>
           <value>30</value>
         </parameter>
       <parameter>
           <name>maxWait</name>
           <value>10000</value>
         </parameter>
       <parameter>
           <name>username</name>
           <value>xxxxxx</value>
         </parameter>
       <parameter>
           <name>password</name>
           <value>xxxxxx</value>
         </parameter>
       <parameter>
           <name>driverClassName</name>
           <value>org.gjt.mm.mysql.Driver</value>
         </parameter>
       <parameter>
           <name>url</name>
           <value>jdbc:mysql://localhost/dbName?autoReconnect=true</value>
         </parameter>
       <parameter>
           <name>removeAbandoned</name>
           <value>true</value>
         </parameter>
       <parameter>
           <name>logAbandoned</name>
           <value>true</value>
         </parameter>
     </ResourceParams>
but when i try to access, i get this exception, taken from the logs for 
that context:

2004-06-08 19:18:24 AbandonedObjectPool is used 
([EMAIL PROTECTED])
  LogAbandoned: true
  RemoveAbandoned: true
  RemoveAbandonedTimeout: 300
org.apache.commons.dbcp.SQLNestedException: Cannot create 
PoolableConnectionFactory, cause:
java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. 
Is there a MySQL server running on the machine/port you are trying to 
connect to? (java.net.ConnectException)
   at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)

incidentally (or maybe not), i have other datasources configured pretty 
much identically that work fine for another context that are connecting 
to remote mysql servers.

any suggestions?
thanks for your time.
--
ilasno
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]