Python Forum
Python Forum

help required to parsing telnet output
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
help required to parsing telnet output
anna
Spam, spam, eggs, and spam
Posts: 221
Threads: 71
Joined: Dec 2017
Reputation: -3
#1
Jan-10-2018, 08:26 AM
telnet output is as below, want to print vlan (vid) and mac, please suggest changes


Port: 1
index vid mac
----- ---- -----------------
1 3738 e4:6f:13:80:dd:52
Port: 3
index vid mac
----- ---- -----------------
2 3738 c4:6e:1f:2f:ac:a6
Port: 5
index vid mac
----- ---- -----------------
3 3738 e4:6f:13:81:fc:a2
Port: 13
index vid mac
----- ---- -----------------
4 3738 48:ee:0c:d1:ba:95
Port: 14
index vid mac
----- ---- -----------------
5 3738 e8:37:7a:9d:0e:66
Port: 15
index vid mac
----- ---- -----------------
6 3738 00:17:7c:6d:64:b4
Port: 20
index vid mac
----- ---- -----------------
7 3638 6c:72:20:54:69:74
Port: 21
index vid mac
----- ---- -----------------
8 3638 10:7b:ef:a6:4b:dc
Port: 25
index vid mac
----- ---- -----------------
9 3638 00:17:7c:80:7a:43






1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
#!/usr/bin/python
import paramiko
import sys
import os
import xlrd
import unidecode
import telnetlib
import time
import re
from time import sleep
mac = re.compile(r'[a-fA-F0-9]{2}[:][a-fA-AF0-9]{2}[:][a-fA-F0-9]{2}[:][a-fA-F0-9]{2}[:][a-fA-F0-9]{2}[:][a-fA-F0-9]{2}')
vlan = re.compile(r'\d{4}')
user = 'admin'
password = '1234'
with open('zyxel.txt','r') as ipfile:
    for sr_no, line in enumerate(ipfile, start=1):
        host = line.strip()
        try:
            print 'Connecting .....'+str(host)
            telnet = telnetlib.Telnet(host, 23, 2)
            telnet.read_until('User name:', 3)
            telnet.write(user.encode('ascii') + '\r')
            telnet.read_until('Password:', 3)
            telnet.write(password.encode('ascii') + '\r')
            #telnet.read_until('>')
            telnet.write('statistics mac 1~48' + '\r')
            telnet.read_until('>')
            telnet.write(' exit''\r')
            output = telnet.read_all()
            print 'printing output.....'
            for line in output:
                if vlan in line:
                    vlan = DslamVlan
                if mac in line:
                    mac = DslamPortMac
                    print DslamVlan+' '+DslamPortMac
        except Exception as excp:
            print(excp)
Find
Reply
wavic
So-and-so of the Yard
Posts: 2,953
Threads: 48
Joined: Sep 2016
Reputation: 90
#2
Jan-10-2018, 10:00 AM
Just check if the first character of the line is a digit then split it and get the second and the third elements.
"As they say in Mexico 'dosvidaniya'. That makes two vidaniyas."
https://freedns.afraid.org
Find
Reply
anna
Spam, spam, eggs, and spam
Posts: 221
Threads: 71
Joined: Dec 2017
Reputation: -3
#3
Jan-10-2018, 10:33 AM (This post was last modified: Jan-10-2018, 11:07 AM by anna.)
Thanks,

