I have same here 3.6.5
I was doing some research and there is a way to change the DB engines.
I am not certian where I saw this documentation I will add on this tread if I find it again. By the way do you know if the Rivendell DB is hidden in MariaDB, I tried show databases and no database is showing for Rivendell
Does anyone have the answer to this.

*I found this tutorial that may help you on youtube
https://www.youtube.com/watch?v=y25eX2zQsgs





On 2022-06-21 12:28, Rob Landry wrote:
Old MariaDB version (CentOS 7): 5.5.68
New MariaDB version (Rocky Linux 8): 10.3.32

...and I'm running Rivendell 3.6.5 (not 4.x).


Rob

--
Не думай что всё пропели,
Что бури все отгремели;
Готовься к великой цели,
А слава тебя найдёт.


On Mon, 20 Jun 2022, [email protected] wrote:

Rob,
check your database version from your old machine and the new machine.
I am having a similar issue. You may have the old databases versions 5.1. and the new system I am going to 5.5 MariaDB. But I am having a error when RD opens in air Play or the library.
I hope this helps




On 2022-06-18 15:27, Rob Landry wrote:
I went and looked at the RDAIRPLAY table in the other RD 3.6.5 system
(which had been installed using the Paravel script under CentOS 7).

Based on what I found there, I went back to the new system, where the
RDAIRPLAY table had no entries.

I executed the following MySQL statement:

INSERT INTO RDAIRPLAY (STATION,INSTANCE) values ("sistrurus",0);

...and now I no longer see the error message when I run rdadmin.
rdairplay no longer asks for a password when I try to exit, and values
I enter in the rdairplay screen under Manage Hosts now get saved,
which they hadn't been.

It sounds like the database restore wasn't perfect. I wonder what
other problems there might be that I haven't encountered yet.

This system is going to get tested thoroughly before it gets deployed.

Today's lesson seems to be: don't try to install Rivendell 3.6.5 on a
Dell Inspiron 3910. My client gave me three of these things, and it's
been tough sledding.


Rob

--
Не думай что всё пропели,
Что бури все отгремели;
Готовься к великой цели,
А слава тебя найдёт.


On Sat, 18 Jun 2022, Rob Landry wrote:


invalid SQL or failed DB connection[Field 'INSTANCE' doesn't have a default value QMYSQL: Unable to execute query]: insert into `RDAIRPLAY` set STATION="sistrurus"

This is on an RD 3.6.5 system compiled from source under Rocky Linux 8, usig a database restored from a backup from another RD 3.6.5 system.


Rob

--
Не думай что всё пропели,
Что бури все отгремели;
Готовься к великой цели,
А слава тебя найдёт.

_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev


_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Reply via email to