OpenEMS with Odoo authentication failed

svenhakvoort · March 8, 2022, 10:07pm

Hello,

I am trying to setup openEMS together with Odoo following the gitpod examples, however in the backend I keep getting the error Connection to backend failed. Apikey [....]. Error: Unable to authenticate this Apikey.. I tried creating an edge in Odoo and setting this apiKey there but that doesn’t seem to help.

Any idea what I am doing wrong?

Thank you in advance!

stefan.feilmeier · March 13, 2022, 10:34am

Hi Sven,

and welcome to the OpenEMS community.

What you did sounds correct in principle. The error you see was thrown here:

github.com

OpenEMS/openems/blob/develop/io.openems.backend.edgewebsocket/src/io/openems/backend/edgewebsocket/OnOpen.java#L37-L41

      
        
            			// get edgeId for apikey
            			var edgeIdOpt = this.parent.metadata.getEdgeIdForApikey(apikey);
            			if (!edgeIdOpt.isPresent()) {
            				throw new OpenemsException("Unable to authenticate this Apikey.");
            			}

With a Odoo Metadata provider, the error would originate from here:

github.com

OpenEMS/openems/blob/develop/io.openems.backend.metadata.odoo/src/io/openems/backend/metadata/odoo/OdooMetadata.java#L127-L134

      
        
            	@Override
            	public Optional<String> getEdgeIdForApikey(String apikey) {
            		var edgeOpt = this.postgresHandler.getEdgeForApikey(apikey);
            		if (edgeOpt.isPresent()) {
            			return Optional.of(edgeOpt.get().getId());
            		}
            		return Optional.empty();
            	}

In the current implementation the Edges are cached by OpenEMS Backend on initialization. This will be changed in future. Did you add the Edge in Odoo after starting the OpenEMS Backend? Can you try debugging the initialization (from openems/InitializeEdgesWorker.java at develop · OpenEMS/openems · GitHub) to see if the Edges are properly imported in Backend?

Regards,
Stefan

svenhakvoort · March 27, 2022, 10:30pm

Yes I tried that but to no avail. Also seeing a lot of org.postgresql.util.PSQLException: ERROR: column “state” does not exist error from the backend, maybe that indicates another issue down the line?

stefan.feilmeier · March 28, 2022, 11:12am

Yes, this is the same problem I found also when I checked our Gitpod Live Demo recently:

I am sorry to say, that the Odoo module seems to be broken right now. We use it in production internally on Odoo v14, and need to find time to backport it to Community (which is difficult right now because we have so many Corona cases…)

Regards,
Stefan

stefan.feilmeier · May 11, 2022, 10:06am

I gave the Gitpod Live-Demo a complete overhaul. Live-Demo should now work with this link: (this runs the develop branch demo, because the required updates will only be released to master on 1st of June)

https://gitpod.io/#https://github.com/OpenEMS/openems/tree/develop

Updated documentation for Gitpod Live-Demo is here:

https://openems.github.io/openems.io/openems/latest/simulation/gitpod.html

Regards,
Stefan