Changes

Machine/Discovery One/Node (view source)

Revision as of 15:55, 21 February 2010

1,333 bytes removed , 15:55, 21 February 2010

m

no edit summary

Line 38: Line 38:

/etc/init.d/networking restart

−

~~== Install Database ==~~

−

~~===Install needed packages===~~

−

~~apt-get install mysql-client-5.0 mysql-server-5.0~~

−

~~===Log Rotate===~~

−

~~/etc/logrotate.d/mysql-server~~

−

~~<pre>~~

−

~~# - I put everything in one block and added sharedscripts, so that mysql gets~~

−

~~# flush-logs'd only once.~~

−

~~# Else the binary logs would automatically increase by n times every day.~~

−

~~# - The error log is obsolete, messages go to syslog now.~~

−

~~/var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log {~~

−

~~daily~~

−

~~rotate 7~~

−

~~missingok~~

−

~~create 640 mysql adm~~

−

~~compress~~

−

~~sharedscripts~~

−

~~postrotate~~

−

~~test -x /usr/bin/mysqladmin || exit 0~~

−

~~# If this fails, check debian.conf!~~

−

~~MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"~~

−

~~if [ -z "`$MYADMIN ping 2>/dev/null`" ]; then~~

−

~~# Really no mysqld or rather a missing debian-sys-maint user?~~

−

~~# If this occurs and is not a error please report a bug.~~

−

~~if ps cax | grep -q mysqld; then~~

−

~~exit 1~~

−

fi

−

~~else~~

−

~~$MYADMIN flush-logs~~

−

fi

−

~~endscript~~

−

}

−

~~</pre>~~

−

~~=== Turn off database by default ===~~

−

~~#FIXME~~

−

~~sudo update-rc.d -f mysql remove~~

== Install php server ==

Dfarning

2,751

edits