Apss Installer generating errors: "Installation_error" for every package!

Hi..
After few hours of reading forum and tutorials I decide to ask from help..
I followed tutorial from this site: https://www.howtoforge.com/tutorial/perfect-server-debian-8-jessie-apache-bind-dovecot-ispconfig-3/
I'm using latest ver of ISPConf v3.0.5.4p8 on Debian v8.2 x64
I build the site and it working OK. But when I login as admin and goes to SITES -> UPDATE PACKAGELIST and select from AVIABLE PACKAGE of any app after ~10-15min of status message: Installation_task it generate me error message Installation_error!
Same is if I login as user (owner of site) and try to install for example WordPress app.
This is on psyhical macheine but I try on Virtual box to repeat angain installation and have a same problem.

Site is generated with next parameters:
SuEXEC -> ticked
Own Error-Documents -> ticked
PHP -> Fast CGI
PHP Version -> Deafault

If I install manualy for example WordPress to my site as client I can connect to MySql database and everything working.
All services running without problem.
I try to remove manualy over ssh all zip files from /usr/local/ispconfig/interface/web/sites/aps_meta_packages/ and generate again, but without success.
Can anyone gave me some suggestion what can I do?
What type of log do I need to read to understand where is the problem?

 

Thx for answer, and helping me..
ISPConfSystem Message log:

Code:

Feb 26 09:28:25 web2 clamd[6535]: Limits: Files limit set to 10000.
Feb 26 09:28:25 web2 clamd[6535]: Limits: MaxEmbeddedPE limit set to 10485760 bytes.
Feb 26 09:28:25 web2 clamd[6535]: Limits: MaxHTMLNormalize limit set to 10485760 bytes.
Feb 26 09:28:25 web2 clamd[6535]: Limits: MaxHTMLNoTags limit set to 2097152 bytes.
Feb 26 09:28:25 web2 clamd[6535]: Limits: MaxScriptNormalize limit set to 5242880 bytes.
Feb 26 09:28:25 web2 clamd[6535]: Limits: MaxZipTypeRcg limit set to 1048576 bytes.
Feb 26 09:28:25 web2 clamd[6535]: Limits: MaxPartitions limit set to 50.
Feb 26 09:28:25 web2 clamd[6535]: Limits: MaxIconsPE limit set to 100.
Feb 26 09:28:25 web2 clamd[6535]: Archive support enabled.
Feb 26 09:28:25 web2 clamd[6535]: Algorithmic detection enabled.
Feb 26 09:28:25 web2 clamd[6535]: Portable Executable support enabled.
Feb 26 09:28:25 web2 clamd[6535]: ELF support enabled.
Feb 26 09:28:25 web2 clamd[6535]: Mail files support enabled.
Feb 26 09:28:25 web2 clamd[6535]: OLE2 support enabled.
Feb 26 09:28:25 web2 clamd[6535]: PDF support enabled.
Feb 26 09:28:25 web2 clamd[6535]: SWF support enabled.
Feb 26 09:28:25 web2 clamd[6535]: HTML support enabled.
Feb 26 09:28:25 web2 clamd[6535]: Self checking every 3600 seconds.
Feb 26 09:29:01 web2 CRON[6712]: (root) CMD (/usr/local/ispconfig/server/server.sh 2>&1 > /dev/null | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done)
Feb 26 09:30:01 web2 CRON[6784]: (root) CMD (/usr/local/ispconfig/server/server.sh 2>&1 > /dev/null | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done)
Feb 26 09:30:01 web2 CRON[6785]: (getmail) CMD (/usr/local/bin/run-getmail.sh > /dev/null 2>> /dev/null)
Feb 26 09:30:04 web2 pure-ftpd: (?@::1) [INFO] New connection from ::1

Code:

Server: xxx.xxxxx.xx (Debian Jessie) ISPConfig 3.0.5.4p8

State: info (0 unknown, 0 info, 1 warning, 0 critical, 0 error)
ok:
The state of your Hard-Disk space is ok [More...]
Your Mail queue load is ok [More...]
Your Server load is ok [More...]
All needed services are online [More...]
The System Log is O.K. [More...]

warning:
Your virus protection is OUTDATED! [More...]

Code:

Web-Server:     Online
FTP-Server:     Online
SMTP-Server:     Online
POP3-Server:     Online
IMAP-Server:     Online
DNS-Server:     Online
mySQL-Server:     Online

Code:

Data from: 2016-02-26 09:30
iptables -S (ipv4)
-P INPUT ACCEPT
-P FORWARD ACCEPT
-P OUTPUT ACCEPT

ip6tables -S (ipv6)
-P INPUT ACCEPT
-P FORWARD ACCEPT
-P OUTPUT ACCEPT

What king of log do you need more to help me?
Waiting for suggestion.

 

In MONITOR -> SYSTEM STATES (ALL SERVERS) -> SHOW SYSTEM LOG:


If you need more log lease tell me detail which one.
Thx

 

Anyone?

 

Is your job queue empty?
Please go to
Server Config and set your Loglevel to debug.
Repeat the steps to install the App and check back on System-log

it installed wordpress for me just fine.

 

Thx for helping me..
I did changes in log as you said.
Now only stuck on message: Installation_task
And now I have a bunch of error message:

Code:

2016-03-16 20:53     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:53     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:53     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:53     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:52     xxx.xxxxxxxxx.xxx     Debug     Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock   
2016-03-16 20:52     xxx.xxxxxxxxx.xxx     Debug     There is already an instance of server.php running. Exiting.   
2016-03-16 20:51     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:51     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:51     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:51     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:51     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:51     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:51     xxx.xxxxxxxxx.xxx     Debug     There is already an instance of server.php running. Exiting.   
2016-03-16 20:50     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:50     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:50     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:50     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:50     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:50     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:50     xxx.xxxxxxxxx.xxx     Debug     There is already an instance of server.php running. Exiting.   
2016-03-16 20:49     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:49     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:49     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:49     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:49     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:49     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:49     xxx.xxxxxxxxx.xxx     Debug     There is already an instance of server.php running. Exiting.   
2016-03-16 20:48     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:48     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:48     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:48     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:48     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
....
....
2016-03-16 20:35     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:35     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:35     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:35     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:35     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:35     xxx.xxxxxxxxx.xxx     Debug     There is already an instance of server.php running. Exiting.   
2016-03-16 20:34     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:34     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:34     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:34     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:34     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:34     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:34     xxx.xxxxxxxxx.xxx     Debug     There is already an instance of server.php running. Exiting.   
2016-03-16 20:33     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:33     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:33     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:33     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:33     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:33     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:33     xxx.xxxxxxxxx.xxx     Debug     There is already an instance of server.php running. Exiting.   
2016-03-16 20:32     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:32     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:32     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:32     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:32     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:32     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:31     xxx.xxxxxxxxx.xxx     Debug     Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock   
.....
.....
2016-03-16 20:13     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:13     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:13     xxx.xxxxxxxxx.xxx     Debug     There is already a lockfile set. Waiting another 10 seconds...   
2016-03-16 20:13     xxx.xxxxxxxxx.xxx     Debug     There is already an instance of server.php running. Exiting.

This message stay more than 2 hour.
I try to manualy delete file:

Code:

/usr/local/ispconfig/server/temp/.ispconfig_lock

but nothing happend.

Btw hoe can I restart ispconfig? Because in /etc/init.d/ folder I have not ispconfig-server file.
Thx

 

And my jobqueue:

Code:

Jobqueue

      
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Update  aps_instances   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  aps_instances   
2016-03-16 20:42  xxx.xxxxxxxxx.xxx  Insert  web_database   
2016-03-16 17:59  xxx.xxxxxxxxx.xxx  Update  aps_instances   
2016-03-16 17:59  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 17:59  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 17:59  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 17:59  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 17:59  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 17:59  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 17:59  xxx.xxxxxxxxx.xxx  Insert  aps_instances_settings   
2016-03-16 17:59  xxx.xxxxxxxxx.xxx  Insert  aps_instances   
2016-03-16 17:58  xxx.xxxxxxxxx.xxx  Update  server   
2016-03-16 17:58  xxx.xxxxxxxxx.xxx  Update  server

 

ISPconfig does not use a deamon you can stop/start using init.d. You give jobs using the interface which are then executed by a cronjob.
To make sure actions won't get executed twice it sets a lockfile to ensure only one instance is running.

You can temporarily disable this:

As root do:

Code:

crontab -e

