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.
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.
Sans virus. https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai gn=sig-email&utm_content=emailclient www.avast.com
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 mailto:igor.potjevlesch@gmail.com > Envoyé : jeudi 31 juillet 2025 09:43 À : sr-users@lists.kamailio.org mailto: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.
Sans virus. https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai gn=sig-email&utm_content=emailclient www.avast.com
Seems not enough because after expire time, all errors came back. Even if, just after a restart, some entries have been added to the location table. Updates seem to be the problem.
Do you have an idea?
Regards,
Igor.
De : Igor Potjevlesch igor.potjevlesch@gmail.com Envoyé : jeudi 31 juillet 2025 12:18 À : sr-users@lists.kamailio.org Objet : RE: Unknown character set utf8mb4
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 mailto:igor.potjevlesch@gmail.com > Envoyé : jeudi 31 juillet 2025 10:01 À : sr-users@lists.kamailio.org mailto: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 mailto:igor.potjevlesch@gmail.com > Envoyé : jeudi 31 juillet 2025 09:43 À : sr-users@lists.kamailio.org mailto: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.
Sans virus. https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai gn=sig-email&utm_content=emailclient www.avast.com
I guess you have a newer mysql client library than the server, because utf8mb4 seems to be the default one for latest versions.
You can try to set the character set in the mysql client configuration file on kamailio server, like:
[mysql] default-character-set=utf8
Cheers, Daniel
On 31.07.25 14:40, Igor Potjevlesch via sr-users wrote:
Seems not enough because after expire time, all errors came back. Even if, just after a restart, some entries have been added to the location table. Updates seem to be the problem.
Do you have an idea?
Regards,
Igor.
*De :*Igor Potjevlesch igor.potjevlesch@gmail.com *Envoyé :* jeudi 31 juillet 2025 12:18 *À :* sr-users@lists.kamailio.org *Objet :* RE: Unknown character set utf8mb4
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.
Sans virus.www.avast.com https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient
Kamailio - Users Mailing List - Non Commercial Discussions -- sr-users@lists.kamailio.org To unsubscribe send an email to sr-users-leave@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender!
Thank you Daniel. Yes, we tried that. But, after some times, errors come back.
We cannot find the root cause yet. We did a rollback.
Regards,
Igor.
De : Daniel-Constantin Mierla miconda@gmail.com Envoyé : jeudi 31 juillet 2025 16:45 À : Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Cc : Igor Potjevlesch igor.potjevlesch@gmail.com Objet : Re: [SR-Users] Re: Unknown character set utf8mb4
I guess you have a newer mysql client library than the server, because utf8mb4 seems to be the default one for latest versions.
You can try to set the character set in the mysql client configuration file on kamailio server, like:
[mysql] default-character-set=utf8
Cheers, Daniel
On 31.07.25 14:40, Igor Potjevlesch via sr-users wrote:
Seems not enough because after expire time, all errors came back. Even if, just after a restart, some entries have been added to the location table. Updates seem to be the problem.
Do you have an idea?
Regards,
Igor.
De : Igor Potjevlesch mailto:igor.potjevlesch@gmail.com igor.potjevlesch@gmail.com Envoyé : jeudi 31 juillet 2025 12:18 À : sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org Objet : RE: Unknown character set utf8mb4
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 mailto:igor.potjevlesch@gmail.com > Envoyé : jeudi 31 juillet 2025 10:01 À : sr-users@lists.kamailio.org mailto: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 mailto:igor.potjevlesch@gmail.com > Envoyé : jeudi 31 juillet 2025 09:43 À : sr-users@lists.kamailio.org mailto: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.
Sans virus. https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient www.avast.com
__________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions -- sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org To unsubscribe send an email to sr-users-leave@lists.kamailio.org mailto:sr-users-leave@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender!
-
Daniel-Constantin Mierla -
Igor Potjevlesch