[BUGS] WARNING: uuid.h: present but cannot be compiled

2009-04-17 Thread David E. Wheeler
I'm building 8.4beta1 on Mac OS X 10.5.6. I have ossp-uuid installed  
with its includes in /usr/local/include/ossp-uuid. I'm building  
PostgreSQL like so:


export CPPFLAGS="-I/usr/local/include/ossp-uuid"
./configure --with-libedit-preferred --with-bonjour --with-perl PERL=/ 
user/local/bin/perl \
--with-openssl --with-pam --with-krb5 --with-libxml --with-ldap --with- 
ossp-uuid \
--with-libs=/usr/local/lib --with-includes=/usr/local/include -- 
prefix=/usr/local/pgsql


Configure generates this warning:

checking uuid.h presence... yes
configure: WARNING: uuid.h: present but cannot be compiled
configure: WARNING: uuid.h: check for missing prerequisite headers?
configure: WARNING: uuid.h: see the Autoconf documentation
configure: WARNING: uuid.h: section "Present But Cannot Be Compiled"
configure: WARNING: uuid.h: proceeding with the preprocessor's result
configure: WARNING: uuid.h: in the future, the compiler will take  
precedence

configure: WARNING: ##  ##
configure: WARNING: ## Report this to pgsql-bugs@postgresql.org ##
configure: WARNING: ##  ##
checking for uuid.h... yes

I guess it's finding Apple's uuid.h and not OSSP's? Do I need to set  
some other environment variable to tell PostgreSQL where to find the  
ossp uuid include?


BTW, I moved OSSP's uuid.h because it caused conflicts with other apps  
that just need Apple's uuid.h. This is a known issue for OSSP UUID:


  http://cvs.ossp.org/tktview?tn=164

Best,

David

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


[BUGS] BUG #4761: service not starts

2009-04-17 Thread Roberto Colmegna

The following bug has been logged online:

Bug reference:  4761
Logged by:  Roberto Colmegna
Email address:  rcolme...@tiscali.it
PostgreSQL version: 8.4.0-1b1
Operating system:   win XP SP1
Description:service not starts
Details: 

Hi,

I have installed the 8.4 beta on a previous installed
8.3 WinXP PC.  The PC isn't registered in an active-dir
environment.

Starting 8.4 service I obtain this error:

%t FATAL:  could not create lock file "postmaster.pid": Permission denied

The error is accessibile via eventvwr.

No way found to start PG 8.4 ... :(

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] WARNING: uuid.h: present but cannot be compiled

2009-04-17 Thread Tom Lane
"David E. Wheeler"  writes:
> I'm building 8.4beta1 on Mac OS X 10.5.6. I have ossp-uuid installed  
> with its includes in /usr/local/include/ossp-uuid.

