Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

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

closed-fixed
nobody
1
2012-08-13
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

  • Jeremy Druin
    Jeremy Druin
    2012-08-13

     
    Attachments
  • 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.

     

  • 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 2014-06-16

  • 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 2014-06-16
  • 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.