Database connection pooling issues

google-code-export / rubycas-server

Automatically exported from code.google.com/p/rubycas-server

GNU Lesser General Public License v2.1

1 stars 1 forks source link

Database connection pooling issues #101

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

What steps will reproduce the problem?
1. Running a web application after a wait of 3 days 
2. without logging out of RubyCAS server.
3.

What version of RubyCAS-Server are you using? How is it installed (rubygem,
manual install)? How are you running it (webrick, mongrel, passenger,
etc.)?

If relevant, please paste your RubyCAS-Server config.yml file here.

Where do I parameterize the Time to Live / session expiry  without actual 
logout ?

Original issue reported on code.google.com by nambia...@gmail.com on 21 Jun 2010 at 4:41

Attachments:

[New Text Document (2).txt](https://storage.googleapis.com/google-code-attachments/rubycas-server/issue-101/comment-0/New Text Document %282%29.txt)

GoogleCodeExporter commented 9 years ago

I got this again.  Probably it is due to bad handling of connection pooling of 
the mysql database -- Isn't it ?

Mr. Matt can probably throw some light please.

Original comment by nambia...@gmail.com on 24 Jun 2010 at 4:19

GoogleCodeExporter commented 9 years ago

I've had problems with database connection pooling for a while now. I thought I 
addressed this here: 
http://github.com/gunark/rubycas-server/commit/33cbb50726022e6aac87ddd1a187e05c1
697a144, but I wouldn't be too surprised if there were still issues.

I don't have a good answer for you right now, but I'll keep this issue open. 
I'll try to take a look at the connection pooling stuff again when I have some 
time.

Original comment by matt.zuk...@gmail.com on 24 Jun 2010 at 4:30

Changed title: Database connection pooling issues
Changed state: Accepted

GoogleCodeExporter commented 9 years ago

[deleted comment]

GoogleCodeExporter commented 9 years ago

It is understood that this is with respect to mysql database.

I used oracle instead and this issue didn't crop up again.

Probably this would help :-
https://wiki.jasig.org/display/CASUM/SSL+Troubleshooting+and+Reference+Guide

keytool -v -list -keystore $JAVA_HOME/jre/lib/security/cacerts

openssl x509 -in etc/pki/incommon-root-cert.pem -out tmp/incommon-root-cert.der 
-outform DER

keytool -import -keystore $JAVA_HOME/jre/lib/security/cacerts -file 
tmp/incommon-root-cert.der -alias incommon

Original comment by soorya.s...@gmail.com on 3 Aug 2010 at 2:37