Eric,
Configuration looks OK to me.
I think it might be a good idea if you turned trace on on pgsql, then
you can see what SQL, if any, is being executed. I think -d can do
this on the command line to the postmaster.
Regards
Ben
On 29 Dec 2006, at 00:24, Monchanin Eric wrote:
Hi All,
I am trying to set up my dlr to a postgresql database.
I re configured and installed kannel 1.4.0 with --with-pgsql and
everything went fine.
Then I added the following to my kannel.conf file
(+ dlr-storage = pgsql in the core group)
group = pgsql-connection
id = mydlr
host = 127.0.0.1
username = foo
password = bar
database = dlr
max-connections = 1
group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
and restarted kannel.
I have bearerbox, smsbox and wapbox started, no sqlbox (errors when
patching kannel)
At the start of kannel, I have an sql connection authorized, then an
unexpected EOF on client connection.
Dec 28 20:14:44 localhost postgres[15590]: [4-1] LOG: connection
received: host=127.0.0.1 port=60672
Dec 28 20:14:44 localhost postgres[15590]: [5-1] LOG: connection
authorized: user=foo database=dlr
Dec 28 20:14:44 localhost postgres[15590]: [6-1] LOG: unexpected
EOF on
client connection
Any idea what could be wrong here ? do I need sqlbox, then how can
I get
it for kannel 1.4.0 (already patched for mbuni)
thanks you very much for your answers,
Eric
