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@lists.sip-router.org > > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > > -- > Daniel-Constantin Mierla > http://www.asipto.com > > _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
