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 ? [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+ > Availability+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*
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev