Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread harry gaillac
PROTECTED] Sent: Monday, October 11, 2004 6:42 PM Subject: Re: [Asterisk-Users] SIP peers in MySQL Database I read the perl script. here is table structure for table `sipfriends` CREATE TABLE `sipfriends` ( `name` varchar(40) NOT NULL default '', `secret

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread harry gaillac
: harry gaillac [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion [EMAIL PROTECTED] Sent: Monday, October 11, 2004 6:42 PM Subject: Re: [Asterisk-Users] SIP peers in MySQL Database I read the perl script. here is table structure for table

RE: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread Bill Seddon
] On Behalf Of harry gaillac Sent: October 13, 2004 10:56 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] SIP peers in MySQL Database I don't try the perl script. here is what I expect from asterisk and sql database for example. one asterisk pbx per office

RE: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread harry gaillac
: October 13, 2004 10:56 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] SIP peers in MySQL Database I don't try the perl script. here is what I expect from asterisk and sql database for example. one asterisk pbx per office, several offices,one

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread Matthew Boehm
[EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion [EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 5:00 AM Subject: Re: [Asterisk-Users] SIP peers in MySQL Database Ok in order to add a conf file in sip.conf we need to load app_realtime harry --- Brian Wilkins

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread harry gaillac
] To: Asterisk Users Mailing List - Non-Commercial Discussion [EMAIL PROTECTED] Sent: Monday, October 11, 2004 6:42 PM Subject: Re: [Asterisk-Users] SIP peers in MySQL Database I read the perl script. here is table structure for table `sipfriends

RE: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread Brian West
include = sip_additional.conf in [general] Ok Just for the sake of some poor soul 4 months from now that keeps trying to do an include and reads this info thinking its correct. The proper way is: #include somefile.conf Or #include /full/path/to/a/file.conf No = and you MUST have a # in

RE: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread harry gaillac
ok but if i add or remove variables from database. Does the perl script overwrite the conf file ? for example i remove a phone so i run the perl script on pbx in order to update config file.Is it a problem for real time calls ? harry --- Brian West [EMAIL PROTECTED] a écrit : include =

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread Brian Wilkins
The perl script will overwrite the existing conf file. I've had bad experiences with constant reloading. Maybe you want to schedule your updates through a crontab. On Wednesday 13 October 2004 03:28 pm, harry gaillac wrote: ok but if i add or remove variables from database. Does the perl

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread harry gaillac
ok do you know app_realtime ?? --- Brian Wilkins [EMAIL PROTECTED] a écrit : The perl script will overwrite the existing conf file. I've had bad experiences with constant reloading. Maybe you want to schedule your updates through a crontab. On Wednesday 13 October 2004 03:28 pm, harry

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread Matthew Boehm
in * to get it to re-parse the sip.conf file. Matthew - Original Message - From: harry gaillac [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion [EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 10:28 AM Subject: RE: [Asterisk-Users] SIP peers in MySQL Database ok

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread Matthew Boehm
Subject: Re: [Asterisk-Users] SIP peers in MySQL Database ok i agree you but what's app_realtime how does it work? harry --- Matthew Boehm [EMAIL PROTECTED] a écrit : No you don't. You had it right in that last email. 1 db server, multiple * boxes. Make 1 sip table on the db server

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread harry gaillac
-Commercial Discussion [EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 10:28 AM Subject: RE: [Asterisk-Users] SIP peers in MySQL Database ok but if i add or remove variables from database. Does the perl script overwrite the conf file ? for example i remove a phone so i run the perl

RE: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread Brian West
The perl script will overwrite the existing conf file. I've had bad experiences with constant reloading. Maybe you want to schedule your updates through a crontab. Problem? We do HUNDREDS of reloads a day without problem. Just an FYI bkw ___

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread Brian Wilkins
I've had bad experiences with reloads of thousands of extensions several times throughout the day. I've spoken with others at AstriCon about the same issue, fyi On Wednesday 13 October 2004 04:35 pm, Brian West wrote: The perl script will overwrite the existing conf file. I've had bad

RE: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread Brian West
? Because it can save your ass! bkw -Original Message- From: [EMAIL PROTECTED] [mailto:asterisk-users- [EMAIL PROTECTED] On Behalf Of Brian Wilkins Sent: Wednesday, October 13, 2004 7:51 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] SIP peers

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-13 Thread Brian Wilkins
] On Behalf Of Brian Wilkins Sent: Wednesday, October 13, 2004 7:51 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] SIP peers in MySQL Database I've had bad experiences with reloads of thousands of extensions several times throughout the day. I've

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-12 Thread Matthew Boehm
- Non-Commercial Discussion [EMAIL PROTECTED] Sent: Monday, October 11, 2004 12:00 PM Subject: Re: [Asterisk-Users] SIP peers in MySQL Database I agree you users from asterisk list don't have to give me FREE SUPPORT the day after I posted a question . I was thinking many

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-12 Thread harry gaillac
a #include line for this new file. Matthew - Original Message - From: harry gaillac [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion [EMAIL PROTECTED] Sent: Monday, October 11, 2004 6:42 PM Subject: Re: [Asterisk-Users] SIP peers in MySQL Database

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-12 Thread Brian Wilkins
for this new file. Matthew - Original Message - From: harry gaillac [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion [EMAIL PROTECTED] Sent: Monday, October 11, 2004 6:42 PM Subject: Re: [Asterisk-Users] SIP peers in MySQL Database I read the perl

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-12 Thread Matthew Boehm
List - Non-Commercial Discussion [EMAIL PROTECTED] Sent: Monday, October 11, 2004 6:42 PM Subject: Re: [Asterisk-Users] SIP peers in MySQL Database I read the perl script. here is table structure for table `sipfriends` CREATE TABLE `sipfriends` ( `name` varchar(40

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-11 Thread Matthew Boehm
You have obviously never posted to any kind of mailing list before. Sometimes you may have to wait a few days for someone to answer you. Sometimes people just don't know. Griping to the owners of the list about the people who take time out of their day to give you FREE support isn't going to make

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-11 Thread harry gaillac
I agree you users from asterisk list don't have to give me FREE SUPPORT the day after I posted a question . I was thinking many users are used to register sip clients in sql database not one sip.conf per Asterisk pbx box . harry --- Matthew Boehm [EMAIL PROTECTED] a écrit : You have

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-11 Thread Matthew Boehm
- From: harry gaillac [EMAIL PROTECTED] To: Asterisk Users Mailing List - Non-Commercial Discussion [EMAIL PROTECTED] Sent: Monday, October 11, 2004 12:00 PM Subject: Re: [Asterisk-Users] SIP peers in MySQL Database I agree you users from asterisk list don't have to give me FREE SUPPORT

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-11 Thread Michael Baird
Matthew, will the new method for dynamic storage of sip peers be based on res_config? Or will it be some new method, is there anything I can look at to start researching it yet? Regards Michael Baird You have obviously never posted to any kind of mailing list before. Sometimes you may have to

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-11 Thread Matthew Boehm
Discussion [EMAIL PROTECTED] Sent: Monday, October 11, 2004 3:54 PM Subject: Re: [Asterisk-Users] SIP peers in MySQL Database Matthew, will the new method for dynamic storage of sip peers be based on res_config? Or will it be some new method, is there anything I can look at to start researching

Re: [Asterisk-Users] SIP peers in MySQL Database

2004-10-11 Thread harry gaillac
] Sent: Monday, October 11, 2004 12:00 PM Subject: Re: [Asterisk-Users] SIP peers in MySQL Database I agree you users from asterisk list don't have to give me FREE SUPPORT the day after I posted a question . I was thinking many users are used to register sip clients in sql database