Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sendmail+MySQL
Top Forums UNIX for Advanced & Expert Users Sendmail+MySQL Post 9041 by eNTer on Monday 22nd of October 2001 04:21:19 AM
Old 10-22-2001
Re: Sendmail+MySQL
You could replace sendmail with qmail, and there is a patch which allows you to store the messages in a mysql database. Just go to http://iain.cx/unix/qmail/mysql.php and see what's the story about :-) If you're using FreeBSD just go to /usr/ports/mail/qmail-mysql and do a make install

Quote:
Originally posted by CGrusden19
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

LEARN ABOUT LINUX

ndb_drop_table

NDB_DROP_TABLE(1)					       MySQL Database System						 NDB_DROP_TABLE(1)

NAME

       ndb_drop_table - drop an NDB table

SYNOPSIS

       ndb_drop_table options

DESCRIPTION

       ndb_drop_table drops the specified NDB table. (If you try to use this on a table created with a storage engine other than NDB, the attempt
       fails with the error 723: No such table exists.) This operation is extremely fast; in some cases, it can be an order of magnitude faster
       than using a MySQL DROP TABLE statement on an NDB table.
	       Usage

	   ndb_drop_table -c connect_string tbl_name -d db_name

       The following table includes options that are specific to ndb_drop_table. Additional descriptions follow the table. For options common to
       most MySQL Cluster programs (including ndb_drop_table), see Options Common to MySQL Cluster Programs(1).

       Table 17.19. ndb_drop_table Options and Variables: MySQL Cluster NDB 7.2
       +--------------------------+-----------------------------------+-------------------------------------+
       |Format			  | Description 		      | Added / Removed 		    |
       +--------------------------+-----------------------------------+-------------------------------------+
       |			  | Name of the database in which the | 				    |
       |       --database=dbname, | table is found		      |        All MySQL 5.5 based releases |
       |			  |				      | 				    |
       |       -d		  |				      | 				    |
       +--------------------------+-----------------------------------+-------------------------------------+

COPYRIGHT

       Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
       published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

SEE ALSO

       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
       at http://dev.mysql.com/doc/.

AUTHOR

       Oracle Corporation (http://dev.mysql.com/).

MySQL 5.5							    01/30/2014							 NDB_DROP_TABLE(1)
All times are GMT -4. The time now is 09:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy