www.digitalmars.com         C & C++   DMDScript  

digitalmars.D.learn - TimeoutException for connecting to MySQL using a hunt-entity.

reply greenbyte <lysenko765 yandex.ru> writes:
Hi, all!

I use the hunt-entity library to work with MySQL. I get the 
hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when 
trying to connect. I configured MySQL and ran the code from the 
instructions https://github.com/huntlabs/hunt-entity

MySQL:
mysql Ver 8.0.27 for Linux on x86_64 (MySQL Community Server - 
GPL)

DUB:
version 1.25.0, built on Apr 23 2021

In dub.json enabled "hunt-entity": "~>2.7.3"
Oct 22 2021
next sibling parent reply WebFreak001 <d.forum webfreak.org> writes:
On Friday, 22 October 2021 at 11:42:34 UTC, greenbyte wrote:
 Hi, all!

 I use the hunt-entity library to work with MySQL. I get the 
 hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when 
 trying to connect. I configured MySQL and ran the code from the 
 instructions https://github.com/huntlabs/hunt-entity

 MySQL:
 mysql Ver 8.0.27 for Linux on x86_64 (MySQL Community Server - 
 GPL)

 DUB:
 version 1.25.0, built on Apr 23 2021

 In dub.json enabled "hunt-entity": "~>2.7.3"
From the error message you posted it seems like it's failing to connect. Did you check that the IP address and port you are connecting to are correct? In case of localhost, try 127.0.0.1 instead of "localhost"
Oct 22 2021
parent reply greenbyte <lysenko765 yandex.ru> writes:
On Friday, 22 October 2021 at 11:51:03 UTC, WebFreak001 wrote:
 On Friday, 22 October 2021 at 11:42:34 UTC, greenbyte wrote:
 Hi, all!

 I use the hunt-entity library to work with MySQL. I get the 
 hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when 
 trying to connect. I configured MySQL and ran the code from 
 the instructions https://github.com/huntlabs/hunt-entity

 MySQL:
 mysql Ver 8.0.27 for Linux on x86_64 (MySQL Community Server - 
 GPL)

 DUB:
 version 1.25.0, built on Apr 23 2021

 In dub.json enabled "hunt-entity": "~>2.7.3"
From the error message you posted it seems like it's failing to connect. Did you check that the IP address and port you are connecting to are correct? In case of localhost, try 127.0.0.1 instead of "localhost"
Yes, I did.
Oct 24 2021
parent reply bauss <jj_1337 live.dk> writes:
On Sunday, 24 October 2021 at 20:58:22 UTC, greenbyte wrote:
 On Friday, 22 October 2021 at 11:51:03 UTC, WebFreak001 wrote:
 On Friday, 22 October 2021 at 11:42:34 UTC, greenbyte wrote:
 Hi, all!

 I use the hunt-entity library to work with MySQL. I get the 
 hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when 
 trying to connect. I configured MySQL and ran the code from 
 the instructions https://github.com/huntlabs/hunt-entity

 MySQL:
 mysql Ver 8.0.27 for Linux on x86_64 (MySQL Community Server 
 - GPL)

 DUB:
 version 1.25.0, built on Apr 23 2021

 In dub.json enabled "hunt-entity": "~>2.7.3"
From the error message you posted it seems like it's failing to connect. Did you check that the IP address and port you are connecting to are correct? In case of localhost, try 127.0.0.1 instead of "localhost"
Yes, I did.
Did you check your firewall configuration and that you're allowed to establish a connection to the port?
Oct 25 2021
parent greenbyte <lysenko765 yandex.ru> writes:
On Monday, 25 October 2021 at 07:15:42 UTC, bauss wrote:
 On Sunday, 24 October 2021 at 20:58:22 UTC, greenbyte wrote:
 On Friday, 22 October 2021 at 11:51:03 UTC, WebFreak001 wrote:
 On Friday, 22 October 2021 at 11:42:34 UTC, greenbyte wrote:
 Hi, all!

 I use the hunt-entity library to work with MySQL. I get the 
 hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when 
 trying to connect. I configured MySQL and ran the code from 
 the instructions https://github.com/huntlabs/hunt-entity

 MySQL:
 mysql Ver 8.0.27 for Linux on x86_64 (MySQL Community Server 
 - GPL)

 DUB:
 version 1.25.0, built on Apr 23 2021

 In dub.json enabled "hunt-entity": "~>2.7.3"
From the error message you posted it seems like it's failing to connect. Did you check that the IP address and port you are connecting to are correct? In case of localhost, try 127.0.0.1 instead of "localhost"
Yes, I did.
Did you check your firewall configuration and that you're allowed to establish a connection to the port?
Firewall disabled.
Oct 25 2021
prev sibling parent reply Imperatorn <johan_forsberg_86 hotmail.com> writes:
On Friday, 22 October 2021 at 11:42:34 UTC, greenbyte wrote:
 Hi, all!

 I use the hunt-entity library to work with MySQL. I get the 
 hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when 
 trying to connect. I configured MySQL and ran the code from the 
 instructions https://github.com/huntlabs/hunt-entity

 MySQL:
 mysql Ver 8.0.27 for Linux on x86_64 (MySQL Community Server - 
 GPL)

 DUB:
 version 1.25.0, built on Apr 23 2021

 In dub.json enabled "hunt-entity": "~>2.7.3"
And also of course triple check your credentials etc.
Oct 25 2021
parent reply greenbyte <lysenko765 yandex.ru> writes:
On Monday, 25 October 2021 at 07:45:26 UTC, Imperatorn wrote:
 On Friday, 22 October 2021 at 11:42:34 UTC, greenbyte wrote:
 Hi, all!

 I use the hunt-entity library to work with MySQL. I get the 
 hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when 
 trying to connect. I configured MySQL and ran the code from 
 the instructions https://github.com/huntlabs/hunt-entity

 MySQL:
 mysql Ver 8.0.27 for Linux on x86_64 (MySQL Community Server - 
 GPL)

 DUB:
 version 1.25.0, built on Apr 23 2021

 In dub.json enabled "hunt-entity": "~>2.7.3"
And also of course triple check your credentials etc.
Yes. When credentials don't match, I have AccessDenied exception.
Oct 25 2021
parent bauss <jj_1337 live.dk> writes:
On Monday, 25 October 2021 at 12:54:32 UTC, greenbyte wrote:
 On Monday, 25 October 2021 at 07:45:26 UTC, Imperatorn wrote:
 On Friday, 22 October 2021 at 11:42:34 UTC, greenbyte wrote:
 Hi, all!

 I use the hunt-entity library to work with MySQL. I get the 
 hunt.Exceptions.TimeoutException: "Timeout in 30 secs" when 
 trying to connect. I configured MySQL and ran the code from 
 the instructions https://github.com/huntlabs/hunt-entity

 MySQL:
 mysql Ver 8.0.27 for Linux on x86_64 (MySQL Community Server 
 - GPL)

 DUB:
 version 1.25.0, built on Apr 23 2021

 In dub.json enabled "hunt-entity": "~>2.7.3"
And also of course triple check your credentials etc.
Yes. When credentials don't match, I have AccessDenied exception.
Are you able to connect to the mysql using something else like a heidisql? Just to isolate whether the issue is mysql configuration or an actual problem with the package.
Oct 27 2021