[Version 2 Release] RaspberryPints - Digital Taplist Solution

[day_trippr]

I have an 8GB RPi4 and tbh would not run it without a cooler...

Cheers!

 

[DuncB]

I have an 8GB RPi4 and tbh would not run it without a cooler...

Cheers!

Assuming you mean a fan or very large heatsink?

I'm thinking something like this.

https://www.jaycar.co.nz/heatsink-c...NSEpgESF2xmxQyqMftVVzbkvRGn6NbsQaAgBTEALw_wcB

 

[day_trippr]

Lol! That looks like a serious Bitcoin mining solution. I went with a slightly more modest kit

With what I've been playing with it does not thermal throttle...

Cheers!

 

[DuncB]

Thanks

I'll just box the Pi and attach the arduino and thing that the sensors can plug into and put an inlet and outlet fan on it. Raspberry pints, youtube or kodi shouldn't throttle with that.

 

[day_trippr]

Of course if you are going with an Alamode my kit isn't going to work, but with an Uno handling the flow meters (tbh, the better choice from a value proposition) it's an inexpensive and practical setup...

Cheers!

 

[DuncB]

Of course if you are going with an Alamode my kit isn't going to work, but with an Uno handling the flow meters (tbh, the better choice from a value proposition) it's an inexpensive and practical setup...

Cheers!

Yes I've got a Uno following your recommendation and also have a linker base to plug the sensors into it.

 

[day_trippr]

On the topic of back-up strategies...

I had related a month or so ago that a lightning strike and accompanying power outage corrupted the Raspberry Pints tap list database for my keezer, but that I was able to recover via a backup SD card with a bit of massaging. And all seemed well. But, it turned out there was a latent corruption on that backup card that didn't become evident until a keg kicked: when I went to put another keg on tap, R'Pints said I actually had zero kegs with beer and suggested I create a keg list. The Kegs table was corrupted. Woof.

I was able to limp along by manually editing the database creating a new "tap" (a specific keg associated with a specific beer at a point in time) and associating it with the specific faucet in the database using Phpmyadmin, but R'Pints would not auto-update with a pour, so I also had to use Phpmyadmin after each pour to keep the keg tracking close. Eventually I figured out the corruption had two kegs associated with the same faucet which was blocking the auto updates. And my attempts to delete the empty keg using Phpmyadmin were rebuffed for some reason.

This was quickly coming to a head and had to be resolved as another keg was getting close to kicking. I was considering wiping out the database and using the original installation script to create an empty one, essentially rolling the clock back to 2014. But I dug through my collection of backup SD cards for the clone of my brewery controller and found a couple from 3 years ago.

Put one of them in the clone system and booted up, and there was a clean if out of date Raspberry Pints tap list, with functional Beer, Keg and Tap tables. I just had to go through the tables to copy over the current values from the running machine, then copy the resulting database and log files to the running machine, and everything was back to sanity.

It's a beautiful thing.

Point is, when doing backups, it's a good idea to have a "rolling" strategy, so you have a few or more different "check-points" to revert to. Had I re-burned all of the SD cards for my clone machine, the latent database corruption would be "everywhere" with no recourse but to start over...

Cheers!

 

[kpietro22]

Apologies if this has been answered before, but I am trying to install RPints on my Pi 4 and am having no such luck following a successful install of Fermentrack. I keep seeing this error: ERROR: apache2 test failed. Can anyone please help? I seep a similar message when I tried to install it following the nginx path under the Fermentrack option. Thank you in advance!

 

[DuncB]

Are you using the install command script?

 

[kpietro22]

Are you using the install command script?

Yes, I am. Originally, the install said it had completed successfully. But when I went to the IP listed, I saw 502 Bad Gateway.

I’m suspecting that I am definitely executing something improperly. I have tried to modify the default sites available scripts in the apache2 folder to reflect what day_triprr has mentioned previously but for some reason I do not have permission to modify/save these files. Any ideas?

 

[DuncB]

Sadly no, I'm imminently going to install from scratch onto pi4 so watching closely.
Your abilities seem well above mine.

 

[day_trippr]

Pretty much everything that runs apache2 requires root privileges to edit. Also you probably want to stop the server process when editing any of its files then start it back up when done...

Cheers!

 

[RandR+]

I keep seeing this error: ERROR: apache2 test failed

in the install script did you choose to use nginx over apache? if you have Fermentrack then its best to use nginx when installing to prevent conflicts

 

[kpietro22]

in the install script did you choose to use nginx over apache? if you have Fermentrack then its best to use nginx when installing to prevent conflicts

I tried it both ways. I am new at using python and raspberry pi so originally I thought that installing it using apache. When I could not get that to work, I tried it with the nginx script and received the same result. Both tests failed. I’m running Fermentrack on port 8080, so I don’t think that this is the issue. I do not have any preferences toward apache or nginx but just would like to run these side by side if possible. Thanks for your help so far!

 

[RandR+]

nginx script and received the same result

I recommend using nginx if running with fementrack

did you see a prompt like:
Fermentrack detected, do you want to place 'Rpints' Under it

when modifying the nginx configuration make sure to use sudo to launch the text editor (from terminal) otherwise just opening the text editor from the window will not have permissions.

 

[kpietro22]

I recommend using nginx if running with fementrack

did you see a prompt like:
Fermentrack detected, do you want to place 'Rpints' Under it

when modifying the nginx configuration make sure to use sudo to launch the text editor (from terminal) otherwise just opening the text editor from the window will not have permissions.

Thank you for this information! Yes, I did see that prompt, and on my last attempt I selected 'yes'. However, I did not know to launch text editor from the terminal. Since my Fermentrack is utilizing port 8080, what file(s) do you suspect I will have to modify with the text editor in order for the install to complete?

 

[RandR+]

Since my Fermentrack is utilizing port 8080, what file(s) do you suspect I will have to modify with the text editor in order for the install to complete?

what files do you have in: /etc/nginx/sites-available/
im guessing default-fermentrack and maybe default-rpints

the installer will add the configuration for Rpints and if it detects fermentrack is installed switch the port to 81

Maybe try port 81 and see what error you get?

 

[DuncB]

Watching closely and pleased to get first post on page 200 of this great thread and program. Keep up the good work.

 

[kpietro22]

what files do you have in: /etc/nginx/sites-available/
im guessing default-fermentrack and maybe default-rpints

the installer will add the configuration for Rpints and if it detects fermentrack is installed switch the port to 81

Maybe try port 81 and see what error you get?

So I edited the default-rpints file to reflect installing rpints in /var/www through the terminal and after directing the install away from going inside Fermentrack, I received this error:

