How to log all AMF requests + arguments

47 views
Skip to first unread message

Aubweb

unread,
Feb 3, 2010, 4:12:38 PM2/3/10
to FusionReactor
Hi,

I've build a Flex apllication and I am using remote objects to
communicate with coldfusion.
For now I am saving all the remote object calls we do on the
application in a database.

I am wondering if FR can do this job instead of doing it from flex and
generating a lot of traffic.
Because for each remote call I do, I do 2 more (on invoke and on
result or fault event).

I know that on the request log settings we can enable something that
generate XML and bin files for each amf request... But it takes a lot
of space on disk and it's less useful than having every records in a
DB on which I can do queries.

Is there an alternative ? Or a way to put all amf request descriptions
in a DB ?

By the way have you some tips to configure well FR (we are running one
big flex application on a cf9 server)
I guess that there no "best" config but I just need advices.

Thanks a lot!

Aubry

Darren Pywell

unread,
Feb 4, 2010, 12:36:07 PM2/4/10
to FusionReactor
Hi Aubry,

FusionReactor tracks the remote object method/function calls that are
made AMF to the request-*.log file if AMF Decoding is enabled (in
Request Settings). The request log contains the names of the methods
that are being called.

The request details screen for a Running Request or a Request in the
Request History shows the names of the methods that were called and
also the data sent with the request (but not the response - which can
be very large!).

If you turn on Request Capture for requests (as you mention) a binary
file is kept of the request AMF and the response AMF (in binary). To
use these files you would have to decode them from binary AMF into
some more readable format (like the one shown in the Request Details).

Could you give me a little more insight into what you need. Currently
I'm under the impression that you want to see which AMF requests are
made (with the AMF request data? could be big?). Are you looking to
profile these requests?

We are working on a new tool at the moment called FusionAnalytics that
captures all of this data to a database and allows you to perform deep
analysis on the data. FusionAnalytics can be expanded by the user
because all of the reports are written in a simple markup language
called APML that allows you to write your own reports. If you can let
me know what your requirements are for AMF requests I can track these
requirements, which may help us in building the right analytics for
AMF.

http://www.fusion-reactor.com/labs/analytics.cfm

Cheers,
Darren

Aubweb

unread,
Feb 5, 2010, 2:59:28 AM2/5/10
to FusionReactor
Hi Darren,

What I need is the same info that we find the in the AMF details
screen for a Running Request or in the
Request History.
Like :

serviceName
serviceMethodName
value (body -> arguments passed trough the function)

+ Info from the Main tab :
Execution Time
Started Time
Finished Time
and Status Code


Only those 7 things logged somewhere into a file or better in a DB.


Best Regards,
Aubry

charlie arehart

unread,
Feb 5, 2010, 11:24:28 AM2/5/10
to fusion...@googlegroups.com
So it sounds like you could get it, with Request Content Capture (which is
off by default, quite separate from the settings to enable request logging,
which are on by default).

As you note, Aubry, the Content capture feature (which generates XML files,
and the binary data for AMF) can generate large amounts of data: but
fortunately the feature lets you choose whether it should log either request
data or response data or both. At least you could get by with only the
request capturing.

It might be nice if you could limit it to only certain paths of requests, or
only those AMF requests. Unfortunately, while FR has such "restriction"
options for other things (CP, compression, and more), the Content capture
has always been a simple binary: on or off, for all requests.

But again by limiting it to just requests, and perhaps only for as long as
you want to capture data to do your analysis, it seems you may have what you
want now. What do you think?

/charlie

Darren Pywell

unread,
Feb 5, 2010, 12:41:58 PM2/5/10
to FusionReactor
Aubry,

I think that the request-*.log contains all the data that you need
except for the value (body arguments passed to the call) already.

The problem with the value body arguments is that AMF is a binary data
structure. I can contain objects that cannot be easily flattened. They
would have to be converted to XML, JSON or some other format to
serialize them. It also can be a LOT of data inside the AMF body.
Writing it to the log file is going to be the same as the data in the
Request Capture files. Even with the request values in XML or JSON it
would be hard to filter requests with queries on those values.

If you wanted to only request capture (fully binary of the request)
the AMF requests you could put a filter into FusionReactor to process
requests going into the gateways. You'd need to add a filter on the
FusionReactor->Restrictions and use a Regex with no host or param
check on: (.*)/flex2gateway/(.*)


How do you want to use the Request value body arguments? Just for
display or also for filters requests? To use them as a filter would
mean that we would have to create a closure for it.

Cheers,
Darren

On Feb 5, 5:24 pm, "charlie arehart" <charlie_li...@carehart.org>
wrote:

> > Aubry- Hide quoted text -
>
> - Show quoted text -

charlie arehart

unread,
Feb 6, 2010, 1:24:56 PM2/6/10
to fusion...@googlegroups.com
Hey Darren, good point about using an overall FR Restriction to only have it
monitor the flex2gateway requests.

Though to be clear for readers here, you mean to add that and then set the
FR settings page to "monitor requests that match the rules", so that only
those requests are monitored, right? (Since otherwise they would be
monitored normally and don't need to be added as a restriction,
specifically).

Readers, this would stop FR monitoring anything but the paths listed in the
FR Restrictions page (like this pattern he's suggesting), so again it's
something one would only want to do for a brief period.

But Darren I'll also ask a follow-up on the point I'd made (in the note to
which you replied): instead of this, have you guys considered adding
restrictions to the Content Capture feature, just like they exist for CP,
compression, content filtering, etc? Would be a nice way to help temper the
potential huge volume of content captured when that content capture is
enabled. At the same time, it would seem also to benefit from addition of a
set of file size limiters like those of the various logs and their
corresponding settings pages.

As for what is in the request logs, I thought readers may like to see a real
example. I'll show that in a follow up note.

/charlie


> -----Original Message-----
> From: fusion...@googlegroups.com
> [mailto:fusion...@googlegroups.com] On Behalf Of Darren Pywell
> Sent: Friday, February 05, 2010 12:42 PM
> To: FusionReactor
> Subject: Re: FusionReactor Group: Re: How to log all AMF requests +
> arguments
>

charlie arehart

unread,
Feb 6, 2010, 1:28:16 PM2/6/10
to fusion...@googlegroups.com
To follow up on Darren's point about what is in the FR request log for flash
remoting (Flex) requests, I though an example may help (not just Aubry but
others who maybe hadn't paid much attention to this feature.)

To clarify, one has to have the "AMF Decoding" option enabled on the Request
Settings page. (For reader not as familiar with these terms, AMF is the
encoding format for Flash Remoting calls, which are one way that Flex apps
can request CF pages from the server.)

Here's an example of some lines tracking requests from the CF Enterprise
Server Monitor, as it comes to the server looking for data (I've edited it
to show only "completed" lines and even then only a couple, not all that are
generated on even the initial opening of the Server Monitor):

2010-02-06 12:53:32.002 1265478812002 4 1265056276205 249 COMPLETED ""
jrpp-8 ::1 GET
http://localhost/CFIDE/administrator/monitor/launch-monitor.cfm 89 28 233024
66314 155520 89205 "" 200 0 "" 8430a46c672144a09d4a3a4433321d1f49f2 0
28285479 0 0 0 0 4636 89 89 1 89

2010-02-06 12:53:37.872 1265478817872 4 1265056276205 254 COMPLETED ""
jrpp-8 ::1 POST http://localhost/flex2gateway 40 28 233024 67396 155712
88315 "" 200 0
ColdFusion/CFIDE.adminapi.servermonitoring.getMonitorStatus,ColdFusion/CFIDE
.adminapi.servermonitoring.getRealtimeStats
8430a46c672144a09d4a3a4433321d1f49f2 0 28285479 0 0 0 0 1535 40 40 40 40

Note above, in the second line, which reflects the Flex call to CF, FR tells
you that two methods were called:

ColdFusion/CFIDE.adminapi.servermonitoring.getMonitorStatus
ColdFusion/CFIDE.adminapi.servermonitoring.getRealtimeStats

And as with all requests, FR tracks all the other key details (time of
execution, duration, status code, bytes returned, time to return them, etc.)
all on the one line of the request log. And if the called CFC did queries,
and JDBC wrapping and logging were enabled, you could find the details of
those queries in the JDBC log, by matching the request id (254, as shown in
the 6th column of the second line above) to the corresponding records in the
JDBC log for that request id.

So Aubry, you really can get quite a lot of information from FR about flex
request calling, whether in the logs (as above) or in the interface or using
content capture (such as to see incoming arguments). I suspect many readers
here weren't aware of much about FR's support for tracking Flex/Flash
Remoting/AMF requests, which is why I've elaborated on it a bit here.

Hope it's helpful.

/charlie


> -----Original Message-----
> From: fusion...@googlegroups.com
> [mailto:fusion...@googlegroups.com] On Behalf Of Darren Pywell
> Sent: Friday, February 05, 2010 12:42 PM
> To: FusionReactor

> Subject: Re: FusionReactor Group: Re: How to log all AMF requests +
> arguments
>

Darren Pywell

unread,
Feb 8, 2010, 5:24:50 PM2/8/10
to FusionReactor
Charlie,

Nice post! I think this would make a great DevNet article:

http://www.fusion-reactor.com/community/developers/autodev.cfm

Would you consider doing one for this?

Thanks,
Darren

On Feb 6, 7:28 pm, "charlie arehart" <charlie_li...@carehart.org>
wrote:


> To follow up on Darren's point about what is in the FR request log for flash
> remoting (Flex) requests, I though an example may help (not just Aubry but
> others who maybe hadn't paid much attention to this feature.)
>
> To clarify, one has to have the "AMF Decoding" option enabled on the Request
> Settings page. (For reader not as familiar with these terms, AMF is the
> encoding format for Flash Remoting calls, which are one way that Flex apps
> can request CF pages from the server.)
>
> Here's an example of some lines tracking requests from the CF Enterprise
> Server Monitor, as it comes to the server looking for data (I've edited it
> to show only "completed" lines and even then only a couple, not all that are
> generated on even the initial opening of the Server Monitor):
>
> 2010-02-06 12:53:32.002 1265478812002 4 1265056276205 249 COMPLETED ""

> jrpp-8 ::1 GEThttp://localhost/CFIDE/administrator/monitor/launch-monitor.cfm89 28 233024


> 66314 155520 89205 "" 200 0 "" 8430a46c672144a09d4a3a4433321d1f49f2 0
> 28285479 0 0 0 0 4636 89 89 1 89
>
> 2010-02-06 12:53:37.872 1265478817872 4 1265056276205 254 COMPLETED ""

> jrpp-8 ::1 POSThttp://localhost/flex2gateway40 28 233024 67396 155712
> 88315 "" 200 0
> ColdFusion/CFIDE.adminapi.servermonitoring.getMonitorStatus,ColdFusion/CFID­E

> > > /charlie- Hide quoted text -

Darren Pywell

unread,
Feb 8, 2010, 5:26:32 PM2/8/10
to FusionReactor
Aubry,

I'm capturing your inputs for FusionAnalytics.

Thanks for giving this feedback,
Darren


On Feb 8, 11:24 pm, Darren Pywell <dapyw...@googlemail.com> wrote:
> Charlie,
>
> Nice post! I think this would make a great DevNet article:
>
> http://www.fusion-reactor.com/community/developers/autodev.cfm
>
> Would you consider doing one for this?
>
> Thanks,
> Darren
>
> On Feb 6, 7:28 pm, "charlie arehart" <charlie_li...@carehart.org>
> wrote:
>
>
>
> > To follow up on Darren's point about what is in the FR request log for flash
> > remoting (Flex) requests, I though an example may help (not just Aubry but
> > others who maybe hadn't paid much attention to this feature.)
>
> > To clarify, one has to have the "AMF Decoding" option enabled on the Request
> > Settings page. (For reader not as familiar with these terms, AMF is the
> > encoding format for Flash Remoting calls, which are one way that Flex apps
> > can request CF pages from the server.)
>
> > Here's an example of some lines tracking requests from the CF Enterprise
> > Server Monitor, as it comes to the server looking for data (I've edited it
> > to show only "completed" lines and even then only a couple, not all that are
> > generated on even the initial opening of the Server Monitor):
>
> > 2010-02-06 12:53:32.002 1265478812002 4 1265056276205 249 COMPLETED ""

> > jrpp-8 ::1 GEThttp://localhost/CFIDE/administrator/monitor/launch-monitor.cfm8928 233024


> > 66314 155520 89205 "" 200 0 "" 8430a46c672144a09d4a3a4433321d1f49f2 0
> > 28285479 0 0 0 0 4636 89 89 1 89
>
> > 2010-02-06 12:53:37.872 1265478817872 4 1265056276205 254 COMPLETED ""

> > jrpp-8 ::1 POSThttp://localhost/flex2gateway4028 233024 67396 155712

> > - Show quoted text -- Hide quoted text -

charlie arehart

unread,
Feb 8, 2010, 5:37:06 PM2/8/10
to fusion...@googlegroups.com
Sure, Darren, would be happy to do it. Feel free to have whoever organizes
it to contact me. Thanks.

/charlie


> -----Original Message-----
> From: fusion...@googlegroups.com
> [mailto:fusion...@googlegroups.com] On Behalf Of Darren Pywell
> Sent: Monday, February 08, 2010 5:25 PM
> To: FusionReactor
> Subject: Re: FusionReactor Group: Re: How to log all AMF requests +
> arguments
>

> --
> You received this message because you are subscribed to the Google
> Groups "FusionReactor" group.
> To post to this group, send email to fusion...@googlegroups.com.
> To unsubscribe from this group, send email to
> fusionreacto...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/fusionreactor?hl=en.


Snake

unread,
Feb 11, 2010, 6:08:33 AM2/11/10
to fusion...@googlegroups.com
I wrapped a MySQL DSN last week and it has been working fine, but today it
mysteriously stopped working with the following error.

Verification ERROR: Application
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to
establish connection

A regular DSN to the exact same database works fine, only the JDBC wrapper
is failing, any idea what could be causing this ?

--
Russ


Darren Pywell

unread,
Feb 11, 2010, 10:31:51 AM2/11/10
to FusionReactor
Russ,

Maybe try adding:

&autoReconnect=true

and/or

&autoReconnectForPools=true

It could be that the unwrapped driver is adding this behind the scenes
without you knowing.

http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html

Cheers,
Darren

Russ Michaels

unread,
Feb 11, 2010, 6:13:27 PM2/11/10
to fusion...@googlegroups.com
alas Darren that didn't work.
I am adding it in right place right?

jdbc:fusionreactor:wrapper:{jdbc:mysql://myservert:3306/mydsn?useUnicode=true&characterEncoding=UTF-8&autoReconnectForPools=true};driver=macromedia.jdbc.MacromediaDriver;name=hp_www_live1

--
You received this message because you are subscribed to the Google Groups "FusionReactor" group.
To post to this group, send email to fusion...@googlegroups.com.
To unsubscribe from this group, send email to fusionreacto...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/fusionreactor?hl=en.




--
---
Russ Michaels
I.T. Consultant

*Disclaimer:- nothing I say via email  is meant to offend, aggravate, annoy, insult, belittle or in any way imply anything toward any particular person unless expressly stated to the contrary. Mis-interpret this email at your own risk.

Darren Pywell

unread,
Feb 11, 2010, 7:19:54 PM2/11/10
to FusionReactor
Hey Russ,

Yeah, that attribute is in the right place, but the issue might be (if
this is ColdFusion) that the Driver name that ships is
org.gjt.mm.mysql.Driver for MySQL. Can you try:

jdbc:fusionreactor:wrapper:{jdbc:mysql://myservert:3306/mydsn?

useUnicode=tr­
ue&characterEncoding=UTF-8&autoReconnectForPools=true};driver=org.gjt.mm.mysql.Driver;name=hp_www_live1

Cheers,
Darren


On Feb 12, 12:13 am, Russ Michaels <russ.micha...@gmail.com> wrote:
> alas Darren that didn't work.
> I am adding it in right place right?
>

> jdbc:fusionreactor:wrapper:{jdbc:mysql://myservert:3306/mydsn?useUnicode=tr­ue&characterEncoding=UTF-8&autoReconnectForPools=true};driver=macromedia.jd­bc.MacromediaDriver;name=hp_www_live1


>
> On Thu, Feb 11, 2010 at 3:31 PM, Darren Pywell <dapyw...@googlemail.com>wrote:
>
>
>
>
>
> > Russ,
>
> > Maybe try adding:
>
> > &autoReconnect=true
>
> > and/or
>
> > &autoReconnectForPools=true
>
> > It could be that the unwrapped driver is adding this behind the scenes
> > without you knowing.
>

> >http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configur...


>
> > Cheers,
> > Darren
>
> > On Feb 11, 12:08 pm, "Snake" <snake.li...@snakepit.net> wrote:
> > > I wrapped a MySQL DSN last week and it has been working fine, but today
> > it
> > > mysteriously stopped working with the following error.
>
> > > Verification ERROR: Application
> > > java.sql.SQLException: Timed out trying to establish connection
> > > The root cause was that: java.sql.SQLException: Timed out trying to
> > > establish connection
>
> > > A regular DSN to the exact same database works fine, only the JDBC
> > wrapper
> > > is failing, any idea what could be causing this ?
>
> > > --
> > > Russ
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "FusionReactor" group.
> > To post to this group, send email to fusion...@googlegroups.com.
> > To unsubscribe from this group, send email to

> > fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog­legroups.com>


> > .
> > For more options, visit this group at
> >http://groups.google.com/group/fusionreactor?hl=en.
>
> --
> ---
> Russ Michaels
> I.T. Consultant
>
> *Disclaimer:- nothing I say via email  is meant to offend, aggravate, annoy,
> insult, belittle or in any way imply anything toward any particular person
> unless expressly stated to the contrary. Mis-interpret this email at your

> own risk.- Hide quoted text -

Russ Michaels

unread,
Feb 11, 2010, 8:07:22 PM2/11/10
to fusion...@googlegroups.com
no joy with that either, still the same error.
What I don;t get is why it worked for several days then mysteriously broke.

Russ

To unsubscribe from this group, send email to fusionreacto...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/fusionreactor?hl=en.

Maureen Barger

unread,
Feb 11, 2010, 8:11:37 PM2/11/10
to fusion...@googlegroups.com
I am wondering if you can connect with an unwrapped connection, or if
you can restart your instance?

Snake

unread,
Feb 11, 2010, 8:18:52 PM2/11/10
to fusion...@googlegroups.com
a normal unwrapped DSN is working fine.

Russ

--------------------------------------------------
From: "Maureen Barger" <moba...@gmail.com>
Sent: Friday, February 12, 2010 1:11 AM
To: <fusion...@googlegroups.com>
Subject: Re: FusionReactor Group: Re: Wrapped DSN not working

Darren Pywell

unread,
Feb 12, 2010, 1:19:15 PM2/12/10
to FusionReactor
So, is the working DSN going to the same MySQL database/schema?

Could you try setting up another one just to see if that works. I
haven't heard of a wrapped JDBC DSN breaking like that before... would
be good to get to the bottom of it.

Cheers,
Darren


On Feb 12, 2:18 am, "Snake" <snake.li...@snakepit.net> wrote:
> a normal unwrapped DSN is working fine.
>
> Russ
>
> --------------------------------------------------

> From: "Maureen Barger" <mobar...@gmail.com>


> Sent: Friday, February 12, 2010 1:11 AM
> To: <fusion...@googlegroups.com>
> Subject: Re: FusionReactor Group: Re: Wrapped DSN not working
>
>
>
> > I am wondering if you can connect with an unwrapped connection, or if
> > you can restart your instance?
>

> > On Thu, Feb 11, 2010 at 20:07, Russ Michaels <russ.micha...@gmail.com>


> > wrote:
> >> no joy with that either, still the same error.
> >> What I don;t get is why it worked for several days then mysteriously
> >> broke.
> >> Russ

> >> On Fri, Feb 12, 2010 at 12:19 AM, Darren Pywell <dapyw...@googlemail.com>


> >> wrote:
>
> >>> Hey Russ,
>
> >>> Yeah, that attribute is in the right place, but the issue might be (if
> >>> this is ColdFusion) that the Driver name that ships is
> >>> org.gjt.mm.mysql.Driver for MySQL. Can you try:
>
> >>> jdbc:fusionreactor:wrapper:{jdbc:mysql://myservert:3306/mydsn?
> >>> useUnicode=tr
>

> >>> ue&characterEncoding=UTF-8&autoReconnectForPools=true};driver=org.gjt.mm.my­sql.Driver;name=hp_www_live1


>
> >>> Cheers,
> >>> Darren
>
> >>> On Feb 12, 12:13 am, Russ Michaels <russ.micha...@gmail.com> wrote:
> >>> > alas Darren that didn't work.
> >>> > I am adding it in right place right?
>

> >>> > jdbc:fusionreactor:wrapper:{jdbc:mysql://myservert:3306/mydsn?useUnicode=tr­ ue&characterEncoding=UTF-8&autoReconnectForPools=true};driver=macromedia.j­d bc.MacromediaDriver;name=hp_www_live1

> >http://groups.google.com/group/fusionreactor?hl=en.- Hide quoted text -

Snake

unread,
Feb 12, 2010, 1:37:23 PM2/12/10
to fusion...@googlegroups.com
Yes it is the exact same mysql database.
I create a new DSN, which works.
Wrap it with the JDBC wrapping tool, it no longer works.

Russ

-----Original Message-----
From: fusion...@googlegroups.com [mailto:fusion...@googlegroups.com]
On Behalf Of Darren Pywell

Russ Michaels

unread,
Feb 15, 2010, 7:44:40 AM2/15/10
to fusion...@googlegroups.com
Any other idea's Darren?
I want to wrap ALL DSN's on the server for monitoring purposes, but need to make sure it is going to work first.
So far not much luck, MSSQL failed with the wrapping tool as well, but I managed to fix that
 


 
On Fri, Feb 12, 2010 at 6:37 PM, Snake <snake...@snakepit.net> wrote:
Yes it is the exact same  mysql database.
I create  a new DSN, which works.
Wrap it with the JDBC wrapping tool, it no longer works.

Russ
-----Original Message-----
From: fusion...@googlegroups.com [mailto:fusion...@googlegroups.com]
On Behalf Of Darren Pywell
Sent: 12 February 2010 18:19
To: FusionReactor
--
For more options, visit this group at http://groups.google.com/group/fusionreactor?hl=en.

Darren Pywell

unread,
Feb 15, 2010, 8:06:17 AM2/15/10
to FusionReactor
Russ,

Sure, of course. It sounds like there is an issue with the wrapping
tool in that it's not wrapping correctly for your environment.

Can you post the original MySQL and wrapped MySQL from the wrapping
tool along with the MSSQL (original and wrapped).

Can you also show me what you changed in the MSSQL version to make it
work; this should help me get on the right path.

Cheers,
Darren

> > > >> own risk.
>
> > > >> --
> > > >> You received this message because you are subscribed to the Google
> > Groups
> > > >> "FusionReactor" group.
> > > >> To post to this group, send email to fusion...@googlegroups.com.
> > > >> To unsubscribe from this group, send email to

> > > >> fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog­legroups.com>
> > .
> > > >> For more options, visit this group at
> > > >>http://groups.google.com/group/fusionreactor?hl=en.
>
> > > > --
> > > > You received this message because you are subscribed to the Google
> > Groups
> > > > "FusionReactor" group.
> > > > To post to this group, send email to fusion...@googlegroups.com.
> > > > To unsubscribe from this group, send email to
> > > > fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog­legroups.com>
> > .
> > > > For more options, visit this group at

> > > >http://groups.google.com/group/fusionreactor?hl=en.-Hide quoted text -


>
> > > - Show quoted text -
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "FusionReactor" group.
> > To post to this group, send email to fusion...@googlegroups.com.
> > To unsubscribe from this group, send email to

Snake

unread,
Feb 15, 2010, 11:53:36 AM2/15/10
to fusion...@googlegroups.com
Original MYSQL3 DSN
I will replace names for security, but all the replaced words are the same
in both the original and wrapped DSN

Cf DSN name: mydsn1
Database: mydsn1
Server: cfdeveloper-sql1
Username: myusername

Wrapped DSN
Cf DSN name: mydsn1_wrapped
JDBC URL:
jdbc:fusionreactor:wrapper:{jdbc:mysql://cfdeveloper-sql1:3306/mydsn?useUnic
ode=true&characterEncoding=UTF-8};driver=macromedia.jdbc.MacromediaDriver;na
me=mydsn


Cf version: 7
FR version: 3


The MSSQL failed due to the "name=myDSN" on the end, giving an invalid
option error. I removed this and it worked.

Russ,

Cheers,
Darren

fusionreacto...@googlegroups.com.

Snake

unread,
Feb 15, 2010, 11:56:08 AM2/15/10
to fusion...@googlegroups.com
Ok I just removed the name=dsnname from the mysql wrapped dsn, and it fixed
this one too :-)

Russ

-----Original Message-----
From: fusion...@googlegroups.com [mailto:fusion...@googlegroups.com]
On Behalf Of Darren Pywell

Sent: 15 February 2010 13:06

Russ,

Cheers,
Darren

fusionreacto...@googlegroups.com.

Darren Pywell

unread,
Feb 15, 2010, 4:37:39 PM2/15/10
to FusionReactor
Ok, we'll take a look into that. Thanks for the update. Very helpful.

Darren

> > > > >http://groups.google.com/group/fusionreactor?hl=en.-Hidequoted text

Snake

unread,
Feb 16, 2010, 6:48:01 AM2/16/10
to fusion...@googlegroups.com
I spoke to soon, it stopped working again today with the same error

Connection verification failed for data source: hp_www_live1


java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to
establish connection

Obviously it was a fluke it started working again yesterday.

Russ

Darren

> > > org.gjt.mm.my-


> > > sql.Driver;name=hp_www_live1
>
> > > > >>> Cheers,
> > > > >>> Darren
>
> > > > >>> On Feb 12, 12:13 am, Russ Michaels <russ.micha...@gmail.com>
> wrote:
> > > > >>> > alas Darren that didn't work.
> > > > >>> > I am adding it in right place right?
>
>

jdbc:fusionreactor:wrapper:{jdbc:mysql://myservert:3306/mydsn?useUnicode=tr-
> -
>
>
ue&characterEncoding=UTF-8&autoReconnectForPools=true};driver=macromedia.j--

fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog-
> legroups.com>
> > > <fusionreactor%2Bunsubscribe@goog-

fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog-

fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog-


> legroups.com>
> > > .
> > > > >> For more options, visit this group at
> > > > >>http://groups.google.com/group/fusionreactor?hl=en.
>
> > > > > --
> > > > > You received this message because you are subscribed to the Google
> > > Groups
> > > > > "FusionReactor" group.
> > > > > To post to this group, send email to
fusion...@googlegroups.com.
> > > > > To unsubscribe from this group, send email to
>
>

fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog-


> legroups.com>
> > > .
> > > > > For more options, visit this group at
> > > > >http://groups.google.com/group/fusionreactor?hl=en.-Hidequoted text
> -
>
> > > > - Show quoted text -
>
> > > --
> > > You received this message because you are subscribed to the Google
> Groups
> > > "FusionReactor" group.
> > > To post to this group, send email to fusion...@googlegroups.com.
> > > To unsubscribe from this group, send email to
>
>

fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog-


> legroups.com>
> > > .
> > > For more options, visit this group at
> > >http://groups.google.com/group/fusionreactor?hl=en.
>
> > > --
> > > You received this message because you are subscribed to the Google
> Groups
> > > "FusionReactor" group.
> > > To post to this group, send email to fusion...@googlegroups.com.
> > > To unsubscribe from this group, send email to
>
>

fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog-

Darren Pywell

unread,
Feb 16, 2010, 7:59:00 AM2/16/10
to FusionReactor
This looks like two different things. One is the ;name param on the
JDBC URL and the other is that the MySQL JDBC connection can't
connect.

What version of FR is this running on?

Cheers,
Darren

> jdbc:fusionreactor:wrapper:{jdbc:mysql://myservert:3306/mydsn?useUnicode=tr­-
> > -
>
> ue&characterEncoding=UTF-8&autoReconnectForPools=true};driver=macromedia.j-­-

> fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog­-

> fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog­-

> fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog­-


> > legroups.com>
> > > > .
> > > > > >> For more options, visit this group at
> > > > > >>http://groups.google.com/group/fusionreactor?hl=en.
>
> > > > > > --
> > > > > > You received this message because you are subscribed to the Google
> > > > Groups
> > > > > > "FusionReactor" group.
> > > > > > To post to this group, send email to
> fusion...@googlegroups.com.
> > > > > > To unsubscribe from this group, send email to
>

> fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog­-


> > legroups.com>
> > > > .
> > > > > > For more options, visit this group at

> > > > > >http://groups.google.com/group/fusionreactor?hl=en.-Hidequotedtext


> > -
>
> > > > > - Show quoted text -
>
> > > > --
> > > > You received this message because you are subscribed to the Google
> > Groups
> > > > "FusionReactor" group.
> > > > To post to this group, send email to fusion...@googlegroups.com.
> > > > To unsubscribe from this group, send email to
>

> fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog­-


> > legroups.com>
> > > > .
> > > > For more options, visit this group at
> > > >http://groups.google.com/group/fusionreactor?hl=en.
>
> > > > --
> > > >  You received this message because you are subscribed to the Google
> > Groups
> > > > "FusionReactor" group.
> > > > To post to this group, send email to fusion...@googlegroups.com.
> > > > To unsubscribe from this group, send email to
>

> fusionreacto...@googlegroups.com<fusionreactor%2Bunsubscribe@goog­-


> > legroups.com>
> > > > .
> > > > For more options, visit this group at
> > > >http://groups.google.com/group/fusionreactor?hl=en.
>
> > > --
> > > ---
> > > Russ Michaels
> > > I.T. Consultant
>
> > > *Disclaimer:- nothing I say via email  is meant to offend, aggravate,
> > annoy,
> > > insult, belittle or in any way imply
>

> ...
>
> read more »- Hide quoted text -

Snake

unread,
Feb 16, 2010, 11:59:22 AM2/16/10
to fusion...@googlegroups.com
It is FR300ENT

The below error is the only one I have ever got for MYSQL, I only removed
the name parameter as that worked for MSSQL, I think the fact that it worked
yesterday was just a fluke and probably not related to my doing that.

Russ

Cheers,
Darren

fusionreacto...@googlegroups.com.

David Stockton

unread,
Feb 23, 2010, 10:19:41 AM2/23/10
to FusionReactor
UPDATE: We (Intergral) are working directly with Russ but have been
unable to reproduce the problem.

We will update this thread if/when we are able to reproduce with
further details.

Many thanks,
David Stockton
Fusion Support Team

> ...
>
> read more »

Russ Michaels

unread,
Apr 10, 2010, 2:30:54 PM4/10/10
to fusion...@googlegroups.com
just to follow up on this, I tried  creating a second wrapped DSN that was not in use and nothing happened, the problem did not re-occur. So it seems the DSN must be in use in order for the problem to occur.


On Thu, Feb 11, 2010 at 12:08 PM, Snake <snake...@snakepit.net> wrote:
I wrapped a MySQL DSN last week and it has been working fine, but today it
mysteriously stopped working with the following error.

Verification ERROR: Application
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to
establish connection

A regular DSN to the exact same database works fine, only the JDBC wrapper
is failing, any idea what could be causing this ?

--
Russ
--
You received this message because you are subscribed to the Google Groups "FusionReactor" group.
To post to this group, send email to fusion...@googlegroups.com.
To unsubscribe from this group, send email to fusionreacto...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/fusionreactor?hl=en.

Reply all
Reply to author
Forward
0 new messages