misc/118003: Port www/apache22 with PgSQL option require only libpq.so.3

[Sergey]

>Number:         118003
>Category:       misc
>Synopsis:       Port www/apache22 with PgSQL option require only libpq.so.3
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Mon Nov 12 14:20:01 UTC 2007
>Closed-Date:
>Last-Modified:
>Originator:     Sergey
>Release:        FreeBSD 6.2-RELEASE-p8 i386
>Organization:
>Environment:
FreeBSD acc.acc.tula.ru 6.2-RELEASE-p8 FreeBSD 6.2-RELEASE-p8 #15: Thu Oct 25 16:55:42 MSD 2007     root at acc.acc.tula.ru:/usr/obj/usr/src/sys/Z  i386

>Description:
I build apache22 with PGSQL option.
Then I try run tcl-written cgi-script and got errors:
httpd-error.log
[Fri Nov 09 21:02:37 2007] [error] [client 192.168.107.2] couldn't load file "libpgtcl.so": Shared object "libpq.so.3" not found, required by "libpgtcl.so"
[Fri Nov 09 21:02:37 2007] [error] [client 192.168.107.2]     while executing
[Fri Nov 09 21:02:37 2007] [error] [client 192.168.107.2] "load libpgtcl.so"
[Fri Nov 09 21:02:37 2007] [error] [client 192.168.107.2]     (file "select.cgi" line 6)
[Fri Nov 09 21:02:37 2007] [error] [client 192.168.107.2]
[Fri Nov 09 21:02:37 2007] [error] [client 192.168.107.2] Premature end of script headers: select.cgi
I have postgresql-server-8.2.5_2 and it use /usr/local/lib/libpq.so.5 but apache try to find libpq.so.3 shared library.
>How-To-Repeat:
0. Install tcl84, PostgreSQL82
1. Build apache22 with PGSQL option
run any tcl-written cgi-script (like this one-line script #!/usr/local/bin/tclsh)
look at /varlog/httpd-error.log for error:
[Fri Nov 09 21:02:37 2007] [error] [client 192.168.107.2] couldn't load file "libpgtcl.so": Shared object "libpq.so.3" not found, required by "libpgtcl.so"

>Fix:
I have a quick, but bad fix:
make symlink libpq.so.3->libpq.so.5

>Release-Note:
>Audit-Trail:
>Unformatted: