Possible challenge for you! Security

Anon

Hey guys... quick question for your thoughts.

Basically what I want to do is extract data from a MYSQL database and create a flat file of orders for the day. Then I want to send that flat file over to a server behind my company's firewall SECURELY(thats the issue).

How can you FTP or send a flat file over securely, automatically?
Any thoughts on this?

Anon

um use ssh or encrypt the file.

Anon

well thats easy to say, but how?

Anon

you could use the crypt function and use a static salt to encrypt it. then send the file and use the static salt to decrypt the information when you receive it.

http://www.php.net/crypt

Anon

If using UNIX you can use scp. Basically scp securely copies a file via the ssh protocol.

scp root@server1:/my.path/to/dumpfile.db root@destinationserver:/my.path/to/dumpfile.db

call scp as a system call. You will need to have an authentiction key setup which allows server1 to connect to destinationserver without providing a password. This is very easy to do with openssh, or any other ssh daemon out there.