similar to: logs show two connections to database even though using static driver

We created a new virtual domain and created a user in that domain in our pgsql database. Instead of creating any directory structure in /home/virtual/mail/<domain>/<user>, I just sent a test email to see if dovecot's lmtp would autocreate. And it did! And mail appears to be delivered to an inbox.. but, logging is weird and I'm not sure everything is working as it should

After hearing so many good things about mdbox, I am testing it. I moved my Maildir to a test box, and did the conversion with dsync which reported no errors and appeared to go fine after I set: namespace { separator = / inbox = yes } and changed mail_location=mdbox:~/mdbox But the problem is that the Inbox now is empty in my imap client. What did I do wrong? I can see the emails are there

I am aware that there are provising for redundant database connections Basically i was working on my main db server (which is also a mail sever) I current have this in the dovecot-pgsql.conf ______________________________________________________________________ driver = pgsql connect = host=localhost port=5433 dbname=scom_billing user=pgsql password=xxxxxxxxx default_pass_scheme = PLAIN

Hi, Our mail system uses dovecot-1.0-1.2.rc15.el5 in Centos-5.1 as our imap server. It connects to a pgsql database in another server as authentication backend. It works fine except occasionally fails to reconnect to the database after temporary network block, and dovecot has to be restarted to work again in such case. Since I can't find any specific setting in dovecot.conf to handle

I just tried upgrading from 1.1.rc6 to v1.2.11, and am getting the following error: dovecot: auth(default): Fatal: Unknown database driver 'mysql'. If I change the respective line in dovecot-sql.conf from driver = mysql to driver = pgsql the error message changes accordingly: dovecot: auth(default): Fatal: Unknown database driver 'pgsql'. I quit using 1.1.rc6 because it started

i have installed database POSTGRESQL for storing call details. when i restart database i get the error. [root at localhost server]# psql -h 127.0.0.1 -U asterisk Password psql: could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? THIS IS MY /VAR/LIB/PGSQL/DATA/POSTGRESQL.CONF # CONNECTIONS AND

Hi, Going by the "static userdb" example? on this page (https://wiki.dovecot.org/VirtualUsers#homedirs), tried to achieve a similar setup in conjunction with pgsql for passdb. However I get an error "auth: Warning: sql: Ignoring changed iterate_query in /etc/dovecot/local_sql_users.conf, because userdb sql not used. (If this is intentional, set userdb_warning_disable=yes)"

Hi, I am using postgresql for my password and user databases. The problem is, that the information needed in the user database is held in more than one table. But it seems to me that dovecot expects to get all the information for mailbox, uid, gid and home in _one_ query. Is there a way to get around this? Maybe even getting some of this information by another way than pgsql (this is more a

Plagued with an error I can't get past: ==> dovecot_info.log <== dovecot: Mar 04 22:09:06 Info: Dovecot starting up ==> dovecot.log <== dovecot-auth: Mar 04 22:09:07 Fatal: Can't open configuration file /usr/local/etc/dovecot-pgsql.conf: No such file or directory dovecot: Mar 04 22:09:07 Error: child 18211 (auth) returned error 89 dovecot: Mar 04 22:09:07 Error: Auth process

I have obviously done something on my system to cause it to no longer show Shorewall log entries in the syslogs, but for the life of me I can''t figure out what. Let me first give you some details about my config which will hopefully show why I think logging should be working, and perhaps you can tell me why it''s not. I am using version 2.0.9 from the debian sarge package

Hi, I am relatively new at R, but I would like to be able to directly access my MySQL and PostgreSQL databases from R. I have been looking around CRAN and searching through Google, however I am not sure what are the best options. I have seen DBI - not sure how this works Rdbi - not sure how this works Rdbi.PgSQL - can install, but fails on trying to load RODBC - cannot

I am having a problem with the configure script for Dovecot 1.0b8. It doesn't seem to be compiling in sql engine driver support. I have specified --with-sql and --with-pgsql but when the script is done it says "Building with SQL drivers ..............:" but lists no drivers afterwards. I tried compiling it anyway but it logs the error " auth(default): Unknown database driver

Hi, I am trying to compile an application (PowerDNS) with PostgreSQL support. Where do the PowerDNS libraries get installed under CentOS? I am constantly getting the error checking for PgSQL library directory... configure: error: Didn't find the pgsql library dir in '/usr/include/lib/pgsql /usr/include/pgsql /usr/include' -- "I never look back darling, it distracts from the

Hi All, I am trying to run rsync from HP11.00 machine (source) to HP11.11 machine, as test for migration plan. The data on the source is not changing since it is snapshot of active data. Every time we try to run the following command: timex rsync -avuz --delete isynh09:/snap We get the following error: receiving file list ... done mknod

Hello, I'm trying to use postgres authentication with dovecot on a linux system running Fedora Core 2. Installation of dovecot was done by installing the rpm included in the fedora distribution ("yum install dovecot"). from /etc/dovecot.conf auth_userdb = pgsql /etc/dovecot-pgsql.conf auth_passdb = pgsql /etc/dovecot-pgsql.conf but the logs tell me: dovecot: Jul 21 19:28:39 Info:

How do I find out who is the maintainer of the php-pgsql package, please? I want to request upgrade from underlying postgresql-libs-8.1.21 (/usr/lib64/libpq.so.4) to postgresql84-libs-8.4.4 (/usr/lib64/libpq.so.5.2). Background on this request: Apache httpd's php's php-pgsql uses PostgreSQL 8.1 library (/usr/lib64/libpq.so.4), which leaks memory. PostgreSQL 8.4 library does not leak.

I just upgraded R to version 2.4.0 and now I can't install packages RdbiPgSQL. I used the same procedure I did for previous versions of R ! Actually, last time I installed RdbiPgSQL day before upgrading but now I got: downloaded 27Kb * Installing *source* package 'RdbiPgSQL' ... creating cache ./config.cache checking for PQconnectdb in -lpq... no I could not find your PostgreSQL

Hi all, I found Dag Wieers' Fedora Core 2 rpm on http://dag.wieers.com/packages/dovecot/ and installed it. Now dovecot-auth isn't complaining anymore about an unknown userdb type but I can't get authentication working. /etc/dovecot.conf (...) # Authentication process name. auth = default # plain digest-md5 anonymous auth_mechanisms = plain auth_userdb = pgsql

Dear All, Why does my configure fail like so: checking for pg_config... /usr/local/pgsql/8.2.4/bin/pg_config checking for PQexec in -lpq... no configure: *** configure: *** The PostgreSQL installation on this system appears to be broken. configure: *** Either correct the installation, or run configure configure: *** including --without-postgres Configure options are: env CC=/usr/local/bin/gcc

I'm building a database/application server with a Dual-Opteron 64 bit system. I need to run PHP4, Apache, and Postgres 8.1, but I'm having conflicts with Postgres 8.1 and PHP 4 that comes with CentOS. History: 1) I installed Apache and PHP with yum. 2) I then installed PostgreSQL 8.1 RPMs from the PG website. 3) Then, I tried to install php-pgsql with yum - and it didn't work,