Hey Jim, On 9/20/21 22:00, JT wrote:
Greetings -I have installed Riv 3.6.2, and done an initial successful checkout using the rddbmgr create audio option. Proving out the system, I then took a Rivendell database (a dump of just that database, <splat>.sql ) FROM ANOTHER machine with a full set of existing carts, logs, etc... and restored over the database in the newly installed machine. $sudo mysql -u root -p Rivendell < <splat>.sql Both machines had the same "/etc/host" name, along with a similarly default /etc/rd.conf file. On the new machine <mumble>$ ls /var/snd shows all files. On the new machine RDLibrary sees all the sound files, and plays them. However, RDAirplay throws an error: rdairplay: invalid SQL or failed DB connection[Column 'EVENT_DATETIME' cannot be null QMYSQL: Unable to execute query]: insert into ELR_LINES set SERVICE_NAME="Production",LENGTH=60549236,LOG_NAME="",LOG_ID=1,CART_NUMBER=45002,STATION_NAME="Rivendell",EVENT_DATETIME=NULL,EVENT_TYPE=3,EVENT_SOURCE=0,EXT_START_TIME=NULL,EXT_LENGTH=-1,EXT_DATA="",EXT_EVENT_ID="",EXT_ANNC_TYPE="",PLAY_SOURCE=1,CUT_NUMBER=1,EXT_CART_NAME="",TITLE="Monitor Beacon",ARTIST="NBC Radio Network",SCHEDULED_TIME=NULL,ISRC="",PUBLISHER="",COMPOSER="",USAGE_CODE=0,START_SOURCE=1,ONAIR_FLAG="N",ALBUM="",LABEL="",USER_DEFINED="d1",CONDUCTOR="",SONG_ID="",DESCRIPTION="Cut 001",OUTCUE="",ISCI="" Sep 20 16:49:09 Rivendell rdairplay: log engine: RDLogPlay::StartEvent(): no audio,CUT=045002_001On the new machine mysql> select * from mysql.user has a row for rduser@localhost, and rduser@%On the new machine mysql> show grants for rduser@localhost has seemingly correct privileges On the new machine $mysql -u rduser -p correctly logins in with default credentials as listed in /etc/rd.conf By chance does the entire mariadb have to be transferred, as opposed to just the Rivendell database? Any suggestions appreciated!
Thanks for providing the details to your problem, it helps troubleshoot!I think your error has nothing to do with the database. Rather, there's an issue with "time" on the new system. Grasping here: is your time-of-day clock set properly? The reason I ask this is "EVENT_DATETIME=NULL" error in the rdairplay output. The database schema says:
`EVENT_DATETIME` datetime NOT NULL,
And for some reason, your system is setting (or leaving)
eventDateTimeSQL in the C++ code to NULL.
Looking at the code in lib/rdlogplay.cpp, I see that EVENT_DATETIME comes from a conditional expression that sets the event time in the method RDCheckDateTime(), but only if the current time and the event start time pass "validity checks" (QT isValid() method).
So, from what I can gather, this is either a bug in the Rivendell code, or there's something fishy with the clock on your computer. Or something else...
Regardless, it seems to me that this code could be improved to either set the event datetime to something "reasonable" or simply permit NULL in the database (probably not a good idea). RDAirplay, in my opinion, should play audio even if it can't log the occurrence of an event.
For starters, I'd say, make sure NTP (or systemd equivalent) is running and the clock is set properly on the computer.
Maybe Fred can weigh in on this one? ~David Klann
Thanks, Jim Thrasher _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
