Re: Fw: configure error with krb5

kanchana wrote:
> Hello Bruce Momjian,
>
> Thanks a lot for all. I tried by adding -lcurses on link line of psql.
> Looks like it works fine.
>
> Next i moved to compile with krb5, it gives error.
> as follows..........
> #./configure --prefix=/opt/postgresql --enable-integer-datetimes --with-open
> ssl=/usr/local/ssl --with-krb5=/usr/local/krb5
>
> ----------no problem here.
>
> #gmake gives ERROR
> :
> :
> /usr/ccs/bin/ld -b +b /opt/postgresql/lib fe-auth.o fe-connect.o fe-exec.o
> fe-misc.o fe-print.o fe-lobj.o pqexpbuffer.o dllist.o md5.o pqsignal.o
> fe-secure.o wchar.o
> encnames.o -L/usr/local/krb5/lib -L/usr/local/ssl/lib -lssl -lcrypto -lkrb5
> -lk5crypto -lcom_err -lnsl -o libpq.sl
> /usr/ccs/bin/ld: (Warning) At least one PA 2.0 object file (fe-auth.o) was
> detected. The linked output may not run on a PA 1.x system.
> /usr/ccs/bin/ld: DP relative code in file
> /usr/local/krb5/lib/libkrb5.a(init_ctx.o) - shared library must be position
> independent. Use +z or +Z to recompile.

Right here, it looks like the k5crypto library wasn't created properly.
I think the problem is that it is trying to create a shared libpq, but
kerberos is a non-shared *.a library, or has non-shared object files in
it. Just a guess, of course.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Hello Bruce Momjian,

Thanks for your times and replies. Once i recompiled krb5 with -fPIC option,
it (postgresql) compiles fine.
Again thanks.

Regards,
-Kanchana

> kanchana wrote:
> > Hello Bruce Momjian,
> >
> > Thanks a lot for all. I tried by adding -lcurses on link line of
psql.
> > Looks like it works fine.
> >
> > Next i moved to compile with krb5, it gives error.
> > as follows..........
> >
#./configure --prefix=/opt/postgresql --enable-integer-datetimes --with-open
> > ssl=/usr/local/ssl --with-krb5=/usr/local/krb5
> >
> > ----------no problem here.
> >
> > #gmake gives ERROR
> > :
> > :
> > /usr/ccs/bin/ld -b +b /opt/postgresql/lib fe-auth.o fe-connect.o
fe-exec.o
> > fe-misc.o fe-print.o fe-lobj.o pqexpbuffer.o dllist.o md5.o pqsignal.o
> > fe-secure.o wchar.o
> >
encnames.o -L/usr/local/krb5/lib -L/usr/local/ssl/lib -lssl -lcrypto -lkrb5
> > -lk5crypto -lcom_err -lnsl -o libpq.sl
> > /usr/ccs/bin/ld: (Warning) At least one PA 2.0 object file (fe-auth.o)
was
> > detected. The linked output may not run on a PA 1.x system.
> > /usr/ccs/bin/ld: DP relative code in file
> > /usr/local/krb5/lib/libkrb5.a(init_ctx.o) - shared library must be
position
> > independent. Use +z or +Z to recompile.
>
> Right here, it looks like the k5crypto library wasn't created properly.
> I think the problem is that it is trying to create a shared libpq, but
> kerberos is a non-shared *.a library, or has non-shared object files in
> it. Just a guess, of course.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania
19073
>

Hello Bruce Momjian,

I done sucessfully for hp-ux pa-risc. Then i treid to work on IA64.
Configure ok but "gmake" gives following error..

Plz tel me how to overcome this.

Advance thanks for your time and efforts.
:
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/
include -I/home/saratha/krb5/include -I/usr/local/ssl/include -c -o float.o
float.c
float.c: In function `float4out':
float.c:233: Internal compiler error in emit_move_insn, at expr.c:2739
Please submit a full bug report,
with preprocessed source if appropriate.
See <URL:http://www.gnu.org/software/gcc/bugs.html> for instructions.
gmake[4]: *** [float.o] Error 1
gmake[4]: Leaving directory `src/backend/utils/adt'
gmake[3]: *** [adt-recursive] Error 2
gmake[3]: Leaving directory `src/backend/utils'
gmake[2]: *** [utils-recursive] Error 2
gmake[2]: Leaving directory `src/backend'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `src'
gmake: *** [all] Error 2

Regards,
-Kanchana
> kanchana wrote:
> > Hello Bruce Momjian,
> >
> > Thanks a lot for all. I tried by adding -lcurses on link line of
psql.
> > Looks like it works fine.
> >
> > Next i moved to compile with krb5, it gives error.
> > as follows..........
> >
#./configure --prefix=/opt/postgresql --enable-integer-datetimes --with-open
> > ssl=/usr/local/ssl --with-krb5=/usr/local/krb5
> >
> > ----------no problem here.
> >
> > #gmake gives ERROR
> > :
> > :
> > /usr/ccs/bin/ld -b +b /opt/postgresql/lib fe-auth.o fe-connect.o
fe-exec.o
> > fe-misc.o fe-print.o fe-lobj.o pqexpbuffer.o dllist.o md5.o pqsignal.o
> > fe-secure.o wchar.o
> >
encnames.o -L/usr/local/krb5/lib -L/usr/local/ssl/lib -lssl -lcrypto -lkrb5
> > -lk5crypto -lcom_err -lnsl -o libpq.sl
> > /usr/ccs/bin/ld: (Warning) At least one PA 2.0 object file (fe-auth.o)
was
> > detected. The linked output may not run on a PA 1.x system.
> > /usr/ccs/bin/ld: DP relative code in file
> > /usr/local/krb5/lib/libkrb5.a(init_ctx.o) - shared library must be
position
> > independent. Use +z or +Z to recompile.
>
> Right here, it looks like the k5crypto library wasn't created properly.
> I think the problem is that it is trying to create a shared libpq, but
> kerberos is a non-shared *.a library, or has non-shared object files in
> it. Just a guess, of course.
>

"kanchana" <pkkanchana(at)gmx(dot)net> writes:
> gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/
> include -I/home/saratha/krb5/include -I/usr/local/ssl/include -c -o float.o
> float.c
> float.c: In function `float4out':
> float.c:233: Internal compiler error in emit_move_insn, at expr.c:2739
> Please submit a full bug report,
> with preprocessed source if appropriate.
> See <URL:http://www.gnu.org/software/gcc/bugs.html> for instructions.

Please observe that gcc's failure message tells you to report it to the
gcc project. This is not Postgres' problem.

regards, tom lane

Hello Tom,

Thanks for your reply, as i'm not positon to upgrade gcc, i tried to build
using CC=cc
it compile fine.

while testing, as follows error came(initdb failed)

#adduser postgres
#mkdir /opt/postgresql/data
#chown postgres /opt/postgresql/data
#su - postgres
$/opt/postgresql/bin/initdb -D /opt/postgresql/data

The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

Fixing permissions on existing directory /opt/postgresql/data... ok
creating directory /opt/postgresql/data/base... ok
creating directory /opt/postgresql/data/global... ok
creating directory /opt/postgresql/data/pg_xlog... ok
creating directory /opt/postgresql/data/pg_clog... ok
creating template1 database in /opt/postgresql/data/base/1...
initdb failed.
$

How to overcome? I don't know what may cause this problem.

Plz help me asap.

Advance thanks.

Regards,
-Kanchana

> "kanchana" <pkkanchana(at)gmx(dot)net> writes:
> >
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/
> > include -I/home/saratha/krb5/include -I/usr/local/ssl/include -c -o
float.o
> > float.c
> > float.c: In function `float4out':
> > float.c:233: Internal compiler error in emit_move_insn, at expr.c:2739
> > Please submit a full bug report,
> > with preprocessed source if appropriate.
> > See <URL:http://www.gnu.org/software/gcc/bugs.html> for instructions.
>
> Please observe that gcc's failure message tells you to report it to the
> gcc project. This is not Postgres' problem.
>
> regards, tom lane
>

"kanchana" <pkkanchana(at)gmx(dot)net> writes:
> creating template1 database in /opt/postgresql/data/base/1...
> initdb failed.

Try it as
initdb -d [other options as before] 2>initdb.err
initdb.err will probably be voluminous, but show us the last
couple dozen lines.

regards, tom lane

Hello Tom,

It(inidb.err) shows error as follows...........
____________________________________________________________________________
_________________
DEBUG: Typ == NULL, typeindex = 11
DEBUG: -> 1184
DEBUG: inserted
DEBUG: inserting column 11 value '1082 1083select timestamptz($1 + $2)'
DEBUG: Typ == NULL, typeindex = 15
ERROR: oidvectorin: error in "select timestamptz($1 + $2)": can't parse
"select
timestamptz($1 + $2)"
DEBUG: proc_exit(1)
DEBUG: shmem_exit(1)
DEBUG: exit(1)

initdb failed.
____________________________________________________________________________
___________________
How to overcome this.
Advance thanks.

Regards,
-Kanchana

> "kanchana" <pkkanchana(at)gmx(dot)net> writes:
> > creating template1 database in /opt/postgresql/data/base/1...
> > initdb failed.
>
> Try it as
> initdb -d [other options as before] 2>initdb.err
> initdb.err will probably be voluminous, but show us the last
> couple dozen lines.
>
> regards, tom lane
>

"kanchana" <pkkanchana(at)gmx(dot)net> writes:
> It(inidb.err) shows error as follows...........

> DEBUG: inserting column 11 value '1082 1083select timestamptz($1 + $2)'
> DEBUG: Typ == NULL, typeindex = 15
> ERROR: oidvectorin: error in "select timestamptz($1 + $2)": can't parse
> "select timestamptz($1 + $2)"

Hm. There seems to be something wrong with your postgres.bki file. It
looks like initdb is working on what should be this line:

insert OID = 1176 ( timestamptz 11 1 14 f f t f s 2 1184 "1082 1083" "select timestamptz($1 + $2)" - _null_ )

but for some reason the two separate columns "1082 1083" and "select timestamptz($1 + $2)"
have gotten run together. You should look at the .bki file to confirm
that there is something wrong with it and not with the initdb code; but
assuming that the file is misconstructed, I'd have to guess there is a
problem with the 'sed' or 'awk' installed on your machine, because those
programs are what are used to construct it.

Another possibility is that you have a corrupted download of Postgres,
with some error in the source file (include/pg_proc.h) that generates
this .bki entry.

regards, tom lane

Hello Tom,

Thanks a lot for your respone. I treid with new source, again same
probelm.
So i edited postgres.bki file as you sent(missind quotes..). Once i give
quotes as follows..it works fine.
i.e.
in .bki file,
for ex..

insert OID = 1176 ( timestamptz 11 1 14 f f t f s 2 1184 "1082 1083select
timestamptz($1 + $2)" - _null_ ) ----------TO --------------->
insert OID = 1176 ( timestamptz 11 1 14 f f t f s 2 1184 "1082 1083" "select
timestamptz($1 + $2)" - _null_ )

One simple Q!, now no problem, postgresql works fine.
* is there any problem with the 'sed' or 'awk' installed on my
machine(made me to edit .bki file)
* i builded wih --with-krb5, how to test krb5 authentication to find whether
it works fine or not. plz point me any link or steps.

Thanks and Regards,
-Kanchana

> "kanchana" <pkkanchana(at)gmx(dot)net> writes:
> > It(inidb.err) shows error as follows...........
>
> > DEBUG: inserting column 11 value '1082 1083select timestamptz($1 + $2)'
> > DEBUG: Typ == NULL, typeindex = 15
> > ERROR: oidvectorin: error in "select timestamptz($1 + $2)": can't parse
> > "select timestamptz($1 + $2)"
>
> Hm. There seems to be something wrong with your postgres.bki file. It
> looks like initdb is working on what should be this line:
>
> insert OID = 1176 ( timestamptz 11 1 14 f f t f s 2 1184 "1082 1083"
"select timestamptz($1 + $2)" - _null_ )
>
> but for some reason the two separate columns "1082 1083" and "select
timestamptz($1 + $2)"
> have gotten run together. You should look at the .bki file to confirm
> that there is something wrong with it and not with the initdb code; but
> assuming that the file is misconstructed, I'd have to guess there is a
> problem with the 'sed' or 'awk' installed on your machine, because those
> programs are what are used to construct it.
>
> Another possibility is that you have a corrupted download of Postgres,
> with some error in the source file (include/pg_proc.h) that generates
> this .bki entry.
>
> regards, tom lane
>

"kanchana" <pkkanchana(at)gmx(dot)net> writes:
> So i edited postgres.bki file as you sent(missind quotes..). Once i give
> quotes as follows..it works fine.

okay ...

> * is there any problem with the 'sed' or 'awk' installed on my
> machine(made me to edit .bki file)

Evidently. Or maybe we're doing something non-portable, though I'd have
thought any such problem would have been noticed before now. If you
want to dig into it, you can look at src/backend/catalog/genbki.sh,
which is the shell script that builds postgres.bki from the input files
in src/include/catalog --- in particular, pg_proc.h is the one that
gives rise to the line that's gettting munged. Perhaps you could trace
through genbki.sh and figure out just what's going wrong? Then you
could either send in a bug report against your sed or awk, or let us
know how we blew it.

> * i builded wih --with-krb5, how to test krb5 authentication to find whether
> it works fine or not. plz point me any link or steps.

Sorry, I know nothing at all about Kerberos. Anyone out there?

regards, tom lane

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> "kanchana" <pkkanchana(at)gmx(dot)net> writes:
> > gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/
> > include -I/home/saratha/krb5/include -I/usr/local/ssl/include -c -o float.o
> > float.c
> > float.c: In function `float4out':
> > float.c:233: Internal compiler error in emit_move_insn, at expr.c:2739
> > Please submit a full bug report,
> > with preprocessed source if appropriate.
> > See <URL:http://www.gnu.org/software/gcc/bugs.html> for instructions.
>
> Please observe that gcc's failure message tells you to report it to the
> gcc project. This is not Postgres' problem.

If you see the same bug repeatably it's a gcc bug. but if you see a different
message each time you try to compile it's more likely you have bad memory in
the machine. It's worth running a memory checker like memtest86 anyways, it
can't hurt. Bad memory is really quite common.

--
greg