I did the normal installation as seen on manual. I did it first on SuSE9.0/mysql-4.0.15-71/apache-1.3.28-77 it worked just perfect.
When tried on SuSE8.2/mysql-3.23.55-32/apache2-2.0.48-149 I've got the following error after the first login administrator/root

APPLICATION ERROR 0000401

Database query failed. Error received from database was 0001064: You have an error in your SQL syntax near 'on cft.id = cfpt.field_id
JOIN mantis_project_table as pt on' at line 3 for the query: SELECT distinct cft.id as id, cft.name as name
FROM mantis_custom_field_table as cft
JOIN mantis_custom_field_project_table as cfpt on cft.id = cfpt.field_id
JOIN mantis_project_table as pt on cfpt.project_id = pt.id
LEFT JOIN mantis_project_user_list_table as pult
on cfpt.project_id = pult.project_id and pult.user_id = 2
JOIN mantis_user_table as ut on ut.id = 2
WHERE pt.view_state = 10 OR
( pt.view_state = 50 and pult.user_id = 2 ) OR
( pult.user_id is null and ut.access_level >= 90 )
ORDER BY name ASC

I've tried to upgrade to mysql-4 and the error stoped.