Re: Relocation error: /usr/lib/libpq.so.5: undefinedsymbol: krb5_cc_get_principal

Hi Devrim,

Thank you for your help.

Our server is Red Hat Enterprise Linux 4 (64-bit).

[root(at)lyris3 lm-9.3b-pgsql-linux-rh-enterprise_3]# uname -a
Linux lyris3.k12.hi.us 2.4.21-20.EL #1 SMP Wed Aug 18 20:34:58 EDT 2004
x86_64 x86_64 x86_64 GNU/Linux

I uninstalled postgresql 8.2.3 and reinstalled pq8.2.6. When I tried to
install the ListManager, I still got same error. I am not sure if I
installed the right version. Please see below to see if you can point me to
the right direction.

Thank you for your help.
Tri.

----------------------------------------------------------------------------
[root(at)lyris3 pq8.2.6]# ls
compat-postgresql-libs-4-2PGDG.rhel4.x86_64.rpm
postgresql-8.2.6-1PGDG.rhel4.x86_64.rpm
postgresql-libs-8.2.6-1PGDG.rhel4.x86_64.rpm
postgresql-server-8.2.6-1PGDG.rhel4.x86_64.rpm

[root(at)lyris3 pq8.2.6]# rpm -qa |grep postgresql
[root(at)lyris3 pq8.2.6]# rpm -ivh
compat-postgresql-libs-4-2PGDG.rhel4.x86_64.rpmPreparing...
########################################### [100%]
1:compat-postgresql-libs ###########################################
[100%]
[root(at)lyris3 pq8.2.6]# rpm -ivh postgresql-libs-8.2.6-1PGDG.rhel4.x86_64.rpm
warning: postgresql-libs-8.2.6-1PGDG.rhel4.x86_64.rpm: V3 DSA signature:
NOKEY, key ID 20579f11
Preparing... ###########################################
[100%]
1:postgresql-libs ###########################################
[100%]
[root(at)lyris3 pq8.2.6]# rpm -ivh postgresql-8.2.6-1PGDG.rhel4.x86_64.rpm
warning: postgresql-8.2.6-1PGDG.rhel4.x86_64.rpm: V3 DSA signature: NOKEY,
key ID 20579f11
Preparing... ###########################################
[100%]
1:postgresql ###########################################
[100%]
[root(at)lyris3 pq8.2.6]# rpm -ivh
postgresql-server-8.2.6-1PGDG.rhel4.x86_64.rpm
warning: postgresql-server-8.2.6-1PGDG.rhel4.x86_64.rpm: V3 DSA signature:
NOKEY, key ID 20579f11
Preparing... ###########################################
[100%]
1:postgresql-server ###########################################
[100%]

[root(at)lyris3 pq8.2.6]# su – postgres

-bash-2.05b$ initdb --lc-collate=C
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 locales
COLLATE: C
CTYPE: en_US.UTF-8
MESSAGES: en_US.UTF-8
MONETARY: en_US.UTF-8
NUMERIC: en_US.UTF-8
TIME: en_US.UTF-8
The default database encoding has accordingly been set to UTF8.

creating directory /var/lib/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ... 24MB/153600
creating configuration files ... ok
creating template1 database in /var/lib/pgsql/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can now start the database server using:

postgres -D /var/lib/pgsql/data
or
pg_ctl -D /var/lib/pgsql/data -l logfile start

-bash-2.05b$ syslog = 2
-bash: syslog: command not found
-bash-2.05b$ pg_ctl start
server starting
-bash-2.05b$ createuser -A -D -P nssb
Enter password for new role:
Enter it again:

Shall the new role be allowed to create more new roles? (y/n) n
createuser: relocation error: /usr/lib64/libpq.so.5: undefined symbol:
krb5_cc_get_principal
-bash-2.05b$ createdb --owner nssb nssbdatabase
createdb: relocation error: /usr/lib64/libpq.so.5: undefined symbol:
krb5_cc_get_principal

-bash-2.05b$ exit
logout

----------------------------------------------------------------------------

-----Original Message-----
From: Devrim GÜNDÜZ [mailto:devrim(at)CommandPrompt(dot)com]
Sent: Monday, March 10, 2008 7:34 PM
To: Tri Quach
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Relocation error: /usr/lib/libpq.so.5:
undefinedsymbol: krb5_cc_get_principal

Hi,

On Mon, 2008-03-10 at 16:35 -1000, Tri Quach wrote:
> I already installed PostgreSQL 8.2.3 without error.

Which distro/arch is this? Probably you installed a package set which is
not built for you distro.

Use 8.2.6 packages for your distro:

http://www.postgresql.org/ftp/binary/v8.2.6/linux/rpms/

or

http://yum.pgsqlrpms.org/

If your Linux distro is not among the listed ones, you will need to
rebuild the SRPM:

http://www.postgresql.org/ftp/binary/v8.2.6/linux/srpms/

-HTH.

Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/