[Serusers] Serusers Digest, Vol 70, Issue 4
郭灵犀
guolingxi at 126.com
Mon Feb 16 02:51:02 CET 2009
help
在2009-02-06，serusers-request at lists.iptel.org 写道：
>Send Serusers mailing list submissions to
> serusers at lists.iptel.org
>
>To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.iptel.org/mailman/listinfo/serusers
>or, via email, send a message with subject or body 'help' to
> serusers-request at lists.iptel.org
>
>You can reach the person managing the list at
> serusers-owner at lists.iptel.org
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of Serusers digest..."
>
>
>Today's Topics:
>
> 1. Re: configure SER and SEMS to work together (Stefan Sayer)
> 2. preload_udomain error (caio)
> 3. Re: preload_udomain error (solved) (caio)
> 4. Re: Error loading "trusted" table (permissions.so) (caio)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Thu, 05 Feb 2009 13:25:00 +0100
>From: Stefan Sayer <stefan.sayer at iptego.com>
>Subject: Re: [Serusers] configure SER and SEMS to work together
>To: Martin Lane <martin.l.lane at gmail.com>
>Cc: sems at iptel.org, Serusers at lists.iptel.org
>Message-ID: <498ADA9C.4050302 at iptego.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>Hello,
>
>
>o Martin Lane [02/04/09 20:17]:
>> I am following the 'mini-Howto on how to configure SER and SEMS to work
>> together' guide on iptel.org. So I have a separate directory for
>as it says at the top of that howto, with a more recent version of SEMS
>this is not required any more; especially if you are using 1.1.0
>version. Also note that there is the 1.1.0 release available
>(http://ftp.iptel.org/pub/sems/sems-1.1.0.tar.gz).
>
>For SEMS 1.1.0 (recommended!), you can use the default configuration,
>just configure 'application' and the server's IP address and port used
>in sems.conf. Then just send the call to the SIP IP:port, e.g. using ser
>with t_relay_to_udp("<sip_ip>","<sip_port>");
>
>for completeness, the following comments:
>
>> integrating the SER and SEMS functionality. For development purposes is
>> there a switch to change the path were SER looks for the modules? As
>no, you need to change every loadmodule line.
>
>> well control which version of SEMS is being used? I've installed Sip
>> Express Media Server (1.1.0-rc1 (i386/linux)) as well as the version
>> from the howto for testing.
>>
>> My basic problem is I currently get a version mismatch error:
>>
>> 0(9590) ERROR: module version mismatch for
>> /usr/local/lib/ser/modules/sl.so; core: ser 0.9.6-sems (i386/linux);
>> module: ser 0.9.6 (i386/linux)
>>
>
>Your specific error comes from that the module you are trying to load
>was not compiled with the same version, e.g. you have one ser installed
>into /usr/local and you have another one in a local directory.
>
>Regards
>Stefan
>
>> The appropriate modules are located in under my ser-sems test dir and I
>> have not been successful in redirecting SER to look there.
>>
>> Also, I have modified ser.cfg and sems.cfg for my system but I did not
>> find a default ser_sems.cfg. Is this file necessary and where is the
>> default location?
>>
>> Thanks for any help or advice.
>>
>> mll
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Serusers mailing list
>> Serusers at lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>
>--
>Stefan Sayer
>VoIP Services
>
>stefan.sayer at iptego.com
>www.iptego.com
>
>IPTEGO GmbH
>Am Borsigturm 40
>13507 Berlin
>Germany
>
>Amtsgericht Charlottenburg, HRB 101010
>Geschaeftsfuehrer: Alexander Hoffmann
>
>
>------------------------------
>
>Message: 2
>Date: Thu, 05 Feb 2009 12:18:40 -0200
>From: caio <elcaio at gmail.com>
>Subject: [Serusers] preload_udomain error
>To: serusers at lists.iptel.org
>Message-ID: <498AF540.4030102 at gmail.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>Hi all,
>
>Running ser0.9.7 on Solaris 10 (mysql 5.0.51 + serweb 0.9.6)
>
>Have this problem when I stop ser service, and then start it again (ser
>-E -D)..
>
> 0(0) preload_udomain: ERROR: bad callid record in table aliases
> 0(0) preload_udomain: ERROR: for username 579981, contact
>sip:579981 at mydomain.com
> 0(0) preload_udomain: ERROR: skipping...
>
>And finally it dies with:
>
> 0(0) get_connection(): Connection not found in the pool
> Fallo de segmentaci??n (core dumped)
>
>It happens with many records on aliases table and happens too with only
>one record:
>
>mysql> select * from aliases\G
>*************************** 1. row ***************************
> username: 579981
> domain: 10.10.1.1
> contact: sip:579981 at mydomain.com
> received: NULL
> expires: 2009-02-05 11:45:21
> q: 1.00
> callid:
>The-Answer-To-The-Ultimate-Question-Of-Life-Universe-And-Everything
> cseq: 42
>last_modified: 2009-02-05 11:45:46
> replicate: 0
> state: 0
> flags: 128
> user_agent: SIP Express Router FIFO
>1 row in set (0.00 sec)
>
>
>SER start normally if I delete all the records on this table. But I need
>create the aliases again, and this is not the normal behaviour..I think.
>
>Here the description of aliases table:
>
>mysql> desc aliases;
>+---------------+---------------------+------+-----+---------------------+-------+
>| Field | Type | Null | Key | Default
> | Extra |
>+---------------+---------------------+------+-----+---------------------+-------+
>| username | varchar(64) | NO | PRI |
> | |
>| domain | varchar(128) | NO | PRI |
> | |
>| contact | varchar(255) | NO | PRI |
> | |
>| received | 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 | | 42
> | |
>| last_modified | timestamp | NO | | CURRENT_TIMESTAMP
> | |
>| replicate | int(10) unsigned | NO | | 0
> | |
>| state | tinyint(1) unsigned | NO | | 0
> | |
>| flags | int(11) | NO | | 0
> | |
>| user_agent | varchar(50) | NO | |
> | |
>+---------------+---------------------+------+-----+---------------------+-------+
>13 rows in set (0.01 sec)
>
>
>Important: when "location" table keeps some records, ser doesn't start too:
>
>mysql> select * from location\G
>*************************** 1. row ***************************
> username: 579981
> domain: mydomain.com
> contact: sip:579981 at 10.10.60.115:5060
> received: NULL
> expires: 2009-02-05 11:46:16
> q: -1.00
> callid: 1f46c06d5e034425286f095b11cf4a1a at 10.10.60.115
> cseq: 6
>last_modified: 2009-02-05 11:45:46
> replicate: 0
> state: 0
> flags: 0
> user_agent: CM5K-TA2S (807100.02)
>1 row in set (0.00 sec)
>
>Here too I must to delete all the records to let SER start successfully.
>
>Does anyone knows about this issue?
>
>Regards,
>Claudio
>
>
>------------------------------
>
>Message: 3
>Date: Thu, 05 Feb 2009 17:13:09 -0200
>From: caio <elcaio at gmail.com>
>Subject: Re: [Serusers] preload_udomain error (solved)
>To: serusers at lists.iptel.org
>Message-ID: <498B3A45.5070501 at gmail.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>caio escribi?:
>> Hi all,
>>
>> Running ser0.9.7 on Solaris 10 (mysql 5.0.51 + serweb 0.9.6)
>>
>> Have this problem when I stop ser service, and then start it again (ser
>> -E -D)..
>>
>> 0(0) preload_udomain: ERROR: bad callid record in table aliases
>> 0(0) preload_udomain: ERROR: for username 579981, contact
>> sip:579981 at mydomain.com
>> 0(0) preload_udomain: ERROR: skipping...
>>
>[cut]
>
>solved.
>there was an old installation of mysql libs (in /usr/sfw/), then I
>removed it, and finally recompile mysql.so module including correct
>mysql.h (/opt/csw/).
>
>cheers,
>caio
>
>
>------------------------------
>
>Message: 4
>Date: Thu, 05 Feb 2009 17:18:03 -0200
>From: caio <elcaio at gmail.com>
>Subject: Re: [Serusers] Error loading "trusted" table (permissions.so)
>To: serusers at lists.iptel.org
>Message-ID: <498B3B6B.20606 at gmail.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>Miklos Tirpak escribi?:
>
>>> Seem that VAL_TYPE of "val + 2" isn't STRING, read it as DOUBLE
>>> (DB_DOUBLE = 1).
>>> Do not know why.
>>> And because of this the 'if' conditions never are satisfy on trusted.c
>>> (line #396):
>>>
>>> if ((ROW_N(row + i) == 3) &&
>>> (VAL_TYPE(val) == DB_STRING) && !VAL_NULL(val) &&
>>> (VAL_TYPE(val + 1) == DB_STRING) && !VAL_NULL(val
>>> + 1) &&
>>> (VAL_TYPE(val + 2) == DB_STRING) && !VAL_NULL(val
>>> + 2)) {
>>
>>
>> Thank you very much for the debug lines! I think SER simply uses the
>> field types returned by the mysql server, so there might be a problem
>> with the server or library. You can check what the field types are along
>> with their names returned by the server in modules/mysql/res.c, search
>> for the mysql_fetch_fields function.
>>
>> Miklos
>>
>
>Miklos,
>
>I've resolved this issue and a similar one ("preload_udomain error").
>There was an old installation of mysql libs (in /usr/sfw/), then I
>removed it, and finally recompile mysql.so module including correct
>mysql.h (/opt/csw/).
>
>Now fields returned are with their correct type.
>
>Thank you..
>
>Caio
>
>
>------------------------------
>
>_______________________________________________
>Serusers mailing list
>Serusers at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
>
>
>End of Serusers Digest, Vol 70, Issue 4
>***************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20090216/4e5f0348/attachment.htm>
More information about the sr-users
mailing list