JDBC Authentication Configuration not working. It is urgent

hani — Fri, 03 Aug 2007 04:58:50 GMT

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

Re: JDBC Authentication Configuration not working. It is urgent

hani — Fri, 03 Aug 2007 09:18:13 GMT

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

topic JDBC Authentication Configuration not working. It is urgent in Alfresco Archive

JDBC Authentication Configuration not working. It is urgent

Re: JDBC Authentication Configuration not working. It is urgent