Yes you are wrong. You seem to be combining two different methods of getting
SIP info out of a database. Pick 1. I use the perl script right now so here
is how to do that:
In order to use the perl script which can support 'ALL' sip abilities, use
this table:
CREATE TABLE sip_perl (
id INT(11) DEFAULT -1 NOT NULL,
keyword VARCHAR(20) NOT NULL,
data VARCHAR(50) NOT NULL,
flags INT(1) DEFAULT 0 NOT NULL,
PRIMARY KEY (id,keyword)
);
Then, insert a new row for each sip parameter keeping the 'id' the same for
each phone:
INSERT INTO `sip_perl` (`id`, `keyword`, `DATA`, `flags`) VALUES (3038,
'account', '3038', 0);
INSERT INTO `sip_perl` (`id`, `keyword`, `DATA`, `flags`) VALUES (3038,
'callerid', '"Cytel" <2814494000>', 1);
INSERT INTO `sip_perl` (`id`, `keyword`, `DATA`, `flags`) VALUES (3038,
'nat', 'yes', 0);
INSERT INTO `sip_perl` (`id`, `keyword`, `DATA`, `flags`) VALUES (3038,
'context', 'cytel-internal', 0);
INSERT INTO `sip_perl` (`id`, `keyword`, `DATA`, `flags`) VALUES (3038,
'type', 'friend', 0);
INSERT INTO `sip_perl` (`id`, `keyword`, `DATA`, `flags`) VALUES (3038,
'mailbox', '[EMAIL PROTECTED]', 0);
INSERT INTO `sip_perl` (`id`, `keyword`, `DATA`, `flags`) VALUES (3038,
'secret', '3038joshdana', 0);
INSERT INTO `sip_perl` (`id`, `keyword`, `DATA`, `flags`) VALUES (3038,
'host', 'dynamic', 0);
Edit the perl script to match. Then run the perl script. It should
create/overwrite whatever file you set in it and produce a new .conf
Go into sip.conf and add 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
> I read the perl script.
> here is table structure for table `sipfriends`
>
> CREATE TABLE `sipfriends` (
> `name` varchar(40) NOT NULL default '',
> `secret` varchar(40) NOT NULL default '',
> `context` varchar(40) NOT NULL default '',
> `username` varchar(40) default '',
> `ipaddr` varchar(20) NOT NULL default '',
> `port` int(6) NOT NULL default '0',
> `regseconds` int(11) NOT NULL default '0',
> PRIMARY KEY (`name`)
> ) TYPE=MyISAM;
>
> I would like asterisk retrieve all sipfriends
> variables
> from database.
>
> I wish to add other variables for each sip clients
> like qualify, nat, ... in sipfriends table but sip
> code channel don't seem to be able to support others
> variables.
> may be i'm wrong ?
>
> best regards
> harry
>
> --- Matthew Boehm <[EMAIL PROTECTED]> a �crit :
> > It is possible to use 1 database for many asterisk
> > boxes. You can do this
> > with the retreive script I mentioned. By adding
> > another column to the
> > database to indicate which * server that phone
> > belongs to, you can easialy
> > change the script on a per machine basis.
> >
> > Matthew
> >
> > ----- Original Message -----
> > 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" 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 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 things better nor will it make you
> > > > popular nor will you get a
> > > > faster response (if any).
> > > >
> > > > As long as the database can be accessed by the
> > > > asterisk server, then you can
> > > > store sip info into that database. You should
> > not
> > > > need to use autocreate. If
> > > > you don't need immediate, uptodate, realtime sip
> > > > configuration, look in
> > > > <ASTERISK SOURCE ROOT>/contrib/scripts/ for
> > > > something called
> > > > retreive_sip_from_mysql.pl or something like
> > that.
> > > > That is what I use.
> > > >
> > > > Or you can be patient and the new RealTime
> > method
> > > > should be in stable form
> > > > in a week or two.
> > > >
> > > > Matthew
> > > >
> > > > ----- Original Message -----
> > > > From: "harry gaillac" <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > Cc: <[EMAIL PROTECTED]>
> > > > Sent: Monday, October 11, 2004 10:01 AM
> > > > Subject: [Asterisk-Users] SIP peers in MySQL
> > > > Database
> > > >
> > > >
> > > > > hello,
> > > > >
> > > > > I wrote to [EMAIL PROTECTED] in
> > > > order to
> > > > > someone help me without reply ?????
> > > > >
> > > > > May be you could help me
> > > > >
> > > > > Here is my problem.Two smalls offices with sip
> > > > clients
> > > > >
> > > > > + Asterisk, one offices with Asterisk and
> > mysql
> > > > > database.
> > > > > I would like to define all sip peers in mysql
> > > > database
> > > > > so Asterisk from small office could read sip
> > peers
> > > > > configuration from database office.
> > > > >
> > > > > May I use autocreatepeer in all asterisk
> > sip.conf
> > > > file
> > > > > with nat=yes in general option ?
> > > > >
> > > > > Regards
> > > > > Harry
> > > > >
> > > > > [general]
> > > > > dbname= Name of database in your Mysql server
> > > > > dbhost= Hostname of server
> > > > > dbuser= Username in MySQL
> > > > > dbpass= Password for user in MySQL
> > > > > autocreatepeer=yes
> > > > > nat=yes
> > > > > ....
> > > > > ----------- ------------------
> > > > > |Asterisk |-- |nat/firewall box |
> > > > > ----------- ------------------
> > > > > |
> > > > > |
> > > > > ------------ ------------------
> > > > > | Internet |-- |nat/firewall
> > > > box|-Asterisk
> > > > >
> > > > > ------------ ------------------
> > > > +
> > > > > |
> > SIPpeers
> > > > in
> > > > > | mysql
> > > > database
> > > > >
> > > > > ----------- ------------------
> > > > > |Asterisk |-- |nat/firewall box |
> > > > > ----------- ------------------
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Vous manquez d'espace pour stocker vos mails ?
> > > > > Yahoo! Mail vous offre GRATUITEMENT 100 Mo !
> > > > > Cr�ez votre Yahoo! Mail sur
> > > > http://fr.benefits.yahoo.com/
> > > > >
> > > > > Le nouveau Yahoo! Messenger est arriv� !
> > D�couvrez
> > > > toutes les nouveaut�s
> > > > pour dialoguer instantan�ment avec vos amis. A
> > > > t�l�charger gratuitement sur
> > > > http://fr.messenger.yahoo.com
> > > > >
> > _______________________________________________
> > > > > Asterisk-Users mailing list
> > > > > [EMAIL PROTECTED]
> > > > >
> > > >
> > >
> >
> http://lists.digium.com/mailman/listinfo/asterisk-users
> > > > > To UNSUBSCRIBE or update options visit:
> > > > >
> > > >
> > >
> >
> http://lists.digium.com/mailman/listinfo/asterisk-users
> > > >
> > > > _______________________________________________
> > > > Asterisk-Users mailing list
> > > > [EMAIL PROTECTED]
> > > >
> > >
> >
> http://lists.digium.com/mailman/listinfo/asterisk-users
> > > > To UNSUBSCRIBE or update options visit:
> > > >
> > > >
> > >
> >
> http://lists.digium.com/mailman/listinfo/asterisk-users
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Vous manquez d'espace pour stocker vos mails ?
> > > Yahoo! Mail vous offre GRATUITEMENT 100 Mo !
> > > Cr�ez votre Yahoo! Mail sur
> > http://fr.benefits.yahoo.com/
> > >
> > > Le nouveau Yahoo! Messenger est arriv� ! D�couvrez
> > toutes les nouveaut�s
> > pour dialoguer instantan�ment avec vos amis. A
> > t�l�charger gratuitement sur
> > http://fr.messenger.yahoo.com
> > > _______________________________________________
> > > Asterisk-Users mailing list
> > > [EMAIL PROTECTED]
> > >
> >
> http://lists.digium.com/mailman/listinfo/asterisk-users
> > > To UNSUBSCRIBE or update options visit:
> > >
> >
> http://lists.digium.com/mailman/listinfo/asterisk-users
> >
> > _______________________________________________
> > Asterisk-Users mailing list
> >
> === message truncated ===
>
>
>
>
>
>
> Vous manquez d'espace pour stocker vos mails ?
> Yahoo! Mail vous offre GRATUITEMENT 100 Mo !
> Cr�ez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/
>
> Le nouveau Yahoo! Messenger est arriv� ! D�couvrez toutes les nouveaut�s
pour dialoguer instantan�ment avec vos amis. A t�l�charger gratuitement sur
http://fr.messenger.yahoo.com
> _______________________________________________
> Asterisk-Users mailing list
> [EMAIL PROTECTED]
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
