|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Help with shell script to compare values between servers
Post 302925242 by Hamdul on Friday 14th of November 2014 11:02:58 PM
11-15-2014
Help with shell script to compare values between servers
Hi
I am a beginner in UNIX and shell scripting and i have a requirement as stated below,
requirement
Login to a unix server 1
1. connect to a database mysql -uUsername -pPassword
2. Select a Schema : "Use Schemaname1"
3. query for a particular record
select cycle_id from DBName where xyz>'execution_date' and cycle_type='xyz';
Note: execution_date= date of execution in YYYY/MM/DD format.
4. Change the schema to SchemaName2; Use SchemaName2;
5. execute the query
select count(*) from DBName where cycle_id='xxxx';
Login to another server 2
6. Connect to a database mysql -uUsername -pPassword
7. select count(*) from modem_core_top_source where cycle_id='xxxx';
cycle_id should be the latest cycle_id noted from p table in step 3.
8. Match the count step 5 = step 7
I got the values from server 1 and stored it in a variable , but how to connect to server 2 ( i tried using sftp , but i am prompted for a password )
Can you guys please help me on this
I am a beginner in UNIX and shell scripting and i have a requirement as stated below,
requirement
Login to a unix server 1
1. connect to a database mysql -uUsername -pPassword
2. Select a Schema : "Use Schemaname1"
3. query for a particular record
select cycle_id from DBName where xyz>'execution_date' and cycle_type='xyz';
Note: execution_date= date of execution in YYYY/MM/DD format.
4. Change the schema to SchemaName2; Use SchemaName2;
5. execute the query
select count(*) from DBName where cycle_id='xxxx';
Login to another server 2
6. Connect to a database mysql -uUsername -pPassword
7. select count(*) from modem_core_top_source where cycle_id='xxxx';
cycle_id should be the latest cycle_id noted from p table in step 3.
8. Match the count step 5 = step 7
I got the values from server 1 and stored it in a variable , but how to connect to server 2 ( i tried using sftp , but i am prompted for a password )
Can you guys please help me on this
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have serverA and serverB and i have a folder with same name an location in both servers.... Now i want to compare files in folder(serverA) with folder (serverB) if there are files missing in folderB then copy those files from folder(serverA) to folder(serverB) (1 Reply)
Discussion started by: ashahzad
1 Replies
2. Shell Programming and Scripting
Hello Lads!
Climbing the shell scripting learning curve, i am faced with yet another obstacle! Here's the challenge in front of me :
1) I have 15 servers in a cluster,all of them have the same config files by name : /home/apps/xrm/App_B.cfg
2) The developers change the entries in the... (5 Replies)
Discussion started by: rdlover
5 Replies
3. Shell Programming and Scripting
Hi gurus
I have two csv files that are outputs. The file contains data similar to
s.no,number1,number2,date1
--------------------------------
1, a123,482.29,11/28/07 13:00
2,a124,602.7,9/24/07 14:00
3,a125,266.93,10/9/07 16.48
4,a126,785.15,11/14/07 16:08
<file 2>
s.no name... (2 Replies)
Discussion started by: inkyponky
2 Replies
4. UNIX for Dummies Questions & Answers
i need to do camparisions like the below.
For the case when first=10 and second=9.9 the scripts displays process failed.
I need to be able to convert the values to integer before doing the comparision.
Like 9.9 should be rounded over to 10 before doing comparision.
Please advice how can... (3 Replies)
Discussion started by: nehagupta
3 Replies
5. Shell Programming and Scripting
Hi all,
I am trying to create shell script to run command then compare values with rule set for every 5 seconds and post a warning message if the compared value meet the rules.
-the script is related to Oracle/Sun product messaging server 6.2
1) command that need to be run to gather... (2 Replies)
Discussion started by: Mr_47
2 Replies
6. Shell Programming and Scripting
Hi,
I need to compare two versions values and report only true or false depending on their difference result.
like -
echo $(echo "1.8 >= 2.0" | bc)
0
echo $(echo "2.0 >= 2.0" | bc)
1
but my task is to compare values like -
echo $(echo "1.9.1 >= 2.0" | bc)
(standard_in) 1: syntax... (3 Replies)
Discussion started by: abhitanshu
3 Replies
7. Shell Programming and Scripting
Here in the input file
23:59:13,devicename,21,server1,700
23:59:13,devicename,22,server2,200
23:59:13,devicename,23,server3,200
23:59:13,devicename,24,server4,200
23:59:13,devicename,25,server5,200
23:59:13,devicename,26,server6,200
23:59:13,devicename,27,server7,200... (6 Replies)
Discussion started by: necro98
6 Replies
8. Shell Programming and Scripting
Hi All,
I have a requirement where I need to compare 2 files & if the values in the files match, it should proceed, else exit the script without proceeding further.
For e.g : Scenario 1
In this case, the script should exit without proceeding further.
Scenario 2
In this case, the script... (7 Replies)
Discussion started by: dsfreddie
7 Replies
9. UNIX for Dummies Questions & Answers
hey i am using this code to connect to sql , store the value in variable and then
compare it with another variable after some time by executing the same query
but the desired result is not coming
#!/bin/bash
val=$(sqlplus -s rte/rted2@rel76d2 <<ENDOFSQL
set heading off
set feedback off... (11 Replies)
Discussion started by: ramsavi
11 Replies
10. Shell Programming and Scripting
Hi,
I need a shell script, which would search the result values from another files.
1)execute " select column1 from table_name" query on the table.
2)Based on the result, need to be grep from .wft files.
could please explain about this.Below is the way i am using.
#!/bin/sh... (4 Replies)
Discussion started by: Rami Reddy
4 Replies
LEARN ABOUT DEBIAN
merge_fonts
merge_fonts(3alleg4) Allegro manual merge_fonts(3alleg4) NAME
merge_fonts - Merges two fonts into one font. Allegro game programming library. SYNOPSIS
#include <allegro.h> FONT *merge_fonts(FONT *f1, FONT *f2) DESCRIPTION
This function merges the character ranges from two fonts and returns a new font containing all characters in the old fonts. In general, you cannot merge fonts of different types (eg, TrueType fonts and bitmapped fonts), but as a special case, this function can promote a mono- chrome bitmapped font to a color font and merge those. Example: FONT *myfont; FONT *myfancy_font; FONT *lower_range; FONT *upper_range; FONT *capitals; FONT *combined_font; FONT *tempfont; ... /* Create a font that contains the capitals from */ /* the fancy font but other characters from myfont */ lower_range = extract_font_range(myfont, -1, 'A'-1); upper_range = extract_font_range(myfont, 'Z'+1, -1); capitals = extract_font_range(myfancy_font, 'A', 'Z'); tempfont = merge_fonts(lower_range, capitals); combined_font = merge_fonts(tempfont, upper_range); /* Clean up temporary fonts */ destroy_font(lower_range); destroy_font(upper_range); destroy_font(capitals); destroy_font(tempfont); RETURN VALUE
Returns a pointer to the new font or NULL on error. Remember that you are responsible for destroying the font when you are finished with it to avoid memory leaks. SEE ALSO
extract_font_range(3alleg4), is_trans_font(3alleg4), is_color_font(3alleg4), is_mono_font(3alleg4), exfont(3alleg4) Allegro version 4.4.2 merge_fonts(3alleg4)