edsiosis Posted January 5, 2003 Share Posted January 5, 2003 ok solved that part, dont know why i didnt twig before.... register_argc_argv = On Needs to be on in php.ini :P But....now i get this hehehe PHP Warning: Failed opening '/home/siosis/www.siosis.com/hns/admin/includes/classes/mime_decode.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/siosis.com/siosis/public_html/hns/osc_mail2db.php on line 93 Link to comment Share on other sites More sharing options...
edsiosis Posted January 5, 2003 Share Posted January 5, 2003 ok sorted that one now as well, whoops hehe. Now runs no problems, just doesnt route emails to the database still :( Link to comment Share on other sites More sharing options...
Harald Ponce de Leon Posted January 5, 2003 Share Posted January 5, 2003 ok sorted that one now as well, whoops hehe. Now runs no problems, just doesnt route emails to the database still :( Good catch with the php.ini parameter. Try now with just the backup email address, so that incoming emails are forwarded to another email account. If that works, then the osc_mail2db.php script should work - otherwise whatever your using might need to be configured to be able to execute scripts/programs in the aliases file. , osCommerce Link to comment Share on other sites More sharing options...
edsiosis Posted January 5, 2003 Share Posted January 5, 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 |/root/php -q /home/siosis.com/siosis/public_html/hns/osc_mail2db.php config=/home/siosis.com/siosis/public_html/hns/admin/includes/configure.php generated by sales@siosis.com The following text was generated during the delivery attempt: ------ pipe to |/root/php -q /home/siosis.com/siosis/public_html/hns/osc_mail2db.php config=/home/siosis.com/siosis/public_html/hns/admin/includes/configure.php generated by sales@siosis.com ------ PHP Notice: Undefined variable: argv in /home/siosis.com/siosis/public_html/hns/osc_mail2db.php on line 69 Its gone back to that shit again!!! it seems to be using a different php.ini file or something located somewhere else. It works fine from the shell, but when i try emailing it screws up. Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2003 Share Posted January 5, 2003 shell> which newaliases /usr/bin/newaliases shell> newaliases Harald can you be a bit more specific. I have never ran a query like this on my server or locally and don't know where tp put it and why/what its trying to achieve, if i know this i will understand a bit more. Thanks Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2003 Share Posted January 5, 2003 How can i get the ordinary email on my local working correctly? It replies with Warning: Server Error in e:phpdevwwwshopcatalogincludesclassesemail.php on line 502 Warning: Cannot add header information - headers already sent by (output started at e:phpdevwwwshopcatalogincludesclassesemail.php:502) in e:phpdevwwwshopcatalogincludesfunctionsgeneral.php on line 23 Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2003 Share Posted January 5, 2003 sorted.. didn't realise the email had to be set to smtp in config when on local, uses sendmail in web setting. Link to comment Share on other sites More sharing options...
TB Posted January 5, 2003 Share Posted January 5, 2003 I'd just like to say that I have absolutly no idea what's going on in this thread! I have SSL shell access if I need it... though wouldn't have a clue what to type after my username and password! HEY! Would you look at that, 'Exit' works! :shock: I think I'll just stick to that one command for now! :oops: I have installed the module, it sends the e-mail to the e-mail specified in the department settings (sales@domain.com)... though it doesn't add any {1234} ticket numbers to it and it also doesn't add it to the database. :? Any ideas on what I'm doing wrong? :roll: Also, what are the effects of integrating an active e-mail account, sales@domain.com is one I already use daily, and would like to use it with the HelpDesk also. Will osc_mail2db.php & sendmail (when I can finally work it out!) do any weird stuff like delete, remove, alter my normal e-mails? Good thread this one... very interesting... "The price of success is perseverance. The price of failure comes much cheaper." Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2003 Share Posted January 5, 2003 from install file A helpdesk feature contributed by Jim MacKay (TMH Corp), which is able to keeptrack of communication made via email. This work was made a while ago and may need to be slightly updated to work with the latest snapshot release. The email tracking capabilities requires the following: * php binary executable ("php" under unix, or "php.exe" under windows) * mail aliases entries (per department) The mail alias entry uses the php binary to execute the osc_mail2db.php script to parse the incoming email into the osCommerce database. If the osc_mail2db.php file needs to be changed to work under new snapshot conditions obviously there are going to be alot of problems and the same questions are going to be asked... is there any chance someone could post the file here to clear up what the setings should beand if poss tell me how to run a shell command on my server.... coz I ain't gota clue! Thanks in advance slightly baffled Richard :wink: Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2003 Share Posted January 5, 2003 I use cuteFTP to upload to my server and have full accesss to everything needed. I looked in the help file and it says I have already "Enable Right-Click Shell Integration", do i still have to run the shell command as previously said in this thread or ?? :?: still not sure where if so Link to comment Share on other sites More sharing options...
edsiosis Posted January 5, 2003 Share Posted January 5, 2003 just type "newaliases" at the shell. It takes the /etc/aliases file and turns it into a useable database for yiur MTA (mail transport agent". As you must be aware a database is much faster than retrivingfrom a file. Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2003 Share Posted January 5, 2003 just type "newaliases" at the shell back to basics i'm afraid... where's thew shell? Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2003 Share Posted January 5, 2003 just type "newaliases" at the shell back to basics i'm afraid... where's the shell? Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2003 Share Posted January 5, 2003 just type "newaliases" at the shell back to basics i'm afraid... where's the shell? Link to comment Share on other sites More sharing options...
edsiosis Posted January 5, 2003 Share Posted January 5, 2003 Ok i thought you considered yourself a "moderate" coder hehe :) The shell is the command line, ie. in windows terms "the dos prompt" :P Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2003 Share Posted January 5, 2003 Ok, fairpoint but i've never had to right a command before in a year on here, NO NEED! :D In cute FTP i just click on the file and it uploads. I just loaded my site to the web to try and make the settings on this easier and saw in the config three emails which I have now set for the support.. am i right in thinking you have to somehow activate these in the osc_mail2db.php script and copy the settings according to what i have just entered in the config to this ie. 'sales:sales@mydomain.com "| /shop/admin/includes/osc_mail2db.php config=/shop/admin/includes/configure.php"' . "nn"; Link to comment Share on other sites More sharing options...
edsiosis Posted January 5, 2003 Share Posted January 5, 2003 that made absolutely no sense what so ever lol Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2003 Share Posted January 5, 2003 what part... i'm making no sense of this... does it show! :cry: 'sales:sales@imageinteiors.com "| /shop/admin/includes/osc_mail2db.php config=/shop/admin/includes/configure.php"' . "nn"; do we add sales, tech, customer services etc. onto this row? Link to comment Share on other sites More sharing options...
edsiosis Posted January 5, 2003 Share Posted January 5, 2003 in what row of what file? you dont need to edit any files. Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2003 Share Posted January 5, 2003 In order to insert incoming emails into the database, a mail alias entry is neededto pass the email content to the osc_mail2db.php script. Each department the helpdesk has should have its own email address. Each address should be entered in the mail aliases file. An example mail alias entry for a "sales" department (email = sales@server.com) is: sales: a_backup@email_address.com, "|/path/to/php -q /path/to/osc_mail2db.php config=/path/to/admin/includes/configure.php" am i reading a different helpdesk contribution made by harald or what. :shock: Link to comment Share on other sites More sharing options...
edsiosis Posted January 5, 2003 Share Posted January 5, 2003 in the /etc/aliases or /etc/mail/aliases file what ever your system uses. You change the line you currently added sales: a_backup@email_address.com, "|/path/to/php -q /path/to/osc_mail2db.php config=/path/to/admin/includes/configure.php" To represent say instead of sales, customerservice@whatever.com Make sure you run newaliases again though. I suggest you just try to get it working without getting bogged down in the details just yet though. Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2003 Share Posted January 5, 2003 Right... the email is received ny my shop... HOORAY! is this correct in order for me to carry on! if not sure about the 'Example /etc/mail/aliases entry:' . "nn" . i presume i remove this? if ($config_file == false) { echo "n" . 'osCommerce 2.2 Mail2Database Script' . "n" . 'Copyright (c) 2002 osCommerce' . "nn" . 'Release under the GNU General Public License' . "nn" . 'Usage: osc_mail2db.php config=<http://www.imageinteriors.com/shop/admin/includes/>' . "nn" . 'The config file parameter is used to retrieve the database' . "n" . 'connection parameters.' . "nn" . 'Example /etc/mail/aliases entry:' . "nn" . 'sales:sales@imageinteiors.com "| /shop/admin/includes/osc_mail2db.php config=/shop/admin/includes/configure.php"' . "nn" . 'customerservices:customerservices@imageinteiors.com "| /shop/admin/includes/osc_mail2db.php config=/shop/admin/includes/configure.php"' . "nn" . 'technical:technical@imageinteiors.com "| /shop/admin/includes/osc_mail2db.php config=/shop/admin/includes/configure.php"' . "nn"; exit; } As you guys that HAVE got it working it doesn't add a ticket to the db. phew! Link to comment Share on other sites More sharing options...
Guest Posted January 5, 2003 Share Posted January 5, 2003 Right... the email is received ny my shop... HOORAY! is this correct in order for me to carry on! if not sure about the 'Example /etc/mail/aliases entry:' . "nn" . i presume i remove this? if ($config_file == false) { echo "n" . 'osCommerce 2.2 Mail2Database Script' . "n" . 'Copyright (c) 2002 osCommerce' . "nn" . 'Release under the GNU General Public License' . "nn" . 'Usage: osc_mail2db.php config=<http://www.mydomain.com/shop/admin/includes/>' . "nn" . 'The config file parameter is used to retrieve the database' . "n" . 'connection parameters.' . "nn" . 'Example /etc/mail/aliases entry:' . "nn" . 'sales:sales@mydomain.com "| /shop/admin/includes/osc_mail2db.php config=/shop/admin/includes/configure.php"' . "nn" . 'customerservices:customerservices@mydomain.com "| /shop/admin/includes/osc_mail2db.php config=/shop/admin/includes/configure.php"' . "nn" . 'technical:technical@mydomain.com "| /shop/admin/includes/osc_mail2db.php config=/shop/admin/includes/configure.php"' . "nn"; exit; } As you guys that HAVE got it working it doesn't add a ticket to the db. phew! Link to comment Share on other sites More sharing options...
edsiosis Posted January 5, 2003 Share Posted January 5, 2003 br /> <b>Fatal error</b>: Call to undefined function: parse_output() in <b>/home/siosis.com/siosis/public_html/hns/osc_mail2db.php</b> on line <b>40</b><br /> I receive this error, i am assuming its a problem with my php compile but not sure what exactly. Have never come across a parse_output error before. Any ideas? Link to comment Share on other sites More sharing options...
markthe5th@hotmail.com Posted January 5, 2003 Share Posted January 5, 2003 markthe5th@hotmail.com wrote: I ran that in my shell...and I got no errors.. So i can only guess that the script works fine? (am I correct in this assumption?) That's correct. markthe5th@hotmail.com wrote: the only other possiblity is that the emails are not being forwarded to the script properly.. Try forwarding the incoming email to another email account. I mean, following the contribution installation text, just use the backup email address to see if that part works. Harald - I did this part - it does forward the email to the other address.... So I can only guess that its not being sent to the script..or its not being sent to the script properly... gotto keep hacking away till I get it working... Mark (thanks by the way) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.