Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sign in to follow this  
Harald Ponce de Leon

[Contribution] HelpDesk For osCommerce

Recommended Posts

Guest

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).

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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 />

Share this post


Link to post
Share on other sites

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


"The price of success is perseverance. The price of failure comes much cheaper."

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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.


:heart:, osCommerce

Share this post


Link to post
Share on other sites

*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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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.


:heart:, osCommerce

Share this post


Link to post
Share on other sites
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


The only thing necessary for evil to flourish is for good men to do nothing

- Edmund Burke

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.


The only thing necessary for evil to flourish is for good men to do nothing

- Edmund Burke

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
Guest

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: sales@mydomain.com, "|/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

Share this post


Link to post
Share on other sites

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?


The only thing necessary for evil to flourish is for good men to do nothing

- Edmund Burke

Share this post


Link to post
Share on other sites

nevermind, the problem was bug with cpanel.


The only thing necessary for evil to flourish is for good men to do nothing

- Edmund Burke

Share this post


Link to post
Share on other sites

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: sales@mydomain.com, "|/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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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.


GALATASARAY RULES!

ultrAslan - ultrAslan - ultrAslan

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×