[asterisk-users] sip realtime question

[Juan E. Rodríguez]

I am not sure, but I think you will get nothing with those commands if realtime cathing is not set.

------Original Message------
From: Emre Kurnaz
Sender: asterisk-users-bounces at lists.digium.com
To: asterisk-users at lists.digium.com
ReplyTo: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: [asterisk-users] sip realtime question
Sent: Dec 11, 2009 4:02 AM

Hi everybody,

First of all i am sorry my English :)

i want to configure my asterisk server as a sip server that stores sip users in the mysql database connecting directly over odbc driver. My odbc configuration works as below

[root at ao042 asterisk]# isql -v asterisk
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+


and i did refer to the site http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip . my res_odbc file as;

[root at ao042 asterisk]# cat res_odbc.conf
[asterisk]
enabled => yes
dsn => asterisk
username => asterisk
password => *******
pre-connect => yes

[root at ao042 asterisk]# grep -Ev '^;|^$' extconfig.conf
[settings]
sipusers => odbc,asterisk,sip_buddies
sippeers => odbc,asterisk,sip_buddies

and i created the asterisk database with sip_buddies table.

Here is my problem:

In asterisk console when i run the following command i get the answer,

ao042*CLI> realtime load sipusers name 100
                   Column Name  Column Value
          --------------------  --------------------
                            id  1
                          name  100
                          host  dynamic
                           nat  no
                          type  friend
                cancallforward  yes
                   canreinvite  yes
                        secret  Deneme01
                      disallow  all
                         allow  g729
                         allow  ilbc
                         allow  gsm
                         allow  ulaw
                         allow  alaw
                          port  5060
                    regseconds  0
                        lastms  0
                      username  100


but the following commands returns nothing

ao042*CLI> sip show users
Username                   Secret           Accountcode      Def.Context      ACL  NAT
ao042*CLI> sip show peers
Name/username              Host            Dyn Nat ACL Port     Status     Realtime
0 sip peers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 0 offline]

besides it does not query anything. So what am i missing? Is there anything that i should mentioned in the sip.conf file?

by the way i am using RHEL 5.4 with 2.6.18-164.el5 kernel - asterisk16-1.6.0.17-1_centos5 rpm

Any help would be appreciated...

-- 

Emre Kurnaz                        
ITU/BIDB                           | Istanbul Technical University / Information Technologies Office
Sistem Destek Grubu                | System Support Team
RHCE : 805009174841679
Yar¹ Zamanl¹ Ö»renci Koordinatörü  | Part-Time Student Manager
kurnaze at itu.edu.tr
+90 0212 285 3930

_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Saludos,
Juan E. Rodríguez