[Version 2 Release] RaspberryPints - Digital Taplist Solution

[RandR+]

simple question. I have my pi up and running and when i try to access it over the network with another computer at is ip address 192.168.1.XXX brings me to the Apache2 Debian default page. Do i need to install something to be able to access the desktop remotely?

I use teamviewer to remote to the desktop.
See https://www.teamviewer.com/en-us/download/linux/ for more information, the link to the pi version is buried on the right side of the page so here is the direct link https://download.teamviewer.com/download/linux/teamviewer-host_armhf.deb

 

[Car Ramrod]

Not Found.

 

[Car Ramrod]

I use teamviewer to remote to the desktop.
See https://www.teamviewer.com/en-us/download/linux/ for more information, the link to the pi version is buried on the right side of the page so here is the direct link https://download.teamviewer.com/download/linux/teamviewer-host_armhf.deb

Do you find it better than Chrome remote desktop.

 

[RandR+]

Do you find it better than Chrome remote desktop.

Yes, my experience with chrome remote desktop is limited, but I cant transfer files to the remote computer with the version I am using

 

[Tobor_8thMan]

Or delete /var/www/html/index.html

 

[Car Ramrod]

RandR+ , i reran your script on a fresh card without doing the updates upon the initial startup. Looks like it almost got done but has this hiccup.

Load Test Data into RaspberryPints? (default is: Y):
Loading Test Data
ERROR 1064 (42000) at line 86: 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 'FROM kegs k LEFT JOIN kegTypes kt ON kt.id = k.kegTypeId WHERE k.beerId IS NOT N' at line 3
pi@raspberrypi:~ $



I can access the GUI. Do i need to fix anything with that load test data error?

 

[RandR+]

ERROR 1064 (42000) at line 86: 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 'FROM kegs k LEFT JOIN kegTypes kt ON kt.id = k.kegTypeId WHERE k.beerId IS NOT N' at line 3

Sorry about that, I tested a few times but a rogue comma got committed when I moved all the keg data to the keg object so if it is untapped the current amount stays with it.

