oor-dev
[Top] [All Lists]

Re: [oor-dev] BioPortal 2.2 install error

To: OpenOntologyRepository-development <oor-dev@xxxxxxxxxxxxxxxx>
From: Tejas Parikh <tejas@xxxxxxxxxxxxxxx>
Date: Tue, 3 Nov 2009 21:36:22 -0500
Message-id: <63274c480911031836t6713f405j92e518bcecfab680@xxxxxxxxxxxxxx>
Shinya,    (01)

Can you please install mysql 5.1 on oor-01f? I am having trouble
deleting old version of mysql.    (02)

Thanks,
--Tejas    (03)



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
>    (04)

_________________________________________________________________
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)
<Prev in Thread] Current Thread [Next in Thread>