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:[EMAIL PROTECTED]:5060 | NULL
| NULL | 2007-03-27 00:46:08 | -1.00 |
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> | 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.
Index: modules/mysql/res.c
===================================================================
--- modules/mysql/res.c (revision 1925)
+++ modules/mysql/res.c (working copy)
@@ -69,6 +69,7 @@
fields = mysql_fetch_fields(CON_RESULT(_h));
for(i = 0; i < n; i++) {
RES_NAMES(_r)[i] = fields[i].name;
+ LOG(L_ERR, "get_columns: col[%d] type [%d]\n", i, fields[i].type);
switch(fields[i].type) {
case FIELD_TYPE_TINY:
case FIELD_TYPE_SHORT:
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
