Running LMS on web server

[frank1969]

> My server (ionos) has MySql support (Sqlite not sure).

What are you running on your server? PHP has sqlite support built in.

And without further knowledge of your application it's hard to tell how
to best do it. You aren't accessing MySQL directly from the road, I'd
assume? If you already had an application in place, automated migration
from SQLite to MySQL would probably be easiest. Or re-write the app to
use SQLite directly etc.

--

Michael

[frank1969]

Running LMS on web server

I'm looking for an easy way to run LMS on a web server / cloud server.
The idea is to have the database always with me, so I don't wanna hear music with it but "only" use the database to browse my library if I'm not at home, so I don't wanna do "imports" but preferably copy my local LMS-files/database to the server.
My server (ionos) has MySql support (Sqlite not sure).

Till now I had a (selfwritten) PHP-script for my MySql database , exported the sqlite from my local LMS installation (into *.csv) and re_imported it on my webserver. But this is pretty boring job so I look for an easier way to either
a) 'automatically' convert Sqlite into MySQL
b) run LMS "as is" on my webserver (copying the *.db files to the server)

Any ideas?
If You might see, I'm not very experienced in databases (except a little MySQL) so I just don't know how Sqlite works on a web server...

[Paul Webster]

I remember a Library-to-PDF module that someone produced ... not as flexible as having the database available but comes with the benfit of being able to browse or even search it when offline.

[frank1969]

> My server (ionos) has MySql support (Sqlite not sure).

What are you running on your server? PHP has sqlite support built in.

And without further knowledge of your application it's hard to tell how
to best do it. [...] Or re-write the app to
use SQLite directly etc.

Thanks for Your quick answer - and I propably expressed my idea to complicated, it is much more simple (I guess):
My "best" experience would be just to copy the "cache" directory onto my web server, maybe even the prorgram directory and the "server" directory, make a few modifications, start the index.html and ... done

or (second best) having the "library.db" on my (web)server and browse them with some sqlite-android-app...

[Roland0]

or (second best) having the "library.db" on my (web)server and browse them with some sqlite-android-app...

You could try this app
Before that, I used this database app to browse/search my collection info on my phone.

[JerryS]

I can't really get my head around why you are trying to do this so I am probably being thick. However, instead of converting SQlite to MYSQL, why not just set up LMS to use MYSQL instead of SQlite? That's what I do. Then no conversion will be necessary, you can use something like phpMyAdmin to export and import the db.

JerryS

[drmatt]

Or use a client VPN and either run a squeeze client on your phone or stick the upnp server plugin on Lms and use a upnp client to browse on your phone instead.


Transcoded from Matt's brain by Tapatalk

[frank1969]

I can't really get my head around why you are trying to do this

Well, the answer is simple: I am working in the music biz, have a 725k database/archive and I am very often abroad so I use my LMS-database when I have to find out if I have song xy by artist yz in my database and can use it for a show/program or even to see, on what album the song xy is/was available. So it would be great to have my LMS always with me (of course I could do an Excel-export but updating it and browsing an excel-sheet with 725k rows via smartphone and using filters isn't that comfortable).

instead of converting SQlite to MYSQL, why not just set up LMS to use MYSQL instead of SQlite? That's what I do.

OK, THANKS ! that's probably a good idea. I had in mind it wasn't recommended for huge databases to user MYSQL and it wasn't supported anymore. Could You give me a hint where I can find the option to change from Sqlite to Mysql (I remember there was an option about 2 or 3 years ago but I can't find it anymore...)

[JerryS]

Well, the answer is simple: I am working in the music biz, have a 725k database/archive and I am very often abroad so I use my LMS-database when I have to find out if I have song xy by artist yz in my database and can use it for a show/program or even to see, on what album the song xy is/was available. So it would be great to have my LMS always with me (of course I could do an Excel-export but updating it and browsing an excel-sheet with 725k rows via smartphone and using filters isn't that comfortable).



OK, THANKS ! that's probably a good idea. I had in mind it wasn't recommended for huge databases to user MYSQL and it wasn't supported anymore. Could You give me a hint where I can find the option to change from Sqlite to Mysql (I remember there was an option about 2 or 3 years ago but I can't find it anymore...)

Ah, got why your doing it.

There was a thread on this April 2018 in the Logitech Media Server Forum where I stated how I did this. Works for me though I think it fair to say that Michael was a bit dubious about it. Disclaimer, I am not an expert.

https://forums.slimdevices.com/showthread.php?108873-Pi3B-Pi3B-and-MYSQL

If you do a google search like site:forums.slimdevices.com MYSQL you should get a load of MYSQL stuff from these forums.

Regards

JerryS

[atrocity]

Well, the answer is simple: I am working in the music biz, have a 725k database/archive and I am very often abroad so I use my LMS-database when I have to find out if I have song xy by artist yz in my database

I use the VPN method drmatt suggested for this situation. I have OrangeSqueeze on my phone for home use but if I'm away I start up the VP, which lets OrangeSqueeze connect just as it would from home.

Being able to query my library remotely has definitely prevented me on multiple occasions from buying something I already own!

[frank1969]

I use the VPN method drmatt suggested for this situation. I have OrangeSqueeze on my phone for home use but if I'm away I start up the VP, which lets OrangeSqueeze connect just as it would from home.

Being able to query my library remotely has definitely prevented me on multiple occasions from buying something I already own!

Thanks for Your reply, but this means, You have Your server at home "always running"? I don't prefer this, if I'm not at home myself, server is "offline" for security reasons...

[atrocity]

Thanks for Your reply, but this means, You have Your server at home "always running"? I don't prefer this, if I'm not at home myself, server is "offline" for security reasons...

Yes, my server has to always be running in order for this to work.