Mantis integration

[CasN]

I have Mantis integrated with dotproject version 2.01. Could use some people to test this further. So if you are interested, drop me a note www.nuy.info.

Here is how it works :
How to install this Integration between Dotproject and Mantis ?

Versions tested:
Dotproject 2.01
Mantis 1.0.1

There is support for different databases.

1. Copy the contents of this package into the root of your Dotproject installation.
There are 2 files being overwriiten :
modules/projects/view.php
modules/tasks/view.php
In these files only one Tab is added, nothing else.

2. Copy docs/mantis/index_dp.php into the root of your mantis installation

3. Add the contents of docs/mantis/config.txt to includes/config.php (inside your Dotproject installation)
4. Now adjust those settings to your environment, the settings are described in config.txt
5. Go !!!!!!!!!

How does it work ?
Within DP, you will find a Tab called Mantis when looking at Projects or Tasks.
For each DP project, a Mantis project will be created when the first issue is added.
Depending on your settings (see point 4), this module can create sub-projects for Tasks.
Default behavior is to show all issues under one project.

Projects in Mantis are created with a special name :
1. Prefix as defined in cinfig.php
2. DP-project-id
3. dot
4. DP-task-id
5. Space
6. DP-project-name
if set to project/sub_project:
7. <->
8. DP-task-name

On the tab all issues related to the project/task will be shown with the following information:
1. Issue-id in Mantis
2. Date-Time reported
3. Reporter of issue
4. Status
5. Summary
6. Description
The summary actually is a hyperlink which takes you straight into Mantis to maintain the issue.

There is also a button which allows you to add an issue to the project/task. All you need to fill in is the Summary and the description. Upon saving the issue is stored in Mantis.
The current DP-user is checked by username in Mantis. If this person does not exist, a user record is created in Mantis.
An email for direct access to Mantis with the password will be send to this user (if configured).
The current project/task is checked and if it does not yet exists, it will be created.
For the issue the following items are recorded :
1. Project-id
2. Reporter-id
3. Summary
4. Description
5. Date-submitted
6. Date-last-updated
All other activity is left within Mantis.


ToDo:
1. Verifying other password encryptions than just PLAIN

[Karen]

Cas

Lovely to see you here - I've been very grateful in the past for many of your Postnuke integrations (which I know you've moved away from). Thank you for this effort, I'll certainly have a look for you as soon as we're done with this next dp release.

KarenC

[CasN]

Karen,

still doing some PostNuke (cant get dplink to work with 2.01 though), my biggest constraint is time.
I made this connection because we might be able to use this in our offices.
Version 0.1 is ready, this works without sub-projects.
I will provide a link so one can download the little module.

It still is an initial piece of work but it does the basic stuff, lot's of room for improvement. I have been trying to find something like this but apparently there was just not enough time available to get it up and running. I do recognize this as a possible issue.

Cas

[CasN]

You can download it here:
http://casnuy.com/pn761/index.php?name=CmodsDownload&file=index&req=getit&lid=16

[CasN]

I have updated this integration(version 0.2) such that it does not need any changes to standard DP files. Comes with a standard setup and is more compliant with the DP framework.
Download available at:
http://casnuy.com/pn761/index.php?name=CmodsDownload&file=index&req=getit&lid=19

Cas

[carlitocabana]

Hello
I got the CVS of DotProject.
I got your newest Mantis zip file.
I extracted the content to the DP folder.
I installed the Mantis module succesfull and it is visible in DP (and project tab).
But when i click on Mantis i get :

Table 'dotproject._project_table' doesn't exist

[CasN]

Well you must have missed the docs:

How to install this Integration between Dotproject and Mantis ?

Versions tested:
Dotproject 2.01
Mantis 1.0.1

There is support for different databases.

1. Copy the contents of this package into the root of your Dotproject installation.

2. Copy docs/mantis/index_dp.php into the root of your mantis installation

3. Add the contents of docs/mantis/config.txt to includes/config.php (inside your Dotproject installation)

4. Now adjust those settings to your environment, the settings are described in config.txt

5. Go !!!!!!!!!


Cas

[petermilburn]

Looks great yet another thing to put into Dotproject. I work for a school in Sydney and we are using it for projects, helpdesk inventory, we have just moved our dev team onto Mantis. Like just gets better.


Not sure if this is a feature, but it does not matter which project I move to in dotproject, but on the mantis tab, I am getting every issue that was been entered.

Is this correct or am I doing something wrong. Woudl have thought mantis tab in Dotporject would only show issues related to that project.

Some good news. I am trying to get Management to donate upto 2K to dotproject.

Keep up the GREAT work.

[CasN]

There are 2 points to access Mantis issues.
1. Through the menu if you have made the option visible.
This will show all issues related to Dotproject projects. It will look for all mantis projects that start with the defined prefix (standard set to 'DP').

2. Through the tab once within a project.
This will show only those issues related to that project. So it will select all issues of the project in Mantis that starts with the prefix+projectnumber.

I assume you talk about the second option. I have tested this once again and it shows up correct on my site.
In case I misunderstood, just let me know.

Cas

[vreuer]

Hi,
I started using dp and mantis, too, and we have the same problem. Once within a project ALL issues/bugs from mantis show regardless of the project.

What kind of information do you need?

Regards
veit

[CasN]

Can I see this somewhere ? I have not yet been able to reproduce this.

Casr

[petermilburn]

Hi The last post is more what I was wanting to say.

If you have a project with no link to mantis you will see every issue created from DB into Mantis.

It is only when you create a isse for a project that you then only see the issues related to that project.



Pete M

[softwareadmin]

I have set $dPconfig['mantis_set'] = 1; as specified in the docs:

// Issues registered from within DP are logged in Mantis as:
// project/task == Project/subproject (1)
// all issues => project (2)

but still only have a mantis tab for projects. Shouldn't setting this option add a mantis tab to the tasks as well; or am I misunderstanding the docs?

