Sorry hit reply on the wrong email, this should be for David Chamla's MySQL problems.
-----Original Message----- From: rivendell-dev-boun...@lists.rivendellaudio.org on behalf of Wayne Merricks Sent: Sun 19/08/2012 19:08 To: User discussion about the Rivendell Radio Automation System Subject: RE: [RDD] Integrate patches in script... / Compile 2.1.5 ->Xubuntu12.04 OK I resorted to Google for this but the error: "The maximum row size for the used table, type, not counting BLOBs, is 8126" Is related to using Innodb with a 16k page size. For reasons I forget this page size is taken down to 8k (8192) and you lose 64 for the index. Not sure where the other 2 bytes have gone mind. Anyway I had a look on the DB I use, if you're in Emma and you click on Table when you've selected the SERVICES table you'll see the SQL code for that table. Mine looked like this: CREATE TABLE `SERVICES` ( `NAME` char(10) NOT NULL, `DESCRIPTION` char(255) DEFAULT NULL, `NAME_TEMPLATE` char(255) DEFAULT NULL, `PROGRAM_CODE` char(255) DEFAULT NULL, ... SNIP SNIP ... `CLOCK167` char(64) DEFAULT NULL, PRIMARY KEY (`NAME`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 The thing to note (I hope) is that mine shows ENGINE=MyISAM which doesn't have this page size limitation (or at least not as small by default). Is your DB also showing MyISAM? I'm honestly not sure why your MySQL setup would be any different from the defaults unless its some strange charset change that forces something different to MyISAM. -----Original Message----- From: rivendell-dev-boun...@lists.rivendellaudio.org on behalf of Rüdiger Sent: Sun 19/08/2012 14:01 To: rivendell-dev@lists.rivendellaudio.org Subject: Re: [RDD] Integrate patches in script... / Compile 2.1.5 ->Xubuntu12.04 Am 18.08.2012 16:46, schrieb Wayne Merricks: > The guide still applies, just skip the steps for pulse audio and any gnome > stuff you don't want. > > Ignore part 3 of the guide and the JACK Scripts of part 5. > > When you move on to getting JACK, Riv and Pulse working you only need the two > JACK scripts simply for starting and stopping the Riv daemons. > > #!/bin/bash > #FILE: jack-post-start.sh > #Start Rivendell Daemons > /usr/local/bin/caed > /usr/local/bin/ripcd > /usr/local/bin/rdcatchd > sleep 5 #not strictly necessary > > and this one: > > #!/bin/bash > #FILE: jack-pre-stop.sh > #Stop Rivendell Daemons > killall rdcatchd ripcd caed > sleep 2 Have nearly finished my script to do that all. But how to automaticaly create the /var/run/rivendell at every boot. Can't put it in the jack script without having root right at this moment... The only way i know is to put it in /etc/rc.local... -- -- Ruediger Radio Ostfriesland Techniksupport Automation _______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev Scanned by MailMarshal Attention: The information contained in this message is confidential and intended for the addressee(s) only. If you have received this message in error or there are any problems, please notify the originator immediately. The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden. Christian Vision or any of its subsidiaries will not be liable for direct, special, indirect or consequential damages arising from alteration of the contents of this message by a third party or as a result of any virus being passed on. Please note that we reserve the right to monitor and read any e-mails sent or received by the company under the Telecommunications (Lawful Business Practice) (Interception of Communications) Regulation 2000. Christian Vision is registered in England as a limited company 2842414 and as a charity 1031031 ####################### Scanned by MailMarshal ####################### ############ Attention: The information contained in this message is confidential and intended for the addressee(s) only. If you have received this message in error or there are any problems, please notify the originator immediately. The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden. Christian Vision or any of its subsidiaries will not be liable for direct, special, indirect or consequential damages arising from alteration of the contents of this message by a third party or as a result of any virus being passed on. Please note that we reserve the right to monitor and read any e-mails sent or received by the company under the Telecommunications (Lawful Business Practice) (Interception of Communications) Regulation 2000. Christian Vision is registered in England as a limited company 2842414 and as a charity 1031031 ############
<<winmail.dat>>
_______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
