Toggle navigation

SimpleInvoices Image Guide

Version 2011.1

Websoft9 SimpleInvoices20 is a pre-configured, ready to run image for running ProcessWire on Alibaba Cloud.

Simple Invoices is a free, open source, web based invoicing system that you can install on your server/pc or have hosted by one of our services providers.Tt’s open source, developed by the community and it’s yours,Easily track your finances, send invoices as PDF’s and hundreds of other great features

Application Software(SimpleInvoices2011.1)
Software directory: /data/wwwroot/processwire

Application Server(PHP5.5,APACHE2.4)
PHP Configuration File: /etc/php/5.5/apache2/php.ini
Apache Vhost Configuration File: /etc/apache2/sites-available
Apache Log Files:/var/log/apache2

Database(MYSQL5.5)
Database install directory: /usr/share/mysql
Database data directory: /data/mysql
Database Configuration File: /etc/mysql/mysql.conf.d/mysqld.cnf
PhpMyAdmin install directory: /usr/share/phpmyadmin
Kown more from MySQL User Guide

After the installation of Image,please verify it

  • Login on Alibaba Cloud console,get you Internet IP Address
  • Open you Chrome or Firefox on your local PC,visit the http://Internet IP Address/
  • If verify successfully,you can enter the Start Installation page of this Image
  • If no response from browser,please check the Security Group settings to ensure that port 80 is been allowed

Using Chrome or Firefox to visit: http://Internet IP Address/ to start the tapplication installation process.It is recommended to complete two steps before the installation:

  • Domain resolution if you want to use (Add an A record to the Internet IP Address of Server from your Domain Control Panel)
  • Modify the MySQL password of Root through PhpMyAdmin
  • Using SFTP to modify the config file:/data/wwwroot/simpleinvoices/config/config.ini

Then access the installation page by domain directly and complete the installation wizard for the following steps:

  1. Visit http://Internet IP Address or http://yourdomain to enter the start page of installation
  2. Click the “Install Database” and Click the ‘Install Essential Data’ button to continue the installation of Simple Invoices
  3. The Simple Invoices essential data has been imported. You can select to just start using Simple Invoices now or install sample data
  4. After the Sample Data install,the system will log in to backend automatic

  5. Then we suggest you should change the password of Administrator like below

Three usernames and passwords are required for application installation, application using, andapplication maintenance:

1、ResourceSpace:Username and password is set by youself when installation,
Backend URL:http://Internet IP Address/
2、MySQL Database:Default username and password is root/123456,
Control Panel URL:http://Internet ip Address/phpmyadmin
3、Linux Server:Username is root,Password is set by youself when buying.You can reset the password through console and restart the Server if you have forgotten it.Please Using the Putty for Remote and WinSCP for SFTP

Routine backup (archives) of the database and application setup is essential to ensure failover is smooth.you can use Manual Backup as following steps:

  1. Download the entire software directory(/data/wwwroot/simpleinvoices) by SFTP or other tools
  2. Visit http://< Internet IP Address >/phpMyAdmin,login in to the phpMyAdmin Panel
  3. Select your database,then Export it
  4. Click “go” button for backup process,and then download the SQL backup file

Before upgrade you should put the site down for maintenance and always Backup your code, data and config files.

Upgrading Simple Invoices from one version to another is very simple, just follow the below steps

  1. Take a backup of your current database.
    1. You can do this via Simple Invoices, just go to the ‘Settings’ menu and select ‘Backup Database’
  2. Download the updated version of Simple Invoices from our website
  3. Make a copy of your config/config.ini file which is located in the config folder
  4. Unzip the contents of the Simple Invoices file which you downloaded into your simpleinvoices directory
  5. Open up the config/config.ini file that’s in the config directory and enter your database details
  6. Open up Simple Invoices in your browser (usually http://Internet IP Address/simpleinvoices)
    1. If there are sql patches to be applied to the database
      1. Simple Invoices will now display the ‘Upgrade Manager’ and list all the sql patches that will be automatically applied
      2. Just click ‘Upgrade’ and Simple Invoices will upgrade your database
    2. If there are no sql patches to be applied Simple Invoices will ‘just work’ as normal, no ‘Upgrade’ options will be presented
  7. You’re done, use Simple Invoices as normal

If you want to modify default database password before installation,you should complete the following steps:

  1. Log in to PhpMyAdmin to modify the password of root
  2. Using SFTP to modify the config file:/data/wwwroot/simpleinvoices/config/config.ini

Simple Invoices is currently translated into about 20 languages. All translations are done using Transifex

Go to https://www.transifex.com/projects/p/SimpleInvoices/ and see if the language you are translating has been started. If so

  1. Sign up for a Transifex account
  2. Open up the selected language
  3. Edit the translation online – refer screenshot below
  4. We’ll merge these Transifex translations back into Simple Invoices on a regular basis

Websoft9 Mantis Image have installed the phpMyadmin

Following is the step for access phpMyadmin

  1. Open Chrome or Firefox on your local PC
  2. visit the http://Internet IP Address/phpMyAdmin,you can enter the login page
  3. select you language,Username:root,Password:123456
  4. Click the button “Go”

You can use the command to manage the services for Server.Please choose the corresponding command mode according to different types of operating system

Ubuntu14.04 Linux

Apache http service

~# service apache2 start
~# service apache2 stop
~# service apache2 restart
~# service apache2 reload  #Configuration file

MySQL  service

~# service mysqld start 
~# service mysqld stop 
~# service mysqld restart 

Else

~# a2dismod ModuleName  #disable Apache2 module
~# a2enmod ModuleName    #enable Apache2 module
~# a2ensite Configuration      #enable vhost configuration
~# a2dissiteConfiguration      #disable vhost configuration

When install new extension from back-end it will not successful,may be the permissions of file and folder is not appropriate,you should change it

Web site root permissions to follow:
file 644,folder 755 ,Permissions Users and groups www-data
If there is a file permissions problem, execute the following three commands:

chown -R www-data.www-data /data/wwwroot/simpleinvoices
find /data/wwwroot/default/simpleinvoices -type d -exec chmod 755 {} \;
find /data/wwwroot/default/simpleinvoices -type f -exec chmod 644 {} \;

Modify the /etc/php/5.5/apache2/php.ini file to increase the allowed size for uploads:

; Maximum size of POST data that PHP will accept.
post_max_size = 16M
; Maximum allowed size for uploaded files.
upload_max_filesize = 16M

then,restart the apache

# service apache2 restart

The PHP configuration file allows you to configure the modules enabled, the email settings or the size of the upload files. It is located at /etc/php/5.5/apache2/php.ini.

There are some PHP settings that need to be sufficient to install.

e.g The values for PHP.ini below are suggested values only.

  • memory_limit – Minimum: 256M Recommended: 1G or better
  • upload_max_filesize – Minimum: 20M
  • post_max_size – Minimum: 20M
  • max_execution_time: At Least 120 Recommended: 300

After modifying the PHP configuration file, restart both Apache and PHP-FPM for the changes to take effect:

# service apache2 restart

If you receive the message “Maximum execution time of 30 seconds exceeded”.You may also like to extend the max_execution_time for PHP and you can modify it by two methods below

Method one: edit your /etc/php/5.5/apache2/php.ini

; Maximum execution time of each script, in seconds
; http://php.net/max-execution-time
; Note: This directive is hardcoded to 0 for the CLI SAPI
max_execution_time = 90
; Maximum amount of time each script may spend parsing request data. It's a good
; idea to limit this time on productions servers in order to eliminate unexpectedly
; long running scripts.

After modifying the PHP configuration file, restart both Apache and PHP-FPM for the changes to take effect:

# service apache2 restart

Method two: edit your .htaccess:


<IfModule mod_php5.c>
php_value max_execution_time 90
</IfModule>