Hi,
I've just carried out a clean install - I initially tried (by mistake)
to login to a database called test1 - and then I logged in to setup.pl
and created two databases - fpl2 and fpl2training.
There seems to be quite a few errors in the Apache error.log - thought
I'd post them here for reference:
[Wed Oct 17 12:16:03 2012] [notice] SIGHUP received. Attempting to restart
[Wed Oct 17 12:16:03 2012] [notice] Apache/2.2.16 (Debian) configured --
resuming normal operations
[Wed Oct 17 12:18:01 2012] [error] [client 83.105.30.67] File does not
exist: /var/www/favicon.ico
[Wed Oct 17 12:18:08 2012] [error] [client 83.105.30.67] client denied
by server configuration: /home/ledgersmb/web/
[Wed Oct 17 12:18:08 2012] [error] [client 83.105.30.67] File does not
exist: /var/www/favicon.ico
[Wed Oct 17 12:19:10 2012] [notice] SIGHUP received. Attempting to restart
[Wed Oct 17 12:19:10 2012] [notice] Apache/2.2.16 (Debian) configured --
resuming normal operations
[Wed Oct 17 12:19:14 2012] [notice] SIGHUP received. Attempting to restart
[Wed Oct 17 12:19:14 2012] [notice] Apache/2.2.16 (Debian) configured --
resuming normal operations
Wed Oct 17 12:19:18 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=0
Use of uninitialized value $msg_plus in concatenation (.) or string at
LedgerSMB/Auth.pm line 79.
DBI connect('dbname=test1','',...) failed: fe_sendauth: no password
supplied at LedgerSMB.pm line 986
DBI connect('dbname=test1','lsadmin',...) failed: FATAL: database
"test1" does not exist at LedgerSMB.pm line 986
Use of uninitialized value $msg_plus in concatenation (.) or string at
LedgerSMB/Auth.pm line 79.
DBI connect('dbname=template1','',...) failed: fe_sendauth: no password
supplied at LedgerSMB.pm line 986
DBI connect('dbname=fpl2','lsadmin',...) failed: FATAL: database "fpl2"
does not exist at LedgerSMB/Database.pm line 287
2012/10/17 12:22:46 - INFO - LedgerSMB::Scripts::setup::create_db --
create_and_load rc=1
commit ineffective with AutoCommit enabled at
LedgerSMB/DBObject/Employee.pm line 107.
commit ineffective with AutoCommit enabled at
LedgerSMB/DBObject/Admin.pm line 101.
commit ineffective with AutoCommit enabled at scripts/setup.pl line 788.
Use of uninitialized value $msg_plus in concatenation (.) or string at
LedgerSMB/Auth.pm line 79.
DBI connect('dbname=fpl2','',...) failed: fe_sendauth: no password
supplied at LedgerSMB.pm line 986
Use of uninitialized value $msg_plus in concatenation (.) or string at
LedgerSMB/Auth.pm line 79.
DBI connect('dbname=template1','',...) failed: fe_sendauth: no password
supplied at LedgerSMB.pm line 986
DBI connect('dbname=fpl2training','lsadmin',...) failed: FATAL:
database "fpl2training" does not exist at LedgerSMB/Database.pm line 287
2012/10/17 12:25:50 - INFO - LedgerSMB::Scripts::setup::create_db --
create_and_load rc=1
commit ineffective with AutoCommit enabled at
LedgerSMB/DBObject/Employee.pm line 107.
commit ineffective with AutoCommit enabled at
LedgerSMB/DBObject/Admin.pm line 101.
commit ineffective with AutoCommit enabled at scripts/setup.pl line 788.
Use of uninitialized value $msg_plus in concatenation (.) or string at
LedgerSMB/Auth.pm line 79.
DBI connect('dbname=fpl2training','',...) failed: fe_sendauth: no
password supplied at LedgerSMB.pm line 986
Use of uninitialized value $msg_plus in concatenation (.) or string at
LedgerSMB/Auth.pm line 79.
DBI connect('dbname=fpl2','',...) failed: fe_sendauth: no password
supplied at LedgerSMB.pm line 986
Use of uninitialized value $msg_plus in concatenation (.) or string at
LedgerSMB/Auth.pm line 79.
DBI connect('dbname=fpl2','',...) failed: fe_sendauth: no password
supplied at LedgerSMB.pm line 986
Use of uninitialized value $msg_plus in concatenation (.) or string at
LedgerSMB/Auth.pm line 79.
DBI connect('dbname=fpl2training','',...) failed: fe_sendauth: no
password supplied at LedgerSMB.pm line 986
Have lsmb_fpl2__account_all
Have lsmb_fpl2__account_create
Have lsmb_fpl2__account_edit
Have lsmb_fpl2__ap_all
Have lsmb_fpl2__ap_all_transactions
On 17/10/12 12:48, Kevin Bailey wrote:
> Here are the instructions I've put together for installing LS on a new
> Debian squeeze install:
>
> ---++ Set up of ledgersmb
>
> ---+++ Get ledgersmb files
>
> As this was to be installed as a website outside of the packaging system
> a new user account called ledgersmb was created to hold the website files.
>
> <verbatim>
> $ cd ~
> $ wget
> http://downloads.sourceforge.net/project/ledger-smb/ledgersmb/1.3.23/ledgersmb-1.3.23.tar.gz
> $ tar -xvzf ledgersmb-1.3.23.tar.gz
> $ mv ledgersmb-1.3.23 web
> </verbatim>
>
> So, the files of ledgersmb are now in /home/ledgersmb/web
>
> ---+++ Install base packages
>
> <verbatim>
> # apt-get install apache2
> # apt-get install postgresql postgresql-client postgresql-contrib
> </verbatim>
>
> NB - This is different from the LedgerSMB INSTALL file which says to
> install postgresql-server.
>
> ---+++ Set up smbledger database admin user
>
> <verbatim>
> # su - postgres
> postgres@whizzer2:~$ createuser -s -P lsadmin
> Enter password for new role:
> Enter it again:
> postgres@whizzer2:~$</verbatim>
> </verbatim>
>
> The default set up of pg_hba.conf on Postgresql on Debian means that
> accounts are already set to authenticate via md5.
>
> ---+++ Install extra packages required by LedgerSMB
>
> Here we will install all perl packages that we can from Debian archive
> so that we don't need to get many from cpan.
>
> =apt-get install libdatetime-perl libdbi-perl libdbd-pg-perl
> libcgi-simple-perl libtemplate-perl libconfig-std-perl libmime-lite-perl
> liberror-perl liblocale-maketext-lexicon-perl libtest-exception-perl
> libtest-trap-perl liblog-log4perl-perl libmath-bigint-gmp-perl
> libfile-mimeinfo-perl=
>
> We also need extra packages to be able to create PDF files.
>
> =apt-get install texlive-latex-recommended=
>
> NB - This will install quite a few packages.
>
> This package may also be needed so it is good to install it now.
>
> =apt-get install libxml-twig-perl=
>
> Now we need to use the built-in perl package checker and downloader.
>
> Before running the command it is necessary to install the following
> package to allow the 'perl Makefile.PL' command to work:
>
> =sudo apt-get install libmodule-install-perl=
>
> Then - we will run LedgerSMB's own script to check all necessary perl
> libriaries are available. As root cd into the base directory
> (/home/ledgersmb/web) and then run:
>
> =perl Makefile.PL=
>
> Which gives output and at the end of the output we have:
> <verbatim>
> ...
> ==> Auto-install the 1 mandatory module(s) from CPAN? [y]
> [Size detection for images for embedding in LaTeX templates]
> - Image::Size ...missing.
> ==> Auto-install the 1 optional module(s) from CPAN? [n] y
> [POS module credit card processing support]
> - Net::TCLink ...missing.
> ==> Auto-install the 1 optional module(s) from CPAN? [n] y
> [Experimental scripting engine]
> - Parse::RecDescent ...missing.
> ==> Auto-install the 1 optional module(s) from CPAN? [n]
> [Developer tool dependencies]
> - Getopt::Long ...loaded. (2.38)
> - FileHandle ...loaded. (2.02)
> - Locale::Country ...loaded. (2.07)
> - Locale::Language ...loaded. (2.07)
> [PDF and Postscript output]
> - Template::Plugin::Latex ...missing. (would need 1)
> ==> Auto-install the 1 optional module(s) from CPAN? [n] y
> [OpenOffice.org output]
> - XML::Twig ...loaded. (3.34)
> - OpenOffice::OODoc ...missing.
> ==> Auto-install the 1 optional module(s) from CPAN? [n] y
> *** Dependencies will be installed the next time you type 'make'.
> *** Module::AutoInstall configuration finished.
> include inc/Module/Install/WriteAll.pm
> include inc/Module/Install/Win32.pm
> include inc/Module/Install/Can.pm
> include inc/Module/Install/Fetch.pm
> Warning: prerequisite IO::Scalar 0 not found.
> Warning: prerequisite Image::Size 0 not found.
> Warning: prerequisite Net::TCLink 0 not found.
> Warning: prerequisite OpenOffice::OODoc 0 not found.
> Warning: prerequisite Template::Plugin::Latex 1 not found.
> Writing Makefile for LedgerSMB
> Writing META.yml
> root@whizzer2:/home/ledgersmb/web#</verbatim>
>
> Not currently sure as whether or not to run 'make install' as per the
> INSTALL file. Need to confirm with Chris Travers if this is needed.
>
> Now - this is not in the INSTALL file - and we're guessing a bit here -
> but we're going to copy ledgersmb.conf.default to ledgersmb.conf and
> then edit the contrib_dir configuration to point to
> /usr/share/postgresql/8.4/contrib as this is where it looks like the
> contrib files are located.
>
> ---+++ Setting up Apache
>
> Now we need to set up the Apache configuration. We have used a standard
> Apache2 installation and if Apache ITK is used then the instructions may
> need to be different.
>
> =cp ledgersmb-httpd.conf.template /etc/apache2/conf.d/ledgersmb-httpd.conf=
>
> Then edit this file and change WORKING_DIR to the base directory of the
> ledgersmb files.
>
> Also, if it is needed to access LS from other machines the lines about
> allowing only from localhost/127.0.0.1 and changed to 'Allow from All'.
>
> <verbatim>
> # 17/10/2012 - kbailey
> # Allow from 127.0.0.1
> # Allow from localhost
> Allow from All
> </verbatim>
>
> Need to enable the mod_rewrite module for Apache:
>
> <verbatim>
> # a2enmod rewrite
> # apache2ctl restart
> </verbatim>
>
> ---+++ Set up databases
>
> It should be possible to access:
>
> http://servername/ledgersmb/setup.pl
>
> And login with the Postgresql user created previously and create new
> databases etc.
>
>
>
>
>
>
> Hope these are of use.
>
> Kevin Bailey
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_sfd2d_oct
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_sfd2d_oct
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
