You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@guacamole.apache.org by doyouhas <zj...@gmail.com> on 2018/10/23 18:57:23 UTC
"Communications link failure" Exception being thrown.... Dear god
help
I have pasted the relevant contents of the catalina.out file to the link
below, as in the past some people have complained about code formatting.
When I began testing my application, I was actually running a mysql server
on an ec2 instance instead of running against an RDS instance. So my
database currently is residing in an Aurora serverless cluster. I haven't
experienced this exception before. That is the only major differences
between my earlier test configurations. I am really stuck here, I have no
idea where to begin troubleshooting this issue. Checked the syslog, no
relevant messages logged there. I get the classic "blank screen" situation
that I have posted about in the past. Any help on this would be greatly
appreciated.
--Zach
http://dpaste.com/0GJ63JE
--
Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
Re: "Communications link failure" Exception being thrown.... Dear
god help
Posted by doyouhas <zj...@gmail.com>.
I wish you had a little more faith in me than that. Yes I made sure I was
able to establish a connection with the cluster by using the mysql client
with the same credentials I provided to guacamole. I was able to get into
the console no problem.
--
Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
Re: "Communications link failure" Exception being thrown.... Dear
god help
Posted by doyouhas <zj...@gmail.com>.
Alright guys. I have an update to this story. I put together a small java
class for the purpose of testing JDBC functionality on the EC2 instance in
question. I was able to execute a query successfully against my database
using the same MySQL jar that resides in my /etc/guacamole/lib folder. So I
am fairly confident now there is an issue with my configuration, the RDS
cluster is not the issue. I tried to do the bare minimum config according to
the docs. The current layout of my /etc/guacamole directory:
/etc/guacamole/lib/mysql-connector-java-8.0.12.jar
/etc/guacamole/extensions/guacamole-auth-jdbc-mysql-0.9.14.jar
My guacamole.properties file is as follows:
# Guacd settings
guacd-hostname: localhost
guacd-port: 4822
# MySQL properties
mysql-hostname: <hostname>
mysql-port: 3306
mysql-database: <db>
mysql-username: <user>
mysql-password: <password>
--
Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
Re: "Communications link failure" Exception being thrown.... Dear god help
Posted by Zachary Piazza <zj...@gmail.com>.
Until I get a response from aws I'm just gonna use a regular mysql server
on an ec2 instance which should work no problem. Thanks again for all the
suggestions guys, you are awesome.
On Tue, Oct 23, 2018, 3:17 PM Nick Couchman <vn...@apache.org> wrote:
> On Tue, Oct 23, 2018 at 4:08 PM Zachary Piazza <zj...@gmail.com> wrote:
>
>> You don't have to apologize my dude I appreciate any input. Gonna open up
>> a aws support ticket and see what they can tell me. How would I use the
>> MariaDB connector with guacamole tho? There's no Auth extension for Maria.
>>
>
> It shouldn't matter, since it's all supposed to be compatible, but, yes,
> you are correct, currently you cannot use the MariaDB Connector/J with
> Guacamole because the classes won't match up.
>
> -Nick
>
>>
Re: "Communications link failure" Exception being thrown.... Dear god help
Posted by Nick Couchman <vn...@apache.org>.
On Tue, Oct 23, 2018 at 4:08 PM Zachary Piazza <zj...@gmail.com> wrote:
> You don't have to apologize my dude I appreciate any input. Gonna open up
> a aws support ticket and see what they can tell me. How would I use the
> MariaDB connector with guacamole tho? There's no Auth extension for Maria.
>
It shouldn't matter, since it's all supposed to be compatible, but, yes,
you are correct, currently you cannot use the MariaDB Connector/J with
Guacamole because the classes won't match up.
-Nick
>
Re: "Communications link failure" Exception being thrown.... Dear god help
Posted by Erik Berndt <er...@superiorpaving.net>.
MariaDB is a fork of MySQL, so the mysql-auth extension should work the
same as it does with MySQL.
Erik Berndt
On Tue, Oct 23, 2018 at 4:08 PM Zachary Piazza <zj...@gmail.com> wrote:
> You don't have to apologize my dude I appreciate any input. Gonna open up
> a aws support ticket and see what they can tell me. How would I use the
> MariaDB connector with guacamole tho? There's no Auth extension for Maria.
>
> On Tue, Oct 23, 2018, 3:04 PM Nick Couchman <vn...@apache.org> wrote:
>
>> On Tue, Oct 23, 2018 at 3:32 PM doyouhas <zj...@gmail.com> wrote:
>>
>>> I checked my cloudwatch logs. Nothing relating to this problem was logged
>>> there. And as I stated in my previous post, on the instance where I've
>>> installed guacamole, I installed the mysql client and can connect to the
>>> database fine. I'm thinking it must have something to do with JDBC and
>>> AWS
>>> RDS, bc when I install mysql server on a physical instance, it doesn't
>>> have
>>> this issue. But I'm not pro enough with java to understand this JDBC
>>> failure.
>>>
>>>
>> I'm guessing you're using a recent-ish version of the MySQL driver in
>> your Guacamole instance? According to Amazon's docs they recommend the
>> MariaDB Connector/J JDBC connector for connecting to Aurora, but I'm
>> guessing MySQL should work fine, too. Also, looks like Aurora can be set
>> up to use SSL/TLS - is that enabled/required/default on your Aurora
>> instance?
>>
>> Sorry, trying to help but kind of shooting in the dark, here - I agree
>> with the other folks that have responded that it really feels like some
>> sort of network connectivity, firewall, or VDC configuration issue that is
>> blocking the JDBC connection from hitting the Aurora instance.
>>
>> -Nick
>>
>
--
This
e-mail and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. If you are not the intended recipient or the person
responsible for delivering the e-mail to the intended recipient, be
advised that you have received this e-mail in error and that any use,
dissemination, forwarding, printing or copying of this e-mail is
strictly
prohibited. If you have received this e-mail in error, please
immediately
notify Superior Paving Corp. by telephone at (703)
631-0004. You will be
reimbursed for reasonable costs incurred in
notifying us.
Re: "Communications link failure" Exception being thrown.... Dear god help
Posted by Zachary Piazza <zj...@gmail.com>.
You don't have to apologize my dude I appreciate any input. Gonna open up a
aws support ticket and see what they can tell me. How would I use the
MariaDB connector with guacamole tho? There's no Auth extension for Maria.
On Tue, Oct 23, 2018, 3:04 PM Nick Couchman <vn...@apache.org> wrote:
> On Tue, Oct 23, 2018 at 3:32 PM doyouhas <zj...@gmail.com> wrote:
>
>> I checked my cloudwatch logs. Nothing relating to this problem was logged
>> there. And as I stated in my previous post, on the instance where I've
>> installed guacamole, I installed the mysql client and can connect to the
>> database fine. I'm thinking it must have something to do with JDBC and AWS
>> RDS, bc when I install mysql server on a physical instance, it doesn't
>> have
>> this issue. But I'm not pro enough with java to understand this JDBC
>> failure.
>>
>>
> I'm guessing you're using a recent-ish version of the MySQL driver in your
> Guacamole instance? According to Amazon's docs they recommend the MariaDB
> Connector/J JDBC connector for connecting to Aurora, but I'm guessing MySQL
> should work fine, too. Also, looks like Aurora can be set up to use
> SSL/TLS - is that enabled/required/default on your Aurora instance?
>
> Sorry, trying to help but kind of shooting in the dark, here - I agree
> with the other folks that have responded that it really feels like some
> sort of network connectivity, firewall, or VDC configuration issue that is
> blocking the JDBC connection from hitting the Aurora instance.
>
> -Nick
>
Re: "Communications link failure" Exception being thrown.... Dear god help
Posted by Nick Couchman <vn...@apache.org>.
On Tue, Oct 23, 2018 at 3:32 PM doyouhas <zj...@gmail.com> wrote:
> I checked my cloudwatch logs. Nothing relating to this problem was logged
> there. And as I stated in my previous post, on the instance where I've
> installed guacamole, I installed the mysql client and can connect to the
> database fine. I'm thinking it must have something to do with JDBC and AWS
> RDS, bc when I install mysql server on a physical instance, it doesn't have
> this issue. But I'm not pro enough with java to understand this JDBC
> failure.
>
>
I'm guessing you're using a recent-ish version of the MySQL driver in your
Guacamole instance? According to Amazon's docs they recommend the MariaDB
Connector/J JDBC connector for connecting to Aurora, but I'm guessing MySQL
should work fine, too. Also, looks like Aurora can be set up to use
SSL/TLS - is that enabled/required/default on your Aurora instance?
Sorry, trying to help but kind of shooting in the dark, here - I agree with
the other folks that have responded that it really feels like some sort of
network connectivity, firewall, or VDC configuration issue that is blocking
the JDBC connection from hitting the Aurora instance.
-Nick
Re: "Communications link failure" Exception being thrown.... Dear
god help
Posted by doyouhas <zj...@gmail.com>.
I checked my cloudwatch logs. Nothing relating to this problem was logged
there. And as I stated in my previous post, on the instance where I've
installed guacamole, I installed the mysql client and can connect to the
database fine. I'm thinking it must have something to do with JDBC and AWS
RDS, bc when I install mysql server on a physical instance, it doesn't have
this issue. But I'm not pro enough with java to understand this JDBC
failure.
--
Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
Re: "Communications link failure" Exception being thrown.... Dear god help
Posted by Erik Berndt <er...@superiorpaving.net>.
Hey Zach,
>The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.Oct 23, 2018 6:28:44 PM com.sun.jersey.spi.container.ContainerResponse logExceptionSEVERE: Mapped exception to response: 500 (Internal Server Error)
Have you checked any of the AWS logs? Based on the text above, there may be
something relevant there as to why the db server is not responding. Are you
able to ping across from the Guacamole instance to the db server and
vice-versa?
Erik Berndt
On Tue, Oct 23, 2018 at 3:09 PM Mike Jumper <mj...@apache.org> wrote:
> Are you sure the database is reachable over the network from the Guacamole
> server? Not blocked by an AWS security group, subnet is in routing tables,
> etc.?
>
> - Mike
>
> On Tue, Oct 23, 2018, 11:57 doyouhas <zj...@gmail.com> wrote:
>
>> I have pasted the relevant contents of the catalina.out file to the link
>> below, as in the past some people have complained about code formatting.
>> When I began testing my application, I was actually running a mysql server
>> on an ec2 instance instead of running against an RDS instance. So my
>> database currently is residing in an Aurora serverless cluster. I haven't
>> experienced this exception before. That is the only major differences
>> between my earlier test configurations. I am really stuck here, I have no
>> idea where to begin troubleshooting this issue. Checked the syslog, no
>> relevant messages logged there. I get the classic "blank screen" situation
>> that I have posted about in the past. Any help on this would be greatly
>> appreciated.
>>
>> --Zach
>>
>> http://dpaste.com/0GJ63JE
>>
>>
>>
>>
>> --
>> Sent from:
>> http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
>>
>
--
This
e-mail and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. If you are not the intended recipient or the person
responsible for delivering the e-mail to the intended recipient, be
advised that you have received this e-mail in error and that any use,
dissemination, forwarding, printing or copying of this e-mail is
strictly
prohibited. If you have received this e-mail in error, please
immediately
notify Superior Paving Corp. by telephone at (703)
631-0004. You will be
reimbursed for reasonable costs incurred in
notifying us.
Re: "Communications link failure" Exception being thrown.... Dear god help
Posted by Mike Jumper <mj...@apache.org>.
Are you sure the database is reachable over the network from the Guacamole
server? Not blocked by an AWS security group, subnet is in routing tables,
etc.?
- Mike
On Tue, Oct 23, 2018, 11:57 doyouhas <zj...@gmail.com> wrote:
> I have pasted the relevant contents of the catalina.out file to the link
> below, as in the past some people have complained about code formatting.
> When I began testing my application, I was actually running a mysql server
> on an ec2 instance instead of running against an RDS instance. So my
> database currently is residing in an Aurora serverless cluster. I haven't
> experienced this exception before. That is the only major differences
> between my earlier test configurations. I am really stuck here, I have no
> idea where to begin troubleshooting this issue. Checked the syslog, no
> relevant messages logged there. I get the classic "blank screen" situation
> that I have posted about in the past. Any help on this would be greatly
> appreciated.
>
> --Zach
>
> http://dpaste.com/0GJ63JE
>
>
>
>
> --
> Sent from:
> http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
>