Similar problems with first user creation

1,071 views
Hello.

I want to do local installation on centos 6.6 32 bit.

Mysql version: 5.1.73

When I tried to deploy war on fresh tomcat installation, it failed.

When I tried to install via RPM, it installed successfuly.

I configured al parameters and got to login page.

When I try to create first user, I put in all parameters (name, mail, password...) and click submit.

Then I am redirected to blank page http://localhost:8080/ganib/newregistration/registerUserProcessing.jsp.

In catalina.out I see this errors:

FIRST on tomcat startup:

INFO: Deploying web application directory examples
dec 08, 2014 5:50:11 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory ganib
log4j:ERROR setFile(null,true) call failed.
java.io.FileNotFoundException: ../logs/ganib.log (No such file or directory)
        at java.io.FileOutputStream.open(Native Method)

SECOND:

INFO: Server startup in 25542 ms
Using stylesheet compilation
/ganib/newregistration/registerUser.jsp
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Can't call rollback when autocommit=true
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

THIRD:

        at java.lang.Thread.run(Thread.java:745)
Error in registration process creation
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'USER_ID' cannot be null
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
 

Database is created, user credentials are OK, database is populated with tables (executed ganib.sql ok).

I'm guessing this should be simple error, but I am not java expert.

Please advise
related to an answer for: Can't register first user
asked Dec 9, 2014 by matjaz (220 points)

4 Answers

0 votes
Hello,
 
Thank you for approaching us.
 
To help you solve this issue, we need some more information from you. Can you please let us know which Tomcat version you are using?
 
Please let us know the above details so that we can trace the issue quickly and provide you with best possible solution.
 
Thanks,

Jaclyn

Jaclyn N,
Ganib Support Team, Ganib Inc.
Free Signup | Free Download | Documentation
Skype ID: ganib.support
Email: support@ganib.com

 

answered Dec 9, 2014 by Jaclyn (18,310 points)
Tomcat Version
0 votes
Hello.

I seemed to have clicked wrong button (ask related question, instead of answer to yours..)

I have tomcat6 (latest and fully updated from centos original repositories).
answered Dec 17, 2014 by matjaz (220 points)
0 votes
Hello,
 
We have tried to reproduce this issue from our side.
 
Can you Please install Ganib 5.1 WAR file again on your system and let us know the results?
If you are still facing any issues, We request you to let us have a remote access to your system and we would install it for you.
 
Please let us know your thoughts on this.
 
Thanks,

Jaclyn

Jaclyn N,
Ganib Support Team, Ganib Inc.
Free Signup | Free Download | Documentation
Skype ID: ganib.support
Email: support@ganib.com

 

answered Dec 24, 2014 by Jaclyn (18,310 points)
0 votes
Hello 
 
We have analyzed this issue and found that the MySQL user configured with ganib doesn't have access to required METADATA.
To resolve this issue you need to execute below GRANT queries with MySQL admin user.
 
GRANT SELECT ON mysql.proc TO  'ganibuser'@'%';
GRANT ALTER ROUTINE, CREATE ROUTINE, EXECUTE, SHOW VIEW, CREATE, DROP ON ganib.* TO 'ganib'@'%';
flush privileges;
 
Once those queries are executed successfully restart the ganib instance and check registration process again.
Please let us know if you need any other help.
 
Thanks,

 

Jaclyn

Jaclyn N,
Ganib Support Team, Ganib Inc.
Free Signup | Free Download | Documentation
Skype ID: ganib.support
Email: support@ganib.com

 

answered Mar 18, 2015 by Jaclyn (18,310 points)
...