Page 1 of 1

PostgreSQL configuration

Posted: 26 Feb 2008, 16:47
by HUN73R
Hi,

this is my first post, and I´m new on Mantis.

I´m trying to configure Instant Mantis (v1.1.1) on a Apache server (v2.0.63 - win32) with PHP (v5.2.6 - win32).
The Apache and PHP are properly set and running...

but I´m having problems to set up the Mantis to access a PostgreSQL (v8.2.5-1) database.

OS: WinXP SP2

I searched the web but didn´t find anything useful.

Any help is welcome!! :D

Thank you,
HUN73R.

Re: PostgreSQL configuration

Posted: 27 Feb 2008, 12:58
by smig1o
HUN73R wrote:Hi,

this is my first post, and I´m new on Mantis.

I´m trying to configure Instant Mantis (v1.1.1) on a Apache server (v2.0.63 - win32) with PHP (v5.2.6 - win32).
The Apache and PHP are properly set and running...

but I´m having problems to set up the Mantis to access a PostgreSQL (v8.2.5-1) database.

OS: WinXP SP2

I searched the web but didn´t find anything useful.

Any help is welcome!! :D

Thank you,
HUN73R.
Owwww... my head..
Can you be more descriptive?
What kind of problems??
We arnet a wizards...

Re: PostgreSQL configuration

Posted: 27 Feb 2008, 14:09
by HUN73R
Owwww... my head..
Can you be more descriptive?
What kind of problems??
We arnet a wizards...
Ok, sorry..

I don´t know which files to change, nor which params are needed..

I can run the Mantis using mysql, but I do need it running on PostgreSQL

There´s a "config_inc.php" file below the \mantis folder...I changed it, now it looks like:
<?php $g_hostname='localhost';$g_db_type='pgsql';$g_database_name='mantis_db';$g_db_username='postgres';$g_db_password='postgres'; ?>

Is it right?
what else do I have to do?

When I try the "install.php", the shown result is all good except for "Checking PHP support for database type" and "Attempting to connect to database as admin"

I´m really lost hehe

Thank you again!
HUN73R

Re: PostgreSQL configuration

Posted: 28 Feb 2008, 18:42
by HUN73R
Ok guys,

that was an error in "php.ini" file!

the line responsible for identify pgsql was commented =/

now everything is ok =)

thank for your attention!

HUN73R.

Re: PostgreSQL configuration

Posted: 28 Feb 2008, 19:55
by smig1o
Add two wings of bats, a dragon scale, 2 breaths of frog
I knew it will work!!!

Re: PostgreSQL configuration

Posted: 29 Feb 2008, 16:40
by HUN73R
hahaha you were right xD

but now I have other problem..

when I try to log on as 'Administrator / root', the system shows "Your account may be disabled or blocked or the username/password you entered is incorrect"

I checked the data base and there´s an account with these values, so it should connect and log on, right?

I know these doubts are too foolish, but consider please! I´m new on Mantis and PHP...and I need your help =)

Thank you again!

HUN73R.