br0ziliy / amb-docker Goto Github PK

any hints i cant get the docker to launch propplery, i can connect with nc localhost 3306

Attaching to amb-docker_db_1, amb-docker_ambweb_1, amb-docker_amb_laps_1, amb-docker_amb_client_1
db_1 | 2021-01-18 21:37:00+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.4.17+mariafocal started.
db_1 | 2021-01-18 21:37:00+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
db_1 | 2021-01-18 21:37:00+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.4.17+mariafocal started.
db_1 | 2021-01-18 21:37:01 0 [Warning] 'default-authentication-plugin' is MySQL 5.6 / 5.7 compatible option. To be implemented in later versions.
db_1 | 2021-01-18 21:37:01 0 [Note] mysqld (mysqld 10.4.17-MariaDB-1:10.4.17+mariafocal) starting as process 1 ...
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: Using Linux native AIO
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: Uses event mutexes
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: Number of pools: 1
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
db_1 | 2021-01-18 21:37:01 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: Completed initialization of buffer pool
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: Waiting for purge to start
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: 10.4.17 started; log sequence number 61309; transaction id 20
db_1 | 2021-01-18 21:37:01 0 [Note] Plugin 'FEEDBACK' is disabled.
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db_1 | 2021-01-18 21:37:01 0 [Note] Server socket created on IP: '::'.
db_1 | 2021-01-18 21:37:01 0 [Warning] 'proxies_priv' entry '@% root@469fcc38541e' ignored in --skip-name-resolve mode.
db_1 | 2021-01-18 21:37:01 0 [Note] Reading of all Master_info entries succeeded
db_1 | 2021-01-18 21:37:01 0 [Note] Added new Master_info '' to hash table
db_1 | 2021-01-18 21:37:01 0 [Note] mysqld: ready for connections.
db_1 | Version: '10.4.17-MariaDB-1:10.4.17+mariafocal' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
db_1 | 2021-01-18 21:37:01 0 [Note] InnoDB: Buffer pool(s) load completed at 210118 21:37:01
amb_laps_1 | args: {'config_file': '/code/local_conf.yaml'}
amb_laps_1 | CONF: {'config_file': '/code/local_conf.yaml', 'ip': '192.168.1.10', 'port': 5403, 'file': '/tmp/out.log', 'debug_file': '/tmp/amb_raw.log', 'mysql_backend': True, 'mysql_host': 'localhost', 'mysql_port': 3306, 'mysql_db': 'karts', 'mysql_user': 'karts', 'mysql_password': 'bBCXi3r3Tq1cDqv1Oov9TMUe'}
amb_laps_1 | ERROR:root:Something went wrong: 2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused)
amb_laps_1 | Traceback (most recent call last):
amb_laps_1 | File "/code/amb_laps.py", line 351, in
amb_laps_1 | main()
amb_laps_1 | File "/code/amb_laps.py", line 346, in main
amb_laps_1 | heat = Heat(conf, decoder_time=dt)
amb_laps_1 | File "/code/amb_laps.py", line 91, in init
amb_laps_1 | self.mysql = mysql_connect(conf)
amb_laps_1 | File "/code/amb_laps.py", line 50, in mysql_connect
amb_laps_1 | if con is None:
amb_laps_1 | UnboundLocalError: local variable 'con' referenced before assignment
amb_client_1 | ************ STARTING *******************
amb_client_1 | args: {'config_file': '/code/local_conf.yaml'}
amb_client_1 | CONF: {'config_file': '/code/local_conf.yaml', 'ip': '192.168.1.10', 'port': 5403, 'file': '/tmp/out.log', 'debug_file': '/tmp/amb_raw.log', 'mysql_backend': True, 'mysql_host': 'localhost', 'mysql_port': 3306, 'mysql_db': 'karts', 'mysql_user': 'karts', 'mysql_password': 'bBCXi3r3Tq1cDqv1Oov9TMUe'}
amb_client_1 | Traceback (most recent call last):
amb_client_1 | File "/usr/local/lib/python3.7/site-packages/mysql/connector/network.py", line 509, in open_connection
amb_client_1 | self.sock.connect(sockaddr)
amb_client_1 | ConnectionRefusedError: [Errno 111] Connection refused
amb_client_1 |
amb_client_1 | During handling of the above exception, another exception occurred:
amb_client_1 |
amb_client_1 | Traceback (most recent call last):
amb_client_1 | File "/code/amb_client.py", line 87, in
amb_client_1 | main()
amb_client_1 | File "/code/amb_client.py", line 30, in main
amb_client_1 | port=conf['mysql_port'],
amb_client_1 | File "/code/AmbP3/write.py", line 9, in open_mysql_connection
amb_client_1 | sql_con = mysqlconnector.connect(user=user, db=db, password=password, host=host, port=port)
amb_client_1 | File "/usr/local/lib/python3.7/site-packages/mysql/connector/init.py", line 179, in connect
amb_client_1 | return MySQLConnection(*args, **kwargs)
amb_client_1 | File "/usr/local/lib/python3.7/site-packages/mysql/connector/connection.py", line 95, in init
amb_client_1 | self.connect(**kwargs)
amb_client_1 | File "/usr/local/lib/python3.7/site-packages/mysql/connector/abstracts.py", line 716, in connect
amb_client_1 | self._open_connection()
amb_client_1 | File "/usr/local/lib/python3.7/site-packages/mysql/connector/connection.py", line 206, in _open_connection
amb_client_1 | self._socket.open_connection()
amb_client_1 | File "/usr/local/lib/python3.7/site-packages/mysql/connector/network.py", line 512, in open_connection
amb_client_1 | errno=2003, values=(self.get_address(), _strioerror(err)))
amb_client_1 | mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused)
amb-docker_amb_laps_1 exited with code 1
amb-docker_amb_client_1 exited with code 1

Hi
i got it up and running after som issues with user and pwd for the db's
but im testing this to a mylaps AMB with version 4.5 software
get this issues on decode som values
amb_client_1 | Requesting Decoder Time
amb_client_1 | Waiting for DECODER timestamp
amb_client_1 | b'001c' record_type uknown
amb_client_1 | Traceback (most recent call last):
amb_client_1 | File "/code/amb_client.py", line 87, in
amb_client_1 | main()
amb_client_1 | File "/code/amb_client.py", line 52, in main
amb_client_1 | if 'GET_TIME' == decoded_body['RESULT']['TOR']:
amb_client_1 | KeyError: 'TOR'
karts_db_1 | 2021-01-22 11:43:08 9 [Warning] Aborted connection 9 to db: 'karts' user: 'karts' host: '172.31.0.1' (Got an error reading communication packets)
amb-docker_amb_laps_1 exited with code 1
amb-docker_amb_client_1 exited with code 1