Re: [Dev] MySQL error while executing dbscripts in windows env

2015-09-07 Thread Niranda Perera 
Hi all,

thanks for the feedback.

I think this should be changed kernel wide. pls follow the thread [1]

cheers

[1] [Dev] [Carbon] mysql dbscripts using values > 255 for varchar for
unique keys

On Mon, Sep 7, 2015 at 3:37 PM, Aiyadurai Rajeevan 
wrote:

> +1 for Gokul suggestion(VARCHAR(255))
>
> I had same issue and fixed it by changing to VARCHAR(255)
>
> Thanks & Regards,
> S.A.Rajeevan
> Software Engineer WSO2 Inc
> E-Mail: rajeev...@wso2.com | Mobile : +94776411636
>
> On Mon, Sep 7, 2015 at 12:51 AM, Gokul Balakrishnan 
> wrote:
>
>> Hi Niranda,
>>
>> IMO we should fix this properly, by setting the type to VARCHAR(255)
>> rather than VARCHAR(256) for fields with unique indices, in the place where
>> the tables are created. This is because we can't mandate users to have a
>> specific character set (especially latin1). Setting the engine to MyISAM
>> during table creation would also solve this but that is also not
>> recommended.
>>
>> Thanks,
>>
>>
>> On Monday, 7 September 2015, Niranda Perera  wrote:
>>
>>> HI Hemika,
>>>
>>> it worked! thank you :-)
>>>
>>> On Mon, Sep 7, 2015 at 12:19 AM, Hemika Kodikara 
>>> wrote:
>>>
 Hi Niranda,

 As far as I can remember this is coming due to a db collation issue.

 You can fix it by changing Collation from UTF-8 to latin.

 ex :
 create database  character set latin1;

 Regards,
 Hemika

 Hemika Kodikara
 Software Engineer
 WSO2 Inc.
 lean . enterprise . middleware
 http://wso2.com

 Mobile : +9477762

 On Mon, Sep 7, 2015 at 12:09 AM, Niranda Perera 
 wrote:

> Hi all,
>
> I'm testing DAS 3.0.0 in the windows env (windows 8.1 & java 1.8.0)
> with MySQL as the carbon_db.
>
> I tried, executing the mysql setup dbscript and I get the following
> error
>
> 23:41:09 CREATE INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON
> REG_PATH(REG_PATH_VALUE, REG_TENANT_ID) Error Code: 1071. Specified
> key was too long; max key length is 767 bytes 0.078 sec
>
> this error has already been reported [1] and when I check the script
> also, it mentions this CARBON JIRA.
>
> however, this error does not occur in the linux (ubuntu) env.
>
> would like to know how to proceed with this?
>
> rgds
>
> [1] https://wso2.org/jira/browse/CARBON-5917
>
> --
> *Niranda Perera*
> Software Engineer, WSO2 Inc.
> Mobile: +94-71-554-8430
> Twitter: @n1r44 
> https://pythagoreanscript.wordpress.com/
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>

>>>
>>>
>>> --
>>> *Niranda Perera*
>>> Software Engineer, WSO2 Inc.
>>> Mobile: +94-71-554-8430
>>> Twitter: @n1r44 
>>> https://pythagoreanscript.wordpress.com/
>>>
>>
>>
>> --
>> Gokul Balakrishnan
>> Senior Software Engineer,
>> WSO2, Inc. http://wso2.com
>> Mob: +94 77 593 5789 | +1 650 272 9927
>>
>>
>> ___
>> Dev mailing list
>> Dev@wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
>


-- 
*Niranda Perera*
Software Engineer, WSO2 Inc.
Mobile: +94-71-554-8430
Twitter: @n1r44 
https://pythagoreanscript.wordpress.com/
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] MySQL error while executing dbscripts in windows env

2015-09-07 Thread Aiyadurai Rajeevan 
+1 for Gokul suggestion(VARCHAR(255))

I had same issue and fixed it by changing to VARCHAR(255)

Thanks & Regards,
S.A.Rajeevan
Software Engineer WSO2 Inc
E-Mail: rajeev...@wso2.com | Mobile : +94776411636

On Mon, Sep 7, 2015 at 12:51 AM, Gokul Balakrishnan  wrote:

> Hi Niranda,
>
> IMO we should fix this properly, by setting the type to VARCHAR(255)
> rather than VARCHAR(256) for fields with unique indices, in the place where
> the tables are created. This is because we can't mandate users to have a
> specific character set (especially latin1). Setting the engine to MyISAM
> during table creation would also solve this but that is also not
> recommended.
>
> Thanks,
>
>
> On Monday, 7 September 2015, Niranda Perera  wrote:
>
>> HI Hemika,
>>
>> it worked! thank you :-)
>>
>> On Mon, Sep 7, 2015 at 12:19 AM, Hemika Kodikara  wrote:
>>
>>> Hi Niranda,
>>>
>>> As far as I can remember this is coming due to a db collation issue.
>>>
>>> You can fix it by changing Collation from UTF-8 to latin.
>>>
>>> ex :
>>> create database  character set latin1;
>>>
>>> Regards,
>>> Hemika
>>>
>>> Hemika Kodikara
>>> Software Engineer
>>> WSO2 Inc.
>>> lean . enterprise . middleware
>>> http://wso2.com
>>>
>>> Mobile : +9477762
>>>
>>> On Mon, Sep 7, 2015 at 12:09 AM, Niranda Perera 
>>> wrote:
>>>
 Hi all,

 I'm testing DAS 3.0.0 in the windows env (windows 8.1 & java 1.8.0)
 with MySQL as the carbon_db.

 I tried, executing the mysql setup dbscript and I get the following
 error

 23:41:09 CREATE INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON
 REG_PATH(REG_PATH_VALUE, REG_TENANT_ID) Error Code: 1071. Specified
 key was too long; max key length is 767 bytes 0.078 sec

 this error has already been reported [1] and when I check the script
 also, it mentions this CARBON JIRA.

 however, this error does not occur in the linux (ubuntu) env.

 would like to know how to proceed with this?

 rgds

 [1] https://wso2.org/jira/browse/CARBON-5917

 --
 *Niranda Perera*
 Software Engineer, WSO2 Inc.
 Mobile: +94-71-554-8430
 Twitter: @n1r44 
 https://pythagoreanscript.wordpress.com/

 ___
 Dev mailing list
 Dev@wso2.org
 http://wso2.org/cgi-bin/mailman/listinfo/dev


>>>
>>
>>
>> --
>> *Niranda Perera*
>> Software Engineer, WSO2 Inc.
>> Mobile: +94-71-554-8430
>> Twitter: @n1r44 
>> https://pythagoreanscript.wordpress.com/
>>
>
>
> --
> Gokul Balakrishnan
> Senior Software Engineer,
> WSO2, Inc. http://wso2.com
> Mob: +94 77 593 5789 | +1 650 272 9927
>
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] MySQL error while executing dbscripts in windows env

2015-09-06 Thread Gokul Balakrishnan 
Hi Niranda,

IMO we should fix this properly, by setting the type to VARCHAR(255) rather
than VARCHAR(256) for fields with unique indices, in the place where the
tables are created. This is because we can't mandate users to have a
specific character set (especially latin1). Setting the engine to MyISAM
during table creation would also solve this but that is also not
recommended.

Thanks,

On Monday, 7 September 2015, Niranda Perera  wrote:

> HI Hemika,
>
> it worked! thank you :-)
>
> On Mon, Sep 7, 2015 at 12:19 AM, Hemika Kodikara  > wrote:
>
>> Hi Niranda,
>>
>> As far as I can remember this is coming due to a db collation issue.
>>
>> You can fix it by changing Collation from UTF-8 to latin.
>>
>> ex :
>> create database  character set latin1;
>>
>> Regards,
>> Hemika
>>
>> Hemika Kodikara
>> Software Engineer
>> WSO2 Inc.
>> lean . enterprise . middleware
>> http://wso2.com
>>
>> Mobile : +9477762
>>
>> On Mon, Sep 7, 2015 at 12:09 AM, Niranda Perera > > wrote:
>>
>>> Hi all,
>>>
>>> I'm testing DAS 3.0.0 in the windows env (windows 8.1 & java 1.8.0) with
>>> MySQL as the carbon_db.
>>>
>>> I tried, executing the mysql setup dbscript and I get the following error
>>>
>>> 23:41:09 CREATE INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON
>>> REG_PATH(REG_PATH_VALUE, REG_TENANT_ID) Error Code: 1071. Specified key
>>> was too long; max key length is 767 bytes 0.078 sec
>>>
>>> this error has already been reported [1] and when I check the script
>>> also, it mentions this CARBON JIRA.
>>>
>>> however, this error does not occur in the linux (ubuntu) env.
>>>
>>> would like to know how to proceed with this?
>>>
>>> rgds
>>>
>>> [1] https://wso2.org/jira/browse/CARBON-5917
>>>
>>> --
>>> *Niranda Perera*
>>> Software Engineer, WSO2 Inc.
>>> Mobile: +94-71-554-8430
>>> Twitter: @n1r44 
>>> https://pythagoreanscript.wordpress.com/
>>>
>>> ___
>>> Dev mailing list
>>> Dev@wso2.org 
>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>
>>>
>>
>
>
> --
> *Niranda Perera*
> Software Engineer, WSO2 Inc.
> Mobile: +94-71-554-8430
> Twitter: @n1r44 
> https://pythagoreanscript.wordpress.com/
>


-- 
Gokul Balakrishnan
Senior Software Engineer,
WSO2, Inc. http://wso2.com
Mob: +94 77 593 5789 | +1 650 272 9927
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] MySQL error while executing dbscripts in windows env

2015-09-06 Thread Niranda Perera 
HI Hemika,

it worked! thank you :-)

On Mon, Sep 7, 2015 at 12:19 AM, Hemika Kodikara  wrote:

> Hi Niranda,
>
> As far as I can remember this is coming due to a db collation issue.
>
> You can fix it by changing Collation from UTF-8 to latin.
>
> ex :
> create database  character set latin1;
>
> Regards,
> Hemika
>
> Hemika Kodikara
> Software Engineer
> WSO2 Inc.
> lean . enterprise . middleware
> http://wso2.com
>
> Mobile : +9477762
>
> On Mon, Sep 7, 2015 at 12:09 AM, Niranda Perera  wrote:
>
>> Hi all,
>>
>> I'm testing DAS 3.0.0 in the windows env (windows 8.1 & java 1.8.0) with
>> MySQL as the carbon_db.
>>
>> I tried, executing the mysql setup dbscript and I get the following error
>>
>> 23:41:09 CREATE INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON
>> REG_PATH(REG_PATH_VALUE, REG_TENANT_ID) Error Code: 1071. Specified key
>> was too long; max key length is 767 bytes 0.078 sec
>>
>> this error has already been reported [1] and when I check the script
>> also, it mentions this CARBON JIRA.
>>
>> however, this error does not occur in the linux (ubuntu) env.
>>
>> would like to know how to proceed with this?
>>
>> rgds
>>
>> [1] https://wso2.org/jira/browse/CARBON-5917
>>
>> --
>> *Niranda Perera*
>> Software Engineer, WSO2 Inc.
>> Mobile: +94-71-554-8430
>> Twitter: @n1r44 
>> https://pythagoreanscript.wordpress.com/
>>
>> ___
>> Dev mailing list
>> Dev@wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
>


-- 
*Niranda Perera*
Software Engineer, WSO2 Inc.
Mobile: +94-71-554-8430
Twitter: @n1r44 
https://pythagoreanscript.wordpress.com/
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] MySQL error while executing dbscripts in windows env

2015-09-06 Thread Hemika Kodikara 
Hi Niranda,

As far as I can remember this is coming due to a db collation issue.

You can fix it by changing Collation from UTF-8 to latin.

ex :
create database  character set latin1;

Regards,
Hemika

Hemika Kodikara
Software Engineer
WSO2 Inc.
lean . enterprise . middleware
http://wso2.com

Mobile : +9477762

On Mon, Sep 7, 2015 at 12:09 AM, Niranda Perera  wrote:

> Hi all,
>
> I'm testing DAS 3.0.0 in the windows env (windows 8.1 & java 1.8.0) with
> MySQL as the carbon_db.
>
> I tried, executing the mysql setup dbscript and I get the following error
>
> 23:41:09 CREATE INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON
> REG_PATH(REG_PATH_VALUE, REG_TENANT_ID) Error Code: 1071. Specified key
> was too long; max key length is 767 bytes 0.078 sec
>
> this error has already been reported [1] and when I check the script also,
> it mentions this CARBON JIRA.
>
> however, this error does not occur in the linux (ubuntu) env.
>
> would like to know how to proceed with this?
>
> rgds
>
> [1] https://wso2.org/jira/browse/CARBON-5917
>
> --
> *Niranda Perera*
> Software Engineer, WSO2 Inc.
> Mobile: +94-71-554-8430
> Twitter: @n1r44 
> https://pythagoreanscript.wordpress.com/
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

[Dev] MySQL error while executing dbscripts in windows env

2015-09-06 Thread Niranda Perera 
Hi all,

I'm testing DAS 3.0.0 in the windows env (windows 8.1 & java 1.8.0) with
MySQL as the carbon_db.

I tried, executing the mysql setup dbscript and I get the following error

23:41:09 CREATE INDEX REG_PATH_IND_BY_PATH_VALUE USING HASH ON
REG_PATH(REG_PATH_VALUE, REG_TENANT_ID) Error Code: 1071. Specified key was
too long; max key length is 767 bytes 0.078 sec

this error has already been reported [1] and when I check the script also,
it mentions this CARBON JIRA.

however, this error does not occur in the linux (ubuntu) env.

would like to know how to proceed with this?

rgds

[1] https://wso2.org/jira/browse/CARBON-5917

-- 
*Niranda Perera*
Software Engineer, WSO2 Inc.
Mobile: +94-71-554-8430
Twitter: @n1r44 
https://pythagoreanscript.wordpress.com/
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev