=========================================================== .___ __ __ _________________ __ __ __| _/|__|/ |_ / ___\_` __ \__ \ | | \/ __ | | \\_ __\ / /_/ > | \// __ \| | / /_/ | | || | \___ /|__| (____ /____/\____ | |__||__| /_____/ \/ \/ grep rough audit - static analysis tool v2.8 written by @Wireghoul =================================[justanotherhacker.com]=== openstack-cluster-installer-31/bin/oci-cluster-upgrade-openstack-release-28-# Make a survey of all the hosts we have in the cluster openstack-cluster-installer-31/bin/oci-cluster-upgrade-openstack-release:29:ALL_CTRL=$(ocicli -csv machine-list -a | q -H -d, "SELECT Cur_ip,hostname FROM - WHERE role='controller' AND cluster='${CLUSTER_NAME}' AND status='installed' ORDER BY hostname" | tr '\n' ' ') openstack-cluster-installer-31/bin/oci-cluster-upgrade-openstack-release:30:ONE_CTRL=$(ocicli -csv machine-list -a | q -H -d, "SELECT Cur_ip,hostname FROM - WHERE role='controller' AND cluster='${CLUSTER_NAME}' AND status='installed' ORDER BY hostname LIMIT 1" | tr '\n' ' ') openstack-cluster-installer-31/bin/oci-cluster-upgrade-openstack-release-31-ONE_CTRL_IP=$(echo ${ONE_CTRL} | cut -d, -f1) openstack-cluster-installer-31/bin/oci-cluster-upgrade-openstack-release:32:ALL_COMP=$(ocicli -csv machine-list -a | q -H -d, "SELECT Cur_ip,hostname FROM - WHERE role='compute' AND cluster='${CLUSTER_NAME}' AND status='installed' ORDER BY hostname" | tr '\n' ' ') openstack-cluster-installer-31/bin/oci-cluster-upgrade-openstack-release:33:ALL_VOL=$(ocicli -csv machine-list -a | q -H -d, "SELECT Cur_ip,hostname FROM - WHERE role='volume' AND cluster='${CLUSTER_NAME}' AND status='installed' ORDER BY hostname" | tr '\n' ' ') openstack-cluster-installer-31/bin/oci-cluster-upgrade-openstack-release:34:ALL_NET=$(ocicli -csv machine-list -a | q -H -d, "SELECT Cur_ip,hostname FROM - WHERE role='network' AND cluster='${CLUSTER_NAME}' AND status='installed' ORDER BY hostname" | tr '\n' ' ') openstack-cluster-installer-31/bin/oci-cluster-upgrade-openstack-release:35:ALL_NODES=$(ocicli -csv machine-list -a | q -H -d, "SELECT Cur_ip,hostname FROM - WHERE cluster='${CLUSTER_NAME}' AND status='installed' ORDER BY hostname" | tr '\n' ' ') openstack-cluster-installer-31/bin/oci-cluster-upgrade-openstack-release-36- ############################################## openstack-cluster-installer-31/bin/oci-cluster-upgrade-stretch-to-buster-18- openstack-cluster-installer-31/bin/oci-cluster-upgrade-stretch-to-buster:19:FIRST_CTRL=$(ocicli -csv machine-list -a | q -H -d, "SELECT Cur_ip,hostname FROM - WHERE role='controller' AND cluster='${CLUSTER_NAME}' ORDER BY hostname LIMIT 1") openstack-cluster-installer-31/bin/oci-cluster-upgrade-stretch-to-buster:20:SEC_CTRL=$(ocicli -csv machine-list -a | q -H -d, "SELECT Cur_ip,hostname FROM - WHERE role='controller' AND cluster='${CLUSTER_NAME}' ORDER BY hostname LIMIT 1,1") openstack-cluster-installer-31/bin/oci-cluster-upgrade-stretch-to-buster:21:LAST_CTRL=$(ocicli -csv machine-list -a | q -H -d, "SELECT Cur_ip,hostname FROM - WHERE role='controller' AND cluster='${CLUSTER_NAME}' ORDER BY hostname DESC LIMIT 1") openstack-cluster-installer-31/bin/oci-cluster-upgrade-stretch-to-buster:22:ALL_CTRL=$(ocicli -csv machine-list -a | q -H -d, "SELECT Cur_ip,hostname FROM - WHERE role='controller' AND cluster='${CLUSTER_NAME}' ORDER BY hostname" | tr '\n' ' ') openstack-cluster-installer-31/bin/oci-cluster-upgrade-stretch-to-buster-23-FIRST_CTRL_IP=$(echo ${FIRST_CTRL} | cut -d, -f1) ############################################## openstack-cluster-installer-31/bin/oci-update-cluster-certs-24- openstack-cluster-installer-31/bin/oci-update-cluster-certs:25:CLUSTER_ID=$(ocicli -csv cluster-list | q -H -d, "SELECT id FROM - WHERE name='"${CLUSTER_NAME}"'") openstack-cluster-installer-31/bin/oci-update-cluster-certs-26- ############################################## openstack-cluster-installer-31/bin/oci-update-cluster-certs-29- openstack-cluster-installer-31/bin/oci-update-cluster-certs:30:for res in $(ocicli -csv machine-list --all | q -H -d, "SELECT hostname, role FROM - WHERE status='installed' AND cluster='"${CLUSTER_NAME}"'") ; do openstack-cluster-installer-31/bin/oci-update-cluster-certs-31- SRV=$(echo $res | awk -F ',' '{ print $1 }') ############################################## openstack-cluster-installer-31/bin/oci-userdb-32-if [ "${1}" = "-d" ] ; then openstack-cluster-installer-31/bin/oci-userdb:33: ${CMD} "DELETE FROM users WHERE login='${2}' LIMIT 1" openstack-cluster-installer-31/bin/oci-userdb-34-fi ############################################## openstack-cluster-installer-31/bin/openstack-cluster-installer-build-live-image-53-if [ -z "${OTCI_PXE_SERVER_IP}" ] ; then openstack-cluster-installer-31/bin/openstack-cluster-installer-build-live-image:54: DEFROUTE_IF=`awk '{ if ( $2 == "00000000" ) print $1 }' /proc/net/route` openstack-cluster-installer-31/bin/openstack-cluster-installer-build-live-image-55- if [ -n "${DEFROUTE_IF}" ] ; then openstack-cluster-installer-31/bin/openstack-cluster-installer-build-live-image-56- if [ -x /bin/ip ] ; then openstack-cluster-installer-31/bin/openstack-cluster-installer-build-live-image:57: DEFROUTE_IP=`LC_ALL=C ip addr show "${DEFROUTE_IF}" | grep inet | head -n 1 | awk '{print $2}' | cut -d/ -f1 | grep -E '^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$'` openstack-cluster-installer-31/bin/openstack-cluster-installer-build-live-image-58- else openstack-cluster-installer-31/bin/openstack-cluster-installer-build-live-image:59: DEFROUTE_IP=`hostname -i | grep -E '^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$'` openstack-cluster-installer-31/bin/openstack-cluster-installer-build-live-image-60- fi ############################################## openstack-cluster-installer-31/bin/openstack-cluster-installer-stop-7-if [ -e ${KVM_PID_FILE} ] ; then openstack-cluster-installer-31/bin/openstack-cluster-installer-stop:8: VM_PID=`cat ${KVM_PID_FILE}` openstack-cluster-installer-31/bin/openstack-cluster-installer-stop-9- echo "===> Found PID running: ${VM_PID}. Killing process..." ############################################## openstack-cluster-installer-31/debian/startup/openstack-cluster-installer.init-16-IPTABLES=/sbin/iptables openstack-cluster-installer-31/debian/startup/openstack-cluster-installer.init:17:EXTIF=`awk '{ if ( $2 == "00000000" ) print $1 }' /proc/net/route | head -n 1` openstack-cluster-installer-31/debian/startup/openstack-cluster-installer.init-18- ############################################## openstack-cluster-installer-31/ocicli/ocicli-1038- local CNT=1800 openstack-cluster-installer-31/ocicli/ocicli:1039: while [ "${CNT}" -gt 0 ] && [ ""$(ocicli -csv machine-list -a | q -H -d, "SELECT ${FIELD} FROM - WHERE serial='${MACHINE_SERIAL}'") != "${VALUE}" ] ; do openstack-cluster-installer-31/ocicli/ocicli-1040- echo -n "." ############################################## openstack-cluster-installer-31/ocicli/ocicli-1054- local CNT=6000 openstack-cluster-installer-31/ocicli/ocicli:1055: local PUPPET_STATUS=$(ocicli -csv machine-list -s | q -H -d, "SELECT puppet FROM - WHERE serial='${MACHINE_SERIAL}'") openstack-cluster-installer-31/ocicli/ocicli-1056- while [ "${CNT}" -gt 0 ] && [ "${PUPPET_STATUS}" != "success" ] && [ "${PUPPET_STATUS}" != "failure" ] ; do ############################################## openstack-cluster-installer-31/ocicli/ocicli-1058- sleep 2 openstack-cluster-installer-31/ocicli/ocicli:1059: PUPPET_STATUS=$(ocicli -csv machine-list -s | q -H -d, "SELECT puppet FROM - WHERE serial='${MACHINE_SERIAL}'") openstack-cluster-installer-31/ocicli/ocicli-1060- CNT=$((${CNT} - 1)) ############################################## openstack-cluster-installer-31/ocicli/ocicli-1072- local CLUSTER_NAME=${1} openstack-cluster-installer-31/ocicli/ocicli:1073: local EXISTS=$(ocicli -csv cluster-list | q -H -d, "SELECT COUNT(id) FROM - WHERE name='${CLUSTER_NAME}'") openstack-cluster-installer-31/ocicli/ocicli-1074- if [ "${EXISTS}" != "1" ] ; then ############################################## openstack-cluster-installer-31/ocicli/ocicli-1078- echo "Installing cluster ${CLUSTER_NAME}..." openstack-cluster-installer-31/ocicli/ocicli:1079: DOMAIN_NAME=$(ocicli -csv cluster-list | q -H -d, "SELECT domain FROM - WHERE name='${CLUSTER_NAME}'") openstack-cluster-installer-31/ocicli/ocicli:1080: CLUSTER_ID=$(ocicli -csv cluster-list | q -H -d, "SELECT id FROM - WHERE name='${CLUSTER_NAME}'") openstack-cluster-installer-31/ocicli/ocicli-1081- echo "Cluster has domain name: ${DOMAIN_NAME} and ID: ${CLUSTER_ID}" openstack-cluster-installer-31/ocicli/ocicli:1082: CEPH_MONS=$(ocicli -csv machine-list -a | q -H -d, "SELECT serial FROM - WHERE role='cephmon' AND cluster='${CLUSTER_NAME}'" | tr '\n' ' ') openstack-cluster-installer-31/ocicli/ocicli:1083: CEPH_OSDS=$(ocicli -csv machine-list -a | q -H -d, "SELECT serial FROM - WHERE role='cephosd' AND cluster='${CLUSTER_NAME}'" | tr '\n' ' ') openstack-cluster-installer-31/ocicli/ocicli:1084: COMPUTE_WITH_CEPH_OSDS=$(ocicli -csv machine-list -a | q -H -d, "SELECT serial FROM - WHERE role='compute' AND cephosd='yes' AND cluster='${CLUSTER_NAME}'" | tr '\n' ' ') openstack-cluster-installer-31/ocicli/ocicli:1085: CONTROLLERS=$(ocicli -csv machine-list -a | q -H -d, "SELECT serial FROM - WHERE role='controller' AND cluster='${CLUSTER_NAME}'" | tr '\n' ' ') openstack-cluster-installer-31/ocicli/ocicli:1086: NETWORKS=$(ocicli -csv machine-list -a | q -H -d, "SELECT serial FROM - WHERE role='network' AND cluster='${CLUSTER_NAME}'" | tr '\n' ' ') openstack-cluster-installer-31/ocicli/ocicli:1087: COMPUTES=$(ocicli -csv machine-list -a | q -H -d, "SELECT serial FROM - WHERE role='compute' AND cluster='${CLUSTER_NAME}'" | tr '\n' ' ') openstack-cluster-installer-31/ocicli/ocicli:1088: VOLUMES=$(ocicli -csv machine-list -a | q -H -d, "SELECT serial FROM - WHERE role='volume' AND cluster='${CLUSTER_NAME}'" | tr '\n' ' ') openstack-cluster-installer-31/ocicli/ocicli:1089: SWIFTPROXIES=$(ocicli -csv machine-list -a | q -H -d, "SELECT serial FROM - WHERE role='swiftproxy' AND cluster='${CLUSTER_NAME}'" | tr '\n' ' ') openstack-cluster-installer-31/ocicli/ocicli:1090: SWIFTSTORES=$(ocicli -csv machine-list -a | q -H -d, "SELECT serial FROM - WHERE role='swiftstore' AND cluster='${CLUSTER_NAME}'" | tr '\n' ' ') openstack-cluster-installer-31/ocicli/ocicli-1091- ############################################## openstack-cluster-installer-31/ocicli/ocicli-1094- for i in ${CEPH_MONS} ; do openstack-cluster-installer-31/ocicli/ocicli:1095: STATUS=$(ocicli -csv machine-list -a | q -H -d, "SELECT status FROM - WHERE serial='${i}'") openstack-cluster-installer-31/ocicli/ocicli-1096- if [ "${STATUS}" = "live" ] ; then ############################################## openstack-cluster-installer-31/ocicli/ocicli-1108- for i in ${CEPH_OSDS} ; do openstack-cluster-installer-31/ocicli/ocicli:1109: STATUS=$(ocicli -csv machine-list -a | q -H -d, "SELECT status FROM - WHERE serial='${i}'") openstack-cluster-installer-31/ocicli/ocicli-1110- if [ "${STATUS}" = "live" ] ; then ############################################## openstack-cluster-installer-31/ocicli/ocicli-1122- for i in ${COMPUTE_WITH_CEPH_OSDS} ; do openstack-cluster-installer-31/ocicli/ocicli:1123: STATUS=$(ocicli -csv machine-list -a | q -H -d, "SELECT status FROM - WHERE serial='${i}'") openstack-cluster-installer-31/ocicli/ocicli-1124- if [ "${STATUS}" = "live" ] ; then ############################################## openstack-cluster-installer-31/ocicli/ocicli-1136- for i in ${CONTROLLERS} ; do openstack-cluster-installer-31/ocicli/ocicli:1137: STATUS=$(ocicli -csv machine-list -a | q -H -d, "SELECT status FROM - WHERE serial='${i}'") openstack-cluster-installer-31/ocicli/ocicli-1138- if [ "${STATUS}" = "live" ] ; then ############################################## openstack-cluster-installer-31/ocicli/ocicli-1153- for i in ${NETWORKS} ; do openstack-cluster-installer-31/ocicli/ocicli:1154: STATUS=$(ocicli -csv machine-list -a | q -H -d, "SELECT status FROM - WHERE serial='${i}'") openstack-cluster-installer-31/ocicli/ocicli-1155- if [ "${STATUS}" = "live" ] ; then ############################################## openstack-cluster-installer-31/ocicli/ocicli-1170- for i in ${COMPUTES} ${VOLUMES} ${SWIFTPROXIES} ${SWIFTSTORES} ; do openstack-cluster-installer-31/ocicli/ocicli:1171: STATUS=$(ocicli -csv machine-list -a | q -H -d, "SELECT status FROM - WHERE serial='${i}'") openstack-cluster-installer-31/ocicli/ocicli-1172- if [ "${STATUS}" = "live" ] ; then ############################################## openstack-cluster-installer-31/ocicli/ocicli-1188- local CLUSTER_NAME=${1} openstack-cluster-installer-31/ocicli/ocicli:1189: local EXISTS=$(ocicli -csv cluster-list | q -H -d, "SELECT COUNT(id) FROM - WHERE name='${CLUSTER_NAME}'") openstack-cluster-installer-31/ocicli/ocicli-1190- if [ "${EXISTS}" != "1" ] ; then ############################################## openstack-cluster-installer-31/ocicli/ocicli-1200- echo "Resetting cluster ${CLUSTER_NAME}..." openstack-cluster-installer-31/ocicli/ocicli:1201: MACHINES=$(ocicli -csv machine-list -a | q -H -d, "SELECT serial FROM - WHERE cluster='${CLUSTER_NAME}' AND status!='live'" | tr '\n' ' ') openstack-cluster-installer-31/ocicli/ocicli-1202- if [ -n "${MACHINES}" ] ; then ############################################## openstack-cluster-installer-31/ocicli/ocicli-1360- IPMI_ADDR=$(ocicli -csv machine-show $machine 2>&1 | grep "IPMI addr:" | cut -d, -f2) openstack-cluster-installer-31/ocicli/ocicli:1361: MACHINE_DC=$(ocicli -csv machine-list -r 2>&1 | q -H -d, "SELECT dc FROM - WHERE serial='${machine}'") openstack-cluster-installer-31/ocicli/ocicli:1362: MACHINE_ROW=$(ocicli -csv machine-list -r 2>&1 | q -H -d, "SELECT row FROM - WHERE serial='${machine}'") openstack-cluster-installer-31/ocicli/ocicli:1363: MACHINE_RACK=$(ocicli -csv machine-list -r 2>&1 | q -H -d, "SELECT rack FROM - WHERE serial='${machine}'") openstack-cluster-installer-31/ocicli/ocicli:1364: MACHINE_USTART=$(ocicli -csv machine-list -r 2>&1 | q -H -d, "SELECT ustart FROM - WHERE serial='${machine}'") openstack-cluster-installer-31/ocicli/ocicli:1365: MACHINE_UEND=$(ocicli -csv machine-list -r 2>&1 | q -H -d, "SELECT uend FROM - WHERE serial='${machine}'") openstack-cluster-installer-31/ocicli/ocicli:1366: HOSTNAME=$(ocicli -csv machine-list -r 2>&1 | q -H -d, "SELECT hostname FROM - WHERE serial='${machine}'") openstack-cluster-installer-31/ocicli/ocicli-1367- echo -n " (dc:${MACHINE_DC}/row:${MACHINE_ROW}/rack:${MACHINE_RACK}/ustart:${MACHINE_USTART}/uend:${MACHINE_UEND}/hostname:${HOSTNAME}): " ############################################## openstack-cluster-installer-31/poc-bin/oci-poc-openstack-provisionning-40- FLAVOR_VCPU=${4} openstack-cluster-installer-31/poc-bin/oci-poc-openstack-provisionning:41: FLAVOR_ID=$(openstack flavor list -f csv 2>/dev/null | q -H -d , "SELECT * FROM - WHERE Name='${FLAVOR_NAME}'" 2>/dev/null | cut -d , -f 1) openstack-cluster-installer-31/poc-bin/oci-poc-openstack-provisionning-42- if [ -z "${FLAVOR_ID}" ] ; then ############################################## openstack-cluster-installer-31/poc-bin/oci-poc-openstack-provisionning-80- FLAVOR_PRICE=${2} openstack-cluster-installer-31/poc-bin/oci-poc-openstack-provisionning:81: MAPPING_ID=$(cloudkitty hashmap mapping list --field-id ${FIELD_ID} -g ${HASHMAP_GROUP_ID} -f csv | q -H -d , "SELECT * FROM - WHERE Value='${FLAVOR_NAME}'" 2>/dev/null | cut -d , -f 1) openstack-cluster-installer-31/poc-bin/oci-poc-openstack-provisionning-82- if [ -z "${MAPPING_ID}" ] ; then ############################################## openstack-cluster-installer-31/poc-bin/oci-poc-save-52- for i in $(ocicli -csv machine-list -a | q -H -d, "SELECT Cur_ip FROM - WHERE status='installed'") ; do openstack-cluster-installer-31/poc-bin/oci-poc-save:53: HOSTNAME=$(ocicli -csv machine-list | q -H -d, "SELECT hostname FROM - WHERE Cur_ip='${i}'") openstack-cluster-installer-31/poc-bin/oci-poc-save-54- echo "Shutting down: ${HOSTNAME}" ############################################## openstack-cluster-installer-31/poc-bin/oci-poc-save-58- for i in $(ocicli -csv machine-list -a | q -H -d, "SELECT Cur_ip FROM - WHERE status='installed'") ; do openstack-cluster-installer-31/poc-bin/oci-poc-save:59: HOSTNAME=$(ocicli -csv machine-list | q -H -d, "SELECT hostname FROM - WHERE Cur_ip='${i}'") openstack-cluster-installer-31/poc-bin/oci-poc-save:60: SERIAL=$(ocicli -csv machine-list | q -H -d, "SELECT serial FROM - WHERE Cur_ip='${i}'") openstack-cluster-installer-31/poc-bin/oci-poc-save-61- VM_NUM=$(printf "%d" $((0x${SERIAL} - 0xC0))) ############################################## openstack-cluster-installer-31/src/api.php-39- if($safe_machine_serial === FALSE){ openstack-cluster-installer-31/src/api.php:40: $q = "SELECT * FROM machines WHERE hostname='$safe_machine_hostname'"; openstack-cluster-installer-31/src/api.php-41- }else{ openstack-cluster-installer-31/src/api.php:42: $q = "SELECT * FROM machines WHERE serial='$safe_machine_serial'"; openstack-cluster-installer-31/src/api.php-43- } ############################################## openstack-cluster-installer-31/src/api.php-52- if($safe_machine_serial !== FALSE){ openstack-cluster-installer-31/src/api.php:53: $q = "SELECT * FROM machines WHERE hostname='$safe_machine_hostname'"; openstack-cluster-installer-31/src/api.php-54- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-105- $safe_hostname = safe_fqdn("hostname"); openstack-cluster-installer-31/src/api.php:106: $r = mysqli_query($con, "SELECT * FROM machines WHERE hostname='$safe_hostname'"); openstack-cluster-installer-31/src/api.php-107- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-128- } openstack-cluster-installer-31/src/api.php:129: $q = "SELECT * FROM clusters WHERE name='$safe_cluster_name'"; openstack-cluster-installer-31/src/api.php-130- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-143- $cluster_id = $cluster["id"]; openstack-cluster-installer-31/src/api.php:144: $q = "SELECT roles.name AS role, rolecounts.count AS count FROM roles,rolecounts WHERE rolecounts.cluster='$cluster_id' AND rolecounts.role=roles.id ORDER BY roles.name"; openstack-cluster-installer-31/src/api.php-145- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-159- } openstack-cluster-installer-31/src/api.php:160: $q = "SELECT * FROM clusters WHERE name='$safe_cluster_name'"; openstack-cluster-installer-31/src/api.php-161- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-177- $machine_id = $json["data"]["first_master_machine_id"]; openstack-cluster-installer-31/src/api.php:178: $q = "SELECT serial FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/api.php-179- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-202- } openstack-cluster-installer-31/src/api.php:203: $q = "SELECT * FROM clusters WHERE name='$safe_cluster_name'"; openstack-cluster-installer-31/src/api.php-204- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-224- } openstack-cluster-installer-31/src/api.php:225: $q = "SELECT * FROM roles WHERE name='$safe_role_name'"; openstack-cluster-installer-31/src/api.php-226- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-247- openstack-cluster-installer-31/src/api.php:248: $q = "UPDATE rolecounts SET count='$safe_role_count' WHERE role='$safe_role_id' AND cluster='$safe_cluster_id'"; openstack-cluster-installer-31/src/api.php-249- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-258- } openstack-cluster-installer-31/src/api.php:259: $q = "SELECT * FROM clusters WHERE name='$safe_cluster_name'"; openstack-cluster-installer-31/src/api.php-260- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-672- } openstack-cluster-installer-31/src/api.php:673: $r = mysqli_query($con, "SELECT * FROM machines WHERE serial='$safe_first_master_serial' AND role='controller' AND cluster='".$cluster["id"]."'"); openstack-cluster-installer-31/src/api.php-674- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-738- openstack-cluster-installer-31/src/api.php:739: $q = "UPDATE clusters SET $update WHERE name='$safe_cluster_name'"; openstack-cluster-installer-31/src/api.php-740- if($update != ""){ ############################################## openstack-cluster-installer-31/src/api.php-752- } openstack-cluster-installer-31/src/api.php:753: $q = "SELECT * FROM clusters WHERE name='$safe_cluster_name'"; openstack-cluster-installer-31/src/api.php-754- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-767- $cluster_id = $cluster["id"]; openstack-cluster-installer-31/src/api.php:768: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr FROM machines,ips WHERE machines.cluster='$cluster_id' AND machines.id=ips.machine"; openstack-cluster-installer-31/src/api.php-769- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-781- openstack-cluster-installer-31/src/api.php:782: $q = "DELETE FROM blockdevices WHERE machine_id='$machine_id'"; openstack-cluster-installer-31/src/api.php-783- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-789- openstack-cluster-installer-31/src/api.php:790: $q = "DELETE FROM physblockdevices WHERE machine_id='$machine_id'"; openstack-cluster-installer-31/src/api.php-791- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-797- openstack-cluster-installer-31/src/api.php:798: $q = "DELETE FROM ifnames WHERE machine_id='$machine_id'"; openstack-cluster-installer-31/src/api.php-799- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-805- openstack-cluster-installer-31/src/api.php:806: $q = "DELETE FROM ips WHERE machine='$machine_id'"; openstack-cluster-installer-31/src/api.php-807- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-813- openstack-cluster-installer-31/src/api.php:814: $q = "DELETE FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/api.php-815- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-836- # Fetch machine info and output openstack-cluster-installer-31/src/api.php:837: $r = mysqli_query($con, "SELECT * FROM machines WHERE ipaddr='$safe_ip'"); openstack-cluster-installer-31/src/api.php-838- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-864- }else{ openstack-cluster-installer-31/src/api.php:865: $rl = mysqli_query($con, "SELECT name,swiftregion FROM locations WHERE id='".$a["location_id"]."'"); openstack-cluster-installer-31/src/api.php-866- $nl = mysqli_num_rows($rl); ############################################## openstack-cluster-installer-31/src/api.php-876- # For each machines, get the block devices openstack-cluster-installer-31/src/api.php:877: $bd_r = mysqli_query($con, "SELECT name,size_mb FROM blockdevices WHERE machine_id='".$a["id"]."' ORDER BY name"); openstack-cluster-installer-31/src/api.php-878- $bd_n = mysqli_num_rows($bd_r); ############################################## openstack-cluster-installer-31/src/api.php-899- # For each machines, get the network devices openstack-cluster-installer-31/src/api.php:900: $nd_r = mysqli_query($con, "SELECT name,macaddr,max_speed,switchport_name,switch_hostname FROM ifnames WHERE machine_id='".$a["id"]."' ORDER BY name"); openstack-cluster-installer-31/src/api.php-901- $nd_n = mysqli_num_rows($nd_r); ############################################## openstack-cluster-installer-31/src/api.php-930- }else{ openstack-cluster-installer-31/src/api.php:931: $rc = mysqli_query($con, "SELECT name FROM clusters WHERE id='".$a["cluster"]."'"); openstack-cluster-installer-31/src/api.php-932- $nc = mysqli_num_rows($rc); ############################################## openstack-cluster-installer-31/src/api.php-944- $json["data"][$i]["mgmt_ip"] = ""; openstack-cluster-installer-31/src/api.php:945: $rnet = mysqli_query($con, "SELECT INET_NTOA(ips.ip) AS ipaddr, networks.name AS networkname FROM ips,networks WHERE ips.network=networks.id AND machine='".$a["id"]."' AND usefor='machine' AND networks.role NOT LIKE 'ipmi' AND networks.role NOT LIKE 'vm-net' AND networks.role NOT LIKE 'ceph-cluster' AND networks.role NOT LIKE 'ovs-bridge'"); openstack-cluster-installer-31/src/api.php-946- $nnet = mysqli_num_rows($rnet); ############################################## openstack-cluster-installer-31/src/api.php-1121- openstack-cluster-installer-31/src/api.php:1122: $q = "UPDATE machines SET report_counter='0' WHERE id='".$machine["id"]."'"; openstack-cluster-installer-31/src/api.php-1123- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1136- openstack-cluster-installer-31/src/api.php:1137: $r = mysqli_query($con, "SELECT * FROM clusters WHERE id='".$machine["cluster"]."'"); openstack-cluster-installer-31/src/api.php-1138- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-1145- openstack-cluster-installer-31/src/api.php:1146: $r = mysqli_query($con, "SELECT * FROM blockdevices WHERE machine_id='".$machine["id"]."' ORDER BY name"); openstack-cluster-installer-31/src/api.php-1147- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-1158- openstack-cluster-installer-31/src/api.php:1159: $r = mysqli_query($con, "SELECT INET_NTOA(ips.ip) as ipaddr,networks.name AS networkname FROM ips,networks WHERE machine='".$machine["id"]."' AND ips.network=networks.id"); openstack-cluster-installer-31/src/api.php-1160- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-1172- # All ifaces openstack-cluster-installer-31/src/api.php:1173: $r = mysqli_query($con, "SELECT * FROM ifnames WHERE machine_id='".$machine["id"]."' ORDER BY name"); openstack-cluster-installer-31/src/api.php-1174- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-1186- # All megacli devices openstack-cluster-installer-31/src/api.php:1187: $r = mysqli_query($con, "SELECT * FROM physblockdevices WHERE machine_id='".$machine["id"]."' ORDER BY slot"); openstack-cluster-installer-31/src/api.php-1188- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-1685- openstack-cluster-installer-31/src/api.php:1686: $q = "UPDATE machines SET $Q_ADDON WHERE serial='$safe_machine_serial'"; openstack-cluster-installer-31/src/api.php-1687- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1702- openstack-cluster-installer-31/src/api.php:1703: $q = "UPDATE machines SET cluster=NULL, hostname='' WHERE id='$machine_id'"; openstack-cluster-installer-31/src/api.php-1704- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1708- if($machine_role == "controller"){ openstack-cluster-installer-31/src/api.php:1709: $q = "SELECT first_master_machine_id FROM clusters WHERE id='$machine_cluster'"; openstack-cluster-installer-31/src/api.php-1710- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1713- if($fm_id == $machine_id){ openstack-cluster-installer-31/src/api.php:1714: $q = "SELECT * FROM machines WHERE cluster='$machine_cluster' AND role='controller' LIMIT 1;"; openstack-cluster-installer-31/src/api.php-1715- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1718- if($n == 0){ openstack-cluster-installer-31/src/api.php:1719: $q = "UPDATE clusters SET first_master_machine_id=NULL WHERE id='$machine_cluster'"; openstack-cluster-installer-31/src/api.php-1720- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1724- $new_fm_id = $first_master["id"]; openstack-cluster-installer-31/src/api.php:1725: $q = "UPDATE clusters SET first_master_machine_id='$new_fm_id' WHERE id='$machine_cluster'"; openstack-cluster-installer-31/src/api.php-1726- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1733- if($machine_role == "sql"){ openstack-cluster-installer-31/src/api.php:1734: $q = "SELECT first_sql_machine_id FROM clusters WHERE id='$machine_cluster'"; openstack-cluster-installer-31/src/api.php-1735- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1738- if($fsql_id == $machine_id){ openstack-cluster-installer-31/src/api.php:1739: $q = "SELECT * FROM machines WHERE cluster='$machine_cluster' AND role='sql' LIMIT 1;"; openstack-cluster-installer-31/src/api.php-1740- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1743- if($n == 0){ openstack-cluster-installer-31/src/api.php:1744: $q = "UPDATE clusters SET first_sql_machine_id=NULL WHERE id='$machine_cluster'"; openstack-cluster-installer-31/src/api.php-1745- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1749- $new_fsql_id = $first_master["id"]; openstack-cluster-installer-31/src/api.php:1750: $q = "UPDATE clusters SET first_sql_machine_id='$new_fsql_id' WHERE id='$machine_cluster'"; openstack-cluster-installer-31/src/api.php-1751- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1756- // Delete all IPs of the machine in the DB openstack-cluster-installer-31/src/api.php:1757: $q = "DELETE FROM ips WHERE machine='$machine_id' AND usefor NOT LIKE 'ipmi'"; openstack-cluster-installer-31/src/api.php-1758- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1769- } openstack-cluster-installer-31/src/api.php:1770: $r = mysqli_query($con, "SELECT * FROM machines WHERE serial='$safe_machine_serial'"); openstack-cluster-installer-31/src/api.php-1771- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-1811- } openstack-cluster-installer-31/src/api.php:1812: $r = mysqli_query($con, "SELECT * FROM clusters WHERE name='$safe_cluster_name'"); openstack-cluster-installer-31/src/api.php-1813- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-1833- } openstack-cluster-installer-31/src/api.php:1834: $r = mysqli_query($con, "SELECT id FROM roles WHERE name='$safe_role_name'"); openstack-cluster-installer-31/src/api.php-1835- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-1855- } openstack-cluster-installer-31/src/api.php:1856: $r = mysqli_query($con, "SELECT id FROM locations WHERE name='$safe_location_name'"); openstack-cluster-installer-31/src/api.php-1857- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-1891- } openstack-cluster-installer-31/src/api.php:1892: $q = "SELECT * FROM locations WHERE name='$safe_location_name'"; openstack-cluster-installer-31/src/api.php-1893- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1911- } openstack-cluster-installer-31/src/api.php:1912: $q = "SELECT * FROM swiftregions WHERE name='$safe_swiftregion_name'"; openstack-cluster-installer-31/src/api.php-1913- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1936- } openstack-cluster-installer-31/src/api.php:1937: $q = "SELECT * FROM locations WHERE name='$safe_location_name'"; openstack-cluster-installer-31/src/api.php-1938- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1951- openstack-cluster-installer-31/src/api.php:1952: $q = "SELECT * FROM networks WHERE location_id='".$a["id"]."'"; openstack-cluster-installer-31/src/api.php-1953- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-1965- openstack-cluster-installer-31/src/api.php:1966: $r = mysqli_query($con, "DELETE FROM locations WHERE name='$safe_location_name'"); openstack-cluster-installer-31/src/api.php-1967- return $json; ############################################## openstack-cluster-installer-31/src/api.php-1986- } openstack-cluster-installer-31/src/api.php:1987: $q = "SELECT * FROM swiftregions WHERE name='$safe_swiftregion_name'"; openstack-cluster-installer-31/src/api.php-1988- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2016- } openstack-cluster-installer-31/src/api.php:2017: $q = "SELECT * FROM swiftregions WHERE name='$safe_swiftregion_name'"; openstack-cluster-installer-31/src/api.php-2018- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2029- } openstack-cluster-installer-31/src/api.php:2030: $q = "SELECT * FROM locations WHERE swiftregion='$safe_swiftregion_name'"; openstack-cluster-installer-31/src/api.php-2031- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-2041- } openstack-cluster-installer-31/src/api.php:2042: $r = mysqli_query($con, "DELETE FROM swiftregions WHERE name='$safe_swiftregion_name'"); openstack-cluster-installer-31/src/api.php-2043- return $json; ############################################## openstack-cluster-installer-31/src/api.php-2058- # Fix status in db openstack-cluster-installer-31/src/api.php:2059: $r = mysqli_query($con, "UPDATE machines SET status='firstboot' WHERE serial='$safe_machine_serial'"); openstack-cluster-installer-31/src/api.php-2060- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-2082- # Fix status in db openstack-cluster-installer-31/src/api.php:2083: $q = "UPDATE machines SET status='bootinglive' WHERE serial='$safe_machine_serial'"; openstack-cluster-installer-31/src/api.php-2084- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2118- // Whipe the first chunks of the HDDs openstack-cluster-installer-31/src/api.php:2119: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id'"; openstack-cluster-installer-31/src/api.php-2120- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2189- openstack-cluster-installer-31/src/api.php:2190: $q = "SELECT networks.name AS networkname, INET_NTOA(ips.ip) AS ipaddr FROM ips,machines,networks WHERE ips.machine=machines.id AND machines.serial='$safe_machine_serial' AND networks.id=ips.network"; openstack-cluster-installer-31/src/api.php-2191- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2217- $safe_ip_long = ip2long($safe_machine_ip); openstack-cluster-installer-31/src/api.php:2218: $q = "SELECT * FROM ips WHERE ip='$safe_ip_long'"; openstack-cluster-installer-31/src/api.php-2219- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2238- } openstack-cluster-installer-31/src/api.php:2239: $q = "SELECT * FROM networks WHERE name='$safe_network_name'"; openstack-cluster-installer-31/src/api.php-2240- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2288- $safe_ip_long = ip2long($safe_machine_ip); openstack-cluster-installer-31/src/api.php:2289: $q = "SELECT * FROM ips WHERE ip='$safe_ip_long'"; openstack-cluster-installer-31/src/api.php-2290- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2303- $ip_id = $ip["id"]; openstack-cluster-installer-31/src/api.php:2304: $q = "DELETE FROM ips WHERE id='$ip_id'"; openstack-cluster-installer-31/src/api.php-2305- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2340- } openstack-cluster-installer-31/src/api.php:2341: $q = "SELECT * FROM clusters WHERE name='$safe_cluster_name'"; openstack-cluster-installer-31/src/api.php-2342- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2373- } openstack-cluster-installer-31/src/api.php:2374: $q = "SELECT * FROM clusters WHERE name='$safe_cluster_name'"; openstack-cluster-installer-31/src/api.php-2375- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2389- # Check if some machines are in the cluster openstack-cluster-installer-31/src/api.php:2390: $q = "SELECT cluster FROM machines WHERE cluster='".$cluster["id"]."'"; openstack-cluster-installer-31/src/api.php-2391- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2404- # Check if some networks are in the cluster openstack-cluster-installer-31/src/api.php:2405: $q = "SELECT cluster FROM networks WHERE cluster='".$cluster["id"]."'"; openstack-cluster-installer-31/src/api.php-2406- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2429- } openstack-cluster-installer-31/src/api.php:2430: $q = "SELECT * FROM clusters WHERE name='$safe_cluster_name'"; openstack-cluster-installer-31/src/api.php-2431- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2445- openstack-cluster-installer-31/src/api.php:2446: $q = "SELECT * FROM networks WHERE cluster='$cluster_id'"; openstack-cluster-installer-31/src/api.php-2447- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2468- } openstack-cluster-installer-31/src/api.php:2469: $q = "SELECT * FROM clusters WHERE name='$safe_cluster_name'"; openstack-cluster-installer-31/src/api.php-2470- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2484- openstack-cluster-installer-31/src/api.php:2485: $q = "SELECT * FROM machines WHERE cluster='$cluster_id'"; openstack-cluster-installer-31/src/api.php-2486- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2515- }else{ openstack-cluster-installer-31/src/api.php:2516: $qc = "SELECT name FROM clusters WHERE id='". $a["cluster"] ."'"; openstack-cluster-installer-31/src/api.php-2517- $rc = mysqli_query($con, $qc); ############################################## openstack-cluster-installer-31/src/api.php-2538- } openstack-cluster-installer-31/src/api.php:2539: $q = "SELECT * FROM networks WHERE name='$safe_network_name'"; openstack-cluster-installer-31/src/api.php-2540- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2552- $network = mysqli_fetch_array($r); openstack-cluster-installer-31/src/api.php:2553: $r = mysqli_query($con, "DELETE FROM ips WHERE network='".$network["id"]."'"); openstack-cluster-installer-31/src/api.php:2554: $r = mysqli_query($con, "DELETE FROM networks WHERE name='$safe_network_name'"); openstack-cluster-installer-31/src/api.php-2555- return $json; ############################################## openstack-cluster-installer-31/src/api.php-2565- } openstack-cluster-installer-31/src/api.php:2566: $q = "SELECT * FROM networks WHERE name='$safe_network_name'"; openstack-cluster-installer-31/src/api.php-2567- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2585- } openstack-cluster-installer-31/src/api.php:2586: $q = "SELECT * FROM locations WHERE name='$safe_location_name'"; openstack-cluster-installer-31/src/api.php-2587- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2667- } openstack-cluster-installer-31/src/api.php:2668: $q = "SELECT * FROM networks WHERE name='$safe_network_name'"; openstack-cluster-installer-31/src/api.php-2669- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2703- } openstack-cluster-installer-31/src/api.php:2704: $q = "SELECT * FROM roles WHERE name='$safe_role_name'"; openstack-cluster-installer-31/src/api.php-2705- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2828- } openstack-cluster-installer-31/src/api.php:2829: $q = "SELECT * FROM locations WHERE name='$safe_location'"; openstack-cluster-installer-31/src/api.php-2830- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2958- } openstack-cluster-installer-31/src/api.php:2959: $q = "UPDATE networks SET $update WHERE name='$safe_network_name'"; openstack-cluster-installer-31/src/api.php-2960- if($update != ""){ ############################################## openstack-cluster-installer-31/src/api.php-2973- } openstack-cluster-installer-31/src/api.php:2974: $q = "SELECT * FROM networks WHERE name='$safe_network_name'"; openstack-cluster-installer-31/src/api.php-2975- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-2989- } openstack-cluster-installer-31/src/api.php:2990: $q = "SELECT * FROM clusters WHERE name='$safe_cluster_name'"; openstack-cluster-installer-31/src/api.php-2991- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-3010- }else{ openstack-cluster-installer-31/src/api.php:3011: $r = mysqli_query($con, "SELECT id FROM roles WHERE name='$safe_role_name'"); openstack-cluster-installer-31/src/api.php-3012- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/api.php-3100- } openstack-cluster-installer-31/src/api.php:3101: $q = "UPDATE networks SET cluster='$safe_cluster_id', role=$sql_role, iface1='$safe_iface1', iface2='$safe_iface2' WHERE name='$safe_network_name'"; openstack-cluster-installer-31/src/api.php-3102- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-3107- } openstack-cluster-installer-31/src/api.php:3108: $q = "SELECT * FROM networks WHERE name='$safe_network_name'"; openstack-cluster-installer-31/src/api.php-3109- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-3137- } openstack-cluster-installer-31/src/api.php:3138: $q = "SELECT * FROM networks WHERE name='$safe_network_name'"; openstack-cluster-installer-31/src/api.php-3139- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-3153- openstack-cluster-installer-31/src/api.php:3154: $q = "UPDATE networks SET cluster=NULL, role=NULL WHERE id='$safe_network_id'"; openstack-cluster-installer-31/src/api.php-3155- $r = mysqli_query($con, $q); openstack-cluster-installer-31/src/api.php:3156: $q = "DELETE FROM ips WHERE network='$safe_network_id'"; openstack-cluster-installer-31/src/api.php-3157- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-3180- $return_var = 0; openstack-cluster-installer-31/src/api.php:3181: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/api.php-3182- $ipmi_default_gw = $output[0]; ############################################## openstack-cluster-installer-31/src/api.php-3196- } openstack-cluster-installer-31/src/api.php:3197: $q = "SELECT * FROM machines WHERE serial='$safe_machine_serial'"; openstack-cluster-installer-31/src/api.php-3198- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-3218- if($_REQUEST["ipmi_use"] != 'yes'){ openstack-cluster-installer-31/src/api.php:3219: $q = "UPDATE machines SET ipmi_use='no' WHERE id='$safe_machine_id'"; openstack-cluster-installer-31/src/api.php-3220- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-3254- } openstack-cluster-installer-31/src/api.php:3255: $q = "UPDATE machines SET ipmi_call_chassis_bootdev='$safe_ipmi_call_chassis_bootdev' WHERE id='$safe_machine_id'"; openstack-cluster-installer-31/src/api.php-3256- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-3279- openstack-cluster-installer-31/src/api.php:3280: $q = "UPDATE machines SET ipmi_use='yes', ipmi_addr='$safe_ipmi_addr', ipmi_port='$safe_ipmi_port', ipmi_username='$safe_ipmi_username', ipmi_password='$safe_ipmi_password' WHERE id='$safe_machine_id'"; openstack-cluster-installer-31/src/api.php-3281- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-3314- openstack-cluster-installer-31/src/api.php:3315: $r = mysqli_query($con, "UPDATE machines SET status='firstboot' WHERE serial='$safe_machine_serial'"); openstack-cluster-installer-31/src/api.php-3316- ############################################## openstack-cluster-installer-31/src/api.php-3319- $return_var = 0; openstack-cluster-installer-31/src/api.php:3320: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/api.php-3321- return $json; ############################################## openstack-cluster-installer-31/src/api.php-3336- openstack-cluster-installer-31/src/api.php:3337: $r = mysqli_query($con, "UPDATE machines SET status='bootinglive' WHERE serial='$safe_machine_serial'"); openstack-cluster-installer-31/src/api.php-3338- ############################################## openstack-cluster-installer-31/src/api.php-3341- $return_var = 0; openstack-cluster-installer-31/src/api.php:3342: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/api.php-3343- return $json; ############################################## openstack-cluster-installer-31/src/api.php-3351- } openstack-cluster-installer-31/src/api.php:3352: $q = "SELECT * FROM clusters WHERE name='$safe_cluster_name'"; openstack-cluster-installer-31/src/api.php-3353- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-3420- } openstack-cluster-installer-31/src/api.php:3421: $q = "SELECT * FROM roles WHERE name='$safe_role_name'"; openstack-cluster-installer-31/src/api.php-3422- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-3448- } openstack-cluster-installer-31/src/api.php:3449: $q = "SELECT * FROM roles WHERE name='$safe_role_name'"; openstack-cluster-installer-31/src/api.php-3450- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/api.php-3461- } openstack-cluster-installer-31/src/api.php:3462: $r = mysqli_query($con, "DELETE FROM roles WHERE name='$safe_role_name'"); openstack-cluster-installer-31/src/api.php-3463- return $json; ############################################## openstack-cluster-installer-31/src/backup_db.php-44- openstack-cluster-installer-31/src/backup_db.php:45: $qshow = "SHOW FULL COLUMNS FROM $row[0] WHERE Field='".$a['Field']."'"; openstack-cluster-installer-31/src/backup_db.php-46- $rshow = mysqli_query($con, $qshow)or die("Cannot query \"$qshow\" !\nError in ".__FILE__." line ".__LINE__.": ".mysqli_error($con)); ############################################## openstack-cluster-installer-31/src/backup_db.php-54- case "text": openstack-cluster-installer-31/src/backup_db.php:55: $q2 = "SELECT character_set_name FROM information_schema.`COLUMNS` WHERE table_name = '".$row[0]."' AND column_name = '".$a['Field']."'"; openstack-cluster-installer-31/src/backup_db.php-56- $r2 = mysqli_query($con, $q2)or die("Cannot execute query: \"$q2\" line ".__LINE__." in file ".__FILE__.", mysql said: ".mysqli_error($con)); ############################################## openstack-cluster-installer-31/src/db_sync.php-124- // If the field is not present, create it. openstack-cluster-installer-31/src/db_sync.php:125: $q = "SHOW FULL COLUMNS FROM $curtbl WHERE Field='$v'"; openstack-cluster-installer-31/src/db_sync.php-126- $r = mysqli_query($con, $q)or die("Cannot execute query: \"$q\" line ".__LINE__." in file ".__FILE__.", mysql said: ".mysqli_error($con)); ############################################## openstack-cluster-installer-31/src/db_sync.php-155- $type = $a_type; openstack-cluster-installer-31/src/db_sync.php:156: $q2 = "SELECT character_set_name FROM information_schema.`COLUMNS` WHERE table_name = '".$curtbl."' AND column_name = '".$v."'"; openstack-cluster-installer-31/src/db_sync.php-157- $r2 = mysqli_query($con, $q2)or die("Cannot execute query: \"$q2\" line ".__LINE__." in file ".__FILE__.", mysql said: ".mysqli_error($con)); ############################################## openstack-cluster-installer-31/src/db_sync.php-323- openstack-cluster-installer-31/src/db_sync.php:324: $qf = "SHOW FULL COLUMNS FROM $table WHERE Field='$col'"; openstack-cluster-installer-31/src/db_sync.php-325- // If the field is not present, create it. ############################################## openstack-cluster-installer-31/src/inc/actions.php-30- } openstack-cluster-installer-31/src/inc/actions.php:31: $r = mysqli_query($con, "UPDATE machines SET hostname='$safe_fqdn' WHERE ipaddr='$safe_ip'"); openstack-cluster-installer-31/src/inc/actions.php-32- ############################################## openstack-cluster-installer-31/src/inc/actions.php-51- } openstack-cluster-installer-31/src/inc/actions.php:52: $q = "SELECT id FROM machines WHERE ipaddr='$safe_ip'"; openstack-cluster-installer-31/src/inc/actions.php-53- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-66- openstack-cluster-installer-31/src/inc/actions.php:67: $r = mysqli_query($con, "UPDATE machines SET status='bootinglive' WHERE ipaddr='$safe_ip'"); openstack-cluster-installer-31/src/inc/actions.php-68- $ret = send_ssh_cmd($conf, $con, $_REQUEST["ipaddr"], "shutdown -r now"); ############################################## openstack-cluster-installer-31/src/inc/actions.php-81- openstack-cluster-installer-31/src/inc/actions.php:82: $q = "SELECT id FROM machines WHERE ipaddr='$safe_ip'"; openstack-cluster-installer-31/src/inc/actions.php-83- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-96- openstack-cluster-installer-31/src/inc/actions.php:97: $r = mysqli_query($con, "UPDATE machines SET status='firstboot' WHERE ipaddr='$safe_ip'"); openstack-cluster-installer-31/src/inc/actions.php-98- $ret = send_ssh_cmd($conf, $con, $_REQUEST["ipaddr"], "shutdown -r now"); ############################################## openstack-cluster-installer-31/src/inc/actions.php-111- openstack-cluster-installer-31/src/inc/actions.php:112: $q = "SELECT id FROM machines WHERE ipaddr='$safe_ip'"; openstack-cluster-installer-31/src/inc/actions.php-113- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-126- openstack-cluster-installer-31/src/inc/actions.php:127: $r = mysqli_query($con, "UPDATE machines SET status='firstboot' WHERE ipaddr='$safe_ip'"); openstack-cluster-installer-31/src/inc/actions.php:128: $q = "SELECT * FROM machines WHERE ipaddr='$safe_ip'"; openstack-cluster-installer-31/src/inc/actions.php-129- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-137- $return_var = 0; openstack-cluster-installer-31/src/inc/actions.php:138: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/actions.php-139- break; ############################################## openstack-cluster-installer-31/src/inc/actions.php-151- openstack-cluster-installer-31/src/inc/actions.php:152: $q = "SELECT id FROM machines WHERE ipaddr='$safe_ip'"; openstack-cluster-installer-31/src/inc/actions.php-153- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-166- openstack-cluster-installer-31/src/inc/actions.php:167: $r = mysqli_query($con, "UPDATE machines SET status='bootinglive' WHERE ipaddr='$safe_ip'"); openstack-cluster-installer-31/src/inc/actions.php:168: $q = "SELECT * FROM machines WHERE ipaddr='$safe_ip'"; openstack-cluster-installer-31/src/inc/actions.php-169- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-177- $return_var = 0; openstack-cluster-installer-31/src/inc/actions.php:178: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/actions.php-179- break; ############################################## openstack-cluster-installer-31/src/inc/actions.php-189- } openstack-cluster-installer-31/src/inc/actions.php:190: $r = mysqli_query($con, "UPDATE machines SET notes='". mysqli_real_escape_string($con, $_REQUEST["notes"]) ."' WHERE ipaddr='$safe_ip'"); openstack-cluster-installer-31/src/inc/actions.php-191- break; ############################################## openstack-cluster-installer-31/src/inc/actions.php-217- } openstack-cluster-installer-31/src/inc/actions.php:218: $q = "DELETE FROM clusters WHERE id='$safe_id'"; openstack-cluster-installer-31/src/inc/actions.php-219- $r = mysqli_query($con, $q); openstack-cluster-installer-31/src/inc/actions.php:220: $q = "UPDATE machines SET cluster=NULL, role='' WHERE cluster='$safe_id'"; openstack-cluster-installer-31/src/inc/actions.php-221- $r = mysqli_query($con, $q); openstack-cluster-installer-31/src/inc/actions.php:222: $q = "DELETE FROM rolecounts WHERE cluster='$safe_id'"; openstack-cluster-installer-31/src/inc/actions.php-223- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-231- } openstack-cluster-installer-31/src/inc/actions.php:232: $q = "SELECT role, cluster FROM machines WHERE id='$safe_machine_id';"; openstack-cluster-installer-31/src/inc/actions.php-233- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-242- openstack-cluster-installer-31/src/inc/actions.php:243: $q = "UPDATE machines SET cluster=NULL WHERE id='$safe_machine_id'"; openstack-cluster-installer-31/src/inc/actions.php-244- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-248- if($safe_role == "controller"){ openstack-cluster-installer-31/src/inc/actions.php:249: $q = "SELECT first_master_machine_id FROM clusters WHERE id='$safe_cluster_id'"; openstack-cluster-installer-31/src/inc/actions.php-250- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-253- if($fm_id == $safe_machine_id){ openstack-cluster-installer-31/src/inc/actions.php:254: $q = "SELECT * FROM machines WHERE cluster='$safe_cluster_id' AND role='controller' LIMIT 1;"; openstack-cluster-installer-31/src/inc/actions.php-255- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-258- if($n == 0){ openstack-cluster-installer-31/src/inc/actions.php:259: $q = "UPDATE clusters SET first_master_machine_id=NULL WHERE id='$safe_cluster_id'"; openstack-cluster-installer-31/src/inc/actions.php-260- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-264- $new_fm_id = $first_master["id"]; openstack-cluster-installer-31/src/inc/actions.php:265: $q = "UPDATE clusters SET first_master_machine_id='$new_fm_id' WHERE id='$safe_cluster_id'"; openstack-cluster-installer-31/src/inc/actions.php-266- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-270- // Delete all IPs of the machine in the DB openstack-cluster-installer-31/src/inc/actions.php:271: $q = "DELETE FROM ips WHERE machine='$safe_machine_id'"; openstack-cluster-installer-31/src/inc/actions.php-272- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-282- } openstack-cluster-installer-31/src/inc/actions.php:283: $q = "SELECT * FROM clusters WHERE id='$safe_cluster_id'"; openstack-cluster-installer-31/src/inc/actions.php-284- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-303- } openstack-cluster-installer-31/src/inc/actions.php:304: $q = "SELECT * FROM roles WHERE name='$safe_role'"; openstack-cluster-installer-31/src/inc/actions.php-305- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-314- $safe_role_id = $a["id"]; openstack-cluster-installer-31/src/inc/actions.php:315: $q = "SELECT * FROM rolecounts WHERE cluster='$safe_cluster_id' AND role='$safe_role_id'"; openstack-cluster-installer-31/src/inc/actions.php-316- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-375- } openstack-cluster-installer-31/src/inc/actions.php:376: $q = "DELETE FROM roles WHERE id='$safe_role_id'"; openstack-cluster-installer-31/src/inc/actions.php-377- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-398- } openstack-cluster-installer-31/src/inc/actions.php:399: $q = "DELETE FROM locations WHERE id='$safe_location_id'"; openstack-cluster-installer-31/src/inc/actions.php-400- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-412- } openstack-cluster-installer-31/src/inc/actions.php:413: $q = "SELECT * FROM machines WHERE cluster='$safe_cluster_id' AND id='$safe_fm_id'"; openstack-cluster-installer-31/src/inc/actions.php-414- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-419- } openstack-cluster-installer-31/src/inc/actions.php:420: $q = "UPDATE clusters SET first_master_machine_id='$safe_fm_id' WHERE id='$safe_cluster_id'"; openstack-cluster-installer-31/src/inc/actions.php-421- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-482- } openstack-cluster-installer-31/src/inc/actions.php:483: $q = "SELECT * FROM networks WHERE id='$safe_id'"; openstack-cluster-installer-31/src/inc/actions.php-484- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-494- } openstack-cluster-installer-31/src/inc/actions.php:495: $q = "SELECT * FROM locations WHERE id='$safe_location_id'"; openstack-cluster-installer-31/src/inc/actions.php-496- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-507- } openstack-cluster-installer-31/src/inc/actions.php:508: $q = "UPDATE networks SET name='$safe_network_name', ip='$safe_ip', cidr='$safe_cidr', mtu='$safe_mtu', is_public='$safe_is_public', location_id='$safe_location_id' WHERE id='$safe_id';"; openstack-cluster-installer-31/src/inc/actions.php-509- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-516- } openstack-cluster-installer-31/src/inc/actions.php:517: $q = "SELECT * FROM networks WHERE id='$safe_id'"; openstack-cluster-installer-31/src/inc/actions.php-518- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-523- } openstack-cluster-installer-31/src/inc/actions.php:524: $q = "DELETE FROM networks WHERE id='$safe_id';"; openstack-cluster-installer-31/src/inc/actions.php-525- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-532- } openstack-cluster-installer-31/src/inc/actions.php:533: $q = "SELECT * FROM networks WHERE id='$safe_network_id'"; openstack-cluster-installer-31/src/inc/actions.php-534- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-547- }else{ openstack-cluster-installer-31/src/inc/actions.php:548: $q = "SELECT * FROM roles WHERE name='$safe_role_name'"; openstack-cluster-installer-31/src/inc/actions.php-549- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-562- } openstack-cluster-installer-31/src/inc/actions.php:563: $q = "SELECT * FROM clusters WHERE id='$safe_cluster_id'"; openstack-cluster-installer-31/src/inc/actions.php-564- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-592- openstack-cluster-installer-31/src/inc/actions.php:593: $q = "UPDATE networks SET cluster='$safe_cluster_id', role=$sql_role, iface1='$safe_iface1', iface2='$safe_iface2', vlan=$safe_vlanid WHERE id='$safe_network_id'"; openstack-cluster-installer-31/src/inc/actions.php-594- $r = mysqli_query($con, $q); openstack-cluster-installer-31/src/inc/actions.php-595- openstack-cluster-installer-31/src/inc/actions.php:596: $q = "SELECT * FROM networks WHERE id='$safe_network_id'"; openstack-cluster-installer-31/src/inc/actions.php-597- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-618- } openstack-cluster-installer-31/src/inc/actions.php:619: $q = "SELECT * FROM networks WHERE id='$safe_network_id'"; openstack-cluster-installer-31/src/inc/actions.php-620- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-631- } openstack-cluster-installer-31/src/inc/actions.php:632: $q = "SELECT * FROM clusters WHERE id='$safe_cluster_id'"; openstack-cluster-installer-31/src/inc/actions.php-633- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-639- openstack-cluster-installer-31/src/inc/actions.php:640: $q = "UPDATE networks SET cluster=NULL, role=NULL WHERE id='$safe_network_id'"; openstack-cluster-installer-31/src/inc/actions.php-641- $r = mysqli_query($con, $q); openstack-cluster-installer-31/src/inc/actions.php:642: $q = "DELETE FROM ips WHERE network='$safe_network_id'"; openstack-cluster-installer-31/src/inc/actions.php-643- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-651- if(!isset($_REQUEST["ipmi_use"])){ openstack-cluster-installer-31/src/inc/actions.php:652: $q = "UPDATE machines SET ipmi_use='no' WHERE id='$safe_machine_id'"; openstack-cluster-installer-31/src/inc/actions.php-653- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-683- } openstack-cluster-installer-31/src/inc/actions.php:684: $q = "UPDATE machines SET ipmi_use='yes', ipmi_call_chassis_bootdev='$ipmi_call_chassis_bootdev', ipmi_addr='$safe_ipmi_addr', ipmi_port='$safe_ipmi_port', ipmi_username='$safe_ipmi_username', ipmi_password='$safe_ipmi_password' WHERE id='$safe_machine_id'"; openstack-cluster-installer-31/src/inc/actions.php-685- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-755- openstack-cluster-installer-31/src/inc/actions.php:756: $q = "SELECT * FROM clusters WHERE id='$safe_cluster_id'"; openstack-cluster-installer-31/src/inc/actions.php-757- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-778- $return_var = 0; openstack-cluster-installer-31/src/inc/actions.php:779: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/actions.php-780- } ############################################## openstack-cluster-installer-31/src/inc/actions.php-787- $return_var = 0; openstack-cluster-installer-31/src/inc/actions.php:788: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/actions.php-789- } ############################################## openstack-cluster-installer-31/src/inc/actions.php-791- openstack-cluster-installer-31/src/inc/actions.php:792: $q = "UPDATE clusters SET swift_part_power='$safe_swift_part_power', swift_replicas='$safe_swift_replicas', swift_min_part_hours='$safe_min_part_hours', vip_hostname='$safe_vip_hostname', swift_proxy_hostname='$safe_swift_proxy_hostname', swift_encryption_key_id='$safe_swift_encryption_key_id', haproxy_custom_url='$safe_haproxy_custom_url', statsd_hostname='$safe_statsd_hostname' WHERE id='$safe_cluster_id'"; openstack-cluster-installer-31/src/inc/actions.php-793- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/actions.php-809- } openstack-cluster-installer-31/src/inc/actions.php:810: $q = "DELETE FROM swiftregions WHERE id='$safe_swiftregion_id'"; openstack-cluster-installer-31/src/inc/actions.php-811- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/auth.php-8- openstack-cluster-installer-31/src/inc/auth.php:9: $q = "SELECT * FROM users WHERE login='$safe_login'"; openstack-cluster-installer-31/src/inc/auth.php-10- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/auto_provision.php-7- # Check if the machine exists openstack-cluster-installer-31/src/inc/auto_provision.php:8: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/auto_provision.php-9- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/auto_provision.php-45- $safe_cluster_name = $conf["auto_provision"]["auto_add_machines_cluster_name"]; openstack-cluster-installer-31/src/inc/auto_provision.php:46: $r = mysqli_query($con, "SELECT * FROM clusters WHERE name='$safe_cluster_name'"); openstack-cluster-installer-31/src/inc/auto_provision.php-47- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/inc/auto_provision.php-99- openstack-cluster-installer-31/src/inc/auto_provision.php:100: $q = "SELECT id FROM locations WHERE name='".$location_name."'"; openstack-cluster-installer-31/src/inc/auto_provision.php-101- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/auto_racking.php-27- # Check if the machine exists openstack-cluster-installer-31/src/inc/auto_racking.php:28: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/auto_racking.php-29- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/auto_racking.php-49- # Seach for its NICs (filtering those without switch hostname) openstack-cluster-installer-31/src/inc/auto_racking.php:50: $q = "SELECT * FROM ifnames WHERE machine_id='$machine_id' AND switch_hostname!='unknown' AND switchport_name!='unknown'"; openstack-cluster-installer-31/src/inc/auto_racking.php-51- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/auto_racking.php-92- # Check if the machine exists openstack-cluster-installer-31/src/inc/auto_racking.php:93: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/auto_racking.php-94- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/auto_racking.php-112- if(isset($ret["data"])){ openstack-cluster-installer-31/src/inc/auto_racking.php:113: $q = "UPDATE machines SET loc_dc='".$ret["data"]["dc"]."', loc_row='".$ret["data"]["row"]."', loc_rack='".$ret["data"]["rack"]."', loc_u_start='".$ret["data"]["u_start"]."', loc_u_end='".$ret["data"]["u_end"]."' WHERE id='".$machine["id"]."'"; openstack-cluster-installer-31/src/inc/auto_racking.php-114- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-5- $json["message"] = "Successfuly queried API."; openstack-cluster-installer-31/src/inc/enc.php:6: $q = "SELECT pass,passtxt1,passtxt2 FROM passwords WHERE cluster='$cluster_id' AND service='$service_type' AND passtype='$password_type'"; openstack-cluster-installer-31/src/inc/enc.php-7- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-16- insert_cluster_pass($con, $conf, $cluster_id, $service_type, $password_type); openstack-cluster-installer-31/src/inc/enc.php:17: $q = "SELECT pass,passtxt1,passtxt2 FROM passwords WHERE cluster='$cluster_id' AND service='$service_type' AND passtype='$password_type'"; openstack-cluster-installer-31/src/inc/enc.php-18- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-43- $json["message"] = "Successfuly queried API."; openstack-cluster-installer-31/src/inc/enc.php:44: $q = "SELECT * FROM sshkeypairs WHERE clusterid='$cluster_id' AND hostname='$hostname' AND username='$username'"; openstack-cluster-installer-31/src/inc/enc.php-45- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-54- insert_ssh_key($con, $conf, $cluster_id, $hostname, $username); openstack-cluster-installer-31/src/inc/enc.php:55: $q = "SELECT * FROM sshkeypairs WHERE clusterid='$cluster_id' AND hostname='$hostname' AND username='$username'"; openstack-cluster-installer-31/src/inc/enc.php-56- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-75-function enc_get_mon_nodes($con,$conf,$cluster_id){ openstack-cluster-installer-31/src/inc/enc.php:76: $q = "SELECT * FROM machines WHERE role='cephmon' AND cluster='$cluster_id'"; openstack-cluster-installer-31/src/inc/enc.php-77- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-85- // If there's no specific cephmon nodes, then controllers will assume that role openstack-cluster-installer-31/src/inc/enc.php:86: $q = "SELECT * FROM machines WHERE role='controller' AND cluster='$cluster_id'"; openstack-cluster-installer-31/src/inc/enc.php-87- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-103- openstack-cluster-installer-31/src/inc/enc.php:104: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips, networks WHERE machines.role='$role_to_select' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND networks.role!='ipmi' AND machines.cluster='$cluster_id'"; openstack-cluster-installer-31/src/inc/enc.php-105- ############################################## openstack-cluster-installer-31/src/inc/enc.php-143- $safe_hostname = safe_fqdn("hostname"); openstack-cluster-installer-31/src/inc/enc.php:144: $q = "SELECT * FROM machines WHERE hostname='$safe_hostname'"; openstack-cluster-installer-31/src/inc/enc.php-145- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-170- // Fetch matching cluster object openstack-cluster-installer-31/src/inc/enc.php:171: $q = "SELECT * FROM clusters WHERE id='$cluster_id'"; openstack-cluster-installer-31/src/inc/enc.php-172- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-237- // Get this machine's IP and hostname openstack-cluster-installer-31/src/inc/enc.php:238: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips WHERE machines.id='$machine_id' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network='$network_id'"; openstack-cluster-installer-31/src/inc/enc.php-239- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-255- // Get the API's VIP ip address openstack-cluster-installer-31/src/inc/enc.php:256: $q = "SELECT * FROM networks WHERE cluster='$cluster_id' AND is_public='yes'"; openstack-cluster-installer-31/src/inc/enc.php-257- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-276- }else{ openstack-cluster-installer-31/src/inc/enc.php:277: $q = "SELECT INET_NTOA(ips.ip) AS ipaddr FROM ips WHERE network='$public_network_id' AND usefor='vip' AND vip_usage='api'"; openstack-cluster-installer-31/src/inc/enc.php-278- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-299- openstack-cluster-installer-31/src/inc/enc.php:300: $q = "SELECT * FROM networks WHERE id='$network_id'"; openstack-cluster-installer-31/src/inc/enc.php-301- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-321- $enc_nids = " all_masters_ids:\n"; openstack-cluster-installer-31/src/inc/enc.php:322: $q = "SELECT machines.hostname AS hostname, machines.id AS nodeid, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips, networks WHERE machines.role='controller' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND networks.role!='ipmi'"; openstack-cluster-installer-31/src/inc/enc.php-323- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-340- // Fetch all networks that contain an IP with a swiftstore or a swiftproxy openstack-cluster-installer-31/src/inc/enc.php:341: $q_allowed_network = "SELECT DISTINCT networks.ip AS ip,networks.cidr AS cidr FROM networks,ips,machines WHERE ips.network = networks.id AND machines.id = ips.machine AND (machines.role='swiftstore' OR machines.role='swiftproxy') AND machines.cluster='$cluster_id'"; openstack-cluster-installer-31/src/inc/enc.php-342- $r_allowed_network = mysqli_query($con, $q_allowed_network); ############################################## openstack-cluster-installer-31/src/inc/enc.php-357- // Fetch all swift stores openstack-cluster-installer-31/src/inc/enc.php:358: $q = "SELECT machines.hostname AS hostname, machines.id AS nodeid, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips, networks WHERE ips.network=networks.id AND networks.role!='ipmi' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND machines.role='swiftstore' AND machines.cluster='$cluster_id' AND machines.id=ips.machine"; openstack-cluster-installer-31/src/inc/enc.php:359: // $q = "SELECT machines.hostname AS hostname, machines.id AS nodeid, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips WHERE machines.role='swiftstore' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network='$network_id'"; openstack-cluster-installer-31/src/inc/enc.php-360- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-377- // Fetch all swift proxies openstack-cluster-installer-31/src/inc/enc.php:378: $q = "SELECT machines.hostname AS hostname, machines.id AS nodeid, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips, networks WHERE networks.id=ips.network AND networks.role!='ipmi' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND machines.role='swiftproxy' AND machines.cluster='$cluster_id' AND machines.id=ips.machine"; openstack-cluster-installer-31/src/inc/enc.php-379- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-397- // Get the number of compute nodes openstack-cluster-installer-31/src/inc/enc.php:398: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='compute'"; openstack-cluster-installer-31/src/inc/enc.php-399- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-407- // Get the number of network nodes openstack-cluster-installer-31/src/inc/enc.php:408: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='network'"; openstack-cluster-installer-31/src/inc/enc.php-409- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-417- // Get the number of swiftstore nodes openstack-cluster-installer-31/src/inc/enc.php:418: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='swiftstore'"; openstack-cluster-installer-31/src/inc/enc.php-419- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-427- // Get the number of volume nodes openstack-cluster-installer-31/src/inc/enc.php:428: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='volume'"; openstack-cluster-installer-31/src/inc/enc.php-429- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-437- // Get the number of cephosd nodes openstack-cluster-installer-31/src/inc/enc.php:438: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='cephosd'"; openstack-cluster-installer-31/src/inc/enc.php-439- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-447- // Get the number of cephmon nodes openstack-cluster-installer-31/src/inc/enc.php:448: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='cephmon'"; openstack-cluster-installer-31/src/inc/enc.php-449- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-490- $first_master_machine_id = $cluster["first_master_machine_id"]; openstack-cluster-installer-31/src/inc/enc.php:491: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips, networks WHERE machines.id='$first_master_machine_id' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND networks.role!='ipmi'"; openstack-cluster-installer-31/src/inc/enc.php-492- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-509- # Otherwise, we have a list of bridge from db. openstack-cluster-installer-31/src/inc/enc.php:510: $q = "SELECT bridgename FROM networks WHERE cluster='$cluster_id' AND role='ovs-bridge'"; openstack-cluster-installer-31/src/inc/enc.php-511- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-545- openstack-cluster-installer-31/src/inc/enc.php:546: $q_ext_net_name = "SELECT DISTINCT neutron_external_network_name FROM machines WHERE (role='compute' OR role='network') AND cluster='$cluster_id'"; openstack-cluster-installer-31/src/inc/enc.php-547- $r_ext_net_name = mysqli_query($con, $q_ext_net_name); ############################################## openstack-cluster-installer-31/src/inc/enc.php-572- # See if we have machines with role SQL, if yes, find who's first_sql_machine_id. openstack-cluster-installer-31/src/inc/enc.php:573: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='sql'"; openstack-cluster-installer-31/src/inc/enc.php-574- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-581- openstack-cluster-installer-31/src/inc/enc.php:582: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='controller'"; openstack-cluster-installer-31/src/inc/enc.php-583- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-605- // Get the first_sql sql node openstack-cluster-installer-31/src/inc/enc.php:606: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips, networks WHERE machines.id='$first_sql_machine_id' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND networks.role!='ipmi'"; openstack-cluster-installer-31/src/inc/enc.php-607- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-633- } openstack-cluster-installer-31/src/inc/enc.php:634: $q = "SELECT machines.hostname AS hostname, machines.id AS nodeid, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips, networks WHERE machines.role='$qrole' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND networks.role!='ipmi'"; openstack-cluster-installer-31/src/inc/enc.php-635- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-653- $enc_non_master_sql_ip = " non_master_sql_ip:\n"; openstack-cluster-installer-31/src/inc/enc.php:654: $q = "SELECT machines.hostname AS hostname, machines.id AS nodeid, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips, networks WHERE machines.role='$qrole' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND networks.role!='ipmi' AND machines.hostname!='$first_sql_hostname'"; openstack-cluster-installer-31/src/inc/enc.php-655- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-670- openstack-cluster-installer-31/src/inc/enc.php:671: $q = "SELECT INET_NTOA(ips.ip) AS ipaddr, networks.iface1 AS iface1, networks.iface2 AS iface2, networks.vlan AS vlan, networks.cidr AS cidr FROM ips,networks WHERE ips.usefor='vip' AND ips.vip_usage='$vip_usage' AND networks.cluster='$cluster_id' AND ips.network=networks.id"; openstack-cluster-installer-31/src/inc/enc.php-672- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-712- $enc_file .= " - 127.0.0.1\n"; openstack-cluster-installer-31/src/inc/enc.php:713: $q = "SELECT INET_NTOA(ips.ip) AS ipaddr FROM machines, ips, networks WHERE machines.id='$machine_id' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role!='ovs-bridge' AND networks.role!='ipmi'"; openstack-cluster-installer-31/src/inc/enc.php-714- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-741- if($machine["role"] == "volume" && $cluster["generate_root_ssh_keys"] == "yes"){ openstack-cluster-installer-31/src/inc/enc.php:742: $q = "SELECT hostname FROM machines WHERE role='volume' AND cluster='$cluster_id' AND id!='$machine_id'"; openstack-cluster-installer-31/src/inc/enc.php-743- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-861- // SQL queries from them, as cinder-volume may run there. openstack-cluster-installer-31/src/inc/enc.php:862: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips, networks WHERE machines.role='compute' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND networks.role!='ipmi'"; openstack-cluster-installer-31/src/inc/enc.php-863- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-882- // Same with volume nodes openstack-cluster-installer-31/src/inc/enc.php:883: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips, networks WHERE machines.role='volume' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND networks.role!='ipmi'"; openstack-cluster-installer-31/src/inc/enc.php-884- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-903- // Get the IP for VM trafic. openstack-cluster-installer-31/src/inc/enc.php:904: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr, networks.mtu AS mtu FROM machines, ips, networks WHERE machines.id='$machine_id' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role='vm-net'"; openstack-cluster-installer-31/src/inc/enc.php-905- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-928- // Fetch all other controllers (ie: all but this machine we're setting-up) openstack-cluster-installer-31/src/inc/enc.php:929: $qnfmc = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips, networks WHERE machines.role='controller' AND machines.cluster='$cluster_id' AND machines.id != '".$cluster["first_master_machine_id"]."' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND networks.role!='ipmi'"; openstack-cluster-installer-31/src/inc/enc.php-930- $rnfmc = mysqli_query($con, $qnfmc); ############################################## openstack-cluster-installer-31/src/inc/enc.php-962- // Fetch all other controllers (ie: all but this machine we're setting-up) openstack-cluster-installer-31/src/inc/enc.php:963: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr FROM machines, ips, networks WHERE machines.role='controller' AND machines.cluster='$cluster_id' AND machines.id != '$machine_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND networks.role!='ipmi'"; openstack-cluster-installer-31/src/inc/enc.php-964- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-1373- openstack-cluster-installer-31/src/inc/enc.php:1374: $qgpu = "SELECT use_gpu,gpu_name,gpu_vendor_id,gpu_product_id,gpu_device_type FROM machines WHERE cluster='$cluster_id' AND use_gpu='yes'"; openstack-cluster-installer-31/src/inc/enc.php-1375- $rgpu = mysqli_query($con, $qgpu); ############################################## openstack-cluster-installer-31/src/inc/enc.php-1385- $enc_file .= " use_gpu: true\n"; openstack-cluster-installer-31/src/inc/enc.php:1386: $qgpu = "SELECT DISTINCT use_gpu,gpu_name,gpu_vendor_id,gpu_product_id,gpu_device_type FROM machines WHERE cluster='$cluster_id' AND use_gpu='yes'"; openstack-cluster-installer-31/src/inc/enc.php-1387- $rgpu = mysqli_query($con, $qgpu); ############################################## openstack-cluster-installer-31/src/inc/enc.php-1418- # controller if we have one. openstack-cluster-installer-31/src/inc/enc.php:1419: $qdragent = "SELECT id FROM machines WHERE cluster='$cluster_id' AND neutron_install_dragent='yes'"; openstack-cluster-installer-31/src/inc/enc.php-1420- $rdragent = mysqli_query($con, $qdragent); ############################################## openstack-cluster-installer-31/src/inc/enc.php-1595- openstack-cluster-installer-31/src/inc/enc.php:1596: $q = "SELECT swiftregions.id AS region_id FROM machines,locations,swiftregions WHERE locations.swiftregion=swiftregions.name AND locations.id=machines.location_id AND machines.id='$machine_id'"; openstack-cluster-installer-31/src/inc/enc.php-1597- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-1630- openstack-cluster-installer-31/src/inc/enc.php:1631: $qexpir = "SELECT hostname FROM machines WHERE cluster='$cluster_id' AND role='swiftproxy' LIMIT 1"; openstack-cluster-installer-31/src/inc/enc.php-1632- $rexpir = mysqli_query($con, $qexpir); ############################################## openstack-cluster-installer-31/src/inc/enc.php-1674- if($machine["install_on_raid"] == "no"){ openstack-cluster-installer-31/src/inc/enc.php:1675: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '%da'"; openstack-cluster-installer-31/src/inc/enc.php-1676- }else{ ############################################## openstack-cluster-installer-31/src/inc/enc.php-1679- case "1": openstack-cluster-installer-31/src/inc/enc.php:1680: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '".$machine["raid_dev0"]."' AND name NOT LIKE '".$machine["raid_dev1"]."'"; openstack-cluster-installer-31/src/inc/enc.php-1681- break; openstack-cluster-installer-31/src/inc/enc.php-1682- case "10": openstack-cluster-installer-31/src/inc/enc.php:1683: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '".$machine["raid_dev0"]."' AND name NOT LIKE '".$machine["raid_dev1"]."' AND name NOT LIKE '".$machine["raid_dev2"]."' AND name NOT LIKE '".$machine["raid_dev3"]."'"; openstack-cluster-installer-31/src/inc/enc.php-1684- break; ############################################## openstack-cluster-installer-31/src/inc/enc.php-1717- if($machine["install_on_raid"] == "no"){ openstack-cluster-installer-31/src/inc/enc.php:1718: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '%da'"; openstack-cluster-installer-31/src/inc/enc.php-1719- }else{ ############################################## openstack-cluster-installer-31/src/inc/enc.php-1722- case "1": openstack-cluster-installer-31/src/inc/enc.php:1723: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '".$machine["raid_dev0"]."' AND name NOT LIKE '".$machine["raid_dev1"]."'"; openstack-cluster-installer-31/src/inc/enc.php-1724- break; openstack-cluster-installer-31/src/inc/enc.php-1725- case "10": openstack-cluster-installer-31/src/inc/enc.php:1726: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '".$machine["raid_dev0"]."' AND name NOT LIKE '".$machine["raid_dev1"]."' AND name NOT LIKE '".$machine["raid_dev2"]."' AND name NOT LIKE '".$machine["raid_dev3"]."'"; openstack-cluster-installer-31/src/inc/enc.php-1727- break; ############################################## openstack-cluster-installer-31/src/inc/enc.php-1803- // Get the IP for VM trafic. openstack-cluster-installer-31/src/inc/enc.php:1804: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr, networks.mtu AS mtu FROM machines, ips, networks WHERE machines.id='$machine_id' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role='vm-net'"; openstack-cluster-installer-31/src/inc/enc.php-1805- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-1857- # compute if we have one. openstack-cluster-installer-31/src/inc/enc.php:1858: $qdragent = "SELECT id FROM machines WHERE cluster='$cluster_id' AND neutron_install_dragent='yes'"; openstack-cluster-installer-31/src/inc/enc.php-1859- $rdragent = mysqli_query($con, $qdragent); ############################################## openstack-cluster-installer-31/src/inc/enc.php-1875- # See if there's some controllers in the clusters that aren't full installed yet openstack-cluster-installer-31/src/inc/enc.php:1876: $q = "SELECT COUNT(id) AS numnotinstalled FROM machines WHERE role='controller' AND cluster='$cluster_id' AND (status!='installed' OR puppet_status!='success');"; openstack-cluster-installer-31/src/inc/enc.php-1877- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-1910- openstack-cluster-installer-31/src/inc/enc.php:1911: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '%da'"; openstack-cluster-installer-31/src/inc/enc.php-1912- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-1952- // Get the IP for the cluster network. openstack-cluster-installer-31/src/inc/enc.php:1953: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr, networks.mtu AS mtu, networks.ip AS networkaddr, networks.cidr AS networkcidr FROM machines, ips, networks WHERE machines.id='$machine_id' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role='ceph-cluster' AND networks.role='ipmi'"; openstack-cluster-installer-31/src/inc/enc.php-1954- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-2003- // Get the IP for VM trafic. openstack-cluster-installer-31/src/inc/enc.php:2004: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr, networks.mtu AS mtu FROM machines, ips, networks WHERE machines.id='$machine_id' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role='vm-net'"; openstack-cluster-installer-31/src/inc/enc.php-2005- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-2200- openstack-cluster-installer-31/src/inc/enc.php:2201: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '%da'"; openstack-cluster-installer-31/src/inc/enc.php-2202- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-2217- # compute if we have one. openstack-cluster-installer-31/src/inc/enc.php:2218: $qdragent = "SELECT id FROM machines WHERE cluster='$cluster_id' AND neutron_install_dragent='yes'"; openstack-cluster-installer-31/src/inc/enc.php-2219- $rdragent = mysqli_query($con, $qdragent); ############################################## openstack-cluster-installer-31/src/inc/enc.php-2245- openstack-cluster-installer-31/src/inc/enc.php:2246: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '%da'"; openstack-cluster-installer-31/src/inc/enc.php-2247- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-2287- // Get the IP for the cluster network. openstack-cluster-installer-31/src/inc/enc.php:2288: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr, networks.mtu AS mtu, networks.ip AS networkaddr, networks.cidr AS networkcidr FROM machines, ips, networks WHERE machines.id='$machine_id' AND machines.cluster='$cluster_id' AND machines.id=ips.machine AND ips.network=networks.id AND networks.is_public='no' AND networks.role='ceph-cluster' AND networks.role='ipmi'"; openstack-cluster-installer-31/src/inc/enc.php-2289- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/enc.php-2378- if($machine["install_on_raid"] == "no"){ openstack-cluster-installer-31/src/inc/enc.php:2379: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '%da'"; openstack-cluster-installer-31/src/inc/enc.php-2380- }else{ ############################################## openstack-cluster-installer-31/src/inc/enc.php-2383- case "1": openstack-cluster-installer-31/src/inc/enc.php:2384: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '".$machine["raid_dev0"]."' AND name NOT LIKE '".$machine["raid_dev1"]."'"; openstack-cluster-installer-31/src/inc/enc.php-2385- break; openstack-cluster-installer-31/src/inc/enc.php-2386- case "10": openstack-cluster-installer-31/src/inc/enc.php:2387: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '".$machine["raid_dev0"]."' AND name NOT LIKE '".$machine["raid_dev1"]."' AND name NOT LIKE '".$machine["raid_dev2"]."' AND name NOT LIKE '".$machine["raid_dev3"]."'"; openstack-cluster-installer-31/src/inc/enc.php-2388- break; ############################################## openstack-cluster-installer-31/src/inc/forms.php-19- } openstack-cluster-installer-31/src/inc/forms.php:20: $q = "SELECT * FROM machines WHERE id='$safe_machine_id'"; openstack-cluster-installer-31/src/inc/forms.php-21- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/forms.php-107- $blockdevs = ""; openstack-cluster-installer-31/src/inc/forms.php:108: $q = "SELECT MIN(name) AS first_dev, MAX(name) AS last_dev,size_mb, COUNT(id) AS numdev FROM blockdevices WHERE machine_id='".$a["id"]."' GROUP BY size_mb ORDER BY name"; openstack-cluster-installer-31/src/inc/forms.php-109- $r2 = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/forms.php-122- $ifaces = ""; openstack-cluster-installer-31/src/inc/forms.php:123: $r2 = mysqli_query($con, "SELECT MIN(name) AS first_dev, MAX(name) AS last_dev, COUNT(id) AS numdev, name, macaddr, max_speed FROM ifnames WHERE machine_id='".$a["id"]."' GROUP BY max_speed ORDER BY name"); openstack-cluster-installer-31/src/inc/forms.php-124- $n2 = mysqli_num_rows($r2); ############################################## openstack-cluster-installer-31/src/inc/forms.php-140- $ifaces_tooltip = ""; openstack-cluster-installer-31/src/inc/forms.php:141: $r2 = mysqli_query($con, "SELECT * FROM ifnames WHERE machine_id='".$a["id"]."'"); openstack-cluster-installer-31/src/inc/forms.php-142- $n2 = mysqli_num_rows($r2); ############################################## openstack-cluster-installer-31/src/inc/forms.php-219-function get_machine_id_from_ip($con, $safe_ip){ openstack-cluster-installer-31/src/inc/forms.php:220: $r = mysqli_query($con, "SELECT * FROM machines WHERE ipaddr='$safe_ip'"); openstack-cluster-installer-31/src/inc/forms.php-221- $n = mysqli_num_rows($r); ############################################## openstack-cluster-installer-31/src/inc/forms.php-351- // Get all role counts for this cluster openstack-cluster-installer-31/src/inc/forms.php:352: $q = "SELECT * FROM rolecounts WHERE cluster='$cluster_id'"; openstack-cluster-installer-31/src/inc/forms.php-353- $r_role_counts = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/forms.php-358- $role_id = $a_role["role"]; openstack-cluster-installer-31/src/inc/forms.php:359: $q = "SELECT name FROM roles WHERE id='$role_id'"; openstack-cluster-installer-31/src/inc/forms.php-360- $r_role_name = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/forms.php-363- // Count how many machines by that role on this cluster openstack-cluster-installer-31/src/inc/forms.php:364: $q = "SELECT count(role) AS rolecount FROM machines WHERE cluster='$cluster_id' AND role='$role_name'"; openstack-cluster-installer-31/src/inc/forms.php-365- $res = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/forms.php-377- ///////////////////////////////// openstack-cluster-installer-31/src/inc/forms.php:378: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='controller'"; openstack-cluster-installer-31/src/inc/forms.php-379- $r_fm = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/forms.php-409- openstack-cluster-installer-31/src/inc/forms.php:410: $q_n = "SELECT * FROM networks WHERE cluster='$cluster_id'"; openstack-cluster-installer-31/src/inc/forms.php-411- $r_n = mysqli_query($con, $q_n); ############################################## openstack-cluster-installer-31/src/inc/forms.php-437- openstack-cluster-installer-31/src/inc/forms.php:438: $qnl = "SELECT * FROM locations WHERE id='$n_locid'"; openstack-cluster-installer-31/src/inc/forms.php-439- $rnl = mysqli_query($con, $qnl); ############################################## openstack-cluster-installer-31/src/inc/forms.php-445- } openstack-cluster-installer-31/src/inc/forms.php:446: $q_vip = "SELECT INET_NTOA(ip) AS addr FROM ips WHERE network='$n_id' AND usefor='vip'"; openstack-cluster-installer-31/src/inc/forms.php-447- $r_vip = mysqli_query($con, $q_vip); ############################################## openstack-cluster-installer-31/src/inc/forms.php-552- $out .= "<h2>Machines in the cluster</h2>"; openstack-cluster-installer-31/src/inc/forms.php:553: $rm = mysqli_query($con, "SELECT * FROM machines WHERE cluster='".$a["id"]."' ORDER BY location_id,role"); openstack-cluster-installer-31/src/inc/forms.php-554- $nm = mysqli_num_rows($rm); ############################################## openstack-cluster-installer-31/src/inc/forms.php-560- $blockdevs = ""; openstack-cluster-installer-31/src/inc/forms.php:561: $q2 = "SELECT MIN(name) AS first_dev, MAX(name) AS last_dev,size_mb, COUNT(id) AS numdev FROM blockdevices WHERE machine_id='".$am["id"]."' GROUP BY size_mb ORDER BY name"; openstack-cluster-installer-31/src/inc/forms.php-562- $r2 = mysqli_query($con, $q2); ############################################## openstack-cluster-installer-31/src/inc/forms.php-572- openstack-cluster-installer-31/src/inc/forms.php:573: $q_mip = "SELECT INET_NTOA(ip) AS addr FROM ips WHERE machine='".$am["id"]."' ORDER BY network"; openstack-cluster-installer-31/src/inc/forms.php-574- $r_mip = mysqli_query($con, $q_mip); ############################################## openstack-cluster-installer-31/src/inc/forms.php-587- openstack-cluster-installer-31/src/inc/forms.php:588: $qloc = "SELECT name FROM locations WHERE id='".$am["location_id"]."'"; openstack-cluster-installer-31/src/inc/forms.php-589- $rloc = mysqli_query($con, $qloc); ############################################## openstack-cluster-installer-31/src/inc/forms.php-613- $blockdevs = ""; openstack-cluster-installer-31/src/inc/forms.php:614: $q2 = "SELECT MIN(name) AS first_dev, MAX(name) AS last_dev,size_mb, COUNT(id) AS numdev FROM blockdevices WHERE machine_id='".$am["id"]."' GROUP BY size_mb ORDER BY name"; openstack-cluster-installer-31/src/inc/forms.php-615- $r2 = mysqli_query($con, $q2); ############################################## openstack-cluster-installer-31/src/inc/hardware_profile.php-6- openstack-cluster-installer-31/src/inc/hardware_profile.php:7: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/hardware_profile.php-8- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/hardware_profile.php-22- # Fetch all block devices behind RAID controllers openstack-cluster-installer-31/src/inc/hardware_profile.php:23: $q = "SELECT * FROM physblockdevices WHERE machine_id='$machine_id' ORDER BY slot"; openstack-cluster-installer-31/src/inc/hardware_profile.php-24- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/hardware_profile.php-38- # Fetch all block devices openstack-cluster-installer-31/src/inc/hardware_profile.php:39: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id'"; openstack-cluster-installer-31/src/inc/hardware_profile.php-40- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/hardware_profile.php-420- $return_var = 0; openstack-cluster-installer-31/src/inc/hardware_profile.php:421: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/hardware_profile.php-422- } ############################################## openstack-cluster-installer-31/src/inc/hardware_profile.php-620- // Find the 1st controller of the cluster openstack-cluster-installer-31/src/inc/hardware_profile.php:621: $q = "SELECT first_master_machine_id FROM clusters WHERE id='".$machine["cluster"]."'"; openstack-cluster-installer-31/src/inc/hardware_profile.php-622- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/hardware_profile.php-637- // Find the IP address of the 1st controller openstack-cluster-installer-31/src/inc/hardware_profile.php:638: $q = "SELECT ipaddr FROM machines WHERE id='$first_master_machine_id'"; openstack-cluster-installer-31/src/inc/hardware_profile.php-639- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/ipmi_cmds.php-6- openstack-cluster-installer-31/src/inc/ipmi_cmds.php:7: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/ipmi_cmds.php-8- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/ipmi_cmds.php-278-function automatic_ipmi_assign($con, $conf, $machine_id){ openstack-cluster-installer-31/src/inc/ipmi_cmds.php:279: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/ipmi_cmds.php-280- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/ipmi_cmds.php-314- # Set the ipmi_set_in_progress lock openstack-cluster-installer-31/src/inc/ipmi_cmds.php:315: $qlock = "UPDATE machines SET ipmi_set_in_progress='yes' WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/ipmi_cmds.php-316- mysqli_query($con, $qlock); ############################################## openstack-cluster-installer-31/src/inc/ipmi_cmds.php-450- # We simply get rid of all IPMI IPs for that machine, so we get back on case 1/. openstack-cluster-installer-31/src/inc/ipmi_cmds.php:451: $qcheckwrong = "SELECT * FROM ips WHERE machine='".$machine["id"]."' AND usefor='ipmi'"; openstack-cluster-installer-31/src/inc/ipmi_cmds.php-452- $rcheckwrong = mysqli_query($con, $qcheckwrong); ############################################## openstack-cluster-installer-31/src/inc/ipmi_cmds.php-454- if($ncheckwrong >= 0){ openstack-cluster-installer-31/src/inc/ipmi_cmds.php:455: $q_remove_ip = "DELETE FROM ips WHERE machine='".$machine["id"]."' AND usefor='ipmi'"; openstack-cluster-installer-31/src/inc/ipmi_cmds.php-456- $r_remove_ip = mysqli_query($con, $q_remove_ip); ############################################## openstack-cluster-installer-31/src/inc/ipmi_cmds.php-473- $hex = base64_encode(openssl_random_pseudo_bytes(9, $crypto_strong)); openstack-cluster-installer-31/src/inc/ipmi_cmds.php:474: $qmachine = "UPDATE machines SET ipmi_use='yes', ipmi_call_chassis_bootdev='yes', ipmi_addr='$ipmi_addr', ipmi_netmask='$ipmi_netmask', ipmi_default_gw='$ipmi_net_def_gateway', ipmi_vlan='$net_vlan', ipmi_username='". $conf["ipmi"]["automatic_ipmi_username"] ."', ipmi_password='$hex' WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/ipmi_cmds.php-475- mysqli_query($con, $qmachine); ############################################## openstack-cluster-installer-31/src/inc/ipmi_cmds.php-479-# }else{ openstack-cluster-installer-31/src/inc/ipmi_cmds.php:480:# $qmachine = "UPDATE machines SET ipmi_use='yes', ipmi_call_chassis_bootdev='yes', ipmi_addr='$ipmi_addr', ipmi_netmask='$ipmi_netmask', ipmi_vlan='$net_vlan', ipmi_username='". $conf["ipmi"]["automatic_ipmi_username"] ."', ipmi_password='$hex' WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/ipmi_cmds.php-481-# mysqli_query($con, $qmachine); ############################################## openstack-cluster-installer-31/src/inc/ipmi_cmds.php-485- # Release the ipmi_set_in_progress lock openstack-cluster-installer-31/src/inc/ipmi_cmds.php:486: $qlock = "UPDATE machines SET ipmi_set_in_progress='no' WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/ipmi_cmds.php-487- mysqli_query($con, $qlock); ############################################## openstack-cluster-installer-31/src/inc/ipmi_cmds.php-522- # We have a match, check if the IPMI IP addr is in the db. openstack-cluster-installer-31/src/inc/ipmi_cmds.php:523: $qip = "SELECT * FROM ips WHERE network='$network_id' AND machine='$machine_id' AND usefor='ipmi'"; openstack-cluster-installer-31/src/inc/ipmi_cmds.php-524- $rip = mysqli_query($con, $qip); ############################################## openstack-cluster-installer-31/src/inc/ipmi_cmds.php-530- # IPs that are conflicting?) openstack-cluster-installer-31/src/inc/ipmi_cmds.php:531: $qipcheck = "SELECT * FROM ips WHERE ip='$machine_ipmi_addr_long'"; openstack-cluster-installer-31/src/inc/ipmi_cmds.php-532- $ripcheck = mysqli_query($con, $qipcheck); ############################################## openstack-cluster-installer-31/src/inc/plugin_dns.php-4- if($ignore_dot_ini_activation=='yes' || $conf["dns_plugin"]["call_dns_shell_script"]){ openstack-cluster-installer-31/src/inc/plugin_dns.php:5: $q = "SELECT INET_NTOA( ips.ip ) AS ipaddr FROM ips,machines,networks WHERE machines.id='".$machine["id"]."' " openstack-cluster-installer-31/src/inc/plugin_dns.php-6- ."AND ips.machine=machines.id AND ips.network=networks.id AND networks.role!='ipmi' " ############################################## openstack-cluster-installer-31/src/inc/plugin_dns.php-22- $return_var = 0; openstack-cluster-installer-31/src/inc/plugin_dns.php:23: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/plugin_dns.php-24- } ############################################## openstack-cluster-installer-31/src/inc/plugin_dns.php-30- if($ignore_dot_ini_activation=='yes' || $conf["dns_plugin"]["call_dns_shell_script"]){ openstack-cluster-installer-31/src/inc/plugin_dns.php:31: $q = "SELECT INET_NTOA( ips.ip ) AS ipaddr FROM ips,machines,networks WHERE machines.id='".$machine["id"]."' " openstack-cluster-installer-31/src/inc/plugin_dns.php-32- ."AND ips.machine=machines.id AND ips.network=networks.id AND networks.role!='ipmi' " ############################################## openstack-cluster-installer-31/src/inc/plugin_dns.php-48- $return_var = 0; openstack-cluster-installer-31/src/inc/plugin_dns.php:49: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/plugin_dns.php-50- } ############################################## openstack-cluster-installer-31/src/inc/plugin_monitoring.php-4- if($ignore_dot_ini_activation == 'yes' || $conf["monitoring_plugin"]["call_monitoring_plugin"]){ openstack-cluster-installer-31/src/inc/plugin_monitoring.php:5: $q = "SELECT INET_NTOA( ips.ip ) AS ipaddr FROM ips,machines,networks WHERE machines.id='".$machine["id"]."' " openstack-cluster-installer-31/src/inc/plugin_monitoring.php-6- ."AND ips.machine=machines.id AND ips.network=networks.id AND networks.role!='ipmi' " ############################################## openstack-cluster-installer-31/src/inc/plugin_monitoring.php-19- openstack-cluster-installer-31/src/inc/plugin_monitoring.php:20: $q = "SELECT * FROM ifnames WHERE switchport_name!='unknown' AND switch_hostname!='unknown' AND machine_id='".$machine["id"]."' LIMIT 1"; openstack-cluster-installer-31/src/inc/plugin_monitoring.php-21- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/plugin_monitoring.php-37- $return_var = 0; openstack-cluster-installer-31/src/inc/plugin_monitoring.php:38: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/plugin_monitoring.php-39- } ############################################## openstack-cluster-installer-31/src/inc/plugin_monitoring.php-50- $return_var = 0; openstack-cluster-installer-31/src/inc/plugin_monitoring.php:51: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/plugin_monitoring.php-52- } ############################################## openstack-cluster-installer-31/src/inc/plugin_root_pass.php-16- $return_var = 0; openstack-cluster-installer-31/src/inc/plugin_root_pass.php:17: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/plugin_root_pass.php-18- } ############################################## openstack-cluster-installer-31/src/inc/plugin_root_pass.php-31- $return_var = 0; openstack-cluster-installer-31/src/inc/plugin_root_pass.php:32: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/plugin_root_pass.php-33- } ############################################## openstack-cluster-installer-31/src/inc/read_conf.php-12- $output = ""; openstack-cluster-installer-31/src/inc/read_conf.php:13: exec("ipcalc $cidr | grep HostMin | awk '{print \$2}'", $output); openstack-cluster-installer-31/src/inc/read_conf.php-14- $conf["network"]["hostmin"] = $output[0]; openstack-cluster-installer-31/src/inc/read_conf.php-15- $output = ""; openstack-cluster-installer-31/src/inc/read_conf.php:16: exec("ipcalc $cidr | grep HostMax | awk '{print \$2}'", $output); openstack-cluster-installer-31/src/inc/read_conf.php-17- $conf["network"]["hostmax"] = $output[0]; openstack-cluster-installer-31/src/inc/read_conf.php-18- $output = ""; openstack-cluster-installer-31/src/inc/read_conf.php:19: exec("ipcalc $cidr | grep Netmask | awk '{print \$2}'", $output); openstack-cluster-installer-31/src/inc/read_conf.php-20- $conf["network"]["netmask"] = $output[0]; openstack-cluster-installer-31/src/inc/read_conf.php-21- $output = ""; openstack-cluster-installer-31/src/inc/read_conf.php:22: exec("ipcalc $cidr | grep Broadcast | awk '{print \$2}'", $output); openstack-cluster-installer-31/src/inc/read_conf.php-23- $conf["network"]["broadcast"] = $output[0]; ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-7- # Fetch cluster name and domain openstack-cluster-installer-31/src/inc/slave_actions.php:8: $q = "SELECT * FROM clusters WHERE id='$cluster_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-9- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-25- # Fetch role ID openstack-cluster-installer-31/src/inc/slave_actions.php:26: $q = "SELECT * FROM roles WHERE name='$role_name'"; openstack-cluster-installer-31/src/inc/slave_actions.php-27- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-45- # the current role count for the node we're adding. openstack-cluster-installer-31/src/inc/slave_actions.php:46: $q = "SELECT * FROM rolecounts WHERE cluster='$cluster_id' AND role='$role_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-47- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-69- openstack-cluster-installer-31/src/inc/slave_actions.php:70: $q = "UPDATE rolecounts SET count='$safe_role_count' WHERE id='$safe_role_count_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-71- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-81- if($role_name == "controller"){ openstack-cluster-installer-31/src/inc/slave_actions.php:82: $q = "SELECT id FROM machines WHERE role='controller' AND cluster='$cluster_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-83- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-90- if($n == 0){ openstack-cluster-installer-31/src/inc/slave_actions.php:91: $q = "UPDATE clusters SET first_master_machine_id='$machine_id' WHERE id='$cluster_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-92- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-109- if($role_name == "sql"){ openstack-cluster-installer-31/src/inc/slave_actions.php:110: $q = "SELECT id FROM machines WHERE role='sql' AND cluster='$cluster_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-111- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-118- openstack-cluster-installer-31/src/inc/slave_actions.php:119: $q = "SELECT id FROM machines WHERE role='controller' AND cluster='$cluster_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-120- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-129- if($num_sql_nodes == 0 && $num_controller_nodes == 0){ openstack-cluster-installer-31/src/inc/slave_actions.php:130: $q = "SELECT * FROM networks WHERE cluster='$cluster_id' AND location_id='$location_id' AND role!='vm-net' AND role!='ovs-bridge' AND role!='ceph-cluster' AND role!='ipmi' LIMIT 1"; openstack-cluster-installer-31/src/inc/slave_actions.php-131- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-146- if($num_sql_nodes == 0 && $role_name == "sql"){ openstack-cluster-installer-31/src/inc/slave_actions.php:147: $q = "UPDATE clusters SET first_sql_machine_id='$machine_id' WHERE id='$cluster_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-148- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-157- if($num_sql_nodes == 0 && $num_controller_nodes == 0 && $role_name == "controller"){ openstack-cluster-installer-31/src/inc/slave_actions.php:158: $q = "UPDATE clusters SET first_sql_machine_id='$machine_id' WHERE id='$cluster_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-159- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-170- $safe_hostname = $cluster_name . "-" . $role_name . "-" . $safe_role_count . "." . $cluster_domain; openstack-cluster-installer-31/src/inc/slave_actions.php:171: $q = "UPDATE machines SET cluster='$cluster_id', role='$role_name', hostname='$safe_hostname', location_id='$location_id' WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-172- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-182- if($role_name == "swiftproxy"){ openstack-cluster-installer-31/src/inc/slave_actions.php:183: $q = "UPDATE machines SET swift_store_account='no', swift_store_container='no', swift_store_object='no' WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-184- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-195- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:196: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-197- openstack-cluster-installer-31/src/inc/slave_actions.php-198- // Insert the machine into the DNS openstack-cluster-installer-31/src/inc/slave_actions.php:199: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-200- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-225- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:226: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-227- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-256- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:257: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-258- $hex = $output[0]; ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-267- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:268: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-269- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-295- // Check if cluster exists openstack-cluster-installer-31/src/inc/slave_actions.php:296: $r = mysqli_query($con, "SELECT * FROM clusters WHERE name='$cluster_name'"); openstack-cluster-installer-31/src/inc/slave_actions.php-297- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-408- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:409: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-410- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-418- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:419: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-420- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-427- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:428: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-429- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-435- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:436: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-437- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-444- openstack-cluster-installer-31/src/inc/slave_actions.php:445: $q = "SELECT * FROM clusters WHERE name='$cluster_name'"; openstack-cluster-installer-31/src/inc/slave_actions.php-446- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-460- openstack-cluster-installer-31/src/inc/slave_actions.php:461: $q = "DELETE FROM passwords WHERE cluster='$cluster_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-462- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-468- openstack-cluster-installer-31/src/inc/slave_actions.php:469: $q = "DELETE FROM clusters WHERE name='$cluster_name'"; openstack-cluster-installer-31/src/inc/slave_actions.php-470- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-487- // Fetch the machine openstack-cluster-installer-31/src/inc/slave_actions.php:488: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-489- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-501- // Fetch its network openstack-cluster-installer-31/src/inc/slave_actions.php:502: $q = "SELECT * FROM networks WHERE cluster='$cluster_id' AND role='$role' AND location_id='$location_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-503- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-509- }else{ openstack-cluster-installer-31/src/inc/slave_actions.php:510: $q = "SELECT * FROM networks WHERE cluster='$cluster_id' AND role='norole' AND location_id='$location_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-511- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-517- openstack-cluster-installer-31/src/inc/slave_actions.php:518: $q = "SELECT * FROM networks WHERE cluster='$cluster_id' AND role='all' AND location_id='$location_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-519- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-525- if($role == 'network' or $role == 'compute'){ openstack-cluster-installer-31/src/inc/slave_actions.php:526: $q = "SELECT * FROM networks WHERE cluster='$cluster_id' AND (role='vm-net' OR role='ovs-bridge') AND location_id='$location_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-527- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-534- if($role == 'cephosd'){ openstack-cluster-installer-31/src/inc/slave_actions.php:535: $q = "SELECT * FROM networks WHERE cluster='$cluster_id' AND (role='ceph-cluster') AND location_id='$location_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-536- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-544- if($role == 'controller'){ openstack-cluster-installer-31/src/inc/slave_actions.php:545: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='network'"; openstack-cluster-installer-31/src/inc/slave_actions.php-546- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-548- if($n == 0){ openstack-cluster-installer-31/src/inc/slave_actions.php:549: $q = "SELECT * FROM networks WHERE cluster='$cluster_id' AND (role='vm-net' OR role='ovs-bridge') AND location_id='$location_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-550- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-567- // Fetch the network openstack-cluster-installer-31/src/inc/slave_actions.php:568: $q = "SELECT * FROM networks WHERE id='$network_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-569- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-578- // Fetch the machine openstack-cluster-installer-31/src/inc/slave_actions.php:579: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-580- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-588- openstack-cluster-installer-31/src/inc/slave_actions.php:589: $q = "SELECT INET_NTOA(ip) AS ipaddr FROM ips WHERE network='$network_id' AND machine='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-590- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-609- openstack-cluster-installer-31/src/inc/slave_actions.php:610: $q = "SELECT * FROM networks WHERE id='$network_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-611- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-646- openstack-cluster-installer-31/src/inc/slave_actions.php:647: $q = "UPDATE networks SET first_ip='$network_first_ip_long', last_ip='$network_last_ip_long' WHERE id='$network_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-648- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-655- // Check if there's either no IP left, or no IP provisionned yet. openstack-cluster-installer-31/src/inc/slave_actions.php:656: $q = "SELECT id FROM ips WHERE network='$network_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-657- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-669- // See if the first IP of the range can be used openstack-cluster-installer-31/src/inc/slave_actions.php:670: $q = "SELECT ips.ip FROM ips WHERE ip='$network_first_ip_long' AND ips.network='$network_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-671- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-677- // Get first IP address available in the range (find out what "hole" we have, or get the last IP +1). openstack-cluster-installer-31/src/inc/slave_actions.php:678: $q = "SELECT MIN(ips.ip + 1) AS nextIP FROM ips LEFT JOIN ips tf1 ON ips.ip + 1 = tf1.ip WHERE tf1.ip IS NULL AND ips.network='$network_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-679- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-713- openstack-cluster-installer-31/src/inc/slave_actions.php:714: $q = "SELECT role,location_id FROM networks WHERE id='$network_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-715- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-723- if($role == "vm-net"){ openstack-cluster-installer-31/src/inc/slave_actions.php:724: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='network'"; openstack-cluster-installer-31/src/inc/slave_actions.php-725- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-728- if($n > 0){ openstack-cluster-installer-31/src/inc/slave_actions.php:729: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND (role='network' OR role='compute') AND location_id='$location_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-730- }else{ openstack-cluster-installer-31/src/inc/slave_actions.php:731: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND (role='controller' OR role='compute') AND location_id='$location_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-732- } openstack-cluster-installer-31/src/inc/slave_actions.php-733- }elseif($role == "ceph-cluster"){ openstack-cluster-installer-31/src/inc/slave_actions.php:734: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='cephosd' AND location_id='$location_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-735- }elseif($role == "ovs-bridge"){ ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-738- if($role != "all"){ openstack-cluster-installer-31/src/inc/slave_actions.php:739: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='$role' AND location_id='$location_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-740- }else{ openstack-cluster-installer-31/src/inc/slave_actions.php:741: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND location_id='$location_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-742- } ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-774- // Fetch the machine openstack-cluster-installer-31/src/inc/slave_actions.php:775: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-776- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-807- for($i=0;$i<sizeof($machine_networks["networks"]);$i++){ openstack-cluster-installer-31/src/inc/slave_actions.php:808: $q = "SELECT INET_NTOA(ip) AS ipaddr FROM ips WHERE network='". $machine_networks["networks"][$i]["id"] ."' AND machine='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-809- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-845- case "10m1": openstack-cluster-installer-31/src/inc/slave_actions.php:846: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed='10' ORDER BY name LIMIT 1"; openstack-cluster-installer-31/src/inc/slave_actions.php-847- break; openstack-cluster-installer-31/src/inc/slave_actions.php-848- case "10m2": openstack-cluster-installer-31/src/inc/slave_actions.php:849: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed='10' ORDER BY name LIMIT 1,1"; openstack-cluster-installer-31/src/inc/slave_actions.php-850- break; openstack-cluster-installer-31/src/inc/slave_actions.php-851- case "10m3": openstack-cluster-installer-31/src/inc/slave_actions.php:852: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed='10' ORDER BY name LIMIT 2,1"; openstack-cluster-installer-31/src/inc/slave_actions.php-853- break; openstack-cluster-installer-31/src/inc/slave_actions.php-854- case "10m4": openstack-cluster-installer-31/src/inc/slave_actions.php:855: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed='10' ORDER BY name LIMIT 3,1"; openstack-cluster-installer-31/src/inc/slave_actions.php-856- break; openstack-cluster-installer-31/src/inc/slave_actions.php-857- case "100m1": openstack-cluster-installer-31/src/inc/slave_actions.php:858: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed='100' ORDER BY name LIMIT 1"; openstack-cluster-installer-31/src/inc/slave_actions.php-859- break; openstack-cluster-installer-31/src/inc/slave_actions.php-860- case "100m2": openstack-cluster-installer-31/src/inc/slave_actions.php:861: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed='100' ORDER BY name LIMIT 1,1"; openstack-cluster-installer-31/src/inc/slave_actions.php-862- break; openstack-cluster-installer-31/src/inc/slave_actions.php-863- case "100m3": openstack-cluster-installer-31/src/inc/slave_actions.php:864: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed='100' ORDER BY name LIMIT 2,1"; openstack-cluster-installer-31/src/inc/slave_actions.php-865- break; openstack-cluster-installer-31/src/inc/slave_actions.php-866- case "100m4": openstack-cluster-installer-31/src/inc/slave_actions.php:867: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed='100' ORDER BY name LIMIT 3,1"; openstack-cluster-installer-31/src/inc/slave_actions.php-868- break; openstack-cluster-installer-31/src/inc/slave_actions.php-869- case "1g1": openstack-cluster-installer-31/src/inc/slave_actions.php:870: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed='1000' ORDER BY name LIMIT 1"; openstack-cluster-installer-31/src/inc/slave_actions.php-871- break; openstack-cluster-installer-31/src/inc/slave_actions.php-872- case "1g2": openstack-cluster-installer-31/src/inc/slave_actions.php:873: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed='1000' ORDER BY name LIMIT 1,1"; openstack-cluster-installer-31/src/inc/slave_actions.php-874- break; openstack-cluster-installer-31/src/inc/slave_actions.php-875- case "1g3": openstack-cluster-installer-31/src/inc/slave_actions.php:876: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed='1000' ORDER BY name LIMIT 2,1"; openstack-cluster-installer-31/src/inc/slave_actions.php-877- break; openstack-cluster-installer-31/src/inc/slave_actions.php-878- case "1g4": openstack-cluster-installer-31/src/inc/slave_actions.php:879: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed='1000' ORDER BY name LIMIT 3,1"; openstack-cluster-installer-31/src/inc/slave_actions.php-880- break; openstack-cluster-installer-31/src/inc/slave_actions.php-881- case "10g1": openstack-cluster-installer-31/src/inc/slave_actions.php:882: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed>='10000' ORDER BY name LIMIT 1"; openstack-cluster-installer-31/src/inc/slave_actions.php-883- break; openstack-cluster-installer-31/src/inc/slave_actions.php-884- case "10g2": openstack-cluster-installer-31/src/inc/slave_actions.php:885: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed>='10000' ORDER BY name LIMIT 1,1"; openstack-cluster-installer-31/src/inc/slave_actions.php-886- break; openstack-cluster-installer-31/src/inc/slave_actions.php-887- case "10g3": openstack-cluster-installer-31/src/inc/slave_actions.php:888: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed>='10000' ORDER BY name LIMIT 2,1"; openstack-cluster-installer-31/src/inc/slave_actions.php-889- break; openstack-cluster-installer-31/src/inc/slave_actions.php-890- case "10g4": openstack-cluster-installer-31/src/inc/slave_actions.php:891: $qeth = "SELECT name FROM ifnames WHERE machine_id='$machine_id' AND max_speed>='10000' ORDER BY name LIMIT 3,1"; openstack-cluster-installer-31/src/inc/slave_actions.php-892- break; ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-914- // Fetch the machine openstack-cluster-installer-31/src/inc/slave_actions.php:915: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-916- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-927- // Get its block device openstack-cluster-installer-31/src/inc/slave_actions.php:928: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name LIKE '%a'"; openstack-cluster-installer-31/src/inc/slave_actions.php-929- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-981- openstack-cluster-installer-31/src/inc/slave_actions.php:982: $qc = "SELECT * FROM clusters WHERE id='$cluster_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-983- $rc = mysqli_query($con, $qc); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1118- // Get the number of compute nodes openstack-cluster-installer-31/src/inc/slave_actions.php:1119: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='compute'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1120- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1128- // Get the number of compute nodes openstack-cluster-installer-31/src/inc/slave_actions.php:1129: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='network'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1130- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1151- // Get its cluster name and fetch the additional package list for this node openstack-cluster-installer-31/src/inc/slave_actions.php:1152: $q = "SELECT * FROM clusters WHERE id='$cluster_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1153- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1213- if($machine["install_on_raid"] == "no"){ openstack-cluster-installer-31/src/inc/slave_actions.php:1214: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '%da' ORDER BY name"; openstack-cluster-installer-31/src/inc/slave_actions.php-1215- }else{ ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1218- case "1": openstack-cluster-installer-31/src/inc/slave_actions.php:1219: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '".$machine["raid_dev0"]."' AND name NOT LIKE '".$machine["raid_dev1"]."' ORDER BY name"; openstack-cluster-installer-31/src/inc/slave_actions.php-1220- break; openstack-cluster-installer-31/src/inc/slave_actions.php-1221- case "10": openstack-cluster-installer-31/src/inc/slave_actions.php:1222: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '".$machine["raid_dev0"]."' AND name NOT LIKE '".$machine["raid_dev1"]."' AND name NOT LIKE '".$machine["raid_dev2"]."' AND name NOT LIKE '".$machine["raid_dev3"]."' ORDER BY name"; openstack-cluster-installer-31/src/inc/slave_actions.php-1223- default: ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1266-function slave_calculate_hosts_file($con, $conf, $machine_id){ openstack-cluster-installer-31/src/inc/slave_actions.php:1267: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1268- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1280- if(!is_null($machine_cluster)){ openstack-cluster-installer-31/src/inc/slave_actions.php:1281: $q = "SELECT * FROM clusters WHERE id='$machine_cluster'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1282- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1299- openstack-cluster-installer-31/src/inc/slave_actions.php:1300: $q = "SELECT INET_NTOA(ips.ip) as ipaddr,networks.name AS networkname FROM ips,networks WHERE ips.machine='".$machine["id"]."' AND ips.network=networks.id AND networks.is_public='no' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND networks.role!='ipmi'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1301-# echo $q; ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1332- if(!is_null($machine_cluster)){ openstack-cluster-installer-31/src/inc/slave_actions.php:1333: $q = "SELECT * FROM networks WHERE cluster='$machine_cluster' AND is_public='yes' AND (role='all' OR role='controller') LIMIT 1"; openstack-cluster-installer-31/src/inc/slave_actions.php-1334- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1343- }else{ openstack-cluster-installer-31/src/inc/slave_actions.php:1344: $q = "SELECT INET_NTOA(ip) AS addr FROM ips WHERE network='$network_id' AND usefor='vip' AND vip_usage='api'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1345- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1354- // Fetch the SQL VIP if it exists openstack-cluster-installer-31/src/inc/slave_actions.php:1355: $q = "SELECT * FROM networks WHERE cluster='$machine_cluster' AND is_public='no' AND role!='ovs-bridge' AND role!='vm-net' AND role!='ceph-cluster' AND role!='ipmi' LIMIT 1"; openstack-cluster-installer-31/src/inc/slave_actions.php-1356- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1361- openstack-cluster-installer-31/src/inc/slave_actions.php:1362: $q = "SELECT INET_NTOA(ip) AS addr FROM ips WHERE network='$network_id' AND usefor='vip' AND vip_usage='sql'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1363- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1375- if(!is_null($machine_cluster)){ openstack-cluster-installer-31/src/inc/slave_actions.php:1376: $q = "SELECT * FROM machines WHERE cluster='$machine_cluster' AND id != '$machine_id' ORDER BY role, id"; openstack-cluster-installer-31/src/inc/slave_actions.php-1377- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1385- openstack-cluster-installer-31/src/inc/slave_actions.php:1386: $q_oh = "SELECT INET_NTOA(ips.ip) AS addr FROM networks, ips WHERE ips.machine='$other_host_id' AND networks.cluster='$machine_cluster' AND networks.id=ips.network order by case when role='all' then 1 when role='vm-net' then 2 when role='ceph-cluster' then 3 else 9 end LIMIT 1"; openstack-cluster-installer-31/src/inc/slave_actions.php-1387- $r_oh = mysqli_query($con, $q_oh); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1404- $out = ""; openstack-cluster-installer-31/src/inc/slave_actions.php:1405: $q = "SELECT * FROM clusters WHERE id='$cluster_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1406- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1441- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:1442: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1443- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1448- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:1449: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1450- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1455- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:1456: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1457- openstack-cluster-installer-31/src/inc/slave_actions.php-1458- openstack-cluster-installer-31/src/inc/slave_actions.php:1459: $q = "SELECT machines.id AS id, machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr, machines.location_id AS locationid, machines.install_on_raid AS install_on_raid, machines.raid_type AS raid_type, machines.raid_dev0 AS raid_dev0, machines.raid_dev1 AS raid_dev1, machines.raid_dev2 AS raid_dev2, machines.raid_dev3 AS raid_dev3, machines.swift_store_account AS swift_store_account, machines.swift_store_container AS swift_store_container, machines.swift_store_object AS swift_store_object FROM ips,machines,networks WHERE networks.id=ips.network AND networks.role!='ipmi' AND networks.role!='ovs-brdige' AND networks.role!='vm-net' AND networks.role!='ceph-cluster' AND machines.cluster='$cluster_id' AND (machines.role='swiftstore' OR machines.role='swiftproxy') AND ips.machine=machines.id ORDER BY ips.ip"; openstack-cluster-installer-31/src/inc/slave_actions.php-1460-# if($verbose == "yes"){ print("Selecting: $q<br>\n"); ob_flush(); }else{ $out .= "Selecting: $q\n";} ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1469- if($machine["install_on_raid"] == "no"){ openstack-cluster-installer-31/src/inc/slave_actions.php:1470: $q = "SELECT blockdevices.name AS hddname FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '%da' ORDER BY blockdevices.name"; openstack-cluster-installer-31/src/inc/slave_actions.php-1471- }else{ ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1474- case "1": openstack-cluster-installer-31/src/inc/slave_actions.php:1475: $q = "SELECT blockdevices.name AS hddname FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '".$machine["raid_dev0"]."' AND name NOT LIKE '".$machine["raid_dev1"]."' ORDER BY blockdevices.name"; openstack-cluster-installer-31/src/inc/slave_actions.php-1476- break; openstack-cluster-installer-31/src/inc/slave_actions.php-1477- case "10": openstack-cluster-installer-31/src/inc/slave_actions.php:1478: $q = "SELECT blockdevices.name AS hddname FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '".$machine["raid_dev0"]."' AND name NOT LIKE '".$machine["raid_dev1"]."' AND name NOT LIKE '".$machine["raid_dev2"]."' AND name NOT LIKE '".$machine["raid_dev3"]."' ORDER BY blockdevices.name"; openstack-cluster-installer-31/src/inc/slave_actions.php-1479- break; ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1493- openstack-cluster-installer-31/src/inc/slave_actions.php:1494: $q = "SELECT swiftregions.id AS swiftregion FROM locations,swiftregions WHERE locations.id='$blockdev_locationid' AND swiftregions.name=locations.swiftregion"; openstack-cluster-installer-31/src/inc/slave_actions.php-1495- $rsw = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1509- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:1510: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1511- } ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1518- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:1519: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1520- } ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1527- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:1528: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1529- $blockdev_object_port += 1; ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1538- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:1539: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1540- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1545- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:1546: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1547- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1552- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:1553: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1554- if($verbose == "yes"){ print("All done!"); }else{ $out .= "All done!";} openstack-cluster-installer-31/src/inc/slave_actions.php-1555- openstack-cluster-installer-31/src/inc/slave_actions.php:1556: $q = "SELECT machines.hostname AS hostname, INET_NTOA(ips.ip) AS ipaddr FROM ips,machines,networks WHERE networks.id=ips.network AND networks.role!='ipmi' AND networks.role!='ovs-brdige' AND networks.role!='vm-net' AND networks.role!='ceph-cluster' AND machines.cluster='$cluster_id' AND (machines.role='swiftstore' OR machines.role='swiftproxy') AND ips.machine=machines.id ORDER BY ips.ip"; openstack-cluster-installer-31/src/inc/slave_actions.php-1557- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1578-function ipmi_set_boot_device($con, $conf, $machine_id, $bootdev){ openstack-cluster-installer-31/src/inc/slave_actions.php:1579: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1580- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1598- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:1599: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1600- } ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1630-function get_machine_management_network_ip($con, $conf, $machine_id){ openstack-cluster-installer-31/src/inc/slave_actions.php:1631: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1632- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1641- openstack-cluster-installer-31/src/inc/slave_actions.php:1642: $q = "SELECT * FROM networks WHERE cluster='$cluster_id' AND location_id='$location_id' AND networks.is_public='no' AND networks.role!='vm-net' AND networks.role!='ovs-bridge' AND networks.role!='ceph-cluster' AND networks.role!='ipmi'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1643- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1655-function slave_install_os($con, $conf, $machine_id, $install_cmd){ openstack-cluster-installer-31/src/inc/slave_actions.php:1656: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1657- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1671- openstack-cluster-installer-31/src/inc/slave_actions.php:1672: $q = "SELECT * FROM clusters WHERE id='$cluster_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1673- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1712- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:1713: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1714- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1718- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:1719: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1720- openstack-cluster-installer-31/src/inc/slave_actions.php-1721- $cmd = "sudo /usr/bin/oci-copy-slave-node-generate-key $machine_hostname $template_path 2>&1"; openstack-cluster-installer-31/src/inc/slave_actions.php:1722: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1723- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1726- $cmd = "sudo /usr/bin/oci-remove-slave-node-generated-key $machine_hostname"; openstack-cluster-installer-31/src/inc/slave_actions.php:1727: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-1728- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1760- $api_keys = "/var/lib/oci/ssl/slave-nodes/$machine_hostname"; openstack-cluster-installer-31/src/inc/slave_actions.php:1761: $q = "SELECT * FROM clusters WHERE id='$cluster_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1762- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1831- # Only build the swift ring if there's some swiftstore nodes. openstack-cluster-installer-31/src/inc/slave_actions.php:1832: $q = "SELECT * FROM machines WHERE cluster='$cluster_id' AND role='swiftstore'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1833- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1910- if($machine["install_on_raid"] == "no"){ openstack-cluster-installer-31/src/inc/slave_actions.php:1911: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '%da'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1912- }else{ ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-1915- case "1": openstack-cluster-installer-31/src/inc/slave_actions.php:1916: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '".$machine["raid_dev0"]."' AND name NOT LIKE '".$machine["raid_dev1"]."'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1917- break; openstack-cluster-installer-31/src/inc/slave_actions.php-1918- case "10": openstack-cluster-installer-31/src/inc/slave_actions.php:1919: $q = "SELECT * FROM blockdevices WHERE machine_id='$machine_id' AND name NOT LIKE '".$machine["raid_dev0"]."' AND name NOT LIKE '".$machine["raid_dev1"]."' AND name NOT LIKE '".$machine["raid_dev2"]."' AND name NOT LIKE '".$machine["raid_dev3"]."'"; openstack-cluster-installer-31/src/inc/slave_actions.php-1920- break; ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-2011- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:2012: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-2013- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-2017- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:2018: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-2019- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-2023- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:2024: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-2025- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-2029- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:2030: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-2031- openstack-cluster-installer-31/src/inc/slave_actions.php-2032- # Fetch all the IPs assigned to the machine, so we can sign the SSH key for them. openstack-cluster-installer-31/src/inc/slave_actions.php:2033: $q = "SELECT INET_NTOA(ip) AS ipaddr FROM ips WHERE machine='" . $machine["id"] . "' AND usefor='machine'"; openstack-cluster-installer-31/src/inc/slave_actions.php-2034- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-2047- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:2048: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-2049- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-2059- $return_var = 0; openstack-cluster-installer-31/src/inc/slave_actions.php:2060: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/slave_actions.php-2061- ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-2074- openstack-cluster-installer-31/src/inc/slave_actions.php:2075: $q = "SELECT * FROM machines WHERE id='$machine_id'"; openstack-cluster-installer-31/src/inc/slave_actions.php-2076- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-2105- # so let's set initial_cluster_setup to yes if that's a controller. openstack-cluster-installer-31/src/inc/slave_actions.php:2106: $r = mysqli_query($con, "UPDATE clusters SET initial_cluster_setup='yes' WHERE id='".$machine["cluster"]."'"); openstack-cluster-installer-31/src/inc/slave_actions.php-2107- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/inc/slave_actions.php-2113- # When a machine gets reinstalled, obviously, puppet hasn't run yet there... openstack-cluster-installer-31/src/inc/slave_actions.php:2114: $r = mysqli_query($con, "UPDATE machines SET puppet_status='notrun' WHERE id='$machine_id'"); openstack-cluster-installer-31/src/inc/slave_actions.php-2115- if($r === FALSE){ ############################################## openstack-cluster-installer-31/src/inc/ssh.php-12- } openstack-cluster-installer-31/src/inc/ssh.php:13: $stream = ssh2_exec($ssh, $command); openstack-cluster-installer-31/src/inc/ssh.php-14- if($stream === FALSE){ ############################################## openstack-cluster-installer-31/src/inc/ssh.php-28- $return_var = 0; openstack-cluster-installer-31/src/inc/ssh.php:29: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/ssh.php-30- return implode($output, "\n"); ############################################## openstack-cluster-installer-31/src/inc/ssh.php-43- $return_var = 0; openstack-cluster-installer-31/src/inc/ssh.php:44: exec($cmd, $output, $return_var); openstack-cluster-installer-31/src/inc/ssh.php-45- } ############################################## openstack-cluster-installer-31/src/inc/validate_param.php-3-function check_machine_with_ip_exists($con, $safe_ipv4){ openstack-cluster-installer-31/src/inc/validate_param.php:4: $r = mysqli_query($con, "SELECT * FROM machines WHERE ipaddr='$safe_ipv4'"); openstack-cluster-installer-31/src/inc/validate_param.php-5- $n = mysqli_num_rows($r); ############################################## openstack-cluster-installer-31/src/inc/validate_param.php-13-function check_cluster_with_id_exists($con, $safe_id){ openstack-cluster-installer-31/src/inc/validate_param.php:14: $q = "SELECT * FROM clusters WHERE id='$safe_id'"; openstack-cluster-installer-31/src/inc/validate_param.php-15- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/install-status.php-27-if($safe_chassis_serial === FALSE){ openstack-cluster-installer-31/src/install-status.php:28: $q = "SELECT * FROM machines WHERE dhcp_ip='$remote_addr'"; openstack-cluster-installer-31/src/install-status.php-29-}else{ openstack-cluster-installer-31/src/install-status.php:30: $q = "SELECT * FROM machines WHERE serial='$safe_chassis_serial'"; openstack-cluster-installer-31/src/install-status.php-31-} ############################################## openstack-cluster-installer-31/src/install-status.php-68- } openstack-cluster-installer-31/src/install-status.php:69: $q = "UPDATE machines SET ipaddr='$safe_ipv4' WHERE serial='$safe_chassis_serial'"; openstack-cluster-installer-31/src/install-status.php-70- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/install-status.php-77- $cmd = "sudo /usr/bin/puppet cert sign " . $machine_hostname; openstack-cluster-installer-31/src/install-status.php:78: exec($cmd , $output); openstack-cluster-installer-31/src/install-status.php-79- ############################################## openstack-cluster-installer-31/src/install-status.php-109- if($safe_chassis_serial === FALSE){ openstack-cluster-installer-31/src/install-status.php:110: $req = "UPDATE machines SET lastseen=NOW() $puppet_status $status WHERE ipaddr='$remote_addr'"; openstack-cluster-installer-31/src/install-status.php-111- }else{ openstack-cluster-installer-31/src/install-status.php-112- if($_REQUEST["status"] == "live"){ openstack-cluster-installer-31/src/install-status.php:113: $req = "UPDATE machines SET lastseen=NOW() $puppet_status $status, ipaddr='$remote_addr', dhcp_ip='$remote_addr' WHERE serial='$safe_chassis_serial'"; openstack-cluster-installer-31/src/install-status.php-114- }else{ openstack-cluster-installer-31/src/install-status.php:115: $req = "UPDATE machines SET lastseen=NOW() $puppet_status $status, ipaddr='$remote_addr' WHERE serial='$safe_chassis_serial'"; openstack-cluster-installer-31/src/install-status.php-116- } ############################################## openstack-cluster-installer-31/src/install-status.php-119- if($update_initial_cluster_setup_var == "yes" && $safe_chassis_serial !== FALSE){ openstack-cluster-installer-31/src/install-status.php:120: $q = "SELECT cluster,role,id FROM machines WHERE serial='$safe_chassis_serial'"; openstack-cluster-installer-31/src/install-status.php-121- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/install-status.php-128- $clusterid = $machine["cluster"]; openstack-cluster-installer-31/src/install-status.php:129: $q = "SELECT hostname FROM machines WHERE cluster='$clusterid' AND role='controller' AND puppet_status NOT LIKE 'success'"; openstack-cluster-installer-31/src/install-status.php-130- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/install-status.php-133- if($n == 0){ openstack-cluster-installer-31/src/install-status.php:134: $q = "UPDATE clusters SET initial_cluster_setup='no' WHERE cluster='$clusterid'"; openstack-cluster-installer-31/src/install-status.php-135- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/install-status.php-138- # TODO ... openstack-cluster-installer-31/src/install-status.php:139: $q = "SELECT ipaddr FROM machines WHERE role='compute' AND compute_is_cephosd='yes' AND cluster='$clusterid'"; openstack-cluster-installer-31/src/install-status.php-140- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/install-status.php-163- # and the compute gets nova up. openstack-cluster-installer-31/src/install-status.php:164: $q = "SELECT * FROM clusters WHERE cluster='$clusterid' AND initial_cluster_setup='no'"; openstack-cluster-installer-31/src/install-status.php-165- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/install-status.php-169- $clusterid = $machine["cluster"]; openstack-cluster-installer-31/src/install-status.php:170: $q = "SELECT ipaddr FROM machines WHERE cluster='$clusterid' AND role='controller' AND puppet_status LIKE 'success' LIMIT 1"; openstack-cluster-installer-31/src/install-status.php-171- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/ipxe.php-17- openstack-cluster-installer-31/src/ipxe.php:18:$r = mysqli_query($con, "SELECT * FROM machines WHERE dhcp_ip='" . $remote_addr . "'"); openstack-cluster-installer-31/src/ipxe.php-19-$n = mysqli_num_rows($r); ############################################## openstack-cluster-installer-31/src/report.php-114- openstack-cluster-installer-31/src/report.php:115:$r = mysqli_query($con, "SELECT * FROM machines WHERE serial='" . $safe_serial_number . "'"); openstack-cluster-installer-31/src/report.php-116-$n = mysqli_num_rows($r); ############################################## openstack-cluster-installer-31/src/report.php-209- // We keep the machine id... openstack-cluster-installer-31/src/report.php:210: $req = "UPDATE machines SET report_counter='$report_counter', ipaddr='$remote_addr', memory='".$safe_memory_size."', serial='$safe_serial_number', product_name='$prod_name', ladvd_report='$ladvd_report', bios_version='$bios_version', dell_lifecycle_version='$dell_lifecycle_version', ipmi_firmware_version='$ipmi_version', ipmi_detected_ip='$ipmi_detected_ip', lastseen=NOW() $dhcp_update WHERE serial='$safe_serial_number'"; openstack-cluster-installer-31/src/report.php-211- $r = mysqli_query($con, $req); ############################################## openstack-cluster-installer-31/src/report.php-236- $safe_blk_size = $myblkdev["size_mb"]; openstack-cluster-installer-31/src/report.php:237: $q = "SELECT id FROM blockdevices WHERE machine_id='$machine_id' AND name='$safe_blk_name' AND size_mb='$safe_blk_size'"; openstack-cluster-installer-31/src/report.php-238- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/report.php-245- // Check if the number of dev don't match openstack-cluster-installer-31/src/report.php:246: $q = "SELECT id FROM blockdevices WHERE machine_id='$machine_id'"; openstack-cluster-installer-31/src/report.php-247- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/report.php-254- if($all_if_in_sql == "no"){ openstack-cluster-installer-31/src/report.php:255: $r = mysqli_query($con, "DELETE FROM blockdevices WHERE machine_id='".$machine_id."'"); openstack-cluster-installer-31/src/report.php-256- for($i=0;$i<sizeof($blkdev_array);$i++){ ############################################## openstack-cluster-installer-31/src/report.php-300- $safe_blk_state = $myblkdev["state"]; openstack-cluster-installer-31/src/report.php:301: $q = "SELECT id FROM physblockdevices WHERE machine_id='$machine_id' AND slot='$safe_blk_slot' AND model='$safe_blk_model' AND serial='$safe_blk_serial' AND size='$safe_blk_size' AND state='$safe_blk_state'"; openstack-cluster-installer-31/src/report.php-302- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/report.php-309- // Check if the number of dev don't match openstack-cluster-installer-31/src/report.php:310: $q = "SELECT id FROM physblockdevices WHERE machine_id='$machine_id'"; openstack-cluster-installer-31/src/report.php-311- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/report.php-318- if($all_if_in_sql == "no"){ openstack-cluster-installer-31/src/report.php:319: $r = mysqli_query($con, "DELETE FROM physblockdevices WHERE machine_id='".$machine_id."'"); openstack-cluster-installer-31/src/report.php-320- for($i=0;$i<sizeof($blkdev_array);$i++){ ############################################## openstack-cluster-installer-31/src/report.php-374- // First check if the number of ifaces is matching. openstack-cluster-installer-31/src/report.php:375: $q = "SELECT id FROM ifnames WHERE machine_id='$machine_id'"; openstack-cluster-installer-31/src/report.php-376- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/report.php-389- $safe_if_switchport_name = $myiface["switchport_name"]; openstack-cluster-installer-31/src/report.php:390: $q = "SELECT id FROM ifnames WHERE machine_id='$machine_id' AND name='$safe_if_name' AND macaddr='$safe_if_macaddr' AND max_speed='$safe_if_max_speed' AND switchport_name='$safe_if_switchport_name' AND switch_hostname='$safe_if_switch_hostname'"; openstack-cluster-installer-31/src/report.php-391- $r = mysqli_query($con, $q); ############################################## openstack-cluster-installer-31/src/report.php-399- if($all_if_in_sql == "no"){ openstack-cluster-installer-31/src/report.php:400: $r = mysqli_query($con, "DELETE FROM ifnames WHERE machine_id='".$machine_id."'"); openstack-cluster-installer-31/src/report.php-401- for($i=0;$i<sizeof($iface_array);$i++){ ############################################## openstack-cluster-installer-31/utils/usr/bin/oci-make-osd-248- # Calculate remaining space on the VG... openstack-cluster-installer-31/utils/usr/bin/oci-make-osd:249: FREE_ON_VG=$(vgs --separator , osdvg${CEPH_OSD_ID} | q -d, -H "SELECT VFree FROM - WHERE VG='osdvg${CEPH_OSD_ID}'") openstack-cluster-installer-31/utils/usr/bin/oci-make-osd-250- ############################################## openstack-cluster-installer-31/utils/usr/bin/oci-make-osd-260-############################################################# openstack-cluster-installer-31/utils/usr/bin/oci-make-osd:261:DEFROUTE_IF=`awk '{ if ( $2 == "00000000" ) print $1 }' /proc/net/route` openstack-cluster-installer-31/utils/usr/bin/oci-make-osd-262-if [ -n "${DEFROUTE_IF}" ] ; then openstack-cluster-installer-31/utils/usr/bin/oci-make-osd-263- if [ -x /bin/ip ] ; then openstack-cluster-installer-31/utils/usr/bin/oci-make-osd:264: DEFROUTE_IP=`LC_ALL=C ip addr show "${DEFROUTE_IF}" | grep inet | head -n 1 | awk '{print $2}' | cut -d/ -f1 | grep -E '^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$' || true` openstack-cluster-installer-31/utils/usr/bin/oci-make-osd-265- else openstack-cluster-installer-31/utils/usr/bin/oci-make-osd:266: DEFROUTE_IP=`hostname -i | grep -E '^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$' | true` openstack-cluster-installer-31/utils/usr/bin/oci-make-osd-267- fi