ident authentication problem

[Shanta McBain]

Hi

I am running Mandrake 10 and would like to get sql-ledger to access the
database.

I can get in to the database with a local user at the command prompt and Web
Admin.

sql-ledger returns ident authentication problem.

the included faq
has this to say

IDENT Authentication failed for user "postgres"

This error has everything to do with the way distros set up access rights
for postgres. They are way too restrictive and leave you wondering what to do
next.

Do yourself a favour and change authentication type in pg_hba.conf to

local all trust

I can't locate this file.

Any suggestions as to how to get SQL-Ledger online?

--
Thanks
Shanta McBain
Http://computersystemconsulting.ca Web hosting and Application Hosting.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Karsten Hilbert]

> I am running Mandrake 10 and would like to get sql-ledger to access the

database. the included faq
has this to say

Do yourself a favour and change authentication type in pg_hba.conf to

local all trust If you follow this sage advice you'll open up your financial
data to anyone happening to have an account on the machine in
question. Anyone. Not just people who also happen to have
*PostgreSQL* DB accounts.
Http://computersystemconsulting.ca Web hosting and Application Hosting. Including any internet user visiting your pages if they
succeed in getting your http server to run some script (if, of
course, sql-ledger is on the exposed machine, which it
shouldn't).
I can't locate this file.

It's in a directory off the home dir of the PostgreSQL system
account running the backends.

Do yourself a favour and read up on ident maps for PG
authentication.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

[Karsten Hilbert]

> I am running Mandrake 10 and would like to get sql-ledger to access the

database. the included faq
has this to say

Do yourself a favour and change authentication type in pg_hba.conf to

local all trust If you follow this sage advice you'll open up your financial
data to anyone happening to have an account on the machine in
question. Anyone. Not just people who also happen to have
*PostgreSQL* DB accounts.
Http://computersystemconsulting.ca Web hosting and Application Hosting. Including any internet user visiting your pages if they
succeed in getting your http server to run some script (if, of
course, sql-ledger is on the exposed machine, which it
shouldn't).
I can't locate this file.

It's in a directory off the home dir of the PostgreSQL system
account running the backends.

Do yourself a favour and read up on ident maps for PG
authentication.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

[Jim Seymour]

Shanta McBain <cs*@computersy stemconsulting. ca> wrote:

[snip]
Do yourself a favour and change authentication type in pg_hba.conf to

local all trust

I can't locate this file.

Any suggestions as to how to get SQL-Ledger online?

You didn't mention what version of pgsql you're running... I'll assume
7.4.x. For this purpose, it probably doesn't matter?

You should start here

http://www.postgresql.org/docs/7.4/static/index.html

See Section III: "Server Administration"

--
Jim Seymour | Spammers sue anti-spammers:
js******@LinxNe t.com | http://www.LinxNet.com/misc/spam/slapp.php
http://jimsun.LinxNet.com | Please donate to the SpamCon Legal Fund:
| http://www.spamcon.org/legalfund/

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Jim Seymour]

Shanta McBain <cs*@computersy stemconsulting. ca> wrote:

[snip]
Do yourself a favour and change authentication type in pg_hba.conf to

local all trust

I can't locate this file.

Any suggestions as to how to get SQL-Ledger online?

You didn't mention what version of pgsql you're running... I'll assume
7.4.x. For this purpose, it probably doesn't matter?

You should start here

http://www.postgresql.org/docs/7.4/static/index.html

See Section III: "Server Administration"

--
Jim Seymour | Spammers sue anti-spammers:
js******@LinxNe t.com | http://www.LinxNet.com/misc/spam/slapp.php
http://jimsun.LinxNet.com | Please donate to the SpamCon Legal Fund:
| http://www.spamcon.org/legalfund/

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Uwe C. Schroeder]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Mandrake installs postgres in /var/lib/pgsql
So you should find the pg_hba.conf file in /var/lib/pgsql/data/

BTW: ever heard of locate ? A simple locate pg_hba.conf should give you the
location.
On Wednesday 21 April 2004 12:26 pm, Shanta McBain wrote:

Hi

I am running Mandrake 10 and would like to get sql-ledger to access the
database.

I can get in to the database with a local user at the command prompt and
Web Admin.

sql-ledger returns ident authentication problem.

the included faq
has this to say

IDENT Authentication failed for user "postgres"

This error has everything to do with the way distros set up access
rights for postgres. They are way too restrictive and leave you wondering
what to do next.

Do yourself a favour and change authentication type in pg_hba.conf to

local all trust

I can't locate this file.

Any suggestions as to how to get SQL-Ledger online?

- --
UC

- --
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: [phone] San Bruno, CA 94066
Cell: [phone] United States
Fax: [phone]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAhvGrjqG XBvRToM4RAhi5AJ 4nR7GrPojZA4RVm KbrhuCPDHavKQCg r7lT
SPUh0eUNTarb3uf FEmPUC/A=
=aR+7
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Uwe C. Schroeder]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Mandrake installs postgres in /var/lib/pgsql
So you should find the pg_hba.conf file in /var/lib/pgsql/data/

BTW: ever heard of locate ? A simple locate pg_hba.conf should give you the
location.
On Wednesday 21 April 2004 12:26 pm, Shanta McBain wrote:

Hi

I am running Mandrake 10 and would like to get sql-ledger to access the
database.

I can get in to the database with a local user at the command prompt and
Web Admin.

sql-ledger returns ident authentication problem.

the included faq
has this to say

IDENT Authentication failed for user "postgres"

This error has everything to do with the way distros set up access
rights for postgres. They are way too restrictive and leave you wondering
what to do next.

Do yourself a favour and change authentication type in pg_hba.conf to

local all trust

I can't locate this file.

Any suggestions as to how to get SQL-Ledger online?

- --
UC

- --
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: [phone] San Bruno, CA 94066
Cell: [phone] United States
Fax: [phone]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAhvGrjqG XBvRToM4RAhi5AJ 4nR7GrPojZA4RVm KbrhuCPDHavKQCg r7lT
SPUh0eUNTarb3uf FEmPUC/A=
=aR+7
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Shanta McBain]

On April 21, 2004 13:26, Karsten Hilbert wrote:

If you follow this sage advice you'll open up your financial
data to anyone happening to have an account on the machine in
question. Anyone. Not just people who also happen to have
*PostgreSQL* DB accounts.

Did not sound like the right thing todo That is why I asked. I am new to
Postgres.
Including any internet user visiting your pages if they
succeed in getting your http server to run some script (if, of
course, sql-ledger is on the exposed machine, which it
shouldn't).

It's not. But I would rather not open it to the world anyway.

I can't locate this file.

It's in a directory off the home dir of the PostgreSQL system
account running the backends.

Do yourself a favour and read up on ident maps for PG
authentication.

Thanks for pointing me to what I needed to read to get it to see the database.
It now accept the authentication but complains of a missing directory or
file.

This I don't know if it is SQL-Ledger problem or in Postgres. I will look
deeper to find out.

Seems like all Mandrake setup for these kinds of services are not smooth. I
have had repeated problems with getting MySQL, Perl DBI, etc working. Once I
have gone through the process though it works well.

Thanks again for the tips.

Shanta
--
Thanks
Shanta McBain
Http://computersystemconsulting.ca Web hosting and Application Hosting.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Shanta McBain]

On April 21, 2004 13:26, Karsten Hilbert wrote:

If you follow this sage advice you'll open up your financial
data to anyone happening to have an account on the machine in
question. Anyone. Not just people who also happen to have
*PostgreSQL* DB accounts.

Did not sound like the right thing todo That is why I asked. I am new to
Postgres.
Including any internet user visiting your pages if they
succeed in getting your http server to run some script (if, of
course, sql-ledger is on the exposed machine, which it
shouldn't).

It's not. But I would rather not open it to the world anyway.

I can't locate this file.

It's in a directory off the home dir of the PostgreSQL system
account running the backends.

Do yourself a favour and read up on ident maps for PG
authentication.

Thanks for pointing me to what I needed to read to get it to see the database.
It now accept the authentication but complains of a missing directory or
file.

This I don't know if it is SQL-Ledger problem or in Postgres. I will look
deeper to find out.

Seems like all Mandrake setup for these kinds of services are not smooth. I
have had repeated problems with getting MySQL, Perl DBI, etc working. Once I
have gone through the process though it works well.

Thanks again for the tips.

Shanta
--
Thanks
Shanta McBain
Http://computersystemconsulting.ca Web hosting and Application Hosting.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Jim Seymour]

Karsten Hilbert <Ka************ *@gmx.net> wrote:

I am running Mandrake 10 and would like to get sql-ledger to access the
database.

the included faq
has this to say

Do yourself a favour and change authentication type in pg_hba.conf to

local all trust

If you follow this sage advice you'll open up your financial
data to anyone happening to have an account on the machine in
question. Anyone. Not just people who also happen to have
*PostgreSQL* DB accounts.

[snip]

How, exactly, is that?

--
Jim Seymour | Spammers sue anti-spammers:
js******@LinxNe t.com | http://www.LinxNet.com/misc/spam/slapp.php
http://jimsun.LinxNet.com | Please donate to the SpamCon Legal Fund:
| http://www.spamcon.org/legalfund/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html