Difference between function and stored procedure

storedVsfunctions

Difference between function and stored procedure

March 11, 2015March 20, 2015 Satya Prakash 1 Comment Difference between function and stored procedure, Exception can be handled by try-catch block in a Procedure whereas try-catch block cannot be used in a Function., Function must return a value but in Stored Procedure it is optional( Procedure can return zero or n values)., Functions can be called from Procedure whereas Procedures cannot be called from Function, Functions can have only input parameters for it whereas Procedures can have input/output parameters ., Functions that return tables can be treated as another rowset. This can be used in JOINs with other tables., Inline Function can be though of as views that take parameters and can be used in JOINs and other Rowset operations., Procedure allows SELECT as well as DML(INSERT/UPDATE/DELETE) statement in it whereas Function allows only SELECT statement in it., Procedures can not be utilized in a SELECT statement whereas Function can be embedded in a SELECT statement., Stored Procedures are pre-compile objects which are compiled for first time and its compiled format is saved which executes (compiled code) whenever it is called. But Function is compiled and executed, Stored Procedures cannot be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section whereas Function can be., The most important feature of stored procedures over function is to retention and reuse the execution plan while in case of function it will be compiled every time., There are many difference between function and stored procedure. In this article we will discuss about the difference between function and procedures in context of SQL Server., There are many difference between function and stored procedure. In this article we will discuss about the difference between function and procedures in context of SQL Server. Stored Procedures are pr, We can go for Transaction Management in Procedure whereas we can't go in Function.

There are many difference between function and stored procedure. In this article we will discuss about the difference between function

google chrome

Install google chrome on centos-redhat-fedora

March 9, 2015March 15, 2015 Satya Prakash 21 Comments chrome in centos, chrome in linux, Extensions) To Google Account Get iPad Interface Select Reopen All Tabs Organize Thumbnails Using Full Screen Key Copy Paste Only Text Drag and Resize Text Box on a Webpage And much more… Installation, google chome in linux, google chrome in centos, google chrome in linux, Google Chrome is a closed source web browser and it is developed by Google Inc. Google Chrome can be installed on all famous Operating system Platforms. In this article we have to learn the installati, Install google chrome on centos-redhat-fedora, run google chrome in centos, run google chrome in linux

Google Chrome is a closed source web browser and it is developed by Google Inc. Google Chrome can be installed

squid proxy server

linux Networking

squid proxy server : Basic of squid

March 8, 2015March 15, 2015 Satya Prakash 1 Comment # yum install squid, Basic of squid, ESTABLISHED, improve user experience : Squid allows Internet Providers to save on their bandwidth through content caching. Cached content means data is served locally and users will see this through faster downloa, including those accessed through HTTP and FTP. Caching frequently requested Web pages, including Windows and is licensed under the GNU GPL. Squid optimizes the data flow between client and server to improve performance and caches frequently-used content to save bandwidth. Squid can also, install squid, install squid proxy server, installation and configuration of squid, Installation of squid proxy server, introduction to squid, media files and other content accelerates response time and reduces bandwidth congestion. It reduces bandwidth and improves response times by caching and reusing frequently-requested web pages. Squid , most of which are enabled by default for simpler installation and high performance. For ISPs: Save on bandwidth, others use Squid in large-scale web proxy installations to speed up broadband and dial up internet access. Squid is being increasingly used in content delivery architectures to deliver static and stre, RELATED -m tcp -p tcp --dport 3128 -j ACCEPT Restart the firewall service # service iptables restart Client configuration Open a web browser > Tools > Internet option > Network settings > , server, squid, Squid Basic Configuration, squid instaaltion, Squid offers a rich set of traffic optimization options, Squid optimizes the data flow between client and server, squid proxy, squid proxy server, squid proxy server : Basic of squid, used by thousands of websites around the world to ease the load on their servers. Frequently-seen content is cached by Squid and served to the end-client with only a fraction of the application server, what is qquid proxy, what is squid proxy, What is squid?, What is squid? Many of you are using Squid without even knowing it! Some companies have embedded Squid in their home or office firewall devices, Why squid?

What is squid? Many of you are using Squid without even knowing it! Some companies have embedded Squid in their

ldap installation

linux Networking

Open LDAP step by step installation and configuration

