Re: Ingres - Locations, Locations, Locations

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 Web wrote:
"Colin Hay" <wobble7@xxxxxxxxxxx> wrote in message
news:1182910244.520814.27290@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jun 26, 10:58 pm, "Gareth Williams" <Gareth.Willi...@bromor-
tr.wales.nhs.uk> wrote:
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-boun...@xxxxxxxxxxxxxxxxxxxxxxxxx

[mailto:info-ingres-boun...@xxxxxxxxxxxxxxxxxxxxxxxxx] On Behalf Of
Colin Hay
Sent: 26 June 2007 10:52
To: info-ing...@xxxxxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Info-Ingres] Ingres - Locations, Locations, Locations

On Jun 26, 7:39 pm, Colin Hay <wobb...@xxxxxxxxxxx> wrote:
On Jun 26, 7:24 pm, "Richard Harden" <richard.har...@xxxxxxxxxxxx>
wrote:

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-boun...@xxxxxxxxxxxxxxxxxxxxxxxxx

[mailto:info-ingres-boun...@xxxxxxxxxxxxxxxxxxxxxxxxx] On Behalf Of
Colin Hay
Sent: Tuesday, 26 June 2007 8:53 p.m.
To: info-ing...@xxxxxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Info-Ingres] Ingres - Locations, Locations, Locations

On Jun 26, 6:23 pm, "Peter Gale" <pgal...@xxxxxxxxx> wrote:
Hi Colin,

What are the underlying messages in errlog.log?

Peter Gale

On 26/06/07, Colin Hay <wobb...@xxxxxxxxxxx> wrote:

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

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

--
Peter Gale
pgal...@xxxxxxxxxx Hide quoted text -

- 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-Ing...@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx://www.kettleriverconsultin
g.com/mailman/listinfo/info-ingres-Hide quoted text -

- 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- Hide quoted text -

- 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-Ing...@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx://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 arwww.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 atwww.bromor-tr.wales.nhs.uk.- Hide quoted text -

- 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

.

Relevant Pages

  • Re: [Info-Ingres] Ingres - Locations, Locations, Locations
    ... You'll need permissions on the shared drives of what ever the Ingres ... location OK although no folders are created automatically ... Cofiwch fod yn ymwybodol ei bod yn bosibl y bydd disgwyl i Ymddiriedolaeth GIG Bro Morgannwg roi cyhoeddusrwydd i gynnwys unrhyw ebost neu ...
    (comp.databases.ingres)
  • Re: Ingres - Locations, Locations, Locations
    ... You'll need permissions on the shared drives of what ever the Ingres ... Have you tried using the unc path instead of drive names e.g. ... Cofiwch fod yn ymwybodol ei bod yn bosibl y bydd disgwyl i Ymddiriedolaeth GIG Bro Morgannwg roi cyhoeddusrwydd i gynnwys unrhyw ebost neu ...
    (comp.databases.ingres)
  • Re: Ingres - Locations, Locations, Locations
    ... You'll need permissions on the shared drives of what ever the Ingres ... path allow access to the ingres user. ... GIG Bro Morgannwg roi cyhoeddusrwydd i gynnwys unrhyw ebost neu ...
    (comp.databases.ingres)
  • ANNOUNCE: new module: Ingres::Utility::IINamu
    ... services of Ingres RDBMS through an object-oriented API. ... print "Server type: ... # stop IIGCN server (no more connections to all of Ingres ... of registering all Ingres services. ...
    (comp.lang.perl.modules)
  • RE: Xen and the art of Database performance
    ... Ingres 2.6 and DB2 were running on RHEL 2.1, ... but the new hardware is not supported by RHEL2.1. ... Finally, I built a RHEL5 server, installed VMWare ...
    (RedHat)