BambooInvoice: A Simple, Opensource Online Invoicing Software
BambooInvoice is easy to use and it is built on the excellent CodeIgniter project using modern coding standards. BambooInvoice sits on your server. Its your data. You never need to trust your invoicing data to anyone else, and you can get it out of the system
easily. BambooInvoice is released under the GPL
In this tutorial i will show you how to install BambooInvoice with LAMP server. If you haven’t installed LAMP sever, just use any one of the following link to setup LAMP server.
Create Database and User for BambooInvoice
For instance, here i am going to create a database called “bamboodb” and database user called “bamboouser” with password “centos” for ProcessWire. You can define database and user as per your liking.
# mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 5.5.31-MariaDB MariaDB Server Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> create database bamboodb; Query OK, 1 row affected (0.02 sec) MariaDB [(none)]> GRANT ALL ON bamboodb.* TO bamboouser@localhost IDENTIFIED BY 'centos'; Query OK, 0 rows affected (0.01 sec) MariaDB [(none)]> flush privileges; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> exit Bye
Allow the apache default port “80″ through iptables/router. Edit file /etc/sysconfig/iptables,
# vi /etc/sysconfig/iptables
Add the following lines.
-A INPUT -p tcp -m state --state NEW --dport 80 -j ACCEPT
Now restart the iptables service.
# /etc/init.d/iptables restart
Restart the system to take effect the saved changes.
Download the latest version from the BambooInvoice website.
# wget http://bambooinvoice.org/img/bambooinvoice_089.zip
Extract it with command:
# unzip bambooinvoice_089.zip
Copy the extracted folder to your web root.
# mv bambooinvoice/ /var/www/html/bambooinvoice
Set BambooInvoice Base URL
Open config.php file.
# cd /var/www/html/bambooinvoice/ # nano bamboo_system_files/application/config/config.php
Set the base URL path.
Here is my base url path. You can use either domain name or ip address.
$config['base_url'] = 'http://192.168.1.201/bambooinvoice/';
Set MySQL database details
Open database.php file.
# nano bamboo_system_files/application/config/database.php
Enter the mysql database name, database user and password.
$active_group = 'default'; $db['default']['hostname'] = 'localhost'; $db['default']['username'] = 'bamboouser'; $db['default']['password'] = 'centos'; $db['default']['database'] = 'bamboodb'; $db['default']['dbdriver'] = 'mysql'; $db['default']['dbprefix'] = 'bamboo_'; $db['default']['active_r'] = TRUE; $db['default']['pconnect'] = FALSE; $db['default']['db_debug'] = TRUE; $db['default']['cache_on'] = FALSE; $db['default']['cachedir'] = '';
Open php.ini file.
# nano /etc/php.ini
Find the following lines and set your time zone.
[Date] ; Defines the default timezone used by the date functions ; http://www.php.net/manual/en/datetime.configuration.php#ini.date.timezone date.timezone = Asia/Calcutta
Save and close the file. Restart apache service to take effect the saved changes.
# service httpd restart
Set write permissions to the following folders as shown below.
# chmod -R 777 invoices_temp/ img/
Open your browser and type “http://ip-address/bambooinvoice” or “http://domain-name/bambooinvoice”. You will see the following screen. Click on the “You can install it now” link.
You you will be asked to enter your email id, primary contact and password. Your email is used both as your “username” for logging in, and also for any email tasks, such as sending invoices, resetting passwords, etc. The Primary Contact name is used in the “from” field when sending out invoices over email.
# rm /var/www/html/bambooinvoice/bamboo_system_files/application/controllers/install.php
Click on the login link to go to the administrative portal. Use the mail id that you’ve entered during installation as username and the password you’ve created before.
Click on the Settings icon and update your company details in the Accounts settings section. Click Save settings.
In the Root window, click on the Clients -> Create new client. Enter the client details and click Save client.
Click on the New Invoice link found in the left pane. Select the client from the client drop-down link. Enter the details and click Create Invoice.