SynIQ

Members

SynIQ's Achievements

Newbie

Newbie (1/14)

1

Reputation

  1. Now I know what's the problem here. I've tried this and got a new type of error. While importing the file into the new container with the latest version I got this: ERROR 4047 (HY000) at line 3357: InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE. When I tried to import the same file to a new container running MariaDB 10.5.11 the import was successful. So I startet to research a bit for this error and found some posts in the nextcloud community with similar problems in conjunction with MariaDB 10.6.3. It seems there is a problem with the compression and the charset. The line which was referenced in the error above was the beginning of table containing the nextcloud users. Now I think the error I had (SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name does not resolve in /config/www/nextcloud/lib/private/DB/Connection.php:85) referenced not the hostname of MariaDB but the name of the current user in the database table. After setting the charset using docker exec -it nextcloud bash sudo -u abc php /config/www/nextcloud/occ config:system:set mysql.utf8mb4 --type boolean --value="false" and sudo -u abc php /config/www/nextcloud/occ maintenance:repair --include-expensive Nextcloud works with the latest image of MariaDB but warning this configuration may cause issues with 4-byte characters like emojis. Again many thanks for your help @mgutt. Without your help I probably would not have come up with a solution.
  2. Thank you very much for testing it again. Until now I used the "latest" tag but I tried the "focal" tag and it didn't work for now. Since there seems to be no fundamental problem I will keep trying to get it work for me. Now it looks like the problem is nextcloud itself. If I may find the problem I will report it here. Thank you very very much for your Help
  3. Hi and thanks for your answer. I tried it over the ip address but I still got the same error: 2021/07/15 10:05:41 [error] 414#414: *51529 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name does not resolve in /config/www/nextcloud/lib/private/DB/Connection.php:85 Stack trace: #0 /config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1486): OC\DB\Connection->connect() #1 /config/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1014): Doctrine\DBAL\Connection->getWrappedConnection() #2 /config/www/nextcloud/lib/private/DB/Connection.php(226): Doctrine\DBAL\Connection->executeQuery() #3 /config/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(210): OC\DB\Connection->executeQuery() #4 /config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\DBAL\Query\QueryBuilder->execute() #5 /config/www/nextcloud/lib/private/AppConfig.php(345): OC\DB\QueryBuilder\QueryBuilder->execute() #6 /config/www/nextcloud/lib/private/AppConfig.php(1" while reading response header from upstream, client: <Client-IP>, server: _, request: "PROPFIND /remote.php/dav/files/<username>/ HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "<Host-IP>" I also tried your suggestion but with no success. I got the following error with both, the hostname and the ip address. After I ran the command the logs of MariaDB say the following but the same error appears when I run the command from Nextcloud container to the older working MariaDB container. 2021-07-17 20:00:04 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'unauthenticated' host: '172.18.0.4' (This connection closed normally without authentication) This means that the Nextcloud container can reach the MariaDB container although the errormessage says that Nextcloud can't resolve the hostname?When I try to make an action on the webinterface of nextcloud connected to the latest container of MariaDB the error appears and there is no new record in the log of MariaDB. Thats so confusing... I've never had somthing like this bevor. I tried the same command from another container (phpMyAdmin) and there the command has apparently been successful. They are all in the same docker network.
  4. Hi, today I upgraded the MariaDB-Official Container to the latest version. I use it to run Nextcloud and Gitea but after the upgraded it I got the following error in Nextcloud (Gitea just works fine): SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name does not resolve in /config/www/nextcloud/lib/private/DB/Connection.php:85 I changed nothing in my Nextcloud configuration. I connect to the database by using the hostname of the MariaDB-Official container (what still works fine with Gitea). Both containers are in the same docker network. I already tried to give the MaraiDB-Official container a static IP address in the docker network and connect Nextcloud by this address but this didn't work. Meanwhile I rolled back to MariaDB-Official 10.5.11 and it works fine at the moment. What can I do? I'm a little bit overloaded with this problem because I do not know what else to do. Many thanks in advance.
  5. These are the inforamtions i needed. Thank you very much
  6. Hi at all. First I have to say that I use unRAID only since two weeks and therefore I'm new and inexperienced. In search of a suitable backup solution for me I found borgmatic and I absolutely love it. For me it's the best way to backup all my important stuff in a secure way. Many thanks for making this possible! At the moment I'm using CA Backup to backup my appdata folder which is located on my cache drive. But for some other schedules it is really annoying that all containers has to be stopped during the backup. I already know that there is a way not to stop some containers but I'm searching for a easier solution. Therefore I would like to backup my appdata folder with borgmatic. But there are a few things I have not yet understood like why Docker containers are not allowed to run during a backup of the appdata folder. What can happen if they run in worst case and why? I need this information to contrast the potentially risk with the advantages of backing up the appdata Folder with borgmatic without stoping the containers. This topic has already been addressed but until now I couldn't find a solution to stop containers with before_backup and after_backup hooks. I wonder if there is an easy way to control docker daemon on unRAID from inside of a docker container. Thanks in advance and sorry for the possibly stupid questions.