Koozali.org: home of the SME Server

Sarg Reports

Offline compsos

  • *
  • 472
  • +0/-0
Sarg Reports
« on: March 30, 2009, 02:02:54 AM »
Is there a way to open the Sarg reports to other users/groups to avoid the opening up of the admin password?
Thanks
Regards

Gordon............

Offline lancelott2

  • *
  • 73
  • +0/-0
  • Ich bin Lancelott2
    • Meine private Homepage
Re: Sarg Reports
« Reply #1 on: March 30, 2009, 06:18:21 AM »
Hello,

i havent tested it but if u install the user-manager-panel and proxy-users it should work.
Have a look here: http://www.dungog.net/wiki/Dungog-proxyusers

Greetings

Lance
---------------------------------------------------------------------
Auch ich lerne noch ständig dazu!
---------------------------------------------------------------------

Offline David Harper

  • *
  • 653
  • +0/-0
  • Watch this space
    • Workgroup Technology Solutions
Re: Sarg Reports
« Reply #2 on: March 30, 2009, 07:06:11 AM »
User access is controlled from the template /etc/e-smith/templates/etc/httpd/conf/httpd.conf/90e-smithAccess20sarg. DOwn the bottom (line 28) you will see:

Code: [Select]
require user admin

So create a custom template and add your admin group in:

Code: [Select]
mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
cp /etc/e-smith/templates/etc/httpd/conf/httpd.conf/90e-smithAccess20sarg /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/

Now add the following change to the custom template

Code: [Select]
require group ntadmins
require user admin

Replace ntadmins with whatever group you wish to grant access to.

Then expand the template and test the generated file:

Code: [Select]
expand-template /etc/httpd/conf/httpd.conf
httpd -t

If everything checks out, restart Apache:

Code: [Select]
service httpd-e-smith restart
« Last Edit: March 30, 2009, 07:08:10 AM by David Harper »

Offline lancelott2

  • *
  • 73
  • +0/-0
  • Ich bin Lancelott2
    • Meine private Homepage
Re: Sarg Reports
« Reply #3 on: March 30, 2009, 07:32:05 AM »
Wow, David, thats a cool way.

But here another way:
Using NCSA Auth login

If you are using ncsa auth, create the user & password authentication list (you don't require users to be valid sme users)

touch /etc/proxyusers

Enter user names & password combinations one by one using this command

htpasswd -b /etc/proxyusers username password

You can test the authentication list using the following command

/usr/lib/squid/ncsa_auth /etc/proxyusers

Then enter the username & password when asked

You will see a ERR or OK response
---------------------------------------------------------------------
Auch ich lerne noch ständig dazu!
---------------------------------------------------------------------

Offline David Harper

  • *
  • 653
  • +0/-0
  • Watch this space
    • Workgroup Technology Solutions
Re: Sarg Reports
« Reply #4 on: March 30, 2009, 07:34:07 AM »
lancelet: proxy users works for proxy access, not access to the Sarg reports. The OP talks about "open[ing] the Sarg reports to other users/groups to avoid the [distribution] of the admin password".

Offline compsos

  • *
  • 472
  • +0/-0
Re: Sarg Reports
« Reply #5 on: March 30, 2009, 08:34:57 AM »
Thanks David

Once I put the group in the server-manager link returned
"Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, admin@domainname and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log."

Comment out the require group command and all is OK. The group name is "manager" so will try another just in case of reserved word issue.
« Last Edit: March 30, 2009, 08:42:48 AM by compsos »
Regards

Gordon............

Offline compsos

  • *
  • 472
  • +0/-0
Re: Sarg Reports
« Reply #6 on: March 30, 2009, 08:42:11 AM »
No group name did not make any difference. Add require group and the link failed.

This looks like the best clue
"configuration error:  couldn't check access.  No groups file?: /squid, referer: https://domainname/server-manager/navigation"

I will try on another system and see if I get the same results
Regards

Gordon............

Offline compsos

  • *
  • 472
  • +0/-0
Re: Sarg Reports
« Reply #7 on: March 30, 2009, 09:10:07 AM »
David
It works with a new file
/usr/local/apache/passwd/passwords
containing
GroupName: user1 user2 user3 etc
Regards

Gordon............

Offline David Harper

  • *
  • 653
  • +0/-0
  • Watch this space
    • Workgroup Technology Solutions
Re: Sarg Reports
« Reply #8 on: March 30, 2009, 09:21:07 AM »
Great, glad you sorted it out.

IMHO the ability to add multiple users and/or groups should be added as a feature. If you like, you can file an NFR bug report.

Offline compsos

  • *
  • 472
  • +0/-0
Re: Sarg Reports
« Reply #9 on: March 30, 2009, 09:25:59 AM »
On the overall design of SME would using this password file just be a break in design? I would have thought it should link back to the main password file rather than a new one. There is also another command of require valid_user but that would probably open it up to all local users. Not quite what management are wanting as a background usage review.
Regards

Gordon............

Offline David Harper

  • *
  • 653
  • +0/-0
  • Watch this space
    • Workgroup Technology Solutions
Re: Sarg Reports
« Reply #10 on: March 30, 2009, 09:27:16 AM »
I'm not sure exactly how snoble (smeserver-sarg maintainer) would make it work, but it's probably worth investigating.

Offline stephen noble

  • *
  • 607
  • +1/-0
    • Dungog
Re: Sarg Reports
« Reply #11 on: March 31, 2009, 12:35:34 AM »
Any admin panel can be delegated to selected users with the usermanager

http://www.dungog.net/wiki/Usermanager

Offline David Harper

  • *
  • 653
  • +0/-0
  • Watch this space
    • Workgroup Technology Solutions
Re: Sarg Reports
« Reply #12 on: March 31, 2009, 01:56:19 AM »
Does that work for Sarg too? When I looked at the template I figured the answer was no.

Offline stephen noble

  • *
  • 607
  • +1/-0
    • Dungog
Re: Sarg Reports
« Reply #13 on: March 31, 2009, 02:43:11 AM »
You could be right,
the panels that insert application data into /server-manager and prompt a second time for admin password probably won't work

working out why it prompts again, would be a better fix than working around each panel

Offline David Harper

  • *
  • 653
  • +0/-0
  • Watch this space
    • Workgroup Technology Solutions
Re: Sarg Reports
« Reply #14 on: March 31, 2009, 02:48:32 AM »
Looking at the file referenced earlier (90e-smithAccess20sarg), Sarg is just using a basic 'require' statement.