Monday, March 30, 2020

Windows Administrator Interview Questions

  1. Answer :
    Active Directory provides a centralised control for network administration and security. Server computers configured with Active Directory are known as domain controllers. Active Directory stores all information and settings for a deployment in a central database, and allows administrators to assign policies and deploy and update software.
  2. Answer :
    A domain is defined as a logical group of network objects (computers, users, devices) that share the same Active Directory database. A tree can have multiple domains.

Answer :
A domain controller (DC) or network domain controller is a Windows-based computer system that is used for storing user account data in a central database. It is the centrepiece of the Windows Active Directory service that authenticates users, stores user account information and enforces security policy for a Windows domain.
A domain controller allows system administrators to grant or deny users access to system resources, such as printers, documents, folders, network locations, etc., via a single username and password.

Answer :
Group Policy allows you to implement specific configurations for users and computers. Group Policy settings are contained in Group Policy objects (GPOs), which are linked to the following Active Directory service containers: sites, domains, or organizational units (OUs).

Answer :
A Group Policy Object (GPO) is a collection of settings that control the working environment of user accounts and computer accounts. GPOs define registry-based policies, security options, software installation and maintenance options, script options, and folder redirection options.
There are two kinds of Group Policy objects:
  • Local Group Policy objects are stored on individual computers.
  • Nonlocal Group Policy objects, which are stored on a domain controller, are available only in an Active Directory environment.
Answer :
A GLDAP (Light-Weight Directory Access Protocol) determines how an object in an Active Directory should be named. LDAP is the industry standard directory access protocol, making Active Directory widely accessible to management and query applications. Active Directory supports LDAPv2 and LDAPv3.
  1. Answer :
    The AD database is stored in C:WindowsNTDSNTDS.DIT.
    1. Answer :
      The SYSVOL folder stores the server copy of the domain’s public files that must be shared for common access and replication throughout a domain.
      All AD databases are stored in a SYSVOL folder and it’s only created in an NTFS partition. The Active Directory Database is stored in the %SYSTEM ROOT%NDTS folder.
    2. Answer :
      Garbage collection is the online defragmentation of the Active Directory which happens every 12 hours.
      1. Answer :
        Windows Deployment Services is a server role used to deploy Windows operating systems remotely. WDS is mainly used for network-based OS installations to set up new computers.
      2. Answer :
        Email servers can be of two types:
        Incoming Mail Server (POP3, IMAP, HTTP): The incoming mail server is the server associated with an email address account. There cannot be more than one incoming mail server for an email account. In order to download your emails, you must have the correct settings configured in your email client program.
        Outgoing Mail Server (SMTP): Most outgoing mail servers use SMTP (Simple Mail Transfer Protocol) for sending emails. The outgoing mail server can belong to your ISP or to the server where you setup your email account.
        The main email ports are:
        POP3 – port 110
        IMAP – port 143
        SMTP – port 25
        HTTP – port 80
        Secure SMTP (SSMTP) – port 465
        Secure IMAP (IMAP4-SSL) – port 585
        IMAP4 over SSL (IMAPS) – port 993
        Secure POP3 (SSL-POP) – port 995

Sunday, June 30, 2013

Increase maximum size pst-files with Outlook 2007

Pst  default Size Information :How do I increase the maximum file size of an UNICODE pst file. The default size is 20 GB but as far as I know there must be a registry value that allows to increase the maximum up to approximately 4TB.



his tip does not apply to pst-files who are in the Outlook 97-2002 format (ANSI formatted pst-files).


Procedure for the Registry settings :

You need to go to the following location in the Registry;
  • Outlook 2003
    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\PST
  • Outlook 2007
    HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook\PST
  • Outlook 2010
    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\PST
Here you must create and set 2 new DWORD values (note that these values are case sensitive);
  • WarnLargeFileSize
    Don’t set this higher than 4090445042 (decimal) or f3cf3cf2 (hexadecimal)
  • MaxLargeFileSize
    Don’t set this higher than 4294967295 (decimal) or ffffffff (hexadecimal)
The first value is how many MB a user can write to a pst-file. The second value is how many MB the system can write to a pst-file. This difference has to be at least 5% since there is more written to a pst-file than just user data.

Registry Editor - Increase the maximum size of your pst-file via the MaxLargeSize key.
the maximum size of a pst-file has been set to 100GB with a warning at 95GB from the above settings.


Post installation of Fedora -Linux first steps

Post installation of Fedora -Linux first step to be performed


