My Idlers - Self hosted web app for your servers, shared hosting and domains information

Asim

@corbpie said: Meaning tiles like it is now and list being a table?

yes, precisely

corbpie

@Asim said:

@corbpie said: Meaning tiles like it is now and list being a table?

yes, precisely

I can eventually but tables on mobile devices wouldn’t go to well.

webcraft

@Asim said:

@webcraft said: Nice project to create a more up to date version for server monitoring but for now I still prefer https://github.com/seikan/NodeList which just looks nicer.

Awesome app, requires absolutely no database. I am still using it. Few issues are (as far as I have noticed)

1) No way to specify IPv6. The IP field isnt long enough to save an IPv6 address even in the short form
2) Works only on PHP 5.6. PHP 7.x+ gives "Internal Server Error" on all pages due to deprecated functions
3) No way to export your data so once its there (and stored in json files), you cannot export them as CSV etc

1) yes, this is indeed an issue but can be fixed by manually editing the view

2) only two brackets need to be changed, then it's working again. It can be fixed by manually editing the includes/function.php#L27 (curly to square brackets).

3) https://json-csv.com/ not sure if the result is what you need though..
it requires quite a bit of extra work but all in all my fave panel for now, still.

corbpie

1.2 changes:

Link

If you have version 1.1 or less installed please run update.sql

Added table view type (use switcher icon to change to this view)
Added auto get IPv4/IPv6 based on hostname (Click icon at hostname input)
Added up/down status (Click OS icon)
Updated the order by table for better formatting
Removed unused buttons from the CSS
Updated Minor style changes
Updated update.sql for pre-existing installations only.
Updated when type DEDI selected "is_dedi" will be toggled
Updated IPv4 no longer required field
Fixed no location and/or provider causing uneven cards
Updated delete labels
Updated domain terms to be annual and longer only
Fixed error when all speed tests are "busy"
Updated my_idlers.sql for changes

New table view:

alento

Very nice, thank you for this @corbpie

rcy026

I see references to "check_up.php", but there is no such file?

Falzo

awesome, thanks for all the efforts you put into this @corbpie !

Hirose

Wow, this is awesome. Installed it this morning and started adding servers. Really love the due date feature so I know when to renew/cancel.

Thank you so much @corbpie

Asim

@corbpie thanks for v1.2

three issues I have noticed so far

• get_ip.php file is missing in the release (https://github.com/cp6/my-idlers/releases/tag/1.2) and in the repo as well
• the list layout is great but as soon as the page is refreshed, it returns back to tile mode (use cookies OR a URL placeholder for the preference e.g. https://idlers/#tile or https://idlers/#list
• the update.sql file should have some comment to identify which release they database changes were added in, I upgraded from v1.1 to v1.2 so I had to check all queries and run them one by one OR have a filder for "schema" and have all sql updates in them as "update_1.1.sql" etc

waiting for the get_ip.php file

corbpie

@rcy026 said:I see references to "check_up.php", but there is no such file?

@Asim said: get_ip.php file is missing in the release (https://github.com/cp6/my-idlers/releases/tag/1.2) and in the repo as well

Sorry about that. I noticed it and did a fix however when re-doing the release it didn't include it.

tldr: get_ip.php & check_up.php should be calls.php in scipts.min.js

@Asim said: the update.sql file should have some comment to identify which release they database changes were added in, I upgraded from v1.1 to v1.2 so I had to check all queries and run them one by one OR have a filder for "schema" and have all sql updates in them as "update_1.1.sql" etc

Good idea, for me i wasn't running into issues with the alter table command even if it had been run before. I will name the update files to include their version.

@Asim said: the list layout is great but as soon as the page is refreshed, it returns back to tile mode (use cookies OR a URL placeholder for the preference e.g. https://idlers/#tile or https://idlers/#list

Was something i had thought about and will look at adding this

Asim

@corbpie I found another issue which I have logged with possible solution
https://github.com/cp6/my-idlers/issues/9

flips

@webcraft said:

@Asim said:

@webcraft said: Nice project to create a more up to date version for server monitoring but for now I still prefer https://github.com/seikan/NodeList which just looks nicer.

Awesome app, requires absolutely no database. I am still using it. Few issues are (as far as I have noticed)

1) No way to specify IPv6. The IP field isnt long enough to save an IPv6 address even in the short form
2) Works only on PHP 5.6. PHP 7.x+ gives "Internal Server Error" on all pages due to deprecated functions
3) No way to export your data so once its there (and stored in json files), you cannot export them as CSV etc

1) yes, this is indeed an issue but can be fixed by manually editing the view

