[asterisk-users] how to store sip.conf and extension.conf into phpmyadmin
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
Re: [asterisk-users] how to store sip.conf and extension.conf into phpmyadmin
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
Re: [asterisk-users] how to store sip.conf and extension.conf into phpmyadmin
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 '1212...@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
Re: [asterisk-users] how to store sip.conf and extension.conf into phpmyadmin
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 '1212...@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 --
Re: [asterisk-users] how to store sip.conf and extension.conf into phpmyadmin
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.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 '1212...@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
