NAS и Billing отдельно

Модуль организации Diulup и VPN доступа
Site Admin
Сообщения: 5654
Зарегистрирован: Пт янв 28, 2005 3:11 pm
Контактная информация:

Re: NAS и Billing отдельно

Сообщение ~AsmodeuS~ » Вс апр 08, 2018 11:04 am

marat1985 писал(а):Добрый день. Решил не плодить темы, написать в эту.
Появилась проблема, не отрисовывает графики и в разделе Мониторинг->Интернет (График для Сервер доступа, График для Тарифные планы, График для Группы).
Версия ABillS 0.76.26
В логах сообщения:

Код: Выделить всё

[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/ 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/ 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/ line 311.: /usr/abills/cgi-bin/charts.cgi, referer: https://*.*.30.3:9443/admin/index.cgi?index=149
Может версия perl не подходит.

Код: Выделить всё

[marat@] /usr/abills/misc/> perl 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-              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-     GNU gettext runtime libraries and programs
gettext-tools-         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               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
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 (
      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;
 --called with 1 bind variables when 0 are needed
 --AutoCommit: 1


Обновите до 0.77 версии

Сообщения: 15
Зарегистрирован: Пт сен 15, 2017 11:43 am

Re: NAS и Billing отдельно

Сообщение marat1985 » Вс апр 08, 2018 4:34 pm

Переехал на новую версию.
Постоянно при добавлении ip polls вылазит ошибка (но пул добавляется и адреса выдаются):
sql error.png
sql error.png (28.36 КБ) 798 просмотров
Модуль Dv уже не нужен

Код: Выделить всё

our @MODULES = (
  #Device monitoring and manage via snmp
#  'Cards',
И видимо уже не требуется по крону запускать?:
*/5 * * * * root /usr/abills/libexec/billd -all
1 0 * * * root /usr/abills/libexec/periodic daily
1 1 * * * root /usr/abills/libexec/periodic monthly

Site Admin
Сообщения: 5654
Зарегистрирован: Пт янв 28, 2005 3:11 pm
Контактная информация:

Re: NAS и Billing отдельно

Сообщение ~AsmodeuS~ » Вс апр 08, 2018 6:12 pm

уже поправлено в обновлениях

у кого еще вылазит

mysql -D abills < db/Dv.sql