Witam. Mam zainstalowany na Synology na Dockerze sewer supli . Ogólnie wszystko przebiegło pomyślnie system utworzył trzy kontenery (supla-cloud,supla-db, supla server . Serwer Supli startuje normalnie jednak po starcie w logach pojawiaja sie bledy polaczenia do bazy danych . W logach wszystkich trzech kontenerów.
W supla-db jest to blad Access denied for user 'supla'0'172.18.0.4(using password :YES)
W supla-server jest to blad Failed to connetct to databaser : Error:Access denied for user.........
W supla-cloud podobnie .
Co moze byc przyczyna ?
supla-server docker blad bazy danych
-
marcinkrysk
- Posts: 47
- Joined: Tue Dec 04, 2018 3:27 pm
Zainstalowalem to na podstawie instrukcji:viewtopic.php?t=5365&fbclid=IwAR0jmbp9P ... WaIew_jbUA
Teraz mam takie bledy:
w logach supla-cloud:
Migrating up to 20221219113615 from 20181024164957
++ migrating 20181025171850
-> CREATE TABLE supla_ic_log (id INT AUTO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL COMMENT '(DC2Type:utcdatetime)', counter BIGINT NOT NULL, calculated_value BIGINT NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB
Migration 20181025171850 failed during Execution. Error An exception occurred while executing 'CREATE TABLE supla_ic_log (id INT AUTO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL COMMENT '(DC2Type:utcdatetime)', counter BIGINT NOT NULL, calculated_value BIGINT NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB':
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_log' already exists
In AbstractMySQLDriver.php line 57:
An exception occurred while executing 'CREATE TABLE supla_ic_log (id INT AU
TO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL COMM
ENT '(DC2Type:utcdatetime)', counter BIGINT NOT NULL, calculated_value BIGI
NT NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIM
ARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = In
noDB':
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_lo
g' already exists
In Exception.php line 18:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_lo
g' already exists
In PDOConnection.php line 141:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_lo
g' already exists
doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--configuration [CONFIGURATION]] [--db-configuration [DB-CONFIGURATION]] [--db DB] [--em EM] [--shard SHARD] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command> [<version>]
Database connection has been established.
Application Migrations
Migrating up to 20221219113615 from 20181024164957
++ migrating 20181025171850
-> CREATE TABLE supla_ic_log (id INT AUTO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL COMMENT '(DC2Type:utcdatetime)', counter BIGINT NOT NULL, calculated_value BIGINT NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB
Migration 20181025171850 failed during Execution. Error An exception occurred while executing 'CREATE TABLE supla_ic_log (id INT AUTO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL COMMENT '(DC2Type:utcdatetime)', counter BIGINT NOT NULL, calculated_value BIGINT NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB':
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_log' already exists
In AbstractMySQLDriver.php line 57:
An exception occurred while executing 'CREATE TABLE supla_ic_log (id INT AU
TO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL COMM
ENT '(DC2Type:utcdatetime)', counter BIGINT NOT NULL, calculated_value BIGI
NT NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIM
ARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = In
noDB':
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_lo
g' already exists
In Exception.php line 18:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_lo
g' already exists
In PDOConnection.php line 141:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_lo
g' already exists
doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--configuration [CONFIGURATION]] [--db-configuration [DB-CONFIGURATION]] [--db DB] [--em EM] [--shard SHARD] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command> [<version>]
w supla-db:
2023-04-16T06:03:28.109199Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-04-16T06:03:28.110763Z 0 [Note] mysqld (mysqld 5.7.20) starting as process 1 ...
2023-04-16T06:03:28.114976Z 0 [Note] InnoDB: PUNCH HOLE support available
2023-04-16T06:03:28.115051Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-04-16T06:03:28.115079Z 0 [Note] InnoDB: Uses event mutexes
2023-04-16T06:03:28.115120Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-04-16T06:03:28.115151Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2023-04-16T06:03:28.115159Z 0 [Note] InnoDB: Using Linux native AIO
2023-04-16T06:03:28.115473Z 0 [Note] InnoDB: Number of pools: 1
2023-04-16T06:03:28.115664Z 0 [Note] InnoDB: Using CPU crc32 instructions
2023-04-16T06:03:28.117532Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2023-04-16T06:03:28.126833Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-04-16T06:03:28.129459Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-04-16T06:03:28.141234Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2023-04-16T06:03:29.733449Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-04-16T06:03:29.733830Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-04-16T06:03:30.156086Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-04-16T06:03:30.157222Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-04-16T06:03:30.157241Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-04-16T06:03:30.157516Z 0 [Note] InnoDB: Waiting for purge to start
2023-04-16T06:03:30.207718Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 16774932
2023-04-16T06:03:30.207961Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-04-16T06:03:30.207982Z 0 [Note] Plugin 'FEDERATED' is disabled.
2023-04-16T06:03:30.211087Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230416 6:03:30
2023-04-16T06:03:30.214050Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2023-04-16T06:03:30.214319Z 0 [Warning] CA certificate ca.pem is self signed.
2023-04-16T06:03:30.216472Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2023-04-16T06:03:30.216505Z 0 [Note] IPv6 is available.
2023-04-16T06:03:30.216516Z 0 [Note] - '::' resolves to '::';
2023-04-16T06:03:30.216535Z 0 [Note] Server socket created on IP: '::'.
2023-04-16T06:03:30.646535Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.646593Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.646606Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.646633Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.646645Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.646660Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.649206Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.649226Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.656211Z 0 [Note] Event Scheduler: Loaded 0 events
2023-04-16T06:03:30.656449Z 0 [Note] mysqld: ready for connections.
Version: '5.7.20' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2023-04-16T06:03:30.656462Z 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.
2023-04-16T06:03:30.656466Z 0 [Note] Beginning of list of non-natively partitioned tables
2023-04-16T06:03:30.671238Z 0 [Note] End of list of non-natively partitioned tables
2023-04-16T06:06:35.606044Z 0 [Note] Giving 0 client threads a chance to die gracefully
2023-04-16T06:06:35.606075Z 0 [Note] Shutting down slave threads
2023-04-16T06:06:35.606080Z 0 [Note] Forcefully disconnecting 0 remaining clients
2023-04-16T06:06:35.606086Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2023-04-16T06:06:35.606122Z 0 [Note] Binlog end
2023-04-16T06:06:35.607710Z 0 [Note] Shutting down plugin 'ngram'
2023-04-16T06:06:35.607750Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2023-04-16T06:06:35.607775Z 0 [Note] Shutting down plugin 'partition'
2023-04-16T06:06:35.607779Z 0 [Note] Shutting down plugin 'ARCHIVE'
2023-04-16T06:06:35.607781Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2023-04-16T06:06:35.607785Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-04-16T06:06:35.607787Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-04-16T06:06:35.607789Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-04-16T06:06:35.607792Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-04-16T06:06:35.607795Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-04-16T06:06:35.607797Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-04-16T06:06:35.607799Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-04-16T06:06:35.607801Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-04-16T06:06:35.607803Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-04-16T06:06:35.607807Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-04-16T06:06:35.607810Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-04-16T06:06:35.607812Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-04-16T06:06:35.607815Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-04-16T06:06:35.607817Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-04-16T06:06:35.607820Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-04-16T06:06:35.607823Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2023-04-16T06:06:35.607825Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2023-04-16T06:06:35.607828Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-04-16T06:06:35.607830Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-04-16T06:06:35.607832Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-04-16T06:06:35.607835Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-04-16T06:06:35.607837Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-04-16T06:06:35.607840Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-04-16T06:06:35.607843Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-04-16T06:06:35.607845Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-04-16T06:06:35.607848Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2023-04-16T06:06:35.607850Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-04-16T06:06:35.607853Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-04-16T06:06:35.607856Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2023-04-16T06:06:35.607859Z 0 [Note] Shutting down plugin 'InnoDB'
2023-04-16T06:06:35.607925Z 0 [Note] InnoDB: FTS optimize thread exiting.
2023-04-16T06:06:35.607982Z 0 [Note] InnoDB: Starting shutdown...
2023-04-16T06:06:35.708463Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2023-04-16T06:06:35.709037Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 230416 6:06:35
2023-04-16T06:06:37.556997Z 0 [Note] InnoDB: Shutdown completed; log sequence number 16774960
2023-04-16T06:06:37.559300Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-04-16T06:06:37.559366Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2023-04-16T06:06:37.559371Z 0 [Note] Shutting down plugin 'MyISAM'
2023-04-16T06:06:37.559384Z 0 [Note] Shutting down plugin 'CSV'
2023-04-16T06:06:37.559389Z 0 [Note] Shutting down plugin 'MEMORY'
2023-04-16T06:06:37.559394Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-04-16T06:06:37.559420Z 0 [Note] Shutting down plugin 'sha256_password'
2023-04-16T06:06:37.559423Z 0 [Note] Shutting down plugin 'mysql_native_password'
2023-04-16T06:06:37.559581Z 0 [Note] Shutting down plugin 'binlog'
2023-04-16T06:06:37.561738Z 0 [Note] mysqld: Shutdown complete
2023-04-16T06:06:44.251668Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-04-16T06:06:44.253485Z 0 [Note] mysqld (mysqld 5.7.20) starting as process 1 ...
2023-04-16T06:06:44.257697Z 0 [Note] InnoDB: PUNCH HOLE support available
2023-04-16T06:06:44.257722Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-04-16T06:06:44.257733Z 0 [Note] InnoDB: Uses event mutexes
2023-04-16T06:06:44.257738Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-04-16T06:06:44.257742Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2023-04-16T06:06:44.257746Z 0 [Note] InnoDB: Using Linux native AIO
2023-04-16T06:06:44.258014Z 0 [Note] InnoDB: Number of pools: 1
2023-04-16T06:06:44.258151Z 0 [Note] InnoDB: Using CPU crc32 instructions
2023-04-16T06:06:44.259979Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2023-04-16T06:06:44.270143Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-04-16T06:06:44.272414Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-04-16T06:06:44.284851Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2023-04-16T06:06:44.609207Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-04-16T06:06:44.609409Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-04-16T06:06:45.231613Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-04-16T06:06:45.232796Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-04-16T06:06:45.232809Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-04-16T06:06:45.233175Z 0 [Note] InnoDB: Waiting for purge to start
2023-04-16T06:06:45.283749Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 16774960
2023-04-16T06:06:45.284026Z 0 [Note] Plugin 'FEDERATED' is disabled.
2023-04-16T06:06:45.284066Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-04-16T06:06:45.287196Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230416 6:06:45
2023-04-16T06:06:45.288610Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2023-04-16T06:06:45.288847Z 0 [Warning] CA certificate ca.pem is self signed.
2023-04-16T06:06:45.290850Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2023-04-16T06:06:45.290880Z 0 [Note] IPv6 is available.
2023-04-16T06:06:45.290893Z 0 [Note] - '::' resolves to '::';
2023-04-16T06:06:45.290912Z 0 [Note] Server socket created on IP: '::'.
2023-04-16T06:06:45.541234Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.541269Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.541279Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.541306Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.541318Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.541331Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.543869Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.543886Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.550749Z 0 [Note] Event Scheduler: Loaded 0 events
2023-04-16T06:06:45.551211Z 0 [Note] mysqld: ready for connections.
Version: '5.7.20' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2023-04-16T06:06:45.551227Z 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.
2023-04-16T06:06:45.551231Z 0 [Note] Beginning of list of non-natively partitioned tables
2023-04-16T06:06:45.566317Z 0 [Note] End of list of non-natively partitioned tables
w supla-server:
2023-04-16 06:03:58,598 CRIT Supervisor running as root (no user in config file)
2023-04-16 06:03:58,617 INFO supervisord started with pid 1
2023-04-16 06:03:59,619 INFO spawned: 'supla-scheduler' with pid 25
2023-04-16 06:03:59,620 INFO spawned: 'supla-server' with pid 26
INFO[06:03:59.713119] Scheduler version 22.07.01
INFO[06:03:59.713189] Started at Sun Apr 16 06:03:59 2023
ERR[06:03:59.731434] Incorrect database version! Expected: 20221219113615
2023-04-16 06:03:59,732 INFO exited: supla-scheduler (exit status 1; not expected)
INFO[06:03:59.964144] Server version 22.12.01 [Protocol v19]
INFO[06:03:59.964230] Started at Sun Apr 16 06:03:59 2023
ERR[06:03:59.967068] Incorrect database version! Expected: 20221219113615
2023-04-16 06:03:59,968 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:04:00,970 INFO spawned: 'supla-scheduler' with pid 27
2023-04-16 06:04:00,971 INFO spawned: 'supla-server' with pid 28
INFO[06:04:00.976225] Scheduler version 22.07.01
INFO[06:04:00.977212] Started at Sun Apr 16 06:04:00 2023
ERR[06:04:00.980095] Incorrect database version! Expected: 20221219113615
INFO[06:04:00.981015] Server version 22.12.01 [Protocol v19]
2023-04-16 06:04:00,981 INFO exited: supla-scheduler (exit status 1; not expected)
INFO[06:04:00.981660] Started at Sun Apr 16 06:04:00 2023
ERR[06:04:00.984335] Incorrect database version! Expected: 20221219113615
2023-04-16 06:04:00,985 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:04:02,988 INFO spawned: 'supla-scheduler' with pid 29
2023-04-16 06:04:02,989 INFO spawned: 'supla-server' with pid 30
INFO[06:04:03.000833] Server version 22.12.01 [Protocol v19]
INFO[06:04:03.001389] Started at Sun Apr 16 06:04:03 2023
ERR[06:04:03.004161] Incorrect database version! Expected: 20221219113615
2023-04-16 06:04:03,005 INFO exited: supla-server (exit status 1; not expected)
INFO[06:04:03.006314] Scheduler version 22.07.01
INFO[06:04:03.006400] Started at Sun Apr 16 06:04:03 2023
ERR[06:04:03.008920] Incorrect database version! Expected: 20221219113615
2023-04-16 06:04:03,009 INFO exited: supla-scheduler (exit status 1; not expected)
2023-04-16 06:04:06,014 INFO spawned: 'supla-scheduler' with pid 31
2023-04-16 06:04:06,016 INFO spawned: 'supla-server' with pid 32
INFO[06:04:06.031028] Server version 22.12.01 [Protocol v19]
INFO[06:04:06.031971] Scheduler version 22.07.01
INFO[06:04:06.032240] Started at Sun Apr 16 06:04:06 2023
INFO[06:04:06.032549] Started at Sun Apr 16 06:04:06 2023
ERR[06:04:06.036650] Incorrect database version! Expected: 20221219113615
ERR[06:04:06.037252] Incorrect database version! Expected: 20221219113615
2023-04-16 06:04:06,039 INFO exited: supla-scheduler (exit status 1; not expected)
2023-04-16 06:04:06,039 INFO gave up: supla-scheduler entered FATAL state, too many start retries too quickly
2023-04-16 06:04:06,039 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:04:07,040 INFO gave up: supla-server entered FATAL state, too many start retries too quickly
2023-04-16 06:06:30,762 WARN received SIGTERM indicating exit request
2023-04-16 06:06:53,107 CRIT Supervisor running as root (no user in config file)
2023-04-16 06:06:53,109 INFO supervisord started with pid 1
2023-04-16 06:06:54,111 INFO spawned: 'supla-scheduler' with pid 17
2023-04-16 06:06:54,112 INFO spawned: 'supla-server' with pid 18
INFO[06:06:54.117526] Scheduler version 22.07.01
INFO[06:06:54.118082] Started at Sun Apr 16 06:06:54 2023
INFO[06:06:54.120904] Server version 22.12.01 [Protocol v19]
INFO[06:06:54.121466] Started at Sun Apr 16 06:06:54 2023
ERR[06:06:54.121904] Incorrect database version! Expected: 20221219113615
2023-04-16 06:06:54,122 INFO exited: supla-scheduler (exit status 1; not expected)
ERR[06:06:54.124097] Incorrect database version! Expected: 20221219113615
2023-04-16 06:06:54,125 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:06:55,127 INFO spawned: 'supla-scheduler' with pid 19
2023-04-16 06:06:55,128 INFO spawned: 'supla-server' with pid 20
INFO[06:06:55.133090] Scheduler version 22.07.01
INFO[06:06:55.133773] Started at Sun Apr 16 06:06:55 2023
ERR[06:06:55.136467] Incorrect database version! Expected: 20221219113615
INFO[06:06:55.136613] Server version 22.12.01 [Protocol v19]
INFO[06:06:55.136666] Started at Sun Apr 16 06:06:55 2023
2023-04-16 06:06:55,138 INFO exited: supla-scheduler (exit status 1; not expected)
ERR[06:06:55.139258] Incorrect database version! Expected: 20221219113615
2023-04-16 06:06:55,140 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:06:57,142 INFO spawned: 'supla-scheduler' with pid 21
2023-04-16 06:06:57,143 INFO spawned: 'supla-server' with pid 22
INFO[06:06:57.153436] Scheduler version 22.07.01
INFO[06:06:57.153497] Started at Sun Apr 16 06:06:57 2023
ERR[06:06:57.157265] Incorrect database version! Expected: 20221219113615
2023-04-16 06:06:57,158 INFO exited: supla-scheduler (exit status 1; not expected)
INFO[06:06:57.159566] Server version 22.12.01 [Protocol v19]
INFO[06:06:57.160111] Started at Sun Apr 16 06:06:57 2023
ERR[06:06:57.163136] Incorrect database version! Expected: 20221219113615
2023-04-16 06:06:57,164 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:07:00,168 INFO spawned: 'supla-scheduler' with pid 23
2023-04-16 06:07:00,170 INFO spawned: 'supla-server' with pid 24
INFO[06:07:00.178823] Scheduler version 22.07.01
INFO[06:07:00.178998] Started at Sun Apr 16 06:07:00 2023
INFO[06:07:00.180629] Server version 22.12.01 [Protocol v19]
INFO[06:07:00.180926] Started at Sun Apr 16 06:07:00 2023
ERR[06:07:00.183985] Incorrect database version! Expected: 20221219113615
2023-04-16 06:07:00,185 INFO exited: supla-scheduler (exit status 1; not expected)
ERR[06:07:00.186018] Incorrect database version! Expected: 20221219113615
2023-04-16 06:07:00,186 INFO gave up: supla-scheduler entered FATAL state, too many start retries too quickly
2023-04-16 06:07:00,187 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:07:01,188 INFO gave up: supla-server entered FATAL state, too many start retries too quickly
Teraz mam takie bledy:
w logach supla-cloud:
Migrating up to 20221219113615 from 20181024164957
++ migrating 20181025171850
-> CREATE TABLE supla_ic_log (id INT AUTO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL COMMENT '(DC2Type:utcdatetime)', counter BIGINT NOT NULL, calculated_value BIGINT NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB
Migration 20181025171850 failed during Execution. Error An exception occurred while executing 'CREATE TABLE supla_ic_log (id INT AUTO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL COMMENT '(DC2Type:utcdatetime)', counter BIGINT NOT NULL, calculated_value BIGINT NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB':
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_log' already exists
In AbstractMySQLDriver.php line 57:
An exception occurred while executing 'CREATE TABLE supla_ic_log (id INT AU
TO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL COMM
ENT '(DC2Type:utcdatetime)', counter BIGINT NOT NULL, calculated_value BIGI
NT NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIM
ARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = In
noDB':
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_lo
g' already exists
In Exception.php line 18:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_lo
g' already exists
In PDOConnection.php line 141:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_lo
g' already exists
doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--configuration [CONFIGURATION]] [--db-configuration [DB-CONFIGURATION]] [--db DB] [--em EM] [--shard SHARD] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command> [<version>]
Database connection has been established.
Application Migrations
Migrating up to 20221219113615 from 20181024164957
++ migrating 20181025171850
-> CREATE TABLE supla_ic_log (id INT AUTO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL COMMENT '(DC2Type:utcdatetime)', counter BIGINT NOT NULL, calculated_value BIGINT NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB
Migration 20181025171850 failed during Execution. Error An exception occurred while executing 'CREATE TABLE supla_ic_log (id INT AUTO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL COMMENT '(DC2Type:utcdatetime)', counter BIGINT NOT NULL, calculated_value BIGINT NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB':
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_log' already exists
In AbstractMySQLDriver.php line 57:
An exception occurred while executing 'CREATE TABLE supla_ic_log (id INT AU
TO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL COMM
ENT '(DC2Type:utcdatetime)', counter BIGINT NOT NULL, calculated_value BIGI
NT NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIM
ARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = In
noDB':
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_lo
g' already exists
In Exception.php line 18:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_lo
g' already exists
In PDOConnection.php line 141:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'supla_ic_lo
g' already exists
doctrine:migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--configuration [CONFIGURATION]] [--db-configuration [DB-CONFIGURATION]] [--db DB] [--em EM] [--shard SHARD] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command> [<version>]
w supla-db:
2023-04-16T06:03:28.109199Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-04-16T06:03:28.110763Z 0 [Note] mysqld (mysqld 5.7.20) starting as process 1 ...
2023-04-16T06:03:28.114976Z 0 [Note] InnoDB: PUNCH HOLE support available
2023-04-16T06:03:28.115051Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-04-16T06:03:28.115079Z 0 [Note] InnoDB: Uses event mutexes
2023-04-16T06:03:28.115120Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-04-16T06:03:28.115151Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2023-04-16T06:03:28.115159Z 0 [Note] InnoDB: Using Linux native AIO
2023-04-16T06:03:28.115473Z 0 [Note] InnoDB: Number of pools: 1
2023-04-16T06:03:28.115664Z 0 [Note] InnoDB: Using CPU crc32 instructions
2023-04-16T06:03:28.117532Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2023-04-16T06:03:28.126833Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-04-16T06:03:28.129459Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-04-16T06:03:28.141234Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2023-04-16T06:03:29.733449Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-04-16T06:03:29.733830Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-04-16T06:03:30.156086Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-04-16T06:03:30.157222Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-04-16T06:03:30.157241Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-04-16T06:03:30.157516Z 0 [Note] InnoDB: Waiting for purge to start
2023-04-16T06:03:30.207718Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 16774932
2023-04-16T06:03:30.207961Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-04-16T06:03:30.207982Z 0 [Note] Plugin 'FEDERATED' is disabled.
2023-04-16T06:03:30.211087Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230416 6:03:30
2023-04-16T06:03:30.214050Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2023-04-16T06:03:30.214319Z 0 [Warning] CA certificate ca.pem is self signed.
2023-04-16T06:03:30.216472Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2023-04-16T06:03:30.216505Z 0 [Note] IPv6 is available.
2023-04-16T06:03:30.216516Z 0 [Note] - '::' resolves to '::';
2023-04-16T06:03:30.216535Z 0 [Note] Server socket created on IP: '::'.
2023-04-16T06:03:30.646535Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.646593Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.646606Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.646633Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.646645Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.646660Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.649206Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.649226Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:03:30.656211Z 0 [Note] Event Scheduler: Loaded 0 events
2023-04-16T06:03:30.656449Z 0 [Note] mysqld: ready for connections.
Version: '5.7.20' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2023-04-16T06:03:30.656462Z 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.
2023-04-16T06:03:30.656466Z 0 [Note] Beginning of list of non-natively partitioned tables
2023-04-16T06:03:30.671238Z 0 [Note] End of list of non-natively partitioned tables
2023-04-16T06:06:35.606044Z 0 [Note] Giving 0 client threads a chance to die gracefully
2023-04-16T06:06:35.606075Z 0 [Note] Shutting down slave threads
2023-04-16T06:06:35.606080Z 0 [Note] Forcefully disconnecting 0 remaining clients
2023-04-16T06:06:35.606086Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2023-04-16T06:06:35.606122Z 0 [Note] Binlog end
2023-04-16T06:06:35.607710Z 0 [Note] Shutting down plugin 'ngram'
2023-04-16T06:06:35.607750Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2023-04-16T06:06:35.607775Z 0 [Note] Shutting down plugin 'partition'
2023-04-16T06:06:35.607779Z 0 [Note] Shutting down plugin 'ARCHIVE'
2023-04-16T06:06:35.607781Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2023-04-16T06:06:35.607785Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-04-16T06:06:35.607787Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-04-16T06:06:35.607789Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-04-16T06:06:35.607792Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-04-16T06:06:35.607795Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-04-16T06:06:35.607797Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-04-16T06:06:35.607799Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-04-16T06:06:35.607801Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-04-16T06:06:35.607803Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-04-16T06:06:35.607807Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-04-16T06:06:35.607810Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-04-16T06:06:35.607812Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-04-16T06:06:35.607815Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-04-16T06:06:35.607817Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-04-16T06:06:35.607820Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-04-16T06:06:35.607823Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2023-04-16T06:06:35.607825Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2023-04-16T06:06:35.607828Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-04-16T06:06:35.607830Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-04-16T06:06:35.607832Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-04-16T06:06:35.607835Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-04-16T06:06:35.607837Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-04-16T06:06:35.607840Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-04-16T06:06:35.607843Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-04-16T06:06:35.607845Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-04-16T06:06:35.607848Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2023-04-16T06:06:35.607850Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-04-16T06:06:35.607853Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-04-16T06:06:35.607856Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2023-04-16T06:06:35.607859Z 0 [Note] Shutting down plugin 'InnoDB'
2023-04-16T06:06:35.607925Z 0 [Note] InnoDB: FTS optimize thread exiting.
2023-04-16T06:06:35.607982Z 0 [Note] InnoDB: Starting shutdown...
2023-04-16T06:06:35.708463Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2023-04-16T06:06:35.709037Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 230416 6:06:35
2023-04-16T06:06:37.556997Z 0 [Note] InnoDB: Shutdown completed; log sequence number 16774960
2023-04-16T06:06:37.559300Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-04-16T06:06:37.559366Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2023-04-16T06:06:37.559371Z 0 [Note] Shutting down plugin 'MyISAM'
2023-04-16T06:06:37.559384Z 0 [Note] Shutting down plugin 'CSV'
2023-04-16T06:06:37.559389Z 0 [Note] Shutting down plugin 'MEMORY'
2023-04-16T06:06:37.559394Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-04-16T06:06:37.559420Z 0 [Note] Shutting down plugin 'sha256_password'
2023-04-16T06:06:37.559423Z 0 [Note] Shutting down plugin 'mysql_native_password'
2023-04-16T06:06:37.559581Z 0 [Note] Shutting down plugin 'binlog'
2023-04-16T06:06:37.561738Z 0 [Note] mysqld: Shutdown complete
2023-04-16T06:06:44.251668Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-04-16T06:06:44.253485Z 0 [Note] mysqld (mysqld 5.7.20) starting as process 1 ...
2023-04-16T06:06:44.257697Z 0 [Note] InnoDB: PUNCH HOLE support available
2023-04-16T06:06:44.257722Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-04-16T06:06:44.257733Z 0 [Note] InnoDB: Uses event mutexes
2023-04-16T06:06:44.257738Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-04-16T06:06:44.257742Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2023-04-16T06:06:44.257746Z 0 [Note] InnoDB: Using Linux native AIO
2023-04-16T06:06:44.258014Z 0 [Note] InnoDB: Number of pools: 1
2023-04-16T06:06:44.258151Z 0 [Note] InnoDB: Using CPU crc32 instructions
2023-04-16T06:06:44.259979Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2023-04-16T06:06:44.270143Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-04-16T06:06:44.272414Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-04-16T06:06:44.284851Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2023-04-16T06:06:44.609207Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-04-16T06:06:44.609409Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-04-16T06:06:45.231613Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-04-16T06:06:45.232796Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-04-16T06:06:45.232809Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-04-16T06:06:45.233175Z 0 [Note] InnoDB: Waiting for purge to start
2023-04-16T06:06:45.283749Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 16774960
2023-04-16T06:06:45.284026Z 0 [Note] Plugin 'FEDERATED' is disabled.
2023-04-16T06:06:45.284066Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-04-16T06:06:45.287196Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230416 6:06:45
2023-04-16T06:06:45.288610Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2023-04-16T06:06:45.288847Z 0 [Warning] CA certificate ca.pem is self signed.
2023-04-16T06:06:45.290850Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2023-04-16T06:06:45.290880Z 0 [Note] IPv6 is available.
2023-04-16T06:06:45.290893Z 0 [Note] - '::' resolves to '::';
2023-04-16T06:06:45.290912Z 0 [Note] Server socket created on IP: '::'.
2023-04-16T06:06:45.541234Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.541269Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.541279Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.541306Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.541318Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.541331Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.543869Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.543886Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2023-04-16T06:06:45.550749Z 0 [Note] Event Scheduler: Loaded 0 events
2023-04-16T06:06:45.551211Z 0 [Note] mysqld: ready for connections.
Version: '5.7.20' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2023-04-16T06:06:45.551227Z 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.
2023-04-16T06:06:45.551231Z 0 [Note] Beginning of list of non-natively partitioned tables
2023-04-16T06:06:45.566317Z 0 [Note] End of list of non-natively partitioned tables
w supla-server:
2023-04-16 06:03:58,598 CRIT Supervisor running as root (no user in config file)
2023-04-16 06:03:58,617 INFO supervisord started with pid 1
2023-04-16 06:03:59,619 INFO spawned: 'supla-scheduler' with pid 25
2023-04-16 06:03:59,620 INFO spawned: 'supla-server' with pid 26
INFO[06:03:59.713119] Scheduler version 22.07.01
INFO[06:03:59.713189] Started at Sun Apr 16 06:03:59 2023
ERR[06:03:59.731434] Incorrect database version! Expected: 20221219113615
2023-04-16 06:03:59,732 INFO exited: supla-scheduler (exit status 1; not expected)
INFO[06:03:59.964144] Server version 22.12.01 [Protocol v19]
INFO[06:03:59.964230] Started at Sun Apr 16 06:03:59 2023
ERR[06:03:59.967068] Incorrect database version! Expected: 20221219113615
2023-04-16 06:03:59,968 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:04:00,970 INFO spawned: 'supla-scheduler' with pid 27
2023-04-16 06:04:00,971 INFO spawned: 'supla-server' with pid 28
INFO[06:04:00.976225] Scheduler version 22.07.01
INFO[06:04:00.977212] Started at Sun Apr 16 06:04:00 2023
ERR[06:04:00.980095] Incorrect database version! Expected: 20221219113615
INFO[06:04:00.981015] Server version 22.12.01 [Protocol v19]
2023-04-16 06:04:00,981 INFO exited: supla-scheduler (exit status 1; not expected)
INFO[06:04:00.981660] Started at Sun Apr 16 06:04:00 2023
ERR[06:04:00.984335] Incorrect database version! Expected: 20221219113615
2023-04-16 06:04:00,985 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:04:02,988 INFO spawned: 'supla-scheduler' with pid 29
2023-04-16 06:04:02,989 INFO spawned: 'supla-server' with pid 30
INFO[06:04:03.000833] Server version 22.12.01 [Protocol v19]
INFO[06:04:03.001389] Started at Sun Apr 16 06:04:03 2023
ERR[06:04:03.004161] Incorrect database version! Expected: 20221219113615
2023-04-16 06:04:03,005 INFO exited: supla-server (exit status 1; not expected)
INFO[06:04:03.006314] Scheduler version 22.07.01
INFO[06:04:03.006400] Started at Sun Apr 16 06:04:03 2023
ERR[06:04:03.008920] Incorrect database version! Expected: 20221219113615
2023-04-16 06:04:03,009 INFO exited: supla-scheduler (exit status 1; not expected)
2023-04-16 06:04:06,014 INFO spawned: 'supla-scheduler' with pid 31
2023-04-16 06:04:06,016 INFO spawned: 'supla-server' with pid 32
INFO[06:04:06.031028] Server version 22.12.01 [Protocol v19]
INFO[06:04:06.031971] Scheduler version 22.07.01
INFO[06:04:06.032240] Started at Sun Apr 16 06:04:06 2023
INFO[06:04:06.032549] Started at Sun Apr 16 06:04:06 2023
ERR[06:04:06.036650] Incorrect database version! Expected: 20221219113615
ERR[06:04:06.037252] Incorrect database version! Expected: 20221219113615
2023-04-16 06:04:06,039 INFO exited: supla-scheduler (exit status 1; not expected)
2023-04-16 06:04:06,039 INFO gave up: supla-scheduler entered FATAL state, too many start retries too quickly
2023-04-16 06:04:06,039 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:04:07,040 INFO gave up: supla-server entered FATAL state, too many start retries too quickly
2023-04-16 06:06:30,762 WARN received SIGTERM indicating exit request
2023-04-16 06:06:53,107 CRIT Supervisor running as root (no user in config file)
2023-04-16 06:06:53,109 INFO supervisord started with pid 1
2023-04-16 06:06:54,111 INFO spawned: 'supla-scheduler' with pid 17
2023-04-16 06:06:54,112 INFO spawned: 'supla-server' with pid 18
INFO[06:06:54.117526] Scheduler version 22.07.01
INFO[06:06:54.118082] Started at Sun Apr 16 06:06:54 2023
INFO[06:06:54.120904] Server version 22.12.01 [Protocol v19]
INFO[06:06:54.121466] Started at Sun Apr 16 06:06:54 2023
ERR[06:06:54.121904] Incorrect database version! Expected: 20221219113615
2023-04-16 06:06:54,122 INFO exited: supla-scheduler (exit status 1; not expected)
ERR[06:06:54.124097] Incorrect database version! Expected: 20221219113615
2023-04-16 06:06:54,125 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:06:55,127 INFO spawned: 'supla-scheduler' with pid 19
2023-04-16 06:06:55,128 INFO spawned: 'supla-server' with pid 20
INFO[06:06:55.133090] Scheduler version 22.07.01
INFO[06:06:55.133773] Started at Sun Apr 16 06:06:55 2023
ERR[06:06:55.136467] Incorrect database version! Expected: 20221219113615
INFO[06:06:55.136613] Server version 22.12.01 [Protocol v19]
INFO[06:06:55.136666] Started at Sun Apr 16 06:06:55 2023
2023-04-16 06:06:55,138 INFO exited: supla-scheduler (exit status 1; not expected)
ERR[06:06:55.139258] Incorrect database version! Expected: 20221219113615
2023-04-16 06:06:55,140 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:06:57,142 INFO spawned: 'supla-scheduler' with pid 21
2023-04-16 06:06:57,143 INFO spawned: 'supla-server' with pid 22
INFO[06:06:57.153436] Scheduler version 22.07.01
INFO[06:06:57.153497] Started at Sun Apr 16 06:06:57 2023
ERR[06:06:57.157265] Incorrect database version! Expected: 20221219113615
2023-04-16 06:06:57,158 INFO exited: supla-scheduler (exit status 1; not expected)
INFO[06:06:57.159566] Server version 22.12.01 [Protocol v19]
INFO[06:06:57.160111] Started at Sun Apr 16 06:06:57 2023
ERR[06:06:57.163136] Incorrect database version! Expected: 20221219113615
2023-04-16 06:06:57,164 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:07:00,168 INFO spawned: 'supla-scheduler' with pid 23
2023-04-16 06:07:00,170 INFO spawned: 'supla-server' with pid 24
INFO[06:07:00.178823] Scheduler version 22.07.01
INFO[06:07:00.178998] Started at Sun Apr 16 06:07:00 2023
INFO[06:07:00.180629] Server version 22.12.01 [Protocol v19]
INFO[06:07:00.180926] Started at Sun Apr 16 06:07:00 2023
ERR[06:07:00.183985] Incorrect database version! Expected: 20221219113615
2023-04-16 06:07:00,185 INFO exited: supla-scheduler (exit status 1; not expected)
ERR[06:07:00.186018] Incorrect database version! Expected: 20221219113615
2023-04-16 06:07:00,186 INFO gave up: supla-scheduler entered FATAL state, too many start retries too quickly
2023-04-16 06:07:00,187 INFO exited: supla-server (exit status 1; not expected)
2023-04-16 06:07:01,188 INFO gave up: supla-server entered FATAL state, too many start retries too quickly
-
marcinkrysk
- Posts: 47
- Joined: Tue Dec 04, 2018 3:27 pm
Ogólnie to jest moja pierwsza i
instalacja supla-server i nie robiłem żadnej migracji . Oczywiscie instalacje robiłem kilka razy nawet próbowałem usunąc całą apke dockera z Synology więc i baza powinna się w całości usunąć cały katalog /docker/ się usuwa
instalacja supla-server i nie robiłem żadnej migracji . Oczywiscie instalacje robiłem kilka razy nawet próbowałem usunąc całą apke dockera z Synology więc i baza powinna się w całości usunąć cały katalog /docker/ się usuwa
-
marcinkrysk
- Posts: 47
- Joined: Tue Dec 04, 2018 3:27 pm
wywalilem wszystko zresetowalem Synology i kontenery wystartowaly i teraz konterner Supla-Cloud caly czas sie resetuje i pokazal taki blad:
Generating a RSA private key
......................................................+++++
...........+++++
writing new private key to '/etc/apache2/ssl/server.key'
-----
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
Generating a RSA private key
......................................................+++++
...........+++++
writing new private key to '/etc/apache2/ssl/server.key'
-----
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
-
marcinkrysk
- Posts: 47
- Joined: Tue Dec 04, 2018 3:27 pm
po kilku samoistnych resetach kontenera supla-cloud juz sie nie resetuje i pokazuje takie logi:
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
Database connection has been established.
Application Migrations
Migrating up to 20221219113615 from 0
++ migrating 20170101000000
-> CREATE TABLE supla_accessid (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, password VARCHAR(32) NOT NULL, caption VARCHAR(100) DEFAULT NULL, enabled TINYINT(1) NOT NULL, INDEX IDX_A5549B6CA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_client (id INT AUTO_INCREMENT NOT NULL, access_id INT NOT NULL, guid BINARY(16) NOT NULL, name VARCHAR(100) DEFAULT NULL, enabled TINYINT(1) NOT NULL, reg_ipv4 INT UNSIGNED NOT NULL, reg_date DATETIME NOT NULL, last_access_ipv4 INT UNSIGNED NOT NULL, last_access_date DATETIME NOT NULL, software_version VARCHAR(20) NOT NULL, protocol_version INT NOT NULL, INDEX IDX_5430007F4FEA67CF (access_id), UNIQUE INDEX UNIQUE_CLIENTAPP (id, guid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_iodevice (id INT AUTO_INCREMENT NOT NULL, location_id INT NOT NULL, user_id INT NOT NULL, guid BINARY(16) NOT NULL, name VARCHAR(100) DEFAULT NULL, enabled TINYINT(1) NOT NULL, comment VARCHAR(200) DEFAULT NULL, reg_date DATETIME NOT NULL, reg_ipv4 INT UNSIGNED NOT NULL, last_connected DATETIME DEFAULT NULL, last_ipv4 INT DEFAULT NULL, software_version VARCHAR(10) NOT NULL, protocol_version INT NOT NULL, UNIQUE INDEX UNIQ_793D49D2B6FCFB2 (guid), INDEX IDX_793D49D64D218E (location_id), INDEX IDX_793D49DA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_dev_channel (id INT AUTO_INCREMENT NOT NULL, iodevice_id INT NOT NULL, user_id INT NOT NULL, channel_number INT NOT NULL, caption VARCHAR(100) DEFAULT NULL, type INT NOT NULL, func INT NOT NULL, flist INT DEFAULT NULL, param1 INT NOT NULL, param2 INT NOT NULL, param3 INT NOT NULL, INDEX IDX_81E928C9125F95D6 (iodevice_id), INDEX IDX_81E928C9A76ED395 (user_id), UNIQUE INDEX UNIQUE_CHANNEL (iodevice_id, channel_number), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_location (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, password VARCHAR(32) NOT NULL, caption VARCHAR(100) NOT NULL, enabled TINYINT(1) NOT NULL, INDEX IDX_3698128EA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_rel_aidloc (location_id INT NOT NULL, access_id INT NOT NULL, INDEX IDX_2B15904164D218E (location_id), INDEX IDX_2B1590414FEA67CF (access_id), PRIMARY KEY(location_id, access_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_temperature_log (id INT AUTO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL, temperature NUMERIC(8, 4) NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_temphumidity_log (id INT AUTO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL, temperature NUMERIC(8, 4) NOT NULL, humidity NUMERIC(8, 4) NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_user (id INT AUTO_INCREMENT NOT NULL, salt VARCHAR(32) NOT NULL, email VARCHAR(255) NOT NULL, password VARCHAR(64) NOT NULL, enabled TINYINT(1) NOT NULL, reg_date DATETIME NOT NULL, last_login DATETIME DEFAULT NULL, last_ipv4 INT DEFAULT NULL, current_login DATETIME DEFAULT NULL, current_ipv4 INT DEFAULT NULL, token VARCHAR(255) NOT NULL, password_requested_at DATETIME DEFAULT NULL, limit_aid INT NOT NULL, limit_loc INT NOT NULL, limit_iodev INT NOT NULL, limit_client INT NOT NULL, UNIQUE INDEX UNIQ_71BAEAC6E7927C74 (email), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
ALTER TABLE supla_accessid ADD CONSTRAINT FK_A5549B6CA76ED395 FOREIGN KEY (user_id) REFERENCES supla_user (id);
ALTER TABLE supla_client ADD CONSTRAINT FK_5430007F4FEA67CF FOREIGN KEY (access_id) REFERENCES supla_accessid (id);
ALTER TABLE supla_iodevice ADD CONSTRAINT FK_793D49D64D218E FOREIGN KEY (location_id) REFERENCES supla_location (id);
ALTER TABLE supla_iodevice ADD CONSTRAINT FK_793D49DA76ED395 FOREIGN KEY (user_id) REFERENCES supla_user (id);
ALTER TABLE supla_dev_channel ADD CONSTRAINT FK_81E928C9125F95D6 FOREIGN KEY (iodevice_id) REFERENCES supla_iodevice (id);
ALTER TABLE supla_dev_channel ADD CONSTRAINT FK_81E928C9A76ED395 FOREIGN KEY (user_id) REFERENCES supla_user (id);
ALTER TABLE supla_location ADD CONSTRAINT FK_3698128EA76ED395 FOREIGN KEY (user_id) REFERENCES supla_user (id);
ALTER TABLE supla_rel_aidloc ADD CONSTRAINT FK_2B15904164D218E FOREIGN KEY (location_id) REFERENCES supla_location (id);
ALTER TABLE supla_rel_aidloc ADD CONSTRAINT FK_2B1590414FEA67CF FOREIGN KEY (access_id) REFERENCES supla_accessid (id);
In ConnectionFactory.php line 79:
An exception occured while establishing a connection to figure out your pla
tform version.
You can circumvent this by setting a 'server_version' configuration value
For further information have a look at:
https://github.com/doctrine/DoctrineBundle/issues/673
In AbstractMySQLDriver.php line 112:
An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused
In Exception.php line 18:
SQLSTATE[HY000] [2002] Connection refused
In PDOConnection.php line 40:
SQLSTATE[HY000] [2002] Connection refused
Database connection has been established.
Application Migrations
Migrating up to 20221219113615 from 0
++ migrating 20170101000000
-> CREATE TABLE supla_accessid (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, password VARCHAR(32) NOT NULL, caption VARCHAR(100) DEFAULT NULL, enabled TINYINT(1) NOT NULL, INDEX IDX_A5549B6CA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_client (id INT AUTO_INCREMENT NOT NULL, access_id INT NOT NULL, guid BINARY(16) NOT NULL, name VARCHAR(100) DEFAULT NULL, enabled TINYINT(1) NOT NULL, reg_ipv4 INT UNSIGNED NOT NULL, reg_date DATETIME NOT NULL, last_access_ipv4 INT UNSIGNED NOT NULL, last_access_date DATETIME NOT NULL, software_version VARCHAR(20) NOT NULL, protocol_version INT NOT NULL, INDEX IDX_5430007F4FEA67CF (access_id), UNIQUE INDEX UNIQUE_CLIENTAPP (id, guid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_iodevice (id INT AUTO_INCREMENT NOT NULL, location_id INT NOT NULL, user_id INT NOT NULL, guid BINARY(16) NOT NULL, name VARCHAR(100) DEFAULT NULL, enabled TINYINT(1) NOT NULL, comment VARCHAR(200) DEFAULT NULL, reg_date DATETIME NOT NULL, reg_ipv4 INT UNSIGNED NOT NULL, last_connected DATETIME DEFAULT NULL, last_ipv4 INT DEFAULT NULL, software_version VARCHAR(10) NOT NULL, protocol_version INT NOT NULL, UNIQUE INDEX UNIQ_793D49D2B6FCFB2 (guid), INDEX IDX_793D49D64D218E (location_id), INDEX IDX_793D49DA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_dev_channel (id INT AUTO_INCREMENT NOT NULL, iodevice_id INT NOT NULL, user_id INT NOT NULL, channel_number INT NOT NULL, caption VARCHAR(100) DEFAULT NULL, type INT NOT NULL, func INT NOT NULL, flist INT DEFAULT NULL, param1 INT NOT NULL, param2 INT NOT NULL, param3 INT NOT NULL, INDEX IDX_81E928C9125F95D6 (iodevice_id), INDEX IDX_81E928C9A76ED395 (user_id), UNIQUE INDEX UNIQUE_CHANNEL (iodevice_id, channel_number), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_location (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, password VARCHAR(32) NOT NULL, caption VARCHAR(100) NOT NULL, enabled TINYINT(1) NOT NULL, INDEX IDX_3698128EA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_rel_aidloc (location_id INT NOT NULL, access_id INT NOT NULL, INDEX IDX_2B15904164D218E (location_id), INDEX IDX_2B1590414FEA67CF (access_id), PRIMARY KEY(location_id, access_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_temperature_log (id INT AUTO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL, temperature NUMERIC(8, 4) NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_temphumidity_log (id INT AUTO_INCREMENT NOT NULL, channel_id INT NOT NULL, date DATETIME NOT NULL, temperature NUMERIC(8, 4) NOT NULL, humidity NUMERIC(8, 4) NOT NULL, INDEX channel_id_idx (channel_id), INDEX date_idx (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE supla_user (id INT AUTO_INCREMENT NOT NULL, salt VARCHAR(32) NOT NULL, email VARCHAR(255) NOT NULL, password VARCHAR(64) NOT NULL, enabled TINYINT(1) NOT NULL, reg_date DATETIME NOT NULL, last_login DATETIME DEFAULT NULL, last_ipv4 INT DEFAULT NULL, current_login DATETIME DEFAULT NULL, current_ipv4 INT DEFAULT NULL, token VARCHAR(255) NOT NULL, password_requested_at DATETIME DEFAULT NULL, limit_aid INT NOT NULL, limit_loc INT NOT NULL, limit_iodev INT NOT NULL, limit_client INT NOT NULL, UNIQUE INDEX UNIQ_71BAEAC6E7927C74 (email), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
ALTER TABLE supla_accessid ADD CONSTRAINT FK_A5549B6CA76ED395 FOREIGN KEY (user_id) REFERENCES supla_user (id);
ALTER TABLE supla_client ADD CONSTRAINT FK_5430007F4FEA67CF FOREIGN KEY (access_id) REFERENCES supla_accessid (id);
ALTER TABLE supla_iodevice ADD CONSTRAINT FK_793D49D64D218E FOREIGN KEY (location_id) REFERENCES supla_location (id);
ALTER TABLE supla_iodevice ADD CONSTRAINT FK_793D49DA76ED395 FOREIGN KEY (user_id) REFERENCES supla_user (id);
ALTER TABLE supla_dev_channel ADD CONSTRAINT FK_81E928C9125F95D6 FOREIGN KEY (iodevice_id) REFERENCES supla_iodevice (id);
ALTER TABLE supla_dev_channel ADD CONSTRAINT FK_81E928C9A76ED395 FOREIGN KEY (user_id) REFERENCES supla_user (id);
ALTER TABLE supla_location ADD CONSTRAINT FK_3698128EA76ED395 FOREIGN KEY (user_id) REFERENCES supla_user (id);
ALTER TABLE supla_rel_aidloc ADD CONSTRAINT FK_2B15904164D218E FOREIGN KEY (location_id) REFERENCES supla_location (id);
ALTER TABLE supla_rel_aidloc ADD CONSTRAINT FK_2B1590414FEA67CF FOREIGN KEY (access_id) REFERENCES supla_accessid (id);