hassconfig/configuration.yaml

config:
frontend:
homeassistant:
counter:
logbook:
notify:
input_datetime:
input_select:
input_text:
timer:
recorder:
  purge_keep_days: 5
  db_url: mysql://hassio:hassiopassword@192.168.1.110/hass?charset=utf8
logger:
  default: info
#  logs:
#    custom_components.philips_airpurifier_coap: debug
#    aioairctrl: debug
    #coap: debug

#  logs:
#    homeassistant.components.mqtt: debug
#  logs:
#    rflink: debug
#    homeassistant.components.rflink: debug

mobile_app:

input_button:

history:
system_health:

http:
  use_x_forwarded_for: true
  trusted_proxies:
    - 192.168.1.110

pyscript:
  allow_all_imports: true

rflink:
  host: 127.0.0.1
  port: 12345
  wait_for_ack: false
  ignore_devices:
    - newkaku_000001_01

#volvooncall:
#  username: thomas.chef@volvo.com
#  password: !secret voc_password
#  scandinavian_miles: true
#  mutable: false


binary_sensor:
   - platform: rflink
     devices:
       newkaku_02ddc7fa_4:
         name: Bedroom door raw sensor
         device_class: door
         force_update: true

# Text to speech
tts:
  - platform: google_translate

switch: !include switches.yaml
input_boolean: !include input_booleans.yaml
input_number: !include input_numbers.yaml
light: !include lights.yaml
group: !include groups.yaml
automation: !include automations.yaml
script: !include scripts.yaml
scene: !include scenes.yaml
mqtt: !include mqtt.yaml


# These are done in the UI. Because they stopped working after 2023_12 update
#sql:
  #- name: "Exterior light status"
  #  db_url: mysql://hassio:hassiopassword@192.168.1.110/RemoteRxLog
  #  query: "SELECT IF(onOff>0,'on','off') AS status FROM RemoteRxLog.nexaLog where rxTx='R' and remote_id = '20071094' and button='1' order by ts desc LIMIT 1;"
  #  column: 'status'
  #- name: "Outside temperature"
  #  db_url: mysql://hassio:hassiopassword@192.168.1.110/RemoteRxLog
  #  query: "SELECT temp1 FROM RemoteRxLog.temp order by ts desc LIMIT 1;"
  #  column: 'status'
  #  unit_of_measurement: "°C"
  #- name: "Piano-lamp repeater status"
  #  db_url: mysql://hassio:hassiopassword@192.168.1.110/RemoteRxLog
  #  query: "SELECT IF(onOff>0,'on','off') AS status FROM RemoteRxLog.nexaLog where rxTx='R' and remote_id = '20071094' and button='2' order by ts desc LIMIT 1;"
  #  column: 'status'
  
#google_assistant:
#  project_id: home-assistant-7390
#  service_account: !include SERVICE_ACCOUNT.JSON
#  report_state: true
#  exposed_domains:
#    - switch
#    - light
#  entity_config:
#    light.hall_door:
#      name: main door
#
#home-assistant-7390
#Alittlesecret
#https://chef.hassio.sundby.com
#Service acc name: thisisthomasserviceaccountname