Email or Password invalid, please verify

[bantibaghel]

Hi, I am facing authentication issue at login time. I am using jdbcauthentication. Email and password are available in db and both users-query and roles-query are working perfectly but email and password does not get match or I think not get from login page. I do not know how it is authenticate. Please help me as soon as possible.

Thanks, Banti kumar

@Value("${spring.queries.users-query}") private String usersQuery;

@Value("${spring.queries.roles-query}")
private String rolesQuery;

@Override
protected void configure(AuthenticationManagerBuilder auth) throws Exception {
	// TODO Auto-generated method stub
	auth.jdbcAuthentication()
	    .usersByUsernameQuery(usersQuery)
	    .authoritiesByUsernameQuery(rolesQuery)
	    .dataSource(dataSource)
	    .passwordEncoder(bCryptPasswordEncoder);	
}

@Override
protected void configure(HttpSecurity http) throws Exception {
	http.authorizeRequests()
	              .antMatchers("/").permitAll()
	              .antMatchers("/login").permitAll()
	              .antMatchers("/registration").permitAll()
	              .antMatchers("/admin/**").hasAnyAuthority("ADMIN").anyRequest()
	              .authenticated().and().csrf().disable().formLogin()
	              .loginPage("/login").failureUrl("/login?error=true")
	              .defaultSuccessUrl("/admin/home")
	              .usernameParameter("email")
	              .passwordParameter("password")
	              .and().logout()
	              .logoutRequestMatcher(new AntPathRequestMatcher("/logout"))
	              .logoutUrl("/").and().exceptionHandling()
	              .accessDeniedPage("/beacon/user/access-denied");			
	
}

@Override
public void configure(WebSecurity web) throws Exception {
	web.ignoring()
	   .antMatchers("/resources/**","/static/**","/css/**","/js/**","/images/**");
}

[reborne]

Greetings! You've mentioned: "I am using jdbcauthentication. Email and password are available in db and both users-query and roles-query are working perfectly"

In what type does password stores in your database (plain-style password(e.g "abcdefg") or encrypted?)

[bantibaghel]

Thanks for your precious response. My problem has been resolved.

Regards, Banti Kumar

On Nov 30, 2017 19:53, "Artyom Ulanchik" [email protected] wrote:

Greetings! You've mentioned: "I am using jdbcauthentication. Email and password are available in db and both users-query and roles-query are working perfectly"

In what type does password stores in your database (plain-style password(e.g "abcdefg") or encrypted?)

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/hellokoding/registration-login-spring-hsql/issues/5#issuecomment-348201893, or mute the thread https://github.com/notifications/unsubscribe-auth/AO9SEfEPFBhQaRFsKNMhjSYT6KhdP17xks5s7rpPgaJpZM4QkMm8 .

[Rajborwade12]

how to mute the thread i have also same problem