[SR-Users] uri_db table version

[Claudio Furrer]

Humm ok, thanks Daniel.
Coming from ser to be now on sr-3 it's a little mess. Have modules from 
modules_s, some of common ones, and others from modules_k (like uri_db) make me 
to do a custom installation (ser flavour with custom db creation just for 
compatibilites, aso...)

Hope to finish soon this upgrade :(

Regards,
Claudio

On Thu, 28 Apr 2011, Daniel-Constantin Mierla wrote:

> Hello,
> 
> if you want to use kamailio modules that need database with ser flavour then
> you have to create the tables from kamailio database, which still has version
> table.
> 
> You have to use 'kamdbctl create'. The scripts to create kamailio database for
> mysql are installed when db_mysql modules is installed for kamailio flavour.
> 
> Cheers,
> Daniel
> 
> 
> On 4/28/11 9:07 PM, Claudio Furrer wrote:
> > Hello,
> > 
> > I've found that scripts/my_create.sql doesn't create the version table
> > anymore
> > (new 3.1 installation). It may be removed since many versions ago, sorry i
> > don't know.
> > 
> > Loading the modules/db_mysql and modules_k/uri_db, with a SER flavour
> > compilation (and also a ser config file), it raises:
> > 
> > 
> >   0(15262) DEBUG: db_mysql [km_my_con.c:94]: opening connection:
> > mysql://xxxx:xxxx@localhost/srtest
> >   0(15262) DEBUG: db_mysql [km_my_con.c:121]: connection type is Localhost
> > via
> > UNIX socket
> >   0(15262) DEBUG: db_mysql [km_my_con.c:122]: protocol version is 10
> >   0(15262) DEBUG: db_mysql [km_my_con.c:123]: server version is 5.1.51-log
> >   0(15262) ERROR: db_mysql [km_dbase.c:120]: driver error on query: Table
> > 'ser_new.version' doesn't exist
> >   0(15262) ERROR:<core>  [db_query.c:101]: error while submitting query
> >   0(15262) ERROR:<core>  [db.c:366]: error in db_query
> > 
> > Should I create the version table manually or using an old script?
> > 
> > Thank you.
> > Regards,
> > Claudio
> > 
> > 
> > _______________________________________________
> > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> > sr-users at lists.sip-router.org
> > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
> 
> -- 
> Daniel-Constantin Mierla
> http://www.asipto.com
> 
>