Hi Daniel,
the location looks like:
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(255) 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 '1900-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`)
and yes there is an entry for this ruid with username "1016811e7"
---
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/373#issuecomment-149574672