Hello again,
I hope I don't bother you too much, but we are having an unexpected difficulty.
While I should be finding out how to bulk import music with a dropbox-folder, I
decided to demonstrate someone how a cart will be filled. So I created a cart,
hit the Import/Export button, selected a song and pressed "OK". At which point
the above error appeared.
The system manager/whizzkid tried to solve this, but the things he tried,
didn't work. Underneath is what he sent me.
_____
Rivendell 2.6.0, op CentOS 6.5
I have no idea if there are more error logs of Rivendell, but
/var/log/messages says:
Dec 21 12:59:26 rdnonstop rdlibrary: invalid SQL or failed DB
connection[You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near ')&& ((CART.TITLE like "%")|| (CART.ARTIST like
"%")||(CART.CLIENT like " 0x0.0000000000668p-1022t line 1 QMYSQL3:
Unable to execute query]: select
CART.NUMBER,CART.FORCED_LENGTH,CART.TITLE,CART.ARTIST,
CART.CLIENT,CART.AGENCY,CART.USER_DEFINED,
CART.COMPOSER,CART.PUBLISHER,CART.CONDUCTOR,
CART.GROUP_NAME,CART.START_DATETIME,CART.END_DATETIME,CART.TYPE,
CART.CUT_QUANTITY,CART.LAST_CUT_PLAYED,
CART.ENFORCE_LENGTH,CART.PRESERVE_PITCH,
CART.LENGTH_DEVIATION,CART.OWNER,CART.VALIDITY,GROUPS.COLOR,
CUTS.LENGTH,CUTS.EVERGREEN,CUTS.START_DATETIME,CUTS.END_DATETIME,
CUTS.START_DAYPART,CUTS.END_DAYPART,CUTS.MON,CUTS.TUE,
CUTS.WED,CUTS.THU,CUTS.FRI,CUTS.SAT,CUTS.SUN from CART left join
GROUPS on CART.GROUP_NAME=GROUPS.NAME left join CUTS on
CART.NUMBER=CUTS.CART_NUMBER where ()&& ((CART.TITLE like "%")||
(CART.ARTIST like "%")||(CART.CLIENT like "%")|| (CART.AGENCY like
"%")||(CART.ALBUM like "%")|| (CART.LABEL like "%")||(CART.NUMBER
like "%")|| (CART.PUBLISHER like "%")||(CART.COMPOSER like "%")||
(CART.CONDUCTOR like "%")||(CART.SONG_ID like "%")||
(CART.USER_DEFINED like "%")||(CUTS.ISCI like "%")
||(CUTS.ISRC like "%")
||(CUTS.DESCRIPTION like "%")
||(CUTS.OUTCUE like "%")) && ((TYPE=1)||(TYPE=2)||(TYPE=3)) order by
CART.NUMBER limit 100
The error appears, I think, at the startup of RDLibrary. No errors appears
while importing audio of deleting carts.
Permissions of /var/snd/ are set to "rivendell" (mode 777 is set
temporary to test, was 775):
[root@rdnonstop ~]# ls -al /var/snd/
totaal 1900
drwxrwxrwx. 2 rivendell rivendell 4096 dec 21 12:32 .
drwxr-xr-x. 20 root root 4096 dec 19 13:51 ..
-rw-r--r--. 1 rivendell rivendell 1933368 dec 19 15:09 999999_001.wav
AudioOwner and AudioGroup are set to "rivendell":
[root@rdnonstop ~]# grep Audio.*= /etc/rd.conf
AudioOwner=rivendell
AudioGroup=rivendell
Rivendell user is in correct group:
[root@rdnonstop ~]# groups rivendell
rivendell : rivendell
And rdlibrary is running as the correct user:
[root@rdnonstop ~]# ps U rivendell | grep rdlibrary
1969 ? S 0:00 rdlibrary
To top it all off, I've disabled SELinux:
[root@rdnonstop ~]# sestatus
SELinux status: disabled
RDLibrary -should- have permissions to write to /var/snd/.
_____
So, does anyone know how to solve this? Because it would be really nice to have
some music in our database, in order to start running a Rivendell operated
radio station.
Kind regards,
Peter van Embden
www.radiocapelle.nl
Verstuurd_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
