Python Forum
Regular expression to print maching
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Regular expression to print maching
#11
Is there an exception traceback?
No exception traceback
Does the remote command execute successfully? Your program needs to check this.
Remote command is execute successfully.. however its not printing whole output, printing less output

Does the stdout.readlines() read all the lines that you're expecting. If not, why?

stdout.readlines() not reading all the lines, what could be the issue?

Is there anything in the command's stderr stream?
not able to understand this
Reply
#12
(Apr-24-2018, 09:38 AM)anna Wrote: not able to understand this
try print(("STDERR'S CONTENT:", stderr.read())) in order to see if the command printed anything in the error stream.
Reply
#13
post changing code as per your suggestion, its printing data, but how to regex for desired output.
import re
import atexit
import paramiko
import time
import logging
import time

stat_time = time.time()

class myssh:
      def __init__(self, host, user, password, port = 22):
        client = paramiko.SSHClient()
        client.load_system_host_keys()
        client.set_missing_host_key_policy(paramiko.AutoAddPolicy())
        client.connect(host, port=port, username=user, password=password)
        atexit.register(client.close)
        self.client = client

      def __call__(self, command):
        stdin,stdout,stderr = self.client.exec_command(command)
        print(("STDERR'S CONTENT:", stderr.read()))

remote = myssh('172.23.96.66','nms','Ttml_nms')
remote('/opt/NMS/server/bin/NMSState')
print('It took', time.time()- stat_time, 'seconds.')
Output:
ME:<PUN_YOUBB_NPT1200> IP:<192.9.52.204> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~6594> Full Upload:<UPLOADED>\n ME:<PUN_Dongkwang_Precision BG20> IP:<192.9.97.218> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~6903> Full Upload:<UPLOADED>\n ME:<Murud_BG20_2> IP:<192.9.34.61> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~6679> Full Upload:<UPLOADED>\n ME:<KOL_MANIKNAGAR_BG20B> IP:<192.9.83.138> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~6488> Full Upload:<UPLOADED>\n ME:<Harihareshwar> IP:<192.9.34.37> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~6499> Full Upload:<UPLOADED>\n ME:<NSK_Ozar MPLS BG 20> IP:<192.9.62.210> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~6450> Full Upload:<UPLOADED>\n ME:<PUN_INSPIRAGE_SOFTWARE> IP:<192.9.30.10> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~6492> Full Upload:<UPLOADED>\n ME:<PUN_DELFINGEN_INDIA> IP:<192.9.30.218> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~6728> Full Upload:<UPLOADED>\n ME:<GOA_Taj_Exotica_BG20_2nd> IP:<192.9.171.79> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~6516> Full Upload:<UPLOADED>\n ME:<NSK_MehrunNagar_BG20> IP:<192.9.93.107> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~6558> Full Upload:<UPLOADED>\n ME:<PUN_SHIRUR_BG64> IP:<192.9.97.221> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~9136> Full Upload:<UPLOADED>\n ME:<AUR_SUPE_BG64> IP:<192.9.57.75> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~9137> Full Upload:<UPLOADED>\n ME:<PUN_Sunshine_BSC-1_BG20B> IP:<192.9.51.1> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~8816> Full Upload:<UPLOADED>\n ME:<PUN_Tapkir nagar Moshi> IP:<192.9.92.227> Core Upload:<NOT_UPLOADED> Full Upload:<NOT_UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~1297> Full Upload:<NOT_UPLOADED>\n ME:<KOL_Mahud_Rd> IP:<192.9.73.232> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~1009> Full Upload:<UPLOADED>\n ME:<GOA-Anup_01> IP:<192.9.79.209> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~826> Full Upload:<UPLOADED>\n ME:<GOA-Royal_Tower_Ponda> IP:<192.9.47.70> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3290> Full Upload:<UPLOADED>\n ME:<NGP_GONDIA (MUNDIPAR) MIDC> IP:<192.9.95.134> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~956> Full Upload:<UPLOADED>\n ME:<KOL_Pachapeth_BG20> IP:<192.9.171.196> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3103> Full Upload:<UPLOADED>\n ME:<NGP_Bus Stand_INDUS> IP:<192.9.32.67> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~887> Full Upload:<UPLOADED>\n ME:<KOL_BarshiP5_2_BG> IP:<192.9.171.219> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3848> Full Upload:<UPLOADED>\n ME:<GOA_Dona Paula Kings palace> IP:<192.9.47.160> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~94> Full Upload:<UPLOADED>\n ME:<KOL_Shivaji_peth-2> IP:<192.9.75.76> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3068> Full Upload:<UPLOADED>\n ME:<KOL_TimberSangli> IP:<192.9.83.145> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3115> Full Upload:<UPLOADED>\n ME:<KOL_Udgir-Market> IP:<192.9.78.204> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3714> Full Upload:<UPLOADED>\n ME:<NGP_Patwa Chowk_INDUS> IP:<192.9.69.145> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~961> Full Upload:<UPLOADED>\n ME:<AUR_Nirala BazarBG20> IP:<192.9.74.194> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~867> Full Upload:<UPLOADED>\n ME:<GOA-Map Hsg Brd> IP:<192.9.79.207> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~1548> Full Upload:<UPLOADED>\n ME:<KOL_Phulewadi_BG20> IP:<192.9.75.80> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~941> Full Upload:<UPLOADED>\n ME:<NGP_Umred WCL_VIOM> IP:<192.9.39.121> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3873> Full Upload:<UPLOADED>\n ME:<PUN_Shirur_GTL> IP:<192.9.57.135> Core Upload:<NOT_UPLOADED> Full Upload:<NOT_UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3507> Full Upload:<NOT_UPLOADED>\n ME:<NGP_Pallavi Apts_INDUS> IP:<192.9.92.66> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3026> Full Upload:<UPLOADED>\n ME:<PUN_padmaprabha> IP:<192.9.37.202> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3300> Full Upload:<UPLOADED>\n ME:<AUR_Jatwada-Road> IP:<192.9.91.161> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3066> Full Upload:<UPLOADED>\n ME:<KOL_Tung> IP:<192.9.20.93> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3022> Full Upload:<UPLOADED>\n ME:<PNMS MGMT> IP:<192.9.66.3> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~2047> Full Upload:<UPLOADED>\n ME:<AUR_Polytechnic college_Beed> IP:<192.9.67.78> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~1685> Full Upload:<UPLOADED>\n ME:<NSK_TA Gate-UT-Deolali_Camp(15> IP:<192.9.170.213> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3576> Full Upload:<UPLOADED>\n ME:<HotelSapnaBg20C> IP:<192.9.38.26> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~5048> Full Upload:<UPLOADED>\n ME:<NGP_SiddheshwarNagar_INDUS> IP:<192.9.92.80> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~991> Full Upload:<UPLOADED>\n ME:<AUR_N6-Bari-colony> IP:<192.9.26.166> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3674> Full Upload:<UPLOADED>\n ME:<NGP_Railtoli_VIOM> IP:<192.9.95.132> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~990> Full Upload:<UPLOADED>\n ME:<NGP_New Friends Colony( Akar)> IP:<192.9.170.98> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~8801> Full Upload:<UPLOADED>\n ME:<AUR_ Roshangate_Haji Ali> IP:<192.9.26.168> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~1919> Full Upload:<UPLOADED>\n ME:<PUN_Jairaj bldg> IP:<192.9.98.137> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~1247> Full Upload:<UPLOADED>\n ME:<PUN_PanchshilRd_Baramati> IP:<192.9.58.79> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~1556> Full Upload:<UPLOADED>\n ME:<NSK_PanchwatiKaranja-BG-20> IP:<192.9.61.218> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3208> Full Upload:<UPLOADED>\n ME:<NGP_ShaktiNagar_INDUS> IP:<192.9.31.23> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~986> Full Upload:<UPLOADED>\n ME:<NSK_PatelColonyBG-20> IP:<192.9.72.147> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~923> Full Upload:<UPLOADED>\n ME:<NGP_Surendra Nagar_VIOM> IP:<192.9.241.15> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3075> Full Upload:<UPLOADED>\n ME:<PUN_Mayfair_tower-BG> IP:<192.9.51.206> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~1716> Full Upload:<UPLOADED>\n ME:<KOL_Ganesh_Nagar_BG20> IP:<192.9.87.21> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3399> Full Upload:<UPLOADED>\n ME:<Vidhya-nagar> IP:<192.9.55.138> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~601> Full Upload:<UPLOADED>\n ME:<AUR_Ambika Nagar_Beed> IP:<192.9.67.84> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3063> Full Upload:<UPLOADED>\n ME:<PUN_Pashankar_auto2> IP:<192.9.94.3> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3232> Full Upload:<UPLOADED>\n ME:<KOL_Nimshirgaon_BG20> IP:<192.9.20.147> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~1652> Full Upload:<UPLOADED>\n ME:<KOL_UT_Ganjagolai_BG20> IP:<192.9.79.77> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3493> Full Upload:<UPLOADED>\n ME:<NAGAR_MIDC-2> IP:<192.9.57.31> Core Upload:<UPLOADED> Full Upload:<UPLOADED>\n SN:<EMS~~LSN/EMS_BG-40_105@@MultiLayerSubnetwork~~3119> Full Upload:<UPLOADED>\n ME:<Aircel_Sangamner_BG> IP:<192.9.53.71> Core Upload:<NOT_UPLOADED> Full Upload:<NOT_UPLOADED>\n
Reply
#14
Is all this output printed to stderr? It is suprising. You could do stderr.readlines() instead of read() and parse the lines as you did before for stdout.

However, you could perhaps run the command NMSState in a ssh session outside of python to understand how it works. Also look in this command's documentation and options.
Reply
#15
changes done for stderr.read(), but printing output one character per line

sshdata = stderr.read()
        for line in sshdata:
            print line
Output:
M E : < P U N _ K a m a l a _ C o r n e r _ X D M 3 0 0 > I P : < 1 9 2 . 9 . 6 1 . 1 7 9 > C o r e U p l o a d : < U P L O A D E D > F u l l U p l o a d : < U P L O A D E D >
Reply
#16
Use readlines()
Reply
#17
Done, thanks.


import re
import atexit
import paramiko
import time
import logging
import time

stat_time = time.time()
class myssh:
      def __init__(self, host, user, password, port = 22):
        client = paramiko.SSHClient()
        client.load_system_host_keys()
        client.set_missing_host_key_policy(paramiko.AutoAddPolicy())
        client.connect(host, port=port, username=user, password=password)
        atexit.register(client.close)
        self.client = client

      def __call__(self, command):
        stdin,stdout,stderr = self.client.exec_command(command)
        sshdata = stderr.readlines()
        for line in sshdata:
            if 'ME:' in line:
                pattern = r'(?<=\<).+?(?=\>)'
                result = re.findall(pattern, line)
                print (','.join(result))
remote = myssh('172.23.96.66','nms','Ttml_nms')
remote('/opt/NMS/server/bin/NMSState')
time.sleep(10)
total_time=time.time()- stat_time
print('It took', time.time()- stat_time, 'seconds.')
Output:
KOL_Nesari_XDM100,192.9.47.2,UPLOADED,UPLOADED PUN_ButtePatil,192.9.21.4,UPLOADED,UPLOADED Waluj_XDM-100,192.9.76.1,UPLOADED,UPLOADED PUN_Goyal-DWDM_(TTML),192.9.37.131,UPLOADED,UPLOADED KOL_BHUM_XDM-100,192.9.240.134,UPLOADED,UPLOADED PUN_JEJURI_5H1_VSNL,192.9.44.37,UPLOADED,UPLOADED KOL_Umerga_xdm100,192.9.73.211,UPLOADED,UPLOADED GOA-TRISTAR_BB_XDM100-6,192.9.49.5,UPLOADED,UPLOADED Pen_Bsc_xdm100_2,192.9.89.120,UPLOADED,UPLOADED NGP_NAGPURXDM100-4,192.9.43.92,UPLOADED,UPLOADED Nasik_Switch_XDM100_9,192.9.62.209,UPLOADED,UPLOADED NGP_Aamgaon_XDM100_VIOM,192.9.95.129,UPLOADED,UPLOADED PANVEL_BB_1K,192.9.89.107,UPLOADED,UPLOADED Turbhe-BB1,192.9.89.106,UPLOADED,UPLOADED PUN_XDM100-4,192.9.71.1,UPLOADED,UPLOADED
fail to understand .. why stderr.readlines() working?
Reply
#18
(Apr-24-2018, 11:08 AM)anna Wrote: fail to understand .. why stderr.readlines() working?
The answer is in the NMSState command. It is not a python problem.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  data validation with specific regular expression shaheen07 0 346 Jan-12-2024, 07:56 AM
Last Post: shaheen07
  Regular Expression search to comment lines of code Gman2233 5 1,701 Sep-08-2022, 06:57 AM
Last Post: ndc85430
  List Creation and Position of Continue Statement In Regular Expression Code new_coder_231013 3 1,681 Jun-15-2022, 12:00 PM
Last Post: new_coder_231013
  Need help with my code (regular expression) shailc 5 1,946 Apr-04-2022, 07:34 PM
Last Post: shailc
  Regular Expression for matching words xinyulon 1 2,188 Mar-09-2022, 10:34 PM
Last Post: snippsat
  regular expression question Skaperen 4 2,516 Aug-23-2021, 06:01 PM
Last Post: Skaperen
  How can I find all combinations with a regular expression? AlekseyPython 0 1,681 Jun-23-2021, 04:48 PM
Last Post: AlekseyPython
  Python Regular expression, small sample works but not on file Acernz 5 2,955 Jun-09-2021, 08:27 PM
Last Post: bowlofred
  Regular expression: cannot find 1st number in a string Pavel_47 2 2,433 Jan-15-2021, 04:39 PM
Last Post: bowlofred
  Regular expression: return string, not list Pavel_47 3 2,514 Jan-14-2021, 11:49 AM
Last Post: Pavel_47

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020