Re: compiling problem - Mailing list pgadmin-support

ooops... I didn't see you were linking libpq.a and not .so.

Try nm /opt/postgresql-7.4.1/lib/libpq.a | grep PQgetssl
If you have an output then your libpq is ok.
If so, I think you face the fact that pgconn.o is loaded before libpq.a in the linker or something like that.
Try to laucnh manually the last line (linking stage) by inserting libpq.a before pgConn.o... If it solves the problem
youshould have a pgadmin3 exe but we will have to go further to definitely solve the problem. 

I personnally link dynamically due to debian policy, but many developers here link statically. So it *should* work! :)

To be continued :)

Regards,
Raphaël

----Message d'origine----
>De: blacknoz@club-internet.fr
>A: mejerdil@pt.lu
>Copie à: pgadmin-support@postgresql.org
>Date: Mon, 23 Feb 2004 11:18:08 CET
>Sujet: Re: [pgadmin-support] compiling problem
>
>
>Hi Dirk,
>
>You're welcome ;)
>
>did you build you libpq with ssl support ?
>What does pgAdmin3 configure scripts tells you about what it detects concerning your libpq ?
>It should be something like "checking for SSL_connect in -lpq."
>
>try ldd whereveryouinstalledlibpq.so/libpq.so*
>and look for a link to openssl lib.
>or strings whereveryouinstalledlibpq.so/libpq.so* | grep PQgetssl
>
>If not, try to rebuild you libpq with ssl support.
>
>We also had problems with defines and gcc. Can you send your pgadmin3 build log (in gzip format).
>
>Regards,
>Raphaël
>
>----Message d'origine----
>>Date: Mon, 23 Feb 2004 09:24:26 +0100
>>De: Dirk Dil <mejerdil@pt.lu>
>>A: Rapha?l Enrici <blacknoz@club-internet.fr>
>>Copie à: pgadmin-support@postgresql.org
>>Sujet: Re: [pgadmin-support] compiling problem
>>
>>Rapha?l Enrici (blacknoz@club-internet.fr) wrote:
>>> Hi,
>>> I had a look to your build log and it looks to be the exact same problem
>>> I had under debian since 1.0.1 (as the SSL build was broken in 1.0.x, I
>>> didn't look too far to know from where this could come from and simply
>>> backported a piece of 1.1x snapshot ... It solves SSL build and solved
>>> the problem you describe too).
>>> Can you try to apply the patch attached on a fresh ogAdmin3 1.0.2 source
>>> and tell me if it solves your problem ?
>>>
>>> Thanks,
>>> Rapha?l
>>>
>>
>>Hi again,
>>
>>Thanks for your help and patience, Raphael!
>>
>>Well, yes I think the problem has been over come.  But now ssl poses a
>>problem.  See below:
>>
>>make  all-recursive
>>make[1]: Entering directory `/home/setup/dirk/pgadmin3-1.0.2'
>>Making all in src
>>make[2]: Entering directory `/home/setup/dirk/pgadmin3-1.0.2/src'
>>g++ -DDATA_DIR=\"/opt/pga3/share/pgadmin3/\" -Wall -g -I../src/include
>>-Wall -g -O0  -L/opt/postgresql-7.4.1/lib -L/opt/wxwindows/lib -o
>>pgadmin3  pgAdmin3.o pgConn.o pgSet.o keywords.o pgAggregate.o pgCast.o
>>pgCheck.o pgCollection.o pgColumn.o pgConstraints.o pgConversion.o
>>pgDatabase.o pgDomain.o pgForeignKey.o pgFunction.o pgGroup.o pgIndex.o
>>pgIndexConstraint.o pgLanguage.o pgObject.o pgOperator.o
>>pgOperatorClass.o pgRule.o pgSchema.o pgSequence.o pgServer.o pgTable.o
>>pgTrigger.o pgType.o pgUser.o pgView.o pgDatatype.o ctlSQLBox.o
>>ctlSQLResult.o frmExport.o dlgAddTableView.o events.o frmAbout.o
>>frmChildTableViewFrame.o frmConnect.o frmMain.o frmOptions.o
>>frmPassword.o frmQuery.o frmQueryBuilder.o frmHelp.o frmQBJoin.o
>>frmSplash.o frmMaintenance.o frmEditGrid.o dlgProperty.o dlgUser.o
>>dlgGroup.o dlgDatabase.o dlgLanguage.o dlgSchema.o dlgDomain.o
>>dlgTable.o dlgColumn.o dlgIndex.o dlgFunction.o dlgView.o dlgRule.o
>>dlgOperator.o dlgAggregate.o dlgCast.o dlgConversion.o
>>dlgIndexConstraint.o dlgForeignKey.o dlgSequence.o dlgTrigger.o
>>dlgType.o dlgCheck.o frmStatus.o misc.o sysLogger.o sysSettings.o
>>xrcDialogs.o  /opt/postgresql-7.4.1/lib/libpq.a -lcrypt  -lssl -lcrypto
>>/opt/wxwindows/lib/libwx_gtk2ud_stc-2.5.a
>>/opt/wxwindows/lib/libwx_gtk2ud_xrc-2.5.a -L/opt/wxwindows/lib -pthread
>>/opt/wxwindows/lib/libwx_gtk2ud_html-2.5.a
>>/opt/wxwindows/lib/libwx_gtk2ud_adv-2.5.a
>>/opt/wxwindows/lib/libwx_gtk2ud_core-2.5.a
>>/opt/wxwindows/lib/libwx_baseud_xml-2.5.a
>>/opt/wxwindows/lib/libwx_baseud_net-2.5.a
>>/opt/wxwindows/lib/libwx_baseud-2.5.a -Wl,--export-dynamic -pthread
>>-lgtk-x11-2.0 -lgdk-x11-2.0 -latk-1.0 -lgdk_pixbuf-2.0 -lm
>>-lpangoxft-1.0 -lpangox-1.0 -lpango-1.0 -lgobject-2.0 -lgmodule-2.0 -ldl
>>-lgthread-2.0 -lglib-2.0 -Wl,--export-dynamic -lpangoft2-1.0 -lpango-1.0
>>-lgobject-2.0 -lgmodule-2.0 -ldl -lglib-2.0 -lpng -ljpeg -ltiff -lexpat
>>-lz -ldl -lm
>>/usr/bin/ld: warning: libexpat.so.1, needed by
>>/usr/X11R6/lib/libXft.so.2, may conflict with libexpat.so.0
>>pgConn.o: In function `pgConn::IsSSLconnected()':
>>/home/dirk/setup/pgadmin3-1.0.2/src/db/pgConn.cpp:186: undefined
>>reference to `PQgetssl'
>>collect2: ld returned 1 exit status
>>make[2]: *** [pgadmin3] Error 1
>>make[2]: Leaving directory `/home/setup/dirk/pgadmin3-1.0.2/src'
>>make[1]: *** [all-recursive] Error 1
>>make[1]: Leaving directory `/home/setup/dirk/pgadmin3-1.0.2'
>>make: *** [all] Error 2
>>
>>
>>I've got /usr/X11R6/lib/libexpat.so.1 as well as /usr/lib/libexpat.so.0.
>>
>>Where from here?
>>
>>Dirk
>>
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>