PostgresSQL as Database

D's Avatar


05 Feb, 2017 09:27 PM

To use PostgreSQL as your database you should:

Backup the default DB configuration file (system/arachni-ui-web/config/database.yml).
Rename system/arachni-ui-web/config/database.yml.pgsql to system/arachni-ui-web/config/database.yml.
Update the configuration file settings with the appropriate credentials.
Run ./bin/arachni_web_task db:setup to setup the database.

How do I update the configuration file settings with the appropriate credentials?

I moved the original database.yml file to another location for backup purposes. I then renamed database.yml.pgsql to just database.yml

Now I am on to the next step of updating the configuration file and am stuck because I do not know how to go about doing this.


  1. Support Staff 1 Posted by Tasos Laskos on 07 Feb, 2017 10:19 AM

    Tasos Laskos's Avatar

    You need to change these values:

      username: arachni
      password: secret

    From arachni and secret to whatever credentials you have set for your DB.

  2. 2 Posted by D on 09 Feb, 2017 04:55 AM

    D's Avatar

    I went into the database.yml.pgsql file and changed "arachni" in all instances along with "secret" in all instances.

    I moved the original database.yml file out the folder.
    I renamed the database.yml.pgsql into database.yml.

    I now go to my terminal and start psql to correct an error I am receiving and cannot find the correct commands to enter. I have enclosed a file which displays the errors I have come across. Please tell me if I am taking the wrong steps.

  3. Support Staff 3 Posted by Tasos Laskos on 09 Feb, 2017 08:32 AM

    Tasos Laskos's Avatar

    I don't think I can be of further help, it's a DB configuration issue from now on and I'm very rusty on my DB admin skills.
    Are you sure the password for the "specias" user is correct?

  4. 4 Posted by D on 12 Feb, 2017 11:22 AM

    D's Avatar

    I think... I think I finally configured the DB. However, I came across this issue:

    ./arachni_web [WARN] table 'Role' doesn't exist. Did you run the migration ? Ignoring rolify config. Puma 2.14.0 starting...
    * Min threads: 0, max threads: 16 * Environment: development * Listening on tcp://localhost:9292

    Kinda scratching my head for any hairs that are left now.......

  5. Support Staff 5 Posted by Tasos Laskos on 12 Feb, 2017 03:12 PM

    Tasos Laskos's Avatar

    Did you run ./bin/arachni_web_task db:setup?

  6. 6 Posted by D on 12 Feb, 2017 07:52 PM

    D's Avatar

    Well, that is the step I missed.
    I remember restarting postgreSQL prior to starting ./arachni_web
    I remember going into the web interface and creating new users so that the logins work.

    I first received this output - that I placed in file format and attached - when starting ./bin/arachni_web_task db:setup

    The first lines put a little fright in me. I thought that the same issue would exist.

    I restarted postgreSQL once again.
    I started ./arachni_web and logged into the web interface.
    However, all the users I created previously were removed or missing.
    I only had to re-add these users. Sign out. Restart postgreSQL.

    I opened ./arachni_web and the command provided no error or warns.

    It appears to me that everything is functioning smoothly now.
    Now that I have the database and web interface configured, I can now continue on with the rest of the tutorial.

    Much thanks!

  7. Tasos Laskos closed this discussion on 22 Feb, 2017 01:52 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac