Domoticz

Egregius wrote: ↑Saturday 08 February 2020 16:29 Yes, if a blockly can be triggered then the device status update will also trigger the lua script to send the status to php.

It should also be possible to let php subscribe to the same MQTT server and receive the messages even faster.

Egregius wrote: ↑Saturday 08 February 2020 19:15 I can help you with the lua script and pass2php but I have no experience with mqtt. A quick google learned me that it’s possible.

Egregius wrote: ↑Sunday 09 February 2020 10:30 That page get’s included in my floorplan. If you want to execute it directly in a browser you need the include the functions.php file.

madradrakie wrote: ↑Monday 10 February 2020 7:19 I have deleted that part of the code because i am not intend to use the floorplan. I placed all the necessary files at the location as prescribed and added the functions.php and config.php in the _fetchdomoticz file. I have no more errors anymore. Unfortunatley the database is not filled with the switches of domoticz when i trigger one in domoticz. Could this something to do with the fact that i use apache2 instead of nginx?

  require '/var/www/config.php'; 
  require '/var/www/html/secure/functions.php';
  
  $db=new PDO("mysql:host=localhost;dbname=$dbname;",$dbuser,$dbpass);

<?php
/**
 * Pass2PHP
 * php version 7.3.4-2
 *
 * Example config file
 * Can be placed in /var/www/config.php
 *
 * @category Home_Automation
 * @package  Pass2PHP
 * @author   Guy Verschuere <[email protected]>
 * @license  GNU GPLv3
 * @link     https://egregius.be
 **/
error_reporting(E_ALL);
ini_set("display_errors", "on");
date_default_timezone_set('Europe/Brussels');
if (!defined('TIME')) {
    define('TIME', $_SERVER['REQUEST_TIME']);
}
$log=false;
$page=basename($_SERVER['PHP_SELF']);

$dbname='domotica';
$dbuser='domotica';
$dbpass='domotica';

$domoticzurl='http://127.0.0.1:8080';

McMelloW wrote: ↑Monday 10 February 2020 16:47

madradrakie wrote: ↑Monday 10 February 2020 7:19 I have deleted that part of the code because i am not intend to use the floorplan. I placed all the necessary files at the location as prescribed and added the functions.php and config.php in the _fetchdomoticz file. I have no more errors anymore. Unfortunatley the database is not filled with the switches of domoticz when i trigger one in domoticz. Could this something to do with the fact that i use apache2 instead of nginx?

I had the same kind of problem. See previous postings in this thread, the answers are very valuable and helpful.
I think I put these lines at the top of _fetchdomoticz.php

Code: Select all

  require '/var/www/config.php'; 
  require '/var/www/html/secure/functions.php';
  
  $db=new PDO("mysql:host=localhost;dbname=$dbname;",$dbuser,$dbpass);

And stripped config.php to this minimal

Code: Select all

<?php
/**
 * Pass2PHP
 * php version 7.3.4-2
 *
 * Example config file
 * Can be placed in /var/www/config.php
 *
 * @category Home_Automation
 * @package  Pass2PHP
 * @author   Guy Verschuere <[email protected]>
 * @license  GNU GPLv3
 * @link     https://egregius.be
 **/
error_reporting(E_ALL);
ini_set("display_errors", "on");
date_default_timezone_set('Europe/Brussels');
if (!defined('TIME')) {
    define('TIME', $_SERVER['REQUEST_TIME']);
}
$log=false;
$page=basename($_SERVER['PHP_SELF']);

$dbname='domotica';
$dbuser='domotica';
$dbpass='domotica';

$domoticzurl='http://127.0.0.1:8080';

After this it did run without any errors. With PhpMyAdmin, I saw all active devises as a row in the Devices table. Correct me if I am wrong.

Egregius wrote: ↑Tuesday 11 February 2020 7:03

Egregius wrote: ↑Tuesday 11 February 2020 22:29 Idx is only filled while running fetchdomoticz.
That script must also be executed every time you add/change devices in domoticz.

Egregius wrote: ↑Wednesday 12 February 2020 8:32 What is the output of the script?

I've made some small changes in it so the output in CLI mode would be nice.