[Serusers] LCR on onsip.org - No DB tables created?

[Greger V. Teigre]

Dave,
The backport of LCR to 0.9.x has been included in the ONsip.org package as a 
help as many people want to use the LCR module. However, the package is a 
true 0.9.3 package and no files have been changed.  ser_mysql.h will thus 
not be changed to include LCR.  Most people up to now have known about this 
and more info hasn't seemed necessary, but I will make sure this will be 
emphasized in future README files.

BTW, Juha is not involved in ONsip.org, but he is the developer of the LCR 
module.
g-)

Dave wrote:
>> if the tables were not created, what error message
>> you got?
>
> None because I checked the database for creation of
> these tables before using LCR module. And since no
> tables were created I did not use LCR.
>
> Could you please update the ser_mysql.sh on onsip.org
> in the ser-0.9.3-gettingstarted for everyones benefit?
> Thanks,
>
>
> Dave
>
>
> --- Juha Heinanen <jh at tutpro.com> wrote:
>
>> Dave writes:
>>
>>  > I used exactly that script. But It did not create
>> any
>>  > LCR related tables.!!!
>>
>> ser cvs HEAD has in scripts/ser_mysql.sh:
>>
>> #
>> # Table structure for table 'gw'
>> #
>>
>> CREATE TABLE gw (
>>   gw_name VARCHAR(128) NOT NULL,
>>   ip_addr INT UNSIGNED NOT NULL,
>>   port SMALLINT UNSIGNED,
>>   uri_scheme TINYINT UNSIGNED,
>>   transport TINYINT UNSIGNED,
>>   grp_id INT UNSIGNED NOT NULL,
>>   PRIMARY KEY (gw_name),
>>   KEY (grp_id)
>> ) $TABLE_TYPE;
>>
>> #
>> # Table structure for table 'gw_grp'
>> #
>>
>> CREATE TABLE gw_grp (
>>   grp_id INT UNSIGNED NOT NULL AUTO_INCREMENT
>> PRIMARY KEY,
>>   grp_name VARCHAR(64) NOT NULL
>> ) $TABLE_TYPE;
>>
>> #
>> # Table structure for table 'lcr'
>> #
>>
>> CREATE TABLE lcr (
>>   prefix varchar(16) NOT NULL,
>>   from_uri varchar(128) NOT NULL DEFAULT '%',
>>   grp_id INT UNSIGNED NOT NULL,
>>   priority TINYINT UNSIGNED NOT NULL,
>>   KEY (prefix),
>>   KEY (from_uri),
>>   KEY (grp_id)
>> ) $TABLE_TYPE;
>>
>> if the tables were not created, what error message
>> you got?
>>
>> -- juha
>>
>
>
>
>
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
>
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers