Sorry, had not seen Natalia's post,
if the user 'Admin' is accessing from another host, you can specify the
host name in the grant command or specify any host which is not advisable
e.g.
mysql> GRANT ALL on mydatabase.* to 'admin'@'192.168.1.34' identified by
'password'; (computer with the IP address specified)
or
mysql> GRANT ALL on mydatabase.* to 'admin'@'%' identified by 'password';
(any host)
on the same line, . . .using a GUI like MySQL Workbench, SQLyog or
phpMyAdmin would make it easier for you to manage permissions
hope this helps
Regards
Michael
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
