[Version 2 Release] RaspberryPints - Digital Taplist Solution

bscuderi · Sep 25, 2017

Hey all. I thought I'd share a video of my setup now that everything is finally put where it's going to go. For hardware I'm using a pi 3 an arduberry arduino shield for the raspberry pints with swissflow sensors. Then the pi also plugs into an arduino uno running brewpi to control my keggerator temp and turn on the tower fan when the compressor is running.... overkill I know but I froze a keg with the standard dial number setting on my mini fridge and had the extra hardware so I was motivated to never freeze another keg lol. Then for the screen I'm using a fire 8 tablet running fully kiosk to detect motion and turn on and off the screen. Enjoy.
https://youtu.be/4F1iis6fjUo

RandR+ · Sep 26, 2017

omhelle said:
How do you choose to use a different user?
Ole

Here are the instruction I followed:

pi@raspberrypi ~ $ sudo mysql
You will see something like this:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 71
Server version: 10.1.23-MariaDB-9+deb9u1 Raspbian 9.0

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>

[Enter the following commands not including MariaDB [(noen)](Lines that start with MariaDB [(none)]> the other lines are the result)
Feel Free to change the userName(after USER) and password (after IDENTIFIED BY )]
MariaDB [(none)]> CREATE USER RaspberryPints@'%' IDENTIFIED BY 'RaspberryPints';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> grant all privileges on *.* to RaspberryPints@'%';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> exit
Bye

Then open install/includes/configprocessor.php and replace all instances of "root" with "RaspberryPints" (or your chosen user name)

Also when install raspberryPints use the password RaspberryPints as the root password(unless you changed it from my command)

tentenbrews · Sep 26, 2017

I have skimmed through this thread a little bit and have seen a few pics of tap lists posted. I would like to get into a little more customization like some of you have. Where do I start? Will I need to hook up a mouse and keyboard to the raspberry pi? Or can I just use my laptop and access it through putty?

day_trippr · Sep 26, 2017

You can do everything remotely. I almost never use local consoles for anything other than display.
When I'm working on an RPi application I have a Putty session open to manage the system, a WinSCP session to pull files to a local editor on my peecee, and a Chrome window for testing...

Cheers!

tentenbrews · Sep 26, 2017

day_trippr said:
You can do everything remotely. I almost never use local consoles for anything other than display.
When I'm working on an RPi application I have a Putty session open to manage the system, a WinSCP session to pull files to a local editor on my peecee, and a Chrome window for testing...

Cheers!

OK, I'm not familiar with WinSCP but I will download it.

One of the first things I would like to do is get rid of the "powered by raspberry pints" logo. And is there a way to add a logo to the header instead of the text?

day_trippr · Sep 26, 2017

There's all kinds of things folks have done by modding the index.php and/or style.css files.
I changed a bunch of font sizes, replaced the logo with a scrolling temperature display and an icon linked to my temperature logger application, and added a footer that ids the faucets (I have a 6-tap t-tower that my tap list display sits atop of)...

Cheers!

tentenbrews · Sep 26, 2017

I have downloaded WinSCP and opened up the index.php. There is a lot of stuff going on in there. I am afraid to go and change things and screw something up. Is there a easy way to save the file before any changes are made and be able to resort back?

tentenbrews · Sep 26, 2017

tentenbrews said:
I have downloaded WinSCP and opened up the index.php. There is a lot of stuff going on in there. I am afraid to go and change things and screw something up. Is there a easy way to save the file before any changes are made and be able to resort back?

Ok I figured out how to save and resort back if needed. I was able to get rid of the raspberry pints logo.

tentenbrews · Sep 27, 2017

So here is my display. I've been trying to figure out how to get the taplist to cover the whole screen. Is there a way to stretch it out?

day_trippr · Sep 27, 2017

I use the zoom function in Chromium to fill the screen...

kaljade · Sep 27, 2017

day_trippr said:
I use the zoom function in Chromium to fill the screen...

Plug a USB keyboard into your RPi temporarily, hold down the CTRL key and then hit the '+' key as many time you need to until you have the screen filled.

tentenbrews · Sep 27, 2017

