[ic] Assistance Request

[Simon Swegles]

*****@***** [~]# /home/*****/interchange/bin/interchange -r
Killing Interchange server 24625 with TERM.
Sending debug messages to debug.log.
Low traffic settings.
Calling UI......UI is loaded...
Interchange V5.4.0
Running with new signals, external programs could be unreliable.
Re-run with environment variable PERL_SIGNALS set to "unsafe" to change 
this.
Configuring catalog serv...Using MySQL, 
DSN=dbi:mysql:my_db...Vend::Table::DBI:debug: bad= connecting to 
dbi:mysql:my_db
Vend::Table::DBI:debug: tree: DBI didn't die, bad=
done.
Interchange server started in UNIX mode(s) (process id 11747)


error.log output:
- - - [13/January/2006:01:03:58 -0500] - - STOP server (24625) on signal 
TERM
- - - [13/January/2006:01:04:02 -0500] - - Sending debug messages to 
debug.log.
- - - [13/January/2006:01:04:02 -0500] - - Low traffic settings.
- - - [13/January/2006:01:04:03 -0500] - - ...UI is loaded...
- - - [13/January/2006:01:04:03 -0500] - - Interchange V5.4.0
- - - [13/January/2006:01:04:03 -0500] - - Running with new signals, 
external programs could be unreliable.
 > Re-run with environment variable PERL_SIGNALS set to "unsafe" to 
change this.
- - - [13/January/2006:01:04:03 -0500] - - Config 'serv' at server startup
- - - [13/January/2006:01:04:05 -0500] - - START server (11747) (UNIX)
- - - [13/January/2006:01:04:05 -0500] - - START server (11747) (UNIX)


debug.log output:
--- debug.log is empty after simple interchange restart. Then when I 
access the customer screen:
Start DEBUG at Fri Jan 13 01:04:05 2006
Vend::Table::DBI:debug: bad= connecting to dbi:mysql:my_db
Vend::Table::DBI:debug: tree: DBI didn't die, bad=
--- Then after trying to access the same screen after logging off SSH:
Vend::Table::DBI:debug: bad= connecting to dbi:mysql:my_db
Vend::Table::DBI:debug: merchandising: DBI didn't die, bad=
Vend::Table::DBI:debug: bad= connecting to dbi:mysql:my_db
Vend::Table::DBI:debug: merchandising: DBI didn't die, bad=
Vend::Table::DBI:debug: bad= connecting to dbi:mysql:my_db
Vend::Table::DBI:debug: merchandising: DBI didn't die, bad=
Vend::Table::DBI:debug: bad= connecting to dbi:mysql:my_db
Vend::Table::DBI:debug: merchandising: DBI didn't die, bad=
Vend::Table::DBI:debug: bad= connecting to dbi:mysql:my_db
Vend::Table::DBI:debug: merchandising: DBI didn't die, bad=
Vend::Table::DBI:debug: bad= connecting to dbi:mysql:my_db
Vend::Table::DBI:debug: merchandising: DBI didn't die, bad=
Vend::Table::DBI:debug: bad= connecting to dbi:mysql:my_db
Vend::Table::DBI:debug: merchandising: DBI didn't die, bad=
Vend::Table::DBI:debug: bad= connecting to dbi:mysql:my_db
Vend::Table::DBI:debug: merchandising: DBI didn't die, bad=

Additional error.log output at this point:
***.***.***.*** wsrWJdRE:***.***.***.*** - [13/January/2006:01:09:59 
-0500] serv /cgi-bin/serv/index.html Runtime error: table merchandising 
connect failed -- DBI connect('my_db','my_user',...) failed: Can't 
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' 
(2) at /home/*****/interchange/lib/Vend/Table/DBI.pm line 581


I can logon to phpMyAdmin and browse through the Merchandising (or any 
other) table whether the interchange user is logged in or not using the 
same logon information specified in the Interchange configuration.



Peter wrote:

> On 01/12/2006 07:15 PM, Simon Swegles wrote:
>
>> Unfortunately, I do not know how to check for the current value of $bad.
>
>
> Uncomment this line:
>
>>    579 #::logDebug("bad=$bad connecting to $call[0]");
>
>
> ...and this line:
>
>>    585 #::logDebug("$config->{name}: DBI didn't die, bad=$bad");
>
>
> ...then set "Variable DEBUG 1" somewhere near the top of 
> interchange.cfg and restart interchange.  IC will then log the above 
> two lines to whatever the DebugFile directive is set to.
>
> When you're done reverse the above procedure to avoid having that file 
> rapidly spammed and filled up with useless info you don't need.
>
> Peter
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
>
>