10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
How do I translate
Let say
Cat inserts.sql
gives
Insert into PM9_TAXATION_ROUNDING
(STATE_GECODE, TAX_TYPE, TAX_AUTHORITY, SYS_CREATION_DATE, SYS_UPDATE_DATE, APPLICATION_ID, DL_SERVICE_CODE, ROUNDING_METHOD)
Values
('xx', 'xx', 'x', TO_DATE('10/26/2012 13:01:20',... (3 Replies)
Discussion started by: anuj87in
3 Replies
2. Programming
dear all,
i want to insert string in file to mysql i just want how to do that cause i am poor in sql languages ...
so this file like this
DATA.txt
doni|student|westjava|123412|lombok|
iwan|student|westjava|1234412|utankayu|
rio|student|westjava|12342|cempedak|
so i want insert DATA.txt to... (2 Replies)
Discussion started by: zvtral
2 Replies
3. Shell Programming and Scripting
My file is now cleaned, sanitized & prepped:
07/07/2008 21:18:51 Installation 52016 complete *BUT NOTHING CHANGED*
07/21/2008 15:28:15 Removal 52016 complete
07/21/2008 15:34:15 Removal 55856 complete
12/08/2009 19:30:40 Installation 62323 complete
12/08/2009 19:39:06 Installation ... (6 Replies)
Discussion started by: dba_frog
6 Replies
4. Emergency UNIX and Linux Support
Hello friends,
I need to insert data from a file to another. I need this to form an sql query file which will consist of 50.000 INSERT INTO sentences.
my sql query file will consist of 50.000 times the below line consecutively:
insert into subscriber... (6 Replies)
Discussion started by: EAGL€
6 Replies
5. Programming
i would like to know how can i fine tune the following query since the cost of the query is too high ..
insert into temp temp_1 select a,b,c,d from xxxx
.. database used is IDS.. (1 Reply)
Discussion started by: expert
1 Replies
6. Shell Programming and Scripting
Hi all,
Does anyone know if it is possible to enable/disable a cron job within a script?
I currently have a cron job which runs every minute but now it seems that sometimes I would like to turn this job off if a condition is met. I would then like to re-enable the job at a later date.
... (5 Replies)
Discussion started by: pxy2d1
5 Replies
7. Solaris
I would like to setup a Cron job to check weather X process is running or not. if it is not running then start that X process with a log message....
can any one help writing a script?
thanks (3 Replies)
Discussion started by: chandravadrevu
3 Replies
8. Web Development
I have following.
.
.
.
$userid = 2
.
$query = "select username from users where userid = ".$userid.";";
.
$username = $line;
$data="Some Data Here";
.
$query = "insert into logger (username, data) valuse ($username, $data);";
.
I would like to not have 2 database calls. (3 Replies)
Discussion started by: Ikon
3 Replies
9. UNIX for Dummies Questions & Answers
Hi all,
I have a doubt in SQL Loader.
We have SEQUENCE function in SQL Loader or can create Sequence in Oracle database for generating a number sequence for
a column while loading data using SQL Loader into table or multiple tables.
My requirment is this.
For the first run in SQL... (2 Replies)
Discussion started by: vinoth_kumar
2 Replies
10. Shell Programming and Scripting
Hi,
sqlplus -s / <<EOF > /dev/null
insert into table1 (a1, a2, a3) values ('a',1,'b');
commit;
EOF
in the above code can i pass the values to the insert command from shell script like this:
insert into table1 (a1, a2, a3) values ('$a',$b,'$c');
If yes, how is it passed??
Any... (2 Replies)
Discussion started by: abey
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.
logfile
This option is useful for debugging sql problems. If logfile is set then all sql queries for the containing section are written to
the file specified. This is useful for debugging and bulk inserts.
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)