<div dir="ltr">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 :<div><br></div><div>Here's some snippets.<br><div><br></div><div>-------- odbc.ini -------</div><div><br></div><div> [asterisk-connector] </div><div>Description = <A description here></div><div>Trace = Off</div><div>TraceFile = stderr</div><div>Driver = MySQL</div><div>SERVER = <server_host></div><div>PORT = 3306</div><div>DATABASE = <database_name></div><div><br></div><div><br></div><div><br></div><div>------------------ res_odbc.conf ---------------------</div><div><br></div><div><div>[telephony] </div><div>enabled => yes</div><div>dsn => asterisk-connector</div><div>username => <db_username></div><div>password => <db_pass></div><div>pre-connect => yes</div></div><div><br></div><div><br></div><div><br></div><div>----------------- extconfig.conf -----------------</div><div><br></div><div><div>sippeers => odbc,telephony,sipfriends</div><div>sipregs => odbc,telephony,sipregs</div><div>voicemail => odbc,telephony,voicemail_users</div><div>extensions => odbc,telelephony,extensions</div><div>queues => odbc,telephony,queue</div><div>queue_members => odbc,telephony,queue_member</div><div>followme => odbc,telephony,followme</div><div>followme_numbers => odbc,telephony,followme_numbers</div></div><div><br></div><div><br></div><div>Don't forget to create the appropriate tables and load res_odbc.so</div><div>Also your shows that asterisk can't resolve the name "<a href="http://sipauth.deltathree.com">sipauth.deltathree.com</a>" thus unable to register to it. Make sure that your server is connected to internet and configured with a DNS server.</div><div><br></div><div><br></div><div><br></div><div>Have a good week-end.</div><div><br></div><div><br></div><div>Adolphe Cher-Aime</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Sep 13, 2014 at 12:35 PM, rafa alfurqan <span dir="ltr"><<a href="mailto:rafa.alfurqan@gmail.com" target="_blank">rafa.alfurqan@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Hi,<br>
<br>
actually i just had trying Asterisk Full RealTime Database from this site<br>
<a href="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/" target="_blank">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/</a><br>
<br>
but in the end, i got failed.<br>
this is the log from CLI<br>
Connected to Asterisk 11.11.0 currently running on server-main (pid = 12017)<br>
[Sep 13 11:55:20] WARNING[12051]: chan_sip.c:3906 __sip_xmit: sip_xmit<br>
of 0x97ae2d8 (len 406) to (null) returned -1: Invalid argument<br>
[Sep 13 11:55:21] WARNING[12051]: config.c:2578 find_engine: Realtime<br>
mapping for 'sippeers' found to engine 'mysql', but the engine is not<br>
available<br>
[Sep 13 11:55:21] WARNING[12051]: config.c:2578 find_engine: Realtime<br>
mapping for 'sippeers' found to engine 'mysql', but the engine is not<br>
available<br>
[Sep 13 11:55:21] ERROR[12051]: netsock2.c:269 ast_sockaddr_resolve:<br>
getaddrinfo("<a href="http://sipauth.deltathree.com" target="_blank">sipauth.deltathree.com</a>", "(null)", ...): No address<br>
associated with hostname<br>
[Sep 13 11:55:21] WARNING[12051]: acl.c:833 resolve_first: Unable to<br>
lookup '<a href="http://sipauth.deltathree.com" target="_blank">sipauth.deltathree.com</a>'<br>
[Sep 13 11:55:21] WARNING[12051]: config.c:2578 find_engine: Realtime<br>
mapping for 'sippeers' found to engine 'mysql', but the engine is not<br>
available<br>
[Sep 13 11:55:21] WARNING[12051]: config.c:2578 find_engine: Realtime<br>
mapping for 'sippeers' found to engine 'mysql', but the engine is not<br>
available<br>
[Sep 13 11:55:21] WARNING[12051]: acl.c:962 ast_ouraddrfor: Cannot connect<br>
[Sep 13 11:55:21] WARNING[12051]: chan_sip.c:3906 __sip_xmit: sip_xmit<br>
of 0x97ae2d8 (len 406) to (null) returned -1: Invalid argument<br>
[Sep 13 11:55:21] NOTICE[12051]: chan_sip.c:15218 sip_reg_timeout:<br>
-- Registration for '<a href="mailto:12121111111@sipauth.deltathree.com">12121111111@sipauth.deltathree.com</a>' timed out,<br>
trying again (Attempt #596)<br>
[Sep 13 11:55:21] WARNING[12051]: chan_sip.c:3906 __sip_xmit: sip_xmit<br>
of 0x97ae2d8 (len 406) to (null) returned -1: Invalid argument<br>
[Sep 13 11:55:22] WARNING[12051]: chan_sip.c:3906 __sip_xmit: sip_xmit<br>
of 0x97ae2d8 (len 406) to (null) returned -1: Invalid argument<br>
<br>
<br>
actually, i use asterisk 11.11.0 and ubuntu 10.04<br>
<br>
what should i do to solve that?<br>
thank you<br>
<div class=""><div class="h5"><br>
<br>
<br>
On 9/13/14, <a href="mailto:acheraime@gmail.com">acheraime@gmail.com</a> <<a href="mailto:acheraime@gmail.com">acheraime@gmail.com</a>> wrote:<br>
> I would suggest you to use asterisk realtime. In this case your peers and<br>
> extensions can be configured from database.<br>
> <a href="https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration" target="_blank">https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration</a><br>
><br>
><br>
><br>
><br>
> Sent from my iPhone<br>
><br>
>> On Sep 13, 2014, at 9:44 AM, rafa alfurqan <<a href="mailto:rafa.alfurqan@gmail.com">rafa.alfurqan@gmail.com</a>><br>
>> wrote:<br>
>><br>
>> hi,<br>
>><br>
>> i want to sip.conf and extension.conf files could to import to the my<br>
>> database phpmyadmin, so the data that i had input to those file could be<br>
>> read into database?<br>
>><br>
>> any help will be appreciated.<br>
>><br>
>> thank you<br>
>> --<br>
>> _____________________________________________________________________<br>
>> -- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
>> New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
>> <a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
>><br>
>> asterisk-users mailing list<br>
>> To UNSUBSCRIBE or update options visit:<br>
>> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
><br>
> --<br>
> _____________________________________________________________________<br>
> -- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
> New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
> <a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
><br>
> asterisk-users mailing list<br>
> To UNSUBSCRIBE or update options visit:<br>
> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
><br>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div><b><br></b></div></div></div>