Thread: How to install pgAgent

Hi Dave and hackers,

I would like to install pgagent on my linux machine (I have a Server
on linux and my administration is on windows).

I looked for pgAgent and found it on linux installation
http://developer.pgadmin.org/snapshots/linux/slackware/

I just put it on my linux machine and try to see if it's ok but notthing done.

[root@linux1 bin]# ./pgagent
./pgagent: error while loading shared libraries: libwx_baseu-2.8.so.0:
cannot open shared object file: No such file or directory
[root@linux1 bin]#

My postgresql must be installed without this contrib (does it is a contrib ?)

I hope you could help me becouse I am very anxious to put some jobs to
work. I need it as fas as possible so I count with you.

Regards ...


--
 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
 http://ezequiasrocha.blogspot.com/

Ezequias Rodrigues da Rocha wrote:
> Hi Dave and hackers,
>
> I would like to install pgagent on my linux machine (I have a Server
> on linux and my administration is on windows).
>
> I looked for pgAgent and found it on linux installation
> http://developer.pgadmin.org/snapshots/linux/slackware/
>
> I just put it on my linux machine and try to see if it's ok but notthing
> done.
>
> [root@linux1 bin]# ./pgagent
> ./pgagent: error while loading shared libraries: libwx_baseu-2.8.so.0:
> cannot open shared object file: No such file or directory
> [root@linux1 bin]#
>
> My postgresql must be installed without this contrib (does it is a
> contrib ?)

Hmm - it looks like pgAgent isn't static linking when it should do :-(.

I'm afraid you'll need to build wxWidgets and pgAgent manually to get it
to work quickly. I'll look at why the static linking is broken - once
fixed, the snapshots should pickup the change.

Regards, Dave.

Dave Page wrote:
> Ezequias Rodrigues da Rocha wrote:
>> Hi Dave and hackers,
>>
>> I would like to install pgagent on my linux machine (I have a Server
>> on linux and my administration is on windows).
>>
>> I looked for pgAgent and found it on linux installation
>> http://developer.pgadmin.org/snapshots/linux/slackware/
>>
>> I just put it on my linux machine and try to see if it's ok but
>> notthing done.
>>
>> [root@linux1 bin]# ./pgagent
>> ./pgagent: error while loading shared libraries: libwx_baseu-2.8.so.0:
>> cannot open shared object file: No such file or directory
>> [root@linux1 bin]#
>>
>> My postgresql must be installed without this contrib (does it is a
>> contrib ?)
>
> Hmm - it looks like pgAgent isn't static linking when it should do :-(.

Correction - the snapshot build wasn't clearing out old pgagent builds,
and because no changes had been made to the source since a dynamic build
was run in the same tree, it wasn't recompiling pgagent.

I've fixed the snapshot script to cleanup properly before it starts, and
regenerated a snapshot with a statically linked pgagent - get it from
http://developer.pgadmin.org/snapshots/linux/slackware/pgadmin3-20061127.tgz

Of course, I can't guarantee there won't be other issues if your not
running an up to date Slackware.

Regards, Dave.

Thank you Dave for the answare. I must tell you that I couldn't install pgAdmin on my linux machine too.

