On 3/15/2013 11:02 AM, Bill McCormick wrote: > On 3/15/2013 9:13 AM, Bill McCormick wrote: >> database is not supported by PHP > I got past this with apt-get install php5-pgsql. > > Now it fails with this: > BAD > Database user doesn't have access to the database ( ERROR: syntax > error at or near "'mantis_user'" LINE 1: CREATE USER 'mantis_user' > WITH PASSWORD 'mypassword' ^ ) BAD > Database ERROR. Try again, uninstall manually the Database if it was > created, and return to the installation. > > I created a new user with superuser, createdb and createrole.and > that's the user I'm using for installation. So I discovered that the Ubunto package for this, that I got with apt-get install mantis, isn't quite ready for prime time; at least in terms of use with postgresql.
I downloaded the latest tarzip and the database setup appears to be a manual operation. I copied the SQL from the output of the admin/install.php, created an new mantis database and a mantis_user, and then psql \i'd in the sql to populate the database with tables and indexes. But then the issue comes down to privileges; the mantis_user has no privileges on any table so the rest of the admin/install fails. Now, I suppose I could grant privileges for user mantis_user to every table but that's such a pain in the butt that I think there must be some better way. Perhaps someone out there has a setup script? Or knows psql enough to be able to move the whole database from the public schema to some other aptly named mantis schema? Does anybody out there have any insight to getting mantis working with postgresql? Thanks !!! ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar _______________________________________________ mantisbt-help mailing list mantisbt-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mantisbt-help
