A New Collection of Thoughtful Learning Apps — Now Available on iOS & Android

Image
I’m excited to share a set of mobile apps I’ve recently completed and published on both the Google Play Store and the Apple App Store. These apps are designed with a simple goal in mind: to make meaningful, structured content more accessible, whether you’re studying theology or improving your English vocabulary. 📱 Now Available on Both Platforms All apps are live and available for download: Google Play Developer Page: https://play.google.com/store/apps/dev?id=5835943159853189043 Apple App Store Developer Page: https://apps.apple.com/ca/developer/q-z-l-corp/id1888794100 📖 Theology & Confession Study Apps For those interested in Reformed theology and classical Christian teachings, I’ve developed a series of apps that present foundational texts in a clean, focused reading format: The Belgic Confession Canons of Dort Heidelberg Catechism Westminster Shorter Catechism Each app is designed to provide a distraction-free experience, making it easier to read, reflect, and revisit these im...

Setup bugzilla on Ubuntu

prepare:
1 apache
$sudo apt-get install apache2
2 mysqlserver
$sudo apt-get install mysql-server
ps: after installed, you need to input password for root(user of adminstrator group, not user group, please keep the password in mind)
3 sendmail
sudo apt-get install sendmail
4 download bugzilla package from http://www.bugzilla.org/



I downloaded  bugzilla-3.6.3.tar.gz

extract the package

$tar -C /var/www/ -xvf bugzilla-3.6.3.tar.gz
rename
$mv bugzilla-3.6.3 bugzilla & cd /var/www/bugzilla/
checkset up 
$sudo perl checksetup.pl 
$/usr/bin/perl install-module.pl --all

configure bugzillla with mysql

the default database name is "bugs", the default database root account is "bugs" too(empty password by default), all these are writed in localconfig


so let's create a admin user "bugs" via mysql
enter mysql
$mysql -u root -p 
input the password I mentened before
create bugs user
$grant all on *.* to bugs@localhost identified by '';flush privileges;
create bugs database
$CREATE DATABASE bugs;

configure bugzilla with apache
modify localconfig, let $webservergroup = 'www-data'
why 'www-data', it is apache env vars in
/etc/apache2/envvars
# settings are defined via environment variables and then used in apache2ctl,
# /etc/init.d/apache2, /etc/logrotate.d/apache2, etc.
export APACHE_RUN_USER=www-data
export APACHE_RUN_GROUP=www-data


and change the owner and group of bugzilla directory.
$sudo chgrp -R root.www-data bugzilla

then do check setup again.
$sudo perl checksetup.pl
please remember the root account and password that you input in this step. 

Above all, bugzilla install and configure are done.
The last step, we need to configure appach2 server for /var/www/bugzilla

$sudo vi /etc/apache2/httpd.conf
add below content
  <Directory "/var/www/bugzilla/">
        AddHandler cgi-script .cgi 
        Options +Indexs +ExecCGI +FollowSymLinks
        DirectoryIndex index.cgi
        AllowOverride None
        Order allow,deny
        Allow from all
    </Directory>

ok, configure done, let's restart appache2 server and mysql server
$sudo /etc/init.d/apache2 restart & sudo /etc/init.d/mysql restart

let's browser bugzilla index via firefox finally
$firefox http://localhost/bugzilla

 


 


❤️ Support This Blog


If this post helped you, you can support my writing with a small donation. Thank you for reading.


Comments

Popular Posts

2026 Begins: Choosing to Stay on the Path as a Blogger

Health Checks and Scaling Strategies for Next.js in Kubernetes