GriefCode Posted February 25, 2017 Share Posted February 25, 2017 Server Console Simple Application to observe multiply servers and bigger infrastructures. The application was basically written that I can keep track of all my servers, without having different pages for monitoring, backups and so on. Features: Frequent checks if a server is online/offline and also getting some information, such as: CPU Usage CPU Load RAM Usage (free/total/percentage) DISK Usage (free/total/percentage) Uptime Block/Widget that users can see the status of the servers as well Dedicated Front Page to observe the status Maintenance mode for servers As this is only an early development a lot things are planned: Graphs displaying status/values over the time More detailed stats Dedicated status page Notifications on downtimes / uptimes Backup system This applications requires the PHP-cURL extension! This applications requires that this script is installed on any client server and is reachable by the forum server. The whole application can be found open sourced on Github: https://github.com/Grief-Code/IPS-Server-Console I'm already working on a minor update fixing some stuff: Widget server selection was totally messed. Add Server empty ips displayed a validation error Update will be added later today. The whole system is currently still in Beta, if you find any bugs please report them, I will commonly fix them within one day. Greetings Link to comment
Dean Spencer Posted February 25, 2017 Share Posted February 25, 2017 where would I find this URL ? http://prntscr.com/edbcd5 Link to comment
GriefCode Posted February 25, 2017 Author Share Posted February 25, 2017 Hey @Dean Spencer, You need to place this file on a client server and place the url to the script there. You can also observe your own server with this url: Quote http://yourdomain.com/applications/serverconsole/serverCheck.php Greetings Link to comment
Orlando Delcid Posted February 26, 2017 Share Posted February 26, 2017 Add These Features As It Progresses: - More Widgets - Better Stats (i mean like visual stats , numeric load looks good but what if there was a meter showing value is good, bad etc) - Weekly reports by email - Convenience of setting into maintenance mode right from the page by adding a button next to status (restricted to certain member groups such as "mayors" [mayors are like super moderators but are a separate member group] in my case) ----> make this a higher priority than others since this is a big convenience and my mayors work under me, so they cant be administrators and access AdminCP besides they dont know how to use IPB - Ajax Refresh For Values(Refresh Values Through AJAX) - Better Widget Presentation (No Offense But Current Widget Looks Boring and Unattractive If You See Through An Eye Of Customer (Non-Technical Person)) Link to comment
shyest Posted February 27, 2017 Share Posted February 27, 2017 So I like the concept of this application, however, getting it to work properly on v4.1.18.2 does not work. I upload the tar file, set my servers up and nothing happens on the front page. The servers say that they were last updated 1969 or something to that nature. So I ventured into the tasks and noticed that the task for it has not run so when I run it comes with this error. SELECT id, last_status_history FROM `serverconsole_servers` WHERE check_server=1 AND in_maintenance == 0 IPS\Db\Exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= 0' at line 1 (1064) #0 /var/www/html/system/Db/Select.php(356): IPS\_Db->preparedQuery('/*IPS\\servercon...', Array, true) #1 /var/www/html/system/Db/Select.php(418): IPS\Db\_Select->runQuery() #2 /var/www/html/applications/serverconsole/tasks/checkservers.php(51): IPS\Db\_Select->rewind() #3 /var/www/html/system/Task/Task.php(249): IPS\serverconsole\tasks\_checkservers->execute() #4 /var/www/html/applications/core/modules/admin/settings/advanced.php(550): IPS\_Task->run() #5 [internal function]: IPS\core\modules\admin\settings\_advanced->runTask() #6 /var/www/html/system/Dispatcher/Controller.php(85): call_user_func(Array) #7 /var/www/html/applications/core/modules/admin/settings/advanced.php(35): IPS\Dispatcher\_Controller->execute() #8 /var/www/html/system/Dispatcher/Dispatcher.php(129): IPS\core\modules\admin\settings\_advanced->execute() #9 /var/www/html/admin/index.php(14): IPS\_Dispatcher->run() #10 {main} Not sure what this all means so please help. Link to comment
GriefCode Posted February 27, 2017 Author Share Posted February 27, 2017 6 minutes ago, shyest said: So I like the concept of this application, however, getting it to work properly on v4.1.18.2 does not work. I upload the tar file, set my servers up and nothing happens on the front page. The servers say that they were last updated 1969 or something to that nature. So I ventured into the tasks and noticed that the task for it has not run so when I run it comes with this error. SELECT id, last_status_history FROM `serverconsole_servers` WHERE check_server=1 AND in_maintenance == 0 IPS\Db\Exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= 0' at line 1 (1064) #0 /var/www/html/system/Db/Select.php(356): IPS\_Db->preparedQuery('/*IPS\\servercon...', Array, true) #1 /var/www/html/system/Db/Select.php(418): IPS\Db\_Select->runQuery() #2 /var/www/html/applications/serverconsole/tasks/checkservers.php(51): IPS\Db\_Select->rewind() #3 /var/www/html/system/Task/Task.php(249): IPS\serverconsole\tasks\_checkservers->execute() #4 /var/www/html/applications/core/modules/admin/settings/advanced.php(550): IPS\_Task->run() #5 [internal function]: IPS\core\modules\admin\settings\_advanced->runTask() #6 /var/www/html/system/Dispatcher/Controller.php(85): call_user_func(Array) #7 /var/www/html/applications/core/modules/admin/settings/advanced.php(35): IPS\Dispatcher\_Controller->execute() #8 /var/www/html/system/Dispatcher/Dispatcher.php(129): IPS\core\modules\admin\settings\_advanced->execute() #9 /var/www/html/admin/index.php(14): IPS\_Dispatcher->run() #10 {main} Not sure what this all means so please Hey @shyest, thanks for your feedback in first place. I think I have made a small mistake, there is a syntax error, I will shortly upgrade the application and notify you on that, then please try again and let me know if all is working. Regards Link to comment
shyest Posted February 27, 2017 Share Posted February 27, 2017 Just now, GriefCode said: Hey @shyest, thanks for your feedback in first place. I think I have made a small mistake, there is a syntax failure which somehow seems to be allowed on mysql but not on mariadb, I will shortly upgrade the application and notify you on that, then please try again and let me know if all is working. Regards @GriefCode Thank you! Link to comment
GriefCode Posted February 27, 2017 Author Share Posted February 27, 2017 Just now, shyest said: @GriefCode Thank you! I'm sorry, I need to correct me, its generally a syntax error. 4 minutes ago, shyest said: @GriefCode Thank you! The application has been updated. Please upgrade your version and let me know if you have still issues. Regards Link to comment
shyest Posted February 27, 2017 Share Posted February 27, 2017 @GriefCode I am sorry to say that yes its different, however, I get this error now: INSERT INTO `serverconsole_server_check_history` ( `serverconsole_servers_id`, `cpu_load_now`, `cpu_load_5min`, `cpu_load_15min`, `cpu_usage`, `ram_used`, `ram_total`, `ram_percentage`, `diskspace_free`, `diskspace_total`, `diskspace_percentage`, `uptime`, `status` ) VALUES ( 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online' ) IPS\Db\Exception: Column 'cpu_load_now' cannot be null (1048) #0 /var/www/html/system/Db/Db.php(808): IPS\_Db->preparedQuery('/*IPS\\servercon...', Array) #1 /var/www/html/system/Patterns/ActiveRecord.php(458): IPS\_Db->insert('serverconsole_s...', Array) #2 /var/www/html/applications/serverconsole/tasks/checkservers.php(97): IPS\Patterns\_ActiveRecord->save() #3 /var/www/html/system/Task/Task.php(249): IPS\serverconsole\tasks\_checkservers->execute() #4 /var/www/html/applications/core/modules/admin/settings/advanced.php(550): IPS\_Task->run() #5 [internal function]: IPS\core\modules\admin\settings\_advanced->runTask() #6 /var/www/html/system/Dispatcher/Controller.php(85): call_user_func(Array) #7 /var/www/html/applications/core/modules/admin/settings/advanced.php(35): IPS\Dispatcher\_Controller->execute() #8 /var/www/html/system/Dispatcher/Dispatcher.php(129): IPS\core\modules\admin\settings\_advanced->execute() #9 /var/www/html/admin/index.php(14): IPS\_Dispatcher->run() #10 {main} Link to comment
GriefCode Posted February 27, 2017 Author Share Posted February 27, 2017 Can you quickly send me in a pm the url to the checkServer.php on the client server? Link to comment
shyest Posted February 27, 2017 Share Posted February 27, 2017 @GriefCode Sent it to you. Link to comment
GriefCode Posted February 27, 2017 Author Share Posted February 27, 2017 I've updated the application again. There was an issue when the response was not as expected. I've added additional checks for the response code, if it is anything else then a '200' HTTP Response Code, i'm throwing a runtime exception which is logged to the system log. Greetings Link to comment
shyest Posted February 27, 2017 Share Posted February 27, 2017 @GriefCode Thanks for what you did. It is now working. Link to comment
icedream Posted March 4, 2017 Share Posted March 4, 2017 Hi, could you check network usage? Link to comment
GriefCode Posted March 4, 2017 Author Share Posted March 4, 2017 6 hours ago, icedream said: Hi, could you check network usage? Will be added soon, as I had the same idea observing the traffic as well. I only ned to decide what should be observed as traffic. Link to comment
Dorian Wawrzonkowski Posted March 4, 2017 Share Posted March 4, 2017 Hey man. Is there any way you could do the serverCheck.php for Windows? I would greatly appreciate it. Link to comment
GriefCode Posted March 4, 2017 Author Share Posted March 4, 2017 Just now, Dorian Wawrzonkowski said: Hey man. Is there any way you could do the serverCheck.php for Windows? I would greatly appreciate it. As I've stated, it's not yet supported but I can try to create support for windows. It will be included into the next update then. Greetings Link to comment
Dorian Wawrzonkowski Posted March 4, 2017 Share Posted March 4, 2017 Thank you @GriefCode and I'm looking forward for the next update! Link to comment
GriefCode Posted March 4, 2017 Author Share Posted March 4, 2017 Just now, Dorian Wawrzonkowski said: Thank you @GriefCode and I'm looking forward for the next update! It will take a bit time, sadly, we are close to a release at my real work, when that is done, I will have time for the update. I'm expecting the update around the next weekend, maybe. Link to comment
Natea Posted March 19, 2017 Share Posted March 19, 2017 Doesn't work for me, I add the servers but script not check anything. I see this logs in my acp: My servers (all unknown): And status page: I use IPS 4.1.19, php 7.0.17 and mariadb Link to comment
GriefCode Posted March 19, 2017 Author Share Posted March 19, 2017 Hey, do you have the latest version? This was an issue in some of the previous versions. Greetings Link to comment
Natea Posted March 19, 2017 Share Posted March 19, 2017 39 minutes ago, GriefCode said: Hey, do you have the latest version? This was an issue in some of the previous versions. Greetings Yes, I have the latest updated yesterday. Link to comment
GriefCode Posted March 19, 2017 Author Share Posted March 19, 2017 Okay, can you pm me the link to your serverCheck.php files on the server? So I can investigate furthere, thanks! Link to comment
DannyPhantom Posted April 2, 2017 Share Posted April 2, 2017 )), '', 'Test', 'all' ) IPS\Db\Exception: Field 'tolerance_counter' doesn't have a default value (1364) #0 D:\ipboard\system\Db\Db.php(808): IPS\_Db->preparedQuery('/*IPS\\servercon...', Array) #1 D:\ipboard\system\Patterns\ActiveRecord.php(460): IPS\_Db->insert('serverconsole_s...', Array) #2 D:\ipboard\applications\serverconsole\modules\admin\general\servers.php(188): IPS\Patterns\_ActiveRecord->save() #3 D:\ipboard\system\Dispatcher\Controller.php(86): IPS\serverconsole\modules\admin\general\_servers->perform() #4 D:\ipboard\applications\serverconsole\modules\admin\general\servers.php(26): IPS\Dispatcher\_Controller->execute() #5 D:\ipboard\system\Dispatcher\Dispatcher.php(129): IPS\serverconsole\modules\admin\general\_servers->execute() #6 D:\ipboard\admin\index.php(14): IPS\_Dispatcher->run() #7 {main} I'm getting this error during setup a host. This I have solved by removing STRICT_TRANS_TABLES from MySQL settings. We're running over ISS, I will take a look if I will able to get all working, it would be nice if this could be happen Link to comment
GriefCode Posted April 4, 2017 Author Share Posted April 4, 2017 On 2.4.2017 at 9:40 AM, DannyPhantom said: )), '', 'Test', 'all' ) IPS\Db\Exception: Field 'tolerance_counter' doesn't have a default value (1364) #0 D:\ipboard\system\Db\Db.php(808): IPS\_Db->preparedQuery('/*IPS\\servercon...', Array) #1 D:\ipboard\system\Patterns\ActiveRecord.php(460): IPS\_Db->insert('serverconsole_s...', Array) #2 D:\ipboard\applications\serverconsole\modules\admin\general\servers.php(188): IPS\Patterns\_ActiveRecord->save() #3 D:\ipboard\system\Dispatcher\Controller.php(86): IPS\serverconsole\modules\admin\general\_servers->perform() #4 D:\ipboard\applications\serverconsole\modules\admin\general\servers.php(26): IPS\Dispatcher\_Controller->execute() #5 D:\ipboard\system\Dispatcher\Dispatcher.php(129): IPS\serverconsole\modules\admin\general\_servers->execute() #6 D:\ipboard\admin\index.php(14): IPS\_Dispatcher->run() #7 {main} I'm getting this error during setup a host. This I have solved by removing STRICT_TRANS_TABLES from MySQL settings. We're running over ISS, I will take a look if I will able to get all working, it would be nice if this could be happen Interesting, I could simply add a default value over the column, wouldn't matter anyway. Glad you found a solution for the issue. Sorry I wasn't around at that time. Greetings Link to comment
Recommended Posts
Archived
This topic is now archived and is closed to further replies.