SourceForge has been redesigned. Learn more.
Close

#3 after using "Did you setup/reset the DB"

closed-fixed
nobody
1
2014-08-20
2012-08-13
Anonymous
No

installed latest on OWASPBWA and fixed the db parameters in the files. Reset with no errors but this error persists on the top of the screen

Discussion

  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous

    Anonymous - 2012-08-13

    failure dood!

     
    Last edit: Anonymous 2015-07-25
  • Jeremy Druin

    Jeremy Druin - 2012-08-13
     
  • Jeremy Druin

    Jeremy Druin - 2012-08-13
    • milestone: --> 3187662
    • status: open --> open-accepted
     
  • Jeremy Druin

    Jeremy Druin - 2012-08-13

    Here is my best guess. In the picture, the error message states the table "mutillidae.balloon_tips" does not exist. The database connection is likely connecting to the MySQL server using database name "mutillidae" configured in file MySQLHandler.php. The most likely reason for the error is that the script set-up-database.php creates database "owasp10" and places table "balloon_tips" inside "owasp10". So Mutillidae has probably created database "owasp10" but the database handler is probably connected to database "mutillidae" and sending queries to this database. Since the table balloon_tips was never created in database mutillidae, the system is throwing an error. Please try to go into file MySQLHandler.php and change the "database name" from "mutillidae" to owasp10, then reset the database again to see if this fixes the issue. Please let me know. I will take a look at the system later to see if set-up-database.php can be improved to take into account that the user might want to use a different database than the "owasp10" value currently hardcoded into the setup. Please see attached image below for assistence.

     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous

    Anonymous - 2012-08-13

    here is the installation error. I fixed the db logins in classes/MySQLHandler.php (and config.inc for the heck of it) and the db setup/reset runs fine but post reset I see no table called balloon_tips

    root@owaspbwa:~# mysql -u mutillidae -p mutillidae
    Enter password:
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 659
    Server version: 5.1.41-3ubuntu12.6-log (Ubuntu)

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    mysql> use mutillidae
    Database changed
    mysql> show tables;
    +----------------------+
    | Tables_in_mutillidae |
    +----------------------+
    | accounts |
    | blogs_table |
    | captured_data |
    | credit_cards |
    | hitlog |
    | pen_test_tools |
    +----------------------+
    6 rows in set (0.00 sec)

    If I manually create the table the error goes away. Maybe it is just something weird with being run under bwa but the code is not creating or populating the table.

     
    Last edit: Anonymous 2015-07-25
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous

    Anonymous - 2012-08-13
    • priority: 5 --> 1
    • milestone: 3187662 -->
    • status: open-accepted --> open
     
    Last edit: Anonymous 2015-07-25
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous

    Anonymous - 2012-08-13

    changing to owasp10 also causes NO errors it works correctly. I had just been downloading regularly and changing the variables as they were in the base OWASPBWA setup. Looking at the code is hardcoded to owasp10 in the set-up-database code but there is a database variable at the top of the MySQLHandler file that is used in the connection. I just went on that and did not look at the setup code carefully, I just checked that it had code to make the table I thought was not being created.

    I understand the issue now, thanks for the guidance.

     
    Last edit: Anonymous 2015-07-25
  • Jeremy Druin

    Jeremy Druin - 2012-08-13
    • status: open --> closed-fixed
     
  • Jeremy Druin

    Jeremy Druin - 2012-08-13

    New feature added in release 2.3.3 which allows user to choose any database name.

     

Log in to post a comment.