samba - Jun 2005 - Linux 2 Linux Host Filesystem Sharing with Samba + MySQL

Hello all,

I've doing some server consolidation using vmware,  I've asked this 
question to the vmware community, and I've gotten good, yet breif 
answers.  I thought, since it's mostly a samba related issue, this was 
the right place to come..  Anyway....

I've successfully shared out my linux host filesystem to my linux guest 
using samba. The linux guest will be a webserver and mysql database server.
One of the mount points on the guest is /usr/local/mysql/data because I 
don't want the virtual disk to hold the databases. (I'm trying to keep 
my virtual disks under 4GB)
My problem is when I try to start mysql, it complains about not being 
about to chown the log files, as they are part of the samba share.
It there a way to have a samba share, hosted from the host machine to 
the guest, to have full permissions on the guest os?

Someone mentioned to me, "make sure that 
uid=XXX,gid=YYY,file_mode=ZZZ,dir_mode=TTT (& -u/-g/-f/-d) options are 
not provided in fstab/smbclient/... Maybe recheck smb.conf on host for 
"unix extensions" (default is YES, so if you'll not find it, it is
OK).
Then mount filesystem in the guest. Full uid/gid/mode should fully 
propagate between host & guest. Just make sure that host & guest use 
same uid & gid in /etc/passwd & /etc/group." 

But that makes no sense to me.  I just need the smbclient machine to be 
able to have full permission on the mysql data share.

Hopefully someone can help here.  Thanks in advance everyone.

Jimmy

Included is my smb.conf file.  Any ideas?

# Samba config file created using SWAT
# from 0.0.0.0 (0.0.0.0)
# Date: 2005/06/09 18:19:32

# Global parameters
[global]
       workgroup = VMSHARES
       netbios name = HOSTER
       server string = Samba Host Box
       interfaces = 192.168.175.1/255.255.255.0
       security = SHARE
       smb passwd file = /etc/smbpasswd
       enable privileges = Yes
       log file = /var/log/samba/log.%m
       max log size = 50
       socket options = TCP_NODELAY SO_SNDBUF=8192 SO_RCVBUF=8192
       load printers = No
       dns proxy = No
       ldap ssl = no
       valid users = mintee
       admin users = mintee
       create mask = 0777
       force create mode = 0777
       force security mode = 0777
       directory mask = 0777
       force directory mode = 0777
       force directory security mode = 0777

[webs]
       comment = Websites share
       path = /mnt/hd/webs_home
       invalid users = uucp, sync, sshd, smmsp, shutdown, rpc, root, 
pop, operator, nobody, news, mysql, mail, lp, hal
t, gdm, games, ftp, daemon, bin, adm
       valid users = mintee, @users
       read only = No

[webdb]
       comment = Websites Database share
       path = /mnt/hd/webs_data
       username = mintee
       valid users = mintee, @users
       read only = No


James McMillan wrote:
> Hello all,
>
> I've doing some server consolidation using vmware,  I've asked this
> question to the vmware community, and I've gotten good, yet breif 
> answers.  I thought, since it's mostly a samba related issue, this was 
> the right place to come..  Anyway....
>
> I've successfully shared out my linux host filesystem to my linux 
> guest using samba. The linux guest will be a webserver and mysql 
> database server.
> One of the mount points on the guest is /usr/local/mysql/data because 
> I don't want the virtual disk to hold the databases. (I'm trying to
> keep my virtual disks under 4GB)
> My problem is when I try to start mysql, it complains about not being 
> about to chown the log files, as they are part of the samba share.
> It there a way to have a samba share, hosted from the host machine to 
> the guest, to have full permissions on the guest os?
>
> Someone mentioned to me, "make sure that 
> uid=XXX,gid=YYY,file_mode=ZZZ,dir_mode=TTT (& -u/-g/-f/-d) options are 
> not provided in fstab/smbclient/... Maybe recheck smb.conf on host for 
> "unix extensions" (default is YES, so if you'll not find it,
it is
> OK). Then mount filesystem in the guest. Full uid/gid/mode should 
> fully propagate between host & guest. Just make sure that host &
guest
> use same uid & gid in /etc/passwd & /etc/group."
> But that makes no sense to me.  I just need the smbclient machine to 
> be able to have full permission on the mysql data share.
>
> Hopefully someone can help here.  Thanks in advance everyone.
>
> Jimmy