Just a simple IT professional

AUSEARCH:(8) System Administration Utilities AUSEARCH:(8)
NAME ausearch - a tool to query audit daemon logs

AUDITCTL:(8) System Administration Utilities AUDITCTL:(8)
NAME auditctl - a utility to assist controlling the kernel’s audit system

#!/bin/bash solr_home="/app/solr" solr_backup_folder="/solr_backup" solr_user_name="solr"
cd $solr_home

To change jboss7 log rotating from periodic to size base, comment periodic-rotating-file-handler and insert the following size-rotating-file-handler into standalone.xml

Below is simple menu for a bash script:


#!/bin/bash
command1() { echo "command1 executed!" read }

If you want to delete a line inplace using sed utility "-i" option should be used:
sed -i -e "/<string pattern>/d" <text file>

There are a lot of tools and libraries for parsing html in java language. One of them is HTML Parser. HTML Parser is a Java library used to parse HTML. It is used for transformation or extraction, it features filters, visitors, custom tags and easy to use JavaBeans. It is a fast, robust and well tested package.
Homepage: http://htmlparser.sourceforge.net

Date  Log Job History (TestDB_Maintenance_Plan.TestDB_Diff_Subplan) Step ID 1 Server TestSRV Job Name TestDB_Maintenance_Plan.TestDB_Diff_Subplan Step Name TestDB_Diff_Subplan Duration 00:00:05 Sql Severity 0 Sql Message ID 0 Operator Emailed  Operator Net sent  Operator Paged  Retries Attempted 0

In order to get total amount of the system memory as GigaByte in a bash script:
#!/bin/bash mem_line=`cat /proc/meminfo |grep MemTotal` mem_kb=`echo $mem_line | tr -cd '[[:digit:]]'` mem_gb=$(awk "BEGIN{print $mem_kb/1024/1024}") echo "System Memory (KB): "$mem_kb echo "System Memory (GB): "$mem_gb

This is accomplished using stat command. -c parameter is for the specified FORMAT instead of the default %Y is for the Time of last modification as seconds since Epoch
#!/bin/bash $file="/tmp/testfile" file_time_stamp=$(stat -c %Y $file) echo $file_time_stamp

To find another user's home folder in a bash script: # getent passwd <username> | cut -d: -f6
for example: # getent passwd nfsnobody | cut -d: -f6 /var/lib/nfs

$RANDOM can be used for generating random number in bash. $RANDOM generate an integer value. For example if you want to generate number as minutes, the command just like:
# echo $[ RANDOM % 60 ] 34

This is an example log format for citrix netscaler:
logFormat Custom %h %l %u [%t] "%r" %s %B "%{Referer}i" "%{User-agent}i"

AVG(expression) : Returns average value of expression
CORR(expression1, expression2) : Returns the coefficient of correlation of a set of number pairs
COVAR_POP(expression1, expression2) : Returns the population covariance of a set of number pairs
COVAR_SAMP(expression1, expression2) : Returns the sample covariance of a set of number pairs
COUNT(expression) : Returns the number of rows returned by the query

dig is one of the finest dns tools for unix and linux admins. ISC (Internet Systems Consortium) provides windows binary for the dig tool. In order to use it from windows machine, download bind zip file from http://www.isc.org downloads site. Then extract following files to your local folder that is already in your %PATH% environment variable or create a folder in the program files folder and add it to the %PATH% environment variable so you can use it from command line without writing the full path.

ORA-39083: Object type REF_CONSTRAINT failed to create with error: ORA-02298: cannot validate <constraint_name> - parent keys not found Failing sql is: ALTER TABLE <detail_table_name> ADD CONSTRAINT <constraint_name> FOREIGN KEY <detail_table_column_name> REFERENCES <master_table_name> <master_table_column_name> ENABLE

winbindd[2753] libsmb/cliconnect.c:1052(cli_session_setup_spnego)
Kinit failed: Clock skew too great

if you encounter this message and can not login via ssh using AD account. This is most probably because server's date and time are not set correctly.

Below is a shell script for joining redhat linux computer to windows domain.

#!/bin/bash

s1=$(cat /etc/redhat-release)
s2="release"
pos1=$(awk -v a="$s1" -v b="$s2" 'BEGIN{print index(a,b)}')
pos=$((pos1+7))
redhat_version=${s1:$pos:1}

First, prepare following files under the Jboss installation folder. Jboss AS zip packages are availeble at http://www.jboss.org/jbossas/downloads/ and java jdk packages are available at http://www.oracle.com/technetwork/java/javase/downloads/
jboss-4.2.2.GA.zip
jboss-4.2.3.GA.zip
jboss-as-7.1.1.Final.zip
jdk-6u37-linux-i586-rpm.bin
jdk-6u37-linux-x64-rpm.bin
jboss-as.conf
jboss-as-standalone.sh
jboss-install.sh

This is a quite good document for tuning and slimming JbossAS 4. Remove unneeded services and slim jboss installation.
https://community.jboss.org/wiki/JBossASTuningSliming

#!/bin/sh
time_stamp=$(date +%d_%m_%Y-%H_%M_%S)

If you use iptables and want to allow tinydns service answer iterative requests:

Note: Tinydns serves from 192.168.1.10 change yours accordingly, and INPUT number may vary for your list of rules.

VegaDNS is the web based tinydns admin tool for configuring DNS records from a web browser.

It has some good features:
Can be accessed with Admin and User levels
Multiple domains can be imported using AXFR
Has a template engine for separation of PHP from HTML
Configurable Default Records to auto-populate new domains with
It is Free
Requirements:
PHP4 (register_globals and safe_mode must be Off for security), MySQL, djbdns, ucspi-tcp, daemontools, wget must be installed.
URL: http://www.vegadns.org

For installing chrome vith yum you just have to: Open a terminal window and type for corresponding cpu architecture:
i386 yum localinstall --nogpgcheck -y https://dl.google.com/linux/direct/google-chrome-stable_current_i386.rpm
x86_64 yum localinstall --nogpgcheck -y https://dl.google.com/linux/direct/google-chrome-stable_current_x86_64.rpm

Following error may be occured when compiling daemontools and djbdns on linux systems.
/usr/bin/ld: errno: TLS definition in /lib64/libc.so.6 section .tbss mismatches non-TLS reference in envdir.o
/lib64/libc.so.6: could not read symbols: Bad value

Twiddle is a command line tool that interact with JMX server instance. For linux systems twiddle.sh is under $JBOSS_HOME\bin directory. Usage can be learned typing ./twiddle.sh -h from command line.

./twiddle.sh -h
A JMX client to 'twiddle' with a remote JBoss server.

If you encounter in the Sql Server Agent Log "SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'ISTMRKSQLHOST\Administrator', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin)" this is related with Sql Server Agent job security.
Open Sql Server Management Studio, go to Object Explorer select Jobs under SQL Server Agent. Find your Maintenance Plan and right click on it, select Properties. On the General Page change Owner to 'sa'. Then execute the maintenance plan again.

Centos Linux operating system can be downloaded from Centos Public Mirrors. Most of the download locations are at US. Current version is 6.3 now. DVD version consist of two files. CentOS-6.3-x86_64-bin-DVD1.iso and CentOS-6.3-x86_64-bin-DVD2.iso.
http://www.centos.org/modules/tinycontent/index.php?id=15

On Redhat EL 6 /dev/shm is returning the old value even if it is specified in the fstab. This is because tmpfs is never remounted during the boot process. Resolution for this is simply adding remount command to /etc/rc.local file.
eg: mount -o remount,size=5G /dev/shm

hdparm command should be executed with root privileges. The following is an example for cached read and buffered disk read.

# hdparm -Tt /dev/mapper/mpath1

/dev/mapper/mpath1:
Timing cached reads: 2832 MB in 2.00 seconds = 1415.46 MB/sec
Timing buffered disk reads: 74 MB in 3.10 seconds = 23.85 MB/sec

