Joinutility seperatorLogin utility separator Infobright.com
   
 
connect for admin console very slow
Posted: 04 August 2009 04:09 AM   Ignore ]  
Newbie
Rank
Total Posts:  5
Joined  2009-07-28

I had reported a problem where I said I could not connect to admin console.
But infact it is that it is extreamely slow at comming with a valid screen on which I can for example add a datasource.
I have two installations one at home and one at office and they both have this exceeding long delay in connecting to admin console.

Appears to be alot of
Aug 3, 2009 9:30:30 AM org.apache.commons.httpclient.HttpMethodDirector executeWithRetry
INFO: Retrying request

Any ideas, this should be repeatable I am using unmodified VM appliance.

Here is some of typical console log :-

INFO: indexes: [sys_idx_54]
Aug 3, 2009 9:27:49 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: table found: PUBLIC.USER_SETTINGS
Aug 3, 2009 9:27:49 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: columns: [username, setting_value, user_settings_id, setting_name]
Aug 3, 2009 9:27:49 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: foreign keys: []
Aug 3, 2009 9:27:49 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: indexes: [sys_idx_134]
Aug 3, 2009 9:27:49 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: schema update complete
Aug 3, 2009 9:27:49 AM org.hibernate.cache.UpdateTimestampsCache <init>
INFO: starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
Aug 3, 2009 9:27:49 AM org.hibernate.cache.EhCacheProvider buildCache
WARNING: Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
Aug 3, 2009 9:27:49 AM org.hibernate.cache.StandardQueryCache <init>
INFO: starting query cache at region: org.hibernate.cache.StandardQueryCache
Aug 3, 2009 9:27:49 AM org.hibernate.cache.EhCacheProvider buildCache
WARNING: Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
Aug 3, 2009 9:27:49 AM org.springframework.jdbc.datasource.JdbcTransactionObjectSupport <clinit>
INFO: JDBC 3.0 Savepoint class is available
root@ice32:/usr/local/pentaho/biserver-ce# Aug 3, 2009 9:30:00 AM org.apache.commons.httpclient.HttpMethodDirector executeWithRetry
INFO: I/O exception (java.net.ConnectException) caught when processing request: Connection timed out
Aug 3, 2009 9:30:00 AM org.apache.commons.httpclient.HttpMethodDirector executeWithRetry
INFO: Retrying request
Aug 3, 2009 9:30:30 AM org.apache.commons.httpclient.HttpMethodDirector executeWithRetry
INFO: I/O exception (java.net.ConnectException) caught when processing request: Connection timed out
Aug 3, 2009 9:30:30 AM org.apache.commons.httpclient.HttpMethodDirector executeWithRetry
INFO: Retrying request

Profile
 
Posted: 06 August 2009 09:58 AM   Ignore ]   [ # 1 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  505
Joined  2008-08-18

Hi,

I am not having the same issue. For me, the admin console comes up right away.

- Log in to the console: ice/infobright
- ifconfig (to determine server IP address, for this example 10.20.30.40)
- From my desktop browser: http://10.20.30.40:8099/
- Log in as admin/password

Could it be something in the way you have configured networking? By default the VM uses bridged mode, which means it gets an IP address that is accessible from your entire network. You can change this to host-only in your VMware configuration.

It could also be a fault with your DHCP server on your local network. By default the VM gets a DHCP address. If you want to make it a static IP, then edit /etc/network/interfaces and specify the IP parameters you want to use. One random web page that explains how to set static IP address: http://codesnippets.joyent.com/posts/show/319

Once you have your IP address, you also need to edit the file /usr/local/pentaho/biserver-ce/tomcat/webapps/pentaho/WEB-INF/web.xml and change the line:

<context-param>
      <
param-name>base-url</param-name>
      <
param-value>http://10.20.30.40:8080/pentaho/</param-value>
  
</context-param

where again 10.20.30.40 is the IP address from my example.

You could also post this question on the Pentaho user forums at http://forums.pentaho.org and see if anyone there can offer some assistance.

Good luck,
Geoffrey

Signature 
Profile
 
Posted: 06 August 2009 03:52 PM   Ignore ]   [ # 2 ]  
Newbie
Rank
Total Posts:  5
Joined  2009-07-28

Hi,

You get the prize.
I changed VM to network host-only and got addres 192.x.x.x.
And got quick login for admin console.

But .....

The issue is that the oracle data base I want use as a source is on the host system
with ip-adress 10.x.x.x, which is now not visable in the VM.
I will try to use a fixed address rather than DHCP.
will use a 10.0.x.x which should be in my subnet.

Your post says to change ip-addess in config for biserver-ce, what about administartoe_console config?


Thanks

Everton

Profile
 
Posted: 07 August 2009 03:29 PM   Ignore ]   [ # 3 ]  
Sr. Member
Avatar
RankRankRankRank
Total Posts:  505
Joined  2008-08-18

Hi,

1) When setting a static IP, you want to use bridged mode so that the Oracle server is visible from the VM on your local network. NAT mode may also work.

2) There is no file to edit in the admin console, only the one web.xml.

Geoffrey

Signature 
Profile