sql-ledger-users

[SL] Access Denied

[Rich S. <rsh...@ap...>]

   This has me completely puzzled, and I need to run payables since it's the
beginning of the month.

   When I try to log in to SL-2.6.23 I am denied access. Just about a week
ago -- January 23rd -- I had access problems after a system upgrade and that
was tracked down to a perl module built against an obsolete library. My last
message to the thread reported the problem was solved and that I could once
again log in.

   I've not used the application since then. Nor have I made any changes to
apache, postgres, or anything else.

   /var/log/apache/access_log shows the latest attempt:

127.0.0.1 - - [01/Feb/2007:18:16:21 -0800] "POST /sql-ledger/login.pl
HTTP/1.1" 200 311

   /var/log/apache/error_log reports nothing.

   httpd and postmaster are running processes; I restarted both.

   What have I missed? If there's nothing in the httpd error log I've no idea
why I see the page that shows, "Error! Access denied."

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Access Denied

[Rich S. <rsh...@ap...>]

On Thu, 1 Feb 2007, Rich Shepard wrote:

>   What have I missed? If there's nothing in the httpd error log I've no idea
> why I see the page that shows, "Error! Access denied."

   I've also searched through the mail list archives through last June
without seeing anything relevant.

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Access Denied

[Paul T. <pt...@wa...>]

Rich Shepard schreef:
> On Thu, 1 Feb 2007, Rich Shepard wrote:
>
>   
>>   What have I missed? If there's nothing in the httpd error log I've no idea
>> why I see the page that shows, "Error! Access denied."
>>     
>
>    I've also searched through the mail list archives through last June
> without seeing anything relevant.
>
> Rich
>
>   
did you try to use /admin.pl instead of just getting barred? Might be a 
default set to something unpractical after upgrade.
Not nice, but it has happened before..

Re: [SL] Access Denied -- RESOLVED

[Rich S. <rsh...@ap...>]

On Fri, 2 Feb 2007, Paul Tammes wrote:

> did you try to use /admin.pl instead of just getting barred? Might be a
> default set to something unpractical after upgrade. Not nice, but it has
> happened before..

Paul,

   No, but I fixed the problem. For reasons I do not know, the ownerships and
permissions were incorrect. I suspected this was the case, but the fact that
I was able to log in to the upgraded system threw me. I suspect that I was
able to do so because firefox cached the information and obfuscated the
ownership/permission changes.

   The other puzzling part is that with all the upgrades I've done over the
past three or four years, this was the first time there were ownership or
permission issues. In the past I untarred the tarball in /usr/local/ and
immediately logged in to check. It always worked.

   Anyway, I will be more aware of changes at the next upgrade.

Thank you,

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Access Denied

[Paul B. <pa...@jp...>]

I know it's a silly point but you have made sure that the postgres config
file wasn't over written in the upgrade??

Additionally I have also had SL lock the database after an upgrade so login
as admin and check that the data isnt locked.

Hope it helps 

Paul 

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of Rich
Shepard
Sent: 02 February 2007 02:25
To: sql...@li...
Subject: [SL] Access Denied

   This has me completely puzzled, and I need to run payables since it's the
beginning of the month.

   When I try to log in to SL-2.6.23 I am denied access. Just about a week
ago -- January 23rd -- I had access problems after a system upgrade and that
was tracked down to a perl module built against an obsolete library. My last
message to the thread reported the problem was solved and that I could once
again log in.

   I've not used the application since then. Nor have I made any changes to
apache, postgres, or anything else.

   /var/log/apache/access_log shows the latest attempt:

127.0.0.1 - - [01/Feb/2007:18:16:21 -0800] "POST /sql-ledger/login.pl
HTTP/1.1" 200 311

   /var/log/apache/error_log reports nothing.

   httpd and postmaster are running processes; I restarted both.

   What have I missed? If there's nothing in the httpd error log I've no
idea why I see the page that shows, "Error! Access denied."

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users