Pass2PHP

[Trigun]

Found it!

Gonna give it a new try![/quote]
Good stuff! Good luck! Should be easy now!


Sent from my iPhone using Tapatalk

[Trigun]

@sincze, great thanks a lot I am going to look into it



Sent from my iPhone using Tapatalk

[Gertony]

Found it!

Gonna give it a new try!

Good stuff! Good luck! Should be easy now!


Sent from my iPhone using Tapatalk
[/quote]

Should be....

followed almost the complete guide, until i had to import a file in phpMyadmin.
i could'nt find the Egregius database and figured this is only used for the floorplan.

Struggling for a few hours now... and i didn't get it to work.

Only thing i would like is a PIR wich is switching a lamp (fast offcourse, blocky is really to slow)

So i don't need a floorplan ect.
Just would like a working "simple version"
as found here: https://egregius.be/2016/lua-pass2php-v ... planation/

strange thing IMO, i created a lua Device script (like the above page explained) and configured
the right place of the pass2php.php but until now there isnt any sign of a script doing anything.

I am feeling silly right now, but what am i missing?

Thanks in advance!

[sincze]

You'll have to use:

Code: Select all

https://github.com/Egregius/PHP-Floorplan-and-advanced-automation-for-Domoticz/blob/master/secure/Create-Update%20SQL%20Database.txt

to create the database.
Pass2PHP is using it... and floorplans as well. Consider floorplans a nice additional feature to Pass2PHP they used to be 2 separate products created by @Egregius

I don't use floorplans, just Pass2PHP.

[Gertony]

You'll have to use:

Code: Select all

https://github.com/Egregius/PHP-Floorplan-and-advanced-automation-for-Domoticz/blob/master/secure/Create-Update%20SQL%20Database.txt

to create the database.
Pass2PHP is using it... and floorplans as well. Consider floorplans a nice additional feature to Pass2PHP they used to be 2 separate products created by @Egregius

I don't use floorplans, just Pass2PHP.

Can I find a log somewhere?

I followed the complete steps from the how to a couple of pages back, but can't can't see anything happening, don't even see errors or something what would point me to the fault.

[Egregius]

The logfile is configured in the lg function in functions.php
The webservers logfile should also indicate the requests coming from domoticz.

[sincze]

Something strange happens to my Pass2PHP database


If I start Domoticz and force Cache refresh to my Pass2PHP database the SQLDB values are correct.

Code: Select all

M3 Device Status is: 444354.898 m3 Watermeter is: 444241.002 m3

As soon as I update the M3 counter via an Domoricz API call with 1 liter for example ..
Pass2PHP reports:

Code: Select all

2019-11-03 13:46:13.859 New Watermeter: M3 received: 18446744073709437767 with current watermetervalue: 444241.002 m3

So $status is filled by a huge number.. And I don't know why.
The domoticz interface correctly shows 1 liter was added to the sensors value.
However I can't do any calculation as the $status is filled with rubbish and from now on the Watermeter value in Pass2PHP is containing that big number...

Maybe something changed in Domoticz on how counters are now being dealt with .... as my watermeter only sends the amount of LITERS of used water in that minute...
https://www.domoticz.com/wiki/Domoticz_ ... 7s#Counter

It all happened when I updated to the latest Domoticz version available last week. At least that is when I noticed things going south.

[Egregius]

Try to add additional logging in the pass2php file and in the lua script.
But, I'm already shure it's a domoticz thing. The pass2php file only handles the data that is sent to it. Must be that it's already corrupted before it's arrived.

[sincze]

Try to add additional logging in the pass2php file and in the lua script.
But, I'm already shure it's a domoticz thing. The pass2php file only handles the data that is sent to it. Must be that it's already corrupted before it's arrived.

Domoticz thing indeed something changed with incremental counter. Rewrite of PHP and help of flowmeter seems to have solved it. Hahaha. The Pass2PHP never gave me any issues.

[Trigun]

Hi Sincze,

where do you put this function and how do I use it with my devices?

thnx in advance!

[ropske]

hi,

suddenly my domoticz is not working fine anymore, when i want to goto temperatures or Switches tabpage, i get this:

2019-11-04_1.jpg (50.66 KiB) Viewed 1469 times

2019-11-04_2.jpg (51.22 KiB) Viewed 1469 times

if i want to go to myphpadmin page i get this:

2019-11-04_3.jpg (18 KiB) Viewed 1469 times

please help, i'm outside the country for work and my wife is stuck with the system, she cant put on the heater,...
thanks

[ropske]

