I'm trying to install php-virt-control to my CentOS 6.3 server, but I cannot get passed this error:
"DB Error The connection to your database has failed. Data file is missing.t"
[cid:4B45E056-6CEA-414A-BAFE-3E9249EC16A8]
libvirt
Libvirt support enabled
Debug support enabled, default maximum log file size: 1024 KiB
Extension version 0.4.6
Libvirt version 0.9.10
Max. connections 5
ISO Image path /var/lib/libvirt/images
Path for images /var/lib/libvirt/images
Features supported create-image
Array
(
[libvirt.release] => 10
[libvirt.minor] => 9
[libvirt.major] => 0
[connector.version] => 0.4.6
[connector.major] => 0
[connector.minor] => 4
[connector.release] => 6
)
[root@ts-z600-1 html]# pwd
/var/www/html
[root@ts-z600-1 html]# ls -l
total 188
-rw-r--r-- 1 root root 399 Dec 3 12:24 libvirt-list-domains.php
-rwxrwxrwx 1 root root 339 Dec 3 11:48 libvirt-logfile-set.php
-rwxrwxrwx 1 root root 43 Dec 3 10:19 libvirt-php-info.php
-rwxrwxrwx 1 root root 3337 Oct 16 13:55 oracleCommand.php
-rwxrwxrwx 1 root root 19 Oct 16 13:33 phpinfo.php
lrwxrwxrwx 1 root root 22 Dec 3 13:09 php-virt-control -> php-virt-control-0.0.3
drwxrwxrwx 11 apache root 4096 Dec 3 13:34 php-virt-control-0.0.3
-rw-r--r-- 1 root root 133890 Dec 3 12:45 php-virt-control-0.0.3.tar.gz
-rwxrwxrwx 1 root root 25958 Dec 3 15:55 test.log
[root@ts-z600-1 html]# hostname -f
ts-z600-1.na.tibco.com
[root@ts-z600-1 html]# uname -a
Linux ts-z600-1 2.6.32-279.14.1.el6.centos.plus.x86_64 #1 SMP Wed Nov 7 00:40:45 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
[root@ts-z600-1 html]#
sftp://ts-z600-1.na.tibco.com//var/www/html/php-virt-control-0.0.3/config/c…
<?php
/*
* Define type of storage type
* Currently supported storages are mysql or file
*/
$type = 'mysql';
/*
* Define configuration file for the storage
* For 'file' type it is the data file to store data into
* For 'mysql' type it is the name of the connection configuration file
*/
$config = 'mysql-connection.php';
?>
sftp://ts-z600-1.na.tibco.com//var/www/html/php-virt-control-0.0.3/config/m…
<?php
/* Name of the database server */
$server = 'localhost';
/* Username for database server */
$user = 'php-virt-control';
/* Password for $user */
$password = 'support';
/* Name of the database with the tables */
$dbname = 'php-virt-control';
/* Prefix of tables for php-virt-control */
$prefix = 'vmc_';
?>
[root@ts-z600-1 html]# mysql -u php-virt-control -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 71
Server version: 5.1.66-log Source distribution
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cloud |
| cloud_usage |
| cloudbridge |
| mysql |
| php-virt-control |
+--------------------+
6 rows in set (0.00 sec)
mysql> SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| NULL |
+------------+
1 row in set (0.00 sec)
mysql> USE php-virt-control;
Database changed
mysql> SELECT DATABASE();
+------------------+
| DATABASE() |
+------------------+
| php-virt-control |
+------------------+
1 row in set (0.00 sec)
mysql> SHOW TABLES;
Empty set (0.00 sec)
mysql>
Please help!
Best Regards,
Adam Scarcella
Sr. Support Engineer | Spotfire, TIBCO Software Inc.
Office: (617) 702-1559 | Mobile: (781) 367-8015
Email: mailto:ascarcel@tibco.com
Web: http://spotfire.tibco.com/support
[Description: Description: TIBCO-Spotfire-Logo]