Re: [GENERAL] Configure can't find com_err on OpenBSD for --with-krb5
AC_SEARCH_LIBS(com_err, [krb5 'krb5 -ldes -lasn1 -lroken' com_err], [], [AC_MSG_ERROR([could not find function 'com_err' required for Kerberos 5])]) AC_SEARCH_LIBS(krb5_sendauth, [krb5 'krb5 -ldes -lasn1 -lroken'], [], [AC_MSG_ERROR([could not find function 'krb5_sendauth' required for Kerberos 5])]) but I'm not sure why no one else would've complained before, if that were necessary... Where are we on this? A thousand apologies, I never posted back my results. I got it to build by hacking configure as per the attached patch. Notice I don't have roken -- don't know what that is. -lroken should probably be patched a second place; I only did it on the first one and it worked. Alas, I haven't actually had a chance to see if Kereberos authentication works, I only know this builds. -Thanks, Jim *** configure.dist Tue Feb 6 22:48:58 2007 --- configure Sun Mar 4 13:57:52 2007 *** *** 6535,6541 rm -f conftest.err conftest.$ac_objext \ conftest$ac_exeext conftest.$ac_ext if test $ac_cv_search_com_err = no; then ! for ac_lib in krb5 'krb5 -ldes -lasn1 -lroken' com_err; do LIBS=-l$ac_lib $ac_func_search_save_LIBS cat conftest.$ac_ext _ACEOF /* confdefs.h. */ --- 6535,6541 rm -f conftest.err conftest.$ac_objext \ conftest$ac_exeext conftest.$ac_ext if test $ac_cv_search_com_err = no; then ! for ac_lib in krb5 'krb5 -lcrypto -lasn1' com_err; do LIBS=-l$ac_lib $ac_func_search_save_LIBS cat conftest.$ac_ext _ACEOF /* confdefs.h. */ *** *** 6665,6671 rm -f conftest.err conftest.$ac_objext \ conftest$ac_exeext conftest.$ac_ext if test $ac_cv_search_krb5_sendauth = no; then ! for ac_lib in krb5 'krb5 -ldes -lasn1 -lroken'; do LIBS=-l$ac_lib $ac_func_search_save_LIBS cat conftest.$ac_ext _ACEOF /* confdefs.h. */ --- 6665,6671 rm -f conftest.err conftest.$ac_objext \ conftest$ac_exeext conftest.$ac_ext if test $ac_cv_search_krb5_sendauth = no; then ! for ac_lib in krb5 'krb5 -lcrypto -lasn1 -lroken'; do LIBS=-l$ac_lib $ac_func_search_save_LIBS cat conftest.$ac_ext _ACEOF /* confdefs.h. */ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] Configure can't find com_err on OpenBSD for --with-krb5
--On Sunday, March 4, 2007 12:40 AM -0500 Tom Lane [EMAIL PROTECTED] wrote: You need to look at the config.log output to see exactly what configure tried to do and what error it got. Thanks, Tom, this was helpful!! Here's the problem: when configure tries to compile the code snippet to check for com_err, it needs to do this with -lcrypto added, but it's not using that. What's the right way to fix this? I could probably get it to work by brutally hacking configure, but there's got to be a better way. -Thanks, Jim ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] Configure can't find com_err on OpenBSD for --with-krb5
I am trying to build PostgreSQL 8.2.3 on OpenBSD 4.0. When I give the command ./configure -v --with-openssl --with-krb5 --with-includes=/usr/include/kerberosV I get: checking for library containing com_err... no configure: error: could not find function 'com_err' required for Kerberos 5 This is puzzling, because com_err.o is clearly listed in libkrb5.a. Any thoughts on how to get this to build would be appreciated. -Thanks, Jim ---(end of broadcast)--- TIP 1: 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: [GENERAL] Configure can't find com_err on OpenBSD for --with-krb5
--On Saturday, March 3, 2007 11:24 PM -0500 Tom Lane [EMAIL PROTECTED] wrote: I am trying to build PostgreSQL 8.2.3 on OpenBSD 4.0. When I give the command ./configure -v --with-openssl --with-krb5 --with-includes=/usr/include/kerberosV I get: checking for library containing com_err... no configure: error: could not find function 'com_err' required for Kerberos 5 Perhaps you need a --with-libs switch too? Usually, if the package didn't put its include files right in /usr/include, it likely didn't put the libraries right in /usr/lib either. Hmm. libkrb5 is in /usr/lib -- with all the rest of the libs -- not somewhere special. I also have /usr/lib/libcom_err.a too, and it seems to have com_err.o also. Putting in an explicit ./configure --with-openssl --with-krb5 --with-includes=/usr/include/kerberosV --with-libs=/usr/lib (sorry for the word wrap) doesn't help. The standard PostgreSQL port that OpenBSD wants to make is (alas) 8.1.8. -Thanks, Jim ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] PG Email Client
dbmail isn't as fast as dovecot for a single user, single event. But not by much. However, it scales *much* better into the 100's and 1000's of actions. $.02 I came within an eyelash of going live with dbmail, and then pulled back. This was a year or so ago, I don't remember exactly. The performance I was getting on very large IMAP folders was just awful. So I turned on PostgreSQL query logging, and looked at the query it was throwing at the database to select an IMAP folder. And then I looked at the schema. I remember being horrified. It was clear that as a pure database application, dbmail was *a mess*. The schema was just not well designed for the queries they were actually making, and not even slightly well indexed. They may have fixed this in the meantime. I did look at the schema for archiveopteryx, and it looked to me to be much better thought out. I got as far as compiling archiveopteryx on my OS of choice (OpenBSD, no flames please) which was not a supported platform. It built, but I didn't go further, so I don't have any results. There's a lot of work in dbmail, and the architecture around the database seems to me to be quality stuff. Now if only they've gotten the database coding up to the same level ... If a database as a message store cannot give good performance, then why do it. Asking for good performance on a folder of 65K messages is not asking for the moon. dbmail broke my heart. This was a while ago, maybe they fixed it, or maybe I had my database tuned wrong, but I'd encourage anybody using a database as a message store for an E-mail system to look over the schema with a fine-tooth comb and evaluate it like you would part of your ERP system. If the schema is not well designed for a typical IMAP query, run the other way. /$.02 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] Building html documentation
The instructions for building html documentation make the assumption that docbook-dsssl (with perhaps other pieces) is already installed. As I'm fond of saying, the assumption is a lethal weapon. Could some kind soul post a URL with *COMPLETE* instructions for what to download and how to install it assuming that none of the docbook-whatever pieces are installed? The install instructions with the download of docbook-dsssl make no sense unless some other stuff is already installed. Grr, the OpenBSD port of textproc/docbook-dsssl seems to be broken ... -Thanks, Jim ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] Subtransaction syntax in 7.5??
I'm thrilled by the news that nested transactions will make it into 7.5 after all, and trying to learn how this will work. The question is what will be the syntax to start / commit / rollback a subtransaction. Leaking a bit from pgsql-hackers [hope it's not bad etiquette to do this] I see this very subject was the subject of some lively discussion as recently as 3 days ago. Could one of you kind folk on the hackers list post something here when there's a resolution of this? Just a pointer to a message on the hackers list would be fine ... -Thanks, Jim ---(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: [GENERAL] Poatgresql database on more than one disk
--On Monday, May 31, 2004 2:14 PM -0500 Philip A. Chapman [EMAIL PROTECTED] wrote: On Tue, 2004-05-25 at 18:33, Barry wrote: Is it possible to configure Postgresql to have seperate databases on seperate disks ? One solution is to run two postmasters (two services). Each would use a different value for the PGDATA environment variable. Pardon me for being dense, but I don't see how, with this approach, you maintain transaction integrity between the two databases. Suppose you need a transaction involving tables from both databases. Can you explain how you achieve this? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Resolved: PostGreSQL - Accessing It
--On Saturday, August 16, 2003 11:40 AM -0400 Bruce Momjian [EMAIL PROTECTED] wrote: I wonder if we should have a novice mode for psql? Are there other things it could control? Change the prompt when output is redirected with \o. I don't know how many times I've redirected output with \o to get a single query in HTML, then forgotten that I did that and been puzzled why my subsequent queries didn't show any results! There's always this head-slap-the-forehead moment when I finally take a look at the HTML, and see all this other stuff on the end ... :-) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org