[Version 2 Release] RaspberryPints - Digital Taplist Solution

[mojophojo]

So I'm trying to get flow monitors working and when I look at the rpints log i see this:

2020-07-25 16:23:58 RPINTS: waiting for Arduino to come alive
2020-07-25 16:24:10 RPINTS: Arduino alive...
2020-07-25 16:24:10 RPINTS: getting config data for Arduino
2020-07-25 16:24:10 RPINTS: Arduino config, about to send: C:4:0:0:0:5:0:300:200:30:250:0:0:1|
2020-07-25 16:24:10 RPINTS: Waiting for Config Response
2020-07-25 16:24:10 RPINTS: Arduino says: C:4:0:0:0:5:0:300:200:30:250:0:0:1|

2020-07-25 16:24:10 RPINTS: listening to Arduino
2020-07-25 16:24:10 RPINTS: Sending Status;NOTOK;-1;0;0;0;0;0;|
2020-07-25 16:24:41 RPINTS: unknown message: StatsCheck;
2020-07-25 16:24:42 RPINTS: Sending Status;NOTOK;-1;0;0;0;0;0;|
2020-07-25 16:24:42 RPINTS: unknown message: SatusCheck;
2020-07-25 16:24:43 RPINTS: unknown message: SatusCheck;
2020-07-25 16:24:44 RPINTS: unknown message: SatusCheck;
2020-07-25 16:24:45 RPINTS: Sending Status;NOTOK;-1;0;0;0;0;0;|

I've tried reloading the sketch to the audrino, but no luck. Any idea what's going on with it?

 

[LBussy]

Then i installed Rpints and after reboot the screen is black.

If you are using that as your display I'm pretty sure you want to choose "no display" when installing RPints. I'm not sure how to fix it now - maybe resintall the screen's drivers?

 

[troyp42]

So I'm trying to get flow monitors working and when I look at the rpints log i see this:

2020-07-25 16:23:58 RPINTS: waiting for Arduino to come alive
2020-07-25 16:24:10 RPINTS: Arduino alive...
2020-07-25 16:24:10 RPINTS: getting config data for Arduino
2020-07-25 16:24:10 RPINTS: Arduino config, about to send: C:4:0:0:0:5:0:300:200:30:250:0:0:1|
2020-07-25 16:24:10 RPINTS: Waiting for Config Response
2020-07-25 16:24:10 RPINTS: Arduino says: C:4:0:0:0:5:0:300:200:30:250:0:0:1|

2020-07-25 16:24:10 RPINTS: listening to Arduino
2020-07-25 16:24:10 RPINTS: Sending Status;NOTOK;-1;0;0;0;0;0;|
2020-07-25 16:24:41 RPINTS: unknown message: StatsCheck;
2020-07-25 16:24:42 RPINTS: Sending Status;NOTOK;-1;0;0;0;0;0;|
2020-07-25 16:24:42 RPINTS: unknown message: SatusCheck;
2020-07-25 16:24:43 RPINTS: unknown message: SatusCheck;
2020-07-25 16:24:44 RPINTS: unknown message: SatusCheck;
2020-07-25 16:24:45 RPINTS: Sending Status;NOTOK;-1;0;0;0;0;0;|

I've tried reloading the sketch to the audrino, but no luck. Any idea what's going on with it?

Not sure what your level of expertise is but mines a beginner but Ive been playing around with mine for months and months and heres some stuff that Ive been told that worked in the past..

To get file permissions to change files do this (Aplogies if you know this)

sudo chmod +777 /var/www/html -R



Try this if you havent already..

In /var/www/html/python/FlowMonitor.py change line 225

from

self.arduino = serial.Serial(self.port,9600,timeout=.5)

to

self.arduino = serial.Serial(self.port,115200,timeout=.5)

and save


in the raspberrypints.ino change line 124

from

Serial.begin(9600);

to

Serial.begin(115200);

Then repeat the upload process

Also check this.

go into config.py and uncomment this line..
config['flowmon.port' ] = '/dev/ttyACM0'. (Assuming your using ACM0)

That has both worked for me with a similar error to yours.

 

[RandR+]

2020-07-25 16:24:45 RPINTS: Sending Status;NOTOK;-1;0;0;0;0;0;|

I've tried reloading the sketch to the audrino, but no luck. Any idea what's going on with it?

I have to get better terminology in those messages because that actually is normal. NOTOK is for the RFID reader portion not that there is an issue and I don't have it log out the message over and over because it would fill up the log so you are actually good to go from the sketch and python perspective.

If you try to pour a pint what does the log say? You may need to turn on python debugging to get more information by going to Config.py and changing False#True to just True for the following lines

#logging settings for flowmon
config['flowmon.debug' ] = False#True
#logging settings for pintdispatch
config['dispatch.debug' ] = False#True

 

[RandR+]

"no display" when installing RPints. I'm not sure how to fix it now - maybe resintall the screen's drivers?

if you seleted a screen during install you may need to revert the changes for the monitor by either ssh into the pi or attaching an hdmi monitor/screen to it

