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

David Ames david at linux-foundation.org
Fri Apr 4 07:52:53 PDT 2008


Wichmann, Mats D wrote:
> Denis Silakov wrote:
>> Wichmann, Mats D wrote:
>>> I've got this set up, but now I'm stuck on permissions again.
>>>
>>> ERROR 1227 (42000) at line 9: Access denied; you need the SUPER
>>> privilege for this operation 

I can grant the Supr_priv if necessary.

>>>
>> This is actually more serious. MySQL has a separate TRIGGER privilege
>> only since 5.1.6, and it seems unreasonable to upgrade to such a fresh
>> version at the moment.
>>
>> I suggest not to create triggers in the master db at all. They are not
>> used by Navigator or by other tools that only read the information. So
>> it would be reasonable to comment out call to 'create_triggers.sql' in
>> makefile and not have them at the master db. Triggers are really
>> useful when someone uploads lots of data to the database, but such
>> uploads are usually performed on local copies of the database, and
>> 'create_triggers' can be called manually. I'll document triggers
>> usage on wiki. 
>>
>> Thus, 'dbperms.sql' is the only script left to be executed.
> 
> I already jumped ahead and did that one.
> 
> So the LF copy should be up to date now - hopefully someone
> can try it out and see that there aren't any problems.

Sounds like we have settled on staying with 5.0.22 let me know if we need to upgrade.

David Ames


More information about the lsb-infrastructure mailing list