but how can i capture Port: 1, Port:2, Port:3 etc. i mean port numbers
changes done.. but not printing output

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
#!/usr/bin/python
import paramiko
import sys
import os
import xlrd
import unidecode
import telnetlib
import time
import re
from time import sleep
mac = re.compile(r'[a-fA-F0-9]{2}[:][a-fA-AF0-9]{2}[:][a-fA-F0-9]{2}[:][a-fA-F0-9]{2}[:][a-fA-F0-9]{2}[:][a-fA-F0-9]{2}')
vlan = re.compile(r'\d{4}')
user = 'admin'
password = '1234'
with open('zyxel.txt','r') as ipfile:
    for sr_no, line in enumerate(ipfile, start=1):
        host = line.strip()
        try:
            print 'Connecting .....'+str(host)
            telnet = telnetlib.Telnet(host, 23, 2)
            telnet.read_until('User name:', 3)
            telnet.write(user.encode('ascii') + '\r')
            telnet.read_until('Password:', 3)
            telnet.write(password.encode('ascii') + '\r')
            #telnet.read_until('>')
            telnet.write('statistics mac 1~48' + '\r')
            telnet.read_until('>')
            telnet.write(' exit''\r')
            output = telnet.read_all()
            print 'printing output.....'
            for line in output:
                #Capture first character of line
                first_character = line[:1]
                #check fist character of line is inter/digit
                if isinstance(first_character,int):
                    data= line.split(' ')
                # split the line
                    for outdata in data:
                        print outdata
 
        except Exception as excp:
            print(excp)
Find
Reply
wavic
So-and-so of the Yard
Posts: 2,953
Threads: 48
Joined: Sep 2016
Reputation: 90
#4
Jan-10-2018, 01:37 PM (This post was last modified: Jan-10-2018, 01:37 PM by wavic.)
if you look at the line with the data you want you will see that the first digit corresponds to the port number. Just get it.

Alright, this is not the case.

Try this:

1
2
3
4
5
6
7
8
data = iter(output)
 
for line in data:
    if "Port:" in line:
        # get this line
        next(data) # scip the headers
        next(data) # scipt the --------
        # get the port number and the mac address. Prev. post
"As they say in Mexico 'dosvidaniya'. That makes two vidaniyas."
https://freedns.afraid.org
Find
Reply
anna
Spam, spam, eggs, and spam
Posts: 221
Threads: 71
Joined: Dec 2017
Reputation: -3
#5
Jan-10-2018, 01:41 PM
still stuck,

checking 4 character if line, if digit, spliting line and printing, however its not printing putout, what is going wrong.

changed code as below

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
#!/usr/bin/python
import paramiko
import sys
import os
import xlrd
import unidecode
import telnetlib
import time
import re
from time import sleep
mac = re.compile(r'[a-fA-F0-9]{2}[:][a-fA-AF0-9]{2}[:][a-fA-F0-9]{2}[:][a-fA-F0-9]{2}[:][a-fA-F0-9]{2}[:][a-fA-F0-9]{2}')
vlan = re.compile(r'\d{4}')
user = 'admin'
password = '1234'
with open('zyxel.txt','r') as ipfile:
    for sr_no, line in enumerate(ipfile, start=1):
        host = line.strip()
        try:
            print 'Connecting .....'+str(host)
            telnet = telnetlib.Telnet(host, 23, 2)
            telnet.read_until('User name:', 3)
            telnet.write(user.encode('ascii') + '\r')
            telnet.read_until('Password:', 3)
            telnet.write(password.encode('ascii') + '\r')
            #telnet.read_until('>')
            telnet.write('statistics mac 1~48' + '\r')
            telnet.read_until('>')
            telnet.write(' exit''\r')
            output = (telnet.read_all().decode('ascii'))
            file = open(host,'w')
            file.write(output.rstrip())
            print 'printing output.....'
            file.close()
            with open (host,'r') as outfile:
                 for lines in outfile:
                     forth_character = lines[:4]
                     #print forth_character, if digit, spit the line
                     if isinstance(forth_character,int):
                        data= lines.split(' ')
                        index = data[0]
                        vlan  = data[1]
                        mac   = data[2]
                        print(host,index,vlan,mac)
        except Exception as excp:
            print(excp)
Find
Reply
wavic
So-and-so of the Yard
Posts: 2,953
Threads: 48
Joined: Sep 2016
Reputation: 90
#6
Jan-10-2018, 02:07 PM
1
2
3
4
5
6
7
8
9
10
11
data = iter(output.split('\n'))
 
try:
    for line in data:
        print(line)
        next(data)
        next(data)
        port_mac = next(data)[1:]
        print(port_mac)
except StopIteration:
    pass
 
Output:
Port: 1
 3738 e4:6f:13:80:dd:52
Port: 3
 3738 c4:6e:1f:2f:ac:a6
Port: 5
 3738 e4:6f:13:81:fc:a2
Port: 13
 3738 48:ee:0c:d1:ba:95
Port: 14
 3738 e8:37:7a:9d:0e:66
Port: 15
 3738 00:17:7c:6d:64:b4
Port: 20
 3638 6c:72:20:54:69:74
Port: 21
 3638 10:7b:ef:a6:4b:dc
Port: 25
 3638 00:17:7c:80:7a:43
You can do the formatting.
"As they say in Mexico 'dosvidaniya'. That makes two vidaniyas."
https://freedns.afraid.org
Find
Reply
anna
Spam, spam, eggs, and spam
Posts: 221
Threads: 71
Joined: Dec 2017
Reputation: -3
#7
Jan-11-2018, 08:57 AM
thanks, Wavic

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
import paramiko
import sys
import os
import xlrd
import unidecode
import telnetlib
import time
import re
from time import sleep
user = 'admin'
password = '1234'
with open('zyxel.txt','r') as ipfile:
    for sr_no, line in enumerate(ipfile, start=1):
        host = line.strip()
        try:
            print 'Connecting .....'+str(host)
            telnet = telnetlib.Telnet(host, 23, 2)
            telnet.read_until('User name:', 3)
            telnet.write(user.encode('ascii') + '\r')
            telnet.read_until('Password:', 3)
            telnet.write(password.encode('ascii') + '\r')
            #telnet.read_until('>')
            telnet.write('statistics mac 1~48' + '\r')
            telnet.read_until('>')
            telnet.write(' exit''\r')
            output = telnet.read_all()
            print 'printing output.....'
            sleep(1)
            data = iter(output.split('\n'))
            try:
                for line in data:
                    if "Port:" in line:
                        port1 = line.split(':')
                        port = str(port1[:5])
                        #port = port1[1]
                        next(data)
                        next(data)
                        port_mac = next(data)[1:]
                        print (host+' '+port+' '+port_mac)
            except StopIteration:
                   pass
        except Exception as excp:
            print(excp)
output

