Simple incoming-only SMTP that stores mail and attachments in MySQL

Closed

PROJECT DESCRIPTION

We need a simple, light SMTP server / listner that will be installed on a Debian and which will write email to a mysql database.

BACKGROUND

We produce a financial product that must store collaboration messages and the occasional documents that are sent as attachements. These messages and attachments must be emailed to an email address rather than uploaded from the desktop, which is a common problem in handheld and tablet apps that do not allow local storage. These emails will consist of normal correspondence, plus documents that can be quite large. The email content may consist of simple text, rtf, or html formatting. The attached documents can be of any number and any type.

The application will then query the database directly and display the contents to the user interface as needed. So there is no need to forward or send email. We only need to receive and store it. Maintenance of it can be done from the user interface side of the application.

We also host this product as an SAS solution and we must have simple C/C++ libraries that can be run anywhere without complex configuration.

We integrate with Sharepoint also, but we need freedom from ties to that vendor's product for those customers that want it, and for our SAS offering.

REQUIREMENTS

(I noticed that this project has been requested before by others, so forgive me if you have seen something like it.)

0) Configure from a text config file. defaults to current directory, unless command line file path specified. Config should Include the db connection information, and table names.

1) write all activity to a text log file. Create new files daily, weekly, monthly, based upon config file.

2) it will listen for a connection on port 25.

3) Once a connection comes in, it will verify the names in the TO list, and check a mysql database table (users) to determine if that email address is registered. This email name will be a long string like a GUID, followed by a domain name ie: @thissegment.anothersegment.yetanothersegment.com.

4) if any name is not found, then that name is discarded. If all names are not, the email is discarded entirely with no further action, other than logging the unlisted address, date and time in the log.

5) If it finds the name, the system will:

a) perform one or more minor regex functions on the email description/title and the body content, replaced with information from the config file.

b) store the contents of the message in the database without encryption.

c) store the attachments in the database without encryption.

d) tolerate attachments up to 100MB, with the maximum attachment size being a configuration option. (I suspect that we may have to RETURN a failure response to the sending server if the attachment is too large?) (not an email, just an error or error code)

6) we must be able to request status from it somehow (our apps are largely written in php)

7) It must process multiple connections at once as multiple messages may come in at a time. And we want to set the connections limit at the top if possible.

8) The language should be C or C++. (No, we cannot use Java, sorry. :)

DELIVERABLES

1) Fully-functional working program in executable form.

2) Complete source code.

3) Installation instructions that are clear enough that we can even give them to our customers if we have to. :)

INTELLECTUAL PROPERTY

1) This project is "work for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

Skills: C Programming, Engineering, MySQL, PHP, Software Architecture

See more: table html, we can write that, top programming language, suspect description form, string c plus plus, simple programming language, sharepoint programming language, sas programming language, sas on line check in, sas hire, regex in c, regex explained, regex c, programming on a tablet, php programming problem set, new line in php, new in java 1.5, new hire background check, mysql database name in include config php, maximum path, mail on line, java command line application, hire sas, gnu regex c, gnu regex

Project ID: #4303510

23 freelancers are bidding on average $2733 for this job

srinichal

I can deliver the project to your specs

$2200 USD in 18 days
(118 Reviews)
7.0
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$5000 USD in 25 days
(370 Reviews)
7.0
qualifiedcoders

Hi We are interested in your project and read your requirements.We have completed 150+ big projects in C,C++,.NET,PHP and Java in last 5 years. Please check private message board for details.

$2750 USD in 22 days
(18 Reviews)
7.0
webedeveloper

Experienced team specializing in CMS open sources like Wordpress, Drupal, Joomla, and more with latest web trends and standards are ready to start. Thank you!

$3500 USD in 45 days
(78 Reviews)
6.7
samitXI

Kindly check your inbox. Thanks

$2500 USD in 35 days
(63 Reviews)
6.0
biddyweb

I can develop this solution using gcc. I could actually this much faster in python(10 days) however, i can achieve the same result within 25 days in c. Kindly send details of versions of debian you intend to support(so More

$3000 USD in 25 days
(7 Reviews)
5.6
universesys

We are a team of developers and designers who are in this field from more than 6 years. Please check your PMB for details. If you will give us the project then we will do that better quality of work within the time per More

$1700 USD in 27 days
(13 Reviews)
5.6
BitsLogic

We are a professionally managed IS0 9001:2008 certified web development company. Our team has extensive experience and we have provided services to reputed companies in US, UK, CANADA & Europe. Currently we have ar More

$4000 USD in 59 days
(5 Reviews)
5.4
eliezedeck

Hi, kindly check my proposal. Thank you

$2500 USD in 21 days
(8 Reviews)
5.4
aptecpymefree

We can work in your Simple incoming-only SMTP that stores mail and attachments in MySQL. I am a leader of the team expert in several tecnologies like PHP, .NET, Oracle, SQL, Movil applications. I have 14 Years of exper More

$2000 USD in 45 days
(6 Reviews)
4.7
defelice

Hi, I am very interested in your project. I developed in the past both network daemons (for example, a little FTP automated client, or a complex RPC-like client-server app), and financial applications (neural network More

$1800 USD in 30 days
(3 Reviews)
3.4
poginato

Hi, I am Masters in Computer Science and have 07+ years experience in Object Oriented commercial Software Design and Software Development. I am results-driven, customer-focused, articulate and analytical Software En More

$1800 USD in 60 days
(4 Reviews)
1.8
getveltrod

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te More

$2500 USD in 25 days
(5 Reviews)
1.3
dhavaljadia

Please check pm.

$1500 USD in 15 days
(1 Review)
1.2
ShawarmaMan

Hi, I've written several multi-threaded daemons in C before to handle concurrent access to resources by clients. I'd be glad to help write your simple SMTP server for you. Thanks.

$2500 USD in 50 days
(1 Review)
1.1
WildMediaRo

Greetings! WildMediaRo team is interested in your project. We are 21 programmers, designers and advertisers, ready to get any job done. We are confident you would be very satisfied with our services. With respect More

$1700 USD in 40 days
(4 Reviews)
0.0
krishcompusoft07

We can do this project ........................Our bid is tentative, we will finalise price after a small discussion about specs with you............................

$10000 USD in 80 days
(0 Reviews)
0.0
Poison80

Interesting. Please see my PM to you

$2000 USD in 30 days
(0 Reviews)
0.0
XmuFive

Hi, check pm.

$1500 USD in 5 days
(0 Reviews)
3.0
RodolfoMartinez

I am a Canadian consultant with over 10 years experience, and my team specializes in blending business & strategic planning with IT solutions. We have done other PHP and MySQL projects, as we are confident that we can More

$2600 USD in 30 days
(0 Reviews)
0.0