BOT TG Blocks Hosting

Bot Development, Python — incorrectly specified categories?

9 USD

Project translated automatically. Log in or register, to view the original There is a website.It is connected with a telegram of the bots, precisely to the database of the MYSQL site (the robot works with it).The bot after the recharge of the server does not run, the error is that the database banits the bot.Then I ask hosting to make a team: mysqladmin flush-hosts and then the bot can be launched.The source of the problem needs to be fixed.Types of errors - sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on '109.94.200.00'"), and pymysql.err.InternalError: Packet sequence number wrong - got 1 expected 0.- And on the telnet the sadness root@vps:~/hugme-bot# telnet 109.94.00.00 3306 Trying 109.94.200.000...Connected to 109.94.00.00Escape character is '^]'.kHost '78.140.000000' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host.Also in logs more than 200k errors.- ERROR - tgbot.services.scheduler - TRY SEND NOTIFICATION ERROR: Forbidden: user is deactivated Every 5 seconds the bot tried to send a message to the person that the bot banned.“Tri send notification error” By the way, the programmer left himself.But the error processing (e.g., removing the message from the cycle) has not been left.I so guess that it may be in the code something wrong is done (for example, those millions of logs), because now open 6 sessions, and the call-to error (from 15:45) increased from: Aborted clients 248.1 k Aborted connects 265.5 k to Aborted clients 248.9 k Aborted connects 275.3 k Finally, two of these problems must be solved.1 .Fix the source of the problem so that the bot doesn’t swim and it starts 2ndRemove the source of errors

Proposals 3 Discussions 3

Roman Kirnis

10 4

Projects 10
Rating -
Rating 558

Budget: 500 UAH Deadline: 1 day

Good Morning Ruslan.
I found a solution: to increase the possible number of connections or disconnect the bots from the databases when they are turned off.
The database is installed on the same server as the robot itself.
I will be happy to cooperate!

Vitalii Yesypenko

0 1

Projects -
Rating -
Rating 198

Budget: 2000 UAH Deadline: 5 days

Hello the reason from part I realized, with the TG bots and their loading to the server I have run for 3 years. The price can be agreed as well as the time.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Bot Development

Creation and launch of a Telegram bot that activates QR codes and manages a product promotion.

62 proposals 4 August

Not specified
AI Bot for Outlook

65 proposals 4 August

Not specified
Signal bot for trading

Python 71 proposals 31 July

67 USD
Creation of an OLX bot

64 proposals 30 July

Not specified
Create an SEO system based on n8n

AI & Machine Learning 61 proposals 30 July

Not specified

Ruslan Solom
Kharkiv, Ukraine

Projects 6
Rating -
Rating 144

Roman Kirnis

Vitalii Yesypenko

Proposals are currently absent

Current freelance projects in the category Bot Development

Creation and launch of a Telegram bot that activates QR codes and manages a product promotion.

AI Bot for Outlook

Signal bot for trading

Creation of an OLX bot

Create an SEO system based on n8n