Git Product home page Git Product logo

Comments (18)

tccyp001 avatar tccyp001 commented on May 4, 2024

where is your android sdk, can you try:
echo $ANDROID_HOME
you should see something like:
/usr/local/xxx/Android/Sdk

from android-uiconductor.

analtrivedi avatar analtrivedi commented on May 4, 2024

from android-uiconductor.

analtrivedi avatar analtrivedi commented on May 4, 2024

Hi,

I Solved ANDROID_HOME related issue and able to build successfully.

But after getting BUILD successful message its showing below error.

Error Log:
**[INFO] --- spring-boot-maven-plugin:1.5.7.RELEASE:repackage (default) @ uicd-service ---
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 3.715s
[INFO] Finished at: Mon Feb 18 19:29:52 JST 2019
[INFO] Final Memory: 37M/531M
[INFO] ------------------------------------------------------------------------
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: [email protected] (node_modules/asap):
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: request to https://registry.npmjs.org/asap/-/asap-2.0.6.tgz failed, reason: write EPROTO 139682844190592:error:1408F10B:SSL routines:ssl3_get_record:wrong version number:../deps/openssl/openssl/ssl/record/ssl3_record.c:252:
npm WARN optional SKIPPING OPTIONAL DEPENDENCY:

npm ERR! code EPROTO
npm ERR! errno EPROTO
npm ERR! request to https://registry.npmjs.org/@ngtools/json-schema/-/json-schema-1.2.0.tgz failed, reason: write EPROTO 139682844190592:error:1408F10B:SSL routines:ssl3_get_record:wrong version number:../deps/openssl/openssl/ssl/record/ssl3_record.c:252:
npm ERR!

npm ERR! A complete log of this run can be found in:
npm ERR! /home/CORPUSERS/xp...../.npm/_logs/2019-02-18T10_29_56_996Z-debug.log**

I think this is Angular CLI setup related error..

If you have any information about this error then please share with us...

from android-uiconductor.

tccyp001 avatar tccyp001 commented on May 4, 2024

Please make sure node and angular is the following version
Angular CLI: 1.7.4
Node: 10.15.0

Please let me know if you still have issue build it, I can provider a release version here, so that you don't need build or anything.

from android-uiconductor.

analtrivedi avatar analtrivedi commented on May 4, 2024

It was proxy related issue and now it has been solved. I am able to build successfully and launched UIConductor using "start.sh" script.
But unfortunately the device is not getting connected with UIConductor(Not showing device screen on UIConductor). Please check below for system setup details & back end launching logs.

Setup Details:
1. Node JS Installed
$ node -v
v10.15.1

2. Angular CLI Installed
Your global Angular CLI version (7.3.2) is greater than your local
version (1.7.4). The local Angular CLI version is used.

3. Device Connect
$ adb devices
List of devices attached
BH9300F8D4 device
Removed password or pattern lock.

4. Java Version
$ java -version
java version "1.8.0_201"
Java(TM) SE Runtime Environment (build 1.8.0_201-b09)
Java HotSpot(TM) 64-Bit Server VM (build 25.201-b09, mixed mode)

5.Create mysql database.
Create an empty database schema called "uicddb" - Done
Execute backend/src/com/google/uicd/backend/recorder/db/initdb.sql to init the database schema. -Done

$ mysql> desc uicddb.uicd_testcase;
+-------------+--------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+-------------------+-------+
| uuid | varchar(60) | NO | PRI | NULL | |
| type | varchar(60) | NO | MUL | NULL | |
| name | varchar(100) | NO | | NULL | |
| tag | varchar(200) | NO | | NULL | |
| description | varchar(500) | NO | | NULL | |
| details | blob | YES | | NULL | |
| created_by | varchar(50) | NO | | NULL | |
| created_at | timestamp | NO | | CURRENT_TIMESTAMP | |
+-------------+--------------+------+-----+-------------------+-------+

Launch UIConductor

$ cd release/
$ ./start.sh

================================= Launch Backend ================================================
List of devices attached
BH9300F8D4 device

Font Name: Doh
UUUUUUUU UUUUUUUUIIIIIIIIII CCCCCCCCCCCCCDDDDDDDDDDDDD
U::::::U U::::::UI::::::::I CCC::::::::::::CD::::::::::::DDD
U::::::U U::::::UI::::::::I CC:::::::::::::::CD:::::::::::::::DD
UU:::::U U:::::UUII::::::IIC:::::CCCCCCCC::::CDDD:::::DDDDD:::::D
U:::::U U:::::U I::::I C:::::C CCCCCC D:::::D D:::::D
U:::::D D:::::U I::::IC:::::C D:::::D D:::::D
U:::::D D:::::U I::::IC:::::C D:::::D D:::::D
U:::::D D:::::U I::::IC:::::C D:::::D D:::::D
U:::::D D:::::U I::::IC:::::C D:::::D D:::::D
U:::::D D:::::U I::::IC:::::C D:::::D D:::::D
U:::::D D:::::U I::::IC:::::C D:::::D D:::::D
U::::::U U::::::U I::::I C:::::C CCCCCC D:::::D D:::::D
U:::::::UUU:::::::U II::::::IIC:::::CCCCCCCC::::CDDD:::::DDDDD:::::D
UU:::::::::::::UU I::::::::I CC:::::::::::::::CD:::::::::::::::DD
UU:::::::::UU I::::::::I CCC::::::::::::CD::::::::::::DDD
UUUUUUUUU IIIIIIIIII CCCCCCCCCCCCCDDDDDDDDDDDDD

2019-02-20 16:10:47.284 INFO 2153 --- [ main] com.google.uicd.backend.app.Application : Starting Application v0.1.0 on jptolx....... with PID 2153 (/home/CORPUSERS/
.........../UIConductor/Set2/android-uiconductor-master/release/uicd-service-0.1.0.jar started by xp...... in /home/CORPUSERS/........./UIConductor/Set2/android-uiconductor-master/release)
2019-02-20 16:10:47.287 INFO 2153 --- [ main] com.google.uicd.backend.app.Application : No active profile set, falling back to default profiles: default
2019-02-20 16:10:47.338 INFO 2153 --- [ main] ationConfigEmbeddedWebApplicationContext : Refreshing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@5cb0d902: startup date [Wed Feb 20 16:10:47 JST 2019]; root of context hierarchy
2019-02-20 16:10:48.510 INFO 2153 --- [ main] s.b.c.e.t.TomcatEmbeddedServletContainer : Tomcat initialized with port(s): 8089 (http)
2019-02-20 16:10:48.521 INFO 2153 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2019-02-20 16:10:48.522 INFO 2153 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet Engine: Apache Tomcat/8.5.20
2019-02-20 16:10:48.584 INFO 2153 --- [ost-startStop-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
2019-02-20 16:10:48.584 INFO 2153 --- [ost-startStop-1] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 1248 ms
2019-02-20 16:10:48.685 INFO 2153 --- [ost-startStop-1] o.s.b.w.servlet.ServletRegistrationBean : Mapping servlet: 'dispatcherServlet' to [/]
2019-02-20 16:10:48.688 INFO 2153 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'characterEncodingFilter' to: [/]
2019-02-20 16:10:48.689 INFO 2153 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'hiddenHttpMethodFilter' to: [/
]
2019-02-20 16:10:48.689 INFO 2153 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'httpPutFormContentFilter' to: [/]
2019-02-20 16:10:48.689 INFO 2153 --- [ost-startStop-1] o.s.b.w.servlet.FilterRegistrationBean : Mapping filter: 'requestContextFilter' to: [/
]
2019-02-20 16:10:48.732 INFO 2153 --- [ main] o.s.j.d.DriverManagerDataSource : Loaded JDBC driver: com.mysql.jdbc.Driver
Cannot connect to Mysql
2019-02-20 16:10:52.919 WARN 2153 --- [ main] ationConfigEmbeddedWebApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'workflowManager': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Connection must not be null
2019-02-20 16:10:52.920 INFO 2153 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat]
2019-02-20 16:10:52.929 INFO 2153 --- [ main] utoConfigurationReportLoggingInitializer :

