View previous topic :: View next topic |
Author |
Message |
rafaelsnsa at gmail.com Guest
|
Posted: Mon Jun 30, 2014 1:47 pm Post subject: [asterisk-users] Sippeers realtime with minimum table |
|
|
Hi there
It's possible configure realtime mysql in Asterisk with a non standard sippeers table?
I need using a sippeers table from other system (non Asterisk). This table has a minimal configuration.
Thank's
Att,Rafael dos Santos Saraiva
[url=http://br.linkedin.com/pub/rafael-saraiva/52/aab/230][/url] |
|
Back to top |
|
|
jcolp at digium.com Guest
|
Posted: Wed Jul 02, 2014 8:04 am Post subject: [asterisk-users] Sippeers realtime with minimum table |
|
|
Rafael dos Santos Saraiva wrote:
Kia ora,
Quote: | It's possible configure realtime mysql in Asterisk with a non standard
sippeers table?
I need using a sippeers table from other system (non Asterisk). This
table has a minimal configuration.
|
The field names have to be what chan_sip is expecting. If they don't
match, then no go. One way to achieve this could be a view in your database.
Cheers,
--
Joshua Colp
Digium, Inc. | Senior Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: www.digium.com & www.asterisk.org
--
_____________________________________________________________________
-- 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 |
|
Back to top |
|
|
barryf-lists at flanag... Guest
|
Posted: Wed Jul 02, 2014 8:19 am Post subject: [asterisk-users] Sippeers realtime with minimum table |
|
|
On 30 June 2014 19:46, Rafael dos Santos Saraiva <rafaelsnsa@gmail.com (rafaelsnsa@gmail.com)> wrote:
Quote: | Hi there
It's possible configure realtime mysql in Asterisk with a non standard sippeers table?
I need using a sippeers table from other system (non Asterisk). This table has a minimal configuration.
|
It would be an easy matter to use a View to create the asterisk sippeers table incorporating data from your existing table and static defaults where appropriate. I have done this on quite a few occasions and it works fine. You would probably want to use a separate sipreg table for Asterisk to store the SIP registration details.
Hope this helps.
-Barry Flanagan |
|
Back to top |
|
|
rafaelsnsa at gmail.com Guest
|
Posted: Wed Jul 02, 2014 12:32 pm Post subject: [asterisk-users] Sippeers realtime with minimum table |
|
|
Hi Joshua
I've tried to create a view in a database, but Asterisk requires updatable fields in sippeers table (view), I cannot edit the structure of the tables. I chose for create a php script to read database and create the sip.conf file.
Thank's
Att,Rafael dos Santos Saraiva
[/url]
2014-07-02 10:03 GMT-03:00 Joshua Colp <jcolp@digium.com (jcolp@digium.com)>:
Quote: | Rafael dos Santos Saraiva wrote:
Kia ora,
Quote: | It's possible configure realtime mysql in Asterisk with a non standard
sippeers table?
I need using a sippeers table from other system (non Asterisk). This
table has a minimal configuration.
|
The field names have to be what chan_sip is expecting. If they don't match, then no go. One way to achieve this could be a view in your database.
Cheers,
--
Joshua Colp
Digium, Inc. | Senior Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - US
Check us out at: [url=http://www.digium.com]www.digium.com & www.asterisk.org
--
_____________________________________________________________________
-- 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
|
|
|
Back to top |
|
|
|