sudo tcpdump -nnvvXSs 1514 -i lo0 dst port 5432

Watch postgresql calls from your application on localhost

It's certainly not nicely formatted SQL, but you can see the SQL in there...

1
2009-12-18 17:12:44

These Might Interest You

  • Check if SSH tunnel is open and open it, if it isn't. NB: In this example, 3333 would be your local port, 5432 the remote port (which is, afaik, usually used by PostgreSQL) and of course you should replace REMOTE_HOST with any valid IP or hostname. The example above let's you work on remote PostgreSQL databases from your local shell, like this: psql -E -h localhost -p 3333


    -1
    while true; do nc -z localhost 3333 >|/dev/null || (ssh -NfL 3333:REMOTE_HOST:5432 USER@REMOTE_HOST); sleep 15; done
    rxw · 2015-09-21 02:25:49 1
  • Show active calls as the happen on an Asterisk server. Note that the Asterisk command (in single quotes) is formatted for Asterisk 1.6. Use the -n flag on the watch command to modify the refresh period (in seconds - default is 2 seconds). Show Sample Output


    7
    watch -n 1 "sudo asterisk -vvvvvrx 'core show channels' | grep call"
    mheadd · 2010-03-26 15:42:13 0
  • Only the number of calls nothing else. Show Sample Output


    1
    /usr/sbin/asterisk -rx 'core show channels' | grep -m1 "call" | cut -d' ' -f1
    stackoverflow128 · 2012-02-01 17:55:17 0
  • Works on asterisk 1.8.


    1
    asterisk -rx "core show calls" | grep "active" | cut -d' ' -f1
    Kouri · 2012-08-15 19:42:30 0
  • In this case it runs the command 'curl localhost:3000/site/sha' waiting the amount of time in sleep, ie: 1 second between runs, appending each run to the console. This works well for any command where the output is less than your line width This is unlike watch, because watch always clears the display. Show Sample Output


    1
    while true ; do echo -n "`date`";curl localhost:3000/site/sha;echo -e;sleep 1; done
    donnoman · 2011-10-14 21:00:41 0
  • This handles when you have a single call or channel. Other commands will strip out the result if there is a single channel or call active because the output changes the noun to be singular instead of plural. Show Sample Output


    2
    watch "asterisk -vvvvvrx 'core show channels' | egrep \"(call|channel)\""
    rowshi · 2012-08-29 13:40:45 0

What Others Think

Thx nice catch... I needed to change the lo0 into lo though
bw · 439 weeks and 3 days ago

What do you think?

Any thoughts on this command? Does it work on your machine? Can you do the same thing with only 14 characters?

You must be signed in to comment.

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands



Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for: