[Version 2 Release] RaspberryPints - Digital Taplist Solution

barrooze · Jul 15, 2017

So, I can ftp in and edit the file contents on a remote box, sure, but can I edit the phpmyadmin stuff through it? Maybe setup a windows version and remote into that somehow?

Also, to add to the oddity of the new 2015 styles, I found that I can change any beer to one of the first 106 line items. Any style after that will not save to the beer. If any of you have the 2015 BJCP styles working, can you tell me how you did it and how many line items you have?

Thank you!

day_trippr · Jul 15, 2017

barrooze said:
So, I can ftp in and edit the file contents on a remote box, sure, but can I edit the phpmyadmin stuff through it? Maybe setup a windows version and remote into that somehow?

Phpadmin is a web app that runs on the host, not the client. If you point a remote browser at the correct url it will run the app just like you were sitting at the local console.

Also, to add to the oddity of the new 2015 styles, I found that I can change any beer to one of the first 106 line items. Any style after that will not save to the beer. If any of you have the 2015 BJCP styles working, can you tell me how you did it and how many line items you have?

Thank you!

I haven't gotten that deep into adding styles, I have only added a few styles that I have brewed that weren't in the original kit.
Is it possible there's some Mysql parameter that needs to be raised with the increased depth of the Styles table?

Cheers!

barrooze · Jul 15, 2017

Thanks, day_trippr. I'm now updating everything from the windows box.

Not sure how I can find out if there's a MySQL parameter for this, BUT I just found that the original table has 106 lines. There HAS to be a hard-coded somewhere. I'm looking through the code for beer_form.php. When you're in that form, the entire list of categories is shown. When I press 'Save' the value just doesn't save. To me, this means that in the Save function, it's checking to see if the ID is found in the list, and if not, will not save it. I've searched the text for all php files in the admin directory and there are no occurrences of '106'.

At this point, I'm temped to revert to the 2008 categories, but I'd rather not... I'm going to try some more stuff first. will keep you posted.

kaljade · Jul 15, 2017

barrooze said:
I made the changes you specified regarding the SRM files, and now I'm getting the following. Any ideas why the images aren't showing up?

Edit: fixed attachment.

I have sent you a PM requesting your index.php and style.css files as I suspect the issue is a missing carriage return or something simple like that but what is likely to take many back and forth posts to diagnose.

barrooze said:
Not sure how I can find out if there's a MySQL parameter for this, BUT I just found that the original table has 106 lines. There HAS to be a hard-coded somewhere. I'm looking through the code for beer_form.php. When you're in that form, the entire list of categories is shown. When I press 'Save' the value just doesn't save. To me, this means that in the Save function, it's checking to see if the ID is found in the list, and if not, will not save it. I've searched the text for all php files in the admin directory and there are no occurrences of '106'.

I suspect an issue with the database structure that is not easily exposed in phpMyAdmin (for example 106 may already exist in the database so it will not let you create a duplicate). It's also worth seeing if your new entries are visible in the vwGetActiveTaps table one you save them in your Beers list:

(ignore my entries as I repurposed this fixed list for brewing method and created a new free text field "beerType" for style to prevent the need to keep updating it in the database)

I'd suggest installing a local client like MySQL Workbench as the web based one will be a lot less feature rich (depending on what version of PHP you have running on your Pi), and is only a benefit for servers that you cannot access from a local client.

barrooze · Jul 15, 2017

FINALLY FIGURED OUT THE BJCP CATEGORIES!

