*Answers to your questions:*
*> what is the db_mode parameter for usrloc module?*
modparam("usrloc", "db_mode", 2) # other modules like dialog have same
mode 2
*> Have you set also time_procs param?*
modparam("usrloc", "timer_procs", 2)
Other usrloc params:
modparam("usrloc", "db_load", 1)
modparam("usrloc", "matching_mode", 0)
modparam("usrloc", "handle_lost_tcp", 0)
modparam("usrloc", "use_domain", MULTIDOMAIN)
modparam("usrloc", "nat_bflag", FLB_NATB)
modparam("usrloc", "timer_interval", 60)
modparam("usrloc", "skip_remote_socket", 0)
Thanks.
On Thu, Jan 4, 2024 at 3:38 AM Daniel-Constantin Mierla <[email protected]>
wrote:
> Hello,
>
> a bit strange as I haven't seen a similar report and 5.6.x series is out
> for quite some time.
>
> It seems to be from the timer routine, what is the db_mode parameter for
> usrloc module? Have you set also time_procs param?
>
> Cheers,
> Daniel
> On 03.01.24 21:28, Sergiu Pojoga via sr-users wrote:
>
> Hi,
>
> Facing the following error after bumping Kam from 5.3 => 5.4 => 5.5 =>
> 5.6, following instructions on each step about DB structure and module
> changes.
>
> These errors show up since. Any clue what they mean? A couple other
> modules are using the same DB MySQL connector. The data in the DB also
> seems to get updated properly.
>
> Jan 03 15:08:30 sip kamailio[20881]: ERROR: <core> [db.c:489]:
> db_use_table(): invalid connection parameter
>
>
> *Jan 03 15:08:30 sip kamailio[20881]: ERROR: usrloc [ucontact.c:1170]:
> db_update_ucontact_ruid(): sql use_table failed Jan 03 15:08:30 sip
> kamailio[20881]: ERROR: usrloc [urecord.c:438]: wb_timer(): updating
> contact in db failed (aor: [email protected] <[email protected]>) *
>
> version: kamailio 5.6.5 (x86_64/linux) 48d48f
> compiled on 02:32:48 Jan 2 2024 with gcc 4.9.2
>
> DB structure:
>
> location | CREATE TABLE `location` (
> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
> `ruid` varchar(64) NOT NULL DEFAULT '',
> `username` varchar(64) NOT NULL DEFAULT '',
> `domain` varchar(64) DEFAULT NULL,
> `contact` varchar(512) NOT NULL DEFAULT '',
> `received` varchar(128) DEFAULT NULL,
> `path` varchar(512) DEFAULT NULL,
> `expires` datetime NOT NULL DEFAULT '2030-05-28 21:32:15',
> `q` float(10,2) NOT NULL DEFAULT 1.00,
> `callid` varchar(255) NOT NULL DEFAULT 'Default-Call-ID',
> `cseq` int(11) NOT NULL DEFAULT 1,
> `last_modified` datetime NOT NULL DEFAULT '2000-01-01 00:00:01',
> `flags` int(11) NOT NULL DEFAULT 0,
> `cflags` int(11) NOT NULL DEFAULT 0,
> `user_agent` varchar(255) NOT NULL DEFAULT '',
> `socket` varchar(64) DEFAULT NULL,
> `methods` int(11) DEFAULT NULL,
> `instance` varchar(255) DEFAULT NULL,
> `reg_id` int(11) NOT NULL DEFAULT 0,
> `server_id` int(11) NOT NULL DEFAULT 0,
> `connection_id` int(11) NOT NULL DEFAULT 0,
> `keepalive` int(11) NOT NULL DEFAULT 0,
> `partition` int(11) NOT NULL DEFAULT 0,
> PRIMARY KEY (`id`),
> UNIQUE KEY `ruid_idx` (`ruid`),
> KEY `account_contact_idx` (`username`,`domain`,`contact`),
> KEY `expires_idx` (`expires`),
> KEY `connection_idx` (`server_id`,`connection_id`),
> *KEY `tcpcon_idx` (`connection_id`)*
> ) ENGINE=InnoDB AUTO_INCREMENT=287989 DEFAULT CHARSET=latin1
>
> > select * from version where table_name='location';
> table_name: location
> table_version: 9
>
> Thanks.
>
> __________________________________________________________
> Kamailio - Users Mailing List - Non Commercial Discussions
> To unsubscribe send an email to [email protected]
> Important: keep the mailing list in the recipients, do not reply only to the
> sender!
> Edit mailing list options or unsubscribe:
>
> --
> Daniel-Constantin Mierla (@ asipto.com)twitter.com/miconda --
> linkedin.com/in/miconda
> Kamailio Consultancy and Development Services
> Kamailio Advanced Training -- asipto.com
>
>
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
To unsubscribe send an email to [email protected]
Important: keep the mailing list in the recipients, do not reply only to the
sender!
Edit mailing list options or unsubscribe:
