[Version 2 Release] RaspberryPints - Digital Taplist Solution

[Tobor_8thMan]

I helped test Lee B's installation script and thus have your code running sans flow meters on one of my test beds (a 3B+, fwiw).
Tbh after that I had pretty much given this path up as the lack of flow meter support is a total show-stopper. But if you're willing to try to get that working I'm willing to test whatever you come up with...

Cheers!

Even though I don't use flow meters I updated the flow meter code for the latest everything (at least in regard to the latest php, OS, etc).

 

[edost]

admin/includes/managers/tap_manager.php hasn't had mysql_query replaced on line 75.


Dave

v2.0.5 wasn't merged into master yet. If you select branch v2.0.5 (scroll all the way to the bottom), it's fixed in there.

 

[edost]

Even though I don't use flow meters I updated the flow meter code for the latest everything (at least in regard to the latest php, OS, etc).

There were a ton of updates that were never merged into the master repo on the rpints github. When I did a quick compare with the zip file that you had attached, I don't think these were included in your version.

I started with their latest when I did mine. I think if we somehow merged both of our efforts together, we'd have a pretty workable solution.

Here's my latest right now for reference: https://github.com/ericdost/RaspberryPints/tree/v2.0.5

 

[Tobor_8thMan]

There were a ton of updates that were never merged into the master repo on the rpints github. When I did a quick compare with the zip file that you had attached, I don't think these were included in your version.

I started with their latest when I did mine. I think if we somehow merged both of our efforts together, we'd have a pretty workable solution.

Here's my latest right now for reference: https://github.com/ericdost/RaspberryPints/tree/v2.0.5

What files were changed and what are the changes in v2.0.5? I made numerous changes to the code. It'll take too long comparing, finding differences and mitigating if, for example, the file in v2.0.5 is simply old code.

 

[edost]

How about we use RandR's GitHub repo? There's a ton of changes there including the new BJCP styles. We can add documentation and the install script there and see what else needs to be done.

https://github.com/rtlindne/RaspberryPints

 

[Tobor_8thMan]

How about we use RandR's GitHub repo? There's a ton of changes there including the new BJCP styles. We can add documentation and the install script there and see what else needs to be done.

https://github.com/rtlindne/RaspberryPints

Unless he's used my update from January 2019 the code will not run in the newest OS/php

 

[RandR+]

Unless he's used my update from January 2019 the code will not run in the newest OS/php

I haven't got to test my version on the latest OS but it should work, I updated the original code to use the mysqli calls long ago.

 

[Tobor_8thMan]

T

I haven't got to test my version on the latest OS but it should work, I updated the original code to use the mysqli calls long ago.

Then why last January didn't you let people know an updated version was available? People were asking as the unmodified RP was failing in the new Debian/php. This is why Kal and I took on the project of updating the RP code. In addition I cleaned up a lot of sloppy RP code.

 

[RandR+]

Then why last January didn't you let people know an updated version was available?

Im sorry you missed it, but Ive been posting my version for some time now.
The big thing is that people don't like how many changes I made to the original instead of just replacing mysql with mysqli

one example post
https://www.homebrewtalk.com/forum/...-taplist-solution.487694/page-93#post-8378889

Kal acknowledge my version back here
https://www.homebrewtalk.com/forum/...-taplist-solution.487694/page-98#post-8478810

 

[Tobor_8thMan]

Im sorry you missed it, but Ive been posting my version for some time now.
The big thing is that people don't like how many changes I made to the original instead of just replacing mysql with mysqli

one example post
https://www.homebrewtalk.com/forum/...-taplist-solution.487694/page-93#post-8378889

Kal acknowledge my version back here
https://www.homebrewtalk.com/forum/...-taplist-solution.487694/page-98#post-8478810

And that's why Kal and I decided to go with the original Raspberry Pints due to the version mentioned in the posts deviating too much from the original.

 

[snarf7]

Started setting up my Pi today, ran into immediate issues with versions. Apparently the latest version is 'Buster' which just got released but I ran into issues with the LAMP install.

So simple question, if I want to make this as painless as possible what are the versions I should be targetting for OS, RP, LAMP etc? Please be specific, I don't care if I'm not on the latest greatest versions of things, I just want this to work without having to fight with it for weeks. Thanks

 

[RandR+]

The last version of stretch worked great. I used this packages when installing:
apache2 mariadb-server php php-mysql libapache2-mod-php phpmyadmin chromium-browser git ttf-mscorefonts-installer x11-xserver-utils unclutter vim

And if using flow meters you also need arduino python-serial python-mysqldb php-cli xdotool dos2unix python-mod-pywebsocket i2c-tools

 

[snarf7]

The last version of stretch worked great. I used this packages when installing:
apache2 mariadb-server php php-mysql libapache2-mod-php phpmyadmin chromium-browser git ttf-mscorefonts-installer x11-xserver-utils unclutter vim

