Nie mogę dołączyć urządzeń
-
slavo_s2k
- Posts: 241
- Joined: Sat Mar 10, 2018 7:32 pm
Mam Cloud-a postawionego na QNAP w Conteiner Station, po ostatniej awarii postawiłem Clouda na nowo , przywróciłem kopię bazy , niestety w kopii brakowało mi dwóch urządzeń ostatnio dodanych. Cała konfiguracja łącznie z loginem i adres IP Clouda jest taka sama. Niestety nie łączy się mimo iż rejestracja urządzeń aktywna. Widzę, że do wifi się podłącza, więc problem gdzieś dalej. Wszystkie urządzenia, który były w bazie podłączyły się prawidłowo bez żadnego problemu. Nie mam pomysłu gdzie dalej szukać rozwiązania problemu.
-
slavo_s2k
- Posts: 241
- Joined: Sat Mar 10, 2018 7:32 pm
LastState jest Connecting... , ale urządzeń łączy się (przechodzi kilka pingów ) potem się restartuje i tak w kółko, tak jakby po połączeniu z wifi nie mógł połączyć się z Cloudem i robił restart i tak w kółko.
Zobacz jeszcze w logi serwera
Code: Select all
docker logs supla-serverSOP 2023 
SOP 2024
Czekam na kolejne Supla Offline Party
: 
cz->b 
+ila
SOP 2024
Czekam na kolejne Supla Offline Party
: 
cz->b 
+ila-
slavo_s2k
- Posts: 241
- Joined: Sat Mar 10, 2018 7:32 pm
W loga-ach takie błędy dotyczące właśnie tego urządzenia (192.168.1.183)
Code: Select all
-sh: ERR[1608394431.951303]: command not found
[~] # INFO[1608394438.219508] Connection accepted: 192.168.1.183:8326 ClientSD: 43 Sec ure: 1
-sh: INFO[1608394438.219508]: command not found
[~] # INFO[1608394438.321850] Cipher: AES128-SHA, ClientSD: 43
-sh: INFO[1608394438.321850]: command not found
[~] # ERR[1608394438.445906] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394438.445906]: command not found
[~] # INFO[1608394444.702228] Connection accepted: 192.168.1.183:47427 ClientSD: 48 Se cure: 1
-sh: INFO[1608394444.702228]: command not found
[~] # INFO[1608394444.802441] Cipher: AES128-SHA, ClientSD: 48
-sh: INFO[1608394444.802441]: command not found
[~] # ERR[1608394444.931296] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394444.931296]: command not found
[~] # INFO[1608394451.62894] Connection accepted: 192.168.1.183:8783 ClientSD: 46 Secu re: 1
-sh: INFO[1608394451.62894]: command not found
[~] # INFO[1608394451.165814] Cipher: AES128-SHA, ClientSD: 46
-sh: INFO[1608394451.165814]: command not found
[~] # ERR[1608394451.302815] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394451.302815]: command not found
[~] # INFO[1608394457.367307] Connection accepted: 192.168.1.183:3502 ClientSD: 43 Sec ure: 1
-sh: INFO[1608394457.367307]: command not found
[~] # INFO[1608394457.467653] Cipher: AES128-SHA, ClientSD: 43
-sh: INFO[1608394457.467653]: command not found
[~] # ERR[1608394457.591136] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394457.591136]: command not found
[~] # INFO[1608394462.752579] Connection accepted: 192.168.1.183:35692 ClientSD: 48 Se cure: 1
-sh: INFO[1608394462.752579]: command not found
[~] # INFO[1608394462.856650] Cipher: AES128-SHA, ClientSD: 48
-sh: INFO[1608394462.856650]: command not found
[~] # ERR[1608394462.999043] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394462.999043]: command not found
[~] # INFO[1608394469.86653] Connection accepted: 192.168.1.183:13607 ClientSD: 43 Sec ure: 1
-sh: INFO[1608394469.86653]: command not found
[~] # INFO[1608394469.190132] Cipher: AES128-SHA, ClientSD: 43
-sh: INFO[1608394469.190132]: command not found
[~] # ERR[1608394469.311905] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394469.311905]: command not found
[~] # INFO[1608394478.989678] Connection accepted: 192.168.1.183:45802 ClientSD: 46 Se cure: 1
-sh: INFO[1608394478.989678]: command not found
[~] # INFO[1608394479.90576] Cipher: AES128-SHA, ClientSD: 46
-sh: INFO[1608394479.90576]: command not found
[~] # ERR[1608394479.215126] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394479.215126]: command not found
[~] # INFO[1608394485.483904] Connection accepted: 192.168.1.183:6040 ClientSD: 48 Sec ure: 1
-sh: INFO[1608394485.483904]: command not found
[~] # INFO[1608394485.586023] Cipher: AES128-SHA, ClientSD: 48
-sh: INFO[1608394485.586023]: command not found
[~] # ERR[1608394485.713509] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394485.713509]: command not found
[~] # INFO[1608394490.801713] Connection accepted: 192.168.1.183:40873 ClientSD: 43 Se cure: 1
-sh: INFO[1608394490.801713]: command not found
[~] # INFO[1608394490.912956] Cipher: AES128-SHA, ClientSD: 43
-sh: INFO[1608394490.912956]: command not found
[~] # ERR[1608394491.82488] MySQL - execute error: PROCEDURE supla.supla_add_channel d oes not exist
-sh: ERR[1608394491.82488]: command not found
[~] # INFO[1608394497.230427] Connection accepted: 192.168.1.183:19367 ClientSD: 48 Se cure: 1
-sh: INFO[1608394497.230427]: command not found
[~] # INFO[1608394497.331839] Cipher: AES128-SHA, ClientSD: 48
-sh: INFO[1608394497.331839]: command not found
[~] # ERR[1608394497.468642] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394497.468642]: command not found
[~] # INFO[1608394503.619279] Connection accepted: 192.168.1.183:9696 ClientSD: 43 Sec ure: 1
-sh: INFO[1608394503.619279]: command not found
[~] # INFO[1608394503.729420] Cipher: AES128-SHA, ClientSD: 43
-sh: INFO[1608394503.729420]: command not found
[~] # ERR[1608394503.858342] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394503.858342]: command not found
[~] # INFO[1608394509.952077] Connection accepted: 192.168.1.183:3635 ClientSD: 46 Sec ure: 1
-sh: INFO[1608394509.952077]: command not found
[~] # INFO[1608394510.54003] Cipher: AES128-SHA, ClientSD: 46
-sh: INFO[1608394510.54003]: command not found
[~] # ERR[1608394510.177827] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394510.177827]: command not found
[~] # INFO[1608394516.338720] Connection accepted: 192.168.1.183:8113 ClientSD: 43 Sec ure: 1
-sh: INFO[1608394516.338720]: command not found
[~] # INFO[1608394516.440865] Cipher: AES128-SHA, ClientSD: 43
-sh: INFO[1608394516.440865]: command not found
[~] # ERR[1608394516.562211] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394516.562211]: command not found
[~] # INFO[1608394526.45118] Connection accepted: 192.168.1.183:26767 ClientSD: 46 Sec ure: 1
-sh: INFO[1608394526.45118]: command not found
[~] # INFO[1608394526.145257] Cipher: AES128-SHA, ClientSD: 46
-sh: INFO[1608394526.145257]: command not found
[~] # ERR[1608394526.266353] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394526.266353]: command not found
[~] # INFO[1608394532.536762] Connection accepted: 192.168.1.183:31210 ClientSD: 48 Se cure: 1
-sh: INFO[1608394532.536762]: command not found
[~] # INFO[1608394532.637202] Cipher: AES128-SHA, ClientSD: 48
-sh: INFO[1608394532.637202]: command not found
[~] # ERR[1608394532.772407] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394532.772407]: command not found
[~] # INFO[1608394537.915823] Connection accepted: 192.168.1.183:35228 ClientSD: 46 Se cure: 1
-sh: INFO[1608394537.915823]: command not found
[~] # INFO[1608394538.17630] Cipher: AES128-SHA, ClientSD: 46
-sh: INFO[1608394538.17630]: command not found
[~] # ERR[1608394538.141534] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394538.141534]: command not found
[~] # INFO[1608394544.254858] Connection accepted: 192.168.1.183:34334 ClientSD: 43 Se cure: 1
-sh: INFO[1608394544.254858]: command not found
[~] # INFO[1608394544.357175] Cipher: AES128-SHA, ClientSD: 43
-sh: INFO[1608394544.357175]: command not found
[~] # ERR[1608394544.495079] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394544.495079]: command not found
[~] # INFO[1608394550.571886] Connection accepted: 192.168.1.183:37792 ClientSD: 46 Se cure: 1
-sh: INFO[1608394550.571886]: command not found
[~] # INFO[1608394550.674250] Cipher: AES128-SHA, ClientSD: 46
-sh: INFO[1608394550.674250]: command not found
[~] # ERR[1608394550.799521] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394550.799521]: command not found
[~] # INFO[1608394556.933933] Connection accepted: 192.168.1.183:13000 ClientSD: 48 Se cure: 1
-sh: INFO[1608394556.933933]: command not found
[~] # INFO[1608394557.35315] Cipher: AES128-SHA, ClientSD: 48
-sh: INFO[1608394557.35315]: command not found
[~] # ERR[1608394557.166667] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394557.166667]: command not found
[~] # INFO[1608394563.281549] Connection accepted: 192.168.1.183:37049 ClientSD: 43 Se cure: 1
-sh: INFO[1608394563.281549]: command not found
[~] # INFO[1608394563.382677] Cipher: AES128-SHA, ClientSD: 43
-sh: INFO[1608394563.382677]: command not found
[~] # ERR[1608394563.506409] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394563.506409]: command not found
[~] # INFO[1608394573.49006] Connection accepted: 192.168.1.183:1081 ClientSD: 46 Secu re: 1
-sh: INFO[1608394573.49006]: command not found
[~] # INFO[1608394573.153833] Cipher: AES128-SHA, ClientSD: 46
-sh: INFO[1608394573.153833]: command not found
[~] # ERR[1608394573.301606] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
-sh: ERR[1608394573.301606]: command not found
[~] # INFO[1608394579.539947] Connection accepted: 192.168.1.183:25354 ClientSD: 43 Se cure: 1
-sh: INFO[1608394579.539947]: command not found
[~] # INFO[1608394579.647687] Cipher: AES128-SHA, ClientSD: 43
epte-sh: INFO[1608394579.647687]: command not found
[~] # ERR[1608394579.778561] MySQL - execute error: PROCEDURE supla.supla_add_channel does not exist
n-sh: ERR[1608394579.778561]: command not found
[~] # INFO[1608394584.899469] Connection accepted: 192.168.1.183:10647 ClientSD: 46 Se cure: 1
-sh: INFO[1608394584.899469]: command not found
[~] # INFO[1608394584.999358] Cipher: AES128-SHA, ClientSD: 46
e-sh: INFO[1608394584.999358]: command not found
Jak robiłeś backup bazy? Użyłeś --routines?
Zobacz czy masz procedury, ja kiedyś nie miałem po odtworzeniu bazy z backupu, bo dump robiłem bez --routines
Zobacz czy masz procedury, ja kiedyś nie miałem po odtworzeniu bazy z backupu, bo dump robiłem bez --routines
Code: Select all
source ./supla-docker/.env
docker exec supla-db mysql -u supla --password=$DB_PASSWORD supla -e "show procedure status"SOP 2023
SOP 2024
Czekam na kolejne Supla Offline Party
: cz->b +ila
SOP 2024
Czekam na kolejne Supla Offline Party
: cz->b +ila-
slavo_s2k
- Posts: 241
- Joined: Sat Mar 10, 2018 7:32 pm
Backup robiłem tak:
Jak sprawdzić uprawnienia użytkownika SQL ??
docker exec supla_supla-db_1 mysqldump -u root --password=$DB_PASSWORD supla > supla.sql
Jak sprawdzić uprawnienia użytkownika SQL ??
docker exec supla-db mysqldump --routines -u root --password="$DB_PASSWORD" supla > supla.sqlslavo_s2k wrote: Sat Dec 19, 2020 6:28 pm ......docker exec supla_supla-db_1 mysqldump -u root --password=$DB_PASSWORD supla > supla.sql
To już wiadomo czemu nie masz procedur. Czyli jak listujesz procedury
Code: Select all
docker exec supla-db mysql -u supla --password=$DB_PASSWORD supla -e "show procedure status"Powinieneś mieć tam tyle procedur
Code: Select all
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
supla supla_add_channel PROCEDURE supla@% 2020-12-19 09:49:02 2020-12-19 09:49:02 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_add_client PROCEDURE supla@% 2020-12-19 09:49:03 2020-12-19 09:49:03 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_add_em_log_item PROCEDURE supla@% 2020-12-19 09:49:03 2020-12-19 09:49:03 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_add_ic_log_item PROCEDURE supla@% 2020-12-19 09:49:02 2020-12-19 09:49:02 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_add_iodevice PROCEDURE supla@% 2020-12-19 09:49:03 2020-12-19 09:49:03 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_add_temperature_log_item PROCEDURE supla@% 2020-12-19 09:49:02 2020-12-19 09:49:02 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_add_temphumidity_log_item PROCEDURE supla@% 2020-12-19 09:49:02 2020-12-19 09:49:02 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_add_thermostat_log_item PROCEDURE supla@% 2020-12-19 09:49:02 2020-12-19 09:49:02 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_get_device_firmware_url PROCEDURE supla@% 2020-12-19 09:48:59 2020-12-19 09:48:59 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_oauth_add_client_for_app PROCEDURE supla@% 2020-12-19 09:49:03 2020-12-19 09:49:03 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_oauth_add_token_for_app PROCEDURE supla@% 2020-12-19 09:49:03 2020-12-19 09:49:03 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_on_channeladded PROCEDURE supla@% 2020-12-19 09:48:59 2020-12-19 09:48:59 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_on_newclient PROCEDURE supla@% 2020-12-19 09:49:00 2020-12-19 09:49:00 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_on_newdevice PROCEDURE supla@% 2020-12-19 09:48:59 2020-12-19 09:48:59 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_set_channel_caption PROCEDURE supla@% 2020-12-19 09:49:03 2020-12-19 09:49:03 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_set_channel_function PROCEDURE supla@% 2020-12-19 09:49:03 2020-12-19 09:49:03 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_set_registration_enabled PROCEDURE supla@% 2020-12-19 09:49:03 2020-12-19 09:49:03 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_update_amazon_alexa PROCEDURE supla@% 2020-12-19 09:49:02 2020-12-19 09:49:02 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_update_channel_value PROCEDURE supla@% 2020-12-19 09:49:03 2020-12-19 09:49:03 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_update_client PROCEDURE supla@% 2020-12-19 09:49:03 2020-12-19 09:49:03 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_update_google_home PROCEDURE supla@% 2020-12-19 09:49:02 2020-12-19 09:49:02 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_update_iodevice PROCEDURE supla@% 2020-12-19 09:49:03 2020-12-19 09:49:03 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_update_state_webhook PROCEDURE supla@% 2020-12-19 09:49:03 2020-12-19 09:49:03 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
SOP 2023
SOP 2024
Czekam na kolejne Supla Offline Party
: cz->b +ila
SOP 2024
Czekam na kolejne Supla Offline Party
: cz->b +ila-
slavo_s2k
- Posts: 241
- Joined: Sat Mar 10, 2018 7:32 pm
Procedurę robienia kopii w takiej formie znalazłem na forum 
a dopiero pierwszy raz przyszło mi korzystać z kopii ...
U mnie wynik:
Widzę, że procedur mam mniej, ale nie jest pusto, tylko co teraz dalej?
a dopiero pierwszy raz przyszło mi korzystać z kopii ...U mnie wynik:
Code: Select all
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
supla supla_add_client PROCEDURE supla@% 2020-12-19 13:43:27 2020-12-19 13:43:27 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_add_em_log_item PROCEDURE supla@% 2020-12-19 13:43:54 2020-12-19 13:43:54 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_add_iodevice PROCEDURE supla@% 2020-12-19 13:43:27 2020-12-19 13:43:27 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_add_thermostat_log_item PROCEDURE supla@% 2020-12-19 13:43:22 2020-12-19 13:43:22 DEFINER utf8mb4utf8mb4_general_ci latin1_swedish_ci
supla supla_oauth_add_client_for_app PROCEDURE supla@% 2020-12-19 13:43:28 2020-12-19 13:43:28 DEFINER utf8mb4utf8mb4_general_ci latin1_swedish_ci
supla supla_oauth_add_token_for_app PROCEDURE supla@% 2020-12-19 13:43:28 2020-12-19 13:43:28 DEFINER utf8mb4utf8mb4_general_ci latin1_swedish_ci
supla supla_set_channel_caption PROCEDURE supla@% 2020-12-19 13:43:28 2020-12-19 13:43:28 DEFINER utf8mb4utf8mb4_general_ci latin1_swedish_ci
supla supla_set_channel_function PROCEDURE supla@% 2020-12-19 13:43:28 2020-12-19 13:43:28 DEFINER utf8mb4utf8mb4_general_ci latin1_swedish_ci
supla supla_set_registration_enabled PROCEDURE supla@% 2020-12-19 13:43:54 2020-12-19 13:43:54 DEFINER utf8mb4utf8mb4_general_ci latin1_swedish_ci
supla supla_update_channel_value PROCEDURE supla@% 2020-12-19 13:43:56 2020-12-19 13:43:56 DEFINER utf8mb4utf8mb4_general_ci latin1_swedish_ci
supla supla_update_client PROCEDURE supla@% 2020-12-19 13:43:27 2020-12-19 13:43:27 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_update_iodevice PROCEDURE supla@% 2020-12-19 13:43:27 2020-12-19 13:43:27 DEFINER utf8mb4 utf8mb4_general_ci latin1_swedish_ci
supla supla_update_state_webhook PROCEDURE supla@% 2020-12-19 13:43:56 2020-12-19 13:43:56 DEFINER utf8mb4utf8mb4_general_ci latin1_swedish_ci