[Casper] 2 part question - Software update server and MySQL
John Wetter
john_wetter at hopkins.k12.mn.us
Mon Sep 29 15:01:23 PDT 2008
The MySQL one is probably a question for support, but I'll answer the first one:
We don't use managed preferences except for our 1-1 program, so we use Casper to enforce everything else, including software updates. I basically allow updates to go on the SUS server as we get a chance to test them a bit. Given time constraints, we usually only really test java updates (due to Infinite Campus), Safari updates (due to Webkit updates breaking NWEA testing in the past) and whole OS updates (just to make sure it doesn't break some app we use). ilife, iWork, Security Updates, etc. pretty much get approved after I read over the notes for them and haven't read in forums that it horribly breaks something. This way, a tech could do the 'check for updates' at any time and get a current set unless we're actively denying an update.
Then, in Casper I have a policy to set as server and install all updates. I have it set to 'run once per computer' and then once some updates build up, I flush the history for the policy so they get all the updates. I do this so we can let our staff know it's coming and also so we aren't interrupting staff constantly with updates. I usually flush the policy every 2-3 months being sure to avoid testing windows here in our K-12 environment.
-John
--
John Wetter
Technology Support Administrator
Technology & Information Services
Hopkins Public Schools
952-988-5373
john_wetter at hopkins.k12.mn.us
On 9/29/08 4:21 PM, "Thomas Larkin" <tlarki at kckps.org> wrote:
First and easiest question
I have set up a SUS and it is now currently caching downloads. It has a static IP and FQDN. I have it set as the default SUS in all network segments. Now, I can go into WGM in our open directory and apply the Software Update Server to my nested groups and the clients can update that way, or I can possibly use the Casper Suite. How do you all implement software updates? I want to be able to push out security updates and the 5.5 client update for OS X.
Second question
My JSS is running out of HD space on the boot volume, which is 75gigs and all it has is a basic load of OS X server 10.5 on it. I ran a disk usage command and go these results
xs001-casper:/ root# du -x -h -d 1/
288K./.fseventsd
33M./.Spotlight-V100
0B./.Trashes
0B./.vol
1.0G./Applications
7.6M./bin
0B./cores
512B./dev
0B./Groups
1.0K./home
4.5G./Library
1.0K./net
1.0K./Network
47G./private
5.7M./sbin
4.0K./Shared Items
3.7G./System
7.1G./Users
1.4G./usr
4.0K./Volumes
65G.
if you look, /private is 47gigs in size, which should automatically tell you , hey this isn't right. So upon further investigation it shows that /private/var/mysql is the culprit. I looked into it and I have a ton of bin files in the mysql directory that are just eating away HD space
Here is the du report on the mysql direcotry:
xs001-casper:mysql root# du -x -h -d 1/
13G./jamfsoftware
756K./mysql
0B./test
41G.
Here are the files in the directory, notice that I have a lot of these bin files about 1 gig in size
xs001-casper:mysql root# ls -al
total 59105792
drwxr-xr-x 55 _mysql admin 1870 Sep 29 15:54 .
drwxr-xr-x 33 root wheel 1122 Aug 14 20:30 ..
-rw-rw---- 1 _mysql admin 5242880 Sep 29 15:54 ib_logfile0
-rw-rw---- 1 _mysql admin 5242880 Aug 13 19:05 ib_logfile1
-rw-rw---- 1 _mysql admin 10485760 Sep 29 15:53 ibdata1
drwx------ 295 _mysql admin 10030 Sep 29 15:31 jamfsoftware
drwx------ 53 _mysql admin 1802 Aug 13 19:05 mysql
-rw-rw---- 1 _mysql admin 14701 Aug 13 19:05 mysql-bin.000001
-rw-rw---- 1 _mysql admin 588296 Aug 13 19:05 mysql-bin.000002
-rw-rw---- 1 _mysql admin 1074389036 Aug 13 19:25 mysql-bin.000003
-rw-rw---- 1 _mysql admin 1074186439 Aug 13 19:27 mysql-bin.000004
-rw-rw---- 1 _mysql admin 303974352 Aug 13 19:52 mysql-bin.000005
-rw-rw---- 1 _mysql admin 705832 Aug 13 20:16 mysql-bin.000006
-rw-rw---- 1 _mysql admin 233165 Aug 13 20:27 mysql-bin.000007
-rw-rw---- 1 _mysql admin 985680 Aug 13 20:56 mysql-bin.000008
-rw-rw---- 1 _mysql admin 127128263 Aug 15 13:03 mysql-bin.000009
-rw-rw---- 1 _mysql admin 54635342 Aug 20 10:55 mysql-bin.000010
-rw-rw---- 1 _mysql admin 2042997 Aug 20 13:44 mysql-bin.000011
-rw-rw---- 1 _mysql admin 1073747635 Aug 26 09:50 mysql-bin.000012
-rw-rw---- 1 _mysql admin 1073741874 Aug 27 19:16 mysql-bin.000013
-rw-rw---- 1 _mysql admin 1073742069 Aug 29 12:27 mysql-bin.000014
-rw-rw---- 1 _mysql admin 1073741954 Sep 2 11:37 mysql-bin.000015
-rw-rw---- 1 _mysql admin 1073756134 Sep 3 11:06 mysql-bin.000016
-rw-rw---- 1 _mysql admin 1073741890 Sep 4 11:25 mysql-bin.000017
-rw-rw---- 1 _mysql admin 1073754600 Sep 5 09:51 mysql-bin.000018
-rw-rw---- 1 _mysql admin 1073759270 Sep 8 07:59 mysql-bin.000019
-rw-rw---- 1 _mysql admin 1073743668 Sep 8 23:06 mysql-bin.000020
-rw-rw---- 1 _mysql admin 1073752134 Sep 9 13:12 mysql-bin.000021
-rw-rw---- 1 _mysql admin 1073742881 Sep 10 10:49 mysql-bin.000022
-rw-rw---- 1 _mysql admin 1073741896 Sep 11 10:26 mysql-bin.000023
-rw-rw---- 1 _mysql admin 1073741974 Sep 12 08:04 mysql-bin.000024
-rw-rw---- 1 _mysql admin 1073742013 Sep 12 12:34 mysql-bin.000025
-rw-rw---- 1 _mysql admin 1073743302 Sep 15 09:52 mysql-bin.000026
-rw-rw---- 1 _mysql admin 1073741978 Sep 15 16:18 mysql-bin.000027
-rw-rw---- 1 _mysql admin 1073743164 Sep 16 11:51 mysql-bin.000028
-rw-rw---- 1 _mysql admin 455707160 Sep 16 14:04 mysql-bin.000029
-rw-rw---- 1 _mysql admin 146945607 Sep 16 16:25 mysql-bin.000030
-rw-rw---- 1 _mysql admin 112651946 Sep 17 08:23 mysql-bin.000031
-rw-rw---- 1 _mysql admin 1073742044 Sep 17 18:30 mysql-bin.000032
-rw-rw---- 1 _mysql admin 1073741957 Sep 18 11:16 mysql-bin.000033
-rw-rw---- 1 _mysql admin 1073744488 Sep 19 08:04 mysql-bin.000034
-rw-rw---- 1 _mysql admin 1073741905 Sep 19 12:22 mysql-bin.000035
-rw-rw---- 1 _mysql admin 366354291 Sep 19 14:11 mysql-bin.000036
-rw-rw---- 1 _mysql admin 817626683 Sep 22 10:26 mysql-bin.000037
-rw-rw---- 1 _mysql admin 1073745275 Sep 23 08:14 mysql-bin.000038
-rw-rw---- 1 _mysql admin 1073756082 Sep 23 13:15 mysql-bin.000039
-rw-rw---- 1 _mysql admin 343654400 Sep 24 08:06 mysql-bin.000040
-rw-rw---- 1 _mysql admin 359678206 Sep 24 09:54 mysql-bin.000041
-rw-rw---- 1 _mysql admin 286920704 Sep 29 08:09 mysql-bin.000042
-rw-rw---- 1 _mysql admin 16091601 Sep 29 15:53 mysql-bin.000043
-rw-rw---- 1 _mysql admin 414656 Sep 29 16:17 mysql-bin.000044
-rw-rw---- 1 _mysql admin 836 Sep 29 15:54 mysql-bin.index
srwxrwxrwx 1 _mysql admin 0 Sep 29 15:54 mysql.sock
drwx------ 2 _mysql admin 68 Aug 13 19:05 test
-rw-rw---- 1 _mysql admin 5 Sep 29 15:54 xs001-casper.kckps.org.pid
What can I delete? What can I optimize? I am not a mysql expert and am still learning how to use the command line and what I can get rid of and what I need to keep.
Thanks in advance for any advice on either question
___________________________
Thomas Larkin
TIS Department
KCKPS USD500
tlarki at kckps.org
blackberry: 913-449-7589
office: 913-627-0351
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.jamfsoftware.com/pipermail/casper/attachments/20080929/bddafe03/attachment-0001.html
More information about the Casper
mailing list