Re: [Serusers] Serusers Digest, Vol 70, Issue 4 - sr-users

16 Feb 2009

      help
在2009-02-06，serusers-request@lists.iptel.org 写道：
...
Send Serusers mailing list submissions to
   serusers@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@lists.iptel.org
You can reach the person managing the list at
   serusers-owner@lists.iptel.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Serusers digest..."
Today's Topics:

Re: configure SER and SEMS to work together (Stefan Sayer)
preload_udomain error (caio)
Re: preload_udomain error (solved) (caio)
Re: Error loading "trusted" table (permissions.so) (caio)

Message: 1
Date: Thu, 05 Feb 2009 13:25:00 +0100
From: Stefan Sayer stefan.sayer@iptego.com
Subject: Re: [Serusers] configure SER and SEMS to work together
To: Martin Lane martin.l.lane@gmail.com
Cc: sems@iptel.org, Serusers@lists.iptel.org
Message-ID: 498ADA9C.4050302@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@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
-- 
Stefan Sayer
VoIP Services
stefan.sayer@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@gmail.com
Subject: [Serusers] preload_udomain error
To: serusers@lists.iptel.org
Message-ID: 498AF540.4030102@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@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@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@10.10.60.115:5060
     received: NULL
      expires: 2009-02-05 11:46:16
            q: -1.00
       callid: 1f46c06d5e034425286f095b11cf4a1a@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@gmail.com
Subject: Re: [Serusers] preload_udomain error (solved)
To: serusers@lists.iptel.org
Message-ID: 498B3A45.5070501@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@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@gmail.com
Subject: Re: [Serusers] Error loading "trusted" table (permissions.so)
To: serusers@lists.iptel.org
Message-ID: 498B3B6B.20606@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 

&&
               (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@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
End of Serusers Digest, Vol 70, Issue 4