Re: [Dspace-tech] Help needed with DBD::Pg
yum install perl-DBD-Pg.x86_64 worked fine for me. Really you shouldn't be building it by hand unless you have specific requirements about the build, or it isn't supported by your package manager. Jim On Mon, Jun 04, 2007 at 01:51:45PM +0930, Steve Thomas wrote: Hi. I'm wondering if anyone has installed the DBD::Pg perl module on RedHat? (RHEL) I'm having severe problems trying to get it to build. I have PostgreSQL 8.2.4 installed from a package. The DBD::Pg install requires pg_config from the development kit, so I've unpacked that and ran gmake to build pg_config. But I still cannot get the make for DBD::Pg to run - it crashes immediately with this: $ make gcc -c -I/home/uals/kit/postgresql-8.2.4/src/include -I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/home/uals/kit/postgresql-8.2.4/src/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -DPGLIBVERSION=80204 -DPGDEFPORT=5432 -O2 -g -pipe -m64 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\1.49\ -DXS_VERSION=\1.49\ -fPIC -I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE Pg.c In file included from Pg.xs:14: Pg.h:21:22: libpq-fe.h: No such file or directory In file included from Pg.h:47, from Pg.xs:14: dbdimp.h:36: error: syntax error before PGconn dbdimp.h:36: warning: no semicolon at end of struct or union etc. for about another hundred error lines. (This was after I tinkered with the DBD::Pg Makefile to adjust the erroneous paths provided by pg_config! Which made no difference.) I am afraid that at this point I am stumped. Any clues as to what to try next will be warmly welcomed. Steve Stephen Thomas, Senior Systems Analyst, University of Adelaide Library UNIVERSITY OF ADELAIDE SA 5005 AUSTRALIA Phone: +61 8 830 35190 Fax: +61 8 830 34369 Email: [EMAIL PROTECTED] URL: http://www.adelaide.edu.au/directory/stephen.thomas CRICOS Provider Number 00123M --- This email message is intended only for the addressee(s) and contains information that may be confidential and/or copyright. If you are not the intended recipient please notify the sender by reply email and immediately delete this email. Use, disclosure or reproduction of this email by anyone other than the intended recipient(s) is strictly prohibited. No representation is made that this email or any attachments are free of viruses. Virus scanning is recommended and is the responsibility of the recipient. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- James Rutherford | Hewlett-Packard Limited registered Office: Research Engineer | Cain Road, HP Labs | Bracknell, Bristol, UK | Berks +44 117 312 7066 | RG12 1HN. [EMAIL PROTECTED] | Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as HP CONFIDENTIAL. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Help needed with DBD::Pg
On Mon, 2007-06-04 at 13:51 +0930, Steve Thomas wrote: I have PostgreSQL 8.2.4 installed from a package. The DBD::Pg install requires pg_config from the development kit, so I've unpacked that and ran gmake to build pg_config. But I still cannot get the make for DBD::Pg to run - it crashes immediately with this: $ make [...] Pg.h:21:22: libpq-fe.h: No such file or directory In file included from Pg.h:47, from Pg.xs:14: dbdimp.h:36: error: syntax error before PGconn dbdimp.h:36: warning: no semicolon at end of struct or union etc. for about another hundred error lines. (This was after I tinkered with the DBD::Pg Makefile to adjust the erroneous paths provided by pg_config! Which made no difference.) The libpq-fe.h file that gcc is unable to find while attempting to compile the code is the primary header file of the postqres C client development library. It defines the PGconn and other API datastructures. It's been many years since I've used RedHat with postgres. But, as I recall there was a postgres-devel package or something similar that would install this header file along with the libpq shared library. You may want to check and make sure that you have all of the postgres devel packages installed. A missing devel package and a lack of a correct devel package dependency in the perl module package would explain why this would work for some people and not others. If there is no longer a devel package, or you already have it installed, you can use 'locate' to find the libpq-fe.h header file. Then, you can either pass the appropriate arugment to './configure' to include that include file path in the include paths or, if that is not possible, edit the make file to include the path of its location after a '-I' argument to gcc. As far as I can remember, I think RedHat used to install these files in strange places like a directories called postgres in /usr/include and /usr/lib rather than those directories themselves. So, you should also be able to fix your problem by symlinking, or moving, those files into the UNIX standard directories for their file type. Although, that type of action would make it more difficult to maintain your install over time as you performed postgres upgrades. Therefor, it would be best to attempt to resolve your issue, as James suggests - by relying on the distributions packages. Reinstalling the packages can sometimes clear up the types of problems you're seeing, especially if the source code and configurations of those packages have been modified. I hope my explanation of what I believe the problem to be has made it easier for you to figure out how to correct it. - VAB signature.asc Description: This is a digitally signed message part - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Help needed with DBD::Pg
Hi. I'm wondering if anyone has installed the DBD::Pg perl module on RedHat? (RHEL) I'm having severe problems trying to get it to build. I have PostgreSQL 8.2.4 installed from a package. The DBD::Pg install requires pg_config from the development kit, so I've unpacked that and ran gmake to build pg_config. But I still cannot get the make for DBD::Pg to run - it crashes immediately with this: $ make gcc -c -I/home/uals/kit/postgresql-8.2.4/src/include -I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/home/uals/kit/postgresql-8.2.4/src/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -DPGLIBVERSION=80204 -DPGDEFPORT=5432 -O2 -g -pipe -m64 -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\1.49\ -DXS_VERSION=\1.49\ -fPIC -I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE Pg.c In file included from Pg.xs:14: Pg.h:21:22: libpq-fe.h: No such file or directory In file included from Pg.h:47, from Pg.xs:14: dbdimp.h:36: error: syntax error before PGconn dbdimp.h:36: warning: no semicolon at end of struct or union etc. for about another hundred error lines. (This was after I tinkered with the DBD::Pg Makefile to adjust the erroneous paths provided by pg_config! Which made no difference.) I am afraid that at this point I am stumped. Any clues as to what to try next will be warmly welcomed. Steve Stephen Thomas, Senior Systems Analyst, University of Adelaide Library UNIVERSITY OF ADELAIDE SA 5005 AUSTRALIA Phone: +61 8 830 35190 Fax: +61 8 830 34369 Email: [EMAIL PROTECTED] URL: http://www.adelaide.edu.au/directory/stephen.thomas CRICOS Provider Number 00123M --- This email message is intended only for the addressee(s) and contains information that may be confidential and/or copyright. If you are not the intended recipient please notify the sender by reply email and immediately delete this email. Use, disclosure or reproduction of this email by anyone other than the intended recipient(s) is strictly prohibited. No representation is made that this email or any attachments are free of viruses. Virus scanning is recommended and is the responsibility of the recipient. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech