[SlimDevices: Beta] 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... :( frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
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 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
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. Paul Webster http://dabdig.blogspot.com Author Radio France (FIP etc) plugin Paul Webster's Profile: http://forums.slimdevices.com/member.php?userid=105 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
mherger wrote: > > 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... frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
frank1969 wrote: > > or (second best) having the "library.db" on my (web)server and browse > them with some sqlite-android-app... You could try 'this app' (https://www.nexus0.net/pub/sw/lmslib2go/) Before that, I used this 'database app' (https://play.google.com/store/apps/details?id=com.portofarina.portodb) to browse/search my collection info on my phone. SW: 'Web UI for LMS' (http://forums.slimdevices.com/showthread.php?98186-Announce-Alternative-Web-Interface-(beta)) | 'Playlist Editor / Generator' (http://forums.slimdevices.com/showthread.php?108199-Announce-LMS-Playlist-Editor) | 'Music Classification' (http://forums.slimdevices.com/showthread.php?108278-Announce-Essentia-Integration-music-classification-(moods-genres-)) | 'Similar Music' (http://forums.slimdevices.com/showthread.php?108495-Announce-LMSmusly-play-similar-music) | 'LMSlib2go' (https://www.nexus0.net/pub/sw/lmslib2go/) HowTos: 'build a self-contained LMS' (http://forums.slimdevices.com/showthread.php?99648-Howto-build-a-self-contained-LMS) | 'Ogg Opus' (http://forums.slimdevices.com/showthread.php?107011-Howto-play-Ogg-Opus-files) | 'Bluetooth/ALSA' (http://forums.slimdevices.com/showthread.php?107230-Howto-Bluetooth-streaming-to-from-LMS-(ALSA-only-no-PulseAudio)) Roland0's Profile: http://forums.slimdevices.com/member.php?userid=56808 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
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 JerryS's Profile: http://forums.slimdevices.com/member.php?userid=38998 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
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- -- Hardware: 3x Touch, 1x Radio, 2x Receivers, 1 HP Microserver NAS with Debian+LMS 7.9.0 Music: ~1300 CDs, as 450 GB of 16/44k FLACs. No less than 3x 24/44k albums.. drmatt's Profile: http://forums.slimdevices.com/member.php?userid=59498 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
JerryS wrote: > 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). JerryS wrote: > 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...) frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
frank1969 wrote: > 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 JerryS's Profile: http://forums.slimdevices.com/member.php?userid=38998 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
frank1969 wrote: > 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! atrocity's Profile: http://forums.slimdevices.com/member.php?userid=16009 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
atrocity wrote: > 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... frank1969's Profile: http://forums.slimdevices.com/member.php?userid=31156 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta
Re: [SlimDevices: Beta] Running LMS on web server
frank1969 wrote: > 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. atrocity's Profile: http://forums.slimdevices.com/member.php?userid=16009 View this thread: http://forums.slimdevices.com/showthread.php?t=110679 ___ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta