Daily Archives: June 20, 2009

0
Filed under WEB-DEV-LOG
Tagged as

www.cyberciti.biz/tips/howto-keep-freebsd-system-upto-date.html

Upgrade FreeBSD ports collection
#portsnap fetch extract

Display outdated ports list

You can list outdated ports list with pkg_version command:
# pkg_version -vIL=
# pkg_version -vIL’<‘

Update FreeBSD packages / software

Now run portmanager to upgrade installed ports:
# portmanager -u

If you need to upgrade all installed ports with logging, enter:
# portmanager -u -l

How do I apply binary security updates for FreeBSD?
# freebsd-update fetch
# freebsd-update install

FreeBSD mysql on all ports. quick fix

0
Filed under WEB-DEV-LOG
Tagged as

By default ports does not create a my.cnf file.

By default MySQL accepts connection over the LAN. I prefer to restrict it to localhost only. Starting with more recent versions of the FreeBSD MySQL port, you can do this:

$ grep mysql /etc/rc.conf
mysql_enable=”YES”
mysql_args=”–bind-address=127.0.0.1″

Then restart mysql:

# /usr/local/etc/rc.d/mysql-server.sh restart
Stopping mysql.
Waiting for PIDS: 90230.
Starting mysql.

Before:

# netstat -an | grep 3306