I just did a make dist-clean, then compiled it and it seemed to fix it. But I'd definitely did recompile it the before emailing the list (2-3 times), so dunno why it didn't work. Oh well -- working now. Thanks for the email replies.
/Mark On 10/8/02 8:39 PM, "Eelco van Beek - IC&S" <[EMAIL PROTECTED]> wrote: > Hi Mark, > > Did you recompile after changeing the config.h? > It looks like your dbmail is trying to connect through unix sockets in > stead of connecting through TCP/IP. > > Eelco > > Mark Mackay heeft op zaterdag, 10 aug 2002 om 05:01 (Europe/Amsterdam) > het volgende geschreven: > >> Hi there. I just hit the table limit of mysql (4G) so thought I'd try >> postgresql first and see if it performs any better, etc. However I >> can't >> seem to get it going. >> >> I've got two servers. >> 1) Dedicated postgresql >> 2) POP/IMAP Toaster >> >> I can connect to the database using the psql command line utility from >> the >> toaster box, no problems. I've set up a simple trusted subnet, which >> doesn't >> require md5/ident authentication or anything. >> >>> pgsql -h dbmail-database -U dbmail dbmail >>> <works great> >> >> However when I try using dbmail, it simply says can't connect see log. >> >>> Aug 10 15:00:07 dbmail-toaster1 dbmail/adduser[7409]: auth_connect(): >> PQconnectdb failed: could not connect to server: No such file or >> directory ^IIs >> the server running locally and accepting ^Iconnections on Unix domain >> socket >> "/tmp/.s.PGSQL.5432"? >> >> I've changed the config.h to the relevant host, and can tcpdump and see >> connections going there. I >> >> I'm really new to postgres and don't know where to start looking >> (though it >> looks like a dbmail problem). I'd appreciate any help from anyone who >> can >> point me in the right direction. >> >> >> Thanks in advance, >> Mark. >> >> >> PS. I've also got dbmail running with Mysql/Innodb and thought I'd try >> postgres for comparison (debian ships with postgres, meaning I >> wouldn't have >> to worry about the upgrading the database software manually...). >> >> Is there anyone who's tried both who can give recommendations? >> >> >> >> >> _______________________________________________ >> Dbmail mailing list >> Dbmail@dbmail.org >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > __________________________ > E.J.A. van Beek > ICT Manager > IC&S > T: +31 30 2322878 > F: +31 30 2322305 > > PGP-key: > www.ic-s.nl/keys/eelco.txt > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail ......................................................................... Mark Mackay, Network Coordinator, Orcon Internet. --> DDI: (09) 480-9399 --> mobile: (021) 622 379 --> email: [EMAIL PROTECTED]
