Bug 690756 – possible errors in /etc/raddb/sql/postgresql/admin.sql template

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 690756 - possible errors in /etc/raddb/sql/postgresql/admin.sql template

Summary:	possible errors in /etc/raddb/sql/postgresql/admin.sql template

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat Enterprise Linux 6
Classification:	Red Hat
Component:	freeradius (Show other bugs)
Sub Component:
Version:	6.1
Hardware:	Unspecified Unspecified

Priority	low Severity low
Target Milestone:	rc
Target Release:	---
Assigned To:	John Dennis
QA Contact:	Patrik Kis
Docs Contact:

URL:
Whiteboard:
Keywords:

Depends On:
Blocks:	818885
	Show dependency tree / graph

Reported:	2011-03-25 06:32 EDT by Karel Srot
Modified:	2012-06-20 10:05 EDT (History)
CC List:	3 users (show)

See Also:
Fixed In Version:	freeradius-2.1.12-1.el6
Doc Type:	Bug Fix
Doc Text:	Cause: Invalid syntax in postgresql admin schema file. Consequence: Creation of the freeradius postgresql tables not successfully completed. Fix: Adjust the syntax to match postgresql. Result: postgresql freeradius tables created with proper properties.
Story Points:	---
Clone Of:
Clones:	818885 (view as bug list)
Environment:
Last Closed:	2012-06-20 10:05:29 EDT
Type:	---
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
Red Hat Product Errata	RHBA-2012:0881	normal	SHIPPED_LIVE	freeradius bug fix and enhancement update	2012-06-19 16:47:36 EDT

Groups: None (edit)

Description Karel Srot 2011-03-25 06:32:52 EDT

Description of problem:

There is very probably an error in /etc/raddb/sql/postgresql/admin.sql template.
I think that instead of

GRANT ALL on radius.radacct TO radius;
GRANT ALL on radius.radpostauth TO radius;

should be

GRANT ALL on radacct TO radius;
GRANT ALL on radpostauth TO radius;

I think it came from mysql syntax which is a bit different.

The rest of the template doesn't use "radius." prefix, e.g.
GRANT SELECT ON radcheck TO radius;
GRANT SELECT ON radreply TO radius;
...


Version-Release number of selected component (if applicable):
freeradius-2.1.10-4.el6.i686

Comment 8 John Dennis 2012-04-24 12:32:19 EDT

    Technical note added. If any revisions are required, please edit the "Technical Notes" field
    accordingly. All revisions will be proofread by the Engineering Content Services team.
    
    New Contents:
Cause:

Invalid syntax in postgresql admin schema file.

Consequence:

Creation of the freeradius postgresql tables not successfully completed.

Fix:

Adjust the syntax to match postgresql.

Result:

postgresql freeradius tables created with proper properties.

Comment 11 errata-xmlrpc 2012-06-20 10:05:29 EDT

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHBA-2012-0881.html

Note You need to log in before you can comment on or make changes to this bug.