setting database ownership
|
View:
New views
6 Messages
—
Rating Filter:
Alert me
|
 |
setting database ownership
by Ethan Mallove
::
Rate this Message:
I am trying to setup a database with ownership other than 'postgres'. I have the
following tags in my exp*.xml file: <owner>ethan</owner> <user>ethan</user> <passwd>secret</passwd> I do not have a $HOME/.pgpass file or any PB* env vars set. But I still get this error when trying to use "perfbase input". ERROR: user 'ethan' has insufficient privileges to access experiment 'test_run_correctness'. And perfbase dump shows what looks like NULL for the Owner: -- Name: DATABASE pb_test_run_correctness; Type: COMMENT; Schema: -; Owner: Is there something else I'm forgetting? Note: if I do: $ cat www/correctness.sql | psql -d my_db -U ethan Database ownership appears to set correctly. -Ethan PS: $ perfbase version perfbase release 0.9.1 (30th June 2006), database version 5 (c) 2004-2006 C&C Research Labs, NEC Europe Ltd. perfbase comes with ABSOLUTELY NO WARRANTY; for details type `perfbase version -w'. This is free software, and you are welcome to redistribute it under certain conditions; type `perfbase version -c' for details. (I just checked this perfbase out from svn, shouldn't the date be more recent?) --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: setting database ownership
by Joachim Worringen-4
::
Rate this Message:
Ethan Mallove wrote:
> I am trying to setup a database with ownership other than 'postgres'. I have the > following tags in my exp*.xml file: > > <owner>ethan</owner> > <user>ethan</user> > <passwd>secret</passwd> > > I do not have a $HOME/.pgpass file or any PB* env vars set. But I still get this > error when trying to use "perfbase input". > > ERROR: user 'ethan' has insufficient privileges to access experiment > 'test_run_correctness'. I guess you use the wrong syntax - please refer to pb_experiment.dtd: <admin_access> <user>...</user> </admin_access> etc. > $ perfbase version > perfbase release 0.9.1 (30th June 2006), database version 5 > (c) 2004-2006 C&C Research Labs, NEC Europe Ltd. > perfbase comes with ABSOLUTELY NO WARRANTY; for details type `perfbase version -w'. > This is free software, and you are welcome to redistribute it > under certain conditions; type `perfbase version -c' for details. > > (I just checked this perfbase out from svn, shouldn't the date be more recent?) This is the release date, not the date of the last svn commit. Joachim -- Joachim Worringen, Software Architect, Dolphin Interconnect Solutions phone ++49/(0)228/324 08 17 - http://www.dolphinics.com --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: setting database ownership
by Ethan Mallove
::
Rate this Message:
Joachim Worringen wrote On 07/27/06 03:11,:
> Ethan Mallove wrote: > >>I am trying to setup a database with ownership other than 'postgres'. I have the >> following tags in my exp*.xml file: >> >> <owner>ethan</owner> >> <user>ethan</user> >> <passwd>secret</passwd> >> >>I do not have a $HOME/.pgpass file or any PB* env vars set. But I still get this >>error when trying to use "perfbase input". >> >>ERROR: user 'ethan' has insufficient privileges to access experiment >>'test_run_correctness'. > > > I guess you use the wrong syntax - please refer to pb_experiment.dtd: > > <admin_access> > <user>...</user> > </admin_access> > <admin_access>ethan</admin_access> <input_access>ethan</input_access> I added the above lines, but that didn't work until I used --dbuser and --dbpasswd: $ perfbase setup --dbuser=ethan --dbpasswd=secret --desc=foo.xml -Ethan --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: setting database ownership
by Ethan Mallove
::
Rate this Message:
Ethan Mallove wrote On 07/27/06 13:28,:
> Joachim Worringen wrote On 07/27/06 03:11,: > >>Ethan Mallove wrote: >> >> >>>I am trying to setup a database with ownership other than 'postgres'. I have the >>>following tags in my exp*.xml file: >>> >>> <owner>ethan</owner> >>> <user>ethan</user> >>> <passwd>secret</passwd> >>> >>>I do not have a $HOME/.pgpass file or any PB* env vars set. But I still get this >>>error when trying to use "perfbase input". >>> >>>ERROR: user 'ethan' has insufficient privileges to access experiment >>>'test_run_correctness'. >> >> >>I guess you use the wrong syntax - please refer to pb_experiment.dtd: >> >><admin_access> >> <user>...</user> >></admin_access> >> > > <admin_access>ethan</admin_access> > <input_access>ethan</input_access> > Disregard! I see I botched the syntax again. So this works: <admin_access><user>ethan</user></admin_access> <input_access><user>ethan</user></input_access> > I added the above lines, but that didn't work until I used --dbuser and --dbpasswd: > > $ perfbase setup --dbuser=ethan --dbpasswd=secret --desc=foo.xml > > > -Ethan > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: setting database ownership
by Joachim Worringen-4
::
Rate this Message:
Ethan Mallove wrote:
> Joachim Worringen wrote On 07/27/06 03:11,: >> Ethan Mallove wrote: >> >>> I am trying to setup a database with ownership other than 'postgres'. I have the >>> following tags in my exp*.xml file: >>> >>> <owner>ethan</owner> >>> <user>ethan</user> >>> <passwd>secret</passwd> >>> >>> I do not have a $HOME/.pgpass file or any PB* env vars set. But I still get this >>> error when trying to use "perfbase input". >>> >>> ERROR: user 'ethan' has insufficient privileges to access experiment >>> 'test_run_correctness'. >> >> I guess you use the wrong syntax - please refer to pb_experiment.dtd: >> >> <admin_access> >> <user>...</user> >> </admin_access> >> > > <admin_access>ethan</admin_access> > <input_access>ethan</input_access> > > I added the above lines, but that didn't work until I used --dbuser and --dbpasswd: Read my reply and the dtd again - your XML is incorrect. Joachim -- Joachim Worringen, Software Architect, Dolphin Interconnect Solutions phone ++49/(0)228/324 08 17 - http://www.dolphinics.com --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: setting database ownership
by Joachim Worringen-4
::
Rate this Message:
Ethan Mallove wrote:
> <admin_access><user>ethan</user></admin_access> > <input_access><user>ethan</user></input_access> admin_access implies input_access, beter leave it away. Joachim -- Joachim Worringen, Software Architect, Dolphin Interconnect Solutions phone ++49/(0)228/324 08 17 - http://www.dolphinics.com --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
| Free embeddable forum powered by Nabble | Forum Help |