Well, then you would need --with-includes=/usr/local/include/ossp-uuid
(don't bother setting CPPFLAGS in addition).

> I guess it's finding Apple's uuid.h and not OSSP's?

Yeah, that's what it looks like, although it's odd that that fails
to compile.

regards, tom lane

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


[BUGS] BUG #4763: postgres service unstable, even during install

2009-04-17 Thread Kevin Field

The following bug has been logged online:

Bug reference:  4763
Logged by:  Kevin Field
Email address:  k...@brantaero.com
PostgreSQL version: 8.4-beta1
Operating system:   Windows Server 2003 Standard Edition SP2
Description:postgres service unstable, even during install
Details: 

Using
http://www.postgresql.org/ftp/binary/v8.4beta/win32/postgresql-8.4-beta1.zip
on a console mode session with SAV autoprotect disabled (and besides told to
exclude anything below "C:\Program Files\PostgreSQL\"), three times now I've
tried to install (no stack builder, then adminpack+fuzzystring+pldebugger
and plpgsql+plperl+plperlu) and encountered the following problems.

The installer gets to the step "Activating procedural languages..." and an
error window pops up:

Database command error: server closed the connection unexpectedly
[square character]This probably means the server terminated abnormally
[square character]before or while processing the request

...and indeed, the service is not running.  If I follow along with the
Services window open during install, at one point the new service shows up
and has status "Starting..." but I'm not sure if it fails to start or if it
starts and then the procedural language thing makes it bail.

I OK the box and another one comes:

"Failed to enable procedural language plperl.  The files are installed but
are not activated in any database."

And another:

"Database command error: no connection to the server"

Then repeat the last two for "plperlu (untrusted)".  Then:

"Failed to connect to the 'template1' database.  Contrib files are
installed, but are not activated in any databases."

...and then finally "Could not connect to server" and asking whether it's
accepting connections.

If after the very first error message I go into Services and start it
manually, the last two messages here do not come up, but the rest still do.

Then I get a success message.

However, after that when I try to run a script to dump another database and
restore it onto the beta, I get a "file not found" error, which is really
odd both because it was working fine on the 2009-03-24 build and because the
permissions have not changed.  Aside from that, which is it's own problem,
after that error the service is no longer running and has to be started
again.

This makes me think that something similar happens during the install, so
that something fails with the plperl setup that causes the service to shut
down (rather than it failing to start up in the first place.)

Anyway both the 2009-01-01 and 2009-03-24 builds seemed smoother to set up
and much more stable.  Not sure why that would be...

Thanks,
Kev

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] WARNING: uuid.h: present but cannot be compiled

2009-04-17 Thread David E. Wheeler

On Apr 17, 2009, at 7:08 AM, Tom Lane wrote:


"David E. Wheeler"  writes:

I'm building 8.4beta1 on Mac OS X 10.5.6. I have ossp-uuid installed
with its includes in /usr/local/include/ossp-uuid.


Well, then you would need --with-includes=/usr/local/include/ossp-uuid
(don't bother setting CPPFLAGS in addition).


Duh, I already had --with-includes for another directory. Thanks.


I guess it's finding Apple's uuid.h and not OSSP's?


Yeah, that's what it looks like, although it's odd that that fails
to compile.


Yeah, seems odd…

Best,

David


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] WARNING: uuid.h: present but cannot be compiled

2009-04-17 Thread David E . Wheeler

On Apr 17, 2009, at 10:21 AM, David E. Wheeler wrote:


On Apr 17, 2009, at 9:22 AM, David E. Wheeler wrote:

So does it not know to look in /usr/local/include/ossp-uuid when  
it's looking for uuid.h?


Tried a few more things. No matter where I put uuid.h, configure  
doesn't seem to find it. I put it in /usr/local/include and ran  
configure with --with-includes=/usr/local/include and it didn't find  
it. RhodiumToad said on IRC that it's looking for "ossp/uuid.h", so  
I tried putting it in /usr/local/include/ossp/ and ran configure  
with the same --with-include and it still didn't find it. So at this  
point, I'm unable to figure out how to get configure to find and use  
the OSSP uuid header. :-(


I take that back. It can find it in the ossp subdirectiry, as  
RhodiumToad said, but it can't compile it:


checking ossp/uuid.h usability... no
checking ossp/uuid.h presence... yes
configure: WARNING: ossp/uuid.h: present but cannot be compiled
configure: WARNING: ossp/uuid.h: check for missing prerequisite  
headers?

configure: WARNING: ossp/uuid.h: see the Autoconf documentation
configure: WARNING: ossp/uuid.h: section "Present But Cannot Be  
Compiled"
configure: WARNING: ossp/uuid.h: proceeding with the preprocessor's  
result
configure: WARNING: ossp/uuid.h: in the future, the compiler will take  
precedence

configure: WARNING: ##  ##
configure: WARNING: ## Report this to pgsql-bugs@postgresql.org ##
configure: WARNING: ##  ##
checking for ossp/uuid.h... yes

Best,

David


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] WARNING: uuid.h: present but cannot be compiled

2009-04-17 Thread Tom Lane
"David E. Wheeler"  writes:
> I take that back. It can find it in the ossp subdirectiry, as  
> RhodiumToad said, but it can't compile it:

> checking ossp/uuid.h usability... no
> checking ossp/uuid.h presence... yes
> configure: WARNING: ossp/uuid.h: present but cannot be compiled

Why not?  There should be compiler messages in config.log.

regards, tom lane

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] WARNING: uuid.h: present but cannot be compiled

2009-04-17 Thread David E . Wheeler


On Apr 17, 2009, at 10:47 AM, David E. Wheeler wrote:


On Apr 17, 2009, at 10:21 AM, David E. Wheeler wrote:


On Apr 17, 2009, at 9:22 AM, David E. Wheeler wrote:

So does it not know to look in /usr/local/include/ossp-uuid when  
it's looking for uuid.h?


