Difference between revisions of "User:Chriss"
From LinuxMCE
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
Contents
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
- inspired by http://forum.linuxmce.org/index.php?topic=8233.0
- installed Ubuntu 9.04 alternate amd64, basic text system
- downloaded kernel 2.6.30.4 from kernel.org, build according to https://wiki.ubuntu.com/KernelTeam/GitKernelBuild
- install kvm and stuff: https://help.ubuntu.com/community/KVM/Installation
- install kubuntu 8.10
- download kubuntu 8.10 i386 desktop .iso
- create an image file (qemu-img create -f qcow lmce0810.img 25G) or use an empty and unmounted partition (that's what I'm doing in the following)
- create a file (lmce0810.xml) with the description for your domain:
- 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
http://forum.linuxmce.org/index.php?topic=3433.60
ideas
- improve media tagging in webadmin
- picture media player
- media transcoding plugin