Thread: Relocation error: /usr/lib/libpq.so.5: undefined symbol: krb5_cc_get_principal

Hi All,

 

I wonder if you can help me out.

I already installed PostgreSQL 8.2.3 without error.

 

postgresql-8.2.3-1PGDG.x86_64.rpm

postgresql-libs-8.2.3-1PGDG.x86_64.rpm

postgresql-server-8.2.3-1PGDG.x86_64.rpm

 

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

Then I tried to install ListManager 9.3b.  I got this error.  The software was not able to connect to the database.  Please the error below.  Any help you can provide will be greatly appreciated. 

 

Thank you for your help.

Tri.

 

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

 

 

Checking database connection...

 

Running command: "/usr/local/lm/bin/lm version"

Attempting to connect to server: /usr/local/lm/bin/lm: relocation error: /usr/lib/libpq.so.5: undefined symbol: krb5_cc_get_principal

Tried to run: /usr/local/lm/bin/lm version

Command failed (return value: 32512)

 

 

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

 

Failed to connect to the database using specified parameters.

 

Install cannot continue without a valid database connection.

 

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/

Attachment
Hi Devrim,

Thank you for your help.

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

[root@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@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@lyris3 pq8.2.6]# rpm -qa |grep postgresql
[root@lyris3 pq8.2.6]# rpm -ivh
compat-postgresql-libs-4-2PGDG.rhel4.x86_64.rpmPreparing...
########################################### [100%]
   1:compat-postgresql-libs ###########################################
[100%]
[root@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@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@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@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@CommandPrompt.com]
Sent: Monday, March 10, 2008 7:34 PM
To: Tri Quach
Cc: pgsql-general@postgresql.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/


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

From
Devrim GÜNDÜZ
Date:
Hi,

On Tue, 2008-03-11 at 11:53 -1000, Tri Quach wrote:
> Our server is Red Hat Enterprise Linux 4 (64-bit).
>
> [root@lyris3 lm-9.3b-pgsql-linux-rh-enterprise_3]#
                           ^^^^^

RHEL 3 or RHEL 4?

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/

Attachment