2) only two brackets need to be changed, then it's working again. It can be fixed by manually editing the includes/function.php#L27 (curly to square brackets).

3) https://json-csv.com/ not sure if the result is what you need though..
it requires quite a bit of extra work but all in all my fave panel for now, still.

Thanks for this. Seems to work well. Haven't looked into changing the view for IPv6.
Should probably send a pull request for the brackets and a view change ...
I like the fact that it has user authentication built in.

I also tried @corbpie's Idlers (v1.2), but had some issues with getting this to work.
Well, if I add VPSes without YABS output it works, but with YABS, it fails, error something like this (trimmed datestamps etc):

[STDERR] PHP Notice:  Undefined variable: gb_s in /path../public_html/vps/class.php on line 3236
[STDERR] PHP Notice:  Undefined index:  in /path../public_html/vps/class.php on line 3236
[STDERR] PHP Fatal error:  Uncaught TypeError: Argument 1 passed to helperFunctions::intValue() must be of the type string, null given, called in /path../public_html/vps/class.php on line 3236 and defined in /path../public_html/vps/class.php:426
Stack trace:
#0 /path../public_html/vps/class.php(3236): helperFunctions->intValue(NULL)
#1 /path../public_html/vps/calls.php(57): itemInsert->insertYabsData()
#2 {main}
  thrown in /path../public_html/vps/class.php on line 426

Maybe it tries hard to parse the YABS and fails. (My yabs are the full -9 version, with everything, both GB4 and GB5.)
I guess I should do some cleanup in the yabs dir.

Here I added the first without YABS, then added the second with YABS. After that, I can't add or do anything, anymore. (Same error repeated in log.)

2021-01-31 14:10:00.072665 [NOTICE] [3768263] [1.2.3.4:59412:HTTP2-15#APVH_www.my.domain.tld:443] [STDERR] PHP Fatal error: Uncaught TypeError: Argument 1 passed to helperFunctions::mhzToGhz() must be of the type string, null given, called in /path../public_html/vps/class.php on line 951 and defined in /path../public_html/vps/class.php:275

corbpie

@flips either the standard YABs command or the shortened network test (-r) are compatible

flips

@corbpie said:
@flips either the standard YABs command or the shortened network test (-r) are compatible

Cool, should I just empty DB, or remove the last entry?

Also, can I just removed the multiple text files in the yabs dir?
(Are they used/referenced after import, or just while importing?)

flips

Huh, I seem to have quite a few typos and bad grammar these days...
Anyways, switching to yabs without GB4 worked. (Some older full yabs with one less network location failed.)

corbpie

@flips Yea you will just have to remove the DB entries for that corrupt id. Removing the files in yabs/ is fine they are just for viewing within the modal.

Im going to implement better error handling in the YABs inserter to prevent wrong YABs types/older YABs corrupting the queries.

Asim

@corbpie lets put in a cleanup / housekeeping method (cron may be) to clean unnecessary yabs data + optimize tables etc

corbpie

@Asim said:
@corbpie lets put in a cleanup / housekeeping method (cron may be) to clean unnecessary yabs data + optimize tables etc

No sure there is anything to clean up, YABs output saving can be turned off. The only thing that maybe might need it is pre-existing installations that have loose rows (disk + net speed & pricing) not belonging to any server-id.

I just did better handling for the YABs inserter then which means if the YABs output isn't correct then nothing will be inserted + saved which honestly was need from day 1.

Asim

Im user from day1, so there are more yabs in directories than there are servers, lol
I need housekeeping

I'll create something quickly and then send a PR on GitHub

corbpie

I recently re-made this project onto the Laravel framework:

This will simplify development and most of the features from the original build are present in V2.

Using Laravel brings an API endpoint and the possibility to show servers publicly with certain parameters removed.

2.0 changes:

Unfortunately you cannot migrate your current install to the new 2.0 version

• Laravel framework (version 9).
• Breeze authentication.
• API GET for any of the CRUD data.
• Labels (titles/desc) CRUD.
• Misc services CRUD.
• DNS CRUD.
• Ip address CRUD.
• Reseller hosting.
• Added Operating systems to DB, Deleting and creating them now possible.
• Make servers displayable public with config options to hide certain values.
• Vue JS used where possible.
• Datatables used on large tables (Locations, labels, and providers).
• Added caching for home page and servers

Seeking a project sponsor

I am seeking at least a 1GB ram, Nvme VPS to host a demo installation of My idlers. In return you will get your provider as the default selection in the create forms, as well as in screenshots.

Abdullah

PM'ed @corbpie

nyamenk

Hi thanks for awesome project, but after signup on ver 2 I got error Undefined array key 0

Janevski

IaaS - Idle as a Service
You just pay people to run fully managed idle boxes for you.

rcy026

Does anyone know of a project like this without a shitload of dependencies? I love the idea but I just broke 2 webservers trying to install version 2 since composer and php8 does not play nice at all with the rest of my sites. And why does it need mysql, I know I have a lot of idlers but not that many? Version 1 was great but had a few really annoying bugs, and since version 2 is out I guess there are no hopes of them ever getting fixed.

Astro

I think adding uptime monitor would also be great

ehab

@Astro said:
I think adding uptime monitor would also be great

i am really considering adding this.
if i get a sponsor it will make me more interested.

webcraft

@rcy026 said:
And why does it need mysql, I know I have a lot of idlers but not that many?

You can use any PDO compatible database like sqlite or pgsql.

rcy026

@webcraft said:

@rcy026 said:
And why does it need mysql, I know I have a lot of idlers but not that many?

You can use any PDO compatible database like sqlite or pgsql.

Wow, talk about missing the point.

sh97

@iandk said:
I'm working on something similar

It's based on VueJS, a vanilla PHP backend and using simple json files for storage instead of a database.

Really liked the UI! Any info on this?

beanman109

@rcy026 said: Does anyone know of a project like this without a shitload of dependencies? I love the idea but I just broke 2 webservers trying to install version 2 since composer and php8 does not play nice at all with the rest of my sites. And why does it need mysql, I know I have a lot of idlers but not that many? Version 1 was great but had a few really annoying bugs, and since version 2 is out I guess there are no hopes of them ever getting fixed.

+1 for something like this without shitty dependencies

davi

Or someone can share proper docker commands with sqllite db. Tried https://github.com/cp6/my-idlers/issues/71 but it does not worked

beanman109

@davi said: Or someone can share proper docker commands with sqllite db. Tried https://github.com/cp6/my-idlers/issues/71 but it does not worked

I struggled to get this working even with MariaDB so I doubt sqlite & it's un-documented-ness would be any better.

ralf

@beanman109 said:

@davi said: Or someone can share proper docker commands with sqllite db. Tried https://github.com/cp6/my-idlers/issues/71 but it does not worked

I struggled to get this working even with MariaDB so I doubt sqlite & it's un-documented-ness would be any better.

Actually, I suspect the complete opposite. A SQLite database is just a file which can be located wherever you want on the filesystem. There are bindings for it for almost every language, and deployment is just copying any default DB into the right place (otherwise create the necessary tables on startup if they don't already exist).

alento

Honestly, I am running this, I mean idling this in PikaPods and it works great for $1 a month, with no fuss. I am loving it! I am actually just now populating it with data after 7 months.

But I have a question and comment for the author @corbpie that's you eh?

How do I actually add a YABS report?

I notice that when I add a new provider or location to the list, they simply just go to the bottom of the list ... how difficult would it be to re-alphabetize the lists?

beanman109

@alento said: I mean idling this in PikaPods and it works great for $1 a month

I was going to set this up in a PikaPod but couldn't justify the $1 a month when I have idlers idling as it is.

m4nu

Just did an ad-hoc update on PikaPods to fix an issue with adding YABs benchmarks raised by @alento . Happy to have dedicated users, who push for improvements.

alento

@alento said: How do I actually add a YABS report?

I discovered that there was a known bug which was already fixed in a pull request. PikaPods updated and all works well now it seems. Thanks @m4nu for the amazing support!

sh97

Sorry for the Necro!

Does anybody have a working docker compose which includes the SQL DB as well?

I tried a lot, but not able to run this using docker/docker compose.

Wonder_Woman

@sh97 said:
Sorry for the Necro!

Does anybody have a working docker compose which includes the SQL DB as well?

I tried a lot, but not able to run this using docker/docker compose.

Hey @sh97, I've used this one from one of the issues on GitHub:

services:
  app:
    container_name: idlers-app
    image: ghcr.io/cp6/my-idlers:latest
    restart: always
    ports:
      - 8000:8000
    environment:
      DB_HOST: db
      DB_DATABASE: db
      DB_USERNAME: user
      DB_PASSWORD: pass

  db:
    image: mariadb:latest
    container_name: idlers-db
    restart: always
    command: --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
    environment:
      MYSQL_ROOT_PASSWORD: passRoot
      MYSQL_USER: user
      MYSQL_PASSWORD: pass
      MYSQL_DATABASE: db
    volumes:
      - ./db:/var/lib/mysql

Don't forget to run the database priming command after starting for the first time, or you'll run into other issues.

It's something like
docker exec ... php artisan migrate:fresh --seed --force

but with the name of the container

DrNutella

This doesn’t just have to be idle servers…? I mean technically you could use it to track all of your servers whether they’re idle or not from what I can see.

Right?

Wonder_Woman

@huntercop said:
This doesn’t just have to be idle servers…? I mean technically you could use it to track all of your servers whether they’re idle or not from what I can see.

Right?

That's correct!

DrNutella

Would be good to see this grow and integrate with other solutions.

corbpie

@huntercop said:
Would be good to see this grow and integrate with other solutions.

If you wanted something that actually has interaction with the servers https://lowendspirit.com/discussion/6660/servyrun-self-hosted-web-app-for-ssh-sftp-and-db-interaction

sh97

@Wonder_Woman thanks a lot for that - got it working now

@corbpie - Dont know if this was discussed before, but is there a way to add custom values for providers and locations? For eg, some providers like Crunchbits, Hivelocity are missing... I'll look into creating a PR for some providers, but a custom insert would be nice.

Wonder_Woman

@sh97 said:
@Wonder_Woman thanks a lot for that - got it working now

No problem, glad I could help!

@corbpie - Dont know if this was discussed before, but is there a way to add custom values for providers and locations? For eg, some providers like Crunchbits, Hivelocity are missing... I'll look into creating a PR for some providers, but a custom insert would be nice.

Try going to the "More" dropdown menu, there should be an option for "Providers". It's also at /providers. You should be able to make adjustments to the provider list you've got there

EDIT: Also, a word of warning: Unfun things seem to happen if you accidentally enter things with identical fields. Like if you add two providers with the same name or two servers with the same IP. It doesn't stop you from doing it

localhost

@Wonder_Woman said:

EDIT: Also, a word of warning: Unfun things seem to happen if you accidentally enter things with identical fields. Like if you add two providers with the same name or two servers with the same IP. It doesn't stop you from doing it

That's a feature. Not a bug. Imagine a common IP across all your servers.

sh97

@Wonder_Woman said:

@sh97 said:
@Wonder_Woman thanks a lot for that - got it working now

No problem, glad I could help!

@corbpie - Dont know if this was discussed before, but is there a way to add custom values for providers and locations? For eg, some providers like Crunchbits, Hivelocity are missing... I'll look into creating a PR for some providers, but a custom insert would be nice.

Try going to the "More" dropdown menu, there should be an option for "Providers". It's also at /providers. You should be able to make adjustments to the provider list you've got there

EDIT: Also, a word of warning: Unfun things seem to happen if you accidentally enter things with identical fields. Like if you add two providers with the same name or two servers with the same IP. It doesn't stop you from doing it

Thank you again. I was at work, so just had a quick glance, did not notice the option to create providers. Also thank you for the heads-up about the "features" 😉

Wonder_Woman

@localhost said:

@Wonder_Woman said:

EDIT: Also, a word of warning: Unfun things seem to happen if you accidentally enter things with identical fields. Like if you add two providers with the same name or two servers with the same IP. It doesn't stop you from doing it

That's a feature. Not a bug. Imagine a common IP across all your servers.

I understand what you're saying, but it should prevent you from doing it rather than what it currently does. Additionally, it's not impossible to have several servers with the same IPv4, there are plenty of NAT services available.

@sh97 said:

@Wonder_Woman said:

@sh97 said:
@Wonder_Woman thanks a lot for that - got it working now

No problem, glad I could help!

@corbpie - Dont know if this was discussed before, but is there a way to add custom values for providers and locations? For eg, some providers like Crunchbits, Hivelocity are missing... I'll look into creating a PR for some providers, but a custom insert would be nice.

Try going to the "More" dropdown menu, there should be an option for "Providers". It's also at /providers. You should be able to make adjustments to the provider list you've got there

EDIT: Also, a word of warning: Unfun things seem to happen if you accidentally enter things with identical fields. Like if you add two providers with the same name or two servers with the same IP. It doesn't stop you from doing it

Thank you again. I was at work, so just had a quick glance, did not notice the option to create providers. Also thank you for the heads-up about the "features" 😉

You're welcome!