Problem z certyfikatami SSL

Dicentis · Post Sun Apr 21, 2024 8:35 pm

Witam wszystkich.
Sprawa wygląda tak - mini komputer z Debianem 12 specjalnie postawiony pod serwer dla smart home. Padło na suple. Instalacje i akrobacje jak zwykle. W końcu udało się to ustawić w kontenerze. Do zarządzania kontenerami mam Portainera. Wewnątrz oczywiście 3 kontenery - supla-cloud, supla-server i supla-db. Pomijam fakt po co mi cloud jeśli chcę się łączyć zdalnie i jest cloud producenta, ale to już pomijam. Problem pojawia się już po pierwszym starcie. Mianowicie supla-cloud nie ufa certyfikatowi localhost'a, a supla-server nie ufa certyfikatowi supla-cloud. Całość jednocześnie instalowana. Baz błędów. Jedyne co mnie zdziwiło, to to że po wpisaniu pierwszy raz komendy "./supla-docker/supla.sh" nie wygenerowało mi pliku .cnv. W kontekście "nano .cnv" wypluło pusty plik.
1.) Czy ktoś wie jak naprawić temat z certyfikatami ?
2.) Czy da się przekierować supla-server aby łączył się bezpośrednio pod cloud.supla.org a nie do localhosta?
3.) Ewentualnie żeby lokalny cloud łączył się do zdalnego i tam był w jakiś sposób konfigurowalny/ cokolwiek.

Wiem że lokalnego clouda mogę zarejestrować, ale nie mam domeny, a IP zmienne ze względu na internet mobilny. Uprzedzając - niestety modem (zyxel - nie pytajcie) średnio pozwala na zabawy z DNS.

Co do logów:
cloud:
ERROR: The certificate of 'localhost' is not trusted. ERROR: The certificate of 'localhost' doesn't have a known issuer. The certificate's owner does not match hostname 'localhost'

server:
ERROR: The certificate of 'supla-cloud' is not trusted. ERROR: The certificate of 'supla-cloud' doesn't have a known issuer. The certificate's owner does not match hostname 'supla-cloud'

Za wszelki konstruktywne uwagi z góry dziękuję.

pzygmunt · Post Mon Apr 22, 2024 7:45 am

Co generuje taki komunikat ? supla-server w komunikacji z supla-cloud nie używa szyfrowania.

Dicentis · Post Mon Apr 22, 2024 1:24 pm

Takie info widnieje w dockerze. Przy jednym i drogim mam "unhealthy" czy coś w tym stylu. Dodatkowo przez aplikację nie jestem w stanie wykryć nic co mam w domu.
Logi
cloud:

