Sponsored Content
Full Discussion: Sendmail+MySQL
Top Forums UNIX for Advanced & Expert Users Sendmail+MySQL Post 9022 by CGrusden19 on Sunday 21st of October 2001 08:18:26 PM
Old 10-21-2001
Sendmail+MySQL

First off, the new site looks damn good..I use to post and it's changed for the better... On to my question... I've already searched these forums and MySQL + Sendmail's site for my answer, and came up with nothing..

My task at hand is I need to be able to STORE messages in a MySQL Database with use with Sendmail.. When a message comes in, I want sendmail to do a few checks before it saves the message..
1) Check the "userlist" table to determine whether the user is a local account, or a virtual account...
2) If so, proceed and parse the message like normal but store it in a "messages" type of table.. where it will store everything...
That's all I want to be able to do... and I know this is probably a major task.. I've found a few sites that have "patches", but have come up with nothing.. I'm NO EXPERT AT ALL, i'm just seeing if I can get some minor direction as to how to handle this.. there's no rush, so if it's advisable to read like a "sendmail" or "how-to" on how to hack the sendmail source, I will definitely do so..

I'm using Sendmail 8.9.3 with nothing special .. no procmail scripts or any qpopper...

Thanks in advance,
 

6 More Discussions You Might Find Interesting

1. Programming

Sendmail & mail.local + MySQL API

I've searched this message board, and the newgroups THOROUGHLY, in search of any information towards implenting the MySQL API with C... I'm a "beginner" to the C language I suppose, and i've made a few functions in C that can be implemented into the source code of Sendmail/mail.local, so that any... (2 Replies)
Discussion started by: CGrusden19
2 Replies

2. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

MySQL on my server is down.... I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock Any suggestions? Here's what I can't do: can't be root don't have physical access (do stuff via SSH) reinstall MySQL (need to keep the current MySQL... (8 Replies)
Discussion started by: _hp_
8 Replies

3. UNIX for Advanced & Expert Users

mysql would not start: missing mysql.sock

I recently installed mysql-standard-5.0.21-solaris9-sparc-64bit.pkg on a Solaris 9 machine (SunOS 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250). The package installation went very smooth, however, starting mysql is a different story. I get the message below everytime I try to start mysql: #... (2 Replies)
Discussion started by: xnightcrawl
2 Replies

4. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)... (3 Replies)
Discussion started by: jastanle84
3 Replies

5. UNIX for Advanced & Expert Users

Sendmail questions, SCO 5.0.6 sendmail 8.11.0

I am running SCO 5.0.6 and using sendmail 8.11.0 and having issues with smtp authentication. When trying to send mail the following message will kick back. (reason: 530 5.7.1 Authentication required) 530 5.7.1 Authentication required Not sure what needs to be tweeked in sendmail.cf but I... (1 Reply)
Discussion started by: ziggy6
1 Replies

6. Solaris

Clarifying sendmail configuration - sendmail-client offline

Hi all, I have read about sendmail running as 2 separate process. 1 as a MSP, and the other as the real daemon or MTA. In my current configuration, the sendmail-client is disabled. Both submit.cf and sendmail.cf are left as default untouch I do not specified any mailhost... (3 Replies)
Discussion started by: javanoob
3 Replies
SENSIBLE-MDA(8) 					      System Manager's Manual						   SENSIBLE-MDA(8)

NAME
sensible-mda - a generic local MDA router for Debian systems SYNOPSIS
sensible-mda from to detail client-addr DESCRIPTION
sensible-mda is used to simplify the installation and configuration of sendmail(8) , or other MTAs for use on Debian systems. With sensi- ble-mda, sendmail can support a plethora of MDAs (procmail, maildrop, deliver, etc.) without having pick any one of them as required. FUNCTION
sensible-mda is called by sendmail as a local mailer when the following exists in sendmail.mc: define(`LOCAL_MAILER_ARGS', `sensible-mda $g $u $h ${client_addr}')dnl sensible-mda will look for the following MDAs (in this order), and pass the mail on to the first SUID MDA found (Or first found MDA, if run w/euid=root): procmail(1), maildrop(1), deliver(8), mail.local(8) OPTIONS
Available command line options are the following: from The sender of this email (sendmail $g variable) to The recipient of this email (sendmail $u variable) detail The detail portion of the recipient userid (sendmail $h variable) - ie: cowboy+sendmail@debian.org client-addr TCP/IP address of the sender (sendmail ${client_addr} variable) Not used (for the nonce) FILES
/etc/mail/sendmail.mc sendmail m4 input to generate sendmail.cf /etc/mail/sendmail.cf actual sendmail configuration file (treated as a binary file) SEE ALSO
sendmail(8), procmail(1), maildrop(1), deliver(8), mail.local(8) BUGS
None known so far. AUTHOR
Richard Nelson <cowboy@debian.org> HISTORY
4th Berkeley Distribution October 21 1999 SENSIBLE-MDA(8)
All times are GMT -4. The time now is 02:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy