[asterisk-users] Problems with res_odbc

[Daniel - Asterisk]

Good morning,

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.
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).
Currently we are usind cdr_odbc to Postgresql and cdr_addon to MySQL (wich
we are planing to eliminate soon)
Mayor issue is that SIP peers dissapear for 1 minute until modules get
reloaded.

Asterisk Version: 1.4.21.1
Local BD: Postgresql 7.4.19
External BD: Postgresql 7.4.19

This is what I see at logs:

*Problem is begginig:*
[May 11 09:02:57] NOTICE[17727] *loader.c: 2 modules will be loaded*.
[May 11 09:02:57] NOTICE[17727] res_odbc.c: Adding ENV var:
INFORMIXSERVER=my_special_database
[May 11 09:02:57] NOTICE[17727] res_odbc.c: Adding ENV var:
INFORMIXDIR=/opt/informix
[May 11 09:02:57] NOTICE[17727] res_odbc.c: Connecting local
[May 11 09:02:57] NOTICE[17727] res_odbc.c: res_odbc: Connected to local [*
conector-loca*l]
[May 11 09:02:57] NOTICE[17727] res_odbc.c: Registered ODBC class 'local'
dsn->[conector-local]
[May 11 09:02:57] NOTICE[17727] res_odbc.c: Connecting remoto
[May 11 09:02:57] NOTICE[17727] res_odbc.c: res_odbc: Connected to remoto [*
connector-remoto*]
[May 11 09:02:57] NOTICE[17727] res_odbc.c: Registered ODBC class 'remoto'
dsn->[connector-remoto]
[May 11 09:02:57] NOTICE[17727] res_odbc.c: res_odbc loaded.
[May 11 09:02:57] NOTICE[17727] config.c: Registered Config Engine odbc
[May 11 09:02:57] NOTICE[17727] cdr.c: CDR simple logging enabled.

*Loader.c again!*May 11 09:02:57] NOTICE[17727*] loader.c: 154 modules will
be loaded.*

*I have my realtime peers with MySQL not Postgresql, but...*
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.
[May 11 09:02:57] NOTICE[17727] config.c: Registered Config Engine pgsql
[May 11 09:02:58] NOTICE[17727] config.c: Registered Config Engine mysql
[May 11 09:02:58] NOTICE[17727] app_queue.c: Queue members successfully
reloaded from database.
[May 11 09:02:58] NOTICE[17727] chan_ooh323.c:
---------------------------------------------------------------------------------
---  ******* IMPORTANT NOTE ***********
---
---  This module is currently unsupported.  Use it at your own risk.
---
---------------------------------------------------------------------------------
[May 11 09:02:58] NOTICE[17727] chan_ooh323.c: Unable to load config
ooh323.conf, OOH323 disabled
[May 11 09:02:58] NOTICE[17727] pbx_ael.c: Starting AEL load process.
[May 11 09:02:58] NOTICE[17727] pbx_ael.c: AEL load process: calculated
config file name '/etc/asterisk/extensions.ael'.
[May 11 09:02:58] NOTICE[17727] pbx_ael.c: File /etc/asterisk/extensions.ael
not found; AEL declining load
[May 11 09:02:58] ERROR[17813] chan_zap.c: !! Got S-frame while link down

*Realtime peers are reacheble again, why they got unreachable?*
[May 11 09:02:59] NOTICE[17835] chan_sip.c: Peer '870' is now Reachable.
(27ms / 2000ms)
[May 11 09:03:00] NOTICE[17835] chan_sip.c: Peer '901' is now Reachable.
(26ms / 2000ms)
[May 11 09:03:00] NOTICE[17835] chan_sip.c: Peer '982' is now Reachable.
(62ms / 2000ms)
[May 11 09:03:07] NOTICE[17835] chan_sip.c: Peer '937' is now Reachable.
(62ms / 2000ms)
[May 11 09:03:11] NOTICE[17835] chan_sip.c: Peer '855' is now Reachable.
(62ms / 2000ms)
[May 11 09:03:13] NOTICE[17835] chan_sip.c: Peer '914' is now Reachable.
(61ms / 2000ms)
[May 11 09:03:13] NOTICE[17835] chan_sip.c: Peer '804' is now Reachable.
(62ms / 2000ms)

I'll be very gratefull by your suggestions.

Elder Arohuanca Lagos
Phone: +51 1 994149553
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090511/84ff6cb3/attachment.htm