FYI, finally, it has been fixed adding ?charset=utf8 in the string of the connector, like this:
#!define SQLCONNECTOR "mysql://user:password@IP/dbkamailio?charset=utf8"
Regards,
Igor.
De : Igor Potjevlesch <igor.potjevlesch@gmail.com>
Envoyé : jeudi 31 juillet 2025 10:01
À : sr-users@lists.kamailio.org
Objet : RE: Unknown character set utf8mb4
To complete, taking a network trace, I saw that before queries, I have one trying to "SET NAMES utf8mb4".
I don't know then if this provoke the failure of the following select query.
Regards,
Igor.
De : Igor Potjevlesch <igor.potjevlesch@gmail.com>
Envoyé : jeudi 31 juillet 2025 09:43
À : sr-users@lists.kamailio.org
Objet : Unknown character set utf8mb4
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.