When viewing size of the Windows directory, users may notice that the C:\Windows\winsxs directory appears to be taking up large amounts of disk space.

BASH_BUILTINS(1)      BASH_BUILTINS(1)
NAME        bash,  :,  ., [, alias, bg, bind, break, builtin, cd, command, compgen,        complete, continue, declare, dirs, disown, echo, enable,  eval, exec,        exit,  export,  fc,  fg, getopts, hash, help, history, jobs, kill, let,        local, logout, popd, printf, pushd, pwd, read, readonly, return,  set,        shift,  shopt,  source,suspend,  test, times, trap,type, typeset,        ulimit, umask, unalias, unset,  wait  -bash  built-incommands,  see        bash(1)

locate(1) locate(1)

NAME
       locate - find files by name

PAM.CONF(5) Linux-PAM Manual PAM.CONF(5)
NAME pam.conf, pam.d - PAM configuration files

First create necessary users: # useradd dnslog # useradd axfrdns
axfrdns-conf command creates axfrdns configuration files and folders: (env, log, Makefile, run, tcp) # axfrdns-conf axfrdns dnslog /etc/axfrdns /etc/tinydns <tiny dns server ip address>

Default runlevel. The runlevels used by RHS are:
0 - halt (Do NOT set initdefault to this) 1 - Single user mode 2 - Multiuser, without NFS (The same as 3, if you do not have networking) 3 - Full multiuser mode 4 - unused 5 - X11 6 - reboot (Do NOT set initdefault to this)

LAST,LASTB(1)      Linux System Administrator’s Manual LAST,LASTB(1)

NAME        last, lastb - show listing of last logged in users

DNS infrastructure should work well In order that winbind funcitons properly. So check it first. # host -t srv _kerberos._tcp.yourdomain.com _kerberos._tcp.yourdomain.com has SRV record 0 100 88 adsrv1.yourdomain.com.  _kerberos._tcp.yourdomain.com has SRV record 0 100 88 adsrv2.yourdomain.com. 
Necessary packages should be installed. # yum installauthconfigpam_krb5samba-common

Fedora spins are custom-made versions of Fedora. Spins are linux versions consist of hand-picked application set or customizations.
http://spins.fedoraproject.org/

From the eclipse menu: Select File > New > Other

OraToolKit is a collection of tools to ease and optimize Oracle setups throughout the whole lifecycle. With its all-purpose usage it can also be called "The Swiss Army Knife for Oracle". Released as open source software it provides to companies using Oracle database technology many benefits. Those can be seen from financial, efficiency as well as from usability point of view. Goal of this open source project is to help reducing total cost of ownership (TCO) when running Oracle on Unix based systems. Supported are currently Linux and Solaris. In Q3/Q4 there there will be a new OTK release which will support IBM AIX as well as HP-UX. Future releases of an OTK light running on Microsoft Windows operating systems may not be excluded.

host is a simple utility for performing DNS lookups. In order to use it dnsutil package should be installed on redhat systems.
For example if you want to check kerberos srv records from AD (Active Directory) infrastructure.
# host -t srv _kerberos._tcp.example.local _kerberos._tcp.example.local has SRV record 0 100 88 srv1.example.local. _kerberos._tcp.example.local has SRV record 0 100 88 srv2.example.local. _kerberos._tcp.example.local has SRV record 0 100 88 srv3.example.local. _kerberos._tcp.example.local has SRV record 0 100 88 srv4.example.local.

HOSTNAME(1)   Linux Programmer’s Manual   HOSTNAME(1)

NAME        hostname - show or set the system’s host name        domainname - show or set the system’s NIS/YP domain name        dnsdomainname - show the system’s DNS domain name        nisdomainname - show or set system’s NIS/YP domain name        ypdomainname - show or set the system’s NIS/YP domain name

HDPARM(8)            HDPARM(8)

NAME
       hdparm - get/set hard disk parameters

Oracle database is quiesced when recreating Oracle Enterprise Manager (OEM) using Enterprise Manager Configuration Agent (EMCA) and can not be connected to database but sys user.

In the alert log file:

GREP(1)       GREP(1)

NAME        grep, egrep, fgrep - print lines matching a pattern

join_buffer_size: (PER SESSION) Controls the amount of memory allocated to perform joins on tables that have no keys which can be used to perform a condition filter. Allocated for each table joined without necessary filter conditions.
key_buffer_size: (GLOBAL) (MyISAM-only) Controls the amount of memory allocated to the MyISAM index key cache.

import java.io.*;
import java.util.regex.*;
public class harness {  /**   * @param args   */  public static void main(String[] args) {  // TODO Auto-generated method stub

To administrate SELinux on a linux box you should have to know some basics of SELinux: Viewing and changing SELinux statesViewing and changing SELinux security contextViewing SELinux violation messagesViewing and changing the state of SELinux booleansUsing basic features of the SELinux gui toolhttp://www.youtube.com/watch?v=aeK5jOwtWoQ

There are five ways to deploy an application to JBoss AS 7 using:
Command LineWeb ConsoleFile SystemMaven PluginEclipsehttp://www.youtube.com/watch?v=OuFaYYQVJP0

GAWK(1)       Utility Commands       GAWK(1)

NAME        gawk - pattern scanning and processing language

http-web-access.log file is in the $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<host>_<sid>/log directory. This log file grows in the long run and can be managed from $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<host>_<sid>/config/http-web-site.xml file.

<?xml version = '1.0' standalone = 'yes'?>
<!DOCTYPE web-site PUBLIC "OracleAS XML Web-site" "http://xmlns.oracle.com/ias/dtds/web-site-9_04.dtd">

Starting and stopping sql server express edition from command line is different from default instance.
Within a windows batch file:
NET STOP MSSQL$SQLEXPRESS timeout 5 NET START MSSQL$SQLEXPRESS

E2FSCK(8)     E2FSCK(8)

NAME        e2fsck - check a Linux ext2/ext3 file system

When it is supposed to host static contents from the same jboss server and additionally host them from multiple domains, new <Host> sections should be defined in the server.xml file. Server.xml file is at /<jboss-home>/deploy/jboss-web.deployer folder in the 4.2 version.

DUMP(8)  System management commands       DUMP(8)

NAME        dump - ext2/3 filesystem backup

DMESG(8)      DMESG(8)

NAME        dmesg - print or control the kernel ring buffer

CHOWN(1) User Commands      CHOWN(1)

NAME        chown - change file owner and group

CHMOD(1) User Commands      CHMOD(1)

NAME        chmod - change file access permissions

CAT(1) User CommandsCAT(1)

NAME        cat - concatenate files and print on the standard output

GAWK(1)       Utility Commands       GAWK(1)

NAME        gawk - pattern scanning and processing language

Redhat's OpenShift project describes itself "OpenShift is Red Hat's free, auto-scaling Platform as a Service (PaaS) for applications. As an application platform in the cloud, OpenShift manages the stack so you can focus on your code." OpenShift uses the Secure Shell (SSH) network protocol to manage your cloud environment. I will give some example commands and results. Cygwin terminal can be used on windows systems. I want to create a namespace and application.

PS(1)      Linux User’s Manual PS(1)

NAME        ps - report a snapshot of the current processes.

IPTABLES(8)   IPTABLES(8)

NAME        iptables - administration tool for IPv4 packet filtering and NAT
SYNOPSIS        iptables [-t table] -[AD] chain rule-specification [options]        iptables [-t table] -I chain [rulenum] rule-specification [options]        iptables [-t table] -R chain rulenum rule-specification [options]        iptables [-t table] -D chain rulenum [options]        iptables [-t table] -[LFZ] [chain] [options]        iptables [-t table] -N chain        iptables [-t table] -X [chain]        iptables [-t table] -P chain target [options]        iptables [-t table] -E old-chain-name new-chain-name

Since the following modifications are made on the conf/jboss-log4j.xml file, jboss apllication middleware logs can be sent to a remote syslog server:

Coment out SYSLOG section and change necessary values according to yours, on the syslog server there are some log facilities as LOCAL0..7 for customizing logs. Choose one of them:   <appender name="SYSLOG" class="org.apache.log4j.net.SyslogAppender">

IFCONFIG(8)   Linux Programmer’s Manual   IFCONFIG(8)

NAME        ifconfig - configure a network interface

service(8)    service(8)

NAME        service - run a System V init script

There is no need for choosing objects when creating collections. Because after creating a user or device collection on microsoft system center configuration manager 2012 there would be objects that is created newly on your network infrastructure.

USERADD(8)  System Management Commands    USERADD(8)

NAME        useradd - create a new user or update default new user information

JSch is a famous Java implementation of SSHv2. Below is an example of a running simple ifconfig command on a linux host from a webapp:
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ page import="java.util.*" %> <%@ page import="java.io.*" %> <%@ page import="com.jcraft.jsch.*" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Remote Ssh</title> </head> <body> <% String sshHost = "sshhost"; int sshPort = 22;

The company i worked for is running IBM System Storage SAN Volume Controller (SVC) to hold some of the media content. SATA disks are attached to the server via fiber channel protocol.

I am searching for a solution about oracle's "Open cursors limit exceeded" alert for sometime. And here is the answer i found:
"The best advice for tuning OPEN_CURSORS is not to tune it. When it comes to the limit, raise it."
Ooh Great :)

In the par file INCLUDE/EXCLUDE parameters can be added in order to filter metadata. For instance only a package can be imported:

Content of the par file:

In order to export man page output to a text file using linux shell:

for example export tar command man page to a file:
man tar | col -b > tar.txt

When SCCM 2012 is integrated with remote WSUS 3.0 SP2 server, synchronization problems occured. In the wsyncmgr log file there are some logs about the problem. Log files are under Program Files\Microsoft Configuration Manager\Logs folder.
Performing sync on retry schedule  $$<SMS_WSUS_SYNC_MANAGER><05-10-2012 14:10:05.829-180><thread=3452 (0xD7C)>

These are some examples creating view from a table

create view prodlist (prid,prname,tam)
as
select prodid, prodname, totalamount
from products


select * from prodlist

How to: Log someone out of the ssh terminal session but yourself? Kick off other users from linux terminal? Kill someone's ssh session?

How to set permissions on linux system when mounting samba or windows share disk using cifs protocol?
in the /etc/fstab set mount options dir_mode and file_mode
An example:

An example solr query
http://test.example.com:<port number>/solr/<core name>/select?q=test

Example response xml is

select host, user from mysql.user order by user;
lists mysql users

curl(1)  Curl Manual       curl(1)

NAME
       curl - transfer a URL

Apache is a open source software development community. There are lots of software projects that are currently continuing to develop.


This is simple list of projects currently ongoing.

Master:Master database contains instance metadata and SQL Server system configuration settings but system objects are stored in resource database.
Model: Model database is a template for creating a new database.
Msdb:Msdbdatabase is used by SQL Server Agent.
Resource:Resource database is a read-only database that contains all the system objects that are included with SQL Server.
Tempdb:Tempdb database is a resource that is available to all users is used to hold temporary objects.

FDISK(8)   Linux Programmer’s Manual      FDISK(8)

NAME
       fdisk - Partition table manipulator for Linux

DATE(1) User Commands       DATE(1)

NAME
       date - print or set the system date and time

IOSTAT(1)      Linux User’s Manual     IOSTAT(1)

NAME
       iostat - Report Central Processing Unit (CPU) statistics and input/out-
       put statistics for devices and partitions.

VMSTAT(8) Linux Administrator’s Manual     VMSTAT(8)

NAME
       vmstat - Report virtual memory statistics

NFS(5)   Linux Programmer’s ManualNFS(5)

NAME
       nfs - nfs and nfs4 fstab format and options

Replication Objects: Article: Objects that will be replicated in the database. Subscription: Object that is used for receiving updates. Each subscriber must be associated with a publisher. Publication: Object that is used for making data available for subscribers. A publication is made of articles.

TAR(1)      tarTAR(1)

NAME
       tar - The GNU version of the tar archiving utility

SCP(1)  BSD General Commands ManualSCP(1)

NAME
     scp - secure copy (remote file copy program)

DU(1) User Commands DU(1)

NAME
       du - estimate file space usage

RM(1) User Commands RM(1)

NAME
       rm - remove files or directories

MV(1) User Commands MV(1)

NAME
       mv - move (rename) files

CP(1) User Commands CP(1)

NAME
       cp - copy files and directories

TOP(1)      Linux User’s ManualTOP(1)

NAME
       top - display Linux tasks

DF(1) User Commands DF(1)

NAME
       df - report file system disk space usage

LS(1) User Commands LS(1)

NAME        ls - list directory contents

If you have plenty of posts in the form of uncategorized then all you have to need is labeling your posts. Once labeling is finished Labels Gadget can be inserted on blog from Layout Tab.It’ll be needed to add it by clicking Add a Gadget.  Then it can be customized the by giving it a different title. Labels Gadget has options how the categories are sorted, and whether to show the number of posts corresponding to each category.

So you want to allow other users to stop and start some of the services. From the linux point of view you can do this by using sudo.
Change ".bash profile" file contents of the user so that "service" and "chkconfig" commands will be in the PATH environment variable. "/sbin" folder must be included.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 04/09/2012 13:43:10 RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

#!/bin/bash
solr_home="/opt/jboss/solr/";
solr_backup_folder="/solr_backup/";
today="$(date +%d%m%Y)";
todays_backup="backup.$(date +%Y%m%d)*"
index_name_tag1="corename=\"";
index_name_tag2="\"instanceDir";
instance_dir_tag1="instanceDir=\"";
instance_dir_tag2="\"/>";
logfile="/tmp/solr/solr_backup.log";
overall_result="ok";

Count number of files per folder with this command:

# find * -maxdepth 0 -type d -exec sh -c "echo -n {} ' ' ; ls -lR {} | wc -l" \;

In order to avoid truncating server.log file contents when restarting jboss, change jboss-log4j.xml FILE Appender class.
<appender name="FILE" class="org.jboss.logging.appender.RollingFileAppender">

After registering redhat linux system for rhn, yum update command returned "No Packages marked for Update"

# yum update Loaded plugins: downloadonly, security Setting up Update Process No Packages marked for Update

When installing vmtools on a linux machine inside the /tmp directory, got this error: ./vmware-install.pl: /usr/bin/perl: bad interpreter: Permission denied
Then looked at tmp for permissions: lrwxrwxrwx   1 root root     31 Mar  6 11:13 vmware-install.pl
It seems ok but if /etc/fstab has noexec option like: LABEL=/tmp    /tmp    ext3    nosuid,noexec,nodev    1    2
Changed with this one and remount again: LABEL=/tmp    /tmp    ext3    defaults    1    2

There are some template files for displaying post contents in excerpt or full-length form in wordpress like index.php, category.php, archive.php etc. If it is wanted to be displayed post contents in the form of multiple columns, following changes may give the desired result.

put these lines of code after <?php if ( have_posts() ) : ?> and just before <?php while ( have_posts() ) : the_post(); ?> loop:

echo "<table>";
$column = 0;

inside the while loop, put <tr> and <td> just after <?php while ( have_posts() ) : the_post(); ?>

if ($column == 0) echo "<tr>";
echo "<td width='50%'>";

Now it comes to close <td> tag after the post content. Post content generally appears similar to <?php get_template_part( 'content', get_post_format() ); ?>

echo "</td>";
$column=$column+1;

Then if the number of columns are reached desired value, close the <tr> tag:

if ($column == 2) {
echo &qu…