[Version 2 Release] RaspberryPints - Digital Taplist Solution

[RandR+]

if it would be possible to add colors or SRM values

Yes, the SRM list is maintained in the database so you can add or remove colors.

from the terminal run
sudo mysql
use <DATABASE NAME> (replace with your database name default is raspberrypints)
insert into srmRgb (srm, rgb ) VALUES(99,'255,0,0');
exit

this will add red at the end of the SRM list, you can change the order by changing 99 to -1 to get it on top
you can change 2550,0 to whatever RGB color you want

Maybe I will add an SRM screen to help with this

 

[scubatech]

Its like a grocery list
Is there an integration for the Plaato keg scale?

 

[RandR+]

Is there an integration for the Plaato keg scale?

Yes, see [Version 2 Release] RaspberryPints - Digital Taplist Solution

You need the authentication token for each device, you then set that on the tap and RPints overrides its values with the plaato ones

see Auth_token | Plaato Help Center (intercom.help)

 

[RandR+]

Announcing the latest update to my Rpints.
My testing was basic and limited to what i could test and since it is an overly large update that happened over a few months you will have to let me know if you see anything that is not correct or could be improved.

Release Notes:
Version 3.0.9.0
Add SRM form
1. No Database access needed to add new SRM colors
2. Under Personalize Menu
Motion Detection (UNTESTED)
1. Add LED Pin to light when Motion is detected
2. Added sound file to option to play sound when motion detected
3. Add MQTT option to send a command when motion detected
Gas Tank
1. Added Gas Tank Tracking
2. Allowed GasTanks to have load cells
a. Todo restructure so we have load cells with gas tanks in case the user switches gas tanks
Temperature Logging:
1. Added state pin to the log with the temp taken
a. i.e. log keezer on/off state
2. Added graphing state to temp log based on min/max of the temps recorded
Fermenter
1. Added Fermenters for tracking prekegged beer
Beer Batches
1. Added beer batches for tracking each brew
2. Allows for variation in the beer on the display (ABV/IBU)
3. Allows for fermentation tracking using different yest
a. TODO add compare function for different batches of the same beer
iSpindel Support
1. Option to add multiple listeners in RPints (not sure why you need more than 1)
a. go to advanced hardware -> iSpindel Connecters
b. enter Pi's IP
c. enter port to listen on (this can be any port open on the Pi i.e. 5003)
d. Enter IP and port into iSpindel
e. test.
2. Outputs to Rpints(SQL)/CSV/CraftBeerPi/Unidots/Forward(send to a url)/Fermenttrack/brewspy/brewfather
a. after iSpindel connects the first time you can configure through advanced hardware -> iSpindel Devices
3. Auto updates beer batches with latest information
a. you must assign a beer batch to the iSpindel through the iSpindel configuration
4. Graph fermentation

This also sets me up to implement a better upper right corner to display more information instead of just static temp/last pour, look for that as my next-ish update

 

[DuncB]

This looks great. Thought that it would be a good use for my Gen 1 ( model A I suppose ) raspberry pi. Reading info seems not going to be able to upcycle that and will have to get a new one.
But it's another project to work on and looks a little simpler than BrewPi which obviously has a different role altogether.

 

[day_trippr]

Announcing the latest update to my Rpints.[...]

Awesome! So if I have an existing installation facilitated by Lee @LBussy's script, can I use the gui's "update" function with something approaching confidence?

Meanwhile...gotta love the combination of SF800 meters and a solid keg volume calculator. 2 oz of 640 is an 0.3% error (or, 99.7% accuracy) vs prediction...

 

[RandR+]

Awesome! So if I have an existing installation facilitated by Lee @LBussy's script, can I use the gui's "update" function with something approaching confidence?

The update button is the old way of updating the database after you manually update the files.

Get Latest RPints is the new way to get the latest way to run the installation script and update RPints (including database) in one go

 

[beerNbikes]

Announcing the latest update to my Rpints.
My testing was basic and limited to what i could test and since it is an overly large update that happened over a few months you will have to let me know if you see anything that is not correct or could be improved.

I updated, it's been a while, and whilst everything appeared to have gone well, the Beer batches page has a Cannot execute query" error at the top of the page. This is also present on the Kegs, Taps, Fermenters and Gas tanks pages.

I used the script to update, and no errors were reported. However, the update button on the install page (GUI) shows the following...

Validating Entries...Success!
Checking DB connectivity...Success Connecting to Database!
Checking config folder permissions...Success!
Upgrading RaspberryPints...error in query 104[UPDATE config SET displayName = 'Show the Last Pour in Upper Right Corner' WHERE] [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `log` ( `id` int(11) NOT NULL AUTO_INCREMENT, ...' at line 2]

 

[RandR+]

I used the script to update, and no errors were reported. However, the update button on the install page (GUI) shows the following...

Try the script again now, i had an error in the update.sql that caused it to fail and now its fixed.

I will have to look at making sql error more pronounced as I missed it to with my update

 

[beerNbikes]

OK, so everything went a bit pear shaped, and I ended up formatting and starting from scratch. New install of Pi Desktop, then the install script. It has since taken a lot to get everything up and running, and I still get odd behaviour.
Possibly the worst issue I have is the flowmeters not displaying anything. They register, can see it all happening in the logs (correct pin, count, calculation for ml), and the screen refreshes, but no pours are shown on the screen, nor in the top corner. But it is subtracting the total from the keg.
I have all the settings for showing pours turned on.
Every now and then, when making changes to kegs, taps, I get "Cannot execute query", but then I refresh the page and we're good.
Anyway, on a more positive note, I've added my two fermenters in, and, since I'm locked down, am awaiting my ingredient order so I can get another Motueka Hazy IPA underway.

 

[LBussy]

Hey all - I thought I'd share a new flowmeter/controller choice that supports Raspberry Pints via MQTT: Keg Cop.

 

[troyp42]

Hi guys, Ive been using Raspberry Pints for over a year now. The problem I find with it is that it works fine for a week or two but then the pours stop being registered. I reboot the pi and it works again but will stop working again a few weeks later. Anyone else have this issue? Im thinking about removing the flow meters and not worrying about the ours aspect of it?

 

[beerNbikes]

Hi guys, Ive been using Raspberry Pints for over a year now. The problem I find with it is that it works fine for a week or two but then the pours stop being registered. I reboot the pi and it works again but will stop working again a few weeks later. Anyone else have this issue? Im thinking about removing the flow meters and not worrying about the ours aspect of it?

No, mine have been running for several months. I did try running mine on an Alamode before I found this forum, and had all kinds of pain with that but now, with the USB Uno, I've had no problem at measuring pours. I run a separate power supply for the Arduino. I have my display controlled by the bar lighting, but the Pi and arduino run all the time.

 

[troyp42]

No, mine have been running for several months. I did try running mine on an Alamode before I found this forum, and had all kinds of pain with that but now, with the USB Uno, I've had no problem at measuring pours. I run a separate power supply for the Arduino. I have my display controlled by the bar lighting, but the Pi and arduino run all the time.

Ive got a seperate power supply for the unit as well. What do you man by display controlled by the bar lighting? What power supply do you have for the uno?

 

[beerNbikes]

Ive got a seperate power supply for the unit as well. What do you man by display controlled by the bar lighting? What power supply do you have for the uno?

The arduino has a 12v 1A plugpack via the voltage in. I had it lying around. I note that this probably not needed as it can also be powered from the Pi. However, the Pi's always seem to be power hungry, so I added the individual power for the Uno. By display, I mean the monitor that the Pi outputs to. That is plugged into a smart power point that activates with the bar lighting, so that the digital tap list shows only when I'm in the bar. Nothing fancy, but it means I can run the Pi and Uno all the time. Even if I duck in for a quiet beer on the weekends, without the lights, the pours still count and are subtracted from my kegs.

 

[troyp42]

The arduino has a 12v 1A plugpack via the voltage in. I had it lying around. I note that this probably not needed as it can also be powered from the Pi. However, the Pi's always seem to be power hungry, so I added the individual power for the Uno. By display, I mean the monitor that the Pi outputs to. That is plugged into a smart power point that activates with the bar lighting, so that the digital tap list shows only when I'm in the bar. Nothing fancy, but it means I can run the Pi and Uno all the time. Even if I duck in for a quiet beer on the weekends, without the lights, the pours still count and are subtracted from my kegs.

Ahh ok yes that makes sense. Good idea. I’m using a 9v 1a power supply for my uno. I thought that might be enough. But perhaps not.

 

[day_trippr]

9V 1A is plenty for both an Uno, a dozen flow meters and an attached LCD display.
As well, using a 12V power source will result in the 5V regulator getting very hot...perhaps life-span threatening hot...

Cheers!

 

[better than whine]

Hi All,

When my Pi boots up, it is automatically running the program and pulling up the page that says "Beers on Tap", but none of the beer information is displayed. If I click on the logo to go into the settings, log out, log back in and click on the logo to get back to the main display page, "Beers on Tap" is now displayed with all of the beer/keg information.

Any ideas on what I can do to get all the information to pull up when the program loads on startup so I don't have to go through the log in / log out step?

 

[shaggybeerprof]

sorry, this is going to be very noob... I just installed the RandR+, thank you btw! But I am getting a "Cannot Execute Query" at the top of a lot of categories... How exactly do I fix that? TIA!

edit: I figured it out! I went to the Manage Install and updated

 

[troyp42]

9V 1A is plenty for both an Uno, a dozen flow meters and an attached LCD display.
As well, using a 12V power source will result in the 5V regulator getting very hot...perhaps life-span threatening hot...

Cheers!

So then why would mine stop working every so often and need a reboot?

 

[day_trippr]

There are quite a few possibilities. Dodgy SD card, overheated SOC, something not solidly connected, etc.
What I am saying is if you're using a 9V 1A wall wart on an UNO that is plenty of capacity and you probably should look elsewhere for root causes of system misbehavior, especially anything that requires a reboot to clear. I would expect a problem on the RPi side in such cases...

Cheers!

 

[RandR+]

Possibly the worst issue I have is the flowmeters not displaying anything. They register, can see it all happening in the logs (correct pin, count, calculation for ml), and the screen refreshes, but no pours are shown on the screen, nor in the top corner. But it is subtracting the total from the keg.
I have all the settings for showing pours turned on.

Try Getting Latest Rpints i found i had an issue with the new upper right corner code that may have caused the issue with no pours being displayed.

Every now and then, when making changes to kegs, taps, I get "Cannot execute query", but then I refresh the page and we're good.

Can you let me know when you see that and what you are doing? Im finding a few minor issues im working through that i can fix

 

[RandR+]

The problem I find with it is that it works fine for a week or two but then the pours stop being registered.

When this happens check the Rpints log (either /var/log/rpints.log or the log screen) to see if there are errors

 

[RandR+]

Any ideas on what I can do to get all the information to pull up when the program loads on startup so I don't have to go through the log in / log out step?

Check /var/log/apache2/error.log on startup to see if there are any errors at the end of it stopping the page from loading.

Though its odd that going to the admin screen fixes it

 

[RandR+]

Any ideas on what I can do to get all the information to pull up when the program loads on startup so I don't have to go through the log in / log out step?

I found an issue with the new upper right logic that was causing issues if the fermenter was not the first fermenter.
I have fixed

Click the Get latest RPints from the manage install screen to update

 

[beerNbikes]

Hi RandR+,
Installed the latest (using the script), still nothing with the pours. I have all the pour display settings on, but nothing on the main screen, and nothing top right. I have turned off the fermenters and gas from displaying top right just in case it was that, but no dice.
I went to the install page, clicked get latest, then clicked update. Got the following:

Validating Entries...Success!
Checking DB connectivity...Success Connecting to Database!
Checking config folder permissions...Success!
Upgrading RaspberryPints...error in query 211[CREATE OR REPLACE VIEW vwFermenters AS select f.id AS id, f.labe] [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE OR REPLACE VIEW vwGetActiveTaps AS SELECT t.id, b.id as 'beerId', ...' at line 39]

The cannot execute query error can no longer be triggered, at least not that I can see.
Pours are still registering
pi@rpints:~ $ tail -f /var/log/rpints.log
2021-06-03 19:31:03 RPINTS: Could not import RFID Reader, RFID disabled. Assuming SPI not installed/configured
2021-06-03 19:31:12 RPINTS: starting WS server
2021-06-03 19:31:12 RPINTS: starting device monitors...
2021-06-03 19:31:12 RPINTS: starting command server
2021-06-03 19:31:12 RPINTS: starting fan control
2021-06-03 19:31:12 RPINTS: Fan Control fanControl1 is Running
2021-06-03 19:31:12 RPINTS: Not Configured to run Fan
Pourpour on pin: 6, count: 462, conversion: 1500, amount: 0.308, amountUnit: ml, user: N/A

And pours are subtracting from the keg remaining.

 

[RandR+]

Installed the latest (using the script), still nothing with the pours. I have all the pour display settings on, but nothing on the main screen, and nothing top right. I have turned off the fermenters and gas from displaying top right just in case it was that, but no dice.

I found an issue, if the pour didnt have a batch it would error on insert but still update the keg. Since there were no pours in the database there was nothing to display on the main page.
I found I updated my environment but didnt take it back to the scripts that is why you had the issue and i didnt

Upgrading RaspberryPints...error in query 211

I fixed this, had a missing ; in the sql

 

[shaggybeerprof]

Hi RandR+,
I've recently installed your version of RPints using the process from install.rpints.com... tried installing Tobor's version but it just doesn't seem to work correctly, so I installed yours and it seems to work, ish... I can't seem to get rid of two glasses under ABV/CALORIES/GRAVITY on two of three beers. I must be missing a setting somewhere? Any insight would be greatly appreciated. Also is there a write-up/tutorial somewhere about what all the settings do, etc?

 

[RandR+]

I can't seem to get rid of two glasses under ABV/CALORIES/GRAVITY on two of three beers. I must be missing a setting somewhere? Any insight would be greatly appreciated. Also is there a write-up/tutorial somewhere about what all the settings do, etc?

The number of glasses and how full the last one is, is a visible representation of the ABV, the higher the ABV the more glasses (the highest being 2 full glass and 1 tipped over). This was part of the original RPints that I took.

Ive been working on a help screen but not with a lot of effort so No there is nothing that shows what the settings do, I am working on a customization screen so you can just use a checkbox to enable or disable settings without knowing there names.

 

[shaggybeerprof]

OK, good to know, thanks! I thought maybe I was doing something wrong... so it looks as if, 5.0% must be the max? Then spills over after that? Any way to change that?