Checking client has finished FTP

[waygood]

We are currently hosting a website on a FreeBSD server, which I am unfamiliar with.

Clients are used various packages to FTP files to our server for loading into our database. Is there any way to check for any FTP connections currently open before I start processing the data.

I will be setting up a cron job to convert and upload the data, but if someone is still uploading then the data will be incomplete. So I want to wait until all FTP have finished and possibly lock anyone from uploading anything further, until the process is complete.

The packages cannot be changed as they form the part of other peoples business suites.

The "w" command (unix -who) lists the users currently logged in but not users going through the FTP daemon.

So can anyone tell me how to get information from the FTP daemon from within a PHP script.

[dalecosp]

Hi,

I'm less of an expert than many. On FreeBSD, the command 'sockstat -u' might be something to look into. From within PHP, you might have to look into stream_get_meta_data.....???

I'm curious about the cron job. Are you going to write it in PHP also? If not, and you're going to be running a cron job anyway, why not write something in sh and use 'sockstat'?

Wish I was the guru!

[waygood]

I was going to do it all in PHP, but I may change it to your suggestion. CRONed shell script to check FTP connections then run the PHP script to translate and load into database. I can then test each section seperately.

Will try sockstat out tomorrow when I have access to command prompt. Thank you, I'll keep you posted on my progress.

[waygood]

Excellent

All the users are listed with ftpd (ftp daemon), just what I needed.