in /boot/config.txt
look for hdmi_group and hdmi_mode, the script first comments out lines starting with those and then adds in them back in with the option you choose for the monitor resolution
the same thing is done for display_rotate.
If you have no commented out lines (starts with #) for those and those lines exists try removing them/commenting them out
If you both commented out and uncommented lines try to switch the commented lines (remove starting # and add # to the other)

then finally is the screen blanking settings which are in either
/home/pi/.config/lxsession/LXDE-pi/autostart
or
/etc/xdg/lxsession/LXDE-pi/autostart

comment out or remove
@xset s off
@xset -dpms
@xset s noblank

that will reset the monitor settings, the last setting is starting chromium in kiosk mode which will be in the same file as the screen blanking settings as a line like
@chromium-browser --kiosk localhost

 

[mojophojo]

So I turned on debugging for the python script. Here's what I got in my log:

2020-07-30 15:26:24 RPINTS: unknown message: SatusCheck;
('Unexpected error:', <class 'serial.serialutil.SerialException'>)
Traceback (most recent call last):
File "/var/www/html/python/FlowMonitor.py", line 270, in monitor
msg = self.readline_notimeout()
File "/var/www/html/python/FlowMonitor.py", line 75, 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?)
2020-07-30 15:26:26 RPINTS: flowmonitor aborted, restarting...
2020-07-30 15:26:26 RPINTS: resetting Arduino
2020-07-30 15:26:27 RPINTS: waiting for Arduino to come alive
2020-07-30 15:26:32 RPINTS: serial connection stopped...
2020-07-30 15:26:32 RPINTS: device reports readiness to read but returned no data (device disconnected or multiple access on port?)
2020-07-30 15:26:33 RPINTS: flowmonitor aborted, restarting...
2020-07-30 15:26:34 RPINTS: resetting Arduino
2020-07-30 15:26:35 RPINTS: waiting for Arduino to come alive
2020-07-30 15:26:41 RPINTS: serial connection stopped...

I tested out the flow meter on the arduino using a different sketch to monitor flow, and it worked so the flow meter and arduino hardware seem to be ok.

Hopefully the log can help with troubleshooting.

 

[RandR+]

2020-07-30 15:26:24 RPINTS: unknown message: SatusCheck;

This looks like messages are coming from the Arduino but are getting messed up. Ive seen this if the serial monitor is open.

device reports readiness to read but returned no data (device disconnected or multiple access on port?)

troyp42 had a bad usb cable that was causing this.


Is there anything else running on the PI that could be trying to access the Arduino.

 

[apscherz]

Feature request:

Custom column for accolades. When entering a beer, you could select the number of Gold, silver, bronze, BOS, medals it has won and display that on the screen. How hard would this be?

 

[RandR+]

How hard would this be?

probably not to hard, a couple of tables and html edits. I should have some time this week to knock it out.

 

[apscherz]

probably not to hard, a couple of tables and html edits. I should have some time this week to knock it out.

That would be incredible. Thank you!

 

[RandR+]

That would be incredible. Thank you!

No problem, accolades are in now. Big thanks to @garzlok for the images, I left them on the small side until someone says they should be bigger. Eventual the size will be more configurable

If you rerun my install script it will detect an installation and ask if you want to update. Hit yes and you can add accolades to the beer. You will have to enable the accolade column on the home screen as that is disabled by default (under Configuration hit on for "Show Accolades Col:")

 

[apscherz]

So this happened when I tried to update. Any ideas?

 

[apscherz]

So this happened when I tried to update. Any ideas?

 

[RandR+]

So this happened when I tried to update. Any ideas?

Yes, that is a compare of the your local files to the latest GitHub files so that if you made changes you can see them and recreate them. The newer installer will install kompare which is the graphical version of that.
I think you can just hit cntrl+c to close the compare and continue the update

 

[apscherz]

Yes, that is a compare of the your local files to the latest GitHub files so that if you made changes you can see them and recreate them. The newer installer will install kompare which is the graphical version of that.
I think you can just hit cntrl+c to close the compare and continue the update

I just took a backup of the DB and reinstalled. Works like a champ! Only thing I'd throw out is they don't appear in order of importance (bronze on bottom, BOS on top, etc), but rather by order in which you enter them. I would be nice if they would sort by importance, or give you the ability to move them. Also, a small text description on the display might not be terrible.

Last thing, how hard would it be to make additional fields there? For instance, there's a competition in Texas called Bluebonnet that awards Steins for gold medals, which are highly sought after, it would be cool to put that on there with an avatar of a stein, or similar for other huge competitions.

You guys are making this amazing, and I love RPints, not sure where you are located but I'd be happy to send you some thank you beers if you're interested.

Cheers!

 

[RandR+]

I would be nice if they would sort by importance, or give you the ability to move them. Also, a small text description on the display might not be terrible....
would it be to make additional fields there

I could a ranking to the accolades and sort by that then you can give an accolade the rank you want it.

Probably should have added to the original post about adding them that I treated them like ingredients in that you can add your own and change images/text by going to the admin page on the left under Ingredients there is a link for Accolades. Click that and you can customize them.

If you upload an image the image is used but if you remove the image the name of the accolade is used on the main display (just like tap numbers). I have type and notes for the accolades but they really don't do anything.

 

[apscherz]

I could a ranking to the accolades and sort by that then you can give an accolade the rank you want it.

Probably should have added to the original post about adding them that I treated them like ingredients in that you can add your own and change images/text by going to the admin page on the left under Ingredients there is a link for Accolades. Click that and you can customize them.

If you upload an image the image is used but if you remove the image the name of the accolade is used on the main display (just like tap numbers). I have type and notes for the accolades but they really don't do anything.

Thank you for all the help with this, it's really awesome and I'm excited to start uploading the data. For whatever reason though, I can't seem to create a new accolade, it says successful but refreshes with only the 4 existing medals shown. Any ideas?

 

[RandR+]

l but refreshes with only the 4 existing medals shown. Any ideas?

I had logic that if the name is empty it wont add it, I now set the name to new if the name is empty on save. Also fixed it so the image isn't copied when adding a row.

Also added the rank field to accolades for sorting

You will need to update to get the rank and add new fix.

 

[apscherz]

I had logic that if the name is empty it wont add it, I now set the name to new if the name is empty on save. Also fixed it so the image isn't copied when adding a row.

Also added the rank field to accolades for sorting

You will need to update to get the rank and add new fix.

well... that bricked my raspberry pi :/ got an error:
error 1136 (21501) at line 799: column count doesn't match value count at row 1

when installing the DB. tries to finish the install but just loads a white screen with nothing on it

 

[RandR+]

799: column count doesn't match value count at row 1

forgot to update the create sql to include the rank, fixed now if you reinstall

 

[apscherz]

forgot to update the create sql to include the rank, fixed now if you reinstall

That seemed to do it. Thanks for the quick response. Only thing I see now is that it doesn't launch in Kiosk mode anymore, but maybe I missed something

 

[RandR+]

launch in Kiosk mode anymore, but maybe I missed something

On install did you select a monitor and select it to open in kiosk mode?

 

[apscherz]

On install did you select a monitor and select it to open in kiosk mode?

...no. I cancelled out of that screen hoping to be clever and avoid having to redo my settings to get the screen to fit. When I do it the right way it works lol.

The problem I'm now seeing is this:

If I try to run the "upgrade" option, I get the split screen "illegal file name" error I posted above, hit ctl-C and it cancels the upgrade.
If I backup the DB and do a fresh RPints install, then restore the DB, there's no "Show Accolades Col:" in the configuration tab.

 

[RandR+]

If I try to run the "upgrade" option, I get the split screen "illegal file name" error I posted above, hit ctl-C and it cancels the upgrade.

Install kompare , from the terminal enter
sudo apt-get install kompare

This will bring up a new window instead of doing everything in the terminal. I'm having trouble getting compare to exit when running it from the script.

 

[apscherz]

Install kompare , from the terminal enter
sudo apt-get install kompare

This will bring up a new window instead of doing everything in the terminal. I'm having trouble getting compare to exit when running it from the script.

ok that seemed to work, but when the upgrade completes the accolades section is completely empty

 

[RandR+]

upgrade completes the accolades section is completely empty

try again, found a typo in the update sql

 

[apscherz]

try again, found a typo in the update sql

Ok that worked, and I can upload custom images for the accolades. However, when I try to add it to the beer and click "save" the screen turns white and doesn't apply it to the beer entry

 

[RandR+]

the screen turns white and doesn't apply it to the beer entry

Its working on my test system with latest. Is there any text in the upper left corner? If you give it a minute does it refresh to the beer List page?

can you look at the end of /var/log/apache2/error.log and post that here?

 

[apscherz]

Its working on my test system with latest. Is there any text in the upper left corner? If you give it a minute does it refresh to the beer List page?

can you look at the end of /var/log/apache2/error.log and post that here?

I don't see anything on the page at all. the last couple lines (after I tried doing it again):

[Mon Aug 10 16:42:50.804163 2020] [php7:notice] [pid 6207] [client ::1:47942] PHP Notice: Trying to get property 'untID' of non-object in /var/www/html/includes/functions.php on line 73, referer: http://localhost/admin/beer_form.php?id=5
[Mon Aug 10 16:42:50.804754 2020] [php7:error] [pid 6207] [client ::1:47942] PHP Fatal error: Uncaught Pintlabs_Service_Untappd_Exception: clientSecret not set and is required in /var/www/html/includes/Pintlabs/Service/Untappd.php:87\nStack trace:\n#0 /var/www/html/includes/functions.php(74): Pintlabs_Service_Untappd->__construct(Array)\n#1 /var/www/html/admin/beer_form.php(57): beerRATING(Array, '', false)\n#2 {main}\n thrown in /var/www/html/includes/Pintlabs/Service/Untappd.php on line 87, referer: http://localhost/admin/beer_form.php?id=5

 

[apscherz]

Nevermind, I got it. The untappd stuff clicked for me. Removed the name and it worked. I'm going to go through and update everything. Thank you, Thank you Thank you! Sorry, I know I've probably been quite annoying with this but I really appreciate it.