Error starting ApplicationContext. To display the auto-configuration report re-run your application with 'debug' enabled.
2019-02-20 16:10:52.935 ERROR 2153 --- [ main] o.s.boot.SpringApplication : Application startup failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'workflowManager': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Connection must not be null
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:137) ~[spring-beans-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:409) ~[spring-beans-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1620) ~[spring-beans-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) ~[spring-beans-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) ~[spring-beans-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) ~[spring-beans-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761) ~[spring-beans-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) ~[spring-context-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543) ~[spring-context-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122) ~[spring-boot-1.5.7.RELEASE.jar!/:1.5.7.RELEASE]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:693) [spring-boot-1.5.7.RELEASE.jar!/:1.5.7.RELEASE]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:360) [spring-boot-1.5.7.RELEASE.jar!/:1.5.7.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:303) [spring-boot-1.5.7.RELEASE.jar!/:1.5.7.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1118) [spring-boot-1.5.7.RELEASE.jar!/:1.5.7.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1107) [spring-boot-1.5.7.RELEASE.jar!/:1.5.7.RELEASE]
at com.google.uicd.backend.app.Application.main(Application.java:48) [classes!/:0.1.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_201]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_201]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_201]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_201]
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [uicd-service-0.1.0.jar:0.1.0]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [uicd-service-0.1.0.jar:0.1.0]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [uicd-service-0.1.0.jar:0.1.0]
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) [uicd-service-0.1.0.jar:0.1.0]
Caused by: java.lang.IllegalArgumentException: Connection must not be null
at org.springframework.util.Assert.notNull(Assert.java:134) ~[spring-core-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.jdbc.datasource.SingleConnectionDataSource.(SingleConnectionDataSource.java:115) ~[spring-jdbc-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at com.google.uicd.backend.core.db.ActionDAO.(ActionDAO.java:43) ~[classes!/:0.1.0]
at com.google.uicd.backend.core.db.ActionStorageManager.init(ActionStorageManager.java:311) ~[classes!/:0.1.0]
at com.google.uicd.backend.core.db.ActionStorageManager.(ActionStorageManager.java:49) ~[classes!/:0.1.0]
at com.google.uicd.backend.recorder.workflowmgr.WorkflowManager.init(WorkflowManager.java:487) ~[classes!/:0.1.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_201]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_201]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_201]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_201]
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:366) ~[spring-beans-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:311) ~[spring-beans-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:134) ~[spring-beans-4.3.11.RELEASE.jar!/:4.3.11.RELEASE]
... 26 common frames omitted

================================= Launch Frontend ================================================
[2186:2186:0220/161056.836465:ERROR:browser_dm_token_storage_linux.cc(93)] Error: /etc/machine-id contains 32 characters (32 were expected).
[2186:2186:0220/161056.836707:ERROR:configuration_policy_handler_list.cc(91)] Unknown policy: EnableCommonNameFallbackForLocalAnchors
Fontconfig warning: "/etc/fonts/fonts.conf", line 86: unknown element "blank"
ATTENTION: default value of option force_s3tc_enable overridden by environment.
[2186:2186:0220/161056.898184:ERROR:configuration_policy_handler_list.cc(91)] Unknown policy: EnableCommonNameFallbackForLocalAnchors
[2223:2223:0220/161056.901248:ERROR:sandbox_linux.cc(379)] InitializeSandbox() called with multiple threads in process gpu-process.
[2186:2186:0220/161056.967058:ERROR:gpu_process_transport_factory.cc(980)] Lost UI shared context.

from android-uiconductor.

tccyp001 avatar tccyp001 commented on May 4, 2024

it says "Cannot connect to Mysql"
have you change the uicd.cfg?
Please follow the instruction in READ.

from android-uiconductor.

analtrivedi avatar analtrivedi commented on May 4, 2024

Yes I already changed.

Installation:
5. Set the db connection string in the release/uicd.cfg to something like this: jdbc:mysql://localhost:3306/uicddb?autoReconnect=true&user=root&password=admin&useUnicode=true&characterEncoding=utf-8 Please make sure change the username and password to your own username and password.

Done.

Also I am able to access mysql using my credentials from terminal.

$ mysql -u USERID -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5727
...........
mysql>

from android-uiconductor.

tccyp001 avatar tccyp001 commented on May 4, 2024

you replaced the user=root and password right? it is the mysql connection string issue, please double check.

from android-uiconductor.

analtrivedi avatar analtrivedi commented on May 4, 2024

Yes I checked it. As per your instructions I already modified[changed user & password] in "uicd.cfg" file.
uicd.cfg:
mysqlconnectionstr="jdbc:mysql://localhost:3306/uicddb?autoReconnect=true&user=root&password=XXXX&useUnicode=true&characterEncoding=utf-8"

from android-uiconductor.

tccyp001 avatar tccyp001 commented on May 4, 2024

oh there is no quote for the connection string
should be like this:
mysqlconnectionstr=jdbc:mysql://localhost:3306/uicddb?autoReconnect=true&user=root&password=XXXX&useUnicode=true&characterEncoding=utf-8

from android-uiconductor.

analtrivedi avatar analtrivedi commented on May 4, 2024

Tried without quote also but getting same error.

Class: UicdConfig.java

Method:
public void initDefaultLocalDBConnection() throws UicdExcpetion {
try {
connection =
DriverManager.getConnection(getDBConnStr());
} catch (SQLException e) {
throw new UicdExcpetion("Cannot connect to Mysql");
}
}

I have written same code in separate Java class(Test.java) and it's working if I specify class path with it.

SQLException e:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

This is the exception I am getting while calling getConnection method.

from android-uiconductor.

tccyp001 avatar tccyp001 commented on May 4, 2024

I think it might be your maven setup issue?
what is your mysql version? can you run "mvn dependency:tree" to see the dependency for the backend project?
do you see mysql:mysql-connector-java:jar:5.1.6:compile?

from android-uiconductor.

analtrivedi avatar analtrivedi commented on May 4, 2024

Yes you are correct. I checked dependency:tree and found mysql-connector jar version is 5.1.6
[INFO] +- mysql:mysql-connector-java:jar:5.1.6:compile

So do I need to upgrade mysql version or I need to modify "mysqlconnectionstr" string format that will support my existing mysql-connector jar version.

I have Ubuntu 14.04 OS in my system.

from android-uiconductor.

tccyp001 avatar tccyp001 commented on May 4, 2024

you should have the currect version of mysql connector. not sure why, what is your mysql version?

from android-uiconductor.

tccyp001 avatar tccyp001 commented on May 4, 2024

can you debug what is getDBConnStr() return?

from android-uiconductor.

analtrivedi avatar analtrivedi commented on May 4, 2024

getDBConnStr() return
jdbc:mysql://localhost:3308/uicddb?autoReconnect=true&user=root&password=uicdawesome&useUnicode=true&characterEncoding=utf-8

$ mysql --version
mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (x86_64) using readline 6.3

mysql connector:
/usr/share/java/mysql-connector-java-5.1.28.jar

Below command I used to install connector:
sudo apt-get install libmysql-java

from android-uiconductor.

tccyp001 avatar tccyp001 commented on May 4, 2024

is it because the port should be 3306 instead of 3308?

from android-uiconductor.

analtrivedi avatar analtrivedi commented on May 4, 2024

I found the the problem. getDBConnStr() method of UicdConfig.java returned hard coded connection string. Because maybe "mysqlConnectionSting" is null or empty. So in initDefaultLocalDBConnection method I modified connection string manually as below and build it again. After that its working fine.

public void initDefaultLocalDBConnection() throws UicdExcpetion {
    try {
      String TempStr = "jdbc:mysql://localhost:3306/uicddb?autoReconnect=true&user=root&password=zero&useUnicode=true&characterEncoding=utf-8";
      connection =
          DriverManager.getConnection(TempStr);
    } catch (SQLException e) {
      throw new UicdExcpetion("Cannot connect to Mysql");
    }
  }  

Thanks for your help & support. :-)

from android-uiconductor.

Related Issues (16)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.