[ic] Keep getting checkout page - interchange 4.8.6-1

[Rick Eicher II]

> > Hello,
> >
> > I am setting this site up to use Authorize.net for the credit cards.
> So
> > I would like to disable PGP encryption. I would like an email sent
to
> > the owner without the CC info. I have set the credit_card and
encrypt
> to
> > 0 in the catalog.cfg file. But it still seems to try and use PGP. :(
> >
> > When I place an order instead of getting the receipt page I get the
> > check out page again with no errors.
> >
> > The error.log for the catalog shows:
> >
> > 63.147.204.243 n6uqGJur:63.147.204.243 - [26/August/2002:10:37:29
> -0500]
> > inventory /cgi-bin/inventory/process.html PGP failed with status 2:
> > 63.147.204.243 n6uqGJur:63.147.204.243 - [26/August/2002:10:37:30
> -0500]
> > inventory /cgi-bin/inventory/process.html PGP failed with status
> > 16777215: Broken pipe
> > 63.147.204.243 n6uqGJur:63.147.204.243 - [26/August/2002:10:37:30
> -0500]
> > inventory /cgi-bin/inventory/process.html Successful login by user
> > 'U00018'
> > 63.147.204.243 n6uqGJur:63.147.204.243 - [26/August/2002:10:37:30
> -0500]
> > inventory /cgi-bin/inventory/process.html Route log failed.
> > 63.147.204.243 n6uqGJur:63.147.204.243 - [26/August/2002:10:37:30
> -0500]
> > inventory /cgi-bin/inventory/process.html ERRORS on ORDER TEST0018:
> > > Error during creation of order routing log:
> > > Route log failed. at /usr/lib/interchange/lib/Vend/Order.pm line
> 1577.
> >
> >
> > The catalog-dir/logs/log file shows:
> >
> > #### begin TEST0018 #####
> > Auto-created user U00018.
> > There was an error adding to the transaction log.
> > 1
> > Logout auto-created user: 1
> > #### end TEST0018 #####
> >
> >
> >
> > When I start interchange:
> >
> > bash-2.05$ /usr/lib/interchange/bin/interchange
> > Sending debug to /tmp/icdebug.
> > Low traffic settings.
> > Calling UI......UI is loaded...
> > Vend::Payment::AuthorizeNet payment module initialized, using LWP
and
> > Crypt::SSLeay
> > Interchange V4.8.6
> > Configuring catalog inventory...Using PostgreSQL,
> > DSN=dbi:Pg:dbname=inventory...done.
> > Interchange server started in UNIX mode(s) (process id 20590)
> >
> >
> > Last part of /tmp/icdebug:
> >
> > ...
> > Vend::Payment:debug: authorizenet response_reason_text=This
> transaction
> > has been approved. response_code: 1
> >
> >
> > I have found some tips in the achieves that talk about the order of
> the
> > Routes in the catalog.cfg file. I have taken a new (4.8.6-1)
> foundation
> > catalog.cfg file and wet it up for my site. This did not make a
> > difference.
> >
> > redhat 7.2
> > interchange 4.8.6
> > postgresql 7.2 (this site runs on postgres)
> > Bundle-Interchange (CPAN install last week)
> > Bundle-InterchangeKitchenSink (CPAN install last week)
> >
> >
> I went ahead and set up PGP for this to see if it would help. I does
> remove the line about the PGP failed but I am still getting the other
> error.
> 
> Rick
> 

For the record I got this working. The problem turns out to be the fact
that I am using 7.2.1 version of postgresql. I learned this from looking
at postgresql logs. Older version would truncate the data and insert it
into the tables. Postgresql 7.2.1 and higher no longer do this, they
will not execute the insert.

So I have to use filter tags in the /etc/log_transaction file to make
sure the data will fit into the database. This is discussed in this
archive record.
http://interchange.redhat.com/pipermail/interchange-users/2002-July/0228
61.html

Rick