printing output.....
10.217.128.24 ['Port', ' 1\r'] 1 3738 e4:6f:13:80:dd:52
10.217.128.24 ['Port', ' 2\r'] 2 3738 c0:a0:bb:89:78:bc
10.217.128.24 ['Port', ' 3\r'] 3 3738 c4:6e:1f:2f:ac:a6
10.217.128.24 ['Port', ' 5\r'] 4 3738 e4:6f:13:81:fc:a2
10.217.128.24 ['Port', ' 14\r'] 5 3738 e8:37:7a:9d:0e:66
10.217.128.24 ['Port', ' 15\r'] 6 3738 00:17:7c:6d:64:b4
10.217.128.24 ['Port', ' 21\r'] 7 3638 10:7b:ef:a6:4b:dc
10.217.128.24 ['Port', ' 25\r'] 8 3638 00:17:7c:80:7a:43
10.217.128.24 ['Port', ' 26\r'] 9 3638 10:7b:ef:a8:94:88
10.217.128.24 ['Port', ' 27\r'] 10 3738 e4:6f:13:c0:42:43
10.217.128.24 ['Port', ' 31\r'] 11 3638 90:8d:78:84:73:81
10.217.128.24 ['Port', ' 36\r'] 12 3638 64:70:02:aa:7e:e2
10.217.128.24 ['Port', ' 37\r'] 13 3638 e4:6f:13:80:e8:e2
10.217.128.24 ['Port', ' 43\r'] 14 3638 80:26:89:cb:d4:6b
10.217.128.24 ['Port', ' 46\r'] 15 3638 e4:6f:13:b1:1c:c3
10.217.128.24 ['Port', ' 48\r'] 16 3638 90:8d:78:83:a2:71
Connecting .....10.217.128.40
printing output.....
10.217.128.40 ['Port', ' 5\r'] 1 3739 48:ee:0c:bc:53:1d
10.217.128.40 ['Port', ' 8\r'] 2 3739 e4:6f:13:c1:a7:42
10.217.128.40 ['Port', ' 16\r'] 3 3739 54:b8:0a:99:3d:97
10.217.128.40 ['Port', ' 23\r'] 4 3739 1c:5f:2b:3c:5d:c1
10.217.128.40 ['Port', ' 25\r'] 5 3739 0c:d2:b5:5e:be:a1
10.217.128.40 ['Port', ' 26\r'] 6 3739 00:17:7c:7d:44:3a
10.217.128.40 ['Port', ' 27\r'] 7 3639 54:b8:0a:98:fd:1f
10.217.128.40 ['Port', ' 33\r'] 8 3739 48:ee:0c:a8:44:03
10.217.128.40 ['Port', ' 34\r'] 9 3739 0c:d2:b5:5e:be:45
10.217.128.40 ['Port', ' 35\r'] 10 3739 e4:6f:13:c1:73:c2
10.217.128.40 ['Port', ' 42\r'] 11 3639 e8:37:7a:9d:0b:f5
10.217.128.40 ['Port', ' 48\r'] 12 3739 54:b8:0a:98:73:bf

but facing difficulty to print as below

HostIP Port vlan Mac
10.217.128.40 48 3739 54:b8:0a:98:73:bf
Find
Reply
wavic
So-and-so of the Yard
Posts: 2,953
Threads: 48
Joined: Sep 2016
Reputation: 90
#8
Jan-11-2018, 10:53 AM
If the file is strictly formatted as in the example you provided then there is no need to for "Port" in line. The first line contains "Port" then you skip the next two lines, the next contains the port_address pair then the for loop starts again and you repeat the same cycle.

In "Port: 1" you can get the number just by splitting the line - line.split(). The result will be the list ["Port:", "1"] whatever the number is. Then grab the second element.

Use string formatting.

1
print("{} {} {}".format(host, port, port_mac))
"As they say in Mexico 'dosvidaniya'. That makes two vidaniyas."
https://freedns.afraid.org
Find
Reply
anna
Spam, spam, eggs, and spam
Posts: 221
Threads: 71
Joined: Dec 2017
Reputation: -3
#9
Jan-12-2018, 11:05 AM
thanks, its working... thanks once again
Find
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Telnet command in Python 3.9 Dre83 0 2,525 Nov-11-2020, 11:42 AM
Last Post: Dre83
  opening files and output of parsing leodavinci1990 4 3,796 Oct-12-2020, 06:52 AM
Last Post: bowlofred
  Sending command using telnet mradovan1208 1 5,335 Apr-24-2020, 07:09 PM
Last Post: Larz60+
  Serial to telnet using Python Charles_Linquist 2 7,752 Jun-17-2019, 04:37 PM
Last Post: DeaD_EyE
  unexpected output while parsing file anna 3 4,205 Apr-28-2018, 05:13 PM
Last Post: anna
  Multi thread telnet issue anna 0 2,651 Mar-29-2018, 05:35 PM
Last Post: anna
  telnet unexpected output printing anna 3 4,674 Jan-17-2018, 01:16 PM
Last Post: anna
  Unexpected Output after Running PArsing Script hotsea 7 6,507 Jan-10-2018, 09:55 AM
Last Post: hotsea
  telnet stuck when get Press any key to continue anna 2 5,782 Dec-31-2017, 11:34 AM
Last Post: anna

Forum Jump:

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020