Re: [Observium] mysql_fetch_array replacement?

Thanks guys, didn’t realise it was a php function ☺

Interestingly there were no errors at all, just a zero output from the function, which didn’t help!

Anyway, the solution was indeed from the example given on here:

foreach(dbFetchRows("SELECT hostname FROM `devices` WHERE `disabled`=0 ORDER BY hostname") as $data)

(Then the rest of the original code)

So cheers for that!

Robert Williams Custodian Data Centre Email: Robert@CustodianDC.com http://www.CustodianDC.com From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong Sent: 05 July 2015 18:54 To: observium@observium.org Subject: Re: [Observium] mysql_fetch_array replacement?

I expect he's now using mysqli_* via the config option, which means mysql_* is no longer connected to a database :)

adam.

Sent from Mailbirdhttp://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm_campaign=sent-from-mailbird

On 05/07/2015 18:43:14, Phillip Baker phil@lchost.co.uk wrote: In fact, I’d be surprised if mysql_query is working if you’ve switched Observium to mysqli. What’s the actual error output of the script when you run it?

Phil

From: observium [mailto:observium-bounces@observium.org] On Behalf Of Robert Williams Sent: 05 July 2015 13:51 To: Observium Network Observation System (observium@observium.org) Subject: [Observium] mysql_fetch_array replacement?

Hi,

After the SVN up on the 18th July the script we use for generating the Smokeping targets stopped producing any data (the list of slightly reformatted hostnames). The script itself was taken from this mailing list about 2 years ago and is as follows:

#!/usr/bin/env php <?php

include("/opt/observium/includes/defaults.inc.php"); include("/opt/observium/config.php"); include("/opt/observium/includes/definitions.inc.php"); include("/opt/observium/includes/functions.php");

echo "*** Targets ***\n\nprobe = FPing\n\nmenu = Top\ntitle = Network Latency Grapher\nremark = Welcome to SmokePing\n\n";

$query = mysql_query("SELECT hostname FROM `devices` WHERE `disabled`=0 ORDER BY hostname");

while ($data = mysql_fetch_array($query)) { $hostid = str_replace(".","_",$data['hostname']); $hostname = $data['hostname']; echo "+ $hostid\n\nhost = $hostname\n\n"; }

?>

I can see that /includes/functions.php no longer exists but it’s replacement in functions.inc.php does not appear to have a function for mysql_fetch_array().

So my question is, can someone point me to the correct replacement function for this? I’ve had a look through it and can’t see what I’m looking for, but PHP is not my ‘thing’ so I’m missing it.

Any assistance appreciated!

Robert Williams Custodian Data Centre Email: Robert@CustodianDC.commailto:Robert@CustodianDC.com http://www.CustodianDC.com