Re: -952 Authentication Error on Solaris 10

On Mar 27, 8:15 pm, Fernando Nunes <domusonl...@xxxxxxxxx> wrote:
Ian Michael Gumby wrote:

 > From: nate...@xxxxxxxxx
 > Subject: Re: -952 Authentication Error on Solaris 10
 > Date: Fri, 27 Mar 2009 06:48:04 -0700
 > To: informix-l...@xxxxxxxx

 > On Mar 27, 8:22 am, Ian Michael Gumby <im_gu...@xxxxxxxxxxx> wrote:
[SNIP]

 > It's a TCP/IP connection.
 > -Nate

Ok, so both the ssh and the ODBC app are connecting via TCP/IP.
The only difference is that if you connect locally, most likely you're
not going to hit any firewall blocks.
So I have to wonder if your error indicates that you can't make a
connection and you time out.

Have you ever run "finderr"?

Does Informix track and log login attempts? You should be able to track
and see how far you got in to the login process.
One more thing that might help... is the -952 error being generated by
the server itself or the client trying to connect?

It surely is the client... Then it sends the info into the server, so that it
can save it in the online.log :)



Unless you know about some bug that messes error codes real bad, please tell
your gut to read the error codes...


Well sparky,
Funny you should pop your fuzzy little head up...

I happened to be experiencing a similar issue with Java, JSTL and JSPs
when trying to connect to an IDS 10.x instance.
I'm not going to bore you with what those components are,. but what
I'm finding out in the error file is that the user name is coming
across as user@xxxxxxxxxxxxxxxxxx and not just user. This could be
causing Informix to barf on the authentication and then failing.

Unfortunately for moi, the error was masked because the glassfish app
server was reporting that there was a null string conversion in the
exception process and since the jdbc connection is abstracted, I had
no way of finding out the issue.

Now I know and I'm looking at not using the Informix native jdbc
driver but trying to use the informix jdbc driver that ships with the
Sun Web Server.

So yeah, you can look at the online.log and see what is being sent
over the wire and getting rejected.
While the online.log doesn't show you the password that was sent, the
fact that I'm seeing user@xxxxxxxxxxxxxxxxx explains why
authentication bombs out.

Now boy wonder, why don't you tell us why Informix 9 and 10 are doing
this? Or rather why the CSDK (odbc for the OP and jdbc for moi) is
doing this?

.

Relevant Pages

  • oninit -i failure
    ... I'm trying to startup informix for the first time on a CentOS 4.5 ... server. ... # Disk Mirroring Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)
  • Re: DBIx::DBH - Perl extension for simplifying database connectio ns
    ... Only one of the Informix notations has a host name in it, ... that's technically not a host name but a server name - the distinction ... under the illusion that people who use Perl to access a database know ... The connection string is system-specific -- end of sob story. ...
    (perl.dbi.users)
  • Re: Trouble connecting to IDS 11.5 development server using SQuirrel SQL with IDS JDBC driver.
    ... A blasted operator error on my part with port forwarding. ... -908 Attempt to connect to database server failed. ... see the IBM Informix Guide to SQL: ...
    (comp.databases.informix)
  • Re: installing DBD-Informix on fedora 6
    ... usually i authenticate on the db server by adding a line to the .rhosts file belonging to root. ... my "stores" database is empty, i use it only for testing connections. ... ESQLTEST Program Running: ... Using IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.UC2 from /opt/informix ...
    (perl.dbi.users)
  • Re: Select from 2 Servers
    ... where is specified the Server? ... > You don't refer to the server, you refer to the Informix instance. ... >> columns in a table except the primary key could/should be nullable. ... > and you don't have a parent row for it, just do an insert into the parent ...
    (comp.databases.informix)
Loading