Hi,

When I try to conenct to a ingres DB through JDBC, I am getting the
following error



Code:
--------------------
SQLException : ca.edbc.util.EdbcEx: User authorization check failed.
Your user identifier was not known to this installation.
Contact your system manager for further assistance.
--------------------



Can someone help me in resolving the problem


--
madhukarmad84

Is the user you are connecting as defined as a valid Ingres user in your
target installation?


--
teresa

Ingres requires two things to complete a connection to a database (by
default anyway):
- A valid operating system login and password. (Default is old style
passwords but you can now use PAM)
- The login is defined as a valid ingres user by the installation
administrator, usually via accessdb.


--
daryl.monge (AT) ingres (DOT) com
------------------------------------------------------------------------
daryl.monge (AT) ingres (DOT) com's Profile: http://community.ingres.com/forum/member.php?userid=736
View this thread: http://community.ingres.com/forum/sh...ad.php?t=11371

On Nov 18, 2009, at 12:38 PM, Ingres Forums wrote:

This is one of my biggest pet peeves. Why does
Ingres require that you have either an OS account
or some sort of directory service account (same thing)
to let you connect to the database?

This is madness. No other database requires this.

This is part of the reason I can fire up a Linux stack and have
developers
coding against, deploying to, and testing on a MySQL or Postgres
server in
about 5 minutes.

Why can you associate a password with the "Ingres user" if you can't
even use
it to authenticate remotely.

Part of getting people to use your software is making it very easy to
use.
The authentication in Ingres is not only complicated, it is more
LIMITED than
any other DBMS.

Cheers,

Mikey

Hi Mike,

or some sort of directory service account (same thing) to let you
connect to the database?
....etc...

I'd have to ask why you think its complicated Mike. It seems to me that
either OS authentication or authentication using an installation
password is pretty simple.

Apart from which, I want people to be authenticated before they access
my installations or databases.

Marty

Sorry, I didn't understand what is "valid Ingres user in your target
installation"

I have updated the user as a valid ID using accessdb command and
granted all the permissions to the user

Still having the same problem.

Thanks,
Madhu


--
madhukarmad84

JDBC authenticates in the same way as Ingres/Net. You may need your user
to be an OS user.


--
denjo02

On Nov 19, 2009, at 2:42 AM, Martin Bowes wrote:

Marty,

I can get ANYTHING to work if I try hard enough. MySQL is just easier
and faster. That is part of its attraction.

I have a few Oracle installations that have thousands of users and
not one of them has an OS account or an entry in any kind of directory
service. Not all of these users are people. Quite a few people have
different users for different roles.

One day, the network services branch of the company decided the entire
company was going to move from Novell directory services to Active
Directory.
I had nothing to do. They didn't bother to tell me ahead of time. And
in
that department, they have strict IT best-practices that each account
has
to be approved through management, etc.

Too many moving parts.

And tell me what I do for VMS sites? How's that PAM authentication
for VMS
coming along? Oh, not til' next year? Hmmm .... can we wait?

Mikey

The user I have used to connect is a OS user


--
madhukarmad84

Mike Leo wrote:

Well playing the Devil's advocate for a moment, I could say that no
resource is more sensitive nor more valuable than the business data. So
is it any kind of best-practice to permit access to it without
management approval and at least the same level of scrutiny as
required for access to the spreadsheets and print servers?

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.