[Bug 86581] Re: Glom has issues if DB user is missing access rights
I'm still hoping that you'll find some time to give me specific instructions for reproducing this error. I'd really like to fix this bug. -- Glom has issues if DB user is missing access rights https://bugs.launchpad.net/bugs/86581 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 86581] Re: Glom has issues if DB user is missing access rights
GuoQuan: I suggest you leave the ubuntu-gnomemm team, if you don't want to receive its bug mails: https://launchpad.net/~ubuntu-gnomemm/+leave Note this piece of information in the emails: You received this bug notification because you are a member of ubuntu-gnomemm, which is a bug contact for ... in ubuntu. -- Glom has issues if DB user is missing access rights https://bugs.launchpad.net/bugs/86581 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 86581] Re: Glom has issues if DB user is missing access rights
** Changed in: glom (Ubuntu) Status: New = Incomplete -- Glom has issues if DB user is missing access rights https://bugs.launchpad.net/bugs/86581 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 86581] Re: Glom has issues if DB user is missing access rights
Hi, have you had a chance to do that? -- Glom has issues if DB user is missing access rights https://bugs.launchpad.net/bugs/86581 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 86581] Re: Glom has issues if DB user is missing access rights
On Fri, 2007-03-09 at 22:27 +, Murray Cumming wrote: I really want to investigate and fix this issue, but I really need those specific instructions to reproduce it. Hi, I was actually preparing these instructions last week. Went through a couple of test runs, and had differing results, so I want to double check them. My wife is almost due with our first child, so my spare time is reducing. But I'll try and get these instructions through to you soon. Cheers! -- Andrew Ruthven, Wellington, New Zealand At home: [EMAIL PROTECTED] | This space intentionally |left blank. -- Glom has issues if DB user is missing access rights https://launchpad.net/bugs/86581 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 86581] Re: Glom has issues if DB user is missing access rights
Thanks, Andrew, and congratulations. -- Glom has issues if DB user is missing access rights https://launchpad.net/bugs/86581 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 86581] Re: Glom has issues if DB user is missing access rights
I really want to investigate and fix this issue, but I really need those specific instructions to reproduce it. -- Glom has issues if DB user is missing access rights https://launchpad.net/bugs/86581 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 86581] Re: Glom has issues if DB user is missing access rights
When I try to create a new database, connecting via a user that does not have createdb rights, I see the error dialog that says Glom could not create the new database. Maybe you do not have the necessary access rights. Please contact your system administrator. (plus I see this on stdout: Frame_Glom::create_database(): Gnome::Gda::Connection::create_database(glom_test) failed. ) I don't understand why you don't see this error dialog. I guess I need very specific instructions to reproduce this problem. -- Glom has issues if DB user is missing access rights https://launchpad.net/bugs/86581 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 86581] Re: Glom has issues if DB user is missing access rights
On Sat, 2007-02-24 at 03:34 +, Andrew Ruthven wrote: No, this is only about missing rights. Nothing to do with missing executables. I think you have misunderstood me because there is a user access right/flag called createdb and a utility called createdb. My DB user was missing the right/flag createdb. Ah, sorry. I'll test that and make sure we handle the error more sensibly, explicitly checking for these rights if possible. -- Murray Cumming [EMAIL PROTECTED] www.murrayc.com www.openismus.com -- Glom has issues if DB user is missing access rights https://launchpad.net/bugs/86581 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 86581] Re: Glom has issues if DB user is missing access rights
On Fri, 2007-02-23 at 07:49 +, Murray Cumming wrote: So is this actually two problems? One about what happens when the utility executable are missing, and one about what happens when a postgres user has particular postgres access rights? Could you provide more information about that second problem, such as the steps you take and what you see, please? Maybe in a separate bug report. Hi, No, this is only about missing rights. Nothing to do with missing executables. I think you have misunderstood me because there is a user access right/flag called createdb and a utility called createdb. My DB user was missing the right/flag createdb. I added right/flag createdb and then I found I was missing the createrole role. The behaviour I noticed is reported in my original description of this bug report. To reproduce this behaviour I expect you could create a DB user (using createuser) that has none of these rights, then try and create a new Glom DB using that user. Cheers! -- Andrew Ruthven Wellington, New Zealand At home: [EMAIL PROTECTED] | This space intentionally |left blank. -- Glom has issues if DB user is missing access rights https://launchpad.net/bugs/86581 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 86581] Re: Glom has issues if DB user is missing access rights
If the DB user you use to connect to PostgreSQL is missing required access rights then Glom has some serious issues... I'm not sure what you mean. Are you talking about the Linux user, or a PostgreSQL user, or just about the availability (or access to) the Postgres command-line utilities that you mention below? If createdb is missing then Glom fails to create the database This should be avoided by the incomplete-installation detection in the latest version (1.3.9). Could you check that please, though you might want to wait for yet another version because the Ubuntu Glom maintainer is making some useful changes at the moment. -- Glom has issues if DB user is missing access rights https://launchpad.net/bugs/86581 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 86581] Re: Glom has issues if DB user is missing access rights
Gidday, On Thu, 2007-02-22 at 12:13 +, Murray Cumming wrote: If the DB user you use to connect to PostgreSQL is missing required access rights then Glom has some serious issues... I'm not sure what you mean. Are you talking about the Linux user, or a PostgreSQL user, or just about the availability (or access to) the Postgres command-line utilities that you mention below? The user in the database. If you use psql (connecting using the user you want to use with glom, which defaults to your Linux username) and use: select * from pg_roles where rolname = current_user Then that user/role needs to have rolcreatedb and rolcreaterole. If createdb is missing then Glom fails to create the database This should be avoided by the incomplete-installation detection in the latest version (1.3.9). Could you check that please, though you might want to wait for yet another version because the Ubuntu Glom maintainer is making some useful changes at the moment. Okay, I'll give it a go when glom 1.3.9 appears in Feisty. Thanks! -- Andrew Ruthven, Wellington, New Zealand At home: [EMAIL PROTECTED] | This space intentionally |left blank. -- Glom has issues if DB user is missing access rights https://launchpad.net/bugs/86581 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 86581] Re: Glom has issues if DB user is missing access rights
So is this actually two problems? One about what happens when the utility executable are missing, and one about what happens when a postgres user has particular postgres access rights? Could you provide more information about that second problem, such as the steps you take and what you see, please? Maybe in a separate bug report. -- Glom has issues if DB user is missing access rights https://launchpad.net/bugs/86581 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs