search

paulpierre / informer

A Telegram Mass Surveillance Bot in Python
https://www.twitter.com/paulpierre
MIT License
1.44k stars 231 forks source link

Error for docker:mysql #13

Open llwh2333 opened 1 year ago

llwh2333 commented 1 year ago

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 commented 7 months ago

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 | / // __ \/ /_/ __ \/ ___/ __ \/ \/ / appinformer | / // / / / / /_/ / / / / / / / / / /
appinformer | /// /// ____// // // //\/_/ 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 commented 7 months ago

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 commented 7 months ago

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 commented 7 months ago

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.