Hi,
I start a dbiproxy with the following command. I checked that 3333 is
free. My questions are:
- Where does the intriguing port 3209 value below comes from? It is
incremented by 1 at every call of the client. Is it relevant or is
that a well-known problem?
- I could not find the log file anywhere. Would its creation be
skipped for some reason?
- Would these be fixed in later versions?
Running a remote client executing no or a single SQL statement at port
3333 is accepted by the proxy, as the printout below says (although
the port is wrong). It sometimes crashes without warning.
I tested the same code code earlier locally with DBI:Oracle and it
runs fine.
---clip------------------------------------------------------------------
[EMAIL PROTECTED] proxy]# dbiproxy --localport=3333 --logfile=log.txt
--pidfile=pid --debug&
[1] 12516
[EMAIL PROTECTED] proxy]# Mon Dec 12 16:09:32 2005 debug, 0, Server starting in
operation mode threads
Mon Dec 12 16:09:32 2005 notice, 0, Server starting
Mon Dec 12 16:09:32 2005 debug, 0, Writing PID to pid
Mon Dec 12 16:09:47 2005 debug, 0, Connection from 172.21.190.29, port 3209
Mon Dec 12 16:09:47 2005 debug, 0, Child clone: DBI::ProxyServer=HASH(0x8357034)
Mon Dec 12 16:09:47 2005 debug, 1, New child starting
(DBI::ProxyServer=HASH(0x836c408)).
Mon Dec 12 16:09:47 2005 debug, 1, Accepting client from 1.2.3.4, port 3209
Mon Dec 12 16:09:47 2005 debug, 1, Client logs in: Application
dbi:Oracle:host=127.0.0.1;port=1521;sid=abc, version 0.2004, user batman
Mon Dec 12 16:09:47 2005 debug, 1, Connecting to
dbi:Oracle:host=127.0.0.1;port=1521;sid=abc as batman
Mon Dec 12 16:09:47 2005 debug, 1, Accepting client
Mon Dec 12 16:09:47 2005 debug, 1, Client executes method Version
Mon Dec 12 16:09:47 2005 debug, 1, Client executes method CallMethod
Mon Dec 12 16:09:47 2005 debug, 1, CallMethod: =>
DBI::ProxyServer::db=HASH(0x857f848),STORE,AutoCommit,0
Mon Dec 12 16:09:47 2005 debug, 1, CallMethod: <= 1
Mon Dec 12 16:09:47 2005 debug, 1, Client executes method DestroyHandle
Mon Dec 12 16:09:47 2005 debug, 1, Child terminating.
[EMAIL PROTECTED] proxy]#
[EMAIL PROTECTED] proxy]# dbiproxy --ver
DBI::ProxyServer 0.3005, Copyright (C) 1998, Jochen Wiedmann
[EMAIL PROTECTED] proxy]# ls
pid
---clip------------------------------------------------------------------
--
Claude
