Re: [ACFUG Discuss] ColdFusion and MySQL
There are many suites you can use (Foundstone Enterprise, Nessus, etc.) and manual methods too. But unless your host agrees to it and you want to pay for it, you're left with whatever info they can give you about penetration testing they have had done in the past. -dhs -- Dean H. Saxe d...@fullfrontalnerdity.com "A true conservationist is a person who knows that the world is not given by his fathers, but borrowed from his children." -- John James Audubon On Jul 10, 2009, at 4:35 PM, Clarke Bishop wrote: Sorry to ask a dumb question, but how, exactly would you "Test the system." Do you mean use some set of methods to try and break in, or is there some sort of standard test suite? Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Dean H. Saxe Sent: Friday, July 10, 2009 2:40 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL If you have security concerns, there is only one way to figure out if they are valid. Test the system. With permission, of course. Dean H. Saxe d...@fullfrontalnerdity.com "A true conservationist is a person who knows that the world is not given by his fathers, but borrowed from his children." -- John James Audubon On Jul 10, 2009, at 2:30 PM, Clarke Bishop wrote: I looked, but couldn't find the message you mentioned. Please resend it. I'm about to conclude that I just need to switch hosts due to security concerns, so that may fix the problem, too. Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Cameron Childress Sent: Friday, July 10, 2009 2:10 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Clarke- Did you see the message I forwarded to the list a few days ago regarding compression in the driver? Also - I'm not sure what the load profile of this website is, but the "performance hit" from turning maintain connections off is not usually visible till you are under relatively high load. When you turned it off, did you see a performance degrade? If not, it may be an easier (and less expensive) fix than changing DB platforms. -Cameron - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] ColdFusion and MySQL
Sorry to ask a dumb question, but how, exactly would you "Test the system." Do you mean use some set of methods to try and break in, or is there some sort of standard test suite? Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Dean H. Saxe Sent: Friday, July 10, 2009 2:40 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL If you have security concerns, there is only one way to figure out if they are valid. Test the system. With permission, of course. Dean H. Saxe d...@fullfrontalnerdity.com "A true conservationist is a person who knows that the world is not given by his fathers, but borrowed from his children." -- John James Audubon On Jul 10, 2009, at 2:30 PM, Clarke Bishop wrote: > I looked, but couldn't find the message you mentioned. Please resend > it. > > I'm about to conclude that I just need to switch hosts due to security > concerns, so that may fix the problem, too. > > Clarke > > -Original Message- > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Cameron > Childress > Sent: Friday, July 10, 2009 2:10 PM > To: discussion@acfug.org > Subject: Re: [ACFUG Discuss] ColdFusion and MySQL > > Clarke- Did you see the message I forwarded to the list a few days > ago regarding compression in the driver? > > Also - I'm not sure what the load profile of this website is, but the > "performance hit" from turning maintain connections off is not usually > visible till you are under relatively high load. When you turned it > off, did you see a performance degrade? If not, it may be an easier > (and less expensive) fix than changing DB platforms. > > -Cameron > - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] ColdFusion and MySQL
If you have security concerns, there is only one way to figure out if they are valid. Test the system. With permission, of course. Dean H. Saxe d...@fullfrontalnerdity.com "A true conservationist is a person who knows that the world is not given by his fathers, but borrowed from his children." -- John James Audubon On Jul 10, 2009, at 2:30 PM, Clarke Bishop wrote: I looked, but couldn't find the message you mentioned. Please resend it. I'm about to conclude that I just need to switch hosts due to security concerns, so that may fix the problem, too. Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Cameron Childress Sent: Friday, July 10, 2009 2:10 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Clarke- Did you see the message I forwarded to the list a few days ago regarding compression in the driver? Also - I'm not sure what the load profile of this website is, but the "performance hit" from turning maintain connections off is not usually visible till you are under relatively high load. When you turned it off, did you see a performance degrade? If not, it may be an easier (and less expensive) fix than changing DB platforms. -Cameron On Fri, Jul 10, 2009 at 1:59 PM, Clarke Bishop> wrote: Sorry if I wasn’t clear about something. As you said, “Maintain connections across client requests” is the default. It’s when you turn it off that the mySQL problem goes away with some server/driver configurations. If maintain connections is off, then CF has to recreate the connection for each query which obviously hurts performance and server load. However, with maintain connections off, the mySQL problem goes away. I think that what’s happening is that ColdFusion somehow loses track of the database connection, but then still tries to use the connection. And, the error I’ve seen is the result. If CF always has to recreate the connection, it can’t lose track so everything is fine. Clarke From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd Sent: Friday, July 10, 2009 1:42 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL That’s very odd considering I have several Windows 2003 servers all running CF8. These servers host about 200 different websites using CF8 that ALL connect to a separate dedicated MySQL server. Some of the sites connect to a MySQL 4.x service and others MySQL 5.x. All of these sites connect via the provided MySQL 4/5 driver in the CF Admin. The “Maintain connections across client requests” is apparently a default option as this is set on all of my datasources. Perhaps this is why I never see this problem. So, as I have many sites accessing a single database server all with this option configured… where is the problem with this? I don’t see any real “performance impact” because of this option being checked. ??? Wes Byrd CIO, Dynapp Inc. 678.528.2952 ext 601 From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Friday, July 10, 2009 10:20 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I still haven't been able to get the host to resolve this problem, and I've decided to just abandon MySQL for SQL Server. The database is simple and I can make the change quickly. To wrap this up, based on what I've learned and what my web research shows: · The problem exists only for MySQL with ColdFusion running under Windows · If you turn off Maintain Connections across client connections in the advanced datasource settings, the problem goes away. Obviously this would impact server performance and isn’t a fix. · So, it is sort of a communications problem. It seems that between ColdFusion and the MySQL driver the reference to the database connection gets confused. ColdFusion expects the connection to the database, but doesn’t find it and throws the error. · Maybe there’s a set of ColdFusion/MySQL/Server configuration settings that will fix this. Or, maybe it’s a ColdFusion or MySQL bug. I just don’t know. Anyway, thanks for all the great ideas. At least I learned some new tricks! Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 5:13 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I got another piece of data from using the cfdbinfo tag. Sometimes, it throws this error: So, I think you're right Wes. It is some kind of communication problem. If this new data gives anyone any ideas on where to go next, please let me know. Thanks again for all the help! Clarke -
RE: [ACFUG Discuss] ColdFusion and MySQL
I looked, but couldn't find the message you mentioned. Please resend it. I'm about to conclude that I just need to switch hosts due to security concerns, so that may fix the problem, too. Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Cameron Childress Sent: Friday, July 10, 2009 2:10 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Clarke- Did you see the message I forwarded to the list a few days ago regarding compression in the driver? Also - I'm not sure what the load profile of this website is, but the "performance hit" from turning maintain connections off is not usually visible till you are under relatively high load. When you turned it off, did you see a performance degrade? If not, it may be an easier (and less expensive) fix than changing DB platforms. -Cameron On Fri, Jul 10, 2009 at 1:59 PM, Clarke Bishop wrote: > Sorry if I wasnt clear about something. As you said, Maintain connections > across client requests is the default. Its when you turn it off that the > mySQL problem goes away with some server/driver configurations. If maintain > connections is off, then CF has to recreate the connection for each query > which obviously hurts performance and server load. > > > > However, with maintain connections off, the mySQL problem goes away. I think > that whats happening is that ColdFusion somehow loses track of the database > connection, but then still tries to use the connection. And, the error Ive > seen is the result. If CF always has to recreate the connection, it cant > lose track so everything is fine. > > > > Clarke > > > > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd > Sent: Friday, July 10, 2009 1:42 PM > To: discussion@acfug.org > Subject: RE: [ACFUG Discuss] ColdFusion and MySQL > > > > Thats very odd considering I have several Windows 2003 servers all running > CF8. These servers host about 200 different websites using CF8 that ALL > connect to a separate dedicated MySQL server. Some of the sites connect to > a MySQL 4.x service and others MySQL 5.x. All of these sites connect via > the provided MySQL 4/5 driver in the CF Admin. > > > > The Maintain connections across client requests is apparently a default > option as this is set on all of my datasources. Perhaps this is why I never > see this problem. So, as I have many sites accessing a single database > server all with this option configured where is the problem with this? I > dont see any real performance impact because of this option being > checked. ??? > > > > Wes Byrd > CIO, Dynapp Inc. 678.528.2952 ext 601 > > > > ____________ > > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop > Sent: Friday, July 10, 2009 10:20 AM > To: discussion@acfug.org > Subject: RE: [ACFUG Discuss] ColdFusion and MySQL > > > > I still haven't been able to get the host to resolve this problem, and I've > decided to just abandon MySQL for SQL Server. The database is simple and I > can make the change quickly. > > > > To wrap this up, based on what I've learned and what my web research shows: > > > > · The problem exists only for MySQL with ColdFusion running under > Windows > > · If you turn off Maintain Connections across client connections in > the advanced datasource settings, the problem goes away. Obviously this > would impact server performance and isnt a fix. > > · So, it is sort of a communications problem. It seems that between > ColdFusion and the MySQL driver the reference to the database connection > gets confused. ColdFusion expects the connection to the database, but > doesnt find it and throws the error. > > · Maybe theres a set of ColdFusion/MySQL/Server configuration > settings that will fix this. Or, maybe its a ColdFusion or MySQL bug. I > just dont know. > > > > Anyway, thanks for all the great ideas. At least I learned some new tricks! > > > > Clarke > > > > -Original Message- > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop > Sent: Wednesday, July 08, 2009 5:13 PM > To: discussion@acfug.org > Subject: RE: [ACFUG Discuss] ColdFusion and MySQL > > > > I got another piece of data from using the cfdbinfo tag. Sometimes, it > > throws this error: > > > > So, I think you're right Wes. It is some kind of communication problem. > > > > If this new data gives anyone any ideas on where to go next, please let me &
Re: [ACFUG Discuss] ColdFusion and MySQL
Clarke- Did you see the message I forwarded to the list a few days ago regarding compression in the driver? Also - I'm not sure what the load profile of this website is, but the "performance hit" from turning maintain connections off is not usually visible till you are under relatively high load. When you turned it off, did you see a performance degrade? If not, it may be an easier (and less expensive) fix than changing DB platforms. -Cameron On Fri, Jul 10, 2009 at 1:59 PM, Clarke Bishop wrote: > Sorry if I wasn’t clear about something. As you said, “Maintain connections > across client requests” is the default. It’s when you turn it off that the > mySQL problem goes away with some server/driver configurations. If maintain > connections is off, then CF has to recreate the connection for each query > which obviously hurts performance and server load. > > > > However, with maintain connections off, the mySQL problem goes away. I think > that what’s happening is that ColdFusion somehow loses track of the database > connection, but then still tries to use the connection. And, the error I’ve > seen is the result. If CF always has to recreate the connection, it can’t > lose track so everything is fine. > > > > Clarke > > > > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd > Sent: Friday, July 10, 2009 1:42 PM > To: discussion@acfug.org > Subject: RE: [ACFUG Discuss] ColdFusion and MySQL > > > > That’s very odd considering I have several Windows 2003 servers all running > CF8. These servers host about 200 different websites using CF8 that ALL > connect to a separate dedicated MySQL server. Some of the sites connect to > a MySQL 4.x service and others MySQL 5.x. All of these sites connect via > the provided MySQL 4/5 driver in the CF Admin. > > > > The “Maintain connections across client requests” is apparently a default > option as this is set on all of my datasources. Perhaps this is why I never > see this problem. So, as I have many sites accessing a single database > server all with this option configured… where is the problem with this? I > don’t see any real “performance impact” because of this option being > checked. ??? > > > > Wes Byrd > CIO, Dynapp Inc. 678.528.2952 ext 601 > > > > ________ > > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop > Sent: Friday, July 10, 2009 10:20 AM > To: discussion@acfug.org > Subject: RE: [ACFUG Discuss] ColdFusion and MySQL > > > > I still haven't been able to get the host to resolve this problem, and I've > decided to just abandon MySQL for SQL Server. The database is simple and I > can make the change quickly. > > > > To wrap this up, based on what I've learned and what my web research shows: > > > > · The problem exists only for MySQL with ColdFusion running under > Windows > > · If you turn off Maintain Connections across client connections in > the advanced datasource settings, the problem goes away. Obviously this > would impact server performance and isn’t a fix. > > · So, it is sort of a communications problem. It seems that between > ColdFusion and the MySQL driver the reference to the database connection > gets confused. ColdFusion expects the connection to the database, but > doesn’t find it and throws the error. > > · Maybe there’s a set of ColdFusion/MySQL/Server configuration > settings that will fix this. Or, maybe it’s a ColdFusion or MySQL bug. I > just don’t know. > > > > Anyway, thanks for all the great ideas. At least I learned some new tricks! > > > > Clarke > > > > -Original Message- > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop > Sent: Wednesday, July 08, 2009 5:13 PM > To: discussion@acfug.org > Subject: RE: [ACFUG Discuss] ColdFusion and MySQL > > > > I got another piece of data from using the cfdbinfo tag. Sometimes, it > > throws this error: > > > > So, I think you're right Wes. It is some kind of communication problem. > > > > If this new data gives anyone any ideas on where to go next, please let me > > know. > > > > Thanks again for all the help! > > > > Clarke > > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink > - > -
RE: [ACFUG Discuss] ColdFusion and MySQL
Sorry if I wasn't clear about something. As you said, "Maintain connections across client requests" is the default. It's when you turn it off that the mySQL problem goes away with some server/driver configurations. If maintain connections is off, then CF has to recreate the connection for each query which obviously hurts performance and server load. However, with maintain connections off, the mySQL problem goes away. I think that what's happening is that ColdFusion somehow loses track of the database connection, but then still tries to use the connection. And, the error I've seen is the result. If CF always has to recreate the connection, it can't lose track so everything is fine. Clarke From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd Sent: Friday, July 10, 2009 1:42 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL That's very odd considering I have several Windows 2003 servers all running CF8. These servers host about 200 different websites using CF8 that ALL connect to a separate dedicated MySQL server. Some of the sites connect to a MySQL 4.x service and others MySQL 5.x. All of these sites connect via the provided MySQL 4/5 driver in the CF Admin. The "Maintain connections across client requests" is apparently a default option as this is set on all of my datasources. Perhaps this is why I never see this problem. So, as I have many sites accessing a single database server all with this option configured. where is the problem with this? I don't see any real "performance impact" because of this option being checked. ??? Wes Byrd CIO, Dynapp Inc. 678.528.2952 ext 601 <http://www.dynapp.com/> _ From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Friday, July 10, 2009 10:20 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I still haven't been able to get the host to resolve this problem, and I've decided to just abandon MySQL for SQL Server. The database is simple and I can make the change quickly. To wrap this up, based on what I've learned and what my web research shows: . The problem exists only for MySQL with ColdFusion running under Windows . If you turn off Maintain Connections across client connections in the advanced datasource settings, the problem goes away. Obviously this would impact server performance and isn't a fix. . So, it is sort of a communications problem. It seems that between ColdFusion and the MySQL driver the reference to the database connection gets confused. ColdFusion expects the connection to the database, but doesn't find it and throws the error. . Maybe there's a set of ColdFusion/MySQL/Server configuration settings that will fix this. Or, maybe it's a ColdFusion or MySQL bug. I just don't know. Anyway, thanks for all the great ideas. At least I learned some new tricks! Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 5:13 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I got another piece of data from using the cfdbinfo tag. Sometimes, it throws this error: So, I think you're right Wes. It is some kind of communication problem. If this new data gives anyone any ideas on where to go next, please let me know. Thanks again for all the help! Clarke - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - <>
RE: [ACFUG Discuss] ColdFusion and MySQL
That's very odd considering I have several Windows 2003 servers all running CF8. These servers host about 200 different websites using CF8 that ALL connect to a separate dedicated MySQL server. Some of the sites connect to a MySQL 4.x service and others MySQL 5.x. All of these sites connect via the provided MySQL 4/5 driver in the CF Admin. The "Maintain connections across client requests" is apparently a default option as this is set on all of my datasources. Perhaps this is why I never see this problem. So, as I have many sites accessing a single database server all with this option configured... where is the problem with this? I don't see any real "performance impact" because of this option being checked. ??? Wes Byrd CIO, Dynapp Inc. 678.528.2952 ext 601 <http://www.dynapp.com/> From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Friday, July 10, 2009 10:20 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I still haven't been able to get the host to resolve this problem, and I've decided to just abandon MySQL for SQL Server. The database is simple and I can make the change quickly. To wrap this up, based on what I've learned and what my web research shows: * The problem exists only for MySQL with ColdFusion running under Windows * If you turn off Maintain Connections across client connections in the advanced datasource settings, the problem goes away. Obviously this would impact server performance and isn't a fix. * So, it is sort of a communications problem. It seems that between ColdFusion and the MySQL driver the reference to the database connection gets confused. ColdFusion expects the connection to the database, but doesn't find it and throws the error. * Maybe there's a set of ColdFusion/MySQL/Server configuration settings that will fix this. Or, maybe it's a ColdFusion or MySQL bug. I just don't know. Anyway, thanks for all the great ideas. At least I learned some new tricks! Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 5:13 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I got another piece of data from using the cfdbinfo tag. Sometimes, it throws this error: So, I think you're right Wes. It is some kind of communication problem. If this new data gives anyone any ideas on where to go next, please let me know. Thanks again for all the help! Clarke - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - <>
RE: [ACFUG Discuss] ColdFusion and MySQL
I still haven't been able to get the host to resolve this problem, and I've decided to just abandon MySQL for SQL Server. The database is simple and I can make the change quickly. To wrap this up, based on what I've learned and what my web research shows: . The problem exists only for MySQL with ColdFusion running under Windows . If you turn off Maintain Connections across client connections in the advanced datasource settings, the problem goes away. Obviously this would impact server performance and isn't a fix. . So, it is sort of a communications problem. It seems that between ColdFusion and the MySQL driver the reference to the database connection gets confused. ColdFusion expects the connection to the database, but doesn't find it and throws the error. . Maybe there's a set of ColdFusion/MySQL/Server configuration settings that will fix this. Or, maybe it's a ColdFusion or MySQL bug. I just don't know. Anyway, thanks for all the great ideas. At least I learned some new tricks! Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 5:13 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I got another piece of data from using the cfdbinfo tag. Sometimes, it throws this error: So, I think you're right Wes. It is some kind of communication problem. If this new data gives anyone any ideas on where to go next, please let me know. Thanks again for all the help! Clarke - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
Just posted it (on the meetup site), and was about to send it to the group here. Coming right up. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Teddy R. Payne Sent: Thursday, July 09, 2009 3:13 PM To: discussion@acfug.org Subject: Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL Charlie/Jasun, Excellent! And we look forward to the "special" announcement for the CF Meetup. Teddy - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
Charlie/Jasun, Excellent! And we look forward to the "special" announcement for the CF Meetup. Teddy
RE: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
Ah, ok. Thanks. :-) And to be clear, Teddy, I did in my reply say that you could have meant either form of bandwidth. Meant to clarify that in my note below. Juggling many things today, including a very cool announcement to come later today about a special CF Meetup event. Will share more after I post that later today. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Jasun Sent: Thursday, July 09, 2009 2:16 PM To: discussion@acfug.org Subject: Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL I wasn't laughing at what you said Charlie. To the contrary... I had to agree. What I found amusing had to do with the irony that some of us may not have the "bandwidth" to deal with links broken by a line wrap, but we will go to great lengths to point out that it IS "broken". And Teddy... no offense intended. You should always feel free to take my comments and throw them in a vat of acid... ;) - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
I wasn't laughing at what you said Charlie. To the contrary... I had to agree. What I found amusing had to do with the irony that some of us may not have the "bandwidth" to deal with links broken by a line wrap, but we will go to great lengths to point out that it IS "broken". And Teddy... no offense intended. You should always feel free to take my comments and throw them in a vat of acid... ;) On Thu, Jul 9, 2009 at 1:47 PM, Charlie Arehart wrote: > Just to be clear, I didn’t take it as patronizing. “We cool.” :-) > > > > But I stand by my statement (and confused by Jasun’s laughter. I was being > serious. But maybe that’s what he was laughing at.) > > > > /charlie > > > > *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Teddy R. > Payne > *Sent:* Wednesday, July 08, 2009 5:36 PM > *To:* discussion@acfug.org > *Subject:* Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and > MySQL > > > > All, > And allow me to apologize here as I did not hit the correct "reply" to send > a personal note to Charlie. I am by no means trying to be patronizing in > public here. I was attempting to resolve a difference in vernacular. > > Mia culpa Charlie, > Teddy > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink <http://www.fusionlink.com> > - >
RE: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
Just to be clear, I didn’t take it as patronizing. “We cool.” :-) But I stand by my statement (and confused by Jasun’s laughter. I was being serious. But maybe that’s what he was laughing at.) /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Teddy R. Payne Sent: Wednesday, July 08, 2009 5:36 PM To: discussion@acfug.org Subject: Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL All, And allow me to apologize here as I did not hit the correct "reply" to send a personal note to Charlie. I am by no means trying to be patronizing in public here. I was attempting to resolve a difference in vernacular. Mia culpa Charlie, Teddy - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
All, And allow me to apologize here as I did not hit the correct "reply" to send a personal note to Charlie. I am by no means trying to be patronizing in public here. I was attempting to resolve a difference in vernacular. Mia culpa Charlie, Teddy
Re: [ACFUG Discuss] ColdFusion and MySQL
You can access and easily see other accounts hosted on that server or
even gain control of the server itself. If the CF service is under
"Local System" account privileges which is the default, cfexecute will
have complete access to the server's file system. CFExecute should be
turned off and the CF services should be under a custom "restricted"
account system account.
John
ma...@fusionlink.com
Clarke Bishop wrote:
The host in question is Media3.net. And, unfortunately while investigating the
DB driver question, I discovered they DO have cfexecute turned on!
I recommended they consider Fusionlink, but they picked Media3 because they were listed as a partner on Adobe's website, and because they were turned on by cool control panels and the illusion of control.
I can guess why cfexecute is a bad idea, but why exactly -- What's a good
example of the risk?
Thanks,
Clarke
-Original Message-
From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of John Mason
Sent: Wednesday, July 08, 2009 2:54 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] ColdFusion and MySQL
And if they have cfexecute access turn on, get off that host :)
John
Teddy R. Payne wrote:
If you have CFEXECUTE ability, here is a curious post for that question:
http://blog.pengoworks.com/index.cfm/2008/1/15/Display-ColdFusion-JDBC-Drivers-on-Windows
Teddy R. Payne, ACCFD
Google Talk - teddyrpa...@gmail.com <mailto:teddyrpa...@gmail.com>
On Wed, Jul 8, 2009 at 2:48 PM, John Mason <mailto:ma...@fusionlink.com>> wrote:
You'll need to ask the host.
John
Clarke Bishop wrote:
Can I find that out directly, or do I have to ask the host?
Clarke
-Original Message-
From: ad...@acfug.org <mailto:ad...@acfug.org>
[mailto:ad...@acfug.org <mailto:ad...@acfug.org>] On Behalf Of
John Mason
Sent: Wednesday, July 08, 2009 2:31 PM
To: discussion@acfug.org <mailto:discussion@acfug.org>
Subject: Re: [ACFUG Discuss] ColdFusion and MySQL
Can you verify that the datasource is using the 4.x driver?
John
Clarke Bishop wrote:
Thanks Wes and everyone else who replied!
Here are the specifics on the configuration:
ColdFusion
Version: 8,0,1,195765 Enterprise
OS: Windows Vista Version 6.0 (That's kind of scary!)
MySQL
Version: 4.1.22
OS: Redhat Linux
Server_Engine: MyISAM
Thanks,
Clarke
-Original Message-
From: ad...@acfug.org <mailto:ad...@acfug.org>
[mailto:ad...@acfug.org <mailto:ad...@acfug.org>] On
Behalf Of Wes Byrd
Sent: Wednesday, July 08, 2009 11:02 AM
To: discussion@acfug.org <mailto:discussion@acfug.org>
Subject: RE: [ACFUG Discuss] ColdFusion and MySQL
I use CF8 with MySQL almost exclusively. I use both 4.x
and 5.x MySQL.
I have 200+ websites using this scenario and have never
seen this error.
There are ton of things to consider for trouble shooting
this. One is
your datasource. How is that setup? Another the code
itself. Yet
another is the database and table setup (innoDB, MyISAM,
etc...). Any
chance we can get these details to help assist further?
Wes
-Original Message-
From: ad...@acfug.org <mailto:ad...@acfug.org>
[mailto:ad...@acfug.org <mailto:ad...@acfug.org>] On
Behalf Of Clarke
Bishop
Sent: Wednesday, July 08, 2009 10:42 AM
To: discussion@acfug.org <mailto:discussion@acfug.org>
Subject: [ACFUG Discuss] ColdFusion and MySQL
I am troubleshooting an application that uses ColdFusion 8
and MySQL.
Intermittently, it throws the error below.
I've seen on the web where others have had a similar
problem. Have any
of
you seen this? Do you know of a fix?
Thanks,
Clarke
p.s. I originally posted this to the wrong list, so if
you're on both
lists,
please forgive me!
java.lang.NullPointerException at
com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) at
coldfusion.server.j2ee.sql.JRunStatement.setMaxRows(JRunStatement.java:2
14)
at
coldfusion.sql.Executive.executeQuery(Executive.java:1276) at
coldfusion.sql.Executive.executeQuery(Executive.java:1008) at
coldfusion.sql.Executive.executeQuery(Executive.java:939
Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
Charlie, Please take this in good humor. When I say "bandwidth", I am referring to the amount of time that I have to allocate to a given topic or item. Situation: "Teddy, can you get me that TP report by 4:00?" "Sorry Bill, I do not have the bandwidth today to fit that in, how about tomorrow morning at 9:00?" It is an expression and not a reference to the technical aspect of network bandwidth. Now Charlie, if you are kidding with me, considered me punked. Teddy
RE: [ACFUG Discuss] ColdFusion and MySQL
I got another piece of data from using the cfdbinfo tag. Sometimes, it throws this error: So, I think you're right Wes. It is some kind of communication problem. If this new data gives anyone any ideas on where to go next, please let me know. Thanks again for all the help! Clarke Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1963) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2375) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2874) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) at com.mysql.jdbc.Connection.execSQL(Connection.java:3243) at com.mysql.jdbc.Connection.execSQL(Connection.java:3172) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1197) at com.mysql.jdbc.DatabaseMetaData.getCatalogs(DatabaseMetaData.java:1915) at coldfusion.sql.DatabaseMetaDataUtil.getCatalogs(DatabaseMetaDataUtil.java:85 5) at coldfusion.sql.DatabaseMetaDataUtil.setSqlImpl(DatabaseMetaDataUtil.java:155 ) at coldfusion.tagext.sql.DBInfoTag.fetchDBMetaData(DBInfoTag.java:160) at coldfusion.tagext.sql.DBInfoTag.doEndTag(DBInfoTag.java:131) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2662) at cfversion2ecfm103399945.runPage(E:\web\engravedforever.com\WebTools\version. cfm:46) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletF ilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26 6) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago. -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd Sent: Wednesday, July 08, 2009 3:22 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I'm going to guess that the reported OS version is actually MS Server 2008 and not Vista... or at least I hope so! The application and the database are obviously on different machines... they could even be in different datacenters half way across the world for all we know. Do you know? There could be a network related problem between the two servers... it could happen. :-) Another thing to consider is the shared hosting scenario. There is just no telling what is going on with the hundreds of other sites using the two different servers. The MySQL server in question might be getting Flushed all the time while new users and databases are added. The service may be restarted as configuration changes happen. "Way back in my day" I had some CF sites hosted on a shared server. It was Linux and Apache. Every time the host would add a new site to the server, they would bounce Apache. Constantly all my sites were going up and down up and down. That was my breaking point to go with a dedicated server and host my customers where I had full control. Anyway... sorry for the tangent. The issue appears to
Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
omg... headache from laughing :) On Wed, Jul 8, 2009 at 4:55 PM, Charlie Arehart wrote: > Eh? I don’t understand, honestly. How does a broken URL affect bandwidth? > I’ll assume you don’t mean bytes but time. You mean it’s regard as an > offense if a URL breaks? But it’s not something people do intentionally. > It’s done by their mail clients. > > > > The solution is just to hit reply, so you can edit the email, and then hit > delete at the end of the line, to be able to proceed. If someone is offering > a helpful URL for a problem, it seems little odd to assert that “forcing > them to do all that” to get the value of the email is an > infringement/offense against their time. Since we know each other, I am > certainly fascinated to have the chance to learn of this perspective. It > totally surprises me, to be honest. > > > > /charlie > > > > *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Teddy R. > Payne > *Sent:* Wednesday, July 08, 2009 4:17 PM > *To:* discussion@acfug.org > *Subject:* Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and > MySQL > > > > Well, I hope that will help you in the future to get your URL(s) across to > those (like me) who may not have too much bandwidth for any given email. > > T > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform<http://www.acfug.org/?fa=login.edituserform> > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink <http://www.fusionlink.com/> > -
RE: [ACFUG Discuss] ColdFusion and MySQL
The host in question is Media3.net. And, unfortunately while investigating the DB driver question, I discovered they DO have cfexecute turned on! I recommended they consider Fusionlink, but they picked Media3 because they were listed as a partner on Adobe's website, and because they were turned on by cool control panels and the illusion of control. I can guess why cfexecute is a bad idea, but why exactly -- What's a good example of the risk? Thanks, Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of John Mason Sent: Wednesday, July 08, 2009 2:54 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL And if they have cfexecute access turn on, get off that host :) John Teddy R. Payne wrote: > If you have CFEXECUTE ability, here is a curious post for that question: > > http://blog.pengoworks.com/index.cfm/2008/1/15/Display-ColdFusion-JDBC-Drivers-on-Windows > > > Teddy R. Payne, ACCFD > Google Talk - teddyrpa...@gmail.com <mailto:teddyrpa...@gmail.com> > > > > On Wed, Jul 8, 2009 at 2:48 PM, John Mason <mailto:ma...@fusionlink.com>> wrote: > > You'll need to ask the host. > > John > > > > Clarke Bishop wrote: > > Can I find that out directly, or do I have to ask the host? > > Clarke > > -Original Message- > From: ad...@acfug.org <mailto:ad...@acfug.org> > [mailto:ad...@acfug.org <mailto:ad...@acfug.org>] On Behalf Of > John Mason > Sent: Wednesday, July 08, 2009 2:31 PM > To: discussion@acfug.org <mailto:discussion@acfug.org> > Subject: Re: [ACFUG Discuss] ColdFusion and MySQL > > Can you verify that the datasource is using the 4.x driver? > > John > > > Clarke Bishop wrote: > > > Thanks Wes and everyone else who replied! > > Here are the specifics on the configuration: > > ColdFusion > Version: 8,0,1,195765 Enterprise > OS: Windows Vista Version 6.0 (That's kind of scary!) > > MySQL > Version: 4.1.22 > OS: Redhat Linux > Server_Engine: MyISAM > > Thanks, > > Clarke > > -Original Message- > From: ad...@acfug.org <mailto:ad...@acfug.org> > [mailto:ad...@acfug.org <mailto:ad...@acfug.org>] On > Behalf Of Wes Byrd > Sent: Wednesday, July 08, 2009 11:02 AM > To: discussion@acfug.org <mailto:discussion@acfug.org> > Subject: RE: [ACFUG Discuss] ColdFusion and MySQL > > I use CF8 with MySQL almost exclusively. I use both 4.x > and 5.x MySQL. > I have 200+ websites using this scenario and have never > seen this error. > There are ton of things to consider for trouble shooting > this. One is > your datasource. How is that setup? Another the code > itself. Yet > another is the database and table setup (innoDB, MyISAM, > etc...). Any > chance we can get these details to help assist further? > > Wes > > > -Original Message- > From: ad...@acfug.org <mailto:ad...@acfug.org> > [mailto:ad...@acfug.org <mailto:ad...@acfug.org>] On > Behalf Of Clarke > Bishop > Sent: Wednesday, July 08, 2009 10:42 AM > To: discussion@acfug.org <mailto:discussion@acfug.org> > Subject: [ACFUG Discuss] ColdFusion and MySQL > > I am troubleshooting an application that uses ColdFusion 8 > and MySQL. > Intermittently, it throws the error below. > I've seen on the web where others have had a similar > problem. Have any > of > you seen this? Do you know of a fix? > > Thanks, > > Clarke > > p.s. I originally posted this to the wrong list, so if > you're on both > lists, > please forgive me! > > java.lang.NullPointerException at > com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) at > > coldfusion.server.j2ee.sql.JRunStatement.setMaxRows(JRunStatement.java:2 > 14) > at > coldfusion.sql.Executive.executeQuery(Executive.java:1276) at > coldfusion.sql.Executive.executeQuery(Executive.java:1008) at
RE: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
Eh? I don’t understand, honestly. How does a broken URL affect bandwidth? I’ll assume you don’t mean bytes but time. You mean it’s regard as an offense if a URL breaks? But it’s not something people do intentionally. It’s done by their mail clients. The solution is just to hit reply, so you can edit the email, and then hit delete at the end of the line, to be able to proceed. If someone is offering a helpful URL for a problem, it seems little odd to assert that “forcing them to do all that” to get the value of the email is an infringement/offense against their time. Since we know each other, I am certainly fascinated to have the chance to learn of this perspective. It totally surprises me, to be honest. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Teddy R. Payne Sent: Wednesday, July 08, 2009 4:17 PM To: discussion@acfug.org Subject: Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL Well, I hope that will help you in the future to get your URL(s) across to those (like me) who may not have too much bandwidth for any given email. T - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
Well, I hope that will help you in the future to get your URL(s) across to those (like me) who may not have too much bandwidth for any given email. T
broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
You know, I’ve always been a bit mystified whenever anyone makes note of that. :-) I realize you said it to be helpful, Teddy, and I do appreciate the concern. More often, it’s from someone complaining. But doesn’t it happen so often that people should just realize they need to join the two lines? :-) I will note that I did a blog entry some years ago on a feature that one might be able to use in such a case, by surrounding the URL in brackets (<>), which some clients would honor as meaning to keep the URL together. I didn’t find it always worked, though, so I stopped worrying about it (for the reasons above): http://tipicalcharlie.blog-city.com/avoid_url_break_in_email.htm Let’s test it here: <http://www.carehart.org/blog/client/index.cfm/2006/8/8/checking_jdbc_driver_version> And for any interested, I counted and see that this broke below at 76 chars. I looked in Outlook (my email client) and sure enough, it has a feature that sets that count (tools>options>mail format>message format>internet format>plain text options>automatically wrap text at). It’s set to 76. I would wonder, if I increased that, if it might cause some readers to get email that would have regular paragraphs run off the right of the screen. :-) /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Teddy R. Payne Sent: Wednesday, July 08, 2009 3:56 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Charlie, I think that your URL broke across two lines. http://www.carehart.org/blog/client/index.cfm/2006/8/8/checking_jdbc_driver_version The above link should work. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Wed, Jul 8, 2009 at 3:38 PM, Charlie Arehart wrote: And for those not on CF8, there are still other ways that don't require CFEXECUTE or direct access to the server. Here's a blog entry I did on 3 ways to find info on the version of DB drivers being used by CF, varying based on what level of access you have to the server: http://www.carehart.org/blog/client/index.cfm/2006/8/8/checking_jdbc_driver_ version They're focused on getting info on the built-in CF drivers, but they may help. /charlie - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] ColdFusion and MySQL
Charlie, I think that your URL broke across two lines. http://www.carehart.org/blog/client/index.cfm/2006/8/8/checking_jdbc_driver_version The above link should work. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Wed, Jul 8, 2009 at 3:38 PM, Charlie Arehart wrote: > And for those not on CF8, there are still other ways that don't require > CFEXECUTE or direct access to the server. Here's a blog entry I did on 3 > ways to find info on the version of DB drivers being used by CF, varying > based on what level of access you have to the server: > > > http://www.carehart.org/blog/client/index.cfm/2006/8/8/checking_jdbc_driver_ > version > > They're focused on getting info on the built-in CF drivers, but they may > help. > > /charlie > > > > -Original Message- > > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Doug Giles > > Sent: Wednesday, July 08, 2009 3:18 PM > > To: discussion@acfug.org > > Subject: Re: [ACFUG Discuss] ColdFusion and MySQL > > > > Since you're on CF8, you can try the CFDBINFO tag. For example, > > > > > > > > > > > > > > > > Clarke Bishop wrote: > > > Can I find that out directly, or do I have to ask the host? > > > > > >Clarke > > > > > > -----Original Message- > > > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of John > > Mason > > > Sent: Wednesday, July 08, 2009 2:31 PM > > > To: discussion@acfug.org > > > Subject: Re: [ACFUG Discuss] ColdFusion and MySQL > > > > > > Can you verify that the datasource is using the 4.x driver? > > > > > > John > > > > > > - > > To unsubscribe from this list, manage your profile @ > > http://www.acfug.org?fa=login.edituserform > > > > For more info, see http://www.acfug.org/mailinglists > > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > > List hosted by http://www.fusionlink.com > > - > > > > > > > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > - > > > >
RE: [ACFUG Discuss] ColdFusion and MySQL
And for those not on CF8, there are still other ways that don't require CFEXECUTE or direct access to the server. Here's a blog entry I did on 3 ways to find info on the version of DB drivers being used by CF, varying based on what level of access you have to the server: http://www.carehart.org/blog/client/index.cfm/2006/8/8/checking_jdbc_driver_ version They're focused on getting info on the built-in CF drivers, but they may help. /charlie > -Original Message- > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Doug Giles > Sent: Wednesday, July 08, 2009 3:18 PM > To: discussion@acfug.org > Subject: Re: [ACFUG Discuss] ColdFusion and MySQL > > Since you're on CF8, you can try the CFDBINFO tag. For example, > > > > > > > > Clarke Bishop wrote: > > Can I find that out directly, or do I have to ask the host? > > > >Clarke > > > > -Original Message- > > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of John > Mason > > Sent: Wednesday, July 08, 2009 2:31 PM > > To: discussion@acfug.org > > Subject: Re: [ACFUG Discuss] ColdFusion and MySQL > > > > Can you verify that the datasource is using the 4.x driver? > > > > John > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > - > > - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] ColdFusion and MySQL
Agreed. I sometimes forget about cfdbinfo... a very handy tool! From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Teddy R. Payne Sent: Wednesday, July 08, 2009 3:29 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Doug G. gets a gold star for the day for the CF approach to display the drivers. =) (not being patronizing here) - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] ColdFusion and MySQL
Doug G. gets a gold star for the day for the CF approach to display the drivers. =) (not being patronizing here)
RE: [ACFUG Discuss] ColdFusion and MySQL
I'm going to guess that the reported OS version is actually MS Server 2008 and not Vista... or at least I hope so! The application and the database are obviously on different machines... they could even be in different datacenters half way across the world for all we know. Do you know? There could be a network related problem between the two servers... it could happen. :-) Another thing to consider is the shared hosting scenario. There is just no telling what is going on with the hundreds of other sites using the two different servers. The MySQL server in question might be getting Flushed all the time while new users and databases are added. The service may be restarted as configuration changes happen. "Way back in my day" I had some CF sites hosted on a shared server. It was Linux and Apache. Every time the host would add a new site to the server, they would bounce Apache. Constantly all my sites were going up and down up and down. That was my breaking point to go with a dedicated server and host my customers where I had full control. Anyway... sorry for the tangent. The issue appears to be caused by loss of connection with the database. This is most likely not a CF problem... or a MySQL problem... or maybe not even a problem with the JDBC drivers. My guess is its network related or related to other users of the systems causing connectivity issues (via process restarting or memory flushing and such). ... but that is only a gross guess. Sorry I can't be more specific. Wes Byrd CIO, Dynapp Inc. 678.528.2952 ext 601 -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 2:21 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL Thanks Wes and everyone else who replied! Here are the specifics on the configuration: ColdFusion Version: 8,0,1,195765 Enterprise OS: Windows Vista Version 6.0 (That's kind of scary!) MySQL Version: 4.1.22 OS: Redhat Linux Server_Engine: MyISAM Thanks, Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd Sent: Wednesday, July 08, 2009 11:02 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I use CF8 with MySQL almost exclusively. I use both 4.x and 5.x MySQL. I have 200+ websites using this scenario and have never seen this error. There are ton of things to consider for trouble shooting this. One is your datasource. How is that setup? Another the code itself. Yet another is the database and table setup (innoDB, MyISAM, etc...). Any chance we can get these details to help assist further? Wes -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 10:42 AM To: discussion@acfug.org Subject: [ACFUG Discuss] ColdFusion and MySQL I am troubleshooting an application that uses ColdFusion 8 and MySQL. Intermittently, it throws the error below. I've seen on the web where others have had a similar problem. Have any of you seen this? Do you know of a fix? Thanks, Clarke p.s. I originally posted this to the wrong list, so if you're on both lists, please forgive me! java.lang.NullPointerException at com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) at coldfusion.server.j2ee.sql.JRunStatement.setMaxRows(JRunStatement.java:2 14) at coldfusion.sql.Executive.executeQuery(Executive.java:1276) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfdbTest32ecfm1104898290.runPage(E:\web\engravedforever.com\WebTools\dbT est3 .cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: 48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist ence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServl
Re: [ACFUG Discuss] ColdFusion and MySQL
Since you're on CF8, you can try the CFDBINFO tag. For example, Clarke Bishop wrote: Can I find that out directly, or do I have to ask the host? Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of John Mason Sent: Wednesday, July 08, 2009 2:31 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Can you verify that the datasource is using the 4.x driver? John - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] ColdFusion and MySQL
There is that.. =)
Re: [ACFUG Discuss] ColdFusion and MySQL
And if they have cfexecute access turn on, get off that host :) John Teddy R. Payne wrote: If you have CFEXECUTE ability, here is a curious post for that question: http://blog.pengoworks.com/index.cfm/2008/1/15/Display-ColdFusion-JDBC-Drivers-on-Windows Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com <mailto:teddyrpa...@gmail.com> On Wed, Jul 8, 2009 at 2:48 PM, John Mason <mailto:ma...@fusionlink.com>> wrote: You'll need to ask the host. John Clarke Bishop wrote: Can I find that out directly, or do I have to ask the host? Clarke -Original Message- From: ad...@acfug.org <mailto:ad...@acfug.org> [mailto:ad...@acfug.org <mailto:ad...@acfug.org>] On Behalf Of John Mason Sent: Wednesday, July 08, 2009 2:31 PM To: discussion@acfug.org <mailto:discussion@acfug.org> Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Can you verify that the datasource is using the 4.x driver? John Clarke Bishop wrote: Thanks Wes and everyone else who replied! Here are the specifics on the configuration: ColdFusion Version: 8,0,1,195765 Enterprise OS: Windows Vista Version 6.0 (That's kind of scary!) MySQL Version: 4.1.22 OS: Redhat Linux Server_Engine: MyISAM Thanks, Clarke -Original Message- From: ad...@acfug.org <mailto:ad...@acfug.org> [mailto:ad...@acfug.org <mailto:ad...@acfug.org>] On Behalf Of Wes Byrd Sent: Wednesday, July 08, 2009 11:02 AM To: discussion@acfug.org <mailto:discussion@acfug.org> Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I use CF8 with MySQL almost exclusively. I use both 4.x and 5.x MySQL. I have 200+ websites using this scenario and have never seen this error. There are ton of things to consider for trouble shooting this. One is your datasource. How is that setup? Another the code itself. Yet another is the database and table setup (innoDB, MyISAM, etc...). Any chance we can get these details to help assist further? Wes -Original Message- From: ad...@acfug.org <mailto:ad...@acfug.org> [mailto:ad...@acfug.org <mailto:ad...@acfug.org>] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 10:42 AM To: discussion@acfug.org <mailto:discussion@acfug.org> Subject: [ACFUG Discuss] ColdFusion and MySQL I am troubleshooting an application that uses ColdFusion 8 and MySQL. Intermittently, it throws the error below. I've seen on the web where others have had a similar problem. Have any of you seen this? Do you know of a fix? Thanks, Clarke p.s. I originally posted this to the wrong list, so if you're on both lists, please forgive me! java.lang.NullPointerException at com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) at coldfusion.server.j2ee.sql.JRunStatement.setMaxRows(JRunStatement.java:2 14) at coldfusion.sql.Executive.executeQuery(Executive.java:1276) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfdbTest32ecfm1104898290.runPage(E:\web\engravedforever.com <http://engravedforever.com>\WebTools\dbT est3 .cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: 48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at
Re: [ACFUG Discuss] ColdFusion and MySQL
If you have CFEXECUTE ability, here is a curious post for that question: http://blog.pengoworks.com/index.cfm/2008/1/15/Display-ColdFusion-JDBC-Drivers-on-Windows Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Wed, Jul 8, 2009 at 2:48 PM, John Mason wrote: > You'll need to ask the host. > > John > > > > Clarke Bishop wrote: > >> Can I find that out directly, or do I have to ask the host? >> >> Clarke >> >> -Original Message- >> From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of John Mason >> Sent: Wednesday, July 08, 2009 2:31 PM >> To: discussion@acfug.org >> Subject: Re: [ACFUG Discuss] ColdFusion and MySQL >> >> Can you verify that the datasource is using the 4.x driver? >> >> John >> >> >> Clarke Bishop wrote: >> >> >>> Thanks Wes and everyone else who replied! >>> >>> Here are the specifics on the configuration: >>> >>> ColdFusion >>> Version: 8,0,1,195765 Enterprise >>> OS: Windows Vista Version 6.0 (That's kind of scary!) >>> >>> MySQL >>> Version: 4.1.22 >>> OS: Redhat Linux >>> Server_Engine: MyISAM >>> >>> Thanks, >>> >>> Clarke >>> >>> -Original Message- >>> From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd >>> Sent: Wednesday, July 08, 2009 11:02 AM >>> To: discussion@acfug.org >>> Subject: RE: [ACFUG Discuss] ColdFusion and MySQL >>> >>> I use CF8 with MySQL almost exclusively. I use both 4.x and 5.x MySQL. >>> I have 200+ websites using this scenario and have never seen this error. >>> There are ton of things to consider for trouble shooting this. One is >>> your datasource. How is that setup? Another the code itself. Yet >>> another is the database and table setup (innoDB, MyISAM, etc...). Any >>> chance we can get these details to help assist further? >>> >>> Wes >>> >>> >>> -Original Message- >>> From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke >>> Bishop >>> Sent: Wednesday, July 08, 2009 10:42 AM >>> To: discussion@acfug.org >>> Subject: [ACFUG Discuss] ColdFusion and MySQL >>> >>> I am troubleshooting an application that uses ColdFusion 8 and MySQL. >>> Intermittently, it throws the error below. >>> I've seen on the web where others have had a similar problem. Have any >>> of >>> you seen this? Do you know of a fix? >>> >>> Thanks, >>> >>> Clarke >>> >>> p.s. I originally posted this to the wrong list, so if you're on both >>> lists, >>> please forgive me! >>> >>> java.lang.NullPointerException at >>> com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) at >>> coldfusion.server.j2ee.sql.JRunStatement.setMaxRows(JRunStatement.java:2 >>> 14) >>> at coldfusion.sql.Executive.executeQuery(Executive.java:1276) at >>> coldfusion.sql.Executive.executeQuery(Executive.java:1008) at >>> coldfusion.sql.Executive.executeQuery(Executive.java:939) at >>> coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at >>> coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at >>> coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at >>> cfdbTest32ecfm1104898290.runPage(E:\web\engravedforever.com\WebTools\dbT >>> est3 >>> .cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at >>> coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at >>> coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at >>> coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) >>> at >>> coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: >>> 48) >>> at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) >>> at >>> coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at >>> coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at >>> coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) >>> at >>> coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist >>> ence >>> Filter.java:28) at >>> coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at >>> coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at >>> coldfusion.filter.GlobalsFilter.invoke(Glob
Re: [ACFUG Discuss] ColdFusion and MySQL
You'll need to ask the host. John Clarke Bishop wrote: Can I find that out directly, or do I have to ask the host? Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of John Mason Sent: Wednesday, July 08, 2009 2:31 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Can you verify that the datasource is using the 4.x driver? John Clarke Bishop wrote: Thanks Wes and everyone else who replied! Here are the specifics on the configuration: ColdFusion Version: 8,0,1,195765 Enterprise OS: Windows Vista Version 6.0 (That's kind of scary!) MySQL Version: 4.1.22 OS: Redhat Linux Server_Engine: MyISAM Thanks, Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd Sent: Wednesday, July 08, 2009 11:02 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I use CF8 with MySQL almost exclusively. I use both 4.x and 5.x MySQL. I have 200+ websites using this scenario and have never seen this error. There are ton of things to consider for trouble shooting this. One is your datasource. How is that setup? Another the code itself. Yet another is the database and table setup (innoDB, MyISAM, etc...). Any chance we can get these details to help assist further? Wes -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 10:42 AM To: discussion@acfug.org Subject: [ACFUG Discuss] ColdFusion and MySQL I am troubleshooting an application that uses ColdFusion 8 and MySQL. Intermittently, it throws the error below. I've seen on the web where others have had a similar problem. Have any of you seen this? Do you know of a fix? Thanks, Clarke p.s. I originally posted this to the wrong list, so if you're on both lists, please forgive me! java.lang.NullPointerException at com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) at coldfusion.server.j2ee.sql.JRunStatement.setMaxRows(JRunStatement.java:2 14) at coldfusion.sql.Executive.executeQuery(Executive.java:1276) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfdbTest32ecfm1104898290.runPage(E:\web\engravedforever.com\WebTools\dbT est3 .cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: 48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist ence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServ letF ilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286 ) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543 ) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java: 203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j ava: 320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java :428 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav a:26 6) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http:
RE: [ACFUG Discuss] ColdFusion and MySQL
Can I find that out directly, or do I have to ask the host? Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of John Mason Sent: Wednesday, July 08, 2009 2:31 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Can you verify that the datasource is using the 4.x driver? John Clarke Bishop wrote: > Thanks Wes and everyone else who replied! > > Here are the specifics on the configuration: > > ColdFusion > Version: 8,0,1,195765 Enterprise > OS: Windows Vista Version 6.0 (That's kind of scary!) > > MySQL > Version: 4.1.22 > OS: Redhat Linux > Server_Engine: MyISAM > > Thanks, > >Clarke > > -Original Message- > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd > Sent: Wednesday, July 08, 2009 11:02 AM > To: discussion@acfug.org > Subject: RE: [ACFUG Discuss] ColdFusion and MySQL > > I use CF8 with MySQL almost exclusively. I use both 4.x and 5.x MySQL. > I have 200+ websites using this scenario and have never seen this error. > There are ton of things to consider for trouble shooting this. One is > your datasource. How is that setup? Another the code itself. Yet > another is the database and table setup (innoDB, MyISAM, etc...). Any > chance we can get these details to help assist further? > > Wes > > > > -Original Message- > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke > Bishop > Sent: Wednesday, July 08, 2009 10:42 AM > To: discussion@acfug.org > Subject: [ACFUG Discuss] ColdFusion and MySQL > > I am troubleshooting an application that uses ColdFusion 8 and MySQL. > Intermittently, it throws the error below. > > I've seen on the web where others have had a similar problem. Have any > of > you seen this? Do you know of a fix? > > Thanks, > >Clarke > > p.s. I originally posted this to the wrong list, so if you're on both > lists, > please forgive me! > > java.lang.NullPointerException at > com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) at > coldfusion.server.j2ee.sql.JRunStatement.setMaxRows(JRunStatement.java:2 > 14) > at coldfusion.sql.Executive.executeQuery(Executive.java:1276) at > coldfusion.sql.Executive.executeQuery(Executive.java:1008) at > coldfusion.sql.Executive.executeQuery(Executive.java:939) at > coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at > coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at > coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at > cfdbTest32ecfm1104898290.runPage(E:\web\engravedforever.com\WebTools\dbT > est3 > .cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at > coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at > coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at > coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) > at > coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: > 48) > at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) > at > coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at > coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at > coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) > at > coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist > ence > Filter.java:28) at > coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at > coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at > coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at > coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at > coldfusion.CfmServlet.service(CfmServlet.java:175) at > coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) > at > jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at > coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServ > letF > ilter.java:42) at > coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) > at > jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at > jrun.servlet.FilterChain.service(FilterChain.java:101) at > jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at > jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at > jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286 > ) at > jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543 > ) at > jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java: > 203) > at > jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j > ava: > 320) at > jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(
Re: [ACFUG Discuss] ColdFusion and MySQL
Can you verify that the datasource is using the 4.x driver? John Clarke Bishop wrote: Thanks Wes and everyone else who replied! Here are the specifics on the configuration: ColdFusion Version: 8,0,1,195765 Enterprise OS: Windows Vista Version 6.0 (That's kind of scary!) MySQL Version: 4.1.22 OS: Redhat Linux Server_Engine: MyISAM Thanks, Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd Sent: Wednesday, July 08, 2009 11:02 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I use CF8 with MySQL almost exclusively. I use both 4.x and 5.x MySQL. I have 200+ websites using this scenario and have never seen this error. There are ton of things to consider for trouble shooting this. One is your datasource. How is that setup? Another the code itself. Yet another is the database and table setup (innoDB, MyISAM, etc...). Any chance we can get these details to help assist further? Wes -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 10:42 AM To: discussion@acfug.org Subject: [ACFUG Discuss] ColdFusion and MySQL I am troubleshooting an application that uses ColdFusion 8 and MySQL. Intermittently, it throws the error below. I've seen on the web where others have had a similar problem. Have any of you seen this? Do you know of a fix? Thanks, Clarke p.s. I originally posted this to the wrong list, so if you're on both lists, please forgive me! java.lang.NullPointerException at com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) at coldfusion.server.j2ee.sql.JRunStatement.setMaxRows(JRunStatement.java:2 14) at coldfusion.sql.Executive.executeQuery(Executive.java:1276) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfdbTest32ecfm1104898290.runPage(E:\web\engravedforever.com\WebTools\dbT est3 .cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: 48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist ence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServ letF ilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286 ) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543 ) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java: 203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j ava: 320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java :428 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav a:26 6) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.o
RE: [ACFUG Discuss] ColdFusion and MySQL
Thanks Wes and everyone else who replied! Here are the specifics on the configuration: ColdFusion Version: 8,0,1,195765 Enterprise OS: Windows Vista Version 6.0 (That's kind of scary!) MySQL Version: 4.1.22 OS: Redhat Linux Server_Engine: MyISAM Thanks, Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd Sent: Wednesday, July 08, 2009 11:02 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I use CF8 with MySQL almost exclusively. I use both 4.x and 5.x MySQL. I have 200+ websites using this scenario and have never seen this error. There are ton of things to consider for trouble shooting this. One is your datasource. How is that setup? Another the code itself. Yet another is the database and table setup (innoDB, MyISAM, etc...). Any chance we can get these details to help assist further? Wes -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 10:42 AM To: discussion@acfug.org Subject: [ACFUG Discuss] ColdFusion and MySQL I am troubleshooting an application that uses ColdFusion 8 and MySQL. Intermittently, it throws the error below. I've seen on the web where others have had a similar problem. Have any of you seen this? Do you know of a fix? Thanks, Clarke p.s. I originally posted this to the wrong list, so if you're on both lists, please forgive me! java.lang.NullPointerException at com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) at coldfusion.server.j2ee.sql.JRunStatement.setMaxRows(JRunStatement.java:2 14) at coldfusion.sql.Executive.executeQuery(Executive.java:1276) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfdbTest32ecfm1104898290.runPage(E:\web\engravedforever.com\WebTools\dbT est3 .cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: 48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist ence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServ letF ilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286 ) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543 ) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java: 203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j ava: 320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java :428 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav a:26 6) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www
RE: [ACFUG Discuss] ColdFusion and MySQL
I use CF8 with MySQL almost exclusively. I use both 4.x and 5.x MySQL. I have 200+ websites using this scenario and have never seen this error. There are ton of things to consider for trouble shooting this. One is your datasource. How is that setup? Another the code itself. Yet another is the database and table setup (innoDB, MyISAM, etc...). Any chance we can get these details to help assist further? Wes -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 10:42 AM To: discussion@acfug.org Subject: [ACFUG Discuss] ColdFusion and MySQL I am troubleshooting an application that uses ColdFusion 8 and MySQL. Intermittently, it throws the error below. I've seen on the web where others have had a similar problem. Have any of you seen this? Do you know of a fix? Thanks, Clarke p.s. I originally posted this to the wrong list, so if you're on both lists, please forgive me! java.lang.NullPointerException at com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) at coldfusion.server.j2ee.sql.JRunStatement.setMaxRows(JRunStatement.java:2 14) at coldfusion.sql.Executive.executeQuery(Executive.java:1276) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfdbTest32ecfm1104898290.runPage(E:\web\engravedforever.com\WebTools\dbT est3 .cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: 48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist ence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServ letF ilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286 ) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543 ) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java: 203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j ava: 320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java :428 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav a:26 6) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] ColdFusion and MySQL
Clarke, What version of MySQL are you using? I believe 5+ is InnoDB storage only. Teddy
