08-04-2011
thank you, although this did solve part of my problem, sometimes the ftp server im attempting
to connect too freezes or dosent allow connections from my specific IP address, in this case
the script freezes because the ftp server does not close. Is there any timeout command that i
could add in to close the session after like 10 seconds or something.
cheers!
#!/bin/sh
for ip in $(cat /root/Desktop/ftp.txt)
do
HOST=$ip
USER='bob'
PASS='bob'
ftp -n $HOST <<EOF
user bob bob
EOF
echo "$ip"
done
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have been “commissioned” to write a shellscript to automate Oracle cold refeshes.. right now we perform about 20 refresh each 300gb in size which takes up our time. my goal is to write a shellscript which can be executed by a user on serverA to refresh any of the 7 databases on ServerA. I am... (4 Replies)
Discussion started by: jigarlakhani
4 Replies
2. Shell Programming and Scripting
Hi guys,
I am facing issues while triggering sqlplus with "/" option
I can connect to database with USER ID and password. but, if i just specify "/" option since it is "externally identiifed user" it doesn't work
Any suggestions?
mail me @ Removed.
Regards, Giri (2 Replies)
Discussion started by: chittari
2 Replies
3. Shell Programming and Scripting
I have 3 shell scripts below.... I need to write a command line parser
for these 3 utilities.
basically the parser will accept ANY number of commands in this syntax
-r = right -f = findtext -c = count so you do something like
mu.s -r 3 4 5 -f hello goodbye.txt -c *.c -h 5 4 3
right... (5 Replies)
Discussion started by: TurboArkhan
5 Replies
4. Shell Programming and Scripting
Hi ,
I'm a beginner in unix shell scripting need help in rectifying an error
Source file :test.txt with
Header
------
-----
Trailer
ex:
FH201010250030170000000000000000
abc def jke
abr ded etf
FE2
I was validating whether the header begin... (2 Replies)
Discussion started by: dudd9
2 Replies
5. Shell Programming and Scripting
Hi all,
Please help me out
How to write a shell script which converts abc.csv file into abc.xls
example file abc.csv
AP_RQ_ID,TXN_IER,AP_RS_RESP_CD,TXN_CNT,TOTAL_AMT
60000002,ACTIVATION,00,490,14657.52
60000002,ACTIVATION,08,1,100
This needs to be converted into excel format using a... (3 Replies)
Discussion started by: dudd9
3 Replies
6. Shell Programming and Scripting
I have an xml file where every line which has the word CDATA in it follows this pattern
(line number) <word1><!]></>I need only these lines editing so that the end result is that
(line number) <word1><!]></word1>so it copies the first bit to the end.
Anyone know how I can do this I am... (10 Replies)
Discussion started by: legolad
10 Replies
7. Shell Programming and Scripting
Hi All,
I have run the below script but getting one small error. please help me to solve this.
ERROR:
tar: Error exit delayed from previous errors
CODE:
#! /bin/bash
CEP=/home/user01/exercise/CEP
ARCH=/home/user01/exercise/archive
LOG=/home/user01/exercise/logs... (3 Replies)
Discussion started by: aish11
3 Replies
8. Shell Programming and Scripting
Can someone explain the -z option in shellscripting.
I did this. When I was in both ksh and bash it echoed back hi.
#!/bin/ksh
if
then
echo hi
fi
When I echoed $BASH_VERSION in bash it gave a version. When I echoed $BASH_VERSION in ksh it was blank.
I thought -z was... (4 Replies)
Discussion started by: cokedude
4 Replies
LEARN ABOUT CENTOS
alter_user_mapping
ALTER USER
MAPPING(7) PostgreSQL 9.2.7 Documentation ALTER USER MAPPING(7)
NAME
ALTER_USER_MAPPING - change the definition of a user mapping
SYNOPSIS
ALTER USER MAPPING FOR { user_name | USER | CURRENT_USER | PUBLIC }
SERVER server_name
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
DESCRIPTION
ALTER USER MAPPING changes the definition of a user mapping.
The owner of a foreign server can alter user mappings for that server for any user. Also, a user can alter a user mapping for his own user
name if USAGE privilege on the server has been granted to the user.
PARAMETERS
user_name
User name of the mapping. CURRENT_USER and USER match the name of the current user. PUBLIC is used to match all present and future
user names in the system.
server_name
Server name of the user mapping.
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
Change options for the user mapping. The new options override any previously specified options. ADD, SET, and DROP specify the action
to be performed. ADD is assumed if no operation is explicitly specified. Option names must be unique; options are also validated by
the server's foreign-data wrapper.
EXAMPLES
Change the password for user mapping bob, serverfoo:
ALTER USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'public');
COMPATIBILITY
ALTER USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED). There is a subtle syntax issue: The standard omits the FOR key word. Since both
CREATE USER MAPPING and DROP USER MAPPING use FOR in analogous positions, and IBM DB2 (being the other major SQL/MED implementation) also
requires it for ALTER USER MAPPING, PostgreSQL diverges from the standard here in the interest of consistency and interoperability.
SEE ALSO
CREATE USER MAPPING (CREATE_USER_MAPPING(7)), DROP USER MAPPING (DROP_USER_MAPPING(7))
PostgreSQL 9.2.7 2014-02-17 ALTER USER MAPPING(7)