Upgrade an Arabic vbulletin 3.x to 5.x and convert it's mysql data from cp1256/latin1 to utf8

Back in 2009 internet was full of community forums to the point where every person would install forum and make his own community especially here in Iraq. a lot of communities were powered by vbulletin software and most of them died. however there are some sites that still up today. Last week I was tasked to upgrade one of those sites from vbulletin 3.8 to vbulletin 5.7 . so I grabbed a copy of its database, Started an upgrade simulation and BOOM nothing works as intended. Let me explain a step by step process, first of all the vbulletin 5.7 requires mysql 8.0 to actually work but vbulletin 3.8 won't work on mysql 8.0 because it sets utf-8 chraset on new connections so you have edit vbulletin 3.8 config file located here includes/config.php Uncomment and modify this line as shown below $config['Mysqli']['charset'] = 'latin1'; The above line shall run your vbulletin 3.8 on mysql 8.0 without gibberish characters. Why latin1 ? Si

Install team based password manager on debian 10

So I needed a team based password manager and I stumbled upon this open source Django based project called PSONO . Since their documentation has docker based installation I created my own guide on how to install both front-end and back-end along with nginx, LetsEncrypt free SSL on single Debian 10 instance .

Install DSpace-CRIS 7 along with Free SSL and Nginx

One of my clients requested a full installation of DSpace-CRIS 7 on his server. below are the steps I followed to deliver his request, you will need about 4GB of RAM to compile DSpace-Angular front-end.

My notes on RedHat Certified System Administrator (RHCSA) EX200V8 Exam

Below are my notes on RHCSA EX200V8 exam objectives that I researched and collected from multi online sources when I was preparing to take my EX200V8 . it may help you get an idea of what is waiting for you . Understand and use essential tools Access a shell prompt and issue commands with correct syntax # system has 6 virtual console we can switch between them using ctrl + alt + f1 to f6. you can also use chvt 2 to change to virtual console number 2 # tty1 is for gui if installed and the other are for terminal based consoles. # ctrl + a => go to the start of the command line # ctrl + e => go to the end of the command line # ctrl + r => search history backward # ctrl + l => clear screen # !3 => runs 3rd command from history list # ^foo^bar => replace foo with bar in last command # everything in .bash_logout file will executed on logout # everything in .bash_profile file will be executed on login # to enter into login shell through su su - Use input

CEPH Bluestore WAL/DB on Software RAID1 for redundancy

As you may already know CEPH is not recommended to be installed over hardware/software RAID due to performance issues. but in this scenario and I will quote CEPH documentation : If there is a mix of fast and slow devices (spinning and solid state), it is recommended to place block.db on the faster device while block (data) lives on the slower (spinning drive). The block.db/wal if added on faster device (ssd/nvme) and that fast device dies out you will lose all OSDs using that ssd. And based on your used CRUSH rule such event might lose all your data. so the best solution to mitigate such event is to use RAID1 for that fast device holding your block.db/wal data. If you have hardware RAID then it should be an easy task but if you don't have hardware RAID then I used this on one of my implementations:/ # Assuming we have 1TB HDD OSD pvcreate /dev/sdc # change 01 to 02 for your second OSD v

Hello world!

 This is my first post apparently.