Thanks again for this integration, btw. after fighting with ticketsmith for a while, this a great solution!

[CasN]

This feature is not yet activated (thought i mentioned this in the docs, apparently it got lost somewhere).
It was bringing some issues and I wanted to make it more compliant with DP framework before continuing.
If the community sees this a big advantage, I will try to add it properly.

Cas

[CasN]

Yes, there is a bug. I have reproduced it and willl fix it also.
As soon as done, will post it here.

Cas

[CasN]

This was a simple one.
I will adjust the download but for those who need it now, here is what you need to do.
Open index.php (modules/mantis) with your editor and navigate to line 102.
You should find the following code:

// retrieve the issue header/detail/user
if ($idprj !=0) {

This needs to be changed to:

// retrieve the issue header/detail/user
if ($idprj !=0 or $project_id>0){


That should do the trick.
Cas

[softwareadmin]

Thank you for the quick response. I saw the 'not yet implemented' comment in the v0.1 notes, but since it wasnt in the v0.2 notes I was afraid I might be missing something simple. And thanks again for this module; its an incredibly useful enhancement to DP for software development projects.

[petermilburn]

Thanks for the post. I made the change and is working perfectly.


Thanks,


Pete M

[petermilburn]

Can I ask when this will work with 2.0.2. Or what I need to do to make it work with 2.0.2

Thanks,

Pete M

[CasN]

Have downloaded a fresh version of DotProject version 2.0.2 and loaded the latest version from my Mantis module (version 0.3 available on my website www.nuy.info) and it seems to work fine.
If you have problems, can you please be more precise ?

Cas

[alexj]

Hello.

We've installed, mantis 1, dp 2.0.2, and dp_mantis 0.3. Everything seems to work OK, but I don't understand what can I do with it except seeing/creating project bugs directly in dp?

Is it possible to associate project tasks with mantis bugs, add working hours to mantis bugs or something else?

Thanks

[CasN]

That is exactly what it does for now. It will create a project within mantis and allow you to post bugs inside mantis directly from DP.
Perhaps in future the functionality can be extended.

cas

[benbbh]

Hello,

That sounds great, I've just quick and dirty installed the module and I'll look what I need to add next week.

Thanks a lot for that great work.

Ben

[feown]

I have used you tool and it works fine. Login to DP and Mantis is through LDAP and when I try to open link (summary) I get the error that the user in Mantis already exists. If I understood it correctly you use your file index_dp.php to make connection to Mantis. Why doesn't the file index_dp.php does not just make a link to mantis/view.php?id=1 for example? And why don't I see the name of the project the indicated error belongs to?

[CasN]

I have not tested this using ldap so I am afraid this is the problem here.
I do not have a solution yet but if i find it, will post it heer.

Cas

[CasN]

I have updated the Dotproject-Mantis module, based upon the request on one of the current users.
Now added the functionality to control the mantis project names yourself in stead of allocating a projectname automatically. The automatic option is till available.
It is relative simple but here are the highlights:
Creation of Projects in mantis can be automatic or by using a custom field within DotProject

In case defined as automatic, Projects in Mantis will be created with a special name as available in previous versions.
In case defined as Custom, Projects in Mantis will be created as follows :
1. First of all, a one time action, a custom field needs to be created in DP on project level.
2. This field needs to be called "Mantis" and type should be TEXT.
Now you have an additional field in your project definition where you can define the project name for Mantis.
If the system is configured to "Custom" and no Mantis name is provided, the system will assume the same name for the project within DP and mantis.
Be aware that the setting is NOT case sensitive.

Please read the docs for additional info.

You can download this module at my home site (http://casnuy.com/pn761/index.php?name=CmodsDownload&file=index&req=getit&lid=24).

Hope you can use it.

Cas

[CasN]

Unfortunately have to report a small bug, discovered in the field.
For those who downloaded version 0.4, please download version 0.4b.

Other option is to adjust addissue.php.
At line 57 the code reads:

$query3="select value_charvalue from custom_fields_values,custom_fields_struct where value_object_id=$idproj and value_field_id=field_id and field_name='Mantis' ";
$result3 = mysql_query( $query3 )or die(mysql_error());


Please change this to :


// connect to the DP database
db_connect( $dPconfig['dbhost'], $dPconfig['dbname'],$dPconfig['dbuser'], $dPconfig['dbpass'], $dPconfig['dbpersist'] );

$query3="select value_charvalue from custom_fields_values,custom_fields_struct where value_object_id=$idproj and value_field_id=field_id and field_name='Mantis' ";
$result3 = mysql_query( $query3 )or die(mysql_error());

// (re)connect to the Mantis DB
db_connect( $dPconfig['mantis_dbhost'], $dPconfig['mantis_dbname'],$dPconfig['mantis_dbuser'], $dPconfig['mantis_dbpass'], $dPconfig['dbpersist']);



Cas

[caseydk]

Hey, do you have a demo of this one available?

We released ours recently too: http://blogs.caseysoftware.com/?q=node/223

[CasN]

No, I have no demo. This one is safe to install since there are no modifications to either Dotproject (other than adding a module) or Mantis (other than adding a script).
In the latest version you even can control the link between the 2 applications yourself using a simple Customfield.

I noticed in the past that there was your development but decided not to wait since I was aiming for a simple integration.

I also noticed that you are selling your integration which makes another difference. Not that I object, it is just a difference + I suppose you offer a full support package.
Feel free to try mine and use parts you like. Equally like to hear your comments.

Cas

[cclingen]

CasN,

I just downloaded your dp-mantis04b.zip and tried to install it. I noticed a bug in the /docs/mantis/config.txt. When you copy in the config.txt into the /includes/config.php, there is an entry:

$dPconfig['mantis_link'] = 'C';

But, the /modules/mantis/index.php is looking for mantislink.

I also noticed that the image does not display. It seems that when you specify the image in /modules/mantis/index.php, it looks for the images in /images

$titleBlock = new CTitleBlock( 'Mantis', 'mantis_logo_button.gif', $m, "$m.$a" )

[caseydk]

There's always room for multiple implementations. After all, competition is good for all of us. ;)

My intention is to release it back GPL in a few months, just as I did with the MS Project Importer last year. Until the actual release happens, we provide support, bug fixes, updates, etc, etc.

[scorgatelli]

I just installed dp-mantis04 with dotProject 2.03 and mantis 1.0.3. I can view issues in dp ok but I can't create new issues. Here are the errors that I receive:


Table 'mantis.custom_fields_values' doesn't exist

ERROR: /home/httpd/dotproject-2.0.3/classes/query.class.php(696): query failed(SELECT count(*) as row_count FROM ((`sessions`)) WHERE session_id = '4960c96993f779604c767814a04f7253') - error was: Table 'mantis.sessions' doesn't exist
Backtrace:
0 /home/httpd/dotproject-2.0.3/classes/query.class.php:696 ...
1 /home/httpd/dotproject-2.0.3/includes/session.php:73 exec() ...

ERROR: /home/httpd/dotproject-2.0.3/classes/query.class.php(696): query failed(INSERT INTO `sessions`(`session_id`,`session_data`,`session_cr eated`) values ...
0 /home/httpd/dotproject-2.0.3/classes/query.class.php:696 ...
1 /home/httpd/dotproject-2.0.3/includes/session.php:86 exec() ...


A few other points:

It would be nice if the global list showed the issues even if the custom project name is being used.
Some filtering in the dotProject mantis pages would be useful.
I know this is on your todo, but being able to validate non-plain passwords is critical, IMHO. My install of mantis is using blowfish I believe.


I don't mean to sound negative. Great work so far.

Thanks for your efforts,

Shane

[diegov]

Hi,
Congratulations, very nice mod.

I installed it here, not error at all, I can create new issues, they go into Mantis, but I don't get they listed in dP, even in the Project tab or the "general" module view. Any idea?

The same problem happen when I tried the Eventum module. Coincidence? :P Seams like dP are not being able to query to tables at the same time. I already updated query.class.php, tried both new and old version, no joy.

Thanks,
DiegoV

[CasN]

Scorgatelli
This problem is described already and fixed in version 04b.
Please download or adjust addisue.php as described on page 3 of this topic.

As for the global list, this would also show non-dotproject related issues so may not always be the best option. Will see if it can be configurable.
Filtering is not on the list, the password issue will be fixed.

Diegov,
I have not heard about this problem before, did you activate it properly ?
can this be seen somewhere on the net ?

Cas

[Vince]

Hello All,

First : Thank you for your help & good, excellent work

Integrate Mantis in this project is a good idea

I read all the posts and docs and I don't find solution

When I click on Projects, I have :
- Icon Mantis
- Add issue
and .. nothing else !

All my projects are deseapere
I tried to check configuration but I didn't find where I forgot to change parameter

Can You help me please ?

Vince.

[diegov]

Hi Cas,

Seams Vince have the same problem.

I've setup an internet instalation so you can see the problem online. This instalation is absolutely different from the internal one, as it is in a web hosting company. I'd say that it should be something, as the environment is very different.

You can access it in http://www.dotproject.com.br/demo/
Default user and password.
Mantis is instaled in the same place, under /mantis
Again, default user and password.

The instalation was normal, for both dP and Mantis, installed with their wizards. After, the mantis module was unpacked inside /modules, the configuration was added to config.php (bellow) and index_dp.php was copied into mantis root directory. Module instalation and activation happened with no problem. The creation of an issue doesn't generate any error, the issue is seem as Mantis, it just don't appear in dP view, as you will be able to check.

Thank you very much.
DiegoV.


<?php
### Copyright (c) 2004, The dotProject Development Team dotproject.net and sf.net/projects/dotproject ###
### All rights reserved. Released under GPL License. For further Information see LICENSE ###

### CONFIGURATION FILE AUTOMATICALLY GENERATED BY THE DOTPROJECT INSTALLER ###
### FOR INFORMATION ON MANUAL CONFIGURATION AND FOR DOCUMENTATION SEE ./includes/config-dist.php ###

$dPconfig['dbtype'] = 'mysql';
$dPconfig['dbhost'] = 'localhost';
$dPconfig['dbname'] = '...';
$dPconfig['dbuser'] = '...';
$dPconfig['dbpass'] = '...';
$dPconfig['dbpersist'] = false;
$dPconfig['root_dir'] = $baseDir;
$dPconfig['base_url'] = $baseUrl;

// Is mantis link active ?

$dPconfig['mantis'] = ON;

// Autmatic or by Custom field (A/C)
$dPconfig['mantis_link'] = 'A';

// Prefix for Mantis projects in case of Automatic
// Naming convention for DPprojects:
// Prefix + DP projectid
$dPconfig['mantis_dp_pref'] = 'DP';

// Users:
// Copy users if not exist (1)
// Use defined user (2)
$dPconfig['mantis_usertype'] = 1;
$dPconfig['mantis_defuser'] = 'Administrator';
$dPconfig['mantis_role'] = 'DEVELOPER';
$dPconfig['mantis_mail'] = ON;

// Users:
// Role to log issues
$dPconfig['dp_role'] = 'DEVELOPER';

//
// Connectionstrings for Mantis
// see config_inc.php within your mantis installation
//
$dPconfig['mantis_dbtype'] = "mysql";
$dPconfig['mantis_dbhost'] = "localhost";
$dPconfig['mantis_dbname'] = "...";
$dPconfig['mantis_dbuser'] = "...";
$dPconfig['mantis_dbpass'] = "...";

// Prefix for your mantis tables
$dPconfig['mantis_prefix'] = "mantis" ;

//
// How is mantis password encryption setup
// see config_inc.php or config_inc_defaults.php within your mantis installation
//
$dPconfig['mantis_login'] = PLAIN ;

// where is Mantis installed, just need the relative path without thrailing slash
$dPconfig['mantis_path'] = "/mantis" ;

?>


Ps: Just in case, the domain dotproject.com.br is gonna be the place for dP comunity in Brasil. No commercial interest. My internal application is for the Brazilian Government.

[Vince]

Hello DiegoV,

Enjoy to see that I'm not alone....

I tried to see your demo but default user & password don't run.

Vince.

[Vince]

The situation has moved !

I kept the index.php of Dp in modules/project & modules/task
and it runs now
I have just put mantis's modules without index.php

So :
I have mantis's tab in view of project and Add issue run perfectly

but... :
Is it normal to have just Add issue and nothing else
Dp doesn't show me the list on the tab..

Thanks for your help
Vince.

[diegov]

Hey Vince,

Now I've got your problem, was not really the same as mine (well, now it is). You have put the dp-mantis files inside modules/project and /tasks, what is not correct. You should put them inside a folder you create, called /modules/mantis, and them install mantis module. The other folders you don't touch. The ADD feature is running well, as I reported, the problem is exactly that issues are not being listed.

Regards,
DiegoV

[CasN]

Diegov and Vince,

i noticed this behavior on the test site where I could login with the deafult userids/passwords.
I also can confirm that the add-issue is working without any problem but that the issues are not listed.
I will try to replay this with a fresh install of Dotproject and Mantis.
What is the platform you are runnig this on, windows or Linux ?

cas

[Vince]

Hello CasN & DiegoV,

Thanks for your help and answer

My platform is Windows

I changed my configuration and did that DiegoV explained
and now I have this message :

Warning: CTabBox::require(L:\ZMWS\_web.zmwsc\dotproject/modules/projects/projects_tab.mantis.php) [function.CTabBox-require]: failed to open stream: No such file or directory in L:\ZMWS\_web.zmwsc\dotproject\style\default\overri des.php on line 83

Fatal error: CTabBox::require() [function.require]: Failed opening required 'L:\ZMWS\_web.zmwsc\dotproject/modules/projects/projects_tab.mantis.php' (include_path='.;C:\php5\pear') in L:\ZMWS\_web.zmwsc\dotproject\style\default\overri des.php on line 83


Yesterday, it run good expect the list on the mantis's tab ( not a big problem )
Now, I have no icon "add issue" + error message in mantis' s tab.


Vince

[Vince]

Again Me !

I logout, restart my sever and tried again

It's crasy !

In /modules, I created a folder mantis , so I have /modules/mantis with all files

( What do you say by "install" the module ? )

I login, I have no mantis's tab, well !

I put also files in modules/tasks and I have it but again without liste
It's not a problem to put files in modules/tasks if it runs

Another problem :
In Addissue, I have an error's page when I click "Cancel"

Vince

[diegov]

Cas,

Thanks again for your time. Both of my instalations are Linux RedHat, up to date.

If I can give you any aditional information, please ask.


Vince,

You need to enter in System Admin > View Modules. Locate the Mantis module and install it clicking "install" and after that active the module clicking on "disabled" (to change that status). Don't forget to put index_dp.php inside Mantis root dir.

Thanks,
DiegoV

[CasN]

Diegov,
I have installed DP 2.0.4 and found no problems.
Possibly Mantis 1.03 is an issue (i am running 1.01).
Will now create a fresh install of Mantis and return here after testing.

Cas

[CasN]

After installing Mantis 1.03 found the issue to be in the addissue.php
Around line 40 you will find :

$prefix = dPgetConfig( 'mantis_dp_pref') ;
$mantisprefix = dPgetConfig( 'mantis_prefix') ;
$mantis_bug_table = $mantisprefix ;

This should be

$prefix = dPgetConfig( 'mantis_dp_pref') ;
$mantisprefix = dPgetConfig( 'mantis_prefix') ;
$mantislink = dPgetConfig( 'mantis_link') ;
$mantis_bug_table = $mantisprefix ;


After changing this, you will see it works as expected.

cas

[diegov]

Cas,

Just to give a feedback, it is working now.

Thank you,
Diego Viegas

[LeTic]

Hey CasN

Thanks a lot for your mantis module it is much appreciated believe me :)

I have been using it since your first release and I never had a single issue with it except the fact that I couldn't open bugs that contains apostrophe " ' " either in the summary field or in the descrption.

I don't know if my issue is due to my configuration :
Debian Sarge up to date
Apache 2.0
PHP 5 (I know it is not supported and it may be where my issue is coming from)
Mantis 0.19.2-5
DotProject 2.0.4

I don't know if you can reproduce it with php4 but anyway I made a quick and dirty patch (below) pending to know if it is PHP version specific to make a better one.

Hope this help
Thanks again for your work and do not hesitate to ask if you need some help with your project, I may find *a bit* of time to get involve ;)

Cheers
LeTic

Update : Typos

--- addissue.php 2006-07-04 00:34:06.000000000 +0100
+++ fixed_addissue.php 2006-07-04 00:30:41.000000000 +0100
@@ -105,7 +105,8 @@
}

}



- // insert the issue

+ // insert the issue
+ $issue_summary = str_replace("'", "''", $issue_summary);

$add3 = "insert into $mantis_bug_table (project_id, reporter_id, summary,date_submitted,last_updated) values('$idprj','$iduser','$issue_summary', NOW(),NOW())";

$adding3 = mysql_query( $add3 )or die(mysql_error());

$idbug = mysql_insert_id();

@@ -114,7 +115,8 @@
$updat1 = "update $mantis_bug_table set bug_text_id='$idbug' where id='$idbug'";

$updating1 = mysql_query( $updat1 )or die(mysql_error());



- // insert the text

+ // insert the text
+ $issue_description = str_replace("'", "''", $issue_description);

$add4 = "insert into $mantis_bug_text_table (id, description) values('$idbug','$issue_description')";

$adding4 = mysql_query( $add4 )or die(mysql_error());

[Vince]

Hello CasN,

Thanks for your help, it runs perfectly

Thanks again

Vince.

[CasN]

LeTic,
thanks for the suggestion.
Will include this in the next version.

Good to hear all is working ok now.

Cas

[fedevela]

CasN,

The links on page 3 seem to be broken.:confused:

Where can i download the dp_mantis module?:mrgreen:

Thanks.

[LeTic]

It is indeed broken :(

I don't know if Cas is having issue with his server... I know I had some issues in the past to reach his site where it was sending error about quota exceeded.

I can send it to you by email if you want :) PM me.

