<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2604" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=684333017-02032005><FONT face=Arial
size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=684333017-02032005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=684333017-02032005><FONT face=Arial size=2>I'm trying to
configure this to use an existing PostgreSQL instance on another machine.
I've completely blown out the pg_hba.conf on the database server to allow the RT
scripts to do basically anything even without authentication. This is the
line I added to the pg_hba.conf</FONT></SPAN></DIV>
<DIV><SPAN class=684333017-02032005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=684333017-02032005><FONT face=Arial
size=2>host
all
all XXX.XXX.XXX.XXX
255.255.255.0 trust</FONT></SPAN></DIV>
<DIV><SPAN class=684333017-02032005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=684333017-02032005><FONT face=Arial size=2>I've hupped the
Postgresql/postmaster process and verified that other machines are able to
connect to the same Postgresql instance via the network. Since
everything else is connecting fine. I'm suspecting that there is some other
problem.</FONT></SPAN></DIV>
<DIV><SPAN class=684333017-02032005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=684333017-02032005><FONT face=Arial size=2>All is well until I
run the make-initialize-database command. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT><BR><FONT face=Arial size=2>In order to
create or update your RT database,this script needs to connect to your Pg
instance on <SPAN class=684333017-02032005>server.somewhere.com</SPAN> as
pgsql.<BR>Please specify that user's database password below. If the user has no
database<BR>password, just press return.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Password: <BR>Now creating a database for
RT.<BR>Creating Pg database rt-test.<BR>DBD::Pg::db do failed: ERROR:
parser: parse error at or near "-" at character 19<BR>DBD::Pg::db do failed:
ERROR: parser: parse error at or near "-" at character 19<BR>ERROR:
parser: parse error at or near "-" at character 19<BR>*** Error code
36<BR></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT><SPAN class=684333017-02032005><FONT face=Arial size=2>My question is
this. Can someone just supply me with the SQL script to create the
database? I've seen where it's trying to connect (in previous attempts)
and is unable to do and it appears to be an authentication issue. I've
even tried running the script as the PostgreSQL user and am still getting the
same error message. If anyone has ideas, I'd be happy to hear
them.</FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=684333017-02032005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=684333017-02032005>Thanks,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=684333017-02032005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=684333017-02032005>Jimi</SPAN></FONT></DIV>
<DIV><FONT><SPAN class=684333017-02032005><FONT face=Arial
size=2></FONT></SPAN></FONT> </DIV>
<DIV><FONT><SPAN class=684333017-02032005><FONT face=Arial
size=2></FONT></SPAN> </DIV></FONT></SPAN></BODY></HTML>