From cf607d93557a99ac40de7a530946e3b9ed8c1bd9 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Sat, 2 Sep 2006 06:02:02 +0000 Subject: Removed more references to SQL-Ledger. Added open source manual to documentation directory. Removed references to SQL-Ledger's website and documentation structure. Updated links to Windows builds of DBD::Pg modules. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@15 4979c152-3d1c-0410-bac9-87ea11338e46 --- doc/faq.html | 95 +++++++++++++++++------------------------------------------- 1 file changed, 26 insertions(+), 69 deletions(-) (limited to 'doc/faq.html') diff --git a/doc/faq.html b/doc/faq.html index ff0999ab..e8fc9436 100755 --- a/doc/faq.html +++ b/doc/faq.html @@ -192,28 +192,28 @@ read the interactive documentation for procedural languages. -

  • The requested URL /sql-ledger/admin.pl was not found

    +

  • The requested URL /ledger-smb/admin.pl was not found

    Your webserver doesn't know where to find the script. Most commonly this is from distributions hiding webserver configuration files in different locations or files and setup.pl wasn't able to configure the location for you. Find out which file (httpd.conf, httpdcommon.conf, ...) controls your webserver configuration and add
    -  # SQL-Ledger
    -  Include /etc/httpd/sql-ledger-httpd.conf
    + # LedgerSMB + Include /etc/httpd/ledger-smb-httpd.conf -Create a file 'sql-ledger-httpd.conf' in /etc/httpd and copy the next part +Create a file 'ledger-smb-httpd.conf' in /etc/httpd and copy the next part into the file.
       AddHandler cgi-script .pl
       AddDefaultCharset On
    -  Alias /sql-ledger /var/www/sql-ledger/
    -  <Directory /var/www/sql-ledger>
    +  Alias /ledger-smb /var/www/ledger-smb/
    +  <Directory /var/www/ledger-smb>
         Options ExecCGI Includes FollowSymlinks
       </Directory>
     
    -  <Directory /var/www/sql-ledger/users>
    +  <Directory /var/www/ledger-smb/users>
         Order Deny,Allow
         Deny from All
       </Directory>
    @@ -251,11 +251,11 @@ SL/Form.pm and change the number (44) on line 84. } -

  • IDENT Authentication failed for user "sql-ledger"

    +

  • IDENT Authentication failed for user "sledger-smb"

    Edit pg_hba.conf and change authentication to
    -  local           all        all           trust
    + local all all MD5 The file is in the 'data' directory of your postgresql installation. This is different with every distribution so look for it. @@ -307,11 +307,11 @@ Unfortunately with all that power there is also a steep learning curve.

  • W3M

    pass terminal=mozilla when you start w3m
    -  $ w3m -F http://localhost/sql-ledger/login.pl?terminal=mozilla
    + $ w3m -F http://localhost/ledger-smb/login.pl?terminal=mozilla To use without frames
    -  $ w3m http://localhost/sql-ledger/login.pl?terminal=lynx
    + $ w3m http://localhost/ledger-smb/login.pl?terminal=lynx

  • PDF option disappeared

    Edit ledger-smb.conf and set $latex = 1; @@ -325,16 +325,17 @@ the internal defaults are used which turn off $latex, hence no PDF option. or Oracle, DBI and the appropriate DBD module
    if you can't compile DBD-Pg here is a precompiled -DBD-Pg module -
  • download the latest version of SQL-Ledger -
  • extract the files to c:\apache\sql-ledger +DBD-Pg module +
  • download the latest version of LedgerSMB +
  • extract the files to c:\apache\ledger-smb
  • run 'perl shebang' to change the first line of the scripts. If perl is not in c:\perl\bin' change '#!c:\\perl\\bin\\perl' to the location where your perl binary is.
  • edit c:\apache\conf\httpd.conf and add
    -Alias /sql-ledger "c:/apache/sql-ledger/"
    -<Directory "c:/apache/sql-ledger">
    +Alias /ledger-smb "c:/apache/ledger-smb/"
    +<Directory "c:/apache/ledger-smb">
       AllowOverride All
       AddHandler cgi-script .pl
       AddDefaultCharset On
    @@ -343,7 +344,7 @@ Alias /sql-ledger "c:/apache/sql-ledger/"
       Allow from All
     </Directory>
     
    -<Directory "c:/apache/sql-ledger/users">
    +<Directory "c:/apache/ledger-smb/users">
       Order Deny,Allow
       Deny from All
     </Directory>
    @@ -351,51 +352,12 @@ Alias /sql-ledger "c:/apache/sql-ledger/"
     
     
  • start Apache
  • start Postgres|Oracle|DB2 -
  • connect to http://localhost/sql-ledger/admin.pl and set up users +
  • connect to http://localhost/ledger-smb/admin.pl and set up users and datasets -
  • connect to http://localhost/sql-ledger/login.pl and login +
  • connect to http://localhost/ledger-smb/login.pl and login -

  • Installation on Windows /w cygwin

    -
      -
    • install cygwin -Apache, perl, postgres, gcc and lynx -
    • install DBI -
    • tar zxvf DBI-1.30.tar.gz -
    • cd DBI-1.30 -
    • perl Makefile.PL -
    • make install -
    • install DBD-Pg -
    • tar -zxvf DBD-Pg-1.13.tar.gz -
    • export POSTGRES_INCLUDE=/usr/include/postgresql -
    • export POSTGRES_LIB=/usr/lib/postgresql -
    • cd DBD-Pg-1.13 -
    • perl Makefile.PL -
    • make install -
    • edit /etc/apache/httpd.conf and add -
      -AddHandler cgi-script .pl
      -AddDefaultCharset On
      -Alias /sql-ledger /var/www/sql-ledger/
      -<Directory /var/www/sql-ledger>
      -  Options +ExecCGI
      -</Directory>
      -
      -<Directory /var/www/sql-ledger/users>
      -  Order Deny,Allow
      -  Deny from All
      -</Directory>
      -
      -
    • install SQL-Ledger -
    • cd /var/www -
    • mkdir sql-ledger -
    • download setup.pl and save the file -in /var/www/sql-ledger -
    • cd /var/www/sql-ledger -
    • perl setup.pl -
    -

  • What do I enter for the language

    If you use English, nothing, if you want to use a foreign language for the login screen and admin stuff enter the language code, this is the @@ -516,11 +478,6 @@ assembly you simply return the parts to inventory by entering a negative quantity for the number of assemblies to stock. -

  • customizing SQL-Ledger

    -The application interface -consists of a global and private interface. - -

  • DBD-Pg not installed

    Most modern distributions now package DBD-Pg. If it is @@ -570,7 +527,7 @@ in your httpd.conf file. the frontend script couldn't figure out which browser you are using

    include the terminal variable on the URL

    -  http://localhost/sql-ledger/login.pl?terminal=lynx
    + http://localhost/ledger-smb/login.pl?terminal=lynx
  • Valid terminal variables are lynx, mozilla and js @@ -600,7 +557,7 @@ access tables owned by joe. Enable Includes and FollowSymlinks Options in your httpd.conf file
    -  <Directory /usr/local/sql-ledger>
    +  <Directory /usr/local/ledger-smb>
         Options ExecCGI Includes FollowSymlinks
       </Directory>
     
    @@ -654,15 +611,15 @@ SQL server. Typical setups: /usr/local/vh/www <- DocumentRoot for virtual host - /usr/local/vh/sql-ledger <- Alias for sql-ledger + /usr/local/vh/ledger-smb <- Alias for ledger-smb /usr/local/vh/users <- users directory out of reach
    /usr/local/vh/www <- DocumentRoot for virtual host - /usr/local/vh/www/sql-ledger <- Alias for sql-ledger - /usr/local/vh/www/sql-ledger/users <- users configuration files and tmp space + /usr/local/vh/www/ledger-smb <- Alias for ledger-smb + /usr/local/vh/www/ledger-smb/users <- users configuration files and tmp space - <Directory /usr/local/vh/www/sql-ledger/users> <- disable webserver access + <Directory /usr/local/vh/www/ledger-smb/users> <- disable webserver access Order Deny,Allow for users directory Deny from All </Directory> -- cgit v1.2.3