Sponsored Content
Top Forums Shell Programming and Scripting how to redirect the output of a grep command to a file inside a shell script Post 302206381 by kripssmart on Tuesday 17th of June 2008 02:36:36 PM
Old 06-17-2008
hi kamalesh,

i tried that grep command.. but can you say me what the option -il is about... actually.. what i am tying to do is that, i am formatting some file and the contents of the file i am passing it as a parameter to an sql query..

so, i will be connecting to sqlplus and i am executing the query.. the output of which i am getting in some file.. and i want to remove the last line in the sql query like "24 rows selected" etc from this file .so for that i am using grep -v option. and here i am trying to redrect the output to a file where i am stuck..

also i want to use the spool command ..to spool this output of the sql query and to create a .lst file.. where i am again stuck..Smilie

thanks for the great help..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Redirect grep output into file !!!!!

Hi, I am writing the following code in command prompt it is working fine. grep ',222,' SAPPCO_20080306.CSV_old > SAPPCO_20080306.CSV_new But the command is not working in the Shell Script... ########################################## #!/bin/sh #... (2 Replies)
Discussion started by: hanu_oracle
2 Replies

2. UNIX for Dummies Questions & Answers

how to get the output of a grep command to a file inside a shell script

hi, i wat to get the output of a grep command in a file. but when i am trying out the same grep command in the unix prompt its working fine.. i am getting the output properly.. but when i am writing the same command inside my shell script , its just creating a new output file with no contents... (1 Reply)
Discussion started by: kripssmart
1 Replies

3. Shell Programming and Scripting

How redirect script output from inside of script?

Is it possible to redirect a script output by command inside of that script? I mean, if I have a script 'dosome.sh' I could run it by >dosome.sh > dosome.log I would dream to get some command inside of scrip to do the same; so, running the dosome.sh would have all output redirected to a log... (4 Replies)
Discussion started by: alex_5161
4 Replies

4. Programming

Redirect input and output to a shell script?

Dear All: I am trying to do something that (I thought) was relatively straightforward, but my code snippet does not seem to work. Any suggestions? Thank you Sincerely yours Misha Koshelev #include <stdio.h> #include <stdlib.h> #include <unistd.h> #include <errno.h> #include... (0 Replies)
Discussion started by: misha680
0 Replies

5. UNIX and Linux Applications

How to redirect grep command output to same file

Hi Everyone, Can anyone please tell me, how can I redirect the grep command output to same file. I am trying with below command but my original file contains no data after executing the command. $grep pattern file1 > file1 Kind Regards, Eswar (5 Replies)
Discussion started by: picheswa
5 Replies

6. Shell Programming and Scripting

Redirect the output in shell script for tftp

I've been using tftp in one of my file #!/bin/bash filename1="config1h.txt" filename2="config15.txt" hostname="test.com" tftp $hostname <</dev/null get $filename1 get $filename2 quit EOF My output looks like this # ./test3.sh tftp> Received 1262 bytes in 0.0 seconds tftp> Received... (2 Replies)
Discussion started by: LavanyaP
2 Replies

7. Shell Programming and Scripting

Shell Script to grep output from top command.

Hello, I want a script which would grep details from top command for specific processes. I m not sure of the PID of these processes but i know the names. $ top -c top - 16:41:55 up 160 days, 5:53, 2 users, load average: 9.36, 9.18, 8.98 Tasks: 288 total, 9 running, 279 sleeping, 0... (8 Replies)
Discussion started by: Siddheshk
8 Replies

8. Programming

How to redirect the output of a shell script to a file?

hi, i have a html form which call a perl program, this perl program calls a shell script. <html> <head> <title>demo</title> </head> <body> <form name="frm1" action="/cgi-bin/perl_script.pl" method="post"> <input type="text" name="fname"> ... (1 Reply)
Discussion started by: Little
1 Replies

9. Shell Programming and Scripting

How to redirect the output of a command inside ftp block?

hi, i am using ftp to get files from remote server. inside the ftp i want to us ls -ltr command and send the output of it to a file. ftp -n remote_server <<_FTP quote USER username quote PASS password prompt noprompt pwd ls -ltr get s1.txt bye _FTP i... (4 Replies)
Discussion started by: Little
4 Replies

