Problems with PostgreSQL

Problems with PostgreSQL

by Jukka Pirttimaki -
Number of replies: 1

Hello!

I have problems with PostgreSQL and Moodle. I am a absolute beginner with Linux, Apache, PHP, PostgreSQL so I am almost sure hat I just don´t understand enough.

I have installed Linux ( Red Hat 8.0), Apache, PHP and PostgreSQL. Ican see index.htm and index.php files from other machines. But when I try to create a database just like installation docs says, I get an error.

# su - postgres

>pql -c "create user moodleuser createdb;" template1

OK

> psql -c "create database moodle;" -U moodleuser template

I get an error:

FATAL1: IDENT authentication failed for user moodle

Can anybody help me? I would very much like to get Moodle working.

Thanks

Jukka Pirttimaki

Finland

Average of ratings: -
In reply to Jukka Pirttimaki

Re: Problems with PostgreSQL

by Janne Mikkonen -

Ident authentication means that postgre tries to find "moodleuser" from system's user database /etc/passwd | /etc/shadow so if you want to continue to use ident authentication you must add a user called moodleuser to Linux.

- Janne -

Average of ratings: -