Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution] HelpDesk For osCommerce


Recommended Posts

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

Link to comment
Share on other sites

  • Replies 130
  • Created
  • Last Reply

Top Posters In This Topic

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

Link to comment
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 />

Link to comment
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."

Link to comment
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.

Link to comment
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

Link to comment
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

Link to comment
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

Link to comment
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

Link to comment
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

Link to comment
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.

Link to comment
Share on other sites

  • 2 weeks later...

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

Link to comment
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.

Link to comment
Share on other sites

  • 4 weeks later...

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

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
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.

Link to comment
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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...