Initial Install of Mantis BT Fails

[MacJoyful]

Server Environment:
Development Server - iMac Intel Core 2 Duo 2.8 GHz, 4 GB RAM, Mac OS X version 10.5.8 client
Apache 2.2.14 mod_ssl 2.2.14
PHP version 5.3.0 (http://www.entropy.ch Release 3) Universal Binary i386/x86_64/ppc7400/ppc64 - this machine runs: x86_64
MySQL version: 5.1.41-log MySQL Community Server (GPL)

When I attempt to run the install, things fail with the following problems:

Attempting to connect to database as user: Possible Problem - Database user doesn't have access to the database.

[atrol]

Attempting to connect to database as user: Possible Problem - Database user doesn't have access to the database.

are you able to connect to database with same user/password using mysql command line?

[woo37830]

I get the problem in the install.php where it says it can't locate the database.

The config_inc.php is copied from a running version of mantis ( 1.0.0 ), and it locates the database fine.

I am trying to install mantisBt 1.2.10 on my Mac OS X Lion 10.7.4 running MySQL Server version: 5.1.58 MySQL Community Server (GPL) and PHP 5.2.10.

I can log into mysql from the command line and run queries against that database using the same userid and password as is in my config_inc.php file.

Why can't it see the database so that I can update it? BTW, I did a
ysql> grant all privileges on *.* to root@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

Just to be sure that all privileges were set for the root account ( the one in question ).

BTW, if i create a new database and do not enter an admin userid or password, how do i add myself as a admin user to mantis?

[atrol]

You must not copy config_inc.php for a fresh installation.
This is only needed when updating.
Read file doc/INSTALL of your download to see instructions for new installations and upgrade installations.

New installations create a default MantisBT (not database) administrator user.
Name: administrator
Password: root

[woo37830]

Thanks, I'll try a new install.

I was attempting to upgrade my 1.0.0 version to the 1.2.10 and since that didn't work tried a new install with the copied config file.

SO, I can't upgrade from 1.0.0 to 1.2.10?

[atrol]

SO, I can't upgrade from 1.0.0 to 1.2.10?

You can, read the instructions in doc/INSTALL.

[woo37830]

My problem came in that the new version could not locate my database. I could use the mantis 1.0.0 and get to the database fine. I put the same information into the startup panel, but it kept saying it couldn't get access. When I did the new install, it created a new database and worked fine.

I looked in the install.php and it seems that if it does not get a database_version from somewhere, it will return a -1 and give the message that it found the init file, but not the database. Is this because the config_inc.php is a copy of the 1.0.0 one and doesn't contain this? The install instructions said to copy that file into mantisbt and use it to do an upgrade.

Also, I am installing this on my server. It has a registered domain name. If I put that name into the hostname position, it says it can't locate it. I had to create the installation using localhost. BUT, the email to new users then have localhost in them instead of the real hostname and they can't click and get to the mantisBT installation. I have my MySQL database set so that users coming into the registered domain name can gain access.