RE: CFMX Linux JDBCPool Timeout
I can consider this issue closed, here is how I resolved it: I feel kind of stupid that I didn't try this earlier, but anyway, I installed cfmx on another machine with the same setup and it worked fine, so instead of just re-installing over what I had, like I had in the past, I completely removed the coldfusionmx directory, the CFIDE, and cfide directories on the problem machine. I then re-installed from scratch. It appears to have fixed the problem. I don't know what was causing the problem in the first place, but I am content with knowing that by reinstalling, I rid the corrupt file, bad config file, or whatever was causing the issue. So, we can consider this issue closed in my opinion. Thank you for everyone's help. Paul -Original Message- From: Paul Hassinger [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 12:29 PM To: CF-Talk Subject: RE: CFMX Linux JDBCPool Timeout Thanks Barney, Unfortunately, no, I don't have any tcpwrappers or firewall settings on the servers. I handle that all with a seperate firewall and the server exists in a demilitarized zone. The port is open, since I can access the connection periodically, but I will check settings over again. Glad to hear you got it working in Linux. I will have to see if I can do the same ;-) Paul -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 12:07 PM To: CF-Talk Subject: RE: CFMX Linux JDBCPool Timeout I haven't been following this thread, but I've been running CFMX (as well as CF4.5 and CF5) and MySQL on the same box and on different boxes, both with Windows and Linux and never had a problem with connecting to databases with any setup. Do you perhaps have a firewall or tcpwrappers disallowing access to port 3306 (a VERY good idea) and accidentally set to disallow access from the local machine as well? That'd keep your connections from working. If I were you, that's the kind of stuff that I'd start analyzing, rather than duplicating the setup, because there are a million instances of CF and MySQL playing nice, and duplicating the set up will very likely not duplicate all those nitty-gritty settings exactly, which would make the test invalid. HTH, barneyb -Original Message- From: Paul Hassinger [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 9:50 AM To: CF-Talk Subject: RE: CFMX Linux JDBCPool Timeout Just an update... I have contacted Macromedia, They claim that they have not heard of this problem from other users. They had me download a JDBC MySQL driver from mysql's site the same problem occured with that driver. I created the data source using a Windows development version of Cold Fusion MX on another machine pointing to the same database. It appeared to work perfectly and correctly with no timeout issues, which points to mysql working just fine. I will await to hear back from Macromedia, but in the meantime, my next task may be to replicate the Linux box and see if it occurs on another box with the same setup. Also, then I may be able to test across machines instead of loopback with Linux, which... maybe there is a problem accessing the database on the same machine as CFMX??? Who knows. I'm always up for more ideas, but I think replicating the environment might be a good clue for finding out if it is a fluke or a repetitive issue for my setup. -Paul Hassinger ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Linux JDBCPool Timeout
OK, I thought the issue was taken care of, but it reappeared. It re-appears whenever I enable Cold Fusion security and I disabled all servers and ports for the sandbox I was using servers/ports in the permissions. Upon adding a port of 3306 for localhost (the port to the mysql database connection), the problems resolved themselves. I think we found the culprit. At least we know the cause now. Paul Hassinger ipaul.com, Inc. -Original Message- From: Paul Hassinger [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:30 AM To: CF-Talk Subject: RE: CFMX Linux JDBCPool Timeout I can consider this issue closed, here is how I resolved it: I feel kind of stupid that I didn't try this earlier, but anyway, I installed cfmx on another machine with the same setup and it worked fine, so instead of just re-installing over what I had, like I had in the past, I completely removed the coldfusionmx directory, the CFIDE, and cfide directories on the problem machine. I then re-installed from scratch. It appears to have fixed the problem. I don't know what was causing the problem in the first place, but I am content with knowing that by reinstalling, I rid the corrupt file, bad config file, or whatever was causing the issue. So, we can consider this issue closed in my opinion. Thank you for everyone's help. Paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Linux JDBCPool Timeout
Just an update... I have contacted Macromedia, They claim that they have not heard of this problem from other users. They had me download a JDBC MySQL driver from mysql's site the same problem occured with that driver. I created the data source using a Windows development version of Cold Fusion MX on another machine pointing to the same database. It appeared to work perfectly and correctly with no timeout issues, which points to mysql working just fine. I will await to hear back from Macromedia, but in the meantime, my next task may be to replicate the Linux box and see if it occurs on another box with the same setup. Also, then I may be able to test across machines instead of loopback with Linux, which... maybe there is a problem accessing the database on the same machine as CFMX??? Who knows. I'm always up for more ideas, but I think replicating the environment might be a good clue for finding out if it is a fluke or a repetitive issue for my setup. -Paul Hassinger ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Linux JDBCPool Timeout
Thanks Barney, Unfortunately, no, I don't have any tcpwrappers or firewall settings on the servers. I handle that all with a seperate firewall and the server exists in a demilitarized zone. The port is open, since I can access the connection periodically, but I will check settings over again. Glad to hear you got it working in Linux. I will have to see if I can do the same ;-) Paul -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 12:07 PM To: CF-Talk Subject: RE: CFMX Linux JDBCPool Timeout I haven't been following this thread, but I've been running CFMX (as well as CF4.5 and CF5) and MySQL on the same box and on different boxes, both with Windows and Linux and never had a problem with connecting to databases with any setup. Do you perhaps have a firewall or tcpwrappers disallowing access to port 3306 (a VERY good idea) and accidentally set to disallow access from the local machine as well? That'd keep your connections from working. If I were you, that's the kind of stuff that I'd start analyzing, rather than duplicating the setup, because there are a million instances of CF and MySQL playing nice, and duplicating the set up will very likely not duplicate all those nitty-gritty settings exactly, which would make the test invalid. HTH, barneyb -Original Message- From: Paul Hassinger [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 9:50 AM To: CF-Talk Subject: RE: CFMX Linux JDBCPool Timeout Just an update... I have contacted Macromedia, They claim that they have not heard of this problem from other users. They had me download a JDBC MySQL driver from mysql's site the same problem occured with that driver. I created the data source using a Windows development version of Cold Fusion MX on another machine pointing to the same database. It appeared to work perfectly and correctly with no timeout issues, which points to mysql working just fine. I will await to hear back from Macromedia, but in the meantime, my next task may be to replicate the Linux box and see if it occurs on another box with the same setup. Also, then I may be able to test across machines instead of loopback with Linux, which... maybe there is a problem accessing the database on the same machine as CFMX??? Who knows. I'm always up for more ideas, but I think replicating the environment might be a good clue for finding out if it is a fluke or a repetitive issue for my setup. -Paul Hassinger ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Linux JDBCPool Timeout
It appears that while the datasource is working, netstat returns an ESTABLISHED state for a connection both to and from the mysql database to cold fusion (and vice-versa). Upon the datasource failing. I am returned only with a connection from mysql to CF in a state of TIME_WAIT for a little bit and then about 30 seconds later, no connections appear. So, it appears that the connection is closed after the timeout period, thereafter, the only way to re-connect is to re-add the datasource or re-verify the datasource. As for loggining in, I am using the same machine to log in with an X-Windows version of MyCC, using the exact same credentials with access to the same databases (same username and password), and the same mechanism would differ in that it is connecting through CF with JDBC instead of however MyCC connects directly. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 7:35 PM One thing that jumps to mind is using netstat to check whether after the timeout period the open connection is really closed. Also, I can login to mysql with simultaneous users using MyCC all while this is going on, so I don't believe it to be a max users issue. From the same machine as CF MX? Using the same credentials? And the same mechanism? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Linux JDBCPool Timeout
Thanks much... I think that is in order. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 11:31 AM To: CF-Talk Subject: Re: CFMX Linux JDBCPool Timeout Paul Hassinger wrote: It appears that while the datasource is working, netstat returns an ESTABLISHED state for a connection both to and from the mysql database to cold fusion (and vice-versa). Upon the datasource failing. I am returned only with a connection from mysql to CF in a state of TIME_WAIT for a little bit and then about 30 seconds later, no connections appear. So, it appears that the connection is closed after the timeout period, thereafter, the only way to re-connect is to re-add the datasource or re-verify the datasource. Yes, and the closing appears to be initiated from the CF MX side. As for loggining in, I am using the same machine to log in with an X-Windows version of MyCC, using the exact same credentials with access to the same databases (same username and password), and the same mechanism would differ in that it is connecting through CF with JDBC instead of however MyCC connects directly. MySQL only has one wire protocol, so from the database point of view they should be identical. Further pointers towards a problem on the CF MX side. You could still try the same tests without a firewall on the CF MX Server, but I think it is time to call Macromedia. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX Linux JDBCPool Timeout
Just wondering if anyone has had this problem. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Linux JDBCPool Timeout
Here is more detailed information surrounding the issue. Thanks == 03/10 13:49:14 error SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. at jrun.sql.pool.JDBCPool.createPhysicalConnection(Unknown Source) at jrun.sql.pool.JDBCPool.create(Unknown Source) at jrun.sql.pool.JDBCPool.checkOut(Unknown Source) at jrun.sql.pool.JDBCPool.requestConnection(Unknown Source) at jrun.sql.pool.JDBCManager.requestConnection(JDBCManager.java:125) at jrun.sql.JRunDataSource.getConnection(JRunDataSource.java:232) at jrun.sql.JRunDataSource.getConnection(JRunDataSource.java:172) at coldfusion.sql.DataSrcImpl.getCachedConnection(Unknown Source) at coldfusion.sql.DataSrcImpl.getConnection(Unknown Source) at coldfusion.sql.SqlImpl.execute(Unknown Source) at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source) at cfsitelist2ecfm452663090.runPage(/home/httpd/public_html/admin/sitelist.cfm: 13) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.BrowserDebugFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) 03/10 13:53:18 user FlashGatewayServlet: destroy 03/10 13:53:18 info 1 session(s) persisted 03/10 13:53:31 info JRunDataSource bound to JNDI under name ipaulsites 03/10 13:53:31 info JRun DataSourceService: Created JDBC XA Connection Pool named ipaulsites 03/10 13:53:31 info Bound a LinkRef from DefaultDataSource to the default DataSource ipaulsites 03/10 13:53:32 info JRun Web Server listening on *:8500 03/10 13:53:32 info JRun Proxy Server listening on *:51010 03/10 13:53:32 info Deploying enterprise application Macromedia ColdFusion MX from: file:/usr/local/coldfusionmx/ 03/10 13:53:32 info Deploying web application ColdFusion Web Application from: file:/usr/local/coldfusionmx/ 03/10 13:53:32 info Web Services in coldfusionmx#wwwroot: 03/10 13:53:32 info CFCProcessor 03/10 13:53:32 user JSPServlet: init 03/10 13:53:33 info Recovering 1 session(s) 03/10 13:53:33 info Deploying enterprise application Flash Remoting EAR from: file:/usr/local/coldfusionmx/runtime/servers/default/flashgateway.ear 03/10 13:53:33 info Deploying web application Flash Remoting from: file:/usr/local/coldfusionmx/runtime/servers/default/flashgateway.ear 03/10 13:53:33 user JSPServlet: init 03/10 13:53:33 user FlashGatewayServlet: init -Original Message- From: Paul Hassinger [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 1:26 PM To: CF-Talk Subject: CFMX Linux JDBCPool Timeout Hello, Running Cold Fusion MX Updater 1 with Apache 2.0.40-11, everything run fine... except: After 20 minutes (or the timeout specified in the CF Administrator for the datasource), the datasource will no longer work and I will receive the standard SQLException with JDBCPool... check username, password, etc. If I go to the Administrator and verify the datasource, it will work for another 20 minutes. Also, if I uncheck maintain connections it will not work at all. I am using the included MySQL driver. Just wondering if anyone else has run into this error before and might be able to help me out. I have not updated to Updater 2 because of the required Apache upgrade. Any help is appreciated. Thank you, Paul Hassinger, ipaul.com, Inc
RE: CFMX Linux JDBCPool Timeout
Hmmm, well I have now done a re-install of apache to 2.0.44 to accomodate CF Updater2. It appears I have the same issue. I have checked the mysql.err file for errors and have found none. I don't beleive this to be a database issue with MySQL since when I change the timeout period of the maintain connections portion of CF Administrator datasource setup, the error happens accordingly after the specified time has expired. Thus, it appears to be a CF issue that doesn't know how to hold the connection information or re-establish the connection. Although I agree, it looks like there is a problem creating the db connection, but it appears to be on the CFMX side of things. Also, I can login to mysql with simultaneous users using MyCC all while this is going on, so I don't believe it to be a max users issue. Paul -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. at jrun.sql.pool.JDBCPool.createPhysicalConnection(Unknown Source) Looks to me like a problem creating a new connection (the maximum number of connections to the datbase is reached?). Make sure you enable sufficient logging options on the MySQL side and watch what happens there. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX Linux JDBCPool Timeout
Hello, Running Cold Fusion MX Updater 1 with Apache 2.0.40-11, everything run fine... except: After 20 minutes (or the timeout specified in the CF Administrator for the datasource), the datasource will no longer work and I will receive the standard SQLException with JDBCPool... check username, password, etc. If I go to the Administrator and verify the datasource, it will work for another 20 minutes. Also, if I uncheck maintain connections it will not work at all. I am using the included MySQL driver. Just wondering if anyone else has run into this error before and might be able to help me out. I have not updated to Updater 2 because of the required Apache upgrade. Any help is appreciated. Thank you, Paul Hassinger, ipaul.com, Inc. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
