sql-ledger-users

[SL] some .pl files dont get found.

[Dieter R. <die...@st...>]

Hi,

I have moved a sqlledger v. 2.4.7 from one server to a different one.
nearly everything seems to work, but if I try for example to change the
address of a company, then my changes get saved in the database, but in
the browser, in the main frame, I get

https://path/to/sql-ledger/ct.pl not found

but when I try to load that file from the browsers address line, then it
is found, and I get the "you are logged out" error.

I dont understand that. What am I missing?

I also tried and upgraded to 2.4.16, but the problem persists.

cu
Dieter

Re: [SL] some .pl files dont get found.

[Rolf S. <in...@to...>]

path/to/sql-ledger/ct.pl is just a gateway script, the file used is 
path/to/sql-ledger/bin/mozilla/ct.pl

Do you get an error message only when you try to save changes of an 
address, or when you click "Update" or "Save as new", too?
Did you try to update to the actual version 2.8.18?

R.

Dieter Ries schrieb:
> Hi,
> 
> I have moved a sqlledger v. 2.4.7 from one server to a different one.
> nearly everything seems to work, but if I try for example to change the
> address of a company, then my changes get saved in the database, but in
> the browser, in the main frame, I get
> 
> https://path/to/sql-ledger/ct.pl not found
> 
> but when I try to load that file from the browsers address line, then it
> is found, and I get the "you are logged out" error.
> 
> I dont understand that. What am I missing?
> 
> I also tried and upgraded to 2.4.16, but the problem persists.
> 
> cu
> Dieter
> 
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] some .pl files dont get found.

[Dieter R. <die...@st...>]

Rolf Stöckli schrieb:
> path/to/sql-ledger/ct.pl is just a gateway script, the file used is 
> path/to/sql-ledger/bin/mozilla/ct.pl

in my case, all those perl scripts,

am.pl
ap.pl
ar.pl
ct.pl
.
.
.

are the same script, no links or something.

and do I need special apache configurations for this bin/mozilla subfolder?

my config is

Alias /sql-ledger /usr/share/sql-ledger/
<Directory /usr/share/sql-ledger>
        AllowOverride All
        AddHandler cgi-script .pl
        Options ExecCGI Includes FollowSymlinks
        Order Allow,Deny
        Allow from All
</Directory>
<Directory "/usr/share/sql-ledger/users">
        Order Deny,Allow
        Deny from All
</Directory>

> 
> Do you get an error message only when you try to save changes of an 
> address, or when you click "Update" or "Save as new", too?
> Did you try to update to the actual version 2.8.18?

There is no "update" or "save as new" button here, but I can create a
new user, that works. and all the changes also work, so the data gets
changed in the db.

I tried upgrading from 2.4.7, which fails with some column "old"
missing. so I wanted to try smaller upgrades and tried 2.4.16 first.

cu
Dieter

> 
> R.
> 
> Dieter Ries schrieb:
>> Hi,
>>
>> I have moved a sqlledger v. 2.4.7 from one server to a different one.
>> nearly everything seems to work, but if I try for example to change the
>> address of a company, then my changes get saved in the database, but in
>> the browser, in the main frame, I get
>>
>> https://path/to/sql-ledger/ct.pl not found
>>
>> but when I try to load that file from the browsers address line, then it
>> is found, and I get the "you are logged out" error.
>>
>> I dont understand that. What am I missing?
>>
>> I also tried and upgraded to 2.4.16, but the problem persists.
>>
>> cu
>> Dieter
>>
>>
>> -------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
>> Build the coolest Linux based applications with Moblin SDK & win great prizes
>> Grand prize is a trip for two to an Open Source event anywhere in the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] some .pl files dont get found.

[Rolf S. <in...@to...>]

Dieter Ries schrieb:
> in my case, all those perl scripts,
> are the same script, no links or something.

The forwarding is done inside these scripts.

> and do I need special apache configurations for this bin/mozilla subfolder?

No. The path is included in the HTTP request.

> There is no "update" or "save as new" button here, but I can create a
> new user, that works. and all the changes also work, so the data gets
> changed in the db.

If you open an existing customer, there are these 2 buttons. If you see 
his address or are able to add a new customer, you are already on ct.pl. 
Add and Update are only subroutines of this script. In this case, the 
problem is that after processing your are not forwarded you to ct.pl 
again. Difficult to say why!

> I tried upgrading from 2.4.7, which fails with some column "old"
> missing. so I wanted to try smaller upgrades and tried 2.4.16 first.

The small steps should be performed automatically. Maybe your db is 
already corrupted now. I suggest to upgrade to 2.8.18, login to Postgres:

"drop database dbname;
create database dbname;
\i backup.sql

when you log in the dataset will be upgraded"
(Dieter Simader, User Forum, 17.10.08)

Gruss aus dem Glarnerland
Rolf

Re: [SL] some .pl files dont get found.

[Dieter R. <die...@st...>]

Rolf Stöckli schrieb:
> If you open an existing customer, there are these 2 buttons. If you see 
> his address or are able to add a new customer, you are already on ct.pl. 
> Add and Update are only subroutines of this script. In this case, the 
> problem is that after processing your are not forwarded you to ct.pl 
> again. Difficult to say why!

OK, I upgraded to 2.6 which worked and fixed the issue.

> 
>> I tried upgrading from 2.4.7, which fails with some column "old"
>> missing. so I wanted to try smaller upgrades and tried 2.4.16 first.
> 
> The small steps should be performed automatically. Maybe your db is 
> already corrupted now. I suggest to upgrade to 2.8.18, login to Postgres:


I tried to upgrade from 2.6.27 to latest 2.8, which fails with:

Upgrading to Version 2.8.18 ...
Error!

insert into temp (aid) select oid from assembly
FEHLER: Spalte »oid« existiert nicht



> 
> "drop database dbname;
> create database dbname;
> \i backup.sql
> 
> when you log in the dataset will be upgraded"
> (Dieter Simader, User Forum, 17.10.08)

how exactly and (more important) with which version should I make that
backup? right now, as I am moving from one server to a new one, I made a
backup with

pg_dump --format=p -c -U postgres <tablename> --file=backup.sql

on the old server, and

psql -U postgres -d tablename -f backup.sql

on the new one.

> 
> Gruss aus dem Glarnerland
> Rolf
> 

cu, Gruss aus Zuerich,

Dieter

> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users