[Dev] Adding data to database in WSO2 App Cloud

[Nilashan Namasivayam]

Hi,

I'm trying to add some data to the database in App Cloud.

The database url like this:
  jdbc:mysql://mysql-dev-01.cloud.wso2.com:3306/db1_x


and I have tried to connect via MySQL client like this
 mysql -u dbuser -h jdbc:mysql://
mysql-dev-01.cloud.wso2.com:3306/db1_x -p

After trying the above code, I get this error in console
  ERROR 2005 (HY000): Unknown MySQL server host 'jdbc:mysql://
mysql-dev-01.cloud.wso2.com:3306/db1_x' (2)

What can be the problem?

I'm following this documentation:
http://docs.wso2.com/display/AppCloud/Add+Data+to+my+Database+or+Connect+to+an+External+Database

Do we need any additional configuration in App Cloud than mentioned in the
above link?


Regards,
Nilashan
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Adding data to database in WSO2 App Cloud

[Danushka Fernando]

Hi
When you use mysql client you have to give the host name for -h option not
the db URL. So try

mysql -u dbuser -h mysql-
dev
-01.
cloud.wso2
.com
 -p
On Jul 9, 2014 10:56 PM, "Nilashan Namasivayam"  wrote:

> Hi,
>
> I'm trying to add some data to the database in App Cloud.
>
> The database url like this:
>   jdbc:mysql://mysql-dev-01.cloud.wso2.com:3306/db1_x
>
>
> and I have tried to connect via MySQL client like this
>  mysql -u dbuser -h jdbc:mysql://
> mysql-dev-01.cloud.wso2.com:3306/db1_x -p
>
> After trying the above code, I get this error in console
>   ERROR 2005 (HY000): Unknown MySQL server host 'jdbc:mysql://
> mysql-dev-01.cloud.wso2.com:3306/db1_x' (2)
>
> What can be the problem?
>
> I'm following this documentation:
>
> http://docs.wso2.com/display/AppCloud/Add+Data+to+my+Database+or+Connect+to+an+External+Database
>
> Do we need any additional configuration in App Cloud than mentioned in the
> above link?
>
>
> Regards,
> Nilashan
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Adding data to database in WSO2 App Cloud

[Nilashan Namasivayam]

Hi,

Even I tried like this, It shows same error.
For the username for the database, It automatically create a username than
I given, Like if I put dbuser then It creates dbuser_ubITB7my. So Do I use
this one? and I have used this one also, It shows same error.

Thank you,

Regards,
Nilashan


On Thu, Jul 10, 2014 at 7:58 AM, Danushka Fernando 
wrote:

> Hi
> When you use mysql client you have to give the host name for -h option not
> the db URL. So try
>
> mysql -u dbuser -h mysql-
> dev
> -01.
> cloud.wso2
> .com
>  -p
> On Jul 9, 2014 10:56 PM, "Nilashan Namasivayam" 
> wrote:
>
>> Hi,
>>
>> I'm trying to add some data to the database in App Cloud.
>>
>> The database url like this:
>>   jdbc:mysql://mysql-dev-01.cloud.wso2.com:3306/db1_x
>>
>>
>> and I have tried to connect via MySQL client like this
>>  mysql -u dbuser -h jdbc:mysql://
>> mysql-dev-01.cloud.wso2.com:3306/db1_x -p
>>
>> After trying the above code, I get this error in console
>>   ERROR 2005 (HY000): Unknown MySQL server host 'jdbc:mysql://
>> mysql-dev-01.cloud.wso2.com:3306/db1_x' (2)
>>
>> What can be the problem?
>>
>> I'm following this documentation:
>>
>> http://docs.wso2.com/display/AppCloud/Add+Data+to+my+Database+or+Connect+to+an+External+Database
>>
>> Do we need any additional configuration in App Cloud than mentioned in
>> the above link?
>>
>>
>> Regards,
>> Nilashan
>>
>> ___
>> Dev mailing list
>> Dev@wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Adding data to database in WSO2 App Cloud

[Udara Liyanage]

HI,

I tried telnet mysql-dev-01.cloud.wso2.com
 3006 and there was a
response. MySQL server seems to run on the given host and port. Please
check whether remote login has enabled from MySQL server side.


On Thu, Jul 10, 2014 at 8:15 AM, Nilashan Namasivayam 
wrote:

> Hi,
>
> Even I tried like this, It shows same error.
> For the username for the database, It automatically create a username than
> I given, Like if I put dbuser then It creates dbuser_ubITB7my. So Do I
> use this one? and I have used this one also, It shows same error.
>
> Thank you,
>
> Regards,
> Nilashan
>
>
> On Thu, Jul 10, 2014 at 7:58 AM, Danushka Fernando 
> wrote:
>
>> Hi
>> When you use mysql client you have to give the host name for -h option
>> not the db URL. So try
>>
>> mysql -u dbuser -h mysql-
>> dev
>> -01.
>> cloud.wso2
>> .com
>>  -p
>> On Jul 9, 2014 10:56 PM, "Nilashan Namasivayam" 
>> wrote:
>>
>>> Hi,
>>>
>>> I'm trying to add some data to the database in App Cloud.
>>>
>>> The database url like this:
>>>   jdbc:mysql://mysql-dev-01.cloud.wso2.com:3306/db1_x
>>>
>>>
>>> and I have tried to connect via MySQL client like this
>>>  mysql -u dbuser -h jdbc:mysql://
>>> mysql-dev-01.cloud.wso2.com:3306/db1_x -p
>>>
>>> After trying the above code, I get this error in console
>>>   ERROR 2005 (HY000): Unknown MySQL server host 'jdbc:mysql://
>>> mysql-dev-01.cloud.wso2.com:3306/db1_x' (2)
>>>
>>> What can be the problem?
>>>
>>> I'm following this documentation:
>>>
>>> http://docs.wso2.com/display/AppCloud/Add+Data+to+my+Database+or+Connect+to+an+External+Database
>>>
>>> Do we need any additional configuration in App Cloud than mentioned in
>>> the above link?
>>>
>>>
>>> Regards,
>>> Nilashan
>>>
>>> ___
>>> Dev mailing list
>>> Dev@wso2.org
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>


-- 

Udara Liyanage
Software Engineer
WSO2, Inc.: http://wso2.com
lean. enterprise. middleware

web: http://udaraliyanage.wordpress.com
phone: +94 71 443 6897
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Adding data to database in WSO2 App Cloud

[Firzhan Naqash]

Hi,

You have to get the remote connection enabled from the Infra. By default it
has been disabled.

Regards,
Firzhan


On Thu, Jul 10, 2014 at 10:45 AM, Udara Liyanage  wrote:

> HI,
>
> I tried telnet mysql-dev-01.cloud.wso2.com
>  3006 and there was a
> response. MySQL server seems to run on the given host and port. Please
> check whether remote login has enabled from MySQL server side.
>
>
> On Thu, Jul 10, 2014 at 8:15 AM, Nilashan Namasivayam 
> wrote:
>
>> Hi,
>>
>> Even I tried like this, It shows same error.
>> For the username for the database, It automatically create a username
>> than I given, Like if I put dbuser then It creates dbuser_ubITB7my. So
>> Do I use this one? and I have used this one also, It shows same error.
>>
>> Thank you,
>>
>> Regards,
>> Nilashan
>>
>>
>> On Thu, Jul 10, 2014 at 7:58 AM, Danushka Fernando 
>> wrote:
>>
>>> Hi
>>> When you use mysql client you have to give the host name for -h option
>>> not the db URL. So try
>>>
>>> mysql -u dbuser -h mysql-
>>> dev
>>> -01.
>>> cloud.wso2
>>> .com
>>>  -p
>>> On Jul 9, 2014 10:56 PM, "Nilashan Namasivayam" 
>>> wrote:
>>>
 Hi,

 I'm trying to add some data to the database in App Cloud.

 The database url like this:
   jdbc:mysql://mysql-dev-01.cloud.wso2.com:3306/db1_x


 and I have tried to connect via MySQL client like this
  mysql -u dbuser -h jdbc:mysql://
 mysql-dev-01.cloud.wso2.com:3306/db1_x -p

 After trying the above code, I get this error in console
   ERROR 2005 (HY000): Unknown MySQL server host 'jdbc:mysql://
 mysql-dev-01.cloud.wso2.com:3306/db1_x' (2)

 What can be the problem?

 I'm following this documentation:

 http://docs.wso2.com/display/AppCloud/Add+Data+to+my+Database+or+Connect+to+an+External+Database

 Do we need any additional configuration in App Cloud than mentioned in
 the above link?


 Regards,
 Nilashan

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


>>
>> ___
>> Dev mailing list
>> Dev@wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
>
>
> --
>
> Udara Liyanage
> Software Engineer
> WSO2, Inc.: http://wso2.com
> lean. enterprise. middleware
>
> web: http://udaraliyanage.wordpress.com
> phone: +94 71 443 6897
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Adding data to database in WSO2 App Cloud

[Nilashan Namasivayam]

Hi,

Thanks, How to enable it from the Infra?

Regards,
Nilashan


On Thu, Jul 10, 2014 at 11:44 AM, Firzhan Naqash  wrote:

>
> Hi,
>
> You have to get the remote connection enabled from the Infra. By default
> it has been disabled.
>
> Regards,
> Firzhan
>
>
> On Thu, Jul 10, 2014 at 10:45 AM, Udara Liyanage  wrote:
>
>> HI,
>>
>> I tried telnet mysql-dev-01.cloud.wso2.com
>>  3006 and there was a
>> response. MySQL server seems to run on the given host and port. Please
>> check whether remote login has enabled from MySQL server side.
>>
>>
>> On Thu, Jul 10, 2014 at 8:15 AM, Nilashan Namasivayam > > wrote:
>>
>>> Hi,
>>>
>>> Even I tried like this, It shows same error.
>>> For the username for the database, It automatically create a username
>>> than I given, Like if I put dbuser then It creates dbuser_ubITB7my. So
>>> Do I use this one? and I have used this one also, It shows same error.
>>>
>>> Thank you,
>>>
>>> Regards,
>>> Nilashan
>>>
>>>
>>> On Thu, Jul 10, 2014 at 7:58 AM, Danushka Fernando 
>>> wrote:
>>>
 Hi
 When you use mysql client you have to give the host name for -h option
 not the db URL. So try

 mysql -u dbuser -h mysql-
 dev
 -01.
 cloud.wso2
 .com
  -p
 On Jul 9, 2014 10:56 PM, "Nilashan Namasivayam" 
 wrote:

> Hi,
>
> I'm trying to add some data to the database in App Cloud.
>
> The database url like this:
>   jdbc:mysql://mysql-dev-01.cloud.wso2.com:3306/db1_x
>
>
> and I have tried to connect via MySQL client like this
>  mysql -u dbuser -h jdbc:mysql://
> mysql-dev-01.cloud.wso2.com:3306/db1_x -p
>
> After trying the above code, I get this error in console
>   ERROR 2005 (HY000): Unknown MySQL server host 'jdbc:mysql://
> mysql-dev-01.cloud.wso2.com:3306/db1_x' (2)
>
> What can be the problem?
>
> I'm following this documentation:
>
> http://docs.wso2.com/display/AppCloud/Add+Data+to+my+Database+or+Connect+to+an+External+Database
>
> Do we need any additional configuration in App Cloud than mentioned in
> the above link?
>
>
> Regards,
> Nilashan
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>
>>>
>>> ___
>>> Dev mailing list
>>> Dev@wso2.org
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>>
>>
>> --
>>
>> Udara Liyanage
>> Software Engineer
>>  WSO2, Inc.: http://wso2.com
>> lean. enterprise. middleware
>>
>> web: http://udaraliyanage.wordpress.com
>> phone: +94 71 443 6897
>>
>> ___
>> Dev mailing list
>> Dev@wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
>
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Adding data to database in WSO2 App Cloud

[Danushka Fernando]

Hi
This is WSO2 Cloud hosted in EC2. So If it can be telnet, then it is open
to the public. This is nothing to do with Infra. Amila can you check what's
going wrong here.

Thanks & Regards
Danushka Fernando
Software Engineer
WSO2 inc. http://wso2.com/
Mobile : +94716332729


On Thu, Jul 10, 2014 at 11:44 AM, Firzhan Naqash  wrote:

>
> Hi,
>
> You have to get the remote connection enabled from the Infra. By default
> it has been disabled.
>
> Regards,
> Firzhan
>
>
> On Thu, Jul 10, 2014 at 10:45 AM, Udara Liyanage  wrote:
>
>> HI,
>>
>> I tried telnet mysql-dev-01.cloud.wso2.com
>>  3006 and there was a
>> response. MySQL server seems to run on the given host and port. Please
>> check whether remote login has enabled from MySQL server side.
>>
>>
>> On Thu, Jul 10, 2014 at 8:15 AM, Nilashan Namasivayam > > wrote:
>>
>>> Hi,
>>>
>>> Even I tried like this, It shows same error.
>>> For the username for the database, It automatically create a username
>>> than I given, Like if I put dbuser then It creates dbuser_ubITB7my. So
>>> Do I use this one? and I have used this one also, It shows same error.
>>>
>>> Thank you,
>>>
>>> Regards,
>>> Nilashan
>>>
>>>
>>> On Thu, Jul 10, 2014 at 7:58 AM, Danushka Fernando 
>>> wrote:
>>>
 Hi
 When you use mysql client you have to give the host name for -h option
 not the db URL. So try

 mysql -u dbuser -h mysql-
 dev
 -01.
 cloud.wso2
 .com
  -p
 On Jul 9, 2014 10:56 PM, "Nilashan Namasivayam" 
 wrote:

> Hi,
>
> I'm trying to add some data to the database in App Cloud.
>
> The database url like this:
>   jdbc:mysql://mysql-dev-01.cloud.wso2.com:3306/db1_x
>
>
> and I have tried to connect via MySQL client like this
>  mysql -u dbuser -h jdbc:mysql://
> mysql-dev-01.cloud.wso2.com:3306/db1_x -p
>
> After trying the above code, I get this error in console
>   ERROR 2005 (HY000): Unknown MySQL server host 'jdbc:mysql://
> mysql-dev-01.cloud.wso2.com:3306/db1_x' (2)
>
> What can be the problem?
>
> I'm following this documentation:
>
> http://docs.wso2.com/display/AppCloud/Add+Data+to+my+Database+or+Connect+to+an+External+Database
>
> Do we need any additional configuration in App Cloud than mentioned in
> the above link?
>
>
> Regards,
> Nilashan
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>
>>>
>>> ___
>>> Dev mailing list
>>> Dev@wso2.org
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>>
>>
>> --
>>
>> Udara Liyanage
>> Software Engineer
>>  WSO2, Inc.: http://wso2.com
>> lean. enterprise. middleware
>>
>> web: http://udaraliyanage.wordpress.com
>> phone: +94 71 443 6897
>>
>> ___
>> Dev mailing list
>> Dev@wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Adding data to database in WSO2 App Cloud

[Amila Maha Arachchi]

We'll look into this and get back to you.


On Thu, Jul 10, 2014 at 11:57 AM, Danushka Fernando 
wrote:

