[Version 2 Release] RaspberryPints - Digital Taplist Solution

[RandR+]

RandR 's script, I noticed it didn't disable the screen blanking

Wonder if they change it in Buster, will need to research

 

[snarf7]

Instructions are not something that I have got around to. The flow meter wiring should be close to the original instructions, BUT there is no longer a need to modify the ino file in my version.

To wire the flow meters hook the power wires to Arduino power pins, then hook the signal to a pin (I used pins next to each other on the alamode, 6-13)

Then go to Admin -> Taps, click on settings, and setup for 4 taps and hit save. Once the screen has 4 taps on it, you can enter in the pulse count and the pin the flow meter is attached to

for each tap​

. If you don't see the pin number column then click on settings again and check the flowmeter box.

OK so no need for inline resistors like some of the diagrams I've seen? Just red to 5V, black to ground and whatever color the other one is to the digital pins on the UNO and any of them will work, so I'll probably choose 4-7 since those are easy to access.

thanks again man

 

[RandR+]

no need for inline resistors like some of the diagrams I've seen

I do not use resisters in the wiring, BUT the Arduinos have built in resistors that can be enabled by code. The ino file already enables the resistor.

 

[zevans08]

I am trying to change the font and when i save the css file i get a permission error. when I try to change the permission I get an error as well. what am i missing?

 

[day_trippr]

Sudo that beyotch!

 

[zevans08]

Sudo that beyotch!

Lol ok so i edo that through (for a lack of a better term) command prompt? Type sudo then ? The file path?

I have some knowledge of this but it's been a while

 

[RandR+]

Type sudo then ? The file path?

sudo chmod 777 /var/www/html -R
will give read/write/execute permission to all files
sudo nano <file>
will allow you to write to files without changing permissions

 

[zevans08]

sudo chmod 777 /var/www/html -R
will give read/write/execute permission to all files
sudo nano <file>
will allow you to write to files without changing permissions

Thanks. I'll give it a try this evening

 

[zevans08]

Thanks. I'll give it a try this evening

Success!!!!!

 

[LBussy]

BUT there is no longer a need to modify the ino file in my version

Excellent change!

 

[snarf7]

A power question...does the Arduino require power from an AC adapter or will the USB connection to the Pi provide the necessary power for it?

 

[mothership]

K, i'm at a loss.
i've been reading thru all these posts now for a few weeks and i thought i had it figured out. i've got my raspberrypi and arduino uno hooked up. arduino is connected to pi via USB. pi has the latest NOOB on it, arduino has .ino from Tobor via this script:

curl -L https://raw.githubusercontent.com/rtlindne/RaspberryPints/master/util/installRaspberryPints | sudo bash

i modified files according to this post: https://www.homebrewtalk.com/forum/...-taplist-solution.487694/page-67#post-8040187

i only have 1 tap and 1 adafruit flow meter. i can see the flowmeter on the arduino. the light on the arduino blinks after the flowmeter stops. also, if i open Arduino IDE on the pi, i can see data from the serial monitor. the arduino is connected via /dev/ttyUSB0. however, when i pour a beer, nothing changes on my "oz poured." i can see the screen refresh, but no numbers change.

what am i missing?

 

[cookiemehnster]

I installed xscreensaver ....

Any tips on how to do this for a noob who is semi-literate at best in all of this stuff?

I visited https://www.jwz.org/xscreensaver/download.html but for Debian (that is what Raspbian is based on, right?) it's not straightforward as to what version to install (or what command to run to do so)....I'm running Buster, and installed RPints through the command line posted by LBussy at (https://www.homebrewtalk.com/forum/...taplist-solution.487694/page-117#post-8624935).

TIA

 

[cookiemehnster]

End users do not need to go to GitHub, nor do they need to download the zip file above. End users need only issue the following command:

curl -L rpints-tobor.brewpiremix.com | sudo bash

This works on a clean Raspbian Stretch installation.

THANK YOU THANK YOU THANK YOU!!

I did a clean Raspbian Buster install, ran this command, and got a clean install. From an end user who has never used a command prompt before this project, this was a godsend.

There are two issues I've encountered: 1) the screen blanking was not disabled, and 2) I cannot populate the Tap List. I added beers, I added kegs, but when I "tap a keg" on the Tap List, the Keg drop down menu does not show any of the kegs I added... Any thoughts? Does it take a while for the updates to take place? (ie, will this issue resolve itself after some amount of time?). Thanks!

 

[RandR+]

i can see the screen refresh, but no numbers change.

did you setup the count per gallon/liter (on the taps page, just to the right of the flow pin)?

If it is set to 0 then the pour wont register, but the screen will refresh.

You can check /var/log/rpints.log to see if any errors occurred during the pour.

 

[mothership]

did you setup the count per gallon/liter (on the taps page, just to the right of the flow pin)?

If it is set to 0 then the pour wont register, but the screen will refresh.

You can check /var/log/rpints.log to see if any errors occurred during the pour.

i'll try that tonight when i get home.

thanks

 

[mothership]

i'll try that tonight when i get home.

thanks

don't think i have the same version you have. i seem to have no /var/log/rpints.log.

this is what my taps page looks like:

 

[mothership]

so a bit more tinkering.

i restarted with a fresh install of NOOBS. i used this script "curl -L https://raw.githubusercontent.com/rtlindne/RaspberryPints/master/util/installRaspberryPints | sudo bash" to install raspberrypints. everything went smooth with that. i setup my taps, kegs and beer in the rpints admin page. still no flow meter action. i modified the raspberrypints.ino file to show 1 meter on pin 2 and re-uploaded to the arduino. i made sure that /var/www/html/includes/pours.php has line 64 changed to $amount = $PULSE_COUNT / 1500;
in fact, i double checked that i followed all the steps relevant to my arduino uno clone in the post by @day_trippr (https://www.homebrewtalk.com/forum/...-taplist-solution.487694/page-67#post-8040187)
still no flow meter action.
then i manually ran the /var/www/html/python/flowmon and /var/www/html/python/flow_monitor.py. only then did i get something new. on the terminal window where i started the flow_monitor.py file, i got the following:

 

[RandR+]

don't think i have the same version you have

What version did you install? I am guess you selected Tobars version which mirrors the original and the steps needed to modify the ino file to work.

i modified the raspberrypints.ino file to show 1 meter

that is the correct action.

the flow_monitor.py file, i got the following:

I downloaded the file from Tobar's post and see there is an error in includes/pours.php at line 76
it should be changed from
mysqli_query(qry);
to
mysqli_query($link, $qry);​

if you make that change it should work

 

[mothership]

What version did you install? I am guess you selected Tobars version which mirrors the original and the steps needed to modify the ino file to work.


that is the correct action.

I downloaded the file from Tobar's post and see there is an error in includes/pours.php at line 76
it should be changed from
mysqli_query(qry);
to
mysqli_query($link, $qry);​

if you make that change it should work

yes, i installed tobar's version

thanks a bunch for the help. as you can tell, i'm no programmer

 

[mothership]

I downloaded the file from Tobar's post and see there is an error in includes/pours.php at line 76

it should be changed from
mysqli_query(qry);
to
mysqli_query($link, $qry);​

if you make that change it should work

SUCCESS!!!! that did it!

thank you so much @RandR+

now if i could just get the brewery logo to be big and centered under the tap list

 

[Tobor_8thMan]

Since I don't use tap meters I asked others to test the mods. I thought they did. Seeing the post I realize, perhaps, the tap mods were not tested.

At any rate, thanks for finding the error. I've fixed the pours.php and rezipped. The newest zip is attached to this post.

 

[mothership]

so, while i was going thru the install process for raspberrypints, i noticed that the script asked if i wanted to use RFID and/or temp sensors. yet in my reading thru these posts, i've not seen any mention to temp sensors.

so what would that do for me and how do i go about using said temp sensors.

and what is RFID?

 

[AI6K]

Some kegs have an RFID (Radio Frequency Identification) for data. That's my unenlightened idea.

 

[day_trippr]

I was assuming the rfid thing was for user identification.

I believe RandR+ integrated something resembling my multi-channel temperature logger (perhaps without the actual logging) as well as the PIR motion detector thing I did...

Cheers!

 

[AI6K]

I like the idea of low-jacking people that are drinking my brew.


Dave

 

[RandR+]

said temp sensors.
and what is RFID?

multi-channel temperature logger (perhaps without the actual logging) as well as the PIR motion detector thing I did

Yes I integrated day trippr's work into mine, and made plenty of mention in the code that it came from his work. So running my version doesn't need to have different processes running to get all those features, and they are all configurable through the admin page

The temp logging does log to the database and you can see historical data from the admin page.

The RFID is used for user identification of a pour. I am still working out some bugs with it but when it is working then a drinker can use a RFID card (and possibly their phone) to trace the pour back to them. It also allows valves to be put inline with the flow sensors so that nothing can be poured without an RFID (they can still be manually turned on through the admin page)

 

[RandR+]

now if i could just get the brewery logo to be big and centered under the tap list

change index.php:462 from
echo '</tbody></table></div></body></html>' . "\n";

to
echo '</tbody></table></div><img src="' . $config[ConfigNames::LogoUrl] . '" height="700" alt=""></a></body></html>' . "\n";

change the 700 in height="700" to what looks good for your screen

 

[mothership]

change index.php:462 from
echo '</tbody></table></div></body></html>' . "\n";

to
echo '</tbody></table></div><img src="' . $config[ConfigNames::LogoUrl] . '" height="700" alt=""></a></body></html>' . "\n";

change the 700 in height="700" to what looks good for your screen

fantastic. thanks again!

 

[Tobor_8thMan]

change index.php:462 from
echo '</tbody></table></div></body></html>' . "\n";

to
echo '</tbody></table></div><img src="' . $config[ConfigNames::LogoUrl] . '" height="700" alt=""></a></body></html>' . "\n";

change the 700 in height="700" to what looks good for your screen

by doing so you're causing a terminating anchor tag </a> without the opening anchor tag (aka unmatched html tags).

line is
echo '</tbody></table></div><img src="' . $config[ConfigNames::LogoUrl] . '" height="700" alt=""></body></html>' . "\n";

 

[RandR+]

</a>

your right, copy and paste error on my side
@mothership

use

echo '</tbody></table></div><img src="' . $config[ConfigNames::LogoUrl] . '" height="700" alt=""></body></html>' . "\n";

 

[RodimusPrime98]

Does anyone know what John Guest fittings are included with the SwissFlow SF800 flow meters? I assume the push-in side is 3/8" ID, is that correct? I am trying to purchase a John Guest adapter that will mate with the fittings provided with the sensors and my existing Bev-Ultra Barrier tubing with 5/16" OD.
I am thinking it is this fitting but again I cannot find any information on what John Guest fittings are included with the SwissFlow SF800.
https://www.freshwatersystems.com/products/john-guest-reducer-stem-polypro-3-8-od-stem-x-5-16

Also, how long has it taken people to receive their SF800's from SwissFlow? I just ordered 6x of the SF800 to start down the path of RaspberryPints.

 

[MoreBeerDude]

THANK YOU THANK YOU THANK YOU!!

There are two issues I've encountered: 1) the screen blanking was not disabled, and 2) I cannot populate the Tap List. I added beers, I added kegs, but when I "tap a keg" on the Tap List, the Keg drop down menu does not show any of the kegs I added... Any thoughts? Does it take a while for the updates to take place? (ie, will this issue resolve itself after some amount of time?). Thanks!

Any progress here? I'm stuck the same place - can't tap a keg. Any insights?

 

[RandR+]

can't tap a keg. Any insights?

One thing I remember from the original was that kegs need to be in the correct status (i.e. must not be any of the following SERVING, NEEDS_CLEANING, NEEDS_PARTS, NEEDS_REPAIRS

I didn't like that so made a change on my version so that any active keg is available to select and when tapped it automatically transitions to the SERVING status

 

[Mrbadgolf]

I have raspberry pints up using RandR+ script. I was able to add everything successfully. When I add my flowmeters and my arduino r3 I am still not sable to see anything as far as pours. Is there anyone that can help me get my flow meters running. I would greatly appreciate it.

 

[RandR+]

Is there anyone that can help me get my flow meters running

On the Taps page (under admin) did you setup the Flow Pin correctly and set the count per gallon to be not 0?

You can check /var/log/rpints.log to see there is an error in there, there should be text like 'got a pour' if the flow meters are registering correctly.

 

[cookiemehnster]

Any progress here? I'm stuck the same place - can't tap a keg. Any insights?

Honestly, I've done about 5 full wipe/reinstalls since posting that (using the RandR+ install command line, not LBussy's which I used originally), with both RandR+ and Tobor's versions, both with and without the "example" data loaded, and I have yet to get any of them to work without issue. (I'm using a brand new setup with NOOBS/Buster installed)

With RandR+'s version, the main page taplist is blank ("your logo here" and "Beers on tap" are there, but no beers), both on initial load after install and with my beers added and set to the tap list. I also can't figure out how to add an admin username, change the password (the browser just loads and loads but the page doesn't change) or do any user setup.

Tobor's version has that keg/beer issue, where I can't add kegs from scratch (when I don't load the example data) and I can't delete beers (when I do load the example data).

My programming knowledge is limited to what I've retained from a high school C++ class (nothing), so I'm not capable of tinkering around and fixing any of these issues. At this point, my best option is to use Tobor's version with the example data loaded, and just leave all the junk in the background pages. At least that would get me the end result I want: a Tap List page with the data I want to display...

[[I don't want the above to sound unappreciative... MANY MANY thanks to all of you who have put work in on this. This project just isn't as "follow the directions and you're good" as I expected when I read the RPints webpage instructions...]]

 

[Tobor_8thMan]

Tobor's version has that keg/beer issue, where I can't add kegs from scratch (when I don't load the example data) and I can't delete beers (when I do load the example data).

I don't have keg taps, but I'm sorry you've run into an issue. Please elaborate about the problems and I will adjust the code. What happens/what error when you add keg from scratch?

Please describe problems about deleting beers and I will analyze the code.

 

[CadiBrewer]

With RandR+'s version, the main page taplist is blank ("your logo here" and "Beers on tap" are there, but no beers), both on initial load after install and with my beers added and set to the tap list. I also can't figure out how to add an admin username, change the password (the browser just loads and loads but the page doesn't change) or do any user setup.

+1 to this. I just tried an install using RandR+'s version and experienced the same phenomena. Blank screen except for the "your logo here" and "beers on tap". I tried changing everthing I could think of in the config page but nothing changed it.

 

[Tobor_8thMan]

+1 to this. I just tried an install using RandR+'s version and experienced the same phenomena. Blank screen except for the "your logo here" and "beers on tap". I tried changing everthing I could think of in the config page but nothing changed it.

Means it's not pulling data from the DB correctly.