Author Archives: site admin

SHA-1 is no longer considered secure

Posted on Thursday, 29 February 2024 by site admin

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

Posted on Thursday, 25 January 2024 by site admin

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

Posted on Sunday, 14 January 2024 by site admin

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

Posted on Saturday, 6 January 2024 by site admin

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

Tahun 2022

Posted on Saturday, 8 January 2022 by site admin

Tahun baru 2022 sudah tiba, banyak perubahan terjadi beberapa tahun kebelakang, ada covid-19 dan ada juga cryptocurrency. Harapan dan doa saya semoga covid-19 segera berakhir, vaksinasi di Indonesia juga menurut saya progressnya cukup baik dan bagus, penting sekali ini. Selain … Continue reading →

Posted in my life | Leave a comment