0830.html 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121
  1. <!DOCTYPE html>
  2. <html lang="en" xmlns="http://www.w3.org/1999/xhtml">
  3. <head>
  4. <title>Install Akaunting - Open Source Accounting Software - On Windows</title>
  5. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  6. <meta charset="UTF-8">
  7. <meta name="keywords" content="Home Lab,Home Lab Ideas,Install Guide,Self-Hosted,Web Based,Web Based Tools,Accounting,Accounting Software,Akaunting,Browser Based,Expense Tracker,Expense Tracking,Homelab,Income Tracking,Invoice,Invoicing Software,Payment Manager,Windows,Microsoft Windows,PHP,XAMPP,PHP Based Application,WA,WAMP,MySQL,MariaDB,How To,Tutorial,i12bretro">
  8. <meta name="author" content="i12bretro">
  9. <meta name="description" content="Install Akaunting - Open Source Accounting Software - On Windows">
  10. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  11. <meta name="revised" content="10/01/2023 10:19:44 AM" />
  12. <link rel="icon" type="image/x-icon" href="includes/favicon.ico">
  13. <script type="text/javascript" src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
  14. <script type="text/javascript" src="includes/js/steps.js"></script>
  15. <link href="css/steps.css" rel="stylesheet" type="text/css" />
  16. </head>
  17. <body>
  18. <div id="gridContainer">
  19. <div class="topMargin"></div>
  20. <div id="listName" class="topMargin">
  21. <h1>Install Akaunting - Open Source Accounting Software - On Windows</h1>
  22. </div>
  23. <div></div>
  24. <div id="content">
  25. <h2>What is Akaunting?</h2>
  26. <blockquote><em>Akaunting is a free, open source and online accounting software designed for small businesses and freelancers. -<a href="https://github.com/akaunting/akaunting" target="_blank">https://github.com/akaunting/akaunting</a></em></blockquote>
  27. <h2>Installation</h2>
  28. <ol>
  29. <li>Download XAMPP <a href="https://sourceforge.net/projects/xampp/files/XAMPP%20Windows/" target="_blank">Download</a></li>
  30. <li>Download Akaunting <a href="https://github.com/akaunting/akaunting/releases/latest" target="_blank">Download</a></li>
  31. <li><label for="cb_li_917989_0">Download Microsoft Visual C++ </label><label for="cb_li_917989_0"><a href="https://aka.ms/vs/16/release/vc_redist.x64.exe" target="_blank">Download</a></label></li>
  32. <li>Install Microsoft Visual C++</li>
  33. <li>Right click the downloaded XAMPP .zip file &gt; Extract All...</li>
  34. <li>Right click the downloaded Akaunting .zip file &gt; Extract All...</li>
  35. <li>Rename the extacted folder to akaunting</li>
  36. <li>Cut the akaunting folder inside the XAMPP/htdocs directory</li>
  37. <li>Navigate into the akaunting folder &gt; Create a copy of .env.example</li>
  38. <li>Rename the copy .env</li>
  39. <li>Edit the .env file in a text editor</li>
  40. <li>Edit the values in .env as follows
  41. <p>APP_URL=http://DNSorIP/akaunting<br />
  42. LOCALE=en-US<br />
  43. <br />
  44. DB_HOST=localhost<br />
  45. DB_PORT=3306<br />
  46. <br />
  47. DB_NAME=akaunting<br />
  48. DB_USERNAME=akaunting_rw<br />
  49. DB_PASSWORD=@kaunt1ng!</p>
  50. <p>DB_PREFIX=</p>
  51. </li>
  52. <li>Save the changes to .env and close the text editor</li>
  53. <li>Navigate back to the Downloads directory and cut the extracted XAMPP directory to a safe location to run from, C:\Program Files for example</li>
  54. <li>Run XAMPP/setup_xampp.bat to update the configuration files with the new server location</li>
  55. <li>Navigate into XAMPP/PHP and edit php.ini in a text editor</li>
  56. <li>Find the list of extensions and make sure the following are enabled by removing the ; at the start of the line
  57. <p>extension=gd<br />
  58. extension=intl</p>
  59. </li>
  60. <li>Save the changes to php.ini and close the text editor</li>
  61. <li>Right click the Start button &gt; Settings &gt; About</li>
  62. <li>Click the Advanced system settings option</li>
  63. <li>Click the Environment Variables...</li>
  64. <li>Edit the System Path variable</li>
  65. <li>Click the New button</li>
  66. <li>Add the PHP installation directory (ie C:\Program Files\xampp\PHP\)</li>
  67. <li>Click OK to all open dialog windows</li>
  68. <li>Back in File Explorer, run XAMPP/xampp-control.exe</li>
  69. <li>Click the Start buttons next to Apache and MySQL</li>
  70. <li>Navigate to XAMPP/mysql/bin</li>
  71. <li>Hold the SHIFT key and right click in the white space &gt; Open PowerShell window here...</li>
  72. <li>Run the following commands in the PowerShell window to setup the database
  73. <div class="codeBlock PS"># connect to mysql<br />
  74. .\mysql -u root<br />
  75. # create the database<br />
  76. CREATE DATABASE akaunting;<br />
  77. # create the service account<br />
  78. GRANT ALL ON akaunting.* to &#39;akaunting_rw&#39;@&#39;localhost&#39; IDENTIFIED BY &#39;@kaunt1ng!&#39;;<br />
  79. # flush privileges<br />
  80. FLUSH PRIVILEGES;<br />
  81. # close mysql connection<br />
  82. EXIT;<br />
  83. # change directory to the akaunting folder<br />
  84. cd ..\..\htdocs\akaunting<br />
  85. # generate an app key<br />
  86. php artisan key:generate<br />
  87. # exit powershell<br />
  88. exit</div>
  89. </li>
  90. </ol>
  91. <h2>Akaunting Web Installer</h2>
  92. <ol>
  93. <li>Open a web browser and navigate to http://DNSorIP/akaunting</li>
  94. <li>Select a Language &gt; Click Next</li>
  95. <li>Complete the Database form as shown below
  96. <p>Hostname: localhost<br />
  97. Username: akaunting_rw<br />
  98. Password: @kaunt1ng!<br />
  99. Database: akaunting</p>
  100. </li>
  101. <li>Click Next</li>
  102. <li>Complete the Admin form by entering a Company Name, Company Email, Admin Email and Admin Password &gt; Click Next</li>
  103. <li>Log in with the Admin username and password</li>
  104. <li>On the Company tab, scroll to the bottom of the form and click Skip this step</li>
  105. <li>Select/add the desired currencies &gt; Click Next</li>
  106. <li>Click Next on the Taxes tab</li>
  107. <li>Click the Create your first invoice link</li>
  108. <li>Welcome to Akaunting</li>
  109. </ol>
  110. <p>Source: <a href="https://akaunting.com/docs/installation" target="_blank">https://akaunting.com/docs/installation</a></p> </div>
  111. </div>
  112. </body>
  113. </html>