[Users] Openser fails when compiled on Solaris 64bit

Daniel-Constantin Mierla daniel at voice-system.ro
Fri Mar 30 19:29:00 CEST 2007


Hello Sergio,

very strange that the column type gets DB_INT. Could you apply attached 
patch (just prints the type of mysql field), compile and install 
openser, run in debug=7 and send to me the log.

I would need the version of mysql client library you have installed to 
match the value printed in log.

Thanks,
Daniel

On 03/30/07 19:59, Sergio Gutierrez wrote:
> 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 
> <mailto: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 <http://192.168.199.200:5060> |    8063 |
> +----+----------+--------+---------------------------------+----------+------+---------------------+-------+-------------------------------------------+------+---------------------+-------+--------+--------------------------------------------+--------------------------+---------+ 
>
>
> The last information is the record I have stored.
>
>
> Kind regards.
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mysql-coltype.patch
Type: text/x-diff
Size: 453 bytes
Desc: not available
Url : http://lists.kamailio.org/pipermail/users/attachments/20070330/dc4870d1/attachment.patch 


More information about the Users mailing list