NATS database query tools??? - GoFuckYourself.com

HunkyLuke · 12-10-2007, 08:00 AM

Anyone know of any database probing tools for NATS? I would like to do extended searches for things like signup IP addresses, login IPs, epassporte accounts names, etc. This info is all available within NATS but searching specifically for them is not supported. I tried checking through phpMyAdmin but the db seems to be encrypted.

thanks,
Luke

ro8in · 12-10-2007, 08:07 AM

Hi Chilihost

db is not encrypted or you have some weird installation, but NATS even has some KB articles referring to looking in the DB

I checked I can see all data fine..

draude · 12-10-2007, 08:15 AM

yup the database in nats is not encypted. you should check it carefuly

Satan · 12-10-2007, 08:24 AM

The ips are not encrypted they are converted to hexidecimal

kowalsky · 12-10-2007, 08:25 AM

Maybe this is a stupid question, but how do you access to the databse? By ssh access to mysql adn then use sql sentences?

HunkyLuke · 12-10-2007, 08:40 AM

Quote:

Originally Posted by Satan

The ips are not encrypted they are converted to hexidecimal

oh thats what it was... I searched for IP addresses and could not match on a 1.1.1.1 format, I never thought it was converted to hex. Thanks! I will give phpMyAdmin another try.

quantum-x · 12-10-2007, 09:45 AM

Quote:

Originally Posted by kowalsky

Maybe this is a stupid question, but how do you access to the databse? By ssh access to mysql adn then use sql sentences?

If you're asking this question, don't go near your nats db

TMM_John · 12-10-2007, 10:14 AM

Quote:

Originally Posted by chilihost

oh thats what it was... I searched for IP addresses and could not match on a 1.1.1.1 format, I never thought it was converted to hex. Thanks! I will give phpMyAdmin another try.

Anything that stores IPs as "1.1.1.1" should make you run far far away

In case you haven't seen there is the KB at http://kb.toomuchmedia.com which has a lot of info but does not get too in-depth as far as the database, etc.

Just be careful when in the DB as you can do a lot of damage. Doing SELECTS are fine, but if you do any modification of the DB structure it can cause lots and lots of problems.

12-10-2007, 08:00 AM	#1
HunkyLuke Virgin by request ;) Industry Role: Join Date: Feb 2002 Posts: 1,924	NATS database query tools??? Anyone know of any database probing tools for NATS? I would like to do extended searches for things like signup IP addresses, login IPs, epassporte accounts names, etc. This info is all available within NATS but searching specifically for them is not supported. I tried checking through phpMyAdmin but the db seems to be encrypted. thanks, Luke

12-10-2007, 08:07 AM	#2
ro8in Confirmed User Industry Role: Join Date: Sep 2006 Posts: 1,542	Hi Chilihost db is not encrypted or you have some weird installation, but NATS even has some KB articles referring to looking in the DB I checked I can see all data fine.. __________________ ------ Offcourse its a dude posting here. Probably a fut ugly one too. Fuck still people falling for this 100 year old trick

12-10-2007, 08:15 AM	#3
draude Confirmed User Join Date: Nov 2006 Location: ... Posts: 1,214	yup the database in nats is not encypted. you should check it carefuly __________________ Web Developer

12-10-2007, 08:24 AM	#4
Satan Confirmed User Industry Role: Join Date: Jun 2005 Location: Hell Posts: 1,626	The ips are not encrypted they are converted to hexidecimal __________________ WHO THE FUCK ARE YOU?

12-10-2007, 08:25 AM	#5
kowalsky Confirmed User Join Date: Oct 2003 Posts: 2,494	Maybe this is a stupid question, but how do you access to the databse? By ssh access to mysql adn then use sql sentences? __________________ Jimmy Kowalsky www.catchycash.com [email protected] ICQ - 7319094