[Kamailio-Devel] purple db scheme

[Eric PTAK]

Hi list,

I'm fixing the issue linked by henning at the bottom of this mail.
But I was in trouble while testing because my table isn't created when using
kamdbctl even if I added purple to EXTRA_TABLES variable.
In fact, it appears there is a trouble with the EXTRA_* variables usage :
In kamdbctl.dbtext, the loop uses EXTRA_TABLES whereas kamdbctl.mysql uses
EXTRA_MODULE to create extra tables.
Moreover, both scripts use EXTRA_MODULE to show the tables when asking the
user to install thoses tables.

So, two points :
* which variable to use in order to declare purple table ?
* may a issue can be opened in order to fix inconsistency


Eric.

2009/2/20 Eric PTAK <eric.ptak.fr at gmail.com>

> Hi henning,
> I quickly checked schemas exemples, it looks quite simple.
> I'll do it for purple on next monday.
>
> Eric.
>
> 2009/2/19 Henning Westerholt <henning.westerholt at 1und1.de>
>
> Hi Eric,
>>
>> perhaps you've a minute.. One thing that is missing for the proper
>> integration
>> of the purple module is a XML table definition. This is used to generate
>> the
>> SQL and other database definitions for each of the databases we support.
>>
>> I've opened a bug report some time ago for this.
>>
>> https://sourceforge.net/tracker/index.php?func=detail&aid=2581015&group_id=139143&atid=743020
>>
>> You find the xml sources in db/schema, the format is not that difficult to
>> understand, just template it from some other module. You can generate the
>> db
>> schemes with "make dbschema" in the trunk directory, you need xsltproc
>> installed. The DB schemes then can be found in scripts/mysql, for example.
>>
>> Would be cool if you could take a look at this. If you've any difficulties
>> with the stuff, just let me know.
>>
>> Thanks,
>>
>> Henning
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/devel/attachments/20090224/23fd10c9/attachment-0001.htm