Resetting a user’s password in NextCloud

Resetting a lost admin password

The normal ways to recover a lost password are:

  1. Click the password reset link on the login screen; this appears after a failed login attempt. This works only if you have entered your email address on your Personal page in the Nextcloud Web interface, so that the Nextcloud server can email a reset link to you.
  2. Ask another Nextcloud server admin to reset it for you.

If neither of these is an option, then you have a third option, and that is using the occ command. See Using the occ command to learn more about using the occ command.

$ sudo -u www-data php /var/www/nextcloud/occ user:resetpassword admin
Enter a new password:
Confirm the new password:
Successfully reset password for admin

If your Nextcloud username is not admin, then substitute your Nextcloud username.

unRAID docker: /config/www/nextcloud
unRAID user: abc

$ sudo -u abc php /config/www/nextcloud/occ user:resetpassword admin

Noodle pork á la Fox

  • 2 Pork Chops
  • Mirin
  • Butter
  • Olive oil
  • Sesame oil
  • Salt and pepper
  • Beef bouillon
  • 1 liter of water
  • Handful of corn kernels
  • Handful of chopped spring onions
  • Long cooking noodles
  • Rice cooker
  1. Chop the meat chops in smaller bits and fry them in a splash of olive oil, a thumb thickness of butter, a splash of mirin and a few drops of sesame oil. Season with pepper and salt.
  2. Fill the rice cooker bowl with a liter of water and the other ingredients. When the meat is done, add that too including the grease.
  3. Start rice cooker
  4. Done when the rice cooker is done (20 minutes)

How to correct the Themler crash after updating to Joomla 3.9

If you updated to the latest version and the following error appears when you try to launch Themler please follow the instruction below:

Fatal error: require_once(): Failed opening required '[...]/administrator/includes/toolbar.php' (include_path='.:/usr/lib/php7.2') in [...]/templates/[theme_name]/app/index.php on line 25

  1. Open theme folder on the server: www/Joomla_directory/templates;
  2. open /app folder;
  3. open index.php for editing in any html or text editor;
  4. find the line
    require_once JPATH_BASE . DS . 'includes' . DS . 'toolbar.php';
    and replace it with the following line:
    $prefix = version_compare(JVERSION, '3.9', '>=') ? 'sub' : '';
    require_once JPATH_BASE . DS . 'includes' . DS . $prefix . 'toolbar.php';
  5. open /app/start folder;
  6. open data.php file for editing and follow step 4;
  7. open manifest.php file for editing and follow step 4;
  8. start Themler.

Notepad++ / Adding a character at the beginning or end of each line

STEP 1. Press CTRL-H to bring up the Find/Replace Dialog.

STEP 2. Choose the “Regular expressions” checkbox near the bottom of the dialog.

STEP 3.a To add “test” to the beginning of each line, type `^` in the “Find what” field, and “test” in the “Replace with” field. Then hit “Replace All”.

STEP 3.b To add “test” to the end of each line, type `$` in the “Find what” field, and “test” in the “Replace with” field. Then hit “Replace All”.

Force a file scan in NextCloud

To force a scan after a manual file transfer, for example, can be done as follows:

sudo -u www-data php occ files:scan --all
Usage:
  files:scan [-p|--path="..."] [-q|--quiet] [-v|vv|vvv --verbose] [--all]
  [user_id1] ... [user_idN]

Arguments:
  user_id               will rescan all files of the given user(s)

Options:
  --path                limit rescan to the user/path given
  --all                 will rescan all files of all known users
  --quiet               suppress any output
  --verbose             files and directories being processed are shown
                        additionally during scanning
  --unscanned           scan only previously unscanned files

Source: https://docs.nextcloud.com/server/15/admin_manual/configuration_server/occ_command.html

Automating PDF processing

To automate PDF processing, you need to grab the following first from your repository:

apt-get install git qpdf exiftool pdftk poppler-utils tesseract-ocr imagemagick-6.q16

Then, install PDF Ingest into a desired folder

git clone https://github.com/tezcatlipoca/pdf_ingest

Enter the followind folder:

cd pdf_ingest

Put the files you wish to convert into SRC and type the following command:

./bulk

Wait until done, then you’re done! 🙂

Doing a large MySQL dump

After discovering that PHPMyAdmin is not suitable to dump or insert large databases, I did a quick search into how things are done by command line.

This worked well and my database was finally not corrupted. Host 1 is a cheap shared hosting provider with a few limitations regarding to internal data transfer, CPU and memory. Host 2 is a VPS with 4 cores, 4GB of memory with an overall decent data speed.

Keep the passwords ready for both hosts.

HOST 1

mysqldump -u [USERNAME] -p [DBNAME] | gzip > [/path_to_file/DBNAME].sql.gz

Copy the file over to Host 2

HOST 2

gzip -d [/path_to_file/DBNAME].sql.gz
[/path_to_mysql/]mysql -u [USERNAME] -p

Be very aware of what you are doing in the next steps since it involves a drop. And when you drop the wrong database, all that’s left is the cold sweat on your forehead.

SHOW DATABASES;
DROP DATABASE [DBNAME];
CREATE DATABASE [DBNAME];
USE [DBNAME];
SOURCE [/path_to_file/DBNAME].sql;

Done.

Saucysauce and more about conditional dumping: https://www.lullabot.com/articles/importexport-large-mysql-databases