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

Discussion:

rafa alfurqan

2014-09-13 13:44:27 UTC

a***@gmail.com

2014-09-13 16:29:53 UTC

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

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 --
http://www.asterisk.org/hello
asterisk-users mailing list
http://lists.digium.com/mailman/listinfo/asterisk-users

rafa alfurqan

2014-09-13 16:35:59 UTC

Permalink

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 '***@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

Post by a***@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

Post by rafa alfurqan
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 --
http://www.asterisk.org/hello
asterisk-users mailing list
http://lists.digium.com/mailman/listinfo/asterisk-users

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
http://www.asterisk.org/hello
asterisk-users mailing list
http://lists.digium.com/mailman/listinfo/asterisk-users

Adolphe Cher-Aime

2014-09-13 17:52:56 UTC

Permalink

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

Post by rafa alfurqan
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
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
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

Post by a***@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

Post by a***@gmail.com
Sent from my iPhone

rafa alfurqan

2014-09-14 03:10:27 UTC

Permalink

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