I am facing an issue with my spring security ( version 4) at this moment.
org.springframework.security.authentication.InternalAuthenticationServiceException: Could not get JDBC Connection
Here is the AppConfig class:
@EnableWebMvc
@Configuration
@ComponentScan({ "controller" })
@Import({ SecurityConfig.class })
public class AppConfig {
@Bean(name = "dataSource")
public DriverManagerDataSource dataSource() {
System.out.println("-------- MySQL JDBC Connection Testing ------------");
System.out.println("JDBC Driver Found");
DriverManagerDataSource driverManagerDataSource = new DriverManagerDataSource();
driverManagerDataSource.setDriverClassName("com.mysql.jdbc.Driver");
driverManagerDataSource.setUrl("jdbc:mysql://localhost:3306/QSQL");
driverManagerDataSource.setUsername("root");
driverManagerDataSource.setPassword("password");
return driverManagerDataSource;
}
@Bean
public InternalResourceViewResolver viewResolver() {
InternalResourceViewResolver viewResolver = new InternalResourceViewResolver();
viewResolver.setViewClass(JstlView.class);
viewResolver.setPrefix("/WEB-INF/Pages/");
viewResolver.setSuffix(".jsp");
return viewResolver;
}
}
Here is my SecurityConfig class:
@Configuration
@EnableWebSecurity
public class SecurityConfig extends WebSecurityConfigurerAdapter {
@Autowired
DataSource dataSource;
@Autowired
public void configAuthentication(AuthenticationManagerBuilder auth) throws Exception {
System.out.println("begin Auth Process");
auth.jdbcAuthentication().dataSource(dataSource)
.usersByUsernameQuery(
"select username,password, enabled from QSQL.users where username=?")
.authoritiesByUsernameQuery(
"select username, role from QSQL.user_roles where username=?");
}
@Override
protected void configure(HttpSecurity http) throws Exception {
http.authorizeRequests()
.antMatchers("/admin/**").access("hasRole('ROLE_ADMIN')")
.and()
.formLogin().loginPage("/login").failureUrl("/login?error")
.usernameParameter("username").passwordParameter("password")
.and()
.logout().logoutSuccessUrl("/login?logout")
.and()
.exceptionHandling().accessDeniedPage("/403")
.and()
.csrf();
}
}
However I am getting the error mentioned above along with the following:
Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server.
Although I can connect to my database using the SQL explorer plugin.
Thanks for the help.
