Tuesday, July 23, 2019

Install Bugzilla on Linux 7

    Bugzilla is a free and open source web-based bug tracker and testing software tool developed by the Mozilla Foundation. It is written in Perl, and uses MySQL as its database back-end. Key features of Bugzilla are listed below:

    1. Email integration capability.
    2. Optimized, well-structured and secure system.
    3. Easily remember your searches using advanced query tool.
    4. Easily edit user profiles.
    5. Comprehensive permission based system.

    # sudo yum update -y



    Install LAMP

    Let us install the Apache web server, MariaDB, and other required packages on the system.

    You can install all of them by running the following command:

    # sudo yum install httpd mariadb mariadb-server httpd-devel mod_ssl mod_ssl mod_perl mod_perl-devel mariadb-devel php-mysql gcc gcc-c++ graphviz graphviz-devel patchutils gd gd-devel wget perl* -y

    Once all the packages are installed including their dependencies, start the Apache and MariaDB services and enable them to start on boot with the following commands:

    # sudo systemctl start httpd

    # sudo systemctl start mariadb

    # sudo systemctl enable httpd

    # sudo systemctl enable mariadb

    Configure MariaDB Database

    Our MariaDB installation needs to be secured. To do so, run the mysql_secure_installation script:

    # sudo mysql_secure_installation

    # mysql -u root –p

    Enter the root password when asked, then create a new database for Bugzilla:

    MariaDB [(none)]> CREATE DATABASE bugzilla;

    Create a database user and password for Bugzilla:

    MariaDB [(none)]>CREATE USER bugs@'localhost' IDENTIFIED BY 'Password';

    MariaDB [(none)]>GRANT ALL PRIVILEGES ON bugzilla.* TO 'bugs'@'localhost' IDENTIFIED BY 'Password' WITH GRANT OPTION;

    MariaDB [(none)]>FLUSH PRIVILEGES;

    MariaDB [(none)]>exit;

    Make a soft where we download or copy the setup

    # mkdir dir

    Give permission to the folder

    # chmod 777 dir/

    # cd /dir/

    Once you are done, you can proceed to install Bugzilla.

    Install Bugzilla

    You can download the latest version of the Bugzilla with the wget command:

    # wget http://ftp.mozilla.org/pub/webtools/bugzilla-5.0.tar.gz

    Once the download is complete, extract the downloaded archive with the tar command:

    # tar -xvzf bugzilla-5.0.tar.gz

    Move the extracted directory into the Apache web root directory:

    # sudo mv bugzilla-5.0 /var/www/html/Bugzilla

    Set proper permissions on the bugzilla directory:

    # sudo chown -R apache:apache /var/www/html/Bugzilla

    You will also need to install all necessary Perl modules in your system.

    Change into the bugzilla directory:

    # cd /var/www/html/bugzilla/

    Install all the required Perl modules with the following command:

    # sudo /usr/bin/perl install-module.pl –all

    Now, Run

    ./checksetup.pl

    Prompt to edit

    Please edit the file ./localconfig and then re-run checksetup.pl

    you will need to edit localconfig file:

    # vi /var/www/html/Bugzilla/localconfig

    Change the file as shown below:

    $db_host = 'localhost';

    $db_name = 'bugzilla';

    $db_user = 'bugs';

    $db_pass = 'Password';

    Save and close the file when you are finished.

    Run the checksetup.pl perl script to install Bugzilla:

    # sudo ./checksetup.pl

    “Enter the e-mail address of the administrator: email ID

    Enter the real name of the administrator: name

    Enter a password for the administrator account:

    Please retype the password to verify:

    email ID is now set up as an administrator.

    Creating initial dummy product 'TestProduct'...

    Now that you have installed Bugzilla, you should visit the 'Parameters'

    page (linked in the footer of the Administrator account) to ensure it

    is set up as you wish - this includes setting the 'urlbase' option to

    the correct URL.

    checksetup.pl complete.“

    Comment out a line in the .htaccess file that the Bugzilla installation script created:

    # sudo sed -i 's/^Options -Indexes$/#Options -Indexes/g' ./.htaccess

    Configure Apache for Bugzilla

    Let's create a new virtualhost directive for Bugzilla. You can do this by creating the file /etc/httpd/conf.d/bugzilla.conf:

    # vi /etc/httpd/conf.d/bugzilla.conf

    Add the following lines:

    <VirtualHost *:80>

    DocumentRoot /var/www/html/bugzilla/

    </VirtualHost>

    <Directory /var/www/html/bugzilla>

    AddHandler cgi-script .cgi

    Options +Indexes +ExecCGI

    DirectoryIndex index.cgi

    AllowOverride Limit FileInfo Indexes

    </Directory>

    Save the file and restart Apache's httpd service for the changes to take effect:

    # sudo systemctl restart httpd

    Disable and stop Firewall

    # systemctl disable firewalld.service

    # systemctl stop firewalld.service

    Disable selinux

    # vi /etc/syscofig/selinux

    Access Bugzilla

    Once everything is setup properly, it is time to access Bugzilla.

    Open your favourite web browser and type the URL http://localhost, you should see the Bugzilla welcome page as below:

    Click on the Log In button and provide your username and password. You should see the Bugzilla Main page as below:

Tuesday, February 26, 2019

Install Active Directory in Windows Server 2012 R2


Installing Apache HTTPD web server with PHP and OpenSSL support on Windows


Apache HTTPD

Fresh Apache HTTPD binaries can be found on Apache Lounge site. Note that you will need the binary compiled with OpenSSL 0.9.8 to work with our future PHP installation. Also, there is a link to VC10 redistributable somewhere at the top part of the download page. Make sure to grab it and install on your Windows before you start with Apache HTTPD installation and configuration.

Go to C:\Apache24\bin

Just extract the content of the package and move “Apache24” directory to the “C:” drive. You can start the web server by running “httpd.exe” from “C:\Apache24\bin” folder. In the same folder you can find useful ApacheMonitor utility, which allows you to start and stop the server conveniently. I recommend to create a shortcut to this utility and place it to the startup folder (either yours or for all users). Also, Apache HTTPD can be set up to run as a service on system startup by executing “C:\Apache24\bin\httpd.exe -k install” command.


The easiest way to start Apache is to add it as a Windows service.

 

Monday, February 25, 2019

Skype for business not saving conversations


    Method 1 :

    To turn on the option for storing chat history:
    1. Open Skype for Business/Lync and sign in. 
    2. Click Show Menu arrow next to the gear icon in the top right and select Tools > Options > Personal.
    1. On the Personal tab, choose Microsoft Exchange or Microsoft Outlook from drop-down menu and select Save my IM conversations in my email Conversation History folder. Click OK.

    1. Sign out of Skype for Business/Lync (choose drop-down menu next to Availability Status > Sign Out), then sign back in to apply changes.
    2. All future chats will be saved in the Conversation History folder. You can open this folder in Outlook or OWA. 
    Note: if there are more than 1000 folders in the mailbox, saving chat conversations feature may not work correctly.
    If the checkbox Save IM conversations in my email Conversation History folder is greyed out, perform the following steps:
    1. Open regedit: to do so, click the Start button and then in the Start Menu, either in the Run box or in the Search box, type regedit and press Enter

    1. Create the registry backup.
      Note: you can skip this step, however, we highly recommend to back up the registry before you proceed to modifying its entries.
    2. Navigate to HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\Office\x.0\Lync (x.0 corresponds to the Office version: 16.0 = Office 2016, 15.0 = Office 2013, 14.0 = Office 2010)
    3. Remove a DWORD entry named IMAutoArchivingPolicy.
      Note: If IMAutoArchivingPolicy has value of 0 the box will be unchecked and greyed out. If IMAutoArchivingPolicy has value of 1, the box will be checked and greyed out.
    4. Reboot your machine. After a reboot you should be able to check the box Save IM conversations in my email Conversation History folder.

    Method 2 :
    1. For SFB client, choose option, go to Personal Tab and make sure “Save IM Conversation in my Email      Conversation History Folder” box is checked

    1. Exit Lync Client
       Backup your old “Conversation History” folder contains in Outlook (export it to a file)
       Delete the “Conversation History” folder and close “outlook”
       Make sure that Lync and outlook are completely closed and no processes are running in the Task Manager
       Start “run” and type in outlook /resetfolders
       Start Lync, and test (wait 10 minutes for the folder to start saving)

    Method 3 :

    Start Window update and update the window with latest updates. That will automatically resolved.


Oracle Database 19c Installation on Oracle Linux 7

Pre-installation settings before installing Oracle Database 19c SELinux If the OS is to be used for an Oracle installation, it is ...