Just to summarize, running "make clean" solved the problem.
And Sergio, no need to apologize. We've all made that same compilation mistake many times before. :-) I'm happy to help!
I'll copy the solution to the related threads. Cheers!
- Jeffrey Magder
Sergio Gutierrez wrote:
Hi Daniel.
First, I have to apologize because I made you lost some time about this issue.
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. At my previous test, I recompiled individual modules, or I used "non clean" 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.
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.
There were just a couple of things I had to have present at compilation time:
- 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?
- I commented out the -Wcast-align option, avoiding a bunch of
warnings about cast alignment.
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.
Again, I apologize for my mistake.
Thank you Daniel, and thanks to Jeffrey by his guidance.
Kind regards.
Sergio Gutiérrez.
On 3/30/07, *Daniel-Constantin Mierla* <daniel@voice-system.ro mailto:daniel@voice-system.ro> wrote:
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@192.168.198.10:5060 | NULL > | NULL | 2007-03-27 00:46:08 | -1.00 | > 5e897d38-ce5af712-6f3a7b51@192.168.198.10 <mailto:5e897d38-ce5af712-6f3a7b51@192.168.198.10> > <mailto:5e897d38-ce5af712-6f3a7b51@192.168.198.10 <mailto:5e897d38-ce5af712-6f3a7b51@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> <http://192.168.199.200:5060> | 8063 | > +----+----------+--------+---------------------------------+----------+------+---------------------+-------+-------------------------------------------+------+---------------------+-------+--------+--------------------------------------------+--------------------------+---------+ > > > The last information is the record I have stored. > > > Kind regards. >