08-31-2006
audit to crontab scripts
hi,
I have scripts which are running every 3 minutes. The scripts include connection to a database, using sqlplus. Sometimes, the connection fails (invalid username or password, locked user etc..) and the connection returns the error code, to the unix screen or to a file.
I want whenever there's a problem, to send a mail with the error code, I tried to returned the error code to a procedure as an input, but it fails...
10 More Discussions You Might Find Interesting
1. HP-UX
Dear Expects,
I am facing following discrepancies on our server.
a) When we give wrong root password three times in a row, the root account has been disabled.
b) System is forced to change the old password, whenever we tried to change the password of any of the OS user and for ROOT user... (2 Replies)
Discussion started by: oracle_rajesh_k
2 Replies
2. Shell Programming and Scripting
when i run the scripts from command line like
php ./file.php they run fine and it ends.
But i have them running in crontab every 5 minutes and they sometimes dont close. Can i write something to log why or force them to close after a certain amount of time by killing the pid? (2 Replies)
Discussion started by: nitrous
2 Replies
3. Debian
Hi all
I installed Debian and i have a few scripts that outputs what is happening.
The wierd part...after fresh install all works ok but after i open or edit Crontab it stops executing the scripts...and scripts runs manually so its not a problem with scripts...what happens is that i usually... (3 Replies)
Discussion started by: ro0t3d
3 Replies
4. Shell Programming and Scripting
hi,
i need to run one script in cron...
in that script has connect antoher server and doing sftp for file transfer to another script.
and going to be run another script in another server
ssh ravikus\@server2 /export/home/ravikus/scripts/GetDetailsC2b.sh
it is work fine when i run... (6 Replies)
Discussion started by: rsivasan
6 Replies
5. UNIX for Dummies Questions & Answers
hi,
instead of typing crontab -e i gave crontab -r and hit enter. So i lost all my scripts.
Is there any way to restore the deleted scripts?
Please help me out
Thanks
Ajay (3 Replies)
Discussion started by: ajayakunuri
3 Replies
6. AIX
Dear All
When I start the AIX(6100-06)audit subsystem.
the log will save in /audit/stream.out (or /audit/trail), but in default when /audit/stream.out to grow up to 150MB.
It will replace the original /audit/stream.out (or /audit/trail).
Then the /audit/stream.out become empty and... (2 Replies)
Discussion started by: nnnnnnine
2 Replies
7. UNIX for Dummies Questions & Answers
I'm trying to create a crontab that runs every hour and runs a script in my $HOME/bin directory.
Everytime it goes to run it I get this mail.
Message 14:
From root@xx.xxxx.edu Thu Apr 12 14:03:01 2012
Return-Path: <root@xx.xxxx.edu>
X-Original-To: bbowers
Delivered-To:... (4 Replies)
Discussion started by: bbowers
4 Replies
8. Shell Programming and Scripting
Hi,
I have a query related to UNIX Crontab scripts -
Issue: Server space on the db server got 100% full as a result of which the cron scripts did not run. The space utilization issue got resolved in the afternoon. The crons scheduled for a time post the resolution caught up. However the... (1 Reply)
Discussion started by: qwerty000
1 Replies
9. Shell Programming and Scripting
Hi,
I'm trying to take backups of script files listed in cron tab
but,my cron entry has value like this
10 3 * * * /usr/sbin/logadm
15 3 * * 0 /usr/lib/fs/nfs/nfsfind
30 3 * * * && /usr/lib/gss/gsscred_clean
#10 3 * * * /usr/lib/krb5/kprop_script ___slave_kdcs___
00,15,30,45 * * * *... (1 Reply)
Discussion started by: Sivarajan N
1 Replies
10. Shell Programming and Scripting
Hello all,
Hope all's well.
i'm not sure if this is possible but i have some scripts running in a crontab with different intervals, 1min, 5 min, etc.
As for a "cleaner" and better control of these scripts (as by time we will have hundred's of scripts used for the same purpose, i.e for Nagios... (4 Replies)
Discussion started by: nms
4 Replies
LEARN ABOUT MOJAVE
clusterdb
CLUSTERDB(1) PostgreSQL Client Applications CLUSTERDB(1)
NAME
clusterdb - cluster a PostgreSQL database
SYNOPSIS
clusterdb [ connection-option... ] [ [ --verbose ] [ -v ] ] [ --table | -t table ] [ dbname ]
clusterdb [ connection-option... ] [ [ --all ] [ -a ] ] [ [ --verbose ] [ -v ] ]
DESCRIPTION
clusterdb is a utility for reclustering tables in a PostgreSQL database. It finds tables that have previously been clustered, and clusters
them again on the same index that was last used. Tables that have never been clustered are not affected.
clusterdb is a wrapper around the SQL command CLUSTER [cluster(7)]. There is no effective difference between clustering databases via this
utility and via other methods for accessing the server.
OPTIONS
clusterdb accepts the following command-line arguments:
-a
--all Cluster all databases.
[-d] dbname
[--dbname] dbname
Specifies the name of the database to be clustered. If this is not specified and -a (or --all) is not used, the database name is
read from the environment variable PGDATABASE. If that is not set, the user name specified for the connection is used.
-e
--echo Echo the commands that clusterdb generates and sends to the server.
-q
--quiet
Do not display progress messages.
-t table
--table table
Cluster table only.
-v
--verbose
Print detailed information during processing.
clusterdb also accepts the following command-line arguments for connection parameters:
-h host
--host host
Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory
for the Unix domain socket.
-p port
--port port
Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections.
-U username
--username username
User name to connect as.
-w
--no-password
Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as
a .pgpass file, the connection attempt will fail. This option can be useful in batch jobs and scripts where no user is present to
enter a password.
-W
--password
Force clusterdb to prompt for a password before connecting to a database.
This option is never essential, since clusterdb will automatically prompt for a password if the server demands password authentica-
tion. However, clusterdb will waste a connection attempt finding out that the server wants a password. In some cases it is worth
typing -W to avoid the extra connection attempt.
ENVIRONMENT
PGDATABASE
PGHOST
PGPORT
PGUSER Default connection parameters
This utility, like most other PostgreSQL utilities, also uses the environment variables supported by libpq (see in the documentation).
DIAGNOSTICS
In case of difficulty, see CLUSTER [cluster(7)] and psql(1) for discussions of potential problems and error messages. The database server
must be running at the targeted host. Also, any default connection settings and environment variables used by the libpq front-end library
will apply.
EXAMPLES
To cluster the database test:
$ clusterdb test
To cluster a single table foo in a database named xyzzy:
$ clusterdb --table foo xyzzy
SEE ALSO
CLUSTER [cluster(7)]
Application 2010-05-14 CLUSTERDB(1)