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