<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1276" name=GENERATOR></HEAD>
<BODY dir=ltr>
<DIV><SPAN class=953180905-07012004><FONT face=Arial color=#0000ff
size=2>oops! I forgot on important one! you have to have at the
minimum this entry:</FONT></SPAN></DIV>
<DIV><SPAN class=953180905-07012004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953180905-07012004>
<DIV><FONT face=Arial color=#0000ff size=2>INSERT INTO `sip` (`id`, `keyword`,
`data`, `flags`) VALUES ('1234', <SPAN
class=953180905-07012004>account</SPAN>', '<SPAN
class=953180905-07012004>1234</SPAN>', '0'); </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=953180905-07012004><FONT face=Arial color=#0000ff size=2>you'll
notice that the 'id' column is an integer. so you have to keep it
numeric. some people like to have their sip extensions be alphanumeric, so
in order to accommodate that there is the id field. this is independent of
anything in your normal sip.conf file. but all entries for each sip.conf
entry must have the same 'id' set. so account is actually the name of the
sip entry. I hope I didn't just make that very
unclear!</FONT></SPAN></DIV>
<DIV><SPAN class=953180905-07012004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953180905-07012004><FONT face=Arial color=#0000ff
size=2>Sean</FONT></SPAN></DIV></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Sean Cheesman
[mailto:asterisk-users-admin@lists.digium.com] <B>On Behalf Of </B>Sean
Cheesman<BR><B>Sent:</B> Tuesday, January 06, 2004 11:43 PM<BR><B>To:</B>
asterisk-users@lists.digium.com<BR><B>Subject:</B> RE: [Asterisk-Users] no
results.<BR><BR></FONT></DIV>
<DIV>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:</DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV>[1234]<BR>type=friend<BR>username=1234<BR>secret=blah<BR>nat=yes<BR>host=dynamic<BR>canreinvite=no<BR>qualify=200<BR>defaultip=192.168.0.4</DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV>your entries in the mysql database would be like this:</DIV>
<DIV>INSERT INTO `sip` (`id`, `keyword`, `data`, `flags`) VALUES ('1234',
'type', 'friend', '0'); </DIV>
<DIV>INSERT INTO `sip` (`id`, `keyword`, `data`, `flags`) VALUES ('1234',
'username', '1234', '0');</DIV>
<DIV>INSERT INTO `sip` (`id`, `keyword`, `data`, `flags`) VALUES ('1234',
'secret', 'blah', '0'); </DIV>
<DIV>and so on..... the 'flags' column allows you to "disable" an entry
without deleting the entry completely. Hope this helps!</DIV>
<DIV> </DIV>
<DIV>Sean</DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT size=2>-----Original Message----- <BR><B>From:</B> Chandra
[mailto:chandra@digital.com.np] <BR><B>Sent:</B> Tue 1/6/2004 11:31 PM
<BR><B>To:</B> asterisk-users@lists.digium.com <BR><B>Cc:</B>
<BR><B>Subject:</B> Re: [Asterisk-Users] no results.<BR><BR></FONT></DIV>
<P><FONT size=2>there are 4 fields, id, keyword,data, flags..<BR><BR>i
really don't know what to put in keyword and data... but i have
something<BR>like 4 datas in my sip
table<BR><BR>1234,account,sip1,0<BR>1235,account,sip2,0<BR>1236,user,sip3,0<BR>1236,peer,sip3,0<BR><BR>what
do u mean by db schema???<BR><BR>----- Original Message -----<BR>From: "Sean
Cheesman" <scheesman@macarthur-group.com><BR>To:
<asterisk-users@lists.digium.com><BR>Sent: Wednesday, January 07, 2004
9:57 AM<BR>Subject: RE: [Asterisk-Users] no results.<BR><BR><BR>> have
you set up the db schema? and have you entered any sip data into
the<BR>db?<BR>><BR>> Sean<BR>><BR>> -----Original
Message-----<BR>> From: Chandra [<A
href="mailto:chandra@digital.com.np">mailto:chandra@digital.com.np</A>]<BR>>
Sent: Tue 1/6/2004 10:57 PM<BR>> To:
asterisk-users@lists.digium.com<BR>> Cc:<BR>> Subject:
[Asterisk-Users] no results.<BR>><BR>><BR>><BR>> i have been
working with the retrieve_sip_conf_from_mysql.pl file and i<BR>have<BR>>
set everything as required. but when i run this script i am
continuously<BR>> getting the "no results" in my screen and
the file written by this<BR>script<BR>> has only first result although i
have many in my database. this is the<BR>part<BR>> of this
script.<BR>><BR>> my @resSet =
@{$result};<BR>> print
$#resSet;<BR>> if (
$#resSet == -1 )
{<BR>>
print "no
results\n";<BR>>
exit;<BR>>
}<BR>><BR>> can any one tell me what is happening? and get rid of this
error?<BR>><BR>> for those who have no clue.. this file is in the
/usr/src/asterisk<BR>> directory... (asterisk source
diretory.)<BR>><BR>> thanks,<BR>> chandra<BR>><BR>><BR>>
_______________________________________________<BR>> Asterisk-Users
mailing list<BR>> Asterisk-Users@lists.digium.com<BR>> <A
href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</A><BR>><BR>><BR>><BR><BR><BR>_______________________________________________<BR>Asterisk-Users
mailing list<BR>Asterisk-Users@lists.digium.com<BR><A
href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</A><BR></FONT></P></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>