Author Archives: site admin

Setting Up the CentOS 7 Vault Repository

Sometimes, there’s a clear reason to install an older operating system. For me, it’s to run old applications or websites that only work with older software. Recently, I installed CentOS 7 minimal as a virtual machine. To install or update … Continue reading

Posted in linux, my life | Leave a comment

SHA-1 is no longer considered secure

So, you’re trying to log in to your server using your SSH key, but you’re getting a mysterious error message instead: “userauth_pubkey: key type ssh-rsa not in PubkeyAcceptedAlgorithms [preauth]“. Frustrating, right? Don’t worry, you’re not locked out forever. A quick … Continue reading

Posted in linux, my life | Leave a comment

regular expression untuk NIP PNS Indonesia

Beberapa waktu lalu ada pertanyaan di komunitas bagaimana regular expression untuk NIP PNS Indonesia? Jadi NIP PNS Indonesia itu ada 18 digit angka semua yaitu terdiri dari 8 angka tahun bulan tanggal lahir ybs (dari tahun 1900 s.d 2099), 6 … Continue reading

Posted in linux | Leave a comment

cara copy ssh publik key ke server tujuan/remote pakai command ssh-copy-id

oke, jadi biasanya saya kalau ssh ke server remote memang sudah pakai ssh key aja, males bolak-balik ngetikin password kalau mau nge-remote ke server dan memang cara ini lebih aman daripada pakai password tapi dengan catatan jangan sampai private key … Continue reading

Posted in linux | Leave a comment

how to sort data in alias column on mysql

so i have been learning mysql syntax about a 5 days now and there is this LENGTH function in mysql that count string length in the column like this: SELECT id, LOWER(NAME) AS ‘Name Lower’, LENGTH(NAME) AS ‘Name Length’ FROM … Continue reading

Posted in mysql | mariadb | Leave a comment