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 <[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]>
> *Envoyé :* jeudi 31 juillet 2025 10:01
> *À :* [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]>
> *Envoyé :* jeudi 31 juillet 2025 09:43
> *À :* [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_campaign=sig-email&utm_content=emailclient>
>
> 	
>
> 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 -- [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!

-- 
Daniel-Constantin Mierla (@ asipto.com)
twitter.com/miconda -- linkedin.com/in/miconda
Kamailio Consultancy, Training and Development Services -- asipto.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!