Thanks! this https://medium.com/@musaamin/install-moodle-4-3-on-ubuntu-22-04-a-step-by-step-tutorial-f49aec2db4f6 installation document worked like a charm, installation done is less than 15 mins except that I had to change in the VMHOST file I had put my local ip address, since it is a local install. Thanks for your help.
ServerName 192.168.2.131
DocumentRoot /var/www/lms.aminlabs.my.id/moodle-app
Options -Indexes +FollowSymLinks +MultiViews
AllowOverride All
Require all granted
ErrorLog /var/log/apache2/lms.aminlabs.my.id_error.log
CustomLog /var/log/apache2/lms.aminlabs.my.id_access.log combined
ServerName 192.168.2.131
DocumentRoot /var/www/lms.aminlabs.my.id/moodle-app
Options -Indexes +FollowSymLinks +MultiViews
AllowOverride All
Require all granted
ErrorLog /var/log/apache2/lms.aminlabs.my.id_error.log
CustomLog /var/log/apache2/lms.aminlabs.my.id_access.log combined