SiWapp versus Frontaccounting

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

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 11 Oct 2013 09:55

If you have solydkbo-admin installed (default in the SolydK BO iso), a sql dump is done daily, and stored in

Code: Select all

/home/solydkbo-backup/*
The script is found here:

Code: Select all

/etc/solydxk/solydkbo/solydkbo-backup
and has a symbolic link in /etc/cron.daily (you need to have anacron installed).


SolydXK needs you!
Development | Testing | Translations

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

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 26 Oct 2013 15:21

OK, thanks!

So if I changed the default password "solydxk" into a new one, from within the Siwapp application, under Settings, that password has to be corrected in the backup script.

Code: Select all

sudo mousepad  /etc/solydxk/solydkbo/solydkbo-backup
and then edit line 168:

Code: Select all

    mysqldump --host=localhost --opt -u root -psolydxk siwapp | gzip -9 > $BCKDIR/siwapp/siwapp_$DT.sql.gz
where my_password is written right behind -p, resulting in something like:

Code: Select all

    mysqldump --host=localhost --opt -u root -pmy_password siwapp | gzip -9 > $BCKDIR/siwapp/siwapp_$DT.sql.gz[
And just to be clear for anyone else strugling with this, the target directory for the backup is changed in line 15, for example resulting in:

Code: Select all

BCKDIR='/home/me/Dropbox/Backups/'

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

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 27 Oct 2013 08:41

:? I was convinced it would work now, after previous post. But this morning I got from anacron:

Code: Select all

/etc/cron.daily/solydkbo-backup:
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
mysqldump > /home/me/Dropbox/Folder/Siwapp_backup/siwapp/siwapp_20131027.sql.gz
How is this possible? The produced output .sql.gz seems empty at only 20 bytes in size...
Is there some other config file where a password needs changing?

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

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 27 Oct 2013 08:53

You changed the password for user siwapp, not the root password that mysql needs.
So, if you change the script back to its original state, it should work again.


SolydXK needs you!
Development | Testing | Translations

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

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 27 Oct 2013 19:02

Err, no, it has never worked. I started delving into this script because I got these error messages from anacron every day. So what I posted seemed the obvious solution; "-u root" seemed user root and on login Siwapp only allows user "root". My mistake.

I'll change it back in the script and then change back my password within Siwapp to the default 'solydxk", everything is then back to its original state, the way you set it up. I'll let you know. Cheers!

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

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 30 Oct 2013 21:42

:) OK, it the backup script is working now! Anacron sent a backup report without errors today! I finally found out what I was doing wrong, and I am to blame for it not working. Here is the thing.

Putting everything back to the default password 'solydxk' did not do the trick. However, all of a sudden I remembered something from the install process of Siwapp, a while ago. Something important.

During install of package 'solydkbo-siwapp' I got a series of questions. One of those questions was, or must have been, the sql password for user root. DO NOT FORGET was you entered there, like I did :oops:.

This is the password that does need to be edited in the backup script '/etc/solydxk/solydkbo/solydkbo-backup' like posted before. Not to be confused with your root password, and not to be confused with the password in the Siwapp application where the only accepted user name is root.

So yes, it may be confusing, but it is possible to have three passwords for user 'root', depending on what you're doing. This is what I learned, I hope this helps to avoid anyone else getting in trouble.

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

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 30 Oct 2013 21:52

:lol: That's why I always use the same user name (root) and password (solydxk).
Probably not the safest thing, but on the other hand, you can't get confused.


SolydXK needs you!
Development | Testing | Translations

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

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 12 Oct 2014 12:56

Old topic, new breakage.

One year later, and having used Siwapp with great pleasure so far (!), this morning something broke.
The page http://localhost/siwapp/index.php is empty..! No login.

I left my work open last night, halfway through the invoicing.
At 2:00 h luckybackup works its magic, and anacron at around 8:00 (succesfull). Update screen was open, not finished updating. I let the updates go through and then rebooted, but still no Siwapp page.

I checked the following:
phpmyadmin: siwapp user and database present

Code: Select all

find /etc/apache2 -mtime 0 -ls
gives no altered files in las 24 hours. So /etc/apache2/apache2.conf and /etc/apache2/sites-available were unchanged.

Code: Select all

find /var/www/ -mtime 0 -ls
gives no altered files in las 24 hours. So .htaccess is unchanged.

Where do I go from here? Apache seems fine, localhost page gives "It works!", so somehow the Siwapp page is not found...

User avatar
MAYBL8
Posts: 1487
Joined: 10 Mar 2013 18:41
Location: Maryland Heights, MO USA
Contact:

Re: SiWapp versus Frontaccounting

Postby MAYBL8 » 12 Oct 2014 13:27

One google search I did said clearing the cache worked to fix their blank page problem.
But I don't know how to tell you to do that.
It may mean the browser cache but I don't see how that affects it on the server.


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

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 12 Oct 2014 14:01

Thanks, but that does not change it.

Firefox: Preferences >> advanced >> network >> clear cache now

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

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 12 Oct 2014 14:28

Have you tried restarting the server:

Code: Select all

sudo service apache2 restart


SolydXK needs you!
Development | Testing | Translations

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

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 12 Oct 2014 15:44

Thanks Chief, but no.
Connecting... Waiting for localhost.

User avatar
MAYBL8
Posts: 1487
Joined: 10 Mar 2013 18:41
Location: Maryland Heights, MO USA
Contact:

Re: SiWapp versus Frontaccounting

Postby MAYBL8 » 12 Oct 2014 15:54

Could this be a MySQL issue?


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

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 12 Oct 2014 16:16

Possibly a MySQL issue,yes.
But with a messed up database the login page should still work, right?

User avatar
MAYBL8
Posts: 1487
Joined: 10 Mar 2013 18:41
Location: Maryland Heights, MO USA
Contact:

Re: SiWapp versus Frontaccounting

Postby MAYBL8 » 12 Oct 2014 16:32

Schoelje could help better at this but do you have any other applications that connect to a MySQL Database that uses a web page to display info? Do they work?
Also I thought I might have a similar issue that had to do with MySQL password in the config file. But I could be way off here. Just trying to think of anything it could be.
Has anything changed on your system since it last was working. New Updates ? Etc.


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

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 12 Oct 2014 17:09

Let's see if php is served right.
Please attach the output of http://localhost/phpinfo.php


SolydXK needs you!
Development | Testing | Translations

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

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 12 Oct 2014 17:28

Mayblade, nothing comes to mind. The latest system update was a whole list. No other MySQL application and Apache only serves out Siwapp.

Schoelje, I get a 404 error on that one! So the problem might be there!

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

Re: SiWapp versus Frontaccounting

Postby Arjen Balfoort » 12 Oct 2014 19:11

Please, post the complete output of both these commands:

Code: Select all

sudo service apache2 stop
and

Code: Select all

sudo service apache2 start
Sometimes rebooting helps.


SolydXK needs you!
Development | Testing | Translations

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

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 12 Oct 2014 19:41

[ ok ] Stopping web server: apache2.
and
[ ok ] Starting web server: apache2.

rebooted three times today
shutdown completely en restarted just now
no change

If apache runs, but does not serve the right page, how can I check that?
Where is the file that makes apache understand which page to serve up? Perhaps something wrong there...?

Mmmm, something else, I don't know anythink about this, but just peeking in http://localhost/phpmyadmin/index.php , at the bottom it says "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here." Is this important? When I click there I get:

PMA Database ... not OK [ Documentation ]
General relation features Disabled

When 'Documentation' is clicked I go to http://localhost/phpmyadmin/pmadb , which is a 404 page. ???

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

Re: SiWapp versus Frontaccounting

Postby Tuna130 » 13 Oct 2014 07:05

Code: Select all

sudo apt-get install --reinstall solydkbo-siwapp
Pakketlijsten worden ingelezen... Klaar
Boom van vereisten wordt opgebouwd        
De status informatie wordt gelezen... Klaar
Herinstallatie van solydkbo-siwapp is niet mogelijk daar het niet opgehaald kan worden.
0 pakketten opgewaardeerd, 0 pakketten nieuw geïnstalleerd, 0 te verwijderen en 0 niet opgewaardeerd.
In Dutch: reinstall not possible because package cannot be fetched.
:? Should I remove and install? Would that wipe my database and settings?


Return to “SolydK Back Office”

Who is online

Users browsing this forum: No registered users and 1 guest