sql-ledger-users — SQL-Ledger users

[SQL-Ledger-users] problem & suggestion

[adrian <ad...@sn...>]

My accounts payable has several zero balances showing which are in
reality very small ammounts. The calculations need to rounded to the
neatest cent ( 1/2 cent).

How can I now manually "zero" these accounts?

Adding bank reconcilation is high priority from our pospective.

Adrian

Re: Re: [SQL-Ledger-users] Still Cannot install sql-ledger

[Antonio G. <ag...@ib...>]

Try to set the AddHandler Directive inside the definition of the Directory for SQL-Ledger.

By the way set the ServerName Directive too. This is actually commented.

Antonio Gallardo
> 
> From: Ibrahim Shaame <gtk...@ya...>
> Date: 2001/04/30 Mon AM 07:50:57 GMT+06:00
> To: sql...@li...
> Subject: Re: [SQL-Ledger-users] Still Cannot install sql-ledger
> 
> Hi,
>     Thanks for the advice. I have trying to make it work following your tips.
> Unfortunately I have not been able. The problem still persist. I am attaching
> here my httpd.conf file if you can try to seen where I am missing.
> 
> Sorry for bothering everybody, but really I want to run sql-ledger.
> 
> Thanks in advance
> 
> Ibrahim Shaame
> 
> Izzy Blacklock wrote:
> 
> > At 10:12 AM 21/04/01, you wrote:
> > >Following my previous emails, here is a copy of the
> > >screen I receive when calling setup.html (which is a
> > >copy of setup.cgi). Whenever I try to click on "Add
> > >User" (or List Users) I get a message : "Netscape in
> > >unable to find the file or directory named
> > >/var/lib/apache/sql-ledger/admin/$script, Check the
> > >name and try again". When I try to call from
> > >Netscape's File, Open Location, sometimes it says that
> > >file not found and sometimes it brings me to
> > >"http://localhost" with the famous apache page
> > >announcing the success of of its installation.
> > >
> > >Thank you for your hints
> >
> > That's about what I'd expect from opening a cgi script in a web browser! :)
> >
> > I'm new to this as well so please forgive me if I'm wrong, but I think your
> > problem is with your Apache setup.  You have to specifically tell Apache
> > it's ok to run scripts outside of it's default cgi directory.  The answers
> > are in the SQL-Ledger FAQ, but I too had problems understanding at
> > first.  There's so many things to install and configure and if you've never
> > done any of it before, it can be quite a daunting task! :(
> >
> > I think your problem is with Apache, so here's what you need to do for
> > it.  The first thing is to add support for running .pl files as cgi scripts
> > as the first point in the FAQ suggests.  Edit your httpd.conf file (mine
> > was in /etc/httpd/httpd.conf) and searched for "To use CGI scripts".  You
> > should find a section like this:
> >
> > # To use CGI scripts:
> > AddHandler cgi-script .cgi
> >
> > If it isn't there already, add the following as is indicated in the FAQ.
> >
> > AddHandler cgi-script .pl
> >
> > Next I'd skip to the bottom of the FAQ to the section on security and
> > follow all these steps.  Don't make the mistake I did and assume that
> > Apache is running as the default user nobody.nogroup.  I found out mine was
> > running as wwwrun.nogroup  which is the default configuration under
> > SuSE.  If you search your httpd.conf file for "User/Group", you should find
> > entries like this
> >
> > User wwwrun
> > Group nogroup
> >
> > Change step 2 in the FAQ to match these settings.  Of course you will also
> > want to change the path in all these steps to match where you've put the
> > sql-Ledger directory.
> >
> > For step 4, I'd just copy the lines as he has them there (with adjustments
> > to the sql-ledger path if needed) and place them in the httpd.conf
> > file.  If you search for "<Directory" you'll find the section where you
> > want to put them. Just move to the bottom of the last entry (they end with
> > </Directory>) and past it all there.  Make sure the path is correct for
> > where you put sql-ledger.
> >
> > I didn't understand step 5, and step 6 you can probably skip.
> >
> > Hope this helps.
> >
> > ...Izzy
> 
> ##
> ## httpd.conf -- Apache HTTP server configuration file
> ##
> 
> #
> # Based upon the NCSA server configuration files originally by Rob McCool.
> #
> # This is the main Apache server configuration file.  It contains the
> # configuration directives that give the server its instructions.
> # See <URL:http://www.apache.org/docs/> for detailed information about
> # the directives.
> #
> # Do NOT simply read the instructions in here without understanding
> # what they do.  They're here only as hints or reminders.  If you are unsure
> # consult the online docs. You have been warned.  
> #
> # After this file is processed, the server will look for and process
> # /var/lib/apache/conf/srm.conf and then /var/lib/apache/conf/access.conf
> # unless you have overridden these with ResourceConfig and/or
> # AccessConfig directives here.
> #
> # The configuration directives are grouped into three basic sections:
> #  1. Directives that control the operation of the Apache server process as a
> #     whole (the 'global environment').
> #  2. Directives that define the parameters of the 'main' or 'default' server,
> #     which responds to requests that aren't handled by a virtual host.
> #     These directives also provide default values for the settings
> #     of all virtual hosts.
> #  3. Settings for virtual hosts, which allow Web requests to be sent to
> #     different IP addresses or hostnames and have them handled by the
> #     same Apache server process.
> #
> # Configuration and logfile names: If the filenames you specify for many
> # of the server's control files begin with "/" (or "drive:/" for Win32), the
> # server will use that explicit path.  If the filenames do *not* begin
> # with "/", the value of ServerRoot is prepended -- so "logs/foo.log"
> # with ServerRoot set to "/usr/local/apache" will be interpreted by the
> # server as "/usr/local/apache/logs/foo.log".
> #
> 
> ### Section 1: Global Environment
> #
> # The directives in this section affect the overall operation of Apache,
> # such as the number of concurrent requests it can handle or where it
> # can find its configuration files.
> #
> 
> #
> # ServerType is either inetd, or standalone.  Inetd mode is only supported on
> # Unix platforms.
> #
> ServerType standalone
> 
> #
> # ServerRoot: The top of the directory tree under which the server's
> # configuration, error, and log files are kept.
> #
> # NOTE!  If you intend to place this on an NFS (or otherwise network)
> # mounted filesystem then please read the LockFile documentation
> # (available at <URL:http://www.apache.org/docs/mod/core.html#lockfile>);
> # you will save yourself a lot of trouble.
> #
> # Do NOT add a slash at the end of the directory path.
> #
> ServerRoot "/var/lib/apache"
> 
> #
> # The LockFile directive sets the path to the lockfile used when Apache
> # is compiled with either USE_FCNTL_SERIALIZED_ACCEPT or
> # USE_FLOCK_SERIALIZED_ACCEPT. This directive should normally be left at
> # its default value. The main reason for changing it is if the logs
> # directory is NFS mounted, since the lockfile MUST BE STORED ON A LOCAL
> # DISK. The PID of the main server process is automatically appended to
> # the filename. 
> #
> #LockFile /var/run/httpd.lock
> 
> #
> # PidFile: The file in which the server should record its process
> # identification number when it starts.
> #
> PidFile /var/run/httpd.pid
> 
> #
> # ScoreBoardFile: File used to store internal server process information.
> # Not all architectures require this.  But if yours does (you'll know because
> # this file will be  created when you run Apache) then you *must* ensure that
> # no two invocations of Apache share the same scoreboard file.
> #
> ScoreBoardFile /var/run/httpd.scoreboard
> 
> #
> # In the standard configuration, the server will process this file,
> # srm.conf, and access.conf in that order.  The latter two files are
> # now distributed empty, as it is recommended that all directives
> # be kept in a single file for simplicity.  The commented-out values
> # below are the built-in defaults.  You can have the server ignore
> # these files altogether by using "/dev/null" (for Unix) or
> # "nul" (for Win32) for the arguments to the directives.
> #
> #ResourceConfig conf/srm.conf
> #AccessConfig conf/access.conf
> 
> #
> # Timeout: The number of seconds before receives and sends time out.
> #
> Timeout 300
> 
> #
> # KeepAlive: Whether or not to allow persistent connections (more than
> # one request per connection). Set to "Off" to deactivate.
> #
> KeepAlive On
> 
> #
> # MaxKeepAliveRequests: The maximum number of requests to allow
> # during a persistent connection. Set to 0 to allow an unlimited amount.
> # We recommend you leave this number high, for maximum performance.
> #
> MaxKeepAliveRequests 100
> 
> #
> # KeepAliveTimeout: Number of seconds to wait for the next request from the
> # same client on the same connection.
> #
> KeepAliveTimeout 15
> 
> #
> # Server-pool size regulation.  Rather than making you guess how many
> # server processes you need, Apache dynamically adapts to the load it
> # sees --- that is, it tries to maintain enough server processes to
> # handle the current load, plus a few spare servers to handle transient
> # load spikes (e.g., multiple simultaneous requests from a single
> # Netscape browser).
> #
> # It does this by periodically checking how many servers are waiting
> # for a request.  If there are fewer than MinSpareServers, it creates
> # a new spare.  If there are more than MaxSpareServers, some of the
> # spares die off.  The default values are probably OK for most sites.
> #
> MinSpareServers 5
> MaxSpareServers 10
> 
> #
> # Number of servers to start initially --- should be a reasonable ballpark
> # figure.
> #
> StartServers 5
> 
> #
> # Limit on total number of servers running, i.e., limit on the number
> # of clients who can simultaneously connect --- if this limit is ever
> # reached, clients will be LOCKED OUT, so it should NOT BE SET TOO LOW.
> # It is intended mainly as a brake to keep a runaway server from taking
> # the system with it as it spirals down...
> #
> MaxClients 150
> 
> #
> # MaxRequestsPerChild: the number of requests each child process is
> # allowed to process before the child dies.  The child will exit so
> # as to avoid problems after prolonged use when Apache (and maybe the
> # libraries it uses) leak memory or other resources.  On most systems, this
> # isn't really needed, but a few (such as Solaris) do have notable leaks
> # in the libraries. For these platforms, set to something like 10000
> # or so; a setting of 0 means unlimited.
> #
> # NOTE: This value does not include keepalive requests after the initial
> #       request per connection. For example, if a child process handles
> #       an initial request and 10 subsequent "keptalive" requests, it
> #       would only count as 1 request towards this limit.
> #
> MaxRequestsPerChild 0
> 
> #
> # Listen: Allows you to bind Apache to specific IP addresses and/or
> # ports, in addition to the default. See also the <VirtualHost>
> # directive.
> #
> #Listen 3000
> #Listen 12.34.56.78:80
> 
> #
> # BindAddress: You can support virtual hosts with this option. This directive
> # is used to tell the server which IP address to listen to. It can either
> # contain "*", an IP address, or a fully qualified Internet domain name.
> # See also the <VirtualHost> and Listen directives.
> #
> #BindAddress *
> 
> #
> # Dynamic Shared Object (DSO) Support
> #
> # To be able to use the functionality of a module which was built as a DSO you
> # have to place corresponding `LoadModule' lines at this location so the
> # directives contained in it are actually available _before_ they are used.
> # Please read the file README.DSO in the Apache 1.3 distribution for more
> # details about the DSO mechanism and run `httpd -l' for the list of already
> # built-in (statically linked and thus always available) modules in your httpd
> # binary.
> #
> # Note: The order is which modules are loaded is important.  Don't change
> # the order below without expert advice.
> #
> # Example:
> # LoadModule foo_module libexec/mod_foo.so
> LoadModule env_module         libexec/mod_env.so
> LoadModule config_log_module  libexec/mod_log_config.so
> LoadModule mime_module        libexec/mod_mime.so
> LoadModule negotiation_module libexec/mod_negotiation.so
> LoadModule status_module      libexec/mod_status.so
> LoadModule includes_module    libexec/mod_include.so
> LoadModule autoindex_module   libexec/mod_autoindex.so
> LoadModule dir_module         libexec/mod_dir.so
> LoadModule cgi_module         libexec/mod_cgi.so
> LoadModule asis_module        libexec/mod_asis.so
> LoadModule imap_module        libexec/mod_imap.so
> LoadModule action_module      libexec/mod_actions.so
> LoadModule userdir_module     libexec/mod_userdir.so
> LoadModule alias_module       libexec/mod_alias.so
> LoadModule access_module      libexec/mod_access.so
> LoadModule auth_module        libexec/mod_auth.so
> LoadModule setenvif_module    libexec/mod_setenvif.so
> 
> #  Reconstruction of the complete module list from all available modules
> #  (static and shared ones) to achieve correct module execution order.
> #  [WHENEVER YOU CHANGE THE LOADMODULE SECTION ABOVE UPDATE THIS, TOO]
> ClearModuleList
> AddModule mod_env.c
> AddModule mod_log_config.c
> AddModule mod_mime.c
> AddModule mod_negotiation.c
> AddModule mod_status.c
> AddModule mod_include.c
> AddModule mod_autoindex.c
> AddModule mod_dir.c
> AddModule mod_cgi.c
> AddModule mod_asis.c
> AddModule mod_imap.c
> AddModule mod_actions.c
> AddModule mod_userdir.c
> AddModule mod_alias.c
> AddModule mod_access.c
> AddModule mod_auth.c
> AddModule mod_so.c
> AddModule mod_setenvif.c
> 
> #
> # ExtendedStatus controls whether Apache will generate "full" status
> # information (ExtendedStatus On) or just basic information (ExtendedStatus
> # Off) when the "server-status" handler is called. The default is Off.
> #
> #ExtendedStatus On
> 
> ### Section 2: 'Main' server configuration
> #
> # The directives in this section set up the values used by the 'main'
> # server, which responds to any requests that aren't handled by a
> # <VirtualHost> definition.  These values also provide defaults for
> # any <VirtualHost> containers you may define later in the file.
> #
> # All of these directives may appear inside <VirtualHost> containers,
> # in which case these default settings will be overridden for the
> # virtual host being defined.
> #
> 
> #
> # If your ServerType directive (set earlier in the 'Global Environment'
> # section) is set to "inetd", the next few directives don't have any
> # effect since their settings are defined by the inetd configuration.
> # Skip ahead to the ServerAdmin directive.
> #
> 
> #
> # Port: The port to which the standalone server listens. For
> # ports < 1023, you will need httpd to be run as root initially.
> #
> Port 80
> 
> #
> # If you wish httpd to run as a different user or group, you must run
> # httpd as root initially and it will switch.  
> #
> # User/Group: The name (or #number) of the user/group to run httpd as.
> #  . On SCO (ODT 3) use "User nouser" and "Group nogroup".
> #  . On HPUX you may not be able to use shared memory as nobody, and the
> #    suggested workaround is to create a user www and use that user.
> #  NOTE that some kernels refuse to setgid(Group) or semctl(IPC_SET)
> #  when the value of (unsigned)Group is above 60000; 
> #  don't use Group nogroup on these systems!
> #
> User nobody
> Group nogroup
> 
> #
> # ServerAdmin: Your address, where problems with the server should be
> # e-mailed.  This address appears on some server-generated pages, such
> # as error documents.
> #
> ServerAdmin ro...@xy...
> 
> #
> # ServerName allows you to set a host name which is sent back to clients for
> # your server if it's different than the one the program would get (i.e., use
> # "www" instead of the host's real name).
> #
> # Note: You cannot just invent host names and hope they work. The name you 
> # define here must be a valid DNS name for your host. If you don't understand
> # this, ask your network administrator.
> # If your host doesn't have a registered DNS name, enter its IP address here.
> # You will have to access it by its address (e.g., http://123.45.67.89/)
> # anyway, and this will make redirections work in a sensible way.
> #
> #ServerName xyzzy.rrnet.com
> 
> #
> # DocumentRoot: The directory out of which you will serve your
> # documents. By default, all requests are taken from this directory, but
> # symbolic links and aliases may be used to point to other locations.
> #
> DocumentRoot "/var/lib/apache/htdocs"
> 
> #
> # Each directory to which Apache has access, can be configured with respect
> # to which services and features are allowed and/or disabled in that
> # directory (and its subdirectories). 
> #
> # First, we configure the "default" to be a very restrictive set of 
> # permissions.  
> #
> Alias /sql-ledger/ /var/lib/apache/sql-ledger/
> <Directory /var/lib/apache/sql-ledger>
> 	AllowOverride None
> 	Options Includes FollowSymLinks ExecCGI
> </Directory>
> <Directory /var/lib/apache/sql-ledger/admin>
> 	AllowOverride FileInfo
> 	Options	FollowSymLinks	ExecCGI
> </Directory>
> <Directory /var/lib/apache/sql-ledger/users>
> 	Options None
> </Directory>		
> <Directory />
>     Options FollowSymLinks
>     AllowOverride None
> </Directory>
> 
> #
> # Note that from this point forward you must specifically allow
> # particular features to be enabled - so if something's not working as
> # you might expect, make sure that you have specifically enabled it
> # below.
> #
> 
> #
> # This should be changed to whatever you set DocumentRoot to.
> #
> <Directory "/var/lib/apache/htdocs">
> 
> #
> # This may also be "None", "All", or any combination of "Indexes",
> # "Includes", "FollowSymLinks", "ExecCGI", or "MultiViews".
> #
> # Note that "MultiViews" must be named *explicitly* --- "Options All"
> # doesn't give it to you.
> #
>     Options Indexes FollowSymLinks
> 
> #
> # This controls which options the .htaccess files in directories can
> # override. Can also be "All", or any combination of "Options", "FileInfo", 
> # "AuthConfig", and "Limit"
> #
>     AllowOverride None
> 
> #
> # Controls who can get stuff from this server.
> #
>     Order allow,deny
>     Allow from all
> </Directory>
> 
> #
> # UserDir: The name of the directory which is appended onto a user's home
> # directory if a ~user request is received.
> #
> UserDir public_html
> 
> #
> # Control access to UserDir directories.  The following is an example
> # for a site where these directories are restricted to read-only.
> #
> #<Directory /home/*/public_html>
> #    AllowOverride FileInfo AuthConfig Limit
> #    Options MultiViews Indexes SymLinksIfOwnerMatch IncludesNoExec
> #    <Limit GET POST OPTIONS PROPFIND>
> #        Order allow,deny
> #        Allow from all
> #    </Limit>
> #    <Limit PUT DELETE PATCH PROPPATCH MKCOL COPY MOVE LOCK UNLOCK>
> #        Order deny,allow
> #        Deny from all
> #    </Limit>
> #</Directory>
> 
> #
> # DirectoryIndex: Name of the file or files to use as a pre-written HTML
> # directory index.  Separate multiple entries with spaces.
> #
> DirectoryIndex index.html
> 
> #
> # AccessFileName: The name of the file to look for in each directory
> # for access control information.
> #
> AccessFileName .htaccess
> 
> #
> # The following lines prevent .htaccess files from being viewed by
> # Web clients.  Since .htaccess files often contain authorization
> # information, access is disallowed for security reasons.  Comment
> # these lines out if you want Web visitors to see the contents of
> # .htaccess files.  If you change the AccessFileName directive above,
> # be sure to make the corresponding changes here.
> #
> # Also, folks tend to use names such as .htpasswd for password
> # files, so this will protect those as well.
> #
> <Files ~ "^\.ht">
>     Order allow,deny
>     Deny from all
> </Files>
> 
> #
> # CacheNegotiatedDocs: By default, Apache sends "Pragma: no-cache" with each
> # document that was negotiated on the basis of content. This asks proxy
> # servers not to cache the document. Uncommenting the following line disables
> # this behavior, and proxies will be allowed to cache the documents.
> #
> #CacheNegotiatedDocs
> 
> #
> # UseCanonicalName:  (new for 1.3)  With this setting turned on, whenever
> # Apache needs to construct a self-referencing URL (a URL that refers back
> # to the server the response is coming from) it will use ServerName and
> # Port to form a "canonical" name.  With this setting off, Apache will
> # use the hostname:port that the client supplied, when possible.  This
> # also affects SERVER_NAME and SERVER_PORT in CGI scripts.
> #
> UseCanonicalName On
> 
> #
> # TypesConfig describes where the mime.types file (or equivalent) is
> # to be found.
> #
> TypesConfig /var/lib/apache/conf/mime.types
> 
> #
> # DefaultType is the default MIME type the server will use for a document
> # if it cannot otherwise determine one, such as from filename extensions.
> # If your server contains mostly text or HTML documents, "text/plain" is
> # a good value.  If most of your content is binary, such as applications
> # or images, you may want to use "application/octet-stream" instead to
> # keep browsers from trying to display binary files as though they are
> # text.
> #
> DefaultType text/plain
> 
> #
> # The mod_mime_magic module allows the server to use various hints from the
> # contents of the file itself to determine its type.  The MIMEMagicFile
> # directive tells the module where the hint definitions are located.
> # mod_mime_magic is not part of the default server (you have to add
> # it yourself with a LoadModule [see the DSO paragraph in the 'Global
> # Environment' section], or recompile the server and include mod_mime_magic
> # as part of the configuration), so it's enclosed in an <IfModule> container.
> # This means that the MIMEMagicFile directive will only be processed if the
> # module is part of the server.
> #
> <IfModule mod_mime_magic.c>
>     MIMEMagicFile /var/lib/apache/conf/magic
> </IfModule>
> 
> #
> # HostnameLookups: Log the names of clients or just their IP addresses
> # e.g., www.apache.org (on) or 204.62.129.132 (off).
> # The default is off because it'd be overall better for the net if people
> # had to knowingly turn this feature on, since enabling it means that
> # each client request will result in AT LEAST one lookup request to the
> # nameserver.
> #
> HostnameLookups Off
> 
> #
> # ErrorLog: The location of the error log file.
> # If you do not specify an ErrorLog directive within a <VirtualHost>
> # container, error messages relating to that virtual host will be
> # logged here.  If you *do* define an error logfile for a <VirtualHost>
> # container, that host's errors will be logged there and not here.
> #
> ErrorLog /var/log/error_log
> 
> #
> # LogLevel: Control the number of messages logged to the error_log.
> # Possible values include: debug, info, notice, warn, error, crit,
> # alert, emerg.
> #
> LogLevel warn
> 
> #
> # The following directives define some format nicknames for use with
> # a CustomLog directive (see below).
> #
> LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
> LogFormat "%h %l %u %t \"%r\" %>s %b" common
> LogFormat "%{Referer}i -> %U" referer
> LogFormat "%{User-agent}i" agent
> 
> #
> # The location and format of the access logfile (Common Logfile Format).
> # If you do not define any access logfiles within a <VirtualHost>
> # container, they will be logged here.  Contrariwise, if you *do*
> # define per-<VirtualHost> access logfiles, transactions will be
> # logged therein and *not* in this file.
> #
> CustomLog /var/log/access_log common
> 
> #
> # If you would like to have agent and referer logfiles, uncomment the
> # following directives.
> #
> #CustomLog /var/log/referer_log referer
> #CustomLog /var/log/agent_log agent
> 
> #
> # If you prefer a single logfile with access, agent, and referer information
> # (Combined Logfile Format) you can use the following directive.
> #
> #CustomLog /var/log/access_log combined
> 
> #
> # Optionally add a line containing the server version and virtual host
> # name to server-generated pages (error documents, FTP directory listings,
> # mod_status and mod_info output etc., but not CGI generated documents).
> # Set to "EMail" to also include a mailto: link to the ServerAdmin.
> # Set to one of:  On | Off | EMail
> #
> ServerSignature On
> 
> #
> # Aliases: Add here as many aliases as you need (with no limit). The format is 
> # Alias fakename realname
> #
> # Note that if you include a trailing / on fakename then the server will
> # require it to be present in the URL.  So "/icons" isn't aliased in this
> # example, only "/icons/"..
> #
> Alias /icons/ "/var/lib/apache/icons/"
> 
> <Directory "/var/lib/apache/icons">
>     Options Indexes MultiViews
>     AllowOverride None
>     Order allow,deny
>     Allow from all
> </Directory>
> 
> #
> # ScriptAlias: This controls which directories contain server scripts.
> # ScriptAliases are essentially the same as Aliases, except that
> # documents in the realname directory are treated as applications and
> # run by the server when requested rather than as documents sent to the client.
> # The same rules about trailing "/" apply to ScriptAlias directives as to
> # Alias.
> #
> # ScriptAlias /cgi-bin/ "/var/lib/apache/cgi-bin/"
> ScriptAlias /cgi-bin/ "/var/lib/apache/sql-ledger"
> # ScriptAlias /cgi-bin/ "/var/lib/apache/sql-ledger/admin"
> # ScriptAlias /cgi-bin/ "/var/lib/apache/sql-ledger/users"
> 
> 
> 
> #
> # "/var/lib/apache/cgi-bin" should be changed to whatever your ScriptAliased
> # CGI directory exists, if you have that configured.
> #
> <Directory "/var/lib/apache/cgi-bin">
>     AllowOverride None
>     Options None
>     Order allow,deny
>     Allow from all
> </Directory>
> 
> #
> # Redirect allows you to tell clients about documents which used to exist in
> # your server's namespace, but do not anymore. This allows you to tell the
> # clients where to look for the relocated document.
> # Format: Redirect old-URI new-URL
> #
> 
> #
> # Directives controlling the display of server-generated directory listings.
> #
> 
> #
> # FancyIndexing is whether you want fancy directory indexing or standard
> #
> IndexOptions FancyIndexing
> 
> #
> # AddIcon* directives tell the server which icon to show for different
> # files or filename extensions.  These are only displayed for
> # FancyIndexed directories.
> #
> AddIconByEncoding (CMP,/icons/compressed.gif) x-compress x-gzip
> 
> AddIconByType (TXT,/icons/text.gif) text/*
> AddIconByType (IMG,/icons/image2.gif) image/*
> AddIconByType (SND,/icons/sound2.gif) audio/*
> AddIconByType (VID,/icons/movie.gif) video/*
> 
> AddIcon /icons/binary.gif .bin .exe
> AddIcon /icons/binhex.gif .hqx
> AddIcon /icons/tar.gif .tar
> AddIcon /icons/world2.gif .wrl .wrl.gz .vrml .vrm .iv
> AddIcon /icons/compressed.gif .Z .z .tgz .gz .zip
> AddIcon /icons/a.gif .ps .ai .eps
> AddIcon /icons/layout.gif .html .shtml .htm .pdf
> AddIcon /icons/text.gif .txt
> AddIcon /icons/c.gif .c
> AddIcon /icons/p.gif .pl .py
> AddIcon /icons/f.gif .for
> AddIcon /icons/dvi.gif .dvi
> AddIcon /icons/uuencoded.gif .uu
> AddIcon /icons/script.gif .conf .sh .shar .csh .ksh .tcl
> AddIcon /icons/tex.gif .tex
> AddIcon /icons/bomb.gif core
> 
> AddIcon /icons/back.gif ..
> AddIcon /icons/hand.right.gif README
> AddIcon /icons/folder.gif ^^DIRECTORY^^
> AddIcon /icons/blank.gif ^^BLANKICON^^
> 
> #
> # DefaultIcon is which icon to show for files which do not have an icon
> # explicitly set.
> #
> DefaultIcon /icons/unknown.gif
> 
> #
> # AddDescription allows you to place a short description after a file in
> # server-generated indexes.  These are only displayed for FancyIndexed
> # directories.
> # Format: AddDescription "description" filename
> #
> #AddDescription "GZIP compressed document" .gz
> #AddDescription "tar archive" .tar
> #AddDescription "GZIP compressed tar archive" .tgz
> 
> #
> # ReadmeName is the name of the README file the server will look for by
> # default, and append to directory listings.
> #
> # HeaderName is the name of a file which should be prepended to
> # directory indexes. 
> #
> # The server will first look for name.html and include it if found.
> # If name.html doesn't exist, the server will then look for name.txt
> # and include it as plaintext if found.
> #
> ReadmeName README
> HeaderName HEADER
> 
> #
> # IndexIgnore is a set of filenames which directory indexing should ignore
> # and not include in the listing.  Shell-style wildcarding is permitted.
> #
> IndexIgnore .??* *~ *# HEADER* README* RCS CVS *,v *,t
> 
> #
> # AddEncoding allows you to have certain browsers (Mosaic/X 2.1+) uncompress
> # information on the fly. Note: Not all browsers support this.
> # Despite the name similarity, the following Add* directives have nothing
> # to do with the FancyIndexing customization directives above.
> #
> AddEncoding x-compress Z
> AddEncoding x-gzip gz tgz
> 
> #
> # AddLanguage allows you to specify the language of a document. You can
> # then use content negotiation to give a browser a file in a language
> # it can understand.  Note that the suffix does not have to be the same
> # as the language keyword --- those with documents in Polish (whose
> # net-standard language code is pl) may wish to use "AddLanguage pl .po" 
> # to avoid the ambiguity with the common suffix for perl scripts.
> #
> AddLanguage en .en
> AddLanguage fr .fr
> AddLanguage de .de
> AddLanguage da .da
> AddLanguage el .el
> AddLanguage it .it
> 
> #
> # LanguagePriority allows you to give precedence to some languages
> # in case of a tie during content negotiation.
> # Just list the languages in decreasing order of preference.
> #
> LanguagePriority en fr de
> 
> #
> # AddType allows you to tweak mime.types without actually editing it, or to
> # make certain files to be certain types.
> #
> # For example, the PHP3 module (not part of the Apache distribution - see
> # http://www.php.net) will typically use:
> #
> #AddType application/x-httpd-php3 .php3
> #AddType application/x-httpd-php3-source .phps
> 
> AddType application/x-tar .tgz
> 
> #
> # AddHandler allows you to map certain file extensions to "handlers",
> # actions unrelated to filetype. These can be either built into the server
> # or added with the Action command (see below)
> #
> # If you want to use server side includes, or CGI outside
> # ScriptAliased directories, uncomment the following lines.
> #
> # To use CGI scripts:
> #
> AddHandler cgi-script .cgi
> AddHandler cgi-script .pl
> 
> #
> # To use server-parsed HTML files
> #
> #AddType text/html .shtml
> #AddHandler server-parsed .shtml
> 
> #
> # Uncomment the following line to enable Apache's send-asis HTTP file
> # feature
> #
> #AddHandler send-as-is asis
> 
> #
> # If you wish to use server-parsed imagemap files, use
> #
> #AddHandler imap-file map
> 
> #
> # To enable type maps, you might want to use
> #
> #AddHandler type-map var
> 
> #
> # Action lets you define media types that will execute a script whenever
> # a matching file is called. This eliminates the need for repeated URL
> # pathnames for oft-used CGI file processors.
> # Format: Action media/type /cgi-script/location
> # Format: Action handler-name /cgi-script/location
> #
> 
> #
> # MetaDir: specifies the name of the directory in which Apache can find
> # meta information files. These files contain additional HTTP headers
> # to include when sending the document
> #
> #MetaDir .web
> 
> #
> # MetaSuffix: specifies the file name suffix for the file containing the
> # meta information.
> #
> #MetaSuffix .meta
> 
> #
> # Customizable error response (Apache style)
> #  these come in three flavors
> #
> #    1) plain text
> #ErrorDocument 500 "The server made a boo boo.
> #  n.b.  the (") marks it as text, it does not get output
> #
> #    2) local redirects
> #ErrorDocument 404 /missing.html
> #  to redirect to local URL /missing.html
> #ErrorDocument 404 /cgi-bin/missing_handler.pl
> #  N.B.: You can redirect to a script or a document using server-side-includes.
> #
> #    3) external redirects
> #ErrorDocument 402 http://some.other_server.com/subscription_info.html
> #  N.B.: Many of the environment variables associated with the original
> #  request will *not* be available to such a script.
> 
> #
> # The following directives modify normal HTTP response behavior.
> # The first directive disables keepalive for Netscape 2.x and browsers that
> # spoof it. There are known problems with these browser implementations.
> # The second directive is for Microsoft Internet Explorer 4.0b2
> # which has a broken HTTP/1.1 implementation and does not properly
> # support keepalive when it is used on 301 or 302 (redirect) responses.
> #
> BrowserMatch "Mozilla/2" nokeepalive
> BrowserMatch "MSIE 4\.0b2;" nokeepalive downgrade-1.0 force-response-1.0
> 
> #
> # The following directive disables HTTP/1.1 responses to browsers which
> # are in violation of the HTTP/1.0 spec by not being able to grok a
> # basic 1.1 response.
> #
> BrowserMatch "RealPlayer 4\.0" force-response-1.0
> BrowserMatch "Java/1\.0" force-response-1.0
> BrowserMatch "JDK/1\.0" force-response-1.0
> 
> #
> # Allow server status reports, with the URL of http://servername/server-status
> # Change the ".your_domain.com" to match your domain to enable.
> #
> #<Location /server-status>
> #    SetHandler server-status
> #    Order deny,allow
> #    Deny from all
> #    Allow from .your_domain.com
> #</Location>
> 
> #
> # Allow remote server configuration reports, with the URL of
> #  http://servername/server-info (requires that mod_info.c be loaded).
> # Change the ".your_domain.com" to match your domain to enable.
> #
> #<Location /server-info>
> #    SetHandler server-info
> #    Order deny,allow
> #    Deny from all
> #    Allow from .your_domain.com
> #</Location>
> 
> #
> # There have been reports of people trying to abuse an old bug from pre-1.1
> # days.  This bug involved a CGI script distributed as a part of Apache.
> # By uncommenting these lines you can redirect these attacks to a logging 
> # script on phf.apache.org.  Or, you can record them yourself, using the script
> # support/phf_abuse_log.cgi.
> #
> #<Location /cgi-bin/phf*>
> #    Deny from all
> #    ErrorDocument 403 http://phf.apache.org/phf_abuse_log.cgi
> #</Location>
> 
> #
> # Proxy Server directives. Uncomment the following lines to
> # enable the proxy server:
> #
> #<IfModule mod_proxy.c>
> #ProxyRequests On
> #
> #<Directory proxy:*>
> #    Order deny,allow
> #    Deny from all
> #    Allow from .your_domain.com
> #</Directory>
> 
> #
> # Enable/disable the handling of HTTP/1.1 "Via:" headers.
> # ("Full" adds the server version; "Block" removes all outgoing Via: headers)
> # Set to one of: Off | On | Full | Block
> #
> #ProxyVia On
> 
> #
> # To enable the cache as well, edit and uncomment the following lines:
> # (no cacheing without CacheRoot)
> #
> #CacheRoot "/var/lib/apache/proxy"
> #CacheSize 5
> #CacheGcInterval 4
> #CacheMaxExpire 24
> #CacheLastModifiedFactor 0.1
> #CacheDefaultExpire 1
> #NoCache a_domain.com another_domain.edu joes.garage_sale.com
> 
> #</IfModule>
> # End of proxy directives.
> 
> ### Section 3: Virtual Hosts
> #
> # VirtualHost: If you want to maintain multiple domains/hostnames on your
> # machine you can setup VirtualHost containers for them.
> # Please see the documentation at <URL:http://www.apache.org/docs/vhosts/>
> # for further details before you try to setup virtual hosts.
> # You may use the command line option '-S' to verify your virtual host
> # configuration.
> 
> #
> # If you want to use name-based virtual hosts you need to define at
> # least one IP address (and port number) for them.
> #
> #NameVirtualHost 12.34.56.78:80
> #NameVirtualHost 12.34.56.78
> 
> #
> # VirtualHost example:
> # Almost any Apache directive may go into a VirtualHost container.
> #
> #<VirtualHost ip.address.of.host.some_domain.com>
> #    ServerAdmin web...@ho...me_domain.com
> #    DocumentRoot /www/docs/host.some_domain.com
> #    ServerName host.some_domain.com
> #    ErrorLog logs/host.some_domain.com-error_log
> #    CustomLog logs/host.some_domain.com-access_log common
> #</VirtualHost>
> 
> #<VirtualHost _default_:*>
> #</VirtualHost>
> 
> 

Re: [SQL-Ledger-users] Still Cannot install sql-ledger

[Ibrahim S. <gtk...@ya...>]

Hi,
    Thanks for the advice. I have trying to make it work following your tips.
Unfortunately I have not been able. The problem still persist. I am attaching
here my httpd.conf file if you can try to seen where I am missing.

Sorry for bothering everybody, but really I want to run sql-ledger.

Thanks in advance

Ibrahim Shaame

Izzy Blacklock wrote:

> At 10:12 AM 21/04/01, you wrote:
> >Following my previous emails, here is a copy of the
> >screen I receive when calling setup.html (which is a
> >copy of setup.cgi). Whenever I try to click on "Add
> >User" (or List Users) I get a message : "Netscape in
> >unable to find the file or directory named
> >/var/lib/apache/sql-ledger/admin/$script, Check the
> >name and try again". When I try to call from
> >Netscape's File, Open Location, sometimes it says that
> >file not found and sometimes it brings me to
> >"http://localhost" with the famous apache page
> >announcing the success of of its installation.
> >
> >Thank you for your hints
>
> That's about what I'd expect from opening a cgi script in a web browser! :)
>
> I'm new to this as well so please forgive me if I'm wrong, but I think your
> problem is with your Apache setup.  You have to specifically tell Apache
> it's ok to run scripts outside of it's default cgi directory.  The answers
> are in the SQL-Ledger FAQ, but I too had problems understanding at
> first.  There's so many things to install and configure and if you've never
> done any of it before, it can be quite a daunting task! :(
>
> I think your problem is with Apache, so here's what you need to do for
> it.  The first thing is to add support for running .pl files as cgi scripts
> as the first point in the FAQ suggests.  Edit your httpd.conf file (mine
> was in /etc/httpd/httpd.conf) and searched for "To use CGI scripts".  You
> should find a section like this:
>
> # To use CGI scripts:
> AddHandler cgi-script .cgi
>
> If it isn't there already, add the following as is indicated in the FAQ.
>
> AddHandler cgi-script .pl
>
> Next I'd skip to the bottom of the FAQ to the section on security and
> follow all these steps.  Don't make the mistake I did and assume that
> Apache is running as the default user nobody.nogroup.  I found out mine was
> running as wwwrun.nogroup  which is the default configuration under
> SuSE.  If you search your httpd.conf file for "User/Group", you should find
> entries like this
>
> User wwwrun
> Group nogroup
>
> Change step 2 in the FAQ to match these settings.  Of course you will also
> want to change the path in all these steps to match where you've put the
> sql-Ledger directory.
>
> For step 4, I'd just copy the lines as he has them there (with adjustments
> to the sql-ledger path if needed) and place them in the httpd.conf
> file.  If you search for "<Directory" you'll find the section where you
> want to put them. Just move to the bottom of the last entry (they end with
> </Directory>) and past it all there.  Make sure the path is correct for
> where you put sql-ledger.
>
> I didn't understand step 5, and step 6 you can probably skip.
>
> Hope this helps.
>
> ...Izzy

[SQL-Ledger-users] PHP port

[Michael D. <mi...@mi...>]

Hi folks,

until now I resited but since the topic of PHP and some
other things came up several times allready ......

In no way I want to start any language/os/db discussion.

Last year I started to do a little project for a friend. He is running 
a motorbike repair shop and needs a management system for his business.

I started doing this in PHP and found SQL-Ledger when I had allready done 
quite a bit of coding. So I decided to integrate SQL-Ledger into
my project by porting it to PHP. It's maybe 80% finished and I stopped
working on this aspect for the moment because I needed to have other 
functionality working before this. Finishing the accounting is now maybe 
the 2nd or 3rd item on my list, so it should not be to long....

I decided not to mix perl and PHP to avoid complexity and because I had 
to make some changes to make it fit with the stuff I did before anyhow.

If you want to look at it goto: 

http://www.michaeldiehl/com/~michael/etc and try QDERP and QDERP
with a drop down menu. Try the frame version with the tree menu first;
it's more stable.

The login information is sqlledger/sqlledger. Use instance "000".
The translation is db based, so if you don't use english and there
are no entries maintained you'll see english anyhow.

Please don't delete anything and don't change the menu  so that other 
people can use the same account. 

I have two pop-up functions which might be interesting to port back
to perl:

1) calendar pop-up (to see it working go to "Master Data"->"Mat./Ser."
->"Create" and click on the "?" next to a date field.

2) generic search help (example on the same screen, the "?" next
to the vendor field)

There was a dicussion about finding Materials some time ago on the list.
Of course, with something like this you can't use text based browsers 
anymore....


There is a link to reports bug as well, if you feel like this, and even
a little bit of documentation. The README under documentation gives an
overview of the existing and planned features.

Since the stuff is not really in a releaseable state I've put a password
on the download link (sqlledger/sqlledger). The files are updated every night
so don't exspect everything to work.


Have fun, Michael

[SQL-Ledger-users] Showing currency with dots and commas

[Paolo B. <p.b...@ic...>]

Hi everyone,

for internal usage, I have made some changes to sql-ledger, in order to show 
dots and commas when showing currency. This is really useful, for seeing how 
much we have to show.

Two questions:

1) I have used the Number::Format module to produce the result. Is this 
acceptable for sql-ledger, so to include the patches in future releases ?

2) How can I modify number shown in reports ? They are put in an array, but 
then they are used to perform calculation. 

And last a plea: is it possible to see the 1.4 version as a development 
version of sql-ledger ? I would like to cooperate to the new version, as the 
things included (like more tax level, for example) are really really useful 
for me.

Regards

Paolo 

-- 
Paolo Bizzarri
Icube S.r.l.

[SQL-Ledger-users] Account Setups?

[Ian \(t. webguy\) <ia...@in...>]

Ok folks, I'm not an Accountant, and I've got some general 
questions/brainstorming ideas that I'd like to bring to the group so that I 
can configure this to my needs.

I've had SQL-Ledger installed and used for about 2 months now, however, 
since most of the employees here are die-hard windows nuts, getting anyone 
to use it (other than myself) have come to be just painful. 

I've made some touch-ups to the code, and I've made it a bit more 
user-friendly.   However, I am trying to figure out the best way to do the 
following: 

  1.) Track Petty Cash
  2.) Payroll (this is a big one)
  3.) Formatting Output to a Beta-Brite LED Sign (this is just to show me in 
the Data Center who has logged in and logged out so that I know when to kill 
my distributed.net daemon)
  4.) Split Invoicing (We charge a person 35% down and the rest at stages in 
the project.  Is there an easy way to do this?) 

There had been some discussion on the list as to #4 in the past few days, 
but nothing too serious has come out of it.  Can someone give me ideas on 
the other three? 

Thanks in Advance,
Ian
 ----
Webmaster, Internationalsportsagency.com
A division of Remani International
Web Division
P.O. Box 304
Ada, Ohio 45810 

(419) 772-1034
(419) 634-2289 FAX
(419) 204-0874 CELL
(888) 218-3996 PAGER 

"Network Administration:  It's a dirty job, but someone made me do it."
"Knowledge unburdened by Ignorance is shallow; Ignorance ungiven to 
Knowledge is the only kind for which to apologize." 

Re: [SQL-Ledger-users] Still Cannot install sql-ledger

[Izzy B. <iz...@ec...>]

At 06:01 AM 22/04/01, you wrote:

Thanks Andy,

I was obviously in need of sleep last night.  I only saw the first 6 steps 
last night.  When I saw the last step in my browser window I thought that 
was it and off to bed I went! :)  Thanks for filling in the missing steps 
for me and explaining step 5 and the reason for step 6.  It's a good habit 
to configure security assuming you do have local users and the threat of 
attack from inside as well as outside is very real.  Even if you only have 
a single server in a home based network protected by a firewall. :)


> >
> > I didn't understand step 5, and step 6 you can probably skip.
> >
>
>Step 5 simply means that you should create a .htaccess file in the admin
>directory.  This will not prevent users from executing (i.e. including) the
>config files, but it will prevent Apache from "handing" the files out to users
>who request:
>
>http://www....com/sql-ledger/admin/config
>
>Step 6 would probably be needed if the system has a number of "local" user
>acounts.
>
>Step 7 is also absolutely critical!  If your SQL-Ledger/Apache server is also
>your PostgreSQL server, use the following line in pg_hba.conf
>
>host         myledgerdb         127.0.0.1     255.255.255.255   password
>
>(assuming your database for SQL-Ledger is myledgerdb)
>
>Be sure NOT to have a line like this in the file:
>
>host         all        0.0.0.0       0.0.0.0           trust
>
>Step 8 is entirely about how granular your security control needs to be.
>Implement it to suit yourself.
>
>BFN
>Andy

Re: [SQL-Ledger-users] Still Cannot install sql-ledger

[Andrew B. <an...@hg...>]

>
> I didn't understand step 5, and step 6 you can probably skip.
>

Step 5 simply means that you should create a .htaccess file in the admin
directory.  This will not prevent users from executing (i.e. including) the
config files, but it will prevent Apache from "handing" the files out to users
who request:

http://www....com/sql-ledger/admin/config

Step 6 would probably be needed if the system has a number of "local" user
acounts.

Step 7 is also absolutely critical!  If your SQL-Ledger/Apache server is also
your PostgreSQL server, use the following line in pg_hba.conf

host         myledgerdb         127.0.0.1     255.255.255.255   password

(assuming your database for SQL-Ledger is myledgerdb)

Be sure NOT to have a line like this in the file:

host         all        0.0.0.0       0.0.0.0           trust

Step 8 is entirely about how granular your security control needs to be.
Implement it to suit yourself.

BFN
Andy

Re: [SQL-Ledger-users] Still Cannot install sql-ledger

[Izzy B. <iz...@ec...>]

At 10:12 AM 21/04/01, you wrote:
>Following my previous emails, here is a copy of the
>screen I receive when calling setup.html (which is a
>copy of setup.cgi). Whenever I try to click on "Add
>User" (or List Users) I get a message : "Netscape in
>unable to find the file or directory named
>/var/lib/apache/sql-ledger/admin/$script, Check the
>name and try again". When I try to call from
>Netscape's File, Open Location, sometimes it says that
>file not found and sometimes it brings me to
>"http://localhost" with the famous apache page
>announcing the success of of its installation.
>
>Thank you for your hints

That's about what I'd expect from opening a cgi script in a web browser! :)

I'm new to this as well so please forgive me if I'm wrong, but I think your 
problem is with your Apache setup.  You have to specifically tell Apache 
it's ok to run scripts outside of it's default cgi directory.  The answers 
are in the SQL-Ledger FAQ, but I too had problems understanding at 
first.  There's so many things to install and configure and if you've never 
done any of it before, it can be quite a daunting task! :(

I think your problem is with Apache, so here's what you need to do for 
it.  The first thing is to add support for running .pl files as cgi scripts 
as the first point in the FAQ suggests.  Edit your httpd.conf file (mine 
was in /etc/httpd/httpd.conf) and searched for "To use CGI scripts".  You 
should find a section like this:

# To use CGI scripts:
AddHandler cgi-script .cgi

If it isn't there already, add the following as is indicated in the FAQ.

AddHandler cgi-script .pl

Next I'd skip to the bottom of the FAQ to the section on security and 
follow all these steps.  Don't make the mistake I did and assume that 
Apache is running as the default user nobody.nogroup.  I found out mine was 
running as wwwrun.nogroup  which is the default configuration under 
SuSE.  If you search your httpd.conf file for "User/Group", you should find 
entries like this

User wwwrun
Group nogroup

Change step 2 in the FAQ to match these settings.  Of course you will also 
want to change the path in all these steps to match where you've put the 
sql-Ledger directory.

For step 4, I'd just copy the lines as he has them there (with adjustments 
to the sql-ledger path if needed) and place them in the httpd.conf 
file.  If you search for "<Directory" you'll find the section where you 
want to put them. Just move to the bottom of the last entry (they end with 
</Directory>) and past it all there.  Make sure the path is correct for 
where you put sql-ledger.

I didn't understand step 5, and step 6 you can probably skip.

Hope this helps.

...Izzy

Re: [SQL-Ledger-users] Partial payments

[Izzy B. <iz...@ec...>]

I know how you feel.  I've been so busy myself lately, I've hardly had time 
to reply to much mail. It's tough finding time to do the things you have 
to, never mind the things you want to.  :(

Take all the time you need.  My intention wasn't to hurry anyone along with 
their projects, just to get an update.  Thanks for providing it.  And 
thanks to Sylvain and Dieter too.  I look forward to seeing new code and 
hope to provide some of my own in the not too distant future.  Time 
permitting of course! ;)

...Izzy

At 08:23 AM 16/04/01, Rod Anderson wrote:
>On Sun, 15 Apr 2001, Izzy Blacklock wrote:
>
>
> > Rod Anderson offered to "launch" himself into creating customer
> > statements.  Something I'd very much like to see.  Hows it going?  Will
> > this make it into the next release?
>
>Once I find a couple of free hours I'll get it done.  I really needed it
>the end of the last couple of months because of a billing agreement I
>have with a couple of customers and kicked myself for not making the
>time to do it.  Dieter provided a very good description of how to
>accomplish it so it will be forthcoming... soon... yes... for sure...
>
>
>Rod
>--

[SQL-Ledger-users] contrib site and list???

[Izzy B. <iz...@ec...>]

Hey Dieter,

I was just thinking it may be useful to have a contrib ftp site and a 
mailing list for announcing contributions.  It'd make it easier for 
everyone to share things they've been working on.  I for one have been 
working on an invoice template I'd like to share once I'm finished it.  It 
can get messy trying to share things via a list.  Could you set this up at 
the sourceforge site?

Thanks.

...Izzy

Re: [SQL-Ledger-users] importing data from other acctng packages

[Dieter S. <dsi...@sq...>]

Individual transactions are recorded in acc_trans. The trans_id is the id
from the header tables (ar, gl, ap), accno refers to the account number in
the table chart and transdate is the transaction date.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Sat, 21 Apr 2001 py...@pa... wrote:

> Greetings, 
> 
> I'm in the process of trying to figure out 
> how to import data from other acctng packages (notably 
> Quicken).  The customer and vendor tables are easy 
> to figure out.  However, can anyone advise a set of 
> heuristics/routines for the rest?  I've got about three to 
> four years worth of data which I'd like to bring over.
> 
> Thanks!
> 
> 
> Max Pyziur                                     BRAMA - Gateway Ukraine
> py...@br...                                  http://www.brama.com/
> 
> 

[SQL-Ledger-users] importing data from other acctng packages

[<py...@pa...>]

Greetings, 

I'm in the process of trying to figure out 
how to import data from other acctng packages (notably 
Quicken).  The customer and vendor tables are easy 
to figure out.  However, can anyone advise a set of 
heuristics/routines for the rest?  I've got about three to 
four years worth of data which I'd like to bring over.

Thanks!


Max Pyziur                                     BRAMA - Gateway Ukraine
py...@br...                                  http://www.brama.com/

[SQL-Ledger-users] Still Cannot Install sql-leger -2

[Ibrahim S. <gtk...@ya...>]

Oof, I quickly pressed sent without attaching the
file. Here it is.

Sorry for that

Ibrahim

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

[SQL-Ledger-users] Still Cannot install sql-ledger

[Ibrahim S. <gtk...@ya...>]

Following my previous emails, here is a copy of the
screen I receive when calling setup.html (which is a
copy of setup.cgi). Whenever I try to click on "Add
User" (or List Users) I get a message : "Netscape in
unable to find the file or directory named
/var/lib/apache/sql-ledger/admin/$script, Check the
name and try again". When I try to call from
Netscape's File, Open Location, sometimes it says that
file not found and sometimes it brings me to
"http://localhost" with the famous apache page
announcing the success of of its installation.

Thank you for your hints

Ibrahim

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

Re: [SQL-Ledger-users] Off-toopic: Arabic (was: subscribe)

[Ibrahim S. <gtk...@ya...>]

Yes, it is said so. With KDE 1.?? I succeeded in getting Arabic characters only in
KEdit and that thanks to ar.kmap written by Alsaid. Unfortunately with KDE 2.0 I
used to get garbage when trying to surf with both Konquerer and Netscape. I don't
know how far sql-ledger supports Konquerer. If it does, then it will be interesting
to see how much we can benefit from it in porting sql-ledger to Arabic. I will try
during this weekend to sort out my Arabic installation and the installation of
sql-ledger itself, because inspite of the changes suggested by Dieter (upgraded to
perl-5.6.1), I still cannot go further than the first screen when trying to setup
user and netscape complains that it does not find the directory where the scripts
are lying, while it infact is on that same directory.

Thanks
Ibrahim

Jonas Smedegaard wrote:

> On Fri, 20 Apr 2001, Ibrahim Shaame wrote:
>
> > way I can. My only handicap is that since more than a year now I have not been
> > able to make my Linux machines speek Arabic, largely because I have not spared
> > enough time for that. But  your idea will definitely push me to take it more
> > seriously.
>
> It seems KDE and Konquerer has the best support for Arabic at the moment.
> Else there's a link from the (quite exciting) http://www.pango.org/ site
> to a "Arabic on Linux" resource page.
>
> And sorry, I don't do arabic myself, I had a visitor some months ago :-)
>
>  - Jonas
>
> --
> Jonas Smedegaard   <jo...@jo...>   http://www.jones.dk/~jonas/
> IT-guide dr. Jones    <dr...@jo...>   http://dr.jones.dk/    +45 40843136
> Debian GNU/Linux    <js...@de...>   http://www.debian.org/
> GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085  ECA9 9FB0 DB32 C024 40B8


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

[SQL-Ledger-users] Off-toopic: Arabic (was: subscribe)

[Jonas S. <jo...@jo...>]

On Fri, 20 Apr 2001, Ibrahim Shaame wrote:

> way I can. My only handicap is that since more than a year now I have not been
> able to make my Linux machines speek Arabic, largely because I have not spared
> enough time for that. But  your idea will definitely push me to take it more
> seriously.

It seems KDE and Konquerer has the best support for Arabic at the moment.
Else there's a link from the (quite exciting) http://www.pango.org/ site
to a "Arabic on Linux" resource page.

And sorry, I don't do arabic myself, I had a visitor some months ago :-)

 - Jonas

-- 
Jonas Smedegaard   <jo...@jo...>   http://www.jones.dk/~jonas/
IT-guide dr. Jones    <dr...@jo...>   http://dr.jones.dk/    +45 40843136
Debian GNU/Linux    <js...@de...>   http://www.debian.org/
GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085  ECA9 9FB0 DB32 C024 40B8

Re: [SQL-Ledger-users] subscribe

[Ibrahim S. <gtk...@ya...>]

Hi abdalla,
    That's a very a good idea. I am more than interested. It will be great to
have it in Arabic. I will be ready to proof read it and even participate in any
way I can. My only handicap is that since more than a year now I have not been
able to make my Linux machines speek Arabic, largely because I have not spared
enough time for that. But  your idea will definitely push me to take it more
seriously.

Regards

Ibrahim Shaame

abdulla wrote:

> can you please add me to the list.  Actually I am interested in meeting
> Arabic accountants because I am translating sql-ledger into Arabic.   I
> need someone to proof read the translated version and make sure that I have
> the correct accounting terms (I am an engineer by profession).  I had one
> accountant who helped me with some terms, but I need one or two more
> people.  Your name will be mentioned in the contributors section of the
> Arabic translation (if thats OK with you of course).


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

[SQL-Ledger-users] unsubscribe

[<drg...@ic...>]

On Thu, 19 April 2001, Richard Eicher II wrote:

> 
> When I try to log in I get:
> Error!
> 
> DBI::errstr
> 
> The error_log shows:
> 
> DBD::Pg::st execute failed: ERROR:  chart:
> Permission denied. at
> /var/www/html/sql-ledger/login.cgi line 80.
> 
> Anyone run into this problem?
> 
> Thank you for your time,
> Rick
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/

Gary Danko - President
Dynamic Resources Group, Inc.
gd...@dr...
ICQ#38631323
-------------
Get your FREE Virtual Office Suite at:
http://www.drgworld.com/x/id/1000


-------------------------------------------------------------
Sign up for ICQmail at http://www.icq.com/icqmail/signup.html

[SQL-Ledger-users] Error! DBI::errstr

[Richard E. II <win...@ya...>]

When I try to log in I get:
Error!

DBI::errstr

The error_log shows:

DBD::Pg::st execute failed: ERROR:  chart:
Permission denied. at
/var/www/html/sql-ledger/login.cgi line 80.

Anyone run into this problem?

Thank you for your time,
Rick

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

[SQL-Ledger-users] subscribe

[abdulla <alm...@po...>]

can you please add me to the list.  Actually I am interested in meeting 
Arabic accountants because I am translating sql-ledger into Arabic.   I 
need someone to proof read the translated version and make sure that I have 
the correct accounting terms (I am an engineer by profession).  I had one 
accountant who helped me with some terms, but I need one or two more 
people.  Your name will be mentioned in the contributors section of the 
Arabic translation (if thats OK with you of course).  

Re: [SQL-Ledger-users] Cannot start sql-ledger

[Martin L. <ma...@li...>]

Ibrahim Shaame wrote:
> 
> Hi everybody,
>     I am completely new to sql-ledger. I have installed version 1.2.9
> and seems to be to be correctly installed. When I try to call setup.cgi
> my netscape browser reads it as a text file. I renamed it (or rather
> integrated it in a html file) and here netscape would load it. But any
> click to the links on that page does not give anything; which means I
> cannot create a user, etc..
> Please bear with me, I don't know much of about html or cgi. I would
> appreciate your indications as of how to proceed.

http://sql-ledger.sourceforge.net/misc/faq.html might help

--
Martin Lillepuu | E-mail: ma...@li... | GSM: +372 51 56 450

Re: [SQL-Ledger-users] Cannot start sql-ledger

[Dieter S. <dsi...@sq...>]

With perl 5.003 you can't use the latest DBD-Pg version.

You got two choices. Install an early DBD-Pg version (0.69 ?)
or install at least perl 5.004

I recommend upgrading perl.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Wed, 18 Apr 2001, Ibrahim Shaame wrote:

> My config is :    Slackware  7.0
>                         Apache      1.3
>                         Perl           5.003_03
>                         Postgesql    7.0.3
> 
> Thanks
> 
> Ibrahim

Re: [SQL-Ledger-users] Internal error

[Dieter S. <dsi...@sq...>]

follow the instructions outlined in the FAQ
(http://sql-ledger.org/misc/faq.html) for a Redhat system.

Did you install the postgresql-devel rpm?


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Wed, 18 Apr 2001, Richard Eicher II wrote:

> Ok,
> 
> When I type "install DBD::Pg: I get,
> 
> Running make for M/ME/MERGL/DBD-Pg-0.96.tar.gz
>   Unwrapped into directory  
>           /root/.cpan/build/DBD-Pg-0.96
>   Makefile.PL returned status 65280
> Running make test
>   Make had some problems, maybe interupted? Won't
>              test
> Running make install
>   Make had some problems, maybe interupted? Won't
>               install
> 
> 
> Anyone know how to trouble shoot this problem?
> 
> Thank you for your time,
> rick
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
> 
> 

Re: [SQL-Ledger-users] Internal error

[Richard E. II <win...@ya...>]

Ok,

When I type "install DBD::Pg: I get,

Running make for M/ME/MERGL/DBD-Pg-0.96.tar.gz
  Unwrapped into directory  
          /root/.cpan/build/DBD-Pg-0.96
  Makefile.PL returned status 65280
Running make test
  Make had some problems, maybe interupted? Won't
             test
Running make install
  Make had some problems, maybe interupted? Won't
              install


Anyone know how to trouble shoot this problem?

Thank you for your time,
rick


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/