Guest Posted January 12, 2003 Share Posted January 12, 2003 For all of those people who are stuck with having to use python or perl, I am going to be creating a script in python to perform the mail2db functions. I'll post here again when I have a beta ready for testing, and then I'll hopefully be able to contribute it (maybe even in the same package set). Quote Link to comment Share on other sites More sharing options...
CC Posted January 12, 2003 Share Posted January 12, 2003 Nice one Will That would be perfect. Make sure yo add paypal options too. No doubt many will want to say thanks with a little contribution. CC. Quote Link to comment Share on other sites More sharing options...
tails2k Posted January 12, 2003 Share Posted January 12, 2003 hey has anyone set this up with exim? I've been trying to get the messages to show up but they dont... here is the line I have configured in my alias file.. I've also setup a .forward for the mail box and there isnt any luck yet... support: sales, |/usr/lib/cgi-bin/php4 -q /var/www/TESTSITE/osc_mail2db.php config=/var/www/TESTISTE/admin/includes/configure.php and for the .foward |/usr/lib/cgi-bin/php4 -q /var/www/TESTSITE/osc_mail2db.php config=/var/www/TESTISTE/admin/includes/configure.php nothing into the DB, with the .forward setup it just goes off to la la land with nothing being done... (not poiting back to save the mail) message returned to me from the cron: 2003-01-12 14:53:02 18XpwG-0004uL-00 Neither the system_aliases director nor the +address_pipe transport set a uid for local delivery of |/usr/lib/cgi-bin/php4 +-q /var/www/TESTSITE/osc_mail2db.php +config=/var/www/TESTISTE/admin/includes/configure.php Quote Link to comment Share on other sites More sharing options...
tails2k Posted January 12, 2003 Share Posted January 12, 2003 hey has anyone set this up with exim? I've been trying to get the messages to show up but they dont... here is the line I have configured in my alias file.. I've also setup a .forward for the mail box and there isnt any luck yet... support: sales, |/usr/lib/cgi-bin/php4 -q /var/www/TESTSITE/osc_mail2db.php config=/var/www/TESTISTE/admin/includes/configure.php and for the .foward |/usr/lib/cgi-bin/php4 -q /var/www/TESTSITE/osc_mail2db.php config=/var/www/TESTISTE/admin/includes/configure.php nothing into the DB, with the .forward setup it just goes off to la la land with nothing being done... (not poiting back to save the mail) message returned to me from the cron: 2003-01-12 14:53:02 18XpwG-0004uL-00 Neither the system_aliases director nor the +address_pipe transport set a uid for local delivery of |/usr/lib/cgi-bin/php4 +-q /var/www/TESTSITE/osc_mail2db.php +config=/var/www/TESTISTE/admin/includes/configure.php Ok looks like ive got a bit further, correct my typo in the directory name... I get a bounce back that looks like this ------ pipe to |/usr/lib/cgi-bin/php4 -q /var/www/TESTSITE/osc_mail2db.php +config=/var/www/TESTSITE/admin/includes/configure.php generated by care@mysite ------ <br /> <b>Fatal error</b>: Call to undefined function: mysql_connect() in +<b>/var/www/TESTSITE/osc_mail2db.php</b> on line <b>95</b><br /> ------ pipe to |/usr/lib/cgi-bin/php4 -q /var/www/TESTSITE/osc_mail2db.php +config=/var/www/TESTSITE/admin/includes/configure.php generated by sales@mysite (ultimately generated from care@mysite) ------ <br /> <b>Fatal error</b>: Call to undefined function: mysql_connect() in +<b>/var/www/TESTSITE/osc_mail2db.php</b> on line <b>95</b><br /> Quote Link to comment Share on other sites More sharing options...
celtic Posted January 13, 2003 Share Posted January 13, 2003 has anyone got it to work with cPanel? the piping of the info to the database. Quote Link to comment Share on other sites More sharing options...
TB Posted January 13, 2003 Share Posted January 13, 2003 This is a great mod, as expressed by many... though it's so dman difficult to install. I haven't been reading too many posts saying 'Yippee! I've got it working too!' I think I'm speak on behalf on many when I talk about the problems with regards to getting the e-mail accounts working with the database. I know my personal problems are that no incoming e-mails from contacts page are entered into the database, though they are sent to the respective accounts listed under each department. As for the incoming e-mails that are to be picked up by the mail2db... I'm running cPanel, and the solution provided I think will interfere with my existing e-mail that I receive on some of those accounts. If ANYONE has been able to get this working can they please post the 'trials and tribulations' they've experienced with their different server configurations so so we can all learn, and enjoy this great mod. Many thanks to those that have already offered their setup information and many thanks in advance to those that respond to this plea... Tony Quote "The price of success is perseverance. The price of failure comes much cheaper." Link to comment Share on other sites More sharing options...
CC Posted January 13, 2003 Share Posted January 13, 2003 Dude I am still working on it, however I have not made it a priority at the mo. I think it will be one of those left till last. As long as the email keeps coming thru to us by email direct from the contact page, it will have to do for now. But your right, not too many success stories as yet! CC. Quote Link to comment Share on other sites More sharing options...
Clement Posted January 14, 2003 Share Posted January 14, 2003 Maybe someone can make a little mod for this mod.. For those who can't set-up such aliases or don't know how yet, it is a better solution that contact_us.php file to send the email AND put in the DB the message, too. Thank you, Clement Quote Link to comment Share on other sites More sharing options...
Harald Ponce de Leon Posted January 14, 2003 Author Share Posted January 14, 2003 Ok looks like ive got a bit further, correct my typo in the directory name... I get a bounce back that looks like this ------ pipe to |/usr/lib/cgi-bin/php4 -q /var/www/TESTSITE/osc_mail2db.php +config=/var/www/TESTSITE/admin/includes/configure.php generated by care@mysite ------ <br /> <b>Fatal error</b>: Call to undefined function: mysql_connect() in +<b>/var/www/TESTSITE/osc_mail2db.php</b> on line <b>95</b><br /> ------ pipe to |/usr/lib/cgi-bin/php4 -q /var/www/TESTSITE/osc_mail2db.php +config=/var/www/TESTSITE/admin/includes/configure.php generated by sales@mysite (ultimately generated from care@mysite) ------ <br /> <b>Fatal error</b>: Call to undefined function: mysql_connect() in +<b>/var/www/TESTSITE/osc_mail2db.php</b> on line <b>95</b><br /> Please tell me you've read that message :D I've marked the important text in bold. Your PHP binary does not include MySQL functionality. It needs to be compiled again. Quote , osCommerce Link to comment Share on other sites More sharing options...
tails2k Posted January 14, 2003 Share Posted January 14, 2003 *reads the line* :oops: hah I did read it and I knew there was a problem there.. but wasnt 100% sure, I guess I'll see what I can do for this... thanks for the response. Quote Link to comment Share on other sites More sharing options...
tails2k Posted January 14, 2003 Share Posted January 14, 2003 Ok looks like ive got a bit further, correct my typo in the directory name... I get a bounce back that looks like this ------ pipe to |/usr/lib/cgi-bin/php4 -q /var/www/TESTSITE/osc_mail2db.php +config=/var/www/TESTSITE/admin/includes/configure.php generated by care@mysite ------ <br /> <b>Fatal error</b>: Call to undefined function: mysql_connect() in +<b>/var/www/TESTSITE/osc_mail2db.php</b> on line <b>95</b><br /> ------ pipe to |/usr/lib/cgi-bin/php4 -q /var/www/TESTSITE/osc_mail2db.php +config=/var/www/TESTSITE/admin/includes/configure.php generated by sales@mysite (ultimately generated from care@mysite) ------ <br /> <b>Fatal error</b>: Call to undefined function: mysql_connect() in +<b>/var/www/TESTSITE/osc_mail2db.php</b> on line <b>95</b><br /> Please tell me you've read that message :D I've marked the important text in bold. Your PHP binary does not include MySQL functionality. It needs to be compiled again. Allright, got that fixed... now I get this error! This message was created automatically by mail delivery software (Exim). A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed: pipe to |php3 -q /var/www/TESTSITE/osc_mail2db.php config=/var/www/TESTSITE/admin/includes/configure.php generated by care@mydomain The following text was generated during the delivery attempt: ------ pipe to |php3 -q /var/www/TESTSITE/osc_mail2db.php config=/var/www/TESTSITE/admin/includes/configure.php generated by care@mydomain ------ <br> <b>Parse error</b>: parse error in <b>/var/www/TESTSITE/admin/includes/classes/mime_decode.php</b> on line <b>209</b><br> ------ This is a copy of the message, including all the headers. ------ Return-path: <tails@mydomain> Received: from tails by mydomain with local (Exim 3.36 #1 (Debian)) id 18YW4j-0006AQ-00 for <care@mydomain>; Tue, 14 Jan 2003 11:46:13 -0700 To: care@mydomain Subject: hi there Message-Id: <E18YW4j-0006AQ-00@mydomain> From: tails <tails@mydomain> Date: Tue, 14 Jan 2003 11:46:13 -0700 hi Quote Link to comment Share on other sites More sharing options...
Harald Ponce de Leon Posted January 14, 2003 Author Share Posted January 14, 2003 This message was created automatically by mail delivery software (Exim). A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed: pipe to |php3 -q /var/www/TESTSITE/osc_mail2db.php config=/var/www/TESTSITE/admin/includes/configure.php generated by care@mydomain <<snip>> You should try the php4 binary :) The mime_decode.php script is not php3 compatible. Just for your information, the mime_decode.php script depended on Pear - I removed that dependency as it was only using Pear for its logging capabilities, so it works without Pear. Quote , osCommerce Link to comment Share on other sites More sharing options...
dwil Posted January 16, 2003 Share Posted January 16, 2003 there is a package called phpTickets that can get email from a POP server and dump it into the DB. Is there a possibility for ease of use, that this mod could use that idea, instead of forwarding? http://www.hotscripts.com/Detailed/12087.html Quote Link to comment Share on other sites More sharing options...
dreamscape Posted January 17, 2003 Share Posted January 17, 2003 has anyone got it to work with cPanel? the piping of the info to the database. yes I am on a cPanel run server and have gotten it to work great Quote The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
celtic Posted January 17, 2003 Share Posted January 17, 2003 yes I am on a cPanel run server and have gotten it to work great Could you elaborate on how you got it to work? The rest of us cPanel users would be grateful :) Quite a number of us don't quite get the piping the email to the database instructions bit. Quote Link to comment Share on other sites More sharing options...
Clement Posted January 18, 2003 Share Posted January 18, 2003 Yes, I'll be gratefull, too, for some CPanel details. Thank you, Quote Link to comment Share on other sites More sharing options...
Deskdirect Posted January 18, 2003 Share Posted January 18, 2003 I have a cpanel - what should I put in the forward as an email address? Ialos like to read the details of how you managed to get the mail working correctly. Thanks Quote Link to comment Share on other sites More sharing options...
dreamscape Posted February 2, 2003 Share Posted February 2, 2003 on Cpanel, in the mail manager, under forwarders is where it shows up. but if you try to put in there, it won't write to the file correctly b/c cpanel takes the spaces out. I have SSH access to the server my site is on. My host looked up the file and location of it to put the aliases into. So I just SSH into the server and add them in that way. Quote The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
Snowman Posted February 2, 2003 Share Posted February 2, 2003 You need to add a line to your valiases file which generally is only available to the admin of server with WHM/CPanel...especially if you are only a customer or a reseller. Just ask your servers admin or host support staff to add the line. Quote Link to comment Share on other sites More sharing options...
Guest Posted February 26, 2003 Share Posted February 26, 2003 Well.. I got it to work.. and it works perfectly!! One thing I will mention.. Don't confuse an alias with a POP box as I did. I was chatting to my most excellent sys admin at my host via MSN, he just added the following line to a hidden alias in my mailnames directory (whatever that means) sales: [email protected], "|/usr/bin/php -q /home/httpd/vhosts/mydomain.com/httpdocs/osc_mail2db.php config=/home/httpd/vhosts/mydomain.com/httpdocs/admin/includes/configure.php Im using sendmail Tracy Quote Link to comment Share on other sites More sharing options...
dreamscape Posted March 29, 2003 Share Posted March 29, 2003 hey harald is this helpdesk comatible with MS1?? I installed an MS1 store and can't get the osc_mail2db.php to work. it is being called, this I know, because I put a mail() in the very beginning of it to see if it was being called.... and it is... but its not puttin the emails in the database. I can get it to work on a november snapshot, but no luck on MS1 so far. any idea what may be causing problems with MS1? Quote The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
dreamscape Posted April 12, 2003 Share Posted April 12, 2003 nevermind, the problem was bug with cpanel. Quote The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
desi Posted April 13, 2003 Share Posted April 13, 2003 I just tried installing the addon, the admin side and the catalog sides look good, just whenever someone sends a enquiry through the catalog there is no ticket being made. In the install, it says I need to make a 'mail alias entry', where would i put this entry? Like there an example but don't know where to put it! I think this may be the problem. sales: [email protected], "|/usr/bin/php -q /home/httpd/vhosts/mydomain.com/httpdocs/osc_mail2db.php config=/home/httpd/vhosts/mydomain.com/httpdocs/admin/includes/configure.php Thanks in advance. Quote Link to comment Share on other sites More sharing options...
rfrangie Posted April 16, 2003 Share Posted April 16, 2003 Hey all, Well i've got it working, but a couple of queries as shown in the following process: 1. Customer sends an enquiry to you 2. Enquiry gets logged in DB and marked as unread 3. I reply to the enquiry 4. Customer replies to that reply via there mail program 5. Enquiry gets logged as a new ticket with a new ticket number????? Is there a way to fix this?? Thanks in Advance Ray. Quote Link to comment Share on other sites More sharing options...
erisen Posted April 20, 2003 Share Posted April 20, 2003 hey has anyone set this up with exim? I've been trying to get the messages to show up but they dont... here is the line I have configured in my alias file.. I've also setup a .forward for the mail box and there isnt any luck yet... support: sales, |/usr/lib/cgi-bin/php4 -q /var/www/TESTSITE/osc_mail2db.php config=/var/www/TESTISTE/admin/includes/configure.php and for the .foward |/usr/lib/cgi-bin/php4 -q /var/www/TESTSITE/osc_mail2db.php config=/var/www/TESTISTE/admin/includes/configure.php nothing into the DB, with the .forward setup it just goes off to la la land with nothing being done... (not poiting back to save the mail) message returned to me from the cron: 2003-01-12 14:53:02 18XpwG-0004uL-00 Neither the system_aliases director nor the +address_pipe transport set a uid for local delivery of |/usr/lib/cgi-bin/php4 +-q /var/www/TESTSITE/osc_mail2db.php +config=/var/www/TESTISTE/admin/includes/configure.php Hi, I just learned from my sysadmin that we were using sendmail/exim. :cry: he did not know where the file would be to write. Can you please give me a hint, where the alias and .forward files may be located. Thanks, Mehmet. Quote GALATASARAY RULES! ultrAslan - ultrAslan - ultrAslan Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.