kaljade said:
Plug a USB keyboard into your RPi temporarily, hold down the CTRL key and then hit the '+' key as many time you need to until you have the screen filled.

Well that worked, sort of. One + was not enough, but 2 +'s was too many.

iainwb · Sep 27, 2017

I have my monitor in landscape mode.

day_trippr · Sep 27, 2017

As do I, on a 4:3 monitor. I don't think four taps can really fill a portrait mode display very well...

Cheers!

CadiBrewer · Sep 27, 2017

I have three taps and it looks great in landscape mode.

jevers · Sep 27, 2017

To start with, I have a Raspberry Pi Model B+ V1.2 running Wheezy. This Pi is also running BrewPi software.

In step 7 where you are supposed to log into the Pi from a browser on another device, it doesn't bring up the installation files the way the guide says it will, it just brings up my normal BrewPi page. I'm sure I'm supposed to stop it somehow, but I don't want to screw anything up in the process. So, how do I stop BrewPi, install RaspberryPints, and then run both simultaneously?

day_trippr · Sep 27, 2017

tentenbrews said:
Well that worked, sort of. One + was not enough, but 2 +'s was too many.

Go back to one +, then find a nice image you can tack on across the bottom to fill the dead space

Cheers!

day_trippr · Sep 27, 2017

jevers said:
To start with, I have a Raspberry Pi Model B+ V1.2 running Wheezy. This Pi is also running BrewPi software.

In step 7 where you are supposed to log into the Pi from a browser on another device, it doesn't bring up the installation files the way the guide says it will, it just brings up my normal BrewPi page. I'm sure I'm supposed to stop it somehow, but I don't want to screw anything up in the process. So, how do I stop BrewPi, install RaspberryPints, and then run both simultaneously?

There is a built-in conflict between the default installations of BrewPi and RaspberryPints: they both use an index.php file as the target of a web access, so if you try to install both in the same root folder, the latter installation will over-write the former's index.php.

While I've always rooted my multiple BrewPi installations in a folder below /var/www (or /var/www/html), one can have them coexist in the same folder by renaming the first installed to something like rpints.php or brewpi.php, so that the latter installation doesn't wipe out the former. Then you can reference the desired page by adding /rpints.php or /brewpi.php (whichever you went with) to the end of the url...

[edit] The only conflicting files are the index.php, btw. BrewPi parks its style.css in a subordinate folder and the apps don't share any folder names or other file names at their roots...

Cheers!

jbadd99 · Sep 27, 2017

tentenbrews said:
Well that worked, sort of. One + was not enough, but 2 +'s was too many.

Sounds like you need more taps!

And a rather interesting screen name you have there? Fight much?

tentenbrews · Sep 27, 2017

jbadd99 said:
Sounds like you need more taps!

And a rather interesting screen name you have there? Fight much?

I'm not following?

omhelle · Sep 28, 2017

RandR+ said:
Here are the instruction I followed:

pi@raspberrypi ~ $ sudo mysql
You will see something like this:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 71
Server version: 10.1.23-MariaDB-9+deb9u1 Raspbian 9.0

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>

[Enter the following commands not including MariaDB [(noen)](Lines that start with MariaDB [(none)]> the other lines are the result)
Feel Free to change the userName(after USER) and password (after IDENTIFIED BY )]
MariaDB [(none)]> CREATE USER RaspberryPints@'%' IDENTIFIED BY 'RaspberryPints';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> grant all privileges on *.* to RaspberryPints@'%';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> exit
Bye

Then open install/includes/configprocessor.php and replace all instances of "root" with "RaspberryPints" (or your chosen user name)

I`ve tried to do this, but without any luck.

I did a complete reboot of my Raspian OS now, for so to follow the installation guide for RaspberryPints step by step again!

Everything is working fine in the beginning, unil I`m at page 7 of the guide.

