* wsv1の相違点 [#t1cc3369]
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 -p7741 --databases hats news vpopmail > www.sql.dump
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 -pscn2jek2 < 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]]
![[PukiWiki]](image/z_logo.gif "[PukiWiki]"){kind=logo}
