[Asterisk-Users] Realtime sipbuddies table structure why?????

[Greg - Cirelle Enterprises]

At 10:32 AM 12/23/04, you wrote:
> > just poor data modeling
>
>     How so? How would you change it? Are you aware that they have written
>code into app_voicemail.c that allows you to store the actual soundfiles for
>voicemail in the database itself? You want to talk about poor database
>design...sheesh..

because it works, doesn't make it right



> > Read it, makes no difference, it's broken :)
>
>     Whats broken?


from tons of previous posts......


Dec 23 09:24:57 NOTICE[12406]: chan_sip.c:7742 handle_request:
Registration from '<sip:52221 at 192.168.70.2>' failed for '192.168.70.26'

happens with app_realtime, doesn't happen without realtime

there are previous posts identifying issues with this.


> > Also, it doesn't say why the table structure is the way it is.
>
>     It most certainly does. Seems you didn't read the REAME after all.
>
>Quoted from README.extconfig:
>
><quote>
>
>It is designed to provide a flexible, seamless integration between
>Asterisk's internal configuration structure and external SQL other other
>databases
>
>the columns in your tables should line up with the
>fields you would specify in the given entity declaration.
>
>For example, an entity that looks like:
>
>[foo]
>host=dynamic
>secret=bar
>context=default
>context=local
>
>could be stored in a table like this:
>
>+------+--------+-------+--------------+----------+-----+-----------+
>| name | host   | secret| context      | ipaddr   | port| regseconds|
>+------+--------+-------+--------------+----------+-----+-----------+
>| foo  | dynamic|  bar  | default;local| 127.0.0.1| 4569| 1096954152|
>+------+--------+-------+--------------+----------+-----+-----------+
>
></quote>
>
>Seems pretty simple and easy to use. This way if new config options are ever
>added, all you have to do to support them is to add a new column. And if all
>you are storing in most columns is 1 byte, it can't take up that much space.
>
>-Matthew


I think you are still missing the point.

for example, host, secret, context, ipaddr, port, regseconds
should not be column names, they should be data points with an
associated column to contain the related value(s)

 From what I can see, i can't add a column say musicclass = something,
or pedantic = yes like I could in the conf file and have it mean anything.

regards
greg


>----- Original Message -----
>From: "Greg - Cirelle Enterprises" <gcirino at cirelle.com>
>To: "Asterisk Users Mailing List - Non-Commercial Discussion"
><asterisk-users at lists.digium.com>
>Sent: Thursday, December 23, 2004 9:00 AM
>Subject: Re: [Asterisk-Users] Realtime sipbuddies table structure why?????
>
>
> > At 09:53 AM 12/23/04, you wrote:
> > >It was written the way it is because that is how RealTime works. =P If
>you
> > >don't like the schema design, talk to Mark so he can rewrite RealTime for
> > >you.
> > >
> > >Read up some more on how RealTime works then you will understand why all
>the
> > >tables are designed the way they are.
> > >
> > >Read docs/README.extconfig
> > >
> > >-Matthew
> >
> >
> > Read it, makes no difference, it's broken :)
> >
> > Also, it doesn't say why the table structure is the
> > way it is.  just poor data modeling.
> >
> > greg
> >
> >
> > _______________________________________________
> > Asterisk-Users mailing list
> > Asterisk-Users at lists.digium.com
> > 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
>Asterisk-Users at lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-users
>To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

Regards
Greg Cirino
___________________________________
Cirelle Enterprises Inc.
603-425-2221
www.cirelle.com Web Application Development & Design
www.cirelle.net ProSpeed High Speed Dial-up - 6 Times Faster
www.cedata.com Web, FTP, Email Hosting Services
www.mlsbot.com  NNEREN MLS IDX Services

When You Want It Done Well, Just Call Cirelle
It's not just a Rhyme... There's a Reason!