connection / certificate error

[HT-Marley]

Hi,

thanks for your great work on this Excel-Makro.
Unfortunately, I get the following error message when connecting with OpenProjectExcel-0.6.15 to our instance in the intranet

I have tried the protocol in the system configuration in Openproject for both https and http and adjusted the "instance url" accordingly. But the error message is the same.
If the option "use proxy" is activated, a different error message appears.

I'am running Openproject 12.0.7 on / via Univention UCS 4.4 server.

Unfortunately there is no debug output either
can you help me with the troubleshooting?

[jcanelhas]

Having the same problem here, how did you solve it ?

[SmallSeedBox]

I have a self signed certificate in OpenProject and received a similar error. In OpenProjectAPIModul, I added

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

    .Open MethodStr, URLCompleteStr, False
    .Option(WinHttpRequestOption_SslErrorIgnoreFlags) = _
    WinHTTP.WinHttpRequestSslErrorFlags.SslErrorFlag_Ignore_All
    

The option lines. It worked for me.

[longyn]

let's encrypt certificate also have the same problem

[MorganReid]

I have a self signed certificate in OpenProject and received a similar error. In OpenProjectAPIModul, I added

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

    .Open MethodStr, URLCompleteStr, False
    .Option(WinHttpRequestOption_SslErrorIgnoreFlags) = _
    WinHTTP.WinHttpRequestSslErrorFlags.SslErrorFlag_Ignore_All
    

The option lines. It worked for me.

My openproject is also using a self-signed certificate and encountered the same problem. I want to try your method, but I don't quite understand how you operate it. Where is OpenProjectAPIModul?