[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [Bug #738] Installation RC3 and Postgres running
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [Bug #738] Installation RC3 and Postgres running on Apache (SSL) |
Date: |
Wed, 26 Jun 2002 12:57:16 -0400 |
=================== BUG #738: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=738&group_id=509
Changes by: Anonymous user Date: 2002-Jun-26 12:57
------------------ Additional Follow-up Comments ----------------------------
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.
=================== BUG #738: FULL BUG SNAPSHOT ===================
Submitted by: pbounin Project: phpGroupWare
Submitted on: 2002-Jun-24 07:49
Category: API - Setup Bug Group: None
Severity: 5 - Major Priority: None
Resolution: None Assigned to: milosch
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-Jun-26 12: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 08: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 05: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,
No files currently attached
For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=738&group_id=509