[Version 2 Release] RaspberryPints - Digital Taplist Solution

[day_trippr]

That's how it should work if Apache2 is up

Cheers!

 

[DuncB]

I've come across an interesting issue, I've installed for testing a flow meter but every time I pour a sample it restarts any youtube video that is playing on the second screen.
How can I debug this?

 

[RandR+]

How can I debug this?

That is caused by includes/refresh.sh

When a pour happens RPints refreshes the browser but is not specific to its tab.
There is an refresh automatically setting to control this

 

[DrinkinBeer]

So I haven't been here for awhile because Rp was working great for me it was just the basics. Recently we had some power outages due to the weather. i noticed my menu was different when I loaded Rpints. I tried to reconfigure it but it wouldn't let me. All my beers were gone. And I couldn't change anything. I figured I would install my last backup. Now Rpints is gone after install of the back up. It says page cannot be found. I've tried reinstalling but I keep getting errors. If I have to delete it all and start over oh well I just want it up and running again. Any suggestions would be awesome

 

[RandR+]

last backup.

what type of backup did you have? database or full sd card copy?

 

[DrinkinBeer]

what type of backup did you have? database or full sd card copy?

Just database

 

[RandR+]

Just database

i would start by checking /var/log/apache2/error.log to see if there is an obvious error after trying RPints again. It could be the restore didnt work quite right.

If not since you have a database export you could save that off the pi, and start the Pi over from scratch reinstall RPints verify its working then import your database again.

 

[DrinkinBeer]

i would start by checking /var/log/apache2/error.log to see if there is an obvious error after trying RPints again. It could be the restore didnt work quite right.

If not since you have a database export you could save that off the pi, and start the Pi over from scratch reinstall RPints verify its working then import your database again.

I ran the rpints again and this is what comes up. How would i go about starting from scratch. Its been awhile and forgot a lot of this.

 

[RandR+]

rpints again and this is what comes up.

looks like there is a table missing from the database restore. my guess is that more tables are missing and causing the issue.
When you rerun the installer it should detect RPints and ask if you want to update or reinstall you can select reinstall to get a fresh RPints.

you could also start with a new Pi OS install:
If you have another SD card you can use i would format and install Pi OS on that then reinstall RPints. That leaves your current card available for data retrieval.
Otherwise you can use the current SD card and just reinstall Pi OS on it.

 

[DrinkinBeer]

looks like there is a table missing from the database restore. my guess is that more tables are missing and causing the issue.
When you rerun the installer it should detect RPints and ask if you want to update or reinstall you can select reinstall to get a fresh RPints.

you could also start with a new Pi OS install:
If you have another SD card you can use i would format and install Pi OS on that then reinstall RPints. That leaves your current card available for data retrieval.
Otherwise you can use the current SD card and just reinstall Pi OS on it.

When I try to reinstall it this is what I get.
I do have another card. Am i installing buster on the new card

 

[day_trippr]

The installer can't find required repositories. Did you do an apt-get update first?

Cheers!

 

[DrinkinBeer]

The installer can't find required repositories. Did you do an apt-get update first?

Cheers!

Yes and this is what I get

 

[day_trippr]

Did you use a root account or do a 'sudo apt-get update'?

[edit] nvm, I can see you didn't. So do ^that^.

If you did, I'd say that SD card image is totally borked if it can't update the package repository lists.
Time to start fresh...

 

[DrinkinBeer]

Did you use a root account or do a 'sudo apt-get update'?

If you did, I'd say that SD card image is totally borked if it can't update the package repository lists.
Time to start fresh...

What os should I install on my new card

 

[day_trippr]

Check my edited post - try 'sudo apt-get update' first.

I'll defer to @RandR+ on which OS version but I have his kit running on Bullseye here....

Cheers!

 

[RandR+]

What os

I havent tried Bookworm. My guess is some dependencies changed names from Bullseye. You certainly can try it but if it doesnt work i would go back to bullseye.

Let me know if you try Bookworm

 

[DrinkinBeer]

Check my edited post - try 'sudo apt-get update' first.

I'll defer to @RandR+ on which OS version but I have his kit running on Bullseye here....

Cheers!

sudo apt-get update conclusion

 

[DuncB]

That is caused by includes/refresh.sh

When a pour happens RPints refreshes the browser but is not specific to its tab.
There is an refresh automatically setting to control this
View attachment 839757

Thank you for this. It was an irritation whilst watching and drinking.

In post# 8033 I was wondering if possible to have my taps arranged in groups of five per page or separate blocks of five that can be scrolled to?

It obviously works in display if I limit my beers on tap to only five. But then other beers on tap in different places can't be shown.

 

[day_trippr]

sudo apt-get update conclusion

It's going for Stretch, which has been deprecated. You might be able to dig out the repositories with some effort, but frankly it's rarely worth keeping obsolete packages alive.

I'd start from scratch with a Bullseye kit. That would be the "RaspberryPi OS - Legacy" version.
https://www.raspberrypi.com/software/operating-systems/
Cheers!

 

[RandR+]

five per page or separate blocks of five that can be scrolled to?

There are no settings for that in RPints

im guessing you have the screen setup so the taps go left to right.
includes/beerListTableVerticle.php would need to be modified to have a loop around the logic that prints the table rows and define a start tap number and end tap number both of which get adjusted each time through the loop so
<?php for($i = 1; $i <= $numberOfBeers; $i++) {
would become
$startTap = 1;
$endTap = min($startTap + 5, $numberOfBeers);
<php while($endTap < $numberOfBeers) { ?>
<?php for($i = $startTap; $i <= $endTap; $i++) {

<php }
$startTap += 5;
$endTap = min($startTap + 5, $numberOfBeers);
} ?>

 

[DuncB]

There are no settings for that in RPints

im guessing you have the screen setup so the taps go left to right.
includes/beerListTableVerticle.php would need to be modified to have a loop around the logic that prints the table rows and define a start tap number and end tap number both of which get adjusted each time through the loop so
<?php for($i = 1; $i <= $numberOfBeers; $i++) {
would become
$startTap = 1;
$endTap = min($startTap + 5, $numberOfBeers);
<php while($endTap < $numberOfBeers) { ?>
<?php for($i = $startTap; $i <= $endTap; $i++) {

<php }
$startTap += 5;
$endTap = min($startTap + 5, $numberOfBeers);
} ?>

You are right about the taps going from left to right.

That's very elegant, I'll have a go at finding that which I'm assuming will be in includes/beerListTableVerticle.php or includes/beerListTableVertical.php

Now I just need to get some flow meters that don't make the beer or even water taste horrible. They said they were food safe , probably are but no way usable. I'm wrangling with them about this. Getting swiss flow meters to NZ is prohibitive.

 

[DrinkinBeer]

I havent tried Bookworm. My guess is some dependencies changed names from Bullseye. You certainly can try it but if it doesnt work i would go back to bullseye.

Let me know if you try Bookworm

Ok I flashed a new card with bullseye, got rpints loaded how do I transfer my files or beers over to the new card

 

[DuncB]

Just a note, bullseye 64 bit and Arduino shield wouldn't work for me. Works in 32 bit.

 

[day_trippr]

"Arduino shield"?

 

[RandR+]

my files or beers over to the new card

if you still have the database backup you can use the mariadb cli to restore. Or if you used the RPints built in backup you can place the file in the <WWWROOTE>/sql/backups directory then use the import command from the admin->install page.

I cant remember if Pi OS can easily mount the old card to pull files from, but based on the errors my guess is that the old actual database files are corrupt and you need your backup. I had my files corrupt a few times and was able to pull the data but it was a pain because i had to load on another computer and replace the data files with the old ones
Hence I enable external connections to mariadb so i can use MySql Workbench to connect remotely and do all of my maintenance using native mysql backups.

 

[DuncB]

There are no settings for that in RPints

im guessing you have the screen setup so the taps go left to right.
includes/beerListTableVerticle.php would need to be modified to have a loop around the logic that prints the table rows and define a start tap number and end tap number both of which get adjusted each time through the loop so
<?php for($i = 1; $i <= $numberOfBeers; $i++) {
would become
$startTap = 1;
$endTap = min($startTap + 5, $numberOfBeers);
<php while($endTap < $numberOfBeers) { ?>
<?php for($i = $startTap; $i <= $endTap; $i++) {

<php }
$startTap += 5;
$endTap = min($startTap + 5, $numberOfBeers);
} ?>

I have modified the file as below

<?php for($startTap = 1;
$endTap = min($startTap + 5, $numberOfBeers);
<php while($endTap < $numberOfBeers) { ?>
<?php for($i = $startTap; $i <= $endTap; $i++) {

<php }
$startTap += 5;
$endTap = min($startTap + 5, $numberOfBeers);
} ?>
$beer = null;


have i done this right?

i'm not sure if i should have deleted the <?php for( before the changes

 

[DuncB]

All I seem to have on main page is this?

 

[RandR+]

have i done this right?

my bad try this file (change extension to php)

on line 21 there is

$tapsPerPage = 5;

change 5 to whatever you want to be.

the issue i found is that tap number rows after the 1st are normal height and not small like the top, so in beerListTableVerticale2.txt i just hide those rows completely. maybe if i get more time this weekend i will just fix the height

there may be more issues i did limited testing

 

[DuncB]

Ohh thank you,
I'll try in the morning and I can try either attachment ?
I understand that I need to change .txt to .php

 

[RandR+]

I can try either attachment ?

either one should work. The one with a 2 does not show the tap numbers after the first set of taps.