hello people,

I am trying to install Mifos BI 1.1, over a customized installation of
mifos,

main.database=mifos
main.database.host=localhost
main.database.port=3307
main.database.user=root
main.database.password= (No password)

when i reach the instruction level "Run the Datawarehouse ETL Job:" I
got the the following error;

C:\Program Files\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows>initia
lise_datawarehouse.bat

C:\Program Files\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows>SET PD
IPATH=data-integration\

C:\Program Files\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows>SET DW
PATH=ETL\MifosDataWarehouseETL\

C:\Program Files\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows>SET DW
DB=mifos_dw

C:\Program Files\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows>echo D
ROP DATABASE IF EXISTS mifos_dw;  1>dropdb.sql

C:\Program Files\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows>echo C
REATE DATABASE mifos_dw;   1>createdb.sql

C:\Program Files\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\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\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows>mysql
-uroot -pmysql mifos_dw  0<ETL\MifosDataWarehouseETL
\load_mifos_datawarehouse.sq
l
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: Y
ES)

C:\Program Files\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows>rem no
t until bi 1.2 mysql -uroot -pmysql mifos_dw < ETL
\MifosDataWarehouseETL\load_mi
fos_datawarehouse_stored_procedures.sql

C:\Program Files\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows>mysql
-uroot -pmysql mifos_dw  0<ETL\MifosDataWarehouseETL
\load_ppi_poverty_lines.sql

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: Y
ES)

C:\Program Files\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows>mysql
-uroot -pmysql mifos_dw  0<ETL\MifosDataWarehouseETL
\load_dw_ppi_survey.sql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: Y
ES)

C:\Program Files\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows>data-i
ntegration\kitchen.bat /file:../ETL\MifosDataWarehouseETL
\DataWarehouseInitialLo
ad.kjb /level:Basic  1>transformationLog_mifos_dw.log
[DS]Getting Connection for url: jdbc:mysql://localhost:3306/mifos?
useUnicode=tru
e&characterEncoding=UTF-8

C:\Program Files\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows>



when i went on to start the Pentaho server i got the following error.


C:\Program Files\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows\biserv
er-ce>start-pentaho.bat
DEBUG: Using JAVA_HOME
DEBUG: _PENTAHO_JAVA_HOME=C:\Program Files\Java\jdk1.6.0_24\bin
DEBUG: _PENTAHO_JAVA=C:\Program Files\Java\jdk1.6.0_24\bin\bin
\java.exe
The file C:\Program Files\Java\jdk1.6.0_24\bin/lib/tools.jar
cannot be found and is required.

C:\Program Files\install_mifos_bi_1_1_Windows
\pentaho_mifosbi_1_1_windows\biserv
er-ce>



PLEASE ADVICE!!

On May 7, 6:43 am, John Woodlock <john.woodl...@gmail.com> wrote:
> Natu,
>
> Yes, the shell scripts are missing from both the 1.1 and 1.0 links.  There
> is a 1.2 release coming up pretty soon and the process should incorporate
> these files.
>
> I've never built the mifosbi 1.1 on linux ubuntu so I've never gone through
> the installation process you are following (only done it on windows)
>
> But I did go to an ubuntu dev site where the 1.1. sh files are deployed and
> I have attached them in the zip.  I think the only one that matters for
> production usage is etl_build_prod.sh.
>
> Also the etl_build_prod.sh file is only needed to run a job to create data
> for data warehouse/PPI reports (about 1/2 of the deployed reports in 1.1.).
>  Even without the 'sh' files, you can follow the rest of the installation
> instructions and still get pentaho environment running with the other mifos
> schema reports to make sure the general installation works okay (and then
> sort out the sh files after).
>
> John
>
>
>
>
>
>
>
> On Fri, May 6, 2011 at 8:53 PM, Natu Lauchande <nlaucha...@gmail.com> wrote:
> > Hi All,
>
> > I am currently following the installation guide available in :
> >http://mifosforge.jira.com/wiki/display/MIFOS/Installing+Mifos+BI+1.1,
> > i am stuck in the following part:
>
> > Extract the files etl_build.sh, etl_build_prod.sh, ppi_build.sh to
> > $PDI_HOME:
>
> >              unzip -d $PDI_HOME mifos_bi-1.1.0.zip etl_build.sh
> > etl_build_prod.sh ppi_build.sh
>
> > The current build that i grabbed from :
>
> >https://ci.mifos.org/hudson/job/bi-1.1.x-archive/lastSuccessfulBuild/...
> > ,
> > has none of the files mentioned in the current installation guide.
>
> > Can anyone help me on how i can sort out this issue or a link to a
> > more updated guide.
>
> > Thanks,
>
> > Natu
>
> > ------------------------------------------------------------------------------
> > WhatsUp Gold - Download Free Network Management Software
> > The most intuitive, comprehensive, and cost-effective network
> > management toolset available today.  Delivers lowest initial
> > acquisition cost and overall TCO of any competing solution.
> >http://p.sf.net/sfu/whatsupgold-sd
> > _______________________________________________
> > Mifos-users mailing list
> > mifos-us...@lists.sourceforge.net
> >https://lists.sourceforge.net/lists/listinfo/mifos-users
>
>
>
>  bi1.1sh_files.zip
> 3KViewDownload
>
> ------------------------------------------------------------------------------
> WhatsUp Gold - Download Free Network Management Software
> The most intuitive, comprehensive, and cost-effective network
> management toolset available today.  Delivers lowest initial
> acquisition cost and overall TCO of any competing 
> solution.http://p.sf.net/sfu/whatsupgold-sd
>
> _______________________________________________
> Mifos-users mailing list
> Mifos-us...@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/mifos-users

------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network 
management toolset available today.  Delivers lowest initial 
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users

Reply via email to