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.alfur...@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 '12121111...@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, achera...@gmail.com <achera...@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.alfur...@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 >
-- _____________________________________________________________________ -- 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