[Version 2 Release] RaspberryPints - Digital Taplist Solution

[Jeffmyers5266]

Hi everyone - first of all thank you to everyone who has put so much work into this. I tried my best to not have to ask for help, but I think I’m out of options at this point. I’ve installed the R&R+ version, and all is well, except the flowmeters. The temperature probe does indeed work, but the flowmeters don’t register any pours, but occasionally register ghost pours. I’ve tried everything I can think of, including replacing the raspberry pi and alamode themselves. I’ve reinstalled the software a few times. I have a raspberry pi endorsed power cord and sd card. I have 6 flowmeters, all Swiss flow SF800. They are wired to a breadboard, with the center as the data line, and side with the wire painted (I have two separate kinds, some are black and some are red), as the ground. The breadboard power goes to the 5v0 in the alamode. I’ve tested it via multimeter and it’s pretty close to 5V (I think it was 4.7. The data lines go to the power with a 2k2 resistor between on the breadboard. The flowmeters are on the collar of the keezer with the cords going through the collar out to the breadboard then pi.

Any ideas? Is this more likely software or hardware connections? Is there a log or way of testing this?

Thank you so much to any

 

[RandR+]

Is this more likely software or hardware connections?

I would say the software is most likely isnt the issue, but i wouldnt rule it out completely.

If you are familiar with Arduino you could try a basic sketch designed for counting pulses to verify its not the software.

I would also check /var/log/rpints.log to see what it says, you can also enable more debugging through the python/Config.py file
specifically change
config['flowmon.debug' ] = False#True
to
config['flowmon.debug' ] = True

then restart the flowmon service.

Also make sure the flow through the meters is going in the correct direction

 

[LBussy]

I tried my best to not have to ask for help, but I think I’m out of options at this point.

A picture of your wiring may help us determine if you've crossed something up there.

 

[Jeffmyers5266]

Thank you both. 6 months of trying to get this setup together- I finally give in and ask for help and the next day it starts working. It seems like it had to be something wiring-wise because I again took it apart and put it together again but I didn’t change the setup, so who knows. I’ll post some pictures when I get the actual monitor up but every pour seems to be registering just perfect suddenly. Temperature too. This software is incredible and hopefully now I’ll never have an empty tap. Thanks again to everyone who has supported it!

 

[day_trippr]

Oh my. Thoughts and prayers?

Assuming you are running on a Raspberry Pi, this would be an awesome time to use the SD Card Copier Utility, create a live copy of your awesome running card, then do an orderly shutdown, remove power, swap the SD card to boot off the clone, reconnect power and reboot.

My philosophy is an untested backup is not a backup at all. Admittedly that was born of the tape backup era, but still

Cheers!

 

[Dellboy78]

I started my keezer build last summer and in anticipation bought myself a raspberry pi and a screen and installed raspberry pints, which seemed to work fine on its test run. Roll on to now and the keezer is finally working, but my raspberry pints doesn’t seem to be playing ball now I actually want to use it! I was hoping for some advice from those on here who are much more knowledgeable than me.
It loads up fine and looks good but then after a while the screen goes black (I think the pi reboots or something), the little raspberry icon shows at the top but not much more happens. The screen goes black and occasionally flickers white but the only thing that temporarily resolves it is to pull the power and reconnect. Any ideas? Should I get a new sd card and do a fresh install? Thanks

 

[Tobor_8thMan]

Is the screen saver blanking the screen?

 

[day_trippr]

That wouldn't explain "the little raspberry icon shows at the top" thing. Sounds to me like whatever the cause it's crashing the 'Pi.
I'm assuming from the questions the OP never cloned the once working card, so this would be a good time to do a fresh installation and then back it up...

Cheers!

 

[Dellboy78]

Is the screen saver blanking the screen?

I don’t think so. At first I thought my screen was faulty as it was black and occasionally flashing white. I’ve not seen a screensaver as such come up.

 

[Dellboy78]

That wouldn't explain "the little raspberry icon shows at the top" thing. Sounds to me like whatever the cause it's crashing the 'Pi.
I'm assuming from the questions the OP never cloned the once working card, so this would be a good time to do a fresh installation and then back it up...

Cheers!

Yes, I think I will have to start over. Just need to remember how I did it the first time now! Thanks.

 

[LBussy]

It loads up fine and looks good but then after a while the screen goes black (I think the pi reboots or something), the little raspberry icon shows at the top but not much more happens.

This sounds like a brownout. Do you have a good Raspberry Pi power supply?

 

[Dellboy78]

This sounds like a brownout. Do you have a good Raspberry Pi power supply?

Not heard of a brownout before! What does that mean? I think I just bought a power supply on Amazon. My pi is mounted on the pack of the screen and is fed from the screen itself via a usb.....

 

[LBussy]

Try a larger dedicated power supply.

A brownout is where the power supply is not capable of supplying the power required for the device. It may boot, but when doing something more intensive, it will reset and possibly not reboot.

 

[day_trippr]

[...]My pi is mounted on the pack of the screen and is fed from the screen itself via a usb.....

And right there is your problem. Many hubs can't provide sufficient power to keep even a Zero-W alive.
Use a dedicated wall wart style power supply...

Cheers!

 

[day_trippr]

I knew this kick was coming. Tapped this keg a month ago so I did a quick check of the database for any ghost pours.
Found just one (couple of ounces), deleted it, then pulled the last pour. Pretty tight!

Cheers!

 

[pjpiranha]

Hello, I have the @RandR+ version installed and operating quite nicely. I cannot for the life of me find where the feature for importing a beer using Beersmith XML format is actually implemented. I can see that others have been doing it but how?

Thanks

 

[Roadrune]

In the "Beers" tab, import xml at the bottom.

Edit: "Add a beer with XML" is the button.

 

[pjpiranha]

In the "Beers" tab, import xml at the bottom.

Edit: "Add a beer with XML" is the button.

Thanks for that, I thought it was for importing Beer Styles not Beers (Doh!) anyway tried it out (with a file from the BeerXML wiki page) and the page went blank and hung there forever. Looking in the apache logfile I see the following error.

[Sun May 16 11:52:10.634422 2021] [php7:error] [pid 1473] [client 192.168.1.2:39334] PHP Fatal error: Uncaught Error: Call to undefined function simplexml_load_file() in /var/www/html/admin/includes/upload_beer.php:46\nStack trace:\n#0 {main}\n thrown in /var/www/html/admin/includes/upload_beer.php on line 46, referer: http://192.168.1.30/admin/beer_form_xml.php

Any clues as to why this is failing?

Thanks

 

[pjpiranha]

Thanks for that, I thought it was for importing Beer Styles not Beers (Doh!) anyway tried it out (with a file from the BeerXML wiki page) and the page went blank and hung there forever. Looking in the apache logfile I see the following error.

[Sun May 16 11:52:10.634422 2021] [php7:error] [pid 1473] [client 192.168.1.2:39334] PHP Fatal error: Uncaught Error: Call to undefined function simplexml_load_file() in /var/www/html/admin/includes/upload_beer.php:46\nStack trace:\n#0 {main}\n thrown in /var/www/html/admin/includes/upload_beer.php on line 46, referer: http://192.168.1.30/admin/beer_form_xml.php

Any clues as to why this is failing?

Thanks

I'll answer my own problem, seems the PHP environment was not properly set. So reloaded the correct php module with:
48 php --version
49 sudo apt-get install php7.3-xml
50 sudo systemctl reload apache2
51 php -m | grep -i simple

Now getting "Invalid XML

Error log gives:
[Sun May 16 12:32:12.306174 2021] [php7:warn] [pid 676] [client 192.168.1.2:42504] PHP Warning: simplexml_load_file(): /tmp/phpGgO5Bx:229: parser error : xmlParseEntityRef: no name in /var/www/html/admin/includes/upload_beer.php on line 46, referer: http://192.168.1.30/admin/beer_form_xml.php
[Sun May 16 12:32:12.306287 2021] [php7:warn] [pid 676] [client 192.168.1.2:42504] PHP Warning: simplexml_load_file(): <CATEGORY>Bitter & English Pale Ale</CATEGORY> in /var/www/html/admin/includes/upload_beer.php on line 46, referer: http://192.168.1.30/admin/beer_form_xml.php
[Sun May 16 12:32:12.306313 2021] [php7:warn] [pid 676] [client 192.168.1.2:42504] PHP Warning: simplexml_load_file(): ^ in /var/www/html/admin/includes/upload_beer.php on line 46, referer: http://192.168.1.30/admin/beer_form_xml.php

Any thoughts?

 

[pjpiranha]

Again - i'll answer my own idiotic question. The format was wrong, using the correct BeerXML stucture works perfectly.

 

[pjpiranha]

Tried to add some Accolades but not having any luck.

This is my screen before i do anything (just hit the Accolades button) --^

This is what I entered to try to add an accolade --^

This is what happens once i've hit the save button --^

Naturally, when i try to apply an accolade to a Beer - there is nothing to choose from in the drop-down.

Any help appreciated.
Thanks

 

[RandR+]

Tried to add some Accolades but not having any luck.

After trying it out, I see that the rank is Silver but RPints expects rank to be a number.

Not sure if I should just force number entry or allow any text in the ranking column....

 

[scubatech]

Trying to run RPints without RPi. Loaded RandR+ fork and feel like I'm in the home stretch (so cheers to that) but get the below error. BTW, I am not using flow monitors, so I don't know if that's relevant. Very new at this and after a week of combing through 182 pages of this topic I'm ready to wave the white flag.

Validating Entries...Success!
Checking DB connectivity...Success Connecting to Database!
Checking config folder permissions...Success!
Update config files...Success!
Update admin config files...Success!
Creating RPints database...Success!
Creating RPints database user...Success!
Running Database Script...error in query 70[CREATE OR REPLACE VIEW vwIoHardwarePins AS (SELECT CASE WHEN tc.flowPin < 0 T] [Table 'raspberrypints.gastanks' doesn't exist]

**UPDATE**
Apparently it didn't matter because I was able to make it to the login page but now am unable to login. I'm using the admin username and the password I created in myphpadmin but its not being recognized.

 

[RandR+]

CREATE OR REPLACE VIEW vwIoHardwarePins AS (SELECT CASE WHEN tc.flowPin < 0 T

Thats my bad, Im working on committing my update and had bad sql. Rerun the installer to get it to work correctly. Or wait a bit till i finish committing my update to get the very latest

Apparently it didn't matter because I was able to make it to the login page but now am unable to login. I'm using the admin username and the password I created in myphpadmin but its not being recognized.

Did in encrypt the password when you inserted it?

 

[scubatech]

Thats my bad, Im working on committing my update and had bad sql. Rerun the installer to get it to work correctly. Or wait a bit till i finish committing my update to get the very latest


Did in encrypt the password when you inserted it?

I don't think it encrypted it but not sure. When I installed XAMPP I immediately went to the control panel and opened myphpadmin to change the password. Everything was working but now I'm just getting this error page.

**UPDATE**
Not sure what I did but it's working now....albeit with a few errors at the top.

 

[RandR+]

I don't think it encrypted it but not sure. When I installed XAMPP I immediately went to the control panel and opened myphpadmin to change the password. Everything was working but now I'm just getting this error page.

Unfortunately i am not sure what password you changed.

The one needed to log into Rpints is in the users table. If you change any other passwords most likely you change phpmyadmin and broke that. The installer should set that all up for you out of the box

 

[Tobor_8thMan]

Trying to run RPints without RPi. Loaded RandR+ fork and feel like I'm in the home stretch (so cheers to that) but get the below error. BTW, I am not using flow monitors, so I don't know if that's relevant. Very new at this and after a week of combing through 182 pages of this topic I'm ready to wave the white flag.

Validating Entries...Success!
Checking DB connectivity...Success Connecting to Database!
Checking config folder permissions...Success!
Update config files...Success!
Update admin config files...Success!
Creating RPints database...Success!
Creating RPints database user...Success!
Running Database Script...error in query 70[CREATE OR REPLACE VIEW vwIoHardwarePins AS (SELECT CASE WHEN tc.flowPin < 0 T] [Table 'raspberrypints.gastanks' doesn't exist]

**UPDATE**
Apparently it didn't matter because I was able to make it to the login page but now am unable to login. I'm using the admin username and the password I created in myphpadmin but its not being recognized.

View attachment 729492

No flow meters then why not use my version of RPints?

 

[scubatech]

Thanks, I'll give it a shot.

 

[Tobor_8thMan]

Thanks, I'll give it a shot.

the RandR install allows one to pick my version to use.

 

[Blade_Beam]

RanR+, this is a little request and I don't know if it's possible, but I started kegging wine for my wife and I was wondering if it would be possible to add colors or SRM values to coordinate those wine colors as well on the tap list. My OCD is going crazy not being able to make a red wine red on the taplist.