Created a JIRA to track this task. https://wso2.org/jira/browse/DOCUMENTATION-6396
Regards, Mariangela *Mariangela Hills* Associate Lead Technical Writer - WSO2, Inc. http://wso2.com Committer and PMC member - Apache Stratos email:[email protected] | mobile: +94 773 500185 <https://wso2.com/signature> On Tue, Nov 7, 2017 at 4:22 PM, Sanjeewa Malalgoda <[email protected]> wrote: > MySQL script on default product pack do not work as expected with mysql > 5.7.19 . Please find updated one here. > > Thanks > sanjeewa. > > On Tue, Nov 7, 2017 at 3:39 PM, Mariangela Hills <[email protected]> > wrote: > >> - Removing [email protected] >> >> Ack for docs! >> >> Regards, >> Mariangela >> >> >> *Mariangela Hills* >> Associate Lead Technical Writer - WSO2, Inc. http://wso2.com >> Committer and PMC member - Apache Stratos >> email:[email protected] | mobile: +94 773 500185 >> <https://wso2.com/signature> >> >> On Tue, Nov 7, 2017 at 3:37 PM, Damith Wickramasinghe <[email protected]> >> wrote: >> >>> As Harsha mentioned it should be some where common to all places. >>> >>> Regards, >>> Damith >>> >>> On Tue, Nov 7, 2017 at 3:35 PM, Harsha Kumara <[email protected]> wrote: >>> >>>> >>>> >>>> On Tue, Nov 7, 2017 at 3:18 PM, Chamalee De Silva <[email protected]> >>>> wrote: >>>> >>>>> Hi Damith, >>>>> >>>>> mysql5.7.sql script has been added for MySQL 5.7 and later versions of >>>>> databases. >>>>> This is clearly described in the documentation on setting up MySQL >>>>> documentation in [1]. >>>>> >>>>> If we are going to add this special note, we may have to add this >>>>> everywhere where mysql is used. >>>>> >>>>> @team, What is the best option ? >>>>> >>>> Best option would be to point to setting up database link as it >>>> contains required information. >>>> >>>>> >>>>> >>>>> [1] https://docs.wso2.com/display/AM200/Setting+up+MySQL >>>>> >>>>> >>>>> On Tue, Nov 7, 2017 at 2:20 PM, Damith Wickramasinghe < >>>>> [email protected]> wrote: >>>>> >>>>>> Hi all, >>>>>> >>>>>> I'm using mysql version 5.7.20. In order to populate userdb and regdb >>>>>> i need to run mysql scripts and i have used the scripts in APIM analytics >>>>>> pack(mysql.sql). When run below issue arises, >>>>>> >>>>>> ERROR 1067 (42000): Invalid default value for 'REG_CREATED_TIME' >>>>>> ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist >>>>>> ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist >>>>>> ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist >>>>>> ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist >>>>>> ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist >>>>>> ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist >>>>>> ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist >>>>>> ERROR 1067 (42000): Invalid default value for 'REG_LAST_UPDATED_TIME' >>>>>> ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE_HISTORY' doesn't exist >>>>>> ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE_HISTORY' doesn't exist >>>>>> ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE_HISTORY' doesn't exist >>>>>> ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist >>>>>> >>>>>> Searching the issue found out i need to run NOT mysql.sql but >>>>>> mysql5.7.sql. So for wt version does the mysql.sql works ? versions other >>>>>> than 5.7 ? IF so we need to mention this clearly in the >>>>>> docs . I found the same issue has been occurred for a customer as >>>>>> well. I followed [1]. >>>>>> >>>>>> [1] - https://docs.wso2.com/display/AM210/Minimum+High+Availabilit >>>>>> y+Deployment+for+WSO2+APIM+Analytics >>>>>> >>>>>> Regards, >>>>>> Damith. >>>>>> >>>>>> -- >>>>>> Senior Software Engineer >>>>>> WSO2 Inc.; http://wso2.com >>>>>> <http://www.google.com/url?q=http%3A%2F%2Fwso2.com&sa=D&sntz=1&usg=AFQjCNEZvyc0uMD1HhBaEGCBxs6e9fBObg> >>>>>> lean.enterprise.middleware >>>>>> >>>>>> mobile: *+94728671315 <+94%2072%20867%201315>* >>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "WSO2 Documentation Group" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to [email protected]. >>>>>> For more options, visit https://groups.google.com/a/wso2.com/d/optout >>>>>> . >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Thanks & Regards, >>>>> >>>>> *Chamalee De Silva* >>>>> Software Engineer >>>>> *WS**O2* Inc. :http://wso2.com/ >>>>> >>>>> Office :- *+94 11 2145345 <%2B94%2011%202145345>* >>>>> mobile :- *+94 7 <%2B94%2077%202782039>1 4315942* >>>>> >>>>> >>>> >>>> >>>> -- >>>> Harsha Kumara >>>> Software Engineer, WSO2 Inc. >>>> Mobile: +94775505618 <+94%2077%20550%205618> >>>> Blog:harshcreationz.blogspot.com >>>> >>> >>> >>> >>> -- >>> Senior Software Engineer >>> WSO2 Inc.; http://wso2.com >>> <http://www.google.com/url?q=http%3A%2F%2Fwso2.com&sa=D&sntz=1&usg=AFQjCNEZvyc0uMD1HhBaEGCBxs6e9fBObg> >>> lean.enterprise.middleware >>> >>> mobile: *+94728671315 <+94%2072%20867%201315>* >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "WSO2 Documentation Group" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/a/wso2.com/d/optout. >>> >> >> > > > -- > > *Sanjeewa Malalgoda* > WSO2 Inc. > Mobile : +94713068779 <+94%2071%20306%208779> > > <http://sanjeewamalalgoda.blogspot.com/>blog :http://sanjeewamalalgoda. > blogspot.com/ <http://sanjeewamalalgoda.blogspot.com/> > > >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
