Thread: trouble with pgaccess
I've just recently installed postgresql 6.4.2 from source. Installation
appeared to complete just fine. I'm just having trouble getting pgaccess
to work. I've read several files that supposedly explain how to fix the
problem I'm having, but I'm not having much luck, or don't undertand.
I keep getting the following error:
Error in startup script: couldn't load file "libpgtcl.so": libpgtcl.so:
cannot open shared object file: No such file or directory
while executing
"load libpgtcl.so"
(procedure "main" line 6)
invoked from within
"main $argc $argv"
(file "/usr/local/pgsql/bin/pgaccess" line 4954)
Any suggestions sure would be appreciated.
Kevin
--------------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612
kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------
Kevin Heflin wrote: > >I've just recently installed postgresql 6.4.2 from source. Installation >appeared to complete just fine. I'm just having trouble getting pgaccess >to work. I've read several files that supposedly explain how to fix the >problem I'm having, but I'm not having much luck, or don't undertand. > >I keep getting the following error: > >Error in startup script: couldn't load file "libpgtcl.so": libpgtcl.so: >cannot open shared object file: No such file or directory > while executing >"load libpgtcl.so" > (procedure "main" line 6) > invoked from within >"main $argc $argv" > (file "/usr/local/pgsql/bin/pgaccess" line 4954) Did you tell configure to build the pgtcl library? (Use the option --with-tcl) -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 ======================================== "My sheep hear my voice, and I know them, and they follow me; And I give unto them eternal life; and they shall never perish, neither shall any man pluck them out of my hand." John 10:27,28
On Sun, 21 Feb 1999, Oliver Elphick wrote: > Kevin Heflin wrote: > > > >I've just recently installed postgresql 6.4.2 from source. Installation > >appeared to complete just fine. I'm just having trouble getting pgaccess > >to work. I've read several files that supposedly explain how to fix the > >problem I'm having, but I'm not having much luck, or don't undertand. > > > >I keep getting the following error: > > > >Error in startup script: couldn't load file "libpgtcl.so": libpgtcl.so: > >cannot open shared object file: No such file or directory > > while executing > >"load libpgtcl.so" > > (procedure "main" line 6) > > invoked from within > >"main $argc $argv" > > (file "/usr/local/pgsql/bin/pgaccess" line 4954) > > Did you tell configure to build the pgtcl library? > (Use the option --with-tcl) my first time through, I did not. I was wanting to keep things simple at first to see if I get postgresql installed. When that went o.k. I started over, and did use the --with-tcl option and --with-perl then gmake all and then gmake install I read this in the pgaccess help files, and tried it, but still no luck ----- PostgreSQL 6.4 release has a minor bug. I does not includ by default the crypt lib when compiling libpgtcl. So, you will need to manually add a -lcrypt to SHLIB line in Makefile in src/interfaces/libpgtcl and then make clean and make again. The new libpgtcl.so library is properly configured to run pgaccess. ------- -------------------------------------------------------------------- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612 kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net --------------------------------------------------------------------
Kevin Heflin wrote: ... >> >I keep getting the following error: >> > >> >Error in startup script: couldn't load file "libpgtcl.so": libpgtcl.so: >> >cannot open shared object file: No such file or directory ... >I started over, and did use the --with-tcl option and --with-perl >then gmake all >and then gmake install So presumably you have a file called libpgtcl.so in (say) /usr/local/pgsql/lib. Your system loader needs to know to look there, so you have to tell it, since this is not one of the default library directories. How you do it varies with the system you are using; for Linux, use the command ldconfig (read its man page for details). Other systems may have their equivalent, or may have nothing (in which case you can perhaps use the -rpath link option to gcc to tell the program where to look for the shared library). As a last resort, set the environment variable LD_LIBRARY_PATH before running the program. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 ======================================== "My sheep hear my voice, and I know them, and they follow me; And I give unto them eternal life; and they shall never perish, neither shall any man pluck them out of my hand." John 10:27,28
On Sun, 21 Feb 1999, Oliver Elphick wrote: > Kevin Heflin wrote: > ... > >> >I keep getting the following error: > >> > > >> >Error in startup script: couldn't load file "libpgtcl.so": libpgtcl.so: > >> >cannot open shared object file: No such file or directory > ... > >I started over, and did use the --with-tcl option and --with-perl > >then gmake all > >and then gmake install > > So presumably you have a file called libpgtcl.so in (say) > /usr/local/pgsql/lib. Your system loader needs to know to look there, > so you have to tell it, since this is not one of the default library > directories. Yes, the file is in /usr/local/pgsql/lib and I've added this directory to my /etc/ld.so.conf and run /sbin/ldconfig > As a last resort, set the environment variable LD_LIBRARY_PATH before > running the program. AHA!. adding the LD_LIBRARY_PATH to my .bash_profile seems to have done the trick Thanks very much for the help -------------------------------------------------------------------- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612 kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net --------------------------------------------------------------------