You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
84 lines
1.9 KiB
84 lines
1.9 KiB
10 months ago
|
#!/bin/sh
|
||
|
|
# Author: Athmane Madjoudj <athmanem@gmail.com>
|
||
|
|
# Author: Christoph Galuschka <tigalch@tigalch.org>
|
||
|
|
# reusing the script from LAMP-Tests
|
||
|
|
|
||
|
|
t_Log "Running $0 - php-cli basic interaction with mysql55 test."
|
||
|
|
if [ $centos_ver != 5 ]
|
||
|
|
then
|
||
|
|
t_Log "This is not a C5-system - skipping"
|
||
|
|
exit 0
|
||
|
|
fi
|
||
|
|
|
||
|
|
# Install php-mysql-module
|
||
|
|
t_InstallPackage php-mysql
|
||
|
|
|
||
|
|
# we need a working and running mysql server
|
||
|
|
#starting with 5.10 we need to reflect mysql55
|
||
|
|
t_ServiceControl mysqld stop
|
||
|
|
t_ServiceControl mysql55-mysqld start >/dev/null 2>&1
|
||
|
|
|
||
|
|
#create a little DB to use
|
||
|
|
CREATE='/var/tmp/mysql-php-QA.sql'
|
||
|
|
|
||
|
|
cat >$CREATE <<EOF
|
||
|
|
drop database if exists phptests;
|
||
|
|
create database phptests;
|
||
|
|
use phptests;
|
||
|
|
create table tests (name varchar(20)) ;
|
||
|
|
grant all on phptests.* to 'centos'@'localhost' identified by 'qa';
|
||
|
|
flush privileges;
|
||
|
|
EOF
|
||
|
|
|
||
|
|
mysql <$CREATE
|
||
|
|
|
||
|
|
# create PHP Script and write something into DB
|
||
|
|
INSERT='/var/tmp/test.php'
|
||
|
|
|
||
|
|
cat >$INSERT <<EOF
|
||
|
|
<?php
|
||
|
|
\$dbconnect = mysql_connect("localhost","centos","qa");
|
||
|
|
if (!\$dbconnect)
|
||
|
|
{
|
||
|
|
die('Could not connect: ' . mysql_error());
|
||
|
|
}
|
||
|
|
mysql_select_db("phptests", \$dbconnect);
|
||
|
|
mysql_query("INSERT INTO tests (name)
|
||
|
|
VALUES ('phpsqltest')");
|
||
|
|
mysql_close(\$dbconnect);
|
||
|
|
?>
|
||
|
|
EOF
|
||
|
|
|
||
|
|
php $INSERT
|
||
|
|
if [ $? -ne 0 ]
|
||
|
|
then
|
||
|
|
t_Log "Inserting into DB failed"
|
||
|
|
exit 1
|
||
|
|
fi
|
||
|
|
|
||
|
|
# create PHP script to read from DB
|
||
|
|
READ='/var/tmp/read.php'
|
||
|
|
cat >$READ <<EOF
|
||
|
|
<?php
|
||
|
|
\$dbconnect = mysql_connect("localhost","centos","qa");
|
||
|
|
if (!\$dbconnect)
|
||
|
|
{
|
||
|
|
die('Could not connect: ' . mysql_error());
|
||
|
|
}
|
||
|
|
mysql_select_db("phptests", \$dbconnect);
|
||
|
|
\$array = mysql_query("SELECT count(*) as success FROM tests WHERE name = 'phpsqltest'");
|
||
|
|
mysql_close(\$dbconnect);
|
||
|
|
\$line = mysql_fetch_array(\$array, MYSQL_ASSOC);
|
||
|
|
print \$line['success'];
|
||
|
|
?>
|
||
|
|
EOF
|
||
|
|
|
||
|
|
# If we execute the script and get '1' it works (1 entry should be in the DB)
|
||
|
|
php $READ | grep -q '1'
|
||
|
|
|
||
|
|
t_CheckExitStatus $?
|
||
|
|
|
||
|
|
#cleaning up
|
||
|
|
/bin/rm $READ $CREATE $INSERT
|
||
|
|
mysql -u root -e 'drop database phptests' >/dev/null 2>&1
|