| #!/bin/bash |
| |
| t_Log "Running $0 - install a minimal lamp stack, and test it" |
| |
| t_InstallPackage httpd mysql mysql-server php php-mysql wget |
| t_ServiceControl mysqld restart |
| t_ServiceControl httpd restart |
| |
| |
| cat >/tmp/mysql-QA.sql <<EOF |
| create database qatests; |
| use qatests; |
| create table tests (name varchar(20)) ; |
| grant all on qatests.* to 'centos'@'localhost' identified by 'qa'; |
| flush privileges; |
| EOF |
| |
| mysql </tmp/mysql-QA.sql |
| /bin/rm /tmp/mysql-QA.sql |
| |
| |
| |
| cat >/var/www/html/mysql.php <<EOF |
| <?php |
| \$dbconnect = mysql_connect("localhost","centos","qa"); |
| if (!\$dbconnect) |
| { |
| die('Could not connect: ' . mysql_error()); |
| } |
| |
| mysql_select_db("qatests", \$dbconnect); |
| |
| mysql_query("INSERT INTO tests (name) |
| VALUES ('mysqltest')"); |
| |
| mysql_close(\$dbconnect); |
| ?> |
| EOF |
| |
| |
| |
| |
| |
| curl -s http://localhost/mysql.php |
| |
| t_Log "Performing basic LAMP test" |
| content=`echo "select * from qatests.tests where name='mysqltest'"|mysql -B --skip-column-names` |
| |
| |
| mysql -u root -e 'drop database qatests;' |
| service httpd stop |
| |
| if [ "$content" = "mysqltest" ] ; then |
| ret_val=0; |
| else |
| ret_val=1; |
| fi |
| |
| t_CheckExitStatus $ret_val |