[Version 2 Release] RaspberryPints - Digital Taplist Solution

[RandR+]

As mentioned before most of the fonts are set in styles.css in the root of the webpage

There may be some element styles in /includes/beerListTable.php but I dont see any font size information in it.

Also I would like to change where is says Bottles to inside and up next.
Where does one enter the information displayed in that section?

The Bottles title is printed in index.php in the root directory. ~line 252
The bottles information is entered in the admin bottles section admin/bottle_list.php

 

[delium55]

See those tread that will help you. # 2658, #5513, #5556, #6154.


Have a good day.

 

[MightyMouth]

I am looking for some help as I am having trouble getting the flow meter working properly.

I have connected my Uno via USB to the Pi. In the Pi Arduino IDE I select port ttyACM0 and run the Serial Monitor, it keeps showing random letters like ukttttttttttataaaaaaaaaaatttttttttatCtttStattae from the word StatusCheck interspersed with StatusCheck;.

If I blow into the Flow Meter I shortly after get something like U;-1;3;xxxx where xxxx will be a 4 digit number that seems to be bigger the longer I blow and sometimes if I blow for 20 or 30 seconds I will get a few of these one after another.

I have selected PIN 3 for the Taps Flow Pin setting on Raspberrypints and connected the flow meter to 5v, gnd and PIN 3.

I did get one update in all my testing in the Analytics Pours Page but that was for 22,478.26ml and so was ignored but subsequent attempts blowing more or less doesn't seem to equate to any update of the pours. /var/log/rpints.log currently shows

2022-05-28 16:49:21 RPINTS: No such device - Sleeping to try again 2022-05-28 16:49:26 RPINTS: Could not import RFID Reader, RFID disabled. Assuming SPI not installed/configured 2022-05-28 16:49:36 RPINTS: starting WS server 2022-05-28 16:49:36 RPINTS: starting device monitors... 2022-05-28 16:49:36 RPINTS: starting command server 2022-05-28 16:49:36 RPINTS: starting fan control 2022-05-28 16:49:36 RPINTS: Fan Control fanControl1 is Running 2022-05-28 16:49:36 RPINTS: Not Configured to run Fan 2022-05-28 16:49:37 RPINTS: 1Wire Temperature Thread 1 is Running ('Unexpected error:', <class 'serial.serialutil.SerialException'>) Traceback (most recent call last): File "/var/www/html/python/FlowMonitor.py", line 308, in monitor msg = self.readline_notimeout(False) File "/var/www/html/python/FlowMonitor.py", line 85, in readline_notimeout c = self.arduino.read(1) File "/usr/lib/python2.7/dist-packages/serial/serialposix.py", line 501, in read 'device reports readiness to read but returned no data ' SerialException: device reports readiness to read but returned no data (device disconnected or multiple access on port?) 2022-05-28 16:56:17 RPINTS: flowmonitor aborted, restarting... 2022-05-28 16:56:18 RPINTS: 1Wire Temperature Thread 1 is Running 2022-05-28 16:57:04 RPINTS: serial connection stopped... 2022-05-28 16:57:05 RPINTS: flowmonitor aborted, restarting... 2022-05-28 16:57:16 RPINTS: serial connection stopped... 2022-05-28 16:57:17 RPINTS: flowmonitor aborted, restarting... 2022-05-28 16:57:29 RPINTS: serial connection stopped... 2022-05-28 16:57:30 RPINTS: flowmonitor aborted, restarting... 2022-05-28 16:58:02 RPINTS: serial connection stopped... 2022-05-28 16:58:03 RPINTS: flowmonitor aborted, restarting... 2022-05-28 16:58:26 RPINTS: serial connection stopped... 2022-05-28 16:58:27 RPINTS: flowmonitor aborted, restarting... 2022-05-28 16:58:34 RPINTS: serial connection stopped... 2022-05-28 16:58:35 RPINTS: flowmonitor aborted, restarting... 2022-05-28 16:58:40 RPINTS: serial connection stopped... 2022-05-28 16:58:41 RPINTS: flowmonitor aborted, restarting... 2022-05-28 16:59:06 RPINTS: serial connection stopped... 2022-05-28 16:59:07 RPINTS: flowmonitor aborted, restarting...