March 7, 2015February 11, 2016 Satya Prakash 2 Comments Click here. http://blog.eduguru.in/ldap-basic-of-open-ldap-introduction-to-ldap/ Install Open LDAP: # yum install *openldap* -y Start the Services: # chkconfig --levels 235 ldap on # service ldap star, Convert passwd.file to ldif (LDAP Data Interchange Format) file, Create a domain ldif file (/etc/openldap/t4test.com.ldif), Create a ldap test user, Create LDAP root user password:, dc=com #2 uid: root #3 cn: Manager #4 objectClass: account Create a domain ldif file (/etc/openldap/t4test.com.ldif) # cat /etc/openldap/t4test.com.ldif dn: dc=t4test, dc=com dc: t4test description: LDAP Admin objectClass: dcObject objectClass: organizationalUnit ou: rootobject dn: ou=People, dc=com ou: People description: Users of t4test objectClass: organizationalUnit Import all users in to the LDAP Add the domain ldf file: # ldapadd -x -D "cn=Manager, dc=com' '(objectclass=*)', dc=com" -W -f /etc/openldap/root.ldif Enter LDAP Password: adding new entry "uid=root, dc=com" -W -f /etc/openldap/t4test.com.ldif Enter LDAP Password: adding new entry "dc=t4test, dc=com" #70 rootdn "cn=Manager, dc=com" #71 rootpw {SSHA}cWB1VzxDXZLf6F4pwvyNvApBQ8G/DltW Restart Services: # service ldap restart Create a test user: # useradd test1 # useradd test2 Set User's Password: # passwd test1 Changing pass, dc=com" Add the users: # ldapadd -x -D "cn=Manager, dc=com" adding new entry "ou=People, dc=com" adding new entry "uid=operator, dc=com" Repeat this for all the user. Restart the LDAP service # service ldap restart Print all the user information: # ldapsearch -x -b 'dc=t4test, dc=com"; Convert passwd.file to ldif (LDAP Data Interchange Format) file #/usr/share/openldap/migration/migrate_passwd.pl /etc/openldap/passwd.root /etc/openldap/root.ldif #/usr/share/openldap/migrati, dc=t4test, Import all users in to the LDAP, In this article we will learn about step by step installation and configuration of LDAP. To learn about Basic of LDAP, Install Open LDAP:, ldap Print all the user information:, Migrate local users to LDAP, open ldap, Open LDAP step by step installation, Open LDAP step by step installation and configuration, ou=People, Restart ldap Services:, Restart the LDAP service, Start the ldap Services:, Update /etc/openldap/slapd.conf for the root password:, Update root.ldif file for the "Manager" of LDAP Server

In this article we will learn about step by step installation and configuration of LDAP. To learn about Basic of

basic of ldap

linux Networking

LDAP : Basic of Open LDAP: Introduction to LDAP

March 7, 2015March 10, 2015 Satya Prakash 30 Comments ... Introduction to OpenLDAP Directory Services www.openldap.org/doc/admin24/intro.html This introduction is only intended to provide enough information so one might get started learning about LDAP, 2003 - This is Chapter 1: Introduction to LDAP from the book LDAP Programming, 2005 - This is the first article in a two-article series which explains LDAP directories and their usage. Part 1 is a simple primer to bring users who have ... Quick Introduction to LDAP Basics « Elec, 2007 - Although being mainly a developer, 2013 - So I'm putting this here for future me: a quick introduction to LDAP basics. Remember, 2013 | Comments. LDAP is definitely not a buzz word technology these days, and directory services. LDAP Basics - David Pashley.com www.davidpashley.com/articles/ldap-basics/ LDAP (Lightweight Directory Access Protocol) has a reputation for being ... exactly how LDAP works in, and easy to maintain., and easy to maintain. LDAP is optimized for rapid search and retrieval. LDAP databases can be massive and secure. LDAP enables the internationalization of data. Why LDAP is called lightweight? LDAP is, and integrate an LDAP environment at your company - will familiarize you ... Introduction to Lightweight Directory Access Protocol (LDAP) support.microsoft.com/kb/196455 To understand Lightweight Dire, and other resources such as files and devices in a network, at the time of ... Searches related to Introduction to LDAP introduction to ldap lightweight directory access protocol introduction to ldap example access ldap server ldap explanation history of ldap , attribute-based information. The information in a directory is generally read much more often than it is written. Directories are tuned to give quick-response to high-volume lookup or search operation, but tends to contain more descriptive, called posixAccount. Note there are GUI web based tools to make managing LDAP painless. Why LDAP? The main benefit of using LDAP is that information for an entire organization can be consolidated into, Directory databases include accounts., future me (and anyone else reading this), however a lot of organizations are still using LDAP. LDAP Tutorial - Brad Marshall's Website - HUMBUG quark.humbug.org.au/publications/ldap/ldap_tut.html Introduction to LDAP. What is LDAP; Acroynms; , I've been lately heavily exposed to LDAP and would like to give a very gentle introduction into this field, if you want to enter data inside a directory, implement, individuals, IP address, Is there Graphical editors for LDAP ?, it is a lightweight client-server protocol for accessing directory services, its a database whereby it has all the details of all of organizations, ldap, LDAP : Basic of Open LDAP: Introduction to LDAP, LDAP can be used as a central directory accessible from anywhere on the network. And because LDAP supports Secure Sockets Layer (SSL) and Transport Layer Security (TLS), LDAP data is object-oriented and encourages heavy reuse., LDAP databases can be massive and secure., LDAP enables the internationalization of data., ldap Information is structured, LDAP is a network protocol., LDAP is an open standard:, LDAP is designed to run directly over the TCP/IP stack. In plain and simple terms, LDAP is optimized for rapid search and retrieval., LDAP is ubiquitous., ldap its a directory?, LDAP servers are small, LDAP uses a naming scheme. Most LDAP distributions (including OpenLDAP) already contain quite a number of predefined (and general approved) schemas, ldapman.org - Introduction to LDAP www.ldapman.org/articles/intro_to_ldap.html This introduction - the first in a series of articles describing how to design, let's discuss X.500 and Directory Access Protocol (DAP). In X.500, Management and Integration (ISBN:1-93011-040-5), or a frequently used schema to define users which Unix/Linux boxes can use, or geographic whereabouts. An LDAP directory can be distributed among many servers on a network, rather than managing user lists for each group within an organization, sensitive data can be protected from prying eyes. LDAP also supports a number of back-end databases in which to store directories. This allows administrators the flexibility to deploy the database bes, simple, specifically X.500-based directory services. LDAP runs over TCP/IP or other connection oriented transfer services. X.500 is a model for Directory Services in the OSI concept. It contains namespace def, such as the inetOrgPerson, temporary inconsistencies are allowed as long as they get synchronized eventually. Information is structured All information inside a directory is structured hierarchically. Even more, the directory must know how to store this data inside a tree. Lets take a look at a fictional company and an Internet-like tree. To name nodes, the Directory System ... LDAP: a Gentle Introduction — Hynek Schlawack https://hynek.me/articles/ldap-a-gentle-introduction/ Feb 13, the number of LDAP-enabled applications are numerous and increasing in quantity and quality. LDAP is an open standard: LDAP is a network protocol. LDAP is ubiquitous. Directory databases include accou, then replicated and synchronized regularly. An LDAP server is also known as a Directory System Agent (DSA). Its a not a relational database. Outlook and other email programs uses LDAP to search for a , There are many GUI based tool for LDAP. Some of them are : – GQ – Java LDAP Browser/Editor – Softerra LDAP Browser, What is LDAP?, What is LDAP? LDAP stands for Lightweight Directory Access Protocol. As the name suggests, whether on the Internet or on corporate intranet and whether or not you know the domain name, while reducing response time. A directory is a specialized database designed for frequent queries but infrequent updates. Unlike general databases they don't contain transaction support or roll-back f, Why its a directory?, Why LDAP is called lightweight?, Why LDAP?, written by ... Cool Solutions: An Introduction to LDAP: Part 1-LDAP Primer https://www.novell.com/coolsolutions/feature/15359.html Jun 21, X.500, X.500 has been found to be overkill in many situations. Enter LDAP. Like X.500 it provides a data/namespace model for the directory and a protocol. However

What is LDAP? LDAP stands for Lightweight Directory Access Protocol. As the name suggests, it is a lightweight client-server protocol

send mail server installation

linux Networking

SETTING UP SENDMAIL ON CENTOS/RHEL 6

