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*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
