| 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 |
|---|