March 4, 2015February 28, 2016 Satya Prakash 1 Comment ”xyz.co.in” # vi /etc/mail/local-host-names abc.com xyz.co.in Make a entry for it to start at boot time and restart the service of sendmail and: # chkconfig sendmail on # service sendmail restart Test, 000 results (0.20 seconds) Search Results SENDMAIL INSTALLATION AND OPERATION GUIDE www.sendmail.org/~ca/email/doc8.12/op.html INSTALLATION AND OPERATION GUIDE. Eric Allman Gregory Neil Shapiro Claus , 2010 - Configuration Of Sendmail : 1. All the sendmail configuration files are located at /etc/mail. 2. Main configuration files are access, 2011 - Section one describes how to do a basic sendmail installation. ... of the existing configurations and that the standard installation parameters are ... configuration - sendmail: how to configur, 2011 - Uploaded by supertecacademy Thanks for uploading this. Sorry for the abusive comments others have left. You should move to Toronto ... How to configure sendmail server in Linux computernetworki, 2012 - When I searched for configuring sendmail on ubuntu I din't get any clear ... You can test sendmail to see if it is properly configured and setup by ... Installing sendmail www.tldp.org/LDP/nag2, check using this command: # ps -ef | grep -v grep | grep -i sendmail root 3595 1 0 00:20 ? 00:00:00 sendmail: accepting connections smmsp 3604 1 0 00:20 ? 00:00:00 sendmail: Queue runner@01:00:00 for , click here to turn off Google Instant. Sign in Google WebVideosImagesNewsMoreSearch tools About 8, create mail server, how-to-install-and-configure-sendmail-in-linux, if this mail server was to accept mail for the domains “abc.com”, Inc. Version \\$2. For Sendmail Version 8.12. BASIC INSTALLATION www.sendmail.org/~ca/email/doc8.12/op-sh-1.html BASIC INSTALLATION. There are two basic steps to installing sendmail. First, including how to stop unwanted email (spam) and how ... Searches related to sendmail installation sendmail installation and configuration in linux sendmail installation linux sendmail installation err, installation and configuration of mail server, just comment the following line in“sendmail.mc”: # vi /etc/mail/sendmail.mc From: DAEMON_OPTIONS(`Port=smtp, linux mail server, mail server for small company, Name=MTA')dnl Now we need to build the “sendmail.cf” file using m4 macro: # m4 /etc/mail/sendmail.mc > /etc/mail/sendmail.cf Restart Sendmail Service: # service sendmail restart Adding your domain , Name=MTA')dnl To dnl DAEMON_OPTIONS(`Port=smtp, or a GUI client, own mail server, sendmail configuration, sendmail first uses DNS to get the MX record for the other domain. It then attempts to relay the mail to the appropriate destination mail server using the Simple Mail Transport Protocol (SMTP). One of, sendmail installation, sendmail.mc ... [PDF]Installation and Operation Guide - Sendmail.com https://www.sendmail.com/pdfs/open.../installation_and_op_guide.pdf Jan 3, SETTING UP SENDMAIL ON CENTOS, SETTING UP SENDMAIL ON CENTOS/RHEL 6, SETTING UP SENDMAIL ON CENTOS/RHEL 6.3, SETTING UP SENDMAIL ON linux, such as Evolution. Linux workstation users can use the same programs to access their mail remotely. 2. Outgoing Mail The process is different when sending mail via the mail server. PC and Linux workst, such as mail, such as Microsoft’s Outlook or Outlook Express, that supports either the POP or IMAP mail retrieval protocols. Linux users logged into the mail server can read their mail directly using a text-based client, the PC of user A can delegate the SMTP processing to the mail server. What you need before set up sendmail? Most important tasks in setting up DNS for your domain (xyz.com) is to use the MX record in , then sendmail places the message in that person’s mailbox so that they can retrieve it using one of the methods above. If the mail is being sent to another domain, there ... How to Install and configure Sendmail in linux - YouTube Video for sendmail installation▶ 4:32 www.youtube.com/watch?v=KC8250lR4u8 Nov 12, What is Sendmail? Sendmail is a mail server used for sending and receiving mails. It works on SMTP (Simple Mail Transfer Protocol ) protocol on port 25. Most of users are familier with sendmail and wa, you have to compile and install the binary. If sendmail has already been ported to ... 24.3.1.2. The Default Sendmail Installation - CentOS https://www.centos.org/docs/5/.../s3-email-mta-sendmail-defa

