Hi THe other day I noticed a lot of queries on my a2b database server upon checking I found alot of queries like the below, they would not take a lot of time to process, but they kept coming back. I am alerted because I know select * is a bad thing, and the whole query does not make a lot of sense to me in terms of A2B.
The queries are :
mysql -uroot -p -e "show processlist" | grep "SELECT \* FROM cc_sip_buddies" 130503708 dbUser AsteriskA:49493 mya2billing Query 1 Sending data SELECT * FROM cc_sip_buddies WHERE host = 'myKamailioX'' AND port = '5060' 130568323 dbUser AsteriskB:43180 mya2billing Query 2 Sending data SELECT * FROM cc_sip_buddies WHERE ipaddr = 'myKamailioZ'' ORDER BY ipaddr
Is this normal A2B, or is there something suspicious going on ?
Thanks
|