I am running TestLink and Mantis on the same system (and database) for the same users and I wanted to have a quick (and dirty) integration of the user management facility. I came up with the following triggers for MySQL that will allow you to use the Mantis User management function to create users, delete users and change passwords. All other settings that TestLink needs (like roles and access levels) still need to be set by using the appropriate functionality in TestLink.

As long as you avoid doing the creation/deletion and update passwords thing in TestLink, your user database tables will be in sync and your users can use the same ID and PW for both systems.

--
-- Triggers mantis_user_table

DROP TRIGGER IF EXISTS bugtracker.tluserinsert;
DELIMITER //
CREATE TRIGGER bugtracker.tluserinsert AFTER INSERT ON bugtracker.mantis_user_table
FOR EACH ROW INSERT INTO
users(users.id,
users.login,
users.password,
users.email,
users.first,
users.last)
values (new.id,
new.username,
new.password,
new.email,
SUBSTRING_INDEX( new.realname , ' ', 1 ),SUBSTRING_INDEX( new.realname , ' ', -1 ))
//
DELIMITER ;
DROP TRIGGER IF EXISTS bugtracker.tluserupd;
DELIMITER //
CREATE TRIGGER bugtracker.tluserupd AFTER UPDATE ON bugtracker.mantis_user_table
FOR EACH ROW update users set users.password=new.password where users.id=old.id
//
DELIMITER ;
DROP TRIGGER IF EXISTS bugtracker.tluserdel;
DELIMITER //
CREATE TRIGGER bugtracker.tluserdel AFTER DELETE ON bugtracker.mantis_user_table
FOR EACH ROW delete from users where users.id=old.id
//
DELIMITER ;