If I had to guess the dev profile is causing your problems. The dev profile automatically loads a couple test users for development so if you are adding the same user(s) separately then I would expect the error you are seeing. A couple of ideas:
- skip the step in the instructions to add users or add different users besides 'user' and 'admin' - don't use the dev profile and manage users yourself - if you're able to use a more recent version, enable LDAP instead Hope that helps. On Thu, Mar 14, 2019 at 5:42 AM Hema malini <[email protected]> wrote: > I am still facing tge same issue with Ambari interface > > On Thu, Mar 14, 2019, 3:59 PM Srikanth Nagarajan <[email protected]> > wrote: > >> Hi - If you are using Ambari interface to start and stop the Metron and >> associated processes this should not happen. I had similar issue only >> during the install once upon a command line start of the process. >> >> Thanks >> >> Srikanth >> >> On March 14, 2019 at 2:34 AM Hema malini <[email protected]> >> wrote: >> >> Hi , >> >> >> >> I followed the instructions in >> https://docs.hortonworks.com/HDPDocuments/HCP1/HCP-1.3.0/bk_installation/content/installing_rest_app.html >> to set up the metron rest db . I have used the profile as dev. But whenever >> I restart the metron rest , I am getting the below error. >> >> >> >> Caused by: org.springframework.dao.DuplicateKeyException: >> PreparedStatementCallback; SQL [insert into users (username, password, >> enabled) values (?,?,?)Duplicate entry 'user' for key 'PRIMARY'; nested >> exception is com.mysql.jdbc.excepti$ >> >> at >> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:242) >> ~[metron-rest-0.7.1.jar:?] >> >> >> >> I deleted the schema and recreated again as mentioned in the link above. >> How can we disable the users being inserted every time during metron rest >> start up . >> >> >> >> >> >> Thanks , >> >> Hema >> >> >> >> >> ______________________ >> >> *Srikanth Nagarajan * >> *Principal* >> >> *Gandiva Networks Inc* >> >> *732.690.1884* Mobile >> >> [email protected] >> >> www.gandivanetworks.com >> >> Please consider the environment before printing this. NOTICE: The >> information contained in this e-mail message is intended for addressee(s) >> only. If you have received this message in error please notify the sender. >> >
