SiWapp versus Frontaccounting

Questions specific to SolydK Back Office
User avatar
Arjen Balfoort
Site Admin
Posts: 8813
Joined: 26 Jan 2013 19:36
Location: Netherlands
Contact:

SiWapp versus Frontaccounting

Postby Arjen Balfoort » 05 Jul 2013 10:55

A user e-mailed me with a suggestion (he was missing accounting software on SolydK BO):
I wish to commend that Solydxk BO is great but it is not complete without a pre-installed accounting software like ledger smb, frontaccounting or Sql-ledger.
On Ledger I can be short: this is ERP software, and I chose not to implement ERP for small and medium sized businesses. It could be rather overwhelming.

However, Frontaccounting, is rather interesting.
I wanted to keep things as simple as possible, and that's why I chose for SiWapp, which handles invoicing.
Frontaccounting is an accounting software, and of course, includes invoicing.
It's a complete package, and also fits the technical specifications for SolydK BO: web based with MySQL backend.

Does anyone have experience with both these packages?
Or maybe just with one of these: please share your experiences here.

What are the pros and cons of replacing SiWapp with Frontaccounting?

You can find their official sites here:
http://www.siwapp.org
http://frontaccounting.com


SolydXK needs you!
Development | Testing | Translations

toothandnail
Posts: 94
Joined: 02 Jun 2013 18:45
Location: Oxfordshire, UK

Re: SiWapp versus Frontaccounting

Postby toothandnail » 27 Jul 2013 00:43

Can't comment on either package. I've had a bit of a play with SiWapp, which seems quite good as an invoice generating package. Personally I'd rather see an accounting package, so Frontaccounting might be a better choice.

I also agree with your comments on ERP software. I've spent some time with WebERP and found it much to complex for the things I need to do, not to mention being tricky to set up and get working properly. So something less complex would be a good compromise.

I'm intending to download Frontaccounting and see if I can get it running on my server, see how well it goes for my needs. It may take a couple of weeks though - I'm short of spare time at present.

I've had a bit of a look at the BO version. I may try installing in on a spare partition on this machine to have more of a look at. While I'd rather see those sorts of packages as server installs, I can think of a few businesses that I deal with that might find Back Office ideal. Though I may try porting the packages to SolydX - I'm not a big KDE fan....

Paul.

User avatar
Arjen Balfoort
Site Admin
Posts: 8813
Joined: 26 Jan 2013 19:36
Location: Netherlands
Contact:

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 27 Jul 2013 06:09

Thanks, I'd really like to know what you think of Frontaccounting, especially in comparison to SiWapp.


SolydXK needs you!
Development | Testing | Translations

User avatar
Tuna130
Posts: 47
Joined: 10 Aug 2013 05:40
Location: Spain

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 11 Aug 2013 07:42

Thanks for the Siwapp package in software manager! So much easier than the install guide on the Siwapp site! I installed it on a fresh SolydX, which was easy, and no errors.

Just a minor issue here, how do I get started? I get a login page in a browser, but the password that was requested during install doesn't let me in. I tried user name admin, root, and my own user name, in combination with that password, or a blank field, and also my system login user name and password. It looks like there was no user account created during install, or should I have done something to do that? Any hints, please?
try SCE to AUX

User avatar
Arjen Balfoort
Site Admin
Posts: 8813
Joined: 26 Jan 2013 19:36
Location: Netherlands
Contact:

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 11 Aug 2013 07:59

Tuna130 wrote:Thanks for the Siwapp package in software manager! So much easier than the install guide on the Siwapp site! I installed it on a fresh SolydX, which was easy, and no errors.

Just a minor issue here, how do I get started? I get a login page in a browser, but the password that was requested during install doesn't let me in. I tried user name admin, root, and my own user name, in combination with that password, or a blank field, and also my system login user name and password. It looks like there was no user account created during install, or should I have done something to do that? Any hints, please?
First of all: welcome to our forum!

root
solydxk

is the default.
Let me know if that worked.


SolydXK needs you!
Development | Testing | Translations

User avatar
Tuna130
Posts: 47
Joined: 10 Aug 2013 05:40
Location: Spain

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 11 Aug 2013 09:14

Great, that worked!
Many thanks, and keep up the good work!
try SCE to AUX

User avatar
Arjen Balfoort
Site Admin
Posts: 8813
Joined: 26 Jan 2013 19:36
Location: Netherlands
Contact:

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 11 Aug 2013 09:35

Tuna130 wrote:Great, that worked!
Many thanks, and keep up the good work!
You're welcome.


SolydXK needs you!
Development | Testing | Translations

User avatar
Tuna130
Posts: 47
Joined: 10 Aug 2013 05:40
Location: Spain

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 20 Sep 2013 15:09

Siwapp broke after the big update, on my Solydx box.

I guess I shouldn't have chosen to keep the exising .conf files. It said this was edited by user or by a script, and I was afraid that Siwapp would break, so I opted to keep the original files. Maybe the wrong choice after all. We'll start using this package by 1st of October, at least that was the plan.

The database is just filled with testing data and the settings can be done again, so uninstalled through the software centre and then

Code: Select all

sudo apt-get install solydkbo-siwapp
from terminal, which gave:
Instellen van solydkbo-siwapp (1.0.7) ...
dbconfig-common: writing config to /etc/dbconfig-common/siwapp.conf
dbconfig-common: flushing administrative password
Module rewrite already enabled
[FAIL] Starting web server: apache2 failed!
[warn] The apache2 configtest failed. ... (warning).
Output of config test was:
apache2: Syntax error on line 265 of /etc/apache2/apache2.conf: Could not open configuration file /etc/apache2/conf.d/: No such file or directory
Action 'configtest' failed.
The Apache error log may have more information.
dpkg: error processing solydkbo-siwapp (--configure):
subproces installed post-installation script gaf een foutwaarde 1 terug
Fouten gevonden tijdens behandelen van:
solydkbo-siwapp
E: Sub-process /usr/bin/dpkg returned an error code (1)
I then read the instructions on the update (sorry guys, I'm a dummy, should have checked first), updated the sources.list and installed solydx-info and solydx-system-adjustments and gave it another go:

Code: Select all

sudo apt-get purge solydkbo-siwapp apache2 && sudo apt-get install solydkbo-siwapp
which seemed to go without error messages, untill right at the end:
Uitpakken van solydkbo-siwapp (uit .../solydkbo-siwapp_1.0.7_all.deb) ...
error: Cannot find a question for siwapp/mysql/app-pass
dpkg: error processing /var/cache/apt/archives/solydkbo-siwapp_1.0.7_all.deb (--unpack):
subproces nieuw pre-installation script gaf een foutwaarde 1 terug
Processing triggers for menu ...
Fouten gevonden tijdens behandelen van:
/var/cache/apt/archives/solydkbo-siwapp_1.0.7_all.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
Should I have taken some of the instructions given about SolydK-Bo? I did not because I am on XFCE.

Please help...
try SCE to AUX

User avatar
Arjen Balfoort
Site Admin
Posts: 8813
Joined: 26 Jan 2013 19:36
Location: Netherlands
Contact:

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 20 Sep 2013 17:25

I have tested with both keeping and overwriting the configuration files.
Unfortunately I do not get the same issue you are describing, and we cannot investigate because you already purged SiWapp. You even removed apache2, which makes it complicated to check if there were things left in MySql that a new installation would hinder.

Now, let's purge SiWapp

Code: Select all

sudo apt-get purge solydkbo-siwapp
Open a browser, open phpMyAdmin (you need to have solydkbo-admin or phpmyadmin installed), and remove any SiWapp remnants:
Right pane:
Users >> select siwapp >> "Remove selected users": check "Drop the databases that have the same names as the users" >> Go
Databases >> select siwapp >> "Drop"

When done, install SiWapp again:

Code: Select all

sudo apt-get install solydkbo-siwapp


SolydXK needs you!
Development | Testing | Translations

User avatar
Tuna130
Posts: 47
Joined: 10 Aug 2013 05:40
Location: Spain

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 20 Sep 2013 22:05

Thanks for the quick answer, Schoelje!

Installed solydkbo-admin and left existing database during install. Then went to
http://localhost/phpmyadmin and removed user siwapp as indicated. There was no database called siwapp under databases.

Then:
sudo apt-get install solydkbo-siwapp
Pakketlijsten worden ingelezen... Klaar
Boom van vereisten wordt opgebouwd
De status informatie wordt gelezen... Klaar
De volgende NIEUWE pakketten zullen geïnstalleerd worden:
solydkbo-siwapp
0 pakketten opgewaardeerd, 1 pakketten nieuw geïnstalleerd, 0 te verwijderen en 0 niet opgewaardeerd.
Er moeten 0 B/13,4 MB aan archieven opgehaald worden.
Door deze operatie zal er 49,7 MB extra schijfruimte gebruikt worden.
(Database inlezen ... 250670 files and directories currently installed.)
Uitpakken van solydkbo-siwapp (uit .../solydkbo-siwapp_1.0.7_all.deb) ...
error: Cannot find a question for siwapp/mysql/app-pass
dpkg: error processing /var/cache/apt/archives/solydkbo-siwapp_1.0.7_all.deb (--unpack):
subproces nieuw pre-installation script gaf een foutwaarde 1 terug
Processing triggers for menu ...
Fouten gevonden tijdens behandelen van:
/var/cache/apt/archives/solydkbo-siwapp_1.0.7_all.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
Hmmm, again. I would almost think of removing everything that has to do with mysql, but my previous attempts to remove and reinstall made it worse, it seems. I'll just do nothing for now. I wish I could send more details other than above.
try SCE to AUX

User avatar
Arjen Balfoort
Site Admin
Posts: 8813
Joined: 26 Jan 2013 19:36
Location: Netherlands
Contact:

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 20 Sep 2013 22:22

I think I know where it goes wrong in your case, but I don't know why.

Could you open a terminal, and run these lines:

Code: Select all

su
echo "solydkbo-siwapp siwapp/mysql/app-pass password siwapp" | debconf-set-selections
echo "solydkbo-siwapp siwapp/app-password-confirm password siwapp" | debconf-set-selections
This will probably go wrong, but I hope I get more info than what the installer returns.


SolydXK needs you!
Development | Testing | Translations

User avatar
Arjen Balfoort
Site Admin
Posts: 8813
Joined: 26 Jan 2013 19:36
Location: Netherlands
Contact:

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 20 Sep 2013 22:32

I just found this bug report: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=487300

It seems to be a corrupt debconf database, which can be solved by running:

Code: Select all

perl /usr/share/debconf/fix_db.pl
prior to installing siwapp:

Code: Select all

sudo apt-get install --reinstall solydkbo-siwapp
If that doesn't work, run the command with sudo (I don't know if that matters), and try again.


