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

2014-10-14 Thread 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 sen

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

2014-10-14 Thread 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/t

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

2014-10-14 Thread 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.middl

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

2014-10-14 Thread 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 Muthutantri

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

2014-10-14 Thread 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@wso

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

2014-10-14 Thread 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 *

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

2014-10-14 Thread 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