• gdel
  • New member
  • Offline
  • From: USA
  • Registered: 01/24/2013
  • Posts: 5

Topic: need installation help

I am trying to install Frontaccounting on a computer running Kubuntu.  I have been using linux for several years, but don't have a lot of knowledge about the inner workings of linux. I used Synaptic to download Apache2, MySQL5 and PHP. Listed below is the detail error listing:

setting up frontaccounting (2.2.10-3) ...
* Reloading web server config apache2                                          apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
                                                                         [ OK ]
ERROR 1064 (42000) at line 12: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=2' at line 7
dpkg: error processing frontaccounting (--configure):
subprocess installed post-installation script returned error exit status 1
Setting up kfind (4:4.8.5-0ubuntu0.1) ...
No apport report written because MaxReports is reached already
                                                              Errors were encountered while processing:
frontaccounting
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install.  Trying to recover:
Setting up frontaccounting (2.2.10-3) ...
* Reloading web server config apache2                                          apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
                                                                         [ OK ]
ERROR 1064 (42000) at line 12: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=2' at line 7
dpkg: error processing frontaccounting (--configure):
subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
frontaccounting

Can someone tell me what I am missing?

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: need installation help

Please download and install the latest release of FrontAccounting (2.3.14) from Sourceforge

Your server has a newer version of MySql.

/Joe

  • Registered: 12/25/2007
  • Posts: 2,448

Re: need installation help

Unfortunately Debian/Ubuntu package is very old, and the problem arises due to changes in MySQL syntax (since some version TYPE is not allowed in CREATE, ENGINE should be used instead). Please follow Joe's advice.

Janusz

  • gdel
  • New member
  • Offline
  • From: USA
  • Registered: 01/24/2013
  • Posts: 5

Re: need installation help

OK, I downloaded Frontaccounting (2.3.14) and extracted it.  What is my next step?

  • Registered: 12/25/2007
  • Posts: 2,448

Re: need installation help

I guess you have extracted FA traball in some subfolder under your www document_root (e.g. /var/www/frontaccounting) ?
Then just run installer in your browser (just http://localhost/frontaccounting/index.php) and follow instructions.
Janusz

  • gdel
  • New member
  • Offline
  • From: USA
  • Registered: 01/24/2013
  • Posts: 5

Re: need installation help

OK!  Progress .....
I know that I am being a pain, but I really am trying to learn.

This is how my screen looks now.

Application cannot be installed. Please fix problems listed below in red, and press Refresh button.
Logo
FrontAccouting ERP Installation Wizard
Step 1: System Diagnostics

Select install wizard language:     English

Test     Test type     Value     Comments
PHP version >=4.3.3     Required     5.4.6-1ubuntu1.1     Ok
PHP MySQL extension     Required     No     Your PHP has to have MySQL extension enabled.
Server system     Info     Linux     Ok
Database auth file     Required     ../config_db.php     Can't write '../config_db.php' file. Check FA directory write permissions.
Main config file     Required     ../config.php     Can't write '../config.php' file. Check FA directory write permissions.
Company subdirectories consistency     Required     ../company/0/*
../company/0/*/images
../company/0/*/pdf_files
../company/0/*/backup
../company/0/*/js_cache     Ok
Language configuration consistency     Required         Ok
Temporary directory     Required     ../tmp     Ok
Session save path     Info     /var/lib/php5     Ok
Extensions system     Required     ../installed_extensions.php
../company/0/*/installed_extensions.php
../modules
../modules/_cache
../themes
../sql
OpenSSL PHP extension     '../installed_extensions.php' is not writeable
Extensions configuration files and directories should be writeable


Back

01/25/2013 | 05:19 pm    
FrontAccounting 2.3.14 - Theme: default -
FrontAccounting

Ubuntu does not allow a root login.  Root commands must be done through "sudo".
What are my next steps?

  • From: Canada, BC, Lantzville
  • Registered: 01/07/2013
  • Posts: 135

Re: need installation help

It looks to me like you have to fix the following problems before you can proceed further:

gdel wrote:

PHP MySQL extension     Required     No     Your PHP has to have MySQL extension enabled.

You need to enable the MySQL module to PHP.  I think this only requires an edit to the PHP configuration file, but I'm not sure.

gdel wrote:

Database auth file     Required     ../config_db.php     Can't write '../config_db.php' file. Check FA directory write permissions.
Main config file     Required     ../config.php     Can't write '../config.php' file. Check FA directory write permissions.

It looks like the permissions for config.php and config_db.php are wrong.  To fix this from a terminal command line, execute this command in the root FA directory (eg. /var/www/frontaccounting):

sudo chmod 755 config*.php

Btw, be sure to change the permissions back to not-writeable once you get FA totally set-up as having the config*.php files writeable is a security risk.

gdel wrote:

OpenSSL PHP extension     '../installed_extensions.php' is not writeable
Extensions configuration files and directories should be writeable

Same problem as above, so change to the directory where the installed_extension.php is located (I can't remember it offhand) and execute the same command as above but change "config*php" to "installed_extension.php".

Once that's done, run the install script again to see if everything is now okay and you can proceed.  If not, keep fixing problems until you can.

Hope that helps...

Regards,

Chris

chrison's Website

  • gdel
  • New member
  • Offline
  • From: USA
  • Registered: 01/24/2013
  • Posts: 5

Re: need installation help

OK....
More progress.
I cleared all errors except:

PHP MySQL extension     Required     No     Your PHP has to have MySQL extension enabled.

Nothing I have tried so far has worked.  Any other suggestions?

9 Reply by chrison (edited by chrison 01/26/2013 01:13:23 am)

  • From: Canada, BC, Lantzville
  • Registered: 01/07/2013
  • Posts: 135

Re: need installation help

It sounds like the MySQL extension to PHP needs to be implemented.  More info on how to do this is on the PHP website.  Apparently, FA uses the MySQL extenstion (not MySQLi) so that's the one you want to implement.

Hope this helps...

Regards,

Chris

chrison's Website

  • gdel
  • New member
  • Offline
  • From: USA
  • Registered: 01/24/2013
  • Posts: 5

Re: need installation help

All errors are now cleared.  As I said before, I am new at this, but I really am trying to learn.  Thanks for the help so far.

Now on to the contimue button at the bottom of the page.

  • From: Canada, BC, Lantzville
  • Registered: 01/07/2013
  • Posts: 135

Re: need installation help

Cool!  Congratulations! cool  Good luck with the rest of the installation process!

Once you get it installed, take a look at the Wiki for guidance on how to get FA up and running.  And, of course, feel free to post in the forum if you need help.

Glad I was able to assist...

Regards,

Chris

chrison's Website