my passs2php program isnt working anymore either.
no crons are running,...

i don't know what happened

[sincze]

Hi Sincze,

where do you put this function and how do I use it with my devices?

thnx in advance!

The core influxdb function can be located in a separate file.
As I don't want to hassle with Egregius code I created a separte file called functions_custom.php that is included in the following way:

pass2php.php contains:

Code: Select all

define('rootdir','/var/www/html/secure/');
require_once(rootdir.'pass2php_include/settings.php');

settings.php contains:

Code: Select all

require_once(rootdir.'pass2php_include/functions_pass2php.php');
require_once(rootdir.'pass2php_include/functions_custom.php');
require_once(rootdir.'pass2php_include/functions_pass2php_scripts.php');

Now each device that I want to log in influxdb. has its own device.php file.
That file contains:

Code: Select all

<?php
	
	influxdb($device,$status);

So Pass2PHP looks if for that specific device a file is available and calls it... resulting in the function influxdb getting called with the parameters $device and $status.

[Trigun]

Why not pull the plug and restart it?
Did you carry out any updates?



Sent from my iPhone using Tapatalk

[sincze]

my passs2php program isnt working anymore either.
no crons are running,...

i don't know what happened

What does dmesg or pass2php.log / domoticz.log say?

[ropske]

pi@raspberrypi:~ $ dmesg
[ 0.000000] Booting Linux on physical CPU 0x0
[ 0.000000] Linux version 4.19.75-v7+ (dom@buildbot) (gcc version 4.9.3 (cros stool-NG crosstool-ng-1.22.0-88-g8460611)) #1270 SMP Tue Sep 24 18:45:11 BST 201 9
[ 0.000000] CPU: ARMv7 Processor [410fd034] revision 4 (ARMv7), cr=10c5383d
[ 0.000000] CPU: div instructions available: patching division code
[ 0.000000] CPU: PIPT / VIPT nonaliasing data cache, VIPT aliasing instructio n cache
[ 0.000000] OF: fdt: Machine model: Raspberry Pi 3 Model B Plus Rev 1.3
[ 0.000000] Memory policy: Data cache writealloc
[ 0.000000] cma: Reserved 8 MiB at 0x3ac00000
[ 0.000000] On node 0 totalpages: 242688
[ 0.000000] Normal zone: 2133 pages used for memmap
[ 0.000000] Normal zone: 0 pages reserved
[ 0.000000] Normal zone: 242688 pages, LIFO batch:63
[ 0.000000] random: get_random_bytes called from start_kernel+0xac/0x4b4 with crng_init=0
[ 0.000000] percpu: Embedded 17 pages/cpu s39488 r8192 d21952 u69632
[ 0.000000] pcpu-alloc: s39488 r8192 d21952 u69632 alloc=17*4096
[ 0.000000] pcpu-alloc: [0] 0 [0] 1 [0] 2 [0] 3
[ 0.000000] Built 1 zonelists, mobility grouping on. Total pages: 240555
[ 0.000000] Kernel command line: coherent_pool=1M 8250.nr_uarts=0 bcm2708_fb. fbwidth=656 bcm2708_fb.fbheight=416 bcm2708_fb.fbswap=1 vc_mem.mem_base=0x3ec000 00 vc_mem.mem_size=0x40000000 dwc_otg.lpm_enable=0 console=ttyS0,115200 console =tty1 root=PARTUUID=a7b9b6e2-02 rootfstype=ext4 elevator=deadline fsck.repair=ye s rootwait
[ 0.000000] Dentry cache hash table entries: 131072 (order: 7, 524288 bytes)
[ 0.000000] Inode-cache hash table entries: 65536 (order: 6, 262144 bytes)
[ 0.000000] Memory: 939088K/970752K available (8192K kernel code, 629K rwdata , 2176K rodata, 1024K init, 821K bss, 23472K reserved, 8192K cma-reserved)
[ 0.000000] Virtual kernel memory layout:
vector : 0xffff0000 - 0xffff1000 ( 4 kB)
fixmap : 0xffc00000 - 0xfff00000 (3072 kB)
vmalloc : 0xbb800000 - 0xff800000 (1088 MB)
lowmem : 0x80000000 - 0xbb400000 ( 948 MB)
modules : 0x7f000000 - 0x80000000 ( 16 MB)
.text : 0x(ptrval) - 0x(ptrval) (9184 kB)
.init : 0x(ptrval) - 0x(ptrval) (1024 kB)
.data : 0x(ptrval) - 0x(ptrval) ( 630 kB)
.bss : 0x(ptrval) - 0x(ptrval) ( 822 kB)
[ 0.000000] SLUB: HWalign=64, Order=0-3, MinObjects=0, CPUs=4, Nodes=1
[ 0.000000] ftrace: allocating 26399 entries in 78 pages
[ 0.000000] rcu: Hierarchical RCU implementation.
[ 0.000000] NR_IRQS: 16, nr_irqs: 16, preallocated irqs: 16
[ 0.000000] arch_timer: cp15 timer(s) running at 19.20MHz (phys).
[ 0.000000] clocksource: arch_sys_counter: mask: 0xffffffffffffff max_cycles: 0x46d987e47, max_idle_ns: 440795202767 ns
[ 0.000007] sched_clock: 56 bits at 19MHz, resolution 52ns, wraps every 43980 46511078ns
[ 0.000023] Switching to timer-based delay loop, resolution 52ns
[ 0.000290] Console: colour dummy device 80x30
[ 0.000910] console [tty1] enabled
[ 0.000967] Calibrating delay loop (skipped), value calculated using timer fr equency.. 38.40 BogoMIPS (lpj=192000)
[ 0.001012] pid_max: default: 32768 minimum: 301
[ 0.001370] Mount-cache hash table entries: 2048 (order: 1, 8192 bytes)
[ 0.001406] Mountpoint-cache hash table entries: 2048 (order: 1, 8192 bytes)
[ 0.002341] CPU: Testing write buffer coherency: ok
[ 0.002826] CPU0: thread -1, cpu 0, socket 0, mpidr 80000000
[ 0.003497] Setting up static identity map for 0x100000 - 0x10003c
[ 0.003664] rcu: Hierarchical SRCU implementation.
[ 0.004478] smp: Bringing up secondary CPUs ...
[ 0.005340] CPU1: thread -1, cpu 1, socket 0, mpidr 80000001
[ 0.006269] CPU2: thread -1, cpu 2, socket 0, mpidr 80000002
[ 0.007133] CPU3: thread -1, cpu 3, socket 0, mpidr 80000003
[ 0.007255] smp: Brought up 1 node, 4 CPUs
[ 0.007336] SMP: Total of 4 processors activated (153.60 BogoMIPS).
[ 0.007361] CPU: All CPU(s) started in HYP mode.
[ 0.007381] CPU: Virtualization extensions available.
[ 0.008371] devtmpfs: initialized
[ 0.021498] VFP support v0.3: implementor 41 architecture 3 part 40 variant 3 rev 4
[ 0.021767] clocksource: jiffies: mask: 0xffffffff max_cycles: 0xffffffff, ma x_idle_ns: 19112604462750000 ns
[ 0.021816] futex hash table entries: 1024 (order: 4, 65536 bytes)
[ 0.022435] pinctrl core: initialized pinctrl subsystem
[ 0.023308] NET: Registered protocol family 16
[ 0.026302] DMA: preallocated 1024 KiB pool for atomic coherent allocations
[ 0.031961] hw-breakpoint: found 5 (+1 reserved) breakpoint and 4 watchpoint registers.
[ 0.031998] hw-breakpoint: maximum watchpoint size is 8 bytes.
[ 0.032221] Serial: AMBA PL011 UART driver
[ 0.034533] bcm2835-mbox 3f00b880.mailbox: mailbox enabled
[ 0.069123] bcm2835-dma 3f007000.dma: DMA legacy API manager at (ptrval), dma chans=0x1
[ 0.071056] SCSI subsystem initialized
[ 0.071301] usbcore: registered new interface driver usbfs
[ 0.071382] usbcore: registered new interface driver hub
[ 0.071494] usbcore: registered new device driver usb
[ 0.090301] raspberrypi-firmware soc:firmware: Attached to firmware from 2019 -09-24 17:37, variant start
[ 0.100130] raspberrypi-firmware soc:firmware: Firmware hash is 6820edeee4ef3 891b95fc01cf02a7abd7ca52f17
[ 0.111773] clocksource: Switched to clocksource arch_sys_counter
[ 0.201258] VFS: Disk quotas dquot_6.6.0
[ 0.201368] VFS: Dquot-cache hash table entries: 1024 (order 0, 4096 bytes)
[ 0.201581] FS-Cache: Loaded
[ 0.201811] CacheFiles: Loaded
[ 0.211850] NET: Registered protocol family 2
[ 0.212638] tcp_listen_portaddr_hash hash table entries: 512 (order: 0, 6144 bytes)
[ 0.212704] TCP established hash table entries: 8192 (order: 3, 32768 bytes)
[ 0.212848] TCP bind hash table entries: 8192 (order: 4, 65536 bytes)
[ 0.213053] TCP: Hash tables configured (established 8192 bind 8192)
[ 0.213214] UDP hash table entries: 512 (order: 2, 16384 bytes)
[ 0.213281] UDP-Lite hash table entries: 512 (order: 2, 16384 bytes)
[ 0.213612] NET: Registered protocol family 1
[ 0.214219] RPC: Registered named UNIX socket transport module.
[ 0.214246] RPC: Registered udp transport module.
[ 0.214268] RPC: Registered tcp transport module.
[ 0.214289] RPC: Registered tcp NFSv4.1 backchannel transport module.
[ 0.215921] hw perfevents: enabled with armv7_cortex_a7 PMU driver, 7 counter s available
[ 0.218938] Initialise system trusted keyrings
[ 0.219146] workingset: timestamp_bits=14 max_order=18 bucket_order=4
[ 0.228986] FS-Cache: Netfs 'nfs' registered for caching
[ 0.229574] NFS: Registering the id_resolver key type
[ 0.229631] Key type id_resolver registered
[ 0.229653] Key type id_legacy registered
[ 0.229685] nfs4filelayout_init: NFSv4 File Layout Driver Registering...
[ 0.232030] Key type asymmetric registered
[ 0.232059] Asymmetric key parser 'x509' registered
[ 0.232126] Block layer SCSI generic (bsg) driver version 0.4 loaded (major 2 50)
[ 0.232312] io scheduler noop registered
[ 0.232337] io scheduler deadline registered (default)
[ 0.232533] io scheduler cfq registered
[ 0.232557] io scheduler mq-deadline registered (default)
[ 0.232581] io scheduler kyber registered
[ 0.234788] bcm2708_fb soc:fb: FB found 1 display(s)
[ 0.244104] Console: switching to colour frame buffer device 82x26
[ 0.250938] bcm2708_fb soc:fb: Registered framebuffer for display 0, size 656 x416
[ 0.257668] bcm2835-rng 3f104000.rng: hwrng registered
[ 0.260344] vc-mem: phys_addr:0x00000000 mem_base=0x3ec00000 mem_size:0x40000 000(1024 MiB)
[ 0.265672] vc-sm: Videocore shared memory driver
[ 0.268422] gpiomem-bcm2835 3f200000.gpiomem: Initialised: Registers at 0x3f2 00000
[ 0.284253] brd: module loaded
[ 0.296902] loop: module loaded
[ 0.299952] Loading iSCSI transport class v2.0-870.
[ 0.303151] libphy: Fixed MDIO Bus: probed
[ 0.305656] usbcore: registered new interface driver lan78xx
[ 0.308111] usbcore: registered new interface driver smsc95xx
[ 0.310462] dwc_otg: version 3.00a 10-AUG-2012 (platform bus)
[ 0.338307] dwc_otg 3f980000.usb: base=(ptrval)
[ 0.540924] Core Release: 2.80a
[ 0.543353] Setting default values for core params
[ 0.545800] Finished setting default values for core params
[ 0.748551] Using Buffer DMA mode
[ 0.750939] Periodic Transfer Interrupt Enhancement - disabled
[ 0.753383] Multiprocessor Interrupt Enhancement - disabled
[ 0.755760] OTG VER PARAM: 0, OTG VER FLAG: 0
[ 0.758107] Dedicated Tx FIFOs mode
[ 0.760810] WARN::dwc_otg_hcd_init:1045: FIQ DMA bounce buffers: virt = bad14 000 dma = 0xfad14000 len=9024
[ 0.765415] FIQ FSM acceleration enabled for :
Non-periodic Split Transactions
Periodic Split Transactions
High-Speed Isochronous Endpoints
Interrupt/Control Split Transaction hack enabled
[ 0.776350] dwc_otg: Microframe scheduler enabled
[ 0.776410] WARN::hcd_init_fiq:457: FIQ on core 1
[ 0.778642] WARN::hcd_init_fiq:458: FIQ ASM at 80655664 length 36
[ 0.780859] WARN::hcd_init_fiq:497: MPHI regs_base at bb810000
[ 0.783125] dwc_otg 3f980000.usb: DWC OTG Controller
[ 0.785392] dwc_otg 3f980000.usb: new USB bus registered, assigned bus number 1
[ 0.787717] dwc_otg 3f980000.usb: irq 56, io mem 0x00000000
[ 0.790023] Init: Port Power? op_state=1
[ 0.792294] Init: Power Port (0)
[ 0.794717] usb usb1: New USB device found, idVendor=1d6b, idProduct=0002, bc dDevice= 4.19
[ 0.799230] usb usb1: New USB device strings: Mfr=3, Product=2, SerialNumber= 1
[ 0.801645] usb usb1: Product: DWC OTG Controller
[ 0.804038] usb usb1: Manufacturer: Linux 4.19.75-v7+ dwc_otg_hcd
[ 0.806470] usb usb1: SerialNumber: 3f980000.usb
[ 0.809422] hub 1-0:1.0: USB hub found
[ 0.811697] hub 1-0:1.0: 1 port detected
[ 0.814483] dwc_otg: FIQ enabled
[ 0.814489] dwc_otg: NAK holdoff enabled
[ 0.814494] dwc_otg: FIQ split-transaction FSM enabled
[ 0.814505] Module dwc_common_port init
[ 0.814778] usbcore: registered new interface driver usb-storage
[ 0.817241] mousedev: PS/2 mouse device common for all mice
[ 0.820390] bcm2835-wdt bcm2835-wdt: Broadcom BCM2835 watchdog timer
[ 0.823050] bcm2835-cpufreq: min=600000 max=1400000
[ 0.825875] sdhci: Secure Digital Host Controller Interface driver
[ 0.828293] sdhci: Copyright(c) Pierre Ossman
[ 0.831066] mmc-bcm2835 3f300000.mmcnr: could not get clk, deferring probe
[ 0.834005] sdhost-bcm2835 3f202000.mmc: could not get clk, deferring probe
[ 0.836684] sdhci-pltfm: SDHCI platform and OF driver helper
[ 0.840779] ledtrig-cpu: registered to indicate activity on CPUs
[ 0.843538] hidraw: raw HID events driver (C) Jiri Kosina
[ 0.846312] usbcore: registered new interface driver usbhid
[ 0.848949] usbhid: USB HID core driver
[ 0.852304] vchiq: vchiq_init_state: slot_zero = (ptrval), is_master = 0
[ 0.856438] [vc_sm_connected_init]: start
[ 0.865181] [vc_sm_connected_init]: end - returning 0
[ 0.868728] Initializing XFRM netlink socket
[ 0.871158] NET: Registered protocol family 17
[ 0.873697] Key type dns_resolver registered
[ 0.876543] Registering SWP/SWPB emulation handler
[ 0.879643] registered taskstats version 1
[ 0.882084] Loading compiled-in X.509 certificates
[ 0.891829] uart-pl011 3f201000.serial: cts_event_workaround enabled
[ 0.894364] 3f201000.serial: ttyAMA0 at MMIO 0x3f201000 (irq = 81, base_baud = 0) is a PL011 rev2
[ 0.901135] mmc-bcm2835 3f300000.mmcnr: mmc_debug:0 mmc_debug2:0
[ 0.903717] mmc-bcm2835 3f300000.mmcnr: DMA channel allocated
[ 0.932400] sdhost: log_buf @ (ptrval) (fad13000)
[ 0.969801] mmc1: queuing unknown CIS tuple 0x80 (2 bytes)
[ 0.973797] mmc1: queuing unknown CIS tuple 0x80 (3 bytes)
[ 0.977659] mmc1: queuing unknown CIS tuple 0x80 (3 bytes)
[ 0.982666] mmc1: queuing unknown CIS tuple 0x80 (7 bytes)
[ 0.984797] mmc0: sdhost-bcm2835 loaded - DMA enabled (>1)
[ 0.988177] of_cfs_init
[ 0.990304] of_cfs_init: OK
[ 0.992841] Waiting for root device PARTUUID=a7b9b6e2-02...
[ 1.031905] Indeed it is in host mode hprt0 = 00021501
[ 1.077442] random: fast init done
[ 1.089648] mmc1: new high speed SDIO card at address 0001
[ 1.241810] usb 1-1: new high-speed USB device number 2 using dwc_otg
[ 1.244077] Indeed it is in host mode hprt0 = 00001101
[ 1.482062] usb 1-1: New USB device found, idVendor=0424, idProduct=2514, bcd Device= b.b3
[ 1.486441] usb 1-1: New USB device strings: Mfr=0, Product=0, SerialNumber=0
[ 1.489320] hub 1-1:1.0: USB hub found
[ 1.491586] hub 1-1:1.0: 4 ports detected
[ 1.811800] usb 1-1.1: new high-speed USB device number 3 using dwc_otg
[ 1.942044] usb 1-1.1: New USB device found, idVendor=0424, idProduct=2514, b cdDevice= b.b3
[ 1.946433] usb 1-1.1: New USB device strings: Mfr=0, Product=0, SerialNumber =0
[ 1.949392] hub 1-1.1:1.0: USB hub found
[ 1.951984] hub 1-1.1:1.0: 3 ports detected
[ 2.271803] usb 1-1.1.2: new full-speed USB device number 4 using dwc_otg
[ 2.405014] usb 1-1.1.2: New USB device found, idVendor=0658, idProduct=0200, bcdDevice= 0.00
[ 2.410288] usb 1-1.1.2: New USB device strings: Mfr=0, Product=0, SerialNumb er=0
[ 2.511803] usb 1-1.1.3: new full-speed USB device number 5 using dwc_otg
[ 2.670509] usb 1-1.1.3: New USB device found, idVendor=0403, idProduct=6001, bcdDevice= 6.00
[ 2.676317] usb 1-1.1.3: New USB device strings: Mfr=1, Product=2, SerialNumb er=3
[ 2.682203] usb 1-1.1.3: Product: FT232R USB UART
[ 2.685115] usb 1-1.1.3: Manufacturer: FTDI
[ 2.687912] usb 1-1.1.3: SerialNumber: A142U47T
[ 2.781799] usb 1-1.2: new high-speed USB device number 6 using dwc_otg
[ 2.913552] usb 1-1.2: New USB device found, idVendor=04e8, idProduct=61f5, b cdDevice= 1.00
[ 2.919164] usb 1-1.2: New USB device strings: Mfr=2, Product=3, SerialNumber =1
[ 2.922098] usb 1-1.2: Product: Portable SSD T5
[ 2.924906] usb 1-1.2: Manufacturer: Samsung
[ 2.927640] usb 1-1.2: SerialNumber: 1234567E6FFA
[ 2.931031] usb 1-1.2: The driver for the USB controller dwc_otg_hcd does not support scatter-gather which is
[ 2.936622] usb 1-1.2: required by the UAS driver. Please try an other USB co ntroller if you wish to use UAS.
[ 2.942292] usb-storage 1-1.2:1.0: USB Mass Storage device detected
[ 2.945809] scsi host0: usb-storage 1-1.2:1.0
[ 3.011807] usb 1-1.1.1: new high-speed USB device number 7 using dwc_otg
[ 3.142197] usb 1-1.1.1: New USB device found, idVendor=0424, idProduct=7800, bcdDevice= 3.00
[ 3.147630] usb 1-1.1.1: New USB device strings: Mfr=0, Product=0, SerialNumb er=0
[ 3.417598] lan78xx 1-1.1.1:1.0 (unnamed net_device) (uninitialized): No Exte rnal EEPROM. Setting MAC Speed
[ 3.424440] libphy: lan78xx-mdiobus: probed
[ 3.432722] lan78xx 1-1.1.1:1.0 (unnamed net_device) (uninitialized): int urb period 64
[ 3.992599] scsi 0:0:0:0: Direct-Access Samsung Portable SSD T5 0 PQ : 0 ANSI: 6
[ 3.999426] sd 0:0:0:0: [sda] 976773168 512-byte logical blocks: (500 GB/466 GiB)
[ 4.006268] sd 0:0:0:0: [sda] Write Protect is off
[ 4.009471] sd 0:0:0:0: [sda] Mode Sense: 43 00 00 00
[ 4.010257] sd 0:0:0:0: [sda] Write cache: enabled, read cache: enabled, does n't support DPO or FUA
[ 4.018959] sda: sda1 sda2
[ 4.024596] sd 0:0:0:0: [sda] Attached SCSI disk
[ 4.073506] EXT4-fs (sda2): mounted filesystem with ordered data mode. Opts: (null)
[ 4.079589] VFS: Mounted root (ext4 filesystem) readonly on device 8:2.
[ 4.083430] devtmpfs: mounted
[ 4.091740] Freeing unused kernel memory: 1024K
[ 4.095134] Run /sbin/init as init process
[ 4.474257] systemd[1]: System time before build time, advancing clock.
[ 4.565524] NET: Registered protocol family 10
[ 4.569798] Segment Routing with IPv6
[ 4.610432] systemd[1]: systemd 241 running in system mode. (+PAM +AUDIT +SEL INUX +IMA +APPARMOR +SMACK +SYSVINIT +UTMP +LIBCRYPTSETUP +GCRYPT +GNUTLS +ACL + XZ +LZ4 +SECCOMP +BLKID +ELFUTILS +KMOD -IDN2 +IDN -PCRE2 default-hierarchy=hybr id)
[ 4.620069] systemd[1]: Detected architecture arm.
[ 4.644444] systemd[1]: Set hostname to <raspberrypi>.
[ 4.652885] systemd[1]: Failed to bump fs.file-max, ignoring: Invalid argumen t
[ 4.908566] systemd-fstab-generator[88]: Checking was requested for "//192.16 8.1.163/Stijn/", but it is not a device.
[ 4.987275] systemd[1]: File /lib/systemd/system/systemd-journald.service:12 configures an IP firewall (IPAddressDeny=any), but the local system does not sup port BPF/cgroup based firewalling.
[ 4.996017] systemd[1]: Proceeding WITHOUT firewalling in effect! (This warni ng is only shown for the first loaded unit using IP firewalling.)
[ 5.474281] random: systemd: uninitialized urandom read (16 bytes read)
[ 5.494041] random: systemd: uninitialized urandom read (16 bytes read)
[ 5.502729] systemd[1]: Created slice system-systemd\x2dfsck.slice.
[ 5.509636] random: systemd: uninitialized urandom read (16 bytes read)
[ 5.513567] systemd[1]: Listening on Journal Socket.
[ 5.520428] systemd[1]: Listening on initctl Compatibility Named Pipe.
[ 5.527766] systemd[1]: Condition check resulted in Huge Pages File System be ing skipped.
[ 5.585855] random: crng init done
[ 5.588822] random: 5 urandom warning(s) missed due to ratelimiting
[ 5.782049] i2c /dev entries driver
[ 7.738084] EXT4-fs (sda2): re-mounted. Opts: (null)
[ 7.888164] systemd-journald[117]: Received request to flush runtime journal from PID 1
[ 8.502454] vc_sm_cma: module is from the staging directory, the quality is u nknown, you have been warned.
[ 8.502682] media: Linux media interface: v0.10
[ 8.522781] bcm2835_vc_sm_cma_probe: Videocore shared memory driver
[ 8.522797] [vc_sm_connected_init]: start
[ 8.532859] [vc_sm_connected_init]: installed successfully
[ 8.543628] videodev: Linux video capture interface: v2.00
[ 8.589443] bcm2835_mmal_vchiq: module is from the staging directory, the qua lity is unknown, you have been warned.
[ 8.610709] bcm2835_v4l2: module is from the staging directory, the quality i s unknown, you have been warned.
[ 8.627740] snd_bcm2835: module is from the staging directory, the quality is unknown, you have been warned.
[ 8.647000] bcm2835_audio soc:audio: card created with 8 channels
[ 8.650377] bcm2835_codec: module is from the staging directory, the quality is unknown, you have been warned.
[ 8.667536] bcm2835-codec bcm2835-codec: Device registered as /dev/video10
[ 8.667632] bcm2835-codec bcm2835-codec: Loaded V4L2 decode
[ 8.675586] bcm2835-codec bcm2835-codec: Device registered as /dev/video11
[ 8.676790] bcm2835-codec bcm2835-codec: Loaded V4L2 encode
[ 8.686794] bcm2835-codec bcm2835-codec: Device registered as /dev/video12
[ 8.686842] bcm2835-codec bcm2835-codec: Loaded V4L2 isp
[ 8.783183] cfg80211: Loading compiled-in X.509 certificates for regulatory d atabase
[ 8.883831] usbcore: registered new interface driver uas
[ 8.915172] cfg80211: Loaded X.509 cert 'sforshee: 00b28ddf47aef9cea7'
[ 8.959554] cdc_acm 1-1.1.2:1.0: ttyACM0: USB ACM device
[ 8.974900] usbcore: registered new interface driver cdc_acm
[ 8.974913] cdc_acm: USB Abstract Control Model driver for USB modems and ISD N adapters
[ 8.976920] usbcore: registered new interface driver usbserial_generic
[ 8.976991] usbserial: USB Serial support registered for generic
[ 8.985689] brcmfmac: F1 signature read @0x18000000=0x15264345
[ 8.995094] usbcore: registered new interface driver ftdi_sio
[ 8.995214] usbserial: USB Serial support registered for FTDI USB Serial Devi ce
[ 8.995773] ftdi_sio 1-1.1.3:1.0: FTDI USB Serial Device converter detected
[ 8.995786] brcmfmac: brcmf_fw_alloc_request: using brcm/brcmfmac43455-sdio f or chip BCM4345/6
[ 8.995970] usb 1-1.1.3: Detected FT232RL
[ 8.996607] usbcore: registered new interface driver brcmfmac
[ 9.011940] usb 1-1.1.3: FTDI USB Serial Device converter now attached to tty USB0
[ 9.024557] sd 0:0:0:0: Attached scsi generic sg0 type 0
[ 9.234947] brcmfmac: brcmf_fw_alloc_request: using brcm/brcmfmac43455-sdio f or chip BCM4345/6
[ 9.248631] brcmfmac: brcmf_c_preinit_dcmds: Firmware: BCM4345/6 wl0: Feb 27 2018 03:15:32 version 7.45.154 (r684107 CY) FWID 01-4fbe0b04
[ 12.052742] uart-pl011 3f201000.serial: no DMA platform data
[ 12.171690] 8021q: 802.1Q VLAN Support v1.8
[ 12.446224] Adding 102396k swap on /var/swap. Priority:-2 extents:1 across:1 02396k FS
[ 12.592013] IPv6: ADDRCONF(NETDEV_UP): wlan0: link is not ready
[ 12.592030] brcmfmac: power management disabled
[ 12.647885] FS-Cache: Netfs 'cifs' registered for caching
[ 12.648544] Key type cifs.spnego registered
[ 12.648567] Key type cifs.idmap registered
[ 12.653696] No dialect specified on mount. Default has changed to a more secu re dialect, SMB2.1 or later (e.g. SMB3), from CIFS (SMB1). To use the less secur e SMB1 dialect to access old servers which do not support SMB3 (or SMB2.1) speci fy vers=1.0 on mount.
[ 12.693578] CIFS VFS: Error connecting to socket. Aborting operation.
[ 12.693596] CIFS VFS: cifs_mount failed w/return code = -101
[ 13.087754] IPv6: ADDRCONF(NETDEV_UP): eth0: link is not ready
[ 13.087768] 8021q: adding VLAN 0 to HW filter on device eth0
[ 13.125809] IPv6: ADDRCONF(NETDEV_CHANGE): eth0: link becomes ready
[ 18.829718] Bluetooth: Core ver 2.22
[ 18.829768] NET: Registered protocol family 31
[ 18.829784] Bluetooth: HCI device and connection manager initialized
[ 18.829798] Bluetooth: HCI socket layer initialized
[ 18.829805] Bluetooth: L2CAP socket layer initialized
[ 18.829825] Bluetooth: SCO socket layer initialized
[ 18.844462] Bluetooth: HCI UART driver ver 2.3
[ 18.844470] Bluetooth: HCI UART protocol H4 registered
[ 18.846675] Bluetooth: HCI UART protocol Three-wire (H5) registered
[ 18.849215] Bluetooth: HCI UART protocol Broadcom registered
[ 19.173204] Bluetooth: BNEP (Ethernet Emulation) ver 1.3
[ 19.173214] Bluetooth: BNEP filters: protocol multicast
[ 19.173231] Bluetooth: BNEP socket layer initialized
[ 19.278305] Bluetooth: RFCOMM TTY layer initialized
[ 19.278355] Bluetooth: RFCOMM socket layer initialized
[ 19.278376] Bluetooth: RFCOMM ver 1.11
pi@raspberrypi:~ $

[Trigun]

Hi Sincze,
a few questions

I created a file called: functions_custom.php
But also I have totaly different locations
I also see you have a folder in the rootdir(/pass2php_include) right?

The stuff below don't make sense to me as I dont' have such files.

settings.php contains: --> I don't have a settings file, what are you using it for?
require_once(rootdir.'pass2php_include/functions_pass2php.php'); this is also a file I don't have
require_once(rootdir.'pass2php_include/functions_custom.php'); this is the one i've created
require_once(rootdir.'pass2php_include/functions_pass2php_scripts.php'); I also don't have this one?

hope you can help me out here.

thnx!

[ropske]

Why not pull the plug and restart it?
Did you carry out any updates?



Sent from my iPhone using Tapatalk

i already tried to reboot it, but the problems stays

[ropske]

ok, update:

after doing this again:
GRANT ALL PRIVILEGES ON *.* TO 'domotica'@'localhost' IDENTIFIED BY 'domotica';

i can access my phpmyadmin page again and pass2php is running again (i can see in the debug logging i activated)

Now, i still don't get a working dashboard/switches and temperatures tabpage in Domoticz.

I'm just wondering why/how it comes this suddenly happened??

[ropske]

and when i want to open other php files for example /secure/domoticz_devices.php
it is downloading the php file instead of opening it

running /secure/phpinfo.php is working well then
??
realy strange things