Getting into archive to help other users in the future. Adding dbmail to an additional server, already had it working for many months on first server.
Dutifully went to download page and added line required to get version 2.1 to debian sources.list on machine. apt-get dbmail-pgsql (OOOPS COULD YOU PLEASE MENTION NEED TO apt-get dbmail2-pgsql on the download page for debian instrucstions) Hours of stupidness ensued... why was relation "users" not found? Finally figured out by using apt-cache search dbmail* that I had the wrong name: apt-cache search dbmail* dbmail-mysql - Fast and scalable sql based imap and pop mailserver dbmail-pgsql - Fast and scalable sql based imap and pop mailserver dbmail2-sqlite - fast and scalable sql based imap and pop mailserver dbmail2-mysql - fast and scalable sql based imap and pop mailserver dbmail2-pgsql - fast and scalable sql based imap and pop mailserver dbmail2-sqlite-ldap - fast and scalable sql based imap and pop mailserver dbmail2-pgsql-ldap - fast and scalable sql based imap and pop mailserver dbmail2-mysql-ldap - fast and scalable sql based imap and pop mailserver Here was what I saw for dbmail trying to connect to the pg server (which was already operating with dbmail version 2.x table structure): Jun 2 19:46:02 imgate dbmail/adduser[12334]: auth_get_known_users(): could not retrieve user list Jun 2 19:46:05 imgate dbmail/adduser[12352]: GetConfigValue(): searching value for config item [host] Jun 2 19:46:05 imgate dbmail/adduser[12352]: GetConfigValue(): found value [crunch-a.mailcruncher.com] Jun 2 19:46:05 imgate dbmail/adduser[12352]: GetConfigValue(): searching value for config item [db] Jun 2 19:46:05 imgate dbmail/adduser[12352]: GetConfigValue(): found value [dbmail] Jun 2 19:46:05 imgate dbmail/adduser[12352]: GetConfigValue(): searching value for config item [user] Jun 2 19:46:05 imgate dbmail/adduser[12352]: GetConfigValue(): found value [dbmail] Jun 2 19:46:05 imgate dbmail/adduser[12352]: GetConfigValue(): searching value for config item [pass] Jun 2 19:46:05 imgate dbmail/adduser[12352]: GetConfigValue(): found value [] Jun 2 19:46:05 imgate dbmail/adduser[12352]: __auth_query(): error executing query: [ERROR: relation "users" does not exist ] Jun 2 19:46:05 imgate dbmail/adduser[12352]: auth_get_known_users(): could not retrieve user list
