[prev in list] [next in list] [prev in thread] [next in thread] 

List:       wsf-java-user
Subject:    Re: [User] Stratos and MySQL InnoDB on Ubuntu server 12.04
From:       Kayode Odeyemi <dreyemi () gmail ! com>
Date:       2012-08-27 5:45:53
Message-ID: CAPbrmCuUmURqbHYctDSCOpcpfObAR6BLxWYC6fYOFZsXYSAPoA () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


On Sun, Aug 26, 2012 at 3:47 PM, Kasun Weranga <kasunw@wso2.com> wrote:

> Hi Kayode,
>
> On Sat, Aug 25, 2012 at 9:51 AM, Kayode Odeyemi <dreyemi@gmail.com> wrote:
>
>> On Sat, Aug 25, 2012 at 5:04 AM, Sumedha Rubasinghe <sumedha@wso2.com>wrote:
>>
>>> Hi,
>>> This seems to be an error in your database scripts.
>>> Usually syntax for specifying MySQL storage engine type is something
>>> similar to following..
>>>
>>> CREATE TABLE IF NOT EXISTS TABLE1(
>>> ...
>>> ...
>>> )ENGINE INNODB;
>>>
>>> Did you modify the default scripts?
>>>
>>
>> No I did not. The installation I did on Ubuntu desktop 12.04 worked
>> perfectly well. I'm using the same stratos tarball without any
>> modifications to the scripts.
>>
>> The syntax in mysql.sql script is the same as described above.
>>
>
> You need to change Type=InnoDB to ENGINE=InnoDB in dbscripts/bps/bpel/mysql.sql,
> only that script has this issue. Please change it as described.
>
> Thanks,
> KasunW.
>
> Thanks. Works like a charm.

[Attachment #5 (text/html)]

<div class="gmail_quote">On Sun, Aug 26, 2012 at 3:47 PM, Kasun Weranga <span \
dir="ltr">&lt;<a href="mailto:kasunw@wso2.com" \
target="_blank">kasunw@wso2.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">

Hi Kayode,<br><br><div class="gmail_quote"><div><div class="h5">On Sat, Aug 25, 2012 \
at 9:51 AM, Kayode Odeyemi <span dir="ltr">&lt;<a href="mailto:dreyemi@gmail.com" \
target="_blank">dreyemi@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">

<div class="gmail_quote"><div>On Sat, Aug 25, 2012 at 5:04 AM, Sumedha Rubasinghe \
<span dir="ltr">&lt;<a href="mailto:sumedha@wso2.com" \
target="_blank">sumedha@wso2.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">






Hi,<br>This seems to be an error in your database scripts.<br>Usually syntax for \
specifying MySQL storage engine type is something similar to \
following..<br><br>CREATE TABLE IF NOT EXISTS TABLE1(<br>...<br>...<br>)ENGINE \
INNODB;<br>








<br>Did you modify the default scripts?<br></blockquote></div><div><br>No I did not. \
The installation I did on Ubuntu desktop 12.04 worked perfectly well. I&#39;m using \
the same stratos tarball without any modifications to the scripts. <br>





<br>The syntax in mysql.sql script is the same as described \
above.<br></div></div></blockquote><div><br></div></div></div><div>You need to change \
Type=InnoDB to <span \
style="font-size:13px;font-family:arial,sans-serif">ENGINE=InnoDB in </span><font \
face="arial, sans-serif">dbscripts/bps/bpel/mysql.sql, only that script has this \
issue. Please change it as described. </font></div>



<div><font color="#222222" face="arial, sans-serif"><br></font></div><div><font \
face="arial, sans-serif">Thanks,</font></div><div><font face="arial, \
sans-serif">KasunW.<br><br></font></div></div></blockquote><div>Thanks. Works like a \
charm. <br>

</div></div><br>



_______________________________________________
User mailing list
User@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/user


[prev in list] [next in list] [prev in thread] [next in thread]