Hello Gregory, On Thu, Sep 15, 2005 at 11:27:47AM +0200, Gregory Machin wrote:
[ ... ] > sql_host: 127.0.0.1 <http://127.0.0.1> > sql_db: pmacct > sql_table: acct > sql_table_version: 2 > sql_passwd: arealsmartpwd > sql_user: pmacct [ ... ] I think you can safely remove the above 'sql_host' directive. At first try to verify manually that the above parameters are correct by using the 'psql' util (eg. psql -U pmacct; insert the password; verify the existence of the 'acct' table; verify write permissions to such table for pmacctuser). If all checks are ok (i suspect that the problem might be to the table name; it could be 'acct_v2' instead of 'acct'), then verify that the SQL table is in v2 format by comparing its fields with the ones of the 'acct_v2' table contained into the SQL script sql/pmacct-create-table_v2.pgsql . Cheers, Paolo
