trouble logging to mysql

Help
jmprouty
2004-11-11
2013-03-14
  • jmprouty

    jmprouty - 2004-11-11

    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

      Hasnain Atique - 2004-11-12

      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

      jmprouty - 2004-12-03

      Awesome! That worked perfectly! Thankyou very much!

      -Jonny

       

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks