Webadm and Postgres 9.2

65 views
Skip to first unread message

Gary

unread,
Feb 20, 2013, 3:56:47 PM2/20/13
to rcdevs-t...@googlegroups.com
Running CentOS 6.3, Postgres 9.2

When initially setting up WebADM, I click on the button to create the SQL tables.  The tables are created in my postgres database and the command appears to be successful.  However, when returning to the setup page, it shows that the tables are not created and the log file shows the error "SQL database tables are not created".  I can manually log into my postgres database and verify that these were created.

Pointing Webadm to an instance of MySQL 5.1 does not suffer from this same issue.

Thoughts as to why WebADM can create the database tables in postgres, but then cannot verify that they exist?

Administrators

unread,
Feb 21, 2013, 4:50:06 AM2/21/13
to RCDevs Security Solutions - Technical
We check this on the PostgreSQL...
Else are you sure the PostgreSQL database-level permissions are setup
with full access for the webadm user?

Gary

unread,
Feb 21, 2013, 10:26:26 AM2/21/13
to rcdevs-t...@googlegroups.com
Yes.

                                  Access privileges
 Schema |     Name      |   Type   |   Access privileges   | Column access privi
leges
--------+---------------+----------+-----------------------+--------------------
------
 public | admin         | table    | webadm=arwdDxt/webadm |
 public | admin_id_seq  | sequence | webadm=rwU/webadm     |
 public | alert         | table    | webadm=arwdDxt/webadm |
 public | alert_id_seq  | sequence | webadm=rwU/webadm     |
 public | manag         | table    | webadm=arwdDxt/webadm |
 public | manag_id_seq  | sequence | webadm=rwU/webadm     |
 public | message       | table    | webadm=arwdDxt/webadm |
 public | webapp        | table    | webadm=arwdDxt/webadm |
 public | webapp_id_seq | sequence | webadm=rwU/webadm     |
 public | websrv        | table    | webadm=arwdDxt/webadm |
 public | websrv_id_seq | sequence | webadm=rwU/webadm     |

Administrators

unread,
Feb 22, 2013, 2:33:56 AM2/22/13
to RCDevs Security Solutions - Technical
That's fixed. We added the fix to our last patch :
http://www.rcdevs.com/downloads/download.php?type=1&id=30d845dc3d5de938d87e7fa02b59a3ee
Thanks for proving the details!
Reply all
Reply to author
Forward
0 new messages