[Phpgroupware-tracker] [Bug #738] Installation RC3 and Postgres running on Apache (SSL)

[nobody]

=================== BUG #738: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=738&group_id=509

Changes by: Dave Hall <address@hidden>
Date: 2002-Sep-12 18:10 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | milosch                   | seek3r


------------------ Additional Follow-up Comments ----------------------------
Is this still a problem?



=================== BUG #738: FULL BUG SNAPSHOT ===================


Submitted by: pbounin                   Project: phpGroupWare                   
Submitted on: 2002-Jun-24 21:49
Category:  API - Setup                  Bug Group:  None                        
Severity:  5 - Major                    Priority:  None                         
Resolution:  None                       Assigned to:  seek3r                    
Status:  Open                           Platform Version:  Linux - Debian       
Reproducibility:  None                  

Summary:  Installation RC3 and Postgres running on Apache (SSL)

Original Submission:  Hello!

I'm using Debian (woody) and tried to install phpgroupware
along with PostgreSQL and apache-ssl.
Insallation of apache works fine. I installed postgres and
tried to run psql (client) as user postgres - fine either.
I than tried to install phpgroupware (debian installation
finisched without errors) and created database "phpgroupware"
and user "phpgroupware" as said in the installation documentation
Furtheron i created a symlink from /var/www (it's debian)
to ../../usr/share/phpgroupware.

Well, than i tried (as recommended in the documentation)
https://localhost/phpgroupware/setup

Nothin happens (e.g. the directory will be listed, that's
all. The reason is, that index.php has not been added to
the list of index files in httpd.conf, which I did later
manually.)

I clicked on config.php - nice! a form apeared to enter
some configuration variables but first of all some error
messages:

*********************************************************
Warning: Unable to connect to PostgreSQL server: FATAL 1: IDENT authentication 
failed for user "phpgroupware" in 
/usr/share/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 89
 
Warning: Supplied argument is not a valid PostgreSQL link resource in 
/usr/share/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 213
 
Warning: Supplied argument is not a valid PostgreSQL link resource in 
/usr/share/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 259
     
*********************************************************

So far so bad. Nevertheless i filled in the form and hit the
"submit" button - a lot more error messages:

*********************************************************
Warning: Unable to connect to PostgreSQL server: FATAL 1: IDENT authentication 
failed for user "phpgroupware" in 
/usr/share/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 89
 
Warning: Supplied argument is not a valid PostgreSQL link resource in 
/usr/share/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 213
 
Warning: Supplied argument is not a valid PostgreSQL link resource in 
/usr/share/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 259
 
Warning: Unable to connect to PostgreSQL server: FATAL 1: IDENT authentication 
failed for user "phpgroupware" in 
/usr/share/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 89
 
Warning: Supplied argument is not a valid PostgreSQL link resource in 
/usr/share/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 213
 
Warning: Unable to connect to PostgreSQL server: FATAL 1: IDENT authentication 
failed for user "phpgroupware" in 
/usr/share/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 89
 
Warning: Supplied argument is not a valid PostgreSQL link resource in 
/usr/share/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 213
 

When doing https://localhost/

.............

*********************************************************


...


I restartet with https://localhost/phpgroupware/setup
and instead clicked on manageheader.php, again filled
in the form and (
*********************************************************
Cannot create the header.inc.php due to file permission restrictions.)
downloaded the header.inc.php.
*********************************************************
What to do with the file? After some researches i copied to /etc/phpgroupware
(it's debian! In /usr/share/phpgroupware/setup is a symlink to
/etc/phpgroupware/header.inc.php) Because I couldn't save it directly but
have copied it as described above, I clicked on "continue" button.

Hm. Not bad!

I've succesfully logged out. What to do now?
I tried "Setup/Administration" (after entering the password)
by clicking on "Login". Result

*********************************************************
Database error: Link-ID == false, connect failed
 PostgreSQL Error: 0 ()
 

Session halted.
*********************************************************


All this could be reproduced in many ways. I tried to
bypass with no success. I read a lot of documentation
(concerning phpgroupware and postgres) - no success at 
all. I re-installed everything (step by step, after
deinstalling everything) - not better.

After some days (two right now) I decided to ask someone
else who might have had the same problems - you?

What to do to get it running?

Any hints?

Thanks in advance

Peter


Follow-up Comments
*******************

-------------------------------------------------------
Date: 2002-Sep-12 18:10             By: skwashd
Is this still a problem?

-------------------------------------------------------
Date: 2002-Jun-27 02:57             By: None
Debian postgresql defaults to ident authentication.  Add the following lines  
to your /etc/postgresql/pg_hba.conf and restart:
local   phpgroupware password
host    phpgroupware 127.0.0.1 255.255.255.0 password

These lines allow the phpgroupware user to log in with a password.  This is 
assuming apache and postgresql are running on the same machine.  Restart 
postgresql.  

-------------------------------------------------------
Date: 2002-Jun-26 22:04             By: milosch
Try running psql as user phpgroupware.  Either the user/db does not exist, or 
the user does not have rights to the db.


-------------------------------------------------------
Date: 2002-Jun-26 19:24             By: yeupou
Well, this bug is not for the savannah project but for the phpgroupware project.

Laurent, can you move this bug to the phpgroupware bug tracker ? 

Best regards,



CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=738&group_id=509