sql-ledger-users

[SL] Admin.pl Error In SL 2.8.10

[Luke <sl...@li...>]

I took this to Deiter, but his best advice was that I get a support 
contract, which I can not currently afford to do. We are evaluating 
TinyERP, and I may end up just switching to that; but I figured I would 
give SL one last try, given the new features and such.

I am experiencing the following problem with the admin section of SL 
2.8.10:

When I am logged into admin.pl, and I attempt to add or delete a user, the 
http connection hangs until it times out (several minutes), and I am 
presented with a 500 internal server error.

The Apache2 logs say nothing.  I have tried Postgresql versions 8.2 and 
8.1.

I recently upgraded from 2.6.8, by doing a progressive upgrade through the 
intermediary versions.

While doing this, I ran into an error about a missing function which the 
upgrade script was trying to drop.  Several of them actually, as I removed 
one from the SQL file, another would come up.  Same for some other 
attempts to drop triggers, a problem which the lock/unlock solution 
wouldn't solve.  The upgrade was seemingly successful after I 
removed the things that had already been dropped.

I don't know if this is some how causing my problem now, but any advice 
would be appreciated.

Regards,

Luke

Re: [SL] Admin.pl Error In SL 2.8.10

[Michael H. <mh...@it...>]

I believe there are some issues w/PGSQL 8...?




On Jan 1, 2008, at 11:47 AM, Luke wrote:

> I took this to Deiter, but his best advice was that I get a support
> contract, which I can not currently afford to do. We are evaluating
> TinyERP, and I may end up just switching to that; but I figured I  
> would
> give SL one last try, given the new features and such.
>
> I am experiencing the following problem with the admin section of SL
> 2.8.10:
>
> When I am logged into admin.pl, and I attempt to add or delete a  
> user, the
> http connection hangs until it times out (several minutes), and I am
> presented with a 500 internal server error.
>
> The Apache2 logs say nothing.  I have tried Postgresql versions 8.2  
> and
> 8.1.
>
> I recently upgraded from 2.6.8, by doing a progressive upgrade  
> through the
> intermediary versions.
>
> While doing this, I ran into an error about a missing function  
> which the
> upgrade script was trying to drop.  Several of them actually, as I  
> removed
> one from the SQL file, another would come up.  Same for some other
> attempts to drop triggers, a problem which the lock/unlock solution
> wouldn't solve.  The upgrade was seemingly successful after I
> removed the things that had already been dropped.
>
> I don't know if this is some how causing my problem now, but any  
> advice
> would be appreciated.
>
> Regards,
>
> Luke
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Admin.pl Error In SL 2.8.10

[Luke <sl...@li...>]

It was working fine with 8.1, and started doing this under 8.1.


On Wed, 2 Jan 2008, Michael Hasse wrote:

> I believe there are some issues w/PGSQL 8...?
> 
> 
> 
> 
> On Jan 1, 2008, at 11:47 AM, Luke wrote:
> 
> > I took this to Deiter, but his best advice was that I get a support
> > contract, which I can not currently afford to do. We are evaluating
> > TinyERP, and I may end up just switching to that; but I figured I  
> > would
> > give SL one last try, given the new features and such.
> >
> > I am experiencing the following problem with the admin section of SL
> > 2.8.10:
> >
> > When I am logged into admin.pl, and I attempt to add or delete a  
> > user, the
> > http connection hangs until it times out (several minutes), and I am
> > presented with a 500 internal server error.
> >
> > The Apache2 logs say nothing.  I have tried Postgresql versions 8.2  
> > and
> > 8.1.
> >
> > I recently upgraded from 2.6.8, by doing a progressive upgrade  
> > through the
> > intermediary versions.
> >
> > While doing this, I ran into an error about a missing function  
> > which the
> > upgrade script was trying to drop.  Several of them actually, as I  
> > removed
> > one from the SQL file, another would come up.  Same for some other
> > attempts to drop triggers, a problem which the lock/unlock solution
> > wouldn't solve.  The upgrade was seemingly successful after I
> > removed the things that had already been dropped.
> >
> > I don't know if this is some how causing my problem now, but any  
> > advice
> > would be appreciated.
> >
> > Regards,
> >
> > Luke
> >
> > ---------------------------------------------------------------------- 
> > ---
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2005.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 

Re: [SL] Admin.pl Error In SL 2.8.10

[Armaghan S. <sa...@le...>]

Luke wrote:
> When I am logged into admin.pl, and I attempt to add or delete a user, the 
> http connection hangs until it times out (several minutes), and I am 
> presented with a 500 internal server error.
>
> The Apache2 logs say nothing.  I have tried Postgresql versions 8.2 and 
> 8.1.
>   
Are other things working fine? Can you login and run the application 
using previously created users etc.
> I recently upgraded from 2.6.8, by doing a progressive upgrade through the 
> intermediary versions.
>
> While doing this, I ran into an error about a missing function which the 
> upgrade script was trying to drop.  Several of them actually, as I removed 
> one from the SQL file, another would come up.  Same for some other 
> attempts to drop triggers, a problem which the lock/unlock solution 
> wouldn't solve.  The upgrade was seemingly successful after I 
> removed the things that had already been dropped.
>
> I don't know if this is some how causing my problem now, but any advice 
> would be appreciated.
This missing procedures error can be some upgrade bug and can be ignored 
in my experience. The latest sql-ledger version does not install/use 
server side procedures (like procedures and triggers). Everything is now 
handled through the application. (so you dont need plpgsql in the 
database now).

Regards

--
Armaghan Saqib

SQL-Ledger Hosting - Reliable, fast, secure
http://www.ledger123.com/

Re: [SL] Admin.pl Error In SL 2.8.10

[Luke <sl...@li...>]

On Thu, 10 Jan 2008, Armaghan Saqib wrote:

> Luke wrote:
> > When I am logged into admin.pl, and I attempt to add or delete a user, the 
> > http connection hangs until it times out (several minutes), and I am 
> > presented with a 500 internal server error.
> >
> > The Apache2 logs say nothing.  I have tried Postgresql versions 8.2 and 
> > 8.1.
> >   
> Are other things working fine? Can you login and run the application 
> using previously created users etc.

Yes.

Luke

Re: [SL] Admin.pl Error In SL 2.8.10

[Armaghan S. <sa...@le...>]

Luke wrote:
> When I am logged into admin.pl, and I attempt to add or delete a user, 
> the http connection hangs until it times out (several minutes), and I 
> am presented with a 500 internal server error.
>
> The Apache2 logs say nothing.  I have tried Postgresql versions 8.2 
> and 8.1.
>   
Are other things working fine? Can you login and run the application 
using previously created users etc.
> I recently upgraded from 2.6.8, by doing a progressive upgrade through 
> the intermediary versions.
>
> While doing this, I ran into an error about a missing function which 
> the upgrade script was trying to drop.  Several of them actually, as I 
> removed one from the SQL file, another would come up.  Same for some 
> other attempts to drop triggers, a problem which the lock/unlock 
> solution wouldn't solve.  The upgrade was seemingly successful after I 
> removed the things that had already been dropped.
>
> I don't know if this is some how causing my problem now, but any 
> advice would be appreciated.
This missing procedures error can be some upgrade bug and can be ignored 
in my experience. The latest sql-ledger version does not install/use 
server side procedures (like procedures and triggers). Everything is now 
handled through the application. (so you dont need plpgsql in the 
database now).

Regards

-- 
Armaghan Saqib

SQL-Ledger Hosting - Reliable, fast, secure
http://www.ledger123.com/

Re: [SL] Admin.pl Error In SL 2.8.10

[Luke <sl...@li...>]

On Thu, 10 Jan 2008, Armaghan Saqib wrote:

> Luke wrote:
> > When I am logged into admin.pl, and I attempt to add or delete a user, 
> > the http connection hangs until it times out (several minutes), and I 
> > am presented with a 500 internal server error.
> >
> > The Apache2 logs say nothing.  I have tried Postgresql versions 8.2 
> > and 8.1.
> >   
> Are other things working fine? Can you login and run the application 
> using previously created users etc.

All other things appear to be working.

Luke

Re: [SL] Admin.pl Error In SL 2.8.10

[Armaghan S. <sa...@le...>]

Can apache has write permission to "users" and "templates" folder and
"members" files withing the user folder?

-- 
Purpose-built SQL-Ledger Hosting
http://www.ledger123.com/

Free trial available.
--

On 1/18/08, Luke <sl...@li...> wrote:
> On Thu, 10 Jan 2008, Armaghan Saqib wrote:
>
> > Luke wrote:
> > > When I am logged into admin.pl, and I attempt to add or delete a user,
> > > the http connection hangs until it times out (several minutes), and I
> > > am presented with a 500 internal server error.
> > >
> > > The Apache2 logs say nothing.  I have tried Postgresql versions 8.2
> > > and 8.1.
> > >
> > Are other things working fine? Can you login and run the application
> > using previously created users etc.
>
> All other things appear to be working.
>
> Luke

Re: [SL] Admin.pl Error In SL 2.8.10

[Luke <sl...@li...>]

Yes.  However, I noticed something which might be of interest: both of 
those directories are set read, write, execute for owner, and execute only 
for group and all.

Is that the intended permission set?  (0711)

Luke

 On Fri, 18 Jan 2008, Armaghan Saqib wrote:

> Can apache has write permission to "users" and "templates" folder and
> "members" files withing the user folder?
> 
> 

Re: [SL] Admin.pl Error In SL 2.8.10

[Armaghan S. <sa...@le...>]

> > Can apache has write permission to "users" and "templates" folder and
> > "members" files withing the user folder?
> >
>
> Yes.  However, I noticed something which might be of interest: both of
> those directories are set read, write, execute for owner, and execute only
> for group and all.
>
> Is that the intended permission set?  (0711)
>
If the files/folders are owned by apache, than these are correct.
Otherwise you can try setting them to 0777 and add a new user and let
us know what happened.