I don't know if that patch is specific to MariaDB, I've only used MySQL.
But I do know that for MySQL on Ubuntu 18.04 and Rivendell 3.x to work,
you need to add the "disable strict mode" configuration file to the
MySQL setup. Otherwise it throws all sorts of errors. Something similar
might be needed for MariaDB. That additional setup is referenced in the
Wiki at:
http://wiki.rivendellaudio.org/index.php/Ubuntu18_04#Getting_MySQL_to_work_and_creating_the_Rivendell_user_and_database
Lorne Tyndale
On 2021-03-19 2:32 a.m., Nick Andre wrote:
I hit this same issue trying to install on Ubuntu 18.04.
Is the patch mentioned here
<https://github.com/ElvishArtisan/rivendell/issues/515#issuecomment-560357397>
still required for mariadb installs? I didn't see it referenced on the
18.04 wiki page
<http://wiki.rivendellaudio.org/index.php/Ubuntu18_04>. We should add
a note if this will continue to be necessary.
On Wed, Oct 9, 2019 at 4:49 AM le père Léon <news.l...@free.fr
<mailto:news.l...@free.fr>> wrote:
I did not specify, but it is on a Debian 10 system.
Le 09/10/2019 à 11:23, le père Léon a écrit :
> Since 310 DB schema, I can't modify or even create a new
complete database.
>
> leon@rivendell:~$ sudo rddbmgr --create
> DB connection re-established
> invalid SQL or failed DB connection[Field 'STATION' doesn't have a
> default value QMYSQL: Unable to execute query]: insert into
> NEXUS_STATIONS set RD_SERVICE="Production"
> rddbmgr: sql error: Field 'STATION' doesn't have a default value
QMYSQL:
> Unable to execute query query: insert into NEXUS_STATIONS set
> RD_SERVICE="Production"
>
>
> DB creation is halted on 309 DB schema
>
>
> MariaDB [Rivendell]> select * from VERSION;
> +-----+---------------------+----------------------+
> | DB | LAST_MAINT_DATETIME | LAST_ISCI_XREFERENCE |
> +-----+---------------------+----------------------+
> | 309 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 |
> +-----+---------------------+----------------------+
> 1 row in set (0.000 sec)
>
> MariaDB [Rivendell]> desc NEXUS_STATIONS;
> +---------------+---------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +---------------+---------------+------+-----+---------+-------+
> | STATION | varchar(255) | NO | | NULL | |
> | CATEGORY | varchar(10) | NO | | NULL | |
> | AUTO_MERGE | enum('N','Y') | YES | | N | |
> | RD_SERVICE | varchar(10) | NO | | NULL | |
> | RD_GROUP_NAME | varchar(10) | NO | | NULL | |
> | RD_SCHED_CODE | varchar(11) | NO | | NULL | |
> +---------------+---------------+------+-----+---------+-------+
> 6 rows in set (0.001 sec)
>
>
>
> Nearly everything defaults to NULL and can't be NULL, but the
values are
> not specified in the INSERT query.
>
>
--
Léon.
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
<mailto:Rivendell-dev@lists.rivendellaudio.org>
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
