I am using kamailio 1.4.3-notls Cordialement, BERGANZ François P Pensez à l'Environnement, n'imprimez ce mail que si nécessaire. *De :* Brandon Armstead [mailto:brandon@cryy.com] *Envoyé :* mardi 15 septembre 2009 19:07 *À :* BERGANZ François *Cc :* users(a)lists.kamailio.org *Objet :* Re: [Kamailio-Users] avp_db_query to SELECT a DOUBLE colomn Hello, CAST the result as a CHAR/VARCHAR. Also what version of kamailio are you running? On Tue, Sep 15, 2009 at 6:53 AM, BERGANZ François &lt;francois(a)acropolistelecom.net <mailto:francois@acropolistelecom.net>> wrote: Hello, I need help. I try to select a DOUBLE(10,4). Kamailio report <null>. Example: avp_db_query("select CREDIT from subscriber where client='$avp(s:679)'", "$avp(i:513)"); $avp(i:513) is null! But in my database, it is 15.0000 Know you how to do ? Cordialement, BERGANZ François cid:image001.gif@01C8F7CD.6BC1D2C0 http://www.acropolistelecom.net <http://www.acropolistelecom.net/> P Pensez à l'Environnement, n'imprimez ce mail que si nécessaire. _______________________________________________ Kamailio (OpenSER) - Users mailing list Users(a)lists.kamailio.org <mailto:Users@lists.kamailio.org> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users ------------------------------------------------------------------------ _______________________________________________ Kamailio (OpenSER) - Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users

For example a PostgreSQL BIGINT is unintelligible to sqlops, I found out.

Iñaki Baz Castillo wrote: CREATE TABLE stuff (   id bigint PRIMARY KEY NOT NULL ); INSERT INTO stuff VALUES (1); ... sql_query("ca", "SELECT id FROM stuff", "ra"); $dbr(ra=>[0,0]) will be NULL.

Iñaki Baz Castillo wrote: Maybe. There was mailing list traffic about it when I first reported it around 1 April 2009. I do not think it is a bug, but rather the understandable unwillingness of the implementors to handle every database-specific data type that might come their way, like 'timestamp', 'inet', etc.

I do think 'bigint' is an important one to handle because there are some values Kamailio may need to retrieve from time to time that are simply larger than 32-bit width. But it's hard to say where the line should be drawn on special RDBM types, especially since the values that are represented by user variables, AVPs, hash table, etc. are ultimately just scalar quantities or strings.

Hello to all I have been using Kamailio for a long time, but now some of my clients aren't registering... I see the REGISTER packets coming in the server (with ngrep), but Kamailio doesn't answer. I'm not using persistent storage, so all registrations are in memory. But when Kamailio reaches 30 or more registrations... it just stops answering and looses all registered clients: [root@server ~]# kamctl ul show | grep records Domain:: location table=512 records=4 max_slot1 I have disk space, could this be lack of memory? [root@server ~]# free -m total used free shared buffers cached Mem: 748 630 118 0 148 391 -/+ buffers/cache: 90 658 Swap: 1503 0 1503 There are no errors in /var/log/kamailio How can I be sure of whats the problem? Thanks Regards Joao Pereira _______________________________________________ Kamailio (OpenSER) - Users mailing list Users(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users