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 <mariang...@wso2.com> wrote: > - Removing dev@wso2.org > > Ack for docs! > > Regards, > Mariangela > > > *Mariangela Hills* > Associate Lead Technical Writer - WSO2, Inc. http://wso2.com > Committer and PMC member - Apache Stratos > email:mariang...@wso2.com | mobile: +94 773 500185 > <https://wso2.com/signature> > > On Tue, Nov 7, 2017 at 3:37 PM, Damith Wickramasinghe <dami...@wso2.com> > 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 <hars...@wso2.com> wrote: >> >>> >>> >>> On Tue, Nov 7, 2017 at 3:18 PM, Chamalee De Silva <chama...@wso2.com> >>> 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 <dami...@wso2.com >>>> > 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 documentation+unsubscr...@wso2.com. >>>>> 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 documentation+unsubscr...@wso2.com. >> For more options, visit https://groups.google.com/a/wso2.com/d/optout. >> > > -- *Sanjeewa Malalgoda* WSO2 Inc. Mobile : +94713068779 <http://sanjeewamalalgoda.blogspot.com/>blog :http://sanjeewamalalgoda.blogspot.com/ <http://sanjeewamalalgoda.blogspot.com/>
mysql.sql
Description: application/sql
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev