[Bug 611801] New: pgadmin3 error in a KDE4 knosole as postgres user
http://bugzilla.novell.com/show_bug.cgi?id=611801 http://bugzilla.novell.com/show_bug.cgi?id=611801#c0 Summary: pgadmin3 error in a KDE4 knosole as postgres user Classification: openSUSE Product: openSUSE 11.3 Version: Milestone 7 Platform: i686 OS/Version: openSUSE 11.3 Status: NEW Severity: Normal Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: n5xwb@comcast.net QAContact: qa@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100401 SUSE/3.6.4-1.3 Firefox/3.6.4 call up KDE4 and then a konsole - su to root and the "su - postgres". you will then be in /var/lib/pgsql hopefully. However an error shows up as postgres@m1l-suse:~> pgadmin3 Error: Unable to initialize gtk, is DISPLAY set properly? Reproducible: Always Steps to Reproduce: 1.Start KDE4 X as root 2. su to postgres 3. execute pgadmin3 Actual Results: Error: Unable to initialize gtk, is DISPLAY set properly? Expected Results: as a user it requires "postgres" to be the user. And then upcomes a error message. Turns out it is permission problem with KDE / QT not allowing others to use it while a system user is using it. As user donn it works but fails because postgres only works a user postgres and KDE doesn't like that. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=611801 http://bugzilla.novell.com/show_bug.cgi?id=611801#c yang xiaoyu <xyyang@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |xyyang@novell.com AssignedTo|bnc-team-screening@forge.pr |max@novell.com |ovo.novell.com | -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=611801 http://bugzilla.novell.com/show_bug.cgi?id=611801#c1 Reinhard Max <max@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |INVALID --- Comment #1 from Reinhard Max <max@novell.com> 2010-06-18 18:32:05 CEST --- The su command drops the DISPLAY environment variable for security reasons when it is called by root, but you shouldn't be logging into KDE as root anyways. Please consider the following two options: - Set a password for the postgres user so that you can su to it from a non-root login. Then you'll get the DISPLAY variable and can start pgadmin. - Adjust the configuration of the PostgreSQL server so that you can access it with PgAdmin3 wrunning under your regular account. See the PostgreSQL documentation on user management and host based authentication for details. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=611801 http://bugzilla.novell.com/show_bug.cgi?id=611801#c yang xiaoyu <xyyang@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |xyyang@novell.com AssignedTo|bnc-team-screening@forge.pr |max@novell.com |ovo.novell.com | -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=611801 http://bugzilla.novell.com/show_bug.cgi?id=611801#c1 Reinhard Max <max@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |INVALID --- Comment #1 from Reinhard Max <max@novell.com> 2010-06-18 18:32:05 CEST --- The su command drops the DISPLAY environment variable for security reasons when it is called by root, but you shouldn't be logging into KDE as root anyways. Please consider the following two options: - Set a password for the postgres user so that you can su to it from a non-root login. Then you'll get the DISPLAY variable and can start pgadmin. - Adjust the configuration of the PostgreSQL server so that you can access it with PgAdmin3 wrunning under your regular account. See the PostgreSQL documentation on user management and host based authentication for details. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply＠novell.com