<p>Hi Daniel,</p>
<p>the location looks like:</p>
<pre><code>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`)
</code></pre>
<p>and yes there is an entry for this ruid with username "1016811e7"</p>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br>Reply to this email directly or <a href="https://github.com/kamailio/kamailio/issues/373#issuecomment-149574672">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AF36ZQI17vUDIOAJh8k9DtQVq3KwI2w-ks5o9j7HgaJpZM4GSIu7.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/kamailio/kamailio/issues/373#issuecomment-149574672"></link>
<meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>