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 - jamo

Pages: 1 2 [3] 4 5 ... 31
31
Users / Re: Following upgrade, media on MD starts at maximum volume
« on: December 09, 2013, 07:47:58 am »
Awesome... thanks for this l3 and phenigma. Can't wait to try out 12.04 as well.

32
Users / Re: problems with medibuntu?
« on: November 12, 2013, 08:15:49 pm »
Did you guys come right with this?

I saw I had a few packages to update so I did an apt-get update and also got the medibuntu errors. Is it safe to carry on with the upgrade?
Code: [Select]
W: Failed to fetch http://packages.medibuntu.org/dists/lucid/Release.gpg  Something wicked happened resolving 'packages.medibuntu.org:http' (-5 - No address associated with hostname)

W: Failed to fetch http://packages.medibuntu.org/dists/lucid/free/i18n/Translation-en_ZA.bz2  Something wicked happened resolving 'packages.medibuntu.org:http' (-5 - No address associated with hostname)

W: Failed to fetch http://packages.medibuntu.org/dists/lucid/non-free/i18n/Translation-en_ZA.bz2  Something wicked happened resolving 'packages.medibuntu.org:http' (-5 - No address associated with hostname)

W: Failed to fetch http://packages.medibuntu.org/dists/lucid/free/binary-i386/Packages.gz  Something wicked happened resolving 'packages.medibuntu.org:http' (-5 - No address associated with hostname)

W: Failed to fetch http://packages.medibuntu.org/dists/lucid/non-free/binary-i386/Packages.gz  Something wicked happened resolving 'packages.medibuntu.org:http' (-5 - No address associated with hostname)

E: Some index files failed to download, they have been ignored, or old ones used instead.

33
Users / Re: HDPVR 1212 Settop box capture and streaming
« on: October 30, 2013, 02:45:53 pm »
Stash

It's a USB connection.

34
Users / Re: video issues with mce
« on: October 17, 2013, 08:05:35 am »
unfortunately re-running the av-wizard has not allowed me to switch from vga to pick up my hdmi cable.  i know it works on my tv because i originally installed it using my tv but a friend advised me to re-install with a pc monitor because of resolution issues so i did and now i cant switch back to tv.  if i boot with tv hooked up i see the pc start and then a bunch of lines of txt then nothing even after trying the 12345 and qwert options.  i do not have any orbiters set up yet.  im in process of getting one going on my android but i am unsecessful as of yet.  my phone just keeps trying to connect to the default ip which is correct but wont connect.

Hi... just to get clarity - you say if you boot with tv hooked up... By that, you mean you power on your MD after plugging in your TV? The same MD that currently works with a pc monitor? Are you sure you are re-running Avwizard? It won't happen by default on boot... it only happens if you use one of the methods outlined by the others - "RebootWithAVWizard.sh" or the "Video Wizard" from another orbiter or something like that. Can you confirm this *is* the method of reboot you're using?

What is the last of the "lines of text" you see. Also try pressing the "Esc" key when the text has stopped scrolling. That shows detail on what the system is trying to do on boot up which could help us figure out what's going wrong.

It's very surprising that AVWizard is not running fine if it's run before and you've seen it on the TV. Very odd!

If we've tried everything else, you can always rebuild the MD image from the web admin and start again.... but that should be last resort.

35
Users / Re: CEC - Anyone (for Denon AVR 1909)
« on: October 04, 2013, 09:52:09 am »
Awesome. "CEC-enabled GPU" how sweet those words are to my ears.

We used to use Pulse-8's but now we just use Rpi's as they have a CEC enabled GPU. So if we just need CEC control we use a Rpi to do power ON from stand-by on say a SmartTV or on older TV's with no UPnP we use a Rpi with to also provide UPnP capability as well. We have an in-house developed customised Raspbmc image that we use for both these situations.

All the best

Andrew

36
Users / Re: CEC - Anyone (for Denon AVR 1909)
« on: October 03, 2013, 08:44:18 am »
Thanks Andrew, that's good news and interesting info. Are you using the pulse 8 CEC injector to CEC-enable your Rpi's and other devices?

Re CEC Control;

We use CEC in most installs now as pretty much all AV Amplifiers, Blu-Ray players & TV's are CEC enabled. Typically in a 'traditional' CEC installation you will have a chain of devices connected together via HDMI 1.3/1.4. The TV will be the master device at one end of the HDMI chain. All devices in the chain can be controlled from lib-CEC or from the master devices remote. So for example if you hook up a Rpi running Raspbmc to your TV and enable the CEC setting in your TV to 'On' then you can use the TV's remote control to control the XBMC UI running on the Rpi (it feels like magic the first time you see this working!).

