Send Netdot-devel mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-devel digest..."
Today's Topics:
1. [Netdot - Bug #1890] (New) PostgreSQL DBA can't run "make
installdb" without superuser privileges ([email protected])
----------------------------------------------------------------------
Message: 1
Date: Thu, 7 Apr 2016 15:11:55 -0700
From: [email protected]
Subject: [Netdot-devel] [Netdot - Bug #1890] (New) PostgreSQL DBA
can't run "make installdb" without superuser privileges
To: [email protected], [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Issue #1890 has been reported by Matt Zagrabelny.
----------------------------------------
Bug #1890: PostgreSQL DBA can't run "make installdb" without superuser
privileges
https://osl.uoregon.edu/redmine/issues/1890
Author: Matt Zagrabelny
Status: New
Priority: Normal
Assignee:
Category:
Target version:
Resolution:
Greetings,
I know Pg support is still not "official". I also understand that the install
docs recommend/suggest using the Pg DBA 'postgres' account for installing the
netdot database.
I am using a separate host for database serving than from web serving. I did
not want to open up the postgres account to the network, thus I created a
netdot_admin database account that had the "create database" privilege.
Running the "make installdb" was successful until make tried the oui target.
At that point, I received the following error:
DEBUG: (COPY oui(oui, vendor) FROM '/tmp/oui.txt'):
DBD::Pg::db do failed: ERROR: must be superuser to COPY to or from a file
HINT: Anyone can COPY to stdout or from stdin. psql's \copy command also works
for anyone. at ../lib/DBUTIL.pm line 594.
ERROR while executing COPY oui(oui, vendor) FROM '/tmp/oui.txt': DBD::Pg::db do
failed: ERROR: must be superuser to COPY to or from a file
HINT: Anyone can COPY to stdout or from stdin. psql's \copy command also works
for anyone. at ../lib/DBUTIL.pm line 594.
I'm sorry I don't have a patch for this right now, but just wanted to get the
bug report submitted.
Thanks!
-m
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://osl.uoregon.edu/redmine/my/account
------------------------------
_______________________________________________
Netdot-devel mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
End of Netdot-devel Digest, Vol 109, Issue 1
********************************************
