Re: Unknown character set utf8mb4

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 <[email protected]> 
Envoyé : jeudi 31 juillet 2025 12:18
À : [email protected]
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 <[email protected]
<mailto:[email protected]> > 
Envoyé : jeudi 31 juillet 2025 10:01
À : [email protected] <mailto:[email protected]> 
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 <[email protected]
<mailto:[email protected]> > 
Envoyé : jeudi 31 juillet 2025 09:43
À : [email protected] <mailto:[email protected]> 
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.

 


 
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai
gn=sig-email&utm_content=emailclient> 

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

 



-- 
Cet e-mail a été vérifié par le logiciel antivirus d'Avast.
www.avast.com

__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions -- [email protected]
To unsubscribe send an email to [email protected]
Important: keep the mailing list in the recipients, do not reply only to the sender!