Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 8:17 am
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Strange queries ..suspicious or normal ?
PostPosted: Sun Sep 02, 2012 10:39 am 
Offline

Joined: Mon Oct 17, 2011 9:19 am
Posts: 14
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


Top
 Profile  
 
 Post subject: Re: Strange queries ..suspicious or normal ?
PostPosted: Mon Sep 03, 2012 6:22 pm 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
Hi

Looks like an A2Billing realtime query where someone is trying to do a SIP register as myKamailioX

Joe


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 
Predictive Dialer


All times are UTC


Who is online

Users browsing this forum: Google [Bot] and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group