WiPPaH

Thats crazy! We ended up using a local AV company in the end to look at ours, who charged us £150 for a replacement fan and callout.

Thanks Matt40k & Los0jos The CommandReporter tool looks perfect!

Hi, I am looking to something similar with merits, do you know if Sims has a way of automating this report generation? The plan is to not have to run a report once a week and have "something" do it for me every X days.

I am also in the same boat, and Equinox dont appear to do on-site maintenance. Hopefully someone out there has some good experience with a repairer.

I had another go with this and I think I am pretty much there now - Thanks! As you say the 7110 doesn't really care much for knowing the username, aslong as the user and group are set correctly (which actually does automatically when you chown the nfs mount point). So my setup is as follows (it might help someone else) * Share setup initially as nobody,other (but then gets changed to 27 (the uid of the mysql user on the client)) wx-rx-rx *Create an NFS exception that allows read/write root access to the VM hostname. *Add the mount point to the autofs file and mount the share to /mnt/MySQL_Data *As root chown the MySQL_Data folder to mysql:mysql (this will change the uid on the 7110) *as root start the mysqld service. Thats pretty much it!

Any update on this Duke? I am having a similar problem with our webservers that have a shared nfs based webroot folder. Its chown'd by root to user apache, runs when I do "service httpd start" as root (runs as root), but if I restart and it runs as user 'apache' on system startup I get access denied.

Thanks Chris - ACL have to be the answer like you said, I suppose I just need a good guide for it. If I get this working I will test the differences between a seperate NFS mysql db and a "part of the vdk" db and see if it was worth it!

Correct - the VM hd is stored on the 7110, and the mysql data share is also running as a seperate nfs share. The problem is the VHD is one big (big) file that is constantly being modified. The Mysql Database is several small files, for example each table has its own set of files. This allows the 7110 to cache and do its own whizzy bits with the files (tables) that are used the most. This gives you a higher level of optimisation. At least that is my understanding of it. Even if I was running a physical DB server I would still be having the same user problem with the NFS share.

I have set the user of the share to '[email protected]' but that fails with error "User: Unknown or invalid user" on the 7110. I have had a look at the wiki but its not _that_ helpful when it comes to stuff like this, I've got a feeling im doing something majorly wrong here though if I cant find anyone else on google with the same problem. I am pretty sure I am not the first person to want to set exact permissions on an NFS share with these boxes.

Not a bad idea Teejay - but storing the contents of the database as 1 vmd file might defeat the object of offloading the database files to the 7110 for speed. Check out the links I posted above, if its anything like what Sun are boasting it would be a massive advantage to mount it as a nfs share.

Hi Chris Thanks for the reply - The VM's VHD is mounted on the 7110 also, however after reading the Sun Big Admin guides and a blueprint document, they have been raving about how well these boxes can run databases when nfs mounted. The speeds they are getting are pretty awesome, infact ill see if I can find a link... MySQL Performance on Sun Storage 7000 : Performance Profiles I have also been following this sun blueprint guide: http://mapping.sun.com/profile/offer.jsp?id=202 (requires SUN account to access) It actually looks pretty impressive, and a job well suited for these high performance boxes.

Currently using NFS v3 for compatibility. Maybe some more information would be helpful. =On the 7110= * Created a new default NFS project and share: RDBMS/MySQL * Setup the 'Root Access' exception for the VM. ==On the VM== The Virtual Machine is running CentOS 5.4. * mounted NFS share as root to /mnt/RDBMS * Installed mysqld which creates a new user 'mysql' for the service. * Edited /etc/my.cm to change the datadir to /mnt/RDBMS * Ran /usr/bin/mysql_install_db as root which creates a 'mysql' and 'test' folder on /mnt/RDBMS and chown's them to the mysql user. The only thing left to do is start the mysqld via 'service start mysqd' however I receive this error in the /var/log/mysqld error log. 100225 12:30:48 mysqld started 100225 12:30:48 [Warning] Can't create test file /mnt/RDBMS/RDBMS.lower-test 100225 12:30:48 [Warning] Can't create test file /mnt/RDBMS/RDBMS.lower-test /usr/libexec/mysqld: Can't change dir to '/mnt/RDBMS/' (Errcode: 13) 100225 12:30:48 [ERROR] Aborting 100225 12:30:48 [Note] /usr/libexec/mysqld: Shutdown complete 100225 12:30:48 mysqld ended My conclusion to this is that root has access to the share (through the exception I added) which was able to chown the folders. However when the 'mysql' cant access it as it needs to be defined somewhere on the 7110 (normally the uids & guids need to match on the NFS server as the NFS client).

No Joy I cant even find a whitepaper on this which seems very odd?!?

Hmm user 'mysql' already exists on the 7110 so might try forcing MySQL to use a new 'mysql_7110' user instead. Will post back results.

Hi Guys, I've got a 7110 here and I have exported a NFS share to a CentOS box, however I am having problems with non root users being able to create files on the share. It works as root with an NFS exception defined for root access. Normally this is down to the user uid/guid not being existing on the NFS server, but I am not sure how I would go about creating the user on the 7110 as I can only see options for access to the web GUI rather than a standard Linux user. Any thoughts?