ok thats done as u said. i am getting
No sip accounts defined in sip
error now.
??
----- Original Message -----
From: "Sean Cheesman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 07, 2004 10:27 AM
Subject: RE: [Asterisk-Users] no results.
> the database schema is the table and it's associated columns. did you use
the create table script in the header of the pl file? basically, for each
of your sip entries, they would be broken down per line. so if your
sip.conf entry looks like this:
>
> [1234]
> type=friend
> username=1234
> secret=blah
> nat=yes
> host=dynamic
> canreinvite=no
> qualify=200
> defaultip=192.168.0.4
>
> your entries in the mysql database would be like this:
> INSERT INTO `sip` (`id`, `keyword`, `data`, `flags`) VALUES ('1234',
'type', 'friend', '0');
> INSERT INTO `sip` (`id`, `keyword`, `data`, `flags`) VALUES ('1234',
'username', '1234', '0');
> INSERT INTO `sip` (`id`, `keyword`, `data`, `flags`) VALUES ('1234',
'secret', 'blah', '0');
> and so on..... the 'flags' column allows you to "disable" an entry
without deleting the entry completely. Hope this helps!
>
> Sean
>
>
> -----Original Message-----
> From: Chandra [mailto:[EMAIL PROTECTED]
> Sent: Tue 1/6/2004 11:31 PM
> To: [EMAIL PROTECTED]
> Cc:
> Subject: Re: [Asterisk-Users] no results.
>
>
>
> there are 4 fields, id, keyword,data, flags..
>
> i really don't know what to put in keyword and data... but i have
something
> like 4 datas in my sip table
>
> 1234,account,sip1,0
> 1235,account,sip2,0
> 1236,user,sip3,0
> 1236,peer,sip3,0
>
> what do u mean by db schema???
>
> ----- Original Message -----
> From: "Sean Cheesman" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, January 07, 2004 9:57 AM
> Subject: RE: [Asterisk-Users] no results.
>
>
> > have you set up the db schema? and have you entered any sip data into
the
> db?
> >
> > Sean
> >
> > -----Original Message-----
> > From: Chandra [mailto:[EMAIL PROTECTED]
> > Sent: Tue 1/6/2004 10:57 PM
> > To: [EMAIL PROTECTED]
> > Cc:
> > Subject: [Asterisk-Users] no results.
> >
> >
> >
> > i have been working with the retrieve_sip_conf_from_mysql.pl file and i
> have
> > set everything as required. but when i run this script i am continuously
> > getting the "no results" in my screen and the file written by this
> script
> > has only first result although i have many in my database. this is the
> part
> > of this script.
> >
> > my @resSet = @{$result};
> > print $#resSet;
> > if ( $#resSet == -1 ) {
> > print "no results\n";
> > exit;
> > }
> >
> > can any one tell me what is happening? and get rid of this error?
> >
> > for those who have no clue.. this file is in the /usr/src/asterisk
> > directory... (asterisk source diretory.)
> >
> > thanks,
> > chandra
> >
> >
> > _______________________________________________
> > Asterisk-Users mailing list
> > [EMAIL PROTECTED]
> > http://lists.digium.com/mailman/listinfo/asterisk-users
> >
> >
> >
>
>
> _______________________________________________
> Asterisk-Users mailing list
> [EMAIL PROTECTED]
> http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
>
_______________________________________________
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
