This looks fine to me. Now you might hope any other folks might spot something 
weird that I couldn't. 

Best,
D.

Sent from my iPhone

> On Jul 17, 2014, at 22:00, "jason" <ja...@metroworks.co.jp> wrote:
> 
> 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: 
> dmitriy.kopyle...@gmail.com
> To unsubscribe, change settings or access archives, see 
> http://www.ja-sig.org/wiki/display/JSG/cas-user

-- 
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

Reply via email to