Show Bid Request
mail archive in MySQL
Bid Request Id: 66977
|
|
|
|
Posted by: |
colorweb (1 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 0.00%
|
Buyer Security Verifications: |
Good
|
|
Approved on: |
Jun 6, 2003
9:36:59 AM EDT
|
|
Bidding Closes: |
Jun 13, 2003
11:50:42 AM EDT
|
|
Viewed (by coders): |
157 times
|
|
Deadline: |
6/13/2003 11:55:00 AM
TIME EXPIRED
|
|
|
|
|
Description:
Setup on a dedicated linux box (ie. mailarchive.com). The box is provided fresh-vanilla RedHat.
Overall functionality:
Emails are sent to multiple adresses (at) mailarchive.com. These emails should be stored in a MySQL database.
Details:
The parts of the mail must be stored in separate fields in the table (ie. subject, date, sender, reciever, body, attachments).
The mails must be processed either as they arrive or schedule'ed (at least every 5 minutes).
Deliverables:
Mail-receive:
1) The box provided must be set up to recieve mails on all emailadresses on a domain ( * (at) mailarchive.com). It must be documented how to change this domain or add new domains.
2) Nameservices (ie. MX records) will be setup on one of our production servers, so nameserver configuration are not included in the assignment.
Mail-parsing:
1) Recieved mails must be processed within 5 minutes.
2) Mails should be stored in a MySQL database.
3) At least the following parts of the mail should be stored in separate fields:
3a) Received date
3b) Sender email
3c) Receiving email
3d) Subject
3e) Body
3f) Attachment(s)
3g) Complete header
4) With regards to attachments they must be detached, saved in a directory, given a unique name, assigned the correct filetype (based on MIME).
4a) The unique name must be stored in the database.
4b) The filetype based on MIME type must be stored in the database.
5) With regards to the body field it must be stored in a text field in the database. HTML is allowed.
5a) The text should be directly readable (ie. no MIME encodings etc.)
Database:
1) The database should be configured in MySQL and be documented.
2) The database design should make all functionality above possible.
General deliverables:
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.
4) The software installed in a working setting on the box provided.
5) Documentation of how to configure the software and which extra packages in realtion to the platform are necessary.
Platform:
Linux box fresh installed with the downloadable version of RedHat 9.
The box is dedicated to this purpose and the coder will be given SSH access to the box.
Must be 100% finished and received by buyer on:
Jun 13, 2003 11:55:00 AM EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
|
This bid was accepted by the buyer!
|
$100 (USD)
|
Jun 6, 2003
9:50:53 AM EDT
|
7.33
(Good)
|
|
|
Thanks for all the good details in your project description. I can get this job done in short order.
In general, I'm familer with the sendmail configuration requirements to accept email for all addresses in a domain and route them to a single email box. Additionally I know how to configure a delivery agent to handle this mail that can do the processing. In particular, a Perl script can parse the email and insert into the database. There is a Perl module available for MIME based email parsing that can make handling the attachements easy and reliable. Of course Perl can talk to MySQL.
My bid is for a turnkey solution including:
1. Configuration of sendmail and a custom delivery agent written in Perl.
2. Install/configure of MySQL (if needed).
3. Documentation of install procedures and steps for adding additional domains.
4. Testing of system to verify proper operation.
5. One month of technical support on the system.
I'm new to Rent-A-Coder but if you take a look at my resume you'll see that I've been doing web development and network engineering for over a decade. My company Reliable Penguin is affiliated with MySQL and we have great experience with this software and Linux in general.
My bid may not be the lowest but I can guarantee that we will return the greatest value for your investment.
I look forward to an opportunity to work with you.
Lee Blakely
Senior Engineer
Reliable Penguin
|
|
|
|
|
|
|