Re: [pgadmin-hackers] ssl configure

2004-08-11 Thread Dave Page
 

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of 
 Andreas Pflug
 Sent: 11 August 2004 00:59
 To: Adam H.Pendleton
 Cc: [EMAIL PROTECTED]
 Subject: [pgadmin-hackers] ssl configure
 
 Adam H.Pendleton wrote:
  
 
  
  Here's your problem.  You don't have the ssl library, but configure 
  expects it.  I submitted a patch to the list a few days ago fixing 
  this problem.
 
 Hi Adam,
 
 that patch was very thorough indeed :-)
 I don't have SSL any more. I can't see any ssl text in config.log.

Hmm, although it worked when I tested it, the auto build last night
(which should have SSL) failed at the link step with the errors below.
I'm sure I did a make clean first, but clearly I didn't :-(. Can you
(Adam) come up with a fix for this easily, or should I roll back the
patch?

Regards, Dave

g++ -DDATA_DIR=\/usr/share/pgadmin3/\ -Wall -g -I../src/include
-I../src/agent/include -Wall -g -O0  -L/usr/local/pgsql/lib
-L/usr/local//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 pgTablespace.o pgTrigger.o pgType.o
pgUser.o pgView.o pgDatatype.o pgaAgent.o pgaJob.o pgaStep.o
pgaSchedule.o dlgJob.o dlgSchedule.o dlgStep.o xh_sqlbox.o xh_calb.o
xh_timespin.o ctlSecurityPanel.o dlgClasses.o ctlComboBox.o calbox.o
timespin.o ctlListView.o ctlSQLBox.o ctlSQLResult.o frmExport.o
dlgEditGridOptions.o events.o frmAbout.o frmIndexcheck.o dlgConnect.o
frmMain.o frmOptions.o frmPassword.o frmQuery.o frmHelp.o frmSplash.o
frmMaintenance.o frmBackup.o frmRestore.o frmGrantWizard.o frmE!
 ditGrid.o dlgProperty.o dlgUser.o dlgServer.o dlgGroup.o dlgDatabase.o
dlgLanguage.o dlgSchema.o dlgDomain.o dlgTable.o dlgTablespace.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 utffile.o xrcDialogs.o
/usr/local/pgsql/lib/libpq.a -lcrypt  -lcrypto
/usr/local//lib/libwx_gtk2ud_stc-2.5.a
/usr/local//lib/libwx_gtk2ud_xrc-2.5.a -L/usr/local/lib -pthread
-L/usr/X11R6/lib /usr/local/lib/libwx_gtk2ud_html-2.5.a
/usr/local/lib/libwx_gtk2ud_adv-2.5.a
/usr/local/lib/libwx_gtk2ud_core-2.5.a
/usr/local/lib/libwx_baseud_xml-2.5.a
/usr/local/lib/libwx_baseud_net-2.5.a /usr/local/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 -lgmo!
 dule-2.0
 -ldl -lglib-2.0 -lXinerama -lXxf86vm -lpng -lz -ljpeg -ltiff -lexpat
-lz -ldl -lm -lwxregexud
/usr/local/pgsql/lib/libpq.a(fe-misc.o)(.text+0xefa): In function
`pqSocketCheck':
: undefined reference to `SSL_pending'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0x4d): In function
`pqsecure_open_client':
: undefined reference to `SSL_new'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0x64): In function
`pqsecure_open_client':
: undefined reference to `SSL_set_ex_data'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0xae): In function
`pqsecure_open_client':
: undefined reference to `SSL_set_fd'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0x13a): In function
`.L14':
: undefined reference to `SSL_read'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0x14b): In function
`.L14':
: undefined reference to `SSL_get_error'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0x296): In function
`pqsecure_write':
: undefined reference to `SSL_write'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0x2a7): In function
`pqsecure_write':
: undefined reference to `SSL_get_error'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0x759): In function
`client_cert_cb':
: undefined reference to `SSL_get_ex_data'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0xb40): In function
`initialize_SSL':
: undefined reference to `SSL_library_init'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0xb45): In function
`initialize_SSL':
: undefined reference to `SSL_load_error_strings'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0xb4d): In function
`initialize_SSL':
: undefined reference to `TLSv1_method'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0xb55): In function
`initialize_SSL':
: undefined reference to `SSL_CTX_new'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0xbe1): In function
`initialize_SSL':
: undefined reference to `SSL_CTX_load_verify_locations'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0xbfe): In function
`initialize_SSL':
: undefined reference to `SSL_CTX_set_verify'
/usr/local/pgsql/lib/libpq.a(fe-secure.o)(.text+0xc0e): In function
`initialize_SSL':
: 

[pgadmin-hackers] Translations

2004-08-11 Thread Dave Page
I was just looking at the translations status web page and was somewhat
surprised to see that virtually all of them are at or very near to 100%.
I can't believe this is right - or is it?

Regards, Dave

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [pgadmin-hackers] Translations

2004-08-11 Thread Andreas Pflug
Dave Page wrote:
I was just looking at the translations status web page and was somewhat
surprised to see that virtually all of them are at or very near to 100%.
I can't believe this is right - or is it?
It's very wrong, we have 1000 strings now. The site simply doesn't update.
Regards,
Andreas
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faqs/FAQ.html


Re: [pgadmin-hackers] Translations

2004-08-11 Thread Dave Page
 

 -Original Message-
 From: Andreas Pflug [mailto:[EMAIL PROTECTED] 
 Sent: 11 August 2004 11:02
 To: Dave Page
 Cc: [EMAIL PROTECTED]; Jean-Michel POURE
 Subject: Re: [pgadmin-hackers] Translations
 
 Dave Page wrote:
  I was just looking at the translations status web page and was 
  somewhat surprised to see that virtually all of them are at 
 or very near to 100%.
  I can't believe this is right - or is it?
 
 It's very wrong, we have 1000 strings now. The site simply 
 doesn't update.

Hmm, do you have any idea how it works? I haven't heard from Jean-Michel
in a while :-(

/D

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-hackers] ssl configure

2004-08-11 Thread Dave Page
 

 -Original Message-
 From: Adam H. Pendleton [mailto:[EMAIL PROTECTED] 
 Sent: 11 August 2004 12:22
 To: Dave Page
 Cc: Andreas Pflug; [EMAIL PROTECTED]
 Subject: Re: [pgadmin-hackers] ssl configure

 Can you send me a config.log from a system that has SSL, but 
 didn't build with it?
 

Attached.

Regards, dave 


config.log
Description: config.log

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [pgadmin-hackers] ssl configure

2004-08-11 Thread Adam H . Pendleton
On Aug 11, 2004, at 7:46 AM, Dave Page wrote:

-Original Message-
From: Adam H. Pendleton [mailto:[EMAIL PROTECTED]
Sent: 11 August 2004 12:22
To: Dave Page
Cc: Andreas Pflug; [EMAIL PROTECTED]
Subject: Re: [pgadmin-hackers] ssl configure
Can you send me a config.log from a system that has SSL, but
didn't build with it?
Attached.
H, this line should have failed with SSL dependency errors:
configure:4619: checking for PQexec in -lpq
configure:4650: gcc -o conftest -Wall -g -O0  
-I/usr/local/pgsql/include  -L/usr/local/pgsql/lib conftest.c -lpq   
5

But it didn't, so you should roll back the patch until I can figure 
something better out.  Sorry.  :-(

ahp
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly


Re: [pgadmin-hackers] ssl configure

2004-08-11 Thread Dave Page
 

 -Original Message-
 From: Adam H. Pendleton [mailto:[EMAIL PROTECTED] 
 Sent: 11 August 2004 12:57
 To: Dave Page
 Cc: Andreas Pflug; [EMAIL PROTECTED]
 Subject: Re: [pgadmin-hackers] ssl configure
 
 
 
 H, this line should have failed with SSL dependency errors:
 
 configure:4619: checking for PQexec in -lpq
 configure:4650: gcc -o conftest -Wall -g -O0  
 -I/usr/local/pgsql/include  -L/usr/local/pgsql/lib conftest.c -lpq   
  5
 
 But it didn't, so you should roll back the patch until I can 
 figure something better out.  Sorry.  :-(

No problem - thanks Adam.

/D

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


[pgadmin-hackers] CVS Commit by dpage: Rollback Adam's last patch.

2004-08-11 Thread cvs
Log Message:
---
Rollback Adam's last patch.

Modified Files:
--
pgadmin3:
acinclude.m4 (r1.32 - r1.33)

Index: acinclude.m4
===
RCS file: /projects/pgadmin3/acinclude.m4,v
retrieving revision 1.32
retrieving revision 1.33
diff -Lacinclude.m4 -Lacinclude.m4 -u -w -r1.32 -r1.33
--- acinclude.m4
+++ acinclude.m4
@@ -117,50 +117,34 @@
 else
 CPPFLAGS=$CPPFLAGS -I${LIBPQ_HOME}/include
 fi
-
-AC_CHECK_LIB(pq, PQexec, [pgsql_cv_libpq=yes], [pgsql_cv_libpq=no])
-if test $pgsql_cv_libpq = no
-then
-LIBS=$LIBS -lssl
-#AC_CHECK_LIB(pq, PQexec, [pgsql_cv_libpq=yes], [pgsql_cv_libpq=no])
-AC_CHECK_LIB(pq, SSL_connect, [pgsql_ssl_libpq=yes], [pgsql_ssl_libpq=np])
-if test $pgsql_ssl_libpq = yes
-then
-pgsql_cv_libpq=yes
 if test $pg_static_build = yes
 then
 LIBS=${LIBPQ_HOME}/lib/libpq.a -lcrypt $LIBS -lssl -lcrypto
 else
 LIBS=$LIBS -lssl -lcrypto -lpq
 fi
-
-CPPFLAGS=$CPPFLAGS -DSSL
-fi
-else
-if test $pg_static_build = yes
-then
-LIBS=${LIBPQ_HOME}/lib/libpq.a -lcrypt $LIBS -lcrypto
-else
-LIBS=$LIBS -lcrypto -lpq
-fi
-
-fi
-AC_CHECK_HEADER(libpq-fe.h, [pgsql_cv_libpqfe_h=yes], [pgsql_cv_libpqfe_h=no])
-
 AC_LANG_SAVE
 AC_LANG_C
+AC_CHECK_LIB(pq, PQexec, [pgsql_cv_libpq=yes], [pgsql_cv_libpq=no])
+AC_CHECK_LIB(pq, SSL_connect, [pgsql_ssl_libpq=yes], [pgsql_ssl_libpq=np])
+AC_CHECK_HEADER(libpq-fe.h, [pgsql_cv_libpqfe_h=yes], [pgsql_cv_libpqfe_h=no])
 AC_LANG_RESTORE
-AC_MSG_CHECKING(pgsql in ${LIBPQ_HOME})
 if test $pgsql_cv_libpq = yes -a $pgsql_cv_libpqfe_h = yes
 then
+AC_MSG_CHECKING(pgsql in ${LIBPQ_HOME})
 AC_MSG_RESULT(ok)
 else
+AC_MSG_CHECKING(pgsql in ${LIBPQ_HOME})
 AC_MSG_RESULT(failed)
 LDFLAGS=$PGSQL_OLD_LDFLAGS
 CPPFLAGS=$PGSQL_OLD_CPPFLAGS
 AC_MSG_ERROR([you must specify a valid pgsql installation with 
--with-pgsql=DIR])
 fi
 
+if test $pgsql_ssl_libpq = yes
+then
+CPPFLAGS=$CPPFLAGS -DSSL
+fi
 fi
 ])
 
---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [pgadmin-hackers] Translations

2004-08-11 Thread Serguei Mokhov
 Date: Wed, 11 Aug 2004 10:02:22 +
 From: Andreas Pflug [EMAIL PROTECTED]
 Subject: Re: Translations
 
 Dave Page wrote:
  I was just looking at the translations status web page and was somewhat
  surprised to see that virtually all of them are at or very near to 100%.
  I can't believe this is right - or is it?
 
 It's very wrong, we have 1000 strings now. The site simply doesn't update.

I (well, poEdit) counted 989... Maybe the site updates only for the
last release? I suggested Jean-Michel in the past to do it similarly
like Peter E. does here:

http://developer.postgresql.org/~petere/nlsstatus/

But the .pot file seems to be updated regularly, so I download
the .po and .pot, then I say Catalog-Update from POT file
and get all the missing ones.

-s

 Regards,
 Andreas


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[pgadmin-hackers] CVS Commit by andreas: rework of ctlComboBox

2004-08-11 Thread cvs
Log Message:
---
rework of ctlComboBox

Added Files:
---
pgadmin3/src/include:
xh_ctlcombo.h (r1.1)
pgadmin3/src/ui:
xh_ctlcombo.cpp (r1.1)

--- /dev/null
+++ src/include/xh_ctlcombo.h
@@ -0,0 +1,31 @@
+//
+//
+// pgAdmin III - PostgreSQL Tools
+// RCS-ID:  $Id: xh_ctlcombo.h,v 1.1 2004/08/11 21:28:49 andreas Exp $
+// Copyright (C) 2002 - 2004, The pgAdmin Development Team
+// This software is released under the Artistic Licence
+//
+// xh_ctlcombo.h - ctlComboBox handler
+//
+//
+
+
+#ifndef _WX_XH_CTLCOMBO_H_
+#define _WX_XH_CTLCOMBO_H_
+
+
+#include wx/xrc/xmlres.h
+#include wx/xrc/xh_combo.h
+
+//class WXDLLIMPEXP_XRC 
+class ctlComboBoxXmlHandler : public wxComboBoxXmlHandler
+{
+DECLARE_DYNAMIC_CLASS(ctlComboBoxXmlHandler)
+public:
+ctlComboBoxXmlHandler() : wxComboBoxXmlHandler() {}
+virtual wxObject *DoCreateResource();
+virtual bool CanHandle(wxXmlNode *node);
+};
+
+
+#endif 
--- /dev/null
+++ src/ui/xh_ctlcombo.cpp
@@ -0,0 +1,31 @@
+//
+//
+// pgAdmin III - PostgreSQL Tools
+// RCS-ID:  $Id: xh_ctlcombo.cpp,v 1.1 2004/08/11 21:28:49 andreas Exp $
+// Copyright (C) 2002 - 2004, The pgAdmin Development Team
+// This software is released under the Artistic Licence
+//
+// xh_ctlcombo.cpp - ctlComboBox handler
+//
+//
+ 
+#include wx/wx.h
+#include xh_ctlcombo.h
+#include ctlComboBox.h
+
+IMPLEMENT_DYNAMIC_CLASS(ctlComboBoxXmlHandler, wxComboBoxXmlHandler)
+
+
+wxObject *ctlComboBoxXmlHandler::DoCreateResource()
+{ 
+ctlComboBox *ctl=new ctlComboBox(m_parentAsWindow, GetID(), GetPosition(), 
GetSize(), GetStyle());
+
+SetupWindow(ctl);
+   
+return ctl;
+}
+
+bool ctlComboBoxXmlHandler::CanHandle(wxXmlNode *node)
+{
+return IsOfClass(node, wxT(ctlComboBox));
+}
---(end of broadcast)---
TIP 8: explain analyze is your friend


[pgadmin-hackers] src compilation on Win32

2004-08-11 Thread Yuri B. Lukyanov
sorry for my english.

Please, help me to build Win32 binaries from project sources.
Why I can't open the poject/workspace by MS Visual C++ 6.0?

___
Best regards, Yuri B. Lukyanov
12  2004 . 7:55:39
mailto:[EMAIL PROTECTED]


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings