How To Store Sip.conf And Extension.conf Into Phpmyadmin

Home » Asterisk Users » How To Store Sip.conf And Extension.conf Into Phpmyadmin
Asterisk Users 4 Comments

hi,

i want to sip.conf and extension.conf files could to import to the my database phpmyadmin, so the data that i had input to those file could be read into database?

any help will be appreciated.

thank you

4 thoughts on - How To Store Sip.conf And Extension.conf Into Phpmyadmin

  • Hi,

    actually i just had trying Asterisk Full RealTime Database from this site http://blog.eduguru.in/tag/configure-asterisk-mysql-connection-create-the-res_mysql-conf-file-in-etcasterisk-vi-etcasteriskres_mysql-conf-enter-the-following-general-dbhost-127-0-0-1-dbname-asteriskrealtime-dbuser/

    but in the end, i got failed. this is the log from CLI
    Connected to Asterisk 11.11.0 currently running on server-main (pid = 12017)
    [Sep 13 11:55:20] WARNING[12051]: chan_sip.c:3906 __sip_xmit: sip_xmit of 0x97ae2d8 (len 406) to (null) returned -1: Invalid argument
    [Sep 13 11:55:21] WARNING[12051]: config.c:2578 find_engine: Realtime mapping for ‘sippeers’ found to engine ‘mysql’, but the engine is not available
    [Sep 13 11:55:21] WARNING[12051]: config.c:2578 find_engine: Realtime mapping for ‘sippeers’ found to engine ‘mysql’, but the engine is not available
    [Sep 13 11:55:21] ERROR[12051]: netsock2.c:269 ast_sockaddr_resolve:
    getaddrinfo(“sipauth.deltathree.com”, “(null)”, …): No address associated with hostname
    [Sep 13 11:55:21] WARNING[12051]: acl.c:833 resolve_first: Unable to lookup ‘sipauth.deltathree.com’
    [Sep 13 11:55:21] WARNING[12051]: config.c:2578 find_engine: Realtime mapping for ‘sippeers’ found to engine ‘mysql’, but the engine is not available
    [Sep 13 11:55:21] WARNING[12051]: config.c:2578 find_engine: Realtime mapping for ‘sippeers’ found to engine ‘mysql’, but the engine is not available
    [Sep 13 11:55:21] WARNING[12051]: acl.c:962 ast_ouraddrfor: Cannot connect
    [Sep 13 11:55:21] WARNING[12051]: chan_sip.c:3906 __sip_xmit: sip_xmit of 0x97ae2d8 (len 406) to (null) returned -1: Invalid argument
    [Sep 13 11:55:21] NOTICE[12051]: chan_sip.c:15218 sip_reg_timeout:
    — Registration for ‘12121111111@sipauth.deltathree.com’ timed out, trying again (Attempt #596)
    [Sep 13 11:55:21] WARNING[12051]: chan_sip.c:3906 __sip_xmit: sip_xmit of 0x97ae2d8 (len 406) to (null) returned -1: Invalid argument
    [Sep 13 11:55:22] WARNING[12051]: chan_sip.c:3906 __sip_xmit: sip_xmit of 0x97ae2d8 (len 406) to (null) returned -1: Invalid argument

    actually, i use asterisk 11.11.0 and ubuntu 10.04

    what should i do to solve that?
    thank you

  • It’s clear in the log. “no mysql engine found”. I would suggest you to install unixodbc, configure res_odbc.conf and in extconfig.conf in place of mysql put odbc and a connection name defined in res_odbc.conf :

    Here’s some snippets.

    ——– odbc.ini —–

  • Hi,

    first, thank you for your guide. i’ve been followed your instruction till created appropirate tables and preload res_odbc.so
    (in the module files).

    this is the odbc show result

    ODBC DSN Settings
    —————