downgrade php 5.3.to 5.2 on CentOS 6

The Atomic repo is unavailable.

yum -y install bzip2-devel curl-devel   db4-devel gmp-devel httpd-devel pam-devel libstdc++-devel pcre-devel  readline-devel  libtool gcc-c++  libc-client-devel cyrus-sasl-devel openldap-devel  postgresql-devel unixODBC-devel libxml2-devel net-snmp-devel libxslt-devel libxml2-devel expat-devel ncurses-devel libjpeg-devel libpng-devel freetype-devel libmcrypt-devel  mhash-devel libtidy-devel  freetds-devel aspell-devel

wget http://museum.php.net/php5/php-5.2.17.tar.bz2

and ./configure

make 

make install

Asterisk convert sounds

ls -1| awk -F. ' {print $1}'| xargs -n 1 --replace=$ sox -r 6000 $.vox -r 8000 $.gsm resample -ql
ls -1| awk -F. ' {print $1}'| xargs -n 1 --replace=$ astconv /usr/lib64/asterisk/modules/codec_g729.so -e 160  $.alaw $.g729

monit and qmail

Usualy monit use pid file to monitoring process, for example

check process postfix with pidfile /var/spool/postfix/pid/master.pid

I don't find qmail pid file and use new feature in 5.2.4 - procmatch
Epel repo(6 version) have 5.1.1 version that don't support this feature
Therefore, you have to download binary from http://mmonit.com/monit/download/
and use it.

#Example

check process qmaild matching "qmail-snmpd"

   alert xxx@yyy.com but not on {pid, ppid, uptime}
   group qmail
   start program = "/etc/init.d/qmail start"
   stop  program = "/etc/init.d/qmail stop"
   if failed port 25 protocol smtp then restart
   if 5 restarts within 5 cycles then timeout

You can use monit wrapper method as well.

#Example 

/etc/monit.d/qmailwrap:

check process qmailwrap with pidfile /var/run/qmailwrap.pid
    alert xxx@yyy.com 

    start program = "/var/qmail/qmailwrap.sh start"
    stop  program = "/var/qmail/qmailwrap.sh stop"
    if failed host a.b.c.d port 25 type tcp then alert
    if 5 restarts within 5 cycles then timeout

/var/qmail/qmailwrap.sh:

#!/bin/bash
case $1 in
    start)
       echo $$ > /var/run/qmailwrap.pid;
       exec 2>&1 /var/qmail/supervise/qmail-smtpd/run   1>/var/log/qmailwrap.log
       ;;
     stop)
       kill `cat /var/run/qmailwrap.pid` ;;
     *)
       echo "usage: qmailwrap {start|stop}" ;;
 esac
 exit 0

/var/qmail/supervise/qmail-smtpd/run:

#!/bin/sh

QMAILDUID=`id -u qmaild`
NOFILESGID=`id -g qmaild`
MAXSMTPD=`cat /var/qmail/control/concurrencyincoming`
LOCAL=`head -1 /var/qmail/control/me`

if [ -z "$QMAILDUID" -o -z "$NOFILESGID" -o -z "$MAXSMTPD" -o -z "$LOCAL" ]; then
    echo QMAILDUID, NOFILESGID, MAXSMTPD, or LOCAL is unset in
    echo /var/qmail/supervise/qmail-smtpd/run
    exit 1
fi

if [ ! -f /var/qmail/control/rcpthosts ]; then
    echo "No /var/qmail/control/rcpthosts!"
    echo "Refusing to start SMTP listener because it'll create an open relay"
    exit 1
fi

exec /usr/local/bin/softlimit -m 40000000 \

 /usr/local/bin/tcpserver -v -R -l "$LOCAL" -x /etc/tcp.smtp.cdb -c "$MAXSMTPD" \ -u "$QMAILDUID" -g "$NOFILESGID" 0 smtp /var/qmail/bin/qmail-smtpd 2>&1

http://cr.yp.to/qmail.html

http://www.lifewithqmail.org/lwq.html

DataPump Import With Object Types Fails With Errors ORA-31693 ORA-2354 ORA-39779 ORA-00600

Error:
ORA-31693: "AAA"."BBB"
ORA-00600:  [kpudpxcs_getCol_ref_4], [Imgver=8 InputStrmVer=9 Name=XXX], [], [], [], [], [], [], [], [], [], []

 or

ORA-39779:

Solution:
Please pre-create the object type(in collumn XXX table "AAA"."BBB" ) in the target database and then retry the DataPump import with the following additional parameter:
TRANSFORM=oid:n

https://support.oracle.com/epmos/faces/DocumentDisplay?id=404234.1

Fatal error: Call to undefined function glob() in PHP >= 4.3.0

Error:
Fatal error: Call to undefined function glob() in PHP >= 4.3.0

Solve: yum install libcurl.i686 libcurl-devel.i686 

dbv script for ASM datastore

select 'dbv file='''||file_name||''' blocksize='||df2.BLOCK_SIZE||' userid=sys/xxx logfile=dbv-'||tablespace_name||'.log' from dba_data_files df,v$datafile df2
where  df.file_id = df2.FILE#

minimum size oracle bigfile tablespace

for normal tablespace:
Metalink ID 153869.1
CREATE TABLESPACE minimum_data DATAFILE '/u00/minimum_data.dbf' SIZE 88k LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO


for bigfile tablespace:
CREATE BIGFILE TABLESPACE minimum_data DATAFILE '/u00/minimum_data.dbf' SIZE 145k LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO