RE: Using MySQL to store email
I believe this is close to what I am needing. Thank you for your time and detail. My thank you to everyone else for their comments. Thanks, Jeff On Thu, 2003-02-27 at 12:13, Vikash K Agarwal wrote: We have used procmail and PHP combination to achieve this for our department mail management and associated workflow. Sendmail invokes procmail which delivers the mail to the normal inbox and invokes a PHP script thru LYNX The PHP script opens an IMAP connection to the inbox, reads the mail and puts in a text data col in the database. This is working successfully for all our 5 departments and over 500-1000 mails a day. Except for big attachments where we have respective limitations (to some extent configurable - maxpacketsize options etc) in PHP as well as MYSQL. vikash -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 12:47 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Using MySQL to store email First, which MYSQL, the program or the company. Assuming you mean a mysql database I think you will need to run it through a program which will parse it and load it into the database tables. Does anyone know where I can read more on how to redirect incoming email (via Sendmail) into MySQL for a given email address? I understand that I can use [EMAIL PROTECTED] | /path/mysql ... in the /etc/aliases file to do this, but I would like to see if anyone has had success with this. I also would like to know if this is not as simple as I may think. Thanks for any thoughts on this, Jeff William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using MySQL to store email
Does anyone know where I can read more on how to redirect incoming email (via Sendmail) into MySQL for a given email address? I understand that I can use [EMAIL PROTECTED] | /path/mysql ... in the /etc/aliases file to do this, but I would like to see if anyone has had success with this. I also would like to know if this is not as simple as I may think. Thanks for any thoughts on this, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INSERT to table from text file
Hello, I'm looking for a solution to INSERT data from a text file that is used for logging into a MySQL table. A hypothetical example... I have a server (any server, could be a RADIUS, a DNS or a MTA) that logs to a file in /var/logs/log-file. Is there a way to take the raw data sent to the log file and INSERT it into a table? Can this be done on the fly, meaning, the data isn't stored in the flat text file at all, but rather the service sends the data to the log file and instead of being written to the file, it's sent to a table. Does this sound like a job for Perl/DBI/DBD? Thanks for any in site or comments, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Install trouble on FreeBSD4.2
I'm seeing this error when installing mysql-server-3.23.32 on FreeBSD4.2. I understand the name resolution issue, however I don't believe this has anything to do with the grant tables failing. This is a binary install from ftp.freebsd.org. Should I consider "rolling my own" from a tar-ball? Would it make any difference? Any help would be great, Thanks! ---SNIP extract: /usr/local/share/mysql/swedish/errmsg.txt extract: execute '/usr/local/bin/mysql_install_db' /usr/libexec/ld-elf.so.1: Shared object "libc_r.so.5" not found WARNING: The host 'noc1' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables /usr/libexec/ld-elf.so.1: Shared object "libc_r.so.5" not found Installation of grant tables failed! ---SNIP -- Jeff Neuffer Jr. Data Services Technician North State Telephone This mail was processed by Mail essentials for Exchange/SMTP, the email security management gateway. Mail essentials adds content checking, email encryption, anti spam, anti virus, attachment compression, personalised auto responders, archiving and more to your Microsoft Exchange Server or SMTP mail server. For more information visit http://www.mailessentials.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php