Posts made by Raymond Bell

@ch3i And all are missing from fog Host Search

mysql> SELECT hostName 
    -> FROM hosts 
    -> WHERE hostID NOT IN ( SELECT hmHostID FROM hostMAC );
+---------------+
| hostName      |
+---------------+
| es-54-01      |
| es-33-t       |
| jh-18-t2      |
| es-53-04      |
| es-53-01      |
| es-53-02      |
| es-53-06      |
| es-53-09      |
| es-53-08      |
| es-53-t       |
| es-53-10      |
| 0023ae5a3b86  |
| es-52-08      |
| es-52-05      |
| es-52-04      |
| es-52-03      |
| es-52-02      |
| es-52-01      |
| es-08-t       |
| ad-bmace-2015 |
| HS-104-08-Lap |
+---------------+
21 rows in set (0.01 sec)

@ch3i I can see the host in the Host Listing Export and it does not have a mac address but when i do a search under host i can not find it. How would i delete it out of the Host Listing Export? Also i get a blank page when i try to look at report Hosts and Users

@ch3i This is a host that was reg and then was missing from fog a week later. I will check the mac address table

@Uncle-Frank Nothing show up running
Ubuntu 12.04

fog@fog-virtual-machine2:~$ lsof -i :3306
fog@fog-virtual-machine2:~$```

@Tom-Elliott removed

@Tom-Elliott Same issue after changing DATABASE_HOST and rebooting

@Uncle-Frank

mysql> show full processlist;
+-----+------+-----------------+------+---------+------+-------+-----------------------+
| Id  | User | Host            | db   | Command | Time | State | Info                  |
+-----+------+-----------------+------+---------+------+-------+-----------------------+
|   1 | root | localhost:43411 | fog  | Sleep   |   59 |       | NULL                  |
|   3 | root | localhost:43412 | fog  | Sleep   |  419 |       | NULL                  |
| 581 | root | localhost:50244 | fog  | Sleep   |    4 |       | NULL                  |
| 595 | root | localhost:50345 | fog  | Sleep   |    8 |       | NULL                  |
| 610 | root | localhost:50528 | fog  | Sleep   |    6 |       | NULL                  |
| 617 | root | localhost:50658 | fog  | Sleep   |    9 |       | NULL                  |
| 633 | root | localhost:50682 | fog  | Sleep   |    5 |       | NULL                  |
| 659 | root | localhost:50708 | fog  | Sleep   |    3 |       | NULL                  |
| 660 | root | localhost:50709 | fog  | Sleep   |    6 |       | NULL                  |
| 662 | root | localhost:50711 | fog  | Sleep   |    3 |       | NULL                  |
| 674 | root | localhost:50723 | fog  | Sleep   |    2 |       | NULL                  |
| 676 | root | localhost:50725 | fog  | Sleep   |    7 |       | NULL                  |
| 700 | root | localhost:51600 | fog  | Sleep   |    0 |       | NULL                  |
| 702 | root | localhost:52100 | fog  | Sleep   |    4 |       | NULL                  |
| 704 | root | localhost:52243 | fog  | Sleep   |    5 |       | NULL                  |
| 705 | root | localhost:52313 | fog  | Sleep   |    8 |       | NULL                  |
| 706 | root | localhost:52316 | fog  | Sleep   |    2 |       | NULL                  |
| 708 | root | localhost:52336 | fog  | Sleep   |    0 |       | NULL                  |
| 709 | root | localhost:52343 | fog  | Sleep   |    6 |       | NULL                  |
| 710 | root | localhost:52386 | fog  | Sleep   |    6 |       | NULL                  |
| 711 | root | localhost:52393 | fog  | Sleep   |    9 |       | NULL                  |
| 712 | root | localhost:52402 | fog  | Sleep   |    0 |       | NULL                  |
| 713 | root | localhost:52405 | fog  | Sleep   |    2 |       | NULL                  |
| 714 | root | localhost:52406 | fog  | Sleep   |    0 |       | NULL                  |
| 715 | root | localhost:52414 | fog  | Sleep   |    0 |       | NULL                  |
| 716 | root | localhost:52423 | fog  | Sleep   |    9 |       | NULL                  |
| 717 | root | localhost:52425 | fog  | Sleep   |    3 |       | NULL                  |
| 718 | root | localhost:52426 | fog  | Sleep   |    8 |       | NULL                  |
| 720 | root | localhost:52430 | fog  | Sleep   |    0 |       | NULL                  |
| 721 | root | localhost:52431 | fog  | Sleep   |    5 |       | NULL                  |
| 722 | root | localhost:52432 | fog  | Sleep   |    9 |       | NULL                  |
| 723 | root | localhost:52439 | fog  | Sleep   |    8 |       | NULL                  |
| 724 | root | localhost:52441 | fog  | Sleep   |    4 |       | NULL                  |
| 726 | root | localhost:52448 | fog  | Sleep   |    4 |       | NULL                  |
| 727 | root | localhost:52455 | fog  | Sleep   |    4 |       | NULL                  |
| 728 | root | localhost:52459 | fog  | Sleep   |    1 |       | NULL                  |
| 729 | root | localhost:52461 | fog  | Sleep   |    3 |       | NULL                  |
| 730 | root | localhost:52485 | fog  | Sleep   |    5 |       | NULL                  |
| 731 | root | localhost:52495 | fog  | Sleep   |    5 |       | NULL                  |
| 732 | root | localhost:52527 | fog  | Sleep   |    0 |       | NULL                  |
| 733 | root | localhost       | fog  | Query   |    0 | NULL  | show full processlist |
| 734 | root | localhost:52607 | fog  | Sleep   |    4 |       | NULL                  |
| 735 | root | localhost:52610 | fog  | Sleep   |    2 |       | NULL                  |
| 736 | root | localhost:52612 | fog  | Sleep   |    2 |       | NULL                  |
| 737 | root | localhost:52618 | fog  | Sleep   |    1 |       | NULL                  |
| 738 | root | localhost:52619 | fog  | Sleep   |    2 |       | NULL                  |
| 739 | root | localhost:52620 | fog  | Sleep   |    1 |       | NULL                  |
| 740 | root | localhost:52622 | fog  | Sleep   |    0 |       | NULL                  |
| 741 | root | localhost:52625 | fog  | Sleep   |    0 |       | NULL                  |
+-----+------+-----------------+------+---------+------+-------+-----------------------+
49 rows in set (0.00 sec)

@Tom-Elliott you will get it worked out you always do…

@Tom-Elliott

[Wed Oct 21 12:39:48.260029 2015] [:error] [pid 17732] [client 10.24.28.18:60773] PHP Warning:  mysqli::mysqli(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/MySQL.class.php on line 37
[Wed Oct 21 12:39:48.260368 2015] [:error] [pid 17732] [client 10.24.28.18:60773] PHP Warning:  mysqli::mysqli(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/MySQL.class.php on line 39
[Wed Oct 21 12:39:48.260503 2015] [:error] [pid 17732] [client 10.24.28.18:60773] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 63
[Wed Oct 21 12:39:48.270557 2015] [:error] [pid 17732] [client 10.24.28.18:60773] PHP Warning:  mysqli::mysqli(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/MySQL.class.php on line 37
[Wed Oct 21 12:39:48.270902 2015] [:error] [pid 17732] [client 10.24.28.18:60773] PHP Warning:  mysqli::mysqli(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/MySQL.class.php on line 39
[Wed Oct 21 12:39:48.271034 2015] [:error] [pid 17732] [client ```

I am getting Attempting To Send Inventory - Invalid Host? on computers now that i have up to 4193

Same error SVN 4181

Unable to see a list of printers to add to host with new r4146

@Tom-Elliott I will leave was just going to try to clean up DB because it is like 96Mb

@Wayne-Workman getting error

mysql> use fog
Database changed
mysql> update hosts set hostLastDeploy = '';
Query OK, 1 row affected, 807 warnings (0.02 sec)
Rows matched: 807  Changed: 1  Warnings: 807

@Wayne-Workman would it be like this

mysql -u root <-p password> fog
truncate table history;
exit;```

Just wanting to know if there a way to clear the image history from all host? I have host that have alot of history back to 4 years ago

@Tom-Elliott Working with latest update TY

I am having the same issue

Just a quick question. Does anyone know what is causing this error?

[Wed Oct 07 07:54:09.514830 2015] [:error] [pid 15975] [client 10.24.28.18:50827] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 63
[Wed Oct 07 07:54:09.519121 2015] [:error] [pid 15975] [client 10.24.28.18:50827] PHP Warning:  mysqli::mysqli(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/MySQL.class.php on line 37
[Wed Oct 07 07:54:09.519445 2015] [:error] [pid 15975] [client 10.24.28.18:50827] PHP Warning:  mysqli::mysqli(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/MySQL.class.php on line 39
[Wed Oct 07 07:54:09.519577 2015] [:error] [pid 15975] [client 10.24.28.18:50827] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 63```

@Tom-Elliott The update fixed the issue…
Thanks