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

Sat Sep 13 12:52:56 CDT 2014

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

 [asterisk-connector]
Description = <A description here>
Trace       = Off
TraceFile   = stderr
Driver      = MySQL
SERVER      = <server_host>
PORT        = 3306
DATABASE    = <database_name>

------------------ res_odbc.conf ---------------------

[telephony]
enabled => yes
dsn => asterisk-connector
username => <db_username>
password =>  <db_pass>
pre-connect => yes

----------------- extconfig.conf -----------------

sippeers => odbc,telephony,sipfriends
sipregs => odbc,telephony,sipregs
voicemail => odbc,telephony,voicemail_users
extensions => odbc,telelephony,extensions
queues => odbc,telephony,queue
queue_members => odbc,telephony,queue_member
followme => odbc,telephony,followme
followme_numbers => odbc,telephony,followme_numbers

Don't forget to create the appropriate tables and  load res_odbc.so
Also your shows that asterisk can't resolve the name "sipauth.deltathree.com"
thus unable to register to it. Make sure that your server is connected to
internet and configured with a DNS server.

Have a good week-end.

Adolphe Cher-Aime

On Sat, Sep 13, 2014 at 12:35 PM, 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
> >
>
> --
> _____________________________________________________________________
> -- 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20140913/368bf19a/attachment.html>