VoIP Mailing List Archives

[rafa.alfurqan at gmail...]

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

[acheraime at gmail.com]

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

[rafa.alfurqan at gmail...]

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



On 9/13/14, acheraime@gmail.com <acheraime@gmail.com> wrote:

[acheraime at gmail.com]

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@gmail.com (rafa.alfurqan@gmail.com)> wrote:

[rafa.alfurqan at gmail...]

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@gmail.com> wrote: