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