Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Bean
- public DataSource dataSource() throws URISyntaxException {
- URI dbUri = new URI(System.getenv("CLEARDB_DATABASE_URL"));
- String username = dbUri.getUserInfo().split(":")[0];
- String password = dbUri.getUserInfo().split(":")[1];
- String dbUrl = "jdbc:mysql://eu-cdbr-west-
- 01.cleardb.com:3306/heroku_eb3825f7cae7006?reconnect=true";
- DriverManagerDataSource dataSource = new DriverManagerDataSource();
- dataSource.setUrl(dbUrl);
- dataSource.setUsername(username);
- dataSource.setPassword(password);
- return dataSource;
- }
- Hibernate:
- : select
- : user0_.id as id1_1_,
- : user0_.enabled as enabled2_1_,
- : user0_.password as password3_1_,
- : user0_.username as username4_1_
- : from
- : lashes.users user0_
- : where
- : user0_.username=?
- : 2018-01-04 15:19:48 [http-nio-35848-exec-9] WARN :: SQL Error: 1142, SQLState: 42000
- : 2018-01-04 15:19:48 [http-nio-35848-exec-9] ERROR:: SELECT command denied to user 'bd427bc263a111'@'ip-10-84-26-33.eu-west-1.compute.internal' for table 'users'
- : 2018-01-04 15:19:48 [http-nio-35848-exec-9] ERROR:: An internal error occurred while trying to authenticate the user.
- : org.springframework.security.authentication.InternalAuthenticationServiceException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
- :at org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:126)
- :at org.springframework.security.authentication.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:144)
- :at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:174)
- :at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:199)
- :at org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter.attemptAuthentication(UsernamePasswordAuthenticationFilter.java:94)
- :at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:212)
- :at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
- :at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
- :at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
- :at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:124)
- :at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- : Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
- : at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:261)
- : at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:244)
- : at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:488)
- : at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
- : at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
- : at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
- : at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
- : at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
- : at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
- at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
- at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
- 2018-01-04T15:19:48.984999+00:00 app[web.1]: at com.sun.proxy.$Proxy55.findByUsername(Unknown Source)
- at com.lashes.services.CustomUserDetailsService.loadUserByUsername(CustomUserDetailsService.java:28)
- : at org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:114)
- Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
- Caused by: java.sql.SQLSyntaxErrorException: SELECT command denied to user 'bd427bc263a111'@'ip-10-84-26-33.eu-west-1.compute.internal' for table 'users'
Add Comment
Please, Sign In to add comment