MYSQL, CommunityServer, MailServer issues (Workspace on Synology NAS)

I've tried several versions from 8.0.36 to 9.0.1. Still get the same issue. After several hours of trying to trouble shoot, I discovered that with the Synology NAS I couldn't map any of the folders to the mysql folder on the host without communityserver and mailserver failing to connect to the mysql container. After discovering this, once I removed the mapping,
Example:
#      - /volume1/docker/onlyoffice/mysql/conf.d:/etc/mysql/conf.d
#      - /volume1/docker/onlyoffice/mysql/docker-entrypoint-initdb.d:/docker-entrypoint-initdb.d
#      - /volume1/docker/onlyoffice/mysql/data:/var/lib/mysql

communityserver finally connected. conf.d and docker-entrypoint-initdb.d is always being ignored so whatever settings don't get applied.
Another issue is with the CommunityServer that two of the services fail which may only fail because there are a services the fail with the MailServer. The service in the mail service fail, because of issues with MySQL. On the CS, the MailAgregator.service fails and the MailWatchdog.service fails. On the MailServer, the  OpenDKIM service fails because of the authentication protocol is not supported by the client.
Note: I know that the issue with the mysql data folder on the host being mapped is a permission issue. Same thing with the other two folders that would go in that same folder. Should I use UMASK=002 to fix this with mysql?
Issue one
[Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
onlyoffice-mysql-server      | 2024-07-29T04:02:33.065370Z 89 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
onlyoffice-mysql-server      | 2024-07-29T04:02:33.070286Z 90 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead

Issue two
ERROR 1251 (08004): Client does not support authentication protocol requested by server; consider upgrading MySQL client

Issue three
onlyoffice-mail-server       | Starting OpenDKIM Milter: opendkim: /etc/opendkim.conf: dsn:mysql://mail_admin:Isadmin123@onlyoffice-mysql-server/onlyoffice_mailserver/table=dkim?keycol=domain_name?datacol=id: dkimf_db_open(): Client does not support authentication protocol requested by server; consider upgrading MySQL client
onlyoffice-mail-server       |                             [FAILED]

Issue four
onlyoffice-mysql-server      | mysqld: [Warning] World-writable config file '/etc/mysql/conf.d/onlyoffice.cnf' is ignored.
onlyoffice-mysql-server      | 2024-07-26T22:16:59.262871Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
onlyoffice-mysql-server      | 2024-07-26T22:16:59.264412Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 9.0.1) initializing of server in progress as process 80
onlyoffice-mysql-server      | 2024-07-26T22:16:59.266216Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
onlyoffice-mysql-server      | 2024-07-26T22:16:59.266221Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
onlyoffice-mysql-server      | 2024-07-26T22:16:59.266271Z 0 [ERROR] [MY-010119] [Server] Aborting
onlyoffice-mysql-server      | 2024-07-26T22:16:59.266689Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
onlyoffice-mysql-server      | 2024-07-26 22:17:45+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.0.1-1.el9 started.
onlyoffice-mysql-server      | 2024-07-26 22:17:45+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
onlyoffice-mysql-server      | 2024-07-26 22:17:45+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.0.1-1.el9 started.
onlyoffice-mysql-server      | 2024-07-26 22:17:45+00:00 [Note] [Entrypoint]: Initializing database files
onlyoffice-mysql-server      | mysqld: [Warning] World-writable config file '/etc/mysql/conf.d/onlyoffice.cnf' is ignored.
onlyoffice-mysql-server      | 2024-07-26T22:17:45.769218Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
onlyoffice-mysql-server      | 2024-07-26T22:17:45.770631Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 9.0.1) initializing of server in progress as process 80
onlyoffice-mysql-server      | 2024-07-26T22:17:45.772447Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
onlyoffice-mysql-server      | 2024-07-26T22:17:45.772452Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
onlyoffice-mysql-server      | 2024-07-26T22:17:45.772502Z 0 [ERROR] [MY-010119] [Server] Aborting
onlyoffice-mysql-server      | 2024-07-26T22:17:45.772932Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
onlyoffice-mysql-server exited with code 0
onlyoffice-mysql-server      | 2024-07-26 22:18:09+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.0.1-1.el9 started.
onlyoffice-mysql-server      | 2024-07-26 22:18:09+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
onlyoffice-mysql-server      | 2024-07-26 22:18:09+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.0.1-1.el9 started.
onlyoffice-mysql-server      | 2024-07-26 22:18:09+00:00 [Note] [Entrypoint]: Initializing database files
onlyoffice-mysql-server      | mysqld: [Warning] World-writable config file '/etc/mysql/conf.d/onlyoffice.cnf' is ignored.
onlyoffice-mysql-server      | 2024-07-26T22:18:09.893748Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
onlyoffice-mysql-server      | 2024-07-26T22:18:09.895376Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 9.0.1) initializing of server in progress as process 80
onlyoffice-mysql-server      | 2024-07-26T22:18:09.897418Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
onlyoffice-mysql-server      | 2024-07-26T22:18:09.897424Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
onlyoffice-mysql-server      | 2024-07-26T22:18:09.897475Z 0 [ERROR] [MY-010119] [Server] Aborting
onlyoffice-mysql-server      | 2024-07-26T22:18:09.897940Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
onlyoffice-mysql-server exited with code 0
onlyoffice-mysql-server      | 2024-07-26 22:18:31+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.0.1-1.el9 started.
onlyoffice-mysql-server      | 2024-07-26 22:18:31+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
onlyoffice-mysql-server      | 2024-07-26 22:18:31+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.0.1-1.el9 started.
onlyoffice-mysql-server      | 2024-07-26T22:18:32.384375Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
onlyoffice-mysql-server      | 2024-07-26T22:18:32.384380Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
onlyoffice-mysql-server      | 2024-07-26T22:18:32.384427Z 0 [ERROR] [MY-010119] [Server] Aborting
onlyoffice-mysql-server      | 2024-07-26T22:18:32.384427Z 0 [ERROR] [MY-010119] [Server] Aborting
onlyoffice-mysql-server      | 2024-07-26T22:18:32.384879Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
onlyoffice-mysql-server      | 2024-07-26T22:18:32.384879Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
onlyoffice-mysql-server exited with code 1

Issue five
× onlyofficeMailWatchdog.service - ONLYOFFICE MailWatchdog Service
     Loaded: loaded (/lib/systemd/system/onlyofficeMailWatchdog.service; enabled; vendor preset: enabled)
     Active: failed (Result: core-dump) since Mon 2024-07-29 05:47:40 UTC; 7min ago
    Process: 7158 ExecStart=/usr/bin/dotnet /var/www/onlyoffice/Services/MailWatchdog/ASC.Mail.Watchdog.Service.dll --urls=http://<IP_ADDRESS>:5031 --pathToConf=/etc/onlyoffice/communityserver --pathToNlogConf=/etc/onlyoffice/communityserver --log:dir=/var/log/onlyoffice/mail --log:name=mail-watchdog --ENVIRONMENT=production (code=dumped, signal=ABRT)
   Main PID: 7158 (code=dumped, signal=ABRT)

Issue 6
× onlyofficeMailAggregator.service - ONLYOFFICE MailAggregator Service
     Loaded: loaded (/lib/systemd/system/onlyofficeMailAggregator.service; enabled; vendor preset: enabled)
     Active: failed (Result: core-dump) since Mon 2024-07-29 05:47:40 UTC; 39min ago
    Process: 7183 ExecStart=/usr/bin/dotnet /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.Aggregator.Service.dll --urls=http://<IP_ADDRESS>:5025 --pathToConf=/etc/onlyoffice/communityserver --pathToNlogConf=/etc/onlyoffice/communityserver --log:dir=/var/log/onlyoffice/mail --log:name=mail-aggregator --ENVIRONMENT=production (code=dumped, signal=ABRT)
   Main PID: 7183 (code=dumped, signal=ABRT)

Docker-compose
version: "3"
services:
  onlyoffice-mysql-server:
    container_name: onlyoffice-mysql-server
    image: mysql:9.0.1
    environment:
      - MYSQL_ROOT_PASSWORD=
      - TZ=America/Chicago
    stdin_open: true
    tty: true
    restart: always
    privileged: true
    expose:
      - "3306"
      - "33060"
  #    volumes:
  #      - /volume1/docker/onlyoffice/mysql/conf.d:/etc/mysql/conf.d
  #      - /volume1/docker/onlyoffice/mysql/docker-entrypoint-initdb.d:/docker-entrypoint-initdb.d
  #      - /volume1/docker/onlyoffice/mysql/data:/var/lib/mysql

  onlyoffice-community-server:
    container_name: onlyoffice-community-server
    image: onlyoffice/communityserver:<IP_ADDRESS>8
    depends_on:
      - onlyoffice-mysql-server
      - onlyoffice-document-server
      - onlyoffice-mail-server
      - onlyoffice-elasticsearch
    environment:
      - ONLYOFFICE_CORE_MACHINEKEY=
      - TZ=America/Chicago
      - CONTROL_PANEL_PORT_80_TCP=80
      - CONTROL_PANEL_PORT_80_TCP_ADDR=onlyoffice-control-panel
      - DOCUMENT_SERVER_PORT_80_TCP_ADDR=onlyoffice-document-server
      - DOCUMENT_SERVER_JWT_ENABLED=true
      - DOCUMENT_SERVER_JWT_SECRET=
      - DOCUMENT_SERVER_JWT_HEADER=AuthorizationJwt
      - MYSQL_SERVER_ROOT_PASSWORD=
      - MYSQL_SERVER_DB_NAME=onlyoffice
      - MYSQL_SERVER_HOST=onlyoffice-mysql-server
      - MYSQL_SERVER_USER=onlyoffice_user
      - MYSQL_SERVER_PASS=onlyoffice_pass
      - MAIL_SERVER_API_PORT=8081
      - MAIL_SERVER_API_HOST=onlyoffice-mail-server
      - MAIL_SERVER_DB_HOST=onlyoffice-mysql-server
      - MAIL_SERVER_DB_PORT=3306
      - MAIL_SERVER_DB_NAME=onlyoffice_mailserver
      - MAIL_SERVER_DB_USER=mail_admin
      - MAIL_SERVER_DB_PASS=
      - ELASTICSEARCH_SERVER_HOST=onlyoffice-elasticsearch
      - ELASTICSEARCH_SERVER_HTTPPORT=9200
    ports:
      - 8500:80
      - 5222:5222
      - 9443:443
    stdin_open: true
    tty: true
    restart: always
    privileged: true
    #    cgroup: host
    volumes:
      - /volume1/docker/onlyoffice/communityserver/data:/var/www/onlyoffice/Data
      - /volume1/docker/onlyoffice/communityserver/logs:/var/log/onlyoffice
      - /volume1/docker/onlyoffice/communityserver/letsencrypt:/etc/letsencrypt
      - /volume1/docker/onlyoffice/documentserver/data:/var/www/onlyoffice/DocumentServerData
      - /sys/fs/cgroup:/sys/fs/cgroup:rw
      - /volume1/docker/onlyoffice/communityserver/certs:/var/www/onlyoffice/Data/certs
  onlyoffice-document-server:
    container_name: onlyoffice-document-server
    image: onlyoffice/documentserver-ee:latest
    stdin_open: true
    tty: true
    restart: always
    environment:
      - JWT_ENABLED=true
      - JWT_SECRET=Jwt password
      - JWT_HEADER=AuthorizationJwt
      - TZ=America/Chicago
    expose:
      - "80"
      - "443"
    volumes:
      - /volume1/docker/onlyoffice/documentserver/data:/var/www/onlyoffice/Data
      - /volume1/docker/onlyoffice/documentserver/logs:/var/log/onlyoffice
      - /volume1/docker/onlyoffice/documentserver/fonts:/usr/share/fonts/truetype/custom
      - /volume1/docker/onlyoffice/documentserver/forgotten:/var/lib/onlyoffice/documentserver/App_Data/cache/files/forgotten
  onlyoffice-mail-server:
    container_name: onlyoffice-mail-server
    image: onlyoffice/mailserver:1.6.74 #1.6.75 tried both
    depends_on:
      - onlyoffice-mysql-server
    hostname: houserofmanns.com
    environment:
      - MYSQL_SERVER=onlyoffice-mysql-server
      - MYSQL_SERVER_PORT=3306
      - MYSQL_ROOT_USER=mail_admin
      - MYSQL_ROOT_PASSWD=password
      - MYSQL_SERVER_DB_NAME=onlyoffice_mailserver
      - TZ=America/Chicago
    restart: always
    privileged: true
    ports:
      - 25:25
      - 143:143
      - 587:587
    stdin_open: true
    tty: true
    expose:
      - "8081"
      - "3306"
    volumes:
      - /volume1/docker/onlyoffice/mailserver/data:/var/vmail
      - /volume1/docker/onlyoffice/mailserver/certs:/etc/pki/tls/mailserver
      - /volume1/docker/onlyoffice/mailserver/log:/var/log
  onlyoffice-control-panel:
    container_name: onlyoffice-control-panel
    depends_on:
      - onlyoffice-document-server
      - onlyoffice-mail-server
      - onlyoffice-community-server
    image: onlyoffice/controlpanel:latest
    environment:
      - ONLYOFFICE_CORE_MACHINEKEY=openssl
    expose:
      - "80"
      - "443"
    restart: always
    volumes:
      - /var/run/docker.sock:/var/run/docker.sock
      - /volume1/docker/onlyoffice/controlpanel/data:/var/www/onlyoffice/Data
      - /volume1/docker/onlyoffice/controlpanel/log:/var/log/onlyoffice
    stdin_open: true
    tty: true
  onlyoffice-elasticsearch:
    # https://hub.docker.com/r/onlyoffice/elasticsearch/tags
    image: onlyoffice/elasticsearch:7.16.3
    container_name: onlyoffice-elasticsearch
    restart: always
    environment:
      - discovery.type=single-node
      - bootstrap.memory_lock=true
      - ES_JAVA_OPTS=-Xms1g -Xmx1g -Dlog4j2.formatMsgNoLookups=true
      - indices.fielddata.cache.size=30%
      - indices.memory.index_buffer_size=30%
      - ingest.geoip.downloader.enabled=false
    ulimits:
      memlock:
        soft: -1
        hard: -1
      nofile:
        soft: 65535
        hard: 65535
    volumes:
      - /volume1/docker/onlyoffice/elasticsearch/data:/usr/share/elasticsearch/data
    expose:
      - "9200"
      - "9300"
networks:
  onlyoffice:
    driver: bridge
#    driver_opts:
#      com.docker.network.enable_ipv6: "true"
    ipam:
      driver: default
      config:
      - subnet: ipv4
        gateway: ipv4
      - subnet: ipv6
        gateway: ipv6

Update:
So I used umask 022 which actually allowed for mysql to read the conf.d and the docker-endpoint folder. However there keeps being the following error.
346ef7a540b1.err
2024-07-30T23:23:27.226490Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-07-30T23:23:28.078347Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.0.1) starting as process 131
2024-07-30T23:23:29.166214Z 0 [Warning] [MY-000054] [Server] World-writable config file '/var/lib/mysql/auto.cnf' is ignored.
2024-07-30T23:23:29.166375Z 0 [Warning] [MY-010107] [Server] World-writable config file '/var/lib/mysql/auto.cnf' has been removed.
2024-07-30T23:23:29.167075Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: ba88e4d3-4eca-11ef-8a9e-0242c0a83003.
2024-07-30T23:23:30.155263Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-30T23:24:32.806798Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-30T23:25:13.987100Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-07-30T23:25:13.987149Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-07-30T23:25:14.139612Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-07-30T23:25:16.325069Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2024-07-30T23:25:16.325133Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '9.0.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server - GPL.

Community Server nginx error
2024/07/31 02:46:09 [crit] 5952#5952: *1807 connect() to unix:/var/run/onlyoffice/onlyoffice.socket failed (2: No such file or directory) while connecting to upstream, client: <IP_ADDRESS>, server: , request: "GET /TenantLogo.ashx?logotype=2&general=false HTTP/1.1", upstream: "fastcgi://unix:/var/run/onlyoffice/onlyoffice.socket:", host: "<IP_ADDRESS>:8500", referrer: "http://<IP_ADDRESS>:8500/"
2024/07/31 02:46:09 [crit] 5952#5952: *1807 connect() to unix:/var/run/onlyoffice/onlyoffice.socket failed (2: No such file or directory) while connecting to upstream, client: <IP_ADDRESS>, server: , request: "GET /TenantLogo.ashx?logotype=3 HTTP/1.1", upstream: "fastcgi://unix:/var/run/onlyoffice/onlyoffice.socket:", host: "<IP_ADDRESS>:8500", referrer: "http://<IP_ADDRESS>:8500/"

