oor-dev
[Top] [All Lists]

Re: [oor-dev] BioPortal 2.2 install error

To: OpenOntologyRepository-development <oor-dev@xxxxxxxxxxxxxxxx>
From: YAMADA Shinya <shinya@xxxxxxxxxxxxx>
Date: Wed, 4 Nov 2009 12:32:38 +0900
Message-id: <36a3b0760911031932u592e2bd9mc94766e4cdab3cb5@xxxxxxxxxxxxxx>
Tejas,    (01)

I've installed MySQL 5.1. Same password for root account.    (02)

Let me know if you see any problems with new version.    (03)

Thansk,
___
Shinya    (04)



On Wed, Nov 4, 2009 at 11:36 AM, Tejas Parikh <tejas@xxxxxxxxxxxxxxx> wrote:
> Shinya,
>
> Can you please install mysql 5.1 on oor-01f? I am having trouble
> deleting old version of mysql.
>
> Thanks,
> --Tejas
>
>
>
> On Sun, Nov 1, 2009 at 11:08 PM, Peter Yim <peter.yim@xxxxxxxx> wrote:
>> Shinya & Tejas ...
>>
>> Given the dependency (as this may come up in future too), may I
>> suggest that Tejas (rather than Shinya) installs, and maintains mysql
>> as well, on <oor-01f>.
>>
>> Is that ok with both of you?
>>
>> Thanks & regards.  =ppy
>> --
>>
>>
>> On Sun, Nov 1, 2009 at 7:58 PM, YAMADA Shinya <shinya@xxxxxxxxxxxxx> wrote:
>>> Tejas,
>>>
>>> It appears the error is caused by the version of MySQL installed on the box.
>>> 5.0.86 is installed on oor-01f but according bioportal installation doc, it
>>> required 5.1.(trigger is not supported in 5.0)
>>>
>>> Let me know if i can re-install MySQL now.( will blow up all DB)
>>>
>>> Thanks,
>>> ___
>>> Shinya
>>
>>
>>> On Mon, Nov 2, 2009 at 12:26 PM, Tejas Parikh <tejas@xxxxxxxxxxxxxxx> wrote:
>>>> I am trying to install BioPortal using the instructions emailed by Natasha.
>>>>
>>>> I am getting MySQL error when executing following command. User
>>>> bioportal_prd was created in MySQL and has ALL access to BioPortal
>>>> databases.
>>>>
>>>> grant SUPER, TRIGGER on *.* to 'bioportal_prd'@'localhost'
>>>>
>>>> MySQL error is:
>>>>
>>>> mysql> grant SUPER, TRIGGER on *.* to 'bioportal_prd'@'localhost';
>>>> ERROR 1064 (42000): You have an error in your SQL syntax; check the
>>>> manual that corresponds to your MySQL server version for the right
>>>> syntax to use near 'TRIGGER on *.* to 'bioportal_prd'@'localhost'' at
>>>> line 1
>>>>
>>>>
>>>> Thanks,
>>>> --Tejas
>>
>> _________________________________________________________________
>> Message Archives: http://ontolog.cim3.net/forum/oor-dev/
>> Config/Unsubscribe: http://ontolog.cim3.net/mailman/listinfo/oor-dev/
>> Shared Files: http://ontolog.cim3.net/file/work/OOR/dev/
>> Wiki: http://ontolog.cim3.net/cgi-bin/wiki.pl?OpenOntologyRepository
>>
>
> _________________________________________________________________
> Message Archives: http://ontolog.cim3.net/forum/oor-dev/
> Config/Unsubscribe: http://ontolog.cim3.net/mailman/listinfo/oor-dev/
> Shared Files: http://ontolog.cim3.net/file/work/OOR/dev/
> Wiki: http://ontolog.cim3.net/cgi-bin/wiki.pl?OpenOntologyRepository
>    (05)

_________________________________________________________________
Message Archives: http://ontolog.cim3.net/forum/oor-dev/   
Config/Unsubscribe: http://ontolog.cim3.net/mailman/listinfo/oor-dev/   
Shared Files: http://ontolog.cim3.net/file/work/OOR/dev/ 
Wiki: http://ontolog.cim3.net/cgi-bin/wiki.pl?OpenOntologyRepository     (06)
<Prev in Thread] Current Thread [Next in Thread>