OK so stretch 1.4.9 looks like the last release on 04/08/2019
Let me try that

And if using flow meters you also need arduino python-serial python-mysqldb php-cli xdotool dos2unix python-mod-pywebsocket i2c-tools

I am using the swiss flow meters, but whats with the arduino stuff? I don't have any of that hardware, just a Pi 3 B+

And what version of Raspberry Pints should I be targetting in Git for this?

thanks for the help dude!

 

[RandR+]

whats with the arduino stuff

Raspberry pints uses Arduino to count the pulses from the meters. Originally it used the Alamode board but many just use a Uno.

Git for this

You can use either Tobor's version (much like the original)
https://www.homebrewtalk.com/forum/attachments/raspberrypints-2-1-0-000-zip.629862/

or my version (much different then the original but easier to use imo)
https://github.com/rtlindne/RaspberryPints

or edost also has a version he is trying to get back into the original
https://github.com/ericdost/RaspberryPints

on a side note you can run the following command to run my install script which will install all packages you need, prompt you what version you want to run, and setup the database for you.
curl -L https://raw.githubusercontent.com/rtlindne/RaspberryPints/master/util/installRaspberryPints | sudo bash

if you do run my script let me know if you have any errors

 

[day_trippr]

The need for an Arduino should not surprise you after this reply to your "no fail grocery list" request...

Cheers!

 

[snarf7]

The need for an Arduino should not surprise you after this reply to your "no fail grocery list" request...

Cheers!

hhmmm, how did I miss that? lol...so is the UNO R3 fine for this?

OK so in a nutshell, explain to me how this is all connected...is the Arduino UNO connected via the GPIO pins on the Pi? So it's just an input device that is capturing pulses and passing them along?

 

[day_trippr]

The Uno is usually attached via USB to the RPi, though some of us are using alternatives (eg: connecting via Bluetooth using an HC-05 or WiFi via an ESP8266, either solution using the Uno rx/tx GPIO pins)...

Cheers!

 

[snarf7]

The Uno is usually attached via USB to the RPi, though some of us are using alternatives (eg: connecting via Bluetooth using an HC-05 or WiFi via an ESP8266, either solution using the Uno rx/tx GPIO pins)...

Cheers!

OK usb is easy peasy, I'll order it now...no specific version needed right? on amazon its listed as an R3

 

[snarf7]

on a side note you can run the following command to run my install script which will install all packages you need, prompt you what version you want to run, and setup the database for you.
curl -L https://raw.githubusercontent.com/rtlindne/RaspberryPints/master/util/installRaspberryPints | sudo bash

if you do run my script let me know if you have any errors

I'll definitely give it a whirl for you. Do I still need to do the initial steps for the PI setup where I do sudo apt-get update and sudo apt-get upgrade and install any LAMP stuff or does your script do all that as well?

thanks, much obliged for the help

 

[RandR+]

sudo apt-get update and sudo apt-get upgrade and install any LAMP stuff or does your script do all that as well?

everything should be done by my script.

 

[snarf7]

everything should be done by my script.

No errors and I have the test data page loading up... so far so good
Now I just gotta wait until the flow meters get here and I can finish it up

thanks

 

[day_trippr]

The current crop of genuine and clone UNOs are all "R3". And if you look around you can find really cheap (like, $5) UNO R3 clones that use the same Atmel Mega16U2 USB/serial bridge chip instead of the CH340/341 that can require extra attention to use...

Cheers!

 

[snarf7]

The current crop of genuine and clone UNOs are all "R3". And if you look around you can find really cheap (like, $5) UNO R3 clones that use the same Atmel Mega16U2 USB/serial bridge chip instead of the CH340/341 that can require extra attention to use...

Cheers!

Roger that, got it ordered now...I guess the bonus of this is I can actually program in C languages pretty well so any Arduino stuff will be easy for me

 

[JonBrewsBeer]

Raspberry pints uses Arduino to count the pulses from the meters. Originally it used the Alamode board but many just use a Uno.


You can use either Tobor's version (much like the original)
https://www.homebrewtalk.com/forum/attachments/raspberrypints-2-1-0-000-zip.629862/

or my version (much different then the original but easier to use imo)
https://github.com/rtlindne/RaspberryPints

or edost also has a version he is trying to get back into the original
https://github.com/ericdost/RaspberryPints

on a side note you can run the following command to run my install script which will install all packages you need, prompt you what version you want to run, and setup the database for you.
curl -L https://raw.githubusercontent.com/rtlindne/RaspberryPints/master/util/installRaspberryPints | sudo bash

if you do run my script let me know if you have any errors

Hi RandR thank you for the link - i have managed to fully install the pints onto my Pi. however i am having issues logging into the system now,i have tried all the password/logins that i used during setup and no success. any idea if i can resolve this, or do i re-install and take more careful notice of what is happening - was disctracted with parenting duties at the time of install

 

[edost]

Have you tried username admin @JonBrewsBeer ?

Edit: And if that doesn't work you should be able to just delete the contents of /var/www/html and re-run the script:

sudo rm -r /var/www/html

 

[AI6K]

RaspberryPints/RaspberryPints
(Can be found in conn.php)

Sorry, that's for phpmyadmin.

There was no username in my database, but there was an entry.

I then went on-line to find an md5 hash generator, gave it a username of admin and my password, then entered the hash in phpmyadmin.


Dave

 

[RandR+]

however i am having issues logging into the system now,i have tried all the password/logins that i used during setup and no success. any idea if i can resolve this, or do i re-install and take more careful notice of what is happening - was disctracted with parenting duties at the time of install

Assuming you put the database on the pi,
On the pi, from the terminal run
sudo mysql
show databases;

you should see that database name you used, if not there is a problem

run the following
use <DATABASENAME>;
select userName from users;

that should return all users in the system, if no rows are returned that is the problem.
hopefully you see the username you expected. If so then reset the password to admin:
update users set password = '21232f297a57a5a743894a0e4a801fc3'


Let me know if you get an errors or unexpected results

 

[daveMN]

I just installed this using RandR+'s installation script, and it worked great. I installed it on a RPi 2B running NOOBS. I have zero programming experience, but was able to navigate the install. Great job!

A note on the admin username and password above, I didn't have a username in MariaDB, and couldn't figure out how to add one, so I left the username and password blank and was able to get in to set up Raspberry Pints.

 

[day_trippr]

Which NOOBs version did you use? Stretch or Buster?

Cheers!

 

[AI6K]

I just used the curl/script, installed RandR+ version on Pi 4 (4GB) running Buster, and it appears to be working fine so far.


Dave

 

[day_trippr]

Thanks for that. Sounds encouraging!
Will you be running flow meters?

Cheers!

 

[AI6K]

I don't have a keezer/kegerator yet. I'm still assembling all the parts.


Dave

 

[daveMN]

Which NOOBs version did you use? Stretch or Buster?

Cheers!

I think it's Buster.

 

[snarf7]

Raspberry pints uses Arduino to count the pulses from the meters. Originally it used the Alamode board but many just use a Uno.

OK I got the Arduino in the mail this weekend, still waiting on my flow meters but I have the Pi all installed from your script. It looks like you have the arduino code on your Git, here:

https://github.com/rtlindne/RaspberryPints/blob/master/arduino/raspberrypints/raspberrypints.ino

is that all I need on the Arduino side? Then I just wire in the meters, connect the arduino to the Pi via USB and good to go?

 

[RandR+]

is that all I need on the Arduino side?...connect the arduino to the Pi via USB and good to go?

Yes that is all you need for the Arduino side.

There is a few configurations you will want to make sure are correct:
in ./python/Config.py make sure there is a line config['flowmon.port' ] = '/dev/ttyACM0' without # infront of it, this indicates to use the USB to talk to the Arduino.

in the tap list page (under Admin) setup the pins for each tap and the pulse count. (There are also some setting dealing with when to register a pour if you click on the settings button on top)

 

[Mellman]

Which flowmeters are you using? I'm trying to determine if I go this route or look at the plaato keg scales. I know in the past the Flow meters had foam issues, curious if there are improved and cheaper ones now

 

[day_trippr]

No foam issues here using a six-pack of SF800 meters...

Cheers!

 

[snarf7]

Yes that is all you need for the Arduino side.

There is a few configurations you will want to make sure are correct:
in ./python/Config.py make sure there is a line config['flowmon.port' ] = '/dev/ttyACM0' without # infront of it, this indicates to use the USB to talk to the Arduino.

in the tap list page (under Admin) setup the pins for each tap and the pulse count. (There are also some setting dealing with when to register a pour if you click on the settings button on top)

OK I'll be sure to verify those as well.

I was reading thru the instructions file in GIT (https://github.com/rtlindne/RaspberryPints/blob/master/instructions.txt) but it does not seem to reflect the current code in the raspberrypints.ino file. Where do I find the updated instructions? Like your example, I have 4 flow meters I'll be setting up so I'm just looking for how to wire it and what to tweak in the ino file, cheers!

 

[daveMN]

One update on my install using RandR 's script, I noticed it didn't disable the screen blanking. I installed xscreensaver and set it to Disable. Hopefully that works.

I think it's Buster.

 

[RandR+]

Where do I find the updated instructions? Like your example, I have 4 flow meters I'll be setting up so I'm just looking for how to wire it and what to tweak in the ino file, cheers

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.