Steps used to recreate / reinstall XPI Store on TSA-CP……
SUDO cheat….# This gives root shell on local machine
echo screen /xsight/opt/scripts/support.sh
sudo /xsight/opt/scripts/support.sh
From root shell XPI Rebuild REMOVE STORAGE xs stop xpi
xs stop mysql
lvdisplay
lvremove /dev/xpivg/data
lvremove /dev/xpivg/data2
lvremove /dev/xpivg/rawdata
vgdisplay
vgremove /dev/xpivg
vgremove /dev/xpivg --force
pvdisplay
pvremove /dev/sdb
RECREATE STORAGE pvcreate /dev/sdb
vgcreate xpivg /dev/sdb
NOTE: LV Allocations as per PORTAL:/playbooks/roles/xpi/tasks/allocation.yml
lvcreate -n rawdata -l 94%VG xpivg
lvcreate -n data2 -l 5%FREE xpivg
lvcreate -n data -l 100%FREE xpivg
mkfs.xfs /dev/xpivg/data
mkfs.xfs /dev/xpivg/data2
/etc/fstab:
/dev/mapper/xpivg-data /data xfs defaults 1 2
/dev/mapper/xpivg-data2 /data2 xfs defaults 1 2
mount -a
df
chown xsight:xsight /data /data2
chmod 775 /data /data2
REMOVE / REINSTALL XPI rpm -e xpi_run-2.3.0-02863.x86_64 xpi_ena-2.3.0-02863.x86_64 MySQL-shared-classic-5.1.73
-1.rhel5.x86_64 MySQL-client-classic-5.1.73-1.rhel5.x86_64 MySQL-server-classic-5.1.73-1.rhel5.x86_64
yum install MySQL-server-classic -y
yum install MySQL-shared-classic -y
yum install MySQL-client-classic -y
cd /data
ln -s /xsight/etc/opt/mysql/data/db db
xs start mysql
xs status mysql
yum install xpi_run -y
yum install xpi_ena -y
cd /xsight/opt/xpi/utils/
./xpi_purge.py
cd /data
mkdir CA xpidb
chown xsrun:xsight xpidb
chown xsight:root CA
chmod 775 CA
xs start xpi
xs status xpi
grep ERROR /xsight/var/opt/xpi/log/recdlog
tail -f /xsight/var/opt/xpi/log/recdlog
tail -f /xsight/var/opt/xpi/log/xpi.log
Now validate with ST: - Confirm query in recdlog
- Confirm results in ST