What is Sendmail? Sendmail is a mail server used for sending and receiving mails. It works on SMTP (Simple Mail Transfer

nagios welcome

info linux Networking

NagiosQL3 installation step by step in centos/redhat or fedora part 2

March 2, 2015February 28, 2016 Satya Prakash 20 Comments fix that manually and click Next nagios installation 4.3: NagiosQL Setup In this step installer will input the database details to be used for nagiosql. Also update the nagiosql path values as per giv, In the previous post we have already completed the first step to install Nagios core service, installer will check the required packages are installed or not. If you see any error on this screen, It may be your setup is different that me, it will automatically redirect you to nagiosql3 admin panel. To open it later use below url. http://192.168.0.5/webadmin Step 6: Configure NagiosQL3 with Nagios Core This is the most important part of, make sure all folder exists in first section and check the files path with Nagios core configuration file. 6.2: Edit Nagios Core Configuration File Now edit nagios configuration file ( Eg: /usr/local/, Nagios installation step by step in centos/redhat or fedora part 2, NagiosQL3 installation, NagiosQL3 installation step by step in centos/redhat or fedora part 2, NagiosQL3 installation with nagios, Now in this article we will learn about installation of Nagios web administration tool. Step 1: Install Required Packages First we need to install required packages, only then change the values of path. 4.4: Finishing Setup This screen showing that all the steps has successfully completed. You just need to click Next nagios finish installation steps nagios finish , restart nagios core service # service nagios restart Congratulation’s You have successfully installed Nagios with NagiosQL3. Reference: http://www.nagios.org/, so be careful with below step. I am trying my best to write to complete integration. 6.1: Edit NagiosQL Configuration Login to NagiosQL administrator section and navigate to Administration -> Admin, Use the following commands to install them. # yum install libssh2 libssh2-devel mysql mysql-server php-mysql Also install ssh2 pecl extension for php. You can use one of below commands to install it. , you will be redirected to NagiosQL login screen. nagios welcome nagios welcome Step 5: Access NagiosQL3 Web Interface After completing web installer, you will find configuration file path

In the previous post we have already completed the first step to install Nagios core service, Now in this article

installation of nagios-monitoring

linux Networking Reports

Nagios installation step by step in centos/redhat or fedora part 1

February 26, 2015February 28, 2016 Satya Prakash 1 Comment 2013 - Here we'll walk you through the installation of Nagios on CentOS 6. ... Step 1 - Install Packages on Monitoring Server. rpm -Uvh ... How to Install and Configure Nagios 4.0.7 on CentOS 7.0 lino, 2013 - This article is intended to guide you with easy instructions on how to install latest Nagios 4.0.1 from source (tarball) on RHEL / CentOS 6.x/5.x ... How To Install Nagios On CentOS 6 | Digital, 2013 - This tutorial shows how to install Nagios 3.4.4 on CentOS 6.3. Prerequisites. After installing your CentOS server, 2014 - This guide will help you install the latest Nagios 4.0.x from the source files on CentOS 7, 2014 - Uploaded by Matthew Bingham Install of Nagios 4.0.2 on CentOS 6.5 Minimal install ... There just isn't a simple, although the same procedure can be used on any ... [PDF]Nagios – Installing Nagios Core From Source assets.nagios.com/.../nagioscore/.../Installing_Nagios_Core_From_Source... This document describes h, complete step-by-step guide out there to getting ... Nagios core installation guide for RED HAT and CentOS ... exchange.nagios.org › ... › Documentation › Nagios Core Documentation Oct 16, Download latest nagios-plugins source and install using following commands. # cd /opt # wget http://nagios-plugins.org/download/nagios-plugins-2.0.3.tar.gz # tar xzf nagios-plugins-2.0.3.tar.gz # cd n, entire IT infrastructure. It has been designed with scalability and flexibility in mind, I've written a simple guide to install nagios core (latest stable release 3.4.1) which contain also a section to help to solve the ... Searches related to nagios installation step by step in centos na, In this part you will find the steps to setup Nagios ... Install and Configure Nagios On CentOS, Nagios gives you the peace of mind that comes from knowing your organization's business processes won't be affected by unknown outages. Nagios is a one of the best open source tools available in the m, nagios installation and configuration on centos step by step, nagios installation on centos 6, nagios installation step by step in centos/redhat or fedora, nagios installation step by step in linux pdf nagios installation step by step in fedora, Please click here for LAMP installation steps or Click on the below link. http://blog.eduguru.in/install-lamp-server-apache-mysql-php-on-rhel-centos-scientific-linux-6-56-4/ Install Packages: # yum in, Red hat or Fedora systems, RHEL, run all steps from this document with root permissions. ... For RHEL/CentOS users:. Nagios Core 4.0.0 Install on CentOS 6 - GeekPeek.Net geekpeek.net/nagios-core-4-0-0-install/ Nagios Core 4.0.0. has , Scientific ... www.unixmen.com/install-and-configure-nagios-in-centos-6-4-rhel-6-4/ Detect security breaches. – Plan and budget for IT upgrades. – Reduce downtime and business losses. Scenario. In thi, Searches related to nagios installation step by step in centos nagios installation and configuration on centos step by step nagios installation on centos 6 nagios installation step by step ubuntu nagi, services, So our first requirement is to install LAMP . You have not installed LAMP server, What is Nagios? Nagios is a powerful monitoring system that enables organizations to identify and resolve IT infrastructure problems before they affect critical business processes. It has the capabili, you have to disable selinux ... Install Nagios 4.0.2 on CentOS 6.5 - YouTube Video for nagios installation step by step in centos▶ 8:28 www.youtube.com/watch?v=1H1uj-DxyPo Feb 8

What is Nagios? Nagios is a powerful monitoring system that enables organizations to identify and resolve IT infrastructure problems before

mysql sqery output into txt file

save mysql sqery output into txt file

February 20, 2015February 20, 2015 Satya Prakash 21 Comments save mysql sqery output into txt file, You just need to modify the query and login credential then run the below command of database server . mysql -e "select * FROM tabledata" -u satya -pPrakash databasename > /home/ob_cdr.txt However

You just need to modify the query and login credential then run the below command of database server . mysql

dialplan basic asterisk dialplan

Asterisk dialpaln [context] : context in asterisk dialpaln

February 15, 2015February 16, 2015 Satya Prakash 0 Comments a context for incoming calls looks like this: [incoming] Please not New things about context Space is conspicuously absent from the list of allowed characters. Don’t use spaces in your context names C, and callers pressing 0 at Company B’s voice menu will get Company B’s receptionist. (This example assumes, and the hyphen and underscore.* For example, Asterisk dialpaln [context] : context in asterisk dialpaln, asterisk diaplan context, context in asterisk dialplan, Contexts Dialplans are broken into sections called contexts. Contexts are named groups of extensions, extension 0 is dialed: people pressing 0 at Company A’s voice menu will get Company A’s receptionist, let’s imagine we have two companies sharing an Asterisk server.If we place each company’s voice menu in its own context, of course, one of the parameters that is defined in the channel definition is the context. In other words, say, that we’ve told Asterisk to transfer the calls to the receptionists when callers press 0.) Contexts are denoted by placing the name of the context inside square brackets ([ ]). The name can be made up, the context is the point in the dialplan where connections from that channel will begin. Another important use of contexts (perhaps the most important) is to provide security. By using contexts correc, the numbers 0 through 9, there are two special contexts named [general] and [globals]. The [general] section contains a list of general dialplan settings you may name your contexts anything you like. When you define a channel, they are effectively separated from each other. This allows us to independently define what happens when, unless interaction is specifically allowed. 3. As a simple example, until the next context is defined. At the beginning of the dialplan, what is context in asterisk, which serve several purposes. 1. Contexts keep different parts of the dialplan from interacting with one another. 2. An extension that is defined in one context is completely isolated from extensions , you can give certain callers access to features (such as longdistance calling) that aren’t made available to others. If you don’t design your dialplan carefully, you may inadvertently allow others to fraudulently use your system. Please keep this in mind as you build your Asterisk system.

Contexts Dialplans are broken into sections called contexts. Contexts are named groups of extensions, which serve several purposes. 1. Contexts keep