John, managed to change the Pentaho server address to an address similar to static i.p. for that machine. it seems to be working fine.
However, there are i few issues i will need your assistance on. 1. Both thee Mifos Transaction detail and summary return the "No Data Available" instead of actual transactions. 2. Creating user in pentaho: I will need assistance on creating users in pentaho. when i try to run the Administration Console "start-pac" i receive the following error; DEBUG: Using JAVA_HOME DEBUG: _PENTAHO_JAVA_HOME=C:\Program Files\Java DEBUG: _PENTAHO_JAVA=C:\Program Files\Java\bin\java.exe The system cannot find the path specified. please advice!! On Jun 6, 12:40 pm, John Woodlock <[email protected]> wrote: > Kevin > > sure, you can try the static ip to see if it works. > > The db port number edits aren't related to your production server but your > test server we tried first. > > John > > On Mon, Jun 6, 2011 at 7:24 PM, Kevin Kimani <[email protected]>wrote: > > > > > > > > > John, > > > Thanks for your insights. Sorry about the ambiguity in the question > > but nonetheless am glad you got what i was asking.PC > > > > <context-param> > > > <param-name>base-url</param-name> > > > <param-value>https://whatever.is.your.url/pentaho/</param-value> > > > </context-param> > > > we made the following change on the tomcat/pentaho/webapps/WEB-INF/ > > web.xml to 127.0.0.1:8086, because the localhost address was not > > working. is it possible > > to use the I.P. address (static) for the server i.e. > >http://10.10.10.10:8086 > > > Also, i might not need to change the port numbers for the DB. The > > production server uses to 3306. if this is the case, do i need to > > edit the following files?? > > > > pentaho-solutions/system/applicationContext-spring-security-jdbc.xml > > > pentaho-solutions/system/applicationContext-spring-security-hibernate.properties > > > /tomcat/webapps/pentaho/META-INF/context.xml > > > On Jun 6, 6:27 am, John Woodlock <[email protected]> wrote: > > > Kevin, > > > > need to include the port in the url as well as it isn't the default (I > > > missed it out) > > > >https://whatever.is.your.url:8086/pentaho/< > >https://whatever.is.your.url/pentaho/> > > > > On Mon, Jun 6, 2011 at 1:24 PM, John Woodlock <[email protected] > > >wrote: > > > > > Kevin > > > > > 1) Not 100% sure what you mean but I think you are trying to access > > pentaho > > > > from 'some other PC'. So I assume there is a url to get to the 'server > > pc'. > > > > You need to edit tomcat/pentaho/webapps/WEB-INF/web.xml (just like we > > did > > > > when localhost wasn't set up on the server PC) and do something like > > what > > > > follows: > > > > > <context-param> > > > > <param-name>base-url</param-name> > > > > <param-value>https://whatever.is.your.url/pentaho/</param-value> > > > > </context-param> > > > > > 2) as far as I know, there are no problems with mifos transactions > > detail > > > > and mifos transactions summary reports. What are you seeing? > > > > > 3) remember when your test server wasn't picking up hibuser at pentaho > > > > startup when you wanted to change the mysql port from 3306 to 3307? > > Well, > > > > we changed mifos jndi settings but we didn't change some other files > > that > > > > were impacted. If you want to try to fix this... edit the following > > files > > > > and change 3306 to 3307 (then start pentaho and see if okay) > > > > > pentaho-solutions/system/applicationContext-spring-security-jdbc.xml > > > pentaho-solutions/system/applicationContext-spring-security-hibernate.properties > > > > /tomcat/webapps/pentaho/META-INF/context.xml > > > > > John > > > > > On Fri, Jun 3, 2011 at 5:41 PM, Kevin Kimani <[email protected] > > >wrote: > > > > >> hi, > > > > >> Am having problems retrieving pentaho reports from remote PC. However, > > > >> the reports are working fine on the server(where the BI Suite is > > > >> installed). i am using the the following address 127.0.0.1:8086 to > > > >> access the reports on the server. > > > > >> also, is there any problems with these reports; mifos transactions > > > >> detail and mifos transactions summary? > > > ------------------------------------------------------------------------------ > > > Simplify data backup and recovery for your virtual environment with > > vRanger. > > > Installation's a snap, and flexible recovery options mean your data is > > safe, > > > secure and there when you need it. Discover what all the cheering's > > about. > > > Get your free trial download today.http://p.sf.net/sfu/quest-dev2dev2 > > > > _______________________________________________ > > > Mifos-users mailing list > > > [email protected]:// > > lists.sourceforge.net/lists/listinfo/mifos-users > > > ------------------------------------------------------------------------------ > > Simplify data backup and recovery for your virtual environment with > > vRanger. > > Installation's a snap, and flexible recovery options mean your data is > > safe, > > secure and there when you need it. Discover what all the cheering's about. > > Get your free trial download today. > >http://p.sf.net/sfu/quest-dev2dev2 > > _______________________________________________ > > Mifos-users mailing list > > [email protected] > >https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > ------------------------------------------------------------------------------ > Simplify data backup and recovery for your virtual environment with vRanger. > Installation's a snap, and flexible recovery options mean your data is safe, > secure and there when you need it. Discover what all the cheering's about. > Get your free trial download today.http://p.sf.net/sfu/quest-dev2dev2 > > _______________________________________________ > Mifos-users mailing list > [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users ------------------------------------------------------------------------------ EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
