I’ve just rebuilt emoncms on a Raspberry Pi v3 using the current standard operating system - Raspbian Stretch, and taken the opportunity to update many of the modules in the process. This build uses the Mariadb database instead of MYSQL for two main reasons; Firstly, Mariadb is now the default Ras…

[image] Greebo: It’s getting pretty close now to all going into a single script instead of a set of instructions. Any volunteer? It would be great if the script also prompted the user for a ‘user’ password, which would then go on to setting up the emoncms db user too. This would then simpli…

[image] Greebo: The script also does one extra thing not included in @pb66 ’s post above (drops the database) so the full command to emulate the script would be: Thanks for adding that, I assumed it would need tinkering with as I just quickly drew this together from several sources that all in…

I have been making notes/changes as I work through the guide in it’s current form. My intention was to make a script, predominantly for my own use but I’m happy to share it or contribute to a team effort. There are 1 or 2 thing’s I do differently that may not be agreeable to some. For example I do …

Thanks for the comments @pb66 & @Greebo , I’ve now updated the build guide in my repo if you could take a look please. I’ve used it to build a system this evening, which worked fine. Paul - Very much agree about keeping the emoncms feed folders together in a sub-folder of their own as it compartmen…

[image] Paul: Paul - Very much agree about keeping the emoncms feed folders together in a sub-folder of their own as it compartmentalizes the feeds, makes backups easier, and could also be created automatically by adding the (almost) empty folders to the emoncms repo, to cut down the installatio…

I haven’t made much progress on this (some! but not a lot), however I am in the process of setting up a new emoncms server and I am going to try Debian9 Stretch, although it’s not a Pi the process should be pretty much the same with only a couple of minor differences. I have started a thread on mig…

[image] pb66: So should we be using the default-mysql-server and default-mysql-client packages and let the installer do it’s thing OR should we dictate using the mariadb-client with the mariadb-server for a fully mariadb install OR are we deliberately hanging on to the mysql-client for a good re…

Using this package list sudo apt-get install -y apache2 default-mysql-server default-mysql-client php7.0 libapache2-mod-php7.0 php7.0-mysql php7.0-gd php7.0-opcache php7.0-curl php7.0-dev php7.0-mcrypt php7.0-common php-pear redis-server git-core make I ended up with the mysql packages pb66@test2…

Out of interest, using the existing build guide; sudo apt-get install -y apache2 mariadb-server mysql-client php7.0 libapache2-mod-php7.0 php7.0-mysql php7.0-gd php7.0-opcache php7.0-curl php-pear php7.0-dev php7.0-mcrypt php7.0-common redis-server php-redis git-core build-essential ufw ntp I got …

So long story short, it doesn’t much matter what you ask for you get what your given! I used default-mysql-client, you used mysql-client and one would hope when mariadb-client is used, all result in mariadb-client-10.1 being installed. Odd how I didn’t get mariadb-server however you did specifical…