<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=802294218-19112002>I am
currently trying to get RT working using the request-tracker, postgresql, and
apache packages from Debian. Following the instructions from the README.Debian
file leads me to the error I listed below. Jesse has suggested that I change PG
to use password instead of ident for authentication, so I changed my pg_hba.conf
to show:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=802294218-19112002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=802294218-19112002>local
all
password sameuser<BR>host
all
127.0.0.1
255.0.0.0 password
sameuser<BR>host
all
0.0.0.0
0.0.0.0
reject</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=802294218-19112002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=802294218-19112002>And
then I restarted PG. Now if I try to add or drop a user in PG, it prompts me for
a password, and I have no idea what that should be; I've been using one password
across the board on this system, and neither that or null will work in this
prompt. If I run the insertdata script, it gives me this:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=802294218-19112002></SPAN></FONT> </DIV><FONT face=Arial
color=#0000ff size=2>DBI->connect(dbname=rt;host=localhost) failed: FATAL
1: Password authentication failed for user "www-data" at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 117<BR>Connect Failed FATAL
1: Password authentication failed for user "www-data"<BR> at
tools/insertdata line 27</FONT>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=802294218-19112002></SPAN></FONT> </DIV>
<P><FONT size=2>Best regards,<BR><BR>Owen B. Mehegan<BR>MIS Manager, Perseus
Development Corp.<BR>Landline: (781) 848-8100 x263<BR>Mobile: (617)
285-1701<BR>SurveySolutions for the Web: Winner of the PC Magazine
Editors' Choice Award </FONT></P>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> rt-users-admin@lists.fsck.com
[mailto:rt-users-admin@lists.fsck.com]<B>On Behalf Of </B>Ron
Alexander<BR><B>Sent:</B> Tuesday, November 19, 2002 1:26 PM<BR><B>To:</B>
rt-users@lists.fsck.com<BR><B>Subject:</B> [rt-users] RE: /usr/lib/rt stuff
(Owen B. Mehegan)<BR><BR></FONT></DIV>
<BLOCKQUOTE><PRE wrap="">>Message: 7
>From: "Owen B. Mehegan" <A class=moz-txt-link-rfc2396E href="mailto:omehegan@perseus.com"><omehegan@perseus.com></A>
>To: <A class=moz-txt-link-rfc2396E href="mailto:rt-users@lists.fsck.com"><rt-users@lists.fsck.com></A>
>Subject: RE: [rt-users] /usr/lib/rt stuff
>Date: Tue, 19 Nov 2002 11:01:51 -0500
>
>Those were the instructions I tried to follow previously, specifically the
>ones that refer to installing on Debian, but I seemed to get nowhere on that
>front. I think I'm pretty close to getting RT working by using the Debian
>package, if I can just resolve this error with "insertdata:"
>
>DBI->connect(dbname=rt;host=localhost) failed: FATAL 1: IDENT
>authentication failed for user "www-data" at
>/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 117
>Connect Failed FATAL 1: IDENT authentication failed for user "www-data"
> at tools/insertdata line 27
</PRE></BLOCKQUOTE>Owen, what setup are you now using? Are you still on
mysql or are you pgsql? What version(If I missed this in an earlier mail,
sorry)? Does your user have privileges? Are you sure? If you are still on mysql
can I recommend <A class=moz-txt-link-abbreviated
href="http://www.mysql.com/doc/EN">www.mysql.com/doc/EN</A>? If pg try <A
class=moz-txt-link-freetext
href="http://techdocs.postgresql.org">http://techdocs.postgresql.org</A>.<BR><BR>Ron
Alexander<BR><A class=moz-txt-link-abbreviated
href="mailto:ralexander@musiciansfriend.com">ralexander@musiciansfriend.com</A><BR>
<BLOCKQUOTE>
<P><TT><BR></TT></P></BLOCKQUOTE><PRE wrap=""></PRE></BODY></HTML>