[CasN]

Yes i have some problems with the domain name (had it through Hosting insiders and that does not work very well).
Please visit http://nuy.info for the download.

Cas

[LeTic]

By the way CasN,

I discovered that the patch I sent you for the apostrophes issue was indeed a bit dodgy (as I thought :) ) . You have to add a test if magic_quotes_gpc is enabled as it will automatigically add the double apostrophe.

Concerning LDAP I investigate a bit the issue that was reported before as I switch my server to LDAP recently.

The error is : APPLICATION ERROR #800
That username is already being used. Please go back and select another one.

And occurs when you're trying to recreate the user when it already exist. I have to look at your code to find why it's trying to re-create it when it already exist... I will send you a patch if I manage to solve it.

Cheers
LeTic

[lvalics]

casnuy.com/pn761/index.php?name=CmodsDownload&file=index&req=getit& lid=19


this link not work, anyone know a working link?

[PHPycho]

I had installed the mantis integration files...but its not working...
i had kept the files as stated and configured as stated
Following are the configuration i made:
(Note: I had installed xampp in C:\Program files\xampp\
-dotProject is installed in C:\Program files\xampp\htdocs\dotproject\
-mantis is installed in C:\Program files\xampp\htdocs\mantis\
)
1>In mantis_config.php
<?php

// Change this to the path to PHPXMLRPC client.php
require_once("C:/Program Files/xampp/htdocs/XMLRPC/PHPXMLRPC/client.php");

// Mantis username and password
$mantis_user = "administrator";
$mantis_pass = "root";

// Your domain
$domain = "http://localhost";

// The web path to the mantis_xmlrpc folder. Make sure you include the end slash
$web_path_to_mantis_xmlrpc = "http://localhost/mantis/mantis_xmlrpc/";
?>

2> In mantishelper.php
# Change this path to point to the Mantis installation core.php file
require_once('C:/Program Files/xampp/htdocs/mantis/core.php');
3> In mantiserver.php
# Change this to point to the PHPXMLRPC server.php
require_once("C:/Program Files/xampp/htdocs/XMLRPC/PHPXMLRPC/server.php");

And finally installed the mantis module from the dotproject and mantis link appeared and when clicked gave the following errors:
Error: [5] Connect error: Unable to find the socket transport "http" - did you forget to enable it when you configured PHP? (1958060647) at client.php:115

I am unable to figure out the problem ?? Anybody there who can help me ?
Thanks in advance to all of you !!

[execute]

Please, have a little patience for a better Mantis Integration Module.

The company ( mgtraining.com (http://mgtraining.com) )I am working for has adopted dP and I am the main (and only) developer to customize it to suit best our needs.

We are going to release back to the community everything we do around dP, when the time comes.
And one of thess things is a Mantis Integration, which was at the beginning this very module here. But we were totally disappointed from its behavior, so I was given the task to change it.

So, please wait two or tree weeks and we will be, hopefully, releasing it.

[lvalics]

// Your domain
$domain = "http://localhost";

// The web path to the mantis_xmlrpc folder. Make sure you include the end slash
$web_path_to_mantis_xmlrpc = "http://localhost/mantis/mantis_xmlrpc/";
?>



$domain = "localhost";

$web_path_to_mantis_xmlrpc = "/mantis/mantis_xmlrpc/";

try like this.

[PHPycho]

Thanks Mr. lvalics
the problem mentioned above got solved and it says

This project was not found in Mantis.
create the project in mantis
What are the furthur modifications that i need to have a complete integration..

Extras:
Suppose if i upload to the server with domain www.xyz.com then the localhost should be "xyz" right ?

I want to know further..what things can we do by integrating mantis..
a few questions?
1>can we insert into the mantis database from the dotproject or just we can do the view only or what , i have no idea

thanks in advance !!

[glynnsmith]

I have modified my installation to do the following:


Allow for issues to be created within dotproject
Automatically link projects in Mantis / Dotproject if a value is entered in custom field of if the name is the same. If not, it will create a project on the mantis side.
Allows for tasks to be created within project referencing the issue (do same thing for risks as well)
Allow issues to be viewed within dotproject, including tabs for viewing notes, adding notes, and list of created tasks from issue.
Also added a "hack" to the task view page to link to issue / risk based on the values in custom fields (A reference ID and type)


I plan on sharing what I have done but I have not yet cleaned it up (i.e. making sure I use variables from config everywhere, etc). However, I am currently in the middle of a project that has me working well into my free time so it hasn't happened yet.

I am planning on going back and working to clean them up and update this module (and a couple others that I have built) to work with the new version of Mantis and Dotproject second week of April.

However, Execute is likely to finish something long before that...

[PHPycho]

Hello forums !!
I was using the dotproject mantis integration module that uses a XML-RPC which was bit tedious work and didnt suit my requirement. I struggle for nothing with this one. Later i looked at this forum and get a link for dp-mantis04b.zip.
I didnt get much into this but i found it useful..
I successfully installed this module..
It works Ok for the existing user but when a new user is created and when that new user logins and try to submit report then the errors occurs and server shutdowns


Duplicate entry '' for key 2
ERROR: C:\Program Files\xampp\htdocs\dotproject\classes\query.class. php(654): query failed(SELECT count(*) as row_count FROM ( `sessions` ) WHERE session_id = '5a4c37a7a61839e35edb8a09ab4e94f9') - error was: Table 'mantis.sessions' doesn't exist
Backtrace:
0 C:\Program Files\xampp\htdocs\dotproject\classes\query.class. php:654 dprint('C:\\Program Files\\xampp\\htdocs\\dotproject\\classes\\query.c lass.php',654,0,'query failed(SELECT count(*) as row_count FROM ( `sessions` ) WHERE session_id = \'5a4c37a7a61839e35edb8a09ab4e94f9\') - error was: Table \'mantis.sessions\' doesn\'t exist')
1 C:\Program Files\xampp\htdocs\dotproject\includes\session.php :79 exec()
2 : dPsessionWrite('5a4c37a7a61839e35edb8a09ab4e94f9', 'AppUI|O:6:"CAppUI":23:{s:5:"state";a:11:{s:13:"CalIdxCompany";s:1:"0";s:12:"CalIdxFilter";s:2:"my";s:13:"CalDayViewTab";s:1:"1";s:14:"TaskDayShowArc";i:0;s:14:"TaskDayShowLow";i:1;s:15:"TaskDayShowHold";i:0;s:14:"TaskDayShowDyn";i:0;s:14:"TaskDayShowPin";i:0;s:20:"TaskDayShowEmptyDate";i:0;s:12:"SAVEDPLACE-1";N;s:10:"SAVEDPLACE";s:8:"m=mantis";}s:7:"user_id";s:2:"13";s:15:"user_first_name";s:4:"user";s:14:"user_last_name";s:6:"name 7";s:12:"user_company";s:1:"0";s:15:"user_department";i:0;s:10:"user_email";s:17:"user7@hotmail.com";s:9:"user_type";s:1:"7";s:10:"user_prefs";a:12:{s:6:"LOCALE";s:5:"en_AU";s:7:"TABVIEW";s:1:"0";s:12:"SHDATEFORMAT";s:8:"%d/%m/%Y";s:10:"TIMEFORMAT";s:8:"%I:%M %p";s:7:"UISTYLE";s:7:"default";s:13:"TASKASSIGNMAX";s:3:"100";s:12:"CURRENCYFORM";s:5:"en_AU";s:11:"EVENTFILTER";s:2:"my";s:7:"MAILALL";s:1:"0";s:12:"TASKLOGEMAIL";s:1:"7";s:11:"TASKLOGSUBJ";s:21:"HWB-Projectmanagement";s:11:"TASKLOGNOTE";s:1:"0";}s:12:"day_selected";N;s:11:"user_locale";s:2:"en";s:9:"user_lang";a:4:{i:0;s:11:"en_AU.utf-8";i:1;s:3:"ena";i:2;s:5:"en_AU";i:3;s:2:"en";}s:11:"base_locale";s:2:"en";s:3:"msg";s:0:"";s:5:"msgNo";i:0;s:15:"defaultRedirect";s:0:"";s:3:"cfg";a:1:{s:11:"locale_warn";b:0;}s:13:"version_major";i:2;s:13:"version_minor";i:1;s:13:"version_patch";N;s:14:"version_string";s:7:"2.1-rc1";s:14:"last_insert_id";s:3:"128";s:10:"project_id";i:0;}LANGUAGES|a:7:{s:5:"en_AU";a:4:{i:0;s:2:"en";i:1;s:13:"English (Aus)";i:2;s:13:"English (Aus)";i:3;s:3:"ena";}s:5:"en_CA";a:4:{i:0;s:2:"en";i:1;s:13:"English (Can)";i:2;s:13:"English (Can)";i:3;s:3:"enc";}s:5:"en_GB";a:4:{i:0;s:2:"en";i:1;s:12:"English (GB)";i:2;s:12:"English (GB)";i:3;s:3:"eng";}s:5:"en_NZ";a:4:{i:0;s:2:"en";i:1;s:12:"English (NZ)";i:2;s:12:"English (NZ)";i:3;s:3:"enz";}s:5:"en_US";a:5:{i:0;s:2:"en";i:1;s:12:"English (US)";i:2;s:12:"English (US)";i:3;s:3:"enu";i:4;s:10:"ISO8859-15";}s:5:"nl_BE";a:4:{i:0;s:2:"nl";i:1;s:10:"Dutch (BE)";i:2;s:10:"Dutch (BE)";i:3;s:3:"nlb";}s:5:"nl_NL";a:4:{i:0;s:2:"nl";i:1;s:10:"Dutch (NL)";i:2;s:10:"Dutch (NL)";i:3;s:3:"nld";}}all_tabs|a:3:{s:8:"calendar";a:0:{}s:6:"mantis";a:0:{}s:0:"";a:0:{}}')

ERROR: C:\Program Files\xampp\htdocs\dotproject\classes\query.class. php(654): query failed(INSERT INTO `sessions`(`session_id`,`session_data`,`session_cr eated`) values ('5a4c37a7a61839e35edb8a09ab4e94f9','AppUI|O:6:\"CAppUI\":23:{s:5:\"state\";a:11:{s:13:\"CalIdxCompany\";s:1:\"0\";s:12:\"CalIdxFilter\";s:2:\"my\";s:13:\"CalDayViewTab\";s:1:\"1\";s:14:\"TaskDayShowArc\";i:0;s:14:\"TaskDayShowLow\";i:1;s:15:\"TaskDayShowHold\";i:0;s:14:\"TaskDayShowDyn\";i:0;s:14:\"TaskDayShowPin\";i:0;s:20:\"TaskDayShowEmptyDate\";i:0;s:12:\"SAVEDPLACE-1\";N;s:10:\"SAVEDPLACE\";s:8:\"m=mantis\";}s:7:\"user_id\";s:2:\"13\";s:15:\"user_first_name\";s:4:\"user\";s:14:\"user_last_name\";s:6:\"name 7\";s:12:\"user_company\";s:1:\"0\";s:15:\"user_department\";i:0;s:10:\"user_email\";s:17:\"user7@hotmail.com\";s:9:\"user_type\";s:1:\"7\";s:10:\"user_prefs\";a:12:{s:6:\"LOCALE\";s:5:\"en_AU\";s:7:\"TABVIEW\";s:1:\"0\";s:12:\"SHDATEFORMAT\";s:8:\"%d/%m/%Y\";s:10:\"TIMEFORMAT\";s:8:\"%I:%M %p\";s:7:\"UISTYLE\";s:7:\"default\";s:13:\"TASKASSIGNMAX\";s:3:\"100\";s:12:\"CURRENCYFORM\";s:5:\"en_AU\";s:11:\"EVENTFILTER\";s:2:\"my\";s:7:\"MAILALL\";s:1:\"0\";s:12:\"TASKLOGEMAIL\";s:1:\"7\";s:11:\"TASKLOGSUBJ\";s:21:\"HWB-Projectmanagement\";s:11:\"TASKLOGNOTE\";s:1:\"0\";}s:12:\"day_selected\";N;s:11:\"user_locale\";s:2:\"en\";s:9:\"user_lang\";a:4:{i:0;s:11:\"en_AU.utf-8\";i:1;s:3:\"ena\";i:2;s:5:\"en_AU\";i:3;s:2:\"en\";}s:11:\"base_locale\";s:2:\"en\";s:3:\"msg\";s:0:\"\";s:5:\"msgNo\";i:0;s:15:\"defaultRedirect\";s:0:\"\";s:3:\"cfg\";a:1:{s:11:\"locale_warn\";b:0;}s:13:\"version_major\";i:2;s:13:\"version_minor\";i:1;s:13:\"version_patch\";N;s:14:\"version_string\";s:7:\"2.1-rc1\";s:14:\"last_insert_id\";s:3:\"128\";s:10:\"project_id\";i:0;}LANGUAGES|a:7:{s:5:\"en_AU\";a:4:{i:0;s:2:\"en\";i:1;s:13:\"English (Aus)\";i:2;s:13:\"English (Aus)\";i:3;s:3:\"ena\";}s:5:\"en_CA\";a:4:{i:0;s:2:\"en\";i:1;s:13:\"English (Can)\";i:2;s:13:\"English (Can)\";i:3;s:3:\"enc\";}s:5:\"en_GB\";a:4:{i:0;s:2:\"en\";i:1;s:12:\"English (GB)\";i:2;s:12:\"English (GB)\";i:3;s:3:\"eng\";}s:5:\"en_NZ\";a:4:{i:0;s:2:\"en\";i:1;s:12:\"English (NZ)\";i:2;s:12:\"English (NZ)\";i:3;s:3:\"enz\";}s:5:\"en_US\";a:5:{i:0;s:2:\"en\";i:1;s:12:\"English (US)\";i:2;s:12:\"English (US)\";i:3;s:3:\"enu\";i:4;s:10:\"ISO8859-15\";}s:5:\"nl_BE\";a:4:{i:0;s:2:\"nl\";i:1;s:10:\"Dutch (BE)\";i:2;s:10:\"Dutch (BE)\";i:3;s:3:\"nlb\";}s:5:\"nl_NL\";a:4:{i:0;s:2:\"nl\";i:1;s:10:\"Dutch (NL)\";i:2;s:10:\"Dutch (NL)\";i:3;s:3:\"nld\";}}all_tabs|a:3:{s:8:\"calendar\";a:0:{}s:6:\"mantis\";a:0:{}s:0:\"\";a:0:{}}','2007-03-29 10:00:09')) - error was: Table 'mantis.sessions' doesn't exist
Backtrace:
0 C:\Program Files\xampp\htdocs\dotproject\classes\query.class. php:654 dprint('C:\\Program Files\\xampp\\htdocs\\dotproject\\classes\\query.c lass.php',654,0,'query failed(INSERT INTO `sessions`(`session_id`,`session_data`,`session_cr eated`) values (\'5a4c37a7a61839e35edb8a09ab4e94f9\',\'AppUI|O:6: \\"CAppUI\\":23:{s:5:\\"state\\";a:11:{s:13:\\"CalIdxCompany\\";s:1:\\"0\\";s:12:\\"CalIdxFilter\\";s:2:\\"my\\";s:13:\\"CalDayViewTab\\";s:1:\\"1\\";s:14:\\"TaskDayShowArc\\";i:0;s:14:\\"TaskDayShowLow\\";i:1;s:15:\\"TaskDayShowHold\\";i:0;s:14:\\"TaskDayShowDyn\\";i:0;s:14:\\"TaskDayShowPin\\";i:0;s:20:\\"TaskDayShowEmptyDate\\";i:0;s:12:\\"SAVEDPLACE-1\\";N;s:10:\\"SAVEDPLACE\\";s:8:\\"m=mantis\\";}s:7:\\"user_id\\";s:2:\\"13\\";s:15:\\"user_first_name\\";s:4:\\"user\\";s:14:\\"user_last_name\\";s:6:\\"name 7\\";s:12:\\"user_company\\";s:1:\\"0\\";s:15:\\"user_department\\";i:0;s:10:\\"user_email\\";s:17:\\"user7@hotmail.com\\";s:9:\\"user_type\\";s:1:\\"7\\";s:10:\\"user_prefs\\";a:12:{s:6:\\"LOCALE\\";s:5:\\"en_AU\\";s:7:\\"TABVIEW\\";s:1:\\"0\\";s:12:\\"SHDATEFORMAT\\";s:8:\\"%d/%m/%Y\\";s:10:\\"TIMEFORMAT\\";s:8:\\"%I:%M %p\\";s:7:\\"UISTYLE\\";s:7:\\"default\\";s:13:\\"TASKASSIGNMAX\\";s:3:\\"100\\";s:12:\\"CURRENCYFORM\\";s:5:\\"en_AU\\";s:11:\\"EVENTFILTER\\";s:2:\\"my\\";s:7:\\"MAILALL\\";s:1:\\"0\\";s:12:\\"TASKLOGEMAIL\\";s:1:\\"7\\";s:11:\\"TASKLOGSUBJ\\";s:21:\\"HWB-Projectmanagement\\";s:11:\\"TASKLOGNOTE\\";s:1:\\"0\\";}s:12:\\"day_selected\\";N;s:11:\\"user_locale\\";s:2:\\"en\\";s:9:\\"user_lang\\";a:4:{i:0;s:11:\\"en_AU.utf-8\\";i:1;s:3:\\"ena\\";i:2;s:5:\\"en_AU\\";i:3;s:2:\\"en\\";}s:11:\\"base_locale\\";s:2:\\"en\\";s:3:\\"msg\\";s:0:\\"\\";s:5:\\"msgNo\\";i:0;s:15:\\"defaultRedirect\\";s:0:\\"\\";s:3:\\"cfg\\";a:1:{s:11:\\"locale_warn\\";b:0;}s:13:\\"version_major\\";i:2;s:13:\\"version_minor\\";i:1;s:13:\\"version_patch\\";N;s:14:\\"version_string\\";s:7:\\"2.1-rc1\\";s:14:\\"last_insert_id\\";s:3:\\"128\\";s:10:\\"project_id\\";i:0;}LANGUAGES|a:7:{s:5:\\"en_AU\\";a:4:{i:0;s:2:\\"en\\";i:1;s:13:\\"English (Aus)\\";i:2;s:13:\\"English (Aus)\\";i:3;s:3:\\"ena\\";}s:5:\\"en_CA\\";a:4:{i:0;s:2:\\"en\\";i:1;s:13:\\"English (Can)\\";i:2;s:13:\\"English (Can)\\";i:3;s:3:\\"enc\\";}s:5:\\"en_GB\\";a:4:{i:0;s:2:\\"en\\";i:1;s:12:\\"English (GB)\\";i:2;s:12:\\"English (GB)\\";i:3;s:3:\\"eng\\";}s:5:\\"en_NZ\\";a:4:{i:0;s:2:\\"en\\";i:1;s:12:\\"English (NZ)\\";i:2;s:12:\\"English (NZ)\\";i:3;s:3:\\"enz\\";}s:5:\\"en_US\\";a:5:{i:0;s:2:\\"en\\";i:1;s:12:\\"English (US)\\";i:2;s:12:\\"English (US)\\";i:3;s:3:\\"enu\\";i:4;s:10:\\"ISO8859-15\\";}s:5:\\"nl_BE\\";a:4:{i:0;s:2:\\"nl\\";i:1;s:10:\\"Dutch (BE)\\";i:2;s:10:\\"Dutch (BE)\\";i:3;s:3:\\"nlb\\";}s:5:\\"nl_NL\\";a:4:{i:0;s:2:\\"nl\\";i:1;s:10:\\"Dutch (NL)\\";i:2;s:10:\\"Dutch (NL)\\";i:3;s:3:\\"nld\\";}}all_tabs|a:3:{s:8:\\"calendar\\";a:0:{}s:6:\\"mantis\\";a:0:{}s:0:\\"\\";a:0:{}}\',\'2007-03-29 10:00:09\')) - error was: Table \'mantis.sessions\' doesn\'t exist')
1 C:\Program Files\xampp\htdocs\dotproject\includes\session.php :94 exec()
2 : dPsessionWrite('5a4c37a7a61839e35edb8a09ab4e94f9', 'AppUI|O:6:"CAppUI":23:{s:5:"state";a:11:{s:13:"CalIdxCompany";s:1:"0";s:12:"

i am not getting the solution
Please Help..
Thanks in advance to all of you

[furlongm]

I'm also interested in this plugin.

glynnsmith, execute, are there any updates on either of your code-changes? If you can post even rough patches or a tar.gz somewhere, maybe more of us can hack on them and help you to get them into shape?

Letic, for the LDAP authentication error, I bypassed the authentication stuff in index_dp.php if I find out it's LDAP authentication.

Add the following 5 lines to index_dp.php (the ones with the +'s):

require_once( 'core.php' );

+if ($g_login_method == "4") //LDAP
+{
+ print_header_redirect( 'view.php?id='.$f_id.'' );
+}else{

$t_user_table = config_get( 'mantis_user_table' );
$f_perm_login='false';

// YADA YADA

+}
?>

It then just redirects to bug number in mantis. If you are already logged in then it's fine, if not, then it redirects to the login page (which will redirect to bug number page when you log in correctly).

[execute]

Look here http://www.dotproject.net/vbulletin/showthread.php?t=6765

[rubenpais]

Hello,

I'm trying to integrate Mantis with DotProyect but when I import a task always appears the XML error: Undeclared entity warning at line 28, column 8Error: [2] Invalid return payload: enable debugging to examine incoming payload (XML error: Undeclared entity warning at line 28, column 8) at client.php:124.

I tested modules dotproject.mantis.integration_2010.8.13.zip and mantis.integration_20070418.zip and the version of Mantis to 1.2.2 and also upgrade the libraries and xmlrpc.inc xmlrpcs.inc

Any ideas?

Thanks!

[petr.gajdusek]

Hello.

I use mantis 1.2.3. and dotproject.mantis.integration_2010.8.13.zip with updated xmlrpc libraries, I had same problem.
I changed getMantisBugById() function in mantis/xmlrpc/dotproject/dphelper.php to


function getMantisBugById( $bug_id ) {
$bug = bug_get($bug_id);
$bug_extra = addExtraBugData($bug);
return $bug_extra;
}


Hope this will help you.

Petr Gajdůšek