marat1985 писал(а):Добрый день. Решил не плодить темы, написать в эту.
Появилась проблема, не отрисовывает графики и в разделе Мониторинг->Интернет (График для Сервер доступа, График для Тарифные планы, График для Группы).
Версия ABillS 0.76.26
В логах сообщения:
Может версия perl не подходит.Код: Выделить всё
[Fri Apr 06 10:44:24.111466 2018] [cgi:error] [pid 41777] [client *.*.16.51:54444] AH01215: DBD::mysql::st execute failed: called with 1 bind variables when 0 are needed at ../Abills/mysql/main.pm line 282.: /usr/abills/cgi-bin/charts.cgi, referer: https://*.*.30.3:9443/admin/index.cgi?index=149 [Fri Apr 06 10:44:24.113919 2018] [cgi:error] [pid 41777] [client *.*.16.51:54444] AH01215: Use of uninitialized value in concatenation (.) or string at ../Abills/mysql/main.pm line 300.: /usr/abills/cgi-bin/charts.cgi, referer: https://*.*.30.3:9443/admin/index.cgi?index=149 [Fri Apr 06 10:44:24.121805 2018] [cgi:error] [pid 41777] [client *.*.16.51:54444] AH01215: Undefined subroutine &main::templates called at ../lib/Abills/Misc.pm line 311.: /usr/abills/cgi-bin/charts.cgi, referer: https://*.*.30.3:9443/admin/index.cgi?index=149
Код: Выделить всё
[marat@] /usr/abills/misc/> perl perldeps.pl port Testing modules Authen::Captcha...............[ OK ] Crypt::DES....................[ OK ] Crypt::OpenSSL::X509..........[ OK ] DBD::mysql....................[ OK ] DBI...........................[ OK ] Devel::NYTProf................[ OK ] Digest::MD4...................[ OK ] Digest::MD5...................[ OK ] Digest::SHA1..................[ OK ] Imager::QRCode................[ OK ] JSON..........................[ OK ] LWP::UserAgent................[ OK ] URI...........................[ OK ] PDF::API2.....................[ OK ] Perl::GD......................[ OK ] Spreadsheet::WriteExcel.......[ OK ] Time::HiRes...................[ OK ] XML::Simple...................[ OK ] LWP::Protocol::https..........[ OK ] IO::Socket::SSL...............[ OK ] Text::CSV.....................[ OK ] Everything's OK
Код: Выделить всё
[marat@] /usr/abills/misc/> pkg info apache24-2.4.33 Version 2.4.x of Apache web server apr-1.6.3.1.6.1_1 Apache Portability Library autoconf-2.69_1 Automatically configure source code on many Un*x platforms autoconf-wrapper-20131203 Wrapper script for GNU autoconf automake-1.15.1 GNU Standards-compliant Makefile generator automake-wrapper-20131203 Wrapper script for GNU automake bigreqsproto-1.1.2 BigReqs extension headers bison-3.0.4,1 Parser generator from FSF, (mostly) compatible with Yacc ca_root_nss-3.36 Root certificate bundle from the Mozilla Project check-0.12.0 Unit test framework for C cmake-3.10.2 Cross-platform Makefile generator curl-7.59.0 Command line tool and library for transferring data with URLs db5-5.3.28_6 Oracle Berkeley DB, revision 5.3 dialog4ports-0.1.6 Console Interface to configure ports expat-2.2.5 XML 1.0 parser written in C fontconfig-2.12.1_3,1 XML-based font configuration API for X Windows freeradius-2.2.9 Free RADIUS server implementation freetype2-2.8_1 Free and portable TrueType font rendering engine gdbm-1.13_1 GNU database manager gettext-runtime-0.19.8.1_1 GNU gettext runtime libraries and programs gettext-tools-0.19.8.1 GNU gettext development and translation tools giflib-5.1.4 Tools and library routines for working with GIF images gmake-4.2.1_2 GNU version of 'make' utility help2man-1.47.6 Automatically generating simple manual pages from program output hwloc-1.11.7_2 Portable Hardware Locality software package indexinfo-0.3.1 Utility to regenerate the GNU info page index inputproto-2.3.2 Input extension headers jbigkit-2.1_1 Lossless compression for bi-level images such as scanned pages, faxes jpeg-turbo-1.5.3 SIMD-accelerated JPEG codec which replaces libjpeg jsoncpp-1.8.1_3 JSON reader and writer library for C++ kbproto-1.0.7 KB extension headers libICE-1.0.9_1,1 Inter Client Exchange library for X11 libSM-1.2.2_3,1 Session Management library for X11 libX11-1.6.5,1 X11 library libXau-1.0.8_3 Authentication Protocol library for X11 libXaw-1.0.13,2 X Athena Widgets library libXdmcp-1.1.2 X Display Manager Control Protocol library libXext-1.3.3_1,1 X11 Extension library libXmu-1.1.2_3,1 X Miscellaneous Utilities libraries libXp-1.0.3,1 X print library libXpm-3.5.12 X Pixmap library libXt-1.1.5,1 X Toolkit library libarchive-3.3.2,1 Library to create and read several streaming archive formats libedit-3.1.20170329_2,1 Command line editor library libevent-2.1.8_1 API for executing callback functions on events or timeouts libffi-3.2.1_2 Foreign Function Interface libgcrypt-1.8.2 General purpose crypto library based on code used in GnuPG libgd-2.2.4_1,1 Graphics library for fast creation of images libgpg-error-1.28 Common error values for all GnuPG components libidn2-2.0.4 Implementation of IDNA2008 internationalized domain names libltdl-2.4.6 System independent dlopen wrapper liblz4-1.8.1.2,1 LZ4 compression library, lossless and very fast libmicrohttpd-0.9.58_1 C library for embedding HTTP server functionality libnghttp2-1.31.0 HTTP/2.0 C Library libpciaccess-0.13.5 Generic PCI access library libpthread-stubs-0.4 This library provides weak aliases for pthread functions libtool-2.4.6 Generic shared library support script libunistring-0.9.9 Unicode string library libunwind-20170615 Generic stack unwinding library libuv-1.19.2 Multi-platform support library with a focus on asynchronous I/O libxcb-1.12_2 The X protocol C-language Binding (XCB) library libxml2-2.9.7 XML parser library for GNOME libxslt-1.1.29_1 The XSLT C library for GNOME libyaml-0.1.6_2 YAML 1.1 parser and emitter written in C libzip-1.3.2 C library for reading, creating, and modifying ZIP archives lzo2-2.10_1 Portable speedy, lossless data compression library m4-1.4.18,1 GNU M4 mod_php56-5.6.34_2 PHP Scripting Language mysql56-client-5.6.39_1 Multithreaded SQL database (client) mysql56-server-5.6.39_1 Multithreaded SQL database (server) nasm-2.13.03,1 General-purpose multi-platform x86 and amd64 assembler oniguruma-6.8.1 Regular expressions library compatible with POSIX/GNU/Perl p5-Authen-Captcha-1.024 Perl module to verify the human element in transactions p5-Authen-NTLM-1.09_1 Perl5 NTLM authentication module p5-Bit-Vector-7.4 Library of advanced math functions that includes a Perl OO module p5-CGI-4.38 Handle Common Gateway Interface requests and responses p5-Cache-2.11 Perl Cache interface p5-Cache-Cache-1.08 Perl Cache interface p5-Carp-Clan-6.06 Report errors from perspective of caller of a "clan" of modules p5-Cpanel-JSON-XS-4.02 JSON::XS for Cpanel, fast and correct serialising p5-Crypt-CBC-2.33_1 Perl5 interface to Cipher Block Chaining with DES and IDEA p5-Crypt-DES-2.07_1 Perl5 interface to DES block cipher p5-Crypt-OpenSSL-X509-1.808 Perl extension for OpenSSL X509 API p5-DBD-mysql-4.046 MySQL driver for the Perl5 Database Interface (DBI) p5-DBI-1.641 Perl5 Database Interface, required for DBD::* modules p5-Date-Calc-6.4 Gregorian calendar date calculations p5-Date-Manip-6.70 Perl5 module containing date manipulation routines p5-Devel-CheckLib-1.11 Check that a library is available p5-Devel-NYTProf-6.04 Powerful feature-rich Perl source code profiler p5-Digest-HMAC-1.03_1 Perl5 interface to HMAC Message-Digest Algorithms p5-Digest-MD4-1.9_1 Perl5 interface to the MD4 message digest algorithm p5-Digest-SHA1-2.13_1 Perl interface to the SHA-1 Algorithm p5-Encode-Locale-1.05 Determine the locale encoding p5-Error-0.17025 Error/exception handling in object-oriented programming style p5-ExtUtils-PkgConfig-1.16 Simplistic interface to pkg-config p5-File-HomeDir-1.002 Get home directory for self or other users p5-File-Listing-6.04_1 Parse directory listings p5-File-NFSLock-1.21_1 File::NFSLock - perl module to do NFS (or not) locking p5-File-Which-1.22 Portable implementation of which(1) in Perl p5-Font-TTF-1.06 Perl module for TrueType font hacking p5-GD-2.68 Perl5 interface to Gd Graphics Library version2 p5-HTML-Parser-3.72 Perl5 module for parsing HTML documents p5-HTML-Tagset-3.20_1 Some useful data table in parsing HTML p5-HTTP-Cookies-6.04 HTTP Cookie jars p5-HTTP-Daemon-6.01_1 Simple HTTP server class p5-HTTP-Date-6.02_1 Conversion routines for the HTTP protocol date formats p5-HTTP-Message-6.15 Representation of HTTP style messages p5-HTTP-Negotiate-6.01_1 Implementation of the HTTP content negotiation algorithm p5-Heap-0.80_1 Perl extensions for keeping data partially sorted p5-IO-HTML-1.001_1 Open an HTML file with automatic charset detection p5-IO-Socket-SSL-2.051 Perl5 interface to SSL sockets p5-IO-String-1.08_1 Simplified Perl5 module to handle I/O on in-core strings p5-IO-stringy-2.111 Use IO handles with non-file objects p5-IPC-ShareLite-0.17_1 Simple interface to access shared memory p5-Imager-1.006 Perl module for manipulating gray, color, and rgba format images p5-Imager-QRCode-0.035 Generate QR Code with Imager using libqrencode p5-JSON-2.97.001 Perl extension to convert to JSON (JavaScript Object Notation) p5-JSON-MaybeXS-1.003010 Use Cpanel::JSON::XS with a fallback to JSON::PP p5-LWP-MediaTypes-6.02_1 Guess media type for a file or a URL p5-LWP-Protocol-https-6.07_1 Provide https support for LWP::UserAgent p5-LWP-UserAgent-WithCache-0.12_1 LWP::UserAgent extension with local cache p5-Locale-gettext-1.07 Message handling functions p5-Module-Build-0.4224 Build and install Perl modules p5-Mozilla-CA-20160104 Perl extension for Mozilla CA cert bundle in PEM format p5-Net-HTTP-6.17 Low-level HTTP client p5-Net-SSLeay-1.85 Perl5 interface to SSL p5-OLE-Storage_Lite-0.19_1 Perl module for OLE document interface p5-PDF-API2-2.033 Facilitates the creation and modification of PDF files p5-Parse-RecDescent-1.967.009_2 Recursive descent parsing framework for Perl p5-Spreadsheet-WriteExcel-2.40_1 Write to a cross-platform Excel binary file p5-String-Random-0.29,1 Perl interface to generate "random" strings p5-Text-CSV-1.95 Composition and decomposition of comma-separated values p5-TimeDate-2.30_2,1 Perl5 module containing a better/faster date parser for absolute dates p5-Try-Tiny-0.28 Minimal try/catch with proper localization of $@ p5-URI-1.73 Perl5 interface to Uniform Resource Identifier (URI) references p5-WWW-RobotRules-6.02_1 Database of robots.txt-derived permissions p5-XML-NamespaceSupport-1.12 Simple generic namespace support class p5-XML-Parser-2.44 Perl extension interface to James Clark's XML parser, expat p5-XML-SAX-1.00 Simple API for XML p5-XML-SAX-Base-1.09 Base class SAX Drivers and Filters p5-XML-SAX-Expat-0.51_1 Simple API for XML p5-XML-Simple-2.25 Trivial API for reading and writing XML (esp config files) p5-libwww-6.33 Perl5 library for WWW access pciids-20180219 Database of all known IDs used in PCI devices pcre-8.40_1 Perl Compatible Regular Expressions library perl5-5.24.3 Practical Extraction and Report Language php56-5.6.34_2 PHP Scripting Language php56-bz2-5.6.34_2 The bz2 shared extension for php php56-ctype-5.6.34_2 The ctype shared extension for php php56-filter-5.6.34_2 The filter shared extension for php php56-gd-5.6.34_1 The gd shared extension for php php56-json-5.6.34_2 The json shared extension for php php56-mbstring-5.6.34_2 The mbstring shared extension for php php56-mysql-5.6.34_2 The mysql shared extension for php php56-mysqli-5.6.34_2 The mysqli shared extension for php php56-openssl-5.6.34_2 The openssl shared extension for php php56-session-5.6.34_2 The session shared extension for php php56-xml-5.6.34_2 The xml shared extension for php php56-zip-5.6.34_2 The zip shared extension for php php56-zlib-5.6.34_2 The zlib shared extension for php phpMyAdmin-4.7.9 Set of PHP-scripts to manage MySQL over the web pkg-1.10.5 Package manager pkgconf-1.4.2,1 Utility to help to configure compiler and linker flags png-1.6.34 Library for manipulating PNG images portupgrade-2.4.16,2 FreeBSD ports/packages administration and management tool suite printproto-1.0.5 Print extension headers py27-Babel-2.5.1 Collection of tools for internationalizing Python applications py27-Jinja2-2.10 Fast and easy to use stand-alone template engine py27-MarkupSafe-1.0 Implements XML/HTML/XHTML Markup safe string for Python py27-alabaster-0.7.6 Modified Kr Sphinx theme py27-asn1crypto-0.22.0 ASN.1 library with a focus on performance and a pythonic API py27-certifi-2018.1.18 Mozilla SSL certificates py27-cffi-1.11.2 Foreign Function Interface for Python calling C code py27-chardet-3.0.4 Universal encoding detector for Python 2 and 3 py27-cryptography-2.1.4 Cryptographic recipes and primitives for Python developers py27-docutils-0.14_1 Python Documentation Utilities py27-enum34-1.1.6 Python 3.4 Enum backported to 3.3, 3.2, 3.1, 2.7 py27-idna-2.6 Internationalized Domain Names in Applications (IDNA) py27-imagesize-0.7.1 Python image size library py27-ipaddress-1.0.19 Port of Python 3.3+ ipaddress module to 2.7 py27-openssl-17.5.0_1 Python interface to the OpenSSL library py27-pycparser-2.10 C parser in Python py27-pygments-2.2.0 Syntax highlighter written in Python py27-pysocks-1.6.8 Python SOCKS module py27-pystemmer-1.3.0_1 Snowball Stemming Algorithms for Information Retrieval py27-pytest-runner-2.11.1 Test support for pytest runner in setup.py py27-pytz-2018.3,1 World Timezone Definitions for Python py27-requests-2.18.4 HTTP library written in Python for human beings py27-setuptools-36.2.2 Python packages installer py27-setuptools_scm-1.15.5 Setuptools plugin to manage your versions by scm tags py27-six-1.11.0 Python 2 and 3 compatibility utilities py27-snowballstemmer-1.2.0_1 Snowball stemming library collection for Python py27-sphinx-1.6.5_1,1 Python documentation generator py27-sphinx_rtd_theme-0.2.4 Mobile-friendly py-sphinx theme py27-sphinxcontrib-websupport-1.0.1 Sphinx API for Web Apps py27-typing-3.6.4 Type Hints for Python py27-urllib3-1.22 HTTP library with thread-safe connection pooling, file post, and more python2-2_3 The "meta-port" for version 2 of the Python interpreter python27-2.7.14_1 Interpreted object-oriented programming language readline-7.0.3_1 Library for editing command lines as they are typed rhash-1.3.5 Utility and library for computing and checking of file hashes ruby-2.4.3,1 Object-oriented interpreted scripting language ruby23-2.3.6,1 Object-oriented interpreted scripting language ruby23-bdb-0.6.6_5 Ruby interface to Oracle Berkeley DB revision 2 or later ruby24-bdb-0.6.6_5 Ruby interface to Oracle Berkeley DB revision 2 or later scons-3.0.1 Build tool alternative to make screen-4.6.2 Multi-screen window manager t1lib-5.1.2_4,1 Type 1 font rasterization library for Unix/X11 texinfo-6.5,1 Typeset documentation system with multiple format output tiff-4.0.9_1 Tools and library routines for working with TIFF images webp-0.6.1 Google WebP image format conversion tool wget-1.19.4_2 Retrieve files from the Net via HTTP(S) and FTP xcb-proto-1.12 The X protocol C-language Binding (XCB) protocol xcmiscproto-1.2.2 XCMisc extension headers xextproto-7.3.0 XExt extension headers xf86bigfontproto-1.2.0 XFree86-Bigfont extension headers xorg-macros-1.19.1 X.Org development aclocal macros xproto-7.0.31 X11 protocol headers xtrans-1.3.5 Abstract network code for X
Код: Выделить всё
ee /usr/abills/var/log/sql_errors 2018-04-06 11:11:20 LOG_ERR: index: SELECT l.last_update, SUM(l.recv1) * 8 , SUM(l.sent1) * 8 , SUM(l.recv2) * 8 , SUM(l.sent2) * 8 FROM s_detail l INNER JOIN users u ON (u.id=l.id) INNER JOIN dv_main dv ON (dv.uid=u.uid) WHERE dv.tp_id='1' and l.last_update > 1522962001 and l.last_update < 1523048401 GROUP BY 1 ORDER BY l.last_update; ---1 --called with 1 bind variables when 0 are needed --AutoCommit: 1
Спасибо.
Обновите до 0.77 версии