Kevin
If you edit file
pentaho_mifosbi_1_1_windows\data-integration\simple-jndi\jdbc.properties

you need to change 3306 to 3307 for the SourceDB and DestinationDB /url
settings.

Its possible you can take the port no. out altogether and it might default
to your 3307

This should get that etl job running.  I'll look at the 2nd bit in a while.


John

On Mon, May 9, 2011 at 5:38 PM, Kevin Kimani <kevmba...@googlemail.com>wrote:

> 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
>
------------------------------------------------------------------------------
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