sql-ledger-users

[SL] problem: postgres IDENT

[Keld S. <ke...@dk...>]

When I try to create a new database, or connect to an
existing one I get the follwing error message:
FATAL 1: IDENT authentication failed for user "postgres"

I can see the dbs when running psql as postgres.
Could it be a firewall problem, or networking problem
or some passwd problem?

This is just after moving from postgres 7.1 to 7.2 
under Mandrake 8.2 and loading the databases.

keld

Re: [SL] problem: postgres IDENT

[Damien B. <da...@eg...>]

> When I try to create a new database, or connect to an
> existing one I get the follwing error message:
> FATAL 1: IDENT authentication failed for user "postgres"

You need to edit $POSTGRES_DIR/data/pg_hba.conf (usually
/var/lib/pgsql/data/pg_hba.conf) to allow remote (and sometimes local)
hosts to connect. Also, make sure that postmaster was started with the
-i flag if you want to connect via TCP/IP.

Damien
 

Re: [SL] problem: postgres IDENT

[Jonas S. <jo...@jo...>]

On Tue, 2 Apr 2002, Keld Jørn Simonsen wrote:

> When I try to create a new database, or connect to an existing one I get
> the follwing error message: FATAL 1: IDENT authentication failed for
> user "postgres"
>
> I can see the dbs when running psql as postgres. Could it be a firewall
> problem, or networking problem or some passwd problem?
>
> This is just after moving from postgres 7.1 to 7.2 under Mandrake 8.2
> and loading the databases.

"ident" authentication method is new in Postgres 7.2.

Debian hacked something together called "peer" authentication, and it was
adopted upstream with version 7.2. If Mandrake adopted the "peer" scheme
used in 7.1 in Debian you need to replace all instances of that word with
"ident" in /etc/postgresql/pg_hba.conf.

But it could be other things as well... :-I

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

[SL] Need Help w/Debian Install

[John F. <jf...@au...>]

Jonas Smedegaard wrote:
I am a Debian user and there are as yet no .deb installation files
available. I have managed to get SL installed and it seems to run up to
the point where I try to create databases or login to the accounting
system. I tried SL several versions ago & decided to wait for it to
mature. I want to try it now to see if will meet my needs. Is there any
body here with experience with Debian that I can correspond with to get
SL working? I have it installed on a Woody box that is currently up to
date. I also do not normally use postgres but MySQL, which is easier to
manage but does not perform transaction accounting. I need to swithc
over and currently not sure where the error is. It seems to be that SL
will communicate with the postgresql server but is refused admittance to
the database that I created using psql command line  instructions. I did
create a postrgres user that is also a linux user and I added the
www-data user to postgres as well. I did read & follow the Debian
installation instructions in the FAQ. The error that I get is below;

Error!

IDENT authentication failed for user 'fred'
-- 
John Foster

Re: [SL] Need Help w/Debian Install

[John F. <jf...@au...>]

John Foster wrote:
> I am a Debian user and there are as yet no .deb installation files
> available. I have managed to get SL installed and it seems to run up to
> the point where I try to create databases or login to the accounting
> system. I tried SL several versions ago & decided to wait for it to
> mature. I want to try it now to see if will meet my needs. Is there any
> body here with experience with Debian that I can correspond with to get
> SL working? I have it installed on a Woody box that is currently up to
> date. I also do not normally use postgres but MySQL, which is easier to
> manage but does not perform transaction accounting. I need to swithc
> over and currently not sure where the error is. It seems to be that SL
> will communicate with the postgresql server but is refused admittance to
> the database that I created using psql command line  instructions. I did
> create a postrgres user that is also a linux user and I added the
> www-data user to postgres as well. I did read & follow the Debian
> installation instructions in the FAQ. The error that I get is below;
> 
> Error!
> 
> IDENT authentication failed for user 'fred'
> --
> John Foster
Sorry Jonas For the first post with your name, I used a reply to
function and did not clean it up.

-- 
John Foster

Re: [SL] Need Help w/Debian Install

[JC B. <jc...@te...>]

I am still running the version before last for SL on a woody box.  I have
no problem so far.

I will attempt to update my system tonight and will email you.  If your
problem persist, I will try my best to assist you.  Make sure you have the
correct version of Postgressql installed.

I beleive the version of Postgressql that you need is not on the package
list like you said, I downloaded the latest Postgressql source and compile
a deb file using checkinstall.

Until later....  have a nice day.

> Jonas Smedegaard wrote:
> I am a Debian user and there are as yet no .deb installation files
> available. I have managed to get SL installed and it seems to run up to
> the point where I try to create databases or login to the accounting
> system. I tried SL several versions ago & decided to wait for it to
> mature. I want to try it now to see if will meet my needs. Is there any
> body here with experience with Debian that I can correspond with to get
> SL working? I have it installed on a Woody box that is currently up to
> date. I also do not normally use postgres but MySQL, which is easier to
> manage but does not perform transaction accounting. I need to swithc
> over and currently not sure where the error is. It seems to be that SL
> will communicate with the postgresql server but is refused admittance
> to the database that I created using psql command line  instructions. I
> did create a postrgres user that is also a linux user and I added the
> www-data user to postgres as well. I did read & follow the Debian
> installation instructions in the FAQ. The error that I get is below;
>
> Error!
>
> IDENT authentication failed for user 'fred'
> --
> John Foster






JC Boursiquot, Chief Architect
TekMD, Incorporated
Tel.  908-412-8511
Fax   908-412-8581
Pager 908-323-1200

Re: [SL] Need Help w/Debian Install

[kevin b. <kev...@bi...>]

hi there,

i've successfully installed SL on debian - i think the instructions are 
not quite right so i made some notes - i'm in a rush at the moment but 
i'll attach the notes as they are - if they need correcting then please 
do so and post them up.

i run woody as far as i remember i used standard packages including 
postgresql.

the notes are originally from the sql-ledger install instructions - my 
added comments are after the '#' marks

----------------------------------8<------------------------------------
Debian Installation
unpack sql-ledger into /var/www/sql-ledger

install postgresql (Dselect)

install apache

# this did not seem to be necessary
install libpg-dev (Dselect)


# these were the debina packages i installed

libdib-perl libdbd-pg-perl libpgperl




modify /etc/postgresql/postmaster.init
# should be /etc/postgresql/postmaster.conf

PGALLOWTCPIP=yes

PGPORT=5432
# this produced an error when restarting postgres - i left it out cos 
this port seems to be the default anyway.



create a user for managing SQL-Ledger databases
from root
su postgres
$ createuser
name of user- (create a postgres user who is also a Linux user
this user will be an account manager. Enable this user to create db and 
users)

# section not required cos of the packages installed earlier. 
---------------------------------------
install DBI
perl Makefile.PL
make
make test
login as root
make install

$ export POSTGRES_INCLUDE=/usr/include/postgresql
$ export POSTGRES_LIB=/var/lib/postgres

install DBD-Pg
login as account manager (above)
perl Makefile.PL
make
make test
login as root
make install

# and of not required 
bit--------------------------------------------------------------------

change /etc/apache/httpd.conf and add
AddHandler cgi-script .pl
ScriptAlias /sql-ledger/ /var/www/sql-ledger/
<Directory /var/www/sql-ledger>
   Options ExecCGI Includes FollowSymlinks
</Directory> restart apache


# the apahce server on woody runs under the user www-data - so use

chown www-data: users templates users/members

the ':' means that the default group for www-data is set.


Make sure the web server has write permission to write to the following

users/
templates/
users/members

# chown nobody:nogroup users templates users/members



users/members might not exist. Not to worry, the file will be created
when you use admin.pl for the first time.
Of course, the permission has to be set correctly for the users directory.
# i found the file was not created automatically - i 'touched' it and 
then set the ownership to www-data


# finally the settings in pg_hba.conf were too restrictive and i set 
them to
host         all         127.0.0.1     255.0.0.0           trust

obviously this should be tighter but it was late at the time!!!


 From browser enter http://my_domain/sql-ledger/admin.pl
Login as the postgres user (account manager) you have created (above)
Create a DB
Create users

then enter http://my_domain/sql-ledger/login.pl



----------------------------------8<------------------------------------

HTH

kev bailey


JC Boursiquot wrote:
> I am still running the version before last for SL on a woody box.  I have
> no problem so far.
> 
> I will attempt to update my system tonight and will email you.  If your
> problem persist, I will try my best to assist you.  Make sure you have the
> correct version of Postgressql installed.
> 
> I beleive the version of Postgressql that you need is not on the package
> list like you said, I downloaded the latest Postgressql source and compile
> a deb file using checkinstall.
> 
> Until later....  have a nice day.
> 
> 
>>Jonas Smedegaard wrote:
>>I am a Debian user and there are as yet no .deb installation files
>>available. I have managed to get SL installed and it seems to run up to
>>the point where I try to create databases or login to the accounting
>>system. I tried SL several versions ago & decided to wait for it to
>>mature. I want to try it now to see if will meet my needs. Is there any
>>body here with experience with Debian that I can correspond with to get
>>SL working? I have it installed on a Woody box that is currently up to
>>date. I also do not normally use postgres but MySQL, which is easier to
>>manage but does not perform transaction accounting. I need to swithc
>>over and currently not sure where the error is. It seems to be that SL
>>will communicate with the postgresql server but is refused admittance
>>to the database that I created using psql command line  instructions. I
>>did create a postrgres user that is also a linux user and I added the
>>www-data user to postgres as well. I did read & follow the Debian
>>installation instructions in the FAQ. The error that I get is below;
>>
>>Error!
>>
>>IDENT authentication failed for user 'fred'
>>--
>>John Foster
>>
> 
> 
> 
> 
> 
> 
> JC Boursiquot, Chief Architect
> TekMD, Incorporated
> Tel.  908-412-8511
> Fax   908-412-8581
> Pager 908-323-1200
> 
> 
> 
> 
> 
> 

Re: [SL] Need Help w/Debian Install

[John F. <jf...@au...>]

kevin bailey wrote:
> 
> hi there,
> 
> i've successfully installed SL on debian - i think the instructions are
> not quite right so i made some notes - i'm in a rush at the moment but
> i'll attach the notes as they are - if they need correcting then please
> do so and post them up.
> 
> i run woody as far as i remember i used standard packages including
> postgresql.
> 
> the notes are originally from the sql-ledger install instructions - my
> added comments are after the '#' marks
> 
> ----------------------------------8<------------------------------------
> Debian Installation
> unpack sql-ledger into /var/www/sql-ledger
> 
> install postgresql (Dselect)
> 
> install apache
> 
> # this did not seem to be necessary
> install libpg-dev (Dselect)
> 
> # these were the debina packages i installed
> 
> libdib-perl libdbd-pg-perl libpgperl
> 
> modify /etc/postgresql/postmaster.init
> # should be /etc/postgresql/postmaster.conf
> 
> PGALLOWTCPIP=yes
> 
> PGPORT=5432
> # this produced an error when restarting postgres - i left it out cos
> this port seems to be the default anyway.
> 
> create a user for managing SQL-Ledger databases
> from root
> su postgres
> $ createuser
> name of user- (create a postgres user who is also a Linux user
> this user will be an account manager. Enable this user to create db and
> users)
> 
> # section not required cos of the packages installed earlier.
> ---------------------------------------
> install DBI
> perl Makefile.PL
> make
> make test
> login as root
> make install
> 
> $ export POSTGRES_INCLUDE=/usr/include/postgresql
> $ export POSTGRES_LIB=/var/lib/postgres
> 
> install DBD-Pg
> login as account manager (above)
> perl Makefile.PL
> make
> make test
> login as root
> make install
> 
> # and of not required
> bit--------------------------------------------------------------------
> 
> change /etc/apache/httpd.conf and add
> AddHandler cgi-script .pl
> ScriptAlias /sql-ledger/ /var/www/sql-ledger/
> <Directory /var/www/sql-ledger>
>    Options ExecCGI Includes FollowSymlinks
> </Directory> restart apache
> 
> # the apahce server on woody runs under the user www-data - so use
> 
> chown www-data: users templates users/members
> 
> the ':' means that the default group for www-data is set.
> 
> Make sure the web server has write permission to write to the following
> 
> users/
> templates/
> users/members
> 
> # chown nobody:nogroup users templates users/members
> 
> users/members might not exist. Not to worry, the file will be created
> when you use admin.pl for the first time.
> Of course, the permission has to be set correctly for the users directory.
> # i found the file was not created automatically - i 'touched' it and
> then set the ownership to www-data
> 
> # finally the settings in pg_hba.conf were too restrictive and i set
> them to
> host         all         127.0.0.1     255.0.0.0           trust
> 
> obviously this should be tighter but it was late at the time!!!
> 
>  From browser enter http://my_domain/sql-ledger/admin.pl
> Login as the postgres user (account manager) you have created (above)
> Create a DB
> Create users
> 
> then enter http://my_domain/sql-ledger/login.pl
> 
> ----------------------------------8<------------------------------------
Thanks for the info. I figured out my own solution about 10 minutes
after I yelled for help. (just about par,HUH!) I needed to change my
host permissions own all of the allowd network hosts from ident to
passward and/or crypt. This allows all of my staff members to log in
from anywhere. It was a postgres problem, not SL. BTW; this also cleared
up 3 other problems with other software that was not working with
postgres. Thanks for the tips!

-- 
John Foster