Installation Documents and version:

The versions of softwares used in Installation of local instance.

Java version: Java1.8.0_73 Tomcat: tomcat 8.0.28 SQL Server: Mysql server 5.7

Securonix home: One available on xx.xx.xx.xx (downloaded on 02/08/2016) Profiler:One available on xx.xx.xx.xx (downloaded on 02/08/2016)

Database Scripts: Securonix_blank_50_1026_1.sql(Available on xx.xx.xx.xx) Securonix_blank_50_0209_2.sql Dump021016.sql(Available on xx.xx.xx.xx) Securonix50beta_5am.sql(Available on xx.xx.xx.xx)

Following error is encountered on startup:

com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception:all parts of primary key must not be null org.hibernate.exception.sqlgrammarexception:could not execute native bulk manipulation query

asked 16 Feb '16, 21:46

Sujay's gravatar image

Sujay
151
accept rate: 0%

edited 29 Mar '16, 01:49

tgulati's gravatar image

tgulati ♦♦
2061411


Use MySQL 5.6 5.7 will be supported in ga release

link

answered 16 Feb '16, 21:48

Sujay's gravatar image

Sujay
151
accept rate: 0%

Using mysql5.6, Following error is encountered on startup: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException

link

answered 16 Feb '16, 21:51

Sujay's gravatar image

Sujay
151
accept rate: 0%

Uncommenting the following lines in tomcat\Webapps\Profile\WEB-INF\classes\quartz.properties as lines highlighted in screenshot get uncomment whille Profiler.war explodes.

***#org.quartz.jobStore.dataSource = myDS

MY Sql

org.quartz.dataSource.myDS.driver = com.mysql.jdbc.Driver

org.quartz.dataSource.myDS.URL = jdbc:mysql://localhost:3306/securonix4611SP2?autoReconnect=true

org.quartz.dataSource.myDS.user = root

org.quartz.dataSource.myDS.password = password***

link

answered 16 Feb '16, 21:56

Sujay's gravatar image

Sujay
151
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×1

Asked: 16 Feb '16, 21:46

Seen: 798 times

Last updated: 29 Mar '16, 01:49

Related questions