0,0 → 1,25 |
#!/bin/sh |
|
# Settings |
#DB_HOST='localhost' |
#DB_PORT='5432' |
DB_NAME='trafficcount' |
DB_USER='dbadmin' |
DB_PASSWORD='' |
DB_COMMAND='/usr/local/bin/psql' |
|
# Form DB command |
COMMAND="$DB_COMMAND" |
if test -n "$DB_HOST"; then COMMAND="$COMMAND -h $DB_HOST"; fi |
if test -n "$DB_PORT"; then COMMAND="$COMMAND -p $DB_PORT"; fi |
if test -n "$DB_USER"; then COMMAND="$COMMAND -U $DB_USER"; fi |
if test -n "$DB_PASSWORD"; then COMMAND="$COMMAND -W $DB_PASSWORD"; fi |
|
# Get values & update |
SOURCE='tun0_in' |
VALUE=`netstat -I tun0 -b | grep '<Link#' | awk '{print $6}'` |
$COMMAND $DB_NAME -c "select insert_count('$SOURCE', $VALUE);" > /dev/null |
|
SOURCE='tun0_out' |
VALUE=`netstat -I tun0 -b | grep '<Link#' | awk '{print $9}'` |
$COMMAND $DB_NAME -c "select insert_count('$SOURCE', $VALUE);" > /dev/null |
Property changes: |
Added: svn:executable |