How to Import Data (tables) from Postgresql to MS Access Database using ODBC : Step by Step Tutorial

 Import Data (tables) from Postgresql to MS Access Database using ODBC : Step by Step Tutorial for data migration from one Database System to Another Database System.

Objective :- Transfer data tables form PostgresSQL database to MS Access Database.

Step1:- Create a Blank MS Access Database in your Windows system.

Step2:- Open that newly created Access database and go  the External Data tab. Next Click on the More button. Where you will find lots of options. Select the ODBC_databse form that list.

 

Step 2: Select the source and destination of data. Select the option "Import the Source Data into a new table in the current database", and click OK.

Step3: A new Popup window will appear on the screen. Click on the "Machine Data Source" tab. Here you will see the all DNS , data source names . We will select for example "BE" data source name and click OK.

Step 4: Import Objects. In this step you will find all the tables under the BE database. Click on the SELECT ALL button to select all the tables then Press the OK.

 

 Step5: Get External Data- ODBC database.All objects are imported successfully. Press the button SAVE IMPORT.

Step 7: Your data has been successfully imported form the PostgreSQL database server to your local Windows PC's Microsoft Access Database. Enjoy !!

Orange { HRM } Human Resource Management Open Source Software installation Process

 Orange HRM Software Installation Process in Your Local Windows PC

Step 1: Download the OrangeHRM for Windows.

Step 2: Install xampp server for windows. {apache, mysql}

Step 3: Now unzip the downloaded software.

A. You will find orangehrm x.x folder.

B. Copy this folder to the C:\xampp\htdocs

C. In your browser, type localhost/orangehrm-x.x

D. A configuration web based window will appear.

Step 4: Database configuration

Database to Use       | New Database|

Database host name |localhost         |

Database host port   | 3306             |

Database Name        | orangehrm_mysql |

Privileged DB user Name  | root      |

Privileged DB password    | root123 |

Use the same DB user for Orange HRM .Yes

OrangeHRM DB username |orangehrm|

OrangeHRM DB userpassword |orange 123|

Enable database encryption .Yes

NB:- In our configuration we did not give any Root Password for my SQL database. So leave the Privilege DB password file as blank.

Step 5: System Check

Step 6: Admin User Creation

Orange HRM Admin ID | Admin |

Orange HRM Admin Password |Admin1234|

Step 7: Press Next

Step 8: Installing ..........

Step 9: Next

Step 10. Registration ? , No Thanks...

How to install Eclips PHP IDE software in Windows System for Software Development

 Q. How to install Eclips PHP software in Windows System ?

Ans: 

Step 1: Download the Eclips PHP. (www.eclips.org)

Step 2: Unzipe the folder and copy the folder to the appropriate drive.

Step 3: Rename of eclips-php.

Step 4: Make a short cut to Desktop.

Step 5: Click on the setup icon and it will automatically installed the software for you.

Step 6: Next, when you first Run the eclips, then it will ask you to give the work space path.

Step 7: That Path should be "xampp / htdoc " folder. Otherwise it will not display in browser.

Note: Before install PHP, Download the xampp software  and install it in your Windows System.

NB:- An integrated development environment (IDE) is software for building applications that combines common developer tools into a single graphical user interface (GUI).

 

 

How to Upload a New Module in Drupal Content Management System ?

 Q. How to Upload a New Module in Drupal Content Management System ?

Ans: Go to the Module tab and check the Update Manager and save it. Otherwise you can't upload new modules in drupal CMS. 

 

How to configure the MRTG to Poll multiple devices in Linux Operating System ?

 Getting MRTG (Multi Router Traffic Grapher) to Poll multiple network devices.

The Fedora Core MRTG installation process create a CORN file named /etc/corn.d/mrtg . This file tells the corn daemon to run MRTG using /etc/mrtg/mrtg.cfg file every 5 minutes to poll your network devices. You can configure MRTG to poll multiple devices, each with a separate configuration file.

1. Create a new configuration file using the steps from the previous section, choose a file name that is not mrtg.cfg

2. Add a new MRTG lene in / etc/corn.d/mrtg for each new configuration file you create.

0-59/5 **** root env LANG=C /usr/bin/mrtg  /etc/mrtg/mrtg.cfg

0-59/5 **** root env LANG=C /usr/bin/mrtg /etc/mrtg/dervice1.cfg

0-59/5 **** root env LANG=C /usr/bin/mrtg /etc/mrtg/device2.cfg

3.Run the indexmaker command, and include all of your /etc/mrtg configuration files.

4. Other versions of Linux keep their MRTG corn entries inside /etc/corntab file. Edit this file using the same syntex.

Now , restart the corn demon as 

root # service cornd restart.

Free software for Monitoring Network Performance - MRTG [Multi Router Traffic Grapher]

 MRTG [Multi Router Traffic Grapher]  is a Free Software for Monitoring Network Performance in Graphical form. Here we will discuss the installation process of this free software in Linux distribution.

For Linux System ,we need to install the following software

1. MRTG [latest version]
2. SNMP
3. Apache Web Server 

MRTG

How to Configure the MRTG ?

When MRTG's rpm is installed, it creates a directory called /etc/mrtg.

To create a replacement, default /etc/mrtg/mrtg.cfg configuration file for server , follow these steps,

1.Use MRTG's cfgmaker command to create a configuration file named mrtg.cfg for the server. Using a read only community string of craz33guy. Place all data files in the directory /var/www/mrtg.

root#cfgmaker --output=/etc/mrtg/mrtg.cfg

--global"varkdir: /var/www/mrtg" -ifref=ip

--blobal 'option[.] : growright, bits

crez33guy@localhost

NOTE :- -if ref=ip cfgmaker command option instruct MRTG to use the interface's IP address as the title for each graph.

2. Edit /etc/mrtg/mrtg.cfg, and remove the section related to interfaces you don't need to monitor. A certain candidate would be the virtual lookup interface LO: (127.0.0.1)

3. Run MRTG using /etc/mrtg/mrtg.cfg as your argument 3 times. You will get an error for 2 times, as MRTG tries to move old data files, and naturally the 1st time when it runs the MRTG , it has no data to move.

root# env LANG=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg

-> give this command 3 times

4. Use MRTG's indexmaker command to create a Web index page using your new mrtg.cfg file as guide.

root# indexmaker --output=var/www/mrtg/index.html   /etc/mrtg/mrtg.cfg

5. MRTG is run every 5 minute by default, and the file that governs this is /etc/corn.d/mrtg. To work correctly edit this file, replacing all occurrence of /usr/bin/mrtg with env LANG = C /usr/bin/mrtg.

Do's and Don'ts of Structured LAN Cabling Network

 What is Structured Cabling & Why it is used ?

"Standard " is to define a method of connecting all types of vendors voice & data equipment, over a cabling system that uses a common media, common connectors and a common topology. This means that a building can be cabled for all its communications needs without the planner or architecture even having to know what type of equipment will be used.

There are three main cabling standards.

• EIA/TIA 568 A ---> American standard and was the first to be published on 1991.
• ISO/IEC 11801 ---> International Standard.
• CENELEC EN 50173 ---> European Standard (British version is BSEN 50173) .

TERMS:

1. Cable Tie
2. Patch Panel
3. PVC pipe of Casing
4. IO Box
5. RJ45 connectors
6. Cat 5e/6/7 cable
7. Wall mount Box.

HDSL Modem Connection & Configuration Details with Diagram

 High Bit Rate Digital Subscriber Line or HDSL Telecommunications Technology is used to transfer data over Private Copper Network or E1 digital Subscriber Line. The Download Speed of the HDSL line is 1.54 Mbps and the Upload speed is is 1.54 Mbps.

HDSL One Pair Modem Connection Diagram

Step by Step Easy Guide to Install Debian Linux

Step by Step Easy Guide to Install Debian Linux

1. Back up any existing data or documents on the hard disk where you plan to install.

2. Gather information about your computer and any needed documentation, before starting the installation.

3. Locate and/or download the installer software and any specialized driver or firmware files your machine requires.

4. Set up boot media such as CDs/DVDs/USB sticks or provide a network boot infrastructure fromwhich the installer can be booted.

5. Boot the installation system.

6. Select the installation language.

7. Activate the ethernet network connection, if available.

8. If necessary, resize existing partitions on your target harddisk to make space for the installation.

9. Create and mount the partitions on which Debian will be installed.

10. Watch the automatic download/install/setup of the base system.

11. Install a boot loader which can start up Debian GNU/Linux and/or your existing system.

12. Load the newly installed system for the first time.

Memory and Disk Space Requirements for Debian Linux installation

Memory and Disk Space Requirements for Debian Linux installation

You must have at least 80MB of memory and 580MB of hard disk space to perform a normal installation.
Note that these are fairly minimal numbers.