And you're tables are probably defined as dbmail_users etc, whereas your config file doesn't specify a table_prefix=dbmail_
Ilja Booij wrote: > Thanks for finding this. I fixed the download page. > > Ilja > > > 2005/6/3, FullScaleCommerce.com Inc <[EMAIL PROTECTED]>: > >>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 >>_______________________________________________ >>Dbmail mailing list >>[email protected] >>https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
