Folks,
I have what *appears to be* a cleanly installed dbmail-postgresql-1.2.1
form the BSD ports tree performed with 'make install -DWITH_PGSQL'
I have a valid user:group dbmail:dbmail on the system, have created a
Postgresql database user 'dbmail' owning database 'dbmail' and uploaded
the 'dbmail' schema to create the empty tables & such in said database.
I can manually see and manipulate said DB via the psql interface, which
is owned by pgsql with a 'GRANT ALL ON DATABASE dbmail TO dbmail;"
giving dbmail full acccess to it.
/usr/local/etc/dbmail.conf has:
# Database settings
host=localhost
user=dbmail
pass=<the valid and tested pwd>
db=dbmail
Postgres is running with the default port on localhost, and happily
serves Zope/Plone against their (separate DB) via that port.
When trying to use dbmail-adduser, however, I get an error:
*** dbmail-adduser ***
Opening connection to database...
Failed. Could not connect to database (check log)
At which point, 'tail /var/log/maillog' shows:
Nov 24 08:19:03 quica dbmail/adduser[62733]: dbconnect(): PQconnectdb
failed: FATAL: no PostgreSQL user name specified in startup packet
I then try 'dbmanage -a <user> <pwd>' to add a user, getting what
*seems* to be completion with no error messages thrown.
If I attempt to repeat that, it reports that said user aleady exists.
- clearly the information is being stored *somewhere*...
BUT as a "SELECT * FROM users;" still shows an empty table...
It doesn't seem to be in the dbmail database...
(MySQL is not running on the box)
Ideas, anyone?
Bill Hacker
I have what *appears to be* a cleanly installed dbmail-postgresql-1.2.1
form the BSD ports tree performed with 'make install -DWITH_PGSQL'
I have a valid user:group dbmail:dbmail on the system, have created a
Postgresql database user 'dbmail' owning database 'dbmail' and uploaded
the 'dbmail' schema to create the empty tables & such in said database.
I can manually see and manipulate said DB via the psql interface, which
is owned by pgsql with a 'GRANT ALL ON DATABASE dbmail TO dbmail;"
giving dbmail full acccess to it.
/usr/local/etc/dbmail.conf has:
# Database settings
host=localhost
user=dbmail
pass=<the valid and tested pwd>
db=dbmail
Postgres is running with the default port on localhost, and happily
serves Zope/Plone against their (separate DB) via that port.
When trying to use dbmail-adduser, however, I get an error:
*** dbmail-adduser ***
Opening connection to database...
Failed. Could not connect to database (check log)
At which point, 'tail /var/log/maillog' shows:
Nov 24 08:19:03 quica dbmail/adduser[62733]: dbconnect(): PQconnectdb
failed: FATAL: no PostgreSQL user name specified in startup packet
I then try 'dbmanage -a <user> <pwd>' to add a user, getting what
*seems* to be completion with no error messages thrown.
If I attempt to repeat that, it reports that said user aleady exists.
- clearly the information is being stored *somewhere*...
BUT as a "SELECT * FROM users;" still shows an empty table...
It doesn't seem to be in the dbmail database...
(MySQL is not running on the box)
Ideas, anyone?
Bill Hacker