FreeBSD/wsv1

wsv1の相違点 †

dump02から

/etc/alias 設定

cd  /usr/ports/databases/mysql55-client/
make package WITH_XCHARSET=all FORCE_PKG_REGISTER=
cd ../mysql55-server
make package WITH_XCHARSET=all FORCE_PKG_REGISTER=

SHOW VARIABLES LIKE 'character_set%';
SHOW VARIABLES LIKE 'collation%';

cd /var
mv log /log
ln -s /log log

shutdown -r now

setenv PACKAGEROOT ftp://ftp3.jp.FreeBSD.org
mount_nfs 192.168.0.146:/back /mnt

pkg_add -rv compat4x-i386 #for WenMoney

pkg_add -rv p5-DBD-mysql55 #for wm_keitai

# for sm
php5-hash-5.3.2_1
php5-xml-5.3.2_1
php5-gettext
gettext

find . -size 0 -exec rm {} \;

ll /com/sm_data/attach/

/usr/local/etc/rc.d/mysql-server stop
pkg_add  -fv /mnt/wsv_package/mysql-client-5.5.4.tbz
pkg_add  -fv /mnt/wsv_package/mysql-server-5.5.4.tbz

my.cnf
[mysqld]
character-set-server=eucjpms
skip-character-set-client-handshake

cd /var/db/
mv mysql /data/
ln -s /data/mysql  mysql
cd /data
/usr/local/etc/rc.d/mysql-server start
権限設定

/usr/local/etc/rc.d/apache22 stop
mkdir /data/www
cd /home
ln -s /data/www www
cd /
ln -s /data/www com
cd /usr/local/www/apache22/
mv data/* /data/www
rmdir data
ln -s /data/www data
/usr/local/etc/rc.d/apache22 start

pkg_add -rv rsync  

cd /usr/local/etc/apache22/
mkdir Comodo2010
cd Comodo2010
rsync -av --delete www:/usr/local/etc/apache2/NEWCOMODO-2010-2/\* ./

wsv1# diff httpd.conf  httpd.conf.bak
198c198
<     Options All
---
>     Options Indexes FollowSymLinks
205c205
<     AllowOverride All
---
>     AllowOverride None
220c220
<     DirectoryIndex index.php index.html index.htm
---
>     DirectoryIndex index.html
372c372
<     AddHandler cgi-script .cgi .pl
---
>     #AddHandler cgi-script .cgi
383,384c383,384
<     AddType text/html .shtml .shtm .html .htm
<     AddOutputFilter INCLUDES .shtml .shtm .html .htm
---
>     #AddType text/html .shtml
>     #AddOutputFilter INCLUDES .shtml
454c454
< Include etc/apache22/extra/httpd-ssl.conf
---
> #Include etc/apache22/extra/httpd-ssl.conf

wsv1# diff httpd-ssl.conf httpd-ssl.conf.2010
99c99
< SSLCertificateFile "/usr/local/etc/apache22/server.crt"
---
> SSLCertificateFile "/usr/local/etc/apache22/Comodo2010/zenno_com.crt"
107c107
< SSLCertificateKeyFile "/usr/local/etc/apache22/server.key"
---
> SSLCertificateKeyFile "/usr/local/etc/apache22/Comodo2010/myserver.key"
127c127
< #SSLCACertificateFile "/usr/local/etc/apache22/ssl.crt/ca-bundle.crt"
---
> SSLCACertificateFile "/usr/local/etc/apache22/Comodo2010/zenno_com.ca-bundle"

rsync -av --delete www:/home/www/ /data/www/

cd /data
mysqldump -hwww -ukenji -p**** --databases hats news vpopmail    > www.sql.dump
sed s/'timestamp(14) NOT NULL'/'timestamp'/ < www.sql.dump > www.sql.dump.temp
sed s/'TYPE=MyISAM'/'ENGINE=MyISAM'/ < www.sql.dump.temp > www.sql.dump
mysql -p******** < www.sql.dump
rm www.sql*

cd /data/www/img/
cp V3/img.php V3/img.php.tmp
cp mac_mail/img.php mac_mail/img.php.tmp
cp nm/img3.php nm/img3.php.tmp
cp outloock/oe03_img.php outloock/oe03_img.php.tmp
cp pet/pet2_img.php pet/pet2_img.php.tmp
sed s/'#$str'/'$str'/ < V3/img.php.tmp > V3/img.php  ; rm V3/img.php.tmp 
sed s/'#$str'/'$str'/ < mac_mail/img.php.tmp > mac_mail/img.php  ; rm mac_mail/img.php.tmp 
sed s/'#$str'/'$str'/ < nm/img3.php.tmp > nm/img3.php  ; rm nm/img3.php.tmp 
sed s/'#$str'/'$str'/ < outloock/oe03_img.php.tmp > outloock/oe03_img.php  ; rm outloock/oe03_img.php.tmp 
sed s/'#$str'/'$str'/ < pet/pet2_img.php.tmp > pet/pet2_img.php  ; rm pet/pet2_img.php.tmp

FreeBSD