Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Xtra

Pages: 1 [2]
16
Installation issues / Re: Installed Beta2, have diskless MD after some trouble but now no Media Scenarios
« on: December 17, 2009, 01:49:29 am »
So, now I did manually:
Code: [Select]
ALTER TABLE CommandGroup ADD COLUMN FK_Text INT(11);
And now the binary crashes without any message but the first room is at least now correct. I can see all the Scenarios in the web admin.
Sadly it still crashes on the Query: "select * from Room where `PK_Room`=3".

When I issue it by hand in the mysql command line client, I see that zero rows match.
So there might be some problem handling empty result sets in this file.

I'll keep on digging.

EDIT/ADD:
I just found out why the Query returns zero rows. That is simply because I deleted that room. My Rooms have the IDs 1,2,4,5 and 3 is deleted.
So I simply added the missing entry back in with the following statement:
Code: [Select]
INSERT INTO Room (PK_Room,FK_Installation,FK_RoomType,Description,psc_mod) VALUES (3,111726,2,"Closet",NOW());

After that I fired for a last time:
Code: [Select]
/usr/pluto/bin/UpdateEntArea -h localhost -u root -D pluto_main

And guess what? It ran through smoothly without error.

So there is definatly a bug in UpdateEntArea for non existing rooms (or rooms that do not exist anymore).
I was not able to locate the exact position in source where this happens but I hope the information in this Thread will help you devs to figure it out.

Regards
Chris

17
Installation issues / Re: Installed Beta2, have diskless MD after some trouble but now no Media Scenarios
« on: December 17, 2009, 01:36:04 am »
Thanks for your replies.

1. All my MDs are added to rooms.
2. I finished the AV Wizard. I just killed the part that alters the xorg.conf and that only on one MD (not the core, that one ran smoothly), therefore my systems should be setup correctly.