This will open your default editor, if it's nano, you can freely edit text. If it's vim you need to press "i" to insert text, press "ESC" to end insert mode and then press ":" type "wq" and hit enter.

Comment out the server.sh cron

Code:

#* * * * * /usr/local/ispconfig/server/server.sh 2>&1 > /dev/null | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done

Find if there's a cron running

Code:

ps aux | grep server.sh

If you see something like this:

Code:

root     19978  0.0  0.0  15112  1368 ?        Ss   02:08   0:00 /bin/sh -c /usr/local/ispconfig/server/server.sh 2>&1 > /dev/null | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done
root     19979  0.0  0.0  15136  1528 ?        S    02:08   0:00 /bin/sh /usr/local/ispconfig/server/server.sh
root     19980  0.0  0.0  15112   624 ?        S    02:08   0:00 /bin/sh -c /usr/local/ispconfig/server/server.sh 2>&1 > /dev/null | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done

it is still running, maybe stuck at something ( which would be rather interesting )
you can kill it, in my case it is running using PID 19978, 19979 and 19980

Code:

kill 19978

Make sure there is no process running anymore.

Check the file /var/log/ispconfig/cron.log for any issues.
Delete the lock file
/usr/local/ispconfig/server/temp/.ispconfig_lock


Run the cron from terminal

Code:

/usr/local/ispconfig/server/server.sh

Do you see any issues here?

Finally edit the crontab file again and remove the extra "#" to reactivate the cronjob.

 

Thanks you for helping me and giving detailed instructions..
Here is what happening:
I followed steps you suggest me.
Disable in user crond both of lines.
Restarted crond with

Code:

/etc/init.d/cron restart

Found

Code:

root     17410  0.0  0.2  13244  2944 ?        S    14:51   0:00 /bin/sh /usr/local/ispconfig/server/server.sh

line and kill it..
Check it is it running.
Then delete

Code:

/usr/local/ispconfig/server/temp/.ispconfig_lock

Start again server.sh with command

Code:

/usr/local/ispconfig/server/server.sh

Now as I start it in that momnet the file .ispconfig_lock appear.
I try to delete it again but it appear again.
If I go to ISPConfig -> Sites -> Installed package I still see the apps in queue with status:

Code:

Installation_task

I try to restart whole debian..but this staus message stay.
Log is totaly same from ISPConfig Log as I sent you in preview message.
You ask me about Jobqueue log, so he it is:

Code:

2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Update     aps_instances    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     aps_instances    
2016-03-16 20:42     xxx.xxxxxxxxx.xxx     Insert     web_database    
2016-03-16 17:59     xxx.xxxxxxxxx.xxx     Update     aps_instances    
2016-03-16 17:59     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 17:59     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 17:59     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 17:59     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 17:59     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 17:59     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 17:59     xxx.xxxxxxxxx.xxx     Insert     aps_instances_settings    
2016-03-16 17:59     xxx.xxxxxxxxx.xxx     Insert     aps_instances    
2016-03-16 17:58     xxx.xxxxxxxxx.xxx     Update     server    
2016-03-16 17:58     xxx.xxxxxxxxx.xxx     Update     server

Have you any suggestion what can I do to repair this?

 

If you run
/usr/local/ispconfig/server/server.sh

the .lock file is supposed to appear again. The interesting part would be, does running that command give you any kind of output?

I assume you have ISPConfig set to debug level, still?

If it does not output anything after a few minutes! it will be a strange issue :/



Does

Code:

apt-get update

apt-get install -f

work?

 

If I run

Code:

/usr/local/ispconfig/server/server.sh

in ssh I receive:

Code:

root@web2:~# /usr/local/ispconfig/server/server.sh
17.03.2016-14:17 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
root@web2:~#

I will run update as I came home...

 

This looks strange, it just does nothing
What if you isse this SQL-query in your dbispconfig database / what does it tell you?

Code:

SELECT s.updated AS datalog_processed_until, MAX(sl.datalog_id) datalog_log_until, MAX(sd.datalog_id) datalog_new_max FROM `server` s, sys_log sl, sys_datalog sd

 

Nothing for update

Code:

root@web2:~# apt-get update
Get:1 http://mirror.pmf.kg.ac.rs jessie-updates InRelease [142 kB]
Get:2 http://mirror.pmf.kg.ac.rs jessie-updates/main Sources [4,092 B]
Get:3 http://security.debian.org jessie/updates InRelease [63.1 kB]
Get:4 http://mirror.pmf.kg.ac.rs jessie-updates/main amd64 Packages/DiffIndex [1,012 B]
Get:5 http://mirror.pmf.kg.ac.rs jessie-updates/main Translation-en/DiffIndex [736 B]
Get:6 http://mirror.pmf.kg.ac.rs jessie-updates/main amd64 2016-03-04-0853.34.pdiff [3,697 B]
Ign http://ftp.us.debian.org jessie InRelease
Get:7 http://mirror.pmf.kg.ac.rs jessie-updates/main amd64 2016-03-04-0853.34.pdiff [3,697 B]
Get:8 http://mirror.pmf.kg.ac.rs jessie-updates/main 2016-03-04-0853.34.pdiff [1,371 B]
Get:9 http://mirror.pmf.kg.ac.rs jessie-updates/main 2016-03-04-0853.34.pdiff [1,371 B]
Get:10 http://security.debian.org jessie/updates/main Sources [120 kB]
Hit http://ftp.us.debian.org jessie Release.gpg
Get:11 http://dl.hhvm.com jessie InRelease [2,106 B]
Get:12 http://security.debian.org jessie/updates/contrib Sources [1,439 B]
Get:13 http://security.debian.org jessie/updates/non-free Sources [14 B]
Hit http://ftp.us.debian.org jessie Release
Get:14 http://security.debian.org jessie/updates/main amd64 Packages [219 kB]
Get:15 http://dl.hhvm.com jessie/main amd64 Packages [1,664 B]
Get:16 http://security.debian.org jessie/updates/contrib amd64 Packages [2,506 B]
Hit http://ftp.us.debian.org jessie/main Sources
Get:17 http://security.debian.org jessie/updates/non-free amd64 Packages [14 B]
Get:18 http://security.debian.org jessie/updates/contrib Translation-en [1,211 B]
Get:19 http://security.debian.org jessie/updates/main Translation-en [120 kB]
Hit http://ftp.us.debian.org jessie/contrib Sources
Get:20 http://security.debian.org jessie/updates/non-free Translation-en [14 B]
Hit http://ftp.us.debian.org jessie/non-free Sources
Hit http://ftp.us.debian.org jessie/main amd64 Packages
Hit http://ftp.us.debian.org jessie/contrib amd64 Packages
Hit http://ftp.us.debian.org jessie/non-free amd64 Packages
Hit http://ftp.us.debian.org jessie/contrib Translation-en
Hit http://ftp.us.debian.org jessie/main Translation-en
Hit http://ftp.us.debian.org jessie/non-free Translation-en
Ign http://dl.hhvm.com jessie/main Translation-en_US
Ign http://dl.hhvm.com jessie/main Translation-en
Fetched 685 kB in 7s (95.8 kB/s)
Reading package lists... Done
root@web2:~#
root@web2:~# apt-get install -f
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 33 not upgraded.
root@web2:~#

 

Can you pls tell me how to do it?
Thx

 

Login as root to your database, select dbispconfig database and enter the code.

Code:

$: mysql -uroot -p dbispconfig
mysql> SELECT s.updated AS datalog_processed_until, MAX(sl.datalog_id) datalog_log_until, MAX(sd.datalog_id) datalog_new_max FROM `server` s, sys_log sl, sys_datalog sd;
+-------------------------+-------------------+-----------------+
| datalog_processed_until | datalog_log_until | datalog_new_max |
+-------------------------+-------------------+-----------------+
|                     154 |               154 |             154 |
+-------------------------+-------------------+-----------------+
1 row in set (0.03 sec)

 

Here it is:

Code:

root@web2:~# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1046
Server version: 10.0.23-MariaDB-0+deb8u1 (Debian)

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SELECT s.updated AS datalog_processed_until, MAX(sl.datalog_id) datalog_log_until, MAX(sd.datalog_id) datalog_new_max FROM `server` s, sys_log sl, sys_datalog sd;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>

I loged with my mysql password that I definied on installation.

 

if you don't put "dbispconfig" as last param for the database you need to type

Code:

use dbispconfig;

before entering the query.
-p is a param which does not take a value if followed by whitespace.