Posts: 45
Threads: 22
Joined: Jan 2022
I have the code below for ldap search.
I want to save my search result as json.
why print(conn.entries) doesnt work?
from ldap3 import Server, Connection, ALL
from ldap3 import Server, Connection, SAFE_SYNC
username = "user1"
server = Server('192.168.1.24', get_info = ALL)
conn = Connection(server, '[email protected]', 'mypassword', client_strategy=SAFE_SYNC, auto_bind=True)
#print(conn)
result= conn.search('dc=my,dc=server', f'(sAMAccountName={username})')
print(conn.entries)
Posts: 4,784
Threads: 76
Joined: Jan 2018
Mar-14-2022, 05:54 PM
(This post was last modified: Mar-14-2022, 05:54 PM by Gribouillis.)
What's in the 'result' object? Have you tried printing result, or dir(result)?
Posts: 45
Threads: 22
Joined: Jan 2022
(Mar-14-2022, 05:54 PM)Gribouillis Wrote: What's in the 'result' object? Have you tried printing result, or dir(result)?
When i run print(result) ı get the search result that i want.
But i cannot parse it. I try to convert the result to json for parsing but i get typeerror: object of type 'bytes' is not json serializable
Posts: 4,784
Threads: 76
Joined: Jan 2018
So you want to convert a search result which is a bytes string to json. What does the bytes string look like? Can you post it here? Also how have you tried to convert it to json?
Posts: 45
Threads: 22
Joined: Jan 2022
(Mar-15-2022, 07:25 AM)Gribouillis Wrote: So you want to convert a search result which is a bytes string to json. What does the bytes string look like? Can you post it here? Also how have you tried to convert it to json?
Here is my search result:
(True, {'result': 0, 'description': 'success', 'dn': '', 'message': '', 'referrals': None, 'type': 'searchResDone'}, [{'raw_dn': b'CN=user G\xc3\xbc\xc3\xa7l\xc3\xbc,OU=DEVELOPERS,OU=ANKARA,OU=TURKIYE,OU=TRD-GLOBAL,DC=TRD,DC=local', 'dn': 'CN=User1,OU=DEVELOPER,OU=ANKARA,OU=TURKIYE,OU=TRD-GLOBAL,DC=TRD,DC=local', 'raw_attributes': {}, 'attributes': {}, 'type': 'searchResEntry'}, {'uri': ['ldap://ForestDnsZones.TRD.local/DC=ForestDnsZones,DC=TRD,DC=local'], 'type': 'searchResRef'}, {'uri': ['ldap://DomainDnsZones.TRD.local/DC=DomainDnsZones,DC=TRD,DC=local'], 'type': 'searchResRef'}, {'uri': ['ldap://TRD.local/CN=Configuration,DC=TRD,DC=local'], 'type': 'searchResRef'}], {'base': 'dc=my,dc=server', 'scope': 2, 'dereferenceAlias': 3, 'sizeLimit': 0, 'timeLimit': 0, 'typesOnly': False, 'filter': '(sAMAccountName=user1)', 'attributes': ['1.1'], 'type': 'searchRequest', 'controls': None}) I've try:
result= conn.search('dc=my,dc=server', f'(sAMAccountName={username})')
print(result)
result2 = json.dump(result)
print(result2) I got:
TypeError: Object of type 'bytes' is not JSON serializable
Posts: 4,784
Threads: 76
Joined: Jan 2018
Mar-15-2022, 08:35 AM
(This post was last modified: Mar-15-2022, 08:35 AM by Gribouillis.)
It fails because the dictionary in the result contains a byte string b'CN=user G\xc3\xbc\xc3\xa7l\xc3\xbc,OU=DEVELOPERS,OU=ANKARA,OU=TURKIYE,OU=TRD-GLOBAL,DC=TRD,DC=local' . A solution is to decode it to unicode with the utf8 encoding. Here is working code that I found with my search engine
result = (True, {'result': 0, 'description': 'success', 'dn': '', 'message': '', 'referrals': None, 'type': 'searchResDone'}, [{'raw_dn': b'CN=user G\xc3\xbc\xc3\xa7l\xc3\xbc,OU=DEVELOPERS,OU=ANKARA,OU=TURKIYE,OU=TRD-GLOBAL,DC=TRD,DC=local', 'dn': 'CN=User1,OU=DEVELOPER,OU=ANKARA,OU=TURKIYE,OU=TRD-GLOBAL,DC=TRD,DC=local', 'raw_attributes': {}, 'attributes': {}, 'type': 'searchResEntry'}, {'uri': ['ldap://ForestDnsZones.TRD.local/DC=ForestDnsZones,DC=TRD,DC=local'], 'type': 'searchResRef'}, {'uri': ['ldap://DomainDnsZones.TRD.local/DC=DomainDnsZones,DC=TRD,DC=local'], 'type': 'searchResRef'}, {'uri': ['ldap://TRD.local/CN=Configuration,DC=TRD,DC=local'], 'type': 'searchResRef'}], {'base': 'dc=my,dc=server', 'scope': 2, 'dereferenceAlias': 3, 'sizeLimit': 0, 'timeLimit': 0, 'typesOnly': False, 'filter': '(sAMAccountName=user1)', 'attributes': ['1.1'], 'type': 'searchRequest', 'controls': None})
import json
class MyEncoder(json.JSONEncoder):
def default(self, obj):
if isinstance(obj, bytes):
return str(obj, encoding='utf-8');
return json.JSONEncoder.default(self, obj)
s = json.dumps(result, cls=MyEncoder, indent=4)
print(s) Output: [
true,
{
"result": 0,
"description": "success",
"dn": "",
"message": "",
"referrals": null,
"type": "searchResDone"
},
[
{
"raw_dn": "CN=user G\u00fc\u00e7l\u00fc,OU=DEVELOPERS,OU=ANKARA,OU=TURKIYE,OU=TRD
-GLOBAL,DC=TRD,DC=local",
"dn": "CN=User1,OU=DEVELOPER,OU=ANKARA,OU=TURKIYE,OU=TRD-GLOBAL,DC=TRD,DC=local",
"raw_attributes": {},
"attributes": {},
"type": "searchResEntry"
},
{
"uri": [
"ldap://ForestDnsZones.TRD.local/DC=ForestDnsZones,DC=TRD,DC=local"
],
"type": "searchResRef"
},
{
"uri": [
"ldap://DomainDnsZones.TRD.local/DC=DomainDnsZones,DC=TRD,DC=local"
],
"type": "searchResRef"
},
{
"uri": [
"ldap://TRD.local/CN=Configuration,DC=TRD,DC=local"
],
"type": "searchResRef"
}
],
{
"base": "dc=my,dc=server",
"scope": 2,
"dereferenceAlias": 3,
"sizeLimit": 0,
"timeLimit": 0,
"typesOnly": false,
"filter": "(sAMAccountName=user1)",
"attributes": [
"1.1"
],
"type": "searchRequest",
"controls": null
}
]
You could perhaps serialize only result[1] because I think the True value at the start of the result is not part of the result's payload. Also note that this solution may encounter other issues if the result contains bytes data encoded in another encoding than utf8 or raw bytes data that don't represent unicode strings.
Posts: 45
Threads: 22
Joined: Jan 2022
(Mar-15-2022, 08:35 AM)Gribouillis Wrote: It fails because the dictionary in the result contains a byte string b'CN=user G\xc3\xbc\xc3\xa7l\xc3\xbc,OU=DEVELOPERS,OU=ANKARA,OU=TURKIYE,OU=TRD-GLOBAL,DC=TRD,DC=local' . A solution is to decode it to unicode with the utf8 encoding. Here is working code that I found with my search engine
result = (True, {'result': 0, 'description': 'success', 'dn': '', 'message': '', 'referrals': None, 'type': 'searchResDone'}, [{'raw_dn': b'CN=user G\xc3\xbc\xc3\xa7l\xc3\xbc,OU=DEVELOPERS,OU=ANKARA,OU=TURKIYE,OU=TRD-GLOBAL,DC=TRD,DC=local', 'dn': 'CN=User1,OU=DEVELOPER,OU=ANKARA,OU=TURKIYE,OU=TRD-GLOBAL,DC=TRD,DC=local', 'raw_attributes': {}, 'attributes': {}, 'type': 'searchResEntry'}, {'uri': ['ldap://ForestDnsZones.TRD.local/DC=ForestDnsZones,DC=TRD,DC=local'], 'type': 'searchResRef'}, {'uri': ['ldap://DomainDnsZones.TRD.local/DC=DomainDnsZones,DC=TRD,DC=local'], 'type': 'searchResRef'}, {'uri': ['ldap://TRD.local/CN=Configuration,DC=TRD,DC=local'], 'type': 'searchResRef'}], {'base': 'dc=my,dc=server', 'scope': 2, 'dereferenceAlias': 3, 'sizeLimit': 0, 'timeLimit': 0, 'typesOnly': False, 'filter': '(sAMAccountName=user1)', 'attributes': ['1.1'], 'type': 'searchRequest', 'controls': None})
import json
class MyEncoder(json.JSONEncoder):
def default(self, obj):
if isinstance(obj, bytes):
return str(obj, encoding='utf-8');
return json.JSONEncoder.default(self, obj)
s = json.dumps(result, cls=MyEncoder, indent=4)
print(s) Output: [
true,
{
"result": 0,
"description": "success",
"dn": "",
"message": "",
"referrals": null,
"type": "searchResDone"
},
[
{
"raw_dn": "CN=user G\u00fc\u00e7l\u00fc,OU=DEVELOPERS,OU=ANKARA,OU=TURKIYE,OU=TRD
-GLOBAL,DC=TRD,DC=local",
"dn": "CN=User1,OU=DEVELOPER,OU=ANKARA,OU=TURKIYE,OU=TRD-GLOBAL,DC=TRD,DC=local",
"raw_attributes": {},
"attributes": {},
"type": "searchResEntry"
},
{
"uri": [
"ldap://ForestDnsZones.TRD.local/DC=ForestDnsZones,DC=TRD,DC=local"
],
"type": "searchResRef"
},
{
"uri": [
"ldap://DomainDnsZones.TRD.local/DC=DomainDnsZones,DC=TRD,DC=local"
],
"type": "searchResRef"
},
{
"uri": [
"ldap://TRD.local/CN=Configuration,DC=TRD,DC=local"
],
"type": "searchResRef"
}
],
{
"base": "dc=my,dc=server",
"scope": 2,
"dereferenceAlias": 3,
"sizeLimit": 0,
"timeLimit": 0,
"typesOnly": false,
"filter": "(sAMAccountName=user1)",
"attributes": [
"1.1"
],
"type": "searchRequest",
"controls": null
}
]
You could perhaps serialize only result[1] because I think the True value at the start of the result is not part of the result's payload. Also note that this solution may encounter other issues if the result contains bytes data encoded in another encoding than utf8 or raw bytes data that don't represent unicode strings.
Thank you. I try the code i have an error message.
TypeError: Object of type 'CaseInsensitiveDict' is not JSON serializable
Posts: 4,784
Threads: 76
Joined: Jan 2018
Try to convert it to dict for example
from ldap3.utils.ciDict import CaseInsensitiveDict
class MyEncoder(json.JSONEncoder):
def default(self, obj):
if isinstance(obj, bytes):
obj = str(obj, encoding='utf-8')
elif isinstance(obj, CaseInsensitiveDict):
obj = dict(obj)
return json.JSONEncoder.default(self, obj)
Posts: 45
Threads: 22
Joined: Jan 2022
(Mar-15-2022, 09:45 AM)Gribouillis Wrote: Try to convert it to dict for example
from ldap3.utils.ciDict import CaseInsensitiveDict
class MyEncoder(json.JSONEncoder):
def default(self, obj):
if isinstance(obj, bytes):
obj = str(obj, encoding='utf-8')
elif isinstance(obj, CaseInsensitiveDict):
obj = dict(obj)
return json.JSONEncoder.default(self, obj)
my mind is so confused. I run this
class MyEncoder(json.JSONEncoder):
def default(self, obj):
if isinstance(obj, bytes):
return str(obj, encoding='utf-8');
elif isinstance(obj, CaseInsensitiveDict):
return dict(obj)
return json.JSONEncoder.default(self, obj)
s = json.dumps(result, cls=MyEncoder, indent=4)
print(s) I get this error
elif isinstance(obj, CaseInsensitiveDict):
TypeError: isinstance() arg 2 must be a type or tuple of types
Posts: 4,784
Threads: 76
Joined: Jan 2018
What is the type of CaseInsensitiveDict ?
|