Re: [Dev] Error establishing data source connection, Communications link failure

[Supun Muthutantrige]

Hi Manoj,

The error occurred when I attempt to link to a mysql database using the
CEP. The following error message was shown when the connection was tested.

Error--

Error establishing data source connection: 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.

-

After I allowed the permission as Yasassri mentioned the problem resolved.

Thank you,
Regards.

*Supun Rasitha Muthutantrige*





*supunrIntern WSO2 Inc: http://wso2.com 
lean.enterprise.middleware*
*Mobile: 0758374608*
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Error establishing data source connection, Communications link failure

[Manoj Gunawardena]

Hi Supun,

What was the problem?  This issue can happen due to various reasons.

Thanks



On Wed, Oct 15, 2014 at 10:35 AM, Supun Muthutantrige 
wrote:

> Hi Yasassri, It worked :)
>
> Thank you all for helping me out with this.
>
> Regards
>
> *Supun Rasitha Muthutantrige*
> *supunr*
> *Intern *
> *WSO2 Inc: http://wso2.com *
> *lean.enterprise.middleware*
>
> *Mobile: 0758374608*
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>


-- 
Manoj Gunawardena
Tech Lead
WSO2, Inc.: http://wso2.com
lean.enterprise.middleware
Mobile : +94 77 2291643
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Error establishing data source connection, Communications link failure

[Supun Muthutantrige]

Hi Yasassri, It worked :)

Thank you all for helping me out with this.

Regards

*Supun Rasitha Muthutantrige*
*supunr*
*Intern *
*WSO2 Inc: http://wso2.com *
*lean.enterprise.middleware*

*Mobile: 0758374608*
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Error establishing data source connection, Communications link failure

[Yasassri Ratnayake]

Hi,

Try commenting out the bind address in my.cnf and granting all access to
the user you are trying to connect with as follows,

GRANT ALL PRIVILEGES ON *.* TO @'%' IDENTIFIED BY ''
WITH GRANT OPTION;

Make sure you restart mysql

With Regards,

On Wed, Oct 15, 2014 at 10:01 AM, Supun Muthutantrige 
wrote:

> Hi Rajeevan,
>
> Yes, I tried by adding *mysql-connector-Java-5.1.33. tar.gz*, and then
> with only having *mysql-connector-Java-5.1.33-bin.jar* in that folder.
> But neither worked.
>
> Regards
> *Supun Rasitha Muthutantrige*
> *supunr*
>
>
> *Intern WSO2 Inc: http://wso2.com
> lean.enterprise.middleware*
>
> *Mobile: 0758374608*
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>


-- 
Yasassri Ratnayake
Software Engineer - QA
WSO2 Inc ; http://wso2.com
lean.enterprise.middleware
*Mobile : +94715933168*
*Blog : http://yasassriratnayake.blogspot.com/
*
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Error establishing data source connection, Communications link failure

[Supun Muthutantrige]

Hi Rajeevan,

Yes, I tried by adding *mysql-connector-Java-5.1.33. tar.gz*, and then with
only having *mysql-connector-Java-5.1.33-bin.jar* in that folder. But
neither worked.

Regards
*Supun Rasitha Muthutantrige*
*supunr*


*Intern WSO2 Inc: http://wso2.com
lean.enterprise.middleware*

*Mobile: 0758374608*
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Error establishing data source connection, Communications link failure

[Vimalanathan Rajeevan]

Hi Supun,

Did you add mysql JDBC driver to /repository/components/lib/
folder?

Thanks,
Rajeevan

On Wed, Oct 15, 2014 at 9:47 AM, Supun Muthutantrige 
wrote:

> Hi all,
>
> While attempting to relate to an RDBMS data source [Driver*:*
> *com.mysql.jdbc.Driver*, URL: *jdbc:mysql://localhost:3306/testdb*] in
> CEP, the following error occurs
>
> Error---
>
> Error establishing data source connection: 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.
>
> Error stack--
>
>
> [2014-10-15 09:21:52,227] ERROR - {DataSourceRepository}  Error
> establishing data source connection: 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.
> org.wso2.carbon.ndatasource.common.DataSourceException: Error establishing
> data source connection: 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.
> at
> org.wso2.carbon.ndatasource.rdbms.RDBMSDataSourceReader.testDataSourceConnection(RDBMSDataSourceReader.java:71)
> at
> org.wso2.carbon.ndatasource.core.DataSourceRepository.testDataSourceConnection(DataSourceRepository.java:510)
> at
> org.wso2.carbon.ndatasource.core.services.NDataSourceAdminService.testDataSourceConnection(NDataSourceAdminService.java:89)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>
> End Error stack--
>
> I have changed the *bind-address* in *my.cnf *file, according to my
> machine ip as well.
>
> Appreciate any support to solve this error.
>
> Regards
>
> *Supun Rasitha Muthutantrige**supunr*
>
>
>
>
> *Intern WSO2 Inc: http://wso2.com 
> lean.enterprise.middleware*
> *Mobile: 0758374608*
>
>
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>


-- 
Best Regards,
V.Rajeevan
Software Engineer,
WSO2 Inc. :http://wso2.com

Mobile : +94 773090875
Email : rajeev...@wso2.com
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

[Dev] Error establishing data source connection, Communications link failure

[Supun Muthutantrige]

Hi all,

While attempting to relate to an RDBMS data source [Driver*:*
*com.mysql.jdbc.Driver*, URL: *jdbc:mysql://localhost:3306/testdb*] in CEP,
the following error occurs

Error---

Error establishing data source connection: 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.

Error stack--


[2014-10-15 09:21:52,227] ERROR - {DataSourceRepository}  Error
establishing data source connection: 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.
org.wso2.carbon.ndatasource.common.DataSourceException: Error establishing
data source connection: 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.
at
org.wso2.carbon.ndatasource.rdbms.RDBMSDataSourceReader.testDataSourceConnection(RDBMSDataSourceReader.java:71)
at
org.wso2.carbon.ndatasource.core.DataSourceRepository.testDataSourceConnection(DataSourceRepository.java:510)
at
org.wso2.carbon.ndatasource.core.services.NDataSourceAdminService.testDataSourceConnection(NDataSourceAdminService.java:89)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

End Error stack--

I have changed the *bind-address* in *my.cnf *file, according to my machine
ip as well.

Appreciate any support to solve this error.

Regards

*Supun Rasitha Muthutantrige**supunr*




*Intern WSO2 Inc: http://wso2.com 
lean.enterprise.middleware*
*Mobile: 0758374608*
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev