Your message dated Wed, 11 Dec 2013 09:58:09 +0000
with message-id <[email protected]>
and subject line Bug#731679: Removed package(s) from unstable
has caused the Debian Bug report #573008,
regarding smbind: database error on postgresql
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)


-- 
573008: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=573008
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: smbind
Version: 0.4.7-3
Severity: important

Hi, I just installed smbind and select postgresql as database backend.
Now, when I load url http://localhost/smbind/src/configtest.php, I get
this output:

[...]
Testing database INSERT into zones table...OK Testing database INSERT
into users table...OK Testing database INSERT into records table...DB
Error: null value violates not-null constraint

This is probably because the statement "INSERT INTO records (host)
VALUES ('test567')" is using a table with many required and unspecified
fields:
smbind=> \d records;
                                Tabella "public.records"
   Colonna   |       Tipo        |
Modificatori                     
-------------+-------------------+------------------------------------------------------
 id          | integer           | not null default
nextval('records_id_seq'::regclass)
 zone        | integer           | not null default 0
 host        | character varying | not null
 type        | character varying | not null
 pri         | integer           | not null default 0
 destination | character varying | not null
 valid       | character varying | not null default 'unknown'::character
varying
Indici:
    "records_id_key" UNIQUE, btree (id)

So, in your statement, you should also specify "type" and "destination"
required and not null fields.

Bye,
Giuseppe




--- End Message ---
--- Begin Message ---
Version: 0.4.7-5.2+rm

Dear submitter,

as the package smbind has just been removed from the Debian archive
unstable we hereby close the associated bug reports.  We are sorry
that we couldn't deal with your issue properly.

For details on the removal, please see http://bugs.debian.org/731679

The version of this package that was in Debian prior to this removal
can still be found using http://snapshot.debian.org/.

This message was generated automatically; if you believe that there is
a problem with it please contact the archive administrators by mailing
[email protected].

Debian distribution maintenance software
pp.
Ansgar Burchardt (the ftpmaster behind the curtain)

--- End Message ---

Reply via email to