Could not connect to database; check your settings.

[yjchen]

Hello, all. I have problems. Please help me, and forgive me for my poor English.

host-S: dbn server (192.168.1.37), Debain GNU/Linux without X window XD.
I have installed php4-pgsql, php4, apache, postgresql.

I have

Code: Select all

createuser yjchen

and

Code: Select all

createdb serendipity

for PostgreSQL.
p.s.: yjchen can create database and user for PostgreSQL.

I have

Code: Select all

chmod -R 777 $SERENDIPITY_DOC_ROOT

, $SERENDIPITY_DOC_ROOT=/home/yjchen/public_html/blog

host-C: yjc client (192.168.1.17), Windows XP, because host-S without X window.

Browse http://dbn/~yjchen/blog by FireFox:

- Serendipity v1.0-beta1 pre-installation report -

PHP installation
Operating system Linux 2.4.27-2-386, i686 // Debian GNU/Linux
Webserver SAPI apache2handler
PHP version >= 4.1.2 Yes, 4.3.10-16
Database extensions PostgreSQL
Session extension Yes
PCRE extension Yes
GDlib extension No
OpenSSL extension Yes
mbstring extension Yes
iconv extension Yes
zlib extension Yes
Imagemagick binary Not found

php.ini configuration
Recommended Actual
safe_mode OFF OFF
register_globals OFF OFF
magic_quotes_gpc OFF ON
magic_quotes_runtime OFF OFF
session.use_trans_sid OFF OFF
allow_url_fopen ON ON
file_uploads ON ON
post_max_size 10M 8M
upload_max_filesize 10M 2M

Permissions
/home/yjchen/public_html/blog/ Writable
/home/yjchen/public_html/blog/templates_c Writable
/home/yjchen/public_html/blog/archives/ Writable
/home/yjchen/public_html/blog/uploads/ Writable
Execute Imagemagick binary Not found

Serendipity Installation

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "serendipity" in /home/yjchen/public_html/blog/include/db/postgres.inc.php on line 308

Could not connect to database; check your settings

Database Settings

Here you can enter all your database information. Serendipity needs this to be able to function

• Database type

PostgreSQL

• Database host

localhost

• Database user

yjchen

• Database password

// empty

• Database name

serendipity

• Database table prefix

serendipity_

...

[garvinhicking]

The error message says that the Postgresql connection failed for user "SerendipitY". Within the DB connection details you must enter the username of your created postgresql user "yjchen", then it should work!

HTH,
Garvin