Nagle brak panelu WWW


Topic author
uris
Posty: 2
Rejestracja: sob sie 24, 2019 6:48 pm

Nagle brak panelu WWW

#1

Post autor: uris » wt wrz 17, 2019 11:56 pm

Witam ,kilka dni temu zauważyłem że nie mogę zalogować się na NT , przesyłam log z ntinfo

Wszedłem tak hxxp(s?)://nettemp_ip/html/errors/db_error.php
I mam teraz tak

Kod: Zaznacz cały

New backup /var/www/nettemp/dbf/nettemp.db.2019-09-18_003153.3868
HEAD is now at 7fd41ba Hdd free space - virtual sensor (#83)
Already up-to-date.
Update 2018-01-29 13:00:00 is NOT applied. Applying...
Update: 2018-01-29 13:00:00 was unsuccessful.

Failed reason: 
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 no such table: sensors' in /var/www/nettemp/modules/tools/update_db.php:61
Stack trace:
#0 /var/www/nettemp/modules/tools/update_db.php(61): PDO->exec('ALTER TABLE sen...')
#1 /var/www/nettemp/modules/tools/html/tools_update.php(35): include('/var/www/nettem...')
#2 /var/www/nettemp/html/errors/db_error.php(57): include('/var/www/nettem...')
#3 {main}2019-09-18 00:32:04 You have all system packages.

Kod: Zaznacz cały

root@raspberrypi:/var/www/nettemp/other# ./ntinfo
-----hostname
raspberrypi
-----kernel
Linux raspberrypi 4.9.35-v7+ #1014 SMP Fri Jun 30 14:47:43 BST 2017 armv7l GNU/Linux
-----interfaces
eth0 up
lo unknown
tun0 unknown
wlan0 down
-----memory
             total       used       free     shared    buffers     cached
Mem:           923        880         42         61        135        652
-/+ buffers/cache:         92        831
Swap:           99          0         99
-----cpu
600000
-----version
4.8.7
betamm
-----space
Filesystem      Size  Used Avail Use% Mounted on
/dev/root       7.0G  3.6G  3.1G  55% /
devtmpfs        458M     0  458M   0% /dev
tmpfs           462M     0  462M   0% /dev/shm
tmpfs           462M   47M  416M  11% /run
tmpfs           5.0M  4.0K  5.0M   1% /run/lock
tmpfs           462M     0  462M   0% /sys/fs/cgroup
/dev/mmcblk0p6   65M   21M   45M  33% /boot
-----apache
apache2                                         deinstall
apache2-bin                                     deinstall
apache2-utils                                   install
./ntinfo: line 22: /etc/init.d/apache: No such file or directory
-----cron
● cron.service - Regular background program processing daemon
   Loaded: loaded (/lib/systemd/system/cron.service; enabled)
   Active: active (running) since Sat 2019-09-14 09:41:47 CEST; 3 days ago
     Docs: man:cron(8)
 Main PID: 453 (cron)
   CGroup: /system.slice/cron.service
           └─453 /usr/sbin/cron -f

Sep 17 23:50:01 raspberrypi CRON[24417]: (root) CMD (/var/www/nettemp/modules/cron/5)
Sep 17 23:50:01 raspberrypi CRON[24374]: (CRON) info (No MTA installed, discarding output)
Sep 17 23:50:01 raspberrypi CRON[24419]: (root) CMD (/var/www/nettemp/modules/cron/1)
Sep 17 23:50:01 raspberrypi CRON[24374]: pam_unix(cron:session): session closed for user root
Sep 17 23:50:02 raspberrypi CRON[24376]: (CRON) info (No MTA installed, discarding output)
Sep 17 23:50:02 raspberrypi CRON[24376]: pam_unix(cron:session): session closed for user root
Sep 17 23:50:02 raspberrypi CRON[24377]: (CRON) info (No MTA installed, discarding output)
Sep 17 23:50:02 raspberrypi CRON[24377]: pam_unix(cron:session): session closed for user root
Sep 17 23:50:07 raspberrypi CRON[24378]: (CRON) info (No MTA installed, discarding output)
Sep 17 23:50:07 raspberrypi CRON[24378]: pam_unix(cron:session): session closed for user root
-----perms
total 172
drwxrwxr-x  15 root www-data  4096 Sep 12 21:37 .
drwxr-xr-x   4 root root      4096 Jul 11  2017 ..
-rwxrwxr-x   1 root www-data   639 Sep 12 21:37 changelog.txt
drwxrwxr-x   2 root www-data  4096 Sep 12 21:36 common
drwxrwsr-x   2 root www-data  4096 Sep 12 21:37 db
drwxrwsr-x   2 root www-data 12288 Sep 12 21:37 dbf
drwxrwxr-x   8 root www-data  4096 Sep 12 21:37 .git
-rwxrwxr-x   1 root www-data    64 Sep 12 21:36 .gitignore
drwxrwxr-x  14 root www-data  4096 Sep 12 21:36 html
-rwxrwxr-x   1 root www-data 10363 Sep 12 21:36 index.php
drwxrwxr-x  20 root www-data  4096 Sep 12 21:37 install
-rwxrwxr-x   1 root www-data 30735 Jul 10  2017 install_log.txt
-rwxrwxr-x   1 root www-data  1914 Sep 12 21:37 install_nettemp
-rwxrwxr-x   1 root www-data   131 Sep 12 21:36 issue
-rwxrwxr-x   1 root www-data  3697 Sep 12 21:36 lcdfeed.php
-rwxrwxr-x   1 root www-data  1037 Sep 12 21:36 LICENSE.txt
drwxrwxr-x   6 root www-data  4096 Aug 24 19:21 media
drwxrwxr-x  28 root www-data  4096 Aug 24 19:21 modules
drwxrwxr-x   3 root www-data  4096 Sep 12 21:36 other
-rwxrwxr-x   1 root www-data  4124 Sep 12 21:37 ownscript.php
-rwxrwxr-x   1 root www-data  5399 Sep 12 21:37 readme.md
-rwxrwxr-x   1 root www-data 17514 Sep 12 21:37 receiver.php
drwxrwsr-x+  2 root www-data  4096 Sep 12 21:36 scripts
drwxrwxr-x   2 root www-data  4096 Sep 12 21:37 status
drwxrwsr-x+  6 root www-data  4096 Sep 16 10:00 tmp
drwxrwxr-x  11 root www-data  4096 Jul 10  2017 wiringPi
-----ports
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      793/sshd
tcp        0      0 0.0.0.0:1883            0.0.0.0:*               LISTEN      570/mosquitto
tcp6       0      0 :::22                   :::*                    LISTEN      793/sshd
tcp6       0      0 :::1883                 :::*                    LISTEN      570/mosquitto
udp        0      0 0.0.0.0:5353            0.0.0.0:*                           457/avahi-daemon: r
udp        0      0 0.0.0.0:47946           0.0.0.0:*                           841/snmpd
udp        0      0 0.0.0.0:68              0.0.0.0:*                           791/dhcpcd
udp        0      0 10.8.0.1:123            0.0.0.0:*                           835/ntpd
udp        0      0 192.168.1.6:123         0.0.0.0:*                           835/ntpd
udp        0      0 127.0.0.1:123           0.0.0.0:*                           835/ntpd
udp        0      0 0.0.0.0:123             0.0.0.0:*                           835/ntpd
udp        0      0 127.0.0.1:161           0.0.0.0:*                           841/snmpd
udp        0      0 0.0.0.0:59554           0.0.0.0:*                           457/avahi-daemon: r
udp        0      0 0.0.0.0:1194            0.0.0.0:*                           522/openvpn
udp6       0      0 :::5353                 :::*                                457/avahi-daemon: r
udp6       0      0 :::53141                :::*                                457/avahi-daemon: r
udp6       0      0 :::546                  :::*                                791/dhcpcd
udp6       0      0 fe80::238f:ae9c:ed5:123 :::*                                835/ntpd
udp6       0      0 fe80::647e:328b:8a5:123 :::*                                835/ntpd
udp6       0      0 ::1:123                 :::*                                835/ntpd
udp6       0      0 fd34:521a:1def:4:7d:123 :::*                                835/ntpd
udp6       0      0 :::123                  :::*                                835/ntpd
raw6       0      0 :::58                   :::*                    7           791/dhcpcd
Active UNIX domain sockets (only servers)
Proto RefCnt Flags       Type       State         I-Node   PID/Program name    Path
unix  2      [ ACC ]     STREAM     LISTENING     1287     1/init              /run/systemd/private
unix  2      [ ACC ]     SEQPACKET  LISTENING     1310     1/init              /run/udev/control
unix  2      [ ACC ]     STREAM     LISTENING     1314     1/init              /run/systemd/journal/stdout
unix  2      [ ACC ]     STREAM     LISTENING     11060    797/php-fpm.conf)   /run/php/php7.3-fpm.sock
unix  2      [ ACC ]     STREAM     LISTENING     11903    859/php-fpm.conf)   /var/run/php5-fpm.sock
unix  2      [ ACC ]     STREAM     LISTENING     11868    841/snmpd           /var/agentx/master
unix  2      [ ACC ]     STREAM     LISTENING     6817     1/init              /var/run/avahi-daemon/socket
unix  2      [ ACC ]     STREAM     LISTENING     6820     1/init              /var/run/dbus/system_bus_socket
unix  2      [ ACC ]     STREAM     LISTENING     10926    792/php-fpm.conf)   /run/php/php7.0-fpm.sock
unix  2      [ ACC ]     STREAM     LISTENING     10456    791/dhcpcd          /var/run/dhcpcd.sock
unix  2      [ ACC ]     STREAM     LISTENING     10458    791/dhcpcd          /var/run/dhcpcd.unpriv.sock
-----firewall
Chain INPUT (policy ACCEPT)
target     prot opt source               destination

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination
Chain PREROUTING (policy ACCEPT)
target     prot opt source               destination

