('HY000', '[HY000] [Microsoft][ODBC Driver 17 for SQL Server]Protocol error in TDS stream (0) (SQLDriverConnect)')

[wes1993]

Hello, i have installed the receipt-manager-webapp using the instruction in the wiki and this is my config file:

backendHostname: ricevute.local
backendIP: 0.0.0.0
backendLanguage: en
backendPort: 5558
dbMode: mssql
encrypted: true
parserIP: 0.0.0.0
parserPort: 8721
parserToken: REDACTED
sqlDatabase: receiptData
sqlPassword: REDACTED
sqlServerIP: 0.0.0.0,3306
sqlUsername: receiptParser
useSSL: false

But seems that cannot connect to the DB, below the error message:

Using mssql DB
('HY000', '[HY000] [Microsoft][ODBC Driver 17 for SQL Server]Protocol error in TDS stream (0) (SQLDriverConnect)')

This is the log of the receiptDB container:

2023-12-04 17:56:35+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Serve                                                                                                             r 8.2.0-1.el8 started.
2023-12-04 17:56:36+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysq                                                                                                             l'
2023-12-04 17:56:36+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Serve                                                                                                             r 8.2.0-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-12-04T17:56:36.802928Z 0 [System] [MY-015015] [Server] MySQL Server - start                                                                                                             .
2023-12-04T17:56:37.418474Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-                                                                                                             host-cache' is deprecated and will be removed in a future release. Please use SE                                                                                                             T GLOBAL host_cache_size=0 instead.
2023-12-04T17:56:37.423562Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (my                                                                                                             sqld 8.2.0) starting as process 1
2023-12-04T17:56:37.444912Z 1 [System] [MY-013576] [InnoDB] InnoDB initializatio                                                                                                             n has started.
2023-12-04T17:56:38.121901Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-12-04T17:56:39.070294Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-12-04T17:56:39.070525Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-12-04T17:56:39.082784Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2023-12-04T17:56:39.299682Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.2.0'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2023-12-04T17:56:39.300672Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock

Best Regards Stefano