Difference between revisions of "User:Chriss"

From LinuxMCE
Jump to: navigation, search
m (progress with virtualisation)
(move pluto_media.MediaType_AttributeType)
Line 20: Line 20:
  
 
=== move pluto_media.MediaType_AttributeType ===
 
=== move pluto_media.MediaType_AttributeType ===
 +
ALTER TABLE `pluto_media`.MediaType_AttributeType RENAME `pluto_main`.`MediaType_AttributeType`;
 +
ALTER TABLE `pluto_main`.`MediaType_AttributeType` CHANGE `EK_MediaType` `FK_MediaType` INT( 11 ) NOT NULL DEFAULT '0';
 +
ALTER TABLE `pluto_main`.`MediaType_AttributeType` CHANGE `FK_AttributeType` `EK_AttributeType` INT( 11 ) NOT NULL DEFAULT '0';
 +
ALTER TABLE `pluto_main`.`MediaType_AttributeType` DROP INDEX `FK_AttributeType` , ADD INDEX `EK_AttributeType` ( `EK_AttributeType` );
 +
CREATE VIEW `pluto_media`.`MediaType_AttributeType` AS SELECT `FK_MediaType` AS 'EK_MediaType', `EK_AttributeType` AS 'FK_AttributeType', `Identifier`, `CombineAsOne`, `MediaSortOption` FROM `pluto_main`.`MediaType_AttributeType`;
  
 
== LMCE 0810 virtualized on Ubuntu 9.04 and KVM ==
 
== LMCE 0810 virtualized on Ubuntu 9.04 and KVM ==

Revision as of 17:15, 2 August 2009

Setup

Core

MDs

Notes to myself

Don't care about the following stuff and beware to use anything if you don't know exactley what you are doing...

proper image support for UpdateMedia

http://svn.linuxmce.org/trac.cgi/ticket/217

Updates to pluto_media.MediaType_AttributeType

  • Added by pos on 2009-07-31:
INSERT INTO `MediaType_AttributeType` (`EK_MediaType`, `FK_AttributeType`, `Identifier`, `CombineAsOne`, `MediaSortOption`) VALUES
(7, 16, 0, 0, NULL),
(7, 29, 0, 0, NULL),
(7, 37, 0, 0, NULL),
(7, 47, 0, 0, NULL),
(7, 48, 0, 0, NULL);

move pluto_media.MediaType_AttributeType

ALTER TABLE `pluto_media`.MediaType_AttributeType RENAME `pluto_main`.`MediaType_AttributeType`;
ALTER TABLE `pluto_main`.`MediaType_AttributeType` CHANGE `EK_MediaType` `FK_MediaType` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `pluto_main`.`MediaType_AttributeType` CHANGE `FK_AttributeType` `EK_AttributeType` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `pluto_main`.`MediaType_AttributeType` DROP INDEX `FK_AttributeType` , ADD INDEX `EK_AttributeType` ( `EK_AttributeType` );
CREATE VIEW `pluto_media`.`MediaType_AttributeType` AS SELECT `FK_MediaType` AS 'EK_MediaType', `EK_AttributeType` AS 'FK_AttributeType', `Identifier`, `CombineAsOne`, `MediaSortOption` FROM `pluto_main`.`MediaType_AttributeType`;

LMCE 0810 virtualized on Ubuntu 9.04 and KVM

work in progress


    • on the shell: virsh --connect qemu:///system
    • in virsh: define lmce0810.xml, start lmce0810
    • connect via VNC and do the installation

Links to keep in mind

Creating_a_Media_Plug-in

http://forum.linuxmce.org/index.php?topic=3433.60

ideas

  • improve media tagging in webadmin
  • picture media player
  • media transcoding plugin