Mysql ssl error and auto-increment not working
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 numberso 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
auto_incrementetc... fields are modified. I have a trigger on before insert which needs the
I have never seen such a behaviour and don't really know what to do.
Does anyone has any idea?
@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?
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.
@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
But when I insert again, nothing changes. I have to always make the
ANALYZE TABLEto update the info.
Have you ever encounter this?
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.
@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/