Page Comparison

...

1. Edit pentaho-spring-beans.xml to use a combination of LDAP and JDBC configuration files.

   Code Block
   xml xml title pentaho-spring-beans.xml
   <beans> <!-- some lines omitted --> <import resource="applicationContext-spring-security.xml" /> <import resource="applicationContext-common-authorization.xml" /> <import resource="applicationContext-spring-security-ldap.xml" /> <import resource="applicationContext-pentaho-security-jdbc.xml" /> </beans>

2. Open applicationContext-spring-security-ldap.xml. Replace the populator bean definition with the one below.

   Code Block
   xml xml title applicationContext-spring-security-ldap.xml
   <bean id="populator" class="org.springframework.security.ldap.populator.UserDetailsServiceLdapAuthoritiesPopulator"> <constructor-arg index="0"> <ref bean="userDetailsService" /> </constructor-arg> </bean>

3. Staying in the same file, remove the userDetailsService bean. (We're removing it to replace it later with the JDBC-based UserDetailsService implementation: JdbcDaoImpl.)

   Code Block
   xml xml title applicationContext-spring-security-ldap.xml
   <!-- removed userDetailsService bean -->

4. Open applicationContext-pentaho-security-jdbc.xml. Add the following two bean definitions. Both of these bean definitions were copied from applicationContext-spring-security-jdbc.xml. (One is the JDBC-based UserDetailsService implementation; the other is a bean required by that implementation.)

   Code Block
   xml xml title applicationContext-pentaho-security-jdbc.xml
   <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="org.hsqldb.jdbcDriver" /> <property name="url" value="jdbc:hsqldb:hsql://localhost:9002/userdb" /> <property name="username" value="sa" /> <property name="password" value="" /> </bean> <bean id="userDetailsService" class="org.springframework.security.userdetails.jdbc.JdbcDaoImpl"> <property name="dataSource"> <ref local="dataSource" /> </property> <property name="authoritiesByUsernameQuery"> <value> <![CDATA[SELECT username, authority FROM granted_authorities WHERE username = ?]]> </value> </property> <property name="usersByUsernameQuery"> <value> <![CDATA[SELECT username, password, enabled FROM users WHERE username = ?]]> </value> </property> </bean>