Where $DIR is a variable with the absolute path where a.sql and b.sql are.
For some time, I've been running this script daily and it works fine. The intentions is that both SQL*Plus sessions go to the background and execute in parallel, and when they finish I can continue with the following steps of the application.
Since it's not a test version anymore, I scheduled it on the crontab to execute daily. The problem I have now is that it wont pause on "wait" and let the sqlplus sessions finish, but it directly outputs "Done!". In the real app, that "echo Done!" is actually a call to another program to do some processing on a.sql's and b.sql's output. But since it's not waiting for both sql scripts to actually finish, the processing cannot be done.
It works absolutely perfect when I run it myself, wether I do it from the local directory or from the root (as crontab would do it). But when it is executed automatically by the crontab, I't doesn't stop at wait and screws the whole thing up.
Any ideas on what might be happening? Thanks!
Last edited by Franklin52; 09-12-2012 at 03:36 AM..
Reason: Please use code tags for data and code samples
Hi all
Trying to run my korn shell script, I got no messages after the sftp.
The "finished" msg is not being displayed.
Any ideas?
sftp $argument <<EOF
quit
EOF
echo "finished"
Thanks in advance,
:O) (1 Reply)
I have to copy an array to a temp variable and back after doing some functions. I am trying to see if it is possible to do without while loops.My closest try was
set -A temp ${THE_ARRAY}
# restore array after some actions
set -A THE_ARRAY ${temp}
The problem with above is that, the new... (1 Reply)
Did not use 'wait' yet.
How I understand by now the wait works only for child processes, started background.
Is there any other way to watch completion of any, not related process (at least, a process, owned by the same user?)
I need to start a background process, witch will be waiting... (2 Replies)
Hi,
I am trying to execute the below in Ksh (telnet)
find ./request.txt -mmin -30
It says
find: bad option -mmin
What i am trying to do is by using find command i am checking wheather the file request.txt is there for 30 minutes or not
Please help (1 Reply)
HI,
I have a strange problem. A shell script that runs fine on solaris. when i ported to linux, it started hanging.
here is the core of the script
CFG_FILE=tab25.cfg
sort -t "!" -k 2 ${CFG_FILE} | egrep -v "^#|^$" | while IFS="!" read a b c
do
#echo "jobs output"
#jobs
#echo "jobs... (13 Replies)
Can anybody help me with this small script , the script works fine and launches the IE from
c:\documents and settings \test\my documents>ksh prompt
$RunURL1.sh
this scitpt works and launches the ie from ksh , but when i schedule it to run the script then i get the error box saying command:1... (2 Replies)
hello,
i use following command:
md5sum TEST.xml
the output looks like:
900hjidur84hjr938ikv TEST.xml
as you can see, the first part is the md5 code, the second part is the file name, but i only want the first part(md5 code), and save it to a file, how to do that? thanks. (2 Replies)
Hi,
I am facing a strange issue,
when i call a script from my while loop in background it doesnt go in background, despite the wait i put below the whil loop it goes forward even before the process put in background is completed.
cat abc.txt | while read -u4 line
do
#if line contains #... (2 Replies)
Hi All,
I have a question related to Shell scripting. In my shell script, I have following two commands in sequence:
sed 's/^/grep "^120" /g' $ORIGCHARGEDAMTLIST|sed "s;$;| cut -f$FIELD_NO1 -d '|' | awk '{ sum+=\$1} END {printf (\"%0.2f\\\n\", sum/100)}' >$TEMPFILE
mv $TEMPFILE $ORIGFILE... (3 Replies)
Discussion started by: angshuman
3 Replies
LEARN ABOUT DEBIAN
rlm_sql
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)