I want to find an existing service, or set one up with available tools, that will do the following:
- Receive MMS message from a cell phone (picture/video/text/sound/anything else possible)
- Store attachment(s) into a structured dynamic filesystem
- Log their respective path, filename, filetype, filesize, timestamp, the sender's phone number/ip address, and the service provider if possible into a database
My ideal environment would be php, perl, linux, and mysql.
Are there any open-source CMS systems that are designed to handle this? Or any open-source software modules that could, if used together, accomplish these tasks?
Also, is it better off to store the attachments onto the server, into the database as blobs, or both?
From what I know is available and is possible, I'm thinking:
- Set up a gmail account for MMS messages to be sent to
- Scan the email via an IMAP perl module for new messages (either retrieve and check entire list of message id's against the table, or via a function/method of the IMAP perl module that only queries for unread messages)
- Parse the new emails and store attachment(s) on the remote server (input validation)
- Log all the worth-while information into the right tables (input validation)
As a side-note, I'm going to try and put it all together on Kodingen. I just became a member at that site and it's pretty sick. Check it out if you haven't already.