[Users] Openser fails when compiled on Solaris 64bit

[Sergio Gutierrez]

Hi Daniel.

There it goes:

mysql> desc location;
+---------------+------------------+------+-----+---------------------+----------------+
| Field         | Type             | Null | Key | Default             |
Extra          |
+---------------+------------------+------+-----+---------------------+----------------+
| id            | int(10) unsigned | NO   | PRI | NULL                |
auto_increment |
| username      | varchar(64)      | NO   | MUL |
|                |
| domain        | varchar(128)     | NO   |     |
|                |
| contact       | varchar(255)     | NO   |     |
|                |
| received      | varchar(255)     | YES  |     | NULL
|                |
| path          | varchar(255)     | YES  |     | NULL
|                |
| expires       | datetime         | NO   |     | 2020-05-28 21:32:15
|                |
| q             | float(10,2)      | NO   |     | 1.00
|                |
| callid        | varchar(255)     | NO   |     | Default-Call-ID
|                |
| cseq          | int(11)          | NO   |     | 13
|                |
| last_modified | datetime         | NO   |     | 1900-01-01 00:00:00
|                |
| flags         | int(11)          | NO   |     | 0
|                |
| cflags        | int(11)          | NO   |     | 0
|                |
| user_agent    | varchar(255)     | NO   |     |
|                |
| socket        | varchar(128)     | YES  |     | NULL
|                |
| methods       | int(11)          | YES  |     | NULL
|                |
+---------------+------------------+------+-----+---------------------+----------------+


| location | CREATE TABLE `location` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(64) NOT NULL default '',
  `domain` varchar(128) NOT NULL default '',
  `contact` varchar(255) NOT NULL default '',
  `received` varchar(255) default NULL,
  `path` varchar(255) default NULL,
  `expires` datetime NOT NULL default '2020-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 '13',
  `last_modified` datetime NOT NULL default '1900-01-01 00:00:00',
  `flags` int(11) NOT NULL default '0',
  `cflags` int(11) NOT NULL default '0',
  `user_agent` varchar(255) NOT NULL default '',
  `socket` varchar(128) default NULL,
  `methods` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `udc_loc` (`username`,`domain`,`contact`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 |


mysql> select * from location;
+----+----------+--------+---------------------------------+----------+------+---------------------+-------+-------------------------------------------+------+---------------------+-------+--------+--------------------------------------------+--------------------------+---------+
| id | username | domain | contact                         | received | path
| expires             | q     | callid                                    |
cseq | last_modified       | flags | cflags |
user_agent                                 | socket                   |
methods |
+----+----------+--------+---------------------------------+----------+------+---------------------+-------+-------------------------------------------+------+---------------------+-------+--------+--------------------------------------------+--------------------------+---------+
| 13 | 3950031  |        | sip:3950031 at 192.168.198.10:5060 | NULL     | NULL
| 2007-03-27 00:46:08 | -1.00 |
5e897d38-ce5af712-6f3a7b51 at 192.168.198.10|   75 | 2007-03-27 00:45:08
|     0 |      0 |
PolycomSoundPointIP-SPIP_300-UA/1.6.5.0043 | udp:192.168.199.200:5060 |
8063 |
+----+----------+--------+---------------------------------+----------+------+---------------------+-------+-------------------------------------------+------+---------------------+-------+--------+--------------------------------------------+--------------------------+---------+

The last information is the record I have stored.


Kind regards.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20070330/b9f9e70a/attachment.htm