I would use phpmyadmin (open browser to http://localhost/phpmyadmin/) to run the following sql statements to complete loading:

INSERT INTO taps(`kegId`, `tapNumber`, `active`, `createdDate`, `modifiedDate`)
SELECT kegs.id as kegId, kegs.onTapId as tapNumber, 1 as active, NOW() as createdDate, NOW() as modifiedDate
FROM (SELECT k.* FROM kegs k LEFT JOIN kegTypes kt ON kt.id = k.kegTypeId WHERE k.beerId IS NOT NULL AND k.onTapId IS NOT NULL ORDER BY Id) as kegs;
UPDATE kegs k INNER JOIN kegTypes kt ON kt.id = k.kegTypeId SET startAmount=kt.maxAmount, maxAmount=kt.maxAmount, currentAmount=kt.maxAmount
WHERE k.beerId IS NOT NULL AND k.onTapId IS NOT NULL;
UPDATE `config` SET configValue='10' WHERE configname='numberOfTaps';

 

[Car Ramrod]

Sorry about that, I tested a few times but a rogue comma got committed when I moved all the keg data to the keg object so if it is untapped the current amount stays with it.

I would use phpmyadmin (open browser to http://localhost/phpmyadmin/) to run the following sql statements to complete loading:

INSERT INTO taps(`kegId`, `tapNumber`, `active`, `createdDate`, `modifiedDate`)
SELECT kegs.id as kegId, kegs.onTapId as tapNumber, 1 as active, NOW() as createdDate, NOW() as modifiedDate
FROM (SELECT k.* FROM kegs k LEFT JOIN kegTypes kt ON kt.id = k.kegTypeId WHERE k.beerId IS NOT NULL AND k.onTapId IS NOT NULL ORDER BY Id) as kegs;
UPDATE kegs k INNER JOIN kegTypes kt ON kt.id = k.kegTypeId SET startAmount=kt.maxAmount, maxAmount=kt.maxAmount, currentAmount=kt.maxAmount
WHERE k.beerId IS NOT NULL AND k.onTapId IS NOT NULL;
UPDATE `config` SET configValue='10' WHERE configname='numberOfTaps';

Before you replied i ended up wiping my card and starting over. By the time that was done you had replied and i figured you corrected the mistake because i re ran the script and it completed. I did mention about plugging in the alamode but a restart was needed. It didnt not mention anything about using an UNO. My plan is to follow this procedure to use the Uno instead of the alamode. Am i correct with this assumption?

https://www.homebrewtalk.com/forum/...-taplist-solution.487694/page-55#post-7722587

 

[RandR+]

My plan is to follow this procedure to use the Uno instead of the alamode. Am i correct with this assumption?

https://www.homebrewtalk.com/forum/...-taplist-solution.487694/page-55#post-7722587

Config for uno moved on my version, its now in python/Config.py. Remove the # at the start of line 9 (uncomment) to set it up to use the uno

 

[Car Ramrod]

Ok. I really don't know what I'm doing when it comes to programing. So go easy on me. Trying to edit the config, it's now allowing me to save. I don't know how to edit via the terminal.

i read through the thread and tried doing sudo nano /var/www/html/python/config.py

and it brings up the nano editor but it looks blank. while when i open it as a text file i see the information im looking for. just cant edit.

 

[RandR+]

i read through the thread and tried doing sudo nano /var/www/html/python/config.py

Linux (which is the bases of raspbian) is case sensitive, you need sudo nano /var/www/html/python/Config.py to make edits

 

[Car Ramrod]

Dang, I cant believe i didnt think to try that.

 

[Car Ramrod]

Linux (which is the bases of raspbian) is case sensitive, you need sudo nano /var/www/html/python/Config.py to make edits

Now im running in to another issue. I dont know how to diagnose problems yet but im getting an error when i try to edit the flow pin and count per gallon on the GUI. the error is "Cannot Execute Query"

 

[ba-brewer]

@Tobor_8thMan @kaljade any updates on the beta testing of the latest Raspberry Pints modified for Debian, php and MariaDB.

 

[RandR+]

the error is "Cannot Execute Query"

Get the latest admin/includes/managers/tap_manager.php
https://raw.githubusercontent.com/r...aster/admin/includes/managers/tap_manager.php

there was an extra ' in the insert to tapconfig

 

[Car Ramrod]

Get the latest admin/includes/managers/tap_manager.php
https://raw.githubusercontent.com/r...aster/admin/includes/managers/tap_manager.php

there was an extra ' in the insert to tapconfig

Hey, when runing your script it alerts you that if your running an alamode to do the 5v jumper. Then it says to reboot but the script will not start back up.

Any direction from here? do i need to run the script again or what?

Also, i hate to be a bother but i guess i am kinda helping you debug your code, but when prompted to boot in incognito kiosk mode, it doesnt when the pi restarts.

ETA: I got the flow meters registering! i was gonna do a write up of all the things i had to do other than the script for you if that is ok to post. Or i can send it to you to go over before i post it. Let me know. I should be able to write it up tomorrow.

 

[RandR+]

Any direction from here? do i need to run the script again or what?

boot in incognito kiosk mode, it doesnt when the pi restarts.
​

ETA: I got the flow meters registering! i was gonna do a write up of all the things i had to do other than the script for you if that is ok to post. Or i can send it to you to go over before i post it. Let me know. I should be able to write it up tomorrow.

The only part after the reboot is motion sensor install, if you are not using motion sensors then you can just ignore. I am doing some updates to move the restart to the end of the script.

I will test on the latest raspbian to see if they changed the config where you specify to start chromium.

Send your write up over to me first, just to make sure it makes sense.

 

[Car Ramrod]

will do. now that i think about it i believe the only changes i had to make was set a static IP and to uncomment the Uno line in the Config.py. Would be nice if that wa a question in the script, but then again, i do not know what that entails in the programming. I believe once that happened the it was recognizing the UNO. ba-brewer helped me turn on the debugging to i could confirm it was working, and then blowing into the meters it was recognized. Im going to go through a fresh install again today so i can familiarize myself more with it and have a back up fresh Install SD.

 

[RandR+]

If chromium is not starting on startup check /etc/xdg/lxsession/LXDE-pi/autostart and very that the chromium command is in it (use the text editor as that wont show anything after the End of file)

From my testing I thought it best to mention some things:
1. You must specify you are using a monitor in my install script and specify you want chromium to start automatically
2. the new config file to put @chromium --kiosk localhost in is /etc/xdg/lxsession/LXDE-pi/autostart the old one was /home/pi/.config/lxsession/LXDE-pi/autostart
3. My first test put '@chromium --kiosk localhost' after some sort of invalid characters in the autostart file and therefore chromium did not start on startup. Though it did work on my second test, not sure of the difference.

 

[Brewing Badger]

If chromium is not starting on startup check /etc/xdg/lxsession/LXDE-pi/autostart and very that the chromium command is in it (use the text editor as that wont show anything after the End of file)

From my testing I thought it best to mention some things:
1. You must specify you are using a monitor in my install script and specify you want chromium to start automatically
2. the new config file to put @chromium --kiosk localhost in is /etc/xdg/lxsession/LXDE-pi/autostart the old one was /home/pi/.config/lxsession/LXDE-pi/autostart
3. My first test put '@chromium --kiosk localhost' after some sort of invalid characters in the autostart file and therefore chromium did not start on startup. Though it did work on my second test, not sure of the difference.

Hi,
I chose "no monitor" in the install script, so that would explain why chromium won't start automatically.
Is there any way to amend this choice now, or do I have to run the scrip again (wich I guess would wipe the changes I have done so far)?
Also, I'm unable to get rid of the list of pours underneath the taplist. Have tried to unhook anything pour related in the admin menu, but stil get the date and time for the pours listed.

I'm also looking for a way to edit the text in the taplist, but I Guess I would have to og into the index and/or styles files for that?

Cheers

 

[RandR+]

The rerunning the script would reset RaspberryPints to default. If you just want chromium to startup automatically add "@chromium --kiosk localhost" (without quotes) to /etc/xdg/lxsession/LXDE-pi/autostart (for latest stretch) or /home/pi/.config/lxsession/LXDE-pi/autostart for older versions

As for the pours, I see that the option to show/hide the date is not displayed: run
update config set showOnPanel = '1' WHERE configName = 'showPourDate';
in the database to add it then you can hide the Date. The Pours header will still be there, I will work on making an overall config to turn off pours.

As far as changing Text what do you want to change? If its column headings then its in includes/beerListTable.php if its the top of the screen its in index.php

 

[DaniFilth]

My flow meter cables aren't very long and i'm wanting connectors on them anyway so they can be removed so what's the best set-up for this and where exactly on the alamode do my cables solder too? Do i just solder them directly onto the board or use a header?
My flow meters have yellow, black and red cables, which cable is which?

 

[Cruz1n]

My flow meter cables aren't very long and i'm wanting connectors on them anyway so they can be removed so what's the best set-up for this and where exactly on the alamode do my cables solder too? Do i just solder them directly onto the board or use a header?
My flow meters have yellow, black and red cables, which cable is which?

I bought this kit https://www.amazon.ca/gp/product/B0744CV3Y5/?tag=skimlinks_replacement-20
to connect to my alamode board then used cat 5 cable to mini 3 pin xlr plug and sockets to connect to my flow meters. I have seen others use a mini board in between also, which is useful to power multiple flow meters depending how many you have.

 

[CadiBrewer]

My flow meter cables aren't very long and i'm wanting connectors on them anyway so they can be removed so what's the best set-up for this and where exactly on the alamode do my cables solder too? Do i just solder them directly onto the board or use a header?
My flow meters have yellow, black and red cables, which cable is which?

Old ethernet cables are great for extending flow meter cables. You'll need to tell us which flow meters you are using so we can help you figure out which wire is 5v, data and GND.

Cut the end off of the ethernet cable. Splice together all of the 5v meter wires to one ethernet wire, all of the GND meter wires to another ethernet wire, and then each individual data wire to a different color ethernet wire. Then cut off the other end of the ethernet cable and use Dupont wires like these https://www.amazon.com/dp/B01EV70C78/?tag=skimlinks_replacement-20 to connect the ethernet wires to the arduino. Cut off one end of the Dupont wires and splice it to the ethernet wire. Use the other end, either a male or female Dupont connector depending on your arduino connection, to connect to the arduino pins. Don't solder the wires directly to the arduino.

 

[DaniFilth]

Thanks both, i'll definitely look into those

I can't find my actual flow meter anymore as i bought them along time ago but they're similar to these, especially the wiring http://rover.ebay.com/rover/1/711-5...0001&campid=5338413729&icep_item=201713728453

 

[DaniFilth]

Haha, typical. After searching and finding nothing i post to you guys then find this "It has three wires namely +5V (Red), GND (Black) and Output (Yellow)"

 

[Andy McKinlay-Clark]

Hi Brains trust, this is my first post having read most of this thread and a number of others and googled to try and answer my question. I have nutted my way through all the install issues I had and got everything installed and up and running using the sample data that you can use when you first load Raspberry Pints. All looking good

Then I delete all the sample data, add my own beers, but I cant seem to add the actual recipes? No user editable fields for that - is that intended? Found the issue of having a line break in the Tasting Notes - fixed by removing said line break.

I add my Kegs - all good. I set the number of Kegs to 4, done.

I go to Tap a Keg and the selected Beer info comes through - great, Select a 'Clean' Keg - Start Amount comes through, but there is a compulsory Pin Number field? Not sure what that is, so I try entering varying different numbers in here and nothing works, when I click Save - nothing is saved, other than my Keg being changed to 'Serving'. No tap with my beer, nothing displayed on the front end GUI!

I think the Pin Number is for the flow meters, but i chose the version without Flow Meters, so how does this get populated from the Keg, or how do I remove the field to get this working?

Screen shots provided to assist anyone who can answer this please

 

[day_trippr]

- As you have found, there are fields in the "My Beers" template that never made it to the show
- As well, certain obvious data linkages from recipe through keg to tap were never established, hence you have to fill those entries in - again.
- Make sure you have checked off the "Use Flow Monitoring" setting under Personalization - Show/Hide Columns.


Cheers!

 

[Andy McKinlay-Clark]

- As well, certain obvious data linkages from recipe through keg to tap were never established, hence you have to fill those entries in - again.
- Make sure you have checked off the "Use Flow Monitoring" setting under Personalization - Show/Hide Columns.


Cheers!

Thanks @day_trippr though I'm not having to enter any again from the Recipe onto the Keg, the recipe data is autopopulating when I select the beer - good

There is no "Use Flow Metering" setting under the Personalisation Show/Hide Columns? Any other suggestion?

 

[Brewing Badger]

will do. now that i think about it i believe the only changes i had to make was set a static IP and to uncomment the Uno line in the Config.py. Would be nice if that wa a question in the script, but then again, i do not know what that entails in the programming. I believe once that happened the it was recognizing the UNO. ba-brewer helped me turn on the debugging to i could confirm it was working, and then blowing into the meters it was recognized. Im going to go through a fresh install again today so i can familiarize myself more with it and have a back up fresh Install SD.

Being totally green, that writeup would be gold. I have managed to uncomment the UNO line in the Config.py file, but when trying to configure the sketch to upload to the UNO as per the instructions in post: https://www.homebrewtalk.com/forum/...-taplist-solution.487694/page-55#post-7722587
I can't find the lines listed there to configure in /var/www/html/arduino/raspberrypints/raspberrypints.ino

Also, in the Rpints admin setup GUI, how do you configure the correct pins on the UNO? The hardware I/O menu only shows the alamode board.

And finllay, how did you test the flowmeters without hooking them up to a keg?

Sorry for the noob questions, but trying to learn.

 

[ba-brewer]

@Brewing Badger if you use Rand's version of rpints you do not need to change the Arduino code, it is done in the GUI.

There should be an option in the tap section of the admin screen, it says flow pins. You also setup the scaling factor(pulses/gal) for the flow meter there. Don't use pin 13, he is blinking a LED with that one.

You can blow or push air thru the meter to get it to generate pulses.

 

[DaniFilth]

Hi all. Should i solder all of the components to the alamode (in case of future use) or do i only need for the sensors and 5v + Ground?
Can i get the 5v and ground from the gpio, or do i need it to come from a seperate part? I have female connectors from the sensors so they can slip right on there and i'm going to use the male ones for 8-11 instead of the female that's supposed to be there, get away with splicing a cable for it.

 

[day_trippr]

Flow meters don't draw much current. You can source the 5V and GND for them from the array of servo pins in the corner quadrant closest to the micro USB receptacle.

As for fully building the Alamode, that's dealers choice, aside from the headers needed to interface to the RPi...

Cheers!

 

[Brewing Badger]

@Brewing Badger if you use Rand's version of rpints you do not need to change the Arduino code, it is done in the GUI.

There should be an option in the tap section of the admin screen, it says flow pins. You also setup the scaling factor(pulses/gal) for the flow meter there. Don't use pin 13, he is blinking a LED with that one.

You can blow or push air thru the meter to get it to generate pulses.

Thank you
So just upload the raspberrypints.ino to the UNO, set the correct pins in the tap section then.

Where would I see the pulses register during testing? I guess I could just put a mock up test beer on tap and see if it registers when I blow through the flowmeters, but is there anywhere to see the actual pulsecount?

And also, would there normally be a need to calibrate the swissflow meteres? I remember reading somewhere in this thread that as Rpints was written with the SF800 flowmeteres in mind, the calibration for these are allready in place.

Thanks again

 

[RandR+]

Thank you
So just upload the raspberrypints.ino to the UNO, set the correct pins in the tap section then.

Where would I see the pulses register during testing? I guess I could just put a mock up test beer on tap and see if it registers when I blow through the flowmeters, but is there anywhere to see the actual pulsecount?

And also, would there normally be a need to calibrate the swissflow meteres? I remember reading somewhere in this thread that as Rpints was written with the SF800 flowmeteres in mind, the calibration for these are allready in place.

Thanks again

In my version, the python will automatically upload to the shield on startup if there is a cpp.hex file in the Arduino/raspberrypints folder. Though I don't have a Uno to verify that works on it.

Also in my version, the easy way to see updates and pours is to look at the file /var/log/rpints.log (use command "tail -f /var/log/rpints.log" to show the latest trace)

Unfortunately, I don't use swissflow meters so I cant help too much, but I don't see anything in the code to about the specific meter being used.

 

[ba-brewer]

Thank you
So just upload the raspberrypints.ino to the UNO, set the correct pins in the tap section then.

Where would I see the pulses register during testing? I guess I could just put a mock up test beer on tap and see if it registers when I blow through the flowmeters, but is there anywhere to see the actual pulsecount?

And also, would there normally be a need to calibrate the swissflow meteres? I remember reading somewhere in this thread that as Rpints was written with the SF800 flowmeteres in mind, the calibration for these are allready in place.

Thanks again

I just observed the results on the display. Once I got that I did some tests with water to verify accurate reporting of volume.

I do have a UNO and it does automatically download the code. I must admit I removed the cpp.hex so the UNO is not repeated programmed.

I use a cheaper flowmeter than the swissflow so can't comment on calibrating. I started with an active kegging system (partial kegs and no idea of tare weights) so I needed to tweak my pulses/gal. My flowmeter gives a pretty consistent 8000 pulses/gal of room temp uncarbonated water but with beer it seem like if needs to be 7400 pulses/gal. Not sure if it the temp, the carbonation or my estimates on tare and volume, but once the latest kegs with more accurate volume estimates are served I will have a better idea.

For clarity this is the flowmeter I use.
https://www.amazon.com/gp/product/B07JWD4C46/?tag=skimlinks_replacement-20

One thing about Rand version it look like he has started to put in the hooks to use different types of flowmeters.

 

[day_trippr]

Could you perhaps take a nice picture of the way you've integrated that particular flow meter into your beer line for posterity?

That's the first 1/4" quick-connect meter I've read of anyone using, but eventually someone will be in your wake and as you've solved the connectivity it could help the next fellow.

As well, if anyone is using threaded meters (aside from the well-understood SF800) and could take a good pic of it with the ins and outs connected that would be cool...

Cheers!

 

[CadiBrewer]

It looks like a John Guest fitting. Probably uses the same 1/4" John Guest to barb fitting that came on my Swissflow meters...

 

[ba-brewer]

yes it is the john guest 1/4in to 1/4in hose barb.
https://www.amazon.com/gp/product/B005XU0SK4/?tag=skimlinks_replacement-20

There is was a ridge inside at the middle so I drilled it out just in case it might cause foam.

I put it about 1ft away from keg disconnect secured with hose clamps like people were doing with the swissflow.

I started with them hanging between kegs but that made adding and removing kegs a bit complicated, so meter and line is coiled on top of keg without any issue so far.

 

[day_trippr]

Thanks. So, same type of barbed insert, but 1/4" stem instead of the 3/8" for the SF800 adapters. Cool beans!

Cheers!