Hello Everybody,

I am a newbie here and pretty novice when it comes about using Infobright.

I am using MySQL as my database. I tried using infobright. Started the infobright client and executed ‘show databases;’ but I cannot see all tables which are there in MySQL. I created a new table using engine=BRIGHTHOUSE suffix and tried to load sql dump into it but I am getting some weird errors like ‘wrong data or column’.

Now this is what I am doing..it could sound silly but I am doing it Kindly correct me if I am doing anything wrong.

I want to access MYSQL with infobright from the front end (J2EE,Springs) simply to perform some analysis? How should I approach it? When I do ‘show engines’ in SQLyog, I dont get infobright there and when I do ‘show engines’ on this infobright client I get brighthouse as an engine but dont get all those tables…

Hope my que is not very confusing..Kindly let me know if you need more clarification from my side.

Thanks,
Pankaj

Hi !

About loading data consult first http://www.infobright.org/Forums/viewannounce/584_30/

Concerning the tool you use, it is possible it has a static list of engines without brighthouse, some tools have such limitations.

The tables in MySQL you cannot see in IB - with which engine they were created?

J.

engine was innoDB..That tool says that if an engine gets added to the MySQL, it shows them..I create a table using brighthouse engine. table got created but ‘show engines’ still not displaying ‘brighthouse’.

btw thanks Janusz for your help..seems I have got a gist of it..have to read a lot though let me try my hands on it :D

I am still facing problem in loading the data due to some weird characters which got created while creating a dump from mysql.

checking…
Regards,
Pankaj

Hi !

Unfortunately Innodb is not included into ICE, so Innodb table are not accessible.

Is your tool connecting to ICE instance? If you have mysql and ICE running together, the tool is likely to connect to standard mysql without proper reconfiguration.

I tried connecting my tool to ICE instance but I am getting this error

access denied for user root@localhost (using password = YES)

I used the same Databseip, user and password but used 5029 port as ICE instance is running on it. normally my mySQL runs on 3306.  anything I am missing?

problem.. :(

using “netstat -a” command, I can see ICE service running on 5029 port but when I am trying to create a connection from Java end or even from my tool, I am not able to connect and getting an error as -

Host ‘dummyxxxx.xxxx.net’ is not allowed to connect to this MySQL server

snippet from my-ib.ini -
# The following options will be passed to all MySQL clients
[client]
#password   = your_password
port     =5029

kindly help..

issue got resolved…