10. Shell Programming and Scripting

Redirect script output to file after grep

i have simple program that generate log file 1 line every sec, i need to do grep for specific record then redirect to another file. #!/bin/bash for i in `seq 1 20`; do echo $i sleep 1 done ./test.sh |egrep "5|10|15" 5 10 15 r ./test.sh... (2 Replies)
Discussion started by: before4
2 Replies
rlm_sql(5)							 FreeRADIUS Module							rlm_sql(5)

NAME
rlm_sql - FreeRADIUS Module DESCRIPTION
The rlm_sql module provides an SQL interface to retrieve authorization information and store accounting information. It can be used in conjunction with, or in lieu of the files and detail modules. The SQL module has drivers to support the following SQL databases: db2 iodbc mysql oracle postgresql sybase unixodbc Due to the size of the configuration variables, the sql module is usually configured in a separate file, which is included in the main radiusd.conf via an include directive. The main configuration items to be aware of are: driver This variable specifies the driver to be loaded. server login password These specify the servername, username, and password the module will use to connect to the database. radius_db The name of the database where the radius tables are stored. acct_table1 acct_table2 These specify the tables names for accounting records. acct_table1 specifies the table where Start records are stored. acct_table2 specifies the table where Stop records are stored. In most cases, this should be the same table. postauth_table The name of the table to store post-authentication data. authcheck_table authreply_table The tables where individual Check-Items and Reply-Items are stored. groupcheck_table groupreply_table The tables where group Check-Items and Reply-Items are stored. usergroup_table The table where username to group relationships are stored. deletestatlesessions This option is set to 'yes' or 'no'. If you are doing Simultaneous-Use checking, and this is set to yes, stale sessions ( defined as sessions for which a Stop record was not received ) will be cleared. sqltrace sqltracefile These two options are useful for debugging sql problems. If sqltrace is set to yes, then all sql queries being executed are written to the file listed in sqltracefile. This is disabled in normal operation. num_sql_socks The number of sql connections to make to the database. connect_failure_retry_delay The number of seconds to wait before attempting to reconnect to a failed database connection. sql_user_name This is the definition of the SQL-User-Name attribute. This is set once, so that you can use %{SQL-User-Name} in the SQL queries, rather than the nested username substitution. This ensures that Username is parsed consistently for all SQL queries executed. default_user_profile This is the default profile name that will be applied to all users if set. This is not set by default. query_on_not_found This option is set to 'yes' or 'no'. If set to yes, then the default user profile is returned if no specific match was found for the user. authorize_check_query authorize_reply_query These queries are run during the authorization stage to extract the user authorization information from the ${authcheck_table} and ${authreply_table}. authorize_group_check_query authorize_group_reply_query These queries are run during the authorization stage to extract the group authorization information from the ${groupcheck_table} and ${groupreply_table}. accounting_onoff_query The query to be run when receiving an Accounting On or Accounting Off packet. accounting_update_query accounting_update_query_alt The query to be run when receiving an Accounting Update packet. If the primary query fails, the alt query is run. accounting_start_query accounting_start_query_alt The query to be run when receiving an Accounting Start packet. If the primary query fails, the alt query is run. accounting_stop_query accounting_stop_query_alt The query to be run when receiving an Accounting Stop packet. If the primary query fails, the alt query is run. simul_count_query The query to be run to return the number simultaneous sessions for the purposes of limiting Simultaneous Use. simul_verify_query The query to return the detail information needed to confirm that all suspected connected sessions are valid, and are not stale ses- sions. group_membership_query The query to run to check user group membership. postauth_query The query to run during the post-authentication stage. CONFIGURATION
Due to the size of the configuration for this module, it is not included in this manual page. Please review the supplied configuration files for example queries and configuration details. SECTIONS
authorization, accounting, checksimul, post-authentication FILES
/etc/raddb/radiusd.conf, /etc/raddb/sql.conf, /etc/raddb/sql/<DB>/dialup.conf, /etc/raddb/sql/<DB>/schema.sql, SEE ALSO
radiusd(8), radiusd.conf(5), AUTHORS
Chris Parker, cparker@segv.org 5 February 2004 rlm_sql(5)
All times are GMT -4. The time now is 05:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy