using wan optimizer

[jeff plummer]

I am currently having a hard time getting the wan optimizer to work, or rather even knowing whether or not it is working at all.

Is there anyway I can even find out if my model is connected using the wan optimizer.  My model opens no matter what I enter into the wan optimizer connection field, so I can't tell if my performance is bad because I'm not connected to the optimizer, or if the optimizer just isn't affecting performance in any noticeable way.

Thanks,
Jeff

[Eve]

Look for the letters 'WAN' in the status bar.  If you hover over them, EA will give you the status.  (It also has an enabled and disabled color, but that depends on the theme.)

[jeff plummer]

Ok,

I see that...  But how in the world do I know what the problem is.  I've tried 50 times now.

My admin client shows that I have the database up and accepting connections.

But when I run my client, I must be entering in the wrong data when I set "Use Wan Optimizer" but I have no idea what I am doing wrong.


The optimizer is on my "localhost:4242", and when I launch my client I use the following wan optimizer settings:
Server: locahost
Port: 4242
DSN:  <blank>  ( I don't know what this is)

Any help would be most appreciated.

Thanks,
Jeff

[mrf]

Hello Jeff,

What version of EA are you using? Anything after build 841 will display errors in the Output tab (View | Output) if the WAN Optimizer fails to connect. Your second post didn't mention if the indicator was on or off either. If it is on, then EA will be routing through the WAN Optimizer.

The WAN Optimizer will most likely not improve performance if it is running on the same machine as your client. It may improve performance on a LAN if it is running on the same machine as the DBMS. It should always improve performance on a WAN if it is on a machine with a highbandwidth connection to the DBMS. Please consult the Wan Optimizer Service user guide for a more thorough explanation of these concepts.

The DSN field is for ODBC connections that specify a Data Source Name. The DSN for a particular ODBC database may be different between the client and server machines, so an additional field is needed. If you are running on localhost, then just fill it in with your local Data Source Name.

[jeff plummer]

My current setup is:
MySQL DB is  on another machine very far away (and slow)
Client & WAN optimizer on my local machine

I am using build 843.  I just downloaded the latest.

I got an error message this time around that says
WAN OPTIMIZER: Unable to connect to database      

Why does my client tell me the WAN optimizer can't connect, but my WAN Optimizer admin seems like it worked (or atleast my "test connection" when I set it up seemed to work).

[mrf]

Ok no problems. If you are using MySQL then you'll be using an ODBC connection. You will note on the ODBC administration dialog where you set up your ODBC connections that there are two categories: User DSN and System DSN.

As the WAN Optimizer service runs under the Local System account it will not have access to any of your User DSNs (whereas the admin client is run explicitly by you and will be able to see them - we're currently looking at what we can do about this as it is a bit confusing). If you create a System DSN for your connection, I'm fairly confident that this should address the problem.

To quote the user guide:

Note: For ODBC connections, the Data Source must be accessible to the user that the service runs as. By default the service runs as the Local System user, which results in the WAN Optimizer Service only having access to ODBC System DSNs.