reinstall 8.1
my example ip is 192.168.1.1
1. portsnap fetch extract
portsnap fetch upgrade
/usr/ports 10G
2. setup ntp.conf
3. setup ipf.rules
4. pureftpd
create ftp account
mail#pw groupadd ftp
mail#pw useradd -n ftp -u 2010 -s /sbin/nologin -d /dev/null
5. dovecot
User administrator not allowed to log in using too low primary UNIX group ID 0(wheel)
(see first_valid_gid in config file)
6. isc-dhcpd
ok
7. mysql
make WITH_CHARSET=utf8 WITH_XCHARSET=all WITH_COLLATION=utf8_general_ci BUILD_OPTIMIZED=yes BUILD_STATIC=yes install clean
In conjunction with the user change in the previous section, you should also change the permissions on the database files. I used the opportunity to move the database files to another location. By default, the database files are located in /var/db/mysql. This can be changed by modifying the script /usr/local/bin/safe_mysqld. But I prefer to leave scripts unchanged and just move the files. So I did this:
cd /var/db
mv mysql /usr/local/
ln -s /usr/local/mysql mysql
Then I changed the permissions.
cd /usr/local
chown -R mysql mysql
And then restarted mysqld.
mysql_install_db
WARNING: The host 'nagi.et.local' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
OK
Filling help tables...
OK
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h hostname.example.com password 'new-password'
cd /var/db/mysql
chown mysql mysql
chown mysql test
chown mysql performance_schema
8. apache?
modify /etc/hosts
192.168.1.1 hostname hostname.example.com
9. php
modify httpd.conf
addtype php
must restart apache
10. phpmyadmin
many package
phpMyAdmin-3.3.8 has been installed into:
/usr/local/www/phpMyAdmin
Please edit config.inc.php to suit your needs.
To make phpMyAdmin available through your web site, I suggest
that you add something like the following to httpd.conf:
Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"
Options none
AllowOverride Limit
Order Deny,Allow
Deny from all
Allow from 127.0.0.1 .example.com
use session method. Not to use config method.
mysqladmi -u root -p password /* change root password */
login phpmyadmin with root and new password, ok.
11. phpbb
phpBB3 has been installed, but is not quite ready to be used yet!
You have to ensure that you have a database server (or ODBC access to a
remote database) installed and configured, and you have to ensure that your
PHP installation has been compiled with support for your database or
database access method. You have to create a database for phpBB3 to use,
and ensure that this database may be accessed and changed by the user id
under which your web server executes. Further information on these
installation procedures may be found in:
/usr/local/share/doc/phpbb/README.html
Once these steps have been taken, you may connect to the following URL to
configure your installation of phpBB3:
http://localhost/phpBB3/
After configuring phpBB3 and ensuring that it is operational, you MUST
remove or rename the install/ directory from /usr/local/www/phpBB3:
user right:
myself as global moderator
12. cacti
Cacti is now installed. If you intall it for the first time,
you may have to follow this steps to make it work correctly:
1. Create the MySQL database:
# mysqladmin --user=root create cacti
2. Create a mysql user/password for cacti:
(change user and/or password if required)
# echo "GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'cactiuser'; FLUSH PRIVILEGES;" | mysql
3. Import the default cacti database:
# mysql cacti < /usr/local/share/cacti/cacti.sql
4. Edit /usr/local/share/cacti/include/config.php.
5. Add the line to cron jobs with the command:
# crontab -u cacti -e
*/5 * * * * /usr/local/bin/php /usr/local/share/cacti/poller.php > /dev/null 2>&1
6. Add alias in apache config for the cacti dir:
Alias /cacti "/usr/local/share/cacti/"
7. Be sure apache gives an access to the directory ('Allow from' keywords).
8. Open a cacti login page in your web browser and login with admin/admin.
If you update cacti, open a login page, an updating process
will start automatically.
modify cacti.sql
"TYPE=MyISAM" with "ENGINE=MyISAM"
/var/cron/tabs/cacti
*/5 * * * * /usr/local/bin/php /usr/local/share/cacti/poller.php > /dev/null 2>&1
crontab -u cacti -l /* list */