error Opencart Cannot connect to database: Connection timed out
boxing stopped connecting to openkart.
gives error
Please help, where to dig? where is the problem in the box or on hosting?
Access on the hosting for the IP box is registered
Access to the open card for the IP box is registered in the admin
The database password has been updated and registered in access
A new API is generated on the site and registered in the settings and in Kron.php
kroner is written in the schedule
PHP 7.1 settings were not changed
gives error
Please help, where to dig? where is the problem in the box or on hosting?
Access on the hosting for the IP box is registered
Access to the open card for the IP box is registered in the admin
The database password has been updated and registered in access
A new API is generated on the site and registered in the settings and in Kron.php
kroner is written in the schedule
PHP 7.1 settings were not changed
screenshot_1.png
screenshot_2.png
screenshot_3.png
screenshot_4.png
screenshot_5.png
screenshot_6.png
screenshot_7.png
screenshot_8.png
screenshot_9.png
Original question is available on version: ua
Answers:
Good afternoon.
The host hosting your Opencart database (db24.freehost.com.ua) is unavailable from the box server.
# ping db24.freehost.com.ua
PING db24.freehost.com.ua (185.13.5.124) 56(84) bytes of data.
^C
--- ping statistics ---
4 packets transmitted, 0 received, 100% packet loss, time 2999ms
The coloration says that our server or hoster is not responding.
mtr --report -c 10 --timeout=3 db24.freehost.com.ua
Start: Mon May 8 15:43:49 2023
HOST: lums.crm-onebox.com Loss% Snt Last Avg Best Wrst StDev
1.|-- gateway 0.0% 10 2.1 2.3 2.0 2.6 0.0
2.|-- 15884.your-cloud.host 0.0% 10 0.3 0.3 0.2 0.7 0.0
3.|-- ??? 100.0 10 0.0 0.0 0.0 0.0 0.0
4.|-- static.88.198.252.165.cli 0.0% 10 0.9 6.5 0.9 38.3 12.2
5.|-- spine11.cloud1.nbg1.hetzn 0.0% 10 1.0 4.1 0.9 30.6 9.3
6.|-- core11.nbg1.hetzner.com 0.0% 10 0.6 1.7 0.6 9.4 2.7
7.|-- core4.fra.hetzner.com 0.0% 10 3.6 3.9 3.6 4.6 0.0
8.|-- core8.fra.hetzner.com 0.0% 10 3.8 4.0 3.8 4.3 0.0
9.|-- freehost2-ix.giganet.ua 0.0% 10 28.6 30.0 28.5 33.2 1.5
10.|-- ??? 100.0 10 0.0 0.0 0.0 0.0 0.0
# traceroute db24.freehost.com.ua
traceroute to db24.freehost.com.ua (185.13.5.124), 30 hops max, 60 byte packets
1 gateway (172.31.1.1) 5.071ms 4.864ms 4.983ms
2 15884.your-cloud.host (49.12.139.69) 0.502 ms 0.646 ms 0.610 ms
3 * * *
4 static.88.198.252.161.clients.your-server.de (88.198.252.161) 1.598 ms 1.917 ms 2.222 ms
5 spine12.cloud1.nbg1.hetzner.com (78.47.3.45) 1.308 ms 1.683 ms spine11.cloud1.nbg1.hetzner.com (213.133.108.149) 1.272 ms
6 core12.nbg1.hetzner.com (213.239.239.141) 13.311 ms core12.nbg1.hetzner.com (213.133.112.85) 0.521 ms
7 core4.fra.hetzner.com (213.239.245.33) 3.609 ms core0.fra.hetzner.com (213.239.252.25) 9.468 ms
8 core8.fra.hetzner.com (213.239.245.86) 3.802 ms 3.793 ms core8.fra.hetzner.com (213.239.224.217) 3.641 ms
9 freehost2-ix.giganet.ua (185.1.62.193) 28.297 ms 28.373 ms 28.138 ms
10 * * *
eleven * * *
12 * * *
13 * * *
14 * * *
*****
The host hosting your Opencart database (db24.freehost.com.ua) is unavailable from the box server.
# ping db24.freehost.com.ua
PING db24.freehost.com.ua (185.13.5.124) 56(84) bytes of data.
^C
--- ping statistics ---
4 packets transmitted, 0 received, 100% packet loss, time 2999ms
The coloration says that our server or hoster is not responding.
mtr --report -c 10 --timeout=3 db24.freehost.com.ua
Start: Mon May 8 15:43:49 2023
HOST: lums.crm-onebox.com Loss% Snt Last Avg Best Wrst StDev
1.|-- gateway 0.0% 10 2.1 2.3 2.0 2.6 0.0
2.|-- 15884.your-cloud.host 0.0% 10 0.3 0.3 0.2 0.7 0.0
3.|-- ??? 100.0 10 0.0 0.0 0.0 0.0 0.0
4.|-- static.88.198.252.165.cli 0.0% 10 0.9 6.5 0.9 38.3 12.2
5.|-- spine11.cloud1.nbg1.hetzn 0.0% 10 1.0 4.1 0.9 30.6 9.3
6.|-- core11.nbg1.hetzner.com 0.0% 10 0.6 1.7 0.6 9.4 2.7
7.|-- core4.fra.hetzner.com 0.0% 10 3.6 3.9 3.6 4.6 0.0
8.|-- core8.fra.hetzner.com 0.0% 10 3.8 4.0 3.8 4.3 0.0
9.|-- freehost2-ix.giganet.ua 0.0% 10 28.6 30.0 28.5 33.2 1.5
10.|-- ??? 100.0 10 0.0 0.0 0.0 0.0 0.0
# traceroute db24.freehost.com.ua
traceroute to db24.freehost.com.ua (185.13.5.124), 30 hops max, 60 byte packets
1 gateway (172.31.1.1) 5.071ms 4.864ms 4.983ms
2 15884.your-cloud.host (49.12.139.69) 0.502 ms 0.646 ms 0.610 ms
3 * * *
4 static.88.198.252.161.clients.your-server.de (88.198.252.161) 1.598 ms 1.917 ms 2.222 ms
5 spine12.cloud1.nbg1.hetzner.com (78.47.3.45) 1.308 ms 1.683 ms spine11.cloud1.nbg1.hetzner.com (213.133.108.149) 1.272 ms
6 core12.nbg1.hetzner.com (213.239.239.141) 13.311 ms core12.nbg1.hetzner.com (213.133.112.85) 0.521 ms
7 core4.fra.hetzner.com (213.239.245.33) 3.609 ms core0.fra.hetzner.com (213.239.252.25) 9.468 ms
8 core8.fra.hetzner.com (213.239.245.86) 3.802 ms 3.793 ms core8.fra.hetzner.com (213.239.224.217) 3.641 ms
9 freehost2-ix.giganet.ua (185.1.62.193) 28.297 ms 28.373 ms 28.138 ms
10 * * *
eleven * * *
12 * * *
13 * * *
14 * * *
*****
Donats
1
10 USD from Юрий Олегович Захарюгин
08.05.2023, 15:50
Original comment available on version: ru
host's TP response
- Access to the database is available only from Ukrainian IP
- the HTTP server was attacked from this IP address (banned on 26.04), can this be the case?
- Access to the database is available only from Ukrainian IP
- the HTTP server was attacked from this IP address (banned on 26.04), can this be the case?
09.05.2023, 10:59
Original comment available on version: ua
Good day.
Yuri Olegovich Zakharyugin wrote:
can you re-popping access?
Access is currently open.
Yuri Olegovich Zakharyugin wrote:
- the HTTP server was attacked from this IP address (banned on 26.04), can this be the case?
Not likely.
Yuri Olegovich Zakharyugin wrote:
can you re-popping access?
Access is currently open.
Yuri Olegovich Zakharyugin wrote:
- the HTTP server was attacked from this IP address (banned on 26.04), can this be the case?
Not likely.
09.05.2023, 14:38
Original comment available on version: ua
thank you
does everything, the orders went to the box
donated for coffee
does everything, the orders went to the box
donated for coffee
09.05.2023, 15:42
Original comment available on version: ua
Greetings, I will continue this topic
my IP got banned again on the hosting
comment from the hosting "the ip address was banned because there was a heavy load on the web server, if the situation repeats, the ip will be banned again"
Yuriy (11:39:57) : A large number of requests to the hosting IP address: 185.13.5.59 for this ip 116.203.109.143
Yuriy (11:40:21) : But why do the requests go to the http server and not the database
Developers, can you look at the plague like this? why is there a large number of requests and overload?
my IP got banned again on the hosting
comment from the hosting "the ip address was banned because there was a heavy load on the web server, if the situation repeats, the ip will be banned again"
Yuriy (11:39:57) : A large number of requests to the hosting IP address: 185.13.5.59 for this ip 116.203.109.143
Yuriy (11:40:21) : But why do the requests go to the http server and not the database
Developers, can you look at the plague like this? why is there a large number of requests and overload?
29.05.2023, 12:09
Original comment available on version: ua
Good day.
If you have questions related to those discussed in the closed topic, it is better to make a new request and provide a link to the topic.
Now to your question:
You have the following actions in the automation once a minute:
Import processes from opencart - 2 pcs
Import users from opencart - 2 pcs
Import of quick orders from opencart - 2 pcs
Will update availability in opencart
They work as API requests over http
Requests should not cause a large load.
If you have questions related to those discussed in the closed topic, it is better to make a new request and provide a link to the topic.
Now to your question:
You have the following actions in the automation once a minute:
Import processes from opencart - 2 pcs
Import users from opencart - 2 pcs
Import of quick orders from opencart - 2 pcs
Will update availability in opencart
They work as API requests over http
Requests should not cause a large load.
29.05.2023, 14:46
Original comment available on version: ua
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
