Re: BUG #2558: initDB failed to run

Please cc the list so others can learn.

Yes, I think a patch for this was recently committed. I know it was at least discussed somewhere...

-----Original Message-----
From: dror [mailto:dror_b(at)hotmail(dot)com]
Sent: Wednesday, August 09, 2006 2:17 AM
To: Jim Nasby
Subject: RE: [BUGS] BUG #2558: initDB failed to run

Hi Jim,
I have already solved the problem, as it is mentioned before, the problem was that on some windows 2003 machine there is no access to the nul device for non administrators users.
The initDB.c redirect the output to > DEVNUL which on windows defined has "nul".
I changed the initDB source by canceling the redirection.
I think this is the easiest way.
I could also solve it by open a file , give W permission to the user to this file and redirect the output to that file.


I think postgres must solve this issue, as more and more windows 2003 machine will be discovered with this limitation which prevent from the users to install the DB.
Attached you can find the fixed initDB.c file
Regards
Dror

_____

> CC: pgsql-bugs(at)postgresql(dot)org
> From: jnasby(at)pervasive(dot)com
> Subject: Re: [BUGS] BUG #2558: initDB failed to run
> Date: Tue, 8 Aug 2006 12:30:56 -0500
> To: dror_b(at)hotmail(dot)com
>
> Does V_MYUSER have access to the PGDATA directory? This might be an
> issue of it not having access to the directory you're running initdb
> from...
>
> On Aug 1, 2006, at 12:57 PM, Dror wrote:
> > The following bug has been logged online:
> >
> > Bug reference: 2558
> > Logged by: Dror
> > Email address: dror_b(at)hotmail(dot)com
> > PostgreSQL version: 8.1.4
> > Operating system: win 2003
> > Description: initDB failed to run
> > Details:
> >
> > On one of mine win 2003 machine ( on any other win2003 machine
> > everything
> > work as expected), I failed to install postgress in service mode
> > using the
> > MSI package , after short investigation i found a failure in the
> > initDB
> > phase, so I install postgress without running the initDB and then
> > ran the
> > initDB manually with the debug option set, (The user is not an
> > Administrator).
> > The strange thing is that EnterpriseDB which is based on postgres
> > works
> > fine.
> > The problem seems to be in the initDB.c source file in the
> > test_connections(void) and test_buffers(void) functions.
> > Here is the procedures and the output of the initDB.
> >
> > After the installation I did:
> >
> > - Runas /user:V_MYUSER CMD
> >
> > - initDB -D "E:\Postgres\Data" -d -U V_MYUSER
> >
> > Running in debug mode.
> > The files belonging to this database system will be owned by user
> > "V_MYUSER".
> > This user must also own the server process.
> >
> > The database cluster will be initialized with locale English_United
> > States.1252.
> >
> > fixing permissions on existing directory E:/Postgres\Data ... ok
> > creating directory E:/Postgres\Data/global ... ok
> > creating directory E:/Postgres\Data/pg_xlog ... ok
> > creating directory E:/Postgres\Data/pg_xlog/archive_status ... ok
> > creating directory E:/Postgres\Data/pg_clog ... ok
> > creating directory E:/Postgres\Data/pg_subtrans ... ok
> > creating directory E:/Postgres\Data/pg_twophase ... ok
> > creating directory E:/Postgres\Data/pg_multixact/members ... ok
> > creating directory E:/Postgres\Data/pg_multixact/offsets ... ok
> > creating directory E:/Postgres\Data/base ... ok
> > creating directory E:/Postgres\Data/base/1 ... ok
> > creating directory E:/Postgres\Data/pg_tblspc ... ok
> > selecting default max_connections ... Access is denied.
> > Access is denied.
> > Access is denied.
> > Access is denied.
> > Access is denied.
> > Access is denied.
> > 10
> > selecting default shared_buffers ... Access is denied.
> > Access is denied.
> > Access is denied.
> > Access is denied.
> > Access is denied.
> > Access is denied.
> > Access is denied.
> > Access is denied.
> > Access is denied.
> > Access is denied.
> > Access is denied.
> > 50
> > creating configuration files ... ok
> > creating template1 database in E:/Postgres\Data/base/1 ...
> > VERSION=8.1.4
> > PGDATA=E:/Postgres\Data
> > share_path=E:/Program Files/postgres/Database/share
> > PGPATH=E:/Program Files/postgres/Database/bin
> > POSTGRES_SUPERUSERNAME=V_MYUSER
> > POSTGRES_BKI=E:/Program Files/postgres/Database/share/postgres.bki
> > POSTGRES_DESCR=E:/Program
> > Files/postgres/Database/share/postgres.description
> > POSTGRESQL_CONF_SAMPLE=E:/Program
> > Files/postgres/Database/share/postgresql.conf.sample
> > PG_HBA_SAMPLE=E:/Program Files/postgres/Database/share/
> > pg_hba.conf.sample
> > PG_IDENT_SAMPLE=E:/Program
> > Files/postgres/Database/share/pg_ident.conf.sample
> > DEBUG: TZ "Asia/Jerusalem" matches Windows timezone "Jerusalem
> > Standard
> > Time"
> > DEBUG: invoking IpcMemoryCreate(size=1327104)
> > LOG: database system was shut down at 2006-08-01 14:36:37 Jerusalem
> > Standard Time
> > LOG: checkpoint record is at 0/20
> > LOG: redo record is at 0/20; undo record is at 0/20; shutdown TRUE
> > LOG: next transaction ID: 3; next OID: 10000
> > LOG: next MultiXactId: 1; next MultiXactOffset: 0
> > LOG: database system is ready
> > DEBUG: StartTransaction
> > DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR,
> > xid/subid/cid: 1/1/0, nestlvl: 1, children: <>
> > DEBUG: start transaction
> > DEBUG: creating bootstrap relation pg_proc 1255
> > DEBUG: column proname name
> >
> >
> >
> > Regards
> > DROR
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 4: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
> --
> Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
> Pervasive Software http://pervasive.com work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
>
>

_____

Express yourself instantly with Windows Live Messenger! Windows Live Messenger! <http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=joinmsncom/messenger>