[Version 2 Release] RaspberryPints - Digital Taplist Solution

[RandR+]

Any ideas how to get it working again?

in /var/www/html/python/Config.py
change
config['flowmon.debug' ] = False#True
to
config['flowmon.debug' ] = True

then restart flowmon
sudo /etc/init.d/flowmon restart

recheck the logs it should have more information in it

 

[esdill]

in /var/www/html/python/Config.py
change
config['flowmon.debug' ] = False#True
to
config['flowmon.debug' ] = True

then restart flowmon
sudo /etc/init.d/flowmon restart

recheck the logs it should have more information in it

2022-06-30 06:34:47

FlowMonitor

D

Traceback (most recent call last): File "/var/www/html/python/FlowMonitor.py", line 658, in run GPIO.add_event_detect(self.pirPin, GPIO.RISING, callback=self.MOTION) RuntimeError: Failed to add edge detection

 

[RandR+]

RuntimeError: Failed to add edge detection

Usually I see that when the pin number used is not a valid GPIO pin, since you said it was working on 26 before i dont suspect this to be the case.

Can you send a screen shot of the motion detector configuration? I will recreate on mine to see if it happens to me also.

You may want to try a different pin configuration just to see if it works (dont need to change wiring around until it does)

 

[RandR+]

This answers my question as well thank you, I'll wait patiently.

It is python 3.x

I committed all my python 3 changes (included the updated installer for bullseye)

I tested with 2.7 and 3.9 without issues but that doesn't mean i missed something:
NOT TESTED:
Load Cells
Temperature probes

 

[esdill]

Usually I see that when the pin number used is not a valid GPIO pin, since you said it was working on 26 before i dont suspect this to be the case.

Can you send a screen shot of the motion detector configuration? I will recreate on mine to see if it happens to me also.

You may want to try a different pin configuration just to see if it works (dont need to change wiring around until it does)

 

[RandR+]

I get the same error. Are you running RFID? If not try disabling SPI from the pi configuration and see if that allows it to work.

 

[DuncB]

@RandR+
Look forward to trying it, I'm not back in NZ for 'nother month. Hopefully someone else can start testing. I don't have flow meters so can't help with that bit.

 

[esdill]

I get the same error. Are you running RFID? If not try disabling SPI from the pi configuration and see if that allows it to work.

Not running RFID, I disabled SPI and rebooted. Some progress was made, according to the log the motion sensor is now detecting motion. Waiting to see if the screen comes alive, someone turned off the monitor without telling me ...

 

[esdill]

Not running RFID, I disabled SPI and rebooted. Some progress was made, according to the log the motion sensor is now detecting motion. Waiting to see if the screen comes alive, someone turned off the monitor without telling me ...

View attachment 773493

It's working again! Thanks for the help!

 

[apscherz]

Is there a good database backup option that I'm not seeing in the GUI? I'd like to be able to go into the management portal and export a copy of the DB to the computer I'm accessing on, but I don't see anything for that

 

[RandR+]

database backup option that I'm not seeing in the GUI?

In my version there is a backup/restore option on the install admin page, but it only places the file in the sql/backups directory on the pi, you have to transfer it to you local computer afterwards.

 

[beren]

Have you considered adding an option for sqlite? It should be pretty simple to convert the base sql dump, there are tools to do it. This seems like a perfect project for a tiny sqlite db so you dont have to worry about a full separate db server.

 

[RandR+]

Have you considered adding an option for sqlite

Not really, it probably would be a better option to make it light weight but mysql/mariadb works just fine as is.

 

[esdill]

@RandR+
An enhancement request ... currently I have the "Allow Sample Pour" set to "On" and when I click the tap number I get a one ounce pour registered. It would be nice if this pour amount could be adjusted by the user to a different default amount in the configuration along with the option to either:
1) always use that default amount, or
2) to automatically open the "Manual Pour" interface so the user could enter a variable amount each time. Sometimes my flow meters just don't record a pour and I currently need to go into the admin page, open the tap page, and enter a manual pour, then exit back to the main screen. If this function could also be triggered by simply clicking the tap number, then the user could simply enter the number of ounces poured without opening the admin screen (i.e. - click the tap number, a dialog box appears to "Enter the amount poured", and the database is updated accordingly when the dialog box is closed).

 

[RandR+]

An enhancement request ... currently I have the "Allow Sample Pour" set to "On" and when I click the tap number I get a one ounce pour registered. It would be nice if this pour amount could be adjusted by the user to a different default amount in the configuration along with the option to either:
1) always use that default amount, or

i got that complete. the second one is going to be more time then i have right now

 

[kdw2pd]

Would the attached work for running two flow meters on an Arduino R3, with the RandR version? I couldn't find any wiring diagrams that laid out how to set them up on an Uno, could only find the descriptions for getting them set up on the Alamode board. The goal is to eventually run 4 or 5, but it's much easier to read with just 2 on there.

 

[day_trippr]

I don't use that type of flow meter but the wiring colors vs their connections all looks proper. Should work...

Cheers!

 

[beren]

Yes I was just thinking it would be easy for backing up and even setting up since it’s one last thing.

 

[ishcor2000]

In a previous version of Raspberry Pints I had the below code I put in to name a location of taps 1-4 and taps 5-8. The current version index.php looks a little different and trying to find where I would enter this code in the index.php??

<?php if ( $i == 1) { ?>
<tr>
<td colspan="6"><font size ="40"><font color="A0A0A0"<b><strong>Cedar Keezer</strong></b></font></td>
</tr>
<?php } ?>

<?php if ( $i == 5) { ?>
<tr>
<td colspan="6"><font size ="40"><font color="A0A0A0"<b><strong>Basement Keezer</strong></b></font></td>
</tr>
<?php } ?>

 

[RandR+]

I put in to name a location of taps 1-4 and taps 5-8. The current version index.php looks a little different and trying to find where I would enter this code in the index.php??

To support vertical and horizontal tap list the logic has been moved to includes/beerListTable.php

~line 109 is where you will want to put in your code

 

[ishcor2000]

To support vertical and horizontal tap list the logic has been moved to includes/beerListTable.php

~line 109 is where you will want to put in your code

Awesome! That worked. Have any ideas to remove some of the empty space between the heading "Cedar Keezer" and tap1?

 

[RandR+]

Have any ideas to remove some of the empty space between the heading "Cedar Keezer" and tap1?

that looks like the logic to make all rows the same height

you can try turning that off and if that fixes it and looks good you can leave it or you will have to modify index.php the javascript under
<?php if($config[ConfigNames:isplayRowsSameHeight]) { ?>

specifically add a if...then continue ~line 303 if the rows are your new rows. (whatever you decide to use to determine if its your row)

 

[esdill]

i got that complete. the second one is going to be more time then i have right now

I set the sample amount to 14 oz, click the "submit" button, and when the interface returns the sample amount is blank and the pours still register as 1 oz ...

 

[RandR+]

I set the sample amount to 14 oz, click the "submit" button, and when the interface returns the sample amount is blank and the pours still register as 1 oz ...

that sounds like the database didnt update properly.

On the Pi, open the terminal,
run sudo mysql
use raspberrypints (or your database name)
then
INSERT IGNORE INTO `config` (`configName`, `configValue`, `displayName`, `showOnPanel`, `createdDate`, `modifiedDate`) VALUES
( 'samplePourSize', '0', 'Size of sample Pour', '0', NOW(), NOW() );


and retry

 

[esdill]

that sounds like the database didnt update properly.

On the Pi, open the terminal,
run sudo mysql
use raspberrypints (or your database name)
then
INSERT IGNORE INTO `config` (`configName`, `configValue`, `displayName`, `showOnPanel`, `createdDate`, `modifiedDate`) VALUES
( 'samplePourSize', '0', 'Size of sample Pour', '0', NOW(), NOW() );


and retry

It's kinda working now, the pour value remains in the configuration field after submitting, but the pour amount is way off, it shows 0.11 oz poured when the value is 14 oz:

 

[RandR+]

It's kinda working now, the pour value remains in the configuration field after submitting, but the pour amount is way off, it shows 0.11 oz poured when the value is 14 oz:

can you look at /admin/includes/managers/pour_manager.php ~line 344 it should be

else
{
$amount = $config[ConfigNames::SamplePourSize]/(is_unit_imperial($tap->get_countUnit())?128:1000);
$amountUnit = $tap->get_countUnit();
}

my other thought is that the tap is configured for metric so its inserting 14ml but when i force that in my system i get .47oz so i am not sure where .11 is coming from.
You can check the pour table in mysql directly to see what is inserted for amountPoured and amountPouredUnit
SELECT * FROM raspberrypints.pours order by createdDate desc limit 1;

 

[esdill]

can you look at /admin/includes/managers/pour_manager.php ~line 344 it should be

else
{
$amount = $config[ConfigNames::SamplePourSize]/(is_unit_imperial($tap->get_countUnit())?128:1000);
$amountUnit = $tap->get_countUnit();
}

my other thought is that the tap is configured for metric so its inserting 14ml but when i force that in my system i get .47oz so i am not sure where .11 is coming from.
You can check the pour table in mysql directly to see what is inserted for amountPoured and amountPouredUnit
SELECT * FROM raspberrypints.pours order by createdDate desc limit 1;

The code shown above is exactly what mine shows, here's the pour data:

21560 is the setting for my flowmeter pulses per gallon ... in case that's important.

 

[RandR+]

here's the pour data:

thanks that help, i was saving off the tap unit but normally pours are either gallon or liters.

I just committed a change to save sample pours in gal or l to match the rest of the logic

 

[esdill]

Working great now ... thanks!

 

[Jblues]

Hello, great work on this and keeping this going. I had a vanilla install with no hardware running fine. I decided to implement load cells. My load cell setup was working fine on my esp8266/esphome setup fine.
I have 1 keg, 1 beer, 1 tap setup now.
Anyhow I followed along a post a little back, but can't seem to get anything to show up in the log.

Well, there is one thing "ImportError: No module named pymysql" This is on a new NOOBS install, only thing on it is rpints installed using the latest script.
in config.py I have set:
#logging settings for flowmon
config['flowmon.debug' ] = True

#logging settings for pintdispatch
config['dispatch.debug' ] = True

#logging settings for load cells
config['loadcell.debug' ] = True

On tap 1 Command pin 11, Response pin 13, scale ratio 1, offset 1, lb

Any ideas?