MYSQL in V 4.6.0

[bmn-m]

Hi,
in my old Install 4.3.2 motion is writing to a localhost mysql database. Everything works fine.
Recently i installed motion 4.6.0 on my new Ubuntu 24.04 machine, copied the config files and edited the connection settings.
I enabled the debuging on my new server and can see that motion is reading the settings as shown below.

[0:motion] [INF] [ALL] [May 16 20:13:03] database_type             mysql
[0:motion] [INF] [ALL] [May 16 20:13:03] database_dbname           motion
[0:motion] [INF] [ALL] [May 16 20:13:03] database_host             10.10.10.22
[0:motion] [INF] [ALL] [May 16 20:13:03] database_port             3306
[0:motion] [INF] [ALL] [May 16 20:13:03] database_user             <redacted>
[0:motion] [INF] [ALL] [May 16 20:13:03] database_password         <redacted>
[0:motion] [INF] [ALL] [May 16 20:13:03] database_busy_timeout     10000
[0:motion] [INF] [ALL] [May 16 20:13:03] sql_log_picture           on
[0:motion] [INF] [ALL] [May 16 20:13:03] sql_log_snapshot          on
[0:motion] [INF] [ALL] [May 16 20:13:03] sql_log_movie             on
[0:motion] [INF] [ALL] [May 16 20:13:03] sql_log_timelapse         off
[0:motion] [INF] [ALL] [May 16 20:13:03] sql_query_start           insert into security_events(camera, event_time_stamp) values('%t', '%Y-%m-%d %T')
[0:motion] [INF] [ALL] [May 16 20:13:03] sql_query_stop            
[0:motion] [INF] [ALL] [May 16 20:13:03] sql_query                 insert into security(camera, filename, frame, file_type, time_stamp ,text_event) values('%t', '%f', '%q', '%n', '%Y-%m-%d %T', '%C')

I tested the connection and inserted a row in the security table manually.
I also installed and tested the .deb from github.
But motion does not write to the database.

Livestream is working and motion creates video and picture files as configured.

I would be very grateful for any help or tips!

[tosiara]

Could you upload the full log -d 9 with at least one event?

[bmn-m]

I found the problem / solution. I read the debug log and got a hint from it.
If i configure the SQL settings (database user port etc..) per camera (in cameraX.conf...) it works like intended.
In V 4.3.2 i had to configure the database settings only in motion.conf. and nothing in cameraX.conf