Re: [RDD] Rivendell plays but will not record
Rob, You may need to update your HPI driver. According to release notes (summary at http://wiki.rivendellaudio.org/index.php/ChangeSummary#2.19.1_.282018-03-27.29) there were some changes to the ASI drivers. I don't have access to any current ASI cards, so take this with a large grain of salt... ~David On 04/10/2018 09:39 PM, Rob Landry wrote: > > I'm running RD 2.19.1 under CentOS 6. > > If I start rdlibrary, add a new cart, bring up the Cut Info/Record > screen, and press the Record button, the Ingest field fills with the > current date and time but the Record button doesn't flash. Pressing the > Play button causes the green arrow to flash once and then the Stop > button highlights. No recording is made. > > Nor will rdcatch record anything. > > I have checked the relevant settings in rdadmin and they seem OK. Audio > Resources shows my ASI5211 card with 2 inputs and 1 output. rdlibrary is > set to record from card 0, input 0, and play on card 0, output 0. > > Changing from input 0 to input 1 doesn't help. > > This used to work, but problems with rdcatch segfaulting induced me to > try upgrading to RD 2.19.1 from 2.18. Now it won't record at all. > > I've a feeling I'm overlooking something obbvious but it's late and I've > been working on some or another radio station since early this morning. > Any suggestions would be welsome, err, welcome. > > > Rob > > > > ___ > 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
[RDD] Rivendell plays but will not record
I'm running RD 2.19.1 under CentOS 6. If I start rdlibrary, add a new cart, bring up the Cut Info/Record screen, and press the Record button, the Ingest field fills with the current date and time but the Record button doesn't flash. Pressing the Play button causes the green arrow to flash once and then the Stop button highlights. No recording is made. Nor will rdcatch record anything. I have checked the relevant settings in rdadmin and they seem OK. Audio Resources shows my ASI5211 card with 2 inputs and 1 output. rdlibrary is set to record from card 0, input 0, and play on card 0, output 0. Changing from input 0 to input 1 doesn't help. This used to work, but problems with rdcatch segfaulting induced me to try upgrading to RD 2.19.1 from 2.18. Now it won't record at all. I've a feeling I'm overlooking something obbvious but it's late and I've been working on some or another radio station since early this morning. Any suggestions would be welsome, err, welcome. Rob -- Я там, где ребята толковые, Я там, где плакаты "Вперёд", Где песни рабочие новые Страна трудовая поёт.___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
[RDD] SQL errors with rdlogedit
I am seeing the following show up in the logs when using rdlogedit to add a file. There is no error reported however the entry never gets saved. However in the logs, there is an SQL error reported. For whatever reason, rdlogedit is passing 0 for ID of the new record rather than using NULL which would trigger autoincrement: Apr 9 20:55:18 westcoast rdlogedit: invalid SQL or failed DB connection[Duplicate entry '0' for key 'PRIMARY' QMYSQL3: Unable to execute query]: insert into `WEST18_04_10_LOG` (ID,COUNT,CART_NUMBER,START_TIME,TIME_TYPE, TRANS_TYPE,START_POINT,END_POINT,SEGUE_START_POINT,SEGUE_END_POINT,TYPE, COMMENT,LABEL,GRACE_TIME,SOURCE,EXT_START_TIME, EXT_LENGTH,EXT_DATA,EXT_EVENT_ID,EXT_ANNC_TYPE,EXT_CART_NAME, FADEUP_POINT,FADEUP_GAIN,FADEDOWN_POINT,FADEDOWN_GAIN,SEGUE_GAIN, LINK_EVENT_NAME,LINK_START_TIME,LINK_LENGTH,LINK_ID,LINK_EMBEDDED, ORIGIN_USER,ORIGIN_DATETIME,LINK_START_SLOP,LINK_END_SLOP, DUCK_UP_GAIN,DUCK_DOWN_GAIN,EVENT_LENGTH) values (0,0,999101,0,0,0,-1,-1,-1,-1,0,"","",0,3,"00:00:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2017-10-26 13:57:58",0,0,0,0,9000),(1,1,100029,1,0,0,-1,-1,-1,-1,0,"","",0,3,"00:00:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2018-04-08 23:42:13",0,0,0,0,131),(2,2,999100,1376500,0,0,-1,-1,-1,-1,0,"","",-1,3,"00:00:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2018-03-30 12:56:34",0,0,0,0,131),(3,3,30006,1355000,0,1,-1,-1,-1,-1,0,"","",0,2,"00:22:35",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2016-11-17 19:11:47",0,0,0,0,145000),(4,4,30279,150,0,1,-1,-1,-1,-1,0,"","",0,2,"00:25:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2016-06-05 18:25:56",0,0,0,0,18),(5,5,800702,180,1,0,-1,-1,-1,-1,0,"","",0,3,"00:00:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2017-11-10 21:53:02",0,0,0,0,5000),(6,6,80008,1805000,0,1,-1,-1,-1,-1,0,"","",0,3,"00:00:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2016-01-13 17:44:08",0,0,0,0,1555000),(7,7,100019,1808700,0,1,-1,-1,-1,-1,0,"","",-1,3,"00:00:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2018-04-08 23:32:13",0,0,0,0,1555000),(8,8,80008,3378400,0,1,-1,-1,-1,-1,0,"","",-1,3,"00:00:00",0,"","","" Short of looking into the code, I have no idea why this is happening. Any help on resolving this would be greatly appreciated. I am running version 2.15.1. Mike ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Mysql Backup
On Tue, 10 Apr 2018 13:01:42 -0400 ija...@jamcorbroadcast.com wrote: > I have been trying to make backup of database. I have tries different > ways to still no success. Open rdadmin Click Backup Database Give it the filename you'd like. Click Save -- Cowboy Fine words! I wonder where you stole them ? ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
[RDD] Mysql Backup
Here is what I have been doing I have been trying to make backup of database. I have tries different ways to still no success. I have not changes anything in the config Here is what I have don so far. 1. I Mounted a hardrive to the Machine Did a Mysquldump to a local folder. I have some instruction bit they I am Missing something. Is Not making The Backup 2. I Was trying to connect to The Mysql Database. It doe not let me Fails to connect. Does Anyone have any documentation or Procedures to connect to The Mysql Database. I am Using Original Set up no changes to The system. I am als trying to copy The Entire Var Directory. Thiers The gmd & SMD that I don't have right to.. I am trying to also fighure out wher the Logs are Kept so I can Make a back up of those to It a ong process to try to copy one by one in RD Log editor. Thanks ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] FTP set up using FileZilla into Appliance
I read your directions and will try your suggestions. I am still trying to learn scripting not a pro at it yet. Do you have a sample script that you can share for me to look at. Thanks On 2018-04-10 03:49, Robert Jeffares wrote: Hi James, On 10/04/18 16:47, ija...@jamcorbroadcast.com wrote: Thanks for your response. We where trying to use Online service Dropbox I have some programmes delivered via Dropbox© and I mapped a copy of my Dropbox folder onto my "Production" [hack used to do everything] machine. That was easy enough I followed the Dropbox help files. I then wrote a script that copied the files out of the locally mounted Dropbox into a local folder. The script also cleans up the filenames and makes them a bit more user friendly. We found having a number of users is a hazard as it only takes one to delete a file and it's deleted for everyone. You think the file is there because yu have been sent a link to it. I also have three different programme providers using three different Dropbox so it became just as easy to download them all manually. I think there is a way to acumulate them but it's just as easy to click on email links. These are all syndicated programmes. For local programmes, news, weather, traffic, waterrestrictions and breaking news I have a dropbox [note all lower case] on each machine in 6 locations and each machine polls some or all of th others for updates which can be created at any one of the sites or externally. Each machine downloads items it needs locally identified by filename and one central machine [igor] holds a copy of everything. All the heavy lifting is done by rsync in shell scripts scheduled by cron with log files written to the dropbox some of which get emailed as confirmations the job is done. Some items are carted using rdimport others [mostly weather] using rdcatch. Weather can be recorded and updated at any time. We have a series of bulletins which vary in content so each has a unique name and we can go from fine to frenzy incredibly quickly. At one site I use rsync running on cygwin to align folders on a windows machine over an intercontinental link, one end of which is very unreliable. Fortunately the time difference allows the far end to work well in advance of broadcast time. At the near end the folder is shared to local Windows machines using Samba. we have been using dropbox long before the name was used to market an eponymous service I figured That you have to manually move files from dropbox to RD. not necessarily I am trying to automate The process. see above But for right now I guess its ok. I have made the appropriate folders. I recommend you set up your own dropbox and have contributors Filezilla or otherwise send audio directly to your server. Relying on some cloud based service, especially a free one, over which you have no control is a bit brave for me. My Other Question as per Weather ect Do you can you have RD catch Import Voicetracks For different. I have been insuccessful in getting Rd Carch to work. I can't get to import anything. we have a file called trunk9amweather.wav [you can call yours whatever you like but *NO* punctuation, gaps, wildcards, non alpha numeric, and no spaces or - at the start of the filename] it is recorded and placed in the dropbox /home/rd/dropbox/trunk9amweather.wav <--you need all of this Set RDCATCH to DOWNLOAD this file. Give the thing a name; use the full name and location pick the cart it is to be loaded into I use autotrim -30 and normalise -13 [some sources I run -10] make sure you check all the days of the week you want it top happen;default is none set the time you want it to run [top left hand corner] 08:58 is good for 9am If the audio is a minute long give it two and if it's a half hour programme be prepared for the normalize to take a little while. the username is rd and the password is whatever password you put in to users and groups>rd save You can test by opening it up again and setting the time to a minute from now then hit save as new close and look for the yellow line which indicates i'm next; it goes green when it downloads and if successful it is white Red/Pink is an error and along the right is the reason Most common after typos is wrong permissions on dropbox and on files in dropbox. I make a habit of setting permissions on all files in the dropbox in shellscripts so everything gets chown to rd:users and chmod 644 although I had to make that 666 to make an OS X Mac happy. You should be able to follow this as you work through I have used rdcatch to download some material direct from http and ftp sources with varying success, some servers just don't deliver, and you have to resort to wget. I think much of the problem is incompatible character sets but you can run in to issues with filenames including dates. Service provider labeling inconstancies will drive you nuts as well. Hope this helps regards Robert
Re: [RDD] MySQL chatter
Hey Robert, I've seen this "chatter" going back to Rivendell version 2.10.3, and maybe even longer ago than that. I too am wary of it, but so far (in my experience) it has not caused any problems with importing audio. ~David On 04/10/2018 01:46 AM, Robert Jeffares wrote: > I have been getting a lot of reports like this when injesting audio both > in dropbox mode and with rdimport on the CentOS 6 Appliance 2.19.1/275 > > despite the chatter everything works fine > > Its just unnerving. > > > invalid SQL or failed DB connection[MySQL server has gone away QMYSQL3: > Unable to execute query]: select FILE_DATETIME from > DROPBOX_PATHS where > (DROPBOX_ID=7)&&(FILE_PATH="/home/rd/dropbox/tuesdaybiblestudy.wav") > Database connection failed: select FILE_DATETIME from > DROPBOX_PATHS where > (DROPBOX_ID=7)&&(FILE_PATH="/home/rd/dropbox/tuesdaybiblestudy.wav") > 04-10-2018 - 18:34:35 : Deleting cuts from cart 000804 > invalid SQL or failed DB connection[Duplicate entry '804' for key > 'PRIMARY' QMYSQL3: Unable to execute query]: insert into CART set > NUMBER=804,TYPE=1,GROUP_NAME="FEATURES",TITLE="\[cart\ 000804-1]" > 04-10-2018 - 18:34:35 : Importing file "tuesdaybiblestudy.wav" to cart > 000804 ... done. > 04-10-2018 - 18:34:51 : Deleted file "tuesdaybiblestudy.wav" > > > > regards > > > Robert > > ___ > 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
Re: [RDD] FTP set up using FileZilla into Appliance
Hi James, On 10/04/18 16:47, ija...@jamcorbroadcast.com wrote: Thanks for your response. We where trying to use Online service Dropbox I have some programmes delivered via Dropbox© and I mapped a copy of my Dropbox folder onto my "Production" [hack used to do everything] machine. That was easy enough I followed the Dropbox help files. I then wrote a script that copied the files out of the locally mounted Dropbox into a local folder. The script also cleans up the filenames and makes them a bit more user friendly. We found having a number of users is a hazard as it only takes one to delete a file and it's deleted for everyone. You think the file is there because yu have been sent a link to it. I also have three different programme providers using three different Dropbox so it became just as easy to download them all manually. I think there is a way to acumulate them but it's just as easy to click on email links. These are all syndicated programmes. For local programmes, news, weather, traffic, waterrestrictions and breaking news I have a dropbox [note all lower case] on each machine in 6 locations and each machine polls some or all of th others for updates which can be created at any one of the sites or externally. Each machine downloads items it needs locally identified by filename and one central machine [igor] holds a copy of everything. All the heavy lifting is done by rsync in shell scripts scheduled by cron with log files written to the dropbox some of which get emailed as confirmations the job is done. Some items are carted using rdimport others [mostly weather] using rdcatch. Weather can be recorded and updated at any time. We have a series of bulletins which vary in content so each has a unique name and we can go from fine to frenzy incredibly quickly. At one site I use rsync running on cygwin to align folders on a windows machine over an intercontinental link, one end of which is very unreliable. Fortunately the time difference allows the far end to work well in advance of broadcast time. At the near end the folder is shared to local Windows machines using Samba. we have been using dropbox long before the name was used to market an eponymous service I figured That you have to manually move files from dropbox to RD. not necessarily I am trying to automate The process. see above But for right now I guess its ok. I have made the appropriate folders. I recommend you set up your own dropbox and have contributors Filezilla or otherwise send audio directly to your server. Relying on some cloud based service, especially a free one, over which you have no control is a bit brave for me. My Other Question as per Weather ect Do you can you have RD catch Import Voicetracks For different. I have been insuccessful in getting Rd Carch to work. I can't get to import anything. we have a file called trunk9amweather.wav [you can call yours whatever you like but *NO* punctuation, gaps, wildcards, non alpha numeric, and no spaces or - at the start of the filename] it is recorded and placed in the dropbox /home/rd/dropbox/trunk9amweather.wav <--you need all of this Set RDCATCH to DOWNLOAD this file. Give the thing a name; use the full name and location pick the cart it is to be loaded into I use autotrim -30 and normalise -13 [some sources I run -10] make sure you check all the days of the week you want it top happen;default is none set the time you want it to run [top left hand corner] 08:58 is good for 9am If the audio is a minute long give it two and if it's a half hour programme be prepared for the normalize to take a little while. the username is rd and the password is whatever password you put in to users and groups>rd save You can test by opening it up again and setting the time to a minute from now then hit save as new close and look for the yellow line which indicates i'm next; it goes green when it downloads and if successful it is white Red/Pink is an error and along the right is the reason Most common after typos is wrong permissions on dropbox and on files in dropbox. I make a habit of setting permissions on all files in the dropbox in shellscripts so everything gets chown to rd:users and chmod 644 although I had to make that 666 to make an OS X Mac happy. You should be able to follow this as you work through I have used rdcatch to download some material direct from http and ftp sources with varying success, some servers just don't deliver, and you have to resort to wget. I think much of the problem is incompatible character sets but you can run in to issues with filenames including dates. Service provider labeling inconstancies will drive you nuts as well. Hope this helps regards Robert ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
[RDD] MySQL chatter
I have been getting a lot of reports like this when injesting audio both in dropbox mode and with rdimport on the CentOS 6 Appliance 2.19.1/275 despite the chatter everything works fine Its just unnerving. invalid SQL or failed DB connection[MySQL server has gone away QMYSQL3: Unable to execute query]: select FILE_DATETIME from DROPBOX_PATHS where (DROPBOX_ID=7)&&(FILE_PATH="/home/rd/dropbox/tuesdaybiblestudy.wav") Database connection failed: select FILE_DATETIME from DROPBOX_PATHS where (DROPBOX_ID=7)&&(FILE_PATH="/home/rd/dropbox/tuesdaybiblestudy.wav") 04-10-2018 - 18:34:35 : Deleting cuts from cart 000804 invalid SQL or failed DB connection[Duplicate entry '804' for key 'PRIMARY' QMYSQL3: Unable to execute query]: insert into CART set NUMBER=804,TYPE=1,GROUP_NAME="FEATURES",TITLE="\[cart\ 000804-1]" 04-10-2018 - 18:34:35 : Importing file "tuesdaybiblestudy.wav" to cart 000804 ... done. 04-10-2018 - 18:34:51 : Deleted file "tuesdaybiblestudy.wav" regards Robert ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