Chain INPUT (policy ACCEPT)
target     prot opt source               destination

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination

Chain POSTROUTING (policy ACCEPT)
target     prot opt source               destination
-----USB info
Bus 001 Device 003: ID 0424:ec00 Standard Microsystems Corp. SMSC9512/9514 Fast Ethernet Adapter
Bus 001 Device 002: ID 0424:9514 Standard Microsystems Corp.
Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub
[    0.158353] usbcore: registered new interface driver usbfs
[    0.158461] usbcore: registered new interface driver hub
[    0.158577] usbcore: registered new device driver usb
[    0.328251] usbcore: registered new interface driver smsc95xx
[    0.808416] dwc_otg 3f980000.usb: DWC OTG Controller
[    0.811058] dwc_otg 3f980000.usb: new USB bus registered, assigned bus number 1
[    0.816387] dwc_otg 3f980000.usb: irq 62, io mem 0x00000000
[    0.824837] usb usb1: New USB device found, idVendor=1d6b, idProduct=0002
[    0.827645] usb usb1: New USB device strings: Mfr=3, Product=2, SerialNumber=1
[    0.833099] usb usb1: Product: DWC OTG Controller
[    0.835874] usb usb1: Manufacturer: Linux 4.9.35-v7+ dwc_otg_hcd
[    0.838685] usb usb1: SerialNumber: 3f980000.usb
[    0.848618] usbcore: registered new interface driver usb-storage
[    0.890064] usbcore: registered new interface driver usbhid
[    0.893041] usbhid: USB HID core driver
[    1.266762] usb 1-1: new high-speed USB device number 2 using dwc_otg
[    1.496998] usb 1-1: New USB device found, idVendor=0424, idProduct=9514
[    1.499912] usb 1-1: New USB device strings: Mfr=0, Product=0, SerialNumber=0
[    1.826729] usb 1-1.1: new high-speed USB device number 3 using dwc_otg
[    1.956974] usb 1-1.1: New USB device found, idVendor=0424, idProduct=ec00
[    1.959803] usb 1-1.1: New USB device strings: Mfr=0, Product=0, SerialNumber=0
[    2.060428] smsc95xx 1-1.1:1.0 eth0: register 'smsc95xx' at usb-3f980000.usb-1.1, smsc95xx USB 2.0 Ethernet, b8:27:eb:d8:2b:bf
[    6.337569] usbcore: registered new interface driver brcmfmac
-----modules
Module                  Size  Used by
iptable_nat             2320  0
nf_conntrack_ipv4       8890  1
nf_defrag_ipv4          1824  1 nf_conntrack_ipv4
nf_nat_ipv4             6071  1 iptable_nat
nf_nat                 18854  1 nf_nat_ipv4
nf_conntrack          104800  3 nf_conntrack_ipv4,nf_nat_ipv4,nf_nat
binfmt_misc             7988  1
bnep                   12051  2
hci_uart               20020  1
btbcm                   7916  1 hci_uart
bluetooth             365511  22 hci_uart,bnep,btbcm
tun                    24067  2
ip6table_filter         2159  0
ip6_tables             13434  1 ip6table_filter
iptable_filter          2197  0
ip_tables              13161  2 iptable_filter,iptable_nat
x_tables               20578  4 ip_tables,iptable_filter,ip6table_filter,ip6_tables
brcmfmac              222874  0
brcmutil                9092  1 brcmfmac
cfg80211              543027  1 brcmfmac
rfkill                 20851  4 bluetooth,cfg80211
w1_therm                6401  0
bcm2835_gpiomem         3940  0
snd_bcm2835            24427  0
snd_pcm                98501  1 snd_bcm2835
snd_timer              23968  1 snd_pcm
w1_gpio                 4818  0
snd                    70032  3 snd_timer,snd_bcm2835,snd_pcm
i2c_bcm2835             7167  0
wire                   32619  2 w1_gpio,w1_therm
cn                      5889  1 wire
fixed                   3285  0
uio_pdrv_genirq         3923  0
uio                    10204  1 uio_pdrv_genirq
i2c_dev                 6913  0
ipv6                  408971  38
# /etc/modules: kernel modules to load at boot time.
#
# This file contains the names of kernel modules that should be loaded
# at boot time, one per line. Lines beginning with "#" are ignored.

i2c-dev
----- Device tree
----- highchats
du: cannot access ‘/var/www/nettemp/modules/highcharts/’: No such file or directory
----- highchats data count
cat: /var/www/nettemp/tmp/highcharts/*: No such file or directory
0
----- sql sensors
Error: file is encrypted or is not a database
----- sql gpio
Error: file is encrypted or is not a database
----- git status
On branch betamm
Your branch is up-to-date with 'origin/betamm'.
Changes not staged for commit:
  (use "git add <file>..." to update what will be committed)
  (use "git checkout -- <file>..." to discard changes in working directory)

        modified:   changelog.txt
        modified:   common/functions.php
        modified:   common/gpio_functions.php
        modified:   common/log_auto_delete.php
        modified:   html/jquery/jquery-3.3.1.js
        modified:   install/python/python.sh
        modified:   install/services/mosquitto.service
        modified:   install/stats/stats.php
        modified:   media/ico/Dewpoint-icon.png
        modified:   media/ico/airly.png
        modified:   media/ico/max-icon.png
        modified:   media/ico/min-icon.png
        modified:   media/ico/pressurenorm.png
        modified:   media/ico/sunrise-icon.png
        modified:   media/ico/sunset-icon.png
        modified:   media/png/nettemp.tk.png
        modified:   modules/counters/html/counters_reports.php
        modified:   modules/cron/10
        modified:   modules/cron/12h
        modified:   modules/cron/15
        modified:   modules/cron/2
        modified:   modules/cron/24h
        modified:   modules/cron/2h
        modified:   modules/cron/30
        modified:   modules/cron/6h
        modified:   modules/gpio/html/gpio_trigger.php
        modified:   modules/mail/html/mail_settings.php
        modified:   modules/notifications/send_notifications.php
        modified:   modules/pushover/html/pushover_settings.php
        modified:   modules/sensors/html/sensors_expand.php
        modified:   modules/sensors/html/sensors_notifications.php
        modified:   modules/sensors/send_domoticz.php
        modified:   modules/sensors/virtual.php
        modified:   modules/sensors/wireless/esp8266_read
        modified:   modules/sensors/wireless/esp8266_scan
        modified:   modules/settings/global.php
        modified:   modules/settings/mail_usun.php
        modified:   modules/settings/notifications.php
        modified:   modules/settings/stats.php
        modified:   modules/settings/status_order.php
        modified:   modules/tools/check_update
        modified:   modules/tools/html/log/log_piups.php
        modified:   modules/tools/send_stats.sh
        modified:   modules/tools/update_db_new.php
        modified:   ownscript.php
        modified:   scripts/testscript

Untracked files:
  (use "git add <file>..." to include in what will be committed)

        db/nettemp.db
        db/nettemp.db.2017-06-01_201050.7048
        db/nettemp.db.2017-06-01_201100.1692
        db/nettemp.db.2017-06-05_220216.4187
        db/nettemp.db.2017-06-12_081412.4871
        db/nettemp.db.2017-06-12_081422.6059
        db/nettemp.db.2017-06-16_122808.1069
        db/nettemp.db.2017-06-16_122816.5784
        db/nettemp.db.2017-06-20_171749.1809
        db/nettemp.db.2017-06-20_171758.3610
        db/nettemp.db.2017-06-26_081024.9171
        db/nettemp.db.2017-06-26_081033.7769
        db/nettemp.db.2017-06-28_181837.1589
        db/nettemp.db.2017-07-06_222246.1033
        db/nettemp.db.2017-07-06_222306.7744
        db/nettemp.db.2017-07-08_144348.1309
        db/nettemp.db.2017-07-10_075731.1285

no changes added to commit (use "git add" and/or "git commit -a")
----- END -----
root@raspberrypi:/var/www/nettemp/other#  
ODPOWIEDZ