Posted by NC on 04/13/06 00:09

kurl wrote:
> NC Wrote:
> > >
> > > I need to do croning in PHP to generate a CDR (Call Details Record)
> > > file daily from the mysql database.
> >
> > You can't "do croning in PHP". Croning is best done with cron.
>
> I mean using croning to run PHP scripts.

This is easy. Best done using the command-line interpreter, since the
command-line interpreter does not require an HTTP server. Hence, no
HTTP server overhead and no timeout problems.

> > > The CDR file has to be named in a certain sequence such as
> > > xx00000xxx200604080850.cdr. A new file is written every day.
> >
> > Do you know what the format of that file would be?
>
> Yes, i have the format of the file. There is two formats that needs
> to be done.

Shouldn't be a problem.

> > > The generated CDR file is then ftp over to a server.
> >
> > Do you have the FTP extension enabled on your machine?
>
> How do i find out whether i hv ftp extension enabled on my machine?

Type "php -m" in the command line. It will show you the list of
modules compiled into PHP. Look for FTP.

> Two files need to ftp over. One of the file need to do a secure ftp.

In order to work with secure FTP, PHP must be compiled with OpenSSL
support (see the "php -m" bit above). There are workarounds, however;
if you have shell access to the machine in question, it's possible to
use a third-party FTP utility such as NcFTPput (free and not affiliated
with me :)

> Can you do the above mentioned and i am willing to pay for it.
> Pls quote.

Since I don't know the availability of secure FTP on your machine, I
can't tell yuo if I can do what you need. If you're still interested,
shoot me an e-mail at nc@iname.com.

Cheers,
NC

[Back to original message]