[SR-Users] uri_db table version
Claudio Furrer
elcaio at gmail.com
Fri Apr 29 21:40:38 CEST 2011
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
>
>
More information about the sr-users
mailing list