Open a terminal.
Become superuser by entering 'su' and then the password.
Then,
# cd /var/run/
# ls
Look for the 'yum.pid' file.
# rm -f yum.pid
# ls
Confirm that the 'yum.pid' file has been deleted.
# yum update
This should re-start your update process

TO UNINSTALL OPENJDK AND INSTALL JDK with Fedora


 PURPOSE: TO UNINSTALL OPENJDK AND INSTALL JDK with Fedora 16 & others

*********** STEP 1 STARTS ***********

  ==:> remove open jdk  <: span="">

1)   to find installed java packages:   rpm -qa | grep java

2)  to uninstall open jdk :   yum remove java-1.6.0-openjdk-1.6.0.0-68.1.11.5.fc16.x86_64


***********STEP 1 ENDS  ***********
   

*********** STEP 2 STARTS ***********

 ==:>  install jdk on fedora  <: span="">

rpm -Uvh /jdk-7u9-linux-x64.rpm

rpm -Uvh /jre-7u9-linux-x64.rpm

## java ##
alternatives --install /usr/bin/java java /usr/java/latest/jre/bin/java 20000
## javaws ##
alternatives --install /usr/bin/javaws javaws /usr/java/latest/jre/bin/javaws 20000
 
## Java Browser (Mozilla) Plugin 64-bit ##
alternatives --install /usr/lib64/mozilla/plugins/libjavaplugin.so libjavaplugin.so.x86_64 /usr/java/latest/jre/lib/amd64/libnpjp2.so 20000
 
## Install javac only if you installed JDK (Java Development Kit) package ##
alternatives --install /usr/bin/javac javac /usr/java/latest/bin/javac 20000
alternatives --install /usr/bin/jar jar /usr/java/latest/bin/jar 20000

alternatives --config java

Enter to keep the current selection[+], or type selection number: 
Note: java with [+] is currently on use

alternatives --config javaws

alternatives --config libjavaplugin.so

alternatives --config libjavaplugin.so.x86_64

alternatives --config javac

*********** STEP 2 STARTS ***********

*********** STEP 3 STARTS ***********
 

 ==:>  set classpath in fedora <: span="">

vi ~/.bash_profile
export JAVA_HOME=/usr/java/jdk1.5.0_07/bin
export PATH=$PATH:/usr/java/jdk1.5.0_07/bin

$ source ~/.bash_profile or  . ~/.bash_profile


 ** * Set JAVA_HOME / PATH for all user

You need to setup global config in /etc/profile OR /etc/bash.bashrc file for all users:
# vi /etc/profile

Next setup PATH / JAVA_PATH variables as follows:

export PATH=$PATH:/usr/java/jdk1.5.0_07/bin
export PATH=$PATH:/usr/java/jdk1.5.0_07/bin

Save and close the file. Once again you need to type the following command to activate the path settings immediately:
# source /etc/profile 

Install Fonts in Fedora

Sunday, July 29, 2012

Installation of Mysql in fedora 16


Install MySQL 5.5.25a on Fedora 17/16, CentOS/Red Hat (RHEL) 6.3/5.8

MySQL LogoMySQL is a relational database management system (RDBMS) that runs as a serverproviding multi-user access to a number of databases. This is guide, howto install or upgrade MySQL Community Server latest and greatest version 5.5.25a on Fedora 17/16/15/14/13/12, CentOS 6.3/6.2/6.1/6/5.8 and Red Hat (RHEL) 6.3/6.2/6.1/6/5.8.
Note: If you are upgrading MySQL (from earlier version), then make sure that you backup (dump and copy) your database and configs. And remember run mysql_upgradecommand.

Install MySQL Database 5.5.25a on Fedora 17/16/15/14/13/12, CentOS 6.3/5.8, Red Hat (RHEL) 6.3/5.8

1. Change root user

su -
## OR ##
sudo -i

2. Install Remi repository

Fedora

## Remi Dependency on Fedora 17, 16
rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm 
rpm -Uvh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm
 
## Fedora 17 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-17.rpm
 
## Fedora 16 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-16.rpm
 
## Fedora 15 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-15.rpm
 
## Fedora 14 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-14.rpm
 
## Fedora 13 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-13.rpm
 
## Fedora 12 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-12.rpm

CentOS and Red Hat (RHEL)

## Remi Dependency on CentOS 6 and Red Hat (RHEL) 6 ##
rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpm
 
## CentOS 6 and Red Hat (RHEL) 6 ##
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
 
 
## Remi Dependency on CentOS 5 and Red Hat (RHEL) 5 ##
rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
 
## CentOS 5 and Red Hat (RHEL) 5 ## 
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm

3. Check Available MySQL versions

Fedora 17, 16, 15, 14, 13, 12

yum --enablerepo=remi list mysql mysql-server

CentOS 6.3/6.2/6.1/6/5.8 and Red Hat (RHEL) 6.3/6.2/6.1/6/5.8

yum --enablerepo=remi,remi-test list mysql mysql-server
Output:
Loaded plugins: changelog, fastestmirror, presto, refresh-packagekit
...
remi                                                            | 3.0 kB     00:00     
remi/primary_db                                                 | 106 kB     00:00     
Available Packages
mysql.i686                               5.5.25-1.fc14.remi                        @remi
mysql-server.i686                        5.5.25-1.fc14.remi                        @remi

4. Update or Install MySQL 5.5.25a

Fedora 17, 16, 15, 14, 13, 12

yum --enablerepo=remi install mysql mysql-server

CentOS 6.3/6.2/6.1/6/5.8 and Red Hat (RHEL) 6.3/6.2/6.1/6/5.8

yum --enablerepo=remi,remi-test install mysql mysql-server

5. Start MySQL server and autostart MySQL on boot

Fedora 17/16

systemctl start mysqld.service ## use restart after update
 
systemctl enable mysqld.service

Fedora 15/14/13/12/11, CentOS 6.3/6.2/6.1/6/5.8 and Red Hat (RHEL) 6.3/6.2/6.1/6/5.8

/etc/init.d/mysqld start ## use restart after update
## OR ##
service mysqld start ## use restart after update
 
chkconfig --levels 235 mysqld on

6. MySQL Secure Installation

  • Set (Change) root password
  • Remove anonymous users
  • Disallow root login remotely
  • Remove test database and access to it
  • Reload privilege tables

Start MySQL Secure Installation with following command

/usr/bin/mysql_secure_installation
Output:
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!
 
 
In order to log into MySQL to secure it, we\'ll need the current
password for the root user.  If you\'ve just installed MySQL, and
you haven\'t set the root password yet, the password will be blank,
so you should just press enter here.
 
Enter current password for root (enter for none): 
OK, successfully used password, moving on...
 
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
 
Set root password? [Y/n] Y
New password: 
Re-enter new password: 
Password updated successfully!
Reloading privilege tables..
 ... Success!
 
 
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.
 
Remove anonymous users? [Y/n] Y
 ... Success!
 
Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.
 
Disallow root login remotely? [Y/n] Y
 ... Success!
 
By default, MySQL comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.
 
Remove test database and access to it? [Y/n] Y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!
 
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
 
Reload privilege tables now? [Y/n] Y
 ... Success!
 
Cleaning up...
 
 
 
All done!  If you\'ve completed all of the above steps, your MySQL
installation should now be secure.
 
Thanks for using MySQL!
Note: If you don’t want some reason, do a “MySQL Secure Installation” then at least it’s very important to change the root user’s password
mysqladmin -u root password [your_password_here]
 
## Example ##
mysqladmin -u root password myownsecrectpass

7. Connect to MySQL database (localhost) with password

mysql -u root -p
 
## OR ##
mysql -h localhost -u root -p

8. Create Database, Create MySQL User and Enable Remote Connections to MySQL Database

This example uses following parameters:
  • DB_NAME = webdb
  • USER_NAME = webdb_user
  • REMOTE_IP = 10.0.15.25
  • PASSWORD = password123
  • PERMISSIONS = ALL
## CREATE DATABASE ##
mysql> CREATE DATABASE webdb;
 
## CREATE USER ##
mysql> CREATE USER 'webdb_user'@'10.0.15.25' IDENTIFIED BY 'password123';
 
## GRANT PERMISSIONS ##
mysql> GRANT ALL ON webdb.* TO webdb_user@'10.0.15.25';
 
##  FLUSH PRIVILEGES, Tell the server TO reload the GRANT TABLES  ##
mysql> FLUSH PRIVILEGES;

Enable Remote Connection to MySQL Server –> Open MySQL Port (3306) on Iptables Firewall (as root user again)

1. Edit /etc/sysconfig/iptables file:

nano -w /etc/sysconfig/iptables

2. Add following line before COMMIT:

-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

3. Restart Iptables Firewall:

service iptables restart
## OR ##
/etc/init.d/iptables restart

4. Test remote connection:

mysql -h dbserver_name_or_ip_address -u webdb_user -p webdb