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
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 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
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
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
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
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
LEARN ABOUT OSF1
mailstats
mailstats(8) System Manager's Manual mailstats(8)
NAME
mailstats - Displays statistics about mail traffic
SYNOPSIS
mailstats [-o] [-C cffile [-f stfile]
FLAGS
Do not display the name of the mailer in the output. Use cffile as the name of the sendmail "cf" file instead of /var/adm/sendmail/send-
mail.cf. Use stfile as the input statistics file instead of /var/adm/sendmail/sendmail.st.
DESCRIPTION
The mailstats command reads the information in the /var/adm/sendmail/sendmail.st file (or in the file specified with the -f flag), formats
it, and writes it to standard output. Note also that you can change the location of the sendmail.st file by editing its pathname in the
sendmail.cf file.
EXAMPLES
The format of the information is shown in the following example, in which the first field (M) contains a number that indicates the position
of that mailer in the sendmail.cf file, starting at 0 (zero). For example, the first mailer in the sendmail.cf file corresponds to the
number 0 in the mailstats display, the second mailer corresponds to the number 1, and so on. Statistics from Thu Feb 17 11:20:01 2000 M
msgsfr bytes_from msgsto bytes_to msgsrej msgsdis Mailer 1 50 77K 1 3K 0 0 local 6
43 59K 58 99K 0 0 smtp ============================================================ T 93
136K 59 102K 0 0 The fields in the report have the following meanings: Indicates the position of the mailer in
the sendmail.cf file. Indicates the number of messages received by the local machine from the indicated mailer. Indicates the number of
bytes in the messages received by the local machine from the indicated mailer. Indicates the number of messages sent from the local
machine using the indicated mailer. Indicates the number of bytes in the messages sent from the local machine using the indicated mailer.
Indicates the number of rejected messages. Indicates the number of discarded messages. Indicates the name of the mailer.
If sendmail transmits mail directly to a file, such as the dead.letter file or an alias target, the message and byte counts are credited to
the prog mailer, as defined in the sendmail.cf file. However, mailstats will still default to var/adm/sendmail/sendmail.st.
FILES
Specifies the command path Contains system statistics Contains configuration information for sendmail
RELATED INFORMATION
Commands: sendmail(8) delim off
mailstats(8)