[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Example of errors

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
..hidden..:~$ createuser -s -P lsadmin
Enter password for new role:
Enter it again:
..hidden..:~$</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
..hidden..:/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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users