Page 4 of 4
Re: Database Creation fails
Posted: Mon Oct 07, 2013 1:25 am
by id10t
Hi!
1. 99% that you will get data corruption sometime (usage in unsupported file system - NTFS).
2. If you will install it on Host OS (aka Windows), can you try to do a backup? Perhaps you will not able to do a backup, since Vertica uses in hard links for backup snapshots and Windows has no hard-links (has, but it hidden and works different than in Linux).
Re: Database Creation fails
Posted: Mon Oct 07, 2013 2:28 am
by oppelo
This is what I get
[dbadmin@vertica ~]$ su -
Password:
[root@vertica ~]# vi /etc/mtab
[root@vertica ~]# sudo umount /mnt/hgfs
[root@vertica ~]# sudo mount /mnt/hgfs
mount: can't find /mnt/hgfs in /etc/fstab or /etc/mtab
Re: Database Creation fails
Posted: Mon Oct 07, 2013 4:38 am
by id10t
Hi!
How I hate it! Why you do not provides anything, any info, output of mtab?
Also forum rejects me and I'm not able to answer most times, so it's my last post.
1. login as root
2. save script on GuestOS (say /tmp/make_dbadmin.sh)
3. set it executable (chmod +x /tmp/make_dbadmin.sh)
4. run script
Code: Select all
#!/bin/bash
uid=`id -u dbadmin`
gid=`id -g dbadmin`
owner=${uid}
# check if root
if [[ `id -u` != 0 ]]
then echo 'Error: run script as root'
exit -1
fi
# create mtab backup
cp /etc/mtab{,_old}
grep -v hgfs /etc/mtab_old > /etc/mtab
# check if mounted, if so => unmount
if [[ -b /mnt/hgfs ]]
then
umount /mnt/hgfs 2>/dev/null
fi
# mount
mount -t vmhgfs -o rw,uid=${uid},gid=${gid},owner=${owner},ttl=1 .host:/ /mnt/hgfs
#validate
for FILE in /mnt/hgfs/*;
do
if [[ `ls -dn ${FILE} | cut -d' ' -f3` != ${uid} ]];
then echo "USER isn't dbadmin!"
fi
if [[ `ls -dn ${FILE} | cut -d' ' -f4` != ${gid} ]];
then echo "GROUP isn't dbadmin!"
fi
done
exit 0
dont do like this:
you are already root
Re: Database Creation fails
Posted: Tue Oct 08, 2013 6:17 am
by oppelo
Thank you very much for your help. I am sorry that I did not give you what you wanted. I did not know that it was required. However, that did not work completely. I will give it a try again.