Step by step works, but
It seems either
I type wrong things in config.pl (quite probable) or
some tables are missing (have to be added to the SQL-Ledger database).
PS: I run stock sql 3.03 downloaded and installed from DIeters site.
That is the only part where I did not follow the step by step..
Here is a more extended log from a newly installed debian 6 machine:
[Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Use of
uninitialized value $form{"page"} in string eq at
/usr/local/sql-ledger/ledgercart/index.pl line 59.
[Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Use of
uninitialized value $form{"page"} in string eq at
/usr/local/sql-ledger/ledgercart/index.pl line 59.
[Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Use of
uninitialized value $form{"page"} in string eq at
/usr/local/sql-ledger/ledgercart/index.pl line 59.
[Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Use of
uninitialized value $form{"page"} in string eq at
/usr/local/sql-ledger/ledgercart/index.pl line 59.
[Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Use of
uninitialized value $form{"page"} in string eq at
/usr/local/sql-ledger/ledgercart/index.pl line 59.
[Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Can't call
method "ck_session" on an undefined value at
/usr/local/sql-ledger/ledgercart/index.pl line 79.
[Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Premature end of
script headers: index.pl
[Sun Nov 11 10:53:28 2012] [notice] caught SIGTERM, shutting down
[Sun Nov 11 10:53:29 2012] [notice] Apache/2.2.16 (Debian)
PHP/5.3.3-7+squeeze14 with Suhosin-Patch mod_perl/2.0.4 Perl/v5.10.1
configured -- resuming normal operations
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] "my" variable
$stmt masks earlier declaration in same scope at
/usr/local/sql-ledger/ledgercart/index.pl line 203.
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] "my" variable
$bind masks earlier declaration in same scope at
/usr/local/sql-ledger/ledgercart/index.pl line 203.
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] "my" variable
$stmt masks earlier declaration in same scope at
/usr/local/sql-ledger/ledgercart/index.pl line 206.
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] "my" variable
$bind masks earlier declaration in same scope at
/usr/local/sql-ledger/ledgercart/index.pl line 206.
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Name
"main::allowedpages" used only once: possible typo at
/usr/local/sql-ledger/ledgercart/index.pl line 59.
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR: relation "customerlogin" does not exist
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] LINE 1: SELECT
id, login FROM customerlogin
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1]
^ at User/Simple.pm line 212.
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Table
customerlogin does not exist or has wrong structure at
/usr/local/sql-ledger/ledgercart/index.pl line 40.
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] DBD::Pg::st
execute failed: ERROR: relation "customerlogin" does not exist
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] LINE 2:
session_exp FROM customerlogin
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1]
^ at User/Simple/Admin.pm line 313.
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Table
customerlogin does not exist or has wrong structure at
/usr/local/sql-ledger/ledgercart/index.pl line 41.
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Use
User::Simple::Admin->create_db_structure first. at
/usr/local/sql-ledger/ledgercart/index.pl line 41.
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Use of
uninitialized value $form{"action"} in substr at
/usr/local/sql-ledger/ledgercart/index.pl line 51.
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Use of
uninitialized value $form{"page"} in string eq at
/usr/local/sql-ledger/ledgercart/index.pl line 59.
[Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Use of
uninitialized value $form{"page"} in string eq at
/usr/local/sql-ledger/ledgercart/index.pl line 59.
Same errors come up on my VPS, which is Ubuntu but also runnig fine.
Upside: SQL-ledger on bith systems work, and I now know that if needed
I can build a machine from scratch and have a restored SQL up and
runnig inside of 4 hours.
Nice to know..
2012/11/10, Paul Tammes <[email protected]>:
> Thanks a whole lot, with your guide I managed to get my own VPS at least
> partly running.
> The other way round I just proved that I can break a running SQL-Ledger
> system any day by installing the File::Basename from 5.17 beta development
> version.
> Luckily, that is not needed at all it seems, at least your notes did not
> mention it and I get it to kind of run.
> That is a lot more than I managed alone..
>
> However, i get an error screen and
>
> Use of uninitialized value $form{"page"} in string eq at
> /usr/local/sql-ledger/ledgercart/index.pl line 59
>
> in the apache logfiles when trying to hit
>
> http://localhost/ledgercart/
>
> Any hints?
>
> /ledgercart is aliased just like /sql-ledger, and that one works ..
>
> Thanks,
>
> Paul
>
> 2012/11/10 Sebastian Weitmann <[email protected]>
>
>> **
>> Hi Paul,
>>
>> I successfully installed LegerCart on Debian Squeeze (6.0) and wrote a
>> small step by step guide here:
>>
>>
>> http://www.sql-ledger-network.com/wiki/doku.php/ledgercart_step_by_step_installation/debian
>>
>> You will also need to install SQL-Ledger and can find the step by step
>> guide for this here:
>>
>>
>> http://www.sql-ledger-network.com/wiki/doku.php/step_by_step_installation/debian
>>
>> Good luck and feel free to contact me if you get stuck and need someone
>> to
>> talk to ;)
>>
>> Regards,
>> Sebastian
>>
>>
>>
>>
>>
>>
>> On Sat, 2012-11-10 at 07:25 +0100, Paul Tammes wrote:
>>
>> I am not a developer, but if you are on ubuntu 10, Perl 5.17 is not
>> the standard there.
>> And one of the modules you listed required 5.17.
>> File::Basename was the one iirc.
>>
>> For people in the know an upgrade inside any distro of perl to a
>> beta-version may be a piece of cake.
>> My guess is that I was able to break things doing just that.
>>
>> Will use this weekend to test on a stand-alone spare machine, will
>> post any results later.
>> I hope to be able to run and install myself, mainly a question of hurt
>> pride.
>> When I run a system and software I want to be able to tweak it myself.
>> I am not a great fan of remote sysops, I rather figure it out myself.
>> May take (much) longer though.
>> But if all else fails I might mail you with a remote login all the
>> same, thanks for the offer.
>>
>> Just thought I'd mention my problems to prevent other
>> non-prefessionals from breaking their running SQL-installs.
>> Might be awkward if you want to send invoices or process sales orders..
>>
>> Cheers,
>>
>> Paul
>> > Not sure what could be wrong. LedgerCart works fine on Ubuntu 10.04
>> > and I have not tried on Ubuntu 12.04. If you still can't do it, I can
>> > login to your server and set it up for you and see what went wrong.
>> >
>> > I am hoping to get a virtual appliance out with everything configured.
>> > This will be announced via SLNA Platform/forum here
>> > http://www.sql-ledger-network.com/forum/
>> >
>> > Regards
>> > _______________________________________________
>> > SQL-Ledger mailing list
>> > [email protected]
>> > http://lists.ledger123.com/mailman/listinfo/sql-ledger
>> _______________________________________________
>> SQL-Ledger mailing
>> [email protected]http://lists.ledger123.com/mailman/listinfo/sql-ledger
>>
>>
>> _______________________________________________
>> SQL-Ledger mailing list
>> [email protected]
>> http://lists.ledger123.com/mailman/listinfo/sql-ledger
>>
>>
>
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
