opf / OpenProjectExcel

MIT License
58 stars 23 forks source link

Sync Issue due to using self-signed certificate #64

Closed siddhu2310 closed 8 months ago

siddhu2310 commented 8 months ago

I have hosted in open project community edition in local server , and used self signed certificate. so the Excel Sync is not working and shows error.

image

siddhu2310 commented 8 months ago

I have resolved this by adding Disbale SSL verification. In Module : OpenProjectAPIModul Function : OpenProjectAPI

 With objHTTP
'To remove SSL  Error
    **.Option(WinHttpRequestOption_SslErrorIgnoreFlags) = &H3300**

    .SetTimeouts 0, 60000, waitLng, waitLng '.SetTimeouts resolve, connect, send, receive  '.SetTimeouts 0, 60000, 30000, 120000

    .Open MethodStr, URLCompleteStr, False

    For i = LBound(RequestHeaderArray, 1) To UBound(RequestHeaderArray, 1)

        .SetRequestHeader RequestHeaderArray(i, 1), RequestHeaderArray(i, 2)

    Next i

    If BodyStr = Empty Then

        .Send

    Else

        .Send (BodyStr)

    End If

    If Not .ResponseText = "" Then

        OpenProjectAPI.Add "ResponseText", .ResponseText

    Else

        OpenProjectAPI.Add "ResponseText", "{}"

    End If

    OpenProjectAPI.Add "Status", .Status

    If Not .Status = 200 And Not .Status = 201 And Not .Status = 204 Then

        If Not .ResponseText = Empty Then

            OpenProjectAPI.Add "StatusText", JsonConverter.ParseJson(.ResponseText)("message")

        Else

            MsgBox ("Error at connecting to Server. Abort.")
            Call BasicsModul.Abort

        End If

    Else

        OpenProjectAPI.Add "StatusText", .StatusText

    End If

End With