For the script api-manager 1.9.0 apimgt/mysql.sql. On Thu, Jun 25, 2015 at 1:02 PM, Chamara Ariyarathne <[email protected]> wrote:
> I got this same error for apimanager table creation in following > environment. > mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using > readline 5.1 > > ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes > ERROR 1146 (42S02): Table 'apimanager.IDN_OAUTH2_ACCESS_TOKEN' doesn't > exist > > What difference does it make when using "character set latin1" ? > > On Fri, Apr 17, 2015 at 10:32 AM, Vinod Kavinda <[email protected]> wrote: > >> Hi Godwin, >> It worked. thanks a lot. >> >> Regards, >> Vinod >> >> On Fri, Apr 17, 2015 at 2:47 PM, Godwin Amila Shrimal <[email protected]> >> wrote: >> >>> Hi, >>> >>> Use latin1 character set. >>> >>> >>> Thanks >>> Godwin >>> >>> >>> On Fri, Apr 17, 2015 at 2:40 PM, Vinod Kavinda <[email protected]> wrote: >>> >>>> Hi, >>>> I'm getting the following error while trying to setup a mysql >>>> datastore, when running the dbscript located at >>>> '<PRODUCT_HOME>/dbscripts/mysql.sql'. >>>> Error - *ERROR 1071 (42000) at line 31: Specified key was too long; >>>> max key length is 767 bytes* >>>> >>>> I tried reducing the REG_PATH_VALUE length to 100(mysql.sql attached), >>>> with no luck. >>>> There is a similar issue[1] that has already resolved. >>>> >>>> mysql version - mysql Ver 14.14 Distrib 5.6.22, for osx10.9 (x86_64) >>>> mysql command used - mysql -u root -p BAR < mysql.sql >>>> >>>> Any help is appreciated. >>>> >>>> [1] - https://wso2.org/jira/browse/CARBON-5917 >>>> >>>> Regards, >>>> Vinod Kavinda >>>> >>>> -- >>>> Vinod Kavinda >>>> Software Engineer, *WSO2, Inc <http://www.wso2.com>.* >>>> Mobile : +94 (0) 712 415544 >>>> [email protected] >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> [email protected] >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> >>> -- >>> *Godwin Amila Shrimal* >>> Senior Software Engineer >>> WSO2 Inc.; http://wso2.com >>> lean.enterprise.middleware >>> >>> mobile: *+94772264165* >>> linkedin: *http://lnkd.in/KUum6D <http://lnkd.in/KUum6D>* >>> twitter: https://twitter.com/godwinamila >>> >> >> >> >> -- >> Vinod Kavinda >> Software Engineer, *WSO2, Inc <http://www.wso2.com>.* >> Mobile : +94 (0) 712 415544 >> [email protected] >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > *Chamara Ariyarathne* > Associate Technical Lead - Quality Assurance > WSO2 Inc; http://www.wso2.com/ > Mobile; *+94772786766 <%2B94772786766>* > -- *Chamara Ariyarathne* Associate Technical Lead - Quality Assurance WSO2 Inc; http://www.wso2.com/ Mobile; *+94772786766*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
