PostgreSQL configuration

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
HUN73R
Posts: 21
Joined: 26 Feb 2008, 16:27
Location: Campinas, SP - Brazil

PostgreSQL configuration

Post 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.
smig1o
Posts: 39
Joined: 30 Nov 2006, 12:26
Location: Poznan - PL
Contact:

Re: PostgreSQL configuration

Post 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...
'Press any key to continue or any other key to quit'
HUN73R
Posts: 21
Joined: 26 Feb 2008, 16:27
Location: Campinas, SP - Brazil

Re: PostgreSQL configuration

Post 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
HUN73R
Posts: 21
Joined: 26 Feb 2008, 16:27
Location: Campinas, SP - Brazil

Re: PostgreSQL configuration

Post 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.
smig1o
Posts: 39
Joined: 30 Nov 2006, 12:26
Location: Poznan - PL
Contact:

Re: PostgreSQL configuration

Post by smig1o »

Add two wings of bats, a dragon scale, 2 breaths of frog
I knew it will work!!!
'Press any key to continue or any other key to quit'
HUN73R
Posts: 21
Joined: 26 Feb 2008, 16:27
Location: Campinas, SP - Brazil

Re: PostgreSQL configuration

Post 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.
Post Reply