Realtime – ara180 – part-2

Home » Asterisk Users » Realtime – ara180 – part-2
Asterisk Users No Comments

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@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