I just has wrote an simple perl-script:
#!/usr/bin/perl -w
use DBI;
my $dbh = DBI->connect_cached("dbi:mysql:opsview", "opsview", "changeme", "")
or die "Couldn't connect to database: " . DBI->errstr;
my $sth = $dbh->prepare('SELECT * FROM roles WHERE id = 10')
or die "Couldn't prepare statement: " . $dbh->errstr;
$sth->execute()
or die "Couldn't execute statement: " . $sth->errstr;
@data = $sth->fetchrow_array();
print $data[1], $data[2];
$sth->finish;
$dbh->disconnect;
Then stat it:
# ./mysqltest.pl
AdminAdministrator access
As you can see, it works. I don't have idea, why opsview's web-server script
fails.
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
