Skip to content

Can't Run 'create_postgresql' Get Permission Denied

Featured Replies

When I try to run the command \i d:\winids\barnyard2\schemas\create_postgresql;

or try to run any of the other \i commands under the install tutorial heading of "Creating the Windows Intrusion Detection System Database Tables "

the result is always "d:: Permission denied"

I've tried many things to try and get around this blockage but I've not been successful.  Any suggestions would be appreciated.

Edited by scowles

Try reversing the slashes:

Change from: \i d:\winids\barnyard2\schemas\create_postgresql;

Change to:  \i d:/winids/barnyard2/schemas/create_postgresql;

Let me know if that works...

Can you also try removing the ; at the end to see if it works?

Edited by Morpheus

  • Author

Thank you.  Reversing the slashes as you suggested and keeping the semi-colon worked...so far

 

Edited by scowles
Next problem I may be able to resolve on my own

  • Author

One more command under the install tutorial heading of "Creating the Windows Intrusion Detection System Database Tables "

\i d:/temp/snort_user.sql;

the result is

WARNING: sequence "reference_ref_id_seq" only supports USAGE, SELECT, and UPDATE privileges

but after that I get

GRANT

Is that the expected result?

 

One more command under the install tutorial heading of "Creating the Windows Intrusion Detection System Database Tables "

\i d:/temp/snort_user.sql;

the result is

WARNING: sequence "reference_ref_id_seq" only supports USAGE, SELECT, and UPDATE privileges

but after that I get

GRANT

Is that the expected result?

 

​I'm not sure, but its a warning and can be ignored.

Create an account or sign in to comment

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.