On Mon, Mar 16, 2009 at 4:41 PM, Henning Westerholt <henning.westerholt@1und1.de> wrote:

On Monday 16 March 2009, Sara EL KABIRI wrote:

> It is appearently a general error.
> The "*select * from penser.version;*" throws the same error "*ERROR 1017

> (HY000): Can't find file: './openser/version.frm' (errno: 13)*"

re-install the openser tables

Cheers,

Henning

Hi again,

I reinstalled the openser tables, and restarted kamailio ->

ims@ims-desktop:~$ sudo /etc/init.d/kamailio restart
Listening on
             udp: 127.0.0.1 [127.0.0.1]:5065
             udp: 192.168.0.99 [192.168.0.99]:5065
             tcp: 127.0.0.1 [127.0.0.1]:5065
             tcp: 192.168.0.99 [192.168.0.99]:5065
Aliases:
             tcp: ims-desktop.local:5065
             tcp: localhost:5065
             udp: ims-desktop.local:5065
             udp: localhost:5065

Mar 16 17:06:02 [6368] INFO:core:init_tcp: using epoll_lt as the TCP io watch method (auto detected)
Mar 16 17:06:02 [6370] NOTICE:core:main: version: kamailio 1.4.3-notls (i386/linux)
Mar 16 17:06:02 [6370] INFO:core:main: using 32 Mb shared memory
Mar 16 17:06:02 [6370] INFO:core:main: using 1 Mb private memory per process
Mar 16 17:06:02 [6370] INFO:sl:mod_init: Initializing StateLess engine
Mar 16 17:06:02 [6370] INFO:tm:mod_init: TM - initializing...
ims@ims-desktop:~$ Mar 16 17:06:02 [6370] INFO:maxfwd:mod_init: initializing...
Mar 16 17:06:02 [6370] INFO:usrloc:ul_init_locks: locks array size 512
Mar 16 17:06:02 [6370] INFO:registrar:mod_init: initializing...
Mar 16 17:06:02 [6370] INFO:textops:mod_init: initializing...
Mar 16 17:06:02 [6370] INFO:xlog:mod_init: initializing...
Mar 16 17:06:02 [6370] INFO:acc:mod_init: initializing...
Mar 16 17:06:02 [6370] INFO:auth:mod_init: initializing...
Mar 16 17:06:02 [6370] INFO:auth_db:mod_init: initializing...
Mar 16 17:06:02 [6370] NOTICE:presence:mod_init: initializing module ...
Mar 16 17:06:02 [6370] INFO:presence:restore_db_subs: The query returned no result
Mar 16 17:06:02 [6370] INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 220 kb
Mar 16 17:06:02 [6370] INFO:core:probe_max_receive_buffer: using a UDP receive buffer of 220 kb
Mar 16 17:06:02 [6373] NOTICE:presence:child_init: init_child [3] pid [6373]
Mar 16 17:06:02 [6371] NOTICE:presence:child_init: init_child [1] pid [6371]
Mar 16 17:06:02 [6372] NOTICE:presence:child_init: init_child [2] pid [6372]
Mar 16 17:06:02 [6375] NOTICE:presence:child_init: init_child [4] pid [6375]
Mar 16 17:06:02 [6377] NOTICE:presence:child_init: init_child [5] pid [6377]
Mar 16 17:06:02 [6379] NOTICE:presence:child_init: init_child [6] pid [6379]
Mar 16 17:06:02 [6380] NOTICE:presence:child_init: init_child [7] pid [6380]
Mar 16 17:06:03 [6384] NOTICE:presence:child_init: init_child [-1] pid [6384]
Mar 16 17:06:03 [6383] NOTICE:presence:child_init: init_child [8] pid [6383]
Mar 16 17:06:03 [6389] NOTICE:presence:child_init: init_child [9] pid [6389]
Mar 16 17:06:03 [6390] NOTICE:presence:child_init: init_child [10] pid [6390]
Mar 16 17:06:03 [6394] NOTICE:presence:child_init: init_child [11] pid [6394]
Mar 16 17:06:03 [6397] NOTICE:presence:child_init: init_child [-4] pid [6397]
Mar 16 17:06:03 [6370] NOTICE:presence:child_init: init_child [0] pid [6370]
Mar 16 17:06:03 [6396] NOTICE:presence:child_init: init_child [12] pid [6396]

ims@ims-desktop:~$
ims@ims-desktop:~$
ims@ims-desktop:~$
ims@ims-desktop:~$
ims@ims-desktop:~$ sudo netstat -anp | grep 5065
tcp        0      0 192.168.0.99:5065       0.0.0.0:*               LISTEN      6370/kamailio
tcp        0      0 127.0.0.1:5065          0.0.0.0:*               LISTEN      6370/kamailio
udp        0      0 192.168.0.99:5065       0.0.0.0:*                           6370/kamailio
udp        0      0 127.0.0.1:5065          0.0.0.0:*                           6370/kamailio
ims@ims-desktop:~$
ims@ims-desktop:~$
ims@ims-desktop:~$
ims@ims-desktop:~$ ims@ims-desktop:~$ kamctl moni
ERROR: Error opening Kamailio's FIFO /tmp/kamailio_fifo
ERROR: Make sure you have the line 'modparam("mi_fifo", "fifo_name", "/tmp/kamailio_fifo")' in your config
ERROR: and also have loaded the mi_fifo module.

It seems that Kamailio is now working fine. Approximately fine i would say because of the error throwed by "kamctl moni"... Is there something to worry about?

--
S.