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