trouble logging to mysql

[jmprouty]

Howdy, I was wondering how I might be able to get my newly compiled nmap to actually dump stuff to the mysql.

I dumped that nmaplog.sql file just fine into mysql and created a user nmap that has access to the nmaplog db.

I created a ~/access.sql with 0600 rights, per the instructions. I still get this error though. Anyone have any ideas? Thanks!!

-Jonny

[root@blahblah]# nmap --mysql 172.22.*.*
mysql_real_connect() failed:
Error 1045 (Access denied for user: 'root@localhost' (Using password: NO))
mysql_real_connect() failed:
Error 1045 (Access denied for user: 'root@localhost' (Using password: NO))
mysql_real_connect() failed:
Error 1045 (Access denied for user: 'root@localhost' (Using password: NO))
mysql_real_connect() failed:
Error 1045 (Access denied for user: 'root@localhost' (Using password: NO))
mysql_real_connect() failed:
Error 1045 (Access denied for user: 'root@localhost' (Using password: NO))

Starting nmap 3.75 ( http://www.insecure.org/nmap/ ) at 2004-11-11 17:44 EST
No target machines/networks specified!
QUITTING!

[Hasnain Atique]

As of the nmapsql version supporting nmap 3.70, the ~/access.sql file is no longer read. Instead, the configuration file is now /etc/nmapsql.conf, which more standard.

BTW, you shouldn't have to log into to MySQL as root to do any of these.

Here's a sample file:

[database]
db=nmaplog
dbserver=localhost
dbuser=nmap
dbpasswd=scanamanga

[tables]
hoststats=hoststats
targets=targets
portstat=portstat
runlist=runlist
scanners=scanners
users=users

[jmprouty]

Awesome! That worked perfectly! Thankyou very much!

-Jonny