net stop spooler
DEL /F /S c:\Windows\System32\spool\PRINTERS\*
net start spooler
Easy peasy.
Failed and working projects, notes etc.
net stop spooler
DEL /F /S c:\Windows\System32\spool\PRINTERS\*
net start spooler
Easy peasy.
Virtualmin is a rock solid control panel for your VPS, it’s simple as that. It’s sometimes not so simple to set it up correctly due to its many options.
I’ve tried my best to make a decent manual that explains how to set up a domain and email in a quick and dirty way. I’m not talking about security and stuff yet. It’s just about setting things up.
I am also assuming your freshly (re)built VPS has a root password set and that you are now ssh-ing into it. If not, do it now.
ifconfig
It’s probably venet0 (that’s venetzero)
apt-get update
apt-get install wget nano curl ca-certificates -y
cd ~
wget http://software.virtualmin.com/gpl/scripts/install.sh
sudo /bin/sh install.sh
@ 1000 MX 10 mail.domainname.tld * 1000 A 0 VPS_IP_ADDRESS @ 1000 A 0 VPS_IP_ADDRESS ftp 1000 A 0 VPS_IP_ADDRESS localhost 1000 A 0 127.0.0.1 mail 1000 A 0 VPS_IP_ADDRESS pop 1000 A 0 VPS_IP_ADDRESS www 1000 A 0 VPS_IP_ADDRESS
Don’t worry about the SPF, domainkey, the acme-challenge and the dmarc yet.
All should be ready now and you should see a few success messages. If not, go fix.
apt-get update
apt-get upgrade -y
apt-get dist-upgrade -y
apt-get autoremove
apt-get autoclean
https://HOSTNAME:10000
Virtualmin is configured to setup DNS zones, but this system is not setup to use itself as a DNS server. Either add 127.0.0.1 to the list of DNS servers, or turn off the BIND feature on the module config page.
Click list of DNS servers and add 127.0.0.1 in the DNS Servers field and press Save. Next, click Apply Configuration. Then, click the Virtualmin on top, click System Settings and then Re-check Configuration.
Your Virtualmin installation is now ready to had domain names etc added.
DOMAINNAME 1000 TXT 0 v=spf1 a mx a:DOMAINNAME.TLD ip4:IPADDRESS1 ip4:IPADDRESS2 ?all
For the acme challenges:
_acme-challenge.mail 1000 TXT 0 RANDOMSTRING_OFCHARACTERS _acme-challenge 1000 TXT 0 RANDOMSTRING_OFCHARACTERS
Error requesting challenges: Error creating new authz :: too many failed authorizations recently: see https://letsencrypt.org/docs/rate-limits/
Now this has been set up, you can poke your DNS settings again! Woo!
Now, clean up the rest in Notepad++:
“v=DKIM1; k=rsa; t=s; p=MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAq8/I4PwduFS/q” “U4y6pDFNFYf868Z2p+BNw+QRMphZ6YnVt1MWeVtNIXnYvhUtf6jhAX2BZ5gl8R2ILyL9NCkFe8W5cAVR” “/cZkZl6OIc7fdTiLePYNCS3HcVcTiE0Szb3zwDRAZE2XyAqFvNQJuVe/H5tJxlOAu1vhqv3FuZM1viv9” “VfiPQ77oQ9eOmQMZH59+QL/Vw4fnUnui4QhqRaH+iLb1bQdcJqIu1y3M+bgSCmrSu7v40V1G+wmUY13J” “fg41SIvYbuEe+CGjwMjVW0KFC15x3m5ChwM3q68b5gBv0L+JeMG27+DDQ5CSUIZSAJU0XifyeAfTIfRe” “5L+Bec7hQIDAQAB”
VALIDATE and install FAIL2BAN
(sorry, i can’t remember how to proceed this installation since the last edit was two years ago.)
Good luck.
Open Terminal
ssh-keygen, create
copy contents of .pub key from /root/.ssh
open gitlab > settings > ssh keys
paste key in field, give title, press add key
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
mkdir DST
mkdir SRC
Put the files you wish to convert into SRC and type the following command:
./bulk
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.
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