I’m having a weird problem. I’ve had NC running with mariadb and swag through a domain for years, with very little issue along the way. Yesterday I went to log in, and it said my password was wrong (I think I last logged into it about 3-4 days ago). Tried again, same issue. Tried to log in as my admin user, same thing. I double checked my password manager… the passwords were 100% right.
I bashed into NC, and changed my admin password, then restarted NC. Still reported my password was wrong. All the data being backed up, I wasn’t overly concerned, so I nuked the containers, volumes, images, folders, etc. and redeployed my compose file. I’ve used this same one for years.
Redeployed, and setup NC again the way I always have. I get an error, (see pic below)… but if I click the back button, I get the local NC login (https://ip:450). When I try to log in as the admin user I just created… it again reports my password is wrong. None of my logs are reporting anything out of the ordinary. About a week ago, I added redis to my NC setup (apparently required now)… and it works fine. So thinkuing that may be the issue, when I redeployed, I removed redis. Now when I redeploy with redis (and adjust my config.php)… I just get an nginx error…
I’m completely befuddled here. Any help is greatly appreciated.
I will start by saying we support the container, not the application. With that in mind, we’ll skip the admin bit you mention and focus on the container itself and the nginx error. Please share the full container logs, which begin with our ascii logo.
Are you using a reverse proxy to access nextcloud? If you are using swag, please share the swag container logs as well.
As a further note, nothing in the official docs implies redis is required. It has always been an optional component that improves the efficiency of nextcloud.
Well, I have no idea what just happened, but I just deployed the same stack I put above, after deleting all images, folders, etc. again and now it appears to have installed. It is incredibly slow at the moment though, but I’ll give it a few minutes and see if that clears as I’ve had that issue before immediately after a new install.
OK, now I’m getting gateway timeouts anytime I click on anything. My other containers are working fine… so I don’t believe this to be a hardware issue of any sort. I missed your reverse proxy/swag question earlier. Not at this time, I’m local only. I was accessing via my domain with no issue.
Nextcloud. I’ve never seen that php error at the end, so I’m assuming that is the problem.: Thanks again.
root@openmediavault:~# docker logs -f nextcloud
[migrations] started
[migrations] 01-nginx-site-confs-default: executing...
[migrations] 01-nginx-site-confs-default: succeeded
[migrations] 02-default-location: executing...
grep: /config/nginx/site-confs/default.conf: No such file or directory
[migrations] 02-default-location: succeeded
[migrations] done
───────────────────────────────────────
██╗ ███████╗██╗ ██████╗
██║ ██╔════╝██║██╔═══██╗
██║ ███████╗██║██║ ██║
██║ ╚════██║██║██║ ██║
███████╗███████║██║╚██████╔╝
╚══════╝╚══════╝╚═╝ ╚═════╝
Brought to you by linuxserver.io
───────────────────────────────────────
To support LSIO projects visit:
https://www.linuxserver.io/donate/
───────────────────────────────────────
GID/UID
───────────────────────────────────────
User UID: 1000
User GID: 100
───────────────────────────────────────
Setting resolver to 127.0.0.11
Setting worker_processes to 4
generating self-signed keys in /config/keys, you can replace these with your own keys if required
......+......+++++++++++++++++++++++++++++++++++++++*.............+++++++++++++++++++++++++++++++++++++++*..+..........+..................+....................+.......+..+....+......+......+...+.....+.+.....+................+...+...........+..........+...+..+.+...+..+...+......+.+...+....................+.......+..+......+.+.....+...................+..+....+...+.....+...+...+......+......+...+....+.....+...............+...+...+.+...........+.........+....+......+.....+......+.......+..+.+.........+.........+.....+.......+...+..++++++
.+.+.....+.+......+........+.......+.....+...+++++++++++++++++++++++++++++++++++++++*.................+.+..+...+......+.+..+.......+.........+..+...+.........+++++++++++++++++++++++++++++++++++++++*.......+...+....+..+.+.....+.......+..+...............+....+.........+..+...+...+...+.+......+.....+..........+..+......+.+........+......+....+..+...+............+.............+...+...+..+....+.....+.........+.+...+......+..+.......+...+...+...........+.+...+....................+.+.....+....+........................+..+...+......+............++++++
-----
Initializing nextcloud 27.0.0.8 (this can take a while) ...
Setting permissions
New nextcloud instance
Please run the web-based installer on first connect!
Initializing finished
After completing the web-based installer, restart the Nextcloud container to apply default memory caching and transactional file locking configurations.
Alternatively, you can apply your own configurations by editing /config/www/nextcloud/config/config.php following the documentation:
https://docs.nextcloud.com/server/latest/admin_manual/configuration_server/caching_configuration.html
https://docs.nextcloud.com/server/latest/admin_manual/configuration_files/files_locking_transactional.html
# do daily/weekly/monthly maintenance
# min hour day month weekday command
*/15 * * * * run-parts /etc/periodic/15min
0 * * * * run-parts /etc/periodic/hourly
0 2 * * * run-parts /etc/periodic/daily
0 3 * * 6 run-parts /etc/periodic/weekly
0 5 1 * * run-parts /etc/periodic/monthly
# nextcloud cron
*/5 * * * * s6-setuidgid abc php -f /app/www/public/cron.php
cp: not replacing '/config/crontabs/root'
[custom-init] No custom files found, skipping...
[ls.io-init] done.
Exception: Not installed in /app/www/public/lib/base.php:285
Stack trace:
#0 /app/www/public/lib/base.php(705): OC::checkInstalled()
#1 /app/www/public/lib/base.php(1173): OC::init()
#2 /app/www/public/cron.php(43): require_once('...')
#3 {main}
nextclouddb
root@openmediavault:~# docker logs -f nextclouddb
[migrations] started
[migrations] no migrations found
───────────────────────────────────────
██╗ ███████╗██╗ ██████╗
██║ ██╔════╝██║██╔═══██╗
██║ ███████╗██║██║ ██║
██║ ╚════██║██║██║ ██║
███████╗███████║██║╚██████╔╝
╚══════╝╚══════╝╚═╝ ╚═════╝
Brought to you by linuxserver.io
───────────────────────────────────────
To support LSIO projects visit:
https://www.linuxserver.io/donate/
───────────────────────────────────────
GID/UID
───────────────────────────────────────
User UID: 1000
User GID: 100
───────────────────────────────────────
Setting Up Initial Databases
chown: cannot access '/auth_pam_tool_dir/auth_pam_tool': No such file or directory
Couldn't set an owner to '/auth_pam_tool_dir/auth_pam_tool'.
It must be root, the PAM authentication plugin doesn't work otherwise..
chown: cannot access '/auth_pam_tool_dir': No such file or directory
Cannot change ownership of the '/auth_pam_tool_dir' directory
to the 'abc' user. Check that you have the necessary permissions and try again.
Installing MariaDB/MySQL system tables in '/config/databases' ...
2023-07-06 14:20:37 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
OK
To start mariadbd at boot time you have to copy
support-files/mariadb.service to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following command:
'/usr/bin/mariadb-secure-installation'
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at https://mariadb.com/kb
You can start the MariaDB daemon with:
cd '/usr' ; /usr/bin/mariadb-safe --datadir='/config/databases'
You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/mysql-test' ; perl mariadb-test-run.pl
Please report any problems at https://mariadb.org/jira
The latest information about MariaDB is available at https://mariadb.org/.
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
2023-07-06 14:21:01 0 [Note] Starting MariaDB 10.11.4-MariaDB-log source revision 4e2b93dffef2414a11ca5edc8d215f57ee5010e5 as process 183
2023-07-06 14:21:01 0 [Note] Using unique option prefix 'myisam_recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead.
2023-07-06 14:21:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2023-07-06 14:21:01 0 [Note] InnoDB: Number of transaction pools: 1
2023-07-06 14:21:01 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-07-06 14:21:01 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-07-06 14:21:01 0 [Note] InnoDB: Using Linux native AIO
2023-07-06 14:21:01 0 [Note] InnoDB: Initializing buffer pool, total size = 256.000MiB, chunk size = 4.000MiB
2023-07-06 14:21:01 0 [Note] InnoDB: Completed initialization of buffer pool
2023-07-06 14:21:01 0 [Note] InnoDB: File system buffers for log disabled (block size=4096 bytes)
2023-07-06 14:21:01 0 [Note] InnoDB: 128 rollback segments are active.
2023-07-06 14:21:01 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-07-06 14:21:01 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-07-06 14:21:01 0 [Note] InnoDB: log sequence number 46456; transaction id 14
2023-07-06 14:21:01 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool
2023-07-06 14:21:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-07-06 14:21:01 0 [Note] InnoDB: Buffer pool(s) load completed at 230706 14:21:01
2023-07-06 14:21:01 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-07-06 14:21:01 0 [Note] Server socket created on IP: '::'.
2023-07-06 14:21:01 0 [Note] mariadbd: ready for connections.
Version: '10.11.4-MariaDB-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Alpine Linux
2023-07-06 14:21:03 0 [Note] mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
2023-07-06 14:21:03 0 [Note] InnoDB: FTS optimize thread exiting.
2023-07-06 14:21:03 0 [Note] InnoDB: Starting shutdown...
2023-07-06 14:21:03 0 [Note] InnoDB: Dumping buffer pool(s) to /config/databases/ib_buffer_pool
2023-07-06 14:21:03 0 [Note] InnoDB: Buffer pool(s) dump completed at 230706 14:21:03
2023-07-06 14:21:03 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-07-06 14:21:03 0 [Note] InnoDB: Shutdown completed; log sequence number 46456; transaction id 16
2023-07-06 14:21:03 0 [Note] mariadbd: Shutdown complete
Database Setup Completed
[custom-init] No custom files found, skipping...
230706 14:21:04 mysqld_safe Logging to '/config/databases/80588e5e23a0.err'.
230706 14:21:04 mysqld_safe Starting mariadbd daemon with databases from /config/databases
[ls.io-init] done.
Yeah something is definitely wrong. It’s been hourglassing for about 20min trying to show users list, then it just timed out. It does the same thing no matter what I click on.
Well, that’s exactly the problem. I redeployed nextcloud, and checked the image tags. Looks like it was updated 3 days ago. So I tagged it to the version from 21 days ago, deployed, and it’s working as expected. Not sure how that is happening, as like I said it was a brand new database.
Let me know if there’s more info I can provide, but like I said, tagging it to the previous version seesm to have resolved the issue.
I’m coming to the conclusion this is definitely a database issue of some sort, Im just not sure what. I went back to using the “latest” database, I got installed by not installing any apps. It seemed OK at first, I added a user, which seemed to go OK. I attempted to add a group, and after a long hourglasss, got an error the group already existed. This is impossible as it’s a new database and if I click on a user and try to add them to this group, it’s not an option.
I checked the container logs for mariadb and nextcloud, and neither seem to be showing anything out fo the ordinary.
root@openmediavault:~# docker logs -f nextcloud
[migrations] started
[migrations] 01-nginx-site-confs-default: executing...
[migrations] 01-nginx-site-confs-default: succeeded
[migrations] 02-default-location: executing...
grep: /config/nginx/site-confs/default.conf: No such file or directory
[migrations] 02-default-location: succeeded
[migrations] done
───────────────────────────────────────
██╗ ███████╗██╗ ██████╗
██║ ██╔════╝██║██╔═══██╗
██║ ███████╗██║██║ ██║
██║ ╚════██║██║██║ ██║
███████╗███████║██║╚██████╔╝
╚══════╝╚══════╝╚═╝ ╚═════╝
Brought to you by linuxserver.io
───────────────────────────────────────
To support LSIO projects visit:
https://www.linuxserver.io/donate/
───────────────────────────────────────
GID/UID
───────────────────────────────────────
User UID: 1000
User GID: 100
───────────────────────────────────────
Setting resolver to 127.0.0.11
Setting worker_processes to 4
generating self-signed keys in /config/keys, you can replace these with your own keys if required
..+.+++++++++++++++++++++++++++++++++++++++*...+...+...........+.........+...+.......+..+..........+...+...+..+...+.......+...+..+......+.......+...+..+...+.+++++++++++++++++++++++++++++++++++++++*...........+...+......+...+.+......+...+.....+.......+...+......+..+..........+...+............+..+......+.+........+..........+..+.+.....+.............+......+.....+....+.....+....+......+...........++++++
............+.........+.............+......+.........+.....+.............+.....+...+....+..+++++++++++++++++++++++++++++++++++++++*..+++++++++++++++++++++++++++++++++++++++*...+..........++++++
-----
Initializing nextcloud 27.0.0.8 (this can take a while) ...
Setting permissions
New nextcloud instance
Please run the web-based installer on first connect!
Initializing finished
After completing the web-based installer, restart the Nextcloud container to apply default memory caching and transactional file locking configurations.
Alternatively, you can apply your own configurations by editing /config/www/nextcloud/config/config.php following the documentation:
https://docs.nextcloud.com/server/latest/admin_manual/configuration_server/caching_configuration.html
https://docs.nextcloud.com/server/latest/admin_manual/configuration_files/files_locking_transactional.html
# do daily/weekly/monthly maintenance
# min hour day month weekday command
*/15 * * * * run-parts /etc/periodic/15min
0 * * * * run-parts /etc/periodic/hourly
0 2 * * * run-parts /etc/periodic/daily
0 3 * * 6 run-parts /etc/periodic/weekly
0 5 1 * * run-parts /etc/periodic/monthly
# nextcloud cron
*/5 * * * * s6-setuidgid abc php -f /app/www/public/cron.php
cp: not replacing '/config/crontabs/root'
[custom-init] No custom files found, skipping...
[ls.io-init] done.
[migrations] started
[migrations] 01-nginx-site-confs-default: skipped
[migrations] 02-default-location: skipped
[migrations] done
usermod: no changes
───────────────────────────────────────
██╗ ███████╗██╗ ██████╗
██║ ██╔════╝██║██╔═══██╗
██║ ███████╗██║██║ ██║
██║ ╚════██║██║██║ ██║
███████╗███████║██║╚██████╔╝
╚══════╝╚══════╝╚═╝ ╚═════╝
Brought to you by linuxserver.io
───────────────────────────────────────
To support LSIO projects visit:
https://www.linuxserver.io/donate/
───────────────────────────────────────
GID/UID
───────────────────────────────────────
User UID: 1000
User GID: 100
───────────────────────────────────────
using keys found in /config/keys
The only part about the mariadb log that is interesting is the parts in red (obviously)… but to me, all that makes sense since it’s a new database, I wouldn’t expect any of those things to be found.
root@openmediavault:~# docker logs -f nextclouddb
[migrations] started
[migrations] no migrations found
───────────────────────────────────────
██╗ ███████╗██╗ ██████╗
██║ ██╔════╝██║██╔═══██╗
██║ ███████╗██║██║ ██║
██║ ╚════██║██║██║ ██║
███████╗███████║██║╚██████╔╝
╚══════╝╚══════╝╚═╝ ╚═════╝
Brought to you by linuxserver.io
───────────────────────────────────────
To support LSIO projects visit:
https://www.linuxserver.io/donate/
───────────────────────────────────────
GID/UID
───────────────────────────────────────
User UID: 1000
User GID: 100
───────────────────────────────────────
Setting Up Initial Databases
chown: cannot access '/auth_pam_tool_dir/auth_pam_tool': No such file or directory
Couldn't set an owner to '/auth_pam_tool_dir/auth_pam_tool'.
It must be root, the PAM authentication plugin doesn't work otherwise..
chown: cannot access '/auth_pam_tool_dir': No such file or directory
Cannot change ownership of the '/auth_pam_tool_dir' directory
to the 'abc' user. Check that you have the necessary permissions and try again.
Installing MariaDB/MySQL system tables in '/config/databases' ...
2023-07-07 7:42:56 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
OK
To start mariadbd at boot time you have to copy
support-files/mariadb.service to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following command:
'/usr/bin/mariadb-secure-installation'
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at https://mariadb.com/kb
You can start the MariaDB daemon with:
cd '/usr' ; /usr/bin/mariadb-safe --datadir='/config/databases'
You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/mysql-test' ; perl mariadb-test-run.pl
Please report any problems at https://mariadb.org/jira
The latest information about MariaDB is available at https://mariadb.org/.
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
2023-07-07 7:43:20 0 [Note] Starting MariaDB 10.11.4-MariaDB-log source revision 4e2b93dffef2414a11ca5edc8d215f57ee5010e5 as process 183
2023-07-07 7:43:20 0 [Note] Using unique option prefix 'myisam_recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead.
2023-07-07 7:43:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2023-07-07 7:43:20 0 [Note] InnoDB: Number of transaction pools: 1
2023-07-07 7:43:20 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-07-07 7:43:20 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-07-07 7:43:20 0 [Note] InnoDB: Using Linux native AIO
2023-07-07 7:43:20 0 [Note] InnoDB: Initializing buffer pool, total size = 256.000MiB, chunk size = 4.000MiB
2023-07-07 7:43:20 0 [Note] InnoDB: Completed initialization of buffer pool
2023-07-07 7:43:20 0 [Note] InnoDB: File system buffers for log disabled (block size=4096 bytes)
2023-07-07 7:43:20 0 [Note] InnoDB: 128 rollback segments are active.
2023-07-07 7:43:20 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-07-07 7:43:20 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-07-07 7:43:20 0 [Note] InnoDB: log sequence number 46456; transaction id 14
2023-07-07 7:43:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-07-07 7:43:20 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool
2023-07-07 7:43:20 0 [Note] InnoDB: Buffer pool(s) load completed at 230707 7:43:20
2023-07-07 7:43:20 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-07-07 7:43:20 0 [Note] Server socket created on IP: '::'.
2023-07-07 7:43:20 0 [Note] mariadbd: ready for connections.
Version: '10.11.4-MariaDB-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Alpine Linux
2023-07-07 7:43:22 0 [Note] mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
2023-07-07 7:43:22 0 [Note] InnoDB: FTS optimize thread exiting.
2023-07-07 7:43:22 0 [Note] InnoDB: Starting shutdown...
2023-07-07 7:43:22 0 [Note] InnoDB: Dumping buffer pool(s) to /config/databases/ib_buffer_pool
2023-07-07 7:43:22 0 [Note] InnoDB: Buffer pool(s) dump completed at 230707 7:43:22
2023-07-07 7:43:22 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-07-07 7:43:22 0 [Note] InnoDB: Shutdown completed; log sequence number 46456; transaction id 16
2023-07-07 7:43:22 0 [Note] mariadbd: Shutdown complete
Database Setup Completed
[custom-init] No custom files found, skipping...
230707 07:43:23 mysqld_safe Logging to '/config/databases/52703a40ce07.err'.
230707 07:43:23 mysqld_safe Starting mariadbd daemon with databases from /config/databases
[ls.io-init] done.
Caught SIGTERM signal!
[migrations] started
[migrations] no migrations found
usermod: no changes
───────────────────────────────────────
██╗ ███████╗██╗ ██████╗
██║ ██╔════╝██║██╔═══██╗
██║ ███████╗██║██║ ██║
██║ ╚════██║██║██║ ██║
███████╗███████║██║╚██████╔╝
╚══════╝╚══════╝╚═╝ ╚═════╝
Brought to you by linuxserver.io
───────────────────────────────────────
To support LSIO projects visit:
https://www.linuxserver.io/donate/
───────────────────────────────────────
GID/UID
───────────────────────────────────────
User UID: 1000
User GID: 100
───────────────────────────────────────
cp: not replacing '/config/custom.cnf'
[custom-init] No custom files found, skipping...
230707 07:47:30 mysqld_safe Logging to '/config/databases/52703a40ce07.err'.
230707 07:47:30 mysqld_safe Starting mariadbd daemon with databases from /config/databases
[ls.io-init] done.
I’ll try taking a deeper look at this tomorrow, but a quick look yesterday. I pinned 10.6.1, and it installed etc. One thing I’m finding, is now the gateway issues start when I start installing apps. If I install no.apps, it’s fine. The instant I install an application from app page… it all goes to hell (yes I’m installing stable/supported apps)
I am going to guess that if everything works until you install the bundle, the bundle is the problem. Is the bundle requiring glibc? if yes, it will not work in our container and you would need to use the official (and much larger) container
It’s the default bundle I’ve installed for years after installing NC ( it’s the suggested bundle right after you click install). I just skipped it after initial install because I kept getting gateway errors
Man I’m still at a total loss here. I pinned maridab to 10.6 in my stack, and still the exact same issue. This makes absolutely no sense and is extremely frustrating. I’ve used NC for years w/ zero issues. As soon as I install an app, any app… it goes to complete crap.