Infobright.org Forums

Trouble connecting ...

2011-11-17T19:01:15-04:00

Hi there ... @ib_community invited me to post our problem here (this is @markjeffrey) so here goes:

Here’s our setup:
The infobright mysql listen post of 5029 is whitelisted in iptables, accessible from anywhere
The root mySQL user has been granted permissions to access remotely from anywhere with the right password
Infobright’s equivalent of my.cnf (my-ib.cnf) is (i believe) free of restrictions on remote access
I’m able to connect to Infobright via MySQL workbench with the root credentials without a problem.

The bug seems to occur at the level of the handshake between the mysql jdbc connector and the infobright server.

We see this (and the password is correct):

Error connecting to database: (using class org.gjt.mm.mysql.Driver)
Access denied for user ‘root’@‘vpn.comcast.com’ (using password: YES)

Our install is as follows:
Server version: 5.1.40-log build number (revision)=IB_4.0.4_r14484_14560(ice) (static)

Problem with Tinfobrightoutput

2011-07-26T03:56:53-04:00

Hi,

I am using InfoBright Enterprise edition on Windows 2008 64 bit server and Talend is installed on the same server.

I got an error while running the job on Talend which imports csv.file to infobright. I followed all the instructions while adding the tinfobrightoutput component to Talend.

Talend Components Used: tfileinputdelimited and tinfobrightoutput

error:
Exception in thread “main” java.lang.Error: Java.lang.Unsatisfiedlinkerror:
C:Windowsinfobright_jni.dll: Can’t find dependent libraries
at
talenddemosjava.importtosdh_0_1.importtosdh.tfileinputdelimited_1process(importtosdh.java:1073)
at
talenddemosjava.importtosdh_0_1.importtosdh.runjobintos(importtosdh.java:1244)
at
talenddemosjava.importtosdh_0_1.importtosdh.main(importtosdh.java:1118)

Caused by Java.lang.Unsatisfiedlinkerror:
C:Windowsinfobright_jni.dll: Can’t find dependent libraries
at java.lang.classloader.loadLibrary0(Unknown source)
at java.lang.classloader.loadLibrary(Unknown source)
at java.lang.Runtime.loadLibrary0(Unknown source)
at java.lang.System.loadLibrary(Unknown source)
at com.infobright.io.windowspipe.<clinit>(Windowsnamedpipe.java:49)
at
com.infobright.io.Namedpipefactory.getnativepipename(Namedpipefactory.java:131)
at
com.infobright.io.infobrightnamedpipeloader.<init>(infobrightnamedpipeloader.java:148)
at
talenddemosjava.importtosdh_0_1.importtosdh.tfileinputdelimited_1process(importtosdh.java:579)

Thanks,
Sampath.

Blank pentaho pages

2010-03-01T09:24:30-04:00

Hi all,

I’m having trouble working out how to see any useful pages in the pentaho webapp. Basically if I go to http://xx.xx.xx.xx:8080/pentaho I can log in as one of the demo users, then a blank page loads with the (window) title “Pentaho BI Platform”. Subsequent request to this URL take me straight to the blank page. Page source:

<?xml version=“1.0” encoding=“utf-8”?>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<html >
<head>
<title>Pentaho BI Platform</title>
<meta http-equiv=“refresh” content=“0;URL=/pentaho”>
</head>
<body>
</body>
</html>

If I point my browser at port 80 on the appliance, i see the ICE32 appliance welcome page ok, and http://xx.xx.xx.xx:8080/pentaho/welcome/welcome.html works just fine (but the JS links don’t work), and http://xx.xx.xx.xx:8099 gives me the pentaho management console, which seem to work fine. These suggest tomcat is up and running ok.

Set up: clean appliance (downloaded today) with the following changes only (as in README):
Updated web.xml/base-url with my appliance’s IP
Updated /etc/hosts with my appliance’s IP
sudo /etc/init.d/pentaho stop
sudo /etc/init.d/pentaho start

I’ve not done anything with shared folders, as I saw the message “initial install is using small internal local disk;
for larger data sets, you need to use shared/data and shared/cache…” and thought i’d get things working first without worrying about big data sets. Should this be a problem?

I’ve checked the logs in /usr/local/pentaho/biserver-ce/tomcat/logs, but not much shows up other than the fact the server has started.

Any thoughts?

Cheers,

Ben

howto add new data source and new metadata model in Pentaho ICE VM ?

2010-10-26T03:43:44-04:00

after successfull running Pentaho + ICE VM, and logging into Pentaho User Console under joe (administator) user
i create infobright tables in standart mysql client

mysql -u ice -pinfobright -P 5029 -h ip_of_virtual_machine

CREATE DATABASE test2;
CREATE TABLE test2.test_slice_and_dice(
id BIGINT(20) NOT NULL UNSIGNED,
date DATE NOT NULL,
city STRING(10) NOT NULL,
salary INT(10) NOT NULL
);

and run
LOAD DATA IN FILE ...

but, i don’t understand howto create new datasource in pentaho user console and create new analyzes view for this datasource?

Ubuntu Desktop does not appear

2010-10-26T06:42:03-04:00

Hi All

I have the Infobright with Pentaho on a VMWare on my Ubuntu 10.04 LTS. I already followd the instructinos on the reame file and it seems that the appliance starts ok, I ge to see the “open browser” button and then I am able to read the information on that IP. But I don’t see any ubuntu desktop on the appliance window, however I realized I can “exit appliance view” and get into the command line. I tried typing startx but seens that no desktop enviroment is installed.

I coulnd not find any information about this topic on these forums nor the documentation, what would you guys suggest/comment?

thank you in advance

PS I also installed VMWare tools using the option on one of Vmware’s menus.. And I also tried modifying the display resolution options but got the same.

Cannot mount file system

2010-02-08T18:07:50-04:00

Hi there

I just d/l the Pentaho ICE and loaded it up in VMWare Workstation 7. Watching the startup commands run there are two messages that cause me concern: First, after “* Mounting local filesystems” I get this: Error: cannot mount filesystem: Protocol error [fail]. A few lines later, “Mounting HGFS” shows “failed.”

The VM does allow me to log on, although nothing appears to happen once I do.

Thanks in advance for any assistance!
- Russell

Virtual Machines

2009-11-25T10:43:40-04:00

Hi,

I was wondering if you guys have any comparative write-ups about different virtual packages (Pentaho-Infobright, Jasper-Infobrights, Talend-Infobright etc).
I was curious what are the differences, issues and benefits of each combinations.
Any lights on that?
Thanks
C_G

Unable to view some of the sample reports from Pentaho / ICE Integrated VM

2009-06-26T09:40:49-04:00

Hi Guys,

I am unable to view some of the example reports from my Pentaho / ICE VM. Are there any specific configurations required? I was able to generate some reports successfully. Some of the reports with charts are displaying only text. I have attached few screenshots for your reference.

Your earliest support is highly appreciated.

Cheers!

Chanaka

VM Ware Image will not start

2009-06-12T03:53:06-04:00

Hi All

I am not a Linux expert however have tried what I have found here so far.

My VM starts and then just hangs.

It sits forever at “Power on…” and in console mode stops at what I think is a MySQL command:

“From command line , use [Ctrl] + [C] to abort abruptly”

By pressing a key from here I can login and have command line control, but do not really know what to look for.

Anyone any ideas?

Thanks

Adam

Pentaho ICE Ubuntu Integrated VM under Parallels Desktop for Mac

2009-09-10T15:42:32-04:00

I apologize if this is the wrong place to ask this question, but I’ve tried the Parallels forums and KB to no avail.

When I try to open the Pentaho ICE Ubuntu VM ice32.vmx file in Parallels, the Parallels Transporter comes up, as expected, but ends with the following error:

“No operating system is installed on the virtual hard disks or Parallels Transporter is unable to make the operating system bootable. The disks will be migrated to Parallels virtual data disks.
“Do you wish to continue?”

At which point I cancel and finish without completing the migration.

Any ideas?

Thanks in advance.