yeah, thats what i found too, but i still get error messages like:
Okt 22 00:15:23 mail grommunio-chat[6354]: {"timestamp":"2024-10-22 00:15:23.396 +02:00","level":"error","msg":"Failed to ping DB","caller":"sql/sql_utils.go:75","database":"master","dataSource":"****:****@tcp(10.1.201.4:3306)/grochat?writeTimeout=30s&charset=utf8mb4%2Cutf8","retrying in seconds":10,"error":"dial tcp 10.1.201.4:3306: connect: connection refused"}
Okt 22 00:16:17 mail piler[6139]: cant connect to mysql server
Okt 22 00:16:17 mail piler[6139]: ERROR: cannot open database
Okt 22 00:16:17 mail piler[6138]: cant connect to mysql server
Okt 22 00:16:17 mail piler[6138]: ERROR: cannot open database
Okt 22 00:16:24 mail grommunio-chat[6420]: Error: failed to initialize platform: cannot create store: error setting up connections: dial tcp 10.1.201.4:3306: connect: connection refused
Okt 22 00:16:24 mail grommunio-chat[6420]: {"timestamp":"2024-10-22 00:16:24.055 +02:00","level":"error","msg":"failed to initialize platform: cannot create store: error setting up connections: dial tcp 10.1.201.4:3306: connect: connection refused","caller":"commands/server.go:76"}
A connection with this command works fine:
mysql -v -u grommunio -p -h 10.1.201.4 -P6033
I already configured the my.cnf as follows:
[client]
ssl-ca=/etc/mysql/ca.pem
ssl-cert=/etc/mysql/client-cert.pem
ssl-key=/etc/mysql/client-key.pem
host=10.1.201.4
port=6033
default-auth=caching_sha2_password
So i changed the port manual in /etc/grommunio-chat/config.json
Then this error appears for it:
Okt 22 00:19:07 mail grommunio-chat[6913]: {"timestamp":"2024-10-22 00:19:07.116 +02:00","level":"error","msg":"Failed to ping DB","caller":"sql/sql_utils.go:75","database":"master","dataSource":"****:****@tcp(10.1.201.4:6033)/grochat?writeTimeout=30s&charset=utf8mb4%2Cutf8","retrying in seconds":10,"error":"unexpect resp from server for caching_sha2_password perform full authentication"}
But i'm already performing full authentication?
postfix logs errors too:
Okt 22 00:29:45 mail postfix/cleanup[8052]: warning: mysql:/etc/postfix/grommunio-virtual-mailbox-alias-maps.cf lookup error for "groarchive@mail.domain.rocks"
Okt 22 00:29:45 mail postfix/cleanup[8052]: warning: 8D04A6A5F2D: virtual_alias_maps map lookup problem for groarchive@mail.domain.rocks -- message not accepted, try again later
Okt 22 00:29:45 mail postfix/cleanup[8052]: warning: mysql:/etc/postfix/grommunio-bcc-forwards.cf lookup error for "groarchive@mail.domain.rocks"
Okt 22 00:29:45 mail postfix/cleanup[8052]: warning: 8D04A6A5F2D: recipient_bcc_maps map lookup problem -- message not accepted, try again later