1) When I`m going to "delete the deafult apache page"
When I write in the comando do I get up: "... command not found"
So I`m trying to move on to the next thing to do.
2) I`m downloading the latest version, and I`m able to unzip it without any problems in the home folder.
3) The next problem occurs when I`m trying to copy the folder to the web host folder. I get this error message: "mv: cannot move 'RaspberryPints-2.0.1/.......' to /var/www/...' : Directory not empty

Where "..." is the different folders within the RapsberryPints folder.

I`ve tried to delete it and unzipped it again, I`ve tried with two different versions.
This is the same problem as I had on my last attempt last week, at that time I had to get a fried to help me to manually move them som how..

At that time we did manage to move them, but then I got the problem with the root password as mentioned on page 294..

I did follow the guide step by step, and I do rembere my password.
Have anyone had the same problem, or hopefully someone could be able to help me.

Thanks in advance

Ole

dcrog · Sep 28, 2017

tentenbrews said:
So here is my display. I've been trying to figure out how to get the taplist to cover the whole screen. Is there a way to stretch it out?

Simple. Add more taps.

jevers · Sep 28, 2017

day_trippr said:
There is a built-in conflict between the default installations of BrewPi and RaspberryPints: they both use an index.php file as the target of a web access, so if you try to install both in the same root folder, the latter installation will over-write the former's index.php.

While I've always rooted my multiple BrewPi installations in a folder below /var/www (or /var/www/html), one can have them coexist in the same folder by renaming the first installed to something like rpints.php or brewpi.php, so that the latter installation doesn't wipe out the former. Then you can reference the desired page by adding /rpints.php or /brewpi.php (whichever you went with) to the end of the url...

[edit] The only conflicting files are the index.php, btw. BrewPi parks its style.css in a subordinate folder and the apps don't share any folder names or other file names at their roots...

Cheers!

So have I screwed up both of them now? Or since I installed RPints second, should it be OK and BrewPi just needs to be wiped and reinstalled?

RandR+ · Sep 28, 2017

omhelle said:
I`ve tried to do this, but without any luck.

Ole

That's my bad I should have mentioned in my original post to use RaspberryPints as the root password for RPints configuration instead of what you used during the package installation.

I edited my original post to include that information

day_trippr · Sep 28, 2017

jevers said:
So have I screwed up both of them now? Or since I installed RPints second, should it be OK and BrewPi just needs to be wiped and reinstalled?

Going back to your original post it is apparent the mv command will not actually overwrite files in the target folder. Hence, when you went to access the R'Pints installation script you actually accessed the BrewPi "home page" index.php instead.

The simplest thing to do is to rename the existing BrewPi index.php file to brewpi.php, then go back to your R'Pints installation and repeat the commands in Step 6.

That should allow you to get to the R'Pints installation script (named index.php) and continue the installation, while maintaining a working BrewPi...

Cheers!

tentenbrews · Sep 28, 2017

day_trippr said:
Go back to one +, then find a nice image you can tack on across the bottom to fill the dead space

Cheers!

Definitely a good idea. But that is a little out of my wheelhouse to accomplish that. Besides, I could be wrong, but I don't think it's possible with the current configuration? The background goes right to the end of the forth tap. It seems everything below that is dead space. If the space below the forth tap was available wouldn't the background cover the entire screen? And yes the background image is definitely big enough to do it.

tentenbrews · Sep 28, 2017

dcrog said:
Simple. Add more taps.

Just not an option.

day_trippr · Sep 28, 2017

tentenbrews said:
Definitely a good idea. But that is a little out of my wheelhouse to accomplish that. Besides, I could be wrong, but I don't think it's possible with the current configuration? The background goes right to the end of the forth tap. It seems everything below that is dead space. If the space below the forth tap was available wouldn't the background cover the entire screen? And yes the background image is definitely big enough to do it.

That the background image isn't covering the entire screen is strange.
I just zoomed way out of my taplist and the background still covered the full screen.
Not sure what to make of that aside from a suspicion the screen geometer isn't set correctly.
What happens when you zoom in - does the background image eventually fill the entire screen?

Anyway...wrt tacking an image to the bottom of the page, if you look at the pic of my taplist a few posts back, the "Taps" line across the bottom of the display is actually an image file (a png with background transparency set).

All it took was to add these lines to the bottom of index.php:

Code:

<style type="text/css">
<!--
img.size{
	width:100%;
	height:auto;
}
-->
</style>

<img class="size" src="img/tap_numbers.png" alt="">

If you want your image to be opaque you can use pretty much any file format including a jpg, no need to use formats that support transparency, and the html code above doesn't specify - or care - either way.
If you park a virgin copy of index.php you can play with the live file 'til you get things the way you want it...

Cheers!

kaljade · Sep 28, 2017

tentenbrews said:
Just not an option.

The other option is a simple css hack to increase the height of each row:

Open your style.css file and look for the following lines:

PHP:

table .tap-num{
width: 50px;
}

Then add a height value in, eg:

PHP:

table .tap-num{
width: 50px;
height: 150px;
}

Save and push it up to your Pi, then plug your USB keyboard back into it and hit 'CTRL+F5' to do a hard refresh and force it to load the new css values.

If 150 is too much, scale it back to 125, or if you need more increase it to 175, then rinse and repeat with the upload and hard refresh.

Might take a little tweaking but it should get you there.

Only caveat is that the row heights are dynamically adjusted based on your text within the notes field, so if you keg a beer with a particularly verbose description you may need to clawback the height value to compensate.

Cheers,

Kal

tentenbrews · Sep 28, 2017

day_trippr said:
That the background image isn't covering the entire screen is strange.
I just zoomed way out of my taplist and the background still covered the full screen.
Not sure what to make of that aside from a suspicion the screen geometer isn't set correctly.
What happens when you zoom in - does the background image eventually fill the entire screen?

Anyway...wrt tacking an image to the bottom of the page, if you look at the pic of my taplist a few posts back, the "Taps" line across the bottom of the display is actually an image file (a png with background transparency set).

All it took was to add these lines to the bottom of index.php:

Code:

<style type="text/css">  </style> <img class="size" src="img/tap_numbers.png" alt="">

If you want your image to be opaque you can use pretty much any file format including a jpg, no need to use formats that support transparency, and the html code above doesn't specify - or care - either way.
If you park a virgin copy of index.php you can play with the live file 'til you get things the way you want it...

Cheers!

So long story short, no the background would not fill the screen when zoomed in. But it's fixed now.

And thanks for the info about the image at the bottom. Where did you save the png file at?

kaljade said:
The other option is a simple css hack to increase the height of each row:

Open your style.css file and look for the following lines:

PHP:

table .tap-num{ width: 50px; }

Then add a height value in, eg:

PHP:

table .tap-num{ width: 50px; height: 150px; }

Save and push it up to your Pi, then plug your USB keyboard back into it and hit 'CTRL+F5' to do a hard refresh and force it to load the new css values.

If 150 is too much, scale it back to 125, or if you need more increase it to 175, then rinse and repeat with the upload and hard refresh.

Might take a little tweaking but it should get you there.

Only caveat is that the row heights are dynamically adjusted based on your text within the notes field, so if you keg a beer with a particularly verbose description you may need to clawback the height value to compensate.

Cheers,

Kal

Thanks. I gave this a try. Indeed it works and I can fill the screen, but it is only expanding the line starting with "tap #". So it ends up looking kinda weird. Plus it throws off the "Beer name & etc" column if one beer has a bunch of tasting notes, like you mentioned. I will probably try and mess around with the header size. What I would really like to do is put a image there instead of the text.

[Version 2 Release] RaspberryPints - Digital Taplist Solution

Help Support Homebrew Talk:

Well-Known Member

Well-Known Member

Well-Known Member

Foxtrot Delta Tango

Well-Known Member

Foxtrot Delta Tango

Well-Known Member

Well-Known Member

Well-Known Member

Foxtrot Delta Tango

Well-Known Member

Well-Known Member

Active Member

Foxtrot Delta Tango

Well-Known Member

Well-Known Member

Foxtrot Delta Tango

Foxtrot Delta Tango

Well-Known Member

Well-Known Member

New Member

Well-Known Member

Well-Known Member

Well-Known Member

Foxtrot Delta Tango

Well-Known Member

Well-Known Member

Foxtrot Delta Tango

Well-Known Member

Well-Known Member

Similar threads