Kylo 0.8.4 Installation Problems

[Jonathan]

Hi All,

I've gone through the official installation instructions at least a dozen times already, and I have never created an installation where I could get past the login screen at localhost:8400.

It appears there are random critical steps left out of the install and config process that make the official instructions an unreliable method in creating a working Kylo installation.

I'm trying to figure out the missing steps so I can progress past the login screen.

Here is my current approach on an Ubuntu VM with Java 8.

Create users (some are superfluous):

useradd -r -m -s /bin/bash nifi && useradd -r -m -s /bin/bash kylo && useradd -r -m -s /bin/bash activemq

groupadd -f kylo && groupadd -f nifi && groupadd -f activemq

Next, install the package:

dpkg -i kylo-0.8.4.1.deb

Now I install MySQL and set the user/pass to root/hadoop:

apt-get -y install mysql-server

Now time to run the setup-wizard.sh:

# /opt/kylo/setup/setup-wizard.sh

The working directory is /opt/kylo/setup

Welcome to the Kylo setup wizard. Lets get started !!!

 

Please enter Y/y or N/n to the following questions:

 

Enter the kylo home folder location, hit Enter for '/opt/kylo': 

 

Would you like to install the database scripts in a database instance? Please enter y/n: n

 

Please enter the password for the dladmin user

> thinkbig

Please re-enter the password for the dladmin user

> thinkbig

Please choose an option to configure Java for Kylo, ActiveMQ, and NiFi

1) I already have Java 8 or higher installed as the system Java and want to use that

2) Install Java 8 in the /opt/java folder for me and use that one

3) I have Java 8 or higher installed in another location already. I will provide the location

4) Java is already setup. No changes necessary

> 4

 

Would you like me to install a local elasticsearch instance? Please enter y/n: n

 

Would you like me to install a local activemq instance?  Please enter y/n: n

 

Would you like me to install a local nifi instance? Please enter y/n: n

users.properties and groups.properties was created in the /opt/kylo folder with the dladmin user. For more information on configuring users and groups please see the "Configure Access Control" page in the Kylo Docs

If this is the first time installing Kylo, or you made hive/database related changes, you will need to modify those settings in the /opt/kylo/kylo-services/conf/application.properties file 

Next, I edited kylo-ui/conf/application.properties and kylo-services/conf/application.properties (see attached) to match the official instructions, as well as the grab bag of magic tricks described in this thread:

Problems Installing Kylo 0.8.4

I ensured the user.properties and groups.properties files had the correct lines and modified permissions:

chown kylo:users /opt/kylo/users.properties

chmod 600 /opt/kylo/users.properties

chown kylo:users /opt/kylo/groups.properties

chmod 600 /opt/kylo/groups.properties

Finally, I ran the SQL setup script:

/opt/kylo/setup/sql/mysql/setup-mysql.sh localhost root hadoop

At this point, I can begin Kylo by executing kylo-service start. I cannot login to localhost:8400 and I see this error in the kylo-ui log:

2018-02-13 03:13:36 INFO  http-nio-8400-exec-4:JerseyRestClient:212 - Created new Jersey Client without SSL connecting to http://localhost:8400/proxy 

2018-02-13 03:13:37 WARN  http-nio-8400-exec-5:SendErrorFilter:65 - Error during filtering

java.net.ConnectException: Connection refused (Connection refused)

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)

at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.net.Socket.connect(Socket.java:589)

at org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:120)

at org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:162)

at org.apache.http.conn.scheme.SchemeSocketFactoryAdaptor.connectSocket(SchemeSocketFactoryAdaptor.java:66)

at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:179)

at org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:144)

at org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:134)

at org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:612)

at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:447)

at org.apache.http.impl.client.AbstractHttpClient.doExecute(AbstractHttpClient.java:884)

at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:117)

at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:55)

at org.springframework.cloud.netflix.zuul.filters.route.SimpleHostRoutingFilter.forwardRequest(SimpleHostRoutingFilter.java:259)

at org.springframework.cloud.netflix.zuul.filters.route.SimpleHostRoutingFilter.forward(SimpleHostRoutingFilter.java:222)

at org.springframework.cloud.netflix.zuul.filters.route.SimpleHostRoutingFilter.run(SimpleHostRoutingFilter.java:174)

at com.netflix.zuul.ZuulFilter.runFilter(ZuulFilter.java:112)

at com.netflix.zuul.FilterProcessor.processZuulFilter(FilterProcessor.java:197)

at com.netflix.zuul.FilterProcessor.runFilters(FilterProcessor.java:161)

at com.netflix.zuul.FilterProcessor.route(FilterProcessor.java:120)

at com.netflix.zuul.ZuulRunner.route(ZuulRunner.java:84)

at com.netflix.zuul.http.ZuulServlet.route(ZuulServlet.java:111)

at com.netflix.zuul.http.ZuulServlet.service(ZuulServlet.java:77)

at org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:158)

at org.springframework.cloud.netflix.zuul.web.ZuulController.handleRequestInternal(ZuulController.java:43)

at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:147)

at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:50)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:858)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.springframework.boot.actuate.autoconfigure.EndpointWebMvcAutoConfiguration$ApplicationContextHeaderFilter.doFilterInternal(EndpointWebMvcAutoConfiguration.java:281)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:115)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:208)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:87)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:103)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)

2018-02-13 03:13:37 ERROR http-nio-8400-exec-4:JerseyRestClient:383 - Failed to process request /v1/about/me

javax.ws.rs.InternalServerErrorException: HTTP 500 Internal Server Error

at org.glassfish.jersey.client.JerseyInvocation.convertToException(JerseyInvocation.java:1020)

at org.glassfish.jersey.client.JerseyInvocation.translate(JerseyInvocation.java:816)

at org.glassfish.jersey.client.JerseyInvocation.access$700(JerseyInvocation.java:92)

at org.glassfish.jersey.client.JerseyInvocation$2.call(JerseyInvocation.java:700)

at org.glassfish.jersey.internal.Errors.process(Errors.java:315)

at org.glassfish.jersey.internal.Errors.process(Errors.java:297)

at org.glassfish.jersey.internal.Errors.process(Errors.java:228)

at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:444)

at org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:696)

at org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:420)

at org.glassfish.jersey.client.JerseyInvocation$Builder.get(JerseyInvocation.java:316)

at com.thinkbiganalytics.rest.JerseyRestClient.get(JerseyRestClient.java:377)

at com.thinkbiganalytics.rest.JerseyRestClient.get(JerseyRestClient.java:359)

at com.thinkbiganalytics.auth.rest.KyloRestLoginModule.retrieveUser(KyloRestLoginModule.java:151)

at com.thinkbiganalytics.auth.rest.KyloRestLoginModule.doLogin(KyloRestLoginModule.java:123)

at com.thinkbiganalytics.auth.jaas.AbstractLoginModule.login(AbstractLoginModule.java:84)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at javax.security.auth.login.LoginContext.invoke(LoginContext.java:755)

at javax.security.auth.login.LoginContext.access$000(LoginContext.java:195)

at javax.security.auth.login.LoginContext$4.run(LoginContext.java:682)

at javax.security.auth.login.LoginContext$4.run(LoginContext.java:680)

at java.security.AccessController.doPrivileged(Native Method)

at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680)

at javax.security.auth.login.LoginContext.login(LoginContext.java:587)

at org.springframework.security.authentication.jaas.AbstractJaasAuthenticationProvider.authenticate(AbstractJaasAuthenticationProvider.java:180)

at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:174)

at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:199)

at org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter.attemptAuthentication(UsernamePasswordAuthenticationFilter.java:94)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:212)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:121)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:87)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:103)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)

Also, curl within the VM doesn't work either:

curl -d 'username=dladmin&password=thinkbig' -D - http://localhost:8400/login

HTTP/1.1 302 Found

Server: Apache-Coyote/1.1

Set-Cookie: remember-me=""; Expires=Thu, 01-Jan-1970 00:00:10 GMT; Path=/

Set-Cookie: JSESSIONID=FA67D7CC0185B0B57B3EF0B4F4D9B3A5; Path=/; HttpOnly

X-Content-Type-Options: nosniff

X-XSS-Protection: 1; mode=block

Cache-Control: no-cache, no-store, max-age=0, must-revalidate

Pragma: no-cache

Expires: 0

X-Frame-Options: DENY

Location: http://localhost:8400/login.html;jsessionid=FA67D7CC0185B0B57B3EF0B4F4D9B3A5?error=true

Content-Length: 0

Date: Tue, 13 Feb 2018 03:37:28 GMT

I can also verify the processes are running:

ps -ef

UID        PID  PPID  C STIME TTY          TIME CMD

root         1     0  0 02:00 pts/0    00:00:00 bash

mysql     3736     1  0 02:11 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe

mysql     4086  3736  0 02:11 ?        00:00:07 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --log-error=/var/log/mysql

kylo      5177     1  2 03:13 ?        00:00:37 java -Xmx512m -cp /opt/kylo/kylo-ui/conf:/opt/kylo/kylo-ui/lib/*:/opt/kylo/kylo-ui/plugin/* com.thinkbiganalytics.Kylo

kylo      5191     1  5 03:13 ?        00:01:17 java -Xmx768m -cp /opt/kylo/kylo-services/conf:/opt/kylo/kylo-services/lib/*:/opt/kylo/kylo-services/lib/nifi-v1.2/*:/

root      5313     1  0 03:37 pts/0    00:00:00 ps -ef

I'm attaching the relevant config files and output files.

If anyone has any advice, thanks in advance!

Jonathan

[Ruslans Uralovs]

Hey Jonathan

Kylo-services hasn't started. Looks like you are hitting an issue where your database is not set to UTC, see if this post helps: https://groups.google.com/d/msg/kylo-community/ZXnXGRFNSkA/jeuM41GgAwAJ

[Jonathan]

Hi Ruslans,

First I tried the steps in the thread you linked.

Here's the first:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

Enter password: hadoop

Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.

Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.

Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.

Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.

Next is the SQL statement:

mysql -u root -p

Enter password: 

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 182

Server version: 5.7.21-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SET GLOBAL time_zone = 'UTC';

Query OK, 0 rows affected (0.00 sec)

I tried starting Kylo again and still couldn't login at localhost:8400.

Next I ran generate-update-sql.sh and ran the update script:

mysql -u root -p < kylo-db-update-script.sql

Enter password: 

ERROR 1067 (42000) at line 14: Invalid default value for 'modified_time'

I no longer see the complaints about "Invalid default value for 'modified_time'" but I still can't login at localhost:8400.

I've attached the latest logs, thanks!

[Jonathan]

I seem to have made a small amount of progress:

In the services appliation.properties I changed these lines:

spring.profiles.include=native,nifi-v1.2,auth-kylo,auth-file,search-esr,jms-activemq

spring.profiles.active=native,auth-file

In the UI properties I changed these lines:

spring.profiles.active=native,auth-file

I can progress the login screen but nothing loads due to HTTP 500 errors everywhere (see attached).

I will experiment with some different settings...

[Greg Hart]

Hi Jonathan,

It looks like an issue with the database tables. When you ran the kylo-db-update-script.sql script, were there any errors? Could you try dropping and recreating the database then re-running the script?

I think that even though you're able to login now, your application.properties changes didn't fix the underlying issue. It just bypassed the issue for the login screen only. I would recommend deleting the "spring.profiles.active=native,auth-file" line from your kylo-services/conf/application.properties file. It may cause additional issues later on.

[Jonathan]

Hi Greg,

As I noted above, the update script produces the following output:

mysql -u root -p < kylo-db-update-script.sql

Enter password:

ERROR 1067 (42000) at line 14: Invalid default value for 'modified_time'

My UI log is filled with exceptions like this:

2018-02-13 17:03:42 WARN  http-nio-8400-exec-3:SendErrorFilter:65 - Error during filtering

And the services log is filled with exceptions like this:

2018-02-13 17:03:09 ERROR main:KyloUpgradeDatabaseVersionChecker:102 - Error has occurred so upgrade is needed

java.sql.SQLSyntaxErrorException: (conn:136) Unknown column 'POINT_VERSION' in 'order clause'

Query is : SELECT * FROM KYLO_VERSION ORDER BY MAJOR_VERSION DESC, MINOR_VERSION DESC, POINT_VERSION DESC, TAG DESC

at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:139)

at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)

at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77)

at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:224)

at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:253)

at org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:366)

at com.thinkbiganalytics.server.upgrade.KyloUpgradeDatabaseVersionChecker.getDatabaseVersion(KyloUpgradeDatabaseVersionChecker.java:90)

at com.thinkbiganalytics.server.upgrade.KyloUpgrader.getCurrentVersion(KyloUpgrader.java:93)

at com.thinkbiganalytics.server.KyloServerApplication.main(KyloServerApplication.java:64)

Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Unknown column 'POINT_VERSION' in 'order clause'

Query is : SELECT * FROM KYLO_VERSION ORDER BY MAJOR_VERSION DESC, MINOR_VERSION DESC, POINT_VERSION DESC, TAG DESC

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1098)

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1030)

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:985)

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:129)

at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:243)

... 4 more

2018-02-13 17:03:09 INFO  main:KyloServerApplication:65 - *****  Upgrade required - this may take some time  *****

2018-02-13 17:03:09 INFO  main:KyloServerApplication:66 - Beginning upgrade from version unknown ...

2018-02-13 17:03:12 INFO  main:KyloServerApplication:664 - The following profiles are active: nifi-v1.2,auth-kylo,auth-file,search-esr,jms-activemq,kyloUpgrade,native

2018-02-13 17:03:21 INFO  localhost-startStop-1:ModeShapeEngineConfig:133 - Starting ModeShape engine...

2018-02-13 17:03:21 INFO  localhost-startStop-1:ModeShapeEngineConfig:135 - ModeShape engine started

2018-02-13 17:03:21 INFO  localhost-startStop-1:HikariDataSource:70 - HikariPool-0 - Started.

2018-02-13 17:03:23 WARN  localhost-startStop-1:RepositoryConfiguration:86 - The field name is not present on com.thinkbiganalytics.metadata.modeshape.security.SpringAuthent

icationProvider or any of its super types

2018-02-13 17:03:23 WARN  localhost-startStop-1:RepositoryConfiguration:86 - The field name is not present on com.thinkbiganalytics.metadata.modeshape.security.OverrideAuthe

nticationProvider or any of its super types

2018-02-13 17:03:23 WARN  localhost-startStop-1:RepositoryConfiguration:86 - The field name is not present on com.thinkbiganalytics.metadata.modeshape.security.AdminAuthenti

cationProvider or any of its super types

2018-02-13 17:03:24 WARN  localhost-startStop-1:ConnectionPool:180 - maxIdle is larger than maxActive, setting maxIdle to: 30

2018-02-13 17:03:25 WARN  localhost-startStop-1:JavaTypeDescriptorRegistry:118 - Could not find matching type descriptor for requested Java class [java.security.Principal]; 

using fallback

2018-02-13 17:03:25 WARN  localhost-startStop-1:JavaTypeDescriptorRegistry:118 - Could not find matching type descriptor for requested Java class [java.util.List]; using fal

lback

2018-02-13 17:03:25 WARN  localhost-startStop-1:JavaTypeDescriptorRegistry:118 - Could not find matching type descriptor for requested Java class [java.util.List]; using fal

lback

2018-02-13 17:03:27 INFO  localhost-startStop-1:JerseyRestClient:212 - Created new Jersey Client without SSL connecting to http://localhost:8079 

2018-02-13 17:03:27 INFO  localhost-startStop-1:AbstractCacheBackedProvider:209 - Populating Cache for com.thinkbiganalytics.metadata.jpa.feed.security.JpaFeedOpsAccessContr

olProvider 

2018-02-13 17:03:28 INFO  localhost-startStop-1:FeedAclCache:97 - FeedAclCache populated.

2018-02-13 17:03:28 INFO  localhost-startStop-1:AbstractCacheBackedProvider:215 - Time to populate com.thinkbiganalytics.metadata.jpa.feed.security.JpaFeedOpsAccessControlPr

ovider Cache 84 ms

2018-02-13 17:03:29 INFO  localhost-startStop-1:AbstractCacheBackedProvider:209 - Populating Cache for com.thinkbiganalytics.metadata.jpa.feed.OpsFeedManagerFeedProvider 

2018-02-13 17:03:29 WARN  localhost-startStop-1:SqlExceptionHelper:129 - SQL Error: 1054, SQLState: 42S22

2018-02-13 17:03:29 ERROR localhost-startStop-1:SqlExceptionHelper:131 - (conn:148) Unknown column 'jpaopsmana0_.IS_STREAM' in 'field list'

Query is: select jpaopsmana0_.id as id1_11_, jpaopsmana0_.FEED_TYPE as FEED_TYP2_11_, jpaopsmana0_.IS_STREAM as IS_STREA3_11_, jpaopsmana0_.name as name4_11_, jpaopsmana0_.T

IME_BTWN_BATCH_JOBS as TIME_BTW5_11_ from FEED jpaopsmana0_

2018-02-13 17:03:30 INFO  localhost-startStop-1:ClusterAwareDtoCache:189 - Populating Cache for ServiceLevelAgreementDescriptionCache 

2018-02-13 17:03:30 WARN  localhost-startStop-1:SqlExceptionHelper:129 - SQL Error: 1146, SQLState: 42S02

2018-02-13 17:03:30 ERROR localhost-startStop-1:SqlExceptionHelper:131 - (conn:148) Table 'kylo.SLA_DESCRIPTION' doesn't exist

Query is: select jpaservice0_.SLA_ID as SLA_ID1_29_, jpaservice0_.DESCRIPTION as DESCRIPT2_29_, jpaservice0_.NAME as NAME3_29_ from SLA_DESCRIPTION jpaservice0_

2018-02-13 17:03:30 INFO  localhost-startStop-1:ElasticSearchRestService:78 - Search engine: Elasticsearch (rc)

2018-02-13 17:08:36 WARN  main:AnnotationConfigEmbeddedWebApplicationContext:546 - Exception encountered during context initialization - cancelling refresh attempt: org.spri

ngframework.beans.factory.BeanCreationException: Error creating bean with name 'kyloUpgradeConfig': Injection of autowired dependencies failed; nested exception is org.sprin

gframework.beans.factory.BeanCreationException: Could not autowire field: private liquibase.integration.spring.SpringLiquibase com.thinkbiganalytics.server.upgrade.KyloUpgra

deConfig.liquibase; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [co

m/thinkbiganalytics/server/upgrade/liquibase/LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.LockException: Could no

t acquire change log lock.  Currently locked by e896ec06b856 (172.17.0.2) since 2/13/18 5:01 PM

2018-02-13 17:08:36 INFO  modeshape-repository-stop-7-thread-1:HikariPool:214 - HikariPool-0 - Close initiated...

2018-02-13 17:08:36 INFO  modeshape-repository-stop-7-thread-1:HikariPool:250 - HikariPool-0 - Closed.

2018-02-13 17:08:36 WARN  localhost-startStop-2:WebappClassLoaderBase:180 - The web application [ROOT] appears to have started a thread named [mariaDb-2-1] but has failed to

 stop it. This is very likely to create a memory leak. Stack trace of thread:

 sun.misc.Unsafe.park(Native Method)

 java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)

 java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:458)

 java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)

 java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:924)

 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1067)

 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)

 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

 java.lang.Thread.run(Thread.java:748)

2018-02-13 17:08:36 WARN  localhost-startStop-2:WebappClassLoaderBase:180 - The web application [ROOT] appears to have started a thread named [mariaDb-2-2] but has failed to

 stop it. This is very likely to create a memory leak. Stack trace of thread:

 sun.misc.Unsafe.park(Native Method)

 java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)

 java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:458)

 java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)

 java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:924)

 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1067)

 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)

 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

 java.lang.Thread.run(Thread.java:748)

2018-02-13 17:08:36 WARN  localhost-startStop-2:WebappClassLoaderBase:180 - The web application [ROOT] appears to have started a thread named [mariaDb-2-3] but has failed to

 stop it. This is very likely to create a memory leak. Stack trace of thread:

 sun.misc.Unsafe.park(Native Method)

 java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)

 java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:458)

 java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)

 java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:924)

 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1067)

 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)

 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

 java.lang.Thread.run(Thread.java:748)

2018-02-13 17:08:36 WARN  localhost-startStop-2:WebappClassLoaderBase:180 - The web application [ROOT] appears to have started a thread named [mariaDb-2-4] but has failed to

 stop it. This is very likely to create a memory leak. Stack trace of thread:

 sun.misc.Unsafe.park(Native Method)

 java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)

 java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:458)

 java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)

 java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:924)

 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1067)

 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)

 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

 java.lang.Thread.run(Thread.java:748)

2018-02-13 17:08:36 WARN  localhost-startStop-2:WebappClassLoaderBase:180 - The web application [ROOT] appears to have started a thread named [mariaDb-2-5] but has failed to

 stop it. This is very likely to create a memory leak. Stack trace of thread:

 sun.misc.Unsafe.park(Native Method)

 java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)

 java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:458)

 java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)

 java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:924)

 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1067)

 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)

 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

 java.lang.Thread.run(Thread.java:748)

2018-02-13 17:08:36 WARN  localhost-startStop-2:WebappClassLoaderBase:180 - The web application [ROOT] appears to have started a thread named [pool-7-thread-1] but has faile

d to stop it. This is very likely to create a memory leak. Stack trace of thread:

 sun.misc.Unsafe.park(Native Method)

 java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)

 java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078)

 java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1093)

 java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:809)

 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1067)

 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)

 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

 java.lang.Thread.run(Thread.java:748)

2018-02-13 17:08:36 WARN  localhost-startStop-2:WebappClassLoaderBase:180 - The web application [ROOT] appears to have started a thread named [pool-10-thread-1] but has fail

ed to stop it. This is very likely to create a memory leak. Stack trace of thread:

 sun.misc.Unsafe.park(Native Method)

 java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)

 java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078)

 java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1093)

 java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:809)

 java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1067)

 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1127)

 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

 java.lang.Thread.run(Thread.java:748)

2018-02-13 17:08:36 ERROR main:SpringApplication:821 - Application startup failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'kyloUpgradeConfig': Injection of autowired dependencies failed; nested exception is o

rg.springframework.beans.factory.BeanCreationException: Could not autowire field: private liquibase.integration.spring.SpringLiquibase com.thinkbiganalytics.server.upgrade.K

yloUpgradeConfig.liquibase; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path reso

urce [com/thinkbiganalytics/server/upgrade/liquibase/LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.LockException: 

Could not acquire change log lock.  Currently locked by e896ec06b856 (172.17.0.2) since 2/13/18 5:01 PM

at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:334)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1214)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)

at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)

at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:760)

at org.springframework.boot.SpringApplication.createAndRefreshContext(SpringApplication.java:360)

at org.springframework.boot.SpringApplication.run(SpringApplication.java:306)

at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:134)

at com.thinkbiganalytics.server.upgrade.KyloUpgrader.upgrade(KyloUpgrader.java:56)

at com.thinkbiganalytics.server.KyloServerApplication.main(KyloServerApplication.java:67)

Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private liquibase.integration.spring.SpringLiquibase com.thinkbiganalytics.serv

er.upgrade.KyloUpgradeConfig.liquibase; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in cla

ss path resource [com/thinkbiganalytics/server/upgrade/liquibase/LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.Loc

kException: Could not acquire change log lock.  Currently locked by e896ec06b856 (172.17.0.2) since 2/13/18 5:01 PM

at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:573)

at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)

at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:331)

... 17 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [com/thinkbiganalytics/server/up

grade/liquibase/LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.LockException: Could not acquire change log lock.  C

urrently locked by e896ec06b856 (172.17.0.2) since 2/13/18 5:01 PM

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1192)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1116)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1014)

at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:545)

... 19 more

Caused by: liquibase.exception.LockException: Could not acquire change log lock.  Currently locked by e896ec06b856 (172.17.0.2) since 2/13/18 5:01 PM

at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:190)

at liquibase.Liquibase.update(Liquibase.java:196)

at liquibase.Liquibase.update(Liquibase.java:192)

at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:431)

at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:388)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)

... 29 more

At this point I'm about to give up as I've even spent 15 hours trying to install Kylo and login.

Perhaps I should try one of the following?

1.) Try a previous version -- maybe 0.8.4.1 introduced all the bugs I'm experiencing?

2.) Try another install method eg., .TAR file

I'm a bit mystified there are so many users of this application when the installation documentation is clearly incorrect or missing the crucial steps necessary to run the software.

Jonathan

[Greg Hart]

Hi Jonathan,

You may need to edit the kylo-db-update-script.sql file and change the default value for modified_time on line 14. The script assumes your database time is in UTC and the script will fail if it's not. Adding one day to the timestamp should fix it. Then you can drop the database, re-create it, and re-run the script and check for additional errors.

The installation steps are mostly the same for previous versions and other install methods. If you need to get something running quickly, you can try using the Kylo sandbox either locally or on Amazon Web Services.

[Jonathan]

Hi Greg,

Turns out answering "no" to setting up DB in the Setup Wizard was a source of problems.

Executing this command: (assuming msql password is 'hadoop')

mysql --password="hadoop" -e "create database if not exists kylo character set utf8 collate utf8_general_ci;"

during the install process fixes the issues above.

Thanks,

Jonathan

[Anup Kumar Saha]

Hi Jonathan,

Can you tell me steps to install kylo.

I am getting so many error during installation of kylo.

Thanks & regards,
Anup Kumar Saha
saha....@gmail.com

[Ruslans Uralovs]

Hi Anup

Please review Kylo documentation here: http://kylo.readthedocs.io/en/latest/

and post your installation problems in a new thread, preferably one problem per thread, thanks.

[Anup Kumar Saha]

Hi,

I am stuck in same place as Jonathan.

At this point I'm about to give up as I've even spent 48 hours trying to install Kylo and login.

It really pathetic in term of kylo document. It's very sad to say that ....learn some thing from Apache people and make simple installation steps.....

Pathetic .......very very pathetic.....

Make some video on ..how to install Kylo .....

I dont know , what is your intention ....i think almost all the people are facing problem during installation .....

[shekhar suman]

Hi