07-25-2009
Hi, All -
Thanks for all your help. I just wanted to see the creative use of SED in this situation.
Thanks again for all your help. I have learned a lot while solving this issue.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I have a problem to format data from different database queries into one look. The input data are as follows, every line has the same number of values but a different number of characters:
adata, bdata, cdata, ddata
fffdata, gdata, hdata, idata
jdata, kdata, ... (6 Replies)
Discussion started by: old_mike
6 Replies
2. Programming
I have few files which have two columns in each.
like
e2
1 1 2694
2 4 2485
3 2 2098
5 1 2079
6 5 2022
9 4 1734
11 5 1585
13 2 1461
18 1 1092
21 2 1019
24 1 915
25 3 907
27 1 891
28 3 890
34 1 748
39 1 700 (1 Reply)
Discussion started by: kamuju
1 Replies
3. Shell Programming and Scripting
I have a very easy one for you this morning :)
A file containing this type of formated data:
500190 488.356
500193 546.7
566486 466.75
506654 288
However, it should be formated like this:
500190 488.356
500193 546.700
566486 466.750
506654 288.000
I know that this can be... (3 Replies)
Discussion started by: Medova
3 Replies
4. Shell Programming and Scripting
I have this format of columns
Quote
2 Points:
np x y z
0 767203.9 2120710 917.2959
1 767071.6 2120658 2793.661
Surface Polyline
Color: (0.0400229 1 0.845803)
2 Points:
np x y ... (7 Replies)
Discussion started by: cml
7 Replies
5. Shell Programming and Scripting
I have a file which looks like this:
/* ----------------- EDW$MOC139_R_NNA_BR_SUM_FACT2 ----------------- */
insert_job: EDW$MOC139_R_NNA_BR_SUM_FACT2 job_type: c
command: /home/btchproc/load_process/batch_files/batch_nna_brn_split_sum_fact2.sh m
machine: edwprod02.dsm.pwj.com
#owner:... (29 Replies)
Discussion started by: Gangadhar Reddy
29 Replies
6. Shell Programming and Scripting
I have a file : e.g.
Charles Dixon Age 23 Hometown Darlington Postcode DL1 2DC
Fred Bixton Age 34 Hometown Leeds Postcode LS1 5XS
Jim Davis Age 48 Hometown Cardiff CF2 8YY
Is it possible to format this file into uniform columns using, say, the spaces as... (11 Replies)
Discussion started by: bigbuk
11 Replies
7. Shell Programming and Scripting
Hi all,
i have written this script:
awk -F';' '
BEGIN {
printf "\n"
printf "\n"
printf "\n"
printf "----------------------------------------------\n"
print " For test "
printf "----------------------------------------------\n"
test_200 = 0
test_300 = 0
test_500 = 0
test_1000 = 0... (11 Replies)
Discussion started by: arrals_vl
11 Replies
8. Programming
Dear All
I have a huge data for 3 columns similar to this
D2cls0 D2cls0 1
D2cls0 D2cls1 0.308
D2cls0 D2cls2 0.554
D2cls0 D2cls3 0.287
D2cls0 D2cls4 0.633
D2cls0 D2cls5 0.341
D2cls0 D2cls6 0.665
D2cls0 D2cls7 0.698
D2cls0 D2cls8 0.625
D2cls0 D2cls9 0.429
I... (9 Replies)
Discussion started by: bala06
9 Replies
9. Shell Programming and Scripting
Input file:
011100020100 0.00 1 20000 30000 20000
011110000025 0.00 1 000 240000 10000
011100020100 0.00 1 200000 2324000 403500
032200030025 0.00 1 2077500 3077500 250000
032200030025 0.00 1 2565000 25536400 320000
022220000005 0.00 1 10000 300000 300000
022220000005 0.00 1 200050... (7 Replies)
Discussion started by: vinus
7 Replies
10. UNIX for Beginners Questions & Answers
My program output text file data in columns format. My problem is the column headers do not align with the data and if filesystem and Mounted On columns pathname are too long the text will not wrap.
Is there any function in Unix that I can use in my code that will align the data for each... (11 Replies)
Discussion started by: dellanicholson
11 Replies
LEARN ABOUT CENTOS
rlm_sql_log
rlm_sql_log(5) FreeRADIUS Module rlm_sql_log(5)
NAME
rlm_sql_log - FreeRADIUS Module
DESCRIPTION
The rlm_sql_log module appends the SQL queries in a log file which is read later by the scripts/radsqlrelay Perl program.
The purpose of this module is to de-couple the storage of long-term accounting data in SQL from "live" information needed by the RADIUS
server as it's running. If you are not using SQL for simultaneous login restrictions (i.e. "sql" is not listed in the "session" section of
"radiusd.conf"), then this module allows you to log SQL queries to a file, and then process them at your leisure.
The benefit of this approach is that for a busy server, the overhead of performing SQL qeuries may be significant. Also, if the SQL data-
bases are large (as is typical for ones storing months of data), the INSERTs and UPDATEs may take a relatively long time. Rather than
slowing down the RADIUS server by having it interact with a database, you can just log the queries to a file, and then run those queries on
another machine, or at a time when the RADIUS server is typically lightly loaded.
If the "sql" module is listed in the "session" section of "radiusd.conf", then a similar system can still be used. In that case, one data-
base would be used to maintain "live" session information. That database would be small, fast, and information would be deleted from it
when a user logs out. A second database would store long-term accounting information, as described above.
LIMITATIONS
This module only performs the dynamic expansion of the variables found in the SQL statements. No operation is executed on the database
server. (this would be done later by an external program) That means the module is useful only with non-"SELECT" statements.
CONFIGURATION
The main configuration items to be aware of are the path of the log file and the different SQL queries.
path An entry named "path" sets the full path of the file where the SQL queries are recorded. (this variable is run through dynamic
string expansion, and can include FreeRADIUS variables to create a dynamic filename)
Accounting queries
When a accounting record is processed, the module searches a config entry keyed by the Acct-Status-Type attribute present in the
packet. For example, the SQL to be run on an accounting start must be named "Start" in the configuration for the module. Other usual
values for Acct-Status-Type are "Stop", "Alive", "Accounting-On", etc. See the VALUEs for Acct-Status-Type in the dictio-
nary.rfc2866 file.
Post-Auth query
An entry named "Post-Auth" sets the query to run during the post-authentication stage. This query is mainly used to log sessions
where there may not be a later accounting packet.
modules {
...
sql_log {
path = "${radacctdir}/sql-relay"
acct_table = "radacct"
postauth_table = "radpostauth"
sql_user_name = "%{%{User-Name}:-DEFAULT}"
Start = "INSERT INTO ${acct_table} ..."
Stop = "UPDATE ${acct_table} SET ..."
Alive = "UPDATE ${acct_table} SET ..."
Post-Auth = "INSERT INTO ${postauth_table} ..."
}
...
}
accounting {
...
sql_log
...
}
post-auth {
...
sql_log
...
}
SECTIONS
accounting, post-auth
FILES
/etc/raddb/radiusd.conf
SEE ALSO
radsqlrelay(8), radiusd(8), radiusd.conf(5)
AUTHOR
Nicolas Baradakis <nicolas.baradakis@cegetel.net>
28 May 2005 rlm_sql_log(5)