I was now able to get the website (lighttpd) working so that RPi became useful. The next piece was to setup mysql database; install mysql-server now causes mariadb to be used rather than mysql. It turns out that the developer of mysql is maintaining mariadb whilst Oracle maintain mysql. Lastly I needed to install PHP which was troublesome. PHP has been updated to version 7 but after installing it lighttpd told me it was still using version 5.5. I followed some non-intuitive steps provided by some kind person to fix it.
Now I have a shiny new headless RPi server which will:
- Strip out the adverts and play internet radio stations (streamripper)
- Allow me to play my albums using my own web-based front-end (javascript, jquery, php)
- Let me use any of my bluetooth devices for listening
- Run a bit torrent client for downloads
- Allow file-sharing with Windows PCs (samba)
- look at my artwork database together with commentaries I have written (mysql, php)
- Share videos locally which can be played on TVs or other devices (minidlna)
The old system ran in read-only mode with all data held on usb sticks. The new installation hasn't got that far yet. Also I haven't re-added my network of temperature sensing arduinos communicating using LRF24N01+ 800MHz wireless devices.