Hi everyone,

I’m new to this forum, and I come here because I have a problem.
First of all, there are informations I can give you. So my ICE is running on a Ubuntu server, hosted by Amazon Web Service EC2, type t1.micro.
To make it simple, I can not connect me to my server with a distant machine. I have made some tests with Tableau Software and Talend.

Tableau send me this exact message:

Error in MySQL Database (0x80004005) : [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0

Unable to connect to the server “XXX.XXX.XXX.XXX”. Check that the server is running and that you have access privileges to the requested database.
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

And there is the answer from Talend:

Exception in component tMysqlConnection_1
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Then after this, I have try to find for some explanations, solutions to my problem, but I can not find the solution.
This is th reason why I’m here.

Another question that I get, is to know if I need to access the “mysql” user, because I don’t have the password, and I think it was created by the deb package.

Thanks in advance!
Gael

PS: I can answer if you need some more informations.

You will need to login to the instance to do a few things. But, you may be blocked by a firewall somewhere in between somewhere.

1.  Where is Tableau running from?  The server or from your own machine?
2.  What else is running on the EC2 instance?
3.  Do you have access to this instance?

Hi Craig!

To answer you :
1. My Tableau version is running on my own machine.
2. There’s nothing as consuming as Infobright, but a few little things like RVM, etc. (this is to run the SnowPlow Analytics environment, which includes ICE).
3. I do have set this instance, and allowed the security rules to allow entrance by the MyQSL-IB port (5029).

Thanks for your help!

Snowplough is a GREAT technology.  I am also in process of getting them embedded in our own stuff becuase I really like their software.  It sounds to me like you need to allow remote connections to the database. 

Please go through this article I wrote on this topic and see if it is a privelege issue.

http://www.infobright.org/Blog/Entry/common_steps_for_debugging_connection_issue/

Also, if you did a default install, your mysql username is root and the password is blank, just hit enter.

This is how I have configure the two users that I use. They have different PW, and not null. But the problem is that I can type any PW I want on Tableau it answer me always the same error… :|
And, one more thing that I didn’t say but which is important: a simple Telnet command launched by the Windows command line on the server/port works normaly.

You’ll want to make sure that:
1.  EC2 Instance allows for users to connect to port 5029.  (Controlled via Instance Control Panel)
2.  No Firewall is blocking connections
3.  Connect to the server using “mysql –h 127.0.0.1 –P 5029 –u root –p” on the EC2 instance where Infobright resides.

As sort of a guide, please review this article:

http://www.infobright.org/Blog/Entry/loading_data_in_infobright_on_amazon_ec2_using_dlp

It gives instructions on Setting up Permissions.

To answer the two first questions, as you can see in the image, the user connection on port 5029 is allowed, and if I can do a telnet command on the port say that there is no firewall blocking.

For the question 3,  I have to say that I can not use “mysql [...]” commands, but “mysql-ib [...]”. May it be the source of the problem?
And another question that I ask me is to know if it may come from the fact that I have installed IB via the .deb package, and not via the .tar.gz package.

Then I have another question to go on, on my side: Are there any log files that I could take a look on to see if it can help me find the problem’s source?

Thanks in advance!
Gaël

Look in the infobright installation folder for a file called bh.err

If you do not find it, open the brighthouse.ini file and set ControlMessages = 5

Then stop & restart the service and run a test again, the bh.err file should be there.

Please zip that and post it here, or email it to me…..

Hi Gael,

Based upon your bh.err, we’re seeing a significant amount of crashing that’s occured.  Since you’re on a micro instance, can you provide more details on the environment including:

1. How much data loaded on Infobright?
2. What version of Ubuntu are you using?
3. Is anything else installed?
4. Enable the General Query Log and then restart the service.  Send Craig the general query log. T hat may indicate what’s happening on the system when it fails.

You’re hitting sig11s which indicates an issue with Memory availability.  I also assume you’re using the latest DEB package of ICE, correct?

Thanks,

Jeff

1. ATM there are about 250 rows in the event_008 table for Snowplow, and tables 004 to 007 would count around a 50 rows.
2. Ubuntu 12.04.2 LTS (GNU/Linux 3.2.0-38-virtual x86_64)
3. I use my EC2 server to run the SnowPlow environment. Then there is nothing as significant as ICE running on it.
4. I send the file just after this post. But don’t you need me to make a connection with Tableau to see all the problems?

Server version: 5.1.40 build number (revision)=IB_4.0.7_r16961_17249(ice)

Here is my ICE version number, and as far as I know, it is the last realese

One of the problems I see already is that you are on Ubuntu 12, which I know for certain works on EC2, but you will never be able to use a remote connection.  It is officially not a supported platform.

http://www.infobright.org/wiki/ICE_Platform_Requirements/

Yes, it will install, yes you can connect using mysql client ON that machine, but you will probably get a signal 11 when anything else tries to connect to it.

So it’s my bad… Thanks for your help, and sorry for the inconvenience.
Gaël

I have the same problem, but my table dir have not a ab_switch file, so i create a new table(the same struct as the crushed table just a new table name),then copy the ab_switch file to my crushed table dir , everything is OK!

jypeng, i am not at all certain what you are talking about, can you please elaborate…..