I did a massive bitwarden_rs to vaultwarden rename so you might have to do a little different then what this says!!
Here is how to install vaultwarden on Debian 10 with MYSQL support Below I will be writing how to install and configure vaultwarden to work with MYSQL without the need for Docker.
Install required softwre Not everything below is required, but I like to install it anyway apt install -y tmux tmux apt install -y build-essential git pkg-config libssl-dev libmariadb-dev-compat libmariadb-dev htop curl wget Install Rust curl --proto '=https' --tlsv1.
Here is a basic cheatsheet for InfluxDB I’ve learned from playing with the TIG stack
How to find the hosts in the series. You run the below command and just go through the list to find the host you want to delete. You can delete with what you know the host is, but his is nice because it will insure there wasn’t a typo
WHERE "host" = 'DESKTOP-NAME'
Here is how you actually drop the data from the DB that way it’s not displayed in Grafana anymore
This so far has been working for me to have DroneCI behind an NGiNX reverse proxy working with Gitea
NGiNX Code nano /etc/nginx/sites-available/droneci.domain.com
ln -s /etc/nginx/sites-available/droneci.domain.com /etc/nginx/sites-enabled
upstream droneci { server 127.0.0.1:8080; } server { server_name droneci.domain.com drone.domain.com; listen 443 ssl http2; ssl_certificate /etc/certs/droneci.domain.com/fullchain.crt; ssl_certificate_key /etc/certs/droneci.domain.com/key; ssl_session_cache builtin:1000 shared:SSL:10m; ssl_protocols TLSv1.2 TLSv1.3; location / { proxy_set_header X-Forwarded-For $remote_addr; proxy_set_header X-Forwarded-Proto $scheme; proxy_set_header Host droneci.domain.com; proxy_pass http://droneci; proxy_redirect off; proxy_http_version 1.1; proxy_buffering off; chunked_transfer_encoding off; } } Here is the code for the docker container docker run \ --volume=/var/lib/drone:/data \ --env=DRONE_GITEA_SERVER="https://git.
Today I was finally able to figure out how to stdin from a file for systemctl edit :-)
env SYSTEMD_EDITOR=tee sudo -E systemctl edit --system [your_unit_name] < [your_content_file] I found it HERE.
Here is how to install SSL certs using acme.sh that will work with haProxy
acme.sh \ --install-cert \ -d domain.com \ --reloadcmd \ "cat \$CERT_KEY_PATH \$CERT_FULLCHAIN_PATH >/etc/haproxy/ssl/domain.com && \ service haproxy reload"
1. Open a command prompt or PowerShell. (You shouldn’t run as admin since this is based for the specific user).
2. Copy and paste the command below into the command prompt or PowerShell for the .exe file of the WSL distro name (ex: “Debian”) you want to set the default user for, and press Enter. (You can replace root with any user you’d like)
[Ubuntu] > ubuntu config --default-user root
There’s many times when I want to send an email for testing using postfix and I can never remember how to do it. Here is how.This is super useful to make sure your SMTP relay thru AWS/Postmark is working as it should. Then you can tail /var/log/mail.log to see if it worked or if it got rejected for whatever reason.
First type the following to start sendmail
sendmail [email protected] Now we can type in or paste the following
This is very useful when you have everything redirected with NGiNX to HTTPS, but acme.sh/LetsEncrypt requires HTTP for verification.
server { listen 80; server_name DOMAIN.COM; root HTTP_ROOT; location ^~ /.well-known/acme-challenge/ { try_files $uri =404; } location / { return 301 https://DOMAIN.COM$request_uri; } }
Here’s how to create a cert/csr with more than one domain name.
First you’ll want to create the directory. I use NGiNX so I like to put my certs in /etc/nginx/ssl, but you can put yours anywhere So now we will create the directory mkdir /etc/nginx/ssl/domainName Now we will cd into the directory cd /etc/nginx/ssl/domainName Now we will paste the following in the sslConfig.txt file.
[req] default_bits = 4096 prompt = no default_md = sha256 req_extensions = req_ext distinguished_name = dn [ dn ] C=US ST=YOURstateHERE L=YOURcityHERE O=YOURorgNAMEhere CN = YOURmainDOMAINhere [ req_ext ] subjectAltName = @alt_names [ alt_names ] DNS.
Unfortunately it doesn’t appear cPanel allows you to easily change the username. Most documentation I’ve read says to use the “Rearrange an Account” option, but if you only have one disk that doesn’t seem to get you an option. The downside to this is that is doesn’t fully do a normal restore it will restore the new account to the new directory, but it will symlink the old username to the new directory.
First you have to install acme.sh. I like using acme.sh because it’s all bash based. As with all posts I take no responsibility for anything and this is more of a quick help instead of a full guide.
I have a script that I use to deploy my WordPress sites. The only thing I recommend is if you use it make sure to add the xml-rpc.php block. I haven’t added that to it yet.
I was having issues finding the correct way to add the remaining free space to the last partition (afraid to do so since it was on a live machine). I was finally able to figure it out.
Use this to see free space
parted /dev/sdX print free Then this to expand
parted /dev/sdX (parted) resizepart Partition number? ENTER NUMBER FROM ABOVE THAT HAS THE LVM End? [1075MB]? 100% (parted) q Then now since this was on a server that uses LVM you have to resize the PV
This is how to use the Xiaomi Aqara Wireless Double Button without the Xiaomi Home Hub (A ZIGBEE STICK IS STILL REQUIRED) using ZHA in Home Assistant. Other devices just work without any hard to find IDs.
ADD DEVICE TO ZHA
Go to “Configuration”
Then “ZHA”
Hit “Add Devices”
Hold down left switch while lights are blinking until the left light blinks and stops
You can now name your button and hit the back button in the upper left hand corner
This works if you’re having PiHole hand out DHCP on your network.
nano /etc/dnsmasq.d/05-no-pihole-dhcp.conf Now we need to add the following to the file. You can change 1.1.1.1 to anything you want
# Assign alternate DNS for select hosts # Set Specific Clients to be affected dhcp-mac=set:altdns,00:00:00:00:00:00 #Device 1 dhcp-mac=set:altdns,00:00:00:00:00:00 #Device 2 # Set Alternate DNS dhcp-option=tag:altdns,option:dns-server,1.1.1.1
How to use SSL tunneling on WSL and access on local machine. This is super useful when needing to VNC into a smartOS KVM VM.
ssh -L 0.0.0.0:PORT:REMOTE_IP:PORT [email protected]
This is probably useful to figure out how to reverse proxy Apache behind NGINX, but I was finally able to get NextCloud working on NGINX with no problem I like to use NGINX as my web server because that’s what I’ve always worked with. I’ve tried a couple times to get NGINX to work with NextCloud, but it would also end up not letting me log in. I did some Googleing and I guess it has something to do with how the cache is handled in NGINX.
Copied from Here
If you don’t want to do any configuration inside the guest, then the only option is a DHCP server that hands out static IP addresses. If you use bridge mode, that will probably be some external DHCP server. Consult its manual to find out how to serve static leases.
But at least in forward modes nat or route, you could use libvirt’s built-in dnsmasqd (More recent versions of libvirtd support the dnsmasq’s “dhcp-hostsfile” option).
I noticed that when trying to mount NFS upon boot it wasn’t working. After it was booted up I could run “mount -a” and everything would come up. After some googling I learned you can add “_netdev” to the mount options in /etc/fstab and it works great.
I’ve tested this on Debian and CentOS
mysql_secure_installation doesn’t seem to work on the newest Debain
After some googling I think I found what works for me.
Delete anon user
DELETE FROM mysql.user WHERE User=’';
delete non local root user
DELETE FROM mysql.user WHERE User=‘root’ AND Host NOT IN (’localhost’, ‘127.0.0.1’, ‘::1’);
drop test database
DROP DATABASE IF EXISTS test;
drop all other root users
drop user ‘root’@’localhost’;
drop user ‘root’@‘127.0.0.1’;
drop user ‘root’@’::1’;
create a new root user with password
I ended up switching to modoboa. I’ve been very happy with it on ServerCheap. I finally set up my own mail server using a couple guides. Just putting this here for my memory. Thank you to the great people who write amazing blogs.
How to set up the server
When put behind cloudflare you need to add the bellow to /etc/nginx/nginx.conf in the http { location
# CF set real ip set_real_ip_from 103.
I found this HERE. I don’t take credit I just wanted to host the zip just in case their site went down for some reason. Here is my LINK. I tried to get it to work, but it wouldn’t recognize that the button was plugged in :-(
If you wanted to use it on Linux it looks like there is a node package for it at LINK.