[jira] [Commented] (FINERACT-1323) Unknown table 'table_names' in information_schema

["Andris (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FINERACT-1323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17293828#comment-17293828 ] 

Andris commented on FINERACT-1323:
----------------------------------

[~francisguchie] how did you solve that issue?

> Unknown table 'table_names' in information_schema
> -------------------------------------------------
>
>                 Key: FINERACT-1323
>                 URL: https://issues.apache.org/jira/browse/FINERACT-1323
>             Project: Apache Fineract
>          Issue Type: Bug
>    Affects Versions: 1.4.0
>            Reporter: Andris
>            Priority: Major
>
> I have the same problem as FINERACT-1276. I try to run Fineract 1.4.0 and I'm getting this exception:
> org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.apache.fineract.infrastructure.core.boot.WebXmlConfiguration': Unsatisfied dependency expressed through field 'basicAuthenticationProcessingFilter'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'basicAuthenticationProcessingFilter' defined in file [C:\apache-tomcat-7.0.108\webapps\fineract-provider\WEB-INF\classes\org\apache\fineract\infrastructure\security\filter\TenantAwareBasicAuthenticationFilter.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.security.authenticationManager': Cannot resolve reference to bean 'customAuthenticationProvider' while setting constructor argument with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'customAuthenticationProvider' defined in URL [file:/C:/apache-tomcat-7.0.108/webapps/fineract-provider/WEB-INF/classes/META-INF/spring/securityContext.xml]: Cannot resolve reference to bean 'userDetailsService' while setting bean property 'userDetailsService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userDetailsService': Unsatisfied dependency expressed through field 'platformUserRepository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'appUserRepository' defined in org.apache.fineract.useradministration.domain.AppUserRepository defined in : Cannot create inner bean '(inner bean)#1d793af0' of type [org.springframework.orm.jpa.SharedEntityManagerCreator] while setting bean property 'entityManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#1d793af0': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantDatabaseUpgradeService': Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SHOW TABLES LIKE 'schema_version';]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'table_names' in information_schema
> Query being executed when exception was thrown:
> SHOW FULL COLUMNS FROM `information_schema`.`TABLE_NAMES`
> My jdbc.properties:
> DRIVERCLASS_NAME:com.mysql.jdbc.Driver
> PROTOCOL:jdbc
> SUB_PROTOCOL:mysql:thin
> fineract_tenants_driver:com.mysql.jdbc.Driver
> fineract_tenants_url:jdbc:mysql://localhost:3306/fineract_tenants
> fineract_tenants_uid:root
> fineract_tenants_pwd:mysql
> MySql version: 5.7.8.0-rc
> jdbc version: 5.6.9.0-rc



--
This message was sent by Atlassian Jira
(v8.3.4#803005)