We have a problem with MySQL for some time.
A friend is having exactly the same issue as well.
This is the error message we have while using MariaDB (10.11.4-MariaDB)
The exception is in French but it just says: Cannot perform a cast of a DBNull object into another type.08:47:36.966 Info: [DbMysql] : MYSQL deploying database log_xv9bpo START
08:47:36.969 Info: [DbMysql] : Connection string: Server=10.10.10.15;Port=3306;User ID=root;Password=***********;Pooling=false;SslMode=None
08:47:36.971 Info: [DbMysql] : Script loaded
08:47:36.973 Debug: [FwFile][WriteFile] : Begin writing text file D:\PERSO\Seafile\Radio\Log4OMv2\config\log\createDatabase_log_xv9bpo.sql
08:47:36.975 Debug: [FwFile][WriteFile] : Text file write completed D:\PERSO\Seafile\Radio\Log4OMv2\config\log\createDatabase_log_xv9bpo.sql
08:47:36.984 Info: [DbMysql] : MySQL creation file is saved here: D:\PERSO\Seafile\Radio\Log4OMv2\config\log\createDatabase_log_xv9bpo.sql
08:47:36.987 Info: [DbMysql] : Opening connection...
08:47:37 Error: [DbMysql][Deploy] : MYSQL Error while deploying database
[EXCEPTION] Impossible d'effectuer un cast d'un objet de DBNull en d'autres types.
So I presume a cast is performed in the code to change a type into another type which cannot succeed due to the fact the first object to convert is a DBNull.
I did not use MySQL for a long time so not sure when this issue started but we cannot use MySQL anymore on our side due to this.
And while trying to connect to an existing database here is the error:
I am 100% sure of the password as I use the same to connect to PhpMyAdmin without any issue, also tried with MariaDB root user.[EXCEPTION] Authentication to host '10.10.10.15' for user 'xv9bpoUser' using method 'mysql_native_password' failed with message: Access denied for user 'xv9bpoUser'@'10.10.10.100' (using password: YES)
Not sure what changed in Log4OM but no more MySQl for me.
Is there anyone facing this issue as well ?
Thanks