Thread: Compiling pgadminIII on SuSE 9.3
I'm running SuSE Linux 9.3, with PostgreSQL 8.0.3 installed from from RPMs downloaded from ftp.suse.com. Now I'm trying to build pgadminIII 1.2.2, but get into difficulties. First, I downloaded, built and installed wxGTK 2.6.1, since the version bundled with SuSE 9.3 is too old. When trying to build pgadminIII I get the following errors from the linker: make[2]: Entering directory `/home/lars/build/pgadmin3-1.2.2/src' g++ -DDATA_DIR=\"/usr/local/pgadmin3/share/pgadmin3/\" -Wall -g -I../src/include -I../src/agent/include -g -O2 -L/usr/lib-L/usr/local/lib -o pgadmin3 pgAdmin3.o pgConn.o pgSet.o keywords.o pgAggregate.o pgCast.o pgCheck.o pgCollection.opgColumn.o pgConstraints.o pgConversion.o pgDatabase.o pgDomain.o pgForeignKey.o pgFunction.o pgGroup.o pgIndex.opgIndexConstraint.o pgLanguage.o pgObject.o pgOperator.o pgOperatorClass.o pgRule.o pgSchema.o pgSequence.o pgServer.opgTable.o pgTablespace.o pgTrigger.o pgType.o pgUser.o pgView.o pgDatatype.o pgaAgent.o pgaJob.o pgaStep.o pgaSchedule.odlgJob.o dlgSchedule.o dlgStep.o xh_sqlbox.o xh_calb.o xh_timespin.o xh_ctlcombo.o ctlSecurityPanel.o dlgClasses.octlComboBox.o calbox.o timespin.o ctlListView.o ctlSQLBox.o ctlSQLResult.o frmExport.o dlgEditGridOptions.o events.ofrmAbout.o frmIndexcheck.o dlgConnect.o frmMain.o frmOptions.o frmPassword.o frmQuery.o frmHelp.o frmSplash.o frmMaintenance.ofrmBackup.o frmRestore.o frmGrantWizard.o frmEditGrid.o dlgProperty.o dlgUser.o dlgServer.o dlgGroup.o dlgDatabase.odlgLanguage.o dlgSchema.o dlgDomain.o dlgTable.o dlgTablespace.o dlgColumn.o dlgIndex.o dlgFunction.o dlgView.odlgRule.o dlgOperator.o dlgAggregate.o dlgCast.o dlgConversion.o dlgIndexConstraint.o dlgForeignKey.o dlgSequence.odlgTrigger.o dlgType.o dlgCheck.o frmStatus.o misc.o sysLogger.o sysSettings.o utffile.o xrcDialogs.o /usr/lib/libpq.a-lcrypt -lssl -lcrypto -L/usr/local/lib -pthread -L/usr/X11R6/lib /usr/local/lib/libwx_gtk2ud_xrc-2.6.a/usr/local/lib/libwx_gtk2ud_qa-2.6.a /usr/local/lib/libwx_gtk2ud_html-2.6.a /usr/local/lib/libwx_gtk2ud_adv-2.6.a/usr/local/lib/libwx_gtk2ud_core-2.6.a /usr/local/lib/libwx_baseud_xml-2.6.a /usr/local/lib/libwx_baseud_net-2.6.a/usr/local/lib/libwx_baseud-2.6.a -pthread -L/opt/gnome/lib -lgtk-x11-2.0 -lgdk-x11-2.0-latk-1.0 -lgdk_pixbuf-2.0 -lpangoxft-1.0 -lpangox-1.0 -lpango-1.0 -lgobject-2.0 -lgmodule-2.0 -lgthread-2.0-lglib-2.0 -lXinerama -lXxf86vm -lpng -ljpeg -ltiff -lexpat -lwxregexud-2.6 -lz -ldl -lm -L/usr/local/lib -pthread -L/usr/X11R6/lib /usr/local/lib/libwx_gtk2ud_stc-2.6.a /usr/local/lib/libwx_gtk2ud_ogl-2.6.a /usr/local/lib/libwx_baseud-2.6.a-lwxregexud-2.6 -lz -ldl -lm /usr/lib/libpq.a(fe-auth.o)(.text+0x3a): In function `pg_krb5_init': : undefined reference to `krb5_init_context' /usr/lib/libpq.a(fe-auth.o)(.text+0x5a): In function `pg_krb5_init': : undefined reference to `krb5_cc_default' /usr/lib/libpq.a(fe-auth.o)(.text+0x84): In function `pg_krb5_init': : undefined reference to `krb5_cc_get_principal' /usr/lib/libpq.a(fe-auth.o)(.text+0xae): In function `pg_krb5_init': : undefined reference to `krb5_unparse_name' /usr/lib/libpq.a(fe-auth.o)(.text+0x111): In function `pg_krb5_init': : undefined reference to `error_message' /usr/lib/libpq.a(fe-auth.o)(.text+0x142): In function `pg_krb5_init': : undefined reference to `error_message' /usr/lib/libpq.a(fe-auth.o)(.text+0x16f): In function `pg_krb5_init': : undefined reference to `krb5_free_context' /usr/lib/libpq.a(fe-auth.o)(.text+0x179): In function `pg_krb5_init': : undefined reference to `error_message' /usr/lib/libpq.a(fe-auth.o)(.text+0x1b0): In function `pg_krb5_init': : undefined reference to `krb5_cc_close' /usr/lib/libpq.a(fe-auth.o)(.text+0x1ba): In function `pg_krb5_init': : undefined reference to `error_message' /usr/lib/libpq.a(fe-auth.o)(.text+0x1f1): In function `pg_krb5_init': : undefined reference to `krb5_free_principal' /usr/lib/libpq.a(fe-auth.o)(.text+0x5e6): In function `.L55': : undefined reference to `krb5_sname_to_principal' /usr/lib/libpq.a(fe-auth.o)(.text+0x5f6): In function `.L55': : undefined reference to `error_message' /usr/lib/libpq.a(fe-auth.o)(.text+0x739): In function `.L55': : undefined reference to `krb5_free_principal' /usr/lib/libpq.a(fe-auth.o)(.text+0x871): In function `.L55': : undefined reference to `krb5_sendauth' /usr/lib/libpq.a(fe-auth.o)(.text+0x897): In function `.L55': : undefined reference to `error_message' /usr/lib/libpq.a(fe-auth.o)(.text+0x8df): In function `.L55': : undefined reference to `krb5_free_principal' /usr/lib/libpq.a(fe-auth.o)(.text+0x963): In function `.L55': : undefined reference to `krb5_free_error' collect2: ld returned 1 exit status make[2]: *** [pgadmin3] Error 1 make[2]: Leaving directory `/home/lars/build/pgadmin3-1.2.2/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/lars/build/pgadmin3-1.2.2' make: *** [all] Error 2 I have both krb5 and krb5-devel RPMs installed. Any ideas what I can do to fix this? Should I install PostgreSQL from source instead, and if so, should I use the --with-krb5 configure option or not? Regards, -- Lars Haugseth
hi! you do not need to install pgsql from source. i've also had the same problem you describe on suse 9.3. following dave's advice i did this to get a successful build: LDFLAGS="-L/usr/lib -lkrb5" ./configure [your configure options] make sudo make install and it works without problems. well, except one, described here: http://archives.postgresql.org/pgadmin-support/2005-06/msg00016.php after your build, can you please send me a note if you get the same error please? thank you :) regards, M Lars Haugseth wrote: > I'm running SuSE Linux 9.3, with PostgreSQL 8.0.3 installed from > from RPMs downloaded from ftp.suse.com. Now I'm trying to build > pgadminIII 1.2.2, but get into difficulties. > > First, I downloaded, built and installed wxGTK 2.6.1, since the > version bundled with SuSE 9.3 is too old. > > When trying to build pgadminIII I get the following errors from > the linker: > > make[2]: Entering directory `/home/lars/build/pgadmin3-1.2.2/src' > g++ -DDATA_DIR=\"/usr/local/pgadmin3/share/pgadmin3/\" -Wall -g -I../src/include -I../src/agent/include -g -O2 -L/usr/lib-L/usr/local/lib -o pgadmin3 pgAdmin3.o pgConn.o pgSet.o keywords.o pgAggregate.o pgCast.o pgCheck.o pgCollection.opgColumn.o pgConstraints.o pgConversion.o pgDatabase.o pgDomain.o pgForeignKey.o pgFunction.o pgGroup.o pgIndex.opgIndexConstraint.o pgLanguage.o pgObject.o pgOperator.o pgOperatorClass.o pgRule.o pgSchema.o pgSequence.o pgServer.opgTable.o pgTablespace.o pgTrigger.o pgType.o pgUser.o pgView.o pgDatatype.o pgaAgent.o pgaJob.o pgaStep.o pgaSchedule.odlgJob.o dlgSchedule.o dlgStep.o xh_sqlbox.o xh_calb.o xh_timespin.o xh_ctlcombo.o ctlSecurityPanel.o dlgClasses.octlComboBox.o calbox.o timespin.o ctlListView.o ctlSQLBox.o ctlSQLResult.o frmExport.o dlgEditGridOptions.o events.ofrmAbout.o frmIndexcheck.o dlgConnect.o frmMain.o frmOptions.o frmPassword.o frmQuery.o frmHelp.o frmSplash.o frmMaintenance.ofrmBackup.o frmRestore.o frmGrantWi zard.o frmEditGrid.o dlgProperty.o dlgUser.o dlgServer.o dlgGroup.o dlgDatabase.o dlgLanguage.o dlgSchema.o dlgDomain.o dlgTable.odlgTablespace.o dlgColumn.o dlgIndex.o dlgFunction.o dlgView.o dlgRule.o dlgOperator.o dlgAggregate.o dlgCast.odlgConversion.o dlgIndexConstraint.o dlgForeignKey.o dlgSequence.o dlgTrigger.o dlgType.o dlgCheck.o frmStatus.omisc.o sysLogger.o sysSettings.o utffile.o xrcDialogs.o /usr/lib/libpq.a -lcrypt -lssl -lcrypto -L/usr/local/lib-pthread -L/usr/X11R6/lib /usr/local/lib/libwx_gtk2ud_xrc-2.6.a /usr/local/lib/libwx_gtk2ud_qa-2.6.a /usr/local/lib/libwx_gtk2ud_html-2.6.a/usr/local/lib/libwx_gtk2ud_adv-2.6.a /usr/local/lib/libwx_gtk2ud_core-2.6.a /usr/local/lib/libwx_baseud_xml-2.6.a/usr/local/lib/libwx_baseud_net-2.6.a /usr/local/lib/libwx_baseud-2.6.a -pthread -L/opt/gnome/lib-lgtk-x11-2.0 -lgdk-x11-2.0 -latk-1.0 -lgdk_pixbuf-2.0 -lpangoxft-1.0 -lpangox-1.0 -lpango-1.0 -lgobject-2.0-lgmodule-2.0 -lgthread-2.0 -lglib-2.0 -lXinerama -lXx f86vm -lpng -ljpeg -ltiff -lexpat -lwxregexud-2.6 -lz -ldl -lm -L/usr/local/lib -pthread -L/usr/X11R6/lib /usr/local/lib/libwx_gtk2ud_stc-2.6.a/usr/local/lib/libwx_gtk2ud_ogl-2.6.a /usr/local/lib/libwx_baseud-2.6.a -lwxregexud-2.6-lz -ldl -lm > /usr/lib/libpq.a(fe-auth.o)(.text+0x3a): In function `pg_krb5_init': > : undefined reference to `krb5_init_context' > /usr/lib/libpq.a(fe-auth.o)(.text+0x5a): In function `pg_krb5_init': > : undefined reference to `krb5_cc_default' > /usr/lib/libpq.a(fe-auth.o)(.text+0x84): In function `pg_krb5_init': > : undefined reference to `krb5_cc_get_principal' > /usr/lib/libpq.a(fe-auth.o)(.text+0xae): In function `pg_krb5_init': > : undefined reference to `krb5_unparse_name' > /usr/lib/libpq.a(fe-auth.o)(.text+0x111): In function `pg_krb5_init': > : undefined reference to `error_message' > /usr/lib/libpq.a(fe-auth.o)(.text+0x142): In function `pg_krb5_init': > : undefined reference to `error_message' > /usr/lib/libpq.a(fe-auth.o)(.text+0x16f): In function `pg_krb5_init': > : undefined reference to `krb5_free_context' > /usr/lib/libpq.a(fe-auth.o)(.text+0x179): In function `pg_krb5_init': > : undefined reference to `error_message' > /usr/lib/libpq.a(fe-auth.o)(.text+0x1b0): In function `pg_krb5_init': > : undefined reference to `krb5_cc_close' > /usr/lib/libpq.a(fe-auth.o)(.text+0x1ba): In function `pg_krb5_init': > : undefined reference to `error_message' > /usr/lib/libpq.a(fe-auth.o)(.text+0x1f1): In function `pg_krb5_init': > : undefined reference to `krb5_free_principal' > /usr/lib/libpq.a(fe-auth.o)(.text+0x5e6): In function `.L55': > : undefined reference to `krb5_sname_to_principal' > /usr/lib/libpq.a(fe-auth.o)(.text+0x5f6): In function `.L55': > : undefined reference to `error_message' > /usr/lib/libpq.a(fe-auth.o)(.text+0x739): In function `.L55': > : undefined reference to `krb5_free_principal' > /usr/lib/libpq.a(fe-auth.o)(.text+0x871): In function `.L55': > : undefined reference to `krb5_sendauth' > /usr/lib/libpq.a(fe-auth.o)(.text+0x897): In function `.L55': > : undefined reference to `error_message' > /usr/lib/libpq.a(fe-auth.o)(.text+0x8df): In function `.L55': > : undefined reference to `krb5_free_principal' > /usr/lib/libpq.a(fe-auth.o)(.text+0x963): In function `.L55': > : undefined reference to `krb5_free_error' > collect2: ld returned 1 exit status > make[2]: *** [pgadmin3] Error 1 > make[2]: Leaving directory `/home/lars/build/pgadmin3-1.2.2/src' > make[1]: *** [all-recursive] Error 1 > make[1]: Leaving directory `/home/lars/build/pgadmin3-1.2.2' > make: *** [all] Error 2 > > I have both krb5 and krb5-devel RPMs installed. > > Any ideas what I can do to fix this? Should I install PostgreSQL > from source instead, and if so, should I use the --with-krb5 configure > option or not? > > Regards,
* miha.radej@siix.com (Miha Radej) wrote: | | Lars Haugseth wrote: | > I'm running SuSE Linux 9.3, with PostgreSQL 8.0.3 installed from | > from RPMs downloaded from ftp.suse.com. Now I'm trying to build | > pgadminIII 1.2.2, but get into difficulties. | | you do not need to install pgsql from source. i've also had the same | problem you describe on suse 9.3. following dave's advice i did this | to get a successful build: | | LDFLAGS="-L/usr/lib -lkrb5" ./configure [your configure options] | make | sudo make install Yes, that did the trick, thanks! | and it works without problems. well, except one, described here: | http://archives.postgresql.org/pgadmin-support/2005-06/msg00016.php | after your build, can you please send me a note if you get the same | error please? thank you :) I get the exact same warning. Though everything seems to work ok, including LATIN1-characters. -- Lars Haugseth
Miha Radej пишет: > [...skip...] > > and it works without problems. well, except one, described here: > http://archives.postgresql.org/pgadmin-support/2005-06/msg00016.php > after your build, can you please send me a note if you get the same > error please? thank you :) > > regards, > M > By default in SuSE (for Russian locale): set | grep 'FILENAME_ENCODING' G_FILENAME_ENCODING=@locale,UTF-8,KOI8-R Short way to fix it for wx application: mv /usr/bin/pgadmin3 /usr/bin/pgadmin3-bin cat > /usr/bin/pgadmin3 << EOF #!/bin/bash # # This is a wrapper for wxWidgets-2.6.x bug # G_FILENAME_ENCODING=UTF-8 /usr/bin/pgadmin3-bin EOF chmod a+x /usr/bin/pgadmin3 wbr, Vasilev Max