Some clarifications needed on building with source code

[chaitanyavolkaji]

Hello DataTurks team,

I have few doubts on building build.

1. Which is the stable branch(master or master_with_dist) to build? I'm using master branch.
2. Which version of mysql-server you are using? I 'm using mysql-server latest
3. I'm able to build(in master branch) the snapshot.jar finally using mvn package, but running into some database connection issues.

• First error I got is
  HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set

Then I have set dialect in on-prem.yaml file using below

database:
driverClass: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/books
user: root
password: root
properties:
charSet: UTF-8
hibernate.dialect: org.hibernate.dialect.MySQLDialect
hibernate.hbm2ddl.auto: create

• After specifying above configuration, I'm getting below error
  Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.

[nishantbhat]

hey,
am also not able to build the package from source. But I found working docker https://hub.docker.com/r/klimentij/dataturks here.
If you want you can pull that.

thank you.

[GokulNC]

@chaitanyavolkaji

1. I actually merged the master_with_dist branch to the master branch and used the repo.
2. You can use any mysql-server version I believe, though I worked using 5.7
3. You'll have to setup the DB using initMySQL.sh before running the backend service. This script will setup a DB called hope with a default user called dataturks with password 12345, which is mentioned already in the onprem.yml, hence you need not modify that file unless you have changed the credentials or db_name. (You might have to add the -p argument to each mysql command so that you can enter the root password)

[GokulNC]

@nishantbhat
Can you please provide the instructions on how to pull it and run it? (the exact commands?)
I was able to pull it and run using docker run, but was unable to connect to the localhost.

[chaitanyavolkaji]

Hello @nishantbhat @GokulNC ,

Finally, I'm able to build using source code of master branch. I'm able to run DataTurks on-prem. However some CSS things were broken while building front end, but intended functionality is still working.

[get-Resource]

@GokulNC您好，我可以使用源代码进行构建，但是http：// localhost / projects /登录页面空白且无提示。无法登录，我不知道我的构建是否有效

[GokulNC]

@get-Resource Please follow the 3 steps which I mentioned in my first comment.
Or you can also try using this latest currently maintaining fork.

[Danble]

Hello @nishantbhat @GokulNC ,

Finally, I'm able to build using source code of master branch. I'm able to run DataTurks on-prem. However some CSS things were broken while building front end, but intended functionality is still working.

@get-Resource please tell me how could you build and run dataturks. I have this error:
Exception in thread "main" org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

when I try to start the backend this way:
java -Djava.net.useSystemProxies=true -server -jar dataturks-1.0-SNAPSHOT.jar server onprem.yml

I changed my database to show there wasn't a connection problem with my db and I already checked my db connection is fine. I don't know what is happening.
I also tried dataturks via dockerfile and it works almost perfect but on the server where we need to install it, we're are not able to use port 80 and docker dataturks needs port 80 to store users, because it doesn't work on other port, I already tried many times.