Pass2PHP

[sincze]

I'm on stable 2024.4.

Didn't notice anything yet. I must add that I don't really have color switch besides my Xiaomi hub which I only use for a green or red light.

mmm that is interesting with pass4mqtt only as that one stores '15' indicating the light would be on. ?
Or in combination with pass2php, pretty much lost you at some point so trying to catch up.
Only difference you running proxmox and I trying in Dockers but result could be the same.

[Egregius]

I see in the logfiles that I get 0, 1 and 10. Didn't test in what condition what enters.
The OS shouldn't make a difference indeed. But pass4mqtt replaces pass2php. The main benefit is that it also links up to HASS.

[sincze]

I see in the logfiles that I get 0, 1 and 10. Didn't test in what condition what enters.
The OS shouldn't make a difference indeed. But pass4mqtt replaces pass2php. The main benefit is that it also links up to HASS.

So I got HASS running... creates a 30GB DB in 10 days... (because I forwarded some devices to domoticz to it...) it is crazy.
Domoticz since 2014 is only 90 MB...

But now, how to manage the way back with what you did with the doorbell ??
You created an 'automation' in HA to publish a specific topic in the mqtt broker and catch that with the 'pass2hass.php' ??
Would that be the idea ?

[Egregius]

Data from hass 2 php is still partially done with the rest command. I have this in my config:

Code: Select all

rest_command:
  eufy_doorbell:
    url: "http://192.168.2.2/secure/pass4hass.php"
    method: post
    content_type: "application/x-www-form-urlencoded"
    payload: "d=eufy&a=doorbell"

and in automations:

Code: Select all

- id: '1681975555777'
  alias: Eufy Doorbell
  description: ''
  trigger:
  - type: running
    platform: device
    device_id: c66600b76ab4ab295a4c8423e1263309
    entity_id: binary_sensor.doorbell_ringing
    domain: binary_sensor
  condition: []
  action:
  - service: rest_command.eufy_doorbell
    data: {}
  mode: single

Only started later with mqtt. Probably would be better to have everything in mqtt. I just don't have much interesest in it anymore. Everything works as expected and is 100% stable so why search for trouble

[Egregius]

Aha, was truly simple to have it al in mqtt, just had to add the binary_sensor line.

Code: Select all

mqtt_statestream:
  base_topic: homeassistant
  include:
    domains:
      - switch
      - sensor
      - binary_sensor

[Egregius]

creates a 30GB DB in 10 days... (because I forwarded some devices to domoticz to it...) it is crazy.

Did you find anything to limit the db size? I'm searching for avoiding disk writes but can't get it lower than 3GB/day for hass. My domoticz server only writes 200MB/day.

[sincze]

creates a 30GB DB in 10 days... (because I forwarded some devices to domoticz to it...) it is crazy.

Did you find anything to limit the db size? I'm searching for avoiding disk writes but can't get it lower than 3GB/day for hass. My domoticz server only writes 200MB/day.

I went down from total DB size of 30 GB to 3 GB. Let me share later. Used the exclude in the recorder and a clean up script at 02:22:22

[sincze]

creates a 30GB DB in 10 days... (because I forwarded some devices to domoticz to it...) it is crazy.

Did you find anything to limit the db size? I'm searching for avoiding disk writes but can't get it lower than 3GB/day for hass. My domoticz server only writes 200MB/day.

I went down from total DB size of 30 GB to 3 GB. Let me share later. Used the exclude in the recorder and a clean up script at 02:22:22

The following line was added to the configuration.yaml

Code: Select all

recorder: !include recorder.yaml

After that I created the recorder.yaml, to 'minimize' the DB Size

Spoiler: show

Code: Select all

# ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
# ┃                                     RECORDER Configuration                                     ┃
# ┃ ---------------------------------------------------------------------------------------------- ┃
# ┃ This file defines settings for the recorder of Home Asistant.                                  ┃
# ┃ ---------------------------------------------------------------------------------------------- ┃
# ┃ File: recorder.yaml                                                                            ┃
# ┃ Created: February 29, 2024                                                                     ┃
# ┃ By: S.Incze                                                                                    ┃
# ┃----------------------------------------------------------------------------------------------- ┃
# ┃ Note: Please be cautious while editing this file to maintain the correct YAML syntax.          ┃
# ┃----------------------------------------------------------------------------------------------- ┃
# ┃ For more information, visit: https://www.home-assistant.io/integrations/recorder/              ┃
# ┗━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┛

  purge_keep_days: 3
  commit_interval: 2
  include:
    domains:
      - sensor
      - switch
      - media_player
    entities:
      - sensor.watermeter_dz
      - device_tracker.gsm_boy
      - device_tracker.gsm_girl
      - device_tracker.tk_905_4g
      - device_tracker.luggage_brown
      - device_tracker.luggage_white
      - binary_sensor.alarm
  exclude:
    event_types:
      - call_service
#      - component_loaded
#      - platform_discovered
#      - service_registered
    entities:
#      - sensor.low_tariff_usage
#      - sensor.high_tariff_usage
#      - sensor.low_tariff_return
#      - sensor.high_tariff_return
#      - sensor.actual_consumption
#      - sensor.actual_return
#      - sensor.mqtt_low_tariff_usage
#      - sensor.mqtt_high_tariff_usage
#      - sensor.mqtt_low_tariff_return
#      - sensor.mqtt_high_tariff_return
#      - sensor.mqtt_actual_consumption
#      - sensor.mqtt_actual_return
      - sensor.last_boot
      - camera.front_door
      - sensor.home_assistant_v2_db
      - sensor.memory_free
      - sensor.memory_use
      - sensor.memory_use_percent
      - sensor.processor_use
      - weather.openweathermap
      - sensor.router_upload_dz
    entity_globs:
      - sensor.*_last_seen
      - sensor.*_linkquality
      - sensor.*_temperature
      - sensor.*_consumption_v
      - sensor.*_consumption_w
      - sensor.*_node_status
      - binary_sensor.*
      - sensor.p1_*
      - sensor.date*
      - sensor.weather_*
      - switch.lamp_*
      - switch.xiaomi_*_dz
      - switch.motion_*_dz
      - switch.deur_*_dz
      - sensor.neo_usg_*
      - sensor.plug_kodi_keuken_electric_*
      - sensor.none_tasmota_alarm_energy_*

#  exclude:
#    domains:
#      - device_tracker
#      - media_player
#      - uptime
#      - time_date
#      - worldclock
#    entity_globs:
#      - sensor.clock*
#      - sensor.date*
#      - sensor.glances*
#      - sensor.load_*m
#      - sensor.time*
#      - sensor.uptime*
#    entities:
#      - camera.front_door
#      - sensor.home_assistant_v2_db
#      - sensor.memory_free
#      - sensor.memory_use
#      - sensor.memory_use_percent
#      - sensor.processor_use
#      - weather.openweathermap

[Egregius]

I already guessed it would be the recorder. I disabled default config to disable history and recorder completely. Still 3GB written each day

[sincze]

I already guessed it would be the recorder. I disabled default config to disable history and recorder completely. Still 3GB written each day

Written a day yes. But mine cleans it back daily at 02:22:22 would that be of interest?? It is an automation task.

[Egregius]

As of now my Github repo pass2php is no longer compatible with Domoticz. It's rewritten to suit Home Assistant MQTT Statestream.
If you still like to use it, as example or anything, you'll have to browse the history to a date before today.

[sincze]

As of now my Github repo pass2php is no longer compatible with Domoticz. It's rewritten to suit Home Assistant MQTT Statestream.
If you still like to use it, as example or anything, you'll have to browse the history to a date before today.

Ow this is interesting. You switched to ' the other side ?? '

[Egregius]

I guess so
Still some work to do but 98% is operational.
Mostly need to move my Xiaomi bridge, if I can figure out the access key.

[sincze]

I guess so
Still some work to do but 98% is operational.
Mostly need to move my Xiaomi bridge, if I can figure out the access key.

Ok, as a Pass2PHP user since the beginning interested in your new approach.
As I could not find it in the repo yet , last update some time ago.

For now I managed to copy all light control e.g. to Node-Red.
Pass2PHP still in use for some custom integrations. I also used ChatGPT to update the .php files to create autodiscovery objects for HA.

[Egregius]

Ha, the access key was stored in plain text in the database

Repo should be up to date, updated 3 minutes ago. But probably something was wrong with the cron job as the previous commit was from May 13th.

I will probably not be visiting this forum often anymore. For any tips on Pass2PHP search me on Github or Telegram: @GuyVerschuere