Posts by LybsterKodi

I have the same issue, sort of solved by using FileZilla to transfer from RPi to PC - it switches : to _

My format string is $t$-c%F%R$-e$n.$x

I should be buying a new machine to run LE/Kodi soon. Up to now I've been running TVHeadend on RPi3. I'm having a look at NextPVR. The configuration certainly seems easier than TVHeadend. I'm just interested in how others percieve the pros and cons of the two systems.

If you boot from a MicroSD card and have a look in Settings|LibreElec is your firmware up to date?

I used balenaEtcher on Windows to write the image to an SSD and my RPi4 booted from it without problems.

Thanks - I'll get one on order

heitbaum

Just to double check - if I buy a Pulse8 USB - CEC Adapter I can hook it onto any PC and it will work? Or are there more gotchas? I have an old HP Compaq 8510W I can use to try things out on before committing to a better spec SFF PC.

I'm reading the Amazon reviews and I found this

Needs separate power USB connection to work

in a 1 star review and it baffles me. I know I need to plug it into a USB port but "separate power"?

<< If it took two remote controls to switch off a light v walking across the room to press a switch the WAF was low>>

Thank you for that it made me smile.

Thanks - this is reminding me of IBM 4341 mainframe assembler - that made my head hurt as well.

Thanks for that link, it rather demonstrates the lack of any useful technical information

I'm guessing you're more hardware oriented than I am (lots of years writing applications, especially database/business) and you've pointed out a weakness in the RPi ie <<On the RPI4 you have four USB ports sharing one PCIe lane >> does this also apply to the Rock machines?

I realise this is in reference to my wife but what does WAF stand for?

One brilliant way is, as I have done when wanting to test an application I've written, get a hex editor and simply alter what's stored on the disk. Great fun if you want to deliberately damage a table.

Badly written software can do it and in part it depends on how the database engine responds to say 25 characters being written to a field that is only big enough for 10, or it can write a character to a field that the engine can't handle. If running over a network a junk character can be introduced by a glitch on the network. Software writing directly to disk when it should go through the engine and overwriting some valid data. Poor transaction handling so that two lots of data are being written simultaneously and some gets in the wrong place on disk. Memory corruption which is subsequently written to disk.

Over the years I've had pretty much all of them.

What might be going on here I don't know. SQLite isn't one I'm overly familiar with (I can use SQL on it but that's because I now SQL) and I'm not familiar with the LE code base (translation I've never even looked at it).

Can one of the developers enlighten me on how the copying from MyVideos120.db to MyVideos121.db is done. If as I'm guessing its read a record, write a record then the table metadata is probably getting screwed, if its a straight copy I'm baffled.

petediscrete

First, thank you for trying to help. However, as you can guess I'm not going to opt for a sat>IP tuner and I really don't care about 4KUHD (at 72 I've seen enough overhyping, but to be fair moving from SD to HD in the US was a big deal, not so much in the UK, and please do not get me started on about PC screens that need to be at 200% to have readable text).

I'll have a look at the Rock machines and see if I can find any performance comparison.

heitbaum

Thanks for that - it explains the very limited command set table

At least I now have some idea where I'm going and the fact that I'll need to add £40 to my budget for the Pulse8 USB adapter

Out of interest is there any usable documentation regarding CEC out there - if there is I was searching for the wrong terms.

petediscrete

Different setup - I want to reduce it to a single box so that its easier for my wife when things go wrong - back to the old IT standby switch it off, switch it on

<<. The difference with 4kUHD is very noticeable>>

I politely disagree with you.

Still looking for a way to say a box supports CEC if you know one.

<<Those DVB USB dongles are just a heart breaker.>>

With my twin RPi3 setup it works well, it works fine on the RPi4 as long as I only record one programme

<<On the RPI4 you have four USB ports sharing one PCIe lane >>

This is almost certainly the problem. For testing I had Hauppage dual tuner, 3TB powered HDD, wifi keyboard dongle, ethernet

<<and have no issues watching and recording up to 4kUHD>>

My antique eyes would, or at least can't see the difference so why bother <G>

I'm going by this information for the NUCs

HDMI CEC Information for Intel&reg; NUC

Information about the HDMI CEC header for Intel&reg; NUC products, including a description and pin numbers.

www.intel.com

and looking only at the onboard CEC section.

How good is the Pulse8 adapter I've found mixed views about it whilst driving myself insane about CEC.

Over many years I've found three main causes of database table corruption:

1. power going off whilst the database is being written to (could also be sudden loss of network connection)

2. badly formatted data being written

3. unacceptable characters

There's also hard drive sectors going duff.

No. 1 you'd probably notice

Nos. 2 & 3 are a bit more difficult but, as chewitt infers, could be being caused by a poorly written add-on but there's probably no way you can test No. 2

No. 3 you can check if you can download an SQlite browser but you need to be at least a bit of a techie. Have a look for "DB Browser for SQLite" on the web - its got an integrity check.

I've come to the conclusion that the RPi4 (running LibreELEC-RPi4.aarch64-12.0-nightly-20230520) will not do what I want - record 2 programmes using my Hauppage tuner whist watching a movie. I've tried several approaches (eg record to SD card, record to USB HDD, force_turbo=1) and I get varied effects (eg audio lost, freezing, video speed up, loss of sync between audio & video) so I've decided I need to buy a more powerful machine.

I've found the Intel page which tells me which NUCs support CEC but I can't find anything which tells me about other machines. Since other machines are generally at a lower price point than Intel I'd like to be able to consider them. Does anyone know a resource which I can use to see if a machine supports CEC before I buy it?

If your Kodi machine is on a LAN and you've enabled SAMBA you should be able to use samba from the Windows 7 pc to transfer files. I currently have 2 RPI3Bs (one for TVHeadend and the other for videos) running LE9.2.8 and I can access the 6TB NTFS HDD using samba and the portion of the microSD card that is EXT4 formatted (eg Recordings).

I'm in the process of moving to an RPi4 and did have a bit of trouble with samba on version 11 and had to use FileZilla which worked fine. My latest experiments with the v12 nightly also work fine with samba.

I have two RPI3Bs running LE9.2.8 and they're fine.

You don't say what you're trying to boot from MicroSD card or USB drive. If the former then it may simply be the SD card isn't seated properly. If the latter then, if my memory is right, the earlier firmware on the Pi doesn't support booting from USB drive. I seem to recall a patch somewhere on this site which tells you which of the config files to alter but my suggestion would be to get a cheapo small microSD card, burn LibreElec onto that and use it to boot from.

It may be possible, once you've booted the machine, to download the latest firmware which will allow booting from USB drive, no guarantees.

Thanks, I'll add that to my list of machines to look at