FrontAccounting forum — need installation help

Re: need installation help

2013-01-26T02:25:15Z

Cool! Congratulations! 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

Re: need installation help

2013-01-26T01:58:24Z

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.

Re: need installation help

2013-01-26T01:09:07Z

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

Re: need installation help

2013-01-25T23:46:18Z

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?

Re: need installation help

2013-01-25T19:06:40Z

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

Re: need installation help

2013-01-25T16:45:03Z

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?

Re: need installation help

2013-01-24T22:16:24Z

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

Re: need installation help

2013-01-24T17:24:55Z

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

Re: need installation help

2013-01-24T13:00:28Z

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

Re: need installation help

2013-01-24T07:55:57Z

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

Your server has a newer version of MySql.

/Joe

need installation help

2013-01-24T03:57:01Z

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?