Python Forum

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)

What's in the 'result' object? Have you tried printing result, or dir(result)?

(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

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?

(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

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.

(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

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)

(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

What is the type of CaseInsensitiveDict ?