---------------------------- #contents ---------------------------- ** 準備 [#d03151f0] # 近いサーバーを選んでおく setenv PACKAGEROOT ftp://ftp3.jp.FreeBSD.org # 設定用のファイルがあるドライブをマウント mount_nfs 192.168.0.146:/data /mnt ** apache [#bae85f88] pkg_add -vr apache22 echo 'apache22_enable="YES"' >> /etc/rc.conf echo 'apache22_http_accept_enable="YES"' >> /etc/rc.conf chown $LOGNAME /usr/local/www/apache22/data cp /usr/local/etc/apache22/httpd.conf /usr/local/etc/apache22/httpd.conf.orig sed s/you@example.com/info@zenno.com/ < /usr/local/etc/apache22/httpd.conf.orig > /usr/local/etc/apache22/httpd.conf patch -p0 < /mnt/src/newsyslog.conf.patch -- ==> newsyslog.conf.patch <== --- /etc/newsyslog.conf.orig 2010-09-02 16:00:26.000000000 +0900 +++ /etc/newsyslog.conf 2010-09-02 17:10:08.000000000 +0900 @@ -36,3 +36,5 @@ /var/log/weekly.log 640 5 1 $W6D0 JN /var/log/wtmp 644 3 * @01T05 B /var/log/xferlog 600 7 100 * JC +/var/log/httpd-access.log 644 7 * @T00 Z /var/run/httpd.pid 30 +/var/log/httpd-error.log 644 7 * @T00 Z /var/run/httpd.pid 30 - libiconv 依存関係でインストールされる libiconv だが make WITH_EXTRA_PATCHES=true の必要性について&br; 十分検証できていないので今回はデフォルトのまま。&br; patchを採用する場合は[[オリジナルpackage>FreeBSD/オリジナルpackage]]を作成 ** snmpd [#eea5d5d5] pkg_add -vr net-snmp echo 'snmpd_enable="YES"' >> /etc/rc.conf cp /mnt/src/snmpd.conf /usr/local/share/snmp/snmpd.conf -- ==> snmpd.conf <== com2sec local localhost zenno com2sec mynetwork 192.168.0.0/24 zenno group MyRWGroup v1 local group MyRWGroup v2c local group MyRWGroup usm local group MyROGroup v1 mynetwork group MyROGroup v2c mynetwork group MyROGroup usm mynetwork view all included .1 80 access MyROGroup "" any noauth exact all none none access MyRWGroup "" any noauth exact all all none syslocation FreeBSD server syscontact kenji <info@zenno.com> disk / 10000 load 12 14 14 ** mysql [#f4aacfd1] pkg_add -vr mysql55-server echo 'mysql_enable="YES"' >> /etc/rc.conf /usr/local/etc/rc.d/mysql-server start rehash mysqladmin -u root password PASS mysql -pPASS use mysql delete from user where password = ""; DROP USER ''@'%'; DROP DATABASE `test`; exit ** php5 [#g8f7bfa4] [[オリジナルpackage>FreeBSD/オリジナルpackage]]で WITH_APACHE=true WITH_MULTIBYTE=true にて作成済み package を使う。 pkg_add -vr libxml2 pkg_add /mnt/new_package/php5-5.3.2_1.tbz echo '<? phpinfo(); ?>' > /usr/local/www/apache22/data/info.php echo 'date.timezone = "Asia/Tokyo"' > /usr/local/etc/php.ini patch -p0 < /mnt/src/php5.httpd.conf.patch -- ==> php5.httpd.conf.patch <== --- /usr/local/etc/apache22/httpd.conf.orig 2010-09-02 17:32:07.000000000 +0900 +++ /usr/local/etc/apache22/httpd.conf 2010-09-02 16:16:25.000000000 +0900 @@ -104,6 +104,9 @@ LoadModule rewrite_module libexec/apache22/mod_rewrite.so LoadModule php5_module libexec/apache22/libphp5.so +AddType application/x-httpd-php .php +AddType application/x-httpd-php-source .phps + <IfModule !mpm_netware_module> <IfModule !mpm_winnt_module> # ** phpMyAdmin [#xf451487] 標準のパッケージは依存関係で古いMySQLを欲しがるので&br; php5-mysql と phpMyAdmin の[[オリジナルpackage>FreeBSD/オリジナルpackage]]を作っておく。&br; また、依存関係で必要な pdflib だがパッケージが提供されていない、ライセンスの関係らしい。&br; これも[[オリジナルpackage>FreeBSD/オリジナルpackage]]で用意しておく。 pkg_add /mnt/new_package/pdflib-7.0.4.tbz pkg_add /mnt/new_package/php5-mysql-5.3.2_1.tbz pkg_add -vr phpMyAdmin # ↑は他の依存関係を解決するため、他の必要なパッケージが # すべて入って本体のインストールがエラーでとまるので。↓ pkg_add /mnt/new_package/phpMyAdmin-3.3.4.tbz cd /usr/local/etc/apache22/Includes/ cp /mnt/src/phpmyadmin.conf ./phpmyadmin.conf -- ==> phpmyadmin.conf <== Alias /phpmyadmin "/usr/local/www/phpMyAdmin/" <Directory "/usr/local/www/phpMyAdmin/"> DirectoryIndex index.php Options none AllowOverride Limit Order Deny,Allow Deny from all Allow from 192.168. </Directory> cd /usr/local/www/phpMyAdmin/ cp /mnt/src/config.inc.php ./config.inc.php --==> config.inc.php <== <?php $cfg['blowfish_secret'] = '"KEY"'; $i = 0; $i++; $cfg['Servers'][$i]['auth_type'] = 'cookie'; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['AllowNoPassword'] = false; $cfg['Servers'][$i]['bs_garbage_threshold'] = 50; $cfg['Servers'][$i]['bs_repository_threshold'] = '32M'; $cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600; $cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M'; $cfg['Servers'][$i]['controluser'] = 'root'; $cfg['Servers'][$i]['controlpass'] = 'PASS'; $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; $cfg['Servers'][$i]['history'] = 'pma_history'; $cfg['Servers'][$i]['tracking'] = 'pma_tracking'; $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; ?> #mysql-server-5.5.4に対応する patch -p0 < /mnt/src/create_tables.patch mysql -u root -pPASS < scripts/create_tables.sql --==> create_tables.patch <== --- scripts/create_tables.sql.orig 2010-09-02 18:02:50.000000000 +0900 +++ scripts/create_tables.sql 2010-09-02 16:39:19.000000000 +0900 @@ -80,7 +80,7 @@ `username` varchar(64) NOT NULL default '', `db` varchar(64) NOT NULL default '', `table` varchar(64) NOT NULL default '', - `timevalue` timestamp(14) NOT NULL, + `timevalue` timestamp NOT NULL, `sqlquery` text NOT NULL, PRIMARY KEY (`id`), KEY `username` (`username`,`db`,`table`,`timevalue`) ** dump [2] [#b8ea2ef1] - ココまでの状態を第二段階として dump しておく shutdown -r now mount_nfs 192.168.0.146:/mnt /mnt dump 0uafL /mnt/kenji/02_.dump / ---- [[FreeBSD]]