Hi all!
Please give expanded tips about usrloc preload(). What exactly it doing?
modparam("usrloc", "db_mode", 0) modparam("usrloc", "preload", "location")
This case kamailio load from db on startup and operate in memory after?
-- WBR, Victor JID: coyote@bks.tv JID: coyote@bryansktel.ru I use FREE operation system: 3.12.9-calculate GNU/Linux
Hi all
#!define KAMDB "cluster://postcash" modparam("dialog", "db_url", KAMDB)
kamctl dialog show - print dialog list kamctl dialog showdb
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Is it bug or feature?
-- WBR, Victor JID: coyote@bks.tv JID: coyote@bryansktel.ru I use FREE operation system: 3.12.9-calculate GNU/Linux
On Monday 10 February 2014 13:01:21 Victor V. Kustov wrote:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Is it bug or feature?
Probably a feature, what is in you kamctlrc regarding database setup?
Maybe the MI interface is of use to you? http://kamailio.org/docs/modules/4.1.x/modules/dialog.html#idp3741088
On 10/02/14 13:25, Daniel Tryba wrote:
On Monday 10 February 2014 13:01:21 Victor V. Kustov wrote:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Is it bug or feature?
Probably a feature, what is in you kamctlrc regarding database setup?
Maybe the MI interface is of use to you? http://kamailio.org/docs/modules/4.1.x/modules/dialog.html#idp3741088
For futher clarification, kamctl dialog showdb is using 'mysql' tool (or other specific db client tool) to simply do a select over dialog table in the database and display the result. Kamailio is not involved in this command.
So it is a matter of configuring kamctl to connect to the database server.
Cheers, Daniel
Hi, Daniel Tryba!
Probably a feature, what is in you kamctlrc regarding database setup?
Thank Daniel, really kamctlrc setuped for mysql.
Maybe the MI interface is of use to you?
MI work as expected.
-- WBR, Victor JID: coyote@bks.tv JID: coyote@bryansktel.ru I use FREE operation system: 3.12.9-calculate GNU/Linux up 2 weeks, 3 days, 7 hours, 10 minutes
Hello,
locations records are loaded from database at startup based on detection of use for registrar functions save/lookup, whose parameters include the name of database table.
But in case you want to use an embedded language, such as Lua, the config interpreter cannot detect if any location tables have to be loaded, thus you have to give them as parameters to usrloc module.
Cheers, Daniel
On 06/02/14 14:55, Victor V. Kustov wrote:
Hi all!
Please give expanded tips about usrloc preload(). What exactly it doing?
modparam("usrloc", "db_mode", 0) modparam("usrloc", "preload", "location")
This case kamailio load from db on startup and operate in memory after?
-- WBR, Victor JID: coyote@bks.tv JID: coyote@bryansktel.ru I use FREE operation system: 3.12.9-calculate GNU/Linux
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 Tryba -
Daniel-Constantin Mierla -
Victor V. Kustov