summaryrefslogtreecommitdiff
path: root/doc
diff options
context:
space:
mode:
Diffstat (limited to 'doc')
-rwxr-xr-xdoc/faq.html421
1 files changed, 29 insertions, 392 deletions
diff --git a/doc/faq.html b/doc/faq.html
index 1e3c3fb8..9ccee91f 100755
--- a/doc/faq.html
+++ b/doc/faq.html
@@ -37,83 +37,7 @@ Unfortunately, since this problem involves information loss, no
solution can be automated without invalidating your accounting
information. </li></p>
-<p><li><h4>Restoring old SQL-Ledger backups</h4>
-PostgreSQL added a restriction in v8.x that a sequence cannot be dropped
-after if it is referenced by a table. However backups created with
-SQL-Ledger v2.6.13 and earlier have a DROP SEQUENCE step in the backup
-which will fail. To fix this edit the backup before restoring on a 8.x
-system.
-
-<p>This typically looks like this:
-<pre>
-DROP SEQUENCE id ;
-CREATE SEQUENCE id START 10579;
---
-DROP SEQUENCE invoiceid ;
-CREATE SEQUENCE invoiceid START 11096;
---
-DROP SEQUENCE orderitemsid ;
-CREATE SEQUENCE orderitemsid START 178;
---
-DROP SEQUENCE jcitemsid ;
-CREATE SEQUENCE jcitemsid START 53;
-</pre>
-
-<p>Change it to:
-<pre>
-CREATE SEQUENCE id;
-SELECT SETVAL('id', 10579);
-CREATE SEQUENCE invoiceid;
-SELECT SETVAL('invoiceid', 11096);
-CREATE SEQUENCE orderitemsid;
-SELECT SETVAL('orderitemsid', 178);
-CREATE SEQUENCE jcitemsid;
-SELECT SETVAL('jcitemsid', 53);
-</pre>
-
-
-<p><li><h4>PostgreSQL template1</h4>
-
-<tt>template1</tt> is a template that new databases are built from, by
-default. Anything you put into <tt>template1</tt> will be copied to a
-new database. Thus, when you try to create a new dataset, the tables
-are already drawn in from <tt>template1</tt> so that when LedgerSMB
-tries to create them, you will receive an error message indicating
-that the tables already exist.
-
-
-<p><li><h4>Japanese characters</h4>
-modify apache so that EUC_JP is the main additional language.
-<br>comment out all unrelated languages except, UTF_8 shift jis, EUC_JP
-<br>restart apache
-<br>Fire up psql and do the encoding as per the table:-
-<br>Table 5-2. Postgres Client/Server Character Set Encodings
-
-<p>Server Encoding Available Client Encodings
-<br>EUC_JP EUC_JP, SJIS
-<br>EUC_TW EUC_TW, BIG5
-<br>LATIN2 LATIN2, WIN1250
-<br>LATIN5 LATIN5, WIN, ALT
-<br>MULE_INTERNAL EUC_JP, SJIS, EUC_KR, EUC_CN, EUC_TW, BIG5, LATIN1 to LATIN5, WIN, ALT, WIN1250
-
-<p>Create the dataset from admin.pl, now the Japanese shows up in multibyte encoding
-
-<p>Now you can write in Hiragana, Katakana, Kanji and English
-
-
-<p><li><h4>Error posting a check/receipt</h4>
-<pre>
-DBD::Pg::db do failed: ERROR: syntax error at or near "," at character 114
-Error!
-INSERT INTO acc_trans (trans_id, chart_id, transdate,amount)
-VALUES (13314, , '03-22-2005',1.00 * 1)
-ERROR: syntax error at or near "," at character 114 </pre>
-This error is caused by a transaction which does not have links to
-an AR/AP account.
-<br>set up your chart of accounts properly and create at least one
-AR and AP account. Then edit all your transactions and repost.
-
-
+<!-- This is from Dieter, so we should probably rewrite -->
<p><li><h4>SELinux</h4>
<a href=http://fedora.redhat.com/docs/selinux-faq-fc3/index.html>http://fedora.redhat.com/docs/selinux-faq-fc3/index.html</a>
@@ -132,12 +56,7 @@ recv_msg };
<br>allow httpd_sys_script_t sysctl_kernel_t:file read;
<br>allow httpd_sys_script_t unconfined_t:unix_stream_socket connectto;
-
-<p><li><h4>session timeouts</h4>
-If you get frequent timeouts or can't even log in, synchronize
-the clocks between the server and workstation.
-
-
+<!-- verify and if necessary rewrite -->
<p><li><h4>lineitems not printing</h4>
Templates designed on a UNIX platform don't work on a DOS platform.
To make them work load the template either with the builtin template editor
@@ -150,142 +69,40 @@ conversions: unix2dos and dos2unix. Windows users can obtain these utilities as
<a href="http://www.cygwin.com">Cygwin</a>.</p>
-<p><li><h4>UTF-8 character encoding</h4>
-Most of the translations are in ISO format. To convert the translations
-change directory to locale/cc and convert the files with iconv to UTF-8.
-You should also convert the COAs too and make sure you select UTF-8
-encoding when you set up a new dataset.
-
-
<p><li><h4>characterset problems</h4>
If you have problems displaying the correct characterset try adding
<pre>
AddDefaultCharset On</pre>
in your <tt>httpd.conf</tt> file.
-<p><li><h4>About installation</h4>
-The easiest is to use the setup.pl script as root.
-You don't need to know very much about your system, just login as root,
-run 'perl setup.pl' and follow the prompts.
-<p>setup.pl does not check for missing software packages and it is your
-responsibility to make sure you have the required software
-installed either from source or from a package.
-
-<p>Requirements are clearly indicated in the <tt>README</tt> file and
-on the download page.
-
-
<p><li><h4>cannot create function</h4>
<ol>
-<li>either run <tt>createlang plpgsql</tt> to install the plpgsql
-language handler or install yourself. For more information how to do
-that, visit <a href=http://www.postgresql.org/docs/>PostgreSQL</a> and
-read the interactive documentation for procedural languages.
+<li>Run: <tt>createlang -U postgres plpgsql ledgersmb</tt> to install the
+plpgsql language handler into the "ledgersmb" database. More information on this
+utility can be found at the interactive documentation at the
+<a href=http://www.postgresql.org/docs/>PostgreSQL</a> site.
-<li>load admin.pl
-<li>unlock the system
-<li>login
</ol>
-<p><li><h4>The requested URL /ledger-smb/admin.pl was not found</h4>
-Your webserver doesn't know where to find the script. Most commonly this
-results when distributions hide webserver configuration files in unexpected
-locations so that <tt>setup.pl</tt> wasn't able to configure the location for
-you. Find out which file (<tt>httpd.conf</tt>, <tt>httpdcommon.conf</tt>, ...)
-controls your webserver configuration and add
-<pre>
- # LedgerSMB
- Include /etc/httpd/ledger-smb-httpd.conf</pre>
-
-Create a file 'ledger-smb-httpd.conf' in /etc/httpd and copy the next part
-into the file.
-
-<pre>
- AddHandler cgi-script .pl
- AddDefaultCharset On
- Alias /ledger-smb /var/www/ledger-smb/
- &lt;Directory /var/www/ledger-smb&gt;
- Options ExecCGI Includes FollowSymlinks
- &lt;/Directory&gt;
-
- &lt;Directory /var/www/ledger-smb/users&gt;
- Order Deny,Allow
- Deny from All
- &lt;/Directory&gt;</pre>
-replace '/etc/httpd' and '/var/www' with the appropriate directories.
-
-
-<p><li><h4>users/members : Permission denied</h4>
-Your webserver must have write access to the users directory.
-If your server runs as user/group 'apache:apache' then set the
-users directory to owner/group apache:apache.
-<pre>
- # chown -R apache:apache users</pre>
-
-
-<p><li><h4>Dataset newer than version</h4>
-You are trying to use an older version with a dataset which was
-created with a newer version.
-
-
-<p><li><h4>PDF option not working</h4>
-Check if you have latex and pdflatex installed.
-
-
-<p><li><h4>Apache 2.0 "error 500"</h4>
-Some of the early versions of Apache 2.0 (&lt; patchlevel 44) had a rewrite engine
-which decoded escaped strings. This created a lot of problems and I worked
-around it by escaping strings twice.
-If you get a server 500 error 'filename too long' or if collapsed menus
-don't expand you may have to adjusted the following code in
-LSMB/Form.pm and change the number (44) on line 84.
-<pre>
- # for Apache 2 we escape strings twice
- if (($ENV{SERVER_SIGNATURE} =~ /Apache\/2\.(\d+)\.(\d+)/) && !$beenthere) {
- $str = $self->escape($str, 1) if $2 < 44;
- }</pre>
-
-
<p><li><h4>IDENT Authentication failed for user "ledger-smb"</h4>
Edit pg_hba.conf and change authentication to
<pre>
- local all all MD5</pre>
+ local all all md5
+ host all all 127.0.0.1/32 md5</pre>
-The file is in the 'data' directory of your postgresql installation.
-This is different with every distribution so look for it.
+The file is often in the 'data' directory of your postgresql
+installation. In some distributions it may be in /etc/pgsql or
+a similar directory. A file search can be helpful when all else fails.
<pre>
# find / -name 'pg_hba.conf'</pre>
-<p>Some people can't read and seem to think 'localhost' is just some
-fancy word for a local machine.
-'localhost' is a host like any other host on a network.
-A 'local' entry in pg_hba.conf will allow socket connections ONLY and
-not allow a host connection. If you then try to connect to 'localhost',
-PostgreSQL will come back with an authentication error.
-
-<p>So, if the database resides on the same server as the web server,
-forget you ever heard there is such a thing as 'localhost' and leave
-the Host portion blank.
-
<p><b>WARNING!</b> DO NOT just put a 'host all all trust' in
pg_hba.conf unless you know what you are doing; that can introduce a
pretty huge security hole.
-<p><li><h4>DBD-Pg for Mandrake 9.0</h4>
-Mandrake did not package a compiled DBD-Pg package again, so install DBD-Pg
-from the source package.
-Install perl-DBD-Pg-1.01-4mdk.i586.rpm from the 'contrib' area.
-(Mandrake / 9.0 / contrib / RPMS)
-
-
-<p><li><h4>LaTeX error</h4>
-If for some reason LaTeX produces an error message check for strange
-characters in your account description and parts description
-and use \usepackage[latin1]{inputenc} in the preamble.
-
<p><li><h4>LaTeX templates</h4>
If you don't want to edit tex code by hand,
@@ -295,157 +112,35 @@ latex code.
superior environment to produce professional-looking forms in
postscript and PDF format.
-<p><li><h4>W3M</h4>
-pass terminal=mozilla when you start w3m
-<pre>
- $ w3m -F http://localhost/ledger-smb/login.pl?terminal=mozilla</pre>
-
-To use without frames
-<pre>
- $ w3m http://localhost/ledger-smb/login.pl?terminal=lynx</pre>
+<p><li><h4>Use without Frames</h4>
+
+To use without frames, add ?path=/bin/lynx to the login URL:
+<pre>http://localhost/ledger-smb/login.pl?path=/bin/lynx</pre>
<p><li><h4>PDF option disappeared</h4>
-Edit ledger-smb.conf and set:
+Edit ledgersmb.conf and set:
latex = 1
-<p><li><h4>Installation on Windows (WIN32)</h4>
-<ul>
-<li>install Apache, perl,
-<a href=http://techdocs.postgresql.org/guides/InstallingOnWindows>Postgres</a>
-or Oracle, DBI and the appropriate DBD
-module
-<br>if you can't compile DBD-Pg here is a precompiled
-<a href=http://http://pgfoundry.org/projects/dbdpgppm/>DBD-Pg module</a>
-<li>download the latest version of <a
- href="http://www.ledgersmb.org/download/">LedgerSMB</a>
-<li>extract the files to c:\apache\ledger-smb
-<li>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.
-<li>edit c:\apache\conf\httpd.conf and add
-<pre>
-Alias /ledger-smb "c:/apache/ledger-smb/"
-&lt;Directory "c:/apache/ledger-smb"&gt;
- AllowOverride All
- AddHandler cgi-script .pl
- AddDefaultCharset On
- Options +ExecCGI
- Order Allow,Deny
- Allow from All
-&lt;/Directory&gt;
-
-&lt;Directory "c:/apache/ledger-smb/users"&gt;
- Order Deny,Allow
- Deny from All
-&lt;/Directory&gt;
-</pre>
-
-<li>start Apache
-<li>start Postgres|Oracle|DB2
-<li>connect to http://localhost/ledger-smb/admin.pl and set up users
-and datasets
-<li>connect to http://localhost/ledger-smb/login.pl and login
-
-</ul>
-
-<p><li><h4>What do I enter for the language</h4>
-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
-directory in the locale directory.
-
-
<p><li><h4>printing to a printer</h4>
-Printers are defined in ledger-smb.conf
+Printers are defined in ledgersmb.conf
<pre>
-%printer = ( 'Default' => 'lpr', 'Color' => 'lpr -PEpson' );</pre>
+[printers]
+Default = lpr
+Color = lpr -PEpson</pre>
Check in your /etc/printcap file for the names of available printers.
<p>If you have LaTeX installed set
<pre>
- $latex = 1</pre> in ledger-smb.conf
+ latex = 1
+</pre> in ledger-smb.conf
-<p>To send the document to the printer check the "Postscript" or "PDF" format,
-enter the number of copies and click on the "Print" button.
-
-<p>The printer you enter in your preferences is the default printer.
-You can choose any other available printer. This makes it possible
-to print from anywhere on the network to any printer.
-
-<p>Note: html format is for screen preview. Use the "Print" option from your
+<p>Note: html data entry format is for screen preview.
+Use the "Print" option from your
browser to print to a printer.
-<p><li><h4>Using samba to send printjobs to a printer attached to a Windows XP workstation</h4>
-The next part applies to roll your own print filters only. If you use CUPS or
-LPRng your milage may vary but you can still use this as a guide how it works.
-I use the printer 'Epson' as an example which is
-attached to a XP workstation called Raven.
-
-<pre>
-/etc/printcap entry on the server which runs lpd
-
-epson:Epson\
- :sh:\
- :lp=/dev/null:\
- :sd=/var/spool/output/epson:\
- :if=/usr/libexec/lpr/epson/prnfilter:\
-
-# end of entry in /etc/printcap
-
-
-# prnfilter shell script
-#!/bin/sh
-# Filter for Epson Stylus
-
-PATH="$PATH:/usr/local/bin"
-
-#read first_line
-read tmp
-first_line=`echo $tmp | cut -b1-2 | sed -n '1p'`
-
-first_chr=`expr "$first_line" : '\(.\)'`
-first_two=`expr "$first_line" : '\(..\)'`
-rewindstdin
-
-if [ "$first_two" = "%!" ]; then # Postscript file
- gs @st640p.upp -dSAFER -dNOPAUSE -q -sOutputFile=/tmp/$$ -
-else
- # text file
- cat &gt; /tmp/$$
- echo -n "^L" &gt;&gt; /tmp/$$
- smbclient '\\Raven\Epson' "" -c 'printmode text'
-fi
-
-smbclient '\\Raven\Epson' "" -P -c "print /tmp/$$"
-rm /tmp/$$
-
-# EOF
-
-
-rewindstdin is a small program to rewind the filehandle for STDIN
-save the next part up to EOF to a file rewindstdin.c and compile
-
-#include &lt;sys/types.h&gt;
-#include &lt;unistd.h&gt;
-extern int errno;
-main()
-{
- if( lseek(0,0,0) == 0 ){
- errno = 0;
- }
- return( errno );
-}
-
-# EOF
-
-compile to an executable
-
-gcc -o /usr/local/bin/rewindstdin rewindstdin.c
-</pre>
-
-
<p><li><h4>beginning balances</h4>
Add a GL Journal entry and enter the beginning balance for your accounts.
Beginning balances are the balances from your last balance sheet. If you also
@@ -486,25 +181,10 @@ not packaged follow this recipe to get it working.
<br>$ make test
<br>if all went well su to root
<br># make install
- <li>remove DBD-Pg
+ <li>remove the DBD-Pg directory
</ul>
-<p><li><h4>login.pl has compilation error</h4>
-
-This could be because of a missing configuration file in the users directory
-
-<p>check the permission for the users directory. The directory must be
-set writeable for the webserver. If your webserver runs ias user/group
-nobody.nogroup set the directory to
-<pre>
-drwx--x--x 2 nobody nogroup 1024 May 26 16:49 users
-
-or
-
-drwxrwx--x 2 johndoe nogroup 1024 May 26 16:49 users</pre>
-
-
<p><li><h4>script not executing, shows in browser instead</h4>
Add
@@ -513,38 +193,6 @@ Add
in your httpd.conf file.
-<p><li><h4>permission denied</h4>
-
-Check if your web server has write permission to write to the following
-files and directories:
-<pre>
- users/
- templates/
- users/members
-
- # chown nobody:nogroup users templates users/members
-</pre>
-
-
-<p><li><h4>permission denied to access tables</h4>
-The user you entered in the "Database section" must be a valid
-database user who has rights to access the tables.
-
-<p>If the tables are owned by 'joe' and you enter 'mary' as the dba
-you might run into this problem if mary doesn't have the rights to
-access tables owned by joe.
-
-
-<p><li><h4>html and graphics files don't show up on screen</h4>
-
-Enable Includes and FollowSymlinks Options in your httpd.conf file
-<pre>
- &lt;Directory /usr/local/ledger-smb&gt;
- Options ExecCGI Includes FollowSymlinks
- &lt;/Directory&gt;
-</pre>
-
-
<p><li><h4>switch display to a foreign language</h4>
Load your preferences and select the language.
@@ -555,19 +203,14 @@ ISO 3166-1</a> standards.
<p><li><h4>Text shows in English when I use a foreign language</h4>
-This is because the corresponding hash entry is missing.
-Add the missing text in the locale/cc/all or locale/cc/missing
-file and run 'perl locales.pl' from the command line to rebuild
-the individual files.
-
-<br>cc refers to the country code.
-
+This is because the corresponding entry in the .po file.
+Add the missing text the appropriate .po
<p><li><h4>switch to a foreign language for the login and admin screen</h4>
Edit ledger-smb.conf and enter the code for the $language variable
<pre>
- $language = "de";</pre>
+ language = "de"</pre>
<p>This is a global change and applies to all logins, individual settings
may be changed by setting the language in your Preferences.
@@ -577,18 +220,12 @@ may be changed by setting the language in your Preferences.
<p>
<hr>
+<!-- still needs help -->
<a name=security>
<h1>LedgerSMB security</h1>
</a>
<ul>
-<li>The security features built into LedgerSMB provide encrypted passwords
-and access control which makes it fairly safe out of the box to run even in
-front of a firewall.
-Some precautions which are out of our control must be taken though.
-It matters where you install LSMB and how you configure your web server and
-SQL server.
-
<pre>
Typical setups: