Mysql ssl error and auto-increment not working

[CarbonBee]

Hi,

I have a strange behaviour with mysql in a Lamp container.
Here is the backgroud:

• I want to have this project https://partkeepr.org/ on my 2 servers
• I requires php <= 7.1
• I use lamp v1.4.0 https://git.cloudron.io/cloudron/lamp-app/-/tags/v1.4.0

On one of my server (cloudron v6.0.1) it works fine.
But on the other one (cloudron v6.2.8), I have many problems :

• In the terminal, when I try to connect to mysql CLI, I've got the error ERROR 2026 (HY000): SSL connection error: unknown error number so I have to use phpmyadmin to make database manipulation,
• When I insert a line in a table, the new id (an AUTOINCREMENT field) is correctly incremented, but in the information_schema fields, neither table_rows nor auto_increment etc... fields are modified. I have a trigger on before insert which needs the auto_increment value.

I have never seen such a behaviour and don't really know what to do.

Does anyone has any idea?

[nebulon]

@carbonbee not sure what that issue is. Maybe since you use some older app package, this is caused by mysql client/server version mismatch?

Anyone else here has seen this?

[msbt]

@carbonbee at least for the first thing I've had a similar issue on a new cloudron and old LAMP, @girish suggested to just use another apps' terminal to connect to the db and do you alterations there.

[girish]

Right, please check the post that @msbt suggested. The main difference is that Cloudron 6.2 has MySQL 8 whereas Cloudron 6.0 is on MySQL 5.6. To connect to MySQL 8, you need the latest CLI tool because they have changed how authentication works.

[CarbonBee]

@girish @msbt Thanks! This helped greatly.
But I still have my increment issue.
In the CLI, I can do ANALYZE TABLE <my_table> after an insert and it updates the information_schema fields (TABLE_ROWS, AUTO_INCREMENT,...).
But when I insert again, nothing changes. I have to always make the ANALYZE TABLE to update the info.
Have you ever encounter this?

[CarbonBee]

Ok, I managed to make the application working from a backup.
The issue appears as soon as I connect to phpmyadmin.
I don't really understand why and what happens, but as long as I stay away from phpmyadmin, everything works fine.

[girish]

@carbonbee don't think it matters but I will push an update to phpMyAdmin 5.1.0 - https://www.phpmyadmin.net/news/2021/2/24/phpmyadmin-510-released/