[ic] FW: SQL setup

Cameron B. Prince cameron@akopia.com
Tue, 5 Dec 2000 11:37:03 -0600


This is a multi-part message in MIME format.

------=_NextPart_000_002A_01C05EAF.B04EDCE0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi Paul,

I believe you have confirmed that your problem is Postgres specific.
Unfortunately, my database experience is limited to MySQL and I am not sure
how to guide you further. Hopefully one of the other list members with
Postgres experience will pick up this thread and give you a hand.

Good luck,

Cameron

-----Original Message-----
From: Paul Aviles [mailto: paul.aviles@palei.com ]
Sent: Tuesday, December 05, 2000 11:07 AM
To: cameron@akopia.com
Subject: SQL setup


Cameron, thanks for the update. This is what I did, created a user using:
CREATEUSER -P wshop with a password. The user can create tables and
additional users.  Then I did su - interch and restarted the service with
/usr/lib/interchange/bin/restart
 and I get the following:

Low traffic settings.
Calling UI....
...UI is loaded....
Interchange V4.6.1
Configuring catalog construct...Using PostgreSQL,
DSN=dbi:Pg:dbname=test_constru
ct.
construct config error: ERROR:  Relation 'country' does not exist

construct: error in configuration. Skipping.
construct: config error. Skipping.


Any ideas?

------=_NextPart_000_002A_01C05EAF.B04EDCE0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D971572617-05122000>Hi=20
Paul,</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D971572617-05122000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D971572617-05122000>I=20
believe you have confirmed that your problem is Postgres specific.=20
Unfortunately, my database experience is limited to MySQL and I am not =
sure how=20
to guide you further. Hopefully one of the other list members with =
Postgres=20
experience will pick up this thread and give you a =
hand.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D971572617-05122000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D971572617-05122000>Good=20
luck,</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D971572617-05122000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D971572617-05122000>Cameron</SPAN></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Paul Aviles =
[mailto:<SPAN=20
class=3D971572617-05122000>&nbsp;<A=20
href=3D"mailto:paul.aviles@palei.com">paul.aviles@palei.com</A>&nbsp;</SP=
AN>]<BR><B>Sent:</B>=20
Tuesday, December 05, 2000 11:07 AM<BR><B>To:</B>=20
cameron@akopia.com<BR><B>Subject:</B> SQL setup<BR><BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Cameron, thanks for the update. This is =
what I did,=20
created a user using: CREATEUSER -P wshop with a password. The user can =
create=20
tables and additional users.&nbsp; Then I did su - interch and restarted =
the=20
service with /usr/lib/interchange/bin/restart</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;and I get the =
following:</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Low traffic settings.<BR>Calling =
UI....<BR>...UI is=20
loaded....<BR>Interchange V4.6.1<BR>Configuring catalog =
construct...Using=20
PostgreSQL, DSN=3Ddbi:Pg:dbname=3Dtest_constru<BR>ct.<BR>construct =
config error:=20
ERROR:&nbsp; Relation 'country' does not exist</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>construct: error in configuration.=20
Skipping.<BR>construct: config error. Skipping.<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Any ideas?</DIV></FONT></BODY></HTML>

------=_NextPart_000_002A_01C05EAF.B04EDCE0--