[[FrontPage]]
#contents
----
*/etc/mail/aliases [#b63d9e92]
root:my@mail.address
*portinstall net/rsync [#a60e1db6]
ssh-keygen -b 1024 -t dsa
*portinstall mail/postfix [#vfd63999]
portinstall mail/pflogsumm
[[VirusScan on FreeBSD 9.0R]]
http://piano2nd.smb.net/~kuji/pukiwiki-1.4.7/index.php?cmd=read&page=VirusScan%20on%20FreeBSD%209.0R&word=Virus%20Scan
portinstall security/clamav
[[VirusScan on FreeBSD 9.0R]]
portinstall japanese/mailman
[[Mailman on FreeBSD]]
[[Mailman-2.1.14+j7スクラッチインストール]]
portinstall www/apache22
mysqlオプションにチェックすると、
mysql-5.5.30.tar.gz が依存関係で入る
[[Apache on FreeBSD]]
----
portinstall japanese/p5-Mail-SpamAssassin
http://nhh.mo-blog.jp/ttt/2010/05/freebsd_portupg.html
----
portinstall databases/mysql55-server
[[MySQL on FreeBSD]]
portinstall databases/phpmyadmin
----
portinstall japanese/trac
portinstall devel/subversion
[[SVN Trac on FreeBSD]]
portinstall devel/p5-SVN-Hooks
root@g7:/root # trac-admin /usr/local/www/apache22/data/trac/RS_Base_2010 upgrade
root@g7:/root #
root@g7:/root # trac-admin /usr/local/www/apache22/data/trac/RS_Base upgrade
Database is up to date, no upgrade necessary.
root@g7:/root #
root@g7:/root # trac-admin /usr/local/www/apache22/data/trac/RS_Base wiki upgrade
portinstall www/trac-webadmin
----
2013-03-08
984 11:53 portinstall databases/mysql56-client
985 11:55 rehash
986 11:55 portinstall databases/mysql56-server
/etc/rc.conf
mysql_enable="YES"
mysql_dbdir="/home/mysql"
/usr/local/etc/my.conf
[mysqld]
datadir=/home/mysql
top
1399 mysql 21 52 0 536M 119M sigwai 0 0:00 0.00% mysqld
MySQL起動
root@g7:/root # /usr/local/etc/rc.d/mysql-server start
http://freebsd.server-manual.com/freebsd8_mysql5.html
root@g7:/root # mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.10-log Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SET PASSWORD FOR root@localhost=password('********');
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT user,host FROM mysql.user;
+------+--------------------+
| user | host |
+------+--------------------+
| root | 127.0.0.1 |
| root | ::1 |
| | g7.kuji-clinic.net |
| root | g7.kuji-clinic.net |
| | localhost |
| root | localhost |
+------+--------------------+
6 rows in set (0.00 sec)
mysql> DELETE FROM mysql.user WHERE user='';
Query OK, 2 rows affected (0.00 sec)
mysql> SELECT user,host FROM mysql.user;
+------+--------------------+
| user | host |
+------+--------------------+
| root | 127.0.0.1 |
| root | ::1 |
| root | g7.kuji-clinic.net |
| root | localhost |
+------+--------------------+
4 rows in set (0.00 sec)
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> DROP DATABASE test;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
*phpMyAdmin 2013-03-08 [#ead37b9c]
2013-03-08
http://9jp.info/archives/12024
root@g7:/usr/home/OpenPNE3-OpenPNE-3.6.8 # mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 35
Server version: 5.6.10-log Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> source /usr/local/www/phpMyAdmin/examples/create_tables.sql
Query OK, 1 row affected (0.00 sec)
Database changed
Query OK, 0 rows affected (0.03 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> grant all privileges on phpmyadmin.* to pma@localhost identified by 'pmapass';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
root@g7:/usr/home/OpenPNE3-OpenPNE-3.6.8 #
----
portinstall textproc/php5-xsl
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
