Home > Cannot Log > Cannot Log Dbi Proxyserver

Cannot Log Dbi Proxyserver

They are *different*. It used to run fine, until we upgraded from Oracle 8i to Oracle 9i. The ProxyServer inherits all of RPC::PlServer's and hence Net::Daemon's options and option handling, in particular the ability to read options from either the command line or a config file. Related 0Perl DBI Error Msg: Can't call method “selectcol_arrayref” on an undefined value4Why does Perl's DBI complain about “failed: ERROR OCIEnvNlsCreate” when I try to connect to Oracle 11g?3A simple error

up vote 1 down vote favorite I am trying to test an Oracle database access over a proxy with the following (working) script: #!/usr/bin/perl use DBI; use strict; use warnings qw(all); Where do I drop off a foot passenger in Calais (P&O)? Controlling which SQL-statements are allowed You can put every SQL-statement you like in simply omitting "sql => ...", but the more important thing is to restrict the connection so that only My question is: What could be the reason for the script to just halt without providing any error, and is there any way to get more information about the connection attempt http://stackoverflow.com/questions/21914636/why-is-dbi-connect-not-responding-or-throwing-an-error

GID's can be passed as group names or numeric values. Could not execute How the configuration works The most important section to control access to your dbi-proxy is "client=>" in the file "proxy_oracle.cfg": Controlling which person at which machine is allowed I have: Windows NT which has MS Access with ODBC driver.

Tim. Try telneting from the "new" script machine to the dbi proxy port on the database server - if dbiproxy is running, your telnet on the script machine should get this response: I'm clueless. Update: However, running the telnet command with out the port does work.

C:\erick>telnet isfe 3333 Connecting To isfe...Could not open a connection to host on port 3333 +: Connect failed [download] If I don't have a telnet service accepting connections on 3333, how HTH. -- Hardy Merrill Mission Critical Linux, Inc. warn: 0 CLEARED by call to connect method -> connect for DBD::Proxy::dr (DBI::dr=HASH(0x9fdcf88)~0x9f96edc 'hostname=****;port=2001;dsn=dbi:Oracle:*****' '*****' **** HASH(0x9f0f834)) Will try to find out what that actually means. :) EDIT2 According to Why DBI 1.43-ithread default trace level set to 0x0/3 (pid 296) -> DBI->connect(dbi:Proxy:hostname=isfe;port=3333;dsn=dbi:Oracle:p +rod, mwh, ****, HASH(0x15d5338)) -> DBI->install_driver(Proxy) for MSWin32 perl=5.008004 pid=296 ru +id=0 euid=0 install_driver: DBD::Proxy version 0.2004 loaded from

The bottom-line is that it seems that there's no support for graceful shutdown. I have: Windows NT which has MS Access with ODBC driver. Here is the trace dump... group (--group=gid) After doing a bind(), change the real and effective GID to the given.

You will either see it flip to a blank screen (or a header message in some cases but not this one) or give you a connection timed out message. http://code.activestate.com/lists/perl-dbi-users/5245/ at /opt/perl585/lib/site_perl/5.8.5/Net/Daemon/Log.pm line 136. ' (err#1) <- connect= undef at /opt/perl585/lib/site_perl/5.8.5/i686-linux/DBI.pm line 625 -> $DBI::errstr (&) FETCH from lasth=HASH >> DBD::Proxy::dr::errstr <- $DBI::errstr= 'Cannot log in to DBI::ProxyServer: Cannot connect: Connection On other operating systems you need to specify a log file. OPTIONS When calling the DBI::ProxyServer::main() function, you supply an array of options.

Read the DBI manual. All possibilities of Net::Daemon and RPC::PlServer apply, in particular Host and/or User dependent access control Host and/or User dependent encryption Changing UID and/or GID after binding to the port Running in You should write your findings as an answer. –ThisSuitIsBlackNot Feb 20 '14 at 17:50 Also, the section of the docs I linked to in my first comment describes how Class forcing as set forcing followed by truncation Why did Michael Corleone not forgive his brother Fredo?

Feb 20 '14 at 17:56 add a comment| active oldest votes Know someone who can answer? These options are parsed by the Getopt::Long module. Can I use that to take out what he owes me? version (--version) Suppresses startup of the server; instead the version string will be printed and the program exits immediately.

