Differences

This shows you the differences between two versions of the page.

--- step_by_step_installation:debian [2014/10/20 15:03] – [Download and install full SQL-Ledger Network Version with LedgerCart] sweitmann
+++ step_by_step_installation:debian [2024/09/25 06:21] (current) – external edit 127.0.0.1
@@ Line 70: / Line 70: @@
   * select "internet site"
   * for SMTP relay host, enter the name of your mail server (smtp...)
+Now you can call the SQL-Ledger admin interface from your browser at
+    http://ip_of_your_server/ledger123/admin.pl
+and the login screen at
+    http://ip_of_your_server/ledger123/login.pl
 If you use another language than English, you may want to install an additional package that supports hyphenation in your language, for example
@@ Line 78: / Line 86: @@
     apt-cache search texlive-lang
-===== SQL-Ledger =====
-We will install SQL-Ledger in the folder /usr/local/sql-ledger. For this, we change to /usr/local:
-    cd /usr/local
-You have two versions to choose between, either **the original SQL-Ledger**, developed by [[DWS systems]], or the **Enhanced** **SQL-Ledger**, provided by [[Ledger123]].
-To install the **original SQL-Ledger**, type:
-    git clone git://github.com/Tekki/sql-ledger.git
-Because of a security leak , the template editor is disabled in the above repository. It is recommended not to use the master, but the full branch:
-    cd /usr/local/sql-ledger
-    git checkout -b full origin/full
-The// full// branch contains some additional features like WLprinter (see below) or an extended admin interface.
-For the **Ledger123** type:
-   git clone git://github.com/ledger123/ledger123.git sql-ledger
-Next, you have to create a spool directory, change the access rights to some files and folders and copy sql-ledger.conf.default to sql-ledger.conf.
-    cd /usr/local/sql-ledger
-    mkdir spool
-    chown -hR www-data.www-data users templates css spool
-    cp sql-ledger.conf.default sql-ledger.conf
-If the remote repositories changed, you update your installation with
-    cd /usr/local/sql-ledger
-    git pull
-In the full branch of the original SQL-Ledger, you have the possibility to update the software using the Software Administration function in the Admin interface. Before it works, you have to give the web server the right to call the git commands. For this, type
-    visudo
-Then add the following line to the user privilege section:
-    www-data ALL=(ALL) NOPASSWD: /usr/bin/git
 ===== Mail transport =====
@@ Line 142: / Line 108: @@
 and move to "# available printers". There you see an example of two printers. Replace them with your own printer or printers. The name on the left side is the name you will see in SQL-Ledger, the one on the right side immediately after -P is the name by which the printer is known to the operating system.
-===== WLprinter =====
-WLprinter is a program that allows to print from SQL-Ledger directly and without further installation or configuration to printers connected to client computers. On the client side, it requires Java and on Windows machines Adobe Reader. After the installation, SQL-Ledger automatically provides an additional printer "WLprinter".
-**Original Version**
-WLprinter is part of the full branch. If you followed the above instructions, this program already installed on your server. It is recommended that you copy the config file wlprinter.conf.default to wlprinter.conf, so you can edit it:
-cp wlprinter.conf.default wlprinter.conf
-**Ledger123**
-WLprinter isn't available for Ledger123.
-If you didn't add printers with CUPS and edit sql-ledger.conf before, open it now with
-    nano /usr/local/sql-ledger.conf
-and change the printer definition to
-    %printer = ( );
-===== Database set up =====
-Edit the Postgresql database configuration.
-    nano /etc/postgresql/9.1/main/pg_hba.conf
-Change the line
-    local    all    all    ident
-to
-    local    all    all    trust
-Restart the database
-    /etc/init.d/postgresql restart
-Create a user for SQL-Ledger
-    su postgres -c "createuser -d -S -R sql-ledger"
-===== Web server set up =====
-Your web server has to know where to find SQL-Ledger. We add a new configuration file and restart the server.
-    cd /etc/apache2/sites-available/
-    wget https://raw.github.com/Tekki/sql-ledger/full/doc/sql-ledger.httpd.conf
-    cd ../sites-enabled/
-    ln -s ../sites-available/sql-ledger 001-sql-ledger
-    mv sql-ledger.httpd.conf sql-ledger
-    /etc/init.d/apache2 restart
-It should now be possible to access SQL-Ledger. As you didn't specify an address for your server, it was received from DHCP. Enter the following command:
-    ifconfig eth0
-You see the address after "inet addr:". In a private network, it will be something starting with "192.168...". Open your web browser, enter this address followed by "/sql-ledger". The SQL-Ledger login screen has to appear.
 ===== Optional components and settings =====
@@ Line 228: / Line 136: @@
 ====Webmin====
-Webmin is a web based administration interface for Linux. It is very convenient for a lot of administration tasks. The following code is for 1.580, you may have to change the version number. Check the actual version at the [[Webmin homepage]] .
+Webmin is a web based administration interface for Linux. It is very convenient for a lot of administration tasks. The following code is for 1.580, you may have to change the version number. Check the actual version at the [[http://www.webmin.com/|Webmin homepage]] .
     cd /tmp
-    wget http://prdownloads.sourceforge.net/webadmin/webmin_1.670_all.deb
+    wget http://prdownloads.sourceforge.net/webadmin/webmin_1.710_all.deb
     apt-get install libapt-pkg-perl apt-show-versions libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl
-    dpkg --install webmin_1.670_all.deb
+    dpkg --install webmin_1.710_all.deb
     If you have installed the Samba server, Webmin is now available at