Hello,

We move to fresh version of Kamailio 6. We have a MySQL backend in an old version.

We have many errors like this:

ERROR: db_mysql [km_dbase.c:127]: db_mysql_submit_query(): driver error on query: Unknown character set: 'utf8mb4' (1115)

ERROR: <core> [lib/srdb1/db_query.c:393]: db_do_update(): error while submitting query

ERROR: dialog [dlg_db_handler.c:1000]: update_dialog_dbinfo_unsafe(): could not update database info

ERROR: db_mysql [km_dbase.c:127]: db_mysql_submit_query(): driver error on query: Unknown character set: 'utf8mb4' (1115)

ERROR: <core> [lib/srdb1/db_query.c:158]: db_do_query_internal(): error while submitting query

ERROR: avpops [avpops_impl.c:328]: ops_dbload_avps(): db_load failed

ERROR: db_mysql [km_dbase.c:127]: db_mysql_submit_query(): driver error on query: Unknown character set: 'utf8mb4' (1115)

ERROR: <core> [lib/srdb1/db_query.c:158]: db_do_query_internal(): error while submitting query

ERROR: avpops [avpops_impl.c:328]: ops_dbload_avps(): db_load failed

It looks like the accounting module is not affected because we have writes in acc table.

Registrar is affected because dump from location to location table is not working.

Is there a way to make it work with older version of MySQL?

Regards,

Igor.