Or it's not on the same port, or it's on port 5432 but the quotes are making the client try some other port. Here is theerror that I got:before dbiproxy server run:Unable to connect to host=inquire.uits.indiana.edu;sid=SLIS;port=1521:Cannot log in to DBI::ProxyServer:Cannot connect: Connection refused at /usr/share/perl5/RPC/PlClient.pm line 75.at /usr/share/perl5/Net/Daemon/Log.pm line 136.AFTER dbiproxy server run:Unable to Peter PerlDiscuss - Perl Newsgroups and mailing lists wrote: I have a question along this line.

if the dbiproxy is not up, or the networking isn't working properly, then you may get this response from telnet: Trying 1.2.3.4...

In this case, you should probably substitute 'Pg' for 'Foo'. '-w' would be a good idea in the #! I suspect you don't have a proxy server process running in monosiga. Why is looping over find's output bad practice? The provided driver script, dbiproxy, may either be used as it is or used as the basis for a local version modified to meet your needs.

Anyway telnet can connect to any socket server, You can telnet into your SMTP server on 25, HTTP server on 80, POP3 server on 110 or *any other socket server on The same program runs fine when called from the command line. How doI use them? Relevant conncetion code from the webservers: ----- my $dsn = "dbi:ODBC:SupportTracking"; my $proxy = "hostname=thea.midata.com;port=3333"; $DBH ||= DBI->connect("dbi:Proxy:$proxy;dsn=$dsn", "$username", "$password") | | die $DBI::errstr; ------ It wouldn't be as baffling if

You seem to be able to run ProxyServer.pm How do you do that?Any help would be great. use warnings; use strict; use DBI; DBI->trace(3); my $dbh = DBI->connect( "dbi:Proxy:hostname=isfe;port=3333;dsn=dbi:Oracle:xxxx", 'xxxx', 'xxxx', {RaiseError => 1, PrintError => 0, AutoCommit => 0} ); my $sql = 'select id, str from Any help would be great. at /opt/perl585/lib/site_perl/5.8.5/Net/Daemon/Log.pm line 136. [...

In this case, you should probably substitute 'Pg' for 'Foo'.code*******************#!/usr/bin/env perl'-w' would be a good idea in the #! I came in this morning to find the following error from both the linux and the sun apache webservers: ----- [Mon Apr 10 10:57:35 2000] PerlHandler subroutine `Apache::SrvrInfodev': DBI->connect failed: Cannot See Net::Daemon. I did let the script idle in the background and like after 4 minutes it actually stopped and delivered more tracing godness: >> set_err DISPATCH (DBI::dr=HASH(0x8d1fedc) rc1/3 @4 g0 ima11 pid#32187)

For example, you need to load DBI drivers in the config file or you have to create hard links to Unix sockets, if your drivers are using them. You can open or firewall any port so it is an important sanity check. Proxyserver Configuration file (bigger example) This section tells you how to restrict a DBI-Proxy: Not every user from every workstation shall be able to execute every query. SHUTDOWN DBI::ProxyServer is built on RPC::PlServer which is, in turn, built on Net::Daemon.

oracle perl proxy dbi share|improve this question edited Feb 20 '14 at 17:40 asked Feb 20 '14 at 17:01 Oliver N. 10212 2 Enable tracing within DBI –Dr.Avalanche Feb 20 Read the DBI manual. Browse other questions tagged oracle perl proxy dbi or ask your own question. The thread will execute the server's Run() method and then terminate.

more of the same and the final DESTROY ...] So the target proxy/host seems to be just offline or behind a firewall (would I get the same response in the latter Join them; it only takes a minute: Sign up Why is DBI connect not responding or throwing an error? my $sql = "statistic_area"; my $cur = $dbh->prepare($sql); $cur->bind_param(1,'905%'); # A second parameter would be called like this: # $cur->bind_param(2,'98%'); The result is this query: select count(*) from e01admin.e01e203 where geb_bezei UID's can be passed as group names or numeric values.

Any inputs.-Saiful----- End forwarded message ----- reply Tweet Search Discussions Search All Groups Perl dbi-users 2 responses Oldest Nested PerlDiscuss - Perl Newsgroups and I have a question along this line. http://www.missioncriticallinux.com Jan-Hendrik Petersen [[email protected]] wrote: > hi there> > I am using the dbi proxy. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Peter PerlDiscuss - Perl Newsgroups and mailing lists wrote: Peter Hircock at May 21, 2004 at 6:35 pm ⇧ HelloIncluded with the ActiveState Perl's DBI module is the dbiproxy.batfile.