supla:cyclic:send-server-messages
---------------------------------
172.18.0.3:80 127.0.0.1 - - [22/Apr/2024:13:31:32 +0000] "HEAD /api/server-info HTTP/1.1" 301 262 "-" "Wget/1.21"
172.18.0.3:80 172.18.0.4 - - [22/Apr/2024:13:31:59 +0000] "HEAD /api/server-status HTTP/1.1" 301 266 "-" "Wget/1.21"
172.18.0.3:80 127.0.0.1 - - [22/Apr/2024:13:32:02 +0000] "HEAD /api/server-info HTTP/1.1" 301 262 "-" "Wget/1.21"
supla:clean:passed-io-client-registration-dates
-----------------------------------------------
Client registration expiration date - cleared: 0
I/O Device registration expiration date - cleared: 0
supla:clean:disable-demo-client-apps
------------------------------------
Clients to disable: 0
supla:generate-schedules-executions
-----------------------------------
Schedules to regenerate: 0
Deleted expired scheduled executions: 0
supla:cyclic:send-server-messages
---------------------------------
172.18.0.3:80 127.0.0.1 - - [22/Apr/2024:13:32:33 +0000] "HEAD /api/server-info HTTP/1.1" 301 262 "-" "Wget/1.21"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:32:37 +0000] "GET / HTTP/1.1" 200 3398 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:32:41 +0000] "GET /dist/css/app.ef592256.css HTTP/1.1" 200 9057 "https://127.0.0.1/" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:32:41 +0000] "GET /dist/css/chunk-vendors.b32f8653.css HTTP/1.1" 200 17198 "https://127.0.0.1/" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:32:41 +0000] "GET /assets/img/preloaders/loader_1c_200.gif HTTP/1.1" 200 94144 "https://127.0.0.1/" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:32:43 +0000] "GET /dist/fonts/quicksand-400-latin.15c3f682.woff2 HTTP/1.1" 200 24258 "https://127.0.0.1/dist/css/app.ef592256.css" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:80 127.0.0.1 - - [22/Apr/2024:13:32:44 +0000] "OPTIONS * HTTP/1.0" 200 110 "-" "Apache/2.4.54 (Debian) OpenSSL/1.1.1w (internal dummy connection)"
172.18.0.3:80 127.0.0.1 - - [22/Apr/2024:13:32:45 +0000] "OPTIONS * HTTP/1.0" 200 110 "-" "Apache/2.4.54 (Debian) OpenSSL/1.1.1w (internal dummy connection)"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:32:43 +0000] "GET /api/server-info HTTP/1.1" 200 1164 "https://127.0.0.1/" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:32:47 +0000] "GET /dist/css/5981.b4af7748.css HTTP/1.1" 200 878 "https://127.0.0.1/" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:32:51 +0000] "GET /dist/fonts/open-sans-v15-latin-ext_latin-regular.741d68a6.woff2 HTTP/1.1" 200 19309 "https://127.0.0.1/dist/css/app.ef592256.css" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:32:51 +0000] "GET /dist/img/logo.b68428ad.svg HTTP/1.1" 200 6362 "https://127.0.0.1/login" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:32:51 +0000] "GET /assets/img/user.png HTTP/1.1" 200 4733 "https://127.0.0.1/login" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:80 127.0.0.1 - - [22/Apr/2024:13:32:51 +0000] "OPTIONS * HTTP/1.0" 200 110 "-" "Apache/2.4.54 (Debian) OpenSSL/1.1.1w (internal dummy connection)"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:32:53 +0000] "POST /api/webapp-auth HTTP/1.1" 200 3057 "https://127.0.0.1/login" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:80 172.18.0.4 - - [22/Apr/2024:13:32:59 +0000] "HEAD /api/server-status HTTP/1.1" 301 266 "-" "Wget/1.21"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:32:57 +0000] "GET /api/users/current HTTP/1.1" 200 1030 "https://127.0.0.1/login" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:33:02 +0000] "GET /api/server-info HTTP/1.1" 200 1221 "https://127.0.0.1/login" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:33:03 +0000] "GET /dist/css/1288.50f38bc3.css HTTP/1.1" 200 793 "https://127.0.0.1/login" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:33:04 +0000] "GET /api/users/current HTTP/1.1" 200 1030 "https://127.0.0.1/" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
supla:clean:passed-io-client-registration-dates
-----------------------------------------------
172.18.0.3:80 127.0.0.1 - - [22/Apr/2024:13:33:05 +0000] "HEAD /api/server-info HTTP/1.1" 301 262 "-" "Wget/1.21"
Client registration expiration date - cleared: 0
I/O Device registration expiration date - cleared: 0
supla:clean:disable-demo-client-apps
------------------------------------
Clients to disable: 0
supla:generate-schedules-executions
-----------------------------------
Schedules to regenerate: 0
Deleted expired scheduled executions: 0
supla:cyclic:send-server-messages
---------------------------------
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:33:04 +0000] "GET /api/iodevices?include=location HTTP/1.1" 200 923 "https://127.0.0.1/" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:33:06 +0000] "GET /assets/img/thermometer.svg HTTP/1.1" 200 4896 "https://127.0.0.1/" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:443 172.18.0.1 - - [22/Apr/2024:13:33:06 +0000] "GET /assets/img/gate.svg HTTP/1.1" 200 12197 "https://127.0.0.1/" "Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/115.0"
172.18.0.3:80 127.0.0.1 - - [22/Apr/2024:13:33:36 +0000] "HEAD /api/server-info HTTP/1.1" 301 262 "-" "Wget/1.21"
172.18.0.3:80 172.18.0.4 - - [22/Apr/2024:13:34:01 +0000] "HEAD /api/server-status HTTP/1.1" 301 266 "-" "Wget/1.21"
supla:clean:passed-io-client-registration-dates
-----------------------------------------------
Client registration expiration date - cleared: 0
I/O Device registration expiration date - cleared: 0
supla:clean:disable-demo-client-apps
------------------------------------
Clients to disable: 0
supla:generate-schedules-executions
-----------------------------------
Schedules to regenerate: 0
Deleted expired scheduled executions: 0
supla:cyclic:send-server-messages
---------------------------------
172.18.0.3:80 127.0.0.1 - - [22/Apr/2024:13:34:06 +0000] "HEAD /api/server-info HTTP/1.1" 301 262 "-" "Wget/1.21"

Server:

2024-04-21 19:00:29,273 INFO exited: supla-server (exit status 1; not expected)
2024-04-21 19:00:31,283 INFO spawned: 'supla-scheduler' with pid 36
2024-04-21 19:00:31,294 INFO spawned: 'supla-server' with pid 37
INFO[19:00:31.328734] Scheduler version 22.07.01
INFO[19:00:31.329096] Started at Sun Apr 21 19:00:31 2024
ERR[19:00:31.349000] MySQL - stmt prepare error - Table 'supla.migration_versions' doesn't exist
ERR[19:00:31.350302] The version of the database can not be determined!
2024-04-21 19:00:31,353 INFO exited: supla-scheduler (exit status 1; not expected)
INFO[19:00:31.390270] Server version 24.03 [Protocol v23]
INFO[19:00:31.390583] Started at Sun Apr 21 19:00:31 2024
ERR[19:00:31.399034] MySQL - stmt prepare error - Table 'supla.migration_versions' doesn't exist
ERR[19:00:31.399462] The version of the database can not be determined!
2024-04-21 19:00:31,404 INFO exited: supla-server (exit status 1; not expected)
2024-04-21 19:00:34,416 INFO spawned: 'supla-scheduler' with pid 38
2024-04-21 19:00:34,431 INFO spawned: 'supla-server' with pid 39
INFO[19:00:34.458576] Scheduler version 22.07.01
INFO[19:00:34.458839] Started at Sun Apr 21 19:00:34 2024
ERR[19:00:34.473508] MySQL - stmt prepare error - Table 'supla.migration_versions' doesn't exist
ERR[19:00:34.474222] The version of the database can not be determined!
2024-04-21 19:00:34,477 INFO exited: supla-scheduler (exit status 1; not expected)
INFO[19:00:34.533983] Server version 24.03 [Protocol v23]
INFO[19:00:34.534283] Started at Sun Apr 21 19:00:34 2024
2024-04-21 19:00:34,535 INFO gave up: supla-scheduler entered FATAL state, too many start retries too quickly
ERR[19:00:34.542925] MySQL - stmt prepare error - Table 'supla.migration_versions' doesn't exist
ERR[19:00:34.543355] The version of the database can not be determined!
2024-04-21 19:00:34,548 INFO exited: supla-server (exit status 1; not expected)
2024-04-21 19:00:35,550 INFO gave up: supla-server entered FATAL state, too many start retries too quickly
2024-04-21 20:02:24,272 WARN received SIGTERM indicating exit request
2024-04-21 20:02:39,794 CRIT Supervisor is running as root. Privileges were not dropped because no user is specified in the config file. If you intend to run as root, you can set user=root in the config file to avoid this message.
2024-04-21 20:02:39,848 INFO supervisord started with pid 1
2024-04-21 20:02:40,857 INFO spawned: 'supla-scheduler' with pid 16
2024-04-21 20:02:40,871 INFO spawned: 'supla-server' with pid 17
INFO[20:02:41.533568] Scheduler version 22.07.01
INFO[20:02:41.535447] Started at Sun Apr 21 20:02:41 2024
2024-04-21 20:02:42,537 INFO success: supla-scheduler entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2024-04-21 20:02:42,538 INFO success: supla-server entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
INFO[20:02:43.036366] Server version 24.03 [Protocol v23]
INFO[20:02:43.038194] Started at Sun Apr 21 20:02:43 2024
INFO[20:02:43.072087] SSL version: LibreSSL 3.5.4
ERR[20:02:43.467246] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:03:43.795825] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:04:44.083556] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:05:43.446397] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:06:43.782116] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:07:44.111090] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:08:43.386935] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:09:43.704709] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:10:44.011615] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:11:43.339317] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:12:43.665855] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:13:43.995509] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:14:43.287237] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:15:43.601842] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:16:43.902897] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:17:44.200005] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:18:43.524445] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:19:43.866027] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:20:44.165327] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:21:43.473076] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:22:43.844882] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:23:44.178470] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:24:43.474913] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:25:43.787216] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:26:44.090330] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:27:43.411956] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:28:43.728000] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:29:44.026011] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:30:43.349374] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:31:43.647475] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:32:43.975081] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:33:44.264571] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:34:43.515068] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:35:43.847365] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:36:44.165224] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:37:43.467854] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:38:43.767529] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:39:44.084702] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:40:43.418741] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:41:43.743031] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:42:44.042261] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:43:43.337474] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:44:43.653624] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:45:43.952153] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:46:44.260861] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:47:43.538875] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:48:43.842078] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:49:44.132244] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:50:43.422892] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:51:43.721896] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:52:44.029757] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:53:43.317812] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:54:43.618211] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[20:55:43.910865] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
INFO[13:29:13.427374] METRICS: USER[COUNT:0] CLIENT[ADD:0 MAX:0 COUNT:0 TRASH:0] DEVICE[ADD:0 MAX:0 COUNT:0 TRASH:0]
ERR[13:29:17.800297] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[13:30:14.034610] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[13:31:13.301722] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[13:32:13.598106] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[13:33:13.897988] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[13:34:14.199775] An attempt to obtain remote gateway token from the AD server failed. Result code: 403

DB:

2024-04-21T19:00:20.261160Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2024-04-21T19:00:20.261196Z 0 [Note] Shutting down plugin 'partition'
2024-04-21T19:00:20.261222Z 0 [Note] Shutting down plugin 'ARCHIVE'
2024-04-21T19:00:20.261246Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2024-04-21T19:00:20.261270Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2024-04-21T19:00:20.261294Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2024-04-21T19:00:20.261317Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2024-04-21T19:00:20.261339Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2024-04-21T19:00:20.261363Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2024-04-21T19:00:20.261386Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2024-04-21T19:00:20.261409Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2024-04-21T19:00:20.261431Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2024-04-21T19:00:20.261455Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2024-04-21T19:00:20.261478Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2024-04-21T19:00:20.261501Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2024-04-21T19:00:20.261525Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2024-04-21T19:00:20.261547Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2024-04-21T19:00:20.261569Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2024-04-21T19:00:20.261592Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2024-04-21T19:00:20.261615Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2024-04-21T19:00:20.261638Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2024-04-21T19:00:20.261661Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2024-04-21T19:00:20.261683Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2024-04-21T19:00:20.261753Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2024-04-21T19:00:20.262521Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2024-04-21T19:00:20.262559Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2024-04-21T19:00:20.262583Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2024-04-21T19:00:20.262606Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2024-04-21T19:00:20.262629Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2024-04-21T19:00:20.262651Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2024-04-21T19:00:20.262675Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2024-04-21T19:00:20.262751Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2024-04-21T19:00:20.262776Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2024-04-21T19:00:20.262799Z 0 [Note] Shutting down plugin 'InnoDB'
2024-04-21T19:00:20.270289Z 0 [Note] InnoDB: FTS optimize thread exiting.
2024-04-21T19:00:20.271043Z 0 [Note] InnoDB: Starting shutdown...
2024-04-21T19:00:20.372344Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2024-04-21T19:00:20.375348Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 240421 19:00:20
2024-04-21T19:00:23.581453Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12160846
2024-04-21T19:00:23.591843Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-04-21T19:00:23.592624Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2024-04-21T19:00:23.593268Z 0 [Note] Shutting down plugin 'MyISAM'
2024-04-21T19:00:23.594001Z 0 [Note] Shutting down plugin 'CSV'
2024-04-21T19:00:23.594614Z 0 [Note] Shutting down plugin 'MEMORY'
2024-04-21T19:00:23.594835Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2024-04-21T19:00:23.595562Z 0 [Note] Shutting down plugin 'sha256_password'
2024-04-21T19:00:23.595773Z 0 [Note] Shutting down plugin 'mysql_native_password'
2024-04-21T19:00:23.596557Z 0 [Note] Shutting down plugin 'binlog'
2024-04-21T19:00:23.600948Z 0 [Note] mysqld: Shutdown complete
MySQL init process done. Ready for start up.
2024-04-21T19:00:24.314231Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-04-21T19:00:24.321174Z 0 [Note] mysqld (mysqld 5.7.20) starting as process 1 ...
2024-04-21T19:00:24.341181Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-04-21T19:00:24.341279Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-04-21T19:00:24.341317Z 0 [Note] InnoDB: Uses event mutexes
2024-04-21T19:00:24.341352Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-04-21T19:00:24.341385Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2024-04-21T19:00:24.341418Z 0 [Note] InnoDB: Using Linux native AIO
2024-04-21T19:00:24.343046Z 0 [Note] InnoDB: Number of pools: 1
2024-04-21T19:00:24.343722Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2024-04-21T19:00:24.352522Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2024-04-21T19:00:24.402260Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-21T19:00:24.412250Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-04-21T19:00:24.626667Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-04-21T19:00:25.545525Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-21T19:00:25.546947Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-21T19:00:25.964373Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-04-21T19:00:25.967930Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2024-04-21T19:00:25.967995Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2024-04-21T19:00:25.973007Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 12160846
2024-04-21T19:00:25.978854Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-04-21T19:00:25.980119Z 0 [Note] Plugin 'FEDERATED' is disabled.
2024-04-21T19:00:26.722381Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240421 19:00:26
2024-04-21T19:00:26.802761Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2024-04-21T19:00:26.804053Z 0 [Warning] CA certificate ca.pem is self signed.
2024-04-21T19:00:26.813622Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2024-04-21T19:00:26.813870Z 0 [Note] IPv6 is available.
2024-04-21T19:00:26.813935Z 0 [Note] - '::' resolves to '::';
2024-04-21T19:00:26.814054Z 0 [Note] Server socket created on IP: '::'.
2024-04-21T19:00:27.166273Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2024-04-21T19:00:27.166372Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2024-04-21T19:00:27.166420Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2024-04-21T19:00:27.166535Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2024-04-21T19:00:27.166577Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2024-04-21T19:00:27.166631Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2024-04-21T19:00:27.298308Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2024-04-21T19:00:27.298647Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2024-04-21T19:00:27.382161Z 0 [Note] Event Scheduler: Loaded 0 events
2024-04-21T19:00:27.383431Z 0 [Note] mysqld: ready for connections.
Version: '5.7.20' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2024-04-21T19:00:27.383497Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2024-04-21T19:00:27.383549Z 0 [Note] Beginning of list of non-natively partitioned tables
2024-04-21T19:00:27.529810Z 0 [Note] End of list of non-natively partitioned tables
2024-04-21T20:02:46.316637Z 173 [Note] Aborted connection 173 to db: 'supla' user: 'supla' host: '172.18.0.3' (Got an error reading communication packets)
2024-04-21T20:02:46.316658Z 15 [Note] Aborted connection 15 to db: 'supla' user: 'supla' host: '172.18.0.3' (Got an error reading communication packets)
2024-04-21T20:03:25.759054Z 221 [Note] Aborted connection 221 to db: 'supla' user: 'supla' host: '172.18.0.3' (Got an error reading communication packets)
2024-04-22T13:29:15.542378Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 59573563ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)

