CodeCanyon

MySQL Server Load Monitor

  • Bought between 10 and 49 items
  • Exclusive Author
  • Has been a member for 3-4 years

Wow this sounds great. Would it function on a shared host?

maringtr

You shouldn’t have any problems in running the app on a shared host. In fact the demo itself is running on one: http://www.marinbezhanov.com/monitor/

  • United States
  • Has been a member for 2-3 years
  • Exclusive Author
  • Sold between 100 and 1 000 dollars
  • Bought between 100 and 499 items
  • Referred between 1 and 9 users

FYI , this is the server response. I am interested in the script but I would like to see it without errors first.


Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘username’@’localhost’ (using password: YES ) in /home/marinbez/public_html/monitor/load.php on line 27

Warning: mysql_query() [function.mysql-query]: Access denied for user ‘marinbez’@’localhost’ (using password: NO) in /home/marinbez/public_html/monitor/load.php on line 30

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/marinbez/public_html/monitor/load.php on line 30

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/marinbez/public_html/monitor/load.php on line 30

Warning: mysql_query() [function.mysql-query]: Access denied for user ‘marinbez’@’localhost’ (using password: NO) in /home/marinbez/public_html/monitor/load.php on line 31

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/marinbez/public_html/monitor/load.php on line 31

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/marinbez/public_html/monitor/load.php on line 31

Warning: mysql_query() [function.mysql-query]: Access denied for user ‘marinbez’@’localhost’ (using password: NO) in /home/marinbez/public_html/monitor/load.php on line 32

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/marinbez/public_html/monitor/load.php on line 32

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/marinbez/public_html/monitor/load.php on line 32

Warning: Division by zero in /home/marinbez/public_html/monitor/load.php on line 33

Warning: mysql_query() [function.mysql-query]: Access denied for user ‘marinbez’@’localhost’ (using password: NO) in /home/marinbez/public_html/monitor/load.php on line 36

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/marinbez/public_html/monitor/load.php on line 36

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/marinbez/public_html/monitor/load.php on line 36

Warning: mysql_query() [function.mysql-query]: Access denied for user ‘marinbez’@’localhost’ (using password: NO) in /home/marinbez/public_html/monitor/load.php on line 37

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/marinbez/public_html/monitor/load.php on line 37

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/marinbez/public_html/monitor/load.php on line 37

Warning: Division by zero in /home/marinbez/public_html/monitor/load.php on line 38

Warning: mysql_query() [function.mysql-query]: Access denied for user ‘marinbez’@’localhost’ (using password: NO) in /home/marinbez/public_html/monitor/load.php on line 41

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/marinbez/public_html/monitor/load.php on line 41

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/marinbez/public_html/monitor/load.php on line 41

Warning: mysql_query() [function.mysql-query]: Access denied for user ‘marinbez’@’localhost’ (using password: NO) in /home/marinbez/public_html/monitor/load.php on line 42

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/marinbez/public_html/monitor/load.php on line 42

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/marinbez/public_html/monitor/load.php on line 42

Warning: Division by zero in /home/marinbez/public_html/monitor/load.php on line 43

maringtr

Hello secoxxx,

Where did you see these errors? At http://www.marinbezhanov.com/monitor/ ? It looks like the database server on my host was down at that time, but everything seems to be working normally now and I can interact with the demo without a problem.

Let me know if you require any further assistance with this.

Marin

  • Bought between 10 and 49 items
  • Exclusive Author
  • Has been a member for 3-4 years

Thanks for your quick reply. That is impressive then.

  • France
  • Bought between 10 and 49 items
  • Has been a member for 3-4 years

possible to use this script with a personal graph ?

I bet data are saved in database ?

maringtr

All data is saved into a CSV file. The CSV data is then used by the charting class to draw the graph. You can customize the output in many ways, although I haven’t described that in detail in the documentation. If you tell me more on what you’re trying to achieve, I’ll be probably able to help you.

Marin

  • Bought between 50 and 99 items
  • Has been a member for 3-4 years

I don’t think this thing is working. dreamybids.com/monitor/

maringtr

It looks like you are experiencing file permission issues on your hosting account. Here is the error causing the issue:

Warning: fopen(pChart/data.csv): failed to open stream: Permission denied in /var/www/vhosts/dreamybids.com/httpdocs/monitor/load.php on line 54

In other words, the file “load.php” cannot write to “pChart/data.csv”. Try doing a CHMOD 775 or 777 on “pChart/data.csv”. If that doesn’t work, I’d suggest contacting your hosting company’s support team, who should be able to assist you further.

  • Bought between 50 and 99 items
  • Has been a member for 3-4 years

Thanks for the prompt response but still not working.

maringtr

It looks like you’ve managed to solve the original issue with the non-writable CSV file. There’s a new error now and here’s what it says:

Warning: imagepng(): Unable to open ‘pChart/load.png’ for writing: Permission denied in /var/www/vhosts/dreamybids.com/httpdocs/monitor/pChart/pChart/pChart.class on line 3183

So it’s the same issue, but different file: ‘pChart/load.png’ needs to be writable as well. Hope that helps!

  • Bought between 50 and 99 items
  • Has been a member for 3-4 years

We are up and running. thanks

maringtr

Happy to hear that, if you need any further assistance – please do not hesitate to ask!

  • Bought between 10 and 49 items
  • Has been a member for 0-1 years

can i use it on windows 2008r2?

maringtr

Yes, the OS doesn’t matter, as it’s a PHP application – any properly configured web server with PHP installed supports it.

  • Bought between 100 and 499 items
  • Has been a member for 3-4 years
  • United States

If my mysql database is on the same server that hosts website content, would these graphs differ from the server load that WHM / cPanel reports, or is this script only useful if your mysql database sits on a separate server?

maringtr

It is useful in both scenarios. Graphs may differ from what WHM / cPanel reports in some cases.

  • Bought between 1 and 9 items
  • Has been a member for 0-1 years

This script has the login form

maringtr

It doesn’t have a login form, but I can add one if you decide to purchase it. It was originally supposed to be integrated into larger scripts that provide login functionality – hence the absence of a login form.

  • Bought between 1 and 9 items
  • Has been a member for 0-1 years

Is it possible to do something with the load so as not to overload the server CPU to 100%


by
by
by
by
by