身份验证问题 [英] ident authentication problem
问题描述
嗨
我正在运行Mandrake 10，并希望获得sql-ledger访问
数据库。
我可以在命令提示符下使用本地用户和Web进入数据库
Admin。
sql-ledger返回身份验证问题。
包含的常见问题
有这个说法
IDENT身份验证失败，用户postgres
这个错误与发行版设置访问权限的方式有关
for postgres。它们的限制性太强，让你想知道该做什么
接下来。
帮自己一个忙，并将pg_hba.conf中的身份验证类型更改为
当地人全部信任
我找不到这个档案。
如何建议如何在线获取SQL-Ledger？
-
谢谢
Shanta McBain
http://computersystemconsulting.ca 虚拟主机和应用托管。
--- ------------------------（播出结束）--------------------- ------
提示3：如果通过Usenet发布/阅读，请发送适当的
subscribe-nomail命令给 ma ******* @ postgresql.org 这样你的
消息可以干净地通过邮件列表
>我正在运行Mandrake 10并希望获得sql-ledger来访问数据库。
包含的常见问题
有这个说明
请自己帮忙并在pg_hba.conf中更改身份验证类型
本地所有信任
如果你遵循这个圣人的建议，你会打开你的财务
数据给那些在机器上有帐户的人在
问题。任何人。不仅仅是那些碰巧拥有
* PostgreSQL *数据库帐户的人。
http://computersystemconsulting.ca 虚拟主机和应用托管。
包括访问您网页的任何互联网用户如果他们成功地让您的http服务器运行某些脚本（如果，
当然，sql-ledger已开启）暴露的机器，它不应该是b $ b。
我找不到这个文件。
它在PostgreSQL系统的主目录下的目录中
运行后端的
帐户。
帮自己一个忙，并在ident地图上阅读PG
认证。
Karsten
-
GPG密钥ID E4071346 @ wwwkeys.pgp .net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
------------------ ---------（广播结束）---------------------------
提示2：您可以使用取消注册命令一次性取消所有列表
（发送取消注册YourEmailAddressHere到 ma ******* @ postgresql.org ）
数据库。
包含的常见问题
有这个说明
请自己帮忙并在pg_hba.conf中更改身份验证类型
本地所有信任
如果你遵循这个圣人的建议，你会打开你的财务
数据给那些在机器上有帐户的人在
问题。任何人。不仅仅是那些碰巧拥有
* PostgreSQL *数据库帐户的人。
http://computersystemconsulting.ca 虚拟主机和应用托管。
包括访问您网页的任何互联网用户如果他们成功地让您的http服务器运行某些脚本（如果，
当然，sql-ledger已开启）暴露的机器，它不应该是b $ b。
我找不到这个文件。
它在PostgreSQL系统的主目录下的目录中
运行后端的
帐户。
帮自己一个忙，并在ident地图上阅读PG
认证。
Karsten
-
GPG密钥ID E4071346 @ wwwkeys.pgp .net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
------------------ ---------（广播结束）---------------------------
提示2：您可以使用取消注册命令一次性取消所有列表
（发送取消注册YourEmailAddressHere到 ma ******* @ postgresql.org ）
[snip]
帮自己一个忙，并在pg_hba.conf中更改身份验证类型
本地所有信任
<我无法找到这个文件。
关于如何在线获取SQL-Ledger的任何建议？
你没有没有提到你正在运行的pgsql的版本......我会假设
7.4.x.为此，它可能没关系？
你应该从这里开始
http://www.postgresql.org/docs/7.4/static/index.html
参见第III节：服务器管理
-
Jim Seymour |垃圾邮件发送者起诉反垃圾邮件发送者：
js******@LinxNet.com | http://www.LinxNet.com/misc/spam/slapp。 php
http://jimsun.LinxNet.com |请捐赠给SpamCon法律基金：
| http://www.spamcon.org/legalfund/
---------------------------（广播结束）----------- ----------------
提示8：解释分析是你的朋友
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*******@postgresql.org so that your
message can get through to the mailing list cleanly
> I am running Mandrake 10 and would like to get sql-ledger to access thedatabase. 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 YourEmailAddressHere" to ma*******@postgresql.org)
> I am running Mandrake 10 and would like to get sql-ledger to access thedatabase. 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 YourEmailAddressHere" to ma*******@postgresql.org)
Shanta McBain <cs*@computersystemconsulting.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******@LinxNet.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
这篇关于身份验证问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
