First, a huge THANK YOU to Fred Gleason (and others?) for this release! The new opsguide is fabulous! It's one of those things I've always hoped for! I've updated the Rivendell Wiki with the change summary for 2.18.0 (http://rivendell.tryphon.org/wiki/ChangeSummary). Thanks Fred!
I just compiled v2.18.0 on Debian 8.10 and encountered a SQL sytax error when running RDLibrary. It appears as if the error is from an empty WHERE clause in this statement: select CART.NUMBER,CART.FORCED_LENGTH,CART.TITLE,CART.ARTIST,CART.ALBUM,CART.LABEL,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 Notice the empty condition in the first part of the WHERE clause. This is on Debian 8.10 with MySQL "Ver 14.14 Distrib 5.5.58, for debian-linux-gnu (x86_64) using readline 6.3", updated just before compiling Rivendell. RDAdmin works fine, but apps that access the library (e.g., RDAirPlay) seem to be busted. The database tables CART and CUTS are both configured as "ENGINE=InnoDB DEFAULT CHARSET=latin1" (as seen with SHOW CREATE TABLE). Here's the output of SHOW ENGINES on this server: Engine Support Comment Transactions XA Savepoints MRG_MYISAM YES Collection of identical MyISAM tables NO NO NO CSV YES CSV storage engine NO NO NO MyISAM YES MyISAM storage engine NO NO NO BLACKHOLE YES /dev/null storage engine (anything you write to it disappears) NO NO NO MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO InnoDB DEFAULT Supports transactions, row-level locking, and foreign keys YES YES YES ARCHIVE YES Archive storage engine NO NO NO PERFORMANCE_SCHEMA YES Performance Schema NO NO NO FEDERATED NO Federated MySQL storage engine NULL NULL NULL ~David Klann On 12/21/2017 12:12 PM, Marius Wikstøl wrote: > I've done a fresh install of Debian 9 and Rivendell v2.18.0 and done all > of the steps mentioned, but I still get an error when running rdadmin > for the first time. What I get is a SQL-syntax error. > > Marius > > On 11/20/2017 10:12 PM, Rob Landry wrote: >> >> For the benefit of anyone attempting to get Rivendell running under >> Debian 9, the MySQL problem is not a bug, but a new feature. >> >> By default, the root user is created in the mysql user table with >> plugin = 'unix_socket'. >> >> That plugin does not allow any Unix user but root to log in to MySQL >> as 'root', whatever the password field is set to. >> >> So, before you run rdadmin, you have to log in as root and change the >> root user to plugin = NULL. >> >> [Pardon my caps, but WHAT IDIOT CAME UP WITH THIS IDEA? I want to >> personally kick his ass all the way to Alabama.] >> >> Now, there's a second problem. which is that creating any table with a >> primary key longer than 197 produces an error. >> >> In /etc/mysql/mariadb.conf.d/50-server.cnf: >> >> Change: >> >> character-set-server = utf8mb4 >> collation-server = utf8mb4_general_ci >> >> ...to: >> >> character-set-server = latin1 collation-server = latin1_swedish_ci >> >> >> [Whose was the bright idea to replace real MySQL with this imitation >> frozen substitute for artificial morning breakfast beverage wih >> pulp-like particles added, just like the concentrate that tastes >> almost like fresh?] >> >> [Yeah, I know, I should be running CentOS. And I would, if this >> machine would let me install it.] >> >> >> Rob, grumble grumble grumble >> >> >> >> _______________________________________________ >> 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 >
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
