copy contents of .pub key from /root/.ssh
open gitlab > settings > ssh keys
paste key in field, give title, press add key
git clone https://github.com/twolfson/sexy-bash-prompt.git
cd sexy-bash-prompt && make install && source ~/.bashrc
enter root password
curl -sL https://deb.nodesource.com/setup_12.x | bash -
apt-get install -y nodejs
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
- Open theme folder on the server:
index.php for editing in any html or text editor;
- 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';
data.php file for editing and follow step 4;
manifest.php file for editing and follow step 4;
- start Themler.
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”.
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
files:scan [-p|--path="..."] [-q|--quiet] [-v|vv|vvv --verbose] [--all]
[user_id1] ... [user_idN]
user_id will rescan all files of the given user(s)
--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
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:
Put the files you wish to convert into SRC and type the following command:
Wait until done, then you’re done! 🙂
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.
mysqldump -u [USERNAME] -p [DBNAME] | gzip > [/path_to_file/DBNAME].sql.gz
Copy the file over to 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.
DROP DATABASE [DBNAME];
CREATE DATABASE [DBNAME];
Saucysauce and more about conditional dumping: https://www.lullabot.com/articles/importexport-large-mysql-databases