Re: [SlimDevices: Plugins] DatabaseQuery and bash scripting

2021-12-12 Thread tuxEvangelist
DONE :D This thread can be marked as solved. I was able to revert my crappy ssh changes via a Tech Support entry, from then on it really was not very difficult anymore. By now the database queries run inside the ssh session on the NAS writing the results on the share that is accessible by NFS.

Re: [SlimDevices: Plugins] DatabaseQuery and bash scripting

2021-12-06 Thread tuxEvangelist
mherger wrote: > > Oh, I actually wanted to ask about this: when I last tried to access my > > NAS in a browser, I wouldn't succeed. I didn't try FF, though. Here it is FF 91.2.0 which comes with an option to switch TLS1.0/1.1 back on, if needed > > I'm using the Pi to run LMS only. So the

Re: [SlimDevices: Plugins] DatabaseQuery and bash scripting

2021-12-06 Thread tuxEvangelist
And if you wanted to save some of your own time, too, I'd recommend you get a Raspberry Pi to run LMS on... I've been using a Duo v2 myself for many years. But LMS never was fun. Using pCP on a Pi3B was so much smoother and easier to deal with! That's really spot-on, because I'm starting to t

Re: [SlimDevices: Plugins] DatabaseQuery and bash scripting

2021-12-06 Thread tuxEvangelist
mherger wrote: > > Hmm... well, the LMS sits on a NAS box which is not accessible by > ssh. > > As I've learned recently SQLite has zero networking DB options unlike > > MySQL. > > What NAS would allow you to install LMS but not provide SSH access? Aah, that's the day of tight questions... Cau

Re: [SlimDevices: Plugins] DatabaseQuery and bash scripting

2021-12-06 Thread tuxEvangelist
mherger wrote: > > AND: Good question, I have an idea where you are pointing me to: > Avoid > > the overhead of the Database Query plugin completely and query > against > > the database directly via SQLite client, right? > > Exactly. Hmm... well, the LMS sits on a NAS box which is not accessib

Re: [SlimDevices: Plugins] DatabaseQuery and bash scripting

2021-12-06 Thread tuxEvangelist
mherger wrote: > > I wonder if there is a possibilty to use the queries I've built from > > outside the LMS UI via a bash script. > > Are the queries SQL? Yes sure. They're just wrapped inside the XML that is stored by the Database Query plugin, looks like that: Code:

Re: [SlimDevices: Plugins] DatabaseQuery and bash scripting

2021-12-05 Thread tuxEvangelist
tuxEvangelist wrote: > I'm a very happy user of the Database Query plugin, still clinging to > LMS 7.9, but everything works so perfectly ;) > > I wonder if there is a possibilty to use the queries I've built from > outside the LMS UI via a bash script. I've trie

[SlimDevices: Plugins] DatabaseQuery and bash scripting

2021-12-05 Thread tuxEvangelist
I'm a very happy user of the Database Query plugin, still clinging to LMS 7.9, but everything works so perfectly ;) I wonder if there is a possibilty to use the queries I've built from outside the LMS UI via a bash script. ---