Re:[cas-user] CAS Logging and CAS with MySQL

[jason]

Hi Dmitriy,

Thanks again for the help.

Below is the relevant config from deployerConfigContext.xml, with a few of the 
surrounding lines for context.  Although "passwordhash" appears in the sql 
statement, this is a plain text field in the db at the moment.

====================
    <!--
    <bean id="primaryAuthenticationHandler"
          class="org.jasig.cas.authentication.AcceptUsersAuthenticationHandler">
        <property name="users">
            <map>
                <entry key="casuser" value="Mellon"/>
            </map>
        </property>
    </bean>
    -->

    <!-- Our MySQL Auth Handler -->
    <bean id="primaryAuthenticationHandler" 
class="org.jasig.cas.adaptors.jdbc.QueryDatabaseAuthenticationHandler">
        <property name="dataSource" ref="dataSource" />
        <property name="sql" value="select passwordhash from users where 
lower(username) = lower( ? )" />
    </bean>

    <!-- MySQL connector -->
    <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/mydb</value>
        </property>
        <property name="username">
            <value>mydbuser</value>
        </property>
        <property name="password">
            <value>mydbpass</value>
        </property>
    </bean>

    <!-- Required for proxy ticket mechanism -->
    <bean id="proxyPrincipalResolver"
          class="org.jasig.cas.authentication.principal.BasicPrincipalResolver" 
/>
====================


Does this look correct?

Thanks!
-- 
You are currently subscribed to cas-user@lists.jasig.org as: 
arch...@mail-archive.com
To unsubscribe, change settings or access archives, see 
http://www.ja-sig.org/wiki/display/JSG/cas-user