But I found out the source of my problems.
By searching via google I ended up that /usr/pluto/bin/UpdateEntArea is responsible for creating those devices.
So I jumped to the command line and fired it up:
Code: [Select]
root@dcerouter:/usr/pluto/bin# ./UpdateEntArea -h localhost -u root -D pluto_main
Cannot perform query: [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, "TV", "Office", 0, 0, 0, NULL, NULL, 33, NULL, 11, "2009-12-17 01:17:48", 0, 32, 1, NULL, NULL, NULL, NULL, 0, NULL)] Unknown column 'FK_Text' in 'field list'
Cannot perform query: [insert into CommandGroup_EntertainArea (`FK_CommandGroup`, `FK_EntertainArea`, `Sort`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 2, 1, NULL, NULL, NULL, 0, NULL)] Duplicate entry '0-2' for key 1
Cannot perform query: [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, "TV", "Office", 0, 0, 0, NULL, NULL, 33, NULL, 11, "2009-12-17 01:17:48", 0, 32, 1, NULL, NULL, NULL, NULL, 0, NULL)] Unknown column 'FK_Text' in 'field list'
Cannot perform query: [insert into CommandGroup_EntertainArea (`FK_CommandGroup`, `FK_EntertainArea`, `Sort`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 2, 1, NULL, NULL, NULL, 0, NULL)] Duplicate entry '0-2' for key 1
Cannot perform query: [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, "TV", "Office", 0, 0, 0, NULL, NULL, 33, NULL, 11, "2009-12-17 01:17:48", 0, 32, 1, NULL, NULL, NULL, NULL, 0, NULL)] Unknown column 'FK_Text' in 'field list'
Cannot perform query: [insert into CommandGroup_EntertainArea (`FK_CommandGroup`, `FK_EntertainArea`, `Sort`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 2, 1, NULL, NULL, NULL, 0, NULL)] Duplicate entry '0-2' for key 1
Cannot perform query: [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, "TV", "Office", 0, 0, 0, NULL, NULL, 33, NULL, 11, "2009-12-17 01:17:48", 0, 32, 1, NULL, NULL, NULL, NULL, 0, NULL)] Unknown column 'FK_Text' in 'field list'
Cannot perform query: [insert into CommandGroup_EntertainArea (`FK_CommandGroup`, `FK_EntertainArea`, `Sort`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 2, 1, NULL, NULL, NULL, 0, NULL)] Duplicate entry '0-2' for key 1
Cannot perform query: [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, "TV", "Office", 0, 0, 0, NULL, NULL, 33, NULL, 11, "2009-12-17 01:17:48", 0, 32, 1, NULL, NULL, NULL, NULL, 0, NULL)] Unknown column 'FK_Text' in 'field list'
Cannot perform query: [insert into CommandGroup_EntertainArea (`FK_CommandGroup`, `FK_EntertainArea`, `Sort`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 2, 1, NULL, NULL, NULL, 0, NULL)] Duplicate entry '0-2' for key 1
Cannot perform query: [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, "TV", "Office", 0, 0, 0, NULL, NULL, 33, NULL, 11, "2009-12-17 01:17:48", 0, 32, 1, NULL, NULL, NULL, NULL, 0, NULL)] Unknown column 'FK_Text' in 'field list'
Cannot perform query: [insert into CommandGroup_EntertainArea (`FK_CommandGroup`, `FK_EntertainArea`, `Sort`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 2, 1, NULL, NULL, NULL, 0, NULL)] Duplicate entry '0-2' for key 1
Cannot perform query: [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, "TV", "Office", 0, 0, 0, NULL, NULL, 33, NULL, 11, "2009-12-17 01:17:48", 0, 32, 1, NULL, NULL, NULL, NULL, 0, NULL)] Unknown column 'FK_Text' in 'field list'
Cannot perform query: [insert into CommandGroup_Command_CommandParameter (`FK_CommandGroup_Command`, `FK_CommandParameter`, `IK_CommandParameter`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (46, 29, "4", NULL, NULL, NULL, 0, NULL)] Duplicate entry '46-29' for key 1
Cannot perform query: [insert into CommandGroup_EntertainArea (`FK_CommandGroup`, `FK_EntertainArea`, `Sort`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 2, 1, NULL, NULL, NULL, 0, NULL)] Duplicate entry '0-2' for key 1
Cannot perform query: [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, "TV", "Office", 0, 0, 0, NULL, NULL, 33, NULL, 11, "2009-12-17 01:17:48", 0, 32, 1, NULL, NULL, NULL, NULL, 0, NULL)] Unknown column 'FK_Text' in 'field list'
Cannot perform query: [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, "TV", "Office", 0, 0, 0, NULL, NULL, 33, NULL, 11, "2009-12-17 01:17:48", 0, 32, 1, NULL, NULL, NULL, NULL, 0, NULL)] Unknown column 'FK_Text' in 'field list'
Cannot perform query: [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, "TV", "Office", 0, 0, 0, NULL, NULL, 33, NULL, 11, "2009-12-17 01:17:48", 0, 32, 1, NULL, NULL, NULL, NULL, 0, NULL)] Unknown column 'FK_Text' in 'field list'
Cannot perform query: [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, "TV", "Office", 0, 0, 0, NULL, NULL, 33, NULL, 11, "2009-12-17 01:17:48", 0, 32, 1, NULL, NULL, NULL, NULL, 0, NULL)] Unknown column 'FK_Text' in 'field list'
Cannot perform query: [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, "TV", "Office", 0, 0, 0, NULL, NULL, 33, NULL, 11, "2009-12-17 01:17:48", 0, 32, 1, NULL, NULL, NULL, NULL, 0, NULL)] Unknown column 'FK_Text' in 'field list'
Cannot perform query: [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, "TV", "Office", 0, 0, 0, NULL, NULL, 33, NULL, 11, "2009-12-17 01:17:48", 0, 32, 1, NULL, NULL, NULL, NULL, 0, NULL)] Unknown column 'FK_Text' in 'field list'
Segmentation fault (core dumped)
So, the first entries are added and then it misses a column "FK_Text".
Eventually it crashes with an segmentation fault.

A strace session provides me with:
Code: [Select]
[...]
write(3, "01\t12/17/09 1:33:11.087\t\t\33[31;1mTable_CommandGroup::Commit Cannot perform query [insert into CommandGroup (`PK_CommandGroup`, `FK_Array`, `FK_Installation`, `Description`, `Hint`, `CanTurnOff`, `AlwaysShow`, `CanBeHidden`, `FK_Criteria_Orbiter`, `FK_DesignObj`, `FK_Template`, `AltID`, `FK_Icon`, `AutoGeneratedDate`, `Disabled`, `TemplateParm1`, `TemplateParm2`, `FK_Text`, `psc_id`, `psc_batch`, `psc_user`, `psc_frozen`, `psc_restrict`) values (0, 5, 111726, \"TV\", \"B\303\274ro\", 0, 0, 0, NULL, NULL, 33, NULL, 11, "..., 661) = 661
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0
write(4, ":\0\0\0\3UPDATE CommandGroup set psc_mod=0 WHERE PK_CommandGroup=0", 62) = 62
read(4, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 0  Changed: 0  Warnings: 0", 16384) = 52
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0
write(4, "B\0\0\0\3UPDATE CommandGroup_Command set psc_mod=0 WHERE FK_CommandGroup=0", 70) = 70
read(4, "0\0\0\1\0\0\0\"\0\0\0(Rows matched: 1  Changed: 0  Warnings: 0", 16384) = 52
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0
write(4, "\306\0\0\0\3UPDATE CommandGroup_Command_CommandParameter JOIN CommandGroup_Command ON FK_CommandGroup_Command=PK_CommandGroup_Command set CommandGroup_Command_CommandParameter.psc_mod=0 WHERE FK_CommandGroup=0", 202) = 202
read(4, "0\0\0\1\0\0\0\"\0\0\0(Rows matched: 1  Changed: 0  Warnings: 0", 16384) = 52
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0
write(4, "?\0\0\0\3UPDATE CommandGroup_Room set psc_mod=0 WHERE FK_CommandGroup=0", 67) = 67
read(4, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 0  Changed: 0  Warnings: 0", 16384) = 52
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0
write(4, "H\0\0\0\3UPDATE CommandGroup_EntertainArea set psc_mod=0 WHERE FK_CommandGroup=0", 76) = 76
read(4, "0\0\0\1\0\0\0\2\0\0\0(Rows matched: 2  Changed: 0  Warnings: 0", 16384) = 52
poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0
write(4, "%\0\0\0\3select * from Room where `PK_Room`=3", 41) = 41
read(4, "\1\0\0\1\0176\0\0\2\3def\npluto_main\4Room\4Room\7PK_Room\7PK_Room\f?\0\v\0\0\0\3\3B\0\0\0F\0\0\3\3def\npluto_main\4Room\4Room\17FK_Installation\17FK_Installation\f?\0\v\0\0\0\3\1\0\0\0\0>\0\0\4\3def\npluto_main\4Room\4Room\vFK_RoomType\vFK_RoomType\f?\0\v\0\0\0\3\0\0\0\0\0>\0\0\5\3def\npluto_main\4Room\4Room\vDescription\vDescription\f!\0Z\0\0\0\375\0\0\0\0\0006\0\0\6\3def\npluto_main\4Room\4Room\7FK_Icon\7FK_Icon\f?\0\v\0\0\0\3\0\0\0\0\0N\0\0\7\3def\npluto_main\4Room\4Room\23ManuallyConfigureEA\23ManuallyConfigureEA\f?\0\1\0\0\0\1\0\0\0\0\0F\0\0\10\3def\npluto_main\4Room\4Room\17HideFromOrbiter\17HideFromOrbiter\f?\0\1\0\0\0\1\1\0\0\0\0T\0\0\t\3def\npluto_main\4Room\4Room"..., 16384) = 1027
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
+++ killed by SIGSEGV (core dumped) +++
So we appear to be crashing when reading the result from the Query: "select * from Room where `PK_Room`=3"

I am wondering how to tackle that one now.

Regards
Chris

18
Installation issues / Re: LinuxMCE 8.10: Installing a new PXE MD screwed up the CORE+Hybrid server -Big Pb
« on: December 16, 2009, 09:35:11 am »
The apache error makes me wonder if you maybe have accidentally lost your IP Address.
What does ifconfig show?
What error do you get in the LMCE Launch Manager?

19
Installation issues / [SOLVED] Installed Beta2, but now no Autogenerated Media Scenarios
« on: December 16, 2009, 08:32:36 am »
Hi there,
first off, congrats to the Beta2 looks very promising so far.
As the subject already told you, I have set up my core and successfully added a diskless MD (which crashed in the AVWizard as soon as I selected the TV out but I got around this after manually hacking the autodetection and switching of the video mode out of the av wizard script and configuring my xorg.conf by hand).
So far everything is as it should be aside from the fact that my Media Scenario list in the Orbiters is entirely empty except for the "Floorplan" option.
When I have a look at the web admin, I see that all default scenarios are missing in there aswell. It simply states "N/A" there.
So, here are my questions:
How can it happen that they are not autogenerated?
How can I manually "auto-generate" them or, what are the SQL values I have to hack into my DB to get them into my installation?

If anyone could give me a hint on those questions, even the slightest hint like suggestion of some shellscript files where I can dig up information myself should do as I am currently really lost here.

Regards
Chris

Pages: 1 [2]