How to install transformation via console

I am looking to enabled/install the regex transformation via the console.

I am running 3.2.0.M2

openhab> feature:list|grep transform
openhab-transformation-bin2json                   x 3.1.0            x          x Uninstalled x openhab-addons-3.1.0     x Binary To JSON Transformation
openhab-transformation-exec                       x 3.1.0            x          x Uninstalled x openhab-addons-3.1.0     x Exec Transformation
openhab-transformation-javascript                 x 3.1.0            x x        x Started     x openhab-addons-3.1.0     x Javascript Transformation
openhab-transformation-jinja                      x 3.1.0            x          x Uninstalled x openhab-addons-3.1.0     x Jinja Transformation
openhab-transformation-jsonpath                   x 3.1.0            x x        x Started     x openhab-addons-3.1.0     x JSONPath Transformation
openhab-transformation-map                        x 3.1.0            x x        x Started     x openhab-addons-3.1.0     x Map Transformation
openhab-transformation-regex                      x 3.1.0            x x        x Started     x openhab-addons-3.1.0     x RegEx Transformation
openhab-transformation-scale                      x 3.1.0            x x        x Started     x openhab-addons-3.1.0     x Scale Transformation
openhab-transformation-xpath                      x 3.1.0            x          x Uninstalled x openhab-addons-3.1.0     x XPath Transformation
openhab-transformation-xslt                       x 3.1.0            x          x Uninstalled x openhab-addons-3.1.0     x XSLT Transformation
openhab> feature:install ....
1 Like

Am I missing something?

openhab> feature:list|grep transform
gogo: CommandNotFoundException: Command not found: feature:list

openhab>

You entered the command after logging into the karaf console ?

Yes, the karaf console

[root@openhab items]$ ssh -p 8101 openhab@localhost
Password:

                           _   _     _     ____
   ___   ___   ___   ___  | | | |   / \   | __ )
  / _ \ / _ \ / _ \ / _ \ | |_| |  / _ \  |  _ \
 | (_) | (_) |  __/| | | ||  _  | / ___ \ | |_) )
  \___/|  __/ \___/|_| |_||_| |_|/_/   \_\|____/
       |_|       3.2.0.M2 - Milestone Build

Use '<tab>' for a list of available commands
and '[cmd] --help' for help on a specific command.
To exit, use '<ctrl-d>' or 'logout'.

openhab> feature:list
Command not found: feature:list
openhab>

Bundle:list works… perhaps ID 189 is part of my problem?

openhab> bundle:list
START LEVEL 100 , List Threshold: 50
 ID β”‚ State    β”‚ Lvl β”‚ Version               β”‚ Name
────┼──────────┼─────┼───────────────────────┼─────────────
 31 β”‚ Active   β”‚  80 β”‚ 2.12.3                β”‚ Jackson-annotations
 32 β”‚ Active   β”‚  80 β”‚ 2.12.3                β”‚ Jackson-core
 33 β”‚ Active   β”‚  80 β”‚ 2.12.3                β”‚ jackson-databind
 34 β”‚ Active   β”‚  80 β”‚ 2.12.3                β”‚ Jackson-dataformat-YAML
 35 β”‚ Active   β”‚  80 β”‚ 2.12.3                β”‚ Jackson datatype: JSR310
 36 β”‚ Active   β”‚  80 β”‚ 6.2.4                 β”‚ Woodstox
 37 β”‚ Active   β”‚  80 β”‚ 2.8.6                 β”‚ Gson
 38 β”‚ Active   β”‚  80 β”‚ 27.1.0.jre            β”‚ Guava: Google Core Libraries for Java
 39 β”‚ Active   β”‚  80 β”‚ 30.1.0.jre            β”‚ Guava: Google Core Libraries for Java
 40 β”‚ Active   β”‚  80 β”‚ 1.0.1                 β”‚ Guava InternalFutureFailureAccess and InternalFutures
 41 β”‚ Active   β”‚  80 β”‚ 3.0.0.v201312141243   β”‚ Google Guice (No AOP)
 43 β”‚ Active   β”‚  80 β”‚ 4.8.35.v20190528-1517 β”‚ ClassGraph
...
189 β”‚ Waiting  β”‚  80 β”‚ 3.2.0.M2              β”‚ openHAB Core :: Bundles :: Karaf Integration
...

Its the only one that says β€œWaiting”.

Here are some of the logs (related to β€œkaraf” and β€œfeature”) which may help:

2021-10-28 05:06:00.190 [INFO ] [ROOT] - bundle org.apache.felix.scr:2.1.26 (72) Starting with globalExtender setting: false
2021-10-28 05:06:00.198 [INFO ] [ROOT] - bundle org.apache.felix.scr:2.1.26 (72)  Version = 2.1.26
2021-10-28 05:06:00.290 [INFO ] [ll.impl.action.osgi.CommandExtension] - Registering commands for bundle org.apache.karaf.bundle.core/4.3.2
2021-10-28 05:06:00.339 [INFO ] [ll.impl.action.osgi.CommandExtension] - Registering commands for bundle org.apache.karaf.config.core/4.3.2
2021-10-28 05:06:00.578 [INFO ] [ll.impl.action.osgi.CommandExtension] - Registering commands for bundle org.apache.karaf.diagnostic.core/4.3.2
2021-10-28 05:06:00.598 [INFO ] [ll.impl.action.osgi.CommandExtension] - Command registration delayed for bundle org.apache.karaf.features.command/4.3.2. Missing service: [org.eclipse.equinox.region.RegionDigraph, org.apache.karaf.features.FeaturesService]
2021-10-28 05:06:00.630 [INFO ] [ll.impl.action.osgi.CommandExtension] - Command registration delayed for bundle org.apache.karaf.http.core/4.3.2. Missing service: [org.apache.karaf.http.core.ServletService, org.apache.karaf.http.core.ProxyService]
2021-10-28 05:06:00.657 [INFO ] [ll.impl.action.osgi.CommandExtension] - Registering commands for bundle org.apache.karaf.instance.core/4.3.2
2021-10-28 05:06:00.676 [INFO ] [ll.impl.action.osgi.CommandExtension] - Command registration delayed for bundle org.apache.karaf.kar.core/4.3.2. Missing service: [org.apache.karaf.kar.KarService]
2021-10-28 05:06:00.696 [INFO ] [ll.impl.action.osgi.CommandExtension] - Command registration delayed for bundle org.apache.karaf.log.core/4.3.2. Missing service: [org.apache.karaf.log.core.LogService]
2021-10-28 05:06:00.708 [INFO ] [ll.impl.action.osgi.CommandExtension] - Registering commands for bundle org.apache.karaf.package.core/4.3.2
2021-10-28 05:06:00.789 [INFO ] [ll.impl.action.osgi.CommandExtension] - Registering commands for bundle org.apache.karaf.log.core/4.3.2
2021-10-28 05:06:00.808 [INFO ] [ll.impl.action.osgi.CommandExtension] - Unregistering commands for bundle org.apache.karaf.log.core/4.3.2
2021-10-28 05:06:00.814 [INFO ] [ll.impl.action.osgi.CommandExtension] - Registering commands for bundle org.apache.karaf.log.core/4.3.2
2021-10-28 05:06:00.834 [INFO ] [ll.impl.action.osgi.CommandExtension] - Registering commands for bundle org.apache.karaf.service.core/4.3.2
2021-10-28 05:06:01.070 [INFO ] [ll.impl.action.osgi.CommandExtension] - Command registration delayed for bundle org.apache.karaf.shell.ssh/4.3.2. Missing service: [org.apache.sshd.server.SshServer]
2021-10-28 05:06:01.104 [INFO ] [ll.impl.action.osgi.CommandExtension] - Registering commands for bundle org.apache.karaf.system.core/4.3.2
2021-10-28 05:06:01.184 [INFO ] [rg.apache.aries.spifly.BaseActivator] - Registered provider org.eclipse.jetty.http.Http1FieldPreEncoder of service org.eclipse.jetty.http.HttpFieldPreEncoder in bundle org.eclipse.jetty.http
2021-10-28 05:06:01.242 [INFO ] [rg.apache.aries.spifly.BaseActivator] - Registered provider org.eclipse.jetty.security.jaspi.JaspiAuthenticatorFactory of service org.eclipse.jetty.security.Authenticator$Factory in bundle org.eclipse.jetty.security.jaspi
2021-10-28 05:06:01.300 [INFO ] [ll.impl.action.osgi.CommandExtension] - Registering commands for bundle org.apache.karaf.shell.ssh/4.3.2
2021-10-28 05:06:01.317 [INFO ] [rg.apache.aries.spifly.BaseActivator] - Registered provider org.eclipse.jetty.websocket.common.extensions.identity.IdentityExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
2021-10-28 05:06:01.321 [INFO ] [rg.apache.aries.spifly.BaseActivator] - Registered provider org.eclipse.jetty.websocket.common.extensions.fragment.FragmentExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
2021-10-28 05:06:01.324 [INFO ] [rg.apache.aries.spifly.BaseActivator] - Registered provider org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
2021-10-28 05:06:01.327 [INFO ] [rg.apache.aries.spifly.BaseActivator] - Registered provider org.eclipse.jetty.websocket.common.extensions.compress.DeflateFrameExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
2021-10-28 05:06:01.328 [INFO ] [rg.apache.aries.spifly.BaseActivator] - Registered provider org.eclipse.jetty.websocket.common.extensions.compress.XWebkitDeflateFrameExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
...
2021-10-28 05:06:02.493 [INFO ] [ll.impl.action.osgi.CommandExtension] - Registering commands for bundle org.apache.karaf.event/4.3.2
2021-10-28 05:06:03.069 [INFO ] [rvice.jetty.internal.JettyServerImpl] - Pax Web available at [0.0.0.0]:[8443]
2021-10-28 05:06:03.091 [INFO ] [vice.jetty.internal.JettyFactoryImpl] - No ALPN class available
2021-10-28 05:06:03.092 [INFO ] [vice.jetty.internal.JettyFactoryImpl] - HTTP/2 not available, creating standard ServerConnector for Http
2021-10-28 05:06:03.093 [INFO ] [rvice.jetty.internal.JettyServerImpl] - Pax Web available at [0.0.0.0]:[8080]
2021-10-28 05:06:03.098 [INFO ] [vice.internal.HttpServiceFactoryImpl] - Binding bundle: [org.apache.karaf.http.core_4.3.2 [82]] to http service
2021-10-28 05:06:03.134 [INFO ] [vice.internal.HttpServiceFactoryImpl] - Binding bundle: [org.ops4j.pax.web.pax-web-extender-whiteboard_7.3.16 [221]] to http service
2021-10-28 05:06:03.141 [INFO ] [rd.activator.CxfJaxrsBundleActivator] - created whiteboard from configuration: {service.pid=org.apache.aries.jax.rs.whiteboard.default}
2021-10-28 05:06:03.157 [INFO ] [ll.impl.action.osgi.CommandExtension] - Registering commands for bundle org.apache.karaf.http.core/4.3.2
2021-10-28 05:06:03.422 [INFO ] [vice.internal.HttpServiceFactoryImpl] - Binding bundle: [org.apache.aries.jax.rs.whiteboard_2.0.0 [63]] to http service
...
2021-10-28 05:06:08.293 [INFO ] [ll.impl.action.osgi.CommandExtension] - Registering commands for bundle org.openhab.core.karaf/3.2.0.M2
2021-10-28 05:06:08.303 [INFO ] [ll.impl.action.osgi.CommandExtension] - Updating commands for bundle org.apache.karaf.jaas.command/4.3.2
2021-10-28 05:06:08.307 [INFO ] [ll.impl.action.osgi.CommandExtension] - Updating commands for bundle org.apache.karaf.jaas.command/4.3.2

There are no errors that I can see other than me writing a super long value to the database:

2021-10-28 07:00:49.957 [ERROR] [org.knowm.yank.Yank                 ] - Error in SQL query!!!
java.sql.SQLException: Data too long for column 'value' at row 1
Query is: INSERT INTO item0038 (TIME, VALUE) VALUES( NOW(3), ? ) ON DUPLICATE KEY UPDATE VALUE= ? Query: INSERT INTO item0038 (TIME, VALUE) VALUES( NOW(3), ? ) ON DUPLICATE KEY UPDATE VALUE= ? Parameters: [iVBORw0KGgoAAAANSUhEUgAABQAAAAQACAIAAAAx8WMUAAAgAElEQVR4nOzdd5zd9X3n++/3106b

In case its important…
Ubuntu 18.04.6 LTS (Bionic Beaver)

[root@openhab items]$ /usr/bin/java -version
openjdk version "11.0.13" 2021-10-19 LTS
OpenJDK Runtime Environment Zulu11.52+13-CA (build 11.0.13+8-LTS)
OpenJDK 64-Bit Server VM Zulu11.52+13-CA (build 11.0.13+8-LTS, mixed mode)
[root@openhab ~]$ apt show openhab
Package: openhab
Version: 3.2.0~M3-1
Priority: optional
Section: java
Source: openhab
Maintainer: https://community.openhab.org
Installed-Size: 110 MB
Depends: adduser
Recommends: zip, unzip
Suggests: default-jre | java11-runtime | java11-runtime-headless
Conflicts: openhab2, openhab-runtime, openhab2-online, openhab2-offline
Breaks: openhab2 (<< 3.0.0~)
Replaces: openhab2 (<< 3.0.0~)
Homepage: www.openhab.org
Download-Size: 99.3 MB
APT-Sources: https://openhab.jfrog.io/artifactory/openhab-linuxpkg testing/main amd64 Packages
Description: openhab
 Linux installation package for openHAB.

My solution was to reinstall Openhab from package.

sudo apt-get install --reinstall openhab openhab-addons

Did the trick, can run β€œfeature:list” no problem. Sorry for the spamming.

1 Like