SHARE
TWEET

Install SQL-Ledger (Dutch) on Debian Wheezy

henrydenhengst May 3rd, 2014 271 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. #!/bin/bash
  2. #
  3. createuser --no-superuser --no-createdb --no-createrole mypguser
  4. createdb -O mypguser mypgdatabase
  5. apt-get -y install ssh acpid apache2 postgresql libdbi-perl libdbd-pg-perl git-core gitweb postfix mailutils texlive texlive-lang-dutch cups hplip hpijs cups-driver-gutenprint
  6. cupsctl --remote-admin
  7. cupsctl --share-printers --remote-any
  8. cd /usr/local
  9. git clone git://github.com/Tekki/sql-ledger.git
  10. cd /usr/local/sql-ledger
  11. chown -hR www-data:www-data users templates css doc
  12. cd /etc/apache2/sites-available/
  13. wget -c https://raw.github.com/Tekki/sql-ledger/full/doc/sql-ledger.httpd.conf
  14. mv sql-ledger.httpd.conf sql-ledger
  15. cd /etc/apache2/sites-enabled
  16. ln -s /etc/apache2/sites-available/sql-ledger 001-sql-ledger
  17. /etc/init.d/apache2 reload
  18. #
  19. # CONTINUE INSTALLATION WITH WEBBROWSER !!!
  20. #
  21. # CREATE DATASET:
  22. # ---------------
  23. # Load your web browser and connect to
  24. # http://localhost/sql-ledger/admin.pl
  25. #
  26. # There is no password so just hit the Enter key or click
  27. # on "Continue".
  28. #
  29. # Check the appropriate database driver if there is more
  30. # than one installed.
  31. #
  32. # Click on "Add Dataset"
  33. #
  34. # Host [database host]               Port [      ]
  35. # User [database user]           Password [database password]
  36. # Connect to [template1 or your_database]
  37. #
  38. # Note: template1 or your_database is required to make a connection
  39. # to access the database, nothing will be created yet.
  40. #
  41. # Click on "Continue"
  42. #
  43. # Dataset [your_dataset]
  44. # Company [name of the company]
  45. # Templates [template set to create]
  46. # Multibyte Encoding [                 ]
  47. #
  48. # Select a chart of accounts and click on "Continue".
  49. #
  50. # Your tables will now be created and the chart of accounts
  51. # will be loaded.
  52. #
  53. #
  54. # CREATE DATASET WITHOUT CREATE PRIVILEGES:
  55. # -----------------------------------------
  56. # If you cannot create a database, most ISPs won't let you
  57. # directly access the database, you can still create the
  58. # neccessary files to run SQL-Ledger.
  59. #
  60. # 1) use your database manager (pgadmin, etc) and log in with the
  61. # database user your ISP has assigned to you
  62. # 2) create a blank database
  63. # 3) go to the previous step CREATE DATASET and enter
  64. # the name of the database in the field "Dataset".
  65. #
  66. #
  67. # LOAD THE PROGRAM:
  68. # ----------------------------
  69. # Load your web browser and connect to
  70. # http://localhost/sql-ledger/login.pl
  71. #
  72. #
  73. # SET UP USERS:
  74. # -------------
  75. # Log into SQL-Ledger as user 'admin'
  76. #
  77. # If you have more than one dataset you can either
  78. # choose from a list of datasets or log in directly
  79. # to the dataset by appending @dataset to admin
  80. #
  81. # Go HR -> Add Employee
  82. #
  83. # In the field 'login' assign a login for the employee.
  84. #
  85. # Note: The same interface is used to remove a login,
  86. # simply remove the login and the employee will no
  87. # longer be able to log in.
  88. #
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top