Mantis/Joomla! integration

[Krastek]

Hello!
I want to ask is it possible to integrate mantis with joomla in such way: mantis use user database (username, realname, mail, password) from joomla - I want to elimiante the neccesity of double-registering. Help!

[akede]

Hello!
I want to ask is it possible to integrate mantis with joomla in such way: mantis use user database (username, realname, mail, password) from joomla - I want to elimiante the neccesity of double-registering. Help!

Which version of Joomla! are u using?

On the 1.5 series it should be absolutly no problem as both system support something like that already.

With the 1.0 version you might want to use a bridge extension such as the SMF integration. This basically makes sure that the cockies are set correctly for a single signon and the user tables are in sync.

The last alternative is to modify the mantis system to use the Joomla! tables this should work as in Mantis most of those tables can be configured. I have not looked into it but I guess it will work.

[Krastek]

I'm using Joomla! 1.0.11 and Mantis 1.05. I didn't noticed that Mantis has some option, that enables it to take users from Joomla database... Maybe I'm blind:) You can show me the way... Unfortunately I haven't seen Joomla 1.5 yet, so I don't know anything about its options...
About customization of joomla: I dunno how to start it. I tried to connect to the mantis database, from the joomla, effect was logout from joomla...

[cas]

This mambo single signon will do:
http://nuy.info/downloads/index.php?dir ... bo/mantis/

[Krastek]

Thanks a lot. I'll try it!!!

[vboctor]

Thanks cas, I added this extension to the FAQ:
http://www.mantisbt.org/wiki/doku.php/mantisbt:faq

[eagle00789]

I hope nobody minds that i do this, but i have updated this Joomla Integration thing for Mantis.
With these changed bits, anonymous login is also enabled. Also, a lot of useless junk is removed. (like logout buttons, and create account buttons)

You can see it working in it's new form at: toolbar.decomputeur.nl
To do this, follow the following steps:

• Setup mantis as according to the manual
• Open index_mambo.php
• Search for

  Code: Select all

  $f_username = $url[0];
  $mail = $url[1];

• Replace with

  Code: Select all

  $f_username = $url[0];
  $mail = $url[1];
  if ($f_username == '')
  {
  $f_username = 'anonymous';
  $mail = 'anonymous@user';
  }

• Save file and upload to mantis root directory.
• Install the Joomla Mantis Component
• Open (Mantis Root Dir)/core/html_api.php
• Search for

  Code: Select all

  			echo '<div align="', $t_align, '">';
  			echo '<a href="http://www.mantisbt.org" title="Free Web Based Bug Tracker"><img border="0" width="242" height="102" alt="Mantis Bugtracker" src="images/mantis_logo.gif" /></a>';
  			echo '</div>';

• Replace with

  Code: Select all

  #			echo '<div align="', $t_align, '">';
  #			echo '<a href="http://www.mantisbt.org" title="Free Web Based Bug Tracker"><img border="0" width="242" height="102" alt="Mantis Bugtracker" src="images/mantis_logo.gif" /></a>';
  #			echo '</div>';

• Search for

  Code: Select all

  					if ( !php_version_at_least( '4.1.0' ) ) {
  						global $_SERVER;
  					}
  
  					$t_return_page = $_SERVER['PHP_SELF'];
  					if ( isset( $_SERVER['QUERY_STRING'] ) ) {
  						$t_return_page .=  '?' . $_SERVER['QUERY_STRING'];
  					}
  
  					$t_return_page = string_url(  $t_return_page );
  					PRINT lang_get( 'anonymous' ) . ' | <a href="login_page.php?return=' . $t_return_page . '">' . lang_get( 'login_link' ) . '</a>';
  					if ( config_get( 'allow_signup' ) == ON ) {
  						PRINT ' | <a href="signup_page.php">' . lang_get( 'signup_link' ) . '</a>';
  					}

• Replace with

  Code: Select all

  /*					if ( !php_version_at_least( '4.1.0' ) ) {
  						global $_SERVER;
  					}
  
  					$t_return_page = $_SERVER['PHP_SELF'];
  					if ( isset( $_SERVER['QUERY_STRING'] ) ) {
  						$t_return_page .=  '?' . $_SERVER['QUERY_STRING'];
  					}
  
  					$t_return_page = string_url(  $t_return_page );*/
  					PRINT lang_get( 'anonymous' ); /*. ' | <a href="login_page.php?return=' . $t_return_page . '">' . lang_get( 'login_link' ) . '</a>';
  					if ( config_get( 'allow_signup' ) == ON ) {
  						PRINT ' | <a href="signup_page.php">' . lang_get( 'signup_link' ) . '</a>';
  					}*/

• Search for

  Code: Select all

  				if ( !current_user_is_anonymous() ) {
  					$t_menu_options[] = '<a href="logout_page.php">' . lang_get( 'logout_link' ) . '</a>';
  				}

• Replace with

  Code: Select all

  #				if ( !current_user_is_anonymous() ) {
  #					$t_menu_options[] = '<a href="logout_page.php">' . lang_get( 'logout_link' ) . '</a>';
  #				}

• Save file and upload to (Mantis Root Dir)/core/.
• Open (Mantis Root Dir)/config_inc.php
• Search for

  Code: Select all

  ?>

• Add before

  Code: Select all

  	$g_allow_signup			= ON; 
  	$g_enable_project_documentation	= OFF; 
  	$g_allow_anonymous_login	= ON;
  	$g_anonymous_account		= 'anonymous'; 

[eagle00789]

This was just to finish off where the creator of the Joomla Component has left off

[perryclark]

Extending the cleanup and functionality one step further -

Here is how to manage Mantis Access Levels via the Joomla User Manager.

See screenshots at bottom of the post.

Thanks
Cas Nuy - For the bridge in the first place, and helping me out a bit. http://www.nuy.info/apps/smf/index.php? ... 48#msg4748 (don't follow these instructions though... )
eagle00789 - For cleaning up the mantis integration
cryan - For another set of eyes.
nlilly - For requesting this functionality.

Prerequsites:
mantis tables are in the same db as Joomla!
You're running the Cas Nuy Joomla/Mambo Mantis Bridge
Create column mantisaccess in jos_users as text
You've made backups of everything - DB's, Dirs, Files, Etc.

TODO / WishList/ Need help with
- Check boxes/ Dropdown list for mantisaccess levels.
- Componentize/modularize these changes into joomla, so we're not hacking core files, make it an installable component...
- Make this read / update mantis_user_table, instead of jos_users.mantisaccess
- Git rid of the <IFRAME> - See above comment about component

The Changes
In Joomla/includes/joomla.php around line 1225 in function getUser find:

Code: Select all

 if ($user->id) {
                        $query = "SELECT id, name, email, block, sendEmail, registerDate, lastvisitDate, activation, params"
                        . "\n FROM #__users"

Change to:

Code: Select all

 if ($user->id) {
                        $query = "SELECT id, name, email, block, sendEmail, registerDate, lastvisitDate, activation, params, mantisaccess"
                        . "\n FROM #__users"

In the same function around line 1239 find:

Code: Select all

$user->activation               = $my->activation;

Add beneath this:

Code: Select all

 $user->mantisaccess     = $my->mantisaccess;

Around line 2816 find:

Code: Select all

 /** @var string */
        var $params                     = null;

Add beneath this:

Code: Select all

        /** @mantisaccess ADDED FOR xTUPLE MANTIS ACCESS LEVELS */   
        var $mantisaccess       = null;

Save and close joomla.php

Open up joomladir/administrator/components/com_users/admin.users.php find around line 322:

Code: Select all

$row->username = trim( $row->username );

Add beneath this:

Code: Select all

 $row->mantisaccess = trim( $row->mantisaccess ); // Mantis Access Level - Gets rid of leading spaces

Close admin.users.php

Open up admin.users.html.php find around line 77:

Code: Select all

                        <th width="1%" class="title">
                        ID
                        </th>
                        </th>

Add beneath it:

Code: Select all

<!-- MANTIS LEVEL INTEGRATION - THIS DISPLAYS THE VALUE IN jos_users.mantisaccess-->
                <th width="15%" class="title">
                        Mantis Level
                        </th>
<!-- MANTIS LEVEL INTEGRATION - END -->

Go to someplace around line 146 for:

Code: Select all

 <td>
                                <?php echo $row->id; ?>
                                </td>

Add beneath:

Code: Select all

<!--MANTIS.. Gets Access Level from jos_users.mantisaccess -->
                                <td>
                                <?php echo $row->mantisaccess; ?>
                                </td>
                                </tr>

Around line 206 find: (this is optional - adds a check for values in the field)

Code: Select all

 } else if (trim(form.email.value) == "") {
                                alert( "You must provide an e-mail address." );

Add this underneath that:

Code: Select all

} else if (trim(form.mantisaccess.value) == "") {
                                alert( "Set Mantis Access Level - Viewer, Reporter, Updater, Developer, Manager or Administrator" );

Find this around line 266:

Code: Select all

 <tr>
                                        <td>
                                        E-mail:
                                        </td>
                                        <td>
                                        <input class="inputbox" type="text" name="email" size="40" value="<?php echo $row->email; ?>" />
                                        </td>
                                </tr>

Add underneath it:

Code: Select all

<!-- MANTIS USER LEVEL INTEGRATION START: THIS PUTS THE OPTION ON THE USER:EDIT SCREEN-->
                                <tr>
                                <td>Mantis Level:
                                </td>
                                        <td>Viewer, Reporter, Updater, Developer, Manager, or Administrator<br>

                                        <input type="text" name="mantisaccess" class="inputbox" size="40" value="<?php echo $row->mantisaccess; ?>" maxlength="25" />
                                        </td>
                                </tr>
<!-- MANTIS USER LEVEL INTEGRATION END -->

Close admin.users.html.php and open up joomladir/components/com_mantis/mantis.php -

The following mods make the Mantis Cas Nuy Joomla integration check the access level set in jos_users.mantisaccess .

Here's the full code, add the appropriate bits for your system.

Code: Select all

<?php
/*
* This is the mantis bridge component for Mambo Open Source
* Created by Cas Nuy March 2005
*/

if (!defined('mantis')){
  global $mosConfig_absolute_path;

  require ($mosConfig_absolute_path."/administrator/components/com_mantis/config.mantis.php");
}

if (!defined("_MOS_ALLOWHTML")){
  define( "_MOS_ALLOWHTML", 0x0002 );
}

$my_id = $my->id;
$name='';
$mail='';
$mantisaccess='';

$sql = "SELECT username,email,mantisaccess FROM ".$mos_prefix."users WHERE id=$my_id";


$result = mysql_query ($sql);
if (isset($result)) {
        $row = mysql_fetch_array($result);
        $name= $row[0] ;
        $mail= $row[1] ;
        $mantisaccess= $row[2] ;
}

$check = $name ;
$check .= "|" ;
$check .= $mail ;
$check .= "|" ;
$check .= $mantisaccess ;

$scripturl = $mantis_path ;
$scripturl .= "/index_mambo.php?parm=" ;
$scripturl .= $check ;

echo "<iframe src='$scripturl' align='center' width='100%' height='800px' space=0 vspace=0 marginwidth=0 marginheight=0 frameborder=0 scrolling=auto name='mantis' onload='parent.scrollTo(0,0);' ></iframe>";

?>

Open up mantis/index_mambo.php, Here's the full code...

Code: Select all

<?php
        # Mantis - a php based bugtracking system
        # Copyright (C) 2000 - 2002  Kenzaburo Ito - kenito@300baud.org
        # Copyright (C) 2002 - 2003  Mantis Team   - mantisbt-dev@lists.sourceforge.net
        # This program is distributed under the terms and conditions of the GPL
        # See the README and LICENSE files for details

        # --------------------------------------------------------
        # $Id: index.php,v 1.13 2003/01/18 02:14:12 jfitzell Exp $
        # --------------------------------------------------------
?>
<?php

$reqVar = '_' . $_SERVER['REQUEST_METHOD'];
$form_vars = $$reqVar;
$parm = $form_vars['parm'] ;

$url = explode("|", $parm);
$f_username = $url[0];
$mail = $url[1];
$mantisaccess= $url[2];

// my defined mantis level for joomla level
//      MANTIS
//      10:viewer - This is the default if the field is NULL, or doesn't match
//      25:reporter
//      40:updater
//      55:developer
//      70:Manager
//      90:administrator
// Sets the Mantis user access_level to what mantisaccess in joomla says.
// This should be a dropdown or checkboxes eventually.

$access_level= null;

switch ($mantisaccess)

{

case "Reporter":
        $access_level = "25";
        break;

case "Updater":
        $access_level = "40";
        break;

case "Developer":
        $access_level = "55";
        break;

case "Manager":
        $access_level = "70" ;
        break;

case "Administrator":
        $access_level = "90" ;
        break;

default:
        $access_level = "10";
}

require_once( 'core.php' );
$t_user_table = config_get( 'mantis_user_table' );
$f_perm_login='false';

$direct= config_get( 'default_home_page' );
if ($direct ==""){
        $direct= "main_page.php" ;
}

$query = "SELECT password FROM $t_user_table WHERE username='$f_username'";
$result = db_query( $query );
$f_password = db_result( $result );
$query = "UPDATE $t_user_table set access_level=$access_level WHERE username='$f_username' AND protected=0";
$result = db_query( $query );

if ( auth_attempt_login( $f_username, $f_password, $f_perm_login ) ) {
                print_header_redirect( $direct );
                $t_redirect_url = 'login_cookie_test.php?return=' . $f_return;
}

$hack_pwd = ranpass() ;

if (user_create ($f_username,"$hack_pwd", "$mail", $access_level,false,true,$f_username )) {



        if ( auth_attempt_login( $f_username, "$hack_pwd" , $f_perm_login ) ) {

                // update table with e-mail address when created an account

                $query = "Update $t_user_table set email='$mail' WHERE username='$f_username'";
                // $query = "Update $t_user_table set access_level='$access_level' WHERE username='$f_username'";
                $result = db_query( $query );
                        print_header_redirect( 'main_page.php' );
                $t_redirect_url = 'login_cookie_test.php?return=' . $f_return;
 }
}

function ranpass($len = "8"){
 $pass = NULL;
 for($i=0; $i<$len; $i++) {
   $char = chr(rand(48,122));
   while (!ereg("[a-zA-Z0-9]", $char)){
     if($char == $lchar) continue;
     $char = chr(rand(48,90));
   }
   $pass .= $char;
   $lchar = $char;
 }
 return $pass;
}

?>

Contact me if you have any problems - pclark-at-xtuple-dot-com.
Sorry for the epic post... Hope it's useful.

Here's some screenshots.
Creating or editing a user:


Not entering a mantis level - if user has no mantis level, it defaults to viewer.


The main user manager screen - I changed the access between screenshots!


Proudly produced by xTuple - The creators of PostBooks, the FREE OpenSource ERP/CRM/Accounting package - online at http://www.postbooks.com .

[perryclark]

Before I start hacking around, I'd like to know if it's probable that Mantis could be integrated into Joomla! without using an IFRAME. Currently the Mantis forums are not searchable/indexable by Joomla. Initially I'm looking for the same level of Joomla! integration as phpBB, and I will be studying that implementation.

Does anyone have any pointers? FAQ's? Has someone else done this?

Thanks,

Perry Clark

[cembree]

Thanks to all of the folks in this thread that helped with Joomla/Mantis integration. Following the step above, I was able to integrate things very well. I'd send a demo site link, but it's for clients only... :/ (not mine, my clients clients).

RE: Joomla w/o IFRAME. The IFRAME allows us to use Joomla links and session info. I think it will be difficult to do away with IFRAME in using the current (above) methods. The best I came up with is to assign a special template to the Mantis integration link. I can better customize the look specifically for Mantis.

[perryclark]

Hi Cembree,

Re the Mantis in Joomla w/o IFRAME... Have you found a way to link to the Mantis Content so that when you refer to a bug issue, you get Mantis presented inside the Joomla "wrapper"?

For example...
My mantis in joomla is at http://www.xtuple.org/index.php?option= ... &Itemid=26

I want to link to my mantis issue at - http://www.xtuple.org/mantis/view.php?id=5977 ... How do I joomlaize this so that the link presents it properly?

That's why I say remove it from the IFRAME, unless there's a workaround. I've got some interns from the local university to help with this. They need something to do!!

Thanks,

Perry Clark
xtuple.org

[cembree]

Modifications to Joomla User Manager Screen:

I didn't care to type in the Mantis Level every time, so I used radio buttons. Changes to changes are hard to follow, so if anyone would like to re-write my explanation, feel free

above in this thread, we're changing admin.users.html.php; around line 266 we find some code and insert after it a textbox input. Ignore that whole section and use this instead:

Code: Select all

<!-- MANTIS USER LEVEL INTEGRATION START: THIS PUTS THE OPTION ON THE USER:EDIT SCREEN-->
                               <tr>
                               <td>Mantis Level:
                               </td>
                                       <td>CLIENTS:&nbsp;&nbsp;
                               <input type="radio" name="mantisaccess" id="block0" value="10" <?php if ($row->mantisaccess == "10") { echo 'checked="checked"'; } ?> class="inputbox" size="1" />
       <label for="block0">Viewer</label>&nbsp;&nbsp;&nbsp;&nbsp;
                               <input type="radio" name="mantisaccess" id="block1" value="25" <?php if ($row->mantisaccess == "25") { echo 'checked="checked"'; } ?> class="inputbox" size="1" />
       <label for="block1">Reporter</label>
<br>
                               STAFF:&nbsp;&nbsp;
                               <input type="radio" name="mantisaccess" id="block2" value="40" <?php if ($row->mantisaccess == "40") { echo 'checked="checked"'; } ?> class="inputbox" size="1" />
       <label for="block2">Updater</label>&nbsp;&nbsp;&nbsp;&nbsp;
                               <input type="radio" name="mantisaccess" id="block3" value="55" <?php if ($row->mantisaccess == "55") { echo 'checked="checked"'; } ?> class="inputbox" size="1" />
       <label for="block3">Developer</label>&nbsp;&nbsp;&nbsp;&nbsp;
                               <input type="radio" name="mantisaccess" id="block4" value="75" <?php if ($row->mantisaccess == "75") { echo 'checked="checked"'; } ?> class="inputbox" size="1" />
       <label for="block4">Manager</label>&nbsp;&nbsp;&nbsp;&nbsp;
                               <input type="radio" name="mantisaccess" id="block5" value="90" <?php if ($row->mantisaccess == "90") { echo 'checked="checked"'; } ?> class="inputbox" size="1" />
       <label for="block5">Administrator</label>
                                       </td>
                               </tr>
<!-- MANTIS USER LEVEL INTEGRATION END -->

Where above we edit the same file around line 77, replace with the following code:

Code: Select all

<!--MANTIS.. Gets Access Level from jos_users.mantisaccess -->
                               <td>
                               <?php switch ($row->mantisaccess) {
                                       case 10: echo "Viewer";
                                       break;
                                       case 25: echo "Reporter";
                                       break;
                                       case 40: echo "Updater";
                                       break;
                                       case 55: echo "Developer";
                                       break;
                                       case 70: echo "Manger";
                                       break;
                                       case 90: echo "Administrator";
                                       break;
                               } ?>
                               </td>

These changes to the other changes also mean we don't have to change from text to a number in the index_mambo.php script. So make the following change to mantis/index_mambo.php:
FROM

Code: Select all

$access_level= null;

switch ($mantisaccess)

{

case "Reporter":
        $access_level = "25";
        break;

case "Updater":
        $access_level = "40";
        break;

case "Developer":
        $access_level = "55";
        break;

case "Manager":
        $access_level = "70" ;
        break;

case "Administrator":
        $access_level = "90" ;
        break;

default:
        $access_level = "10";
}

change to by commenting is all out

Code: Select all

/* $access_level= null;

switch ($mantisaccess)

{

case "Reporter":
        $access_level = "25";
        break;

case "Updater":
        $access_level = "40";
        break;

case "Developer":
        $access_level = "55";
        break;

case "Manager":
        $access_level = "70" ;
        break;

case "Administrator":
        $access_level = "90" ;
        break;

default:
        $access_level = "10";
}
*/

Just add /* before and */ after. Because of the changes we made using the radio buttons, the database now contains the Mantis values (10,25,55 ... ) instead of the words. We no longer need to translate with the switch case.

I hope this helps someone

[perryclark]

Hey,

Thanks for getting radio buttons on that page, that helps me out a lot. One of my next projects is getting our Mantis issues to replicate up to our Sourceforge.net project's bug tracker pages. If you've ever worked on a SF project, you know that the project ranking is affected by how much community activity there is around your project. ERP projects like OpenBravo, Compiere, OpenTaps all benefit from having a large part of their community activity hosted on SF's services (forums, bug tracker, dev snapshots, etc.). Well, before we started using SF for our project, PostBooks, we had already built up a rather large community and knowledge base hosted on our local servers. Much of the activity still occurs on our local server rather than the SF server even though we've got over 30K DL's from SF. The people are led back to our Joomla/phpBB/Mantis content items for help, community, etc. So, to facilitate this I've got a rough hack to phpBB working that mirrors submitted content to an appropriate SF forum. Naturally, the next step is to replicate our mantis issues up to the SF bug tracker.

See the phpBB -> SF hack details here... http://www.phpbb.com/community/viewtopi ... 5&t=596609 - I have to update the page because I added authentication to it, but it gives you the idea. It needs improvements, but it does work... I suppose that this or a similar method could work between any forum system where you have local content control and db access and need to get it to some other site where you don't.

- Perry

[perryclark]

I'm also getting involved with a project to convert Joomla to PostgreSQL at: http://forum.joomla.org/index.php/topic,128257.0.html

How much integration do we want/need? I'm thinking about making Joomla plug into our ERP package - PostBooks/OpenMFG. In my case, this would solve so many problems of having to deal with multiple user management interfaces for all our systems. The bridges for mantis and phpbb and joomla work great, but they really should be able to plug into 1 true source for that info... IMHO that source should be a PostBooks/OpenMFG DB running on PostgreSQL, but I'm biased. I'll kick it around with my co-workers and see what jells...

I mean, isn't this what everyone who integrates Mantis, phpBB and Joomla together really wants? Imagine running your company's accounting/erp/website/leads/etc etc all from 1 common db. No, I don't want a website running inside the same db as my erp... but it should definately talk to the system.

- Perry