10-03-2013
data is the most generic of terms and could mean anything. Assuming you mean it's the result of some SQL query, then you still need to post some of it before anyone can know what to do with it. And you need to be much more specific about what you mean by converting it to ASCII. Without knowing exactly what you mean by data and without seeing some of it, I don't know how you can expect any help here.
10 More Discussions You Might Find Interesting
1. Programming
please let me know that in unix using c programming language we can do binary to string conversion and vice versa using ltoa and atol but how can we do it in c++ programming language.
thank you in advance. (3 Replies)
Discussion started by: kinnaree
3 Replies
2. UNIX for Advanced & Expert Users
Dear All,
Business Users are transfering ( FTP ) a CSV file into the IBM AIX box with transfer mode as ASCII. But I want to convert the CSV file from ASCII mode into binary mode, as my script expects file in binary mode.
Is it possible to do through Unix commands?
Thanks in Advance,
RK (1 Reply)
Discussion started by: srajeshmca
1 Replies
3. Shell Programming and Scripting
Hi,
I have a pdf file. i want to convert it to text file and do some work on it and later want to convert it back to pdf. Can this be done via unix?
or
Is there a way unix can directly work on PDF file? (2 Replies)
Discussion started by: saltysumi
2 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I am new to Unix and discovered this example problem online that I believe will help my learning:
Run the command's below
env >> xx
env >> xx
env >> xx
env >> xx
env >> xx
You will now have a file called XX with the env redirected into it 5 times
Create a script named... (2 Replies)
Discussion started by: Jimmy_c
2 Replies
5. Shell Programming and Scripting
shell script to convert file names from UPPERCASE to lowercase file names or vice versa in linux
anybody please help me out!!!! (5 Replies)
Discussion started by: jacky29
5 Replies
6. Ubuntu
i am thinking of replacing my vista with ubuntu.
Questions:
1) what will be the advantages and disadvantages of using ubuntu instead of vista?
2) what will be the setbacks of replacing my vista?
3) how hard is it to cope up with the new OS? what must i learn to utilize ubuntu? (1 Reply)
Discussion started by: Anna Hussie
1 Replies
7. Shell Programming and Scripting
I need to write a script that will take the input from a file and convert the number from centigrade to fahrenheit and vice versa.
This is what I have but it doesn't seem to be correct.
Also the data file has 11 numbers inside of it and the output needs to be listed as so:
Fahrenheit Temperature... (18 Replies)
Discussion started by: N1ckNak
18 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
I installed Oracle virtual box 4.1.8 on my desktop. I installed Windows 2008 server R2 as one instance and Solaris 10 as another instance. When am trying to ping from Windows to solaris and vice-versa, ping not working.
windows IP : 10.1.47.24
Solaris IP : 10.1.47.25
netstat... (2 Replies)
Discussion started by: kjks
2 Replies
9. Shell Programming and Scripting
Hello All,
I have a below data in a .csv file where all rows where col1 is A, col2 is odd numbers, similarly even numbers for all rows where col1 is B.
Note that my data has some other columns(not shown here) too (around 100) after col2.
Tool,Data
A,1
A,3
A,5
....
so on
B,2
B,4
.... ... (4 Replies)
Discussion started by: ks_reddy
4 Replies
10. UNIX for Dummies Questions & Answers
Hi,
In unix or linux is there any command exist to identify Host Name to IP Address or Vice Versa?
Thanks in advance (6 Replies)
Discussion started by: nag_sathi
6 Replies
LEARN ABOUT DEBIAN
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)