> Hi
> This is WSO2 Cloud hosted in EC2. So If it can be telnet, then it is open
> to the public. This is nothing to do with Infra. Amila can you check what's
> going wrong here.
>
> Thanks & Regards
> Danushka Fernando
> Software Engineer
> WSO2 inc. http://wso2.com/
> Mobile : +94716332729
>
>
> On Thu, Jul 10, 2014 at 11:44 AM, Firzhan Naqash  wrote:
>
>>
>> Hi,
>>
>> You have to get the remote connection enabled from the Infra. By default
>> it has been disabled.
>>
>> Regards,
>> Firzhan
>>
>>
>> On Thu, Jul 10, 2014 at 10:45 AM, Udara Liyanage  wrote:
>>
>>> HI,
>>>
>>> I tried telnet mysql-dev-01.cloud.wso2.com
>>>  3006 and there was
>>> a response. MySQL server seems to run on the given host and port. Please
>>> check whether remote login has enabled from MySQL server side.
>>>
>>>
>>> On Thu, Jul 10, 2014 at 8:15 AM, Nilashan Namasivayam <
>>> n.nil...@gmail.com> wrote:
>>>
 Hi,

 Even I tried like this, It shows same error.
 For the username for the database, It automatically create a username
 than I given, Like if I put dbuser then It creates dbuser_ubITB7my. So
 Do I use this one? and I have used this one also, It shows same error.

 Thank you,

 Regards,
 Nilashan


 On Thu, Jul 10, 2014 at 7:58 AM, Danushka Fernando 
 wrote:

> Hi
> When you use mysql client you have to give the host name for -h option
> not the db URL. So try
>
> mysql -u dbuser -h mysql-
> dev
> -01.
> cloud.wso2
> .com
>  -p
> On Jul 9, 2014 10:56 PM, "Nilashan Namasivayam" 
> wrote:
>
>> Hi,
>>
>> I'm trying to add some data to the database in App Cloud.
>>
>> The database url like this:
>>   jdbc:mysql://mysql-dev-01.cloud.wso2.com:3306/db1_x
>>
>>
>> and I have tried to connect via MySQL client like this
>>  mysql -u dbuser -h jdbc:mysql://
>> mysql-dev-01.cloud.wso2.com:3306/db1_x -p
>>
>> After trying the above code, I get this error in console
>>   ERROR 2005 (HY000): Unknown MySQL server host 'jdbc:mysql://
>> mysql-dev-01.cloud.wso2.com:3306/db1_x' (2)
>>
>> What can be the problem?
>>
>> I'm following this documentation:
>>
>> http://docs.wso2.com/display/AppCloud/Add+Data+to+my+Database+or+Connect+to+an+External+Database
>>
>> Do we need any additional configuration in App Cloud than mentioned
>> in the above link?
>>
>>
>> Regards,
>> Nilashan
>>
>> ___
>> Dev mailing list
>> Dev@wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>

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


>>>
>>>
>>> --
>>>
>>> Udara Liyanage
>>> Software Engineer
>>>  WSO2, Inc.: http://wso2.com
>>> lean. enterprise. middleware
>>>
>>> web: http://udaraliyanage.wordpress.com
>>> phone: +94 71 443 6897
>>>
>>> ___
>>> Dev mailing list
>>> Dev@wso2.org
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>>
>> ___
>> Dev mailing list
>> Dev@wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
>


-- 
*Amila Maharachchi*
Senior Technical Lead
WSO2, Inc.; http://wso2.com

Blog: http://maharachchi.blogspot.com
Mobile: +94719371446
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Adding data to database in WSO2 App Cloud

[Nilashan Namasivayam]

Hi,

This problem has been solved.  The remote connection has been enabled.

Regards,
Nilashan


On Thu, Jul 10, 2014 at 10:23 PM, Amila Maha Arachchi 
wrote:

> We'll look into this and get back to you.
>
>
> On Thu, Jul 10, 2014 at 11:57 AM, Danushka Fernando 
> wrote:
>
>> Hi
>> This is WSO2 Cloud hosted in EC2. So If it can be telnet, then it is open
>> to the public. This is nothing to do with Infra. Amila can you check what's
>> going wrong here.
>>
>> Thanks & Regards
>> Danushka Fernando
>> Software Engineer
>> WSO2 inc. http://wso2.com/
>> Mobile : +94716332729
>>
>>
>> On Thu, Jul 10, 2014 at 11:44 AM, Firzhan Naqash 
>> wrote:
>>
>>>
>>> Hi,
>>>
>>> You have to get the remote connection enabled from the Infra. By default
>>> it has been disabled.
>>>
>>> Regards,
>>> Firzhan
>>>
>>>
>>> On Thu, Jul 10, 2014 at 10:45 AM, Udara Liyanage  wrote:
>>>
 HI,

 I tried telnet mysql-dev-01.cloud.wso2.com
  3006 and there was
 a response. MySQL server seems to run on the given host and port. Please
 check whether remote login has enabled from MySQL server side.


 On Thu, Jul 10, 2014 at 8:15 AM, Nilashan Namasivayam <
 n.nil...@gmail.com> wrote:

> Hi,
>
> Even I tried like this, It shows same error.
> For the username for the database, It automatically create a username
> than I given, Like if I put dbuser then It creates dbuser_ubITB7my.
> So Do I use this one? and I have used this one also, It shows same
> error.
>
> Thank you,
>
> Regards,
> Nilashan
>
>
> On Thu, Jul 10, 2014 at 7:58 AM, Danushka Fernando  > wrote:
>
>> Hi
>> When you use mysql client you have to give the host name for -h
>> option not the db URL. So try
>>
>> mysql -u dbuser -h mysql-
>> dev
>> -01.
>> cloud.wso2
>> .com
>>  -p
>> On Jul 9, 2014 10:56 PM, "Nilashan Namasivayam" 
>> wrote:
>>
>>> Hi,
>>>
>>> I'm trying to add some data to the database in App Cloud.
>>>
>>> The database url like this:
>>>   jdbc:mysql://mysql-dev-01.cloud.wso2.com:3306/db1_x
>>>
>>>
>>> and I have tried to connect via MySQL client like this
>>>  mysql -u dbuser -h jdbc:mysql://
>>> mysql-dev-01.cloud.wso2.com:3306/db1_x -p
>>>
>>> After trying the above code, I get this error in console
>>>   ERROR 2005 (HY000): Unknown MySQL server host 'jdbc:mysql://
>>> mysql-dev-01.cloud.wso2.com:3306/db1_x' (2)
>>>
>>> What can be the problem?
>>>
>>> I'm following this documentation:
>>>
>>> http://docs.wso2.com/display/AppCloud/Add+Data+to+my+Database+or+Connect+to+an+External+Database
>>>
>>> Do we need any additional configuration in App Cloud than mentioned
>>> in the above link?
>>>
>>>
>>> Regards,
>>> Nilashan
>>>
>>> ___
>>> Dev mailing list
>>> Dev@wso2.org
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>


 --

 Udara Liyanage
 Software Engineer
  WSO2, Inc.: http://wso2.com
 lean. enterprise. middleware

 web: http://udaraliyanage.wordpress.com
 phone: +94 71 443 6897

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


>>>
>>> ___
>>> Dev mailing list
>>> Dev@wso2.org
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>>
>
>
> --
> *Amila Maharachchi*
> Senior Technical Lead
> WSO2, Inc.; http://wso2.com
>
> Blog: http://maharachchi.blogspot.com
> Mobile: +94719371446
>
>
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Adding data to database in WSO2 App Cloud

[Gunarajah Pirinthan]

Hi
I got same error.

"ERROR 2005 (HY000): Unknown MySQL server host 
'jdbc:mysql://mysql-dev-01.cloud.wso2.com:3306/db1_x' (2)"

i don't know exactly problem but when i used dongle for Internet,  i did not 
get any error.  its works normal.



On Thursday, 10 July 2014 10:40 PM, Nilashan Namasivayam  
wrote:
 


Hi,

This problem has been solved.  The remote connection has been enabled.

Regards,
Nilashan 



On Thu, Jul 10, 2014 at 10:23 PM, Amila Maha Arachchi  wrote:

We'll look into this and get back to you.
>
>
>
>On Thu, Jul 10, 2014 at 11:57 AM, Danushka Fernando  wrote:
>
>Hi 
>>This is WSO2 Cloud hosted in EC2. So If it can be telnet, then it is open to 
>>the public. This is nothing to do with Infra. Amila can you check what's 
>>going wrong here.
>>
>>
>>Thanks & Regards
>>Danushka Fernando
>>Software Engineer
>>WSO2 inc. http://wso2.com/
>>Mobile : +94716332729
>>
>>
>>On Thu, Jul 10, 2014 at 11:44 AM, Firzhan Naqash  wrote:
>>
>>
>>>Hi,
>>>
>>>You have to get the remote connection enabled from the Infra. By default it 
>>>has been disabled.
>>>
>>>
>>>
>>>Regards,
>>>Firzhan
>>>
>>>
>>>
>>>On Thu, Jul 10, 2014 at 10:45 AM, Udara Liyanage  wrote:
>>>
>>>HI,


I tried telnet mysql-dev-01.cloud.wso2.com 3006 and there was a response. 
MySQL server seems to run on the given host and port. Please check whether 
remote login has enabled from MySQL server side.



On Thu, Jul 10, 2014 at 8:15 AM, Nilashan Namasivayam  
wrote:

Hi,
>
>
>Even I tried like this, It shows same error.
>For the username for the database, It automatically create a username than 
>I given, Like if I put dbuser then It creates dbuser_ubITB7my. So Do I use 
>this one? and I have used this one also, It shows same error.
>
>
>Thank you,
>
>
>Regards,
>Nilashan
>
>
>
>On Thu, Jul 10, 2014 at 7:58 AM, Danushka Fernando  
>wrote:
>
>Hi
>>When you use mysql client you have to give the host name for -h option 
>>not the db URL. So try
>>mysql -u dbuser -h mysql-dev-01.cloud.wso2.com -p 
>>On Jul 9, 2014 10:56 PM, "Nilashan Namasivayam"  
>>wrote:
>>
>>Hi,
>>>
>>>
>>>I'm trying to add some data to the database in App Cloud.
>>>
>>>
>>>The database url like this:
>>> jdbc:mysql://mysql-dev-01.cloud.wso2.com:3306/db1_x
>>>
>>>
>>>
>>>
>>>and I have tried to connect via MySQL client like this
>>>     mysql -u dbuser -h 
>>>jdbc:mysql://mysql-dev-01.cloud.wso2.com:3306/db1_x -p 
>>>
>>>
>>>
>>>After trying the above code, I get this error in console
>>> ERROR 2005 (HY000): Unknown MySQL server host 
>>>'jdbc:mysql://mysql-dev-01.cloud.wso2.com:3306/db1_x' (2)
>>>
>>>
>>>What can be the problem?
>>>
>>>
>>>I'm following this documentation:
>>>http://docs.wso2.com/display/AppCloud/Add+Data+to+my+Database+or+Connect+to+an+External+Database
>>>
>>>
>>>
>>>Do we need any additional configuration in App Cloud than mentioned in 
>>>the above link? 
>>>
>>>
>>>
>>>
>>>
>>>Regards,
>>>Nilashan
>>>___
>>>Dev mailing list
>>>Dev@wso2.org
>>>http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>
>___
>Dev mailing list
>Dev@wso2.org
>http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>



-- 


Udara Liyanage
Software Engineer
WSO2, Inc.: http://wso2.com
lean. enterprise. middleware


web: http://udaraliyanage.wordpress.com
phone: +94 71 443 6897

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


>>>
>>>___
>>>Dev mailing list
>>>Dev@wso2.org
>>>http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>>
>
>
>
>-- 
>
>Amila Maharachchi
>Senior Technical Lead
>WSO2, Inc.; http://wso2.com
>
>Blog: http://maharachchi.blogspot.com 
>Mobile: +94719371446
>
>


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