<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#ffffff" text="#000000">
I've got a strange issue with the latest kamailio. I also had this
problem with kamailio 3.0.3 downloaded from the webpage.<br>
<br>
I can start kamailio, but after a while (sometimes within one
minuten, sometimes after an hour),<br>
I get the following log errors:<br>
<br>
Oct 12 15:46:24 sp01 /sbin/kamailio[26621]: ERROR: <core>
[db.c:387]: invalid type (3) or nul (0) version columns for trusted<br>
Oct 12 15:46:24 sp01 /sbin/kamailio[26621]: ERROR: <core>
[db.c:405]: querying version for table trusted<br>
Oct 12 15:46:24 sp01 /sbin/kamailio[26621]: ERROR: permissions
[trusted.c:249]: error during table version check.<br>
Oct 12 15:46:24 sp01 /sbin/kamailio[26621]: ERROR: <core>
[sr_module.c:832]: init_mod_child(): Error while initializing module
permissions (//lib/kamailio/modules_k/permissions.so)<br>
Oct 12 15:46:24 sp01 /sbin/kamailio[26621]: ERROR: <core>
[pt.c:481]: ERROR: fork_tcp_process(): init_child failed for process
10, pid 26621, "tcp receiver child=0"<br>
Oct 12 15:46:24 sp01 /sbin/kamailio[26621]: ERROR: <core>
[tcp_main.c:4811]: ERROR: tcp_main: fork failed: Success<br>
Oct 12 15:46:24 sp01 /sbin/kamailio[26625]: : <core>
[pass_fd.c:103]: ERROR: recv_all: 1st recv on 21 failed: Connection
reset by peer<br>
Oct 12 15:46:24 sp01 /sbin/kamailio[26625]: : <core>
[tcp_main.c:3323]: ERROR: handle_tcp_child: read from tcp child 0
(pid 26621, no 10) Connection reset by peer [104]<br>
Oct 12 15:46:24 sp01 /sbin/kamailio[26625]: : <core>
[pass_fd.c:293]: ERROR: receive_fd: EOF on 19<br>
Oct 12 15:46:24 sp01 /sbin/kamailio[26611]: ALERT: <core>
[main.c:738]: child process 26621 exited normally, status=255<br>
Oct 12 15:46:24 sp01 /sbin/kamailio[26611]: INFO: <core>
[main.c:756]: INFO: terminating due to SIGCHLD<br>
Oct 12 15:46:24 sp01 /sbin/kamailio[26625]: INFO: <core>
[main.c:807]: INFO: signal 15 received<br>
<br>
Looking at the error message, it thinks that the column type of
table_version in the table version is a string (type 3), and it
should be an int (type 1).<br>
But in the database it really is an int.<br>
<br>
When I run kamailio with debugging on level 5, I see that it's
trying to run the "select table_version from version where
table_name='trusted'" several times when kamailio starts (for every
child thread).<br>
And then minutes, of even an hour later, it suddenly continues with
that check, but based on a database response from another query.<br>
This is the "select password from subscriber ....etc...".<br>
And that column is indeed an string.<br>
<br>
I'm using PostgreSQL 8.4 as server,<br>
but maybe someone has seen this before, or now where I have to start
looking?<br>
I first saw it yesterday when started to use the permissions module.<br>
I only see this with the trusted table,<br>
And always it uses the "select password from subscriber ... "
response when giving this error.<br>
<br>
So is this an error in the permissions module / trusted.c file?<br>
or something in auth_db that's not freeing the response correctly?<br>
<br>
Strange thing is, that is sometimes happens very quick, and
sometimes it can take an half hour or hour.<br>
<br>
I can mail the full log if anybody is interested and thinks he/she
can help me.<br>
<br>
With kind regards,<br>
Robert Verspuy<br>
<br>
<br>
<div class="moz-signature">-- <br>
<b>Exa-Omicron</b><br>
Patroonsweg 10<br>
3892 DB Zeewolde<br>
Tel.: 088-OMICRON (66 427 66)<br>
<a class="moz-txt-link-freetext" href="http://www.exa-omicron.nl">http://www.exa-omicron.nl</a></div>
</body>
</html>