Re: [Serusers] Serusers Digest, Vol 70, Issue 4

Send Serusers mailing list submissions to serusers(a)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(a)lists.iptel.org You can reach the person managing the list at serusers-owner(a)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 &lt;stefan.sayer(a)iptego.com&gt; Subject: Re: [Serusers] configure SER and SEMS to work together To: Martin Lane &lt;martin.l.lane(a)gmail.com&gt; Cc: sems(a)iptel.org, Serusers(a)lists.iptel.org Message-ID: &lt;498ADA9C.4050302(a)iptego.com&gt; Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hello, o Martin Lane [02/04/09 20:17]: 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: no, you need to change every loadmodule line. 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 -- Stefan Sayer VoIP Services stefan.sayer(a)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 &lt;elcaio(a)gmail.com&gt; Subject: [Serusers] preload_udomain error To: serusers(a)lists.iptel.org Message-ID: &lt;498AF540.4030102(a)gmail.com&gt; 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(a)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 &lt;elcaio(a)gmail.com&gt; Subject: Re: [Serusers] preload_udomain error (solved) To: serusers(a)lists.iptel.org Message-ID: &lt;498B3A45.5070501(a)gmail.com&gt; Content-Type: text/plain; charset=ISO-8859-1; format=flowed caio escribi?: [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 &lt;elcaio(a)gmail.com&gt; Subject: Re: [Serusers] Error loading "trusted" table (permissions.so) To: serusers(a)lists.iptel.org Message-ID: &lt;498B3B6B.20606(a)gmail.com&gt; Content-Type: text/plain; charset=ISO-8859-1; format=flowed Miklos Tirpak escribi?: 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(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers End of Serusers Digest, Vol 70, Issue 4 ***************************************