[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