Home → Questions →

PostgresSQL as Database

• Edit

D

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.

Thanks

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

   

   You need to change these values:

     username: arachni
     password: secret
   

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

   • Edit

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

   

   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.

   • dbsetuparachni 13.8 KB
   • Edit

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

   

   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?

   • Edit

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

   

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

   • Edit

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

   

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

   • Edit

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

   

   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!

   • arachni 5.03 KB
   • Edit

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