On Friday 31 August 2007, Cliff Flood wrote:
Hi,
I have an Ubuntu 6.06 install with PostgreSQL 8.1 and OpenSER 1.2.2 which I am testing at the moment.
I have tested OpenSER with MySQL and it worked fine but when when I want to switch to PostgreSQL I'm having some difficulty.
I have used the postgressqldb.sh script to initialise the database and it has completed without error.
When I start OpenSER I get the following lines in my PostgreSQL logs:
LOG: connection received: host=127.0.0.1 port=37610 LOG: connection authorized: user=openser database=openser LOG: SSL SYSCALL error: EOF detected LOG: could not receive data from client: Connection reset by peer LOG: unexpected EOF on client connection
Hello Cliff,
you're using the SSL mode of the postgresql library, is this intentional? I don't know if this is supported from OpenSER. Anyway, you've get an error during the pgReadData call, http://doxygen.postgresql.org/fe-secure_8c.html#a0df80706c485b6104f901dc11c3...
I have looked at OpenSER's logs with debugging turned on but I don't see anything that looks like an error but I would be happy to provide them.
`openserctl moni` returns:
ERROR: Error opening OpenSER's FIFO /tmp/openser_fifo ERROR: Make sure you have the line 'modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo")' in your config ERROR: and also have loaded the mi_fifo module.
Does the server starts at all? Normally the fifo should work. There is an error in the postgresql driver in 1.2.2 present that was fixed after the release, have you applied this patch? You've find further information about this in the thursday thread "openser 1.2.2 segmentation fault".
Cheers,
Henning