Re: [Sqlrelay-discussion] user size is wrong error

[David M. <dav...@fi...>]

I think I see what's going on.

SQL Relay has it's own client/server protocol and client API.  Programs
that use oracle directly use Oracle's client API and use the OCI
protocol to talk to the oracle database.  If you try to connect to SQL
Relay using a program that was written to talk to oracle directly, that
program will try to use the OCI protocol to talk to SQL Relay rather
than SQL Relay's protocol and you'll get an authentication error.

There are a few solutions.

If you just want to run queries, SQL Relay comes with a tool called
sqlrsh that is similar to sqlplus or the mysql client.

If you have an app that uses PHP Pear DB or Perl DBI, Python DB, or Ruby
DBI, then you can just configure your app to use the SQL Relay driver
rather than the Oracle driver.

However, if your app uses native Oracle function calls, then the only
solution is to modify it to use SQL Relay's function calls.

Hope this helps.

David Muse
dav...@fi...

On Fri, 2006-01-13 at 11:38 +0000, Corey Gill wrote:
> Hello.  I have installed oracle 10gr2 client and sqlrelay 0.36.4 on a
> whitebox linux machine (pentium 4, kernel 2.4.21-15.ELsmp).  The sqlrelay
> daemons are connecting to an oracle10gr2 database (on windows 2003) ok and I
> am able to execute queries using the query command line interface.
> 
> When I try to connect using an oracle client (sqlplus, php, etc), I receive
> an ora-12537: connection closed error.  The following message appears in the
> sqlrelay debug file:
> 01/13/2006 11:21:05 GMT listener [29984] : authentication failed: user size
> is wrong
> 
> In the sqlnet trace, the following appears:
> [13-JAN-2006 10:27:37:666] ntt2err: entry
> [13-JAN-2006 10:27:37:666] ntt2err: Read unexpected EOF ERROR on 9
> [13-JAN-2006 10:27:37:666] ntt2err: exit
> [13-JAN-2006 10:27:37:666] nsprecv: error exit
> [13-JAN-2006 10:27:37:666] nserror: entry
> [13-JAN-2006 10:27:37:666] nserror: nsres: id=0, op=68, ns=12537, ns2=12560;
> nt[
> 0]=507, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
> 
> I have tried setting authtier to all of the possible options with the same
> result.
> 
> I downloaded .37pre3 but this will not compile on the whitebox machine due
> to errors related to uint32_t:
> debugfile.h:22: type specifier omitted for parameter `uint32_t'
> 
> Does this appear to be a problem due to the operating system or is this a
> config issue?
> 
> Thanks,
> Corey
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>