SolydXK needs you!
Development | Testing | Translations

User avatar
Tuna130
Posts: 47
Joined: 10 Aug 2013 05:40
Location: Spain

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 21 Sep 2013 10:35

OK, now we are making progress!

I tried last post first, first as normal user, but the installer still stumbled over the same error. Then as sudo, and the troublemaker came up:
sudo perl /usr/share/debconf/fix_db.pl
debconf: template "siwapp/mysql/app-pass" claims to be used by nonexistant question "siwapp/mysql/app-pass"; removing that.
debconf: template "siwapp/app-password-confirm" claims to be used by nonexistant question "siwapp/app-password-confirm"; removing that.
Then reinstalled solydkbo-siwapp, and no errors. Yeah!

Login screen worked normal, but then, woops, a 404 error.
Not Found
The requested URL /siwapp/login was not found on this server.
Apache/2.4.6 (Debian) Server at localhost Port 80
Rebooted, still the same. Then reinstalled solydkbo-siwapp once more: no errors, but no solution either.
try SCE to AUX

User avatar
Arjen Balfoort
Site Admin
Posts: 8813
Joined: 26 Jan 2013 19:36
Location: Netherlands
Contact:

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 21 Sep 2013 15:06

I haven't been able to reproduce your problem, and this weekend I haven't got the time to test any further.
Have you checked in phpMyAdmin if the siwapp database and siwapp user exist?
Have you tried to open http://localhost/siwapp/index.php


SolydXK needs you!
Development | Testing | Translations

User avatar
Tuna130
Posts: 47
Joined: 10 Aug 2013 05:40
Location: Spain

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 22 Sep 2013 13:39

Yes, siwapp database and siwapp user exist.
Image
Have you tried to open http://localhost/siwapp/index.php
Yes, this is the login page, which works correctly. Once logged in I get sent to page http://localhost/siwapp/login which is not found.

I may have found a solution here: https://groups.google.com/forum/#!searc ... bR4tCM09AJ