Updating Packages which may require it - Complete.
Fermentrack detected, do you want to place 'Rpints' Under it (i.e. http://fermtrack.ip/RPints) [y/N]:
sed: can't read /usr/share/phpmyadmin/libraries/sql.lib.php: No such file or directory

Searching for default web location.
Where do you want to install RaspberryPints? : /var/www
Installing to: /var/www
URL's Sub Folder: :81
sed: -e expression #1, char 39: unterminated `s' command

Updated /etc/nginx/sites-available/default-rpints

Testing nginx.

ERROR: nginx test failed.


I am still puzzled. Any ideas?

 

[day_trippr]

Watching closely and pleased to get first post on page 200 of this great thread and program. Keep up the good work.

It is indeed one of the all time long running threads.
And congrats on bagging your white whale though it's more fun to bag a "thousandth" post, imo.
We have one within sight

Cheers!

 

[RandR+]

sed: -e expression #1, char 39: unterminated `s' command

that is definitely an error in the install script, i am trying to setup my test VM with fermentrack to test

 

[RandR+]

Testing nginx.

ERROR: nginx test failed.

how did you install fermentrack? The default is now to install it with docker which leaves you free to install any other web server on your pi.

The error is caused because the installer found 2 different php and that caused the replace to fail but then you would have this error
ERROR: PHP test failed.
not the nginx failed.

I did install fermentrack using the old method that installed nginx, then installed Rpints and it work up to that php error. I manually changed default-rpints
replaced #PHPSOCKET# and ngix still worked.
But on my installation i got the gateway error for fermentrack so it seems like it could be fermentrack nginx configuration is old and doesnt work anymore

 

[kpietro22]

how did you install fermentrack? The default is now to install it with docker which leaves you free to install any other web server on your pi.

The error is caused because the installer found 2 different php and that caused the replace to fail but then you would have this error
ERROR: PHP test failed.
not the nginx failed.

I did install fermentrack using the old method that installed nginx, then installed Rpints and it work up to that php error. I manually changed default-rpints
replaced #PHPSOCKET# and ngix still worked.
But on my installation i got the gateway error for fermentrack so it seems like it could be fermentrack nginx configuration is old and doesnt work anymore

I believe I did use the docker approach, but I could be wrong. I used the script:

(cd fermentrack-tools && sudo ./install.sh)

so that I could alter the port utilized during the process. Do you suggest I reinstall Fermentrack using the docker approach and deal with the port issue later when trying to install rpints?

Thanks for your help!

 

[Thorrak]

I believe I did use the docker approach, but I could be wrong. I used the script:

(cd fermentrack-tools && sudo ./install.sh)

For the past two years, that would result - by default - in you receiving the "docker" version. Fermentrack doesn't use or install anything PHP related (and, even if it did, as @RandR+ noted it would be segregated into its own container).

Did you happen to install (or try installing) BrewPi Remix at some point?

 

[kpietro22]

For the past two years, that would result - by default - in you receiving the "docker" version. Fermentrack doesn't use or install anything PHP related (and, even if it did, as @RandR+ noted it would be segregated into its own container).

Did you happen to install (or try installing) BrewPi Remix at some point?

I see. So I need to have rpints point to a new install of php? I’m sorry I’m just very new to understanding the raspberry pi system and programming. I did not install brewpi-remix. The Fermentrack install was on a fresh install of Raspbian. Should I format the card and try this again using the docker approach formally?

 

[RandR+]

So I need to have rpints point to a new install of php? I’m sorry I’m just very new to understanding the raspberry pi system and programming. I did not install brewpi-remix. The Fermentrack install was on a fresh install of Raspbian. Should I format the card and try this again using the docker approach formally?

what i would do is install Fermentrack using the docker approach.
Setup to use port 8080 and verify it is working. if not working try again.

Then you should be able to run the installer for Rpints and install normally following the basic prompts. You can use any web server.
the installer should correctly install php for you and Rpints will be your default when you go to your pi ip in a browser.

 

[kpietro22]

what i would do is install Fermentrack using the docker approach.
Setup to use port 8080 and verify it is working. if not working try again.

Then you should be able to run the installer for Rpints and install normally following the basic prompts. You can use any web server.
the installer should correctly install php for you and Rpints will be your default when you go to your pi ip in a browser.

Thanks for your help! I followed this pipeline and got both to work! Now just waiting on my d32 pro and tft to arrive to flash and finish building my BrewPi-ESP setup. Thanks @Thorrak !

 

[Thorrak]

Thanks for your help! I followed this pipeline and got both to work! Now just waiting on my d32 pro and tft to arrive to flash and finish building my BrewPi-ESP setup. Thanks @Thorrak !

Thanks @RandR+

 

[DuncB]

Sorry posted this in the wrong thread first, I've deleted it there.

Quick questions about the flowmeter wiring.

I've got the UNO R3 and have also got a Base shield

Base Shield V2 (Seeed Studio)​

As an expansion board, Base Shield v2 has many Grove connectors, making it convenient for you to use Grove products together. And It is compatible with...

core-electronics.com.au

If I understand correctly I power the rasp pi 4 from the correct 3 A power supply.

Separate power supply to the UNO R3 all connected to the Pi via USB.
Do I set the shield to 5 volts to supply the arduino flow meters?

The shield fits on the top of the R3 and I run VCC, GND and Data from each grove digital connector to each individual flow meter.
I've noted that some people using ribbon connectors or CAT 6 cables to simplify multiple wires out of the keg fridge.

I should be having the flow meters at what distance from each keg? Most of my lines are about 5 foot as evabarrier 4mm internal 8mm external.

Do I need to cover the connections inside the fridge with silicone to protect against condensation?

What type of temperature sensor should I use for the fridge? DSB1820 or an NTC 10k sensor?

The 10K pull up resistor, do I put one for each sensor? and does it goes in parallel to the sensor ie attached to the VCC and GND for each sensor?

I've tested the Raspberry Pi 4 and it's far superior to the Pi 3 I had before, glad finally to get my hands on one.

 

[day_trippr]

Yes, an RPi4B will be the snappiest 'Pi for this job, though even a 2B works pretty well. But I always recommend avoiding the single core Zero.

Provide the RPi4B with a dedicated 5VDC @ 3A supply, and the UNO R3 a dedicated 9VDC @1A supply via its barrel connector, and tie them together via their USB ports. The shield sits atop the UNO which is a 5V platform, so set the shield accordingly.

Each flow meter should receive 5VDC via the shield. It is also recommended to provide each flow meter data circuit with a 2.2Kohm pull-up resistor to 5VDC, but there have been folks that never used a pull-up and just relied on the programmable pull-ups on the AVR, apparently without problem. It is possible - the bandwidth needed for the meters is sub one kilohertz

Otherwise, wiring should not be critical, I have my flow meters original 100cm ribbon cables then connected via twisted pair approximately another 5 feet in total length to the controller complex and traversing at least 4 connector interfaces along the way with no issues.

I have six SF800 flow meters, six ds18b20 temperature sensors, and three fan power leads, all terminated with Tiny XLR connectors plugged into receptacles located in tightly sealed enclosures attached to my custom keezer lid, which puts them fairly out of the way of condensation which if it happens usually is well below the lid level. But I also have a pair of Eva Dry 500 desiccators inside to help keep condensation at bay, and my lid is tighter than any oem lid I've had the pleasure of using.

Cheers!