Back end and web code for controlling the JAJ whole house LED system. This speaks to LEDControllers using UDP, and listens for messages from the hardware LEDChooser.
Go to file
2025-05-05 21:55:35 -04:00
ajax Add devices tab with list of known devices/boards 2025-05-05 21:41:26 -04:00
core Switch to new jquery/jqueryui 2025-05-05 21:54:26 -04:00
css Add devices tab with list of known devices/boards 2025-05-05 21:41:26 -04:00
dev Initial commit 2023-08-29 12:25:33 -04:00
img Fix file modes. Add 512x icon size. 2024-06-15 09:15:52 -04:00
install Add firmware column to devices table to store version numbers 2025-03-10 16:43:38 -04:00
js Add devices tab with list of known devices/boards 2025-05-05 21:41:26 -04:00
.gitignore Move DB connection to header.php. Add initial SQL db file. 2023-11-14 09:44:17 -05:00
.htaccess Fix file modes. Add 512x icon size. 2024-06-15 09:15:52 -04:00
actionbutton.php Renamed toggleleds to actionbutton 2025-03-09 20:18:55 -04:00
boardstatus.php Add handling of firmware property to board status 2025-03-10 16:45:06 -04:00
config-dist.php Change default DB host name to localhost 2023-11-14 09:47:49 -05:00
functions.php Initial commit 2023-08-29 12:25:33 -04:00
getpatterns.php Move DB connection to header.php. Add initial SQL db file. 2023-11-14 09:44:17 -05:00
header.php Move DB connection to header.php. Add initial SQL db file. 2023-11-14 09:44:17 -05:00
htmlfooter.php Switch to new jquery/jqueryui 2025-05-05 21:54:26 -04:00
htmlheader.php Switch to new jquery/jqueryui 2025-05-05 21:54:26 -04:00
index.php Fix id of devices tab 2025-05-05 21:55:35 -04:00
manifest.json Change default scope path 2025-02-23 15:53:23 -05:00
README.md Add instructions for initializing database 2023-11-14 11:08:22 -05:00
setcolor_cli.php Remove debug statement 2025-02-23 15:56:18 -05:00
setcolor.php Remove debug echo statements 2025-03-06 12:49:39 -05:00
setpattern.php Move DB connection to header.php. Add initial SQL db file. 2023-11-14 09:44:17 -05:00

LEDColors

This project is a simple web interface for managing "JAJ LED Controllers". JAJ LED Controllers are custom analog LED strip driver boards which use a WiFi connected microcontroller (ESP8266 for now) to drive analog 12v RGB LED strip lights.

Installation

The hardware "LEDChooser" device uses a database to store named color patterns.

Create Database and Grant Permissions

While logged into the SQL database as root...

create database ledcolors;
create user 'ledcolors'@'localhost' identified by 'mypassword';
grant all privileges on ledcolors.* to 'ledcolors'@'localhost';
flush privileges;
  • Note that the "localhost" reference above should be changed to reflect the local environment if a remote database is used.
  • The "mypassword" reference is a password chosen for the application and will need to be set in the configuration file.

Configuration

The config.php file should be customized for the local environment. The following settings should receive particular focus:

  • LEDADDRESS: This should be set to the broadcast address for the local network.
  • DBHOST: If a remote database is used this must be set appropriately.
  • DBPASS: This is the password selected in the "Create Database..." section above.