Community Server mailserver cleaner storage error log
2024-07-31 00:37:17,853 ERROR [41] ASC.Mail.Cleaner - Timer -> WorkTimerElapsed. Exception:
Autofac.Core.DependencyResolutionException: An exception was thrown while activating ASC.Mail.Core.Engine.MailboxEngine -> ASC.Core.TenantManager -> ASC.Core.Caching.CachedTenantService -> ASC.Core.Data.DbTenantService -> λ:Microsoft.EntityFrameworkCore.IDbContextFactory`1[[ASC.Core.Common.EF.Context.TenantDbContext, ASC.Core.Common, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=null]] -> Microsoft.EntityFrameworkCore.Internal.DbContextPool`1[[ASC.Core.Common.EF.Context.TenantDbContext, ASC.Core.Common, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=null]] -> λ:Microsoft.EntityFrameworkCore.DbContextOptions`1[[ASC.Core.Common.EF.Context.TenantDbContext, ASC.Core.Common, Version=<IP_ADDRESS>, Culture=neutral, PublicKeyToken=null]].
 ---> MySqlConnector.MySqlException (0x80004005): Access denied for user<EMAIL_ADDRESS>(using password: YES)
   at MySqlConnector.Core.ServerSession.SendEncryptedPasswordAsync(AuthenticationMethodSwitchRequestPayload switchRequest, String rsaPublicKey, String password, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 834
   at MySqlConnector.Core.ServerSession.SwitchAuthenticationAsync(ConnectionSettings cs, String password, PayloadData payload, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 747
   at MySqlConnector.Core.ServerSession.ConnectAsync(ConnectionSettings cs, MySqlConnection connection, Int32 startTickCount, ILoadBalancer loadBalancer, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 573
   at MySqlConnector.Core.ConnectionPool.ConnectSessionAsync(MySqlConnection connection, String logMessage, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 403
   at MySqlConnector.Core.ConnectionPool.ConnectSessionAsync(MySqlConnection connection, String logMessage, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 408
   at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 98
   at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 128
   at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int32 startTickCount, Activity activity, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 929
   at MySqlConnector.MySqlConnection.OpenAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 423
   at MySqlConnector.MySqlConnection.Open() in /_/src/MySqlConnector/MySqlConnection.cs:line 382
   at Microsoft.EntityFrameworkCore.ServerVersion.AutoDetect(String connectionString)
   at ASC.Core.Common.EF.InstallerOptionsAction.OptionsAction(IServiceProvider sp, DbContextOptionsBuilder optionsBuilder)
   at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.<>c__DisplayClass6_0`1.<AddPoolingOptions>b__0(IServiceProvider sp, DbContextOptionsBuilder ob)
   at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.CreateDbContextOptions[TContext](IServiceProvider applicationServiceProvider, Action`2 optionsAction)
   at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.<>c__DisplayClass17_0`1.<AddCoreServices>b__0(IServiceProvider p)
   at Autofac.Extensions.DependencyInjection.AutofacRegistration.<>c__DisplayClass3_0.<Register>b__0(IComponentContext context, IEnumerable`1 parameters)
   at Autofac.Core.Activators.Delegate.DelegateActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)
   at Autofac.Core.Activators.Delegate.DelegateActivator.<ConfigurePipeline>b__2_0(ResolveRequestContext ctxt, Action`1 next)
   at Autofac.Core.Resolving.Middleware.DisposalTrackingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
   at Autofac.Core.Resolving.Middleware.ActivatorErrorHandlingMiddleware.Execute(ResolveRequestContext context, Action`1 next)

Hello @Dvalin21 We recommend using version 8.0.29 of the mysql docker container. We do not guarantee stable operation of Workspace with other versions. In the next releases, we will update the supported version of mysql for docker.

Hello @Dvalin21 We recommend using version 8.0.29 of the mysql docker container. We do not guarantee stable operation of Workspace with other versions. In the next releases, we will update the supported version of mysql for docker.

Thanks for your response. I did discover that 8.0.29 is the only one that works. So this part is fixed for me. The only thing now is trying to get communityserver from failing. Which version do you recommend using?

Update: Switched community server to <IP_ADDRESS>8. Its still doing the same as the latest version. It keeps failing the mailwatchdog and the other. Also, getting a access denied when trying to connect to the database user with mysql
2024/07/31 02:25:07	stdout	ERROR 1045 (28000): Access denied for user<EMAIL_ADDRESS>(using password: YES)
2024/07/31 02:25:07	stdout	mysql: [Warning] Using a password on the command line interface can be insecure.
2024/07/31 02:25:07	stdout	++ mysql --silent --skip-column-names -h onlyoffice-mysql-server -P 3306 -u onlyoffice_user '--password=password' -D onlyoffice -e 'TRUNCATE webstudio_index'
2024/07/31 02:25:07	stdout	+ '[' '' == opt_ignore_db_name ']'

Hello @Dvalin21 We recommend using version 8.0.29 of the mysql docker container. We do not guarantee stable operation of Workspace with other versions. In the next releases, we will update the supported version of mysql for docker.

So I got it all to install and work. Ill share my docker-compose, but why is a lic file still required for the community edition?
version: "3"
services:
  onlyoffice-mysql-server:
    container_name: onlyoffice-mysql-server
    networks:
      onlyoffice:
        ipv4_address: <IP_ADDRESS>
    image: mysql:8.0.29
    environment:
      - MYSQL_ROOT_PASSWORD=
      - TZ=America/Chicago
      - UMASK=022
#      - UMASK_DIR=755
    stdin_open: true
    tty: true
    restart: always
    privileged: true
    expose:
      - "3306"
      - "33060"
    volumes:
      - /volume1/docker/onlyoffice/mysql/conf.d:/etc/mysql/conf.d
      - /volume1/docker/onlyoffice/mysql/docker-entrypoint-initdb.d:/docker-entrypoint-initdb.d
      - /volume1/docker/onlyoffice/mysql/data:/var/lib/mysql

  onlyoffice-community-server:
    container_name: onlyoffice-community-server
    networks:
      onlyoffice:
        ipv4_address: <IP_ADDRESS>
    image: onlyoffice/communityserver:<IP_ADDRESS>8
    depends_on:
      - onlyoffice-mysql-server
      - onlyoffice-document-server
      - onlyoffice-mail-server
      - onlyoffice-elasticsearch
    environment:
      - ONLYOFFICE_CORE_MACHINEKEY=
      - TZ=America/Chicago
      - CONTROL_PANEL_PORT_80_TCP=80
      - CONTROL_PANEL_PORT_80_TCP_ADDR=onlyoffice-control-panel
      - DOCUMENT_SERVER_PORT_80_TCP_ADDR=onlyoffice-document-server
      - DOCUMENT_SERVER_JWT_ENABLED=true
      - DOCUMENT_SERVER_JWT_SECRET=
      - DOCUMENT_SERVER_JWT_HEADER=AuthorizationJwt
      - MYSQL_SERVER_ROOT_PASSWORD=
      - MYSQL_SERVER_DB_NAME=onlyoffice
      - MYSQL_SERVER_HOST=onlyoffice-mysql-server
      - MYSQL_SERVER_USER=onlyoffice_user
      - MYSQL_SERVER_PASS=onlyoffice_pass
      - MAIL_SERVER_API_PORT=8081
      - MAIL_SERVER_API_HOST=onlyoffice-mail-server
      - MAIL_SERVER_DB_HOST=onlyoffice-mysql-server
      - MAIL_SERVER_DB_PORT=3306
      - MAIL_SERVER_DB_NAME=onlyoffice_mailserver
      - MAIL_SERVER_DB_USER=mail_admin
      - MAIL_SERVER_DB_PASS=Isadmin123
      - ELASTICSEARCH_SERVER_HOST=onlyoffice-elasticsearch
      - ELASTICSEARCH_SERVER_HTTPPORT=9200
    ports:
      - 8500:80
      - 5222:5222
      - 9443:443
    expose:
      - "9865"
      - "9888"
      - "9866"
      - "9871"
      - "9882"
      - "5280"
    stdin_open: true
    tty: true
    restart: always
    privileged: true
    #    cgroup: host
    volumes:
      - /volume1/docker/onlyoffice/communityserver/data:/var/www/onlyoffice/Data
      - /volume1/docker/onlyoffice/communityserver/logs:/var/log/onlyoffice
      - /volume1/docker/onlyoffice/communityserver/letsencrypt:/etc/letsencrypt
      - /volume1/docker/onlyoffice/documentserver/data:/var/www/onlyoffice/DocumentServerData
      - /sys/fs/cgroup:/sys/fs/cgroup:rw
      - /volume1/docker/onlyoffice/communityserver/certs:/var/www/onlyoffice/Data/certs

  onlyoffice-document-server:
    container_name: onlyoffice-document-server
    networks:
      onlyoffice:
        ipv4_address: <IP_ADDRESS>
    image: onlyoffice/documentserver-ee:latest
    stdin_open: true
    tty: true
    restart: always
    environment:
      - JWT_ENABLED=true
      - JWT_SECRET=TGCrx6eUsG2Ww45RLwpRLFKvDiYbeDjL
      - JWT_HEADER=AuthorizationJwt
      - TZ=America/Chicago
    expose:
      - "80"
      - "443"
    volumes:
      - /volume1/docker/onlyoffice/documentserver/data:/var/www/onlyoffice/Data
      - /volume1/docker/onlyoffice/documentserver/logs:/var/log/onlyoffice
      - /volume1/docker/onlyoffice/documentserver/fonts:/usr/share/fonts/truetype/custom
      - /volume1/docker/onlyoffice/documentserver/forgotten:/var/lib/onlyoffice/documentserver/App_Data/cache/files/forgotten

  onlyoffice-mail-server:
    container_name: onlyoffice-mail-server
    networks:
      onlyoffice:
        ipv4_address: <IP_ADDRESS>
        ipv6_address: 2600:1700:b730::5
    image: onlyoffice/mailserver:1.6.75
    depends_on:
      - onlyoffice-mysql-server
    hostname: houserofmanns.com
    environment:
      - MYSQL_SERVER=onlyoffice-mysql-server
      - MYSQL_SERVER_PORT=3306
      - MYSQL_ROOT_USER=mail_admin
      - MYSQL_ROOT_PASSWD=Isadmin123
      - MYSQL_SERVER_DB_NAME=onlyoffice_mailserver
      - TZ=America/Chicago
    restart: always
    privileged: true
    ports:
      - 25:25
      - 143:143
      - 587:587
    stdin_open: true
    tty: true
    expose:
      - "8081"
      - "3306"
    volumes:
      - /volume1/docker/onlyoffice/mailserver/data:/var/vmail
      - /volume1/docker/onlyoffice/mailserver/certs:/etc/pki/tls/mailserver
      - /volume1/docker/onlyoffice/mailserver/log:/var/log

  onlyoffice-control-panel:
    container_name: onlyoffice-control-panel
    networks:
      onlyoffice:
        ipv4_address: <IP_ADDRESS>
    depends_on:
      - onlyoffice-document-server
      - onlyoffice-mail-server
      - onlyoffice-community-server
    image: onlyoffice/controlpanel:latest
    environment:
      - ONLYOFFICE_CORE_MACHINEKEY=
    expose:
      - "80"
      - "443"
    restart: always
    volumes:
      - /var/run/docker.sock:/var/run/docker.sock
      - /volume1/docker/onlyoffice/controlpanel/data:/var/www/onlyoffice/Data
      - /volume1/docker/onlyoffice/controlpanel/log:/var/log/onlyoffice
    stdin_open: true
    tty: true

  onlyoffice-elasticsearch:
    # https://hub.docker.com/r/onlyoffice/elasticsearch/tags
    image: onlyoffice/elasticsearch:7.16.3
    container_name: onlyoffice-elasticsearch
    networks:
      onlyoffice:
        ipv4_address: <IP_ADDRESS>
    restart: always
    environment:
      - discovery.type=single-node
      - bootstrap.memory_lock=true
      - ES_JAVA_OPTS=-Xms1g -Xmx1g -Dlog4j2.formatMsgNoLookups=true
      - indices.fielddata.cache.size=30%
      - indices.memory.index_buffer_size=30%
      - ingest.geoip.downloader.enabled=false
    ulimits:
      memlock:
        soft: -1
        hard: -1
      nofile:
        soft: 65535
        hard: 65535
    volumes:
      - /volume1/docker/onlyoffice/elasticsearch/data:/usr/share/elasticsearch/data
    expose:
      - "9200"
      - "9300"
networks:
  onlyoffice:
    driver: bridge
    driver_opts:
      com.docker.network.enable_ipv6: "true"
    ipam:
      driver: default
      config:
      - subnet: <IP_ADDRESS>/24
        gateway: <IP_ADDRESS>
      - subnet:
        gateway:

lic file still required for the community edition

For the community edition of Workspace, you should use image: onlyoffice/documentserver:latest

lic file still required for the community edition

For the community edition of Workspace, you should use image: onlyoffice/documentserver:latest

So I would still be able to use mailserver as well correct?

So I would still be able to use mailserver as well correct?

Yes, MailServer is free and is part of Workspace CE.

So I would still be able to use mailserver as well correct?

Yes, MailServer is free and is part of Workspace CE.

Thanks!! Switching it out right now

So I would still be able to use mailserver as well correct?

Yes, MailServer is free and is part of Workspace CE.

Score!! Workspace CE is running on Synology NAS, HOWEVER, it took an entire 1hr 42 minutes from clicking build to the point of logging in. Not sure if that is a product of Synology NAS. I will say I'm using their new beta of docker as well.


Replace "Save As" by Rename

Currently we do use two different "Save As" features. The other one is named export.
Export can use different functions for same extension while "Save As" can only use one extension per function.
If there are several csv plugins "Save As" can only use one.  "Save As" also renames the  active local flight path.
We should simplify this, Rename should replace "Save As" and could be used to rename any active flight path.
All other file exchange functionality should go to "Import" / "Export".
The creation of an operation should use the same Import definition as for Import in the menu. We need to replace the simplified file browse functionality by select first the import function then choose a file. By this also the extension is not a master key.

I reject this idea, rename have to be different implemented, when wanted.. This feature is needed as it is.


Update Install-PowerShell.ps1 add hash validation and default temp file clean up

The file SHA256 hashes appear to be provided in the release notes on the version tag. Added a process to use a regular expression that pulls out the expected hash value  for the file from the website and compares that to a calculated hash of the file.
The two hashes should match, and if they don't then it's likely that the file has been corrupted.
Also it's a bit of a breaking change, but cleaned up the file in the temp folder once it has been installed. If this is not desired it can be removed, or the caller can also use the new -KeepDownload option as well.

🙄 the static code "Analysis" could be better; I'm not going to fix that since it matches style with the original.


web hooks notifications to MIS

As a MIS
I want to get web hook calls about the async processes completion
so that I can get ID of the created entity

[ ] design solution #279

[ ] employee_request

[ ] declaration request

@pzhuk Please add a list of use cases when web hooks should be sent

Capitation:

employee_request - status change (employee_id towards all MIS?)
declaration - status change (declaration_id towards all MIS?)
employee - status change (employee_id towards all MIS?)

Reimbursement:

medication dispense (all MIS again?)

I really think we should organize it via some kind of endpoint which emulates subscription-based queue of different event types

Events to be handled:

declaration status change
medication request status change

Each status change should publish event to a corresponding eventlog table

Additional endpoint should be added for fetching events.
Endpoint should support offset filtering (i.e. give me events happened after specific timestamp) filtering
Endpoint should support filtering by object id
Endpoint should support filtering by event type OR different eventpoints could be provided for different even types

Event tables cleanup should be configurable and support cleanup by 2 types of events

event age (i.e. delete events older than <event_max_age>)
event count (delete old events, if amount of events in the eventlog is large than <event_max_amount>

Event manager was done. It works on all environments.


Need to update rack configuration from 2.2.3 to <IP_ADDRESS>

Defectdojo found critical vulnerabilities

OmniAuth does not specify a specific version of rack, only greater than a certain version. Update rack to whatever version you want.
spec.add_dependency 'rack', '>= 2.2.3'


[FEATURE] Storage network support for Multus v4.0 thick-plugin

Is your feature request related to a problem? Please describe (👍 if you like this request)
Longhorn storage network doesn't work with Multus 4.0 thick-plugin base on the feedback.
Describe the solution you'd like
Support Multus 4.0 thick plugin.
Describe alternatives you've considered
None
Additional context
https://github.com/longhorn/longhorn/issues/4937

The thick plugin introduced a server/client architecture, metrics for tracking requested counts, and support for multus-dynamic-network-controller (hot-plug). I don't see anything that is blocking.

Moving the milestone to v1.6.0. cc @innobead

Hi @c3y1huang ,
By test steps, I can not use storagenetwork with multus thick plugin, the multus pod kept loop in Runing -> CrashLoopBackOff, could you help me on this if I did something wrong? thank you.
My environment

OS : Ubuntu 20.04
Kubernetes : v1.28.2+k3s1

Below are some information

Instance manager annotaion

Annotations:      k8s.v1.cni.cncf.io/networks: [{"namespace": "kube-system", "name": "demo-192-168-0-0", "interface": "lhnet1"}]
                  longhorn.io/last-applied-tolerations: []
                  longhorn.io/v2-data-engine: false

Instance manager event

Warning  FailedCreatePodSandBox  3m44s               kubelet  Failed to create pod sandbox: rpc error: code = Unknown desc = failed to setup network for sandbox "0e152f70adbd9cf51fd84cee7e4875803f73aa08457d5a7d2d42cc3f3bcca68d": plugin type="multus" failed (add): Multus: [longhorn-system/instance-manager-b1982f961c17f5513fad4f9404ea7e02/d50e2d8b-1f5f-4a84-9208-de1a40ddec15]: error getting pod: Unauthorized

multus pod event

Events:
 Type     Reason     Age                  From               Message
 ----     ------     ----                 ----               -------
 Normal   Scheduled  29m                  default-scheduler  Successfully assigned kube-system/kube-multus-ds-g52cj to ip-10-0-1-175
 Normal   Pulled     29m                  kubelet            Container image "ghcr.io/k8snetworkplumbingwg/multus-cni:v4.0.2-thick" already present on machine
 Normal   Created    29m                  kubelet            Created container install-multus-binary
 Normal   Started    29m                  kubelet            Started container install-multus-binary
 Normal   Pulled     20m (x5 over 29m)    kubelet            Container image "ghcr.io/k8snetworkplumbingwg/multus-cni:v4.0.2-thick" already present on machine
 Normal   Created    20m (x5 over 29m)    kubelet            Created container kube-multus
 Normal   Started    20m (x5 over 29m)    kubelet            Started container kube-multus
 Warning  BackOff    3m2s (x51 over 25m)  kubelet            Back-off restarting failed container kube-multus in pod kube-multus-ds-g52cj_kube-system(2a3a8876-136e-4077-a9c8-ea183a4a45f5)

local symbolic link

root@ip-10-0-1-91:/home/ubuntu# ls -ls /etc/cni
0 lrwxrwxrwx 1 root root 40 Nov 29 06:39 /etc/cni -> /var/lib/rancher/k3s/agent/etc/cni/net.d
root@ip-10-0-1-91:/home/ubuntu# ls -ls /opt/cni
0 lrwxrwxrwx 1 root root 37 Nov 29 06:39 /opt/cni -> /var/lib/rancher/k3s/data/current/bin

supportbundle_7ec9be4f-25aa-49d9-bff4-38c5e3756489_2023-11-29T08-02-22Z.zip

But on the same environment, I can see below annotation in instance-manager pod when set storage network with Multus thin plugin

Annotation
Annotations:      k8s.v1.cni.cncf.io/network-status:
                  [{
                      "name": "cbr0",
                      "interface": "eth0",
                      "ips": [
                          "<IP_ADDRESS>"
                      ],
                      "mac": "42:cc:a5:44:0d:41",
                      "default": true,
                      "dns": {},
                      "gateway": [
                          "<IP_ADDRESS>"
                      ]
                  },{
                      "name": "kube-system/demo-192-168-0-0",
                      "interface": "lhnet1",
                      "ips": [
                          "<IP_ADDRESS>"
                      ],
                      "mac": "06:0b:c4:40:19:59",
                      "dns": {}
                  }]
                k8s.v1.cni.cncf.io/networks: [{"namespace": "kube-system", "name": "demo-192-168-0-0", "interface": "lhnet1"}]

the multus pod kept loop in Runing -> CrashLoopBackOff

We need to figure out why mutlus pod is in crash loop. Let's discuss this offline.

Verified pass on longhorn master (longhorn bcd399) with test steps
instance-manager pod  annotation
Annotations:      k8s.v1.cni.cncf.io/network-status:
                    [{
                        "name": "cbr0",
                        "interface": "eth0",
                        "ips": [
                            "<IP_ADDRESS>"
                        ],
                        "mac": "da:ab:c6:3d:6c:f6",
                        "default": true,
                        "dns": {},
                        "gateway": [
                            "<IP_ADDRESS>"
                        ]
                    },{
                        "name": "kube-system/demo-192-168-0-0",
                        "interface": "lhnet1",
                        "ips": [
                            "<IP_ADDRESS>"
                        ],
                        "mac": "06:7c:1a:c7:45:9f",
                        "dns": {}
                    }]
                  k8s.v1.cni.cncf.io/networks: [{"namespace": "kube-system", "name": "demo-192-168-0-0", "interface": "lhnet1"}]

Engine storage IP is 192.168.1.x
root@ip-10-0-1-108:/home/ubuntu# k get engine pvc-48d097cb-ba15-4591-86d1-2c1a189fa201-e-0 -n longhorn-system -o yaml | grep storage
  storageIP: <IP_ADDRESS>

Replica storage IP is 192.168.1.x
root@ip-10-0-1-108:/home/ubuntu# k get replica pvc-48d097cb-ba15-4591-86d1-2c1a189fa201-r-f0093f1a -n longhorn-system -o yaml | grep storage
  storageIP: <IP_ADDRESS>


Spotify integration

Describe the bug
Once I put in the spotify client ID and secret, gives me error. See screenshot.
Checked common issues

[ ] Unblocked the files. (Windows blocks files when installing / upgrading for some people)
[ ] Double checked audio source specific issues (for audio source related issues)

To Reproduce
Steps to reproduce the behavior:

Open Audio Band settings
Go to Spotify (in the settings).
Create spotify client ID and secret on the spotify website.
Fill inn spotify ID and secret in the Spotify settings of Audio band.
Hit Apply.
Get error when Spotify wants to authorize the app.

Expected behavior
Expected Audio Band to get info from Spotify about the current playing song, and let it control the music with the buttons.
Screenshots
https://i.imgur.com/B3oqJ9H.jpg
Version Info
Microsoft Windows [Version 10.0.18363.752]
AudioBand-v0.9.4
Logs attachment
2020-04-04 02:50:09.4398|INFO|AudioBand|Starting AudioBand. Version: "v0.9.4", OS: Microsoft Windows NT 10.0.18363.0
2020-04-04 02:50:11.9525|DEBUG|AudioBand.UI.AudioBandToolbarViewModel|Loading audio sources
2020-04-04 02:50:11.9525|DEBUG|AudioBand.AudioSource.AudioSourceManager|Loading audio sources in "C:\Program Files\AudioBand\AudioSources"
2020-04-04 02:50:12.5436|DEBUG|AudioSourceWrapper(spotify)|Initializing wrapper
2020-04-04 02:50:12.6160|DEBUG|AudioSourceHost.AudioSourceLoader|Probing path "C:\Program Files\AudioBand\AudioSources\spotify" for audio source
2020-04-04 02:50:12.8103|DEBUG|AudioSourceHost.AudioSourceLoader|Loading audio source from path "C:\Program Files\AudioBand\AudioSources\spotify\SpotifyAudioSource.dll"
2020-04-04 02:50:13.0827|DEBUG|AudioSourceWrapper(spotify)|Wrapper initialization complete
2020-04-04 02:50:13.1621|DEBUG|AudioBand.UI.AudioBandToolbarViewModel|Activating new audio source "Spotify"
2020-04-04 02:50:13.1701|DEBUG|AudioBand.UI.AudioBandToolbarViewModel|Audio sources loaded. Loaded 1 sources
2020-04-04 12:32:23.8293|DEBUG|AudioBand.UI.TemplateSelectors.AudioSourceSettingSelector|Selecting value template for setting "Spotify Client ID", type System.String
2020-04-04 12:32:23.8435|DEBUG|AudioBand.UI.TemplateSelectors.AudioSourceSettingSelector|Selecting value template for setting "Spotify Client secret", type System.String
2020-04-04 12:32:23.8435|DEBUG|AudioBand.UI.TemplateSelectors.AudioSourceSettingSelector|Selecting value template for setting "Callback Port", type System.UInt32
2020-04-04 12:32:23.8575|DEBUG|AudioBand.UI.AudioSourceSettingKeyValue|Starting edit
2020-04-04 12:32:23.8575|DEBUG|AudioBand.UI.AudioSourceSettingsCollectionViewModel|Starting edit
2020-04-04 12:32:23.8704|DEBUG|AudioBand.UI.TemplateSelectors.AudioSourceSettingSelector|Selecting value template for setting "Proxy Host", type System.String
2020-04-04 12:32:23.8704|DEBUG|AudioBand.UI.TemplateSelectors.AudioSourceSettingSelector|Selecting value template for setting "Proxy Password", type System.String
2020-04-04 12:32:23.8904|DEBUG|AudioBand.UI.TemplateSelectors.AudioSourceSettingSelector|Selecting value template for setting "Proxy Port", type System.UInt32
2020-04-04 12:32:23.8904|DEBUG|AudioBand.UI.AudioSourceSettingKeyValue|Starting edit
2020-04-04 12:32:23.9014|DEBUG|AudioBand.UI.TemplateSelectors.AudioSourceSettingSelector|Selecting value template for setting "Proxy Username", type System.String
2020-04-04 12:32:23.9014|DEBUG|AudioBand.UI.TemplateSelectors.AudioSourceSettingSelector|Selecting value template for setting "Use Proxy", type System.Boolean
2020-04-04 12:33:22.5441|DEBUG|AudioBand.UI.AudioSourceSettingKeyValue|Starting edit
2020-04-04 12:33:24.0749|DEBUG|AudioBand.UI.AudioSourceSettingKeyValue|Starting edit
2020-04-04 12:33:24.1915|DEBUG|AudioBand.UI.AudioSourceSettingsCollectionViewModel|Ending edit
2020-04-04 12:33:24.1915|DEBUG|AudioBand.UI.AudioSourceSettingKeyValue|Ending edit
2020-04-04 12:33:24.1915|DEBUG|AudioBand.UI.AudioSourceSettingKeyValue|Ending edit
2020-04-04 12:33:24.1915|DEBUG|AudioBand.UI.AudioSourceSettingKeyValue|Ending edit
2020-04-04 12:33:24.1915|DEBUG|AudioBand.UI.AudioSourceSettingKeyValue|Ending edit
2020-04-04 12:33:24.1935|DEBUG|AudioSource(Spotify)|Connecting to spotify
2020-04-04 12:34:45.7867|WARN|AudioSource(Spotify)|Error with player command [SetRepeatModeAsync]: Code = '400', Message = 'Only valid bearer authentication supported'
2020-04-04 12:34:46.7612|WARN|AudioSource(Spotify)|Error with player command [SetRepeatModeAsync]: Code = '400', Message = 'Only valid bearer authentication supported'
2020-04-04 12:34:48.0220|WARN|AudioSource(Spotify)|Error with player command [SetShuffleAsync]: Code = '400', Message = 'Only valid bearer authentication supported'
2020-04-04 12:34:48.7193|WARN|AudioSource(Spotify)|Error with player command [SetShuffleAsync]: Code = '400', Message = 'Only valid bearer authentication supported'
2020-04-04 12:34:57.7525|INFO|AudioBand|Starting AudioBand. Version: "v0.9.4", OS: Microsoft Windows NT 10.0.18363.0
2020-04-04 12:34:57.9782|DEBUG|AudioBand.UI.AudioBandToolbarViewModel|Loading audio sources
2020-04-04 12:34:57.9782|DEBUG|AudioBand.AudioSource.AudioSourceManager|Loading audio sources in "C:\Program Files\AudioBand\AudioSources"
2020-04-04 12:34:58.3190|DEBUG|AudioSourceWrapper(spotify)|Initializing wrapper
2020-04-04 12:34:58.3839|DEBUG|AudioSourceHost.AudioSourceLoader|Probing path "C:\Program Files\AudioBand\AudioSources\spotify" for audio source
2020-04-04 12:34:58.5570|DEBUG|AudioSourceHost.AudioSourceLoader|Loading audio source from path "C:\Program Files\AudioBand\AudioSources\spotify\SpotifyAudioSource.dll"
2020-04-04 12:34:58.7114|DEBUG|AudioSourceWrapper(spotify)|Wrapper initialization complete
2020-04-04 12:34:58.7471|DEBUG|AudioBand.UI.AudioBandToolbarViewModel|Activating new audio source "Spotify"
2020-04-04 12:34:58.7491|DEBUG|AudioSource(Spotify)|Connecting to spotify
2020-04-04 12:34:58.8844|DEBUG|AudioBand.UI.AudioBandToolbarViewModel|Audio sources loaded. Loaded 1 sources
Additional context
Link of the URL it tries to authorize with(without the ID):
https://accounts.spotify.com/authorize/?client_id=(spotify client ID here)&response_type=code&redirect_uri=http://localhost:80&state=2bf31225&scope=user-read-playback-state%20user-modify-playback-state%20user-read-currently-playing&show_dialog=False

Also tried adding this URL into "Redirect URIs" on the App-page on Spotify Development page.

Added http://localhost:80 there, and it seem to work. It will now only open the developer page whenever I disable/enable the widget. But it still doesn't work. And I wasn't told there would be this much to set up!

Again I've followed this:

Today it suddenly started working for some reason. I didn't even have Spotify on my PC opened at the time, just on my phone. So the buttons didn't work, but now when Spotify is opened it does work, excellent.


add error offsets to DetailedError

sqlite3_error_offset API introduced on 3.38.0:

Added the sqlite3_error_offset() interface, which can sometimes help to localize an SQL error to a specific character in the input SQL text, so that applications can provide better error messages.

Hm. CI's failing because it's using the system sqlite library, which means it fails on ubuntu who hasn't updated to 3.38, yet it works fine on my Void machine... what should be the best course of action here?

I don't think we can require a version that recent yet (Debian Bullseye is shipping 3.34.1, Fedora 35 is shipping 3.36.0).
But I think you can simply add a comptime check using the SQLITE_VERSION_NUMBER constant.
Something like this:
fn getErrorOffset(db: *c.sqlite3) i32 {
    if (comptime c.SQLITE_VERSION_NUMBER >= 3038000) {
        return c.sqlite3_error_offset(db);
    }
    return -1;
}

and then call that instead of sqlite3_error_offset.
but actually there was another problem that I just fixed in #83.
In the build.zig file we used to always add the c directory to the include directories, but this would result in the comptime check passing (because we include the 3.38.0 version) even though the system library is not always 3.38.0.
If you rebase on master the CI should fail while compiling, not linking.

Thanks !


Is this still up to date?

I don't see recommendations regarding north south segmentation with ASG's or anything about Azure Firewall. Are the recommendations above still considered best practice?

Document Details
⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

ID: a1856224-8709-d6db-c533-50e5e05f2091
Version Independent ID: f4f18c8f-c849-6da6-e0ab-a52c6eeec07a
Content: Azure Network Security Best Practices
Content Source: articles/security/azure-security-network-security-best-practices.md
Service: security
GitHub Login: @TomShinder
Microsoft Alias: TomSh

@dave-ch Thanks for your feedback! We will investigate and update soon on it.

@dave-ch Thanks for reaching out! I have assigned the issue to the content author to investigate and update as appropriate.

Just wanted to ping this. Is there any plan to review this and determine if an update is needed?

Thanks for your dedication to our documentation. Unfortunately, at this time we have been unable to review your issue in a timely manner and we sincerely apologize for the delayed response. The requested updates have not been made since the creation of this issue, and the timeline for resolution may vary based on resourcing, so we've created an internal work item to incorporate your suggestions. We are closing this issue for now, but feel free to comment here as necessary.
#please-close


fix: clarify --path is the installation source not destination

What does this PR try to resolve?
There is a misunderstanding of “default location” mentioned in cargo install --help.
I don't think one-line explanation helps much there, So remove that imprecise description.
This PR also add more "from" for places mentioning installation sources.
How should we test and review this PR?
Read the new help text.

Additional information
Fixes #13200

Thank you all :)
@bors r=hi-rustin

:pushpin: Commit eb8870f098a68640fc64a054c27589bf8db18b41 has been approved by hi-rustin
It is now in the queue for this repository.

:hourglass: Testing commit eb8870f098a68640fc64a054c27589bf8db18b41 with merge 308ceee7fa8ce8abc6b3b174e034199f6c17a995...

:sunny: Test successful - checks-actions
Approved by: hi-rustin
Pushing 308ceee7fa8ce8abc6b3b174e034199f6c17a995 to master...


Add convert-to-timezone tag for AsOfAttributes. Fixes #26.

Hi,
I just saw these changes come in. I tried them out and I still seem to have the same issue. I still think it is odd that only two of the times have changed. See the images below.

I've just had a thought.
I wonder if the TimeZone.inDaylightTime has the knowledge of historic daylight savings. Here in Queensland we no longer have Daylight Savings. However we did have and it would not always have been as it is a more recent idea.
The Times back in the 1960's are coming through fine. The times in the 2000's are fine it is the dates in the 1990's that are 1 hour adjusted which when I was a kid did have daylight savings.
I shall look at when Daylight Savings here in Queensland Australia come in to effect and ended to see if that matches up.

@nikhilnanivadekar
Can you try Brisbane, Australia?
Mine still doesn't work and I have done a clean and install.
In my timezone if I insert '1990-01-01 06:00:00.000' be it currently daylight savings or not I would expect to get '1990-01-01 06:00:00.000' back when I query.  Currently this is not happening for me.
Currently for me the debug log is telling me that I am inserting '1990-01-01 05:00:00.000' which is not what is in the data_tasks.txt file.


[Question] Train on 2D medical images

:question: Question
Hi!
Is it worth to try experimenting with the nnDetection framework on 2D medical images, or is it designed (as the description says) solely for "3D (volumetric) medical object detection"?

2D support would be of interest to me as well.
I have previously experimented with RetinaNets, YOLO networks, and Faster R-CNN.
Testing your design is the next step for me, to properly benchmark our designs which we have tuned ourselves.

how to initialize the model？ I didn't find any tips

2D support would be of interest to me as well.
I have previously experimented with RetinaNets, YOLO networks, and Faster R-CNN.
Testing your design is the next step for me, to properly benchmark our designs which we have tuned ourselves.
Found this rather late... I had spent quite some time getting this to install on colab with pip (working now though). Should've checked issues earlier...
Hey, did you install this wihour using docker?
can you help me?


R8 on Android with Ktor3 & Ksoup

I've just tried to update my apps to the ksoup variant with ktor3 since ktor3 is now stable. When trying to build my Android app I've gotten the following:
ERROR: R8: Missing class io.ktor.utils.io.core.ByteReadPacket (referenced from: int com.fleeksoft.ksoup.io.CharsetImpl.decode(java.lang.StringBuilder, byte[], int, int))
Missing class io.ktor.utils.io.core.ByteReadPacketExtensionsKt (referenced from: int com.fleeksoft.ksoup.io.CharsetImpl.decode(java.lang.StringBuilder, byte[], int, int))
Missing class io.ktor.utils.io.core.Input (referenced from: int com.fleeksoft.ksoup.io.CharsetImpl.decode(java.lang.StringBuilder, byte[], int, int))

Does Ksoup require proguard rules with ktor3? This never happened with the ktor2 variant of ksoup.

@vanniktech I think somehow these references are from an older version of Ktor 2. Can you please make sure your project doesn’t have any Ktor 2 dependencies and that you are using ksoup dependencies without Ktor 2 for both ksoup and ksoup-network?

Nope. I'm all ktor3

I tried, but I can’t reproduce this issue. Could you provide minimal sample code to reproduce this issue?

Weird. I've tried again, but this time I did a gradle clean and now it works.

First of all, I mixed up my project. I use it in two of my apps. Same repository. I know what the problem is. It is ksoup itself.

So the okio module that you have is using ktor2, but in my app I'm already using ktor3, therefore it is being upgraded and then it rightfully complains.
So to fix this, either the ksoup-okio needs to be free from ktor dependencies or there need to be 2 different modules, once for ktor2 and one for ktor3.

Yes, I have published one called ksoup-okio-ktor3, which you can use. However, in the upcoming version, I have already removed the Ktor dependency from the core, and in the future, it will consist of simpler and more extensible modules

Amazing, that worked!


Incorrect indentation when the type of a function is on the next line

pub fn point_is_empty(&self, tile_map_pos: Point<isize>,
                      point: Point<f32>) -> bool {
    | correctly indents to this point

while
pub fn point_is_empty(&self, tile_map_pos: Point<isize>, point: Point<f32>)
		              -> bool {
                                  | incorrectly indents to this point

I think this is a duplicate of #8 and maybe related to #10. I sympathize though; this is easily the most annoying bug in rust-mode.

Yes, okay. I am going to friggin' fix this, if I can at all help it.


Cache a ghc session per file of interest

I recently discovered that the .hi files PR had regressed the performance of GetSpanInfo quite noticeably. This is due mostly to a change in the extraction of spanInfoDocs. Prior to the interfaces change, these were mined out of parsed ASTs. .hi files don't come with ASTs but instead bundle the haddocks for identifiers. But to be able to use them, we need to:

set up a GHC session with all the transitive .hi files
rely on getDocs to extract them

Step 1 can be sped up easily by caching a GHC session per module for files of interest, which makes GetSpanInfo as speedy as it used to be, as seen in the "hover after edit" experiment.  I was hoping it would also speed up typechecking, but the edit experiment suggests otherwise so I might have missed something.
Benchmark results (hover becomes much faster, all else stays the same):
version              name                         success   samples   startup              setup                 experiment            maxResidency
upstream             hover                        True      100       7.567142767000001    0.0                   0.479372591           218MB
upstream             edit                         True      100       7.953766959          0.0                   25.364602476          217MB
upstream             getDefinition                True      100       8.692988179          0.0                   0.46926602100000003   219MB
upstream             hover after edit             True      100       8.31115918           0.0                   66.021477715          237MB
upstream             completions after edit       True      100       9.410036817          0.0                   33.817070408          222MB
upstream             code actions                 True      100       10.039016802         0.44827246800000004   0.576492419           242MB
upstream             code actions after edit      False     100       7.954712423          0.0                   1.5715171460000001    245MB
upstream             documentSymbols after edit   True      100       9.284543272          0.0                   1.883872325           218MB
module-ghc-session   hover                        True      100       7.223818533          0.0                   0.13876206500000002   228MB
module-ghc-session   edit                         True      100       7.344935921          0.0                   24.669866416          219MB
module-ghc-session   getDefinition                True      100       7.237144228          0.0                   0.119550469           216MB
module-ghc-session   hover after edit             True      100       7.276310433000001    0.0                   29.694541188000002    218MB
module-ghc-session   completions after edit       True      100       7.3100683150000005   0.0                   30.394427346          222MB
module-ghc-session   code actions                 True      100       7.236867787          0.304327993           0.407078469           243MB
module-ghc-session   code actions after edit      False     100       7.397161018          0.0                   0.445487738           242MB
module-ghc-session   documentSymbols after edit   True      100       7.867092457000001    0.0                   1.7937549000000002    216MB

Unfortunately github doesn't allow SVG attachments in PRs, so I have uploaded the benchmarks here: https://github.com/pepeiborra/ghcide/tree/module-ghc-session-benchmarks/bench-hist/module-ghc-session
!(hover after edit)[https://raw.githubusercontent.com/pepeiborra/ghcide/module-ghc-session-benchmarks/bench-hist/module-ghc-session/hover_after_edit.diff.svg]

Early cut-off for the GetModSummary rule, to bypass work when a module imports & pragmas haven't changed,e.g. GetDependencies, GetDependencyInformation, GetLocatedImports, etc.
This results in further perf improvements for hover after edit and for edit.

Windows 10 build is failing as usual, please retry


feat(stats): implement is.css

Summary
This PR implements:

[x] is.css for the widget stats.
[x] removes the panel from the widget.
[x] move the data computation into the widget.

Specification
Result
Story

\o/


[BEAM-14483] Adds Java cross-language transforms for invoking Python Map and FlatMap

Please add a meaningful description for your change here

Thank you for your contribution! Follow this checklist to help us incorporate your contribution quickly and easily:

[ ] Choose reviewer(s) and mention them in a comment (R: @username).
[ ] Format the pull request title like [BEAM-XXX] Fixes bug in ApproximateQuantiles, where you replace BEAM-XXX with the appropriate JIRA issue, if applicable. This will automatically link the pull request to the issue.
[ ] Update CHANGES.md with noteworthy changes.
[ ] If this contribution is large, please file an Apache Individual Contributor License Agreement.

See the Contributor Guide for more tips on how to make review process smoother.
To check the build health, please visit https://github.com/apache/beam/blob/master/.test-infra/BUILD_STATUS.md
GitHub Actions Tests Status (on master branch)

See CI.md for more information about GitHub Actions CI.

Run XVR_JavaUsingPython_Dataflow PostCommit

Run XVR_JavaUsingPython_Dataflow PostCommit

Run XVR_JavaUsingPython_Dataflow PostCommit

PTAL :)

Run Java PreCommit

Thanks.

Run Java PreCommit


[WIP] Upgrade buildkit to current master

Trying to keep up to date with all the API changes...
This isn't quite ready to yet. TestYAML sometimes fails (seems inconsistent):
--- FAIL: TestYAML (0.01s)
    --- FAIL: TestYAML/dockerfile (0.05s)
        yaml_test.go:215:
                Error Trace:    /Users/alehmann/src/llblib/yaml_test.go:215
                Error:          Not equal:
                                expected: "# [download 2/2] COPY --from=hi hi hi\n- type: FILE\n  actions:\n    - type: COPY\n      src: /hi\n      dest: /hi\n      follow-symlinks: true\n      contents-only: true\n      create-dest-path: true\n      allow-wildcard: true\n      allow-empty-wildcard: true\n      dest-input:\n        # [download 1/2] COPY --from=start start start\n        type: FILE\n        actions:\n            - type: COPY\n              src: /start\n              dest: /start\n              follow-symlinks: true\n              contents-only: true\n              create-dest-path: true\n              allow-wildcard: true\n              allow-empty-wildcard: true\n              dest-input:\n                type: SOURCE\n                source: scratch\n              src-input:\n                # [start 2/2] RUN echo start > start\n                type: EXEC\n                args: [/bin/sh, -c, echo start > start]\n                env: ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin']\n                cwd: /\n                mounts:\n                    - mountpoint: /\n                      type: BIND\n                      output: 0\n                      input: &ref0_0\n                        # [hi 1/2] FROM docker.io/library/busybox@sha256:b5d6fe0712636ceb7430189de28819e195e8966372edfc2d9409d79402a0dc16\n                        type: SOURCE\n                        source: docker-image://docker.io/library/busybox@sha256:b5d6fe0712636ceb7430189de28819e195e8966372edfc2d9409d79402a0dc16\n                        platform: linux/arm64\n      src-input:\n        # [hi 2/2] RUN echo hi > hi\n        type: EXEC\n        args: [/bin/sh, -c, echo hi > hi]\n        env: ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin']\n        cwd: /\n        mounts:\n            - mountpoint: /\n              type: BIND\n              output: 0\n              input: *ref0_0\n"
                                actual  : "# [download 2/2] COPY --from=hi hi hi\n- type: FILE\n  actions:\n    - type: COPY\n      src: /hi\n      dest: /hi\n      follow-symlinks: true\n      contents-only: true\n      create-dest-path: true\n      allow-wildcard: true\n      allow-empty-wildcard: true\n      dest-input:\n        # [download 1/2] COPY --from=start start start\n        type: FILE\n        actions:\n            - type: COPY\n              src: /start\n              dest: /start\n              follow-symlinks: true\n              contents-only: true\n              create-dest-path: true\n              allow-wildcard: true\n              allow-empty-wildcard: true\n              dest-input:\n                type: SOURCE\n                source: scratch\n              src-input:\n                # [start 2/2] RUN echo start > start\n                type: EXEC\n                args: [/bin/sh, -c, echo start > start]\n                env: ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin']\n                cwd: /\n                mounts:\n                    - mountpoint: /\n                      type: BIND\n                      output: 0\n                      input: &ref0_0\n                        # [start 1/2] FROM docker.io/library/busybox@sha256:b5d6fe0712636ceb7430189de28819e195e8966372edfc2d9409d79402a0dc16\n                        type: SOURCE\n                        source: docker-image://docker.io/library/busybox@sha256:b5d6fe0712636ceb7430189de28819e195e8966372edfc2d9409d79402a0dc16\n                        platform: linux/arm64\n      src-input:\n        # [hi 2/2] RUN echo hi > hi\n        type: EXEC\n        args: [/bin/sh, -c, echo hi > hi]\n        env: ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin']\n        cwd: /\n        mounts:\n            - mountpoint: /\n              type: BIND\n              output: 0\n              input: *ref0_0\n"

                                Diff:
                                --- Expected
                                +++ Actual
                                @@ -37,3 +37,3 @@
                                                       input: &ref0_0
                                -                        # [hi 1/2] FROM docker.io/library/busybox@sha256:b5d6fe0712636ceb7430189de28819e195e8966372edfc2d9409d79402a0dc16
                                +                        # [start 1/2] FROM docker.io/library/busybox@sha256:b5d6fe0712636ceb7430189de28819e195e8966372edfc2d9409d79402a0dc16
                                                         type: SOURCE
                Test:           TestYAML/dockerfile
    yaml_test.go:20: build output:
        #1 [internal] load metadata for docker.io/library/busybox@sha256:b5d6fe0712636ceb7430189de28819e195e8966372edfc2d9409d79402a0dc16
        #1 DONE 0.0s
FAIL
exit status 1
FAIL    github.com/coryb/llblib 1.848s

Yeah, TestYAML is known to be random.  The LLB generated from Dockerfile2LLB seems to generate random LLB in cases where ordering is not important.


Invalid external pointers crash the R session

See pola-rs/r-polars#874

Thank you.
I am curious as to why you are a member of this organization but make massive changes to your own fork.
I would think that changes so huge that no one can review them and they are unlikely to be merged here?
(It seems to me that even small changes are hardly merged here in the first place, and I fear that the extendr project is almost at a standstill now)
Should we switch to your fork?

My intention is not to fork extendr. I've made a fork, with the intention of figuring out the big challenges we have in extendr-development. I'm periodically rebasing / sorting commits to merge them into single-feature-commits, so they can be used as basis for PRs.
extendr development is very tangled, and I wanted to untangle it bit by bit. Limitation in Rust and R makes it hard to work on a single thing and just make it into a solid, review-ready PR.
Currently, what my fork does:

Adds libR-sys and rextendr as git submodules to extendr, so the syncing between versions can happen more holistically. This has been very nice..
Using parking_lot for R_API-lock.
Fix: issue with returning &Self / &mut Self from extendr-impl
conversion of strings made more "efficient" because we no longer look for the NUL https://github.com/CGMossa/extendr/commit/c62e6537ebd8632f03eb9fd6bfad0168d8f1b9e1
Added support for enum as R factors via #[extendr]-macro on enums https://github.com/CGMossa/extendr/commit/3cbc9a4e652d87e909427cec9fde3706c58d426d
Use use_try_from as default and removed FromRobj completely.
Removed one macro from R-internals stuff https://github.com/CGMossa/extendr/commit/9332208292985f20bdf3daa810055d3b74a18791

Originally, what I wanted to do is simply figure out the multi-threading issues we have been having.
The goal is to merge the good part over.

Thank you for your detailed explanation. It would be great if they were merged.


Fix panic when reporting shard diagnostics

Shard diagnostics wasn't been populated correctly and it made influx panic when reporting shards.
I also changed the TestSingleServerDiags test to reproduce the error
Fixes #2421

You can ignore the test failure for now, it's a known issue we need to look into.

OK, thanks @marcosnils -- I'll take a closer look at this diff shortly.

OK, thanks very much @marcosnils -- I see where you are going. In fact this code has caused multiple issues, so I've actually simplified it at https://github.com/influxdb/influxdb/pull/2431.
Your code showed me what was wrong, but I'd like to solve it slightly differently. Please take a look at PR 2431.


Rubgems pubilsh action

After new release tag is added, new gem should be build and published

A new error:

Run bundle exec rake release

rake aborted!
Don't know how to build task 'release' (See the list of available tasks with `rake --tasks`)
/home/runner/work/bddsm/bddsm/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/exe/rake:27:in `<top (required)>'
/opt/hostedtoolcache/Ruby/3.3.3/x64/bin/bundle:25:in `load'
/opt/hostedtoolcache/Ruby/3.3.3/x64/bin/bundle:25:in `<main>'
(See full trace by running task with --trace)
Error: Process completed with exit code 1.

https://github.com/HeavyTechRuby/bddsm/actions/runs/9757234217/job/26929178450

An error again
rake aborted!
Running `git push origin refs/heads/HEAD` failed with the following output:
error: src refspec refs/heads/HEAD does not match any
error: failed to push some refs to 'https://github.com/HeavyTechRuby/bddsm'
/home/runner/work/bddsm/bddsm/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/exe/rake:27:in `<top (required)>'
/opt/hostedtoolcache/Ruby/3.3.3/x64/bin/bundle:25:in `load'
/opt/hostedtoolcache/Ruby/3.3.3/x64/bin/bundle:25:in `<main>'
Tasks: TOP => release => release:source_control_push
(See full trace by running task with --trace)

https://github.com/HeavyTechRuby/bddsm/actions/runs/9773500375/job/26979793959#step:4:27

Fixed here https://github.com/HeavyTechRuby/bddsm/commit/3ca9ffa00caa219ee9308fafc4fab97b6e9f4340


Added support for running externally defined functions

Libraries such as typer define app in a different file so we cannot normally use mainpy.main(app) anymore. With this patch we read the current call stack to see if we're still being called from the __main__ module

I've re-merged the pyproject.toml. Apparently git f'ed up again :P


feat: prewired added for vpc->iam access mgmt and iam groups

Description
Pre-wired rule added for VPCs -> IAM access management and VPCs -> IAM groups for SCC scan to pass, refer screenshot below.
Git Issue

Release required?

[ ] No release
[ ] Patch release (x.x.X)
[x] Minor release (x.X.x)
[ ] Major release (X.x.x)

Release notes content
Prewired CBR rule added for -
VPCs -> IAM access management
VPCs -> IAM groups
Run the pipeline
If the CI pipeline doesn't run when you create the PR, the PR requires a user with GitHub collaborators access to run the pipeline.
Run the CI pipeline when the PR is ready for review and you expect tests to pass. Add a comment to the PR with the following text:
/run pipeline

Checklist for reviewers

[ ] If relevant, a test for the change is included or updated with this PR.
[ ] If relevant, documentation for the change is included or updated with this PR.

For mergers

Use a conventional commit message to set the release level. Follow the guidelines.
Include information that users need to know about the PR in the commit message. The commit message becomes part of the GitHub release notes.
Use the Squash and merge option.

/run pipeline

:tada: This PR is included in version 1.28.0 :tada:
The release is available on GitHub release
Your semantic-release bot :package::rocket:


ActiveRecord::unlink() is unnecessarily nulling foreign key property

Hello,
I have problem with foreach on line 1307 in BaseActiveRecord.php, which is nulling foreign key property of parent model.
I'm using custom delete behavior, where I cancel "real" model deletion and I just set the "deleted" attribute to "true" instead.
Important part of my custom delete behavior code:
public function beforeDelete($event) {
    ...
    $owner->{$this->deletedAttribute} = true;
    $owner->save();
    $event->isValid = false;
}

So imho it would be correct to keep foreign key value, but only when "$delete" parameter is set to "true", so it won't break the other functionality.
Original code:
foreach ($relation->link as $a => $b) {
    $model->$a = null;
}
$delete ? $model->delete() : $model->save(false);

Altered code:
if (!$delete) {
    foreach ($relation->link as $a => $b) {
        $model->$a = null;
    }
}
$delete ? $model->delete() : $model->save(false);

When programmer want to unlink without delete, it will do the nullification of foreign key, which is OK. But when he wants to delete foreign model, it will keep the foreign key value. This doesn't matter when you do "real" delete (foreign model will be deleted anyway), but when you override deletion in behavior by updating "deleted" attribute, you keep data in database and when the non-nullable foreign key is nullified, the SQL update crashes.
Cheers and thanks.
~PMan
Additional info

Q
A

Yii version
2.0.6

PHP version
5.5.30

Operating system
Win 8.1

ActiveRecord deleting does not connected to the unlink() method anyhow inside the core.
It seems to invoke it yourself somewhere, thus you should apply your logic at that place on your own.


Implement train_test_split

Implemented the method train_test_split to prepare a DataFrame for machine learning algorithms, by dividing it into 2-3 smaller DataFrames, which represent the train, test (and optionally validation) sets and additional test. The idea is that users are working with a DataFrame that has columns text, pca, ..., X, Y where columns X, Y are columns with input and labels/output (e.g. X might be a bert embedding of the text, Y might be class targets and users want to train an ML model to predict the labels). Most users currently use sklearn.train_test_split which we also internally use in the new function, but with this function we

provide a unified interface for users (don't have to import sklearn for their ML preprocessing pipeline)
extend the sklearn function to split into train-test-validation (sklearn can only split into train-test)

Overview
def train_test_split(df,train=0.0,test=0.0,val=0.0,class_balance=None,shuffle=True,random_state=None) ->
Union[
    Tuple[pd.DataFrame, pd.DataFrame], Tuple[pd.DataFrame, pd.DataFrame, pd.DataFrame]
]:

Here the method takes:

a DataFrame that we want to split up into training, testing, and optionally validation.
train=0.0,test=0.0,val=0.0, where, when all are set to 0.0, then the proportion will be 70% training set and 30% test set. If just validation is set, then we will return an error, as no training and test sizes are defined. If ints instead of floats are given, it will interpret this as the absolute value (e.g. train=200 -> train DF will have 200 documents)
class_balance: if the data is already labeled and we want to keep the label proportions in the subsets (same as sklearn stratify), we pass a Series with the labels here (see example below)
shuffle, which shuffles the dataset
random_state, to create deterministic results

The method will return 2 or 3 DataFrames in a Tuple, with at the first 🥇 position the train_set_DataFrame, at the second 🥈 place the test_set_DataFrame and if validation was set to a different value than 0.0 it will return on the third 🥉 place the validation_set_DataFrame.
Example

>>> import texthero as hero
>>> import pandas as pd
>>> df = pd.read_csv(
...    "https://raw.githubusercontent.com/jbesomi/texthero/master/dataset/bbcsport.csv"
... ) # doctest: +SKIP
>>> train_df, test_df = hero.train_test_split(
...                  df, class_balance = df["topic"], random_state = 42, train=0.8
... ) # doctest: +SKIP
>>> len(train_df) # doctest: +SKIP
589
>>> len(test_df) # doctest: +SKIP
148
>>> # to check wether we have a equal class distribution (in this case a class is a topic)
>>> # we will look at the percentage of each topic in the DataFrame
>>> train_df["topic"].value_counts() / train_df["topic"].value_counts().sum() # doctest: +SKIP
football     0.359932
rugby        0.198642
cricket      0.168081
athletics    0.137521
tennis       0.135823
Name: topic, dtype: float64
>>> # and now the same for the test dataset
>>> test_df["topic"].value_counts() / test_df["topic"].value_counts().sum() # doctest: +SKIP
football     0.358108
rugby        0.202703
cricket      0.168919
athletics    0.135135
tennis       0.135135
Name: topic, dtype: float64

As Texthero cannot really offer ML capabilities (see #155 for instance), I don't really see where users can make use of this function as they would need anyway to import and use scikit-learn ...
Also, split into train-test-dev is quite straightforward:
X_train, y_train, X_test, y_test = train_test_split(df[['columns', ...,]], df['target], ...)
X_val, y_val, X_test, y_test = train_test_split(X_test, y_test, ...)

Not sure users would want to read the docstring of a new function from a library not designed for these kinds of ML operations ...
Sorry for the negative review! :( 👍
Would be happy to see your motivations though!

Would be happy to see your motivations though!

we saw three main advantages in this implementation

the users don't have to import sklearn, when they do machine learning. They can preprocess the text with Texthero, split it with Texthero, and then dump it into TensorFlow.  This way the user saves to import one additional library
it makes the code of the user shorter as it saves one line
we have the option to keep the class balance even for the case with validation, so the user doesn't have to create his own solution, so he doesn't have to google it.

But no worries if it's not gonna be merged, as we do this project for fun 🪂 🥇 ⛽

Closing this as this is out-of-scope, at least for now. Thank you for the contribution nonetheless! 👌


Docs/dt/prep 24 05

Description
follow-up to #815

[x] shorten exceeding file lengths. closes #646
[x] fix broken link. closes #763
[x] execute suggestions from. closes #334
[x] complete fixes from. closes #779
[x] check for updates in CX-0001, -0002, -0003, -0053
[x] add section on interface property. closes #859

Pre-review checks
Please ensure to do as many of the following checks as possible, before asking for committer review:

[x] DEPENDENCIES are up-to-date. Dash license tool. Committers can open IP issues for restricted libs.
[x] Copyright and license header are present on all affected files

Someone please review this 😭

Someone please review this 😭

Unfortunately, I cannot provide feedback to any of the changes. Not really into the topic

Someone please review this 😭

Hi @arnoweiss me neither... 😅


Restructure Documentation for Readability

I think there might be several phases to documentation updates. For this first phase, I'm hoping to just settle on a reordering of the pages for overall readability and to make clear what user vs developer is and provide information on how they should approach the documentation, without being too focused on content of specific pages.

Change
Reason

(1) Move intro into index.html
Helps make the default entrance page more meaningful

(2) Shorten User Guide
- Pulling out all pages which require developer mindset- Want to keep clean information for users (who don’t plan to contribute)

(3) Add new FLOW BASICS section for flow
Group together "data model," "programming model" and "execution model" since these three main sections are the next step to understanding the flow that the user ran

(4) Reverse order of FLOW BASICS files
Reverse order Execution → Programming → Data because… - While referenced in others, execution describes for the first time...    - flowgraph   - step/index   - node/edge   - get/set - Pictures are always easier to absorb and the flowgraphs will help - Data model is the most detailed one and concerned this will lose people early It helps to see big picture then get into details

(5) Add a Developer Manual section
- Move everything else in User Guide here- Move contributing modules here since it’s a bit different than other tutorials

(6) Group frontend tutorials together
Cleans up tutorial section for easier reading

(7) Adjusted some links in tutorials
Now that merged together in one page these were added to address conflicting label warnings

Look through documentation created for this PR here: https://siliconcompiler--1389.org.readthedocs.build/en/1389/
Note: If these changes are approved, it would make sense for some files to move, but I didn't want to do that right away so you could see the file diffs.

Thanks @nmoroze for the review. I think your suggestion on moving "Getting Started" up makes sense, so I incorporated it.
As for Flow Basics, I moved the order back to the original order, but I do agree it needs some rework. I'll think about how to adjust it in a way that makes sense. But does the motivation of Flow Basics still make sense as a separate section? There are links at the end of Quickstart which point you to the different flow basic sections so the idea is that a user has already run through Quickstart, and they're ready to get into how to set up a run with their design in more detail.

LGTM, I assume we are addressing the content in a series of future PRs?

Yes, future PRs, since I think the current changes is a standalone step to improving readability on the docs.


Build Instructions

Can I get the build instructions for this? I wanted to enhance this but am unable to build it

Current project use Gradle, you can read dev document at Building Plugins with Gradle
,
You also can push a Pull Request.

Not sure a pull request would work as I had to remove a lot of the exception logging code because of mandarin characters which my IDE didnt work. I added compatibility to intellij 2020 and gradle 7+, plus I wanted to add support for jsonb columns with postgres which I did. I can send a PR if you want. Ill probably have to fork the repo for that since I dont have permission to push a branch to this repo.


Droid build error after adding plugin: "The "GenerateJavaStubs" task failed unexpectedly...

Please fill out either the bug or feature request section and remove whatever section you are not using.
Severity	Code	Description	Project	File	Line	Suppression State
Error		The "GenerateJavaStubs" task failed unexpectedly.
System.InvalidOperationException: There can be only one type with an [Application] attribute; found: ,
   at Xamarin.Android.Tasks.ManifestDocument.CreateApplicationElement(XElement manifest, String applicationClass, List`1 subclasses, List`1 selectedWhitelistAssemblies)
   at Xamarin.Android.Tasks.ManifestDocument.Merge(List`1 subclasses, List`1 selectedWhitelistAssemblies, String applicationClass, Boolean embed, String bundledWearApplicationName, IEnumerable`1 mergedManifestDocuments)
   at Xamarin.Android.Tasks.GenerateJavaStubs.Run()
   at Xamarin.Android.Tasks.GenerateJavaStubs.Execute()
   at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute()
   at Microsoft.Build.BackEnd.TaskBuilder.<ExecuteInstantiatedTask>d__26.MoveNext()	PatrolLiveApp.Droid	C:\Program Files (x86)\MSBuild\Xamarin\Android\Xamarin.Android.Common.targets	1682

Bug
Version Number of Plugin: 3.04
Device Tested On:
Simulator Tested On: android xxhdpi phone emulator API 19 (but it doesn't build so this is not relevant)
Expected Behavior
Project built before adding library.
Actual Behavior
Project did not build after adding library.
Steps to reproduce the Behavior'
Add plugin to portable library and android library.
Feature Request:
Please fill in what you would like

Oops there was a duplicate MainApplication class in a separate library. Deleting the auto-generated one in the droid project solved it


Move PubSub interface to ports

At the moment, the definition of the application-level PubSubService can be found in internal/core/application. Like the definition of the RepoManager, it should be placed into internal/core/ports.

thoughts @sekulicd

agree with @altafan


Initial consideration for integration with https://gitlab.com/bootc-org/podman-bootc-cli

Is your enhancement related to a problem? Please describe
This extension is doing some cool stuff, but I want to do things from a CLI too
Describe the solution you'd like
Let's figure out how we can integrate with https://gitlab.com/bootc-org/podman-bootc-cli
Describe alternatives you've considered
No response
Additional context
No response

Actually...can a podman-desktop extension also ship a CLI binary?  If so, then I think we could poentially just couple the two together?

Actually...can a podman-desktop extension also ship a CLI binary? If so, then I think we could poentially just couple the two together?

Yup! We can! Best thing about shipping an extension. Can also download / install the binary too.
The only thing though is that we only support GitHub releases right now, so the CLI would have to move away from GitLab or we implement it upstream on Podman Desktop / ask to support it.

I think releases can be everywhere as it's managed by the extension

The only thing though is that we only support GitHub releases right now,

We could add the CLI as a git submodule here, and build it here too, right?

I think releases can be everywhere as it's managed by the extension

Not for CLI updates at the moment, right? Octokit + GitHub integration?

The only thing though is that we only support GitHub releases right now,

We could add the CLI as a git submodule here, and build it here too, right?

Thats correct, as long as there are releases, we could use octokit inside the extension and help manage it / install / etc.

I may not be understanding something here.  You're talking about octokit, which implies us talking to the github API...to fetch out of band binaries?
I had been thinking of this more like the CLI binary ships in the extension container image, and client side we extract the binary from the extension container or so?  Is that viable?
The key advantage of shipping this in the extension container is it inherently supports offline/disconnected installs better.

@cdrage the update is managed by the extension so no requirement on GitHub nor Octokit
@cgwalters for some extensions we're not shipping with the binary inside the OCI image, for some yes.
But what is nice from user POV is also to be notified when there are new CLI updates ( so you can update the CLI in an independent way of the extension)
That said, if the two are heavily linked ( extension and CLi) then in that case the update would come with the extension update
It also depends if the CLi is to be distributed/ installed globally for the user or if it's only for extension usage.
All combinations are possible, just need to agree on the best pattern for this CLi/extension

But what is nice from user POV is also to be notified when there are new CLI updates ( so you can update the CLI in an independent way of the extension)

I think anyone who wants this can install the cli from homebrew.

It also depends if the CLi is to be distributed/ installed globally for the user or if it's only for extension usage.

The primary point of the CLI is that it's in the user's $PATH; but very closely secondary is that it's sharing code with the GUI.

Just want to keep this conversation going...maybe short term we just cross-reference the two projects as in https://github.com/containers/podman-desktop-extension-bootc/pull/193 ?

100% I am onboard to have this in, as it would make it a more reliable solution to running a bare vfkit command. We could package it with the extension.
Let's talk more about it this week / try to get a timeline / POC of it.


[Frontend] - Building UI

Design: https://www.figma.com/file/BPaDYx9xn4OFejQlUwpF4g?node-id=240:1713#395559663

break down task to smaller pieces. will close this one

there are other issues in issues section. Broken down


add the command import default

Pre-Submission Checklist

[ ] Your pull request targets the staging branch of freeCodeCamp.
[ ] Branch starts with either fix/, feature/, or translate/ (e.g. fix/signin-issue)
[ ] You have only one commit (if not, squash them into one commit).
[ ] All new and existing tests pass the command npm test. Use git commit --amend to amend any fixes.

Type of Change

[ ] Small bug fix (non-breaking change which fixes an issue)
[ ] New feature (non-breaking change which adds new functionality)
[ ] Breaking change (fix or feature that would change existing functionality)
[ ] Add new translation (feature adding new translations)

Checklist:

[ ] Tested changes locally.
[ ] Addressed currently open issue (replace XXXXX with an issue no in next line)

Closes #XXXXX
Description

Again mrugesh sending overwhelming talkative emails
Sent from Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 for Windows 10

From: mrugesh mohapatra<EMAIL_ADDRESS>Sent: Tuesday, October 2, 2018 3:34:48 PM
To: freeCodeCamp/freeCodeCamp
Cc: Subscribed
Subject: Re: [freeCodeCamp/freeCodeCamp] add the command import default (#18207)
Hi,
Thanks for this pull request (PR).
Unfortunately, we are marking this PR invalid for hacktoberfest. We believe it does not follow the recommended guidelines:
Quality Standards
In line with Hacktoberfest value #2 (Quantity is fun, Quality is key), we have provided examples of the quality standards we encourage. This applies mainly to beginners.

PRs that are automated e.g. scripted opening PRs to remove whitespace / optimize images.
PRs that are disruptive e.g. taking someone else's branch/commits and making a PR.
PRs that are regarded by a project maintainer as a hindrance vs. helping.
Something that's clearly an attempt to simply +1 your PR count for October.

Learn more at https://hacktoberfest.digitalocean.com/detailshttps://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fhacktoberfest.digitalocean.com%2Fdetails&data=02|01||67d389bcad7f44b2471208d628b7433c|84df9e7fe9f640afb435aaaaaaaaaaaa|1|0|636741164895268069&sdata=ddxoBtEYMKt8Gu00OTfe2d9vLXO6i57%2FdyxCMSWw1MI%3D&reserved=0
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHubhttps://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FfreeCodeCamp%2FfreeCodeCamp%2Fpull%2F18207%23issuecomment-426451153&data=02|01||67d389bcad7f44b2471208d628b7433c|84df9e7fe9f640afb435aaaaaaaaaaaa|1|0|636741164895268069&sdata=6Lb3jyg2mcdNnf4%2BMozYcrbj%2FqwBuENCm1%2FxYYPrZFs%3D&reserved=0, or mute the threadhttps://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAfJhmjX_ua_Rffl6O9cpxztTt2w_bhvSks5ug-oIgaJpZM4XB-xZ&data=02|01||67d389bcad7f44b2471208d628b7433c|84df9e7fe9f640afb435aaaaaaaaaaaa|1|0|636741164895268069&sdata=24boHD0UFdWWaxrbpM%2FvDhoepuPZgKsYLWrEYYx2dcI%3D&reserved=0.


Allow single-point open contours in area pen

Sometimes an anchor is drawn as a moveTo followed by an endPath, for
that case it makes sense just to ignore and count the area as zero.
r? @anthrotype

Care adding test?  lgtm otherwise.


fix: construct query params from location.search on rehydrate

Fixes https://github.com/sveltejs/kit/issues/669
When rehydrating a page, the query params were set to URLSearchParams(s(page.query.toString())). This change uses location.search when page.query is empty.

Actually I just didn't want to prevent what was happening before if page.query is set. We could probably just use location.search.

Yes, this seems simpler. Still, I'm wondering what exactly the bug was. E.g. there are other places we use page and I wouldn't want there to be issues there as well. Can you explain why or when page.query.toString() is different from location.search?

The bug was that when rehydrating pages on static sites, the query string from the url was not used, only the query prop of the page object which was empty.

This will fix #669

the query prop of the page object which was empty

That's what concerns me about this fix. It seems like a bit of a workaround. Why is the query prop empty? It seems like the query prop is still going to be broken for anyone who tries to use it

I added an explanation for what's happening on the ticket: https://github.com/sveltejs/kit/issues/669#issuecomment-848988844. I'm not sure what the other maintainers think, but at the moment I'd lean towards disallowing usage of $page.query on prerendered pages instead

I think we need to address the issue of static rendered pages that want per-request page store data at runtime, in a wholistic way. If #669 is about query parameters, and #1561 is about route parameters, they're two sides of the same coin and we should address them both in one pass.

I'd be curious if @benmccann or @pz-mxu has anything thoughts about this RFC I submittted today, making the argument this that PR is a special case of a general issue. https://github.com/sveltejs/rfcs/pull/52

Using page.query is deliberate — the idea is to guarantee consistency between server and client renders.  If you don't know location.search at SSR time (because you're prerendering) then it feels more appropriate to disable SSR for that page than to render an incorrect page, surely?

Thanks for taking the time to investigate and propose this fix. I'm going to go ahead and close this given that Rich has the same opinion as I do that this isn't the correct way to address the issue

So this issue seems to be fixed now... if I serve a staticly built page and put this code in there:
	if (!prerendering) {
		console.log($page.url.searchParams.get('foo'));
	}

I get the actual runtime per-request value of "foo" as seen by the client, instead of the value as was snapshotted at prerender time. I'd like to find out which commit change all this around!


qa: split the activation of vaults for large tests

This is causing timeouts on CI, and i'm out of optimizations: it's just
a lot of traffic. So, solve the issue at the root and make it wait for
smaller batches of vaults at a time.

ACK 80701bf2214a25bef806fbc6d8016f1de0e8be20


move font-related stuff-files to CDN-neutral URLs

The following files needs to be hosted on CDN-neutral URLs:

Source/Fuse.Common/Internal/DesktopFonts.stuff
Source/Fuse.Text/harfbuzz/lib/Android.stuff
Source/Fuse.Text/harfbuzz/lib/OSX.stuff
Source/Fuse.Text/harfbuzz/lib/Windows.stuff
Source/Fuse.Text/harfbuzz/lib/iOS.stuff
Source/Fuse.Text/icu/Windows.stuff
Source/Fuse.Text/icu/iOS.stuff

Source/Fuse.Text/icu/Windows.stuff is the only one that doens't currently point to az664292.vo.msecnd.net, but instead points to download.icu-project.org. I have no idea if this is a good idea to keep doing or not, so I'm still including it in this list just for completeness.

#508 moves the Source/Fuse.Text/icu/Windows.stuff dependencies to the new CDN.


Prepare for Document Intelligence beta release

API change check
API changes are not detected in this pull request.