Cheshire Cat Computing

Hi Steve,

Great stuff your doing here,
I have a requirement for the company that I'm working for to have a Unix shell script automatically generate the export.csv file that is generated from your perl app. I tried to invoke the link that is attached to the Export button using the unix wget command but it obviously didn't work. I don't believe the wget utility can invoike cgi scripts.

The ultimate goal would be to export the file for a specific graph and transfer it to a remote location where another application would parse it, then perform calculations on specific values and then place the required values into a mysql database.

If you know how I can get that export file generated or perhaps a simpler way to achieve my goal described above it would be greatly appreciated.

Thank you very much for your help in advance.
Jason Chechik

There are two ways to achieve this.

1. You can use wget, it does work. You need to pass the correct parameters, and if you have an authenticated system then the authentication as well. If you are using routers2 internal authentication, though, this will not work.

2. You can call routers2 from the command line on the MRTG server, it has special command line options to allow you to pass the device -D, target -T, style -s and type -t. You can also pass the authenticated username this way if you have authenication enabled. Older versions have a bug that still outputs the HTML header in this case, so watch out for this one.

Authentication can mess things up as routers2 will not hand over the csv if it thinks you're not entitled to it.

_________________
Steve Shipway
UNIX Systems, ITSS, University of Auckland, NZ
Woe unto them that rise up early in the morning... -- Isaiah 5:11

Thanks Steve very much for your help it very much appreciated.
I got it to work using wget using the get parameters that you stated above.
This is very helpful and I truely do appreciate your timely response.

Hi Steve, sorry I am new to wget. Can you show me how to use it to get the CSV file? Thanks

1. Use the web browser to find the appropriate URL to obtain the CSV you're after.
2. Pass this URL to wget -- you may also need to include authentication information if you're running with web server authentication.

_________________
Steve Shipway
UNIX Systems, ITSS, University of Auckland, NZ
Woe unto them that rise up early in the morning... -- Isaiah 5:11