intaro / pinboard Goto Github PK
View Code? Open in Web Editor NEWRealtime PHP monitoring system which aggregates and displays Pinba data.
Home Page: http://intaro.github.io/pinboard/
License: MIT License
Realtime PHP monitoring system which aggregates and displays Pinba data.
Home Page: http://intaro.github.io/pinboard/
License: MIT License
Show total values in table on the homepage.
At the main overview page sorting by values Requests / Sec
and Pages with errors
performs as values are string, number-like sorting is needed.
Может не стоит так часто рассылать письма "drawdown of indicators" где статус даты [OK]? Если все ОК - то кого это должно волновать?
Hi!
I found that if I have empty server name on pinba stats (I know that it's wrong but I don't think it's a good reason to crush total pinboard because of it) pinboard will crush.
Twig_Error_Runtime: An exception has been thrown during the rendering of a template ("Parameter "serverName" for route "server" must match "[^/]++" ("" given) to generate a corresponding URL.") in "index.html.twig" at line 18.
Hi,
I want encode my password like describe in the documentation.
I have encode my paasmord to sha512 with 5000 iterations and re-encode this hash to base64.
I have launch all operation in PHP script.
echo base64_encode(crypt('myPasswordToEncode', '$6$rounds=5000$usesomesillystringforsalt$'));
The hash is not matching when I try to log in.
A suggestion ?
Выдается такая ошибка:
SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1.
Насколько я понял, это вызвано разницей полей в таблицах ipm и pinba. При этом я собирал pinba_engine из ветки master:
git remote show origin
* remote origin
Fetch URL: https://github.com/tony2001/pinba_engine.git
Push URL: https://github.com/tony2001/pinba_engine.git
HEAD branch: master
Remote branches:
devel tracked
devel_ntag tracked
devel_percentiles tracked
devel_read_by_pos tracked
devel_schema tracked
devel_schema_request_tags tracked
generator tracked
gh-pages tracked
master tracked
Local branch configured for 'git pull':
master merges with remote master
Local ref configured for 'git push':
master pushes to master (up to date)
Now i need to be a programmer to write it.
www # /var/www/pinboard/console aggregate
[PDOException]
SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1
aggregate
I had an issue with the installation on mysql with non-standart port (3307 in my case). The solution is to add two lines of code:
$app->register(new Silex\Provider\DoctrineServiceProvider(), array(
'db.options' => array(
...
'port' => $app['params']['db']['port'],
...
)
));
db:
...
port: 3307
...
When I go to...
http://intaro.github.io/pinboard/
and click the logo in the upper left I get...
404 There isn't a GitHub Page here.
Thanks.
When using the secure option with PHP-FPM, the user can not login.
The fix, found in Pydio documentation is to use theses lines in .htaccess:
RewriteCond %{HTTP:Authorization} ^(.)
RewriteRule ^(.) - [E=HTTP_AUTHORIZATION:%1]
If server has several hosts charts in "Overview" tab contain duplicated values for each time position which quantity equals hosts quantity.
In config/parameters.yml
add option notification/ignore
:
notification:
ignore:
- (foo|otp)\.example\.com$
- second-example\.ru$
In command aggregate
don't send emails about 5xx statuses for this hosts.
Pinboard displays statistic for a day. Can it show data for various period?
Please, consider updating composer.json, the line of the version of symphony/security component as its dev-master version currently has a call to event->isMasterRequest() method, which doesn't exist in the current 2.3. Or possibly add the line to include the current dev-master of http-kernel component.
The problem is that piboard won't start throwing fatal error.
config/parameters.yml
throw regexpconsole aggregate
commandCondition:
Now this chart display all requests per sec to website. In mode "All hosts" add figures for requests/sec per hostname.
Add notification about increasing of 90th and 95th percentiles of request time higher than a border value.
2/2Twig_Error_Runtime: An exception has been thrown during the rendering of a template ("Parameter "serverName" for route "server" must match "[^/]++" ("ct=/yandsearch
Sec" given) to generate a corresponding URL.") in "index.html.twig" at line 24.
Add necessary indexes to pinboard tables.
When the pinboard installed not in the root, html resouces (js, css, etc.) won't load beacause absolute URL paths are used in the base.html.twig. Suggest to change them for relative paths.
Add ability to define array of hosts for user access settings. Example for testuser3
:
secure:
enable: false
users:
testuser1:
password: my_password1
testuser2:
password: my_password2
hosts: 'example\.com$'
testuser3:
password: my_password3
hosts:
- 'example\.com$'
- 'some\-domain\.net$'
Try to start, getting exception:
2013/07/22 18:08:09 [error] 12904#0: *1135 FastCGI sent in stderr: "PHP message: PHP Fatal error: Call to undefined function Doctrine\Common\Cache\apc_fetch() in /var/www/pinboard/vendor/doctrine/common/lib/Doctrine/Common/Cache/ApcCache.php on line 52" while reading response header from upstream, client:XX.XX.XX.XX, server: somesite.shalb.com, request: "GET / HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "somesite.shalb.com"
Ajax loading broken when ID of requests in request
table achieves value of 999999.
Email notiication instead of:
example.com
* HTTP status 503: example.com/ajax/search/autocomplete.php
* HTTP status 503: example.com/ajax/search/autocomplete.php
* HTTP status 503: example.com/ajax/search/autocomplete.php
* HTTP status 503: example.com/ajax/search/autocomplete.php
* HTTP status 503: example.com/ajax/search/autocomplete.php
* HTTP status 503: example.com/index.php
* HTTP status 503: example.com/product.php
must form:
example.com
* HTTP status 503: example.com/ajax/search/autocomplete.php (5)
* HTTP status 503: example.com/index.php
* HTTP status 503: example.com/product.php
For error pages in email notification display hostname. It's useful if site runs on several servers.
Добрый день. После установки pinboard и запуска получаю такую штуку
/usr/local/src/pinboard/src/Pinboard/Command/../../../console -vvv aggregate
[PDOException]
SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty
Exception trace:
() at /usr/local/src/pinboard/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:716
PDO->query() at n/a:n/a
call_user_func_array() at /usr/local/src/pinboard/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:716
Doctrine\DBAL\Connection->query() at /usr/local/src/pinboard/src/Pinboard/Command/AggregateCommand.php:202
Pinboard\Command\AggregateCommand->execute() at /usr/local/src/pinboard/vendor/symfony/console/Symfony/Component/Console/Command/Command.php:245
Symfony\Component\Console\Command\Command->run() at /usr/local/src/pinboard/vendor/symfony/console/Symfony/Component/Console/Application.php:880
Symfony\Component\Console\Application->doRunCommand() at /usr/local/src/pinboard/vendor/symfony/console/Symfony/Component/Console/Application.php:194
Symfony\Component\Console\Application->doRun() at /usr/local/src/pinboard/vendor/symfony/console/Symfony/Component/Console/Application.php:124
Symfony\Component\Console\Application->run() at /usr/local/src/pinboard/console:15
aggregate
Подскажите, пожалуйста, что с этим можно сделать.
show tables;
| info |
| ipm_info |
| ipm_mem_peak_usage_details |
| ipm_report_2_by_hostname_and_server |
| ipm_report_by_hostname |
| ipm_report_by_hostname_and_script |
| ipm_report_by_hostname_and_server |
| ipm_report_by_hostname_server_and_script |
| ipm_report_by_script_name |
| ipm_report_by_server_and_script |
| ipm_report_by_server_name |
| ipm_report_status |
| ipm_req_time_details |
| ipm_status_details |
| report_by_hostname |
| report_by_hostname_and_script |
| report_by_hostname_and_server |
| report_by_hostname_server_and_script |
| report_by_script_name |
| report_by_server_and_script |
| report_by_server_name |
| request |
| tag |
| timer |
| timertag |
PHP 5.4.17 (cli) (built: Jul 23 2013 13:57:49)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies
with XCache v3.0.3, Copyright (c) 2005-2013, by mOo
with XCache Cacher v3.0.3, Copyright (c) 2005-2013, by mOo
На Xcache переключил - тут ошибок не всплывает.
Опции сборки php
./configure --enable-fpm --enable-libxml --with-mcrypt --enable-mbstring --with-gd --with-mysql-sock --with-mysqli=mysqlnd --with-pdo-mysql=mysqlnd --with-mysql=mysqlnd --enable-sockets --with-iconv --with-gettext --with-zlib --with-freetype-dir=/usr --with-jpeg-dir=/usr --prefix=/usr/local/php-fpm --with-config-file-path=/usr/local/php-fpm/etc --with-config-file-scan-dir=/usr/local/php-fpm/etc/conf.d --with-fpm-user=www-data --with-fpm-group=www-data --disable-simplexml --disable-xmlreader --disable-xmlwriter --disable-tokenizer --without-sqlite3 --without-pdo-sqlite --with-curl
Спасибо.
config/parameters.yml
for turn on/off authenticationconfig/parameters.yml
for user/pass settings (example http://silex.sensiolabs.org/doc/providers/security.html#securing-a-path-with-http-authentication)config/parameters.yml
for access settings for users to sites with regexp/server/{serverName}/{host}/overview.json?apiKey={apiKey}
{host}
— optional parameter, equals all
by defaultAfter some time cant see data in web.
After try start Crontab task manually get error:
Cannot run data aggregating: the another instance of this script is already executing. Otherwise, remove /var/www/pinboard/src/Pinboard/Command/AggregateCommand.php.lock file
but nothing running at this time.
to resolve this issue, to the end of aggregate command in crontab add
&& rm -rf /%PATH_to_lockFIle%/AggregateCommand.php.lock
pinboard v.1.1
Sometimes smtp is not accessable thats why aggregate
command throws exception
[Swift_IoException]
Connection to smtp.ht-systems.ru:25 Timed Out
aggregate
PHP Fatal error: Uncaught exception 'Swift_IoException' with message 'Connection to smtp.ht-systems.ru:25 Timed Out' in /home/webmaster/pinboard/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php:174
Stack trace:
#0 /home/webmaster/pinboard/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(438): Swift_Transport_StreamBuffer->readLine(14)
#1 /home/webmaster/pinboard/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(301): Swift_Transport_AbstractSmtpTransport->_getFullResponse(14)
#2 /home/webmaster/pinboard/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/EsmtpTransport.php(224): Swift_Transport_AbstractSmtpTransport->executeCommand('QUIT??', Array, Array)
#3 /home/webmaster/pinboard/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(237): Swift_Transport_EsmtpTransport->executeCommand('QUIT??', Array)
#4 /home/webmaster/pinboard/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/Ab in /home/webmaster/pinboard/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php on line 174
Add handling of this situation.
console aggregate
removing old record from pinboard tables.config/parameters.yml
with life time of records.I received empty dashboard with message "Whoops, looks like something went wrong" after some time (service works from 30 minutes to 1 day).
How can i fix this?
enable debug: Whoops, looks like something went wrong.
2/2 Twig_Error_Runtime: An exception has been thrown during the rendering of a template ("Parameter "serverName" for route "server" must match "[^/]++" ("" given) to generate a corresponding URL.") in "_menu.html.twig" at line 10.
in /mnt/web/pinboard/vendor/twig/twig/lib/Twig/Template.php line 291 .....
1/2 InvalidParameterException: Parameter "serverName" for route "server" must match "[^/]++" ("" given) to generate a corresponding URL.
in /mnt/web/pinboard/vendor/symfony/routing/Symfony/Component/Routing/Generator/UrlGenerator.php line 167 .....
i`m receiving error when run : php composer.phar install
Loading composer repositories with package information
Installing dependencies (including require-dev)
Your requirements could not be resolved to an installable set of packages.
Problem 1
- Installation request for symfony/security dev-master -> satisfiable by symfony/security[dev-master].
- symfony/security dev-master requires symfony/http-foundation ~2.4 -> no matching package found.
Potential causes:
Read http://getcomposer.org/doc/articles/troubleshooting.md for further common problems.
Please help me
config/parameters.yml
for records count on page in pagination.I did all steps before like on documentation but receive this error then:
./console init
Creating database tables...
[PDOException]
SQLSTATE[HY000] [2002] No such file or directory
init [--no-tables] [--no-indexes] [--no-crontab]
I checked my db settings from console (mysql -u pinboard -p -h 127.0.0.1) and they woking fine
Requirements are in process.
/var/www/pinboard/src/Pinboard/Command/../../../console aggregate
[PDOException]
SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1
aggregate
Every 5 seconds page Live throw ajax requests fresh data from server and adds them to top of table. Table size grows and after a time can make page not responding.
If agregation function not finished in 5 minutes interval. New instance will be run by cron which will overload db with heavy commands running in parallel. And possible will not have much sence. Possible need to add some lock to avoid this.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.