Hi Daniel.<br>
<br>
First, I have to apologize because I made you lost some time about this issue.<br>
<br>
Following a recommendation of Jeffrey because something we detected
trying to diagnose the problem of snmpstat module, I recompiled and
instaled from scratch the whole componentes of my instalation: MySQL,
Libradiusclient and snmp; later Openser. <br>
At my previous test, I recompiled individual modules, or I used &quot;non
clean&quot; source directories, and, in the same way that happened with
snmpstats, I think that the error which was causing the segmentation
fault could be produced by an inconsistent linking on the compilation
process.<br>
<br>
At this time, I can confirm that Openser is working perfectly compiled
on Solaris SPARC hardware, on 64 bits, and using the recommended
optimizations for the package GCC for Sparc Systems.<br>
<br>
There were just a couple of things I had to have present at compilation time:<br>
<br>
1. I included within my Solaris installation the Freeware packages,
which include libxml. So, for the compilation, I had to include in
CFLAGS the directory of includes (/usr/sfw/include) and in LDFLAGS the
libraries directory (/usr/sfw/lib/sparcv). Would it be possible to
include within makefiles this path as a possible header/libraries
search path, on Solaris Platforms?<br>
<br>
2. I commented out the -Wcast-align option, avoiding a bunch of warnings about cast alignment.<br>
<br>
If you consider it worth, I can publish some lines about these
optimizations. For the results of my performance tests, I found an
improvement of Openser behaviour when compiled using this optimized
version of GCC.<br>
<br>
Again, I apologize for my mistake.<br>
<br>
Thank you Daniel, and thanks to Jeffrey by his guidance.<br>
<br>
Kind regards.<br>
<br>
Sergio Gutiérrez.<br>
<br>
<br><br><div><span class="gmail_quote">On 3/30/07, <b class="gmail_sendername">Daniel-Constantin Mierla</b> &lt;<a href="mailto:daniel@voice-system.ro">daniel@voice-system.ro</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello Sergio,<br><br>very strange that the column type gets DB_INT. Could you apply attached<br>patch (just prints the type of mysql field), compile and install<br>openser, run in debug=7 and send to me the log.<br><br>I would need the version of mysql client library you have installed to
<br>match the value printed in log.<br><br>Thanks,<br>Daniel<br><br>On 03/30/07 19:59, Sergio Gutierrez wrote:<br>&gt; Hi Daniel.<br>&gt;<br>&gt; There it goes:<br>&gt;<br>&gt; mysql&gt; desc location;<br>&gt; +---------------+------------------+------+-----+---------------------+----------------+
<br>&gt;
| Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| Null | Key | Default<br>&gt; | Extra&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt; +---------------+------------------+------+-----+---------------------+----------------+<br>&gt;
|
id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|
int(10) unsigned | NO&nbsp;&nbsp; | PRI | NULL<br>&gt; | auto_increment |<br>&gt; | username&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| varchar(64)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| NO&nbsp;&nbsp; | MUL |<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt;
| domain&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|
varchar(128)&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp;
|&nbsp;&nbsp;&nbsp;&nbsp; |<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt;
| contact&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
varchar(255)&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp;
|&nbsp;&nbsp;&nbsp;&nbsp; |<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt;
| received&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|
varchar(255)&nbsp;&nbsp;&nbsp;&nbsp; |
YES&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp; | NULL<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt;
| path&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|
varchar(255)&nbsp;&nbsp;&nbsp;&nbsp; |
YES&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp; | NULL<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt;
| expires&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
datetime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
NO&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | 2020-05-28 21:32:15<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt;
|
q&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| float(10,2)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| NO&nbsp;&nbsp;
|&nbsp;&nbsp;&nbsp;&nbsp; | 1.00<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt;
| callid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|
varchar(255)&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp;
|&nbsp;&nbsp;&nbsp;&nbsp; | Default-Call-ID<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt;
| cseq&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|
int(11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|
NO&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | 13<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt;
| last_modified |
datetime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
NO&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | 1900-01-01 00:00:00<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt;
| flags&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
int(11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|
NO&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | 0<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt;
| cflags&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|
int(11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|
NO&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | 0<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt; | user_agent&nbsp;&nbsp;&nbsp;&nbsp;| varchar(255)&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; |<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt;
| socket&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|
varchar(128)&nbsp;&nbsp;&nbsp;&nbsp; |
YES&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp; | NULL<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt;
| methods&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
int(11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|
YES&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp; | NULL<br>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br>&gt; +---------------+------------------+------+-----+---------------------+----------------+<br>&gt;<br>&gt;<br>&gt; | location | CREATE TABLE `location` (<br>&gt;&nbsp;&nbsp; `id` int(10) unsigned NOT NULL auto_increment,
<br>&gt;&nbsp;&nbsp; `username` varchar(64) NOT NULL default &#39;&#39;,<br>&gt;&nbsp;&nbsp; `domain` varchar(128) NOT NULL default &#39;&#39;,<br>&gt;&nbsp;&nbsp; `contact` varchar(255) NOT NULL default &#39;&#39;,<br>&gt;&nbsp;&nbsp; `received` varchar(255) default NULL,
<br>&gt;&nbsp;&nbsp; `path` varchar(255) default NULL,<br>&gt;&nbsp;&nbsp; `expires` datetime NOT NULL default &#39;2020-05-28 21:32:15&#39;,<br>&gt;&nbsp;&nbsp; `q` float(10,2) NOT NULL default &#39;1.00&#39;,<br>&gt;&nbsp;&nbsp; `callid` varchar(255) NOT NULL default &#39;Default-Call-ID&#39;,
<br>&gt;&nbsp;&nbsp; `cseq` int(11) NOT NULL default &#39;13&#39;,<br>&gt;&nbsp;&nbsp; `last_modified` datetime NOT NULL default &#39;1900-01-01 00:00:00&#39;,<br>&gt;&nbsp;&nbsp; `flags` int(11) NOT NULL default &#39;0&#39;,<br>&gt;&nbsp;&nbsp; `cflags` int(11) NOT NULL default &#39;0&#39;,
<br>&gt;&nbsp;&nbsp; `user_agent` varchar(255) NOT NULL default &#39;&#39;,<br>&gt;&nbsp;&nbsp; `socket` varchar(128) default NULL,<br>&gt;&nbsp;&nbsp; `methods` int(11) default NULL,<br>&gt;&nbsp;&nbsp; PRIMARY KEY&nbsp;&nbsp;(`id`),<br>&gt;&nbsp;&nbsp; KEY `udc_loc` (`username`,`domain`,`contact`)
<br>&gt; ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 |<br>&gt;<br>&gt;<br>&gt; mysql&gt; select * from location;<br>&gt; +----+----------+--------+---------------------------------+----------+------+---------------------+-------+-------------------------------------------+------+---------------------+-------+--------+--------------------------------------------+--------------------------+---------+
<br>&gt;<br>&gt;
| id | username | domain |
contact&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| received<br>&gt; | path | expires&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | q&nbsp;&nbsp;&nbsp;&nbsp; |<br>&gt;
callid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|
cseq | last_modified<br>&gt; | flags | cflags |
user_agent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
|<br>&gt;
socket&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| methods |<br>&gt; +----+----------+--------+---------------------------------+----------+------+---------------------+-------+-------------------------------------------+------+---------------------+-------+--------+--------------------------------------------+--------------------------+---------+
<br>&gt;<br>&gt; | 13 | 3950031&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| sip:3950031@192.168.198.10:5060 | NULL<br>&gt; | NULL | 2007-03-27 00:46:08 | -1.00 |<br>&gt; <a href="mailto:5e897d38-ce5af712-6f3a7b51@192.168.198.10">5e897d38-ce5af712-6f3a7b51@192.168.198.10
</a><br>&gt; &lt;mailto:<a href="mailto:5e897d38-ce5af712-6f3a7b51@192.168.198.10">5e897d38-ce5af712-6f3a7b51@192.168.198.10</a>&gt; |&nbsp;&nbsp; 75 | 2007-03-27<br>&gt; 00:45:08 |&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0 | PolycomSoundPointIP-SPIP_300-UA/1.6.5.0043
<br>&gt; | udp:<a href="http://192.168.199.200:5060">192.168.199.200:5060</a> &lt;<a href="http://192.168.199.200:5060">http://192.168.199.200:5060</a>&gt; |&nbsp;&nbsp;&nbsp;&nbsp;8063 |<br>&gt; +----+----------+--------+---------------------------------+----------+------+---------------------+-------+-------------------------------------------+------+---------------------+-------+--------+--------------------------------------------+--------------------------+---------+
<br>&gt;<br>&gt;<br>&gt; The last information is the record I have stored.<br>&gt;<br>&gt;<br>&gt; Kind regards.<br>&gt;<br><br></blockquote></div><br>