Mysql "asterisk" database
Posted: Fri Aug 17, 2007 4:08 pm
I intend to use softphones only, so why the need for "phone_ip" and "computer_ip" in the "phones" table?
------------------------------------------------------------
insert into phones (extension, dialplan_number, voicemail_id, phone_ip, computer_ip, server_ip, login, pass, status, active, phone_type, fullname, company, picture, messages, old_messages, protocol) values('gs102','102','102','10.10.10.16','10.10.9.16','10.10.10.15','gs102','test', 'ADMIN','Y','Grandstream BT 102','Test Admin Phone','TEST','','0','0','SIP');
-------------------------------------------------------------
A major advantage of SIP and AIX(2) is flexibility. Once my IAX2 trunks have been registered, and my extensions defined, I want to be able to log into the dialer from my IAX softphone from any box on my LAN using the web-only app. That way I can place my call centre agents in any available lab with PCs and and internet connections, without having to tie them to predetermined, static IPs. My IT department would certainly be more comfortable with the dialer calling out to the client via SIP/IAX.
Since I've already idenitified my extensions by IAX ID, can I simply put the empty string ('') as the value for this two keys? Wishful thinking, I suppose, but is there another workaround?
------------------------------------------------------------
insert into phones (extension, dialplan_number, voicemail_id, phone_ip, computer_ip, server_ip, login, pass, status, active, phone_type, fullname, company, picture, messages, old_messages, protocol) values('gs102','102','102','10.10.10.16','10.10.9.16','10.10.10.15','gs102','test', 'ADMIN','Y','Grandstream BT 102','Test Admin Phone','TEST','','0','0','SIP');
-------------------------------------------------------------
A major advantage of SIP and AIX(2) is flexibility. Once my IAX2 trunks have been registered, and my extensions defined, I want to be able to log into the dialer from my IAX softphone from any box on my LAN using the web-only app. That way I can place my call centre agents in any available lab with PCs and and internet connections, without having to tie them to predetermined, static IPs. My IT department would certainly be more comfortable with the dialer calling out to the client via SIP/IAX.
Since I've already idenitified my extensions by IAX ID, can I simply put the empty string ('') as the value for this two keys? Wishful thinking, I suppose, but is there another workaround?