Tried a few more things. No matter where I put uuid.h, configure  
doesn't seem to find it. I put it in /usr/local/include and ran  
configure with --with-includes=/usr/local/include and it didn't  
find it. RhodiumToad said on IRC that it's looking for "ossp/ 
uuid.h", so I tried putting it in /usr/local/include/ossp/ and ran  
configure with the same --with-include and it still didn't find it.  
So at this point, I'm unable to figure out how to get configure to  
find and use the OSSP uuid header. :-(


I take that back. It can find it in the ossp subdirectiry, as  
RhodiumToad said, but it can't compile it:


checking ossp/uuid.h usability... no
checking ossp/uuid.h presence... yes
configure: WARNING: ossp/uuid.h: present but cannot be compiled
configure: WARNING: ossp/uuid.h: check for missing prerequisite  
headers?

configure: WARNING: ossp/uuid.h: see the Autoconf documentation
configure: WARNING: ossp/uuid.h: section "Present But Cannot Be  
Compiled"
configure: WARNING: ossp/uuid.h: proceeding with the preprocessor's  
result
configure: WARNING: ossp/uuid.h: in the future, the compiler will  
take precedence

configure: WARNING: ##  ##
configure: WARNING: ## Report this to pgsql-bugs@postgresql.org ##
configure: WARNING: ##  ##
checking for ossp/uuid.h... yes


Oh, and despite that warning, I am in fact able to build and install  
the OSSP UUID contrib module. So I've no idea what that warning is  
about.


Best,

David

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] WARNING: uuid.h: present but cannot be compiled

2009-04-17 Thread David E. Wheeler

On Apr 17, 2009, at 11:08 AM, Tom Lane wrote:


"David E. Wheeler"  writes:

I take that back. It can find it in the ossp subdirectiry, as
RhodiumToad said, but it can't compile it:



checking ossp/uuid.h usability... no
checking ossp/uuid.h presence... yes
configure: WARNING: ossp/uuid.h: present but cannot be compiled


Why not?  There should be compiler messages in config.log.


Dunno. Here's the log for the latest build:




config.log.gz
Description: GNU Zip compressed data



Best,

David
-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] WARNING: uuid.h: present but cannot be compiled

2009-04-17 Thread Alvaro Herrera
David E. Wheeler wrote:
> On Apr 17, 2009, at 11:08 AM, Tom Lane wrote:
>
>> "David E. Wheeler"  writes:
>>> I take that back. It can find it in the ossp subdirectiry, as
>>> RhodiumToad said, but it can't compile it:
>>
>>> checking ossp/uuid.h usability... no
>>> checking ossp/uuid.h presence... yes
>>> configure: WARNING: ossp/uuid.h: present but cannot be compiled
>>
>> Why not?  There should be compiler messages in config.log.
>
> Dunno. Here's the log for the latest build:

configure:13224: checking ossp/uuid.h usability
configure:13241: gcc -no-cpp-precomp -c -O2 -Wall -Wmissing-prototypes 
-Wpointer-arith -Wdeclaration-after-statement -Wendif-labels 
-fno-strict-aliasing -fwrapv  -I/usr/local/include/libxml2  
-I/usr/local/include conftest.c >&5
In file included from conftest.c:98:
/usr/local/include/ossp/uuid.h:94: error: conflicting types for 'uuid_t'
/usr/include/unistd.h:133: error: previous declaration of 'uuid_t' was here

-- 
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] WARNING: uuid.h: present but cannot be compiled

2009-04-17 Thread David E. Wheeler

On Apr 17, 2009, at 11:28 AM, Alvaro Herrera wrote:


Dunno. Here's the log for the latest build:


configure:13224: checking ossp/uuid.h usability
configure:13241: gcc -no-cpp-precomp -c -O2 -Wall -Wmissing- 
prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif- 
labels -fno-strict-aliasing -fwrapv  -I/usr/local/include/libxml2  - 
I/usr/local/include conftest.c >&5

In file included from conftest.c:98:
/usr/local/include/ossp/uuid.h:94: error: conflicting types for  
'uuid_t'
/usr/include/unistd.h:133: error: previous declaration of 'uuid_t'  
was here


Oh, that old canard. So it's just http://cvs.ossp.org/tktview?tn=164  
again.


Thanks,

David

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs