Author Topic: Reworking TBBP for MySQL 5.7/PHP 7.2: Any requests?  (Read 717 times)

Syonyk

  • Newby
  • *
  • Posts: 25
Reworking TBBP for MySQL 5.7/PHP 7.2: Any requests?
« on: January 25, 2019, 11:28:36 PM »
My experimental Raspberry Pi logging setup sort of blew up recently (don't use btrfs on a USB SSD), and now that my home/office network link is a bit more solid, I set about reinstalling The Blackbox Project on an Ubuntu 18.04 server in my VM cluster, to avoid some of the complexity of setup from the Pi.

And discovered, to my dismay, that it flat out doesn't work, at ALL, under PHP 7.2 and MySQL 5.7 - there are quite a few database constraints that are not obeyed (inserts with unset fields that are defined as "not null" with no defaults - MySQL used to silently ignore that), PHP 7 makes some breaking changes in functions that throw errors, etc.

Since it seems nobody has really been working on this lately, and I can't find code more recent than a few years (for the bulk of it - there are some forks on Github that fix a few bugs), I've decided to go about and fix it up.  I'm stripping out support for things like SQLite and PDO, fixing errors, and generally trying to update the code to work with modern installs, while ideally adding a few features.

I suck at the front end of web dev, but I've got some legacy LAMP stack knowledge (made my living with it for a while back a decade ago), so other than being out of practice, I'm familiar with how stuff is supposed to work.

So, with that, are there any feature requests?  I'm planning to add some options for larger graphs (if you click them), and I'm considering adding memcache support - despite the regular logging going to the ramdisk in this setup, the whole system is still pretty darn hard on SD cards with regular minutely writes (both graphs and the database), so I'm considering redoing some of that as well to store stuff in RAM (compressed) to reduce SD card traffic on a Pi based install.

Or, is anyone else actively working on this?  I haven't seen many indications of active development recently.

I've forked dan-da's work to here: https://github.com/Syonyk/theblackboxproject  And will be actively working on this over the next few weeks until I have something that runs properly. ;)

ClassicCrazy

  • Hero Member
  • *****
  • Posts: 2135
Re: Reworking TBBP for MySQL 5.7/PHP 7.2: Any requests?
« Reply #1 on: January 29, 2019, 11:00:40 PM »
Did you see that Graham is working on mqtt and also may be working on something with esp32 ?
Larry
system one
Classic 150 , 5s4p  Kyocera 135watt , 12s Soneil 2v 540amp lead crystal for 24v pack , Outback 3524 inverter
system two
Classic 150 ,5s 135 watt Kyocero , 16s Calb 100AH LiFePO4 , Outback VFX 3648 inverter
system three
Midnite KID MPPT 24 DC in to  12 volt AGM batterie

Syonyk

  • Newby
  • *
  • Posts: 25
Re: Reworking TBBP for MySQL 5.7/PHP 7.2: Any requests?
« Reply #2 on: January 29, 2019, 11:19:35 PM »
Can't say I have.

The ESP32 doesn't have the capabilities to run anything near TBBP...

ClassicCrazy

  • Hero Member
  • *****
  • Posts: 2135
Re: Reworking TBBP for MySQL 5.7/PHP 7.2: Any requests?
« Reply #3 on: January 30, 2019, 04:55:06 PM »
I don't understand  what you are trying to do but here is link for Grahams mqtt  project
http://midniteftp.com/forum/index.php?topic=4464.new#new

Larry
system one
Classic 150 , 5s4p  Kyocera 135watt , 12s Soneil 2v 540amp lead crystal for 24v pack , Outback 3524 inverter
system two
Classic 150 ,5s 135 watt Kyocero , 16s Calb 100AH LiFePO4 , Outback VFX 3648 inverter
system three
Midnite KID MPPT 24 DC in to  12 volt AGM batterie

Syonyk

  • Newby
  • *
  • Posts: 25
Re: Reworking TBBP for MySQL 5.7/PHP 7.2: Any requests?
« Reply #4 on: January 30, 2019, 06:02:12 PM »
The Blackbox Project does not run with modern versions of MySQL/PHP.

I'm trying to fix that.

ClassicCrazy

  • Hero Member
  • *****
  • Posts: 2135
Re: Reworking TBBP for MySQL 5.7/PHP 7.2: Any requests?
« Reply #5 on: January 30, 2019, 06:09:52 PM »
Okay -- got ya .
I haven't heard anyone talk about the Black Box project in a long time.
If I remember correctly it was to have one thing that could communicate to different controllers, inverters, etc .
Do I have that correct ?

Larry
system one
Classic 150 , 5s4p  Kyocera 135watt , 12s Soneil 2v 540amp lead crystal for 24v pack , Outback 3524 inverter
system two
Classic 150 ,5s 135 watt Kyocero , 16s Calb 100AH LiFePO4 , Outback VFX 3648 inverter
system three
Midnite KID MPPT 24 DC in to  12 volt AGM batterie