Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Error for docker:mysql #13

Open
llwh2333 opened this issue Mar 31, 2023 · 4 comments
Open

Error for docker:mysql #13

llwh2333 opened this issue Mar 31, 2023 · 4 comments

Comments

@llwh2333
Copy link

llwh2333 commented Mar 31, 2023 •
edited

I try to run./quick_start.sh firstly ,but it alway return me

INFO:root:Setting up MySQL connector with connector string: mysql+mysqlconnector://informer:informer_P455w0rd!@172.17.0.1:3307/informer_db?charset=utf8mb4&collation=utf8mb4_general_ci ... 


INFO:root:Attempting to load user session from database with account_id ********* ...

Traceback (most recent call last):
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/mysql/connector/network.py", line 529, in open_connection
    self.sock.connect(sockaddr)
ConnectionRefusedError: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect
    return fn()
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 363, in connect
    return _ConnectionFairy._checkout(self)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
    rec = pool._do_get()
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 138, in _do_get
    with util.safe_reraise():
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
    raise value
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
    return self._create_connection()
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
    return _ConnectionRecord(self)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
    self.__connect(first_connect_check=True)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
    connection = pool._invoke_creator(self)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
    return dialect.connect(*cargs, **cparams)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 482, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/mysql/connector/__init__.py", line 177, in connect
    return MySQLConnection(*args, **kwargs)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/mysql/connector/connection.py", line 104, in __init__
    self.connect(**kwargs)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/mysql/connector/abstracts.py", line 781, in connect
    self._open_connection()
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/mysql/connector/connection.py", line 284, in _open_connection
    self._socket.open_connection()
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/mysql/connector/network.py", line 531, in open_connection
    raise errors.InterfaceError(
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '172.17.0.1:3307' (111 Connection refused)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/root/informer-test/app/bot.py", line 42, in <module>
    informer = TGInformer(
  File "/root/informer-test/app/informer.py", line 133, in __init__
    self.account = self.session.query(Account).filter_by(account_id=tg_account_id).first()
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3265, in first
    ret = list(self[0:1])
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3043, in __getitem__
    return list(res)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3367, in __iter__
    return self._execute_and_instances(context)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3388, in _execute_and_instances
    conn = self._get_bind_args(
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3403, in _get_bind_args
    return fn(
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3382, in _connection_from_session
    conn = self.session.connection(**kw)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1121, in connection
    return self._connection_for_bind(
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1129, in _connection_for_bind
    return self.transaction._connection_for_bind(
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 431, in _connection_for_bind
    conn = bind._contextual_connect()
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2242, in _contextual_connect
    self._wrap_pool_connect(self.pool.connect, None),
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2279, in _wrap_pool_connect
    Connection._handle_dbapi_exception_noconnection(
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1547, in _handle_dbapi_exception_noconnection
    util.raise_from_cause(sqlalchemy_exception, exc_info)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
    raise value.with_traceback(tb)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect
    return fn()
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 363, in connect
    return _ConnectionFairy._checkout(self)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
    rec = pool._do_get()
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 138, in _do_get
    with util.safe_reraise():
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
    raise value
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
    return self._create_connection()
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
    return _ConnectionRecord(self)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
    self.__connect(first_connect_check=True)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
    connection = pool._invoke_creator(self)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
    return dialect.connect(*cargs, **cparams)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 482, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/mysql/connector/__init__.py", line 177, in connect
    return MySQLConnection(*args, **kwargs)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/mysql/connector/connection.py", line 104, in __init__
    self.connect(**kwargs)
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/mysql/connector/abstracts.py", line 781, in connect
    self._open_connection()
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/mysql/connector/connection.py", line 284, in _open_connection
    self._socket.open_connection()
  File "/root/informer-test/app/venv/lib/python3.10/site-packages/mysql/connector/network.py", line 531, in open_connection
    raise errors.InterfaceError(
sqlalchemy.exc.InterfaceError: (mysql.connector.errors.InterfaceError) 2003: Can't connect to MySQL server on '172.17.0.1:3307' (111 Connection refused)

I run it on Centos 7,I don't know why.
@dexteon
Copy link

dexteon commented Mar 30, 2024

Did you ever address this issue? Im still having it.

./start.sh Building app_informer Sending build context to Docker daemon 97.27MB Step 1/6 : FROM python:3.7-alpine ---> 1bac8ae77e4a Step 2/6 : RUN apk add --no-cache gcc musl-dev ---> Using cache ---> d414fb0a1b6e Step 3/6 : RUN apk update && apk upgrade && apk add git alpine-sdk bash python3 ---> Using cache ---> 8e84786d6690 Step 4/6 : COPY app /usr/local/app ---> Using cache ---> c47c2b543954 Step 5/6 : WORKDIR /usr/local/app ---> Using cache ---> 500f921a1d76 Step 6/6 : RUN pip3 install -r requirements.txt ---> Using cache ---> 5f35223df71f Successfully built 5f35223df71f Successfully tagged informer_app_informer:latest db_informer is up-to-date dozzle is up-to-date Starting app_informer ... done Attaching to db_informer, dozzle, app_informer dozzle | time="2024-03-30T02:15:45Z" level=info msg="Dozzle version v6.4.2" dozzle | time="2024-03-30T02:15:45Z" level=info msg="Connected to 1 Docker Engine(s)" dozzle | time="2024-03-30T02:15:45Z" level=info msg="Accepting connections on :8080" dozzle | time="2024-03-30T02:16:33Z" level=info msg="shutting down gracefully, press Ctrl+C again to force" dozzle | time="2024-03-30T02:16:41Z" level=info msg="Dozzle version v6.4.2" dozzle | time="2024-03-30T02:16:41Z" level=info msg="Connected to 1 Docker Engine(s)" dozzle | time="2024-03-30T02:16:41Z" level=info msg="Accepting connections on :8080" dozzle | time="2024-03-30T02:17:11Z" level=info msg="shutting down gracefully, press Ctrl+C again to force" dozzle | time="2024-03-30T02:35:59Z" level=info msg="Dozzle version v6.4.2" dozzle | time="2024-03-30T02:35:59Z" level=info msg="Connected to 1 Docker Engine(s)" dozzle | time="2024-03-30T02:35:59Z" level=info msg="Accepting connections on :8080" dozzle | time="2024-03-30T02:43:05Z" level=info msg="shutting down gracefully, press Ctrl+C again to force" dozzle | time="2024-03-30T02:43:49Z" level=info msg="Dozzle version v6.4.2" dozzle | time="2024-03-30T02:43:49Z" level=info msg="Connected to 1 Docker Engine(s)" dozzle | time="2024-03-30T02:43:49Z" level=info msg="Accepting connections on :8080" dozzle | time="2024-03-30T02:44:57Z" level=info msg="shutting down gracefully, press Ctrl+C again to force" dozzle | time="2024-03-30T02:45:06Z" level=info msg="Dozzle version v6.4.2" dozzle | time="2024-03-30T02:45:06Z" level=info msg="Connected to 1 Docker Engine(s)" dozzle | time="2024-03-30T02:45:06Z" level=info msg="Accepting connections on :8080" dozzle | time="2024-03-30T02:48:14Z" level=info msg="shutting down gracefully, press Ctrl+C again to force" dozzle | time="2024-03-30T02:53:22Z" level=info msg="Dozzle version v6.4.2" dozzle | time="2024-03-30T02:53:22Z" level=info msg="Connected to 1 Docker Engine(s)" dozzle | time="2024-03-30T02:53:22Z" level=info msg="Accepting connections on :8080" dozzle | time="2024-03-30T03:02:18Z" level=info msg="shutting down gracefully, press Ctrl+C again to force" dozzle | time="2024-03-30T03:02:23Z" level=info msg="Dozzle version v6.4.2" dozzle | time="2024-03-30T03:02:23Z" level=info msg="Connected to 1 Docker Engine(s)" dozzle | time="2024-03-30T03:02:23Z" level=info msg="Accepting connections on :8080" db_informer | 2024-03-30 02:53:22+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started. db_informer | 2024-03-30 02:53:22+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' db_informer | 2024-03-30 02:53:22+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started. db_informer | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' db_informer | 2024-03-30T02:53:23.141898Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). db_informer | 2024-03-30T02:53:23.144164Z 0 [Note] mysqld (mysqld 5.7.44) starting as process 1 ... db_informer | 2024-03-30T02:53:23.149915Z 0 [Note] InnoDB: PUNCH HOLE support available db_informer | 2024-03-30T02:53:23.150310Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins db_informer | 2024-03-30T02:53:23.150365Z 0 [Note] InnoDB: Uses event mutexes db_informer | 2024-03-30T02:53:23.150414Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier db_informer | 2024-03-30T02:53:23.150462Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 db_informer | 2024-03-30T02:53:23.150503Z 0 [Note] InnoDB: Using Linux native AIO db_informer | 2024-03-30T02:53:23.150968Z 0 [Note] InnoDB: Number of pools: 1 db_informer | 2024-03-30T02:53:23.151663Z 0 [Note] InnoDB: Using CPU crc32 instructions db_informer | 2024-03-30T02:53:23.154467Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M db_informer | 2024-03-30T02:53:23.169573Z 0 [Note] InnoDB: Completed initialization of buffer pool db_informer | 2024-03-30T02:53:23.171851Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). db_informer | 2024-03-30T02:53:23.186187Z 0 [Note] InnoDB: Highest supported file format is Barracuda. db_informer | 2024-03-30T02:53:23.193244Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables db_informer | 2024-03-30T02:53:23.193308Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... db_informer | 2024-03-30T02:53:23.240798Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. db_informer | 2024-03-30T02:53:23.243269Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. db_informer | 2024-03-30T02:53:23.243282Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. db_informer | 2024-03-30T02:53:23.244068Z 0 [Note] InnoDB: Waiting for purge to start db_informer | 2024-03-30T02:53:23.294566Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 12219446 db_informer | 2024-03-30T02:53:23.295073Z 0 [Note] Plugin 'FEDERATED' is disabled. db_informer | 2024-03-30T02:53:23.295608Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool db_informer | 2024-03-30T02:53:23.296617Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240330 2:53:23 db_informer | 2024-03-30T02:53:23.303980Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. db_informer | 2024-03-30T02:53:23.304020Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. db_informer | 2024-03-30T02:53:23.304025Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. db_informer | 2024-03-30T02:53:23.304027Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. db_informer | 2024-03-30T02:53:23.304476Z 0 [Warning] CA certificate ca.pem is self signed. db_informer | 2024-03-30T02:53:23.304544Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. db_informer | 2024-03-30T02:53:23.304759Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 db_informer | 2024-03-30T02:53:23.304825Z 0 [Note] IPv6 is available. db_informer | 2024-03-30T02:53:23.304834Z 0 [Note] - '::' resolves to '::'; db_informer | 2024-03-30T02:53:23.304850Z 0 [Note] Server socket created on IP: '::'. db_informer | 2024-03-30T02:53:23.305926Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. db_informer | 2024-03-30T02:53:23.316646Z 0 [Note] Event Scheduler: Loaded 0 events db_informer | 2024-03-30T02:53:23.318040Z 0 [Note] mysqld: ready for connections. db_informer | Version: '5.7.44' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) db_informer | 2024-03-30T02:54:47.896313Z 2 [Note] Got packets out of order db_informer | 2024-03-30T02:54:48.231277Z 3 [Note] Got packets out of order db_informer | 2024-03-30T02:55:10.328993Z 4 [Note] Access denied for user 'informer'@'172.18.0.1' (using password: YES) db_informer | 2024-03-30T02:56:34.418330Z 5 [Note] Access denied for user 'informer'@'172.18.0.1' (using password: YES) db_informer | 2024-03-30T02:56:50.905621Z 6 [Note] Access denied for user 'root'@'localhost' (using password: YES) db_informer | 2024-03-30T02:56:59.931466Z 7 [Note] Access denied for user 'root'@'localhost' (using password: NO) db_informer | 2024-03-30T02:58:42.300873Z 8 [Note] Access denied for user 'root'@'localhost' (using password: YES) db_informer | 2024-03-30T02:59:43.900970Z 10 [Note] Access denied for user 'root'@'localhost' (using password: YES) db_informer | 2024-03-30T03:00:44.221704Z 12 [Note] Unknown database 'root' db_informer | 2024-03-30T03:02:18.148158Z 0 [Note] Giving 1 client threads a chance to die gracefully db_informer | 2024-03-30T03:02:18.148208Z 0 [Note] Shutting down slave threads db_informer | 2024-03-30 03:02:23+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started. db_informer | 2024-03-30 03:02:23+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' db_informer | 2024-03-30 03:02:23+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started. db_informer | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' db_informer | 2024-03-30T03:02:24.329450Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). db_informer | 2024-03-30T03:02:24.330480Z 0 [Note] mysqld (mysqld 5.7.44) starting as process 1 ... db_informer | 2024-03-30T03:02:24.333882Z 0 [Note] InnoDB: PUNCH HOLE support available db_informer | 2024-03-30T03:02:24.333925Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins db_informer | 2024-03-30T03:02:24.333931Z 0 [Note] InnoDB: Uses event mutexes db_informer | 2024-03-30T03:02:24.333933Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier db_informer | 2024-03-30T03:02:24.333935Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 db_informer | 2024-03-30T03:02:24.333937Z 0 [Note] InnoDB: Using Linux native AIO db_informer | 2024-03-30T03:02:24.334189Z 0 [Note] InnoDB: Number of pools: 1 db_informer | 2024-03-30T03:02:24.334354Z 0 [Note] InnoDB: Using CPU crc32 instructions db_informer | 2024-03-30T03:02:24.336137Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M db_informer | 2024-03-30T03:02:24.342661Z 0 [Note] InnoDB: Completed initialization of buffer pool db_informer | 2024-03-30T03:02:24.344896Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). db_informer | 2024-03-30T03:02:24.357692Z 0 [Note] InnoDB: Highest supported file format is Barracuda. db_informer | 2024-03-30T03:02:24.359169Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 12219465 db_informer | 2024-03-30T03:02:24.359252Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 12219474 db_informer | 2024-03-30T03:02:24.359270Z 0 [Note] InnoDB: Database was not shutdown normally! db_informer | 2024-03-30T03:02:24.359289Z 0 [Note] InnoDB: Starting crash recovery. db_informer | 2024-03-30T03:02:24.468740Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" db_informer | 2024-03-30T03:02:24.468759Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables db_informer | 2024-03-30T03:02:24.468810Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... db_informer | 2024-03-30T03:02:24.499458Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. db_informer | 2024-03-30T03:02:24.499864Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. db_informer | 2024-03-30T03:02:24.500386Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. db_informer | 2024-03-30T03:02:24.501836Z 0 [Note] InnoDB: Waiting for purge to start db_informer | 2024-03-30T03:02:24.555661Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 12219474 db_informer | 2024-03-30T03:02:24.555981Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool db_informer | 2024-03-30T03:02:24.556035Z 0 [Note] Plugin 'FEDERATED' is disabled. db_informer | 2024-03-30T03:02:24.557526Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240330 3:02:24 db_informer | 2024-03-30T03:02:24.565097Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. db_informer | 2024-03-30T03:02:24.565377Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. db_informer | 2024-03-30T03:02:24.565536Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. db_informer | 2024-03-30T03:02:24.565766Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. db_informer | 2024-03-30T03:02:24.566853Z 0 [Warning] CA certificate ca.pem is self signed. db_informer | 2024-03-30T03:02:24.567161Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. db_informer | 2024-03-30T03:02:24.568070Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 db_informer | 2024-03-30T03:02:24.568230Z 0 [Note] IPv6 is available. db_informer | 2024-03-30T03:02:24.568258Z 0 [Note] - '::' resolves to '::'; db_informer | 2024-03-30T03:02:24.568496Z 0 [Note] Server socket created on IP: '::'. db_informer | 2024-03-30T03:02:24.569564Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. db_informer | 2024-03-30T03:02:24.579278Z 0 [Note] Event Scheduler: Loaded 0 events db_informer | 2024-03-30T03:02:24.580054Z 0 [Note] mysqld: ready for connections. db_informer | Version: '5.7.44' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) app_informer | INFO:root:env_file: ../informer.env app_informer | INFO:telethon.crypto.libssl:Failed to load SSL library: <class 'OSError'> (no library called "ssl" found) app_informer | INFO:telethon.crypto.aes:cryptg module not installed and libssl not found, falling back to (slower) Python encryption app_informer | INFO:root:Starting Informer SERVER_MODE: local app_informer | app_informer | INFO:root:Attempting to access Google Sheet Informer Notifications Sheet.sheet1 ... app_informer | app_informer | INFO:root:Setting up MySQL connector with connector string: mysql+mysqlconnector://informer:sampat@localhost:3306/db_informer?charset=utf8mb4&collation=utf8mb4_general_ci ... app_informer | app_informer | INFO:root:Attempting to load user session from database with account_id 5487378140 ... app_informer | app_informer | app_informer | -------------------------------------------------- app_informer | ____ ____ app_informer | / _/___ / __/___ _________ ___ ___ _____ app_informer | / // __ \/ /_/ __ \/ ___/ __ __ / _ / /
app_informer | / // / / / __/ // / / / / / / / / / /
app_informer | /// /// _// // // //___/_/
app_informer |
app_informer | --------------------------------------------------
app_informer | by @paulpierre updated 2021-08-16 (2019-11-26)
app_informer | https://github.com/paulpierre/informer
app_informer |
app_informer | Traceback (most recent call last):
app_informer | File "/usr/local/lib/python3.7/site-packages/mysql/connector/network.py", line 529, in open_connection
app_informer | self.sock.connect(sockaddr)
app_informer | ConnectionRefusedError: [Errno 111] Connection refused
app_informer |
app_informer | During handling of the above exception, another exception occurred:
app_informer |
app_informer | Traceback (most recent call last):
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect
app_informer | return fn()
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 363, in connect
app_informer | return _ConnectionFairy._checkout(self)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
app_informer | fairy = _ConnectionRecord.checkout(pool)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
app_informer | rec = pool._do_get()
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
app_informer | self._dec_overflow()
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 68, in exit
app_informer | compat.reraise(exc_type, exc_value, exc_tb)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
app_informer | raise value
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
app_informer | return self._create_connection()
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
app_informer | return _ConnectionRecord(self)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 437, in init
app_informer | self.__connect(first_connect_check=True)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
app_informer | connection = pool._invoke_creator(self)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
app_informer | return dialect.connect(*cargs, **cparams)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 482, in connect
app_informer | return self.dbapi.connect(*cargs, **cparams)
app_informer | File "/usr/local/lib/python3.7/site-packages/mysql/connector/init.py", line 177, in connect
app_informer | return MySQLConnection(*args, **kwargs)
app_informer | File "/usr/local/lib/python3.7/site-packages/mysql/connector/connection.py", line 104, in init
app_informer | self.connect(**kwargs)
app_informer | File "/usr/local/lib/python3.7/site-packages/mysql/connector/abstracts.py", line 781, in connect
app_informer | self._open_connection()
app_informer | File "/usr/local/lib/python3.7/site-packages/mysql/connector/connection.py", line 284, in _open_connection
app_informer | self._socket.open_connection()
app_informer | File "/usr/local/lib/python3.7/site-packages/mysql/connector/network.py", line 532, in open_connection
app_informer | errno=2003, values=(self.get_address(), _strioerror(err)))
app_informer | mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused)
app_informer |
app_informer | The above exception was the direct cause of the following exception:
app_informer |
app_informer | Traceback (most recent call last):
app_informer | File "bot.py", line 43, in
app_informer | google_sheet_name=os.getenv('GOOGLE_SHEET_NAME')
app_informer | File "/usr/local/app/informer.py", line 133, in init
app_informer | self.account = self.session.query(Account).filter_by(account_id=tg_account_id).first()
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3265, in first
app_informer | ret = list(self[0:1])
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3043, in getitem
app_informer | return list(res)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3367, in iter
app_informer | return self._execute_and_instances(context)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3389, in _execute_and_instances
app_informer | querycontext, self._connection_from_session, close_with_result=True
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3404, in _get_bind_args
app_informer | mapper=self._bind_mapper(), clause=querycontext.statement, **kw
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3382, in _connection_from_session
app_informer | conn = self.session.connection(**kw)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1124, in connection
app_informer | execution_options=execution_options,
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1130, in _connection_for_bind
app_informer | engine, execution_options
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 431, in _connection_for_bind
app_informer | conn = bind._contextual_connect()
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2242, in _contextual_connect
app_informer | self._wrap_pool_connect(self.pool.connect, None),
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2280, in _wrap_pool_connect
app_informer | e, dialect, self
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1547, in _handle_dbapi_exception_noconnection
app_informer | util.raise_from_cause(sqlalchemy_exception, exc_info)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
app_informer | reraise(type(exception), exception, tb=exc_tb, cause=cause)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
app_informer | raise value.with_traceback(tb)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect
app_informer | return fn()
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 363, in connect
app_informer | return _ConnectionFairy._checkout(self)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
app_informer | fairy = _ConnectionRecord.checkout(pool)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
app_informer | rec = pool._do_get()
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
app_informer | self._dec_overflow()
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 68, in exit
app_informer | compat.reraise(exc_type, exc_value, exc_tb)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
app_informer | raise value
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
app_informer | return self._create_connection()
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
app_informer | return _ConnectionRecord(self)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 437, in init
app_informer | self.__connect(first_connect_check=True)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
app_informer | connection = pool._invoke_creator(self)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
app_informer | return dialect.connect(*cargs, **cparams)
app_informer | File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 482, in connect
app_informer | return self.dbapi.connect(*cargs, **cparams)
app_informer | File "/usr/local/lib/python3.7/site-packages/mysql/connector/init.py", line 177, in connect
app_informer | return MySQLConnection(*args, **kwargs)
app_informer | File "/usr/local/lib/python3.7/site-packages/mysql/connector/connection.py", line 104, in init
app_informer | self.connect(**kwargs)
app_informer | File "/usr/local/lib/python3.7/site-packages/mysql/connector/abstracts.py", line 781, in connect
app_informer | self._open_connection()
app_informer | File "/usr/local/lib/python3.7/site-packages/mysql/connector/connection.py", line 284, in _open_connection
app_informer | self._socket.open_connection()
app_informer | File "/usr/local/lib/python3.7/site-packages/mysql/connector/network.py", line 532, in open_connection
app_informer | errno=2003, values=(self.get_address(), _strioerror(err)))
app_informer | sqlalchemy.exc.InterfaceError: (mysql.connector.errors.InterfaceError) 2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused)
app_informer | (Background on this error at: http://sqlalche.me/e/rvf5)
app_informer exited with code 1
`

@santosadrian
Copy link

same here, I changed in env the ip addres of docker to MYSQL_IP_ADDRESS=db and this happened:

(informer) mr_rob0townsyou@instance-20240322-021615:~/informer$ ./quick_start.sh
usage: venv [-h] [--system-site-packages] [--symlinks | --copies] [--clear]
[--upgrade] [--without-pip] [--prompt PROMPT] [--upgrade-deps]
ENV_DIR [ENV_DIR ...]
venv: error: the following arguments are required: ENV_DIR
./quick_start.sh: line 11: venv/bin/activate: No such file or directory
Requirement already satisfied: SQLAlchemy==1.3.11 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 1)) (1.3.11)
Requirement already satisfied: sqlalchemy-migrate==0.13.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 2)) (0.13.0)
Requirement already satisfied: Telethon==1.23.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 3)) (1.23.0)
Requirement already satisfied: mysql-connector-python==8.0.18 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 4)) (8.0.18)
Requirement already satisfied: gspread==3.1.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 5)) (3.1.0)
Requirement already satisfied: oauth2client==4.1.3 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 6)) (4.1.3)
Requirement already satisfied: python-dotenv==0.19.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 7)) (0.19.0)
Requirement already satisfied: pbr>=1.8 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (6.0.0)
Requirement already satisfied: decorator in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (5.1.1)
Requirement already satisfied: six>=1.7.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (1.16.0)
Requirement already satisfied: sqlparse in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (0.4.4)
Requirement already satisfied: Tempita>=0.4 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (0.5.2)
Requirement already satisfied: pyaes in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from Telethon==1.23.0->-r requirements.txt (line 3)) (1.6.1)
Requirement already satisfied: rsa in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from Telethon==1.23.0->-r requirements.txt (line 3)) (4.9)
Requirement already satisfied: protobuf>=3.0.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from mysql-connector-python==8.0.18->-r requirements.txt (line 4)) (5.26.1)
Requirement already satisfied: requests>=2.2.1 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from gspread==3.1.0->-r requirements.txt (line 5)) (2.31.0)
Requirement already satisfied: httplib2>=0.9.1 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from oauth2client==4.1.3->-r requirements.txt (line 6)) (0.22.0)
Requirement already satisfied: pyasn1>=0.1.7 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from oauth2client==4.1.3->-r requirements.txt (line 6)) (0.6.0)
Requirement already satisfied: pyasn1-modules>=0.0.5 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from oauth2client==4.1.3->-r requirements.txt (line 6)) (0.4.0)
Requirement already satisfied: pyparsing!=3.0.0,!=3.0.1,!=3.0.2,!=3.0.3,<4,>=2.4.2 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from httplib2>=0.9.1->oauth2client==4.1.3->-r requirements.txt (line 6)) (3.1.2)
Requirement already satisfied: charset-normalizer<4,>=2 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (3.3.2)
Requirement already satisfied: idna<4,>=2.5 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (3.6)
Requirement already satisfied: urllib3<3,>=1.21.1 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (2.2.1)
Requirement already satisfied: certifi>=2017.4.17 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (2024.2.2)
INFO:root:env_file: ../informer.env
INFO:telethon.crypto.aes:libssl detected, it will be used for encryption

--------------------------------------------------
    ____      ____                              
   /  _/___  / __/___  _________ ___  ___  _____
   / // __ \/ /_/ __ \/ ___/ __ `__ \/ _ \/ ___/
 _/ // / / / __/ /_/ / /  / / / / / /  __/ /    
/___/_/ /_/_/  \____/_/  /_/ /_/ /_/\___/_/

--------------------------------------------------
by @paulpierre updated 2021-08-16 (2019-11-26)
https://github.com/paulpierre/informer

INFO:root:Starting Informer SERVER_MODE: local

INFO:root:Attempting to access Google Sheet Informer Notifications Sheet.sheet1 ...

INFO:root:Setting up MySQL connector with connector string: mysql+mysqlconnector://informer:informer_P455w0rd!@db:3307/informer_db?charset=utf8mb4&collation=utf8mb4_general_ci ...

INFO:root:Attempting to load user session from database with account_id 6872002273 ...

Traceback (most recent call last):
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/network.py", line 502, in open_connection
addrinfos = socket.getaddrinfo(self.server_host,
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/socket.py", line 953, in getaddrinfo
for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
socket.gaierror: [Errno -2] Name or service not known

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect
return fn()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 363, in connect
return _ConnectionFairy._checkout(self)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
rec = pool._do_get()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
self._dec_overflow()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 68, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
raise value
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
return self._create_connection()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
return _ConnectionRecord(self)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 437, in init
self.__connect(first_connect_check=True)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
connection = pool._invoke_creator(self)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 482, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/init.py", line 177, in connect
return MySQLConnection(*args, **kwargs)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/connection.py", line 104, in init
self.connect(**kwargs)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/abstracts.py", line 781, in connect
self._open_connection()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/connection.py", line 284, in _open_connection
self._socket.open_connection()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/network.py", line 520, in open_connection
raise errors.InterfaceError(
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'db:3307' (-2 Name or service not known)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/home/mr_rob0townsyou/informer/app/bot.py", line 42, in
informer = TGInformer(
File "/home/mr_rob0townsyou/informer/app/informer.py", line 133, in init
self.account = self.session.query(Account).filter_by(account_id=tg_account_id).first()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3265, in first
ret = list(self[0:1])
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3043, in getitem
return list(res)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3367, in iter
return self._execute_and_instances(context)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3388, in _execute_and_instances
conn = self._get_bind_args(
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3403, in _get_bind_args
return fn(
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3382, in _connection_from_session
conn = self.session.connection(**kw)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1121, in connection
return self._connection_for_bind(
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1129, in _connection_for_bind
return self.transaction._connection_for_bind(
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 431, in _connection_for_bind
conn = bind._contextual_connect()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2242, in _contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2279, in _wrap_pool_connect
Connection._handle_dbapi_exception_noconnection(
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1547, in _handle_dbapi_exception_noconnection
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
raise value.with_traceback(tb)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect
return fn()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 363, in connect
return _ConnectionFairy._checkout(self)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
rec = pool._do_get()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
self._dec_overflow()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 68, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
raise value
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
return self._create_connection()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
return _ConnectionRecord(self)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 437, in init
self.__connect(first_connect_check=True)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
connection = pool._invoke_creator(self)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 482, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/init.py", line 177, in connect
return MySQLConnection(*args, **kwargs)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/connection.py", line 104, in init
self.connect(**kwargs)
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/abstracts.py", line 781, in connect
self._open_connection()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/connection.py", line 284, in _open_connection
self._socket.open_connection()
File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/network.py", line 520, in open_connection
raise errors.InterfaceError(
sqlalchemy.exc.InterfaceError: (mysql.connector.errors.InterfaceError) 2003: Can't connect to MySQL server on 'db:3307' (-2 Name or service not known)
(Background on this error at: http://sqlalche.me/e/rvf5)

I installed python-env, but it outputs this:
(informer) mr_rob0townsyou@instance-20240322-021615:/informer$ ./quick_start.sh
usage: venv [-h] [--system-site-packages] [--symlinks | --copies] [--clear]
[--upgrade] [--without-pip] [--prompt PROMPT] [--upgrade-deps]
ENV_DIR [ENV_DIR ...]
venv: error: the following arguments are required: ENV_DIR
./quick_start.sh: line 11: venv/bin/activate: No such file or directory
Requirement already satisfied: SQLAlchemy==1.3.11 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 1)) (1.3.11)
Requirement already satisfied: sqlalchemy-migrate==0.13.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 2)) (0.13.0)
Requirement already satisfied: Telethon==1.23.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 3)) (1.23.0)
Requirement already satisfied: mysql-connector-python==8.0.18 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 4)) (8.0.18)
Requirement already satisfied: gspread==3.1.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 5)) (3.1.0)
Requirement already satisfied: oauth2client==4.1.3 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 6)) (4.1.3)
Requirement already satisfied: python-dotenv==0.19.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 7)) (0.19.0)
Requirement already satisfied: pbr>=1.8 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (6.0.0)
Requirement already satisfied: decorator in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (5.1.1)
Requirement already satisfied: six>=1.7.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (1.16.0)
Requirement already satisfied: sqlparse in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (0.4.4)
Requirement already satisfied: Tempita>=0.4 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (0.5.2)
Requirement already satisfied: pyaes in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from Telethon==1.23.0->-r requirements.txt (line 3)) (1.6.1)
Requirement already satisfied: rsa in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from Telethon==1.23.0->-r requirements.txt (line 3)) (4.9)
Requirement already satisfied: protobuf>=3.0.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from mysql-connector-python==8.0.18->-r requirements.txt (line 4)) (5.26.1)
Requirement already satisfied: requests>=2.2.1 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from gspread==3.1.0->-r requirements.txt (line 5)) (2.31.0)
Requirement already satisfied: httplib2>=0.9.1 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from oauth2client==4.1.3->-r requirements.txt (line 6)) (0.22.0)
Requirement already satisfied: pyasn1>=0.1.7 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from oauth2client==4.1.3->-r requirements.txt (line 6)) (0.6.0)
Requirement already satisfied: pyasn1-modules>=0.0.5 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from oauth2client==4.1.3->-r requirements.txt (line 6)) (0.4.0)
Requirement already satisfied: pyparsing!=3.0.0,!=3.0.1,!=3.0.2,!=3.0.3,<4,>=2.4.2 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from httplib2>=0.9.1->oauth2client==4.1.3->-r requirements.txt (line 6)) (3.1.2)
Requirement already satisfied: charset-normalizer<4,>=2 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (3.3.2)
Requirement already satisfied: idna<4,>=2.5 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (3.6)
Requirement already satisfied: urllib3<3,>=1.21.1 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (2.2.1)
Requirement already satisfied: certifi>=2017.4.17 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (2024.2.2)
Traceback (most recent call last):
File "/home/mr_rob0townsyou/informer/app/bot.py", line 4, in
from dotenv import load_dotenv
ImportError: cannot import name 'load_dotenv' from 'dotenv' (/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/dotenv/init.py)
(informer) mr_rob0townsyou@instance-20240322-021615:/informer$ pip install dotenv
Collecting dotenv
Downloading dotenv-0.0.5.tar.gz (2.4 kB)
Preparing metadata (setup.py) ... error
error: subprocess-exited-with-error

× python setup.py egg_info did not run successfully.
│ exit code: 1
╰─> [76 lines of output]
/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/init.py:80: _DeprecatedInstaller: setuptools.installer and fetch_build_eggs are deprecated.
!!

          ********************************************************************************
          Requirements should be satisfied by a PEP 517 installer.
          If you are using pip, you can try `pip install --use-pep517`.
          ********************************************************************************
  
  !!
    dist.fetch_build_eggs(dist.setup_requires)
    error: subprocess-exited-with-error
  
    × python setup.py egg_info did not run successfully.
    │ exit code: 1
    ╰─> [16 lines of output]
        Traceback (most recent call last):
          File "<string>", line 2, in <module>
          File "<pip-setuptools-caller>", line 14, in <module>
          File "/tmp/pip-wheel-7zgw7nx3/distribute_88c232bdb979481cb6c44c0c8212cde0/setuptools/__init__.py", line 2, in <module>
            from setuptools.extension import Extension, Library
          File "/tmp/pip-wheel-7zgw7nx3/distribute_88c232bdb979481cb6c44c0c8212cde0/setuptools/extension.py", line 5, in <module>
            from setuptools.dist import _get_unpatched
          File "/tmp/pip-wheel-7zgw7nx3/distribute_88c232bdb979481cb6c44c0c8212cde0/setuptools/dist.py", line 7, in <module>
            from setuptools.command.install import install
          File "/tmp/pip-wheel-7zgw7nx3/distribute_88c232bdb979481cb6c44c0c8212cde0/setuptools/command/__init__.py", line 8, in <module>
            from setuptools.command import install_scripts
          File "/tmp/pip-wheel-7zgw7nx3/distribute_88c232bdb979481cb6c44c0c8212cde0/setuptools/command/install_scripts.py", line 3, in <module>
            from pkg_resources import Distribution, PathMetadata, ensure_directory
          File "/tmp/pip-wheel-7zgw7nx3/distribute_88c232bdb979481cb6c44c0c8212cde0/pkg_resources.py", line 1518, in <module>
            register_loader_type(importlib_bootstrap.SourceFileLoader, DefaultProvider)
        AttributeError: module 'importlib._bootstrap' has no attribute 'SourceFileLoader'
        [end of output]
  
    note: This error originates from a subprocess, and is likely not a problem with pip.
  error: metadata-generation-failed
  
  × Encountered error while generating package metadata.
  ╰─> See above for output.
  
  note: This is an issue with the package mentioned above, not pip.
  hint: See above for details.
  Traceback (most recent call last):
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/installer.py", line 101, in _fetch_build_egg_no_warn
      subprocess.check_call(cmd)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/subprocess.py", line 373, in check_call
      raise CalledProcessError(retcode, cmd)
  subprocess.CalledProcessError: Command '['/home/mr_rob0townsyou/anaconda3/envs/informer/bin/python', '-m', 'pip', '--disable-pip-version-check', 'wheel', '--no-deps', '-w', '/tmp/tmpigon9zl0', '--quiet', 'distribute']' returned non-zero exit status 1.
  
  The above exception was the direct cause of the following exception:
  
  Traceback (most recent call last):
    File "<string>", line 2, in <module>
    File "<pip-setuptools-caller>", line 34, in <module>
    File "/tmp/pip-install-1ogoiqqd/dotenv_da101cdcff7c45feae5be71204a76ecd/setup.py", line 13, in <module>
      setup(name='dotenv',
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/__init__.py", line 102, in setup
      _install_setup_requires(attrs)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/__init__.py", line 75, in _install_setup_requires
      _fetch_build_eggs(dist)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/__init__.py", line 80, in _fetch_build_eggs
      dist.fetch_build_eggs(dist.setup_requires)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/dist.py", line 662, in fetch_build_eggs
      return _fetch_build_eggs(self, requires)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/installer.py", line 38, in _fetch_build_eggs
      resolved_dists = pkg_resources.working_set.resolve(
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/pkg_resources/__init__.py", line 829, in resolve
      dist = self._resolve_dist(
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/pkg_resources/__init__.py", line 865, in _resolve_dist
      dist = best[req.key] = env.best_match(
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/pkg_resources/__init__.py", line 1135, in best_match
      return self.obtain(req, installer)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/pkg_resources/__init__.py", line 1147, in obtain
      return installer(requirement)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/installer.py", line 103, in _fetch_build_egg_no_warn
      raise DistutilsError(str(e)) from e
  distutils.errors.DistutilsError: Command '['/home/mr_rob0townsyou/anaconda3/envs/informer/bin/python', '-m', 'pip', '--disable-pip-version-check', 'wheel', '--no-deps', '-w', '/tmp/tmpigon9zl0', '--quiet', 'distribute']' returned non-zero exit status 1.
  [end of output]

note: This error originates from a subprocess, and is likely not a problem with pip.
error: metadata-generation-failed

× Encountered error while generating package metadata.
╰─> See above for output.

note: This is an issue with the package mentioned above, not pip.
hint: See above for details.

upgraded python to 3.11, and pip install -U pip

I get stuck here, please help.

@dexteon
Copy link

dexteon commented Apr 4, 2024

same here, I changed in env the ip addres of docker to MYSQL_IP_ADDRESS=db and this happened:

(informer) mr_rob0townsyou@instance-20240322-021615:~/informer$ ./quick_start.sh usage: venv [-h] [--system-site-packages] [--symlinks | --copies] [--clear] [--upgrade] [--without-pip] [--prompt PROMPT] [--upgrade-deps] ENV_DIR [ENV_DIR ...] venv: error: the following arguments are required: ENV_DIR ./quick_start.sh: line 11: venv/bin/activate: No such file or directory Requirement already satisfied: SQLAlchemy==1.3.11 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 1)) (1.3.11) Requirement already satisfied: sqlalchemy-migrate==0.13.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 2)) (0.13.0) Requirement already satisfied: Telethon==1.23.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 3)) (1.23.0) Requirement already satisfied: mysql-connector-python==8.0.18 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 4)) (8.0.18) Requirement already satisfied: gspread==3.1.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 5)) (3.1.0) Requirement already satisfied: oauth2client==4.1.3 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 6)) (4.1.3) Requirement already satisfied: python-dotenv==0.19.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 7)) (0.19.0) Requirement already satisfied: pbr>=1.8 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (6.0.0) Requirement already satisfied: decorator in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (5.1.1) Requirement already satisfied: six>=1.7.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (1.16.0) Requirement already satisfied: sqlparse in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (0.4.4) Requirement already satisfied: Tempita>=0.4 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (0.5.2) Requirement already satisfied: pyaes in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from Telethon==1.23.0->-r requirements.txt (line 3)) (1.6.1) Requirement already satisfied: rsa in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from Telethon==1.23.0->-r requirements.txt (line 3)) (4.9) Requirement already satisfied: protobuf>=3.0.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from mysql-connector-python==8.0.18->-r requirements.txt (line 4)) (5.26.1) Requirement already satisfied: requests>=2.2.1 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from gspread==3.1.0->-r requirements.txt (line 5)) (2.31.0) Requirement already satisfied: httplib2>=0.9.1 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from oauth2client==4.1.3->-r requirements.txt (line 6)) (0.22.0) Requirement already satisfied: pyasn1>=0.1.7 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from oauth2client==4.1.3->-r requirements.txt (line 6)) (0.6.0) Requirement already satisfied: pyasn1-modules>=0.0.5 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from oauth2client==4.1.3->-r requirements.txt (line 6)) (0.4.0) Requirement already satisfied: pyparsing!=3.0.0,!=3.0.1,!=3.0.2,!=3.0.3,<4,>=2.4.2 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from httplib2>=0.9.1->oauth2client==4.1.3->-r requirements.txt (line 6)) (3.1.2) Requirement already satisfied: charset-normalizer<4,>=2 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (3.3.2) Requirement already satisfied: idna<4,>=2.5 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (3.6) Requirement already satisfied: urllib3<3,>=1.21.1 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (2.2.1) Requirement already satisfied: certifi>=2017.4.17 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (2024.2.2) INFO:root:env_file: ../informer.env INFO:telethon.crypto.aes:libssl detected, it will be used for encryption

--------------------------------------------------
    ____      ____                              
   /  _/___  / __/___  _________ ___  ___  _____
   / // __ \/ /_/ __ \/ ___/ __ `__ \/ _ \/ ___/
 _/ // / / / __/ /_/ / /  / / / / / /  __/ /    
/___/_/ /_/_/  \____/_/  /_/ /_/ /_/\___/_/

--------------------------------------------------
by @paulpierre updated 2021-08-16 (2019-11-26)
https://github.com/paulpierre/informer

INFO:root:Starting Informer SERVER_MODE: local

INFO:root:Attempting to access Google Sheet Informer Notifications Sheet.sheet1 ...

INFO:root:Setting up MySQL connector with connector string: mysql+mysqlconnector://informer:informer_P455w0rd!@db:3307/informer_db?charset=utf8mb4&collation=utf8mb4_general_ci ...

INFO:root:Attempting to load user session from database with account_id 6872002273 ...

Traceback (most recent call last): File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/network.py", line 502, in open_connection addrinfos = socket.getaddrinfo(self.server_host, File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/socket.py", line 953, in getaddrinfo for res in _socket.getaddrinfo(host, port, family, type, proto, flags): socket.gaierror: [Errno -2] Name or service not known

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect return fn() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 363, in connect return _ConnectionFairy._checkout(self) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 492, in checkout rec = pool._do_get() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 139, in _do_get self._dec_overflow() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 68, in exit compat.reraise(exc_type, exc_value, exc_tb) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 153, in reraise raise value File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 136, in _do_get return self._create_connection() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection return _ConnectionRecord(self) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 437, in init self.__connect(first_connect_check=True) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 639, in __connect connection = pool._invoke_creator(self) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect return dialect.connect(*cargs, **cparams) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 482, in connect return self.dbapi.connect(*cargs, **cparams) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/init.py", line 177, in connect return MySQLConnection(*args, **kwargs) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/connection.py", line 104, in init self.connect(**kwargs) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/abstracts.py", line 781, in connect self._open_connection() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/connection.py", line 284, in _open_connection self._socket.open_connection() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/network.py", line 520, in open_connection raise errors.InterfaceError( mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'db:3307' (-2 Name or service not known)

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "/home/mr_rob0townsyou/informer/app/bot.py", line 42, in informer = TGInformer( File "/home/mr_rob0townsyou/informer/app/informer.py", line 133, in init self.account = self.session.query(Account).filter_by(account_id=tg_account_id).first() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3265, in first ret = list(self[0:1]) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3043, in getitem return list(res) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3367, in iter return self._execute_and_instances(context) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3388, in _execute_and_instances conn = self._get_bind_args( File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3403, in _get_bind_args return fn( File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3382, in _connection_from_session conn = self.session.connection(**kw) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1121, in connection return self._connection_for_bind( File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1129, in _connection_for_bind return self.transaction._connection_for_bind( File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 431, in _connection_for_bind conn = bind._contextual_connect() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2242, in _contextual_connect self._wrap_pool_connect(self.pool.connect, None), File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2279, in _wrap_pool_connect Connection._handle_dbapi_exception_noconnection( File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1547, in _handle_dbapi_exception_noconnection util.raise_from_cause(sqlalchemy_exception, exc_info) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 152, in reraise raise value.with_traceback(tb) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect return fn() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 363, in connect return _ConnectionFairy._checkout(self) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout fairy = _ConnectionRecord.checkout(pool) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 492, in checkout rec = pool._do_get() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 139, in _do_get self._dec_overflow() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 68, in exit compat.reraise(exc_type, exc_value, exc_tb) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 153, in reraise raise value File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 136, in _do_get return self._create_connection() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection return _ConnectionRecord(self) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 437, in init self.__connect(first_connect_check=True) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 639, in __connect connection = pool._invoke_creator(self) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect return dialect.connect(*cargs, **cparams) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 482, in connect return self.dbapi.connect(*cargs, **cparams) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/init.py", line 177, in connect return MySQLConnection(*args, **kwargs) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/connection.py", line 104, in init self.connect(**kwargs) File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/abstracts.py", line 781, in connect self._open_connection() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/connection.py", line 284, in _open_connection self._socket.open_connection() File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/mysql/connector/network.py", line 520, in open_connection raise errors.InterfaceError( sqlalchemy.exc.InterfaceError: (mysql.connector.errors.InterfaceError) 2003: Can't connect to MySQL server on 'db:3307' (-2 Name or service not known) (Background on this error at: http://sqlalche.me/e/rvf5)

I installed python-env, but it outputs this: (informer) mr_rob0townsyou@instance-20240322-021615:/informer$ ./quick_start.sh usage: venv [-h] [--system-site-packages] [--symlinks | --copies] [--clear] [--upgrade] [--without-pip] [--prompt PROMPT] [--upgrade-deps] ENV_DIR [ENV_DIR ...] venv: error: the following arguments are required: ENV_DIR ./quick_start.sh: line 11: venv/bin/activate: No such file or directory Requirement already satisfied: SQLAlchemy==1.3.11 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 1)) (1.3.11) Requirement already satisfied: sqlalchemy-migrate==0.13.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 2)) (0.13.0) Requirement already satisfied: Telethon==1.23.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 3)) (1.23.0) Requirement already satisfied: mysql-connector-python==8.0.18 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 4)) (8.0.18) Requirement already satisfied: gspread==3.1.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 5)) (3.1.0) Requirement already satisfied: oauth2client==4.1.3 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 6)) (4.1.3) Requirement already satisfied: python-dotenv==0.19.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from -r requirements.txt (line 7)) (0.19.0) Requirement already satisfied: pbr>=1.8 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (6.0.0) Requirement already satisfied: decorator in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (5.1.1) Requirement already satisfied: six>=1.7.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (1.16.0) Requirement already satisfied: sqlparse in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (0.4.4) Requirement already satisfied: Tempita>=0.4 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from sqlalchemy-migrate==0.13.0->-r requirements.txt (line 2)) (0.5.2) Requirement already satisfied: pyaes in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from Telethon==1.23.0->-r requirements.txt (line 3)) (1.6.1) Requirement already satisfied: rsa in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from Telethon==1.23.0->-r requirements.txt (line 3)) (4.9) Requirement already satisfied: protobuf>=3.0.0 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from mysql-connector-python==8.0.18->-r requirements.txt (line 4)) (5.26.1) Requirement already satisfied: requests>=2.2.1 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from gspread==3.1.0->-r requirements.txt (line 5)) (2.31.0) Requirement already satisfied: httplib2>=0.9.1 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from oauth2client==4.1.3->-r requirements.txt (line 6)) (0.22.0) Requirement already satisfied: pyasn1>=0.1.7 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from oauth2client==4.1.3->-r requirements.txt (line 6)) (0.6.0) Requirement already satisfied: pyasn1-modules>=0.0.5 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from oauth2client==4.1.3->-r requirements.txt (line 6)) (0.4.0) Requirement already satisfied: pyparsing!=3.0.0,!=3.0.1,!=3.0.2,!=3.0.3,<4,>=2.4.2 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from httplib2>=0.9.1->oauth2client==4.1.3->-r requirements.txt (line 6)) (3.1.2) Requirement already satisfied: charset-normalizer<4,>=2 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (3.3.2) Requirement already satisfied: idna<4,>=2.5 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (3.6) Requirement already satisfied: urllib3<3,>=1.21.1 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (2.2.1) Requirement already satisfied: certifi>=2017.4.17 in /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages (from requests>=2.2.1->gspread==3.1.0->-r requirements.txt (line 5)) (2024.2.2) Traceback (most recent call last): File "/home/mr_rob0townsyou/informer/app/bot.py", line 4, in from dotenv import load_dotenv ImportError: cannot import name 'load_dotenv' from 'dotenv' (/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/dotenv/init.py) (informer) mr_rob0townsyou@instance-20240322-021615:/informer$ pip install dotenv Collecting dotenv Downloading dotenv-0.0.5.tar.gz (2.4 kB) Preparing metadata (setup.py) ... error error: subprocess-exited-with-error

× python setup.py egg_info did not run successfully. │ exit code: 1 ╰─> [76 lines of output] /home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/init.py:80: _DeprecatedInstaller: setuptools.installer and fetch_build_eggs are deprecated. !!

          ********************************************************************************
          Requirements should be satisfied by a PEP 517 installer.
          If you are using pip, you can try `pip install --use-pep517`.
          ********************************************************************************
  
  !!
    dist.fetch_build_eggs(dist.setup_requires)
    error: subprocess-exited-with-error
  
    × python setup.py egg_info did not run successfully.
    │ exit code: 1
    ╰─> [16 lines of output]
        Traceback (most recent call last):
          File "<string>", line 2, in <module>
          File "<pip-setuptools-caller>", line 14, in <module>
          File "/tmp/pip-wheel-7zgw7nx3/distribute_88c232bdb979481cb6c44c0c8212cde0/setuptools/__init__.py", line 2, in <module>
            from setuptools.extension import Extension, Library
          File "/tmp/pip-wheel-7zgw7nx3/distribute_88c232bdb979481cb6c44c0c8212cde0/setuptools/extension.py", line 5, in <module>
            from setuptools.dist import _get_unpatched
          File "/tmp/pip-wheel-7zgw7nx3/distribute_88c232bdb979481cb6c44c0c8212cde0/setuptools/dist.py", line 7, in <module>
            from setuptools.command.install import install
          File "/tmp/pip-wheel-7zgw7nx3/distribute_88c232bdb979481cb6c44c0c8212cde0/setuptools/command/__init__.py", line 8, in <module>
            from setuptools.command import install_scripts
          File "/tmp/pip-wheel-7zgw7nx3/distribute_88c232bdb979481cb6c44c0c8212cde0/setuptools/command/install_scripts.py", line 3, in <module>
            from pkg_resources import Distribution, PathMetadata, ensure_directory
          File "/tmp/pip-wheel-7zgw7nx3/distribute_88c232bdb979481cb6c44c0c8212cde0/pkg_resources.py", line 1518, in <module>
            register_loader_type(importlib_bootstrap.SourceFileLoader, DefaultProvider)
        AttributeError: module 'importlib._bootstrap' has no attribute 'SourceFileLoader'
        [end of output]
  
    note: This error originates from a subprocess, and is likely not a problem with pip.
  error: metadata-generation-failed
  
  × Encountered error while generating package metadata.
  ╰─> See above for output.
  
  note: This is an issue with the package mentioned above, not pip.
  hint: See above for details.
  Traceback (most recent call last):
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/installer.py", line 101, in _fetch_build_egg_no_warn
      subprocess.check_call(cmd)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/subprocess.py", line 373, in check_call
      raise CalledProcessError(retcode, cmd)
  subprocess.CalledProcessError: Command '['/home/mr_rob0townsyou/anaconda3/envs/informer/bin/python', '-m', 'pip', '--disable-pip-version-check', 'wheel', '--no-deps', '-w', '/tmp/tmpigon9zl0', '--quiet', 'distribute']' returned non-zero exit status 1.
  
  The above exception was the direct cause of the following exception:
  
  Traceback (most recent call last):
    File "<string>", line 2, in <module>
    File "<pip-setuptools-caller>", line 34, in <module>
    File "/tmp/pip-install-1ogoiqqd/dotenv_da101cdcff7c45feae5be71204a76ecd/setup.py", line 13, in <module>
      setup(name='dotenv',
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/__init__.py", line 102, in setup
      _install_setup_requires(attrs)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/__init__.py", line 75, in _install_setup_requires
      _fetch_build_eggs(dist)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/__init__.py", line 80, in _fetch_build_eggs
      dist.fetch_build_eggs(dist.setup_requires)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/dist.py", line 662, in fetch_build_eggs
      return _fetch_build_eggs(self, requires)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/installer.py", line 38, in _fetch_build_eggs
      resolved_dists = pkg_resources.working_set.resolve(
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/pkg_resources/__init__.py", line 829, in resolve
      dist = self._resolve_dist(
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/pkg_resources/__init__.py", line 865, in _resolve_dist
      dist = best[req.key] = env.best_match(
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/pkg_resources/__init__.py", line 1135, in best_match
      return self.obtain(req, installer)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/pkg_resources/__init__.py", line 1147, in obtain
      return installer(requirement)
    File "/home/mr_rob0townsyou/anaconda3/envs/informer/lib/python3.9/site-packages/setuptools/installer.py", line 103, in _fetch_build_egg_no_warn
      raise DistutilsError(str(e)) from e
  distutils.errors.DistutilsError: Command '['/home/mr_rob0townsyou/anaconda3/envs/informer/bin/python', '-m', 'pip', '--disable-pip-version-check', 'wheel', '--no-deps', '-w', '/tmp/tmpigon9zl0', '--quiet', 'distribute']' returned non-zero exit status 1.
  [end of output]

note: This error originates from a subprocess, and is likely not a problem with pip. error: metadata-generation-failed

× Encountered error while generating package metadata. ╰─> See above for output.

note: This is an issue with the package mentioned above, not pip. hint: See above for details.

upgraded python to 3.11, and pip install -U pip

I get stuck here, please help.

mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'db:3307' (-2 Name or service not known)

'db:3307 did you set the mysql ip in the .env? Shouldnt that DB be an IP address or a port?

@santosadrian
Copy link

I already tried 127.0.0.1, localhost, local ip address, 0.0.0.0, external ip address... none work, I don't know the ip addres that docker container runs on.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@santosadrian @llwh2333 @dexteon