[asterisk-users] how to store sip.conf and extension.conf into phpmyadmin

[rafa alfurqan]

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
-----------------

  Name:   asterisk
  DSN:    asterisk-connector
    Last connection attempt: 1969-12-31 19:00:00
  Pooled: No
  Connected: Yes

i was insert this configuration in sip.conf file
[1001]
type    = friend
context = tutorial
username = 1001
secret  = 1001
host    = dynamic

could this configuration store into database in phpmyadmin?

thank you


On 9/13/14, rafa alfurqan <rafa.alfurqan at gmail.com> wrote:
> 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 at 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
>
>
>
> On 9/13/14, acheraime at gmail.com <acheraime at gmail.com> wrote:
>> I would suggest you to use asterisk realtime. In this case your peers and
>> extensions can be configured from database.
>> https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration
>>
>>
>>
>>
>> Sent from my iPhone
>>
>>> On Sep 13, 2014, at 9:44 AM, rafa alfurqan <rafa.alfurqan at gmail.com>
>>> wrote:
>>>
>>> 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
>>> --
>>> _____________________________________________________________________
>>> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>>> New to Asterisk? Join us for a live introductory webinar every Thurs:
>>>               http://www.asterisk.org/hello
>>>
>>> asterisk-users mailing list
>>> To UNSUBSCRIBE or update options visit:
>>>   http://lists.digium.com/mailman/listinfo/asterisk-users
>>
>> --
>> _____________________________________________________________________
>> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>> New to Asterisk? Join us for a live introductory webinar every Thurs:
>>                http://www.asterisk.org/hello
>>
>> asterisk-users mailing list
>> To UNSUBSCRIBE or update options visit:
>>    http://lists.digium.com/mailman/listinfo/asterisk-users
>>
>