[asterisk-users] Realtime - ara180 - part-2

[Hans Witvliet]

On Thu, 2011-05-12 at 21:30 +0200, bakko wrote:
> Hi,
> 
> look if you have res_config_mysql.so module instaled on your asterisk.
> 
> On CentOS /usr/lib/asterisk/modules
> 
> Regards
Tnx for your reply.
It turned out, that mysql-support was in a different rpm (addons)
As systems are never connected to the big-bad-external world, it took
some time to do an upgrade and fetch the missing rpm. had some serious
complaining l-users to tend to ;-)

So i left the config unchanged, but noticed:
kc3054*CLI> sip show users
Username  Secret  Accountcode Def.Context      ACL  ForcerPort
j.witvliet geheim              default          No   Yes       
00000277611 25b06d3a0b5ef73    default          No   Yes       
kc3054*CLI> 


kc3054*CLI> sip show peers
Name/username Host  Dyn Forcerport ACL Port     Status     Realtime
0000277611  Unspecified)  D   N      0        Unmonitored 
j.witvliet  (Unspecified) D   N      0        Unmonitored 
2 sip peers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 2
offline] kc3054*CLI> 


kc3054*CLI> realtime mysql status
general connected to asterisk at 127.0.0.1, port 3306 with username
voipadmin for 2 hours, 7 minutes.
kc3054*CLI> 

kc3054*CLI>
kc3054*CLI>  realtime mysql cache
kc3054*CLI> 


So, no more complaints at the cli or logfile,
But the sip-entry from mysql "00000031756" still does not show up.

I hope that any suggestions/help will be "educational to others"

Hans