Hi .....

    I am working with ICE3.2 virtual machine which is a integration of Infobright, Talend and Jasperserver…
   
    I have a scenario where i want to use the Mysql database available on host machine in to the guest machine i.e ICE virtual machine.

    Please i need this urgently….

    Thanks in advance..

Hi Kaushik;

I’m not clear on what you are asking;

the VM is complete, and the MySQL contained within is Infobright;

you want to
1) connect to another MySQL instance on your host for data?
Or
2) use MySQL client applications on your host?

For ICE to work, the data needs to be inside an Infobright version of mysqld.
for (1) You can transfer data into the ICE vm via the connectors;

for (2) you need to get the networking information, and you can use external clients as long as the ports, IP addresses are configured correctly.
if you go to a “terminal” or console inside the VM, you can run /sbin/ifconfig to get the network address information

tw

I am sorry sir for not being clear….!

Let me explain you in detail….

I have installed ubuntu 9.10 on my computer.. On this Ubuntu i have installed VMPlayer..

Now with the help of VMPlayer i am opening a virtual machine ie. ICE 3.2 virtual machine…....

Now this ICE VM is having infobright….

On ubuntu 9.10 i.e. host machine i have installed Mysql…

My all data resides on mysql on host machine….

Now i want to access the databases on mysql of host machine, from VM i.e ICE infobright..

So how can i accees that…....?

I have tried to configure the network on ICE but i think the configration setting for network is disabled in VM ICE 3.2…

——————————————————

I have tried to run the command u told me above.. i.e. run /sbin/ifconfig

but it shows that the command not found….

so please help me..

thanks..

Hi Kaushik;

as mentioned, ICE requires the data to be within it’s own database, it cannot just “access” another mysql database.

So you will need to copy/export the data from your current mysql into ICE.
this page has some docs/utilities for this:
http://www.infobright.org/Downloads/Contributed-Software/

a few notes:
1) the ICE VM has a small disk;  if you want to put lots of data onto it, you can use VMWare’s shared folder option to give the VM more disk (as much as the host has)

ICE can be configured to use the shared disk, you have to modify the data directory in /etc/my-ib.cnf
and cache directory in the brighthouse.ini

2) which VM are you using?
are you using the “ice only” VM, or one of the BI tools versions?
there are a few postings on network settings; each VM is slightly different.

if the shared folders are working, you may not require networking;
it depends on what your requirements are.

tw