PHP Errors and not logging

[bobreese]

After installing the plugin, I am getting a log of errors in the apache2-error.log file
[Wed Dec 10 21:31:01.421137 2025] [proxy_fcgi:error] [pid 975:tid 1071] [client 127.0.0.1:34254] AH01071: Got error 'PHP message: PHP Warning: Undefined variable $settings in /home/fpp/media/plugins/fpp-plugin-AdvancedStats/api.php on line 7; PHP message: PHP Warning: Trying to access array offset on value of type null in /home/fpp/media/plugins/fpp-plugin-AdvancedStats/api.php on line 7'
[Wed Dec 10 21:31:01.421623 2025] [proxy_fcgi:error] [pid 976:tid 1030] [client 192.168.1.252:55566] AH01071: Got error 'PHP message: PHP Warning: Undefined variable $settings in /home/fpp/media/plugins/fpp-plugin-AdvancedStats/api.php on line 7; PHP message: PHP Warning: Trying to access array offset on value of type null in /home/fpp/media/plugins/fpp-plugin-AdvancedStats/api.php on line 7', referer: http://192.168.1.118/filemanager.php

FPP_Logs_20251210.2318.zip
I am hoping to do some extensive testing with this new plugin.
Bob

[bobreese]

@OnlineDynamic
Another possible issue:
sudo mosquitto_sub -h localhost -t "falcon/player/#" -v
Returns
Connection error: Connection Refused: not authorised.

[OnlineDynamic]

Hi Bob - will have a look into this for you...

Are you running fpp 9.4?

The pluggin is very hot off the press and needs new core functionality that i added in 9.4

[OnlineDynamic]

Hi - can answer my own question I can see you are on 9.4 - I have just pushed a fix for the original error you reported and updated the mqtt_setup documentation to higlight that you need to pass authorisation details:

command should be:
mosquitto_sub -h localhost -u fpp -P falcon -t '#' -v -C 1

[bobreese]

Thank you sir!!
The errors are all cleared up and the mosuitto_sub returned properly.

Question: Should the plugin register and or show an fscq being run on a remote Pi? Currently it does not.
Also, I am building a testing station for testing different types of GPIO buttons and sensors using this Pi hat.
https://a.co/d/gw3FXgS

I am including the current log files what I did play a sequence on this Pi (remote) started from my Player Pi.

FPP_Logs_20251212.2110.zip
Here is the backup jason file from my remote and currently testing this on.

SantaFPP_all-backup_v9_20251212152054.json

[bobreese]

@OnlineDynamic

Installed a fresh install of 9.4 on a new Pi4 named GPIOTest.

Created a playlist called Music and added the song Carol of the Bells.mp3
Under Input/Ouput Setup - GPIO
Actviated P1-11 0/17 Pull Up Debounce 100 Commands: Falling Edge:
Command: Start Playlist
Multisync: Not Checked
Playlisy Name: Music
Repeat: Not Checked
If Not Running: Checked

Connected a button to GPIO P1-11
When I push the button the Playlst "Music" starts.
Nothing is registered in Advanced Stats Dashboard (No GPIO, No Sequence Played, etc).

Using the Advanced Stats Pluin - Help & About.
Ran and checked the chown www-data:www-data in SSH, all set read write for that user.
Checked mosquitto_sub -h localhost -u fpp -P falcon -t '#' -v -C 1
Retured: //falcon/player/GPIOTest/ststus idle
(in the help section, the last update did not change the new mosuitto_sub command to include the -C 1 )

tail -50 /var/log/fpp/fpp.log | grep -i "advancedstats|mqtt" #
tail: cannot open 'var/log/fpp.log' for reading: No such file or directory

ps aux | grep mqtt_listener #
root 1521 0.0 4.1 38940 31792 ? S 12:10 0:02 python3 /home/fpp/media/plugins/fpp-plugin-AdvancedStats/mqtt_listener.py
fpp 4305 0.0 0.2 7532 2000 pts/0 S+ 16:42 0:00 grep --color=auto mqtt_listener

sqlite3 /home/fpp/media/config/plugin.fpp-plugin-AdvancedStats.db "SELECT COUNT(*) FROM sequence_history;" #
0

sudo systemctl status mosquitto #
● mosquitto.service - Mosquitto MQTT Broker
Loaded: loaded (;;file://GPIOTest/lib/systemd/system/mosquitto.service/lib/systemd/system/mosquitto.service;;; enabled; preset: enabled)
Active: active (running) since Sat 2025-12-13 12:09:54 CST; 4h 34min ago
Docs: ;;man:mosquitto.conf(5)man:mosquitto.conf(5);;
;;man:mosquitto(8)man:mosquitto(8);;
Process: 716 ExecStartPre=/bin/mkdir -m 740 -p /var/log/mosquitto (code=exited, status=0/SUCCESS)
Process: 731 ExecStartPre=/bin/chown mosquitto /var/log/mosquitto (code=exited, status=0/SUCCESS)
Process: 732 ExecStartPre=/bin/mkdir -m 740 -p /run/mosquitto (code=exited, status=0/SUCCESS)
Process: 733 ExecStartPre=/bin/chown mosquitto /run/mosquitto (code=exited, status=0/SUCCESS)
Main PID: 739 (mosquitto)
Tasks: 1 (limit: 1129)
CPU: 6.001s
CGroup: /system.slice/mosquitto.service
└─739 /usr/sbin/mosquitto -c /etc/mosquitto/mosquitto.conf

Dec 13 12:09:54 GPIOTest systemd[1]: Starting mosquitto.service - Mosquitto MQTT Broker...
Dec 13 12:09:54 GPIOTest mosquitto[739]: 1765649394: Loading config file /etc/mosquitto/conf.d/fpp_local_broker.conf
Dec 13 12:09:54 GPIOTest systemd[1]: Started mosquitto.service - Mosquitto MQTT Broker.

[OnlineDynamic]

Hi - if you update the plugin you will see I added a new 'Support' tab in the help page - can you please use the functionality there to pull of the diagnostic data for your system and paste it here so I have more to work off

[bobreese]

The copy to clip board did not seem to work so I manually copied the info you requested.

=== ADVANCED STATS PLUGIN - SYSTEM DIAGNOSTICS ===
Generated: 2025-12-16 05:50:11 CST

--- FPP CORE INFORMATION ---
FPP Version: 9.4
FPP Branch: v9.4
OS Version: v2025-11
Platform: Raspberry Pi
Variant: Pi 4
Hardware Model: Raspberry Pi 4 Model B Rev 1.5
Operating System: Raspbian GNU/Linux 12 (bookworm)
Kernel Version: 6.12.57-v7l+

--- ADVANCED STATS PLUGIN INFORMATION ---
Plugin Name: Advanced Stats Plugin
Plugin Author: Stuart Ledingham (onlinedynamic)
Git Commit: 682a0e8
Git Branch: master

--- MQTT CONFIGURATION ---
Local MQTT Broker Service: Active (enabled at boot)
MQTT Client Configured: Yes
MQTT Host: localhost
MQTT Port: 1883
MQTT Prefix: /
MQTT Username: Configured
MQTT Password: Configured (hidden)
MQTT CA Certificate: Not Set

MQTT Broker Connection Test:
Broker: Reachable (authentication required)
Status: Broker is running but requires credentials

--- MQTT LISTENER STATUS ---
MQTT Listener: Running (PID: 31315)
Listener Uptime: 00:57

--- DATABASE INFORMATION ---
Database File: Exists
Database Size: 0.07 MB
sequences: 0 records
playlists: 0 records
gpio_events: 0 records
commands: 0 records
command_presets: 0 records

--- SYSTEM RESOURCES ---
Root Disk Usage: 3%
Media Disk Usage: 3%
Memory Usage: 254Mi/739Mi
CPU Load (1/5/15 min): 0.08 0.03 0.00
System Uptime: up 2 days, 17 hours, 40 minutes

--- PYTHON ENVIRONMENT ---
Python Version: Python 3.11.2
paho-mqtt: NOT INSTALLED
sqlite3: Installed

--- RECENT LOG ENTRIES (Last 20 lines) ---
sequence
media
playlist
sequence
Stopping Advanced Stats MQTT listener...
MQTT listener stopped successfully
media
playlist
sequence
Starting Advanced Stats MQTT listener...
MQTT listener started with PID: 31315
[2025-12-16 05:49:14] ============================================================
[2025-12-16 05:49:14] Advanced Stats Plugin - MQTT Listener Starting
[2025-12-16 05:49:14] ============================================================
[2025-12-16 05:49:14] Database connection initialized
[2025-12-16 05:49:14] Loaded descriptions for 1 GPIO pins
[2025-12-16 05:49:14] Connecting to MQTT broker at localhost:1883...
[2025-12-16 05:49:14] MQTT listener is running. Press Ctrl+C to stop.
[2025-12-16 05:49:14] Connected to MQTT broker successfully
[2025-12-16 05:49:14] Subscribed to: falcon/player/+/#

=== END OF DIAGNOSTICS ===

[bobreese]

GPIOTest.zip

GPIOTest_all-backup_v9_20251216064008.json

FYI: I am normally in the xLights zoom room at 6:30am Chicago USA time and in and out throughout the day.

[bobreese]

On a whim, I made the following changes to MQTT
Publish Playlist Frequency [1]
Publish Port Status Frequency [1]
Publish FPPD Status Frequency [1]
Subscribe Topics [#]

Nothing is being reported to MQTT.
fyi: my email is lightsonwalnut@gmail.com

[bobreese]

I found the fix....
Removed the Topic Prefix, User Name, and Password
Everything is now working.
Also can monitor with
mosquitto_sub -v -h localhost -t "falcon/player/#"

=== ADVANCED STATS PLUGIN - SYSTEM DIAGNOSTICS ===
Generated: 2025-12-20 06:44:19 CST

--- FPP CORE INFORMATION ---
FPP Version: 9.4
FPP Branch: v9.4
OS Version: v2025-11
Platform: Raspberry Pi
Variant: Pi 4
Hardware Model: Raspberry Pi 4 Model B Rev 1.5
Operating System: Raspbian GNU/Linux 12 (bookworm)
Kernel Version: 6.12.57-v7l+

--- ADVANCED STATS PLUGIN INFORMATION ---
Plugin Name: Advanced Stats Plugin
Plugin Author: Stuart Ledingham (onlinedynamic)
Git Commit: 682a0e8
Git Branch: master

--- MQTT CONFIGURATION ---
Local MQTT Broker Service: Active (enabled at boot)
MQTT Client Configured: Yes
MQTT Host: localhost
MQTT Port: 1883
MQTT Prefix: Not Set
MQTT Username: Not Set
MQTT Password: Not Set
MQTT CA Certificate: Not Set

MQTT Broker Connection Test:
Connection: SUCCESS
Broker Version: mosquitto version 2.0.11

--- MQTT LISTENER STATUS ---
MQTT Listener: Running (PID: 1503)
Listener Uptime: 01:51:07
Recent Activity: Yes (receiving MQTT messages)

--- DATABASE INFORMATION ---
Database File: Exists
Database Size: 0.08 MB
sequences: 0 records
playlists: 0 records
gpio_events: 10 records
commands: 0 records
command_presets: 0 records

--- SYSTEM RESOURCES ---
Root Disk Usage: 3%
Media Disk Usage: 3%
Memory Usage: 271Mi/739Mi
CPU Load (1/5/15 min): 0.01 0.06 0.03
System Uptime: up 1 hour, 51 minutes

--- PYTHON ENVIRONMENT ---
Python Version: Python 3.11.2
paho-mqtt: NOT INSTALLED
sqlite3: Installed

--- RECENT LOG ENTRIES (Last 20 lines) ---
[2025-12-20 06:35:37] Command Executed: Insert Random Item From Playlist (args: ["Music", "true"])
[2025-12-20 06:35:37] MQTT Message - Topic: falcon/player/GPIOTest/playlist/name/status, Payload: Music
[2025-12-20 06:35:37] Logged playlist start: Music
[2025-12-20 06:35:37] MQTT Message - Topic: falcon/player/GPIOTest/playlist/repeat/status, Payload: 0
[2025-12-20 06:35:37] MQTT Message - Topic: falcon/player/GPIOTest/status, Payload: playing
[2025-12-20 06:35:37] MQTT Message - Topic: falcon/player/GPIOTest/playlist/section/status, Payload: MainPlaylist
[2025-12-20 06:35:37] MQTT Message - Topic: falcon/player/GPIOTest/playlist/sectionPosition/status, Payload: 0
[2025-12-20 06:35:37] MQTT Message - Topic: falcon/player/GPIOTest/playlist/media/status, Payload: Carol of the Bells.mp3
[2025-12-20 06:35:37] MQTT Message - Topic: falcon/player/GPIOTest/playlist/media/title, Payload: Carol of the Bells
[2025-12-20 06:35:37] MQTT Message - Topic: falcon/player/GPIOTest/playlist/media/artist, Payload: Pentatonix
[2025-12-20 06:35:58] MQTT Message - Topic: falcon/player/GPIOTest/command/run, Payload: {"args":[],"command":"Stop Now","trigger":"api-get"}
[2025-12-20 06:35:58] Command Executed: Stop Now (args: [])
[2025-12-20 06:35:58] MQTT Message - Topic: falcon/player/GPIOTest/playlist/media/status, Payload:
[2025-12-20 06:35:58] MQTT Message - Topic: falcon/player/GPIOTest/playlist/media/title, Payload:
[2025-12-20 06:35:58] MQTT Message - Topic: falcon/player/GPIOTest/playlist/media/artist, Payload:
[2025-12-20 06:35:58] MQTT Message - Topic: falcon/player/GPIOTest/status, Payload: idle
[2025-12-20 06:35:58] MQTT Message - Topic: falcon/player/GPIOTest/playlist/name/status, Payload:
[2025-12-20 06:35:58] MQTT Message - Topic: falcon/player/GPIOTest/playlist/section/status, Payload:
[2025-12-20 06:35:58] MQTT Message - Topic: falcon/player/GPIOTest/playlist/sectionPosition/status, Payload: 0
[2025-12-20 06:35:58] MQTT Message - Topic: falcon/player/GPIOTest/playlist/repeat/status, Payload: 0

=== END OF DIAGNOSTICS ===