1. I added a client and it is Active. However there are 2 columns in the table clients: whil 'status' is 'active', the column 'isactive' = 0. 2. The query run by the SNMP stats poller cron job is: SELECT farms.*, clients.* FROM farms INNER JOIN clients ON clients.id = farms.clientid WHERE farms.status='1' AND clients.isactive='1' 3. This always returns 0 farms and hence there are never any statistics shown. 4. I updated the column 'isactive' to 1 and the cron job recognizes the client and the farm.
Either the status column should be used for the where clause, or the isactive column should be set to 1. Regards Srini -- You received this message because you are subscribed to the Google Groups "scalr-discuss" group. To view this discussion on the web visit https://groups.google.com/d/msg/scalr-discuss/-/26hX9TlqrM0J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/scalr-discuss?hl=en.
