[cas-dev] mysql+ cas 3.0.7+tomcat 5.5 -urgent help, please!!!

Edward Chen edwardc at wolfram.com
Thu Apr 10 16:14:38 EDT 2008


I installed Tomcat 5.5 in my PC and I installed CAS 3.0.7 (central 
Authentication Service) server and I installed MySql in my PC.

I following the instruction from 
http://www.ja-sig.org/wiki/display/CASUM/Using+JDBC+for+Authentication, 
and pick mysql connectivity

I want to configure MySQL to my Apache Tomcat. I modified a file 
deployerConfigContent.xml. Basically, insert the following section
...
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
 <property name="driverClassName">
  <value>com.mysql.jdbc.Driver</value>
 </property>
 <property name="url">
  <value>jdbc:mysql://localhost:3306/login</value>
 </property>
 <property name="username">
  <value>admusr</value>
 </property>
 <property name="password">
  <value>admpwd</value>
 </property>
</bean>
.....

After I re-run the tomcat, I cannot open the CAS, it says "CAS is 
Unavailable"

In this post, I don't plan you to understand CAS but a connectivity 
between MySQL and Tomcat. Can you see anything wrong above code?

I suspect the following with problem

I got confused this line "<bean id="dataSource" 
class="org.apache.commons.dbcp.BasicDataSource">"

After I open
C:\Program Files\Apache Software Foundation\Tomcat 5.5\common,

I don't see any folder and file for "dbcp.BasicDataSource"
So, how to modify this to connect to MySQL.

Also, I have root password for MySQL, should I modify

<property name="username">
  <value>admusr</value>
 </property>
 <property name="password">
  <value>admpwd</value>
 </property>

as

<property name="username">
  <value>root</value>
 </property>
 <property name="password">
  <value>xxxxx</value>
 </property>


??


More information about the cas-dev mailing list