rpm -qa | grep postgresql rpm -e postgresql-python-8.1.23-6.el5_8 rpm -e postgresql-pl-8.1.23-6.el5_8 rpm -e postgresql-docs-8.1.23-6.el5_8 rpm -e postgresql-odbc-08.01.0200-3.1 rpm -e postgresql-jdbc-8.1.407-1jpp.4 rpm -e postgresql-test-8.1.23-6.el5_8 rpm -e postgresql-tcl-8.1.23-6.el5_8 rpm -e qt4-postgresql-4.2.1-1.el5_7.1 rpm -e postgresql-contrib-8.1.23-6.el5_8 rpm -e freeradius-postgresql-1.1.3-1.6.el5 rpm -e postgresql-server-8.1.23-6.el5_8 rpm -e postgresql-devel-8.1.23-6.el5_8.x86_64 rpm -e postgresql-devel-8.1.23-6.el5_8.i386 rpm -e postgresql-8.1.23-6.el5_8 cd /usr/local/src/ wget http://ftp.postgresql.org/pub/source/v9.2.3/postgresql-9.2.3.tar.gz tar -zxvf postgresql-9.2.3.tar.gz cd postgresql-9.2.3 ./configure make make install cp -p /usr/local/src/postgresql-9.2.3/contrib/start-scripts/linux /etc/init.d/postgresql chmod +x /etc/init.d/postgresql mkdir /usr/local/pgsql/data useradd postgres -d /usr/local/pgsql chown -R postgres.postgres /usr/local/pgsql su - postgres vi .bash_profile --------------------------------------------------------------------------- # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH unset USERNAME export LANG=C --------------------------------------------------------------------------- vi .bashrc ------------------------------------------------------------ PATH="$PATH":/usr/local/pgsql/bin export POSTGRES_HOME=/usr/local/pgsql export PGLIB=$POSTGRES_HOME/lib export PGDATA=$POSTGRES_HOME/data export MANPATH="$MANPATH":$POSTGRES_HOME/man export LD_LIBRARY_PATH="$LD_LIBRARY_PATH":"$PGLIB" ------------------------------------------------------------ /usr/local/pgsql/bin/initdb --no-locale -E EUC_JP /usr/local/pgsql/data exit /etc/init.d/postgresql start ps -ef | grep postgres /etc/init.d/postgresql stop ps -ef | grep postgres mkdir /var/log/postgres chown -R postgres.postgres /var/log/postgres cd /usr/local/pgsql/data/ vi pg_hba.conf ------------------------------------------------------------ host all all 203.183.143.0/24 trust host all all 202.218.192.0/26 trust host all all 172.17.57.0/24 trust ------------------------------------------------------------ vi postgresql.conf ------------------------------------------------------------ listen_addresses = '*' max_connections = 512 shared_buffers = 4GB(搭載メモリの1/4) maintenance_work_mem = 512MB checkpoint_segments = 64 effective_cache_size = 8GB(搭載メモリの1/2〜2/3) log_destination = 'stderr' logging_collector = on log_directory = '/var/log/postgres' log_filename = 'postgresql-%a.log' log_truncate_on_rotation = on log_rotation_age = 1d log_line_prefix = '%t,%h,%u,%d,%l,' autovacuum_max_workers = 4 autovacuum_vacuum_cost_limit = 200(性能が良ければ多めに) ------------------------------------------------------------ /etc/init.d/postgresql start ps -ef | grep postgres cd /usr/local/src/ wget http://www.emaillab.org/djb/tools/ucspi-tcp/ucspi-tcp-0.88.tar.gz wget http://djbware.csi.hu/patches/ucspi-tcp-0.88.errno.patch tar zxvf ucspi-tcp-0.88.tar.gz cd ucspi-tcp-0.88 patch -p1 < ../ucspi-tcp-0.88.errno.patch make make setup check cd /usr/local/src/ wget http://cr.yp.to/checkpwd/checkpassword-0.90.tar.gz wget http://vps-tora.com/src/checkpassword-glibc.patch tar zxvf checkpassword-0.90.tar.gz cd checkpassword-0.90 patch -s < ../checkpassword-glibc.patch make make setup check mkdir /var/qmail groupadd nofiles /usr/sbin/useradd -g nofiles -M -d /var/qmail -s /bin/false qmaild /usr/sbin/useradd -g nofiles -M -d /var/qmail -s /bin/false qmaill /usr/sbin/useradd -g nofiles -M -d /var/qmail -s /bin/false qmailp /usr/sbin/useradd -g nofiles -M -d /var/qmail/alias -s /bin/false alias /usr/sbin/groupadd qmail /usr/sbin/useradd -g qmail -M -d /var/qmail -s /bin/false qmailq /usr/sbin/useradd -g qmail -M -d /var/qmail -s /bin/false qmailr /usr/sbin/useradd -g qmail -M -d /var/qmail -s /bin/false qmails cd /usr/local/src/ wget ftp://ftp.eu.uu.net/pub/unix/mail/qmail/qmail-1.03.tar.gz vi qmail-date-localtime.patch ------------------------------------------------------------ s patch causes the various qmail programs to generate date stamps in the local timezone. I find GMT too annoying to convert from/to. I make no warranties that it will work in your timezone, however it works for me. Works with qmail 1.01 to 1.03. To apply this patch, cd into the qmail source directory and type... patch -s -p1 < patch-to-patch-file --- qmail-1.03.orig/date822fmt.c Tue Apr 15 15:05:23 1997 +++ qmail-1.03/date822fmt.c Fri Apr 18 00:39:41 1997 @@ -1,3 +1,4 @@ +#include #include "datetime.h" #include "fmt.h" #include "date822fmt.h" @@ -12,18 +13,51 @@ { unsigned int i; unsigned int len; + time_t now; + datetime_sec utc; + datetime_sec local; + struct tm *tm; + struct datetime new_dt; + int minutes; + + utc = datetime_untai(dt); + now = (time_t)utc; + tm = localtime(&now); + new_dt.year = tm->tm_year; + new_dt.mon = tm->tm_mon; + new_dt.mday = tm->tm_mday; + new_dt.hour = tm->tm_hour; + new_dt.min = tm->tm_min; + new_dt.sec = tm->tm_sec; + local = datetime_untai(&new_dt); + len = 0; - i = fmt_uint(s,dt->mday); len += i; if (s) s += i; + i = fmt_uint(s,new_dt.mday); len += i; if (s) s += i; i = fmt_str(s," "); len += i; if (s) s += i; - i = fmt_str(s,montab[dt->mon]); len += i; if (s) s += i; + i = fmt_str(s,montab[new_dt.mon]); len += i; if (s) s += i; i = fmt_str(s," "); len += i; if (s) s += i; - i = fmt_uint(s,dt->year + 1900); len += i; if (s) s += i; + i = fmt_uint(s,new_dt.year + 1900); len += i; if (s) s += i; i = fmt_str(s," "); len += i; if (s) s += i; - i = fmt_uint0(s,dt->hour,2); len += i; if (s) s += i; + i = fmt_uint0(s,new_dt.hour,2); len += i; if (s) s += i; i = fmt_str(s,":"); len += i; if (s) s += i; - i = fmt_uint0(s,dt->min,2); len += i; if (s) s += i; + i = fmt_uint0(s,new_dt.min,2); len += i; if (s) s += i; i = fmt_str(s,":"); len += i; if (s) s += i; - i = fmt_uint0(s,dt->sec,2); len += i; if (s) s += i; - i = fmt_str(s," -0000\n"); len += i; if (s) s += i; + i = fmt_uint0(s,new_dt.sec,2); len += i; if (s) s += i; + + if (local < utc) { + minutes = (utc - local + 30) / 60; + i = fmt_str(s," -"); len += i; if (s) s += i; + i = fmt_uint0(s,minutes / 60,2); len += i; if (s) s += i; + i = fmt_uint0(s,minutes % 60,2); len += i; if (s) s += i; + } + else { + minutes = (local - utc + 30) / 60; + i = fmt_str(s," +"); len += i; if (s) s += i; + i = fmt_uint0(s,minutes / 60,2); len += i; if (s) s += i; + i = fmt_uint0(s,minutes % 60,2); len += i; if (s) s += i; + } + + i = fmt_str(s,"\n"); len += i; if (s) s += i; + return len; } ------------------------------------------------------------ wget http://vps-tora.com/src/qmail-glibc.patch tar zxvf qmail-1.03.tar.gz cd qmail-1.03 patch < ../qmail-date-localtime.patch patch -s <../qmail-glibc.patch make make man make setup check ./config ./config-fast sv.example.co.jp cd /var/qmail/alias/ vi .qmail-postmaster vi .qmail-mailer-daemon vi .qmail-root cp /var/qmail/boot/home /var/qmail/rc vi /var/qmail/rc ------------------------------ /usr/local/bin/envdir /etc/relay-ctrl /usr/local/bin/tcpserver -u qmaild -g nofiles 0 25 /usr/local/bin/relay-ctrl-check /var/qmail/bin/qmail-smtpd & /usr/local/bin/envdir /etc/relay-ctrl /usr/local/bin/tcpserver 0 110 /var/qmail/bin/qmail-popup sv.example.co.jp /bin/checkpassword /usr/local/bin/relay-ctrl-allow /var/qmail/bin/qmail-pop3d Maildir & exec env - PATH="/var/qmail/bin:$PATH" \ qmail-start ./Maildir/ splogger qmail ------------------------------ /var/qmail/bin/maildirmake /etc/skel/Maildir echo ./Maildir/ > /etc/skel/.qmail /var/qmail/bin/maildirmake /home/homepage/Maildir echo ./Maildir/ >> /home/homepage/.qmail chown homepage /home/homepage/Maildir chown homepage /home/homepage/.qmail vi /etc/rc.d/rc.local ------------------------------ #qmail csh -cf '/var/qmail/rc &' # ------------------------------ rm /etc/rc.d/rc*/*sendmail ps ax | grep sendmail #kill -KILL #kill -KILL /usr/lib/sendmail -q chmod 0 /usr/sbin/sendmail mv /usr/sbin/sendmail /usr/sbin/sendmail-old ln -s /var/qmail/bin/sendmail /usr/sbin/sendmail mkdir -p /package chmod 755 /package chmod +t /package cd /usr/local/src/ wget http://tools.qmail.jp/daemontools/daemontools-0.76.tar.gz tar xvpfz /usr/local/src/daemontools-0.76.tar.gz cd admin/daemontools-0.76 vi src/error.h ------------------------------ extern int errno ↓ #include ------------------------------ ./package/install vi /etc/inittab ps -aef | grep svscan cd /command/ date | ./tai64n | ./tai64nlocal date | sh -c './multilog t e 2>&1' | ./tai64nlocal cd /usr/local/src/ wget http://untroubled.org/relay-ctrl/relay-ctrl-3.1.1.tar.gz tar xvfz relay-ctrl-3.1.1.tar.gz cd relay-ctrl-3.1.1 vi conf-man ------------------------------ /usr/local/man ↓に修正 /usr/local/share/man/ ------------------------------ make ./installer chmod u+s /usr/local/bin/relay-ctrl-allow mkdir /etc/relay-ctrl mkdir /var/spool/relay-ctrl echo "/var/spool/relay-ctrl" >/etc/relay-ctrl/RELAY_CTRL_DIR crontab -e ------------------------------ * * * * * /usr/local/bin/envdir /etc/relay-ctrl /usr/local/bin/relay-ctrl-age ------------------------------ vi /var/qmail/control/rcpthosts vi /var/qmail/control/virtualdomains vi /etc/xinetd.d/qpopper ------------------------------ Disable = no をyesに変更 ------------------------------ /etc/rc.d/init.d/xinetd restart /var/qmail/rc & ps -ef | grep qmail cd /usr/local/src/ wget http://jp1.php.net/get/php-5.3.28.tar.gz/from/this/mirror tar zxvf php-5.3.28.tar.gz cd php-5.3.28 ./configure --prefix=/usr/local --enable-mbstring --with-pgsql=/usr/local/pgsql --with-apxs2=/usr/sbin/apxs --enable-mbregex --with-zlib --with-gd --enable-gd-native-ttf --with-ttf --with-openssl --enable-soap --enable-pdo --with-xmlrpc --with-curl --enable-ftp make make install cd /usr/local/src/ wget http://sourceforge.net/projects/mcrypt/files/Libmcrypt/2.5.8/libmcrypt-2.5.8.tar.gz/download tar zxvf libmcrypt-2.5.8.tar.gz cd libmcrypt-2.5.8 ./configure make make install cd /usr/local/src/php-5.3.28/ext/mcrypt phpize ./configure --with-zlib-dir=/usr/lib make make install cd /usr/local/src/ wget http://www.smarty.net/files/Smarty-2.6.27.tar.gz tar zxvf Smarty-2.6.27.tar.gz mkdir /usr/local/lib/php/Smarty cd Smarty-2.6.27 cp -r libs/* /usr/local/lib/php/Smarty pear install Pager pear install DB pear install Log pear install Auth pear install HTTP_Request pear install HTTP_Request2 pear install XML_Serializer-beta vi /etc/hosts.allow ------------------------------ #sp-comic svn sshd: 203.183.143.202 sshd: 172.17.57.3 ------------------------------ cd /usr/local/src/ wget http://launchpad.net/imagemagick/main/6.3.6-1/+download/ImageMagick-6.3.6-1.tar.gz tar zxvf ImageMagick-6.3.6-1.tar.gz cd ImageMagick-6.3.6 ./configure make make install cd /usr/local/src/ wget http://pecl.php.net/get/imagick-2.2.2.tgz tar zxvf imagick-2.2.2.tgz cd imagick-2.2.2 phpize ./configure make make install cd /usr/local/lib wget http://supokon.net/php.ini /etc/init.d/httpd configtest cd /etc/httpd/conf.d/ vi php.conf ------------------------------ # LoadModule php5_module modules/libphp5.so ------------------------------ /etc/init.d/httpd configtest /etc/init.d/httpd restart useradd redhotsongs.com useradd support-redhotsongs.com cd /home/ passwd redhotsongs.com passwd support-redhotsongs.com cd /var/qmail/ vi rc cd control/ vi defaultdomain ------------------------------ ns1.redhotsongs.com ------------------------------ vi locals ------------------------------ ns1.redhotsongs.com localhost ------------------------------ vi me ------------------------------ ns1.redhotsongs.com ------------------------------ vi rcpthosts ------------------------------ redhotsongs.com .redhotsongs.com ------------------------------ ------------------------------ vi virtualdomains redhotsongs.com:redhotsongs.com .redhotsongs.com:redhotsongs.com ------------------------------ ps -ef | grep qmail #kill 22699 #kill 22700 #kill 22701 ps -ef | grep qmail /var/qmail/rc & cd /etc/httpd/conf vi httpd.conf ------------------------------ NameVirtualHost *:80 DocumentRoot /home/homepage/public_html ServerAdmin root@redhotsongs.com DocumentRoot /home/redhotsongs.com/public_html ServerName redhotsongs.com ErrorLog logs/redhotsongs.com-error_log CustomLog logs/redhotsongs.com-access_log combined ------------------------------ /etc/init.d/httpd restart tail -f /var/log/httpd/access_log cd /home/homepage/public_html/check/ mv _check.html check_210_168_23_237.html SSLの発行 772 [13/07/03 13:06:20] openssl genrsa -out deco_party_net_2013_key.pem 2048 773 [13/07/03 13:06:53] openssl req -new -key deco_party_net_2013_key.pem -out deco_party_net_2013_csr.pem ServerAdmin root@utatown.com DocumentRoot /home/utatown.com/public_html ServerName utatown.com ServerAlias www.utatown.com SSLEngine on SSLCertificateFile /etc/httpd/conf/ssl/utatown_cert.pem SSLCertificateKeyFile /etc/httpd/conf/ssl/utatown_key.pem SSLCertificateChainFile /etc/httpd/conf/ssl/utatown_inca.pem ErrorLog logs/moez.jp-ssl-error_log CustomLog logs/moez.jp-ssl-access_log common