On 22 November 2011 20:36, Ewan MacMahon <[log in to unmask]> wrote:
> -----Original Message-----
> From: GRIDPP2: Deployment and support of SRM and local storage management
> [mailto:[log in to unmask]] On Behalf Of Jens Jensen


> 5. EMI install saga continues?

Just for a quick update on this from the Oxford experience,
I initially tried doing this as a clean install of SL5 and
EMI DPM, but with a mysql instance populated from a dump
of the existing/previous SE. YAIM failed with permissions
errors doing things to the mysql. I've then tried it again
on the same install, but with a completely virgin mysql
instance, and it behaved the same way. I've now installed
a clean copy of SL5, and will go through the install from
scratch as if it were a completely fresh one and see what
happens. If it fails the same way again I'm pretty close to
calling it broken and going for gLite 3.2 instead.

That said, I really don't understand how it could be as
broken as it appears and have been released, so I suspect
there's something I'm missing, but I'm simplifying the
setup and I haven't found it yet.

The bit that's failing is:
 /opt/glite/yaim/functions/utils/set_mysql_passwd
which seems to try to (re)set various mysql passwords in
a manner while
- fails
- stuffs something up.
The first run generates a couple of errors, a subsequent
one fails with more errors, unless you first restart
mysql or do a 'flush privileges', which puts you back to
square one. It's very odd. The YAIM function itself seems
to be unchanged from the gLite version.



Ah, this. What version of MySQL are you using? Alessandra found issues with the mysql configurator in YAIM with MySQL 5.5, because it uses different keywords to describe the same thing. 
(In particular, to quote from the emails on dpm-user-forum:

May be this:

http://stackoverflow.com/questions/5856511/how-to-setup-inno-db-in-mysql-5-5-8

So replacing "TYPE = InnoDB" by " ENGINE = InnoDB" should fix the issue.

I can confirm from the manual that it is ENGINE what is specified for MySQL 5.5
)

Sam

Ewan