Please help

Thanks

 

[MightyMouth]

OK I have replaced the USB Cable and I seem to be getting fewer errors and service restarts, also calibrated the Count per litre which changed it from 23 which was a guess of mine to 1323 so now a 10 second blow registers about 1.5l. Obviously I will have to re-calibrate with liquid once I have everything in place. My question now is how often and how quickly should pours be registered as mine seem to take an age to register and where can I change these settings if at all? Also is there a minimum pour setting and where can I change it?

 

[MightyMouth]

It can use any Arduino board. I have not heard of it being done with just a Raspberry Pi though.

It would be so much more convenient to be able to not have to use an Arduino board. How hard would it be to incorporate this code or similar into Raspberrypints?

 

[Roadrune]

Ok, had my Rpints running just long enough to have forgotten absolutely everything about setup...

Changing a keg today and could not connect to the IP so i restarted, and still no luck.

Then i connected a keyboard and a mouse and got in the menu, i saw that the last update was more then a year ago so i clicked "get latest..." and it seemed like nothing happened, after a while by not being able to do anything i pulled the plug, and it rebooted fine, but when Rpints loads i get a white screen, and it looks like i cannot do anything.

Any chance i can save all my settings (kegs) if so, how?

 

[RandR+]

My question now is how often and how quickly should pours be registered as mine seem to take an age to register and where can I change these settings if at all? Also is there a minimum pour setting and where can I change it?

They should register pretty quickly if you dont have a long timeout when the pour stops the settings under the tap list control this: pour message delay defaults to 300 millisecondsm Pour Trigger Count is the minimum number of pulses for it to record a pour.

How hard would it be to incorporate this code or similar into Raspberrypints?

Probably not too hard, as I already have logic in Rpints to use MQTT it would just be add in a setting for just using the PI, but I like the Arduino board as it keeps the pins on the pi open for other things (like RFID or fans)

 

[RandR+]

Any chance i can save all my settings (kegs) if so, how?

Is Pi OS loading? Can you get to the database? If so you can create a backup that way and continue on.

RPints has a built in backup feature but if you cant get RPints to load then you need to manually create the backup see:
https://mariadb.com/kb/en/incremental-backup-and-restore-with-mariabackup/
Though a few months ago my system became so corrupt i had to manually pull the files from the SD card and manual recover them to a different database then restore that back to a fresh pi (I did have a clone of the SD card that worked but it was a few months old so I wanted to save my latest data)

 

[beerNbikes]

Though a few months ago my system became so corrupt i had to manually pull the files from the SD card and manual recover them to a different database then restore that back to a fresh pi (I did have a clone of the SD card that worked but it was a few months old so I wanted to save my latest data)

Ooh, there's another feature request - auto remote backups ;-) (just kidding)

 

[Thorrak]

Ooh, there's another feature request - auto remote backups ;-) (just kidding)

If you have any leads on how to build OneDrive backups into a distributed project like this, let me know. I was looking into them awhile back, but OAuth isn't designed for projects that aren't centrally hosted.

 

[beerNbikes]

If you have any leads on how to build OneDrive backups into a distributed project like this, let me know. I was looking into them awhile back, but OAuth isn't designed for projects that aren't centrally hosted.

I have no idea, my googling is possibly worse than my HTML skills.

https://jarrodstech.net/how-to-raspberry-pi-onedrive-sync/
I got this from: MS Onedrive - Raspberry Pi Forums

Like I said, no idea, not tried any of this yet. (I only just got the idea reading RandR+'s post a few minutes ago!

 

[day_trippr]

fwiw, at least with the "classic" R'Pints, there are only a handful of data files that need backing up - the database itself and its log files - and together there's not much space used. Many if not most routers provide a USB port that can accomodate a thumb drive set up as a mini NAS device, which can in turn be exploited by bash scripts on an RPi host. I've been doing this for years, with the only fly in the ointment being Microsoft's insistence in disabling SMB/CIFS client services every 30 days. But that only affects visibility/management via my Windows machines and has no deleterious affects on the actual NAS functionality wrt my fleet of RPi's...

Cheers!

 

[RandR+]

Ooh, there's another feature request - auto remote backup

instead how about OS supported methods like cron jobs that generic for more than the RPints database. Like:
https://www.folio3.com/5-easy-steps-on-scheduling-mysql-database-backup-using-cron

 

[beerNbikes]

instead how about OS supported methods like cron jobs that generic for more than the RPints database. Like:
https://www.folio3.com/5-easy-steps-on-scheduling-mysql-database-backup-using-cron

Cheers for that, I'll have a go at that once I get the remote file push happening.

 

[Roadrune]

Is Pi OS loading? Can you get to the database? If so you can create a backup that way and continue on.

RPints has a built in backup feature but if you cant get RPints to load then you need to manually create the backup see:
https://mariadb.com/kb/en/incremental-backup-and-restore-with-mariabackup/
Though a few months ago my system became so corrupt i had to manually pull the files from the SD card and manual recover them to a different database then restore that back to a fresh pi (I did have a clone of the SD card that worked but it was a few months old so I wanted to save my latest data)

Hi, yes, Pi OS is loading, but when i get the white screen i cannot get back to it...

Cant remember what keys to push to exit Rpints.

 

[RandR+]

Cant remember what keys to push to exit Rpints.

alt + F4 for standard exit,
F11 to get out of full screen

 

[Roadrune]

Thanks, will have a go when i get back home from offshore work.

 

[nicoblu]

So trying to install w/flowmeter
After running curl -L install.rpints.com | sudo bash
reboot, web page fine

log
$ tail -f /var/log/rpints.log
/var/www/html/python/hx711.py:100: SyntaxWarning: "is" with a literal. Did you mean "=="?
if gain is 128:
/var/www/html/python/hx711.py:102: SyntaxWarning: "is" with a literal. Did you mean "=="?
elif gain is 64:
/var/www/html/python/hx711.py:104: SyntaxWarning: "is" with a literal. Did you mean "=="?
elif gain is 32:
Traceback (most recent call last):
File "/var/www/html/python/PintDispatch.py", line 21, in <module>
import SocketServer
ModuleNotFoundError: No module named 'SocketServer'

I can fix those by changing to == int the hx711.py
sudo pip3 install mysqlclient
change SocketServer to socketserver

Then get error for mod_pywebsocket.standalone
sudo pip3 install mod-pywebsocket

Then get to
Traceback (most recent call last):
File "/var/www/html/python/PintDispatch.py", line 26, in <module>
from mod_pywebsocket.standalone import WebSocketServer
File "/usr/local/lib/python3.9/dist-packages/mod_pywebsocket/standalone.py", line 331
except OpenSSL.SSL.SysCallError, (err, message):
^
SyntaxError: invalid syntax

I know site is not SSL so how do I get around this? Or what should I do differently.

Been through a few reinstalls always turns out the same.

Appreciate any help or assistance.

 

[DuncB]

There's quite a lot to read on this thread, I've had a look at the raspberry pints web page and have installed Raspberry pi os called
bullseye on my 3b+. From reading post 7606 by @RandR+ I suspect I'm doomed and can't currently install raspberry pints.
It was one of the reasons that I got the pi but also to run kodi / watch content and use brewfather in the bar room next to the brewery.
I will wait patiently for a reworking if needed as there's been quite a lot of code change I believe from Buster to Bullseye.
Keep up the good work it's a great program by the looks of it.

 

[RandR+]

Been through a few reinstalls always turns out the same.

Appreciate any help or assistance.

From those errors it looks like you are trying to use python 3.0 which RPints is not compatible with yet, I have a start on upgrading it but I just havent made time to finish it.

If running Bullseye OS version you cannot use Python 2.7

 

[DuncB]

From those errors it looks like you are trying to use python 3.0 which RPints is not compatible with yet, I have a start on upgrading it but I just havent made time to finish it.

If running Bullseye OS version you cannot use Python 2.7

This answers my question as well thank you, I'll wait patiently.

 

[nicoblu]

From those errors it looks like you are trying to use python 3.0 which RPints is not compatible with yet, I have a start on upgrading it but I just havent made time to finish it.

If running Bullseye OS version you cannot use Python 2.7

It is python 3.x

I realized at some point it was likely the issue. Saw @DuncB post and confirmed. Not sure how I missed the one a dozen or so before but I have been through alot of this thread. Needs a place of its own with several threads. Installation, issues, feature requests etc..

Anyway I was hoping someone had some ideas. I have been altering the scripts as I find issues trying to make it work.


I do like what I have been playing with and appreciate how you @RandR+ and others have kept it alive.

 

[RandR+]

It is python 3.x

This answers my question as well thank you, I'll wait patiently.

I got the main pieces committed to make RPints.
Mainly converting mod_pywebsocket to be python2.7 and python3 compatible.

I still need to install the latest OS on my PI and run the installer. I believe there will be some dependency changes I need to make in the installer and the rest of the python, but feel free to try it on yours and report any other python issues you have

 

[SimKow]

Nevermind -- deleted post

 

[RandR+]

Anyone know how to remove the Accolades column?

you found a bug with the vertical tap list display. Instead of removing the column that configuration would just show/hide accolade title.
Use the customize tap display under Personalize to show/hide columns (also you can drag and drop them to where you want them to be)

I removed that config now to prevent future confusion

 

[waynerob11]

I am setting up Raspberry Pints for the first time and have loaded and configured Buster, and have followed the installation routine to install Raspberry Pints with changes to Mysql to mariadb, and from php 5 to php 7 and have finally got to the setup screen.
Once completed I get this message:-

"Validating Entries...Success!
Checking DB connectivity...
Warning: mysqli_connect(): (HY000/2002): No such file or directory in /var/www/html/install/includes/configprocessor.php on line 52
Success!
Checking config folder permissions...Success!

Cannot connect the the database using the supplied information.

Please press the back button on your browser to fix these errors."

Any advice on how to fix this.

I have redownloaded the LAMP stack but it says I have the latest versions installed.

 

[day_trippr]

Yes it is, I am still trying to make updates to it though much slower now days.

The official website is out of date, and the original code does not work on the latest raspbian systems.

My version works up buster (bullseye removes python 2.7 support and some dependency are only available there i started working to get them updated to python 3 but havent made time to finish yet)

So after you install Buster on a pi open the terminal and run
curl -L https://raw.githubusercontent.com/rtlindne/RaspberryPints/master/util/installRaspberryPints | sudo bash

this will launch an install script that will install all the dependencies you need and walk you through the setup of RPints.

I recommend you do ^that^...

Cheers!

 

[RandR+]

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /var/www/html/install/includes/configprocessor.php on line 52
Success!

Yes do

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

I'm guessing you are trying to use the original, the original doesn't work past Jessie because php deprecated mysql calls in favor of mysqli calls. Tobor's version and my version both support Buster. Im working on Bullseye for some reason it seems like the Arduino isnt getting messages from the python and thats the last thing to work out

 

[waynerob11]

I recommend you do ^that^...

Cheers!

That worked a treat - thank you very much

 

[esdill]

My SD card died a few days ago, I inserted my backup SD card (unfortunately it was very old), I ran all the update and upgrades, then ran the RPints install script. Everything is up and running just fine, except for the motion detector. The log shows this:

The motion detector is still attached to pin 26 (CE1) just as it was when it was working properly, and i have entered 26 as the pin number in the configuration.

Any ideas how to get it working again?