Error building PHP with PostgreSQL support

[Robert Fitzpatrick]

I am getting the following problem with trying to install from source
PHP 4.3.6 with PG support on FreeBSD 5.2.1. I have PostgreSQL 7.4.2
recently upgraded from 7.3.x and it is up and running fine. I also have
Heimdal 0.6 installed and PostgreSQL was built with that support. Is the
error below from something missing on the Heimdal side of things or
PostgreSQL? And what does anyone suggest to resolve the issue? Maybe I
need to rebuild Heimdal since upgrading PostgreSQL with krb5 support?

/usr/local/lib/libc-client4.so: warning: tmpnam() possibly used
unsafely; consider using mkstemp()
/usr/local/lib/libpq.so: undefined reference to `krb5_cc_get_pr incipal'
/usr/local/lib/libpq.so: undefined reference to
`krb5_sname_to_ principal'
/usr/local/lib/libpq.so: undefined reference to `krb5_cc_defaul t'
/usr/local/lib/libpq.so: undefined reference to `krb5_cc_close'
/usr/local/lib/libpq.so: undefined reference to `error_message'
/usr/local/lib/libpq.so: undefined reference to `krb5_free_erro r'
/usr/local/lib/libpq.so: undefined reference to `krb5_sendauth'
/usr/local/lib/libpq.so: undefined reference to `krb5_free_prin cipal'
/usr/local/lib/libpq.so: undefined reference to `krb5_unparse_n ame'
/usr/local/lib/libpq.so: undefined reference to `krb5_free_cont ext'
/usr/local/lib/libpq.so: undefined reference to `krb5_init_cont ext'
*** Error code 1

--
Robert
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Joshua D. Drake]

Hello,

It looks like you compiled PostgreSQL with kerberos support. You
probably need to add a
-lkrb5 or something to your link line.

J
Robert Fitzpatrick wrote:

I am getting the following problem with trying to install from source
PHP 4.3.6 with PG support on FreeBSD 5.2.1. I have PostgreSQL 7.4.2
recently upgraded from 7.3.x and it is up and running fine. I also have
Heimdal 0.6 installed and PostgreSQL was built with that support. Is the
error below from something missing on the Heimdal side of things or
PostgreSQL? And what does anyone suggest to resolve the issue? Maybe I
need to rebuild Heimdal since upgrading PostgreSQL with krb5 support?

/usr/local/lib/libc-client4.so: warning: tmpnam() possibly used
unsafely; consider using mkstemp()
/usr/local/lib/libpq.so: undefined reference to `krb5_cc_get_pr incipal'
/usr/local/lib/libpq.so: undefined reference to
`krb5_sname_to _principal'
/usr/local/lib/libpq.so: undefined reference to `krb5_cc_defaul t'
/usr/local/lib/libpq.so: undefined reference to `krb5_cc_close'
/usr/local/lib/libpq.so: undefined reference to `error_message'
/usr/local/lib/libpq.so: undefined reference to `krb5_free_erro r'
/usr/local/lib/libpq.so: undefined reference to `krb5_sendauth'
/usr/local/lib/libpq.so: undefined reference to `krb5_free_prin cipal'
/usr/local/lib/libpq.so: undefined reference to `krb5_unparse_n ame'
/usr/local/lib/libpq.so: undefined reference to `krb5_free_cont ext'
/usr/local/lib/libpq.so: undefined reference to `krb5_init_cont ext'
*** Error code 1

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
[phone] - jd@commandpromp t.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend