Hi,
I'm receiving the following error when attempting to connect to ingres
through jdbc:
"User authorization check failed. Your user identified was not known to
this installation".
I'm using Windows XP, Weblogic, and Ingres II 3.0/0404 (int.w32/81); my
settings are
URL = jdbc:edbc://localhost:II7/dbname
driver = ca.edbc.jdbc.EdbcDriver
user=ingres

I don't have any problems using isql or sql to connect to the database. I
have an "ingres" user account on the localhost PC, I've used accessdb to set
"ingres" permissions.

Any help is greatly apprciated,
Eric

The following solved the issue:

1) Install Ingres from the ingres account letting everything default
2) log into ingres account and ingstart
3) use ingres/password from 1 above for JDBC connect

Eric

"Eric" wrote
> Hi,
> I'm receiving the following error when attempting to connect to ingres
> through jdbc:
> "User authorization check failed. Your user identifier was not known to
> this installation".

Hi Eric,

Just a comment about the user for JDBC connection. You should use a
less priviledged user for JDBC, and specially not ingres. On the OS
side, in a windows installation like yours I think ingres must be a
member of the administrator group. On the DBMS system side, ingres is
an special user. If someone gets by any mean the ingres/passwd pair
through the network or reading some config file on a remote machine
you have a serious security issue.

I recommend to you to consider creating a dedicated user (at OS and
DBMS) for this conn, with the minimun priveledges you can give to it.
In Unix, for example, in some OSs, you can use a nologin account.


Hope this helps

Carlos

"Eric" <EricC@org.org> wrote in message news:<cm5063$imq$1@inn.jlab.org>...
> The following solved the issue:
>
> 1) Install Ingres from the ingres account letting everything default
> 2) log into ingres account and ingstart
> 3) use ingres/password from 1 above for JDBC connect
>
> Eric
>
> "Eric" wrote
> > Hi,
> > I'm receiving the following error when attempting to connect to ingres
> > through jdbc:
> > "User authorization check failed. Your user identifier was not known to
> > this installation".

Excellent point. This setup is for strictly for development work on an
isolated, non-networked PC. But even with this isolated configuration, it
makes sense to connect with a non-administrator, non-privileged user as
suggested.

Many thanks for the feedback,
Eric

"Carlos Alonso" <izena@mixmail.com> wrote in message
news:79016e6d.0411020221.62e46e94@posting.google.c om...
> Hi Eric,
>
> Just a comment about the user for JDBC connection. You should use a
> less priviledged user for JDBC, and specially not ingres. On the OS
> side, in a windows installation like yours I think ingres must be a
> member of the administrator group. On the DBMS system side, ingres is
> an special user. If someone gets by any mean the ingres/passwd pair
> through the network or reading some config file on a remote machine
> you have a serious security issue.
>
> I recommend to you to consider creating a dedicated user (at OS and
> DBMS) for this conn, with the minimun priveledges you can give to it.
> In Unix, for example, in some OSs, you can use a nologin account.
>
>
> Hope this helps
>
> Carlos
>
> "Eric" <EricC@org.org> wrote in message
news:<cm5063$imq$1@inn.jlab.org>...
> > The following solved the issue:
> >
> > 1) Install Ingres from the ingres account letting everything default
> > 2) log into ingres account and ingstart
> > 3) use ingres/password from 1 above for JDBC connect
> >
> > Eric
> >
> > "Eric" wrote
> > > Hi,
> > > I'm receiving the following error when attempting to connect to
ingres
> > > through jdbc:
> > > "User authorization check failed. Your user identifier was not known
to
> > > this installation".