Our server is a CentOS (I really don't like it) and am thinking to change it to Fedora as fast as possible.

Another question: Why we don't have a pgAdmin 1.6.0 in rpm format ?

I am still waitting for you to solve my problem(please do not forget me).

Regards
Ezequias




--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

Ezequias Rodrigues da Rocha wrote:
> Thank you Dave for the answare. I must tell you that I couldn't install
> pgAdmin on my linux machine too.
>
> Our server is a CentOS (I really don't like it) and am thinking to
> change it to Fedora as fast as possible.
>
> Another question: Why we don't have a pgAdmin 1.6.0 in rpm format ?

Because the RPM guys haven't built them yet. I believe they are waiting
for wxWidgets 2.8.0 to be formally released.

> I am still waitting for you to solve my problem(please do not forget me).

I have solved the static link problem - see my followup email. If that
doesn't work though, you will need to compile it yourself.

Regards, Dave.

Ezequias Rodrigues da Rocha wrote:
> I just copied it to /usr/bin
>
> here what I did:
>
> [root@linux1 bin]# chmod 755 pgagent
> [root@linux1 bin]# ./pgagent
> ./pgagent: error while loading shared libraries: libssl.so.0: cannot
> open shared object file: No such file or directory
> [root@linux1 bin]#
>
> Did I something wrong ?

You need to install that library from whatever RPM on your OS includes
it. As it's part of OpenSSL, it shouldn't be hard to find.

Regards, Dave

I just copied it to /usr/bin

here what I did:

[root@linux1 bin]# chmod 755 pgagent
[root@linux1 bin]# ./pgagent
./pgagent: error while loading shared libraries: libssl.so.0: cannot open shared object file: No such file or directory
[root@linux1 bin]#

Did I something wrong ?

Ezequias





--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

Ezequias Rodrigues da Rocha wrote:
> I was more confident when the openssl was installed ok but the problem
> still be having.
>
...

> Updated: openssl.i686 0:0.9.7a-43.14
> Dependency Updated: openssl-devel.i586 0:0.9.7a-43.14
> Complete!
> [root@linux1 bin]# ./pgagent
> ./pgagent: error while loading shared libraries: libssl.so.0: cannot
> open shared object file: No such file or directory
>
> Should I reboot my system ? (it is a windows feature don't is ? hehehehehe)

:-)

Don't reboot. Check that you do actually have a libssl.so.0 now, and if
so, that it's location is listed in /etc/ld.so.conf. Then, run ldconfig
and try again.

Regards, Dave

I was more confident when the openssl was installed ok but the problem still be having.

See my work:

[root@linux1 bin]# yum install openssl
Setting up Install Process
Setting up repositories
Reading repository metadata in from local files
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for openssl to pack into transaction set.
openssl-0.9.7a-43.14.i686 100% |=========================|  28 kB    00:00
---> Package openssl.i686 0:0.9.7a-43.14 set to be updated
--> Running transaction check
--> Processing Dependency: openssl = 0.9.7a-43.8 for package: openssl-devel
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for openssl-devel to pack into transaction set.
openssl-devel-0.9.7a-43.1 100% |=========================| 126 kB    00:01
---> Package openssl-devel.i586 0:0.9.7a-43.14 set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Updating:
 openssl                 i686       0.9.7a-43.14     update            1.1 M
Updating for dependencies:
 openssl-devel           i586       0.9.7a-43.14     update            1.6 M

Transaction Summary
=============================================================================
Install      0 Package(s)
Update       2 Package(s)
Remove       0 Package(s)
Total download size: 2.6 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): openssl-0.9.7a-43. 100% |=========================| 1.1 MB    00:13
(2/2): openssl-devel-0.9. 100% |=========================| 1.6 MB    00:20
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating  : openssl                      ######################### [1/4]
  Updating  : openssl-devel                ######################### [2/4]
  Cleanup   : openssl                      ######################### [3/4]
  Cleanup   : openssl-devel                ######################### [4/4]

Updated: openssl.i686 0:0.9.7a-43.14
Dependency Updated: openssl-devel.i586 0:0.9.7a-43.14
Complete!
[root@linux1 bin]# ./pgagent
./pgagent: error while loading shared libraries: libssl.so.0: cannot open shared object file: No such file or directory

Should I reboot my system ? (it is a windows feature don't is ? hehehehehe)


Regards
Ezequias




--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

Ezequias Rodrigues da Rocha wrote:
> I have all those:
>
> [root@linux1 bin]# updatedb
> [root@linux1 bin]# locate libssl.so.0
> /work/vmware/vmware-distrib/lib/lib/libssl.so.0.9.7
> /usr/local/Adobe/Acrobat7.0/Reader/intellinux/lib/libssl.so.0.9.6
> /usr/local/Adobe/Acrobat7.0/Reader/intellinux/lib/libssl.so.0
> /usr/local/vmware/lib/lib/libssl.so.0.9.7
> /lib/libssl.so.0.9.7a
> [root@linux1 bin]#
>
> Strange that doesn't appear neither /etc... nor <ssl-dir>/...

I owuldn't expect to see it in /etc, it's a library.

> What folder do you recommend ?

/lib

That should already be in /etc/ld.so.conf though. You might need to
create a symlink (libssl.so.0 -> libssl.so.0.9.7a) and then run ldconfig
again.

Regard,s Dave