Hi. I need to trace on Unix level number of connections to an Oracle database. The listener runs on port 1521.
The following is run:
I need to append these values into a text file every 5 mins through cron. That part works. The problem I am having is getting rid of the "IPv4" string. I just need number of connections and nothing else:
87
88
87
How do I change the statement so it only returns the numbers?
Thanks.
Last edited by vbe; 03-24-2011 at 05:54 AM..
Reason: Please use code tags
I've got a diff command running in a shell script that writes the ouput to a new file. In the new file there is a ">" at the beginning of each line. The output file is going to be used by another program and that character makes the file useless.
What I'm getting in the new file:
> 2007-09-27... (5 Replies)
Hi every1
Well i have a list of numbers e.g
12304
13450
01234
00123
14567
what i want is a command to check if the number is starting from 0 and then delete the 0 without doing anything else!!!!
any help wud b appreciated!!!!!!!!:( (4 Replies)
Hi
how to replace un wanted new line characters.
my file contains data like.
ramu,sony,"raju \n ravi \n ramya" \n
ravi,sarah,"sowmya \n sorry s\ sangam" \n
i want replace new line characters in between double coats with single space.
for example
$ cat input_file
ramu,sony,"raju... (3 Replies)
Hi All,
I wanted to delete all the unwanted characters in the string. ie, to delete all the characters which are not alpha numeric values.
var1="a./bc"
var2='abc/\."123'
like to get the output as
print var1
abc
print var2
abc123
Could you guys help me out pls.
Your help is... (3 Replies)
i have a file like this
1111_2222#$#$dudgfdk
11111111_343434#$#$334
1111_22222#43445667
i want to remove all those charachetrs from #
how can i do this
Thank in advance
Saravanan (4 Replies)
Hi all,
i am just a beginner in shell. Need some code for my problem.
SCENARIO
I have 2 directories. Let A,B.
Everyday files from directory A are compressed and moved to B.(already got the script).
In directory A
abc.doc
def.exe
ghi.c
jkl.pl
In directory B
abc.tar.gz... (1 Reply)
Hi,
I have a file that has data in the following manner,
tt_0.00001.dat 123.000
tt_0.00002.dat 124.000
tt_0.00002.dat 125.000
This is consistent for all the entries in the file. I want to delete the 'tt_' and '.dat' from each line. Could anyone please guide me how to do this using awk or... (2 Replies)
so i have strings such as this:
'postfix/local#2,5#|CRON.*12062.*root.*CMD#2,5#|roice.*NQN1#1,2#|toysprc#1,4#'
i need to get rid of the "#" and the numbers between them for each of the strings above. so the desired output should be:
... (1 Reply)
I wrote myself a small little shell script to clean up a file I have issues with. In particular, I am stripping down a fully qualified host/domain name to just the hostname itself. The script works, but from a performance standpoint, it's not very fast and I will be working with large data sets.
... (4 Replies)
My sed is not working on deleting the entire special characters and leaving what is necessary.grep connections_per a|sed -e 's/\<\!\-\-//g'
INPUT:
<!-- <connections_per_instance>1</connections_per_instance> -->
<method>HALF</method>
<!--... (10 Replies)
Discussion started by: kenshinhimura
10 Replies
LEARN ABOUT DEBIAN
radsqlrelay
RADSQLRELAY(8) FreeRADIUS helper program RADSQLRELAY(8)NAME
radsqlrelay - relay SQL queries to a central database server
SYNOPSIS
radsqlrelay [-?] [-d sql_driver] [-b database] [-f file] [-h host] [-u user] [-P port] [-p password] [-1] [-x] file_path
DESCRIPTION
radsqlrelay tails a SQL logfile and forwards the queries to a database server. Used to replicate accounting records to one (central) data-
base, even if the database has extended downtime.
The SQL logfile is created by the rlm_sql_log module. The module must be configured in the radiusd server before you can use radsqlrelay.
OPTIONS
-? Print usage help information.
-d sql_driver
Driver to use: mysql, pg, oracle.
-b database
Name of the database to use.
-f file
Read password from file, instead of command line.
-h host
Connect to host.
-u user
User for login.
-P port
Port number to use for connection.
-p password
Password to use when connecting to server.
-1 One-shot mode: push the file to database and exit.
-x Turn on debugging.
file_path
The pathname of the SQL logfile to use.
NOTES
Oracle driver
The command "radsqlrelay -d oracle -b db.domain.tld sql-relay" reads the database description stored in $TNS_ADMIN/tnsnames.ora:
db.domain.tld =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db.domain.tld)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = <DB SID>)
)
)
SEE ALSO rlm_sql_log(5)AUTHOR
Nicolas Baradakis <nicolas.baradakis@cegetel.net>
19 June 2005 RADSQLRELAY(8)