AnsweredAssumed Answered

JDBC Authentication Configuration not working. It is urgent

Question asked by hani on Aug 3, 2007
Latest reply on Aug 3, 2007 by hani
Hello All,

How can I use the users from my Application DB to authenticate in Alfresco. Other than SOS using NTLM.

For Implementing JDBC Authentication I have added the following to
"authentication-services-context.xml" file but still for authentication the alfresco table is using.
What I am misssing? Can Any on look on this…
*******************************
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName"><value>com.mysql.jdbc.Driver</value></property>
<property name="url"><value>jdbc:mysql://localhost:3307/alfresco</value></property>
<property name="username"><value>alfresco</value></property>
<property name="password"><value>alfresco</value></property>
</bean>

<bean id="jdbcDaoImpl" class="net.sf.acegisecurity.providers.dao.jdbc.JdbcDaoImpl">
<property name="dataSource" ref="dataSource"/>
<property name="usersByUsernameQuery">
<value>SELECT user_passwd from his_user where active_yesno=1 AND user_login=?</value>
</property>
<property name="authoritiesByUsernameQuery">
<value>SELECT DISTINCT 'hisuser','Roles' FROM his_user WHERE user_login=?</value>
</property>
<!– <property name="passwordEncoder" ref="passwordEncoder"/> –>
</bean>

******************************
regards,

–Hani

Outcomes