All the best

Andy

37
Bushtech had a bit of a problem yesterday which we seem to have resolved with a bit of hacking. Thought I'd post the details here in case it helps anyone else or... if anyone can shed light on why it occurred.

Firstly, due to him running out of space on his root file system, his core froze and after a lot of messing about, he decided to re-install.

He did a clean install from iso image. First reboot brought black screen with cursor hanging (I think) at which point he dropped into command line and did an apt-get update; apt-get upgrade; reboot.
This time it came up with "Failed to start X". messages seemed to indicate that the correct nvidia drivers and alsa backports had been successfully installed.

We tried a lot of stuff- many deletes of xorg.conf and reboots with no luck. In the end, we tried a direct "startx" from the command line. This produced the following:
Code: [Select]
creating new authority file /root/.Xauthority
X.Org X Server 1.7.6
Release Date: 2010-03-17
X Protocol Version 11, Revision 0
Build Operating System: Linux 2.6.42-37-generic i686 Ubuntu
Current Operating System: Linux dcerouter 2.6.32-45-generic #104-Ubuntu SMP Tue Feb 19 21:21:41 UTC 2013 i686
Kernel command line: BOOT_IMAGE=/boot/vmlinuz-2.6.32-45-generic root=UUID=6f5b3d7b-8d58-421b-9580-c6fc8418acbf ro vmalloc=256m quiet uvesafb mode_option=1024x768-24 mtrr=3 scroll=ywrap
Build Date: 11 April 2013  01:18:49PM
xorg-server 2:1.7.6-2ubuntu7.12 (For technical support please see http://www.ubuntu.com/support)
Current version of pixman: 0.16.4
Markers: (--) probed, (**) from config file, (==) default setting,
(==) Using config file: "/etc/X11/xorg.conf" (==) Log file: "/var/log/Xorg.0.log", Time: Wed Oct  2 Using config directory: "/usr/lib/X11/xorg.conf.d" 14:58:18 2013
(EE) XKB: Couldn't open rules file /usr/share/X11/xkb/rules/evdev
XKB: Failed to compile keymap
Keyboard initialization failed. This could be a missing or incorrect setup of xkeyboard-config.
Fatal server error:
Failed to activate core devices.
giving up.
xinit:  No such file or directory (errno 2):  unable to connect to X server
xinit:  No such process (errno 3):  Server error.

We focussed on the critical error - couldn't open rules file /usr/share/X11/kxb/rules/evdev. Confirmed that the folder(s) file(s) didn't exist at all and managed to track down the package that provides them- xkb-data. Package was already installed but folders/files not there so we did a

Code: [Select]
apt-get install --reinstall xkb-data
After which the folders were created, startx worked and took him to kde... a reboot brought up avwiz with badly sized but usable screen.

Not sure what happened but hope this helps someone else who hits the same issue or is trying to figure out the problems.

bushtech - can you post your nvidia card details?

ta.

38
Developers / Re: Improving Performance of Play All
« on: October 02, 2013, 08:29:09 am »
So you're saying that we run a "big" query to get all the files from the datagrid and then we *requery* the database for each one to populate the members of the MediaFile object? Is that right? And you're suggesting that if we pick up the relevant data at the time of the "big" query and just push it straight into the members without having to requery each one....

I saw the constructor of MediaFile in MediaFile.h but where is the actual code for the constructor?

39
Developers / Re: Improving Performance of Play All
« on: October 01, 2013, 08:27:43 am »
Possibly. you would need to look at the media browser code in Media Plugin Grids, to see how the query is constructed. Take a look at the code and let me know your thoughts.

At least with my current approach, we can see an order of magnitude difference, and I already know how to implement it.

-Thom

Hi Thom... if the query works, go for it!

40
Developers / Re: Improving Performance of Play All
« on: September 30, 2013, 11:47:08 am »
Thom...  just a thought, apologies if you've been down this route already...

Should we not go back a level above this? What I'm thinking is that we look at the process that populated the datagrid in the first place. Presumably there is a sql query that is used to return the list that is currently in the DG. If we can dive in there and record that sql query (possibly as a property of the DG object) then when the user hits "Play All" we pull the query and possibly combine it to form a query that returns distinct entries from the "File" table. Then we loop through those rows to populate the playlist queue.

41
Users / Re: Huge query in pluto_media : taking my disk down to crawling
« on: September 30, 2013, 08:19:59 am »
Bushtek...

there should be no space betweekn "PK" and "_Attribute". I think copying and pasting has introduced an error. It should read "ON PK_Attribute=FK_Attribute" or something like that.

phenigma:

Ran jamo's query from your last post:

But I get this error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that       corresponds to your MySQL server version for the right syntax to use near 'ON PK      _Attribute=FK_Attribute WHERE FK_File=PK_File),
(select (IFNULL(MAX(LongAtt' at line 22


42
Users / Re: Huge query in pluto_media : taking my disk down to crawling
« on: September 21, 2013, 09:41:37 pm »
explain on my side
Code: [Select]
+----+-------------+----------------+--------+--------------------+---------+---------+-----------------------------------------+------+-------------+
| id | select_type | table          | type   | possible_keys      | key     | key_len | ref                                     | rows | Extra       |
+----+-------------+----------------+--------+--------------------+---------+---------+-----------------------------------------+------+-------------+
|  1 | PRIMARY     | <derived2>     | ALL    | NULL               | NULL    | NULL    | NULL                                    | 3017 |             |
|  1 | PRIMARY     | File           | eq_ref | PRIMARY,FatGroupBy | PRIMARY | 4       | s.PK_File                               |    1 |             |
|  2 | DERIVED     | File           | index  | Path,Filename      | PRIMARY | 4       | NULL                                    | 3231 | Using where |
|  2 | DERIVED     | Bookmark       | ref    | FK_File            | FK_File | 5       | pluto_media.File.PK_File                |    1 |             |
|  2 | DERIVED     | File_Attribute | ref    | PRIMARY,FK_File    | FK_File | 4       | pluto_media.File.PK_File                |    2 | Using index |
|  2 | DERIVED     | Attribute      | eq_ref | PRIMARY            | PRIMARY | 4       | pluto_media.File_Attribute.FK_Attribute |    1 |             |
|  2 | DERIVED     | LongAttribute  | ref    | FK_File            | FK_File | 5       | pluto_media.File.PK_File                |    1 |             |
|  2 | DERIVED     | Picture_File   | ref    | FK_File            | FK_File | 4       | pluto_media.File.PK_File                |    1 |             |
+----+-------------+----------------+--------+--------------------+---------+---------+-----------------------------------------+------+-------------+
8 rows in set (0.10 sec)

43
Users / Re: Huge query in pluto_media : taking my disk down to crawling
« on: September 21, 2013, 09:22:11 pm »
Thom

Did some research on that explain plan you posted and I think the problem was the group-by clause that groups by a bunch of dependent fields that aren't indexed. If we group on the PK of File and then join back to file to get the fields we need it seems to take care of that. In fact, it improves my query by quite a dramatic amount. Does anyone else want to try this?

Code: [Select]
SELECT File.PK_File, File.Path, File.Filename, File.Inode,
  s.CurrentDbAttrDate, s.CurrentDbAttrCount, s.HasAttributes,
  File.AttrDate AS OldDbAttrDate, File.AttrCount AS OldDbAttrCount,
  File.ModificationDate AS OldFileDate, File.Source
FROM
(SELECT PK_File,
  greatest(
    IF(Bookmark.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), Bookmark.psc_mod),
    IF(Attribute.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), Attribute.psc_mod),
    IF(LongAttribute.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), LongAttribute.psc_mod),
    IF(Picture_File.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), Picture_File.psc_mod),
    CAST('0000-00-00 00:00:00' AS DATE)
  ) As CurrentDbAttrDate,
  (1000000 * COUNT(Bookmark.PK_Bookmark) + 10000 * COUNT(Attribute.PK_Attribute) +
   100 * COUNT(LongAttribute.PK_LongAttribute) + COUNT(Picture_File.FK_Picture))
  AS CurrentDbAttrCount,
  COUNT(Attribute.PK_Attribute)+COUNT(LongAttribute.PK_LongAttribute) AS HasAttributes
FROM
File
LEFT JOIN Bookmark ON Bookmark.FK_File = PK_File
LEFT JOIN File_Attribute ON File_Attribute.FK_File = PK_File
LEFT JOIN Attribute ON File_Attribute.FK_Attribute = PK_Attribute
LEFT JOIN LongAttribute ON LongAttribute.FK_File = PK_File
LEFT JOIN Picture_File ON Picture_File.FK_File = PK_File
  WHERE 1 = 1 AND (Path LIKE '/home/public/data%' OR (Path = '/home/public' AND Filename = 'data' )  OR Path LIKE '/home/user_1/data%' OR (Path = '/home/user_1' AND Filename = 'data' )  OR Path LIKE '/home/user_2/data%' OR (Path = '/home/user_2' AND Filename = 'data' )  OR Path LIKE '/home/user_3/data%' OR (Path = '/home/user_3' AND Filename = 'data' )  OR Path LIKE '/home/user_4/data%' OR (Path = '/home/user_4' AND Filename = 'data' )  OR Path LIKE '/home/user_5/data%' OR (Path = '/home/user_5' AND Filename = 'data' )  OR Path LIKE '/home/user_6/data%' OR (Path = '/home/user_6' AND Filename = 'data' )  OR Path LIKE '/home/user_7/data%' OR (Path = '/home/user_7' AND Filename = 'data' )  OR Path LIKE '/home/user_8/data%' OR (Path = '/home/user_8' AND Filename = 'data' )  )  AND Missing = 0
GROUP BY PK_File) s
inner join File on s.PK_File=File.PK_File;

44
Users / Re: Huge query in pluto_media : taking my disk down to crawling
« on: September 21, 2013, 09:19:41 pm »
Code: [Select]
mysql> select count(*) from Picture_File;
+----------+
| count(*) |
+----------+
|      154 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from File;
+----------+
| count(*) |
+----------+
|     4333 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from File_Attribute;
+----------+
| count(*) |
+----------+
|    11794 |
+----------+
1 row in set (0.01 sec)

mysql> select count(*) from LongAttribute;
+----------+
| count(*) |
+----------+
|       22 |
+----------+
1 row in set (0.00 sec)

Yes, you have a lot more media than I do (and more pictures!)

45
Users / Re: Huge query in pluto_media : taking my disk down to crawling
« on: September 21, 2013, 02:22:00 pm »
Hmmm... don't have time to check if the data is exactly the same but it is certainly the same number of rows and results in about a 25% speed improvement for me... perhaps someone else can try the following query rewrite to compare with the original:
Code: [Select]
SELECT PK_File, Path, Filename, INode,
  greatest(
    IF(Bookmark.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), Bookmark.psc_mod),
    IF(Attribute.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), Attribute.psc_mod),
    IF(LongAttribute.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), LongAttribute.psc_mod),
    IF(Picture_File.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), Picture_File.psc_mod),
    CAST('0000-00-00 00:00:00' AS DATE)
  ) As CurrentDbAttrDate,
  (1000000 * COUNT(Bookmark.PK_Bookmark) + 10000 * COUNT(Attribute.PK_Attribute) +
   100 * COUNT(LongAttribute.PK_LongAttribute) + COUNT(Picture_File.FK_Picture))
  AS CurrentDbAttrCount,
  COUNT(Attribute.PK_Attribute)+COUNT(LongAttribute.PK_LongAttribute) AS HasAttributes,
  AttrDate AS OldDbAttrDate, AttrCount AS OldDbAttrCount, ModificationDate AS OldFileDate,
  Source
FROM
File
LEFT JOIN Bookmark ON Bookmark.FK_File = PK_File
LEFT JOIN File_Attribute ON File_Attribute.FK_File = PK_File
LEFT JOIN Attribute ON File_Attribute.FK_Attribute = PK_Attribute
LEFT JOIN LongAttribute ON LongAttribute.FK_File = PK_File
LEFT JOIN Picture_File ON Picture_File.FK_File = PK_File
  WHERE 1 = 1 AND (Path LIKE '/home/public/data%' OR (Path = '/home/public' AND Filename = 'data' )  OR Path LIKE '/home/user_1/data%' OR (Path = '/home/user_1' AND Filename = 'data' )  OR Path LIKE '/home/user_2/data%' OR (Path = '/home/user_2' AND Filename = 'data' )  OR Path LIKE '/home/user_3/data%' OR (Path = '/home/user_3' AND Filename = 'data' )  OR Path LIKE '/home/user_4/data%' OR (Path = '/home/user_4' AND Filename = 'data' )  OR Path LIKE '/home/user_5/data%' OR (Path = '/home/user_5' AND Filename = 'data' )  OR Path LIKE '/home/user_6/data%' OR (Path = '/home/user_6' AND Filename = 'data' )  OR Path LIKE '/home/user_7/data%' OR (Path = '/home/user_7' AND Filename = 'data' )  OR Path LIKE '/home/user_8/data%' OR (Path = '/home/user_8' AND Filename = 'data' )  )  AND Missing = 0
GROUP BY PK_File, Path, Filename, INode, AttrDate, AttrCount, ModificationDate;

Pages: 1 2 [3] 4 5 ... 31