There's apparently some 'Foreign Keys' in the SQL DB. They are linking the original 'beerStyles' table to the 'beers' table. I had renamed the original styles table to 'beerStyles2', which drove the limit of the style ID number to be no more than the max of the original table. The PHP beer_form sheet showed the 'beerStyles' table, but the code in the background used the 'beerStyles2' sheet. I could not figure out how to re-direct the relation, so I ended up re-renaming the original table back to 'beerStyles', appended the 2015 category table to the original, then just deleted all of the original line items in the now-merged table.
(EDIT: I found out how to change the relation in 'beers'. If you've renamed the original table to something (i.e. beerStyles2008) and named the 2015 cats to 'beerStyles', you'll need to go to 'beers', Structure, click on "Relations View under the fields. On the beerStyleId line, the 5th dropdown should be 'beerStyles2008'. Click on this and point to 'beerStyles'. Press Save, and your RPints should now allow all the categories found in the 'beerStyles' table!)

Something to note at this point: any beer you have in your 'beers' table needs to have the style updated to the new category. If you do not, and you delete the id from 'beerStyles', the beer entirely gets deleted from the 'beers' table. I only had a few, and I had my tap listing up on a monitor so it was easy to re-add the beers. That being said, if you've been using RPints for years and have tons of Beers in the table, you may want to forego this update. OR you can update the category IDs in the beer table with a relation table.

If anyone is interested in updating their category list to the 2015 BJCP cats, I will type up how to do it and post it here. I'll also try to add the 2008-2015 mapping table and SQL code to update the cats in the 'beers' table.

NOW... continue trying to figure out wtf is up with these BeerSmith SRM images...

TheSkaz · Jul 17, 2017

Hello all,

I am finishing up my keezer in another thread and have an ESP8266 that is using some temp sensors and relays to control temp. Then I stumbled across this thread. I am amazed at what you guys have going on here and wanted to see if I could "add" to it, or ask for some direction.

I have walked through the installation on the raspberry pi and got that working (had to make some changes to the original instructions like /var/www/html and the cromium browser bit. What I would like to do, is add 2 temp displays at the top to the left or right of "Currently On Tap" one for the keezer, and one for the coffin. And here is the big one, I would like to port the .ino for the arduino to the ESP8266 and send the pulses + temps across the wifi signal, instead of usb/serial. basically serial over wifi. the Adafruit Huzzah has just enough GPIO pins to support 1 onewire bus (temp sensors), 2 relays (freezer cooling and 12v fans in my case), and 6 flow meters, assuming all GPIO pins can be used in that manner (will test soon). I'm not fluent in PHP, but decent in c/c++/c# and sql. I would like to help, just need to be pointed in the right direction.

kaljade · Jul 17, 2017

TheSkaz said:
Hello all,

I am finishing up my keezer in another thread and have an ESP8266 that is using some temp sensors and relays to control temp. Then I stumbled across this thread. I am amazed at what you guys have going on here and wanted to see if I could "add" to it, or ask for some direction.

I have walked through the installation on the raspberry pi and got that working (had to make some changes to the original instructions like /var/www/html and the cromium browser bit. What I would like to do, is add 2 temp displays at the top to the left or right of "Currently On Tap" one for the keezer, and one for the coffin. And here is the big one, I would like to port the .ino for the arduino to the ESP8266 and send the pulses + temps across the wifi signal, instead of usb/serial. basically serial over wifi. the Adafruit Huzzah has just enough GPIO pins to support 1 onewire bus (temp sensors), 2 relays (freezer cooling and 12v fans in my case), and 6 flow meters, assuming all GPIO pins can be used in that manner (will test soon). I'm not fluent in PHP, but decent in c/c++/c# and sql. I would like to help, just need to be pointed in the right direction.

Hello there and welcome to our little corner, sadly the original devs have long since departed, but the most knowledgeable/helpful/active contributor here would undoubtedly be day_trippr.

I believe he already has temperature displaying on his RPints page and he's even started a separate thread on temperature logging via the Pi here: https://www.homebrewtalk.com/showthread.php?t=469523 (which I'd suggest you take a read through).

I've ordered my sensors, etc and am just waiting for the "slow boat from China", but techo questions on this stuff should probably go in the other thread.

That said it is great to see someone with c/c++/c# and sql chops as this community is only surviving on the kindness of others so anything you have to offer is greatly appreciated.

Cheers,

Kal

TheSkaz · Jul 18, 2017

got it working and added 2 kegs and 2 beers. when I go to "My Taps" and Tap a keg, it goes through, but doesn't persist. it still show nothing on tap. Where should I start looking?

do note that I set it up for flow meters, but havent configured that part yet.

TheSkaz · Jul 18, 2017

nevermind, ive been looking at this too long.

kaljade · Jul 19, 2017

TheSkaz said:
got it working and added 2 kegs and 2 beers. when I go to "My Taps" and Tap a keg, it goes through, but doesn't persist. it still show nothing on tap. Where should I start looking?

do note that I set it up for flow meters, but havent configured that part yet.

Need a bit more info on this one, so are you saying you can see the new kegs and beers on the tap form, but can't get them to display on the tap list?

Have you made any code/database changes or is it a "virgin" RPints setup?

TheSkaz · Jul 19, 2017

I figured it out. i disabled the flow meter column and everything worked. I assume since I didnt have a pin, it failed. although it might be nice to have some error handling around it. It is, or should I say was, a vanilla build.

surfer23505 · Jul 19, 2017

I dont know if anyone else has had this issue or knows how to resolve it but any help would be greatly appreciated. I have been trying to change the background image but can not seem to get it to change. If I do it remotely from my desktop computer it will show as being changed once I reload the page. Yet when I go back to the tap list on the actual RaspberryPi itself it will not update the background even though if I log in to the setting menu on the RaspberryPi it shows the image I uploaded within the the settings page but still not changed when got back to the tap list. Have even tried to upload the image directly on the RaspberryPi as well and even then will update the background when tap list is viewed remotely but still not showing up on the tap list on the RaspberryPi.

CadiBrewer · Jul 19, 2017

Have you tried clearing the cache on your pi browser or restarting the pi?

surfer23505 · Jul 19, 2017

Yes, I have restarted it, refreshed the page in the browser as well, still wont change. Yet it is changed when I log in remotely.

day_trippr · Jul 19, 2017

Jeeze, that's pretty weird.
Only thing I can think of is to check the permissions on the local image copy and make sure they're wide open...

Cheers!

surfer23505 · Jul 19, 2017

Honestly the Raspberry Pi and the whole OS are rather new to me. How would I go about to check that?

kaljade · Jul 19, 2017

I vaguely recall having the same issue way back when, I think from memory the solution was to rename my new background image to match the one in the /img directory (ensuring same file format too of course), then using SFTP client to overwrite existing with new

surfer23505 · Jul 19, 2017

I looked into doing that and then i go into the file explorer in the Raspberry Pi and navigate to the /img directory it shows a thumbnail of what it it supposed to be and even when i change the background remotely through the RaspberryPints interface I see the thumbnail immediately change to whatever image I upload yet still wont change when i view the taplist on the RaspberryPi. I have no idea what is going on here.

kaljade · Jul 20, 2017

surfer23505 said:
I looked into doing that and then i go into the file explorer in the Raspberry Pi and navigate to the /img directory it shows a thumbnail of what it it supposed to be and even when i change the background remotely through the RaspberryPints interface I see the thumbnail immediately change to whatever image I upload yet still wont change when i view the taplist on the RaspberryPi. I have no idea what is going on here.

Only two more things it can be:
1. Browser cache needs to be cleared (CTRL + F5 should do it)
2. File permissions there's a couple of ways to fix that, but try step 1 first

surfer23505 · Jul 20, 2017

Clearing the cache did work.

Thanks for all the input guys. It is much appreciated.

kaljade · Jul 20, 2017

surfer23505 said:
Clearing the cache did work.

Thanks for all the input guys. It is much appreciated.

No trouble at all, caching still catches me out on a regular basis, and I work in IT. Glad you're up and running, cheers!

Mafoley29 · Jul 21, 2017

Was hoping that someone can assist on this more me. Running an rp3 with Jessie and Firefox. Everything was working fine and the pours were showing in the browser just fine. Today all of a sudden Firefox is not updating after the pour. You have to refresh the browser to get the pour to update. How can you code to get Firefox to update every 30 seconds or so?

Boomer3731 · Jul 21, 2017

day_trippr said:
Any chance your optical registration is off by one pin?

I've never run into an issue like that, but if I did the first thing I'd do is get a fresh copy of the raspberrypints.ino file and start over.
And double check my wiring.

fwiw, I run six taps and use digital IO 2 and 5 through 9, and have not had a single problem in over two years.

Back when we first got the flow meters working I tried using 2 through 7 but had unresolved issues with 3 and 4.
On the AlaMode digital IO 3 is shared with the RTC chip on the back of the board so potential conflict there seemed logical, but I was never able to find a similar shared status for digital IO 4. As I didn't need to use it I simply avoided it as well...

Cheers!

Just to test things out and make sure I'm not losing my mind and plugging things in in the wrong place I have only one sensor plugged in to pin 2 on the UNO (which is connected to the RPi3 through USB). I also flashed a fresh .ino with just pin 2 mentioned. It's working but it's updating the pour count to my tap #3 on the taplist.

Just to be clear, I'm using the numbers printed on the board itself. Is this correct?

kaljade · Jul 21, 2017

Mafoley29 said:
Was hoping that someone can assist on this more me. Running an rp3 with Jessie and Firefox. Everything was working fine and the pours were showing in the browser just fine. Today all of a sudden Firefox is not updating after the pour. You have to refresh the browser to get the pour to update. How can you code to get Firefox to update every 30 seconds or so?

In your index.php file add the following line:

Code:

<meta http-equiv="refresh" content="30">

Like this:

PHP:

<html>
	<head>
		<title>RaspberryPints</title>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
		<meta http-equiv="refresh" content="30">

		<!-- Set location of Cascading Style Sheet -->
		<link rel="stylesheet" type="text/css" href="style.css">
		
		<?php if($config[ConfigNames::UseHighResolution]) { ?>
			<link rel="stylesheet" type="text/css" href="high-res.css">
		<?php } ?>
		
		<link rel="shortcut icon" href="img/pint.ico">
	</head>

Cheers,

Kal

CadiBrewer · Jul 21, 2017

Boomer3731 said:
Just to test things out and make sure I'm not losing my mind and plugging things in in the wrong place I have only one sensor plugged in to pin 2 on the UNO (which is connected to the RPi3 through USB). I also flashed a fresh .ino with just pin 2 mentioned. It's working but it's updating the pour count to my tap #3 on the taplist.

Just to be clear, I'm using the numbers printed on the board itself. Is this correct?

In the raspberry pints software, when you are tapping a keg, you set the pin number that you have that flow meter connected to, to the tap number on your tap list. Check the settings on the beer you have hooked up to tap #3 and make sure that tap doesn't have pin 2 assigned to it.

Boomer3731 · Jul 22, 2017

CadiBrewer said:
In the raspberry pints software, when you are tapping a keg, you set the pin number that you have that flow meter connected to, to the tap number on your tap list. Check the settings on the beer you have hooked up to tap #3 and make sure that tap doesn't have pin 2 assigned to it.

Man, when you get this deep into it it really is the simplest of things that you forget. Haha.

Thanks! :mug:

barrooze · Jul 24, 2017

kaljade said:
Only two more things it can be:
1. Browser cache needs to be cleared (CTRL + F5 should do it)
2. File permissions there's a couple of ways to fix that, but try step 1 first

I had never heard of the ctrl+F5 trick until you mentioned it last week or so. It works so well! Thanks again! FYI, I just mounted the monitor onto my kegerator door. Looks awesome! I've got my motion sensor mounted on the side so it "sees" me and turns off screensaver before I see the monitor. Pretty slick!

jbinbama · Jul 24, 2017

I thought I read somewhere on here about connecting to the DB remotely (through the web interface) but maybe i was just imagining it. How can I connect to the DB? And can I do it remotely or do I have to be on the PI itself. I want to just get in and dig around a bit.

day_trippr · Jul 24, 2017

Install phpmyadmin on the RPi.
It is a "web app" that can be accessed locally or remotely from anything with a decent browser.
[edit] Note that when you run phpmyadmin from wherever you need to log into it using the same credentials used during the Mysql installation for it to find the Raspberrypints database.
Generally, that would be 'root' with whatever password was used.

Cheers!

jbinbama · Jul 24, 2017

thanks that did it. I apparently had it installed - I was using phpmysql instead of phpmyadmin. Now let's hope I don't break anything

[Version 2 Release] RaspberryPints - Digital Taplist Solution

Help Support Homebrew Talk:

Well-Known Member

Foxtrot Delta Tango

Well-Known Member

Well-Known Member

Well-Known Member

Active Member

Well-Known Member

Active Member

Active Member

Well-Known Member

Active Member

Member

Well-Known Member

Member

Foxtrot Delta Tango

Member

Well-Known Member

Member

Well-Known Member

Member

Well-Known Member

Well-Known Member

Member

Well-Known Member

Well-Known Member

Member

Well-Known Member

Member

Foxtrot Delta Tango

Member

Similar threads