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

Francis Guchie commented on FINERACT-1276:
------------------------------------------

Yes [~vorburger] 
I was doing too many things at the same time. 
My root password was not the default ( this means for every launch i have to do 
some changes in the hikariDataSource file etc etc 
Also i was trying to test real-life production settings (security, firewalls 
etc) 

What i did 
1- I set mySql root password the the usual default
2- Tested the build by running a fineract-provider.jar that provided me with 
more details on the error
3- Rebuilt the War and started tomcat on a test environment (came down from my 
high horse)

All went well so i am closing this issues 
but this is a good lesson learnt for me (hope it helps someone else)

> Unknown table 'TABLE_NAMES' in information_schema
> -------------------------------------------------
>
>                 Key: FINERACT-1276
>                 URL: https://issues.apache.org/jira/browse/FINERACT-1276
>             Project: Apache Fineract
>          Issue Type: Bug
>            Reporter: Francis Guchie
>            Assignee: Francis Guchie
>            Priority: Major
>
> After building the latest develop branch, I can not spring boot fineract i 
> get the error below
> *Error creating bean with name '(inner bean)#707f107c': 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`*
> *if you look at  
> org\apache\fineract\infrastructure\core\service\TenantDatabaseUpgradeService.java*
>  *line 133 this is where it all starts* 
> But i cannot figure out where the SHOW FULL COLUMNS FROM 
> `information_schema`.`TABLE_NAMES` line is 
>  



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

Reply via email to