unstable proxy

unstable proxy

am 12.12.2005 15:34:39 von claude.b

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----------------------------------------------------- -------------
[root@blooto proxy]# dbiproxy --localport=3333 --logfile=log.txt --pidfile=pid --debug&
[1] 12516
[root@blooto 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.

[root@blooto proxy]#
[root@blooto proxy]# dbiproxy --ver
DBI::ProxyServer 0.3005, Copyright (C) 1998, Jochen Wiedmann
[root@blooto proxy]# ls
pid
---clip----------------------------------------------------- -------------
--
Claude