2014-12-20 23:01 EST

View Issue Details Jump to Notes ] Wiki ]
IDProjectCategoryView StatusLast Update
0011770Plugin - EmailReporting[All Projects] Generalpublic2011-08-25 16:55
Assigned ToSL-Gundam 
PlatformWindowsOSWindows 2003 ServerOS Version2003 Server
Product Version 
Target VersionFixed in Version 
Summary0011770: Problem with plugin Email Reporting
DescriptionHi all,

I have recently installed Mantis plus the mentioned plugin, the whole configuration is:
 - system Windows 2003 Server
 - MySQL db version 5.1
 - Mantis 1.2.0
 - plugin Email reporting 0.7.9-DEV

The thing that is important to me is for all the users to be able to create issues in Mantis by sending email. I have installed and configured everything according to documenation and it works - well, most of the time: I have one problem I haven't been able to solve. The problem I need help with concerns automatization: everything works if I manually get emails from POP3 account to mantis using webserver, but it sometimes crashes when I try the other method - to schedule a job with php.exe running the script.

 - documentation says that you can either via webserver or via commandline with php.exe
 - via webserver you can do it manually just clicking "/plugins/EmailReporting/scripts/bug_report_mail.php" link or you can set up mantis to do it everytime someone visits the page
 - you can also create a batch with php.exe running the very same php script and schedule it as a reapating tasks
 - with simple mails all the methods above works
 - with some mails, html ones with mime content and footnote, the only method that works is to manually click link on the page; if you do so, the mail is parsed and the image from the footnote is treated as attachment and becomes properly a part of mantis issue; however if you don't do it manully but instead you choose the option that makes mantis webserver to do it triggered by the site visit you can see "SYSTEM WARNING: fsockopen() [function.fsockopen]: unable to connect to (Failed to parse address "")" on the screen; if leave the job to commandline job, you get:
C:\>c:\php\php.exe c:\Inetpub\wwwroot\mantis\plugins\EmailReporting\scripts\bug_
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.or [^]
        <link rel="stylesheet" type="text/css" href="C:/Inetpub/wwwroot/mantis/c
ss/default.css" />
        <script type="text/javascript" language="JavaScript"><!--
                if(document.layers) {document.write("<style>td{padding:0px;}<\/s
        // --></script>
        <meta http-equiv="Content-type" content="text/html; charset=utf-8" />
        <meta http-equiv="Pragma" content="no-cache" />
        <meta http-equiv="Cache-Control" content="no-cache" />
        <meta http-equiv="Pragma-directive" content="no-cache" />
        <meta http-equiv="Cache-Directive" content="no-cache" />
        <meta http-equiv="Expires" content="Thu, 08 Apr 2010 12:40:06 GMT" />
        <link rel="shortcut icon" href="C:/Inetpub/wwwroot/mantis/images/favicon
.ico" type="image/x-icon" />
        <link rel="search" type="application/opensearchdescription+xml" title="M
antisBT: Text Search" href="http://helpdesk.orbistravel.pl/browser_search_plugin [^]
.php?type=text" /> <link rel="search" type="application/opensearchdescripti
on+xml" title="MantisBT: Issue Id" href="http://helpdesk.orbistravel.pl/browser_ [^]
search_plugin.php?type=id" /> <title>MantisBT</title>
<script type="text/javascript" src="C:/Inetpub/wwwroot/mantis/javascript/min/com
<script language="javascript">var loading_lang = "Ładuję...";</script><script
type="text/javascript" src="C:/Inetpub/wwwroot/mantis/javascript/min/ajax.js"></
<div align="left"><a href="my_view_page.php"><img border="0" alt="Mantis Bug Tra
cker" src="C:/Inetpub/wwwroot/mantis/images/mantis_logo.gif" /></a></div>
div align="center"><table class="width50" cellspacing="1"><tr><td class="form-ti
tle">APPLICATION ERROR 0000401</td></tr><tr><td><p class="center" style="color:red"
>B┼é─ůd wykonania zapytania w bazie danych 1366 ÔÇô Incorrect string value: '\xB
3obuck...' for column 'description' at row 1 dla zapytania INSERT INTO mantis_bu

                                            ( description, steps_to_reproduce, a
dditional_information )


                                            ( ?,?,?).

</td></tr><tr><td><p cl
ass="center">Prosz─Ö u┼╝y─ç przycisku ÔÇ×WsteczÔÇŁ w przegl─ůdarce by powr├│ci─ç
 do poprzedniej strony. Tam mo┼╝na poprawi─ç to co spowodowa┼éo b┼é─ůd lub wybra
─ç inn─ů operacj─Ö. Mo┼╝na r├│wnie┼╝ klikn─ů─ç opcj─Ö w g├│rnym menu, aby przej┼
Ť─ç bezpo┼Ťrednio do innej sekcji.


plz hlp anybody because there is no info on the web...
TagsNo tags attached.
Attached Files
  • ? file icon config_defaults_inc.php (116,474 bytes) 2010-04-08 11:09
  • ? file icon config_inc.php (3,587 bytes) 2010-04-08 11:09 - 
    # MantisBT - a php based bugtracking system
    # MantisBT is free software: you can redistribute it and/or modify
    # it under the terms of the GNU General Public License as published by
    # the Free Software Foundation, either version 2 of the License, or
    # (at your option) any later version.
    # MantisBT is distributed in the hope that it will be useful,
    # but WITHOUT ANY WARRANTY; without even the implied warranty of
    # GNU General Public License for more details.
    # You should have received a copy of the GNU General Public License
    # along with MantisBT.  If not, see <http://www.gnu.org/licenses/>.
     * @package MantisBT
     * @copyright Copyright (C) 2000 - 2002  Kenzaburo Ito - kenito@300baud.org
     * @copyright Copyright (C) 2002 - 2010  MantisBT Team - mantisbt-dev@lists.sourceforge.net
     * @link http://www.mantisbt.org
    # This sample file contains the essential files that you MUST
    # configure to your specific settings.  You may override settings
    # from config_defaults_inc.php by assigning new values in this file
    # Rename this file to config_inc.php after configuration.
    # In general the value OFF means the feature is disabled and ON means the
    # feature is enabled.  Any other cases will have an explanation.
    # Look in http://www.mantisbt.org/docs/ or config_defaults_inc.php for more
    # detailed comments.
    # --- Database Configuration ---
    $g_hostname      = 'localhost';
    $g_db_username   = 'root';
    $g_db_password   = 'mysql2010';
    $g_database_name = 'bugtracker';
    $g_db_type       = 'mysql';
    # --- Anonymous Access / Signup ---
    $g_allow_signup				= ON;
    $g_allow_anonymous_login	= OFF;
    $g_anonymous_account		= '';
    # --- Email Configuration ---
    $g_smtp_host			= 'msg.orbistravel.pl';				# used with PHPMAILER_METHOD_SMTP
    $g_smtp_username		= 'mantis';					# used with PHPMAILER_METHOD_SMTP
    $g_smtp_password		= 'mantis2010';					# used with PHPMAILER_METHOD_SMTP
    $g_administrator_email  = 'helpdesk@orbistravel.pl';
    $g_webmaster_email      = 'helpdesk@orbistravel.pl';
    $g_from_name			= 'HelpDesk';
    $g_from_email           = 'helpdesk@orbistravel.pl';	# the "From: " field in emails
    $g_return_path_email    = 'helpdesk@orbistravel.pl';	# the return address for bounced mail
    $g_email_receive_own	= OFF;
    $g_email_send_using_cronjob = OFF;
    # --- Attachments / File Uploads ---
    $g_allow_file_upload	= ON;
    $g_file_upload_method	= DATABASE; # DISK or DATABASE
    #$g_absolute_path_default_upload_folder = 'C:\Inetpub\wwwroot\mantis\tmp\attachments'; # used with DISK, must contain trailing \ or /.
    $g_absolute_path_default_upload_folder = 'D:\Temp'; # used with DISK, must contain trailing \ or /.
    $g_max_file_size		= 5000000;	# in bytes
    $g_preview_attachments_inline_max_size = 0;
    $g_allowed_files		= '';		# extensions comma separated, e.g. 'php,html,java,exe,pl'
    $g_disallowed_files		= '';		# extensions comma separated
    #$g_mail_tmp_directory		= 'C:\Inetpub\wwwroot\mantis\tmp\mail';
    $g_mail_tmp_directory		= 'd:\Temp';
    # --- Branding ---
    $g_window_title			= 'MantisBT';
    $g_logo_image			= 'images/mantis_logo.gif';
    $g_favicon_image		= 'images/favicon.ico';
    # --- Real names ---
    $g_show_realname = OFF;
    $g_show_user_realname_threshold = NOBODY;	# Set to access level (e.g. VIEWER, REPORTER, DEVELOPER, MANAGER, etc)
    # --- Others ---
    $g_default_home_page = 'my_view_page.php';	# Set to name of page to go to after login
    ? file icon config_inc.php (3,587 bytes) 2010-04-08 11:09 + 
  • ? file icon php.ini (50,262 bytes) 2010-04-08 11:10

- Relationships
+ Relationships

-  Notes
User avatar


SL-Gundam (manager)

This "... or you can set up mantis to do it everytime someone visits the page" functionality has been removed in 0.8.0

Can you check whether this problem persists in newer version (0.8.4 is the latest atm)

See 0004286
User avatar


SL-Gundam (manager)

Assuming it has been fixed

Closing issue
+  Notes

- Issue History
Date Modified Username Field Change
2010-04-08 11:06 filmerkl New Issue
2010-04-08 11:09 filmerkl File Added: config_defaults_inc.php
2010-04-08 11:09 filmerkl File Added: config_inc.php
2010-04-08 11:10 filmerkl File Added: php.ini
2010-12-29 09:12 SL-Gundam Note Added: 0027749
2011-05-09 07:52 dhx Project mantisbt => Plugin - EmailReporting
2011-05-09 07:52 dhx Category email => General
2011-08-17 21:41 SL-Gundam Assigned To => SL-Gundam
2011-08-17 21:41 SL-Gundam Status new => assigned
2011-08-17 21:42 SL-Gundam Note Added: 0029500
2011-08-17 21:42 SL-Gundam Status assigned => resolved
2011-08-17 21:42 SL-Gundam Resolution open => fixed
2011-08-25 16:55 SL-Gundam Status resolved => closed
+ Issue History