Blank page after submitting 1st user, user_Id cannot be null in logs

1,374 views

Hi,

I tried Ganib online and liked it over all others. It has all the features that any developer/team would need. But all the excitement died and turned into hair-pulling hours after I decided to install on own server for testing. After some hiccups I managed to get it started and show the signup page. But like others have pointed, it does not work after submitting the user information.

I think this issue never got resolved. Maybe people moved to other products after trying hard. I have been working on this for the last 3 days, reinstalled OS downlgraded to centos 6.4 too to rule out CentOS 7 issues, just in case. However the problem remains the same.

In catalina.out:

============================

INFO: Server startup in 91122 ms
Using stylesheet compilation
/newregistration/registerUser.jsp
=========== checking limit ==========
Class not found exception
Is Valied 1
Error in registration process creation
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'USER_ID' cannot be null
============================

I tried to make USER_ID an auto_increment one but then the error moved to some other column.

Steps taken to fix the issue:

1. Checked database permissions for the user, localhost and all both tried, all OK

2. Checked ganib database, all OK

3. downloaded and updated mysql-connection-5.34----.jar, no resolution

4. Disabled firewall, disabled Selinx - no resolution

5. Tried different ports (obviously this is not the problem)

6. Tried Ganib5.0, 51. on CentOS 7 via WAR and .tgz, same or other issues.

7. Tried bundled JRE and installed separately. same result.

8. Downloaded .sql file from Sourceforge page just to rule out any sql issues.

 

Install details:

==============

Ganib: 5.1 tarbar (had tried WAR and 5.0 tarball earlier, same result)

Database: Mysql 5.1.72

OS: CentOS 6.4 x64

JRE: 1.7u72

Tomcat 7

Database source used: ganib/database/ganib.sql

 

Some other irrelevant anomalies that should not be there:

1. why have space bar in filenames "Start ganib.sh" and "Stop ganib.sh". From this, it makes me feel there could be similar issues inside too.

2. Why do you think everyone will install it on a desktop computer? "Start ganib.sh" tries to start firefox. I am installing on a server so don't have firefox.

Basically, all roads lead to a deadend.  This is how an excellent software dies. I would love to make it work and show everyone how good this software is. Please Guide.

 

Sincerely,

Inderjeet

 

related to an answer for: Can't register first user
asked Mar 16, 2015 by swexpert (280 points)

8 Answers

0 votes

Hello,

Thank you for escalating the issue to us.

We did try to reproduce this issue from our side, but the everything seems to work properly here.

Can we have a remote access to your system, so that we can find the root cause of this issue? This way, we would be able to find a best possible solution to this issue and provide you with the fixes quickly.

Please let us know your thoughts on this. You can contact us on our Skype ID: ganib.support or mail us at support@ganib.com.

Thanks,

Jaclyn

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

 

answered Mar 16, 2015 by Jaclyn (18,310 points)
0 votes
Hi,

Thank you for the response. Certainly, let's get this issue resolved for everyone's sake. I am going to send the SSH credentials to you via support email shortly.

Sincerely,

Inderjeet
answered Mar 16, 2015 by swexpert (280 points)
0 votes
Hello 
 
We did some remote debugging with ganib instance installed on your server and we found that the MySQL user configured with ganib doesn't have access to required METADATA.
To resolved 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)
0 votes

Hi,

Thank you for taking out the time to try to resolve this issue. The specific problem is resolved but now it is stuck at the next step. After successful creation of first user(hopefully), then Add a Group and it stalls, keeps waiting for response from the server:

I used manager to review the information this time. And as you can see the threads keep waiting.

Again, It is on CentOS 6.6 x64, JRE 1.7, 2GB RAM. The fireall is off, seleinux is disabled. mySQL is running fine. Tomcat independently runs fine. To rule out DB permission issues, root access was also tested but same result.

Please suggest a direction and I'll try to fix mysqlf first.

Sincerely,

Inderjeet

answered Mar 18, 2015 by swexpert (280 points)
0 votes

Hello,

Thank you for approaching us.

Can you please send us the log files from tomcat/logs directory?
This will help us trace the issue quickly and provide you with the 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 Mar 19, 2015 by Jaclyn (18,310 points)
0 votes
Hello,

Thank you for your assistance. The files have been sent via email.

Please let me know if any other assistance is required.

Buy the way, my objective is to make it run and fix the issue for everyone, not just me.

Sincerely,

Inderjeet
answered Mar 19, 2015 by swexpert (280 points)
0 votes

Hello,

Thank you for sending the details.

We have received the logs sent by you and we are in the process of fixing the issue currently.
We will get back to you once the issues are fixed.

Meanwhile, if there are any other concerns, please feel free to contact us. We are happy to help you.

Thanks,

Jaclyn

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

 

answered Mar 20, 2015 by Jaclyn (18,310 points)
0 votes
Hello,

Is there any update or ETA on this issue?

Thanks,

Inderjeet
answered Apr 3, 2015 by swexpert (280 points)
...