[OpenSER-Devel] Re: [OpenSER-Users] New db_berkeley module

[Henning Westerholt]

On Friday 05 October 2007, William Quan wrote:
> Henning,
> I'll have to look into indexing the subscriber table, and get back to
> you on that.

Hello William,

do you have any update on this topic? The current autogenerated db tables for 
db_berkeley are not functional at all, the tables that your provides lacks 
some keys.

Subscriber table in mysql:

PRIMARY KEY id,
UNIQUE KEY user_id (username, domain),
KEY username_id (username)

db_berkeley generated from you:

METADATA_KEY
0 1 (username, domain)

db_berkeley generated autogenerated:

METADATA_KEY
0 1 1 (id, username, username) 

> I can provide some openserctl cmds for the db_berkeley.

Good, if you have a patch available just submit it to the tracker. Don't 
hesitate to pester me with questions, if you have some.. :-)

> Aside, there is a new release of BDB  4.6.21 available at:
> http://www.oracle.com/technology/software/products/berkeley-db/index.html
> From reading the change log, this version has the fix we need. However,
> I have yet to verify.

Great news. At the moment the debian build requires a rather old version that 
is available in stable.

Cheers,

Henning