28 Apr
2011
28 Apr
'11
9:07 p.m.
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
28 Apr
28 Apr
9:07 p.m.
New subject: Out-of-office-reply: uri_db table version
I will be on leave from Friday the 29th to Monday the 2nd of May (inclusive).
I will be returning to work on Tuesday the 3rd.
All urgent SIP queries should be directed to Paul McKernon on Friday. The office shall be
closed on Monday.
11:56 p.m.
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
http://www.asipto.com
11:57 p.m.
New subject: Out-of-office-reply: Re: uri_db table version
I will be on leave from Friday the 29th to Monday the 2nd of May (inclusive).
I will be returning to work on Tuesday the 3rd.
All urgent SIP queries should be directed to Paul McKernon on Friday. The office shall be
closed on Monday.
29 Apr
29 Apr
9:40 p.m.
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
http://www.asipto.com
9:40 p.m.
New subject: Out-of-office-reply: Re: uri_db table version
I will be on leave from Friday the 29th to Monday the 2nd of May (inclusive).
I will be returning to work on Tuesday the 3rd.
All urgent SIP queries should be directed to Paul McKernon on Friday. The office shall be
closed on Monday.
4753
days inactive
4754
days old
5 comments
3 participants
participants (3)
-
Claudio Furrer -
Daniel-Constantin Mierla -
Stephen.McVarnock＠aepona.com