Ingres - Locations, Locations, Locations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Colin Hay - 26 Jun 2007 09:10 GMT

I want to create a 2.6 database from my Windows PC, residing on the
office network (the H: drive)

I create the location in accessdb

ii_cmt H:\IngresII

and set its usage to y y y y y

I then create all the relevant folders

H:\IngresII\ingres\data\default
H:\IngresII\ingres\ckp\default
H:\IngresII\ingres\jnl\default
H:\IngresII\ingres\dmp\default
H:\IngresII\ingres\work\default

but when I try to

createdb fin_dev_700 -dii_cmt

I get

E_DM0080 Location's area does not exist or cannot be used.

Huh ?!?

Colin Hay

Reply to this Message

Peter Gale - 26 Jun 2007 09:23 GMT

Hi Colin,

What are the underlying messages in errlog.log?

Peter Gale

> I want to create a 2.6 database from my Windows PC, residing on the
> office network (the H: drive)
[quoted text clipped - 29 lines]
> Info-Ingres@kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres

Signature

Peter Gale
pgale61@gmail.com

Reply to this Message

Colin Hay - 26 Jun 2007 09:52 GMT

> Hi Colin,
>
[quoted text clipped - 41 lines]
>
> - Show quoted text -

Good question

WORKSTAT::[II\INGRES\788 , 00ab51a0]: Tue Jun 26 18:05:17 2007
E_CL0610_DI_DIRNOTFOUND The directory pointed to path could not be
found list() failed with operating system error 3 (The system cannot
find the path specified.)
WORKSTAT::[II\INGRES\788 , 00ab51a0]: Tue Jun 26 18:05:17 2007
E_DM91A8_DMM_LOCV_DILISTDIR An unexpected error was encountered in the
DIlistdir() routine. This error was encountered while trying to
validate either the II_WORK, II_DATABASE, and/or the auxiliary work
location. The following pathname caused the error (H:\IngresII\ingres
\data\default). Check that the path exists and that permissions on
all parts of the path allow access to the ingres user.

I created the folders as myself, not as my local ingres user - does it
matter on Windows though ?

Colin

Reply to this Message

Peter Gale - 26 Jun 2007 10:05 GMT

It would seem so. I have a vague recollection of problems with directory
permissions.
At the very least make sure Ingres has write access and preferably Ingres
should own the directories. Also Ingres needs to be a local user on your PC
as well and not a domain user IIRC.

Peter

> > Hi Colin,
> >
[quoted text clipped - 65 lines]
> Info-Ingres@kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres

Signature

Peter Gale
pgale61@gmail.com

Reply to this Message

Jean-Pierre Zuate, La Fage Conseil - 26 Jun 2007 10:08 GMT

Hello,

As far as I know when you create a location the area is created by Ingres
itself. I've just do this test on Ingres 2.6 / HP-UX.

So the question is : what directory do you create manualy ?

Regards,

Signature

Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jean-pierre.zuate@lafageconseil.fr
http://lafageconseil.fr/

2007/6/26, Colin Hay <wobble7@hotmail.com>:

>
> > Hi Colin,
[quoted text clipped - 66 lines]
> Info-Ingres@kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres

Reply to this Message

Richard Harden - 26 Jun 2007 10:24 GMT

Hi Colin,

Also, looking at your errors below, there looks to be a space in the
location name

" |
The following pathname caused the error (H:\IngresII\ingres \data\default).
"
So it might be the data location entered

Cheers

Richard

/**********************************\

| New Zealander, leading the world |

\**********************************/

