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.
Sorry.. need 5 post to paste results which include links
one more (sorry not spamming)
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......
Thanks again.~ # 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
Last edited by bowerj01; 12-20-2011 at 02:54 AM.
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
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)Originally Posted by dmorris
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.
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
I ran the patch and the results were as follows:
Unfortunately, I can no longer access the GUI remotely after running the patch, only via SSH.~ # 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+1ce3PaSBLP33yKOa5SSBuFgOPHleu4OgI4cS 0GH+Db3fJRKhkGo4tAijR47bu6
7349L2n0BGzH2eyqNwnSqLunZ3r6Nz2j0dbfvfrq1AA6OTmiv8 2To4b4fc/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+31rbxd3csrMTTqM9d x/QBZAeJXyed28y9rc4kdD/vJ
R8EXRzyh4tFdpbLw3RXygoeZ690e1MEcvA5sdx0goaFrEXwGPB f3W1n/sXEJno+JT1uxjXlirzCM
gpWnKhfmSp7O0vJJ9hPX2azWXRzMMh9325OeeTYcXbQnk94omw UTy3bGeEbAqkyOj77lLTOffLJv
lw78zbbt0/BqtKXyH/HDmFjEDoid3YDL857Z+dQeTTKfjtht5qPxpN35sdc1P7RHBQrG m9XK8h+K
Wj85v+iZwzOz2/5lS2MY57g3Ou+NM6qs4zWMahx3XBHHmTUjE+vGwUVMn4bjidkd nff73eFPgyLO
ASBo0fPJ8NLs9/7Z6xcxXUHz8qpTQktwexAAxCT2isZBxUStrAitQ/SbxLfWgWNRJ2g1CfpvKei/
BdCv6XVHYsQcL9DA1CBmAusW66egkmz8NRIFlUp/+PF8AFWZWq3vgu01vXJ1SeOAl115cwhkKAS+
4dUkZHQ3BArP2uf9XpcXnkFYYKi7wuq0NsQ17fXM1yhkE/POcja41TCQtXLBYBBp6qcVBHQH19cK
05SVUh0LTbBQmm18HzPBu+vGNCymN+hNS6gNi0UrhVClopQtKp WZYwUB6nhzjXpZVEJrNMFkm5im
FmBnoVRO2eqxhwbK6vdKqCmAyjzByRtH+9FAeD1nV4pyygTKZz 6GcnNNp23Toa4w8R0YH2iZ8oXi
N447+7ybeHixoH0bBpFWk2NPNYi4xHKCmhEKJShTiJtRIAQjHp sM02sGup7Sv7riSTWw6j6+BfTD
vrkAS03CTF0Q0fG8GfUVtoKNj4O65XnQYI1jh1Zj5hQYErcKYh HfYn9H9uqMjj+t0x730E+fegPE
Wg09WmMBVkMTWthEvT4wDK76fdQbdPWqru9i+IYF4YtbznHgaa Y7DCq+RacDWj3N9AUAGi3fyZi9
LM+3mwNqgd07hisHgD3DVUWNHcM1j+ladqLnu8SFsK6dDyYHNT 2/d6TAzLGhfoBasqgZ+0pZ8zk4
LGCCvckuggH27wBNkoLT7S1jvUUlbmyAFULbyN36gw7yjwMwOn Ow+d2dmSu8usF+sLS95GwkJrLr
MAWZRtKe5XPQzxaJJq27VW0ar5QbmpQMeK4X0Fl6Gg0/eh/PBqEv+T30BKQD4qHIOYtcwTrVm4fJ
MbOgvrZWuFgIlhi283BF0xhtC+fE9a7A08EOfB+oW/G8wwYUCEz1VFdIoAiUcEw+Y7kUXytoer4K
VluaLem3UeQaI9ShjBkes+bMwdY6TDtmkIItVFcS/+E01vwoBa37m7UJt1q1Wv1Xpdvr9yABPBsN
L4TqxIROKgBbox6KoAD9Fb0OQNhAGq/XUJqD72fYI6cwOIOg8ozmSMB6sjm0D0WcbutExci573om
BByxqT/wXERzNZ38VENFj9XDoTzSkxopO+tTUf4pdqlTTIYedvH32JJG9 nRhrrtTxhzZKDRlWElH
TmfUoyuZSftDv4fyc1OkMdXK8CFylwH9apMlZDCsBP0HKuAIws UpSCG6zuKFfBqP7mERtDTJg6fy
KDMVgvlAlTTtOaLr4XZfZ0M3kRln5/FZnQLKzZmYpooyclST9dJrAEjbcmqZQ0HGY0306Pmg2/sZ
pXWaUiH8uUfDQUGna5JVrymtmLnrNUwtStV0aqKlYpbR98eP8w H06gRsngwL7BGqtKjPDcXLBneR
EfnUUF2pV8YAUp0JepR0pQBp6UjYllLCtIaiLmrRS4OvwGfuam WT1hnEqLLmkx1d54+1JDSiHvsB
XWD4aVrMdx3nxpp91uIqfcsOMMKV3UM/vk59qdBXa31E6LOUlo6mg1hE04w1XSoSS0TTytgDtuMD
7Ie8NJ6HKuziQYL9pfAiviR4HrxQdW7Bi9j4UPFCHY4vBxeqOV lwwUaGoQ4IIzEODNX9RsLrhurs
TER5zgoyQCfMp75H0Il29aKVRHiVt8dnILbOiKoLJZLbfQzGi/rE1Jgq9AZV4b83xaxV8OQMPILn
1VACVV9rfItKD6o7qtmAQ/k8IzwZ7hFk4y+NjqVsooRcCQ6GGO5w8xDktnXpBqQ1oGiIaO3i Eq9g
CcOulc60F4wbuT5jpb+ML+5dscahshE64TmEdfQOSUtvXAK7+S vGn7P50Fu0uq/TB/SFUXjRxQ6x
NKWZ6pbKlw2GBWsLMRQQ0dcZtvu9caenweJWesdADZ2+DuO3PI 7yd0vl2gQwZmayqeRvLVicoPag
qxaKBUt6CbgHxM02Pl2X8yiDa9fXlOYt4dF//5ePh1Siju8xZPJYY30BqyfZy+DhudpXUmHCLECZ
jQM9azPTYP2vUa16aixF21j22nKcpCUxmEguhpcy1JX1P3vnts NGPuNL7+RTHXzbgqmrbQ+iW6qo
MH6yAyUjqvJCh5XTmFFjaIfQieZ98M/e8RDp+TOaExZcD2jCRnIdockSA9paPqxolvCXFSMXphR2
DwBkwyPQU1e0eDSUL4EFNDEVdoDgDxVYb+geF3IXyEIsj5ttHM sX6yj6ZiymyvksdqFkgRKwqXgd
X11oc1LnMWp6c/3d68BoQOyGHBftn+Mc9LHUnaGH7mNvUSRZijTJbeUiVSrPFqu4 7TBdxCzg9xlV
pTQle2G7JlAjtTDo09QhKdxA7RNoidpjFGrPGv+Cl9YnmUXded zSGsaumJbFz17pT0ZXg45Wg9FU
MyLMZeJQpkptA3OFdXdcV6U+joZXl+jDL2rF3BBSUfH/qbAvH6bT3s2KhVE1NpiUqe30dOG4FsnJ
AFNizG8xuSyxHXSFXlWVTSu5WvA98S3z1yX2cWJzmpK9UNEYtV qoeZoyguXW9M2Nf2c5oOS4gX6A
f1J8G5guKM58cjd+NfV04fori4ASYEkc4ojZC+nwdhMODpkJxX YAkhabkTjIkmSNFXwxsmZyC0Ad
psK5yUCWpj8wpVXzI2P7giFNygp1f+Fw1n2EaGzkKHeP0JX0X+ w+sfqJJVjQ64l8ir3kjc9wlHho
ZpbT2Es/kIGUERUwRhDdd+S2LDCZLSH9Us9ZxIyRryn868Y0ncRxwyKeZj YPNTJiOshgkgZHXO+n
eiqc1y4RVaatjfqoYUxzBKkdmZKyF3NEpXVpWbWjqXA8N/Oy0uMvG8iQ5rAAt/OOZuw3BnOTOroe
GmOYE+aBFh+TiZ5lSZV6sEyDNLjNox/1+ZEJgGRl/YPeIQevNd/b8jYN0ZNHtR7fPNLf1N7V3pga
hTA9PgQgr5Oe/5xYK2Qad2HdK4atrPtw9noWc7Z1CDvPEPUIz1t+G10iTRN9wqf mb2KQ7K8zeYhC
dFiUuv0Gekw1jnZZlIF80z6TmtWgeyPc+eY31YGRpcqIS5v6VQ zcZwtBloYXnuPSRIodFNbo+5hW
6gBsjtHEJg5usSMK7DKH7d6xbrDTEg3JYXqQTGHrcxhX1r9d3w wTvFY8y8wRSkw2LRgpsfazbX+Y
cawAE41N9+KVFf2VhoU4m+9Cdqi8xY+W129dd77GQbBTVXSUxO sSALZjZXNMYDGE59srk0NRqU0J
/h2ru7FE05I7UhoMTYPVrYf70OGRk6dtTRHXe0v3fQK+PQVaUcf yiH2H0SVk4pByslq+7x2rb7zZ
K/eOlPe18iTX6Sn05i57veKlEN8TGAxVZeh8zM7wVejOAN/a+lN01I+VKq8flU2E+GmWSrhzEKmm
xj9mxyBz7zd/51hy7LU7nNqto+TZmIUm34p+5NJkY9Px4qvHwMNK5TqArkYqqc fpiQx0Rag3UAAv
YymTM/8k23YNOqdQjxgyYfv22OlOT0/hhx1GagZKyDH4k7ZQCJTXBprbgedYD6Zj0/dzzUYRkhmI
PQ/BLHEu7umodsMVJtFN1INERSWwPQOwJV4R06ySn16N8I3fZ+Gbe s5Lwbfk+QaOccndz/wt0RDN
4or+mIiW6MwccOM+2gPckkcDuAIWah/46eWnwFxcO0U8MYjC9n+XiCcgTz3AG/vmbwfQi/GnwA+C
6i2bG96G52rAIZ3LLq8zXFQlzoTzAzrynf1+b+FD/JKv4an4Dvjls4+zoo8mtfgJIwrZcE/Xf7Uu
+0wsCaqqaJS2cFHe2gG91wsFWTeJ6mBkAPc05Ub/Lt5b9DRP/oGyR/ffvq9ivzhxJM45HljZ8t1Q
7XVQ40oLPhehTPQ7kR2T1J1yzuGo2xtRlFYedHvjDn1VhV4jjR lpIG5H6ENlJot6X896HE6I6cCE
vpOxqJ6Sf/5YZKiVikWZh/xeozH5xQxrNytDbVFWHJXKObOY9CX73KNQNPnRDftehJXtWLdy jC0m
Ler+XcAD1ZWYwfX46T6ph3HG+1TPOOpXcJbxGRHh+WI/78Mp+rmtRj/eBcFv/X9kKKmkkkoqqaSS
SiqppJJKKqmkkkoqqaSSSiqppJJKKqmkkkoqqaSSSiqppJJKKq mkkkoqpv8Dj9VqDgB4AAA=
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
The box is approximately 100 miles away, may need to go to site and reinstall :-(
Thanks for the reply though.
You need to this command
This:Code:curl http://untangle.com/download/patches...ent_cleanup.sh | dash
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
Hi,
Downloaded the script and ran it, results as follows:
Rebooted and no change unfortunately; still cant access GUI, so cant enable support or check UID. Disk appears to be 100% full~ # 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]
Thanks
Posting Permissions
LinkBack URL
About LinkBacks
