Forwarding additional details to the mifos-users list as Thomas was
having troubles posting.
From: Thomas Ndugwa [mailto:[email protected]]
Sent: Thursday, May 19, 2011 9:48 AM
To: Edward Cable
Subject: Re: Deploying Mifos Business Intelligence Suite 1.1
To the Error am getting when Deploying BI SUITE 1.1
A)
I get the InItial error when Initializing Dataware House ETL Job of :
Access denied for user 'root'@'localhost' (using password: YES).
I hv attached Error Log (Error Log when intializing Dataware House ETL
Job.txt)
B)
So I then run the mifosbi_users.sql even with the password as
'password' but stil no luck with intializing dataware house ETL Job.
Any Pointer on what i could still be doing wrong
************************************************************************
************************************************************************
*********
create user 'hibuser'@'localhost' identified by 'password';
grant all on hibernate.* to 'hibuser'@'localhost' identified by
'password';
create user 'pentaho_user'@'localhost' identified by 'password';
grant all on quartz.* to 'pentaho_user'@'localhost' identified by
'password';
grant all on sampledata.* to 'pentaho_user'@'localhost' identified by
'password';
create user 'pentaho_admin'@'localhost' identified by 'password';
grant all on sampledata.* to 'pentaho_admin'@'localhost' identified by
'password';
create user 'mifosbi'@'localhost' identified by 'password';
grant all on mifos.* to 'mifosbi'@'localhost' identified by 'password';
grant all on mifos_dw.* to 'mifosbi'@'localhost' identified by
'password';
************************************************************************
************************************************************************
*******************
Ndugwa Thomas Henry
email: [email protected]
Skype: ndugwa2u
________________________________
From: Edward Cable <[email protected]>
To: A good place to start for users or folks new to Mifos.
<[email protected]>; [email protected];
[email protected]
Sent: Thu, May 19, 2011 5:07:22 PM
Subject: Fwd: Deploying Mifos Business Intelligence Suite 1.1
Thomas,
I'm forwarding this to our mifos users mailing list so our community can
help with a response.
Ed
-------- Original Message --------
Subject: Deploying Mifos Business Intelligence Suite 1.1
From: Thomas Ndugwa <[email protected]>
To: Edward Cable <[email protected]>
CC:
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>initialise_datawarehouse.bat
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>SET PDIPATH=data-integration\
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>SET DWPATH=ETL\MifosDataWarehouseETL\
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>SET DWDB=mifos_dw
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>echo DROP DATABASE IF EXISTS mifos_dw;
1>dropdb.sql
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>echo CREATE DATABASE mifos_dw; 1>creat
edb.sql
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>mysql -uroot -pmysql 0<dropdb.sql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>mysql -uroot -pmysql 0<createdb.sql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>mysql -uroot -pmysql mifos_dw 0<ETL\Mif
osDataWarehouseETL\load_mifos_datawarehouse.sql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>rem not until bi 1.2 mysql -uroot -pmysq
l mifos_dw < ETL\MifosDataWarehouseETL\load_mifos_datawarehouse_stored_procedure
s.sql
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>mysql -uroot -pmysql mifos_dw 0<ETL\Mif
osDataWarehouseETL\load_ppi_poverty_lines.sql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>mysql -uroot -pmysql mifos_dw 0<ETL\Mif
osDataWarehouseETL\load_dw_ppi_survey.sql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>data-integration\kitchen.bat /file:../ET
L\MifosDataWarehouseETL\DataWarehouseInitialLoad.kjb /level:Basic 1>transformat
ionLog_mifos_dw.log
[DS]Getting Connection for url: jdbc:mysql://localhost:3306/mifos?useUnicode=tru
e&characterEncoding=UTF-8
C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\install_mifos_bi_
1_1_Windows\pentaho_mifosbi_1_1_windows>
------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its
next-generation tools to help Windows* and Linux* C/C++ and Fortran
developers boost performance applications - including clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
