Page 1 of 2 12 LastLast
Results 1 to 10 of 13
  1. #1
    Newbie
    Join Date
    Dec 2010
    Posts
    10

    Default Captive Portal disk usage

    Can the patch be applied remotely? I have 2 boxes that are full since the 9.1 upgrade; I have tried applying remotely and it has made no difference.

    Thanks for any assistance.

  2. #2
    Newbie
    Join Date
    Dec 2010
    Posts
    10

    Default

    Sorry.. need 5 post to paste results which include links

  3. #3
    Newbie
    Join Date
    Dec 2010
    Posts
    10

    Default

    one more (sorry not spamming)

  4. #4
    Newbie
    Join Date
    Dec 2010
    Posts
    10

    Default

    Here are my results.

    Please accept my apologies for the multiple posts. :-)

    ~ # curl http://www.untangle.com/download/pat...ric/diskuse.sh | dash
    % Total % Received % Xferd Average Speed Time Time Time Current
    Dload Upload Total Spent Left Speed
    100 793 100 793 0 0 1102 0 --:--:-- --:--:-- --:--:-- 0
    Disk Free Status
    Filesystem Size Used Avail Use% Mounted on
    /dev/sda1 145G 137G 0 100% /
    tmpfs 944M 0 944M 0% /lib/init/rw
    udev 10M 700K 9.4M 7% /dev
    tmpfs 944M 0 944M 0% /dev/shm
    overflow 1.0M 100K 924K 10% /tmp
    Top 20 Tables
    relname | reltuples | relpages
    ---------------------------------+-------------+----------
    n_cpd_block_events | 1.45146e+09 | 12135923
    n_cpd_block_events_event_id_idx | 1.45146e+09 | 3993003
    n_cpd_block_evt | 1.09721e+07 | 102543
    n_cpd_block_evt_ts_idx | 1.09721e+07 | 30094
    n_cpd_block_evt_pkey | 1.09721e+07 | 30085
    n_http_events | 410190 | 15636
    pl_endp_sid_idx | 40 | 5977
    sessions | 376474 | 5700
    pl_stats_plepid_idx | 1 | 4766
    pl_endp_ts_idx | 40 | 3589
    pl_endp_pkey | 40 | 3589
    n_http_evt_req_pkey | 0 | 3358
    n_http_evt_req_ts_idx | 0 | 3358
    n_http_evt_req_rid_idx | 0 | 3358
    n_http_req_line_pkey | 0 | 3358
    pl_stats_pkey | 1 | 3324
    n_http_evt_resp_pkey | 0 | 2929
    n_http_evt_resp_rid_idx | 0 | 2913
    n_http_events_event_id_idx | 410190 | 1997
    n_http_events_policy_id_idx | 410190 | 1948
    (20 rows)

    Oldest record in database

    Disk Use of /var/log - Top 10 files
    163652 /var/log/uvm
    16628 /var/log/messages.1
    15996 /var/log/user.log.1
    5988 /var/log/messages
    5764 /var/log/user.log
    4508 /var/log/daemon.log.1
    3048 /var/log/syslog.1
    2236 /var/log/untangle-net-alpaca
    1748 /var/log/untangle-cpd
    1268 /var/log/syslog
    Disk Use of /var/log/uvm - Top 10 files
    13700 /var/log/uvm/uvm.log
    13672 /var/log/uvm/uvm.log.crash
    13644 /var/log/uvm/uvm.log.crash.1
    13620 /var/log/uvm/uvm.log.crash.2
    8044 /var/log/uvm/schema-err.log
    5020 /var/log/uvm/6.log.8
    5020 /var/log/uvm/6.log.7
    5020 /var/log/uvm/6.log.3
    5020 /var/log/uvm/6.log.2
    5020 /var/log/uvm/6.log.1
    Disk Use of postgres db files
    135G /var/lib/postgresql/8.3
    Disk Use of /usr/share/untangle/web/reports/ (old reports)
    58M /usr/share/untangle/web/reports
    Disk Use of /tmp
    60K /tmp
    Disk Use of /var
    4.0K /var/agentx
    2.4M /var/backups
    661M /var/cache
    135G /var/lib
    4.0K /var/local
    8.0K /var/lock
    224M /var/log
    4.0K /var/mail
    4.0K /var/opt
    140K /var/run
    72K /var/spool
    12K /var/tmp
    43M /var/www

    And another box......


    ~ # curl http://www.untangle.com/download/pat...ric/diskuse.sh | dash
    % Total % Received % Xferd Average Speed Time Time Time Current
    Dload Upload Total Spent Left Speed
    100 793 100 793 0 0 364 0 0:00:02 0:00:02 --:--:-- 0
    Disk Free Status
    Filesystem Size Used Avail Use% Mounted on
    /dev/hda1 149G 142G 0 100% /
    tmpfs 502M 0 502M 0% /lib/init/rw
    udev 10M 656K 9.4M 7% /dev
    tmpfs 502M 0 502M 0% /dev/shm
    shmfs 502M 12K 502M 1% /lib/init/rw/splashy
    Top 20 Tables
    relname | reltuples | relpages
    ---------------------------------+-------------+----------
    n_cpd_block_events | 1.66793e+09 | 13899392
    n_cpd_block_events_event_id_idx | 1.66793e+09 | 3657735
    n_http_events | 1.63924e+06 | 97024
    sessions | 1.20386e+06 | 28970
    session_totals | 1.2735e+06 | 22832
    n_http_events_request_id_idx | 1.63924e+06 | 22697
    n_http_events_event_id_idx | 1.63924e+06 | 18717
    n_http_events_policy_id_idx | 1.63924e+06 | 16427
    sessions_pl_endp_id_idx | 1.20386e+06 | 13147
    n_http_totals | 414051 | 11498
    sessions_event_id_idx | 1.20386e+06 | 10437
    session_totals_trunc_time_idx | 1.2735e+06 | 9739
    sessions_policy_id_idx | 1.20386e+06 | 9635
    session_counts | 326028 | 3695
    session_counts_trunc_time_idx | 326028 | 3613
    n_cpd_block_evt | 390935 | 3460
    n_cpd_block_totals | 343198 | 2703
    n_cpd_block_evt_ts_idx | 390935 | 1075
    n_cpd_block_evt_pkey | 390935 | 1075
    pl_stats | 29772 | 678
    (20 rows)

    Oldest record in database
    2011-12-19 16:56:52.854

    Disk Use of /var/log - Top 10 files
    154044 /var/log/apache2
    91364 /var/log/uvm
    21692 /var/log/postgresql
    7212 /var/log/daemon.log.1
    2272 /var/log/mail.log.1
    2272 /var/log/mail.info.1
    2100 /var/log/daemon.log
    1760 /var/log/untangle-cpd
    1752 /var/log/syslog.1
    1312 /var/log/messages.1
    Disk Use of /var/log/uvm - Top 10 files
    8752 /var/log/uvm/uvm.log.crash.1
    5016 /var/log/uvm/4.log.9
    5016 /var/log/uvm/4.log.8
    5016 /var/log/uvm/4.log.7
    5016 /var/log/uvm/4.log.6
    5016 /var/log/uvm/4.log.5
    5016 /var/log/uvm/4.log.4
    5016 /var/log/uvm/4.log.3
    5016 /var/log/uvm/4.log.2
    5016 /var/log/uvm/4.log.1
    Disk Use of postgres db files
    139G /var/lib/postgresql/8.3
    Disk Use of /usr/share/untangle/web/reports/ (old reports)
    94M /usr/share/untangle/web/reports
    Disk Use of /tmp
    132K /tmp
    Disk Use of /var
    4.0K /var/agentx
    2.5M /var/backups
    564M /var/cache
    140G /var/lib
    4.0K /var/local
    8.0K /var/lock
    288M /var/log
    4.0K /var/mail
    4.0K /var/opt
    144K /var/run
    72K /var/spool
    4.0K /var/tmp
    43M /var/www
    Thanks again.
    Last edited by bowerj01; 12-20-2011 at 02:54 AM.

  5. #5
    Untangle Junkie dmorris's Avatar
    Join Date
    Nov 2006
    Location
    San Mateo, CA
    Posts
    14,598

    Default

    please don't thread jack, it creates a lot of confusion.
    Your issue has nothing to do with logrotate.

    Run this patch or email support with your UID and enable remote support and we will fix it for you.

    http://wiki.untangle.com/index.php/9...tabase_cleanup
    Attention: Support and help on the Untangle Forums is provided by volunteers and community members like yourself.
    If you need Untangle support please call or email support@untangle.com

  6. #6
    Newbie
    Join Date
    Dec 2010
    Posts
    10

    Default

    Quote Originally Posted by dmorris View Post
    please don't thread jack, it creates a lot of confusion.
    Your issue has nothing to do with logrotate.

    Run this patch or email support with your UID and enable remote support and we will fix it for you.

    http://wiki.untangle.com/index.php/9...tabase_cleanup
    That was not my intention, the symptoms other posters described in a different thread (which these posts were in) were identical to my own. (Thread: Hard disk filling up, before 9.x had 80%+ free)

    The question I asked was can I apply this patch remotely (which I have tried and it had no effect) or does it have to be applied locally for it to work.

    We have around 10 Untangle boxes and these two were unfortunately left on automatic upgrade, one of these systems supports over 300 users and they are considering purchasing several licenses, (bandwidth control, directory connector and web cache)

    As a new member and instantly being accused of thread jacking

    Thanks anyway, I will ask elsewhere.

    Merry Christmas and a happy new year.
    Last edited by bowerj01; 12-21-2011 at 06:38 AM.

  7. #7
    Untangle Junkie dmorris's Avatar
    Join Date
    Nov 2006
    Location
    San Mateo, CA
    Posts
    14,598

    Default

    Quote Originally Posted by bowerj01 View Post
    The question I asked was can I apply this patch remotely (which I have tried and it had no effect) or does it have to be applied locally for it to work.
    Yes, you can. Its the same.
    What did it say when you ran it?
    Attention: Support and help on the Untangle Forums is provided by volunteers and community members like yourself.
    If you need Untangle support please call or email support@untangle.com

  8. #8
    Newbie
    Join Date
    Dec 2010
    Posts
    10

    Default

    I ran the patch and the results were as follows:

    ~ # curl http://untangle.com/download/patches...ent_cleanup.sh
    #!/bin/dash
    if [ `cat /usr/share/untangle/lib/untangle-libuvm-api/VERSION` != '9.1.0' ] ; then
    echo "This patch can only be run on 9.1.0" ;
    exit 1
    fi
    patch_fs()
    {
    openssl enc -d -a | tar -C / -zxf -
    }
    cat <<LONG_EOF_STRING | patch_fs
    H4sIAENd4k4AA+1ce3PaSBLP33yKOa5SSBuFgOPHleu4OgI4cS0GH+Db3fJRKhkGo4tAijR47bu6
    7349L2n0BGzH2eyqNwnSqLunZ3r6Nz2j0dbfvfrq1AA6OTmiv82To4b4fc/KBb1qNo9PGodHQMev
    Gs1mE37Q0dc37dWrTUAsH6FX85Xr+3aQy7ft+XdK9XebwP/KY+AR/j85Pin9/xLE/e/YN19xDOzv
    /4Oj90el/1+CIv97D2Tprg/qR88+Evb3/+H7xvvS/y9BWf73sef6JHi2cbC//4+Bo/T/S1CR/9fu
    HD/HINjH/yfNJvX/SbOc/1+Etvp/sybW+tbBJr0zZ9687j3sWQd18PHxYY7/DxuHBwdx/x8cnBwC
    /je+SosT9Af3v72ivka3mBB8Tyri1nFvb+31rbxd3csrMTTqM9dx/QBZAeJXyed28y9rc4kdD/vJ
    R8EXRzyh4tFdpbLw3RXygoeZ690e1MEcvA5sdx0goaFrEXwGPBf3W1n/sXEJno+JT1uxjXlirzCM
    gpWnKhfmSp7O0vJJ9hPX2azWXRzMMh9325OeeTYcXbQnk94omwUTy3bGeEbAqkyOj77lLTOffLJv
    lw78zbbt0/BqtKXyH/HDmFjEDoid3YDL857Z+dQeTTKfjtht5qPxpN35sdc1P7RHBQrGm9XK8h+K
    Wj85v+iZwzOz2/5lS2MY57g3Ou+NM6qs4zWMahx3XBHHmTUjE+vGwUVMn4bjidkdnff73eFPgyLO
    ASBo0fPJ8NLs9/7Z6xcxXUHz8qpTQktwexAAxCT2isZBxUStrAitQ/SbxLfWgWNRJ2g1CfpvKei/
    BdCv6XVHYsQcL9DA1CBmAusW66egkmz8NRIFlUp/+PF8AFWZWq3vgu01vXJ1SeOAl115cwhkKAS+
    4dUkZHQ3BArP2uf9XpcXnkFYYKi7wuq0NsQ17fXM1yhkE/POcja41TCQtXLBYBBp6qcVBHQH19cK
    05SVUh0LTbBQmm18HzPBu+vGNCymN+hNS6gNi0UrhVClopQtKpWZYwUB6nhzjXpZVEJrNMFkm5im
    FmBnoVRO2eqxhwbK6vdKqCmAyjzByRtH+9FAeD1nV4pyygTKZz6GcnNNp23Toa4w8R0YH2iZ8oXi
    N447+7ybeHixoH0bBpFWk2NPNYi4xHKCmhEKJShTiJtRIAQjHpsM02sGup7Sv7riSTWw6j6+BfTD
    vrkAS03CTF0Q0fG8GfUVtoKNj4O65XnQYI1jh1Zj5hQYErcKYhHfYn9H9uqMjj+t0x730E+fegPE
    Wg09WmMBVkMTWthEvT4wDK76fdQbdPWqru9i+IYF4YtbznHgaaY7DCq+RacDWj3N9AUAGi3fyZi9
    LM+3mwNqgd07hisHgD3DVUWNHcM1j+ladqLnu8SFsK6dDyYHNT2/d6TAzLGhfoBasqgZ+0pZ8zk4
    LGCCvckuggH27wBNkoLT7S1jvUUlbmyAFULbyN36gw7yjwMwOnOw+d2dmSu8usF+sLS95GwkJrLr
    MAWZRtKe5XPQzxaJJq27VW0ar5QbmpQMeK4X0Fl6Gg0/eh/PBqEv+T30BKQD4qHIOYtcwTrVm4fJ
    MbOgvrZWuFgIlhi283BF0xhtC+fE9a7A08EOfB+oW/G8wwYUCEz1VFdIoAiUcEw+Y7kUXytoer4K
    VluaLem3UeQaI9ShjBkes+bMwdY6TDtmkIItVFcS/+E01vwoBa37m7UJt1q1Wv1Xpdvr9yABPBsN
    L4TqxIROKgBbox6KoAD9Fb0OQNhAGq/XUJqD72fYI6cwOIOg8ozmSMB6sjm0D0WcbutExci573om
    BByxqT/wXERzNZ38VENFj9XDoTzSkxopO+tTUf4pdqlTTIYedvH32JJG9nRhrrtTxhzZKDRlWElH
    TmfUoyuZSftDv4fyc1OkMdXK8CFylwH9apMlZDCsBP0HKuAIwsUpSCG6zuKFfBqP7mERtDTJg6fy
    KDMVgvlAlTTtOaLr4XZfZ0M3kRln5/FZnQLKzZmYpooyclST9dJrAEjbcmqZQ0HGY0306Pmg2/sZ
    pXWaUiH8uUfDQUGna5JVrymtmLnrNUwtStV0aqKlYpbR98eP8wH06gRsngwL7BGqtKjPDcXLBneR
    EfnUUF2pV8YAUp0JepR0pQBp6UjYllLCtIaiLmrRS4OvwGfuamWT1hnEqLLmkx1d54+1JDSiHvsB
    XWD4aVrMdx3nxpp91uIqfcsOMMKV3UM/vk59qdBXa31E6LOUlo6mg1hE04w1XSoSS0TTytgDtuMD
    7Ie8NJ6HKuziQYL9pfAiviR4HrxQdW7Bi9j4UPFCHY4vBxeqOVlwwUaGoQ4IIzEODNX9RsLrhurs
    TER5zgoyQCfMp75H0Il29aKVRHiVt8dnILbOiKoLJZLbfQzGi/rE1Jgq9AZV4b83xaxV8OQMPILn
    1VACVV9rfItKD6o7qtmAQ/k8IzwZ7hFk4y+NjqVsooRcCQ6GGO5w8xDktnXpBqQ1oGiIaO3iEq9g
    CcOulc60F4wbuT5jpb+ML+5dscahshE64TmEdfQOSUtvXAK7+SvGn7P50Fu0uq/TB/SFUXjRxQ6x
    NKWZ6pbKlw2GBWsLMRQQ0dcZtvu9caenweJWesdADZ2+DuO3PI7yd0vl2gQwZmayqeRvLVicoPag
    qxaKBUt6CbgHxM02Pl2X8yiDa9fXlOYt4dF//5ePh1Siju8xZPJYY30BqyfZy+DhudpXUmHCLECZ
    jQM9azPTYP2vUa16aixF21j22nKcpCUxmEguhpcy1JX1P3vntsNGPuNL7+RTHXzbgqmrbQ+iW6qo
    MH6yAyUjqvJCh5XTmFFjaIfQieZ98M/e8RDp+TOaExZcD2jCRnIdockSA9paPqxolvCXFSMXphR2
    DwBkwyPQU1e0eDSUL4EFNDEVdoDgDxVYb+geF3IXyEIsj5ttHMsX6yj6ZiymyvksdqFkgRKwqXgd
    X11oc1LnMWp6c/3d68BoQOyGHBftn+Mc9LHUnaGH7mNvUSRZijTJbeUiVSrPFqu47TBdxCzg9xlV
    pTQle2G7JlAjtTDo09QhKdxA7RNoidpjFGrPGv+Cl9YnmUXdedzSGsaumJbFz17pT0ZXg45Wg9FU
    MyLMZeJQpkptA3OFdXdcV6U+joZXl+jDL2rF3BBSUfH/qbAvH6bT3s2KhVE1NpiUqe30dOG4FsnJ
    AFNizG8xuSyxHXSFXlWVTSu5WvA98S3z1yX2cWJzmpK9UNEYtVqoeZoyguXW9M2Nf2c5oOS4gX6A
    f1J8G5guKM58cjd+NfV04fori4ASYEkc4ojZC+nwdhMODpkJxXYAkhabkTjIkmSNFXwxsmZyC0Ad
    psK5yUCWpj8wpVXzI2P7giFNygp1f+Fw1n2EaGzkKHeP0JX0X+w+sfqJJVjQ64l8ir3kjc9wlHho
    ZpbT2Es/kIGUERUwRhDdd+S2LDCZLSH9Us9ZxIyRryn868Y0ncRxwyKeZjYPNTJiOshgkgZHXO+n
    eiqc1y4RVaatjfqoYUxzBKkdmZKyF3NEpXVpWbWjqXA8N/Oy0uMvG8iQ5rAAt/OOZuw3BnOTOroe
    GmOYE+aBFh+TiZ5lSZV6sEyDNLjNox/1+ZEJgGRl/YPeIQevNd/b8jYN0ZNHtR7fPNLf1N7V3pga
    hTA9PgQgr5Oe/5xYK2Qad2HdK4atrPtw9noWc7Z1CDvPEPUIz1t+G10iTRN9wqfmb2KQ7K8zeYhC
    dFiUuv0Gekw1jnZZlIF80z6TmtWgeyPc+eY31YGRpcqIS5v6VQzcZwtBloYXnuPSRIodFNbo+5hW
    6gBsjtHEJg5usSMK7DKH7d6xbrDTEg3JYXqQTGHrcxhX1r9d3wwTvFY8y8wRSkw2LRgpsfazbX+Y
    cawAE41N9+KVFf2VhoU4m+9Cdqi8xY+W129dd77GQbBTVXSUxOsSALZjZXNMYDGE59srk0NRqU0J
    /h2ru7FE05I7UhoMTYPVrYf70OGRk6dtTRHXe0v3fQK+PQVaUcfyiH2H0SVk4pByslq+7x2rb7zZ
    K/eOlPe18iTX6Sn05i57veKlEN8TGAxVZeh8zM7wVejOAN/a+lN01I+VKq8flU2E+GmWSrhzEKmm
    xj9mxyBz7zd/51hy7LU7nNqto+TZmIUm34p+5NJkY9Px4qvHwMNK5TqArkYqqcfpiQx0Rag3UAAv
    YymTM/8k23YNOqdQjxgyYfv22OlOT0/hhx1GagZKyDH4k7ZQCJTXBprbgedYD6Zj0/dzzUYRkhmI
    PQ/BLHEu7umodsMVJtFN1INERSWwPQOwJV4R06ySn16N8I3fZ+Gbes5Lwbfk+QaOccndz/wt0RDN
    4or+mIiW6MwccOM+2gPckkcDuAIWah/46eWnwFxcO0U8MYjC9n+XiCcgTz3AG/vmbwfQi/GnwA+C
    6i2bG96G52rAIZ3LLq8zXFQlzoTzAzrynf1+b+FD/JKv4an4Dvjls4+zoo8mtfgJIwrZcE/Xf7Uu
    +0wsCaqqaJS2cFHe2gG91wsFWTeJ6mBkAPc05Ub/Lt5b9DRP/oGyR/ffvq9ivzhxJM45HljZ8t1Q
    7XVQ40oLPhehTPQ7kR2T1J1yzuGo2xtRlFYedHvjDn1VhV4jjRlpIG5H6ENlJot6X896HE6I6cCE
    vpOxqJ6Sf/5YZKiVikWZh/xeozH5xQxrNytDbVFWHJXKObOY9CX73KNQNPnRDftehJXtWLdyjC0m
    Ler+XcAD1ZWYwfX46T6ph3HG+1TPOOpXcJbxGRHh+WI/78Mp+rmtRj/eBcFv/X9kKKmkkkoqqaSS
    SiqppJJKKqmkkkoqqaSSSiqppJJKKqmkkkoqqaSSSiqppJJKKqmkkkoqpv8Dj9VqDgB4AAA=
    LONG_EOF_STRING

    echo
    echo
    echo "Patch applied."
    echo
    echo
    echo "Cleaning out old events... (this will happen automatically from now on)"
    echo
    echo

    /etc/init.d/postgresql-8.3 restart
    sleep 5
    echo 'truncate table reports.n_cpd_block_events' | psql -U postgres uvm > /dev/null 2>&1
    echo 'truncate table events.n_cpd_block_evt' | psql -U postgres uvm > /dev/null 2>&1
    Unfortunately, I can no longer access the GUI remotely after running the patch, only via SSH.

    The box is approximately 100 miles away, may need to go to site and reinstall :-(

    Thanks for the reply though.

  9. #9
    Untangle Junkie dmorris's Avatar
    Join Date
    Nov 2006
    Location
    San Mateo, CA
    Posts
    14,598

    Default

    You need to this command

    This:
    does nothing. it just prints it to the screen.

    Just email us your UID at support@untangle.com and we'll take a look if you have remote support enabled.
    I wouldn't go driving anywhere just yet.
    Attention: Support and help on the Untangle Forums is provided by volunteers and community members like yourself.
    If you need Untangle support please call or email support@untangle.com

  10. #10
    Newbie
    Join Date
    Dec 2010
    Posts
    10

    Default

    Hi,

    Downloaded the script and ran it, results as follows:

    ~ # sh cpd_event_cleanup.sh [root @ firewallhampton]


    Patch applied.


    Cleaning out old events... (this will happen automatically from now on)


    * Restarting PostgreSQL 8.3 database server * The PostgreSQL server failed to start. Please check the log output:
    [fail]
    Rebooted and no change unfortunately; still cant access GUI, so cant enable support or check UID. Disk appears to be 100% full

    Thanks

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

SEO by vBSEO 3.6.0 PL2