Hi Natalia I have done the below but still the ETL Job fails
mysql> GRANT ALL on mydatabase.* to 'admin'@'localhost' identified by 'password'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL on mifosdw.* to 'admin'@'localhost' identified by 'password'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL on mifosdw.* to 'mifos'@'localhost' identified by 'mifos'; Query OK, 0 rows affected (0.00 sec) But I also tried to change the local.properties to below are the ETL job now fails with the error of "Maximum number for connections for user mifos" > > main.database=mydatabase > > main.database.host=localhost > > main.database.port=3306 > > main.database.user=mifos > > main.database.password=mifos > > main.database.dbPentahoDW=mifosdw On Jan 3, 1:32 pm, Natalia Szpręga <[email protected]> wrote: > Hi Thomas, > > you have no access to database. Default in local.properties should be: > > main.database.user=mifos > main.database.password=mifos > > Did you created your database with user /admin/ and password /password/? > > If yes, did you grant permissions to your database using following command: > > GRANT ALL on mydatabase.* to 'admin' identified by 'password'; > > Regards, > Natalia > > On 03/01/13 09:40, 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] > >https://lists.sourceforge.net/lists/listinfo/mifos-users > > -- > MifCloud support > > Website:www.mifcloud.com > Facebook:www.facebook.com/MifCloud > Twitter:www.twitter.com/mif_cloud > > Phone: (+48) 58 782 45 40 > Fax: (+48) 58 782 45 41 > Email: [email protected] > > ------------------------------------------------------------------------------ > 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]https://lists.sourceforge.net/lists/listinfo/mifos-users ------------------------------------------------------------------------------ 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] https://lists.sourceforge.net/lists/listinfo/mifos-users
