[Asterisk-Users] Help: Using asterisk and mysql for a university project

[Sergio Iñigo Ibáñez]

Hello all,

 

I want to use mysql for to save the users of my asterisk PBX. I use the
realtime solution with mysql but when I made the ‘sip show peers’ command
doesn’t appear my users. My configurations are:

 

res_mysql.conf 

 [general]

dbhost = 127.0.0.1

dbname = asterisk

dbuser = asterisk

dbpass = satec

dbport = 3306

dbsock = /var/run/mysqld/mysqld.sock

 

sip.conf 

[general]

dbuser=asterisk

dbpass=satec

dbhost=127.0.0.1

dbname=asterisk 

table=sipusers

rtcachefriends=yes

 

extconfig.conf

sipusers => mysql, asterisk, sipusers

sippeers => mysql, asterisk, sipusers

 

and the output of the ‘realtime mysql status’ 

asterisk2006*CLI> realtime mysql status

Connected to asterisk at 127.0.0.1, port 3306 with username asterisk for 3
minutes, 42 seconds.

asterisk2006*CLI> sip show peers

Name/username              Host            Dyn Nat ACL Port     Status    

0 sip peers [0 online , 0 offline]

asterisk2006*CLI> sip show users

Username                   Secret           Accountcode      Def.Context
ACL  NAT       

asterisk2006*CLI>

 

What is the problem?

 

Thanks and Regards,

 

Sergio

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060320/701968f4/attachment.htm