-----Original Message-----
From: info-ingres-bounces@kettleriverconsulting.com
[mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of Colin
Hay
Sent: Tuesday, 26 June 2007 8:53 p.m.
To: info-ingres@kettleriverconsulting.com
Subject: Re: [Info-Ingres] Ingres - Locations, Locations, Locations

On Jun 26, 6:23 pm, "Peter Gale" <pgal...@gmail.com> wrote:

> Hi Colin,
>
[quoted text clipped - 43 lines]
>
> - Show quoted text -

Good question

WORKSTAT::[II\INGRES\788 , 00ab51a0]: Tue Jun 26 18:05:17 2007
E_CL0610_DI_DIRNOTFOUND The directory pointed to path could not be
found list() failed with operating system error 3 (The system cannot find
the path specified.)
WORKSTAT::[II\INGRES\788 , 00ab51a0]: Tue Jun 26 18:05:17 2007
E_DM91A8_DMM_LOCV_DILISTDIR An unexpected error was encountered in the
DIlistdir() routine. This error was encountered while trying to validate
either the II_WORK, II_DATABASE, and/or the auxiliary work location. The
following pathname caused the error (H:\IngresII\ingres \data\default).
Check that the path exists and that permissions on all parts of the path
allow access to the ingres user.

I created the folders as myself, not as my local ingres user - does it
matter on Windows though ?

Colin

_______________________________________________
Info-Ingres mailing list
Info-Ingres@kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres

Reply to this Message

Colin Hay - 26 Jun 2007 10:39 GMT

On Jun 26, 7:24 pm, "Richard Harden" <richard.har...@orcon.net.nz>
wrote:

> Hi Colin,
>
[quoted text clipped - 96 lines]
>
> - Show quoted text -

Hmmmm - the plot thickens

Dropped the location and created it again as ingres on my workstation

Accessdb lets you create locations on drives that don't even exist !

Once I had mapped my H: drive as ingres, I dropped and recreated the
location OK
although no folders are created automatically

the createdb still fails

The pathname doesn't have any spaces in it - so its not that

So maybe I do have to create the folders manually if they are on a
network drive, and they do have to be created as ingres ?

One last go ...

Colin

Reply to this Message

Colin Hay - 26 Jun 2007 10:52 GMT

> On Jun 26, 7:24 pm, "Richard Harden" <richard.har...@orcon.net.nz>
> wrote:
[quoted text clipped - 122 lines]
>
> - Show quoted text -

Reply to this Message

Gareth Williams - 26 Jun 2007 13:58 GMT

Perhaps you've tried some of this...

You'll need permissions on the shared drives of what ever the Ingres
service is running as. Normally this would be a local account to the
Server/PC. But in this case you'd need to go to windows -> services and
change all the ingres services logons to a user who can connect to the
DOMAIN the remote share is on.

Have you tried using the unc path instead of drive names e.g.
\\remoteserver\ingres

Cheers

Gareth

-----Original Message-----
From: info-ingres-bounces@kettleriverconsulting.com
[mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of
Colin Hay
Sent: 26 June 2007 10:52
To: info-ingres@kettleriverconsulting.com
Subject: Re: [Info-Ingres] Ingres - Locations, Locations, Locations

> On Jun 26, 7:24 pm, "Richard Harden" <richard.har...@orcon.net.nz>
> wrote:
>
> > Hi Colin,
>
> > Also, looking at your errors below, there looks to be a space in the

> > location name
>
[quoted text clipped - 72 lines]
> > E_CL0610_DI_DIRNOTFOUND The directory pointed to path could not be
> > found list() failed with operating system error 3 (The system cannot

> > find the path specified.)
> > WORKSTAT::[II\INGRES\788 , 00ab51a0]: Tue Jun 26 18:05:17 2007
> > E_DM91A8_DMM_LOCV_DILISTDIR An unexpected error was encountered in the
> > DIlistdir() routine. This error was encountered while trying to
> > validate either the II_WORK, II_DATABASE, and/or the auxiliary work

> > location. The following pathname caused the error

(H:\IngresII\ingres \data\default).

> > Check that the path exists and that permissions on all parts of the
> > path allow access to the ingres user.
[quoted text clipped - 32 lines]
>
> - Show quoted text -

I recreated the location as ingres with attendant folders owned by
ingres but still no joy ....

According to the 2.6 dba guide the folders are only created upon
createdb,
- though accessdb should still check the path name before on Save I
reckon ....

I just created an alternate location for my C: drive and the createdb -
d worked fine

So ... it looks like a permission problem with mapped drives ?

Running Ingres 2.6/0305 unpatched

Colin

_______________________________________________
Info-Ingres mailing list
Info-Ingres@kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
Cymraeg:-
Mae'r neges hon yn gyfrinachol nad chi yw'r derbynnydd y bwriedid y neges ar ei gyfer, byddwch mor garedig ? rhoi gwybod
i'r anfonydd yn ddi-oed. Dylid ystyried un rhywd datganiadau neu sylwadau a wneir uchod yn rhai personol,ac nid o angen rhaid yn rhai o
eiddo Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol ohoni na chorff cysylltiedig.

Cofiwch fod yn ymwybodol ei bod yn bosibl y bydd disgwyl i Ymddiriedolaeth GIG Bro Morgannwg roi cyhoeddusrwydd i gynnwys unrhyw ebost neu
ohebiaeth a dderbynnir, yn unol ag amodau'r Ddeddf Rhyddid Gwybodaeth 2000. I gael mwy o wybodaeth am Ryddid Gwybodaeth, cofiwch gyfeirio
at wefan Ymddiriedolaeth GIG Bro Morgannwg ar www.bromor-tr.wales.nhs.uk

English:-
This message is confidential. If you are not the intended recipient of the message then please notify the sender immediately.
Any of the statements or comments made above should be regarded as personal and not necessarily those of Bro Morgannwg NHS Trust, any
constituent part or connected body.

Please be aware that, under the terms of the Freedom of Information Act 2000, Bro Morgannwg NHS Trust may be required to make public the
content of any emails or correspondence received. For further information on Freedom of Information, please refer to the Bro Morgannwg NHS
Trust website at www.bromor-tr.wales.nhs.uk.

Reply to this Message

Colin Hay - 27 Jun 2007 03:10 GMT

On Jun 26, 10:58 pm, "Gareth Williams" <Gareth.Willi...@bromor-
tr.wales.nhs.uk> wrote:

> Perhaps you've tried some of this...
>
[quoted text clipped - 190 lines]
>
> - Show quoted text -

I tried the UNC path to no avail - every user has their own H: drive
mapping which points to a user specific location so we can't use the
UNC path anyway

I ensured all priviledges are OK for colinh and ingres on my domain
and ingres on my workstation also to no avail ....

Very strange ....

Colin

Reply to this Message

On Web - 27 Jun 2007 08:27 GMT

On Jun 26, 10:58 pm, "Gareth Williams" <Gareth.Willi...@bromor-
tr.wales.nhs.uk> wrote:

> Perhaps you've tried some of this...
>
[quoted text clipped - 202 lines]
>
> - Show quoted text -

>I tried the UNC path to no avail - every user has their own H: drive
>mapping which points to a user specific location so we can't use the
>UNC path anyway

Isn't this the answer? The server will be running as the ingres user and
have a different H: drive to you.

>I ensured all priviledges are OK for colinh and ingres on my domain
>and ingres on my workstation also to no avail ....

>Very strange ....

>Colin

If you are doing things with relation to the ingres database server, always
do them as the ingres user, rather than your own user (which is asking for
trouble).

Paul

Reply to this Message

simonl@unwired.com.au - 27 Jun 2007 08:59 GMT

All this begs the question: why would you want to do such a strange
thing?

Shouldn't the dbms server and the disk controller be on the same bus?

SAN systems are a pretty dubious idea for the DBMS server.

If you want a private database for each person, it would be easier to
set it up on the local PC. If you don't want to do that, why not just
set up a db on the server for that user.

> On Jun 26, 10:58 pm, "Gareth Williams" <Gareth.Willi...@bromor-
> tr.wales.nhs.uk> wrote:
[quoted text clipped - 224 lines]
>
> Paul

Reply to this Message

Paul Mason - 26 Jun 2007 09:59 GMT

> I want to create a 2.6 database from my Windows PC, residing on the
> office network (the H: drive)
[quoted text clipped - 12 lines]
> H:\IngresII\ingres\dmp\default
> H:\IngresII\ingres\work\default

I'm suspicious about this part - you haven't had to manually create the
directories for a few versions now. Try deleting the location and then
re-add it but let Ingres create the directories.

but when I try to

> createdb fin_dev_700 -dii_cmt
>
[quoted text clipped - 5 lines]
>
> Colin Hay

Signature

Paul Mason

Reply to this Message