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

2008-03-13 Thread Albe Laurenz
Tri Quach wrote:
 When I tried to install, I got this error.
 
 [EMAIL PROTECTED] pq8.2.6]# rpmbuild --rebuild --define 'buildrhel3 1' 
 postgresql-8.2.6-1PGDG.f8.src.rpm
 -bash: rpmbuild: command not found
 
 Do you know where can I download rpmbuild for RHEL 3?

You cannot download it, but it is on one of your RHEL CDs.
All you have to do is install it from there.

If you don't have rpmbuild installed, chances are that you are missing
many other build requisites too.
Do you have gcc? gmake?
You might end up installing a whole lot of software on your
machine, but it should work eventually.

Yours,
Laurenz Albe

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


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

2008-03-12 Thread Tri Quach
Hi Devrim,

When I tried to install, I got this error.

[EMAIL PROTECTED] pq8.2.6]# rpmbuild --rebuild --define 'buildrhel3 1'
postgresql-8.2.6-1PGDG.f8.src.rpm
-bash: rpmbuild: command not found


Do you know where can I download rpmbuild for RHEL 3?

Thank you for your help,
Tri

-Original Message-
From: Devrim GÜNDÜZ [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 11, 2008 2:40 PM
To: Tri Quach
Cc: PostgreSQL - General ML
Subject: RE: [GENERAL] Relocation error:/usr/lib/libpq.so.5:undefinedsymbol:
krb5_cc_get_principal

Hi,

On Tue, 2008-03-11 at 14:27 -1000, Tri Quach wrote:

 It is RHEL 3.

The packages you are installing are for RHEL 4, which won't install on
RHEL 3 correctly. Unfortunately, we don't have RHEL 3 - x86_64 packages.
Please download:

http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.2.6
%2Flinux%2Fsrpms%2Fredhat%2Frhel-3.0-x86_64%2Fpostgresql-8.2.6-1PGDG.f8.src.
rpm

and rebuild it on your server with:

rpmbuild --rebuild --define 'buildrhel3 1' postgresql-8.2.6-1PGDG.f8.src.rpm

You can find more information about this process at:

http://pgfoundry.org/docman/view.php/148/1338/PostgreSQL-RPM-Installatio
n-PGDG.pdf

-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/


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


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

2008-03-11 Thread Tri Quach
Hi Devrim,

Thank you for your help.

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

[EMAIL PROTECTED] 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.


[EMAIL PROTECTED] 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


 [EMAIL PROTECTED] pq8.2.6]# rpm -qa |grep postgresql
[EMAIL PROTECTED] pq8.2.6]# rpm -ivh
compat-postgresql-libs-4-2PGDG.rhel4.x86_64.rpmPreparing...
### [100%]
   1:compat-postgresql-libs ###
[100%]
[EMAIL PROTECTED] 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%]
[EMAIL PROTECTED] 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%]
[EMAIL PROTECTED] 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%]


[EMAIL PROTECTED] 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:[EMAIL PROTECTED] 
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

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

2008-03-11 Thread Devrim GÜNDÜZ
Hi,

On Tue, 2008-03-11 at 11:53 -1000, Tri Quach wrote:
 Our server is Red Hat Enterprise Linux 4 (64-bit).
 
 [EMAIL PROTECTED] 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/


signature.asc
Description: This is a digitally signed message part


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

2008-03-11 Thread Devrim GÜNDÜZ
Hi,

On Tue, 2008-03-11 at 14:27 -1000, Tri Quach wrote:

 It is RHEL 3.

The packages you are installing are for RHEL 4, which won't install on
RHEL 3 correctly. Unfortunately, we don't have RHEL 3 - x86_64 packages.
Please download:

http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.2.6%2Flinux%2Fsrpms%2Fredhat%2Frhel-3.0-x86_64%2Fpostgresql-8.2.6-1PGDG.f8.src.rpm

and rebuild it on your server with:

rpmbuild --rebuild --define 'buildrhel3 1' postgresql-8.2.6-1PGDG.f8.src.rpm

You can find more information about this process at:

http://pgfoundry.org/docman/view.php/148/1338/PostgreSQL-RPM-Installation-PGDG.pdf

-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/


signature.asc
Description: This is a digitally signed message part