Jump to content

User:Chriss: Difference between revisions

From LinuxMCE
Chriss (talk | contribs)
m progress with virtualisation
Chriss (talk | contribs)
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 16: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

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