[ic] undefined carts on upgrade

[David Etheredge]

----- Original Message ----- 
From: "Stefan Hornburg (Racke)" <racke at linuxia.de>
To: <interchange-users at icdevgroup.org>
Sent: Tuesday, December 31, 2013 9:18 AM
Subject: Re: [ic] undefined carts on upgrade


> On 12/31/2013 08:01 AM, David Etheredge wrote:
>>
>> ----- Original Message ----- From: "David Etheredge" 
>> <David_e at charter.net>
>> To: <interchange-users at icdevgroup.org>
>> Sent: Monday, December 30, 2013 12:17 AM
>> Subject: Re: [ic] undefined carts on upgrade
>>
>>
>>> Found this in apache error.log
>>>
>>> 97.81.233.34 - - [30/Dec/2013:16:25:36 -0500] "GET 
>>> /~ezclang/cgi-bin/sys_cpanel/images/bottombody.jpg HTTP/1.1" 403 2244
>>>
>>>
>>>
>>> The problem must be in apache setup I guess?
>>>
>>>
>>
>>
>> OK, that issue is fixed but I am still having problems with the cart. It 
>> is failing but there is not any logging to show what is causing the 
>> error.
>>
>
> David, please explain how you fixed issues as other users can learn from 
> it! Support on a mailing list
> isn't a one way road.
>
>> Apache access.log
>> - - [31/Dec/2013:01:32:45 -0500] "GET /~ezclang/cgi-bin/cart.cgi 
>> HTTP/1.1" 500 2261
>>
>> Apache error.log
>>
>>
>> [Tue Dec 31 01:46:16 2013] [error] [client 10.30.4.53] Premature end of 
>> script headers: cart.cgi
>>
>> Suexec.log
>>
>> [2013-12-31 01:46:16]: uid: (516/ezclang) gid: (517/ezclang) cmd: 
>> cart.cgi
>>
>> [2013-12-31 01:46:16]: error: target uid/gid (516/517) mismatch with 
>> directory (516/32013) or program (516/517) or trusted user (0/10)
>>
>
> Still Apache problem. Fix your suexec setup.
>
>> Nothing in the catalog error.log
>>
>> Nothing in icdebug
>>
>
> The request never reaches Interchange, so ...
>
>>
>>
>> How do I add or turn on debugging to the cart?
>>
>
> ... this question is irrelevant.
>
> Enjoy + see you next year.
>
> Regards
> Racke
>
>
> -- 
> LinuXia Systems => http://www.linuxia.de/
> Expert Interchange Consulting and System Administration
> ICDEVGROUP => http://www.icdevgroup.org/
> Interchange Development Team
>
>

I believe that the question about debugging is relevant.

Apache error reports: The request was not completed. The server met an 
unexpected condition.

The Suexec error was corrected.

As for the Apache error, the cart was being called and started to reply but 
did not send the proper text which cause an unexpected end of script error. 
This fell back to apache which was looking for a jpg to fill the background. 
I just found the relevant directory sys_cpanel and copied it to the cgi-bin 
directory and applied the correct attributes.


What appears to be happening is that cart.cgi is being called and gets lost. 
Then just drops back to apache unexplainedly.


I am getting a series of DBI failures On interchange restart:

Configuring catalog ezclang...Using PostgreSQL, 
DSN=dbi:Pg:dbname=ezclang...Vend::Table::DBI:debug: bad= connecting to 
dbi:Pg:dbname=ezclang
table 'pay_cert_redeem' failed: connect to dbi:Pg:dbname=ezclang failed 
(create) -- fe_sendauth: no password supplied

This problem has been discussed in the past but I never saw an actual 
resolution.

I did try the one fix mentioned
>>>> $db = DBI->connect( @call ) unless $bad;
>>>>
>>>> ...to:
>>>>
>>>> $db = DBI->connect( @call );
but it does not work.What password is required for these files?I added the 
following to each of the 4 config files:ifdef SQLUSERDatabase userdb USER 
__SQLUSER__endififdef SQLPASSDatabase userdb PASS __SQLPASS__endifOn 
Interchange restart:Database userdb scalar parameter USER redefined to 
"interch", was "interch".Database userdb scalar parameter PASS redefined to 
"#######", was "#######".table 'pay_cert_lock' failed: connect to 
dbi:Pg:dbname=ezclang failed (create) -- fe_sendauth: no password 
suppliedThe problem exists with only the 4 new db files. All 4 files are 
empty except for the header text.The fe_sendauth:  no password supplied 
appears to come from Postgres.David