PostgreSQL Module can't handle Users

A web-based interface for system administration of UNIX

Brought to you by: iliaross, jcameron

#4727 PostgreSQL Module can't handle Users

Milestone: 1.791

Status: closed-fixed

Owner: nobody

Labels: postgresql (1)

Priority: 7

Updated: 2016-06-25

Created: 2016-03-24

Creator: Gencer Genç

Private: No

On PostgreSQL 9.5.x Webmin can't handle users.

SQL select usename,usesysid,usecreatedb,usesuper,usecatupd,passwd,valuntil from pg_shadow failed : ERROR: column "usecatupd" does not exist LINE 1: select usename,usesysid,usecreatedb,usesuper,usecatupd,passw... ^

Tried on various servers. All the same on Pgsql 9.5.x

Discussion

Gencer Genç - 2016-03-24

Seems related: https://sourceforge.net/p/webadmin/bugs/4702/

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jamie Cameron - 2016-03-25

Which Linux distribution are you running there, and where did you install PostgreSQL 9.5 from?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gencer Genç - 2016-03-25

@Jamie, Debian 8.3 x64 and installed from official APT Repository of postgresql.org.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jamie Cameron - 2016-03-27

Just installed the latest PostgreSQL 9.5 RPM from postgresql.org , and wasn't able to re-produce this error. Also, I verified that the pg_shadow table does have a usecatupd column.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gencer Genç - 2016-03-27

RPM? I use debian not CentOS btw.

See: http://i.imgur.com/9q1dmhY.png

This is a fresh installation.

Last edit: Gencer Genç 2016-03-27

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jamie Cameron - 2016-03-27

Ok, but I would assume that the latest RPM and Debian packages from postgresql.org contain the same server version and code (hopefully).

What output do you get if you click on the postgres database and then on Execute SQL, and run select * from pg_shadow ?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gencer Genç - 2016-03-27

I get exactly this...

See: http://i.imgur.com/9uW1sWQ.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jamie Cameron - 2016-03-27

status: open --> closed-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jamie Cameron - 2016-03-27

Ok, this will be fixed in the next Webmin release.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Christopher Caruk - 2016-06-22

Was this fixed? I believe that I am using the latest version of Wbbmin (1.801) but it's still not working for me.

Last edit: Christopher Caruk 2016-06-22

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jamie Cameron - 2016-06-23

It should have been, as long as Webmin detects that you are running PostgreSQL 9.5 or later (as shown at Servers -> PostgreSQL Database).

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Christopher Caruk - 2016-06-23

Hello Jamie, Thank you for your response.

According the webmin header, I'm using :
* PostgreSQL Database Server
* PostgreSQL version 9.5.3 (With schemas)

This is a fresh install of Ubuntu 16.04 and an install of postgres using this guide: https://www.howtoforge.com/tutorial/how-to-install-postgresql-95-on-ubuntu-12_04-15_10/

Postgres seems to be working perfectly.

Does webmin select a version of postgres when installed or dynamically, at runtime?

When I try to access users I get:

SQL select usename,usesysid,usecreatedb,usesuper,usecatupd,passwd,valuntil from pg_user failed : ERROR: column "usecatupd" does not exist LINE 1: select usename,usesysid,usecreatedb,usesuper,usecatupd,passw... ^

Can I assist further by providing more diagnostic information?

Thanks
Chris

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jamie Cameron - 2016-06-24

What version does it show at the top of the page in the PostgreSQL Database module?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Christopher Caruk - 2016-06-24

The information above was from the top of the page in the PostgreSQL database module. It says:

PostgreSQL Database Server
PostgreSQL version 9.5.3 (With schemas)

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jamie Cameron - 2016-06-24

My mistake, this isn't fixed in the 1.801 release. It will be fixed in a future version.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Christopher Caruk - 2016-06-24

OK, Thanks. Do you know when the fix might appear? Can i patch manually before then?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jamie Cameron - 2016-06-25

Try applying this patch : https://github.com/webmin/webmin/commit/98677fd304d49e8fc1c07212a15384254845e026

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.