It recommends to copy over .htaccess files. So I found them like this:
locate .htaccess
/var/www/siwapp/.htaccess
/var/www/siwapp_data/lib/vendor/symfony/lib/task/generator/skeleton/project/web/.htaccess
Then renamed the origial files into .bak and tried both versions in boh places, and noticed no improvement.

Another advise was:
Edit /etc/apache2/sites-enabled/000-default,
change the "AllowOverride None" directive to "AllowOverride All" on
the "<Directory /var/www>" section
But my folder /etc/apache2/sites-enabled/ is empty. Should there be a .conf file here?

There is also mention of editing the .htaccess file, but I don't dare just yet...
try SCE to AUX

User avatar
Arjen Balfoort
Site Admin
Posts: 8813
Joined: 26 Jan 2013 19:36
Location: Netherlands
Contact:

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 22 Sep 2013 16:59

After login I go to:

Code: Select all

http://localhost/siwapp/dashboard
What if you go to that url after you login?

How does your .htaccess look like, can you attach it to you next post, including /etc/apache2/apache2.conf (you probably need to compress it)?

Mine looks like:

Code: Select all

Options +FollowSymLinks +ExecCGI -MultiViews

AddDefaultCharset utf-8 

<IfModule mod_authz_host.c>
  <FilesMatch "\.(lock|conf)$">
    Order deny,allow
    Deny  from all
  </FilesMatch>

  <FilesMatch "pre_.+\.php">
    Order deny,allow
    Deny  from all
  </FilesMatch>
</IfModule>


<IfModule mod_rewrite.c>
  RewriteEngine On

  # Rule to test if rewrite module is available during
  # the install process
  RewriteRule test_rewrite1\.txt test_rewrite2.txt
  
  RewriteRule .+/favicon.ico$ favicon.ico [L]

  # uncomment the following line, if you are having trouble
  # getting no_script_name to work
  #RewriteBase /

  # we skip all files with .something
  RewriteCond %{REQUEST_URI} /\..+$
  RewriteCond %{REQUEST_URI} !\.html$
  RewriteRule .* - [L]

  # we check if the .html version is here (caching)
  RewriteRule ^$ index.html [QSA]
  RewriteRule ^([^.]+)$ $1.html [QSA]
  
  RewriteCond %{REQUEST_FILENAME} !-d
  RewriteCond %{REQUEST_FILENAME} !-f

  # no, so we redirect to our front web controller
  RewriteRule (.*) index.php [L,QSA]
</IfModule>
and this is the contents of /etc/apache2/sites-available:
sites-available.tar.gz
(3.17 KiB) Downloaded 262 times
with a symlink /etc/apache2/sites-enabled/000-default.conf to /etc/apache2/sites-available/000-default.conf


SolydXK needs you!
Development | Testing | Translations

User avatar
Tuna130
Posts: 47
Joined: 10 Aug 2013 05:40
Location: Spain

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 22 Sep 2013 21:40

I cannot get to the dashboard page, I get a 404 Not Found.

The file .htaccess looks identical. I renamed mine to .bak and used yours, just to be sure.

The contents of /etc/apache2/sites-available were entirely different, so I renamed mine to .bak and used yours.
(These are the ones I had: https://dl.dropboxusercontent.com/u/138 ... ble.tar.gz)
Also made the symlink.

After login Siwapp still gives me the 404 error.
I will shutdown and see tomorrow if a reboot makes a difference. I need a reboot for sure...
Many thanks for now!

User avatar
Tuna130
Posts: 47
Joined: 10 Aug 2013 05:40
Location: Spain

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 23 Sep 2013 09:03

Good Morning! A very good one, indeed. Siwapp works again!

Thank you so much for your help!

User avatar
Arjen Balfoort
Site Admin
Posts: 8813
Joined: 26 Jan 2013 19:36
Location: Netherlands
Contact:

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 23 Sep 2013 10:29

I'm very glad we solved this one!


SolydXK needs you!
Development | Testing | Translations

User avatar
Tuna130
Posts: 47
Joined: 10 Aug 2013 05:40
Location: Spain

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 11 Oct 2013 09:17

Happily using Siwapp now!

How would you recommend to backup my invoice data?

I looked at AutoMySQLBackup http://sourceforge.net/projects/automysqlbackup/, but I haven't found out yet where my data is stored. I thought about setting the destination folder for the backup in Dropbox, to get an off site copy.


Return to “SolydK Back Office”

Who is online

Users browsing this forum: No registered users and 1 guest