Simono · Post Sun May 05, 2024 3:55 pm

Dawno nie patrzyłem u siebie w logi Supli i mam:

Code: Select all

root@supla-srv:~# docker logs --since=5m supla-server
ERR[15:45:35.574778] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[15:46:35.715063] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[15:47:35.864392] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[15:48:36.008630] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
ERR[15:49:35.139729] An attempt to obtain remote gateway token from the AD server failed. Result code: 403
root@supla-srv:~#

Co to dokładnie mam znaczyć? Mam lokalną dockerowa instalację.

pzygmunt · Post Sun May 05, 2024 4:05 pm

Prywatne instancje nie mają prawa rozmawiać bezpośrednio z GH, Alexą, APNS, Firebsse dlatego dostają w odpowiedzi http 403 (Forbidden) i muszą rozmawiać z tymi usługami przez bramki. Twoje logi są poprawne.

Simono · Post Sun May 05, 2024 4:43 pm

pzygmunt wrote: Sun May 05, 2024 4:05 pm Prywatne instancje nie mają prawa rozmawiać bezpośrednio z GH, Alexą, APNS, Firebsse dlatego dostają w odpowiedzi http 403 (Forbidden) i muszą rozmawiać z tymi usługami przez bramki. Twoje logi są poprawne.

Dzięki za szybkie info