ESP32-POE netboot wired ethernet

[marekm]

I'm working on an application that will be put in a difficult to access place (on a 12m high mast where it sends data from an accelerometer and a wind speed sensor, not using WiFi/BT just wired Ethernet with PoE), would like to be able to update the software without risk of bricking.

Is there some kind of existing open source bootloader that could be put into the flash, do the usual DHCP+TFTP to configure the network and load the application from the server to RAM (can executable code be put in the external PSRAM?) and run it there?  If it crashes, power-cycle the board to reload the updated software from the server.  No need to flash the application permanently, as it depends on the server anyway to process the data.  Kind of like diskless boot of a PC from a boot ROM on the network card - is this possible?

The prototype is built into the case of this anemometer https://www.amazon.pl/seav-Seav-anemometr-nowy/dp/B07ZJWLG3S which has just enough room inside for the ESP32-POE board (the smaller non-isolated one) and small board with digital SPI MEMS accelerometer (EVAL-ADXL355Z, the most expensive part).

[LubOlimex]

All ESP32 chips have such option. It is called OTA (Over-the-air) update. Check here:

https://docs.espressif.com/projects/esp-idf/en/stable/esp32/api-reference/system/ota.html

[marekm]

I've looked into OTA but it's not exactly what I'm looking for.
Over the wire (not air), dedicated VLAN not on the Internet so it doesn't have to be secure.
No flash writes, no configuration stored on board (only by DHCP), load and run from RAM every time (so no wear on the flash and no way to lose access to the device, except with special firmware that runs from RAM and updates the boot flash, but that should be very rare and well tested on the ground first).
It doesn't have to be ESP32-POE, but that board has just the right size and PoE built-in (too little space available for separate PoE DC/DC modules).
Can be 48V active or 24V passive PoE, will be powered from MikroTik CRS318-16P-2S+OUT which can do either.
Need just two devices so makes no sense to design custom boards, just use what is already available.
A few years ago I've done something similar on a Blackfin DSP board where U-boot in flash boots ucLinux to RAM over DHCP+TFTP. Linux support for that architecture was dropped and I left that job a bit later, maybe I was the last user