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_001 On 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, Jim Thrasher _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
