Hi Thomas,
Just a suggestion
Check permissions and privileges of the user 'Admin' on the database, and
grant as needed
On Thursday, 3 January 2013 11:40:02 UTC+3, Thomas (Uganda) wrote:
>
> Hello
>
> I am try to populate the 11 Reports Datawarehouse But the ETL Job
> fails with the error below.
>
> This is my local.properties
>
> main.database=mydatabase
> main.database.host=localhost
> main.database.port=3306
> main.database.user=admin
> main.database.password=password
> main.database.dbPentahoDW=mifosdw
>
>
> I also created a user
> User = mifos
> password = mifos
>
> But the ETL Job fails with the error below
>
> Any pointer to what i cud be missing
> Tx
>
> ******************************************************************
> INFO 03-01 11:29:54,859 - Using "C:\Windows\TEMP\vfs_cache" as
> temporary files store.
> INFO 03-01 11:29:55,156 - Data Warehouse Initial Load - Start of job
> execution
> INFO 03-01 11:29:55,156 - Data Warehouse Initial Load - Starting
> entry [Log Start Entry for Initial Load]
> INFO 03-01 11:29:55,156 - Log Start Entry for Initial Load - Loading
> transformation from XML file [file:///C:/Program Files/Apache Software
> Foundation/Tomcat 6.0/webapps/config/ETL/MifosDataWarehouseETL/
> InitialLoadLogStartEntry.ktr]
> INFO 03-01 11:29:55,265 - Initial Load Log Start Entry - Dispatching
> started for transformation [Initial Load Log Start Entry]
> INFO 03-01 11:29:55,281 - Initial Load Log Start Entry - This
> transformation can be replayed with replay date: 2013/01/03 11:29:55
> [DS]Getting Connection for url: jdbc:mysql://localhost:3306/mifosdw?
> useUnicode=true&characterEncoding=UTF-8
> [DS]Getting Connection for url: jdbc:mysql://localhost:3306/mifosdw?
> useUnicode=true&characterEncoding=UTF-8
> ERROR 03-01 11:29:55,359 - Set ETL start time and complete to date - A
> database error occurred, stopping everything:
> Error occured while trying to connect to the database
>
> Invalid JNDI connection DestinationDB : Access denied for user
> 'admin'@'localhost' (using password: YES)
>
> ------------------------------------------------------------------------------
>
>
> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. ON SALE this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122712
> _______________________________________________
> Mifos-users mailing list
> [email protected] <javascript:>
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
