[Lsb-infrastructure] Update: New database up - partly / problems

Dan Kohn dan at dankohn.com
Thu Apr 3 17:19:04 PDT 2008


David, are we using the MySQL from Ubuntu LTS?  It is possible to install a
custom package?

On Thu, Apr 3, 2008 at 3:47 PM, Wichmann, Mats D <mats.d.wichmann at intel.com>
wrote:

> Wichmann, Mats D wrote:
> > The 1.3 database update is now loaded on the
> > Linux Foundation server.  However, the community data
> > is not loaded.
> >
> > Turns out the new method for installing the
> > data into the community tables runs afoul of
> > permissions, the database user that I operate as
> > is not allowed to perform these operations.
> >
> > ERROR 1045 (27000) at line 1: Access denied for 'lsbdbadmin'@
> > 'localhost' (using password: YES)
> >
> > While I wait for an answer on this, the state is we
> > have the LSB Elements loaded, but not the Community Data,
> > since all of it failed.
>
> Okay, with David's help that part of the problem is
> in the past.  All the tables are loaded up now.
>
> However, the create_triggers.sql script failed,
> complaining of a syntax error in the SQL.  The line
> complaining is this one (line 7):
>
> DROP TRIGGER IF EXISTS int_insert |
>
>
> Is it possible this is not supported by the LF's version
> of mysql?  Yes... looks like the ability to qualify with
> IF EXSITS specifically on DROP TRIGGER was missing, and was
> not added until 5.0.32.  The LF db server is running 5.0.22,
> and so is too old.  Grumble mumble.
>
> http://dev.mysql.com/doc/refman/5.0/en/drop-trigger.html
>
> I'm open to suggestions here.
>
> _______________________________________________
> lsb-infrastructure mailing list
> lsb-infrastructure at lists.linux-foundation.org
> https://lists.linux-foundation.org/mailman/listinfo/lsb-infrastructure
>



-- 
Dan Kohn <mailto:dan at dankohn.com>
COO, The Linux Foundation <http://www.linux-foundation.org>
<http://www.dankohn.com/> <tel:+1-415-233-1000>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.linux-foundation.org/pipermail/lsb-infrastructure/attachments/20080403/2456591e/attachment.htm 


More information about the lsb-infrastructure mailing list