Good morning,<br><br>I'm having suddenly cut-offs and I don`t know why. It's been hapenning since I enabled cdr_odbc/func_odbc in my system. <br>We use func_odbc to register some queue member's events (login, pause, etc.) at an external DB ('remoto' connector) and to uptade local tables at a local DB ('local' connector). <br>
Currently we are usind cdr_odbc to Postgresql and cdr_addon to MySQL (wich we are planing to eliminate soon)<br>Mayor issue is that SIP peers dissapear for 1 minute until modules get reloaded.<br><br>Asterisk Version: 1.4.21.1 <br>
Local BD: Postgresql 7.4.19<br>External BD: Postgresql 7.4.19<br><br>This is what I see at logs:<br><font size="1"><br><i><font size="2">Problem is begginig:</font></i><br></font><div style="margin-left: 40px;"><font size="1">[May 11 09:02:57] NOTICE[17727] <b>loader.c: 2 modules will be loaded</b>.</font><br>
<font size="1">[May 11 09:02:57] NOTICE[17727] res_odbc.c: Adding ENV var: INFORMIXSERVER=my_special_database</font><br><font size="1">[May 11 09:02:57] NOTICE[17727] res_odbc.c: Adding ENV var: INFORMIXDIR=/opt/informix</font><br>
<font size="1">[May 11 09:02:57] NOTICE[17727] res_odbc.c: Connecting local</font><br><font size="1">[May 11 09:02:57] NOTICE[17727] res_odbc.c: res_odbc: Connected to local [<b>conector-loca</b>l]</font><br><font size="1">[May 11 09:02:57] NOTICE[17727] res_odbc.c: Registered ODBC class 'local' dsn->[conector-local]</font><br>
<font size="1">[May 11 09:02:57] NOTICE[17727] res_odbc.c: Connecting remoto</font><br><font size="1">[May 11 09:02:57] NOTICE[17727] res_odbc.c: res_odbc: Connected to remoto [<b>connector-remoto</b>]</font><br><font size="1">[May 11 09:02:57] NOTICE[17727] res_odbc.c: Registered ODBC class 'remoto' dsn->[connector-remoto]</font><br>
<font size="1">[May 11 09:02:57] NOTICE[17727] res_odbc.c: res_odbc loaded.</font><br><font size="1">[May 11 09:02:57] NOTICE[17727] config.c: Registered Config Engine odbc</font><br><font size="1">[May 11 09:02:57] NOTICE[17727] cdr.c: CDR simple logging enabled.</font><br>
<br></div><i>Loader.c again!</i><div style="margin-left: 40px;"><font size="1">May 11 09:02:57] NOTICE[17727<b>] loader.c: 154 modules will be loaded.</b></font><br><br></div><i>I have my realtime peers with MySQL not Postgresql, but...</i><br>
<div style="margin-left: 40px;"><font size="1">May 11 09:02:57] ERROR[17727] res_config_pgsql.c: Postgresql RealTime: Failed to connect database server asterisk on . Check debug for more info.</font><br><font size="1">[May 11 09:02:57] NOTICE[17727] config.c: Registered Config Engine pgsql</font><br>
<font size="1">[May 11 09:02:58] NOTICE[17727] config.c: Registered Config Engine mysql</font><br><font size="1">[May 11 09:02:58] NOTICE[17727] app_queue.c: Queue members successfully reloaded from database.</font><br><font size="1">[May 11 09:02:58] NOTICE[17727] chan_ooh323.c: ---------------------------------------------------------------------------------</font><br>
<font size="1">--- ******* IMPORTANT NOTE ***********</font><br><font size="1">---</font><br><font size="1">--- This module is currently unsupported. Use it at your own risk.</font><br><font size="1">---</font><br><font size="1">---------------------------------------------------------------------------------</font><br>
<font size="1">[May 11 09:02:58] NOTICE[17727] chan_ooh323.c: Unable to load config ooh323.conf, OOH323 disabled</font><br><font size="1">[May 11 09:02:58] NOTICE[17727] pbx_ael.c: Starting AEL load process.</font><br><font size="1">[May 11 09:02:58] NOTICE[17727] pbx_ael.c: AEL load process: calculated config file name '/etc/asterisk/extensions.ael'.</font><br>
<font size="1">[May 11 09:02:58] NOTICE[17727] pbx_ael.c: File /etc/asterisk/extensions.ael not found; AEL declining load</font><br><font size="1">[May 11 09:02:58] ERROR[17813] chan_zap.c: !! Got S-frame while link down</font><br>
<br></div><i>Realtime peers are reacheble again, why they got unreachable?</i><br><div style="margin-left: 40px;"><font size="1">[May 11 09:02:59] NOTICE[17835] chan_sip.c: Peer '870' is now Reachable. (27ms / 2000ms)</font><br>
<font size="1">[May 11 09:03:00] NOTICE[17835] chan_sip.c: Peer '901' is now Reachable. (26ms / 2000ms)</font><br><font size="1">[May 11 09:03:00] NOTICE[17835] chan_sip.c: Peer '982' is now Reachable. (62ms / 2000ms)</font><br>
<font size="1">[May 11 09:03:07] NOTICE[17835] chan_sip.c: Peer '937' is now Reachable. (62ms / 2000ms)</font><br><font size="1">[May 11 09:03:11] NOTICE[17835] chan_sip.c: Peer '855' is now Reachable. (62ms / 2000ms)</font><br>
<font size="1">[May 11 09:03:13] NOTICE[17835] chan_sip.c: Peer '914' is now Reachable. (61ms / 2000ms)</font><br><font size="1">[May 11 09:03:13] NOTICE[17835] chan_sip.c: Peer '804' is now Reachable. (62ms / 2000ms)</font><br>
</div><br>I'll be very gratefull by your suggestions.<br><br>Elder Arohuanca Lagos<br>Phone: +51 1 994149553<br><br><br>