Aktualizacja firmware - tabela esp_update

barrth
Posty: 5
Rejestracja: ndz lut 14, 2021 3:49 am

Cześć,

Da się jakoś wymusić aktualizację tej tabeli (np. firmware do MEW-01 do wersji 2.8.5)? Generalnie mam własną instancję, ale nie mam zewnętrznego IP żeby ją zarejestrować via https://cloud.supla.org/register-cloud.
W kliku wątkach (np. tu: viewtopic.php?t=8407) były gotowe inserty SQL, ale nie znalazłem z wariantem najnowszego firmware.
MEW-01
SRW-01 x 7
ROW-2 x 1
Instancja lokalna (bez Proxy i Let’s Encrypt) zintegorwana z HA :D
Awatar użytkownika
pzygmunt
Posty: 18280
Rejestracja: wt sty 19, 2016 9:26 am
Lokalizacja: Paczków
Kontakt:

Rejestracja lub dump z bazy, która jest aktualna i import do Twojej.
barrth
Posty: 5
Rejestracja: ndz lut 14, 2021 3:49 am

A możesz się "podzielić": zrzutem z esp_update; może być txt z select * from esp_update, inseta zrobię :)
MEW-01
SRW-01 x 7
ROW-2 x 1
Instancja lokalna (bez Proxy i Let’s Encrypt) zintegorwana z HA :D
Awatar użytkownika
pzygmunt
Posty: 18280
Rejestracja: wt sty 19, 2016 9:26 am
Lokalizacja: Paczków
Kontakt:

Kod: Zaznacz cały

INSERT INTO `esp_update` (`id`, `device_id`, `device_name`, `platform`, `latest_software_version`, `fparam1`, `fparam2`, `fparam3`, `fparam4`, `protocols`, `host`, `port`, `path`, `is_synced`) VALUES
(651799, 0, 'SUPLA-GATE-MODULE', 1, '2.0.1', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/gate_module2_wroom_user2.2048.new.5.bin', 1),
(651800, 0, 'SUPLA-GATE-MODULE', 1, '2.0.1', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/gate_module2_wroom_user1.2048.new.5.bin', 1),
(651801, 0, 'NICE Wi-Fi', 1, '2.8.54', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/n_sbw_01_2854_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651802, 0, 'NICE Wi-Fi', 1, '2.8.54', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/n_sbw_01_2854_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651803, 0, 'NICE Wi-Fi SBP-01', 1, '2.8.54', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/n_sbw_01_2854_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651804, 0, 'NICE Wi-Fi SBP-01', 1, '2.8.54', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/n_sbw_01_2854_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651805, 0, 'NICE Wi-Fi SCREEN', 1, '2.8.47', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/n_srw_01_2847_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651806, 0, 'NICE Wi-Fi SCREEN', 1, '2.8.47', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/n_srw_01_2847_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651807, 0, 'ZAMEL SRW-03', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_srw_03_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651808, 0, 'ZAMEL SRW-03', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_srw_03_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651809, 0, 'ZAMEL ROW-02 FIX', 1, '9.9.9', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_01to02_user2.2048_DIO.new.5.bin', 1),
(651810, 0, 'ZAMEL ROW-02 FIX', 1, '9.9.9', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_01to02_user1.2048_DIO.new.5.bin', 1),
(651811, 0, 'PEVEKO VALVE', 1, '2.7.21', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/peveko_valve_user2.2048_DIO.new.5.bin', 1),
(651812, 0, 'PEVEKO VALVE', 1, '2.7.21', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/peveko_valve_user1.2048_DIO.new.5.bin', 1),
(651813, 0, 'VARILIGHT V-PRO SMART', 1, '2.8.52', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/vl_dimmer_2852_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651814, 0, 'VARILIGHT V-PRO SMART', 1, '2.8.52', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/vl_dimmer_2852_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651815, 0, 'ZAMEL SRW-01', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_srw_01_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651816, 0, 'ZAMEL SRW-01', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_srw_01_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651817, 0, 'ZAMEL SBW-01', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_sbw_01_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651818, 0, 'ZAMEL SBW-01', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_sbw_01_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651819, 0, 'ZAMEL SBW-02', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_sbw_02_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651820, 0, 'ZAMEL SBW-02', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_sbw_02_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651821, 0, 'ZAMEL ROW-02', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_02_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651822, 0, 'ZAMEL ROW-02', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_02_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651823, 0, 'ZAMEL ROW-01', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_01_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651824, 0, 'ZAMEL ROW-01', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_01_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651825, 0, 'ZAMEL LIW-01', 1, '2.8.54', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_liw_01_2854_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651826, 0, 'ZAMEL LIW-01', 1, '2.8.54', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_liw_01_2854_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651827, 0, 'ZAMEL SLW-01', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_slw_01_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651828, 0, 'ZAMEL SLW-01', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_slw_01_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651829, 0, 'ZAMEL SLW-02', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_slw_02_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651830, 0, 'ZAMEL SLW-02', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_slw_02_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651831, 0, 'ZAMEL ROW-01/16A', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_16A_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651832, 0, 'ZAMEL ROW-01/16A', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_16A_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651833, 0, 'ZAMEL ROW-04', 1, '2.7.25', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_04m_2725_user2.2048_DIO.new.5.bin', 1),
(651834, 0, 'ZAMEL ROW-04', 1, '2.7.25', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_04m_2725_user1.2048_DIO.new.5.bin', 1),
(651835, 0, 'ZAMEL ROW-04m', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_04m_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651836, 0, 'ZAMEL ROW-04m', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_04m_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651837, 0, 'UV TRONIC', 1, '2.7.25', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/uvtronic_2725_user2.2048_DIO.new.5.bin', 1),
(651838, 0, 'UV TRONIC', 1, '2.7.25', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/uvtronic_2725_user1.2048_DIO.new.5.bin', 1),
(651839, 0, 'ZAMEL MEW-01', 1, '2.8.55', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_mew_01_2855_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651840, 0, 'ZAMEL MEW-01', 1, '2.8.55', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_mew_01_2855_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651841, 0, 'HEATPOL HOME+', 1, '2.7.26', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/hp_homeplus_2726_user2.2048_DIO.new.5.bin', 1),
(651842, 0, 'HEATPOL HOME+', 1, '2.7.26', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/hp_homeplus_2726_user1.2048_DIO.new.5.bin', 1),
(651843, 0, 'ZAMEL SRW-02m', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_srw_02m_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651844, 0, 'ZAMEL SRW-02m', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_srw_02m_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651845, 0, 'ZAMEL SRW-02', 1, '2.7.25', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_srw_02m_2725_user2.2048_DIO.new.5.bin', 1),
(651846, 0, 'ZAMEL SRW-02', 1, '2.7.25', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_srw_02m_2725_user1.2048_DIO.new.5.bin', 1),
(651847, 0, 'ZAMEL PNW-01', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_pnw_01_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651848, 0, 'ZAMEL PNW-01', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_pnw_01_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651849, 0, 'ZAMEL DIW-01', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_diw_01_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651850, 0, 'ZAMEL DIW-01', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_diw_01_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651851, 0, 'ZAMEL LEW-01', 1, '2.8.7', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_lew_01_287_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651852, 0, 'ZAMEL LEW-01', 1, '2.8.7', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_lew_01_287_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651853, 0, 'ZAMEL mROW-02', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_02_mini_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651854, 0, 'ZAMEL mROW-02', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_02_mini_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651855, 0, 'ZAMEL ROW-02m', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_02m_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651856, 0, 'ZAMEL ROW-02m', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_02m_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651857, 0, 'Comelit WREL205', 1, '2.8.46', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/comelit_wrel205_2846_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651858, 0, 'Comelit WREL205', 1, '2.8.46', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/comelit_wrel205_2846_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651859, 0, 'Comelit WDIM100', 1, '2.8.36', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/comelit_wdim100_2836_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651860, 0, 'Comelit WDIM100', 1, '2.8.36', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/comelit_wdim100_2836_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651861, 0, 'Comelit WMIS300', 1, '2.8.29', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/comelit_wmis300_2829_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651862, 0, 'Comelit WMIS300', 1, '2.8.29', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/comelit_wmis300_2829_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651863, 0, 'Comelit WREL116', 1, '2.8.47', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/comelit_wrel116_2847_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651864, 0, 'Comelit WREL116', 1, '2.8.47', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/comelit_wrel116_2847_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651865, 0, 'ZAMEL mSRW-01', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_srw_01_mini_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651866, 0, 'ZAMEL mSRW-01', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_srw_01_mini_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651867, 0, 'Comelit WTAP100', 1, '2.8.46', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/comelit_wtap100_2846_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651868, 0, 'Comelit WTAP100', 1, '2.8.46', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/comelit_wtap100_2846_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651869, 0, 'ZAMEL ROW-07', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_07_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651870, 0, 'ZAMEL ROW-07', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_row_07_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651871, 0, 'ZAMEL OSW-01', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_osw_01_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651872, 0, 'ZAMEL OSW-01', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_osw_01_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651873, 0, 'VARILIGHT V-PRO SMART', 1, '2.8.55', 5, 0, 1, 0, 1, 'updates.supla.org', 80, 'download/vl_dimmer_pic13_2855_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651874, 0, 'VARILIGHT V-PRO SMART', 1, '2.8.55', 5, 1, 1, 0, 1, 'updates.supla.org', 80, 'download/vl_dimmer_pic13_2855_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651875, 0, 'ZAMEL RNW-01', 1, '2.8.53', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_rnw_01_2853_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651876, 0, 'ZAMEL RNW-01', 1, '2.8.53', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/zam_rnw_01_2853_user1.2048_DIO.new.5.sdk3x.bin', 1),
(651877, 0, 'VARILIGHT CEILING DIMMER', 1, '2.8.52', 5, 0, 0, 0, 1, 'updates.supla.org', 80, 'download/vl_ceiling_dimmer_x2_2852_user2.2048_DIO.new.5.sdk3x.bin', 1),
(651878, 0, 'VARILIGHT CEILING DIMMER', 1, '2.8.52', 5, 1, 0, 0, 1, 'updates.supla.org', 80, 'download/vl_ceiling_dimmer_x2_2852_user1.2048_DIO.new.5.sdk3x.bin', 1);
barrth
Posty: 5
Rejestracja: ndz lut 14, 2021 3:49 am

Wielkie dzięki, właśnie już aktualizuję urządzenia.

Tak z ciekawości - da się jakoś obejść rejestrację, lub zrobić ją bez konieczności posiadanie "zielonego" certyfikatu?
MEW-01
SRW-01 x 7
ROW-2 x 1
Instancja lokalna (bez Proxy i Let’s Encrypt) zintegorwana z HA :D
Awatar użytkownika
pzygmunt
Posty: 18280
Rejestracja: wt sty 19, 2016 9:26 am
Lokalizacja: Paczków
Kontakt:

Nie da się. Zielony nie jest konieczny. Wystarczy ważny let's encrypt.
ODPOWIEDZ

Wróć do „Pomoc”